112: px_party_site_rec.addressee := p_party_site_obj.addressee;
113: IF(p_create_or_update = 'C') THEN
114: px_party_site_rec.orig_system := p_ps_os;
115: px_party_site_rec.orig_system_reference := p_ps_osr;
116: px_party_site_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
117: END IF;
118: px_party_site_rec.global_location_number := p_party_site_obj.global_location_number;
119: END assign_party_site_rec;
120:
165: FND_MSG_PUB.initialize;
166: END IF;
167:
168: -- initialize Global variable
169: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
170: IF(p_created_by_module IS NULL) THEN
171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
172: ELSE
173: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
167:
168: -- initialize Global variable
169: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
170: IF(p_created_by_module IS NULL) THEN
171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
172: ELSE
173: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
174: END IF;
175:
169: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
170: IF(p_created_by_module IS NULL) THEN
171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
172: ELSE
173: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
174: END IF;
175:
176: -- Debug info.
177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
174: END IF;
175:
176: -- Debug info.
177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
178: hz_utility_v2pub.debug(p_message=>'do_create_party_site_bo(+)',
179: p_prefix=>l_debug_prefix,
180: p_msg_level=>fnd_log.level_procedure);
181: END IF;
182:
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: END IF;
353:
354: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
355:
356: ----------------------------------------------------------
357: -- For contact points - phone, telex, email and web
358: ----------------------------------------------------------
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: END IF;
386:
387: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
388:
389: ----------------------------
390: -- For contact preference
391: ----------------------------
405: END IF;
406: END IF;
407:
408: -- reset Global variable
409: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
410: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
411:
412: -- Debug info.
413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
406: END IF;
407:
408: -- reset Global variable
409: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
410: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
411:
412: -- Debug info.
413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
410: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
411:
412: -- Debug info.
413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
415: p_msg_data=>x_msg_data,
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);
418: END IF;
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);
418: END IF;
419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
420: hz_utility_v2pub.debug(p_message=>'do_create_party_site_bo(-)',
421: p_prefix=>l_debug_prefix,
422: p_msg_level=>fnd_log.level_procedure);
423: END IF;
424:
426: WHEN fnd_api.g_exc_error THEN
427: ROLLBACK TO do_create_party_site_bo_pub;
428:
429: -- reset Global variable
430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
431: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
432:
433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
434: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
427: ROLLBACK TO do_create_party_site_bo_pub;
428:
429: -- reset Global variable
430: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
431: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
432:
433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
434: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
435: FND_MSG_PUB.ADD;
441: p_data => x_msg_data);
442:
443: -- Debug info.
444: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
446: p_msg_data=>x_msg_data,
447: p_msg_type=>'ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;
447: p_msg_type=>'ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;
450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'do_create_party_site_bo(-)',
452: p_prefix=>l_debug_prefix,
453: p_msg_level=>fnd_log.level_procedure);
454: END IF;
455:
456: WHEN fnd_api.g_exc_unexpected_error THEN
457: ROLLBACK TO do_create_party_site_bo_pub;
458:
459: -- reset Global variable
460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
461: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
462:
463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
464: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
457: ROLLBACK TO do_create_party_site_bo_pub;
458:
459: -- reset Global variable
460: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
461: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
462:
463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
464: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
465: FND_MSG_PUB.ADD;
471: p_data => x_msg_data);
472:
473: -- Debug info.
474: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
475: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
476: p_msg_data=>x_msg_data,
477: p_msg_type=>'UNEXPECTED ERROR',
478: p_msg_level=>fnd_log.level_error);
479: END IF;
477: p_msg_type=>'UNEXPECTED ERROR',
478: p_msg_level=>fnd_log.level_error);
479: END IF;
480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
481: hz_utility_v2pub.debug(p_message=>'do_create_party_site_bo(-)',
482: p_prefix=>l_debug_prefix,
483: p_msg_level=>fnd_log.level_procedure);
484: END IF;
485:
486: WHEN OTHERS THEN
487: ROLLBACK TO do_create_party_site_bo_pub;
488:
489: -- reset Global variable
490: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
491: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
492:
493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
494: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
487: ROLLBACK TO do_create_party_site_bo_pub;
488:
489: -- reset Global variable
490: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
491: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
492:
493: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
494: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
495: FND_MSG_PUB.ADD;
505: p_data => x_msg_data);
506:
507: -- Debug info.
508: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
509: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
510: p_msg_data=>x_msg_data,
511: p_msg_type=>'SQL ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
511: p_msg_type=>'SQL ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
515: hz_utility_v2pub.debug(p_message=>'do_create_party_site_bo(-)',
516: p_prefix=>l_debug_prefix,
517: p_msg_level=>fnd_log.level_procedure);
518: END IF;
519: END do_create_party_site_bo;
754: FND_MSG_PUB.initialize;
755: END IF;
756:
757: -- initialize Global variable
758: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
759: IF(p_created_by_module IS NULL) THEN
760: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
761: ELSE
762: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
756:
757: -- initialize Global variable
758: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
759: IF(p_created_by_module IS NULL) THEN
760: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
761: ELSE
762: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
763: END IF;
764:
758: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
759: IF(p_created_by_module IS NULL) THEN
760: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
761: ELSE
762: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
763: END IF;
764:
765: -- Debug info.
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
763: END IF;
764:
765: -- Debug info.
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(+)',
768: p_prefix=>l_debug_prefix,
769: p_msg_level=>fnd_log.level_procedure);
770: END IF;
771:
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: END IF;
918:
919: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
920:
921: ---------------------
922: -- For Contact Points
923: ---------------------
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951:
952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
953:
954: -------------------------
955: -- For Contact Preference
956: -------------------------
970: END IF;
971: END IF;
972:
973: -- reset Global variable
974: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
975: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
976:
977: -- Debug info.
978: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
971: END IF;
972:
973: -- reset Global variable
974: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
975: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
976:
977: -- Debug info.
978: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
979: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
975: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
976:
977: -- Debug info.
978: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
979: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
980: p_msg_data=>x_msg_data,
981: p_msg_type=>'WARNING',
982: p_msg_level=>fnd_log.level_exception);
983: END IF;
981: p_msg_type=>'WARNING',
982: p_msg_level=>fnd_log.level_exception);
983: END IF;
984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
985: hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
986: p_prefix=>l_debug_prefix,
987: p_msg_level=>fnd_log.level_procedure);
988: END IF;
989:
991: WHEN fnd_api.g_exc_error THEN
992: ROLLBACK TO do_update_party_site_bo_pub;
993:
994: -- reset Global variable
995: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
996: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
997:
998: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
999: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
992: ROLLBACK TO do_update_party_site_bo_pub;
993:
994: -- reset Global variable
995: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
996: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
997:
998: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
999: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1000: FND_MSG_PUB.ADD;
1006: p_data => x_msg_data);
1007:
1008: -- Debug info.
1009: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1010: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1011: p_msg_data=>x_msg_data,
1012: p_msg_type=>'ERROR',
1013: p_msg_level=>fnd_log.level_error);
1014: END IF;
1012: p_msg_type=>'ERROR',
1013: p_msg_level=>fnd_log.level_error);
1014: END IF;
1015: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1016: hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
1017: p_prefix=>l_debug_prefix,
1018: p_msg_level=>fnd_log.level_procedure);
1019: END IF;
1020:
1021: WHEN fnd_api.g_exc_unexpected_error THEN
1022: ROLLBACK TO do_update_party_site_bo_pub;
1023:
1024: -- reset Global variable
1025: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1026: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1027:
1028: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1029: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1022: ROLLBACK TO do_update_party_site_bo_pub;
1023:
1024: -- reset Global variable
1025: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1026: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1027:
1028: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1029: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1030: FND_MSG_PUB.ADD;
1036: p_data => x_msg_data);
1037:
1038: -- Debug info.
1039: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1040: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1041: p_msg_data=>x_msg_data,
1042: p_msg_type=>'UNEXPECTED ERROR',
1043: p_msg_level=>fnd_log.level_error);
1044: END IF;
1042: p_msg_type=>'UNEXPECTED ERROR',
1043: p_msg_level=>fnd_log.level_error);
1044: END IF;
1045: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1046: hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
1047: p_prefix=>l_debug_prefix,
1048: p_msg_level=>fnd_log.level_procedure);
1049: END IF;
1050:
1051: WHEN OTHERS THEN
1052: ROLLBACK TO do_update_party_site_bo_pub;
1053:
1054: -- reset Global variable
1055: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1056: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1057:
1058: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1059: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1052: ROLLBACK TO do_update_party_site_bo_pub;
1053:
1054: -- reset Global variable
1055: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1056: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1057:
1058: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1059: FND_MESSAGE.SET_TOKEN('OBJECT', 'PARTY_SITE');
1060: FND_MSG_PUB.ADD;
1070: p_data => x_msg_data);
1071:
1072: -- Debug info.
1073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1075: p_msg_data=>x_msg_data,
1076: p_msg_type=>'SQL ERROR',
1077: p_msg_level=>fnd_log.level_error);
1078: END IF;
1076: p_msg_type=>'SQL ERROR',
1077: p_msg_level=>fnd_log.level_error);
1078: END IF;
1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'do_update_party_site_bo(-)',
1081: p_prefix=>l_debug_prefix,
1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;
1084: END do_update_party_site_bo;
1119: END IF;
1120:
1121: -- Debug info.
1122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug(p_message=>'do_save_party_site_bo(+)',
1124: p_prefix=>l_debug_prefix,
1125: p_msg_level=>fnd_log.level_procedure);
1126: END IF;
1127:
1182: END IF;
1183:
1184: -- Debug info.
1185: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1187: p_msg_data=>x_msg_data,
1188: p_msg_type=>'WARNING',
1189: p_msg_level=>fnd_log.level_exception);
1190: END IF;
1188: p_msg_type=>'WARNING',
1189: p_msg_level=>fnd_log.level_exception);
1190: END IF;
1191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1192: hz_utility_v2pub.debug(p_message=>'do_save_party_site_bo(-)',
1193: p_prefix=>l_debug_prefix,
1194: p_msg_level=>fnd_log.level_procedure);
1195: END IF;
1196:
1203: p_data => x_msg_data);
1204:
1205: -- Debug info.
1206: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1207: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1208: p_msg_data=>x_msg_data,
1209: p_msg_type=>'ERROR',
1210: p_msg_level=>fnd_log.level_error);
1211: END IF;
1209: p_msg_type=>'ERROR',
1210: p_msg_level=>fnd_log.level_error);
1211: END IF;
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'do_save_party_site_bo(-)',
1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:
1223: p_data => x_msg_data);
1224:
1225: -- Debug info.
1226: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1227: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1228: p_msg_data=>x_msg_data,
1229: p_msg_type=>'UNEXPECTED ERROR',
1230: p_msg_level=>fnd_log.level_error);
1231: END IF;
1229: p_msg_type=>'UNEXPECTED ERROR',
1230: p_msg_level=>fnd_log.level_error);
1231: END IF;
1232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1233: hz_utility_v2pub.debug(p_message=>'do_save_party_site_bo(-)',
1234: p_prefix=>l_debug_prefix,
1235: p_msg_level=>fnd_log.level_procedure);
1236: END IF;
1237: WHEN OTHERS THEN
1246: p_data => x_msg_data);
1247:
1248: -- Debug info.
1249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1251: p_msg_data=>x_msg_data,
1252: p_msg_type=>'SQL ERROR',
1253: p_msg_level=>fnd_log.level_error);
1254: END IF;
1252: p_msg_type=>'SQL ERROR',
1253: p_msg_level=>fnd_log.level_error);
1254: END IF;
1255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1256: hz_utility_v2pub.debug(p_message=>'do_save_party_site_bo(-)',
1257: p_prefix=>l_debug_prefix,
1258: p_msg_level=>fnd_log.level_procedure);
1259: END IF;
1260: END do_save_party_site_bo;
1435:
1436:
1437: -- Debug info.
1438: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo(+)',
1440: p_prefix=>l_debug_prefix,
1441: p_msg_level=>fnd_log.level_procedure);
1442: END IF;
1443:
1479:
1480:
1481: -- Debug info.
1482: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1484: p_msg_data=>x_msg_data,
1485: p_msg_type=>'WARNING',
1486: p_msg_level=>fnd_log.level_exception);
1487: END IF;
1487: END IF;
1488:
1489: -- Debug info.
1490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1491: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1492: p_prefix=>l_debug_prefix,
1493: p_msg_level=>fnd_log.level_procedure);
1494: END IF;
1495:
1504: p_data => x_msg_data);
1505:
1506: -- Debug info.
1507: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1509: p_msg_data=>x_msg_data,
1510: p_msg_type=>'ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1510: p_msg_type=>'ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN fnd_api.g_exc_unexpected_error THEN
1523: p_data => x_msg_data);
1524:
1525: -- Debug info.
1526: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1527: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1528: p_msg_data=>x_msg_data,
1529: p_msg_type=>'UNEXPECTED ERROR',
1530: p_msg_level=>fnd_log.level_error);
1531: END IF;
1529: p_msg_type=>'UNEXPECTED ERROR',
1530: p_msg_level=>fnd_log.level_error);
1531: END IF;
1532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1533: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1534: p_prefix=>l_debug_prefix,
1535: p_msg_level=>fnd_log.level_procedure);
1536: END IF;
1537: WHEN OTHERS THEN
1546: p_data => x_msg_data);
1547:
1548: -- Debug info.
1549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1550: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1551: p_msg_data=>x_msg_data,
1552: p_msg_type=>'SQL ERROR',
1553: p_msg_level=>fnd_log.level_error);
1554: END IF;
1552: p_msg_type=>'SQL ERROR',
1553: p_msg_level=>fnd_log.level_error);
1554: END IF;
1555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1556: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1557: p_prefix=>l_debug_prefix,
1558: p_msg_level=>fnd_log.level_procedure);
1559: END IF;
1560: