DBA Data[Home] [Help]

APPS.ARH_CONT_PKG dependencies on ARP_STANDARD

Line 593: arp_standard.debug('arh_cont_pkg.insert_row +');

589: l_update_required VARCHAR2(1) := 'N';
590:
591: BEGIN
592:
593: arp_standard.debug('arh_cont_pkg.insert_row +');
594: arp_standard.debug(' x_contact_number :'||x_contact_number );
595: arp_standard.debug(' x_contact_id :'||x_contact_id );
596: --
597: -- Bug 631501: automatically assign contact number if profile

Line 594: arp_standard.debug(' x_contact_number :'||x_contact_number );

590:
591: BEGIN
592:
593: arp_standard.debug('arh_cont_pkg.insert_row +');
594: arp_standard.debug(' x_contact_number :'||x_contact_number );
595: arp_standard.debug(' x_contact_id :'||x_contact_id );
596: --
597: -- Bug 631501: automatically assign contact number if profile
598: -- option AR_AUTOMATIC_CONTACT_NUNMBERING is set to 'Yes'

Line 595: arp_standard.debug(' x_contact_id :'||x_contact_id );

591: BEGIN
592:
593: arp_standard.debug('arh_cont_pkg.insert_row +');
594: arp_standard.debug(' x_contact_number :'||x_contact_number );
595: arp_standard.debug(' x_contact_id :'||x_contact_id );
596: --
597: -- Bug 631501: automatically assign contact number if profile
598: -- option AR_AUTOMATIC_CONTACT_NUNMBERING is set to 'Yes'
599: --

Line 619: arp_standard.debug(' i_create_org_contact :'||i_create_org_contact );

615: IF i_create_org_contact = 'Y' THEN
616: SELECT hz_org_contacts_s.nextval INTO x_contact_id FROM DUAL;
617: END IF;
618:
619: arp_standard.debug(' i_create_org_contact :'||i_create_org_contact );
620:
621: -- BugFix:2225260
622: --- If Subject Party does not exist,added this following if clause.
623: --

Line 631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );

627: ELSE
628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;
630:
631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );
632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;

Line 632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );

628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;
630:
631: arp_standard.debug(' X_Sub_Party_Id :'||X_Sub_Party_Id );
632: arp_standard.debug(' i_subject_party_id :'||i_subject_party_id );
633:
634: select hz_contact_points_s.nextval into i_contact_point_id from dual;
635: select hz_cust_account_roles_s.nextval into x_cust_account_role_id from dual;
636: select hz_cust_contact_points_s.nextval into x_cust_contact_point_id from dual;

Line 819: arp_standard.debug('Calling compare_existing_contact_info ');

815:
816: --{BUG#4064156
817: IF i_create_org_contact = 'N' THEN
818:
819: arp_standard.debug('Calling compare_existing_contact_info ');
820:
821: ocon_rec.org_contact_id := X_Org_Contact_Id;
822:
823: compare_existing_contact_info

Line 829: arp_standard.debug(' l_update_required :'||l_update_required);

825: x_update_required => l_update_required,
826: x_relationship_id => l_relationship_id,
827: x_ocon_version_number => l_ocon_version_number );
828:
829: arp_standard.debug(' l_update_required :'||l_update_required);
830: arp_standard.debug(' l_relationship_id :'||l_relationship_id);
831: arp_standard.debug(' l_ocon_version_number :'||l_ocon_version_number);
832:
833:

Line 830: arp_standard.debug(' l_relationship_id :'||l_relationship_id);

826: x_relationship_id => l_relationship_id,
827: x_ocon_version_number => l_ocon_version_number );
828:
829: arp_standard.debug(' l_update_required :'||l_update_required);
830: arp_standard.debug(' l_relationship_id :'||l_relationship_id);
831: arp_standard.debug(' l_ocon_version_number :'||l_ocon_version_number);
832:
833:
834: IF l_update_required = 'Y' THEN

Line 831: arp_standard.debug(' l_ocon_version_number :'||l_ocon_version_number);

827: x_ocon_version_number => l_ocon_version_number );
828:
829: arp_standard.debug(' l_update_required :'||l_update_required);
830: arp_standard.debug(' l_relationship_id :'||l_relationship_id);
831: arp_standard.debug(' l_ocon_version_number :'||l_ocon_version_number);
832:
833:
834: IF l_update_required = 'Y' THEN
835: arp_standard.debug('Calling upd_ocon_update ');

Line 835: arp_standard.debug('Calling upd_ocon_update ');

831: arp_standard.debug(' l_ocon_version_number :'||l_ocon_version_number);
832:
833:
834: IF l_update_required = 'Y' THEN
835: arp_standard.debug('Calling upd_ocon_update ');
836: arp_standard.debug(' ocon_rec.org_contact_id :'||ocon_rec.org_contact_id);
837:
838: upd_ocon_update(p_ocon_rec => ocon_rec);
839: END IF;

Line 836: arp_standard.debug(' ocon_rec.org_contact_id :'||ocon_rec.org_contact_id);

832:
833:
834: IF l_update_required = 'Y' THEN
835: arp_standard.debug('Calling upd_ocon_update ');
836: arp_standard.debug(' ocon_rec.org_contact_id :'||ocon_rec.org_contact_id);
837:
838: upd_ocon_update(p_ocon_rec => ocon_rec);
839: END IF;
840: