eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SUPPLIER_BO_DEP_PKG dependencies on FND_API

Line 18: PROCEDURE get_financial_report_bos(p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

14: * @rep:displayname Get Supplier Financial Report
15: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
16: */
17:
18: PROCEDURE get_financial_report_bos(p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
19: p_organization_id IN NUMBER,
20: p_action_type IN VARCHAR2 := NULL,
21: x_financial_report_objs OUT NOCOPY hz_financial_bo_tbl,
22: x_return_status OUT NOCOPY VARCHAR2,

Line 88: x_return_status := fnd_api.g_ret_sts_success;

84:
85: BEGIN
86:
87: -- initialize API return status to success.
88: x_return_status := fnd_api.g_ret_sts_success;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE
91: IF fnd_api.to_boolean(p_init_msg_list) THEN
92: fnd_msg_pub.initialize;

Line 91: IF fnd_api.to_boolean(p_init_msg_list) THEN

87: -- initialize API return status to success.
88: x_return_status := fnd_api.g_ret_sts_success;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE
91: IF fnd_api.to_boolean(p_init_msg_list) THEN
92: fnd_msg_pub.initialize;
93: END IF;
94:
95: -- Debug info.

Line 124: WHEN fnd_api.g_exc_error THEN

120: p_msg_level => fnd_log.level_procedure);
121: END IF;
122:
123: EXCEPTION
124: WHEN fnd_api.g_exc_error THEN
125:
126: x_return_status := fnd_api.g_ret_sts_error;
127: fnd_msg_pub.count_and_get(p_count => x_msg_count,
128: p_data => x_msg_data);

Line 126: x_return_status := fnd_api.g_ret_sts_error;

122:
123: EXCEPTION
124: WHEN fnd_api.g_exc_error THEN
125:
126: x_return_status := fnd_api.g_ret_sts_error;
127: fnd_msg_pub.count_and_get(p_count => x_msg_count,
128: p_data => x_msg_data);
129: WHEN fnd_api.g_exc_unexpected_error THEN
130:

Line 129: WHEN fnd_api.g_exc_unexpected_error THEN

125:
126: x_return_status := fnd_api.g_ret_sts_error;
127: fnd_msg_pub.count_and_get(p_count => x_msg_count,
128: p_data => x_msg_data);
129: WHEN fnd_api.g_exc_unexpected_error THEN
130:
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: fnd_msg_pub.count_and_get(p_count => x_msg_count,
133: p_data => x_msg_data);

Line 131: x_return_status := fnd_api.g_ret_sts_unexp_error;

127: fnd_msg_pub.count_and_get(p_count => x_msg_count,
128: p_data => x_msg_data);
129: WHEN fnd_api.g_exc_unexpected_error THEN
130:
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: fnd_msg_pub.count_and_get(p_count => x_msg_count,
133: p_data => x_msg_data);
134: WHEN OTHERS THEN
135:

Line 136: x_return_status := fnd_api.g_ret_sts_unexp_error;

132: fnd_msg_pub.count_and_get(p_count => x_msg_count,
133: p_data => x_msg_data);
134: WHEN OTHERS THEN
135:
136: x_return_status := fnd_api.g_ret_sts_unexp_error;
137:
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,
139: p_data => x_msg_data);
140:

Line 157: PROCEDURE get_organization_bo(p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

153: * @rep:lifecycle active
154: * @rep:displayname Get Organization BO
155: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
156: */
157: PROCEDURE get_organization_bo(p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
158: p_organization_id IN NUMBER,
159: p_action_type IN VARCHAR2 := NULL,
160: x_organization_obj OUT NOCOPY hz_organization_bo,
161: x_return_status OUT NOCOPY VARCHAR2,

Line 565: x_return_status := fnd_api.g_ret_sts_success;

561: l_prof_id NUMBER;
562: BEGIN
563:
564: -- initialize API return status to success.
565: x_return_status := fnd_api.g_ret_sts_success;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE
568: IF fnd_api.to_boolean(p_init_msg_list) THEN
569: fnd_msg_pub.initialize;

Line 568: IF fnd_api.to_boolean(p_init_msg_list) THEN

564: -- initialize API return status to success.
565: x_return_status := fnd_api.g_ret_sts_success;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE
568: IF fnd_api.to_boolean(p_init_msg_list) THEN
569: fnd_msg_pub.initialize;
570: END IF;
571:
572: -- Debug info.

Line 584: hz_extract_orig_sys_ref_bo_pvt.get_orig_sys_ref_bos(p_init_msg_list => fnd_api.g_false,

580: FETCH c1
581: INTO x_organization_obj;
582: CLOSE c1;
583:
584: hz_extract_orig_sys_ref_bo_pvt.get_orig_sys_ref_bos(p_init_msg_list => fnd_api.g_false,
585: p_owner_table_id => p_organization_id,
586: p_owner_table_name => 'HZ_PARTIES',
587: p_action_type => NULL, --p_action_type,
588: x_orig_sys_ref_objs => x_organization_obj.orig_sys_objs,

Line 593: IF x_return_status <> fnd_api.g_ret_sts_success THEN

589: x_return_status => x_return_status,
590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data);
592:
593: IF x_return_status <> fnd_api.g_ret_sts_success THEN
594: RAISE fnd_api.g_exc_error;
595: END IF;
596:
597: OPEN get_profile_id_csr;

Line 594: RAISE fnd_api.g_exc_error;

590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data);
592:
593: IF x_return_status <> fnd_api.g_ret_sts_success THEN
594: RAISE fnd_api.g_exc_error;
595: END IF;
596:
597: OPEN get_profile_id_csr;
598: FETCH get_profile_id_csr

Line 602: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos(p_init_msg_list => fnd_api.g_false,

598: FETCH get_profile_id_csr
599: INTO l_prof_id;
600: CLOSE get_profile_id_csr;
601:
602: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos(p_init_msg_list => fnd_api.g_false,
603: p_ext_object_id => l_prof_id,
604: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',
605: p_action_type => p_action_type,
606: x_ext_attribute_objs => x_organization_obj.ext_attributes_objs,

Line 611: IF x_return_status <> fnd_api.g_ret_sts_success THEN

607: x_return_status => x_return_status,
608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data);
610:
611: IF x_return_status <> fnd_api.g_ret_sts_success THEN
612: RAISE fnd_api.g_exc_error;
613: END IF;
614:
615: hz_extract_party_site_bo_pvt.get_party_site_bos(p_init_msg_list => fnd_api.g_false,

Line 612: RAISE fnd_api.g_exc_error;

608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data);
610:
611: IF x_return_status <> fnd_api.g_ret_sts_success THEN
612: RAISE fnd_api.g_exc_error;
613: END IF;
614:
615: hz_extract_party_site_bo_pvt.get_party_site_bos(p_init_msg_list => fnd_api.g_false,
616: p_party_id => p_organization_id,

Line 615: hz_extract_party_site_bo_pvt.get_party_site_bos(p_init_msg_list => fnd_api.g_false,

611: IF x_return_status <> fnd_api.g_ret_sts_success THEN
612: RAISE fnd_api.g_exc_error;
613: END IF;
614:
615: hz_extract_party_site_bo_pvt.get_party_site_bos(p_init_msg_list => fnd_api.g_false,
616: p_party_id => p_organization_id,
617: p_party_site_id => NULL,
618: p_action_type => p_action_type,
619: x_party_site_objs => x_organization_obj.party_site_objs,

Line 624: IF x_return_status <> fnd_api.g_ret_sts_success THEN

620: x_return_status => x_return_status,
621: x_msg_count => x_msg_count,
622: x_msg_data => x_msg_data);
623:
624: IF x_return_status <> fnd_api.g_ret_sts_success THEN
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: hz_extract_party_usage_bo_pvt.get_party_usage_bos(p_init_msg_list => fnd_api.g_false,

Line 625: RAISE fnd_api.g_exc_error;

621: x_msg_count => x_msg_count,
622: x_msg_data => x_msg_data);
623:
624: IF x_return_status <> fnd_api.g_ret_sts_success THEN
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: hz_extract_party_usage_bo_pvt.get_party_usage_bos(p_init_msg_list => fnd_api.g_false,
629: p_owner_table_id => p_organization_id,

Line 628: hz_extract_party_usage_bo_pvt.get_party_usage_bos(p_init_msg_list => fnd_api.g_false,

624: IF x_return_status <> fnd_api.g_ret_sts_success THEN
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: hz_extract_party_usage_bo_pvt.get_party_usage_bos(p_init_msg_list => fnd_api.g_false,
629: p_owner_table_id => p_organization_id,
630: p_owner_table_name => 'HZ_PARTIES',
631: p_action_type => p_action_type,
632: x_party_usage_objs => x_organization_obj.party_usage_objs,

Line 637: IF x_return_status <> fnd_api.g_ret_sts_success THEN

633: x_return_status => x_return_status,
634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data);
636:
637: IF x_return_status <> fnd_api.g_ret_sts_success THEN
638: RAISE fnd_api.g_exc_error;
639: END IF;
640:
641: hz_extract_org_cont_bo_pvt.get_org_contact_bos(p_init_msg_list => fnd_api.g_false,

Line 638: RAISE fnd_api.g_exc_error;

634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data);
636:
637: IF x_return_status <> fnd_api.g_ret_sts_success THEN
638: RAISE fnd_api.g_exc_error;
639: END IF;
640:
641: hz_extract_org_cont_bo_pvt.get_org_contact_bos(p_init_msg_list => fnd_api.g_false,
642: p_organization_id => p_organization_id,

Line 641: hz_extract_org_cont_bo_pvt.get_org_contact_bos(p_init_msg_list => fnd_api.g_false,

637: IF x_return_status <> fnd_api.g_ret_sts_success THEN
638: RAISE fnd_api.g_exc_error;
639: END IF;
640:
641: hz_extract_org_cont_bo_pvt.get_org_contact_bos(p_init_msg_list => fnd_api.g_false,
642: p_organization_id => p_organization_id,
643: p_action_type => p_action_type,
644: x_org_contact_objs => x_organization_obj.contact_objs,
645: x_return_status => x_return_status,

Line 649: IF x_return_status <> fnd_api.g_ret_sts_success THEN

645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data);
648:
649: IF x_return_status <> fnd_api.g_ret_sts_success THEN
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,

Line 650: RAISE fnd_api.g_exc_error;

646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data);
648:
649: IF x_return_status <> fnd_api.g_ret_sts_success THEN
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,
654: p_organization_id => p_organization_id,

Line 653: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,

649: IF x_return_status <> fnd_api.g_ret_sts_success THEN
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,
654: p_organization_id => p_organization_id,
655: p_action_type => p_action_type,
656: x_financial_report_objs => x_organization_obj.financial_report_objs,
657: x_return_status => x_return_status,

Line 661: IF x_return_status <> fnd_api.g_ret_sts_success THEN

657: x_return_status => x_return_status,
658: x_msg_count => x_msg_count,
659: x_msg_data => x_msg_data);
660:
661: IF x_return_status <> fnd_api.g_ret_sts_success THEN
662: RAISE fnd_api.g_exc_error;
663: END IF;
664:
665: hz_extract_cont_point_bo_pvt.get_phone_bos(p_init_msg_list => fnd_api.g_false,

Line 662: RAISE fnd_api.g_exc_error;

658: x_msg_count => x_msg_count,
659: x_msg_data => x_msg_data);
660:
661: IF x_return_status <> fnd_api.g_ret_sts_success THEN
662: RAISE fnd_api.g_exc_error;
663: END IF;
664:
665: hz_extract_cont_point_bo_pvt.get_phone_bos(p_init_msg_list => fnd_api.g_false,
666: p_phone_id => NULL,

Line 665: hz_extract_cont_point_bo_pvt.get_phone_bos(p_init_msg_list => fnd_api.g_false,

661: IF x_return_status <> fnd_api.g_ret_sts_success THEN
662: RAISE fnd_api.g_exc_error;
663: END IF;
664:
665: hz_extract_cont_point_bo_pvt.get_phone_bos(p_init_msg_list => fnd_api.g_false,
666: p_phone_id => NULL,
667: p_parent_id => p_organization_id,
668: p_parent_table_name => 'HZ_PARTIES',
669: p_action_type => p_action_type,

Line 675: IF x_return_status <> fnd_api.g_ret_sts_success THEN

671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data);
674:
675: IF x_return_status <> fnd_api.g_ret_sts_success THEN
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: hz_extract_cont_point_bo_pvt.get_telex_bos(p_init_msg_list => fnd_api.g_false,

Line 676: RAISE fnd_api.g_exc_error;

672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data);
674:
675: IF x_return_status <> fnd_api.g_ret_sts_success THEN
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: hz_extract_cont_point_bo_pvt.get_telex_bos(p_init_msg_list => fnd_api.g_false,
680: p_telex_id => NULL,

Line 679: hz_extract_cont_point_bo_pvt.get_telex_bos(p_init_msg_list => fnd_api.g_false,

675: IF x_return_status <> fnd_api.g_ret_sts_success THEN
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: hz_extract_cont_point_bo_pvt.get_telex_bos(p_init_msg_list => fnd_api.g_false,
680: p_telex_id => NULL,
681: p_parent_id => p_organization_id,
682: p_parent_table_name => 'HZ_PARTIES',
683: p_action_type => p_action_type,

Line 689: IF x_return_status <> fnd_api.g_ret_sts_success THEN

685: x_return_status => x_return_status,
686: x_msg_count => x_msg_count,
687: x_msg_data => x_msg_data);
688:
689: IF x_return_status <> fnd_api.g_ret_sts_success THEN
690: RAISE fnd_api.g_exc_error;
691: END IF;
692:
693: hz_extract_cont_point_bo_pvt.get_email_bos(p_init_msg_list => fnd_api.g_false,

Line 690: RAISE fnd_api.g_exc_error;

686: x_msg_count => x_msg_count,
687: x_msg_data => x_msg_data);
688:
689: IF x_return_status <> fnd_api.g_ret_sts_success THEN
690: RAISE fnd_api.g_exc_error;
691: END IF;
692:
693: hz_extract_cont_point_bo_pvt.get_email_bos(p_init_msg_list => fnd_api.g_false,
694: p_email_id => NULL,

Line 693: hz_extract_cont_point_bo_pvt.get_email_bos(p_init_msg_list => fnd_api.g_false,

689: IF x_return_status <> fnd_api.g_ret_sts_success THEN
690: RAISE fnd_api.g_exc_error;
691: END IF;
692:
693: hz_extract_cont_point_bo_pvt.get_email_bos(p_init_msg_list => fnd_api.g_false,
694: p_email_id => NULL,
695: p_parent_id => p_organization_id,
696: p_parent_table_name => 'HZ_PARTIES',
697: p_action_type => p_action_type,

Line 703: IF x_return_status <> fnd_api.g_ret_sts_success THEN

699: x_return_status => x_return_status,
700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data);
702:
703: IF x_return_status <> fnd_api.g_ret_sts_success THEN
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: hz_extract_cont_point_bo_pvt.get_web_bos(p_init_msg_list => fnd_api.g_false,

Line 704: RAISE fnd_api.g_exc_error;

700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data);
702:
703: IF x_return_status <> fnd_api.g_ret_sts_success THEN
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: hz_extract_cont_point_bo_pvt.get_web_bos(p_init_msg_list => fnd_api.g_false,
708: p_web_id => NULL,

Line 707: hz_extract_cont_point_bo_pvt.get_web_bos(p_init_msg_list => fnd_api.g_false,

703: IF x_return_status <> fnd_api.g_ret_sts_success THEN
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: hz_extract_cont_point_bo_pvt.get_web_bos(p_init_msg_list => fnd_api.g_false,
708: p_web_id => NULL,
709: p_parent_id => p_organization_id,
710: p_parent_table_name => 'HZ_PARTIES',
711: p_action_type => p_action_type,

Line 717: IF x_return_status <> fnd_api.g_ret_sts_success THEN

713: x_return_status => x_return_status,
714: x_msg_count => x_msg_count,
715: x_msg_data => x_msg_data);
716:
717: IF x_return_status <> fnd_api.g_ret_sts_success THEN
718: RAISE fnd_api.g_exc_error;
719: END IF;
720:
721: hz_extract_cont_point_bo_pvt.get_edi_bos(p_init_msg_list => fnd_api.g_false,

Line 718: RAISE fnd_api.g_exc_error;

714: x_msg_count => x_msg_count,
715: x_msg_data => x_msg_data);
716:
717: IF x_return_status <> fnd_api.g_ret_sts_success THEN
718: RAISE fnd_api.g_exc_error;
719: END IF;
720:
721: hz_extract_cont_point_bo_pvt.get_edi_bos(p_init_msg_list => fnd_api.g_false,
722: p_edi_id => NULL,

Line 721: hz_extract_cont_point_bo_pvt.get_edi_bos(p_init_msg_list => fnd_api.g_false,

717: IF x_return_status <> fnd_api.g_ret_sts_success THEN
718: RAISE fnd_api.g_exc_error;
719: END IF;
720:
721: hz_extract_cont_point_bo_pvt.get_edi_bos(p_init_msg_list => fnd_api.g_false,
722: p_edi_id => NULL,
723: p_parent_id => p_organization_id,
724: p_parent_table_name => 'HZ_PARTIES',
725: p_action_type => p_action_type,

Line 731: IF x_return_status <> fnd_api.g_ret_sts_success THEN

727: x_return_status => x_return_status,
728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: IF x_return_status <> fnd_api.g_ret_sts_success THEN
732: RAISE fnd_api.g_exc_error;
733: END IF;
734:
735: hz_extract_cont_point_bo_pvt.get_eft_bos(p_init_msg_list => fnd_api.g_false,

Line 732: RAISE fnd_api.g_exc_error;

728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: IF x_return_status <> fnd_api.g_ret_sts_success THEN
732: RAISE fnd_api.g_exc_error;
733: END IF;
734:
735: hz_extract_cont_point_bo_pvt.get_eft_bos(p_init_msg_list => fnd_api.g_false,
736: p_eft_id => NULL,

Line 735: hz_extract_cont_point_bo_pvt.get_eft_bos(p_init_msg_list => fnd_api.g_false,

731: IF x_return_status <> fnd_api.g_ret_sts_success THEN
732: RAISE fnd_api.g_exc_error;
733: END IF;
734:
735: hz_extract_cont_point_bo_pvt.get_eft_bos(p_init_msg_list => fnd_api.g_false,
736: p_eft_id => NULL,
737: p_parent_id => p_organization_id,
738: p_parent_table_name => 'HZ_PARTIES',
739: p_action_type => p_action_type,

Line 745: IF x_return_status <> fnd_api.g_ret_sts_success THEN

741: x_return_status => x_return_status,
742: x_msg_count => x_msg_count,
743: x_msg_data => x_msg_data);
744:
745: IF x_return_status <> fnd_api.g_ret_sts_success THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: hz_extract_relationship_bo_pvt.get_relationship_bos(p_init_msg_list => fnd_api.g_false,

Line 746: RAISE fnd_api.g_exc_error;

742: x_msg_count => x_msg_count,
743: x_msg_data => x_msg_data);
744:
745: IF x_return_status <> fnd_api.g_ret_sts_success THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: hz_extract_relationship_bo_pvt.get_relationship_bos(p_init_msg_list => fnd_api.g_false,
750: p_subject_id => p_organization_id,

Line 749: hz_extract_relationship_bo_pvt.get_relationship_bos(p_init_msg_list => fnd_api.g_false,

745: IF x_return_status <> fnd_api.g_ret_sts_success THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: hz_extract_relationship_bo_pvt.get_relationship_bos(p_init_msg_list => fnd_api.g_false,
750: p_subject_id => p_organization_id,
751: p_action_type => p_action_type,
752: x_relationship_objs => x_organization_obj.relationship_objs,
753: x_return_status => x_return_status,

Line 757: IF x_return_status <> fnd_api.g_ret_sts_success THEN

753: x_return_status => x_return_status,
754: x_msg_count => x_msg_count,
755: x_msg_data => x_msg_data);
756:
757: IF x_return_status <> fnd_api.g_ret_sts_success THEN
758: RAISE fnd_api.g_exc_error;
759: END IF;
760:
761: hz_extract_cont_point_bo_pvt.get_cont_pref_objs(p_init_msg_list => fnd_api.g_false,

Line 758: RAISE fnd_api.g_exc_error;

754: x_msg_count => x_msg_count,
755: x_msg_data => x_msg_data);
756:
757: IF x_return_status <> fnd_api.g_ret_sts_success THEN
758: RAISE fnd_api.g_exc_error;
759: END IF;
760:
761: hz_extract_cont_point_bo_pvt.get_cont_pref_objs(p_init_msg_list => fnd_api.g_false,
762: p_cont_level_table_id => p_organization_id,

Line 761: hz_extract_cont_point_bo_pvt.get_cont_pref_objs(p_init_msg_list => fnd_api.g_false,

757: IF x_return_status <> fnd_api.g_ret_sts_success THEN
758: RAISE fnd_api.g_exc_error;
759: END IF;
760:
761: hz_extract_cont_point_bo_pvt.get_cont_pref_objs(p_init_msg_list => fnd_api.g_false,
762: p_cont_level_table_id => p_organization_id,
763: p_cont_level_table => 'HZ_PARTIES',
764: p_contact_type => NULL,
765: p_action_type => p_action_type,

Line 771: IF x_return_status <> fnd_api.g_ret_sts_success THEN

767: x_return_status => x_return_status,
768: x_msg_count => x_msg_count,
769: x_msg_data => x_msg_data);
770:
771: IF x_return_status <> fnd_api.g_ret_sts_success THEN
772: RAISE fnd_api.g_exc_error;
773: END IF;
774:
775: -- Debug info.

Line 772: RAISE fnd_api.g_exc_error;

768: x_msg_count => x_msg_count,
769: x_msg_data => x_msg_data);
770:
771: IF x_return_status <> fnd_api.g_ret_sts_success THEN
772: RAISE fnd_api.g_exc_error;
773: END IF;
774:
775: -- Debug info.
776: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 791: WHEN fnd_api.g_exc_error THEN

787: p_msg_level => fnd_log.level_procedure);
788: END IF;
789:
790: EXCEPTION
791: WHEN fnd_api.g_exc_error THEN
792:
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);

Line 793: x_return_status := fnd_api.g_ret_sts_error;

789:
790: EXCEPTION
791: WHEN fnd_api.g_exc_error THEN
792:
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);
796: WHEN fnd_api.g_exc_unexpected_error THEN
797:

Line 796: WHEN fnd_api.g_exc_unexpected_error THEN

792:
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);
796: WHEN fnd_api.g_exc_unexpected_error THEN
797:
798: x_return_status := fnd_api.g_ret_sts_unexp_error;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count,
800: p_data => x_msg_data);

Line 798: x_return_status := fnd_api.g_ret_sts_unexp_error;

794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);
796: WHEN fnd_api.g_exc_unexpected_error THEN
797:
798: x_return_status := fnd_api.g_ret_sts_unexp_error;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count,
800: p_data => x_msg_data);
801: WHEN OTHERS THEN
802:

Line 803: x_return_status := fnd_api.g_ret_sts_unexp_error;

799: fnd_msg_pub.count_and_get(p_count => x_msg_count,
800: p_data => x_msg_data);
801: WHEN OTHERS THEN
802:
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804:
805: fnd_msg_pub.count_and_get(p_count => x_msg_count,
806: p_data => x_msg_data);
807: END get_organization_bo;