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
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;
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:
183: -- Base on p_validate_bo_flag, check the completeness of business objects
184: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
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,
415: p_msg_data=>x_msg_data,
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);
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;
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,
415: p_msg_data=>x_msg_data,
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;
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:
425: EXCEPTION
426: WHEN fnd_api.g_exc_error THEN
440: p_count => x_msg_count,
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);
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;
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,
446: p_msg_data=>x_msg_data,
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;
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;
470: p_count => x_msg_count,
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);
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;
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,
476: p_msg_data=>x_msg_data,
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;
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;
504: p_count => x_msg_count,
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);
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;
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,
510: p_msg_data=>x_msg_data,
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;
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;
520:
521: PROCEDURE create_party_site_bo(
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
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;
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:
772: x_party_site_id := p_party_site_obj.party_site_id;
773: x_party_site_os := p_party_site_obj.orig_system;
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,
980: p_msg_data=>x_msg_data,
981: p_msg_type=>'WARNING',
982: p_msg_level=>fnd_log.level_exception);
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;
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,
980: p_msg_data=>x_msg_data,
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;
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:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error THEN
1005: p_count => x_msg_count,
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);
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;
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,
1011: p_msg_data=>x_msg_data,
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;
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;
1035: p_count => x_msg_count,
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);
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;
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,
1041: p_msg_data=>x_msg_data,
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;
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;
1069: p_count => x_msg_count,
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);
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;
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,
1075: p_msg_data=>x_msg_data,
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;
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;
1085:
1086: -- PROCEDURE do_save_party_site_bo
1118: FND_MSG_PUB.initialize;
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;
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:
1128: x_party_site_id := p_party_site_obj.party_site_id;
1129: x_party_site_os := p_party_site_obj.orig_system;
1181: RAISE FND_API.G_EXC_ERROR;
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);
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;
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,
1187: p_msg_data=>x_msg_data,
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;
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:
1197: EXCEPTION
1198: WHEN fnd_api.g_exc_error THEN
1202: p_count => x_msg_count,
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);
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;
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,
1208: p_msg_data=>x_msg_data,
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;
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:
1218: WHEN fnd_api.g_exc_unexpected_error THEN
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1222: p_count => x_msg_count,
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);
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;
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,
1228: p_msg_data=>x_msg_data,
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;
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
1238: x_return_status := fnd_api.g_ret_sts_unexp_error;
1239:
1245: p_count => x_msg_count,
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);
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;
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,
1251: p_msg_data=>x_msg_data,
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;
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;
1261:
1262: PROCEDURE save_party_site_bo(
1434: END IF;
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;
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:
1444: -- check if pass in contact_point_id and/or os+osr
1445: -- extraction validation logic is same as update
1478: END IF;
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);
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;
1488:
1489: -- Debug info.
1490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1486: p_msg_level=>fnd_log.level_exception);
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;
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:
1496:
1497: EXCEPTION
1503: p_count => x_msg_count,
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);
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;
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,
1509: p_msg_data=>x_msg_data,
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;
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
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1522: p_count => x_msg_count,
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);
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;
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,
1528: p_msg_data=>x_msg_data,
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;
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
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539:
1545: p_count => x_msg_count,
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);
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;
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,
1551: p_msg_data=>x_msg_data,
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;
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:
1561: end;
1562: