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_PARTY_CONTACT_V2PUB dependencies on FND_LOG

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

187:
188: BEGIN
189:
190: -- Debug info.
191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
192: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (+)',
193: p_prefix=>l_debug_prefix,
194: p_msg_level=>fnd_log.level_procedure);
195: END IF;

Line 194: p_msg_level=>fnd_log.level_procedure);

190: -- Debug info.
191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
192: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (+)',
193: p_prefix=>l_debug_prefix,
194: p_msg_level=>fnd_log.level_procedure);
195: END IF;
196:
197: -- if primary key value is passed, check for uniqueness.
198: IF l_org_contact_id IS NOT NULL AND

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

351: p_org_contact_rec.org_contact_id := NULL;
352: END IF;
353:
354: -- Debug info.
355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
356: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',
357: p_prefix=>l_debug_prefix,
358: p_msg_level=>fnd_log.level_procedure);
359: END IF;

Line 358: p_msg_level=>fnd_log.level_procedure);

354: -- Debug info.
355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
356: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',
357: p_prefix=>l_debug_prefix,
358: p_msg_level=>fnd_log.level_procedure);
359: END IF;
360:
361: -- call table-handler.
362: HZ_ORG_CONTACTS_PKG.Insert_Row (

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

405: X_STATUS => l_org_status
406: );
407:
408: -- Debug info.
409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',
411: p_prefix=>l_debug_prefix,
412: p_msg_level=>fnd_log.level_procedure);
413: END IF;

Line 412: p_msg_level=>fnd_log.level_procedure);

408: -- Debug info.
409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',
411: p_prefix=>l_debug_prefix,
412: p_msg_level=>fnd_log.level_procedure);
413: END IF;
414:
415:
416:

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

436:
437: x_org_contact_id := p_org_contact_rec.org_contact_id;
438:
439: -- Debug info.
440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
441: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (-)',
442: p_prefix=>l_debug_prefix,
443: p_msg_level=>fnd_log.level_procedure);
444: END IF;

Line 443: p_msg_level=>fnd_log.level_procedure);

439: -- Debug info.
440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
441: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (-)',
442: p_prefix=>l_debug_prefix,
443: p_msg_level=>fnd_log.level_procedure);
444: END IF;
445:
446: END do_create_org_contact;
447:

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

498: l_person_pre_name HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
499: l_party_id HZ_PARTIES.PARTY_ID%TYPE := NULL;
500: BEGIN
501: -- Debug info.
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;

Line 505: p_msg_level=>fnd_log.level_procedure);

501: -- Debug info.
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;
507:
508:
509: -- check whether record has been updated by another user. If not, lock it.

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

643: -- but we should not update existing osr, set it to null
644: end if;
645:
646: -- Debug info.
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;

Line 650: p_msg_level=>fnd_log.level_procedure);

646: -- Debug info.
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652: -- call to table-handler
653: HZ_ORG_CONTACTS_PKG.Update_Row (
654: X_Rowid => l_rowid,

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

696: X_APPLICATION_ID => p_org_contact_rec.application_id,
697: X_STATUS => l_org_status
698: );
699: -- Debug info.
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;

Line 703: p_msg_level=>fnd_log.level_procedure);

699: -- Debug info.
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705:
706: -- update party relationship. party_relationship_id in hz_org_contacts is
707: -- non-updateable and l_party_relationship_id is selected from table.

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

752: END IF;
753: END IF;
754:
755: -- Debug info.
756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
758: p_prefix=>l_debug_prefix,
759: p_msg_level=>fnd_log.level_procedure);
760: END IF;

Line 759: p_msg_level=>fnd_log.level_procedure);

755: -- Debug info.
756: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
758: p_prefix=>l_debug_prefix,
759: p_msg_level=>fnd_log.level_procedure);
760: END IF;
761:
762: END do_update_org_contact;
763:

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

805: l_object_version_number NUMBER; -- Added: Bug#6411541
806: BEGIN
807:
808: -- Debug info.
809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
810: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (+)',
811: p_prefix=>l_debug_prefix,
812: p_msg_level=>fnd_log.level_procedure);
813: END IF;

Line 812: p_msg_level=>fnd_log.level_procedure);

808: -- Debug info.
809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
810: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (+)',
811: p_prefix=>l_debug_prefix,
812: p_msg_level=>fnd_log.level_procedure);
813: END IF;
814:
815: -- if primary key value is passed, check for uniqueness.
816: IF l_org_contact_role_id IS NOT NULL AND

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

892: EXCEPTION
893: WHEN NO_DATA_FOUND THEN
894:
895: -- Debug info.
896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
898: p_prefix=>l_debug_prefix,
899: p_msg_level=>fnd_log.level_procedure);
900: END IF;

Line 899: p_msg_level=>fnd_log.level_procedure);

895: -- Debug info.
896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
898: p_prefix=>l_debug_prefix,
899: p_msg_level=>fnd_log.level_procedure);
900: END IF;
901:
902: -- call table-handler.
903: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (

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

916:
917: x_org_contact_role_id := p_org_contact_role_rec.org_contact_role_id;
918:
919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||
922: 'x_org_contact_role_id = ' || x_org_contact_role_id,
923: p_prefix=>l_debug_prefix,
924: p_msg_level=>fnd_log.level_procedure);

Line 924: p_msg_level=>fnd_log.level_procedure);

920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||
922: 'x_org_contact_role_id = ' || x_org_contact_role_id,
923: p_prefix=>l_debug_prefix,
924: p_msg_level=>fnd_log.level_procedure);
925: END IF;
926: END;
927: END IF;
928:

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

951: END IF;
952: end if;
953:
954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (-)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;

Line 958: p_msg_level=>fnd_log.level_procedure);

954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (-)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;
960:
961: END do_create_org_contact_role;
962:

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

1001:
1002: BEGIN
1003:
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;

Line 1008: p_msg_level=>fnd_log.level_procedure);

1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:
1011: -- check whether record has been updated by another user. If not, lock it.
1012: BEGIN

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

1061: -- but we should not update existing osr, set it to null
1062: end if;
1063:
1064: -- Debug info.
1065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1066: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1067: p_prefix=>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_procedure);
1069: END IF;

Line 1068: p_msg_level=>fnd_log.level_procedure);

1064: -- Debug info.
1065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1066: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1067: p_prefix=>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_procedure);
1069: END IF;
1070:
1071: -- call to table-handler
1072: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

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

1084: X_APPLICATION_ID => p_org_contact_role_rec.application_id
1085: );
1086:
1087: -- Debug info.
1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1089: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',
1090: p_prefix=>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;

Line 1091: p_msg_level=>fnd_log.level_procedure);

1087: -- Debug info.
1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1089: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',
1090: p_prefix=>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;
1093:
1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;
1093:
1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1096: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (-)',
1097: p_prefix=>l_debug_prefix,
1098: p_msg_level=>fnd_log.level_procedure);
1099: END IF;

Line 1098: p_msg_level=>fnd_log.level_procedure);

1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1096: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (-)',
1097: p_prefix=>l_debug_prefix,
1098: p_msg_level=>fnd_log.level_procedure);
1099: END IF;
1100:
1101: END do_update_org_contact_role;
1102:

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

1162: -- Check if API is called in debug mode. If yes, enable debug.
1163: --enable_debug;
1164:
1165: -- Debug info.
1166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1167: hz_utility_v2pub.debug(p_message=>'create_org_contact (+)',
1168: p_prefix=>l_debug_prefix,
1169: p_msg_level=>fnd_log.level_procedure);
1170: END IF;

Line 1169: p_msg_level=>fnd_log.level_procedure);

1165: -- Debug info.
1166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1167: hz_utility_v2pub.debug(p_message=>'create_org_contact (+)',
1168: p_prefix=>l_debug_prefix,
1169: p_msg_level=>fnd_log.level_procedure);
1170: END IF;
1171:
1172: -- initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1227: p_count => x_msg_count,
1228: p_data => x_msg_data);
1229:
1230: -- Debug info.
1231: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1233: p_msg_data=>x_msg_data,
1234: p_msg_type=>'WARNING',
1235: p_msg_level=>fnd_log.level_exception);

Line 1235: p_msg_level=>fnd_log.level_exception);

1231: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1233: p_msg_data=>x_msg_data,
1234: p_msg_type=>'WARNING',
1235: p_msg_level=>fnd_log.level_exception);
1236: END IF;
1237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1238: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1239: p_prefix=>l_debug_prefix,

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

1233: p_msg_data=>x_msg_data,
1234: p_msg_type=>'WARNING',
1235: p_msg_level=>fnd_log.level_exception);
1236: END IF;
1237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1238: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1239: p_prefix=>l_debug_prefix,
1240: p_msg_level=>fnd_log.level_procedure);
1241: END IF;

Line 1240: p_msg_level=>fnd_log.level_procedure);

1236: END IF;
1237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1238: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1239: p_prefix=>l_debug_prefix,
1240: p_msg_level=>fnd_log.level_procedure);
1241: END IF;
1242:
1243: -- Check if API is called in debug mode. If yes, disable debug.
1244: --disable_debug;

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

1252: p_count => x_msg_count,
1253: p_data => x_msg_data);
1254:
1255: -- Debug info.
1256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'ERROR',
1260: p_msg_level=>fnd_log.level_error);

Line 1260: p_msg_level=>fnd_log.level_error);

1256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'ERROR',
1260: p_msg_level=>fnd_log.level_error);
1261: END IF;
1262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1263: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1264: p_prefix=>l_debug_prefix,

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

1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'ERROR',
1260: p_msg_level=>fnd_log.level_error);
1261: END IF;
1262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1263: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;

Line 1265: p_msg_level=>fnd_log.level_procedure);

1261: END IF;
1262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1263: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;
1267:
1268:
1269: -- Check if API is called in debug mode. If yes, disable debug.

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

1277: p_count => x_msg_count,
1278: p_data => x_msg_data);
1279:
1280: -- Debug info.
1281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'UNEXPECTED ERROR',
1285: p_msg_level=>fnd_log.level_error);

Line 1285: p_msg_level=>fnd_log.level_error);

1281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'UNEXPECTED ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1289: p_prefix=>l_debug_prefix,

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

1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'UNEXPECTED ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;

Line 1290: p_msg_level=>fnd_log.level_procedure);

1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1292:
1293: -- Check if API is called in debug mode. If yes, disable debug.
1294: --disable_debug;

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

1304: p_count => x_msg_count,
1305: p_data => x_msg_data);
1306:
1307: -- Debug info.
1308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1310: p_msg_data=>x_msg_data,
1311: p_msg_type=>'SQL ERROR',
1312: p_msg_level=>fnd_log.level_error);

Line 1312: p_msg_level=>fnd_log.level_error);

1308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1310: p_msg_data=>x_msg_data,
1311: p_msg_type=>'SQL ERROR',
1312: p_msg_level=>fnd_log.level_error);
1313: END IF;
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1315: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1316: p_prefix=>l_debug_prefix,

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

1310: p_msg_data=>x_msg_data,
1311: p_msg_type=>'SQL ERROR',
1312: p_msg_level=>fnd_log.level_error);
1313: END IF;
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1315: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1316: p_prefix=>l_debug_prefix,
1317: p_msg_level=>fnd_log.level_procedure);
1318: END IF;

Line 1317: p_msg_level=>fnd_log.level_procedure);

1313: END IF;
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1315: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1316: p_prefix=>l_debug_prefix,
1317: p_msg_level=>fnd_log.level_procedure);
1318: END IF;
1319:
1320: -- Check if API is called in debug mode. If yes, disable debug.
1321: --disable_debug;

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

1381: -- Check if API is called in debug mode. If yes, enable debug.
1382: --enable_debug;
1383:
1384: -- Debug info.
1385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1386: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',
1387: p_prefix=>l_debug_prefix,
1388: p_msg_level=>fnd_log.level_procedure);
1389: END IF;

Line 1388: p_msg_level=>fnd_log.level_procedure);

1384: -- Debug info.
1385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1386: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',
1387: p_prefix=>l_debug_prefix,
1388: p_msg_level=>fnd_log.level_procedure);
1389: END IF;
1390:
1391: -- initialize message list if p_init_msg_list is set to TRUE.
1392: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478:
1479: -- Debug info.
1480: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1481: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1482: p_msg_data=>x_msg_data,
1483: p_msg_type=>'WARNING',
1484: p_msg_level=>fnd_log.level_exception);

Line 1484: p_msg_level=>fnd_log.level_exception);

1480: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1481: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1482: p_msg_data=>x_msg_data,
1483: p_msg_type=>'WARNING',
1484: p_msg_level=>fnd_log.level_exception);
1485: END IF;
1486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1487: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1488: p_prefix=>l_debug_prefix,

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

1482: p_msg_data=>x_msg_data,
1483: p_msg_type=>'WARNING',
1484: p_msg_level=>fnd_log.level_exception);
1485: END IF;
1486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1487: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1488: p_prefix=>l_debug_prefix,
1489: p_msg_level=>fnd_log.level_procedure);
1490: END IF;

Line 1489: p_msg_level=>fnd_log.level_procedure);

1485: END IF;
1486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1487: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1488: p_prefix=>l_debug_prefix,
1489: p_msg_level=>fnd_log.level_procedure);
1490: END IF;
1491:
1492: -- Check if API is called in debug mode. If yes, disable debug.
1493: --disable_debug;

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

1500: p_count => x_msg_count,
1501: p_data => x_msg_data);
1502:
1503: -- Debug info.
1504: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1506: p_msg_data=>x_msg_data,
1507: p_msg_type=>'ERROR',
1508: p_msg_level=>fnd_log.level_error);

Line 1508: p_msg_level=>fnd_log.level_error);

1504: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1506: p_msg_data=>x_msg_data,
1507: p_msg_type=>'ERROR',
1508: p_msg_level=>fnd_log.level_error);
1509: END IF;
1510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1511: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1512: p_prefix=>l_debug_prefix,

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

1506: p_msg_data=>x_msg_data,
1507: p_msg_type=>'ERROR',
1508: p_msg_level=>fnd_log.level_error);
1509: END IF;
1510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1511: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1512: p_prefix=>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_procedure);
1514: END IF;

Line 1513: p_msg_level=>fnd_log.level_procedure);

1509: END IF;
1510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1511: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1512: p_prefix=>l_debug_prefix,
1513: p_msg_level=>fnd_log.level_procedure);
1514: END IF;
1515:
1516: -- Check if API is called in debug mode. If yes, disable debug.
1517: --disable_debug;

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

1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:
1527: -- Debug info.
1528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'UNEXPECTED ERROR',
1532: p_msg_level=>fnd_log.level_error);

Line 1532: p_msg_level=>fnd_log.level_error);

1528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'UNEXPECTED ERROR',
1532: p_msg_level=>fnd_log.level_error);
1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1536: p_prefix=>l_debug_prefix,

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

1530: p_msg_data=>x_msg_data,
1531: p_msg_type=>'UNEXPECTED ERROR',
1532: p_msg_level=>fnd_log.level_error);
1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1536: p_prefix=>l_debug_prefix,
1537: p_msg_level=>fnd_log.level_procedure);
1538: END IF;

Line 1537: p_msg_level=>fnd_log.level_procedure);

1533: END IF;
1534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1535: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1536: p_prefix=>l_debug_prefix,
1537: p_msg_level=>fnd_log.level_procedure);
1538: END IF;
1539:
1540: -- Check if API is called in debug mode. If yes, disable debug.
1541: --disable_debug;

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

1551: p_count => x_msg_count,
1552: p_data => x_msg_data);
1553:
1554: -- Debug info.
1555: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1556: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1557: p_msg_data=>x_msg_data,
1558: p_msg_type=>'SQL ERROR',
1559: p_msg_level=>fnd_log.level_error);

Line 1559: p_msg_level=>fnd_log.level_error);

1555: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1556: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1557: p_msg_data=>x_msg_data,
1558: p_msg_type=>'SQL ERROR',
1559: p_msg_level=>fnd_log.level_error);
1560: END IF;
1561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1562: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1563: p_prefix=>l_debug_prefix,

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

1557: p_msg_data=>x_msg_data,
1558: p_msg_type=>'SQL ERROR',
1559: p_msg_level=>fnd_log.level_error);
1560: END IF;
1561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1562: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1563: p_prefix=>l_debug_prefix,
1564: p_msg_level=>fnd_log.level_procedure);
1565: END IF;

Line 1564: p_msg_level=>fnd_log.level_procedure);

1560: END IF;
1561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1562: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1563: p_prefix=>l_debug_prefix,
1564: p_msg_level=>fnd_log.level_procedure);
1565: END IF;
1566:
1567: -- Check if API is called in debug mode. If yes, disable debug.
1568: --disable_debug;

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

1621: -- Check if API is called in debug mode. If yes, enable debug.
1622: --enable_debug;
1623:
1624: -- Debug info.
1625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1626: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',
1627: p_prefix=>l_debug_prefix,
1628: p_msg_level=>fnd_log.level_procedure);
1629: END IF;

Line 1628: p_msg_level=>fnd_log.level_procedure);

1624: -- Debug info.
1625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1626: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',
1627: p_prefix=>l_debug_prefix,
1628: p_msg_level=>fnd_log.level_procedure);
1629: END IF;
1630:
1631: -- initialize message list if p_init_msg_list is set to TRUE.
1632: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1663: p_count => x_msg_count,
1664: p_data => x_msg_data);
1665:
1666: -- Debug info.
1667: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'WARNING',
1671: p_msg_level=>fnd_log.level_exception);

Line 1671: p_msg_level=>fnd_log.level_exception);

1667: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'WARNING',
1671: p_msg_level=>fnd_log.level_exception);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1675: p_prefix=>l_debug_prefix,

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

1669: p_msg_data=>x_msg_data,
1670: p_msg_type=>'WARNING',
1671: p_msg_level=>fnd_log.level_exception);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;

Line 1676: p_msg_level=>fnd_log.level_procedure);

1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678:
1679: -- Check if API is called in debug mode. If yes, disable debug.
1680: --disable_debug;

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

1688: p_count => x_msg_count,
1689: p_data => x_msg_data);
1690:
1691: -- Debug info.
1692: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1693: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1694: p_msg_data=>x_msg_data,
1695: p_msg_type=>'ERROR',
1696: p_msg_level=>fnd_log.level_error);

Line 1696: p_msg_level=>fnd_log.level_error);

1692: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1693: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1694: p_msg_data=>x_msg_data,
1695: p_msg_type=>'ERROR',
1696: p_msg_level=>fnd_log.level_error);
1697: END IF;
1698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1699: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1700: p_prefix=>l_debug_prefix,

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

1694: p_msg_data=>x_msg_data,
1695: p_msg_type=>'ERROR',
1696: p_msg_level=>fnd_log.level_error);
1697: END IF;
1698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1699: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1700: p_prefix=>l_debug_prefix,
1701: p_msg_level=>fnd_log.level_procedure);
1702: END IF;

Line 1701: p_msg_level=>fnd_log.level_procedure);

1697: END IF;
1698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1699: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1700: p_prefix=>l_debug_prefix,
1701: p_msg_level=>fnd_log.level_procedure);
1702: END IF;
1703:
1704: -- Check if API is called in debug mode. If yes, disable debug.
1705: --disable_debug;

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

1712: p_count => x_msg_count,
1713: p_data => x_msg_data);
1714:
1715: -- Debug info.
1716: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1718: p_msg_data=>x_msg_data,
1719: p_msg_type=>'UNEXPECTED ERROR',
1720: p_msg_level=>fnd_log.level_error);

Line 1720: p_msg_level=>fnd_log.level_error);

1716: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1718: p_msg_data=>x_msg_data,
1719: p_msg_type=>'UNEXPECTED ERROR',
1720: p_msg_level=>fnd_log.level_error);
1721: END IF;
1722: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1723: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1724: p_prefix=>l_debug_prefix,

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

1718: p_msg_data=>x_msg_data,
1719: p_msg_type=>'UNEXPECTED ERROR',
1720: p_msg_level=>fnd_log.level_error);
1721: END IF;
1722: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1723: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1724: p_prefix=>l_debug_prefix,
1725: p_msg_level=>fnd_log.level_procedure);
1726: END IF;

Line 1725: p_msg_level=>fnd_log.level_procedure);

1721: END IF;
1722: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1723: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1724: p_prefix=>l_debug_prefix,
1725: p_msg_level=>fnd_log.level_procedure);
1726: END IF;
1727:
1728: -- Check if API is called in debug mode. If yes, disable debug.
1729: --disable_debug;

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

1739: p_count => x_msg_count,
1740: p_data => x_msg_data);
1741:
1742: -- Debug info.
1743: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1745: p_msg_data=>x_msg_data,
1746: p_msg_type=>'SQL ERROR',
1747: p_msg_level=>fnd_log.level_error);

Line 1747: p_msg_level=>fnd_log.level_error);

1743: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1745: p_msg_data=>x_msg_data,
1746: p_msg_type=>'SQL ERROR',
1747: p_msg_level=>fnd_log.level_error);
1748: END IF;
1749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1750: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1751: p_prefix=>l_debug_prefix,

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

1745: p_msg_data=>x_msg_data,
1746: p_msg_type=>'SQL ERROR',
1747: p_msg_level=>fnd_log.level_error);
1748: END IF;
1749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1750: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1751: p_prefix=>l_debug_prefix,
1752: p_msg_level=>fnd_log.level_procedure);
1753: END IF;

Line 1752: p_msg_level=>fnd_log.level_procedure);

1748: END IF;
1749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1750: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1751: p_prefix=>l_debug_prefix,
1752: p_msg_level=>fnd_log.level_procedure);
1753: END IF;
1754:
1755: -- Check if API is called in debug mode. If yes, disable debug.
1756: --disable_debug;

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

1810: -- Check if API is called in debug mode. If yes, enable debug.
1811: --enable_debug;
1812:
1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',
1816: p_prefix=>l_debug_prefix,
1817: p_msg_level=>fnd_log.level_procedure);
1818: END IF;

Line 1817: p_msg_level=>fnd_log.level_procedure);

1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',
1816: p_prefix=>l_debug_prefix,
1817: p_msg_level=>fnd_log.level_procedure);
1818: END IF;
1819:
1820: -- initialize message list if p_init_msg_list is set to TRUE.
1821: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:
1886: -- Debug info.
1887: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1889: p_msg_data=>x_msg_data,
1890: p_msg_type=>'WARNING',
1891: p_msg_level=>fnd_log.level_exception);

Line 1891: p_msg_level=>fnd_log.level_exception);

1887: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1889: p_msg_data=>x_msg_data,
1890: p_msg_type=>'WARNING',
1891: p_msg_level=>fnd_log.level_exception);
1892: END IF;
1893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1894: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1895: p_prefix=>l_debug_prefix,

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

1889: p_msg_data=>x_msg_data,
1890: p_msg_type=>'WARNING',
1891: p_msg_level=>fnd_log.level_exception);
1892: END IF;
1893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1894: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1895: p_prefix=>l_debug_prefix,
1896: p_msg_level=>fnd_log.level_procedure);
1897: END IF;

Line 1896: p_msg_level=>fnd_log.level_procedure);

1892: END IF;
1893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1894: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1895: p_prefix=>l_debug_prefix,
1896: p_msg_level=>fnd_log.level_procedure);
1897: END IF;
1898:
1899: -- Check if API is called in debug mode. If yes, disable debug.
1900: --disable_debug;

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

1908: p_count => x_msg_count,
1909: p_data => x_msg_data);
1910:
1911: -- Debug info.
1912: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1914: p_msg_data=>x_msg_data,
1915: p_msg_type=>'ERROR',
1916: p_msg_level=>fnd_log.level_error);

Line 1916: p_msg_level=>fnd_log.level_error);

1912: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1914: p_msg_data=>x_msg_data,
1915: p_msg_type=>'ERROR',
1916: p_msg_level=>fnd_log.level_error);
1917: END IF;
1918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1919: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1920: p_prefix=>l_debug_prefix,

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

1914: p_msg_data=>x_msg_data,
1915: p_msg_type=>'ERROR',
1916: p_msg_level=>fnd_log.level_error);
1917: END IF;
1918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1919: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: END IF;

Line 1921: p_msg_level=>fnd_log.level_procedure);

1917: END IF;
1918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1919: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: END IF;
1923:
1924: -- Check if API is called in debug mode. If yes, disable debug.
1925: --disable_debug;

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

1932: p_count => x_msg_count,
1933: p_data => x_msg_data);
1934:
1935: -- Debug info.
1936: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1938: p_msg_data=>x_msg_data,
1939: p_msg_type=>'UNEXPECTED ERROR',
1940: p_msg_level=>fnd_log.level_error);

Line 1940: p_msg_level=>fnd_log.level_error);

1936: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1938: p_msg_data=>x_msg_data,
1939: p_msg_type=>'UNEXPECTED ERROR',
1940: p_msg_level=>fnd_log.level_error);
1941: END IF;
1942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1944: p_prefix=>l_debug_prefix,

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

1938: p_msg_data=>x_msg_data,
1939: p_msg_type=>'UNEXPECTED ERROR',
1940: p_msg_level=>fnd_log.level_error);
1941: END IF;
1942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1944: p_prefix=>l_debug_prefix,
1945: p_msg_level=>fnd_log.level_procedure);
1946: END IF;

Line 1945: p_msg_level=>fnd_log.level_procedure);

1941: END IF;
1942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1944: p_prefix=>l_debug_prefix,
1945: p_msg_level=>fnd_log.level_procedure);
1946: END IF;
1947:
1948: -- Check if API is called in debug mode. If yes, disable debug.
1949: --disable_debug;

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

1959: p_count => x_msg_count,
1960: p_data => x_msg_data);
1961:
1962: -- Debug info.
1963: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1965: p_msg_data=>x_msg_data,
1966: p_msg_type=>'SQL ERROR',
1967: p_msg_level=>fnd_log.level_error);

Line 1967: p_msg_level=>fnd_log.level_error);

1963: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1965: p_msg_data=>x_msg_data,
1966: p_msg_type=>'SQL ERROR',
1967: p_msg_level=>fnd_log.level_error);
1968: END IF;
1969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1970: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1971: p_prefix=>l_debug_prefix,

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

1965: p_msg_data=>x_msg_data,
1966: p_msg_type=>'SQL ERROR',
1967: p_msg_level=>fnd_log.level_error);
1968: END IF;
1969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1970: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1971: p_prefix=>l_debug_prefix,
1972: p_msg_level=>fnd_log.level_procedure);
1973: END IF;

Line 1972: p_msg_level=>fnd_log.level_procedure);

1968: END IF;
1969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1970: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1971: p_prefix=>l_debug_prefix,
1972: p_msg_level=>fnd_log.level_procedure);
1973: END IF;
1974:
1975: -- Check if API is called in debug mode. If yes, disable debug.
1976: --disable_debug;