eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 247: * HZ_UTILITY_V2PUB.enable_debug

243: * DESCRIPTION
244: * Turn on debug mode.
245: *
246: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
247: * HZ_UTILITY_V2PUB.enable_debug
248: *
249: * MODIFICATION HISTORY
250: *
251: * 07-23-2001 Jianying Huang o Created.

Line 265: HZ_UTILITY_V2PUB.enable_debug;

261: IF G_DEBUG_COUNT = 1 THEN
262: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
263: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
264: THEN
265: HZ_UTILITY_V2PUB.enable_debug;
266: G_DEBUG := TRUE;
267: END IF;
268: END IF;
269:

Line 280: * HZ_UTILITY_V2PUB.disable_debug

276: * DESCRIPTION
277: * Turn off debug mode.
278: *
279: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
280: * HZ_UTILITY_V2PUB.disable_debug
281: *
282: * MODIFICATION HISTORY
283: *
284: * 07-23-2001 Jianying Huang o Created.

Line 296: HZ_UTILITY_V2PUB.disable_debug;

292: IF G_DEBUG THEN
293: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
294:
295: IF G_DEBUG_COUNT = 0 THEN
296: HZ_UTILITY_V2PUB.disable_debug;
297: G_DEBUG := FALSE;
298: END IF;
299: END IF;
300:

Line 414: hz_utility_v2pub.debug(p_message=>'do_create_rel (+)',

410: BEGIN
411:
412: -- Debug info.
413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug(p_message=>'do_create_rel (+)',
415: p_prefix=>l_debug_prefix,
416: p_msg_level=>fnd_log.level_procedure);
417: END IF;
418:

Line 469: hz_utility_v2pub.debug(p_message=>'Obtained relationship_id : '||x_relationship_id,

465: x_relationship_id := l_relationship_id;
466:
467: -- Debug info.
468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'Obtained relationship_id : '||x_relationship_id,
470: p_prefix =>l_debug_prefix,
471: p_msg_level=>fnd_log.level_statement);
472: END IF;
473:

Line 513: hz_utility_v2pub.debug(p_message=>'relationship type record found',

509: END IF;
510:
511: -- Debug info.
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: hz_utility_v2pub.debug(p_message=>'relationship type record found',
514: p_prefix =>l_debug_prefix,
515: p_msg_level=>fnd_log.level_statement);
516: END IF;
517:

Line 642: hz_utility_v2pub.debug(p_message=>'creating relationship party',

638: THEN
639:
640: -- Debug info.
641: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'creating relationship party',
643: p_prefix =>l_debug_prefix,
644: p_msg_level=>fnd_log.level_statement);
645: END IF;
646:

Line 696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',

692: THEN
693:
694: -- Debug info.
695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;
700:

Line 711: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',

707: p_relationship_rec.relationship_id := l_relationship_id;
708:
709: -- Debug info.
710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
711: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',
712: p_prefix=>l_debug_prefix,
713: p_msg_level=>fnd_log.level_procedure);
714: END IF;
715:

Line 795: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||

791: );
792:
793: -- Debug info.
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||
796: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
797: p_prefix=>l_debug_prefix,
798: p_msg_level=>fnd_log.level_procedure);
799: END IF;

Line 803: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',

799: END IF;
800:
801: -- Debug info.
802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',
804: p_prefix=>l_debug_prefix,
805: p_msg_level=>fnd_log.level_procedure);
806: END IF;
807:

Line 898: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||

894: );
895:
896: -- Debug info.
897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||
899: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
900: p_prefix=>l_debug_prefix,
901: p_msg_level=>fnd_log.level_procedure);
902: END IF;

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

1043: X_APPLICATION_ID => p_org_contact_rec.application_id,
1044: X_STATUS => p_org_contact_rec.party_rel_rec.status
1045: );
1046:
1047: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1048: -- Invoke business event system.
1049: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (p_org_contact_rec);
1050: END IF;
1051:

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

1048: -- Invoke business event system.
1049: HZ_BUSINESS_EVENT_V2PVT.create_org_contact_event (p_org_contact_rec);
1050: END IF;
1051:
1052: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1053: IF(p_relationship_rec.subject_type = 'PERSON' AND p_relationship_rec.object_type = 'ORGANIZATION') THEN
1054: HZ_POPULATE_BOT_PKG.pop_hz_org_contacts(
1055: p_operation => 'I',
1056: p_org_contact_id => p_org_contact_rec.org_contact_id);

Line 1179: hz_utility_v2pub.debug(p_message=>'do_create_rel (-)',

1175: END IF;
1176:
1177: -- Debug info.
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'do_create_rel (-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;
1183:

Line 1290: hz_utility_v2pub.debug(p_message=>'do_update_rel (+)',

1286: BEGIN
1287:
1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'do_update_rel (+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:

Line 1447: hz_utility_v2pub.debug(p_message=>'Done with locking',

1443: END;
1444:
1445: -- Debug info.
1446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'Done with locking',
1448: p_prefix =>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_statement);
1450: END IF;
1451:

Line 1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',

1654: THEN
1655:
1656: -- Debug info.
1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1659: p_prefix =>l_debug_prefix,
1660: p_msg_level=>fnd_log.level_statement);
1661: END IF;
1662:

Line 1669: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',

1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:

Line 1675: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:
1674: -- Bug 4693719 : pass NULL if the secure data is not updated
1675: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
1676: l_acs := nvl(p_relationship_rec.actual_content_source, 'USER_ENTERED');
1677: ELSE
1678: l_acs := NULL;
1679: END IF;

Line 1775: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',

1771: );
1772:
1773: -- Debug info.
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1776: p_prefix=>l_debug_prefix,
1777: p_msg_level=>fnd_log.level_procedure);
1778: END IF;
1779:

Line 1793: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',

1789: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1790:
1791: -- Debug info.
1792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1793: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_procedure);
1796: END IF;
1797:

Line 1878: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',

1874: );
1875:
1876: -- Debug info.
1877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1878: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1879: p_prefix=>l_debug_prefix,
1880: p_msg_level=>fnd_log.level_procedure);
1881: END IF;
1882:

Line 1911: hz_utility_v2pub.debug(p_message=>'updating party record',

1907: IF l_party_id IS NOT NULL THEN
1908:
1909: -- Debug info.
1910: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1911: hz_utility_v2pub.debug(p_message=>'updating party record',
1912: p_prefix =>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_statement);
1914: END IF;
1915:

Line 2059: hz_utility_v2pub.debug(p_message=>'do_update_rel (-)',

2055: END IF;
2056:
2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_update_rel (-)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;
2063:

Line 2243: hz_utility_v2pub.debug(p_message=>'do_create_party (+)',

2239: BEGIN
2240:
2241: -- Debug info.
2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2243: hz_utility_v2pub.debug(p_message=>'do_create_party (+)',
2244: p_prefix=>l_debug_prefix,
2245: p_msg_level=>fnd_log.level_procedure);
2246: END IF;
2247:

Line 2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',

2367: END IF;
2368:
2369: -- Debug info.
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:

Line 2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||

2464: x_party_number := l_party_rec.party_number;
2465:
2466: -- Debug info.
2467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2469: 'x_party_id = ' || x_party_id,
2470: p_prefix=>l_debug_prefix,
2471: p_msg_level=>fnd_log.level_procedure);
2472: END IF;

Line 2483: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',

2479: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
2480:
2481: -- Debug info.
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',
2484: p_prefix=>l_debug_prefix,
2485: p_msg_level=>fnd_log.level_procedure);
2486: END IF;
2487:

Line 2552: hz_utility_v2pub.debug(p_message=>'do_update_party (+)',

2548: BEGIN
2549:
2550: -- Debug info.
2551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2552: hz_utility_v2pub.debug(p_message=>'do_update_party (+)',
2553: p_prefix=>l_debug_prefix,
2554: p_msg_level=>fnd_log.level_procedure);
2555: END IF;
2556:

Line 2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',

2609: END IF;
2610:
2611: -- Debug info.
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617:

Line 2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',

2706: );
2707:
2708: -- Debug info.
2709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2711: p_prefix=>l_debug_prefix,
2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;
2714:

Line 2717: hz_utility_v2pub.debug(p_message=>'do_update_party (-)',

2713: END IF;
2714:
2715: -- Debug info.
2716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2717: hz_utility_v2pub.debug(p_message=>'do_update_party (-)',
2718: p_prefix=>l_debug_prefix,
2719: p_msg_level=>fnd_log.level_procedure);
2720: END IF;
2721:

Line 2936: hz_utility_v2pub.debug(p_message=>'create_relationship (+)',

2932: --enable_debug;
2933:
2934: -- Debug info.
2935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2936: hz_utility_v2pub.debug(p_message=>'create_relationship (+)',
2937: p_prefix=>l_debug_prefix,
2938: p_msg_level=>fnd_log.level_procedure);
2939: END IF;
2940:

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

3041: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
3042: -- Bug 2197181: Added below condition for Mix-n-Match
3043: g_rel_is_datasource_selected = 'Y' */
3044: THEN
3045: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
3046: HZ_BUSINESS_EVENT_V2PVT.create_relationship_event (
3047: l_rel_rec, l_created_party );
3048: END IF;
3049:

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

3046: HZ_BUSINESS_EVENT_V2PVT.create_relationship_event (
3047: l_rel_rec, l_created_party );
3048: END IF;
3049:
3050: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3051: -- populate function for integration service
3052: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3053: p_operation => 'I',
3054: p_RELATIONSHIP_ID => x_relationship_id );

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

3062: p_data => x_msg_data);
3063:
3064: -- Debug info.
3065: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3066: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3067: p_msg_data=>x_msg_data,
3068: p_msg_type=>'WARNING',
3069: p_msg_level=>fnd_log.level_exception);
3070: END IF;

Line 3072: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

3068: p_msg_type=>'WARNING',
3069: p_msg_level=>fnd_log.level_exception);
3070: END IF;
3071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3073: p_prefix=>l_debug_prefix,
3074: p_msg_level=>fnd_log.level_procedure);
3075: END IF;
3076:

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

3087: p_data => x_msg_data);
3088:
3089: -- Debug info.
3090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3092: p_msg_data=>x_msg_data,
3093: p_msg_type=>'ERROR',
3094: p_msg_level=>fnd_log.level_error);
3095:

Line 3098: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

3094: p_msg_level=>fnd_log.level_error);
3095:
3096: END IF;
3097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3098: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3099: p_prefix=>l_debug_prefix,
3100: p_msg_level=>fnd_log.level_procedure);
3101: END IF;
3102:

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

3112: p_data => x_msg_data);
3113:
3114: -- Debug info.
3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'UNEXPECTED ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120:

Line 3123: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

3119: p_msg_level=>fnd_log.level_error);
3120:
3121: END IF;
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;
3127:

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

3140: p_data => x_msg_data);
3141:
3142: -- Debug info.
3143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3145: p_msg_data=>x_msg_data,
3146: p_msg_type=>'SQL ERROR',
3147: p_msg_level=>fnd_log.level_error);
3148:

Line 3151: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

3147: p_msg_level=>fnd_log.level_error);
3148:
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;
3155:

Line 3223: hz_utility_v2pub.debug(p_message=>'update_relationship (+)',

3219: --enable_debug;
3220:
3221: -- Debug info.
3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3223: hz_utility_v2pub.debug(p_message=>'update_relationship (+)',
3224: p_prefix=>l_debug_prefix,
3225: p_msg_level=>fnd_log.level_procedure);
3226: END IF;
3227:

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

3328: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
3329: -- Bug 2197181: Added below condition for Mix-n-Match
3330: g_rel_is_datasource_selected = 'Y' */
3331: THEN
3332: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
3333: HZ_BUSINESS_EVENT_V2PVT.update_relationship_event (
3334: l_rel_rec, l_old_rel_rec );
3335: END IF;
3336:

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

3333: HZ_BUSINESS_EVENT_V2PVT.update_relationship_event (
3334: l_rel_rec, l_old_rel_rec );
3335: END IF;
3336:
3337: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3338: -- populate function for integration service
3339: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3340: p_operation => 'U',
3341: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );

Line 3345: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3341: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );
3342: END IF;
3343: END IF;
3344:
3345: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3346: -- Standard call to get message count and if count is 1, get message info.
3347: FND_MSG_PUB.Count_And_Get(
3348: p_encoded => FND_API.G_FALSE,
3349: p_count => x_msg_count,

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

3350: p_data => x_msg_data);
3351:
3352: -- Debug info.
3353: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3355: p_msg_data=>x_msg_data,
3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;

Line 3360: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3361: p_prefix=>l_debug_prefix,
3362: p_msg_level=>fnd_log.level_procedure);
3363: END IF;
3364:

Line 3371: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3367:
3368: EXCEPTION
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: ROLLBACK TO update_relationship;
3371: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: FND_MSG_PUB.Count_And_Get(
3374: p_encoded => FND_API.G_FALSE,
3375: p_count => x_msg_count,

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

3376: p_data => x_msg_data);
3377:
3378: -- Debug info.
3379: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3381: p_msg_data=>x_msg_data,
3382: p_msg_type=>'ERROR',
3383: p_msg_level=>fnd_log.level_error);
3384:

Line 3387: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

3383: p_msg_level=>fnd_log.level_error);
3384:
3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3388: p_prefix=>l_debug_prefix,
3389: p_msg_level=>fnd_log.level_procedure);
3390: END IF;
3391:

Line 3397: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3393: --disable_debug;
3394:
3395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3396: ROLLBACK TO update_relationship;
3397: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3399: FND_MSG_PUB.Count_And_Get(
3400: p_encoded => FND_API.G_FALSE,
3401: p_count => x_msg_count,

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

3402: p_data => x_msg_data);
3403:
3404: -- Debug info.
3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);
3410:

Line 3413: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

3409: p_msg_level=>fnd_log.level_error);
3410:
3411: END IF;
3412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3414: p_prefix=>l_debug_prefix,
3415: p_msg_level=>fnd_log.level_procedure);
3416: END IF;
3417:

Line 3423: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3419: --disable_debug;
3420:
3421: WHEN OTHERS THEN
3422: ROLLBACK TO update_relationship;
3423: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3427: FND_MSG_PUB.ADD;

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

3431: p_data => x_msg_data);
3432:
3433: -- Debug info.
3434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3436: p_msg_data=>x_msg_data,
3437: p_msg_type=>'SQL ERROR',
3438: p_msg_level=>fnd_log.level_error);
3439:

Line 3442: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

3438: p_msg_level=>fnd_log.level_error);
3439:
3440: END IF;
3441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3443: p_prefix=>l_debug_prefix,
3444: p_msg_level=>fnd_log.level_procedure);
3445: END IF;
3446: -- Check if API is called in debug mode. If yes, disable debug.

Line 3501: hz_utility_v2pub.debug(p_message=>'get_relationship_rec (+)',

3497: --enable_debug;
3498:
3499: -- Debug info.
3500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3501: hz_utility_v2pub.debug(p_message=>'get_relationship_rec (+)',
3502: p_prefix=>l_debug_prefix,
3503: p_msg_level=>fnd_log.level_procedure);
3504: END IF;
3505:

Line 3536: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',

3532: END IF;
3533:
3534: -- Debug info.
3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3537: p_prefix =>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_statement);
3539: END IF;
3540:

Line 3618: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_V2PUB.get_party_rec',

3614: );
3615:
3616: -- Debug info.
3617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3618: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_V2PUB.get_party_rec',
3619: p_prefix =>l_debug_prefix,
3620: p_msg_level=>fnd_log.level_statement);
3621: END IF;
3622:

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

3646: p_data => x_msg_data );
3647:
3648: -- Debug info.
3649: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3650: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3651: p_msg_data=>x_msg_data,
3652: p_msg_type=>'WARNING',
3653: p_msg_level=>fnd_log.level_exception);
3654: END IF;

Line 3656: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',

3652: p_msg_type=>'WARNING',
3653: p_msg_level=>fnd_log.level_exception);
3654: END IF;
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3656: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',
3657: p_prefix=>l_debug_prefix,
3658: p_msg_level=>fnd_log.level_procedure);
3659: END IF;
3660:

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

3671: p_data => x_msg_data );
3672:
3673: -- Debug info.
3674: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3675: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3676: p_msg_data=>x_msg_data,
3677: p_msg_type=>'ERROR',
3678: p_msg_level=>fnd_log.level_error);
3679:

Line 3682: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',

3678: p_msg_level=>fnd_log.level_error);
3679:
3680: END IF;
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3683: p_prefix=>l_debug_prefix,
3684: p_msg_level=>fnd_log.level_procedure);
3685: END IF;
3686:

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

3696: p_data => x_msg_data );
3697:
3698: -- Debug info.
3699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3701: p_msg_data=>x_msg_data,
3702: p_msg_type=>'UNEXPECTED ERROR',
3703: p_msg_level=>fnd_log.level_error);
3704:

Line 3707: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',

3703: p_msg_level=>fnd_log.level_error);
3704:
3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3708: p_prefix=>l_debug_prefix,
3709: p_msg_level=>fnd_log.level_procedure);
3710: END IF;
3711:

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

3725: p_data => x_msg_data );
3726:
3727: -- Debug info.
3728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3730: p_msg_data=>x_msg_data,
3731: p_msg_type=>'SQL ERROR',
3732: p_msg_level=>fnd_log.level_error);
3733:

Line 3736: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,

3732: p_msg_level=>fnd_log.level_error);
3733:
3734: END IF;
3735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,
3737: p_prefix=>l_debug_prefix,
3738: p_msg_level=>fnd_log.level_procedure);
3739: END IF;
3740: