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_PERSON_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_person_id Person ID.
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_person_obj Logical person 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_person_obj Logical person 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_person_obj Logical person 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_person_obj Logical person 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_employ_hist_bos
45:
46: PROCEDURE get_employ_hist_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_person_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_employ_hist_objs OUT NOCOPY HZ_EMPLOY_HIST_BO_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 119: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 154: WHEN fnd_api.g_exc_error THEN

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

Line 155: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 173: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 174: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 193: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

255:
256:
257:
258: PROCEDURE get_person_bo(
259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
260: p_person_id IN NUMBER,
261: p_action_type IN VARCHAR2 := NULL,
262: x_person_obj OUT NOCOPY HZ_PERSON_BO,
263: x_return_status OUT NOCOPY VARCHAR2,

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

556: l_prof_id number;
557: BEGIN
558:
559: -- initialize API return status to success.
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561:
562: -- Initialize message list if p_init_msg_list is set to TRUE
563: IF FND_API.to_Boolean(p_init_msg_list) THEN
564: FND_MSG_PUB.initialize;

Line 563: IF FND_API.to_Boolean(p_init_msg_list) THEN

559: -- initialize API return status to success.
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561:
562: -- Initialize message list if p_init_msg_list is set to TRUE
563: IF FND_API.to_Boolean(p_init_msg_list) THEN
564: FND_MSG_PUB.initialize;
565: END IF;
566:
567:

Line 580: (p_init_msg_list => fnd_api.g_false,

576: fetch c1 into x_person_obj;
577: close c1;
578:
579: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
580: (p_init_msg_list => fnd_api.g_false,
581: p_owner_table_id => p_person_id,
582: p_owner_table_name => 'HZ_PARTIES',
583: p_action_type => NULL, --p_action_type,
584: x_orig_sys_ref_objs => x_person_obj.orig_sys_objs,

Line 589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

585: x_return_status => x_return_status,
586: x_msg_count => x_msg_count,
587: x_msg_data => x_msg_data);
588:
589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos

Line 590: RAISE FND_API.G_EXC_ERROR;

586: x_msg_count => x_msg_count,
587: x_msg_data => x_msg_data);
588:
589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
594: (p_init_msg_list => fnd_api.g_false,

Line 594: (p_init_msg_list => fnd_api.g_false,

590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
594: (p_init_msg_list => fnd_api.g_false,
595: p_owner_table_id => p_person_id,
596: p_owner_table_name => 'HZ_PARTIES',
597: p_action_type => p_action_type,
598: x_party_usage_objs => x_person_obj.party_usage_objs,

Line 603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

599: x_return_status => x_return_status,
600: x_msg_count => x_msg_count,
601: x_msg_data => x_msg_data);
602:
603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606:
607: open get_profile_id_csr;

Line 604: RAISE FND_API.G_EXC_ERROR;

600: x_msg_count => x_msg_count,
601: x_msg_data => x_msg_data);
602:
603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606:
607: open get_profile_id_csr;
608: fetch get_profile_id_csr into l_prof_id;

Line 612: (p_init_msg_list => fnd_api.g_false,

608: fetch get_profile_id_csr into l_prof_id;
609: close get_profile_id_csr;
610:
611: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
612: (p_init_msg_list => fnd_api.g_false,
613: p_ext_object_id => l_prof_id,
614: p_ext_object_name => 'HZ_PERSON_PROFILES',
615: p_action_type => p_action_type,
616: x_ext_attribute_objs => x_person_obj.ext_attributes_objs,

Line 621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

617: x_return_status => x_return_status,
618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data);
620:
621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624:
625:

Line 622: RAISE FND_API.G_EXC_ERROR;

618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data);
620:
621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624:
625:
626:

Line 628: (p_init_msg_list => fnd_api.g_false,

624:
625:
626:
627: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
628: (p_init_msg_list => fnd_api.g_false,
629: p_party_id => p_person_id,
630: p_party_site_id => NULL,
631: p_action_type => p_action_type,
632: x_party_site_objs => x_person_obj.party_site_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_RELATIONSHIP_BO_PVT.get_relationship_bos

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_RELATIONSHIP_BO_PVT.get_relationship_bos
642: (p_init_msg_list => fnd_api.g_false,

Line 642: (p_init_msg_list => fnd_api.g_false,

638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: HZ_EXTRACT_RELATIONSHIP_BO_PVT.get_relationship_bos
642: (p_init_msg_list => fnd_api.g_false,
643: p_subject_id => p_person_id,
644: p_action_type => p_action_type,
645: x_relationship_objs => x_person_obj.relationship_objs,
646: x_return_status => x_return_status,

Line 650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

646: x_return_status => x_return_status,
647: x_msg_count => x_msg_count,
648: x_msg_data => x_msg_data);
649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: hz_extract_cont_point_bo_pvt.get_phone_bos

Line 651: RAISE FND_API.G_EXC_ERROR;

647: x_msg_count => x_msg_count,
648: x_msg_data => x_msg_data);
649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: hz_extract_cont_point_bo_pvt.get_phone_bos
655: (p_init_msg_list => fnd_api.g_false,

Line 655: (p_init_msg_list => fnd_api.g_false,

651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: hz_extract_cont_point_bo_pvt.get_phone_bos
655: (p_init_msg_list => fnd_api.g_false,
656: p_phone_id => null,
657: p_parent_id => p_person_id,
658: p_parent_table_name => 'HZ_PARTIES',
659: p_action_type => p_action_type,

Line 665: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data);
664:
665: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: hz_extract_cont_point_bo_pvt.get_email_bos

Line 666: RAISE FND_API.G_EXC_ERROR;

662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data);
664:
665: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: hz_extract_cont_point_bo_pvt.get_email_bos
670: (p_init_msg_list => fnd_api.g_false,

Line 670: (p_init_msg_list => fnd_api.g_false,

666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: hz_extract_cont_point_bo_pvt.get_email_bos
670: (p_init_msg_list => fnd_api.g_false,
671: p_email_id => null,
672: p_parent_id => p_person_id,
673: p_parent_table_name => 'HZ_PARTIES',
674: p_action_type => p_action_type,

Line 680: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

676: x_return_status => x_return_status,
677: x_msg_count => x_msg_count,
678: x_msg_data => x_msg_data);
679:
680: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684:

Line 681: RAISE FND_API.G_EXC_ERROR;

677: x_msg_count => x_msg_count,
678: x_msg_data => x_msg_data);
679:
680: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684:
685: hz_extract_cont_point_bo_pvt.get_web_bos

Line 686: (p_init_msg_list => fnd_api.g_false,

682: END IF;
683:
684:
685: hz_extract_cont_point_bo_pvt.get_web_bos
686: (p_init_msg_list => fnd_api.g_false,
687: p_web_id => null,
688: p_parent_id => p_person_id,
689: p_parent_table_name => 'HZ_PARTIES',
690: p_action_type => p_action_type,

Line 696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

692: x_return_status => x_return_status,
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695:
696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: hz_extract_cont_point_bo_pvt.get_sms_bos

Line 697: RAISE FND_API.G_EXC_ERROR;

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695:
696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: hz_extract_cont_point_bo_pvt.get_sms_bos
701: (p_init_msg_list => fnd_api.g_false,

Line 701: (p_init_msg_list => fnd_api.g_false,

697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: hz_extract_cont_point_bo_pvt.get_sms_bos
701: (p_init_msg_list => fnd_api.g_false,
702: p_sms_id => null,
703: p_parent_id => p_person_id,
704: p_parent_table_name => 'HZ_PARTIES',
705: p_action_type => p_action_type,

Line 711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

707: x_return_status => x_return_status,
708: x_msg_count => x_msg_count,
709: x_msg_data => x_msg_data);
710:
711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: get_employ_hist_bos(p_init_msg_list => fnd_api.g_false,

Line 712: RAISE FND_API.G_EXC_ERROR;

708: x_msg_count => x_msg_count,
709: x_msg_data => x_msg_data);
710:
711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: get_employ_hist_bos(p_init_msg_list => fnd_api.g_false,
716: p_person_id => p_person_id,

Line 715: get_employ_hist_bos(p_init_msg_list => fnd_api.g_false,

711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: get_employ_hist_bos(p_init_msg_list => fnd_api.g_false,
716: p_person_id => p_person_id,
717: p_action_type => p_action_type,
718: x_employ_hist_objs => x_person_obj.employ_hist_objs,
719: x_return_status => x_return_status,

Line 725: (p_init_msg_list => fnd_api.g_false,

721: x_msg_data => x_msg_data);
722:
723:
724: hz_extract_cont_point_bo_pvt.get_cont_pref_objs
725: (p_init_msg_list => fnd_api.g_false,
726: p_cont_level_table_id => p_person_id,
727: p_cont_level_table => 'HZ_PARTIES',
728: p_contact_type => NULL,
729: p_action_type => p_action_type,

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:

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:
740: -- Debug info.

Line 758: WHEN fnd_api.g_exc_error THEN

754:
755:
756: EXCEPTION
757:
758: WHEN fnd_api.g_exc_error THEN
759: x_return_status := fnd_api.g_ret_sts_error;
760:
761: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
762: p_count => x_msg_count,

Line 759: x_return_status := fnd_api.g_ret_sts_error;

755:
756: EXCEPTION
757:
758: WHEN fnd_api.g_exc_error THEN
759: x_return_status := fnd_api.g_ret_sts_error;
760:
761: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
762: p_count => x_msg_count,
763: p_data => x_msg_data);

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

757:
758: WHEN fnd_api.g_exc_error THEN
759: x_return_status := fnd_api.g_ret_sts_error;
760:
761: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
762: p_count => x_msg_count,
763: p_data => x_msg_data);
764:
765: -- Debug info.

Line 777: WHEN fnd_api.g_exc_unexpected_error THEN

773: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
774: p_prefix=>l_debug_prefix,
775: p_msg_level=>fnd_log.level_procedure);
776: END IF;
777: WHEN fnd_api.g_exc_unexpected_error THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779:
780: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
781: p_count => x_msg_count,

Line 778: x_return_status := fnd_api.g_ret_sts_unexp_error;

774: p_prefix=>l_debug_prefix,
775: p_msg_level=>fnd_log.level_procedure);
776: END IF;
777: WHEN fnd_api.g_exc_unexpected_error THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779:
780: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
781: p_count => x_msg_count,
782: p_data => x_msg_data);

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

776: END IF;
777: WHEN fnd_api.g_exc_unexpected_error THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779:
780: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
781: p_count => x_msg_count,
782: p_data => x_msg_data);
783:
784: -- Debug info.

Line 797: x_return_status := fnd_api.g_ret_sts_unexp_error;

793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;
796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:
799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;

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

799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;
802:
803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806:
807: -- Debug info.

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

836: -- ARGUMENTS
837: -- IN:
838: -- p_init_msg_list Initialize message stack if it is set to
839: -- p_event_id BES Event identifier.
840: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
841: -- OUT:
842: -- x_person_objs One or more created logical person.
843: -- x_return_status Return status after the call. The status can
844: -- be fnd_api.g_ret_sts_success (success),

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

840: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
841: -- OUT:
842: -- x_person_objs One or more created logical person.
843: -- x_return_status Return status after the call. The status can
844: -- be fnd_api.g_ret_sts_success (success),
845: -- fnd_api.g_ret_sts_error (error),
846: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
847: -- x_msg_count Number of messages in message stack.
848: -- x_msg_data Message text if x_msg_count is 1.

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

841: -- OUT:
842: -- x_person_objs One or more created logical person.
843: -- x_return_status Return status after the call. The status can
844: -- be fnd_api.g_ret_sts_success (success),
845: -- fnd_api.g_ret_sts_error (error),
846: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
847: -- x_msg_count Number of messages in message stack.
848: -- x_msg_data Message text if x_msg_count is 1.
849: --

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

842: -- x_person_objs One or more created logical person.
843: -- x_return_status Return status after the call. The status can
844: -- be fnd_api.g_ret_sts_success (success),
845: -- fnd_api.g_ret_sts_error (error),
846: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
847: -- x_msg_count Number of messages in message stack.
848: -- x_msg_data Message text if x_msg_count is 1.
849: --
850: -- NOTES

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

870: */
871:
872:
873: PROCEDURE get_persons_created(
874: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
875: p_event_id IN NUMBER,
876: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,

Line 887: x_return_status := FND_API.G_RET_STS_SUCCESS;

883: l_debug_prefix VARCHAR2(30) := '';
884: begin
885:
886: -- initialize API return status to success.
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: -- Initialize message list if p_init_msg_list is set to TRUE
890: IF FND_API.to_Boolean(p_init_msg_list) THEN
891: FND_MSG_PUB.initialize;

Line 890: IF FND_API.to_Boolean(p_init_msg_list) THEN

886: -- initialize API return status to success.
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: -- Initialize message list if p_init_msg_list is set to TRUE
890: IF FND_API.to_Boolean(p_init_msg_list) THEN
891: FND_MSG_PUB.initialize;
892: END IF;
893:
894:

Line 904: p_init_msg_list => fnd_api.g_false,

900: END IF;
901:
902:
903: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
904: p_init_msg_list => fnd_api.g_false,
905: p_event_id => p_event_id,
906: x_obj_root_ids => l_obj_root_ids,
907: x_return_status => x_return_status,
908: x_msg_count => x_msg_count,

Line 911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

907: x_return_status => x_return_status,
908: x_msg_count => x_msg_count,
909: x_msg_data => x_msg_data);
910:
911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: x_person_objs := HZ_PERSON_BO_TBL();

Line 912: RAISE FND_API.G_EXC_ERROR;

908: x_msg_count => x_msg_count,
909: x_msg_data => x_msg_data);
910:
911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: x_person_objs := HZ_PERSON_BO_TBL();
916:

Line 921: p_init_msg_list => fnd_api.g_false,

917: for i in 1..l_obj_root_ids.count loop
918:
919: x_person_objs.extend;
920: get_person_bo(
921: p_init_msg_list => fnd_api.g_false,
922: p_person_id => l_obj_root_ids(i),
923: p_action_type => 'CREATED',
924: x_person_obj => x_person_objs(i),
925: x_return_status => x_return_status,

Line 929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

925: x_return_status => x_return_status,
926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data);
928:
929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933: end loop;

Line 930: RAISE FND_API.G_EXC_ERROR;

926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data);
928:
929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933: end loop;
934:

Line 953: WHEN fnd_api.g_exc_error THEN

949:
950:
951: EXCEPTION
952:
953: WHEN fnd_api.g_exc_error THEN
954: x_return_status := fnd_api.g_ret_sts_error;
955:
956: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
957: p_count => x_msg_count,

Line 954: x_return_status := fnd_api.g_ret_sts_error;

950:
951: EXCEPTION
952:
953: WHEN fnd_api.g_exc_error THEN
954: x_return_status := fnd_api.g_ret_sts_error;
955:
956: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
957: p_count => x_msg_count,
958: p_data => x_msg_data);

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

952:
953: WHEN fnd_api.g_exc_error THEN
954: x_return_status := fnd_api.g_ret_sts_error;
955:
956: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
957: p_count => x_msg_count,
958: p_data => x_msg_data);
959:
960: -- Debug info.

Line 972: WHEN fnd_api.g_exc_unexpected_error THEN

968: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: x_return_status := fnd_api.g_ret_sts_unexp_error;
974:
975: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
976: p_count => x_msg_count,

Line 973: x_return_status := fnd_api.g_ret_sts_unexp_error;

969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: x_return_status := fnd_api.g_ret_sts_unexp_error;
974:
975: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
976: p_count => x_msg_count,
977: p_data => x_msg_data);

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

971: END IF;
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: x_return_status := fnd_api.g_ret_sts_unexp_error;
974:
975: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
976: p_count => x_msg_count,
977: p_data => x_msg_data);
978:
979: -- Debug info.

Line 992: x_return_status := fnd_api.g_ret_sts_unexp_error;

988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: END IF;
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
995: fnd_message.set_token('ERROR' ,SQLERRM);
996: fnd_msg_pub.add;

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

994: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
995: fnd_message.set_token('ERROR' ,SQLERRM);
996: fnd_msg_pub.add;
997:
998: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
999: p_count => x_msg_count,
1000: p_data => x_msg_data);
1001:
1002: -- Debug info.

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

1031: -- ARGUMENTS
1032: -- IN:
1033: -- p_init_msg_list Initialize message stack if it is set to
1034: -- p_event_id BES Event identifier.
1035: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1036: -- OUT:
1037: -- x_person_objs One or more created logical person.
1038: -- x_return_status Return status after the call. The status can
1039: -- be fnd_api.g_ret_sts_success (success),

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

1035: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1036: -- OUT:
1037: -- x_person_objs One or more created logical person.
1038: -- x_return_status Return status after the call. The status can
1039: -- be fnd_api.g_ret_sts_success (success),
1040: -- fnd_api.g_ret_sts_error (error),
1041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1042: -- x_msg_count Number of messages in message stack.
1043: -- x_msg_data Message text if x_msg_count is 1.

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

1036: -- OUT:
1037: -- x_person_objs One or more created logical person.
1038: -- x_return_status Return status after the call. The status can
1039: -- be fnd_api.g_ret_sts_success (success),
1040: -- fnd_api.g_ret_sts_error (error),
1041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1042: -- x_msg_count Number of messages in message stack.
1043: -- x_msg_data Message text if x_msg_count is 1.
1044: --

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

1037: -- x_person_objs One or more created logical person.
1038: -- x_return_status Return status after the call. The status can
1039: -- be fnd_api.g_ret_sts_success (success),
1040: -- fnd_api.g_ret_sts_error (error),
1041: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1042: -- x_msg_count Number of messages in message stack.
1043: -- x_msg_data Message text if x_msg_count is 1.
1044: --
1045: -- NOTES

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

1061: and returns them to the caller.
1062: */
1063:
1064: PROCEDURE get_persons_updated(
1065: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1066: p_event_id IN NUMBER,
1067: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,

Line 1079: x_return_status := FND_API.G_RET_STS_SUCCESS;

1075:
1076: begin
1077:
1078: -- initialize API return status to success.
1079: x_return_status := FND_API.G_RET_STS_SUCCESS;
1080:
1081: -- Initialize message list if p_init_msg_list is set to TRUE
1082: IF FND_API.to_Boolean(p_init_msg_list) THEN
1083: FND_MSG_PUB.initialize;

Line 1082: IF FND_API.to_Boolean(p_init_msg_list) THEN

1078: -- initialize API return status to success.
1079: x_return_status := FND_API.G_RET_STS_SUCCESS;
1080:
1081: -- Initialize message list if p_init_msg_list is set to TRUE
1082: IF FND_API.to_Boolean(p_init_msg_list) THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085:
1086:

Line 1096: p_init_msg_list => fnd_api.g_false,

1092: END IF;
1093:
1094:
1095: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1096: p_init_msg_list => fnd_api.g_false,
1097: p_event_id => p_event_id,
1098: x_obj_root_ids => l_obj_root_ids,
1099: x_return_status => x_return_status,
1100: x_msg_count => x_msg_count,

Line 1103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1099: x_return_status => x_return_status,
1100: x_msg_count => x_msg_count,
1101: x_msg_data => x_msg_data);
1102:
1103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107:

Line 1104: RAISE FND_API.G_EXC_ERROR;

1100: x_msg_count => x_msg_count,
1101: x_msg_data => x_msg_data);
1102:
1103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107:
1108: -- call event API get_organization_updated for each id.

Line 1116: p_init_msg_list => fnd_api.g_false,

1112: for i in 1..l_obj_root_ids.count loop
1113:
1114: x_person_objs.extend;
1115: get_person_updated(
1116: p_init_msg_list => fnd_api.g_false,
1117: p_event_id => p_event_id,
1118: p_person_id => l_obj_root_ids(i),
1119: x_person_obj => x_person_objs(i),
1120: x_return_status => x_return_status,

Line 1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1120: x_return_status => x_return_status,
1121: x_msg_count => x_msg_count,
1122: x_msg_data => x_msg_data);
1123:
1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126:
1127: END IF;
1128:

Line 1125: RAISE FND_API.G_EXC_ERROR;

1121: x_msg_count => x_msg_count,
1122: x_msg_data => x_msg_data);
1123:
1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126:
1127: END IF;
1128:
1129: end loop;

Line 1151: WHEN fnd_api.g_exc_error THEN

1147:
1148:
1149: EXCEPTION
1150:
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => x_msg_count,

Line 1152: x_return_status := fnd_api.g_ret_sts_error;

1148:
1149: EXCEPTION
1150:
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);

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

1150:
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158: -- Debug info.

Line 1170: WHEN fnd_api.g_exc_unexpected_error THEN

1166: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1167: p_prefix=>l_debug_prefix,
1168: p_msg_level=>fnd_log.level_procedure);
1169: END IF;
1170: WHEN fnd_api.g_exc_unexpected_error THEN
1171: x_return_status := fnd_api.g_ret_sts_unexp_error;
1172:
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1174: p_count => x_msg_count,

Line 1171: x_return_status := fnd_api.g_ret_sts_unexp_error;

1167: p_prefix=>l_debug_prefix,
1168: p_msg_level=>fnd_log.level_procedure);
1169: END IF;
1170: WHEN fnd_api.g_exc_unexpected_error THEN
1171: x_return_status := fnd_api.g_ret_sts_unexp_error;
1172:
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data);

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

1169: END IF;
1170: WHEN fnd_api.g_exc_unexpected_error THEN
1171: x_return_status := fnd_api.g_ret_sts_unexp_error;
1172:
1173: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176:
1177: -- Debug info.

Line 1190: x_return_status := fnd_api.g_ret_sts_unexp_error;

1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;
1189: WHEN OTHERS THEN
1190: x_return_status := fnd_api.g_ret_sts_unexp_error;
1191:
1192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1193: fnd_message.set_token('ERROR' ,SQLERRM);
1194: fnd_msg_pub.add;

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

1192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1193: fnd_message.set_token('ERROR' ,SQLERRM);
1194: fnd_msg_pub.add;
1195:
1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: -- Debug info.

Line 1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

1256: l_child_upd_flag varchar2(1);
1257:
1258: begin
1259: -- initialize API return status to success.
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: -- Solve populate_flag is not in sync in hz_parties and hz_org_profiles.
1263: -- c1 can't return profile entity.
1264:

Line 1610: WHEN fnd_api.g_exc_unexpected_error THEN

1606:
1607: EXCEPTION
1608:
1609:
1610: WHEN fnd_api.g_exc_unexpected_error THEN
1611: x_return_status := fnd_api.g_ret_sts_unexp_error;
1612:
1613:
1614: WHEN OTHERS THEN

Line 1611: x_return_status := fnd_api.g_ret_sts_unexp_error;

1607: EXCEPTION
1608:
1609:
1610: WHEN fnd_api.g_exc_unexpected_error THEN
1611: x_return_status := fnd_api.g_ret_sts_unexp_error;
1612:
1613:
1614: WHEN OTHERS THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1615: x_return_status := fnd_api.g_ret_sts_unexp_error;

1611: x_return_status := fnd_api.g_ret_sts_unexp_error;
1612:
1613:
1614: WHEN OTHERS THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616:
1617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1618: fnd_message.set_token('ERROR' ,SQLERRM);
1619: fnd_msg_pub.add;

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

1635: -- IN:
1636: -- p_init_msg_list Initialize message stack if it is set to
1637: -- p_event_id BES Event identifier.
1638: -- p_person_id Person identifier.
1639: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1640: -- OUT:
1641: -- x_person_objs One or more created logical person.
1642: -- x_return_status Return status after the call. The status can
1643: -- be fnd_api.g_ret_sts_success (success),

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

1639: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1640: -- OUT:
1641: -- x_person_objs One or more created logical person.
1642: -- x_return_status Return status after the call. The status can
1643: -- be fnd_api.g_ret_sts_success (success),
1644: -- fnd_api.g_ret_sts_error (error),
1645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1646: -- x_msg_count Number of messages in message stack.
1647: -- x_msg_data Message text if x_msg_count is 1.

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

1640: -- OUT:
1641: -- x_person_objs One or more created logical person.
1642: -- x_return_status Return status after the call. The status can
1643: -- be fnd_api.g_ret_sts_success (success),
1644: -- fnd_api.g_ret_sts_error (error),
1645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1646: -- x_msg_count Number of messages in message stack.
1647: -- x_msg_data Message text if x_msg_count is 1.
1648: --

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

1641: -- x_person_objs One or more created logical person.
1642: -- x_return_status Return status after the call. The status can
1643: -- be fnd_api.g_ret_sts_success (success),
1644: -- fnd_api.g_ret_sts_error (error),
1645: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1646: -- x_msg_count Number of messages in message stack.
1647: -- x_msg_data Message text if x_msg_count is 1.
1648: --
1649: -- NOTES

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

1657:
1658: -- Get only one person object based on p_person_id and event_id
1659:
1660: PROCEDURE get_person_updated(
1661: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1662: p_event_id IN NUMBER,
1663: p_person_id IN NUMBER,
1664: x_person_obj OUT NOCOPY HZ_PERSON_BO,
1665: x_return_status OUT NOCOPY VARCHAR2,

Line 1676: x_return_status := FND_API.G_RET_STS_SUCCESS;

1672:
1673: begin
1674:
1675: -- initialize API return status to success.
1676: x_return_status := FND_API.G_RET_STS_SUCCESS;
1677:
1678: -- Initialize message list if p_init_msg_list is set to TRUE
1679: IF FND_API.to_Boolean(p_init_msg_list) THEN
1680: FND_MSG_PUB.initialize;

Line 1679: IF FND_API.to_Boolean(p_init_msg_list) THEN

1675: -- initialize API return status to success.
1676: x_return_status := FND_API.G_RET_STS_SUCCESS;
1677:
1678: -- Initialize message list if p_init_msg_list is set to TRUE
1679: IF FND_API.to_Boolean(p_init_msg_list) THEN
1680: FND_MSG_PUB.initialize;
1681: END IF;
1682:
1683:

Line 1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1691: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1692: p_party_id => p_person_id,
1693: x_return_status => x_return_status);
1694:
1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1696: RAISE FND_API.G_EXC_ERROR;
1697: END IF;
1698: */
1699:

Line 1696: RAISE FND_API.G_EXC_ERROR;

1692: p_party_id => p_person_id,
1693: x_return_status => x_return_status);
1694:
1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1696: RAISE FND_API.G_EXC_ERROR;
1697: END IF;
1698: */
1699:
1700: -- Set action type to 'UNCHANGED' by default

Line 1703: p_init_msg_list => fnd_api.g_false,

1699:
1700: -- Set action type to 'UNCHANGED' by default
1701:
1702: get_person_bo(
1703: p_init_msg_list => fnd_api.g_false,
1704: p_person_id => p_person_id,
1705: p_action_type => 'UNCHANGED',
1706: x_person_obj => x_person_obj,
1707: x_return_status => x_return_status,

Line 1711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1707: x_return_status => x_return_status,
1708: x_msg_count => x_msg_count,
1709: x_msg_data => x_msg_data);
1710:
1711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: RAISE FND_API.G_EXC_ERROR;
1713: END IF;
1714:
1715: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

Line 1712: RAISE FND_API.G_EXC_ERROR;

1708: x_msg_count => x_msg_count,
1709: x_msg_data => x_msg_data);
1710:
1711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: RAISE FND_API.G_EXC_ERROR;
1713: END IF;
1714:
1715: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'
1716:

Line 1724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1720: p_root_id => p_person_id,
1721: px_person_obj => l_person_obj,
1722: x_return_status => x_return_status
1723: );
1724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1725: RAISE FND_API.G_EXC_ERROR;
1726: END IF;
1727:
1728: x_person_obj := l_person_obj;

Line 1725: RAISE FND_API.G_EXC_ERROR;

1721: px_person_obj => l_person_obj,
1722: x_return_status => x_return_status
1723: );
1724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1725: RAISE FND_API.G_EXC_ERROR;
1726: END IF;
1727:
1728: x_person_obj := l_person_obj;
1729:

Line 1749: WHEN fnd_api.g_exc_error THEN

1745:
1746:
1747: EXCEPTION
1748:
1749: WHEN fnd_api.g_exc_error THEN
1750: x_return_status := fnd_api.g_ret_sts_error;
1751:
1752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1753: p_count => x_msg_count,

Line 1750: x_return_status := fnd_api.g_ret_sts_error;

1746:
1747: EXCEPTION
1748:
1749: WHEN fnd_api.g_exc_error THEN
1750: x_return_status := fnd_api.g_ret_sts_error;
1751:
1752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1753: p_count => x_msg_count,
1754: p_data => x_msg_data);

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

1748:
1749: WHEN fnd_api.g_exc_error THEN
1750: x_return_status := fnd_api.g_ret_sts_error;
1751:
1752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1753: p_count => x_msg_count,
1754: p_data => x_msg_data);
1755:
1756: -- Debug info.

Line 1768: WHEN fnd_api.g_exc_unexpected_error THEN

1764: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1765: p_prefix=>l_debug_prefix,
1766: p_msg_level=>fnd_log.level_procedure);
1767: END IF;
1768: WHEN fnd_api.g_exc_unexpected_error THEN
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1772: p_count => x_msg_count,

Line 1769: x_return_status := fnd_api.g_ret_sts_unexp_error;

1765: p_prefix=>l_debug_prefix,
1766: p_msg_level=>fnd_log.level_procedure);
1767: END IF;
1768: WHEN fnd_api.g_exc_unexpected_error THEN
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1772: p_count => x_msg_count,
1773: p_data => x_msg_data);

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

1767: END IF;
1768: WHEN fnd_api.g_exc_unexpected_error THEN
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:
1771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1772: p_count => x_msg_count,
1773: p_data => x_msg_data);
1774:
1775: -- Debug info.

Line 1788: x_return_status := fnd_api.g_ret_sts_unexp_error;

1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;
1787: WHEN OTHERS THEN
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789:
1790: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1791: fnd_message.set_token('ERROR' ,SQLERRM);
1792: fnd_msg_pub.add;

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

1790: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1791: fnd_message.set_token('ERROR' ,SQLERRM);
1792: fnd_msg_pub.add;
1793:
1794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798: -- Debug info.