DBA Data[Home] [Help]

APPS.HZ_ORG_CONTACT_BO_PUB dependencies on FND_LOG

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

357: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
358: END IF;
359:
360: -- Debug info.
361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
362: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(+)',
363: p_prefix=>l_debug_prefix,
364: p_msg_level=>fnd_log.level_procedure);
365: END IF;

Line 364: p_msg_level=>fnd_log.level_procedure);

360: -- Debug info.
361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
362: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(+)',
363: p_prefix=>l_debug_prefix,
364: p_msg_level=>fnd_log.level_procedure);
365: END IF;
366:
367: -- Base on p_validate_bo_flag check completeness of business object
368: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

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

623: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
624: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
625:
626: -- Debug info.
627: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
629: p_msg_data=>x_msg_data,
630: p_msg_type=>'WARNING',
631: p_msg_level=>fnd_log.level_exception);

Line 631: p_msg_level=>fnd_log.level_exception);

627: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
629: p_msg_data=>x_msg_data,
630: p_msg_type=>'WARNING',
631: p_msg_level=>fnd_log.level_exception);
632: END IF;
633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
635: p_prefix=>l_debug_prefix,

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

629: p_msg_data=>x_msg_data,
630: p_msg_type=>'WARNING',
631: p_msg_level=>fnd_log.level_exception);
632: END IF;
633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
635: p_prefix=>l_debug_prefix,
636: p_msg_level=>fnd_log.level_procedure);
637: END IF;

Line 636: p_msg_level=>fnd_log.level_procedure);

632: END IF;
633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
635: p_prefix=>l_debug_prefix,
636: p_msg_level=>fnd_log.level_procedure);
637: END IF;
638:
639: EXCEPTION
640: WHEN fnd_api.g_exc_error THEN

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

654: p_count => x_msg_count,
655: p_data => x_msg_data);
656:
657: -- Debug info.
658: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
660: p_msg_data=>x_msg_data,
661: p_msg_type=>'ERROR',
662: p_msg_level=>fnd_log.level_error);

Line 662: p_msg_level=>fnd_log.level_error);

658: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
660: p_msg_data=>x_msg_data,
661: p_msg_type=>'ERROR',
662: p_msg_level=>fnd_log.level_error);
663: END IF;
664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
666: p_prefix=>l_debug_prefix,

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

660: p_msg_data=>x_msg_data,
661: p_msg_type=>'ERROR',
662: p_msg_level=>fnd_log.level_error);
663: END IF;
664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
666: p_prefix=>l_debug_prefix,
667: p_msg_level=>fnd_log.level_procedure);
668: END IF;

Line 667: p_msg_level=>fnd_log.level_procedure);

663: END IF;
664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
666: p_prefix=>l_debug_prefix,
667: p_msg_level=>fnd_log.level_procedure);
668: END IF;
669:
670: WHEN fnd_api.g_exc_unexpected_error THEN
671: ROLLBACK TO do_create_org_contact_bo_pub;

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

684: p_count => x_msg_count,
685: p_data => x_msg_data);
686:
687: -- Debug info.
688: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
690: p_msg_data=>x_msg_data,
691: p_msg_type=>'UNEXPECTED ERROR',
692: p_msg_level=>fnd_log.level_error);

Line 692: p_msg_level=>fnd_log.level_error);

688: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
690: p_msg_data=>x_msg_data,
691: p_msg_type=>'UNEXPECTED ERROR',
692: p_msg_level=>fnd_log.level_error);
693: END IF;
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
696: p_prefix=>l_debug_prefix,

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

690: p_msg_data=>x_msg_data,
691: p_msg_type=>'UNEXPECTED ERROR',
692: p_msg_level=>fnd_log.level_error);
693: END IF;
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
696: p_prefix=>l_debug_prefix,
697: p_msg_level=>fnd_log.level_procedure);
698: END IF;

Line 697: p_msg_level=>fnd_log.level_procedure);

693: END IF;
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
696: p_prefix=>l_debug_prefix,
697: p_msg_level=>fnd_log.level_procedure);
698: END IF;
699:
700: WHEN OTHERS THEN
701: ROLLBACK TO do_create_org_contact_bo_pub;

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

718: p_count => x_msg_count,
719: p_data => x_msg_data);
720:
721: -- Debug info.
722: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
724: p_msg_data=>x_msg_data,
725: p_msg_type=>'SQL ERROR',
726: p_msg_level=>fnd_log.level_error);

Line 726: p_msg_level=>fnd_log.level_error);

722: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
724: p_msg_data=>x_msg_data,
725: p_msg_type=>'SQL ERROR',
726: p_msg_level=>fnd_log.level_error);
727: END IF;
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
730: p_prefix=>l_debug_prefix,

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

724: p_msg_data=>x_msg_data,
725: p_msg_type=>'SQL ERROR',
726: p_msg_level=>fnd_log.level_error);
727: END IF;
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;

Line 731: p_msg_level=>fnd_log.level_procedure);

727: END IF;
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;
733: END do_create_org_contact_bo;
734:
735: PROCEDURE create_org_contact_bo(

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

963: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
964: END IF;
965:
966: -- Debug info.
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(+)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;

Line 970: p_msg_level=>fnd_log.level_procedure);

966: -- Debug info.
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(+)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;
972:
973: x_org_contact_id := p_org_contact_obj.org_contact_id;
974: x_org_contact_os := p_org_contact_obj.orig_system;

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

1205: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1206: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1207:
1208: -- Debug info.
1209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1211: p_msg_data=>x_msg_data,
1212: p_msg_type=>'WARNING',
1213: p_msg_level=>fnd_log.level_exception);

Line 1213: p_msg_level=>fnd_log.level_exception);

1209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1211: p_msg_data=>x_msg_data,
1212: p_msg_type=>'WARNING',
1213: p_msg_level=>fnd_log.level_exception);
1214: END IF;
1215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1217: p_prefix=>l_debug_prefix,

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

1211: p_msg_data=>x_msg_data,
1212: p_msg_type=>'WARNING',
1213: p_msg_level=>fnd_log.level_exception);
1214: END IF;
1215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1217: p_prefix=>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_procedure);
1219: END IF;

Line 1218: p_msg_level=>fnd_log.level_procedure);

1214: END IF;
1215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1217: p_prefix=>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_procedure);
1219: END IF;
1220: EXCEPTION
1221: WHEN fnd_api.g_exc_error THEN
1222: ROLLBACK TO do_update_org_contact_bo_pub;

Line 1239: IF fnd_log.level_error>=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_error>=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=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);

Line 1243: p_msg_level=>fnd_log.level_error);

1239: IF fnd_log.level_error>=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=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
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=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
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=>'do_update_org_contact_bo(-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:
1251: WHEN fnd_api.g_exc_unexpected_error THEN
1252: ROLLBACK TO do_update_org_contact_bo_pub;

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

1265: p_count => x_msg_count,
1266: p_data => x_msg_data);
1267:
1268: -- Debug info.
1269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1271: p_msg_data=>x_msg_data,
1272: p_msg_type=>'UNEXPECTED ERROR',
1273: p_msg_level=>fnd_log.level_error);

Line 1273: p_msg_level=>fnd_log.level_error);

1269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1271: p_msg_data=>x_msg_data,
1272: p_msg_type=>'UNEXPECTED ERROR',
1273: p_msg_level=>fnd_log.level_error);
1274: END IF;
1275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1276: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1277: p_prefix=>l_debug_prefix,

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

1271: p_msg_data=>x_msg_data,
1272: p_msg_type=>'UNEXPECTED ERROR',
1273: p_msg_level=>fnd_log.level_error);
1274: END IF;
1275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1276: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1277: p_prefix=>l_debug_prefix,
1278: p_msg_level=>fnd_log.level_procedure);
1279: END IF;

Line 1278: p_msg_level=>fnd_log.level_procedure);

1274: END IF;
1275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1276: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1277: p_prefix=>l_debug_prefix,
1278: p_msg_level=>fnd_log.level_procedure);
1279: END IF;
1280:
1281: WHEN OTHERS THEN
1282: ROLLBACK TO do_update_org_contact_bo_pub;

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

1299: p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: -- Debug info.
1303: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1305: p_msg_data=>x_msg_data,
1306: p_msg_type=>'SQL ERROR',
1307: p_msg_level=>fnd_log.level_error);

Line 1307: p_msg_level=>fnd_log.level_error);

1303: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1305: p_msg_data=>x_msg_data,
1306: p_msg_type=>'SQL ERROR',
1307: p_msg_level=>fnd_log.level_error);
1308: END IF;
1309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1311: p_prefix=>l_debug_prefix,

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

1305: p_msg_data=>x_msg_data,
1306: p_msg_type=>'SQL ERROR',
1307: p_msg_level=>fnd_log.level_error);
1308: END IF;
1309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1311: p_prefix=>l_debug_prefix,
1312: p_msg_level=>fnd_log.level_procedure);
1313: END IF;

Line 1312: p_msg_level=>fnd_log.level_procedure);

1308: END IF;
1309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1311: p_prefix=>l_debug_prefix,
1312: p_msg_level=>fnd_log.level_procedure);
1313: END IF;
1314: END do_update_org_contact_bo;
1315:
1316: -- PROCEDURE do_save_org_contact_bo

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

1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:
1350: -- Debug info.
1351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1352: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(+)',
1353: p_prefix=>l_debug_prefix,
1354: p_msg_level=>fnd_log.level_procedure);
1355: END IF;

Line 1354: p_msg_level=>fnd_log.level_procedure);

1350: -- Debug info.
1351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1352: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(+)',
1353: p_prefix=>l_debug_prefix,
1354: p_msg_level=>fnd_log.level_procedure);
1355: END IF;
1356:
1357: x_org_contact_id := p_org_contact_obj.org_contact_id;
1358: x_org_contact_os := p_org_contact_obj.orig_system;

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

1410: RAISE FND_API.G_EXC_ERROR;
1411: END IF;
1412:
1413: -- Debug info.
1414: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1416: p_msg_data=>x_msg_data,
1417: p_msg_type=>'WARNING',
1418: p_msg_level=>fnd_log.level_exception);

Line 1418: p_msg_level=>fnd_log.level_exception);

1414: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1416: p_msg_data=>x_msg_data,
1417: p_msg_type=>'WARNING',
1418: p_msg_level=>fnd_log.level_exception);
1419: END IF;
1420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1421: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1422: p_prefix=>l_debug_prefix,

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

1416: p_msg_data=>x_msg_data,
1417: p_msg_type=>'WARNING',
1418: p_msg_level=>fnd_log.level_exception);
1419: END IF;
1420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1421: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1422: p_prefix=>l_debug_prefix,
1423: p_msg_level=>fnd_log.level_procedure);
1424: END IF;

Line 1423: p_msg_level=>fnd_log.level_procedure);

1419: END IF;
1420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1421: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1422: p_prefix=>l_debug_prefix,
1423: p_msg_level=>fnd_log.level_procedure);
1424: END IF;
1425:
1426: EXCEPTION
1427: WHEN fnd_api.g_exc_error THEN

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

1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: -- Debug info.
1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);

Line 1439: p_msg_level=>fnd_log.level_error);

1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1443: p_prefix=>l_debug_prefix,

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

1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;

Line 1444: p_msg_level=>fnd_log.level_procedure);

1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448:

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

1450: p_count => x_msg_count,
1451: p_data => x_msg_data);
1452:
1453: -- Debug info.
1454: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1455: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1456: p_msg_data=>x_msg_data,
1457: p_msg_type=>'UNEXPECTED ERROR',
1458: p_msg_level=>fnd_log.level_error);

Line 1458: p_msg_level=>fnd_log.level_error);

1454: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1455: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1456: p_msg_data=>x_msg_data,
1457: p_msg_type=>'UNEXPECTED ERROR',
1458: p_msg_level=>fnd_log.level_error);
1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1462: p_prefix=>l_debug_prefix,

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

1456: p_msg_data=>x_msg_data,
1457: p_msg_type=>'UNEXPECTED ERROR',
1458: p_msg_level=>fnd_log.level_error);
1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;

Line 1463: p_msg_level=>fnd_log.level_procedure);

1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;
1465: WHEN OTHERS THEN
1466: x_return_status := fnd_api.g_ret_sts_unexp_error;
1467:

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

1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.
1477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'SQL ERROR',
1481: p_msg_level=>fnd_log.level_error);

Line 1481: p_msg_level=>fnd_log.level_error);

1477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'SQL ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1485: p_prefix=>l_debug_prefix,

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

1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'SQL ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;

Line 1486: p_msg_level=>fnd_log.level_procedure);

1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;
1488: END do_save_org_contact_bo;
1489:
1490: PROCEDURE save_org_contact_bo(

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

1630: END IF;
1631:
1632:
1633: -- Debug info.
1634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',
1636: p_prefix=>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_procedure);
1638: END IF;

Line 1637: p_msg_level=>fnd_log.level_procedure);

1633: -- Debug info.
1634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',
1636: p_prefix=>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_procedure);
1638: END IF;
1639:
1640: -- check if pass in contact_point_id and/or os+osr
1641: -- extraction validation logic is same as update

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

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

Line 1681: p_msg_level=>fnd_log.level_exception);

1677: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1679: p_msg_data=>x_msg_data,
1680: p_msg_type=>'WARNING',
1681: p_msg_level=>fnd_log.level_exception);
1682: END IF;
1683:
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1681: p_msg_level=>fnd_log.level_exception);
1682: END IF;
1683:
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;

Line 1688: p_msg_level=>fnd_log.level_procedure);

1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690:
1691:
1692: EXCEPTION

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

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

Line 1706: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1711: p_msg_level=>fnd_log.level_procedure);

1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN
1714: x_return_status := fnd_api.g_ret_sts_unexp_error;
1715:

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

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

Line 1725: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1730: p_msg_level=>fnd_log.level_procedure);

1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732: WHEN OTHERS THEN
1733: x_return_status := fnd_api.g_ret_sts_unexp_error;
1734:

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

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

Line 1748: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1753: p_msg_level=>fnd_log.level_procedure);

1749: END IF;
1750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1751: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1752: p_prefix=>l_debug_prefix,
1753: p_msg_level=>fnd_log.level_procedure);
1754: END IF;
1755:
1756: end;
1757: