DBA Data[Home] [Help]

APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 68: * HZ_UTILITY_V2PUB.enable_debug

64: * DESCRIPTION
65: * Turn on debug mode.
66: *
67: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
68: * HZ_UTILITY_V2PUB.enable_debug
69: *
70: * MODIFICATION HISTORY
71: *
72: * 07-23-2001 Jianying Huang o Created.

Line 86: HZ_UTILITY_V2PUB.enable_debug;

82: IF G_DEBUG_COUNT = 1 THEN
83: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
84: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
85: THEN
86: HZ_UTILITY_V2PUB.enable_debug;
87: G_DEBUG := TRUE;
88: END IF;
89: END IF;
90:

Line 102: * HZ_UTILITY_V2PUB.disable_debug

98: * DESCRIPTION
99: * Turn off debug mode.
100: *
101: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
102: * HZ_UTILITY_V2PUB.disable_debug
103: *
104: * MODIFICATION HISTORY
105: *
106: * 07-23-2001 Jianying Huang o Created.

Line 118: HZ_UTILITY_V2PUB.disable_debug;

114: IF G_DEBUG THEN
115: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
116:
117: IF G_DEBUG_COUNT = 0 THEN
118: HZ_UTILITY_V2PUB.disable_debug;
119: G_DEBUG := FALSE;
120: END IF;
121: END IF;
122:

Line 192: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (+)',

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;
196:

Line 359: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',

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;
363:

Line 413: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',

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;
417:

Line 446: hz_utility_v2pub.debug(p_message=>'do_create_org_contact (-)',

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;
450:

Line 508: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',

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;
512:

Line 653: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',

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;
657: -- call to table-handler

Line 706: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',

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;
710:

Line 762: hz_utility_v2pub.debug(p_message=>'do_update_org_contact (-)',

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;
766:

Line 815: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (+)',

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;
819:

Line 902: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',

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;
906:

Line 926: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||

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);
930: END IF;

Line 961: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_role (-)',

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;
965:

Line 1011: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (+)',

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;
1015:

Line 1071: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',

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;
1075:

Line 1094: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',

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;
1098:

Line 1101: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_role (-)',

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;
1105:

Line 1172: hz_utility_v2pub.debug(p_message=>'create_org_contact (+)',

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;
1176:

Line 1209: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1205: x_party_number
1206: );
1207:
1208: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1209: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1210: -- Invoke business event system.
1211: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (
1212: l_org_contact_rec );
1213: END IF;

Line 1215: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1211: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (
1212: l_org_contact_rec );
1213: END IF;
1214:
1215: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1216: -- populate function for integration service
1217: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1218: p_operation => 'I',
1219: p_org_contact_id => x_org_contact_id);

Line 1240: hz_utility_v2pub.debug_return_messages(p_msg_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);
1244: END IF;

Line 1246: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',

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;
1250:

Line 1265: hz_utility_v2pub.debug_return_messages(p_msg_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);
1269: END IF;

Line 1271: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',

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;
1275:

Line 1290: hz_utility_v2pub.debug_return_messages(p_msg_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);
1294: END IF;

Line 1296: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',

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;
1300:

Line 1317: hz_utility_v2pub.debug_return_messages(p_msg_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);
1321: END IF;

Line 1323: hz_utility_v2pub.debug(p_message=>'create_org_contact (-)',

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;
1327:

Line 1394: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',

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;
1398:

Line 1463: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1459: );
1460:
1461: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1462: l_old_org_contact_rec.orig_system := p_org_contact_rec.orig_system;
1463: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1464: -- Invoke business event system.
1465: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_event (
1466: l_org_contact_rec,
1467: l_old_org_contact_rec );

Line 1470: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1466: l_org_contact_rec,
1467: l_old_org_contact_rec );
1468: END IF;
1469:
1470: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1471: -- populate function for integration service
1472: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1473: p_operation => 'U',
1474: p_org_contact_id => l_org_contact_rec.org_contact_id);

Line 1489: hz_utility_v2pub.debug_return_messages(p_msg_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);
1493: END IF;

Line 1495: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',

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;
1499:

Line 1513: hz_utility_v2pub.debug_return_messages(p_msg_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);
1517: END IF;

Line 1519: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',

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;
1523:

Line 1537: hz_utility_v2pub.debug_return_messages(p_msg_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);
1541: END IF;

Line 1543: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',

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;
1547:

Line 1564: hz_utility_v2pub.debug_return_messages(p_msg_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);
1568: END IF;

Line 1570: hz_utility_v2pub.debug(p_message=>'update_org_contact (-)',

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;
1574:

Line 1634: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',

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;
1638:

Line 1656: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1652: );
1653:
1654: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1655: -- Invoke business event system.
1656: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1657: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_role_event (
1658: l_org_contact_role_rec );
1659: END IF;
1660:

Line 1661: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1657: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_role_event (
1658: l_org_contact_role_rec );
1659: END IF;
1660:
1661: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1662: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1663: p_operation => 'I',
1664: p_org_contact_role_id => x_org_contact_role_id );
1665: END IF;

Line 1676: hz_utility_v2pub.debug_return_messages(p_msg_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);
1680: END IF;

Line 1682: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',

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;
1686:

Line 1701: hz_utility_v2pub.debug_return_messages(p_msg_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);
1705: END IF;

Line 1707: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',

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;
1711:

Line 1725: hz_utility_v2pub.debug_return_messages(p_msg_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);
1729: END IF;

Line 1731: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',

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;
1735:

Line 1752: hz_utility_v2pub.debug_return_messages(p_msg_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);
1756: END IF;

Line 1758: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (-)',

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;
1762:

Line 1823: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',

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;
1827:

Line 1876: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

1872:
1873: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1874: -- Invoke business event system.
1875: l_old_org_contact_role_rec.orig_system := p_org_contact_role_rec.orig_system;
1876: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1877: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_role_event (
1878: l_org_contact_role_rec , l_old_org_contact_role_rec );
1879: END IF;
1880:

Line 1881: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1877: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_role_event (
1878: l_org_contact_role_rec , l_old_org_contact_role_rec );
1879: END IF;
1880:
1881: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1882: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1883: p_operation => 'U',
1884: p_org_contact_role_id => l_org_contact_role_rec.org_contact_role_id );
1885: END IF;

Line 1896: hz_utility_v2pub.debug_return_messages(p_msg_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);
1900: END IF;

Line 1902: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',

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;
1906:

Line 1921: hz_utility_v2pub.debug_return_messages(p_msg_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);
1925: END IF;

Line 1927: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',

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;
1931:

Line 1945: hz_utility_v2pub.debug_return_messages(p_msg_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);
1949: END IF;

Line 1951: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',

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;
1955:

Line 1972: hz_utility_v2pub.debug_return_messages(p_msg_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);
1976: END IF;

Line 1978: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (-)',

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;
1982: