Showing posts with label API. Show all posts
Showing posts with label API. Show all posts

Wednesday, November 16, 2011

Error Error while caling AS_OPPORTUNITY_PUB.Update_Opp_Header API Current resource does not have a login user assigned. Please use resource manager to assign a login user to this resource

Error: Error while caling AS_OPPORTUNITY_PUB.Update_Opp_Header API Current resource does not have a login user assigned. Please use resource manager to assign a login user to this resource

    headerRec.close_reason     := 'DROPPED';
        headerRec.last_update_date := lastUpdatedDate;
        headerRec.last_updated_by  := FND_GLOBAL.USER_ID;

        AS_OPPORTUNITY_PUB.Update_Opp_Header(p_api_version_number     => '2.0',
                                             p_commit                 => fnd_api.G_FALSE,
                                             p_header_rec             => headerRec,
                                             p_check_access_flag      => 'Y',
                                             p_admin_flag             => 'N',
                                             p_admin_group_id         => null,
                                             p_identity_salesforce_id => null,
                                             p_partner_cont_party_id  => null,
                                             x_return_status          => x_return_status,
                                             x_msg_count              => x_msg_count,
                                             x_msg_data               => x_msg_data,
                                             x_lead_id                => x_lead_id);
        IF (x_return_status != 'S') THEN
          IF (fnd_msg_pub.count_msg > 0) THEN
            FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
              fnd_msg_pub.get(p_msg_index     => i,
                              p_encoded       => 'F',
                              p_data          => x_msg_data,
                              p_msg_index_out => x_msg_count);
              DBMS_OUTPUT.put_line(x_msg_data);
            END LOOP;

Solution: Pass the sales_force_id  into  p_identity_salesforce_id

Wednesday, August 24, 2011

Change Password using API for e-Business Suite Login

You can change password and also disable the change password which will be asked when the password change limit days has crossed  as given below.


No need to pass the old password for the below.

begin
fnd_user_pkg.updateuser(
                x_user_name => 'fnd_user.User_NAME',
                x_unencrypted_password => 'password',
                x_password_date => (sysdate+31)
                );
commit;
end;

Friday, August 12, 2011

Error - Another user has updated Opportunity header record in AS_OPPORTUNITY_PUB.Update_Opp_Header

Cause: 
While Updating opportunities using AS_OPPORTUNITY_PUB.Update_Opp_Header I am getting the below error


Another user has updated Opportunity header record. please re-query to see the changes.


The Code is 
headerRec.lead_id := leadId;
headerRec.owner_salesforce_id := resourceid;
headerRec.owner_sales_group_id :=salesGroupid;
headerRec.status :='Dropped';
headerRec.status_code :='Dropped';
headerRec.close_reason:='NOT_SPECIFIED';
headerRec.last_update_date := sysdate;
headerRec.last_updated_by := FND_GLOBAL.USER_ID;
-- dbms_output.put_line (headerRec.last_update_date );
AS_OPPORTUNITY_PUB.Update_Opp_Header(p_api_version_number => '2.0',
p_commit => fnd_api.G_FALSE,
p_header_rec => headerRec,
p_check_access_flag => 'Y',
p_admin_flag => 'N',
p_admin_group_id => null,
p_identity_salesforce_id => resourceid,
p_partner_cont_party_id => null,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_lead_id => x_lead_id);
DBMS_OUTPUT.put_line('--' || x_return_status);
IF (x_return_status != 'S') THEN
IF (fnd_msg_pub.count_msg > 0) THEN
FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
fnd_msg_pub.get(p_msg_index => i,
p_encoded => 'F',
p_data => x_msg_data,
p_msg_index_out => x_msg_count);
DBMS_OUTPUT.put_line(x_msg_data);
END LOOP;


Solution:
  Get the Last_updated_date from the opportunity table for the selected opportunity and pass it to the headerRec.last_update_date

SELECT last_update_date
FROM as_leads_all
WHERE lead_id = opportunity_id;

Error - Close reason with value: does not exist. in Update Opportunities

Cause:
While Updating opportunities using AS_OPPORTUNITY_PUB.Update_Opp_Header I am getting the below error


Close reason with value: BUYING DEFERRED does not exist.

The code is


headerRec.lead_id := leadId;
headerRec.owner_salesforce_id := resourceid;
headerRec.owner_sales_group_id :=salesGroupid;
headerRec.status :='Dropped';
headerRec.status_code :='Dropped';
headerRec.close_reason:='BUYING DEFERRED';
headerRec.last_update_date := lastUpdatedDate;
headerRec.last_updated_by := FND_GLOBAL.USER_ID;
-- dbms_output.put_line (headerRec.last_update_date );
AS_OPPORTUNITY_PUB.Update_Opp_Header(p_api_version_number => '2.0',
p_commit => fnd_api.G_FALSE,
p_header_rec => headerRec,
p_check_access_flag => 'Y',
p_admin_flag => 'N',
p_admin_group_id => null,
p_identity_salesforce_id => resourceid,
p_partner_cont_party_id => null,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_lead_id => x_lead_id);
DBMS_OUTPUT.put_line('--' || x_return_status);
IF (x_return_status != 'S') THEN
IF (fnd_msg_pub.count_msg > 0) THEN
FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
fnd_msg_pub.get(p_msg_index => i,
p_encoded => 'F',
p_data => x_msg_data,
p_msg_index_out => x_msg_count);
DBMS_OUTPUT.put_line(x_msg_data);

Solution:
You have to pass one of the values from column lookup_code from below query

select lookup_code from fnd_lookup_values  where lookup_type='CLOSE_REASON'