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_ACCT_SITE_BO_PVT dependencies on FND_API

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

11: */
12:
13: -- Private local procedure
14: PROCEDURE get_site_use_profile_bo(
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_site_use_id IN NUMBER,
17: p_action_type IN VARCHAR2 := NULL,
18: x_cust_profile_obj OUT NOCOPY HZ_CUSTOMER_PROFILE_BO,
19: x_return_status OUT NOCOPY VARCHAR2,

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: BEGIN
238:
239:
240: -- initialize API return status to success.
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE
244: IF FND_API.to_Boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;

Line 244: IF FND_API.to_Boolean(p_init_msg_list) THEN

240: -- initialize API return status to success.
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE
244: IF FND_API.to_Boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248:

Line 278: WHEN fnd_api.g_exc_error THEN

274:
275:
276: EXCEPTION
277:
278: WHEN fnd_api.g_exc_error THEN
279: x_return_status := fnd_api.g_ret_sts_error;
280:
281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
282: p_count => x_msg_count,

Line 279: x_return_status := fnd_api.g_ret_sts_error;

275:
276: EXCEPTION
277:
278: WHEN fnd_api.g_exc_error THEN
279: x_return_status := fnd_api.g_ret_sts_error;
280:
281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data);

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

277:
278: WHEN fnd_api.g_exc_error THEN
279: x_return_status := fnd_api.g_ret_sts_error;
280:
281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data);
284:
285: -- Debug info.

Line 297: WHEN fnd_api.g_exc_unexpected_error THEN

293: hz_utility_v2pub.debug(p_message=>'get_site_use_profile_bo (-)',
294: p_prefix=>l_debug_prefix,
295: p_msg_level=>fnd_log.level_procedure);
296: END IF;
297: WHEN fnd_api.g_exc_unexpected_error THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
301: p_count => x_msg_count,

Line 298: x_return_status := fnd_api.g_ret_sts_unexp_error;

294: p_prefix=>l_debug_prefix,
295: p_msg_level=>fnd_log.level_procedure);
296: END IF;
297: WHEN fnd_api.g_exc_unexpected_error THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
301: p_count => x_msg_count,
302: p_data => x_msg_data);

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

296: END IF;
297: WHEN fnd_api.g_exc_unexpected_error THEN
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
301: p_count => x_msg_count,
302: p_data => x_msg_data);
303:
304: -- Debug info.

Line 317: x_return_status := fnd_api.g_ret_sts_unexp_error;

313: p_prefix=>l_debug_prefix,
314: p_msg_level=>fnd_log.level_procedure);
315: END IF;
316: WHEN OTHERS THEN
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318:
319: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
320: fnd_message.set_token('ERROR' ,SQLERRM);
321: fnd_msg_pub.add;

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

319: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
320: fnd_message.set_token('ERROR' ,SQLERRM);
321: fnd_msg_pub.add;
322:
323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
324: p_count => x_msg_count,
325: p_data => x_msg_data);
326:
327: -- Debug info.

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

343:
344:
345: -- Private procedure
346: PROCEDURE get_cust_site_use_bos(
347: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
348: p_cust_acct_site_id IN NUMBER,
349: p_action_type IN VARCHAR2 := NULL,
350: x_cust_site_use_objs OUT NOCOPY HZ_CUST_SITE_USE_BO_TBL,
351: x_return_status OUT NOCOPY VARCHAR2,

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571: BEGIN
572:
573:
574: -- initialize API return status to success.
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE
578: IF FND_API.to_Boolean(p_init_msg_list) THEN
579: FND_MSG_PUB.initialize;

Line 578: IF FND_API.to_Boolean(p_init_msg_list) THEN

574: -- initialize API return status to success.
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE
578: IF FND_API.to_Boolean(p_init_msg_list) THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582:

Line 597: p_init_msg_list => fnd_api.g_false,

593: close c1;
594:
595: for i in 1..x_cust_site_use_objs.count loop
596: get_site_use_profile_bo(
597: p_init_msg_list => fnd_api.g_false,
598: p_site_use_id => x_cust_site_use_objs(i).site_use_id,
599: p_action_type => p_action_type,
600: x_cust_profile_obj => x_cust_site_use_objs(i).site_use_profile_obj,
601: x_return_status => x_return_status,

Line 605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

601: x_return_status => x_return_status,
602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data);
604:
605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
606: RAISE FND_API.G_EXC_ERROR;
607: END IF;
608: end loop;
609:

Line 606: RAISE FND_API.G_EXC_ERROR;

602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data);
604:
605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
606: RAISE FND_API.G_EXC_ERROR;
607: END IF;
608: end loop;
609:
610: -- Debug info.

Line 628: WHEN fnd_api.g_exc_error THEN

624:
625:
626: EXCEPTION
627:
628: WHEN fnd_api.g_exc_error THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630:
631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
632: p_count => x_msg_count,

Line 629: x_return_status := fnd_api.g_ret_sts_error;

625:
626: EXCEPTION
627:
628: WHEN fnd_api.g_exc_error THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630:
631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
632: p_count => x_msg_count,
633: p_data => x_msg_data);

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

627:
628: WHEN fnd_api.g_exc_error THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630:
631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
632: p_count => x_msg_count,
633: p_data => x_msg_data);
634:
635: -- Debug info.

Line 647: WHEN fnd_api.g_exc_unexpected_error THEN

643: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_bos (-)',
644: p_prefix=>l_debug_prefix,
645: p_msg_level=>fnd_log.level_procedure);
646: END IF;
647: WHEN fnd_api.g_exc_unexpected_error THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,

Line 648: x_return_status := fnd_api.g_ret_sts_unexp_error;

644: p_prefix=>l_debug_prefix,
645: p_msg_level=>fnd_log.level_procedure);
646: END IF;
647: WHEN fnd_api.g_exc_unexpected_error THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);

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

646: END IF;
647: WHEN fnd_api.g_exc_unexpected_error THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.

Line 667: x_return_status := fnd_api.g_ret_sts_unexp_error;

663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666: WHEN OTHERS THEN
667: x_return_status := fnd_api.g_ret_sts_unexp_error;
668:
669: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
670: fnd_message.set_token('ERROR' ,SQLERRM);
671: fnd_msg_pub.add;

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

669: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
670: fnd_message.set_token('ERROR' ,SQLERRM);
671: fnd_msg_pub.add;
672:
673: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:
677: -- Debug info.

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

705: -- IN:
706: -- p_init_msg_list Initialize message stack if it is set to
707: -- p_parent_id parent id.
708: -- p_cust_acct_site_id customer account site ID.
709: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
710: -- OUT:
711: -- x_cust_acct_site_objs Logical customer account site records.
712: -- x_return_status Return status after the call. The status can
713: -- be fnd_api.g_ret_sts_success (success),

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

709: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
710: -- OUT:
711: -- x_cust_acct_site_objs Logical customer account site records.
712: -- x_return_status Return status after the call. The status can
713: -- be fnd_api.g_ret_sts_success (success),
714: -- fnd_api.g_ret_sts_error (error),
715: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
716: -- x_msg_count Number of messages in message stack.
717: -- x_msg_data Message text if x_msg_count is 1.

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

710: -- OUT:
711: -- x_cust_acct_site_objs Logical customer account site records.
712: -- x_return_status Return status after the call. The status can
713: -- be fnd_api.g_ret_sts_success (success),
714: -- fnd_api.g_ret_sts_error (error),
715: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
716: -- x_msg_count Number of messages in message stack.
717: -- x_msg_data Message text if x_msg_count is 1.
718: --

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

711: -- x_cust_acct_site_objs Logical customer account site records.
712: -- x_return_status Return status after the call. The status can
713: -- be fnd_api.g_ret_sts_success (success),
714: -- fnd_api.g_ret_sts_error (error),
715: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
716: -- x_msg_count Number of messages in message stack.
717: -- x_msg_data Message text if x_msg_count is 1.
718: --
719: -- NOTES

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

756:
757:
758:
759: PROCEDURE get_cust_acct_site_bos(
760: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
761: p_parent_id IN NUMBER,
762: p_cust_acct_site_id IN NUMBER,
763: p_action_type IN VARCHAR2 := NULL,
764: x_cust_acct_site_objs OUT NOCOPY HZ_CUST_ACCT_SITE_BO_TBL,

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942: BEGIN
943:
944:
945: -- initialize API return status to success.
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947:
948: -- Initialize message list if p_init_msg_list is set to TRUE
949: IF FND_API.to_Boolean(p_init_msg_list) THEN
950: FND_MSG_PUB.initialize;

Line 949: IF FND_API.to_Boolean(p_init_msg_list) THEN

945: -- initialize API return status to success.
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947:
948: -- Initialize message list if p_init_msg_list is set to TRUE
949: IF FND_API.to_Boolean(p_init_msg_list) THEN
950: FND_MSG_PUB.initialize;
951: END IF;
952:
953:

Line 968: p_init_msg_list => fnd_api.g_false,

964: close c1;
965:
966: for i in 1..x_cust_acct_site_objs.count loop
967: get_cust_site_use_bos(
968: p_init_msg_list => fnd_api.g_false,
969: p_cust_acct_site_id => x_cust_acct_site_objs(i).cust_acct_site_id,
970: p_action_type => p_action_type,
971: x_cust_site_use_objs =>x_cust_acct_site_objs(i).CUST_ACCT_SITE_USE_OBJS,
972: x_return_status => x_return_status,

Line 976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

972: x_return_status => x_return_status,
973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data);
975:
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979:
980: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(

Line 977: RAISE FND_API.G_EXC_ERROR;

973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data);
975:
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979:
980: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
981: p_init_msg_list => fnd_api.g_false,

Line 981: p_init_msg_list => fnd_api.g_false,

977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979:
980: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
981: p_init_msg_list => fnd_api.g_false,
982: p_parent_id => x_cust_acct_site_objs(i).cust_acct_site_id,
983: p_cust_acct_contact_id => null,
984: p_action_type => p_action_type,
985: x_cust_acct_contact_objs =>x_cust_acct_site_objs(i).CUST_ACCT_CONTACT_OBJS,

Line 990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

986: x_return_status => x_return_status,
987: x_msg_count => x_msg_count,
988: x_msg_data => x_msg_data);
989:
990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: /*

Line 991: RAISE FND_API.G_EXC_ERROR;

987: x_msg_count => x_msg_count,
988: x_msg_data => x_msg_data);
989:
990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: /*
995: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos

Line 996: (p_init_msg_list => fnd_api.g_false,

992: END IF;
993:
994: /*
995: HZ_EXTRACT_PARTY_SITE_BO_PVT.get_party_site_bos
996: (p_init_msg_list => fnd_api.g_false,
997: p_party_id => NULL,
998: p_party_site_id => x_cust_acct_site_objs(i).party_site_id,
999: p_action_type => p_action_type,
1000: x_party_site_objs =>l_party_site_objs,

Line 1027: WHEN fnd_api.g_exc_error THEN

1023:
1024:
1025: EXCEPTION
1026:
1027: WHEN fnd_api.g_exc_error THEN
1028: x_return_status := fnd_api.g_ret_sts_error;
1029:
1030: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1031: p_count => x_msg_count,

Line 1028: x_return_status := fnd_api.g_ret_sts_error;

1024:
1025: EXCEPTION
1026:
1027: WHEN fnd_api.g_exc_error THEN
1028: x_return_status := fnd_api.g_ret_sts_error;
1029:
1030: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1031: p_count => x_msg_count,
1032: p_data => x_msg_data);

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

1026:
1027: WHEN fnd_api.g_exc_error THEN
1028: x_return_status := fnd_api.g_ret_sts_error;
1029:
1030: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1031: p_count => x_msg_count,
1032: p_data => x_msg_data);
1033:
1034: -- Debug info.

Line 1046: WHEN fnd_api.g_exc_unexpected_error THEN

1042: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_bos (-)',
1043: p_prefix=>l_debug_prefix,
1044: p_msg_level=>fnd_log.level_procedure);
1045: END IF;
1046: WHEN fnd_api.g_exc_unexpected_error THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:
1049: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1050: p_count => x_msg_count,

Line 1047: x_return_status := fnd_api.g_ret_sts_unexp_error;

1043: p_prefix=>l_debug_prefix,
1044: p_msg_level=>fnd_log.level_procedure);
1045: END IF;
1046: WHEN fnd_api.g_exc_unexpected_error THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:
1049: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data);

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

1045: END IF;
1046: WHEN fnd_api.g_exc_unexpected_error THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:
1049: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data);
1052:
1053: -- Debug info.

Line 1066: x_return_status := fnd_api.g_ret_sts_unexp_error;

1062: p_prefix=>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_procedure);
1064: END IF;
1065: WHEN OTHERS THEN
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067:
1068: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1069: fnd_message.set_token('ERROR' ,SQLERRM);
1070: fnd_msg_pub.add;

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

1068: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1069: fnd_message.set_token('ERROR' ,SQLERRM);
1070: fnd_msg_pub.add;
1071:
1072: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1073: p_count => x_msg_count,
1074: p_data => x_msg_data);
1075:
1076: -- Debug info.

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

1089: end;
1090:
1091: -- Private procedure
1092: PROCEDURE get_cust_site_use_v2_bos(
1093: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1094: p_cust_acct_site_id IN NUMBER,
1095: p_action_type IN VARCHAR2 := NULL,
1096: x_cust_site_use_v2_objs OUT NOCOPY HZ_CUST_SITE_USE_V2_BO_TBL,
1097: x_return_status OUT NOCOPY VARCHAR2,

Line 1321: x_return_status := FND_API.G_RET_STS_SUCCESS;

1317: BEGIN
1318:
1319:
1320: -- initialize API return status to success.
1321: x_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: -- Initialize message list if p_init_msg_list is set to TRUE
1324: IF FND_API.to_Boolean(p_init_msg_list) THEN
1325: FND_MSG_PUB.initialize;

Line 1324: IF FND_API.to_Boolean(p_init_msg_list) THEN

1320: -- initialize API return status to success.
1321: x_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: -- Initialize message list if p_init_msg_list is set to TRUE
1324: IF FND_API.to_Boolean(p_init_msg_list) THEN
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:
1328:

Line 1343: p_init_msg_list => fnd_api.g_false,

1339: close c1;
1340:
1341: for i in 1..x_cust_site_use_v2_objs.count loop
1342: get_site_use_profile_bo(
1343: p_init_msg_list => fnd_api.g_false,
1344: p_site_use_id => x_cust_site_use_v2_objs(i).site_use_id,
1345: p_action_type => p_action_type,
1346: x_cust_profile_obj => x_cust_site_use_v2_objs(i).site_use_profile_obj,
1347: x_return_status => x_return_status,

Line 1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1347: x_return_status => x_return_status,
1348: x_msg_count => x_msg_count,
1349: x_msg_data => x_msg_data);
1350:
1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354: end loop;
1355:

Line 1352: RAISE FND_API.G_EXC_ERROR;

1348: x_msg_count => x_msg_count,
1349: x_msg_data => x_msg_data);
1350:
1351: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354: end loop;
1355:
1356: -- Debug info.

Line 1374: WHEN fnd_api.g_exc_error THEN

1370:
1371:
1372: EXCEPTION
1373:
1374: WHEN fnd_api.g_exc_error THEN
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1377: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1378: p_count => x_msg_count,

Line 1375: x_return_status := fnd_api.g_ret_sts_error;

1371:
1372: EXCEPTION
1373:
1374: WHEN fnd_api.g_exc_error THEN
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1377: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);

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

1373:
1374: WHEN fnd_api.g_exc_error THEN
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1377: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380:
1381: -- Debug info.

Line 1393: WHEN fnd_api.g_exc_unexpected_error THEN

1389: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_v2_bos (-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:
1396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1397: p_count => x_msg_count,

Line 1394: x_return_status := fnd_api.g_ret_sts_unexp_error;

1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:
1396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data);

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

1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: x_return_status := fnd_api.g_ret_sts_unexp_error;
1395:
1396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:
1400: -- Debug info.

Line 1413: x_return_status := fnd_api.g_ret_sts_unexp_error;

1409: p_prefix=>l_debug_prefix,
1410: p_msg_level=>fnd_log.level_procedure);
1411: END IF;
1412: WHEN OTHERS THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414:
1415: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1416: fnd_message.set_token('ERROR' ,SQLERRM);
1417: fnd_msg_pub.add;

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

1415: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1416: fnd_message.set_token('ERROR' ,SQLERRM);
1417: fnd_msg_pub.add;
1418:
1419: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1420: p_count => x_msg_count,
1421: p_data => x_msg_data);
1422:
1423: -- Debug info.

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

1451: -- IN:
1452: -- p_init_msg_list Initialize message stack if it is set to
1453: -- p_parent_id parent id.
1454: -- p_cust_acct_site_id customer account site ID.
1455: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1456: -- OUT:
1457: -- x_cust_acct_site_v2_objs Logical customer account site records.
1458: -- x_return_status Return status after the call. The status can
1459: -- be fnd_api.g_ret_sts_success (success),

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

1455: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1456: -- OUT:
1457: -- x_cust_acct_site_v2_objs Logical customer account site records.
1458: -- x_return_status Return status after the call. The status can
1459: -- be fnd_api.g_ret_sts_success (success),
1460: -- fnd_api.g_ret_sts_error (error),
1461: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1462: -- x_msg_count Number of messages in message stack.
1463: -- x_msg_data Message text if x_msg_count is 1.

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

1456: -- OUT:
1457: -- x_cust_acct_site_v2_objs Logical customer account site records.
1458: -- x_return_status Return status after the call. The status can
1459: -- be fnd_api.g_ret_sts_success (success),
1460: -- fnd_api.g_ret_sts_error (error),
1461: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1462: -- x_msg_count Number of messages in message stack.
1463: -- x_msg_data Message text if x_msg_count is 1.
1464: --

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

1457: -- x_cust_acct_site_v2_objs Logical customer account site records.
1458: -- x_return_status Return status after the call. The status can
1459: -- be fnd_api.g_ret_sts_success (success),
1460: -- fnd_api.g_ret_sts_error (error),
1461: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1462: -- x_msg_count Number of messages in message stack.
1463: -- x_msg_data Message text if x_msg_count is 1.
1464: --
1465: -- NOTES

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

1502:
1503:
1504:
1505: PROCEDURE get_cust_acct_site_v2_bos(
1506: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1507: p_parent_id IN NUMBER,
1508: p_cust_acct_site_id IN NUMBER,
1509: p_action_type IN VARCHAR2 := NULL,
1510: x_cust_acct_site_v2_objs OUT NOCOPY HZ_CUST_ACCT_SITE_V2_BO_TBL,

Line 1692: x_return_status := FND_API.G_RET_STS_SUCCESS;

1688: BEGIN
1689:
1690:
1691: -- initialize API return status to success.
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694: -- Initialize message list if p_init_msg_list is set to TRUE
1695: IF FND_API.to_Boolean(p_init_msg_list) THEN
1696: FND_MSG_PUB.initialize;

Line 1695: IF FND_API.to_Boolean(p_init_msg_list) THEN

1691: -- initialize API return status to success.
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694: -- Initialize message list if p_init_msg_list is set to TRUE
1695: IF FND_API.to_Boolean(p_init_msg_list) THEN
1696: FND_MSG_PUB.initialize;
1697: END IF;
1698:
1699:

Line 1714: p_init_msg_list => fnd_api.g_false,

1710: close c1;
1711:
1712: for i in 1..x_cust_acct_site_v2_objs.count loop
1713: get_cust_site_use_v2_bos(
1714: p_init_msg_list => fnd_api.g_false,
1715: p_cust_acct_site_id => x_cust_acct_site_v2_objs(i).cust_acct_site_id,
1716: p_action_type => p_action_type,
1717: x_cust_site_use_v2_objs =>x_cust_acct_site_v2_objs(i).CUST_ACCT_SITE_USE_OBJS,
1718: x_return_status => x_return_status,

Line 1722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1718: x_return_status => x_return_status,
1719: x_msg_count => x_msg_count,
1720: x_msg_data => x_msg_data);
1721:
1722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725:
1726: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(

Line 1723: RAISE FND_API.G_EXC_ERROR;

1719: x_msg_count => x_msg_count,
1720: x_msg_data => x_msg_data);
1721:
1722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725:
1726: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
1727: p_init_msg_list => fnd_api.g_false,

Line 1727: p_init_msg_list => fnd_api.g_false,

1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725:
1726: HZ_EXTRACT_ACCT_CONT_BO_PVT.get_cust_acct_contact_bos(
1727: p_init_msg_list => fnd_api.g_false,
1728: p_parent_id => x_cust_acct_site_v2_objs(i).cust_acct_site_id,
1729: p_cust_acct_contact_id => null,
1730: p_action_type => p_action_type,
1731: x_cust_acct_contact_objs =>x_cust_acct_site_v2_objs(i).CUST_ACCT_CONTACT_OBJS,

Line 1736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1732: x_return_status => x_return_status,
1733: x_msg_count => x_msg_count,
1734: x_msg_data => x_msg_data);
1735:
1736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;
1739:
1740:

Line 1737: RAISE FND_API.G_EXC_ERROR;

1733: x_msg_count => x_msg_count,
1734: x_msg_data => x_msg_data);
1735:
1736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;
1739:
1740:
1741: end loop;

Line 1761: WHEN fnd_api.g_exc_error THEN

1757:
1758:
1759: EXCEPTION
1760:
1761: WHEN fnd_api.g_exc_error THEN
1762: x_return_status := fnd_api.g_ret_sts_error;
1763:
1764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1765: p_count => x_msg_count,

Line 1762: x_return_status := fnd_api.g_ret_sts_error;

1758:
1759: EXCEPTION
1760:
1761: WHEN fnd_api.g_exc_error THEN
1762: x_return_status := fnd_api.g_ret_sts_error;
1763:
1764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data);

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

1760:
1761: WHEN fnd_api.g_exc_error THEN
1762: x_return_status := fnd_api.g_ret_sts_error;
1763:
1764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data);
1767:
1768: -- Debug info.

Line 1780: WHEN fnd_api.g_exc_unexpected_error THEN

1776: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_v2_bos (-)',
1777: p_prefix=>l_debug_prefix,
1778: p_msg_level=>fnd_log.level_procedure);
1779: END IF;
1780: WHEN fnd_api.g_exc_unexpected_error THEN
1781: x_return_status := fnd_api.g_ret_sts_unexp_error;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1784: p_count => x_msg_count,

Line 1781: x_return_status := fnd_api.g_ret_sts_unexp_error;

1777: p_prefix=>l_debug_prefix,
1778: p_msg_level=>fnd_log.level_procedure);
1779: END IF;
1780: WHEN fnd_api.g_exc_unexpected_error THEN
1781: x_return_status := fnd_api.g_ret_sts_unexp_error;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data);

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

1779: END IF;
1780: WHEN fnd_api.g_exc_unexpected_error THEN
1781: x_return_status := fnd_api.g_ret_sts_unexp_error;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: -- Debug info.

Line 1800: x_return_status := fnd_api.g_ret_sts_unexp_error;

1796: p_prefix=>l_debug_prefix,
1797: p_msg_level=>fnd_log.level_procedure);
1798: END IF;
1799: WHEN OTHERS THEN
1800: x_return_status := fnd_api.g_ret_sts_unexp_error;
1801:
1802: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1803: fnd_message.set_token('ERROR' ,SQLERRM);
1804: fnd_msg_pub.add;

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

1802: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1803: fnd_message.set_token('ERROR' ,SQLERRM);
1804: fnd_msg_pub.add;
1805:
1806: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1807: p_count => x_msg_count,
1808: p_data => x_msg_data);
1809:
1810: -- Debug info.