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 358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 361: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 415: p_msg_level=>fnd_log.level_procedure);

411: -- Debug info.
412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',
414: p_prefix=>l_debug_prefix,
415: p_msg_level=>fnd_log.level_procedure);
416: END IF;
417:
418: --Bug13117445
419: --DQM Sync call added

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

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

Line 448: p_msg_level=>fnd_log.level_procedure);

444: -- Debug info.
445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
446: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (-)',
447: p_prefix=>l_debug_prefix,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450:
451: END do_create_org_contact;
452:

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

503: l_person_pre_name HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE := NULL;
504: l_party_id HZ_PARTIES.PARTY_ID%TYPE := NULL;
505: BEGIN
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;

Line 510: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 655: p_msg_level=>fnd_log.level_procedure);

651: -- Debug info.
652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
653: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',
654: p_prefix=>l_debug_prefix,
655: p_msg_level=>fnd_log.level_procedure);
656: END IF;
657: -- call to table-handler
658: HZ_ORG_CONTACTS_PKG.Update_Row (
659: X_Rowid => l_rowid,

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

701: X_APPLICATION_ID => p_org_contact_rec.application_id,
702: X_STATUS => l_org_status
703: );
704: -- Debug info.
705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
706: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',
707: p_prefix=>l_debug_prefix,
708: p_msg_level=>fnd_log.level_procedure);
709: END IF;

Line 708: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 764: p_msg_level=>fnd_log.level_procedure);

760: -- Debug info.
761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
762: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',
763: p_prefix=>l_debug_prefix,
764: p_msg_level=>fnd_log.level_procedure);
765: END IF;
766:
767: END do_update_org_contact;
768:

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

810: l_object_version_number NUMBER; -- Added: Bug#6411541
811: BEGIN
812:
813: -- Debug info.
814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (+)',
816: p_prefix=>l_debug_prefix,
817: p_msg_level=>fnd_log.level_procedure);
818: END IF;

Line 817: p_msg_level=>fnd_log.level_procedure);

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

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

897: EXCEPTION
898: WHEN NO_DATA_FOUND THEN
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;

Line 904: p_msg_level=>fnd_log.level_procedure);

900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
906:
907: -- call table-handler.
908: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (

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

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

Line 929: p_msg_level=>fnd_log.level_procedure);

925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
926: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||
927: 'x_org_contact_role_id = ' || x_org_contact_role_id,
928: p_prefix=>l_debug_prefix,
929: p_msg_level=>fnd_log.level_procedure);
930: END IF;
931: END;
932: END IF;
933:

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

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

Line 963: p_msg_level=>fnd_log.level_procedure);

959: -- Debug info.
960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
961: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (-)',
962: p_prefix=>l_debug_prefix,
963: p_msg_level=>fnd_log.level_procedure);
964: END IF;
965:
966: END do_create_org_contact_role;
967:

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

1006:
1007: BEGIN
1008:
1009: -- Debug info.
1010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (+)',
1012: p_prefix=>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_procedure);
1014: END IF;

Line 1013: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1073: p_msg_level=>fnd_log.level_procedure);

1069: -- Debug info.
1070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1071: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1072: p_prefix=>l_debug_prefix,
1073: p_msg_level=>fnd_log.level_procedure);
1074: END IF;
1075:
1076: -- call to table-handler
1077: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

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

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

Line 1096: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1103: p_msg_level=>fnd_log.level_procedure);

1099: -- Debug info.
1100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1101: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (-)',
1102: p_prefix=>l_debug_prefix,
1103: p_msg_level=>fnd_log.level_procedure);
1104: END IF;
1105:
1106: END do_update_org_contact_role;
1107:

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

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

Line 1174: p_msg_level=>fnd_log.level_procedure);

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

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

1235: p_count => x_msg_count,
1236: p_data => x_msg_data);
1237:
1238: -- Debug info.
1239: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'WARNING',
1243: p_msg_level=>fnd_log.level_exception);

Line 1243: p_msg_level=>fnd_log.level_exception);

1239: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'WARNING',
1243: p_msg_level=>fnd_log.level_exception);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1247: p_prefix=>l_debug_prefix,

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

1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'WARNING',
1243: p_msg_level=>fnd_log.level_exception);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;

Line 1248: p_msg_level=>fnd_log.level_procedure);

1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:
1251: -- Check if API is called in debug mode. If yes, disable debug.
1252: --disable_debug;

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

1260: p_count => x_msg_count,
1261: p_data => x_msg_data);
1262:
1263: -- Debug info.
1264: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1266: p_msg_data=>x_msg_data,
1267: p_msg_type=>'ERROR',
1268: p_msg_level=>fnd_log.level_error);

Line 1268: p_msg_level=>fnd_log.level_error);

1264: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1266: p_msg_data=>x_msg_data,
1267: p_msg_type=>'ERROR',
1268: p_msg_level=>fnd_log.level_error);
1269: END IF;
1270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1271: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1272: p_prefix=>l_debug_prefix,

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

1266: p_msg_data=>x_msg_data,
1267: p_msg_type=>'ERROR',
1268: p_msg_level=>fnd_log.level_error);
1269: END IF;
1270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1271: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1272: p_prefix=>l_debug_prefix,
1273: p_msg_level=>fnd_log.level_procedure);
1274: END IF;

Line 1273: p_msg_level=>fnd_log.level_procedure);

1269: END IF;
1270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1271: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1272: p_prefix=>l_debug_prefix,
1273: p_msg_level=>fnd_log.level_procedure);
1274: END IF;
1275:
1276:
1277: -- Check if API is called in debug mode. If yes, disable debug.

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

1285: p_count => x_msg_count,
1286: p_data => x_msg_data);
1287:
1288: -- Debug info.
1289: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1291: p_msg_data=>x_msg_data,
1292: p_msg_type=>'UNEXPECTED ERROR',
1293: p_msg_level=>fnd_log.level_error);

Line 1293: p_msg_level=>fnd_log.level_error);

1289: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1291: p_msg_data=>x_msg_data,
1292: p_msg_type=>'UNEXPECTED ERROR',
1293: p_msg_level=>fnd_log.level_error);
1294: END IF;
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1297: p_prefix=>l_debug_prefix,

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

1291: p_msg_data=>x_msg_data,
1292: p_msg_type=>'UNEXPECTED ERROR',
1293: p_msg_level=>fnd_log.level_error);
1294: END IF;
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;

Line 1298: p_msg_level=>fnd_log.level_procedure);

1294: END IF;
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;
1300:
1301: -- Check if API is called in debug mode. If yes, disable debug.
1302: --disable_debug;

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

1312: p_count => x_msg_count,
1313: p_data => x_msg_data);
1314:
1315: -- Debug info.
1316: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1317: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1318: p_msg_data=>x_msg_data,
1319: p_msg_type=>'SQL ERROR',
1320: p_msg_level=>fnd_log.level_error);

Line 1320: p_msg_level=>fnd_log.level_error);

1316: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1317: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1318: p_msg_data=>x_msg_data,
1319: p_msg_type=>'SQL ERROR',
1320: p_msg_level=>fnd_log.level_error);
1321: END IF;
1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1324: p_prefix=>l_debug_prefix,

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

1318: p_msg_data=>x_msg_data,
1319: p_msg_type=>'SQL ERROR',
1320: p_msg_level=>fnd_log.level_error);
1321: END IF;
1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1324: p_prefix=>l_debug_prefix,
1325: p_msg_level=>fnd_log.level_procedure);
1326: END IF;

Line 1325: p_msg_level=>fnd_log.level_procedure);

1321: END IF;
1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',
1324: p_prefix=>l_debug_prefix,
1325: p_msg_level=>fnd_log.level_procedure);
1326: END IF;
1327:
1328: -- Check if API is called in debug mode. If yes, disable debug.
1329: --disable_debug;

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

1389: -- Check if API is called in debug mode. If yes, enable debug.
1390: --enable_debug;
1391:
1392: -- Debug info.
1393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1394: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',
1395: p_prefix=>l_debug_prefix,
1396: p_msg_level=>fnd_log.level_procedure);
1397: END IF;

Line 1396: p_msg_level=>fnd_log.level_procedure);

1392: -- Debug info.
1393: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1394: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',
1395: p_prefix=>l_debug_prefix,
1396: p_msg_level=>fnd_log.level_procedure);
1397: END IF;
1398:
1399: -- initialize message list if p_init_msg_list is set to TRUE.
1400: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1484: p_count => x_msg_count,
1485: p_data => x_msg_data);
1486:
1487: -- Debug info.
1488: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'WARNING',
1492: p_msg_level=>fnd_log.level_exception);

Line 1492: p_msg_level=>fnd_log.level_exception);

1488: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'WARNING',
1492: p_msg_level=>fnd_log.level_exception);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1496: p_prefix=>l_debug_prefix,

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

1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'WARNING',
1492: p_msg_level=>fnd_log.level_exception);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;

Line 1497: p_msg_level=>fnd_log.level_procedure);

1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;
1499:
1500: -- Check if API is called in debug mode. If yes, disable debug.
1501: --disable_debug;

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

1508: p_count => x_msg_count,
1509: p_data => x_msg_data);
1510:
1511: -- Debug info.
1512: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1513: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1514: p_msg_data=>x_msg_data,
1515: p_msg_type=>'ERROR',
1516: p_msg_level=>fnd_log.level_error);

Line 1516: p_msg_level=>fnd_log.level_error);

1512: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1513: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1514: p_msg_data=>x_msg_data,
1515: p_msg_type=>'ERROR',
1516: p_msg_level=>fnd_log.level_error);
1517: END IF;
1518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1520: p_prefix=>l_debug_prefix,

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

1514: p_msg_data=>x_msg_data,
1515: p_msg_type=>'ERROR',
1516: p_msg_level=>fnd_log.level_error);
1517: END IF;
1518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1520: p_prefix=>l_debug_prefix,
1521: p_msg_level=>fnd_log.level_procedure);
1522: END IF;

Line 1521: p_msg_level=>fnd_log.level_procedure);

1517: END IF;
1518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1520: p_prefix=>l_debug_prefix,
1521: p_msg_level=>fnd_log.level_procedure);
1522: END IF;
1523:
1524: -- Check if API is called in debug mode. If yes, disable debug.
1525: --disable_debug;

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

1532: p_count => x_msg_count,
1533: p_data => x_msg_data);
1534:
1535: -- Debug info.
1536: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1538: p_msg_data=>x_msg_data,
1539: p_msg_type=>'UNEXPECTED ERROR',
1540: p_msg_level=>fnd_log.level_error);

Line 1540: p_msg_level=>fnd_log.level_error);

1536: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1538: p_msg_data=>x_msg_data,
1539: p_msg_type=>'UNEXPECTED ERROR',
1540: p_msg_level=>fnd_log.level_error);
1541: END IF;
1542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1543: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1544: p_prefix=>l_debug_prefix,

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

1538: p_msg_data=>x_msg_data,
1539: p_msg_type=>'UNEXPECTED ERROR',
1540: p_msg_level=>fnd_log.level_error);
1541: END IF;
1542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1543: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1544: p_prefix=>l_debug_prefix,
1545: p_msg_level=>fnd_log.level_procedure);
1546: END IF;

Line 1545: p_msg_level=>fnd_log.level_procedure);

1541: END IF;
1542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1543: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1544: p_prefix=>l_debug_prefix,
1545: p_msg_level=>fnd_log.level_procedure);
1546: END IF;
1547:
1548: -- Check if API is called in debug mode. If yes, disable debug.
1549: --disable_debug;

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

1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561:
1562: -- Debug info.
1563: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1564: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1565: p_msg_data=>x_msg_data,
1566: p_msg_type=>'SQL ERROR',
1567: p_msg_level=>fnd_log.level_error);

Line 1567: p_msg_level=>fnd_log.level_error);

1563: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1564: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1565: p_msg_data=>x_msg_data,
1566: p_msg_type=>'SQL ERROR',
1567: p_msg_level=>fnd_log.level_error);
1568: END IF;
1569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1570: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1571: p_prefix=>l_debug_prefix,

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

1565: p_msg_data=>x_msg_data,
1566: p_msg_type=>'SQL ERROR',
1567: p_msg_level=>fnd_log.level_error);
1568: END IF;
1569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1570: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1571: p_prefix=>l_debug_prefix,
1572: p_msg_level=>fnd_log.level_procedure);
1573: END IF;

Line 1572: p_msg_level=>fnd_log.level_procedure);

1568: END IF;
1569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1570: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',
1571: p_prefix=>l_debug_prefix,
1572: p_msg_level=>fnd_log.level_procedure);
1573: END IF;
1574:
1575: -- Check if API is called in debug mode. If yes, disable debug.
1576: --disable_debug;

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

1629: -- Check if API is called in debug mode. If yes, enable debug.
1630: --enable_debug;
1631:
1632: -- Debug info.
1633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1634: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',
1635: p_prefix=>l_debug_prefix,
1636: p_msg_level=>fnd_log.level_procedure);
1637: END IF;

Line 1636: p_msg_level=>fnd_log.level_procedure);

1632: -- Debug info.
1633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1634: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',
1635: p_prefix=>l_debug_prefix,
1636: p_msg_level=>fnd_log.level_procedure);
1637: END IF;
1638:
1639: -- initialize message list if p_init_msg_list is set to TRUE.
1640: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1671: p_count => x_msg_count,
1672: p_data => x_msg_data);
1673:
1674: -- Debug info.
1675: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1677: p_msg_data=>x_msg_data,
1678: p_msg_type=>'WARNING',
1679: p_msg_level=>fnd_log.level_exception);

Line 1679: p_msg_level=>fnd_log.level_exception);

1675: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1677: p_msg_data=>x_msg_data,
1678: p_msg_type=>'WARNING',
1679: p_msg_level=>fnd_log.level_exception);
1680: END IF;
1681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1683: p_prefix=>l_debug_prefix,

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

1677: p_msg_data=>x_msg_data,
1678: p_msg_type=>'WARNING',
1679: p_msg_level=>fnd_log.level_exception);
1680: END IF;
1681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1683: p_prefix=>l_debug_prefix,
1684: p_msg_level=>fnd_log.level_procedure);
1685: END IF;

Line 1684: p_msg_level=>fnd_log.level_procedure);

1680: END IF;
1681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1683: p_prefix=>l_debug_prefix,
1684: p_msg_level=>fnd_log.level_procedure);
1685: END IF;
1686:
1687: -- Check if API is called in debug mode. If yes, disable debug.
1688: --disable_debug;

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

1696: p_count => x_msg_count,
1697: p_data => x_msg_data);
1698:
1699: -- Debug info.
1700: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1702: p_msg_data=>x_msg_data,
1703: p_msg_type=>'ERROR',
1704: p_msg_level=>fnd_log.level_error);

Line 1704: p_msg_level=>fnd_log.level_error);

1700: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1702: p_msg_data=>x_msg_data,
1703: p_msg_type=>'ERROR',
1704: p_msg_level=>fnd_log.level_error);
1705: END IF;
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1708: p_prefix=>l_debug_prefix,

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

1702: p_msg_data=>x_msg_data,
1703: p_msg_type=>'ERROR',
1704: p_msg_level=>fnd_log.level_error);
1705: END IF;
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1708: p_prefix=>l_debug_prefix,
1709: p_msg_level=>fnd_log.level_procedure);
1710: END IF;

Line 1709: p_msg_level=>fnd_log.level_procedure);

1705: END IF;
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1708: p_prefix=>l_debug_prefix,
1709: p_msg_level=>fnd_log.level_procedure);
1710: END IF;
1711:
1712: -- Check if API is called in debug mode. If yes, disable debug.
1713: --disable_debug;

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

1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:
1723: -- Debug info.
1724: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1726: p_msg_data=>x_msg_data,
1727: p_msg_type=>'UNEXPECTED ERROR',
1728: p_msg_level=>fnd_log.level_error);

Line 1728: p_msg_level=>fnd_log.level_error);

1724: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1726: p_msg_data=>x_msg_data,
1727: p_msg_type=>'UNEXPECTED ERROR',
1728: p_msg_level=>fnd_log.level_error);
1729: END IF;
1730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1732: p_prefix=>l_debug_prefix,

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

1726: p_msg_data=>x_msg_data,
1727: p_msg_type=>'UNEXPECTED ERROR',
1728: p_msg_level=>fnd_log.level_error);
1729: END IF;
1730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1732: p_prefix=>l_debug_prefix,
1733: p_msg_level=>fnd_log.level_procedure);
1734: END IF;

Line 1733: p_msg_level=>fnd_log.level_procedure);

1729: END IF;
1730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1732: p_prefix=>l_debug_prefix,
1733: p_msg_level=>fnd_log.level_procedure);
1734: END IF;
1735:
1736: -- Check if API is called in debug mode. If yes, disable debug.
1737: --disable_debug;

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

1747: p_count => x_msg_count,
1748: p_data => x_msg_data);
1749:
1750: -- Debug info.
1751: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1752: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1753: p_msg_data=>x_msg_data,
1754: p_msg_type=>'SQL ERROR',
1755: p_msg_level=>fnd_log.level_error);

Line 1755: p_msg_level=>fnd_log.level_error);

1751: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1752: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1753: p_msg_data=>x_msg_data,
1754: p_msg_type=>'SQL ERROR',
1755: p_msg_level=>fnd_log.level_error);
1756: END IF;
1757: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1759: p_prefix=>l_debug_prefix,

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

1753: p_msg_data=>x_msg_data,
1754: p_msg_type=>'SQL ERROR',
1755: p_msg_level=>fnd_log.level_error);
1756: END IF;
1757: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1759: p_prefix=>l_debug_prefix,
1760: p_msg_level=>fnd_log.level_procedure);
1761: END IF;

Line 1760: p_msg_level=>fnd_log.level_procedure);

1756: END IF;
1757: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',
1759: p_prefix=>l_debug_prefix,
1760: p_msg_level=>fnd_log.level_procedure);
1761: END IF;
1762:
1763: -- Check if API is called in debug mode. If yes, disable debug.
1764: --disable_debug;

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

1818: -- Check if API is called in debug mode. If yes, enable debug.
1819: --enable_debug;
1820:
1821: -- Debug info.
1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1823: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',
1824: p_prefix=>l_debug_prefix,
1825: p_msg_level=>fnd_log.level_procedure);
1826: END IF;

Line 1825: p_msg_level=>fnd_log.level_procedure);

1821: -- Debug info.
1822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1823: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',
1824: p_prefix=>l_debug_prefix,
1825: p_msg_level=>fnd_log.level_procedure);
1826: END IF;
1827:
1828: -- initialize message list if p_init_msg_list is set to TRUE.
1829: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1891: p_count => x_msg_count,
1892: p_data => x_msg_data);
1893:
1894: -- Debug info.
1895: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1897: p_msg_data=>x_msg_data,
1898: p_msg_type=>'WARNING',
1899: p_msg_level=>fnd_log.level_exception);

Line 1899: p_msg_level=>fnd_log.level_exception);

1895: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1897: p_msg_data=>x_msg_data,
1898: p_msg_type=>'WARNING',
1899: p_msg_level=>fnd_log.level_exception);
1900: END IF;
1901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1903: p_prefix=>l_debug_prefix,

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

1897: p_msg_data=>x_msg_data,
1898: p_msg_type=>'WARNING',
1899: p_msg_level=>fnd_log.level_exception);
1900: END IF;
1901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1903: p_prefix=>l_debug_prefix,
1904: p_msg_level=>fnd_log.level_procedure);
1905: END IF;

Line 1904: p_msg_level=>fnd_log.level_procedure);

1900: END IF;
1901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1903: p_prefix=>l_debug_prefix,
1904: p_msg_level=>fnd_log.level_procedure);
1905: END IF;
1906:
1907: -- Check if API is called in debug mode. If yes, disable debug.
1908: --disable_debug;

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

1916: p_count => x_msg_count,
1917: p_data => x_msg_data);
1918:
1919: -- Debug info.
1920: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'ERROR',
1924: p_msg_level=>fnd_log.level_error);

Line 1924: p_msg_level=>fnd_log.level_error);

1920: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'ERROR',
1924: p_msg_level=>fnd_log.level_error);
1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1928: p_prefix=>l_debug_prefix,

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

1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'ERROR',
1924: p_msg_level=>fnd_log.level_error);
1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1928: p_prefix=>l_debug_prefix,
1929: p_msg_level=>fnd_log.level_procedure);
1930: END IF;

Line 1929: p_msg_level=>fnd_log.level_procedure);

1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1928: p_prefix=>l_debug_prefix,
1929: p_msg_level=>fnd_log.level_procedure);
1930: END IF;
1931:
1932: -- Check if API is called in debug mode. If yes, disable debug.
1933: --disable_debug;

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

1940: p_count => x_msg_count,
1941: p_data => x_msg_data);
1942:
1943: -- Debug info.
1944: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1945: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1946: p_msg_data=>x_msg_data,
1947: p_msg_type=>'UNEXPECTED ERROR',
1948: p_msg_level=>fnd_log.level_error);

Line 1948: p_msg_level=>fnd_log.level_error);

1944: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1945: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1946: p_msg_data=>x_msg_data,
1947: p_msg_type=>'UNEXPECTED ERROR',
1948: p_msg_level=>fnd_log.level_error);
1949: END IF;
1950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1951: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1952: p_prefix=>l_debug_prefix,

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

1946: p_msg_data=>x_msg_data,
1947: p_msg_type=>'UNEXPECTED ERROR',
1948: p_msg_level=>fnd_log.level_error);
1949: END IF;
1950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1951: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1952: p_prefix=>l_debug_prefix,
1953: p_msg_level=>fnd_log.level_procedure);
1954: END IF;

Line 1953: p_msg_level=>fnd_log.level_procedure);

1949: END IF;
1950: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1951: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1952: p_prefix=>l_debug_prefix,
1953: p_msg_level=>fnd_log.level_procedure);
1954: END IF;
1955:
1956: -- Check if API is called in debug mode. If yes, disable debug.
1957: --disable_debug;

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

1967: p_count => x_msg_count,
1968: p_data => x_msg_data);
1969:
1970: -- Debug info.
1971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1973: p_msg_data=>x_msg_data,
1974: p_msg_type=>'SQL ERROR',
1975: p_msg_level=>fnd_log.level_error);

Line 1975: p_msg_level=>fnd_log.level_error);

1971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1973: p_msg_data=>x_msg_data,
1974: p_msg_type=>'SQL ERROR',
1975: p_msg_level=>fnd_log.level_error);
1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1979: p_prefix=>l_debug_prefix,

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

1973: p_msg_data=>x_msg_data,
1974: p_msg_type=>'SQL ERROR',
1975: p_msg_level=>fnd_log.level_error);
1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;

Line 1980: p_msg_level=>fnd_log.level_procedure);

1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1982:
1983: -- Check if API is called in debug mode. If yes, disable debug.
1984: --disable_debug;