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;
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
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);
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,
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;
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
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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(
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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
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;
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;
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);
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,
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;
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
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);
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,
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;
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:
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);
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,
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;
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:
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);
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,
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;
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(
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;
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
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);
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
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;
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
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);
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,
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;
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:
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);
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,
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;
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:
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);
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,
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;
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: