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 356: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1062: end if;
1063:
1064: -- Debug info.
1065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1066: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1067: p_prefix=>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_procedure);
1069: END IF;
1070:

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

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

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

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

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

1163: --enable_debug;
1164:
1165: -- Debug info.
1166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1167: hz_utility_v2pub.debug(p_message=>'create_org_contact (+)',
1168: p_prefix=>l_debug_prefix,
1169: p_msg_level=>fnd_log.level_procedure);
1170: END IF;
1171:

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

1200: x_party_number
1201: );
1202:
1203: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1204: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1205: -- Invoke business event system.
1206: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (
1207: l_org_contact_rec );
1208: END IF;

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

1206: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (
1207: l_org_contact_rec );
1208: END IF;
1209:
1210: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1211: -- populate function for integration service
1212: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1213: p_operation => 'I',
1214: p_org_contact_id => x_org_contact_id);

Line 1232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

1382: --enable_debug;
1383:
1384: -- Debug info.
1385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1386: hz_utility_v2pub.debug(p_message=>'update_org_contact (+)',
1387: p_prefix=>l_debug_prefix,
1388: p_msg_level=>fnd_log.level_procedure);
1389: END IF;
1390:

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

1451: );
1452:
1453: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1454: l_old_org_contact_rec.orig_system := p_org_contact_rec.orig_system;
1455: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1456: -- Invoke business event system.
1457: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_event (
1458: l_org_contact_rec,
1459: l_old_org_contact_rec );

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

1458: l_org_contact_rec,
1459: l_old_org_contact_rec );
1460: END IF;
1461:
1462: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1463: -- populate function for integration service
1464: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1465: p_operation => 'U',
1466: p_org_contact_id => l_org_contact_rec.org_contact_id);

Line 1481: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1556: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

1622: --enable_debug;
1623:
1624: -- Debug info.
1625: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1626: hz_utility_v2pub.debug(p_message=>'create_org_contact_role (+)',
1627: p_prefix=>l_debug_prefix,
1628: p_msg_level=>fnd_log.level_procedure);
1629: END IF;
1630:

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

1644: );
1645:
1646: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1647: -- Invoke business event system.
1648: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1649: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_role_event (
1650: l_org_contact_role_rec );
1651: END IF;
1652:

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

1649: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_role_event (
1650: l_org_contact_role_rec );
1651: END IF;
1652:
1653: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1654: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1655: p_operation => 'I',
1656: p_org_contact_role_id => x_org_contact_role_id );
1657: END IF;

Line 1668: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1693: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1717: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1744: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

1811: --enable_debug;
1812:
1813: -- Debug info.
1814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1815: hz_utility_v2pub.debug(p_message=>'update_org_contact_role (+)',
1816: p_prefix=>l_debug_prefix,
1817: p_msg_level=>fnd_log.level_procedure);
1818: END IF;
1819:

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

1864:
1865: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1866: -- Invoke business event system.
1867: l_old_org_contact_role_rec.orig_system := p_org_contact_role_rec.orig_system;
1868: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1869: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_role_event (
1870: l_org_contact_role_rec , l_old_org_contact_role_rec );
1871: END IF;
1872:

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

1869: HZ_BUSINESS_EVENT_V2PVT.update_org_contact_role_event (
1870: l_org_contact_role_rec , l_old_org_contact_role_rec );
1871: END IF;
1872:
1873: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1874: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1875: p_operation => 'U',
1876: p_org_contact_role_id => l_org_contact_role_rec.org_contact_role_id );
1877: END IF;

Line 1888: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

Line 1964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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