DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PUB dependencies on FND_LOG

Line 177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 180: p_msg_level=>fnd_log.level_procedure);

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

Line 413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 422: p_msg_level=>fnd_log.level_procedure);

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

Line 444: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 453: p_msg_level=>fnd_log.level_procedure);

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;

Line 474: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 483: p_msg_level=>fnd_log.level_procedure);

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;

Line 508: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 517: p_msg_level=>fnd_log.level_procedure);

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(

Line 766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 769: p_msg_level=>fnd_log.level_procedure);

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;

Line 978: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 987: p_msg_level=>fnd_log.level_procedure);

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

Line 1009: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 1015: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1018: p_msg_level=>fnd_log.level_procedure);

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;

Line 1039: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1045: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1048: p_msg_level=>fnd_log.level_procedure);

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;

Line 1073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1082: p_msg_level=>fnd_log.level_procedure);

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

Line 1122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1125: p_msg_level=>fnd_log.level_procedure);

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;

Line 1185: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1194: p_msg_level=>fnd_log.level_procedure);

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

Line 1206: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1215: p_msg_level=>fnd_log.level_procedure);

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;

Line 1226: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1235: p_msg_level=>fnd_log.level_procedure);

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:

Line 1249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1258: p_msg_level=>fnd_log.level_procedure);

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(

Line 1438: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1441: p_msg_level=>fnd_log.level_procedure);

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

Line 1482: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 1493: p_msg_level=>fnd_log.level_procedure);

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

Line 1507: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1516: p_msg_level=>fnd_log.level_procedure);

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:

Line 1526: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1535: p_msg_level=>fnd_log.level_procedure);

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:

Line 1549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 1555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1558: p_msg_level=>fnd_log.level_procedure);

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: