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.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on FND_API

Line 26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

22: -- ARGUMENTS
23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to
25: -- p_organization_id Organization ID.
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_organization_obj Logical organization record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),

Line 30: -- be fnd_api.g_ret_sts_success (success),

26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_organization_obj Logical organization record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.

Line 31: -- fnd_api.g_ret_sts_error (error),

27: -- OUT:
28: -- x_organization_obj Logical organization record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --

Line 32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

28: -- x_organization_obj Logical organization record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --
36: -- NOTES

Line 47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

43:
44: -- private procedure get_financial_report_bos
45:
46: procedure get_financial_report_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_organization_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_financial_report_objs OUT NOCOPY HZ_FINANCIAL_BO_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115: BEGIN
116:
117:
118: -- initialize API return status to success.
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE
122: IF FND_API.to_Boolean(p_init_msg_list) THEN
123: FND_MSG_PUB.initialize;

Line 122: IF FND_API.to_Boolean(p_init_msg_list) THEN

118: -- initialize API return status to success.
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE
122: IF FND_API.to_Boolean(p_init_msg_list) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126:

Line 157: WHEN fnd_api.g_exc_error THEN

153:
154:
155: EXCEPTION
156:
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159:
160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
161: p_count => x_msg_count,

Line 158: x_return_status := fnd_api.g_ret_sts_error;

154:
155: EXCEPTION
156:
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159:
160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
161: p_count => x_msg_count,
162: p_data => x_msg_data);

Line 160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

156:
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159:
160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
161: p_count => x_msg_count,
162: p_data => x_msg_data);
163:
164: -- Debug info.

Line 176: WHEN fnd_api.g_exc_unexpected_error THEN

172: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: END IF;
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178:
179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
180: p_count => x_msg_count,

Line 177: x_return_status := fnd_api.g_ret_sts_unexp_error;

173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: END IF;
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178:
179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
180: p_count => x_msg_count,
181: p_data => x_msg_data);

Line 179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

175: END IF;
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178:
179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: -- Debug info.

Line 196: x_return_status := fnd_api.g_ret_sts_unexp_error;

192: p_prefix=>l_debug_prefix,
193: p_msg_level=>fnd_log.level_procedure);
194: END IF;
195: WHEN OTHERS THEN
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197:
198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
199: fnd_message.set_token('ERROR' ,SQLERRM);
200: fnd_msg_pub.add;

Line 202: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
199: fnd_message.set_token('ERROR' ,SQLERRM);
200: fnd_msg_pub.add;
201:
202: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
203: p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: -- Debug info.

Line 263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

259: */
260:
261:
262: PROCEDURE get_organization_bo(
263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
264: p_organization_id IN NUMBER,
265: p_action_type IN VARCHAR2 := NULL,
266: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
267: x_return_status OUT NOCOPY VARCHAR2,

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: l_prof_id number;
657: BEGIN
658:
659: -- initialize API return status to success.
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE
663: IF FND_API.to_Boolean(p_init_msg_list) THEN
664: FND_MSG_PUB.initialize;

Line 663: IF FND_API.to_Boolean(p_init_msg_list) THEN

659: -- initialize API return status to success.
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE
663: IF FND_API.to_Boolean(p_init_msg_list) THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667:

Line 680: (p_init_msg_list => fnd_api.g_false,

676: fetch c1 into x_organization_obj;
677: close c1;
678:
679: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
680: (p_init_msg_list => fnd_api.g_false,
681: p_owner_table_id => p_organization_id,
682: p_owner_table_name => 'HZ_PARTIES',
683: p_action_type => NULL, --p_action_type,
684: x_orig_sys_ref_objs => x_organization_obj.orig_sys_objs,

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: open get_profile_id_csr;

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: open get_profile_id_csr;
694: fetch get_profile_id_csr into l_prof_id;

Line 698: (p_init_msg_list => fnd_api.g_false,

694: fetch get_profile_id_csr into l_prof_id;
695: close get_profile_id_csr;
696:
697: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
698: (p_init_msg_list => fnd_api.g_false,
699: p_ext_object_id => l_prof_id,
700: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',
701: p_action_type => p_action_type,
702: x_ext_attribute_objs => x_organization_obj.ext_attributes_objs,

Line 707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

703: x_return_status => x_return_status,
704: x_msg_count => x_msg_count,
705: x_msg_data => x_msg_data);
706:
707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos

Line 708: RAISE FND_API.G_EXC_ERROR;

704: x_msg_count => x_msg_count,
705: x_msg_data => x_msg_data);
706:
707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
712: (p_init_msg_list => fnd_api.g_false,

Line 712: (p_init_msg_list => fnd_api.g_false,

708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
712: (p_init_msg_list => fnd_api.g_false,
713: p_party_id => p_organization_id,
714: p_party_site_id => NULL,
715: p_action_type => p_action_type,
716: x_party_site_objs => x_organization_obj.party_site_objs,

Line 721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);
720:
721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos

Line 722: RAISE FND_API.G_EXC_ERROR;

718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);
720:
721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
726: (p_init_msg_list => fnd_api.g_false,

Line 726: (p_init_msg_list => fnd_api.g_false,

722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
726: (p_init_msg_list => fnd_api.g_false,
727: p_owner_table_id => p_organization_id,
728: p_owner_table_name => 'HZ_PARTIES',
729: p_action_type => p_action_type,
730: x_party_usage_objs => x_organization_obj.party_usage_objs,

Line 735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

731: x_return_status => x_return_status,
732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data);
734:
735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:
739: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos

Line 736: RAISE FND_API.G_EXC_ERROR;

732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data);
734:
735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:
739: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos
740: (p_init_msg_list => fnd_api.g_false,

Line 740: (p_init_msg_list => fnd_api.g_false,

736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:
739: HZ_EXTRACT_ORG_CONT_BO_PVT.get_org_contact_bos
740: (p_init_msg_list => fnd_api.g_false,
741: p_organization_id => p_organization_id,
742: p_action_type => p_action_type,
743: x_org_contact_objs => x_organization_obj.contact_objs,
744: x_return_status => x_return_status,

Line 748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

744: x_return_status => x_return_status,
745: x_msg_count => x_msg_count,
746: x_msg_data => x_msg_data);
747:
748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751:
752:

Line 749: RAISE FND_API.G_EXC_ERROR;

745: x_msg_count => x_msg_count,
746: x_msg_data => x_msg_data);
747:
748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751:
752:
753: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,

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

749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751:
752:
753: get_financial_report_bos(p_init_msg_list => fnd_api.g_false,
754: p_organization_id => p_organization_id,
755: p_action_type => p_action_type,
756: x_financial_report_objs => x_organization_obj.financial_report_objs,
757: x_return_status => x_return_status,

Line 762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

758: x_msg_count => x_msg_count,
759: x_msg_data => x_msg_data);
760:
761:
762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: hz_extract_cont_point_bo_pvt.get_phone_bos

Line 763: RAISE FND_API.G_EXC_ERROR;

759: x_msg_data => x_msg_data);
760:
761:
762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: hz_extract_cont_point_bo_pvt.get_phone_bos
767: (p_init_msg_list => fnd_api.g_false,

Line 767: (p_init_msg_list => fnd_api.g_false,

763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: hz_extract_cont_point_bo_pvt.get_phone_bos
767: (p_init_msg_list => fnd_api.g_false,
768: p_phone_id => null,
769: p_parent_id => p_organization_id,
770: p_parent_table_name => 'HZ_PARTIES',
771: p_action_type => p_action_type,

Line 777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

773: x_return_status => x_return_status,
774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776:
777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781: hz_extract_cont_point_bo_pvt.get_telex_bos

Line 778: RAISE FND_API.G_EXC_ERROR;

774: x_msg_count => x_msg_count,
775: x_msg_data => x_msg_data);
776:
777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781: hz_extract_cont_point_bo_pvt.get_telex_bos
782: (p_init_msg_list => fnd_api.g_false,

Line 782: (p_init_msg_list => fnd_api.g_false,

778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780:
781: hz_extract_cont_point_bo_pvt.get_telex_bos
782: (p_init_msg_list => fnd_api.g_false,
783: p_telex_id => null,
784: p_parent_id => p_organization_id,
785: p_parent_table_name => 'HZ_PARTIES',
786: p_action_type => p_action_type,

Line 792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

788: x_return_status => x_return_status,
789: x_msg_count => x_msg_count,
790: x_msg_data => x_msg_data);
791:
792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796:

Line 793: RAISE FND_API.G_EXC_ERROR;

789: x_msg_count => x_msg_count,
790: x_msg_data => x_msg_data);
791:
792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796:
797: hz_extract_cont_point_bo_pvt.get_email_bos

Line 798: (p_init_msg_list => fnd_api.g_false,

794: END IF;
795:
796:
797: hz_extract_cont_point_bo_pvt.get_email_bos
798: (p_init_msg_list => fnd_api.g_false,
799: p_email_id => null,
800: p_parent_id => p_organization_id,
801: p_parent_table_name => 'HZ_PARTIES',
802: p_action_type => p_action_type,

Line 808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

804: x_return_status => x_return_status,
805: x_msg_count => x_msg_count,
806: x_msg_data => x_msg_data);
807:
808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;
811:
812:

Line 809: RAISE FND_API.G_EXC_ERROR;

805: x_msg_count => x_msg_count,
806: x_msg_data => x_msg_data);
807:
808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;
811:
812:
813: hz_extract_cont_point_bo_pvt.get_web_bos

Line 814: (p_init_msg_list => fnd_api.g_false,

810: END IF;
811:
812:
813: hz_extract_cont_point_bo_pvt.get_web_bos
814: (p_init_msg_list => fnd_api.g_false,
815: p_web_id => null,
816: p_parent_id => p_organization_id,
817: p_parent_table_name => 'HZ_PARTIES',
818: p_action_type => p_action_type,

Line 824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

820: x_return_status => x_return_status,
821: x_msg_count => x_msg_count,
822: x_msg_data => x_msg_data);
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828:

Line 825: RAISE FND_API.G_EXC_ERROR;

821: x_msg_count => x_msg_count,
822: x_msg_data => x_msg_data);
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828:
829:

Line 831: (p_init_msg_list => fnd_api.g_false,

827:
828:
829:
830: hz_extract_cont_point_bo_pvt.get_edi_bos
831: (p_init_msg_list => fnd_api.g_false,
832: p_edi_id => null,
833: p_parent_id => p_organization_id,
834: p_parent_table_name => 'HZ_PARTIES',
835: p_action_type => p_action_type,

Line 841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

837: x_return_status => x_return_status,
838: x_msg_count => x_msg_count,
839: x_msg_data => x_msg_data);
840:
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845:

Line 842: RAISE FND_API.G_EXC_ERROR;

838: x_msg_count => x_msg_count,
839: x_msg_data => x_msg_data);
840:
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845:
846: hz_extract_cont_point_bo_pvt.get_eft_bos

Line 847: (p_init_msg_list => fnd_api.g_false,

843: END IF;
844:
845:
846: hz_extract_cont_point_bo_pvt.get_eft_bos
847: (p_init_msg_list => fnd_api.g_false,
848: p_eft_id => null,
849: p_parent_id => p_organization_id,
850: p_parent_table_name => 'HZ_PARTIES',
851: p_action_type => p_action_type,

Line 857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

853: x_return_status => x_return_status,
854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856:
857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861:

Line 858: RAISE FND_API.G_EXC_ERROR;

854: x_msg_count => x_msg_count,
855: x_msg_data => x_msg_data);
856:
857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861:
862: HZ_EXTRACT_RELATIONSHIP_BO_PVT.get_relationship_bos

Line 863: (p_init_msg_list => fnd_api.g_false,

859: END IF;
860:
861:
862: HZ_EXTRACT_RELATIONSHIP_BO_PVT.get_relationship_bos
863: (p_init_msg_list => fnd_api.g_false,
864: p_subject_id => p_organization_id,
865: p_action_type => p_action_type,
866: x_relationship_objs => x_organization_obj.relationship_objs,
867: x_return_status => x_return_status,

Line 871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

867: x_return_status => x_return_status,
868: x_msg_count => x_msg_count,
869: x_msg_data => x_msg_data);
870:
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:
875:

Line 872: RAISE FND_API.G_EXC_ERROR;

868: x_msg_count => x_msg_count,
869: x_msg_data => x_msg_data);
870:
871: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:
875:
876: hz_extract_cont_point_bo_pvt.get_cont_pref_objs

Line 877: (p_init_msg_list => fnd_api.g_false,

873: END IF;
874:
875:
876: hz_extract_cont_point_bo_pvt.get_cont_pref_objs
877: (p_init_msg_list => fnd_api.g_false,
878: p_cont_level_table_id => p_organization_id,
879: p_cont_level_table => 'HZ_PARTIES',
880: p_contact_type => NULL,
881: p_action_type => p_action_type,

Line 887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

883: x_return_status => x_return_status,
884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886:
887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;
890:
891:

Line 888: RAISE FND_API.G_EXC_ERROR;

884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886:
887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;
890:
891:
892: -- Debug info.

Line 910: WHEN fnd_api.g_exc_error THEN

906:
907:
908: EXCEPTION
909:
910: WHEN fnd_api.g_exc_error THEN
911: x_return_status := fnd_api.g_ret_sts_error;
912:
913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,

Line 911: x_return_status := fnd_api.g_ret_sts_error;

907:
908: EXCEPTION
909:
910: WHEN fnd_api.g_exc_error THEN
911: x_return_status := fnd_api.g_ret_sts_error;
912:
913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data);

Line 913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

909:
910: WHEN fnd_api.g_exc_error THEN
911: x_return_status := fnd_api.g_ret_sts_error;
912:
913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data);
916:
917: -- Debug info.

Line 929: WHEN fnd_api.g_exc_unexpected_error THEN

925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:
932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
933: p_count => x_msg_count,

Line 930: x_return_status := fnd_api.g_ret_sts_unexp_error;

926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:
932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
933: p_count => x_msg_count,
934: p_data => x_msg_data);

Line 932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:
932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935:
936: -- Debug info.

Line 949: x_return_status := fnd_api.g_ret_sts_unexp_error;

945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;
948: WHEN OTHERS THEN
949: x_return_status := fnd_api.g_ret_sts_unexp_error;
950:
951: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
952: fnd_message.set_token('ERROR' ,SQLERRM);
953: fnd_msg_pub.add;

Line 955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

951: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
952: fnd_message.set_token('ERROR' ,SQLERRM);
953: fnd_msg_pub.add;
954:
955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
956: p_count => x_msg_count,
957: p_data => x_msg_data);
958:
959: -- Debug info.

Line 994: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

990: -- ARGUMENTS
991: -- IN:
992: -- p_init_msg_list Initialize message stack if it is set to
993: -- p_event_id BES Event identifier.
994: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
995: -- OUT:
996: -- x_organization_objs One or more created logical organization.
997: -- x_return_status Return status after the call. The status can
998: -- be fnd_api.g_ret_sts_success (success),

Line 998: -- be fnd_api.g_ret_sts_success (success),

994: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
995: -- OUT:
996: -- x_organization_objs One or more created logical organization.
997: -- x_return_status Return status after the call. The status can
998: -- be fnd_api.g_ret_sts_success (success),
999: -- fnd_api.g_ret_sts_error (error),
1000: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1001: -- x_msg_count Number of messages in message stack.
1002: -- x_msg_data Message text if x_msg_count is 1.

Line 999: -- fnd_api.g_ret_sts_error (error),

995: -- OUT:
996: -- x_organization_objs One or more created logical organization.
997: -- x_return_status Return status after the call. The status can
998: -- be fnd_api.g_ret_sts_success (success),
999: -- fnd_api.g_ret_sts_error (error),
1000: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1001: -- x_msg_count Number of messages in message stack.
1002: -- x_msg_data Message text if x_msg_count is 1.
1003: --

Line 1000: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

996: -- x_organization_objs One or more created logical organization.
997: -- x_return_status Return status after the call. The status can
998: -- be fnd_api.g_ret_sts_success (success),
999: -- fnd_api.g_ret_sts_error (error),
1000: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1001: -- x_msg_count Number of messages in message stack.
1002: -- x_msg_data Message text if x_msg_count is 1.
1003: --
1004: -- NOTES

Line 1028: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1024: */
1025:
1026:
1027: PROCEDURE get_organizations_created(
1028: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1029: p_event_id IN NUMBER,
1030: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
1031: x_return_status OUT NOCOPY VARCHAR2,
1032: x_msg_count OUT NOCOPY NUMBER,

Line 1040: x_return_status := FND_API.G_RET_STS_SUCCESS;

1036: l_debug_prefix VARCHAR2(30) := '';
1037: begin
1038:
1039: -- initialize API return status to success.
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE
1043: IF FND_API.to_Boolean(p_init_msg_list) THEN
1044: FND_MSG_PUB.initialize;

Line 1043: IF FND_API.to_Boolean(p_init_msg_list) THEN

1039: -- initialize API return status to success.
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE
1043: IF FND_API.to_Boolean(p_init_msg_list) THEN
1044: FND_MSG_PUB.initialize;
1045: END IF;
1046:
1047:

Line 1057: p_init_msg_list => fnd_api.g_false,

1053: END IF;
1054:
1055:
1056: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1057: p_init_msg_list => fnd_api.g_false,
1058: p_event_id => p_event_id,
1059: x_obj_root_ids => l_obj_root_ids,
1060: x_return_status => x_return_status,
1061: x_msg_count => x_msg_count,

Line 1064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1060: x_return_status => x_return_status,
1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data);
1063:
1064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067:
1068:

Line 1065: RAISE FND_API.G_EXC_ERROR;

1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data);
1063:
1064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067:
1068:
1069: x_organization_objs := HZ_ORGANIZATION_BO_TBL();

Line 1074: p_init_msg_list => fnd_api.g_false,

1070:
1071: for i in 1..l_obj_root_ids.count loop
1072: x_organization_objs.extend;
1073: get_organization_bo(
1074: p_init_msg_list => fnd_api.g_false,
1075: p_organization_id => l_obj_root_ids(i),
1076: p_action_type => 'CREATED',
1077: x_organization_obj => x_organization_objs(i),
1078: x_return_status => x_return_status,

Line 1101: WHEN fnd_api.g_exc_error THEN

1097:
1098:
1099: EXCEPTION
1100:
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := fnd_api.g_ret_sts_error;
1103:
1104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1105: p_count => x_msg_count,

Line 1102: x_return_status := fnd_api.g_ret_sts_error;

1098:
1099: EXCEPTION
1100:
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := fnd_api.g_ret_sts_error;
1103:
1104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);

Line 1104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1100:
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := fnd_api.g_ret_sts_error;
1103:
1104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:
1108: -- Debug info.

Line 1120: WHEN fnd_api.g_exc_unexpected_error THEN

1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1124: p_count => x_msg_count,

Line 1121: x_return_status := fnd_api.g_ret_sts_unexp_error;

1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);

Line 1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
1127: -- Debug info.

Line 1140: x_return_status := fnd_api.g_ret_sts_unexp_error;

1136: p_prefix=>l_debug_prefix,
1137: p_msg_level=>fnd_log.level_procedure);
1138: END IF;
1139: WHEN OTHERS THEN
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:
1142: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1143: fnd_message.set_token('ERROR' ,SQLERRM);
1144: fnd_msg_pub.add;

Line 1146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1142: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1143: fnd_message.set_token('ERROR' ,SQLERRM);
1144: fnd_msg_pub.add;
1145:
1146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: -- Debug info.

Line 1185: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

1181: -- ARGUMENTS
1182: -- IN:
1183: -- p_init_msg_list Initialize message stack if it is set to
1184: -- p_event_id BES Event identifier.
1185: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1186: -- OUT:
1187: -- x_organization_objs One or more created logical organization.
1188: -- x_return_status Return status after the call. The status can
1189: -- be fnd_api.g_ret_sts_success (success),

Line 1189: -- be fnd_api.g_ret_sts_success (success),

1185: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1186: -- OUT:
1187: -- x_organization_objs One or more created logical organization.
1188: -- x_return_status Return status after the call. The status can
1189: -- be fnd_api.g_ret_sts_success (success),
1190: -- fnd_api.g_ret_sts_error (error),
1191: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1192: -- x_msg_count Number of messages in message stack.
1193: -- x_msg_data Message text if x_msg_count is 1.

Line 1190: -- fnd_api.g_ret_sts_error (error),

1186: -- OUT:
1187: -- x_organization_objs One or more created logical organization.
1188: -- x_return_status Return status after the call. The status can
1189: -- be fnd_api.g_ret_sts_success (success),
1190: -- fnd_api.g_ret_sts_error (error),
1191: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1192: -- x_msg_count Number of messages in message stack.
1193: -- x_msg_data Message text if x_msg_count is 1.
1194: --

Line 1191: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1187: -- x_organization_objs One or more created logical organization.
1188: -- x_return_status Return status after the call. The status can
1189: -- be fnd_api.g_ret_sts_success (success),
1190: -- fnd_api.g_ret_sts_error (error),
1191: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1192: -- x_msg_count Number of messages in message stack.
1193: -- x_msg_data Message text if x_msg_count is 1.
1194: --
1195: -- NOTES

Line 1215: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1211: returns them to the caller.
1212: */
1213:
1214: PROCEDURE get_organizations_updated(
1215: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1216: p_event_id IN NUMBER,
1217: x_organization_objs OUT NOCOPY HZ_ORGANIZATION_BO_TBL,
1218: x_return_status OUT NOCOPY VARCHAR2,
1219: x_msg_count OUT NOCOPY NUMBER,

Line 1229: x_return_status := FND_API.G_RET_STS_SUCCESS;

1225:
1226: begin
1227:
1228: -- initialize API return status to success.
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231: -- Initialize message list if p_init_msg_list is set to TRUE
1232: IF FND_API.to_Boolean(p_init_msg_list) THEN
1233: FND_MSG_PUB.initialize;

Line 1232: IF FND_API.to_Boolean(p_init_msg_list) THEN

1228: -- initialize API return status to success.
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231: -- Initialize message list if p_init_msg_list is set to TRUE
1232: IF FND_API.to_Boolean(p_init_msg_list) THEN
1233: FND_MSG_PUB.initialize;
1234: END IF;
1235:
1236:

Line 1246: p_init_msg_list => fnd_api.g_false,

1242: END IF;
1243:
1244:
1245: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1246: p_init_msg_list => fnd_api.g_false,
1247: p_event_id => p_event_id,
1248: x_obj_root_ids => l_obj_root_ids,
1249: x_return_status => x_return_status,
1250: x_msg_count => x_msg_count,

Line 1253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1249: x_return_status => x_return_status,
1250: x_msg_count => x_msg_count,
1251: x_msg_data => x_msg_data);
1252:
1253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1254: RAISE FND_API.G_EXC_ERROR;
1255: END IF;
1256:
1257: -- call event API get_organization_updated for each id.

Line 1254: RAISE FND_API.G_EXC_ERROR;

1250: x_msg_count => x_msg_count,
1251: x_msg_data => x_msg_data);
1252:
1253: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1254: RAISE FND_API.G_EXC_ERROR;
1255: END IF;
1256:
1257: -- call event API get_organization_updated for each id.
1258:

Line 1264: p_init_msg_list => fnd_api.g_false,

1260:
1261: for i in 1..l_obj_root_ids.count loop
1262: x_organization_objs.extend;
1263: get_organization_updated(
1264: p_init_msg_list => fnd_api.g_false,
1265: p_event_id => p_event_id,
1266: p_organization_id => l_obj_root_ids(i),
1267: x_organization_obj => x_organization_objs(i),
1268: x_return_status => x_return_status,

Line 1272: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,
1270: x_msg_data => x_msg_data);
1271:
1272: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275: end loop;
1276:

Line 1273: RAISE FND_API.G_EXC_ERROR;

1269: x_msg_count => x_msg_count,
1270: x_msg_data => x_msg_data);
1271:
1272: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275: end loop;
1276:
1277:

Line 1297: WHEN fnd_api.g_exc_error THEN

1293:
1294:
1295: EXCEPTION
1296:
1297: WHEN fnd_api.g_exc_error THEN
1298: x_return_status := fnd_api.g_ret_sts_error;
1299:
1300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1301: p_count => x_msg_count,

Line 1298: x_return_status := fnd_api.g_ret_sts_error;

1294:
1295: EXCEPTION
1296:
1297: WHEN fnd_api.g_exc_error THEN
1298: x_return_status := fnd_api.g_ret_sts_error;
1299:
1300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data);

Line 1300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1296:
1297: WHEN fnd_api.g_exc_error THEN
1298: x_return_status := fnd_api.g_ret_sts_error;
1299:
1300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data);
1303:
1304: -- Debug info.

Line 1316: WHEN fnd_api.g_exc_unexpected_error THEN

1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:
1319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1320: p_count => x_msg_count,

Line 1317: x_return_status := fnd_api.g_ret_sts_unexp_error;

1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:
1319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1320: p_count => x_msg_count,
1321: p_data => x_msg_data);

Line 1319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:
1319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1320: p_count => x_msg_count,
1321: p_data => x_msg_data);
1322:
1323: -- Debug info.

Line 1336: x_return_status := fnd_api.g_ret_sts_unexp_error;

1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335: WHEN OTHERS THEN
1336: x_return_status := fnd_api.g_ret_sts_unexp_error;
1337:
1338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1339: fnd_message.set_token('ERROR' ,SQLERRM);
1340: fnd_msg_pub.add;

Line 1342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1339: fnd_message.set_token('ERROR' ,SQLERRM);
1340: fnd_msg_pub.add;
1341:
1342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1343: p_count => x_msg_count,
1344: p_data => x_msg_data);
1345:
1346: -- Debug info.

Line 1500: x_return_status := FND_API.G_RET_STS_SUCCESS;

1496: l_child_upd_flag varchar2(1);
1497:
1498: begin
1499: -- initialize API return status to success.
1500: x_return_status := FND_API.G_RET_STS_SUCCESS;
1501:
1502: -- Solve populate_flag is not in sync in hz_parties and hz_org_profiles.
1503: -- c1 can't return profile entity.
1504:

Line 2006: WHEN fnd_api.g_exc_unexpected_error THEN

2002:
2003: EXCEPTION
2004:
2005:
2006: WHEN fnd_api.g_exc_unexpected_error THEN
2007: x_return_status := fnd_api.g_ret_sts_unexp_error;
2008:
2009:
2010: WHEN OTHERS THEN

Line 2007: x_return_status := fnd_api.g_ret_sts_unexp_error;

2003: EXCEPTION
2004:
2005:
2006: WHEN fnd_api.g_exc_unexpected_error THEN
2007: x_return_status := fnd_api.g_ret_sts_unexp_error;
2008:
2009:
2010: WHEN OTHERS THEN
2011: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2011: x_return_status := fnd_api.g_ret_sts_unexp_error;

2007: x_return_status := fnd_api.g_ret_sts_unexp_error;
2008:
2009:
2010: WHEN OTHERS THEN
2011: x_return_status := fnd_api.g_ret_sts_unexp_error;
2012:
2013: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2014: fnd_message.set_token('ERROR' ,SQLERRM);
2015: fnd_msg_pub.add;

Line 2035: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

2031: -- ARGUMENTS
2032: -- IN:
2033: -- p_init_msg_list Initialize message stack if it is set to
2034: -- p_event_id BES Event identifier.
2035: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2036: -- OUT:
2037: -- x_organization_objs One or more created logical organization.
2038: -- x_return_status Return status after the call. The status can
2039: -- be fnd_api.g_ret_sts_success (success),

Line 2039: -- be fnd_api.g_ret_sts_success (success),

2035: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2036: -- OUT:
2037: -- x_organization_objs One or more created logical organization.
2038: -- x_return_status Return status after the call. The status can
2039: -- be fnd_api.g_ret_sts_success (success),
2040: -- fnd_api.g_ret_sts_error (error),
2041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2042: -- x_msg_count Number of messages in message stack.
2043: -- x_msg_data Message text if x_msg_count is 1.

Line 2040: -- fnd_api.g_ret_sts_error (error),

2036: -- OUT:
2037: -- x_organization_objs One or more created logical organization.
2038: -- x_return_status Return status after the call. The status can
2039: -- be fnd_api.g_ret_sts_success (success),
2040: -- fnd_api.g_ret_sts_error (error),
2041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2042: -- x_msg_count Number of messages in message stack.
2043: -- x_msg_data Message text if x_msg_count is 1.
2044: --

Line 2041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

2037: -- x_organization_objs One or more created logical organization.
2038: -- x_return_status Return status after the call. The status can
2039: -- be fnd_api.g_ret_sts_success (success),
2040: -- fnd_api.g_ret_sts_error (error),
2041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2042: -- x_msg_count Number of messages in message stack.
2043: -- x_msg_data Message text if x_msg_count is 1.
2044: --
2045: -- NOTES

Line 2053: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2049: -- 06-JUN-2005 AWU Created.
2050: --
2051:
2052: PROCEDURE get_organization_updated(
2053: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2054: p_event_id IN NUMBER,
2055: p_organization_id IN NUMBER,
2056: x_organization_obj OUT NOCOPY HZ_ORGANIZATION_BO,
2057: x_return_status OUT NOCOPY VARCHAR2,

Line 2069: x_return_status := FND_API.G_RET_STS_SUCCESS;

2065:
2066: begin
2067:
2068: -- initialize API return status to success.
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071: -- Initialize message list if p_init_msg_list is set to TRUE
2072: IF FND_API.to_Boolean(p_init_msg_list) THEN
2073: FND_MSG_PUB.initialize;

Line 2072: IF FND_API.to_Boolean(p_init_msg_list) THEN

2068: -- initialize API return status to success.
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071: -- Initialize message list if p_init_msg_list is set to TRUE
2072: IF FND_API.to_Boolean(p_init_msg_list) THEN
2073: FND_MSG_PUB.initialize;
2074: END IF;
2075:
2076:

Line 2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2084: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2085: p_party_id => p_organization_id,
2086: x_return_status => x_return_status);
2087:
2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091: */
2092: -- Set action type to 'UNCHANGED' by default

Line 2089: RAISE FND_API.G_EXC_ERROR;

2085: p_party_id => p_organization_id,
2086: x_return_status => x_return_status);
2087:
2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091: */
2092: -- Set action type to 'UNCHANGED' by default
2093:

Line 2095: p_init_msg_list => fnd_api.g_false,

2091: */
2092: -- Set action type to 'UNCHANGED' by default
2093:
2094: get_organization_bo(
2095: p_init_msg_list => fnd_api.g_false,
2096: p_organization_id => p_organization_id,
2097: p_action_type => 'UNCHANGED',
2098: x_organization_obj => x_organization_obj,
2099: x_return_status => x_return_status,

Line 2103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2099: x_return_status => x_return_status,
2100: x_msg_count => x_msg_count,
2101: x_msg_data => x_msg_data);
2102:
2103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106:
2107:

Line 2104: RAISE FND_API.G_EXC_ERROR;

2100: x_msg_count => x_msg_count,
2101: x_msg_data => x_msg_data);
2102:
2103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106:
2107:
2108: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

Line 2117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2113: p_root_id => p_organization_id,
2114: px_org_obj => l_organization_obj,
2115: x_return_status => x_return_status
2116: );
2117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: x_organization_obj := l_organization_obj;

Line 2118: RAISE FND_API.G_EXC_ERROR;

2114: px_org_obj => l_organization_obj,
2115: x_return_status => x_return_status
2116: );
2117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: x_organization_obj := l_organization_obj;
2122:

Line 2143: WHEN fnd_api.g_exc_error THEN

2139:
2140:
2141: EXCEPTION
2142:
2143: WHEN fnd_api.g_exc_error THEN
2144: x_return_status := fnd_api.g_ret_sts_error;
2145:
2146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2147: p_count => x_msg_count,

Line 2144: x_return_status := fnd_api.g_ret_sts_error;

2140:
2141: EXCEPTION
2142:
2143: WHEN fnd_api.g_exc_error THEN
2144: x_return_status := fnd_api.g_ret_sts_error;
2145:
2146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);

Line 2146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2142:
2143: WHEN fnd_api.g_exc_error THEN
2144: x_return_status := fnd_api.g_ret_sts_error;
2145:
2146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: -- Debug info.

Line 2162: WHEN fnd_api.g_exc_unexpected_error THEN

2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,

Line 2163: x_return_status := fnd_api.g_ret_sts_unexp_error;

2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);

Line 2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.

Line 2182: x_return_status := fnd_api.g_ret_sts_unexp_error;

2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;
2181: WHEN OTHERS THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2184: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2185: fnd_message.set_token('ERROR' ,SQLERRM);
2186: fnd_msg_pub.add;

Line 2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2184: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2185: fnd_message.set_token('ERROR' ,SQLERRM);
2186: fnd_msg_pub.add;
2187:
2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: -- Debug info.