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 644: hz_utility_v2pub.debug(p_message=>'creating relationship party',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1292: BEGIN
1293:
1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'do_update_rel (+)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;
1300:

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

1449: END;
1450:
1451: -- Debug info.
1452: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1453: hz_utility_v2pub.debug(p_message=>'Done with locking',
1454: p_prefix =>l_debug_prefix,
1455: p_msg_level=>fnd_log.level_statement);
1456: END IF;
1457:

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

1662: THEN
1663:
1664: -- Debug info.
1665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1666: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1667: p_prefix =>l_debug_prefix,
1668: p_msg_level=>fnd_log.level_statement);
1669: END IF;
1670:

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

1673: END IF;
1674:
1675: -- Debug info.
1676: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1677: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1678: p_prefix=>l_debug_prefix,
1679: p_msg_level=>fnd_log.level_procedure);
1680: END IF;
1681:

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

1679: p_msg_level=>fnd_log.level_procedure);
1680: END IF;
1681:
1682: -- Bug 4693719 : pass NULL if the secure data is not updated
1683: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN
1684: l_acs := nvl(p_relationship_rec.actual_content_source, 'USER_ENTERED');
1685: ELSE
1686: l_acs := NULL;
1687: END IF;

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

1779: );
1780:
1781: -- Debug info.
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;
1787:

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

1797: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1798:
1799: -- Debug info.
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1802: p_prefix=>l_debug_prefix,
1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:

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

1882: );
1883:
1884: -- Debug info.
1885: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1886: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1887: p_prefix=>l_debug_prefix,
1888: p_msg_level=>fnd_log.level_procedure);
1889: END IF;
1890:

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

1915: IF l_party_id IS NOT NULL THEN
1916:
1917: -- Debug info.
1918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1919: hz_utility_v2pub.debug(p_message=>'updating party record',
1920: p_prefix =>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_statement);
1922: END IF;
1923:

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

2080: END IF;
2081:
2082: -- Debug info.
2083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2084: hz_utility_v2pub.debug(p_message=>'do_update_rel (-)',
2085: p_prefix=>l_debug_prefix,
2086: p_msg_level=>fnd_log.level_procedure);
2087: END IF;
2088:

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

2264: BEGIN
2265:
2266: -- Debug info.
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'do_create_party (+)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;
2272:

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

2392: END IF;
2393:
2394: -- Debug info.
2395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2396: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;
2400:

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

2489: x_party_number := l_party_rec.party_number;
2490:
2491: -- Debug info.
2492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2493: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2494: 'x_party_id = ' || x_party_id,
2495: p_prefix=>l_debug_prefix,
2496: p_msg_level=>fnd_log.level_procedure);
2497: END IF;

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

2504: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
2505:
2506: -- Debug info.
2507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2508: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',
2509: p_prefix=>l_debug_prefix,
2510: p_msg_level=>fnd_log.level_procedure);
2511: END IF;
2512:

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

2573: BEGIN
2574:
2575: -- Debug info.
2576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2577: hz_utility_v2pub.debug(p_message=>'do_update_party (+)',
2578: p_prefix=>l_debug_prefix,
2579: p_msg_level=>fnd_log.level_procedure);
2580: END IF;
2581:

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

2634: END IF;
2635:
2636: -- Debug info.
2637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2639: p_prefix=>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_procedure);
2641: END IF;
2642:

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

2731: );
2732:
2733: -- Debug info.
2734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2735: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2736: p_prefix=>l_debug_prefix,
2737: p_msg_level=>fnd_log.level_procedure);
2738: END IF;
2739:

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

2738: END IF;
2739:
2740: -- Debug info.
2741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug(p_message=>'do_update_party (-)',
2743: p_prefix=>l_debug_prefix,
2744: p_msg_level=>fnd_log.level_procedure);
2745: END IF;
2746:

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

2957: --enable_debug;
2958:
2959: -- Debug info.
2960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2961: hz_utility_v2pub.debug(p_message=>'create_relationship (+)',
2962: p_prefix=>l_debug_prefix,
2963: p_msg_level=>fnd_log.level_procedure);
2964: END IF;
2965:

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

3066: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
3067: -- Bug 2197181: Added below condition for Mix-n-Match
3068: g_rel_is_datasource_selected = 'Y' */
3069: THEN
3070: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
3071: HZ_BUSINESS_EVENT_V2PVT.create_relationship_event (
3072: l_rel_rec, l_created_party );
3073: END IF;
3074:

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

3071: HZ_BUSINESS_EVENT_V2PVT.create_relationship_event (
3072: l_rel_rec, l_created_party );
3073: END IF;
3074:
3075: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3076: -- populate function for integration service
3077: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3078: p_operation => 'I',
3079: p_RELATIONSHIP_ID => x_relationship_id );

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_exception>=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=>'WARNING',
3094: p_msg_level=>fnd_log.level_exception);
3095: END IF;

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

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

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=>'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 3141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

3165: p_data => x_msg_data);
3166:
3167: -- Debug info.
3168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3170: p_msg_data=>x_msg_data,
3171: p_msg_type=>'SQL ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173:

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

3172: p_msg_level=>fnd_log.level_error);
3173:
3174: END IF;
3175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3176: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3177: p_prefix=>l_debug_prefix,
3178: p_msg_level=>fnd_log.level_procedure);
3179: END IF;
3180:

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

3244: --enable_debug;
3245:
3246: -- Debug info.
3247: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3248: hz_utility_v2pub.debug(p_message=>'update_relationship (+)',
3249: p_prefix=>l_debug_prefix,
3250: p_msg_level=>fnd_log.level_procedure);
3251: END IF;
3252:

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

3353: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
3354: -- Bug 2197181: Added below condition for Mix-n-Match
3355: g_rel_is_datasource_selected = 'Y' */
3356: THEN
3357: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
3358: HZ_BUSINESS_EVENT_V2PVT.update_relationship_event (
3359: l_rel_rec, l_old_rel_rec );
3360: END IF;
3361:

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

3358: HZ_BUSINESS_EVENT_V2PVT.update_relationship_event (
3359: l_rel_rec, l_old_rel_rec );
3360: END IF;
3361:
3362: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3363: -- populate function for integration service
3364: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3365: p_operation => 'U',
3366: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );

Line 3370: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3366: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );
3367: END IF;
3368: END IF;
3369:
3370: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3371: -- Standard call to get message count and if count is 1, get message info.
3372: FND_MSG_PUB.Count_And_Get(
3373: p_encoded => FND_API.G_FALSE,
3374: p_count => x_msg_count,

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

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

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

3381: p_msg_type=>'WARNING',
3382: p_msg_level=>fnd_log.level_exception);
3383: END IF;
3384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3385: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3386: p_prefix=>l_debug_prefix,
3387: p_msg_level=>fnd_log.level_procedure);
3388: END IF;
3389:

Line 3396: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3392:
3393: EXCEPTION
3394: WHEN FND_API.G_EXC_ERROR THEN
3395: ROLLBACK TO update_relationship;
3396: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3397: x_return_status := FND_API.G_RET_STS_ERROR;
3398: FND_MSG_PUB.Count_And_Get(
3399: p_encoded => FND_API.G_FALSE,
3400: p_count => x_msg_count,

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

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

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

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

Line 3422: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3418: --disable_debug;
3419:
3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: ROLLBACK TO update_relationship;
3422: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: FND_MSG_PUB.Count_And_Get(
3425: p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count,

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

3427: p_data => x_msg_data);
3428:
3429: -- Debug info.
3430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3432: p_msg_data=>x_msg_data,
3433: p_msg_type=>'UNEXPECTED ERROR',
3434: p_msg_level=>fnd_log.level_error);
3435:

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

3434: p_msg_level=>fnd_log.level_error);
3435:
3436: END IF;
3437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3438: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3439: p_prefix=>l_debug_prefix,
3440: p_msg_level=>fnd_log.level_procedure);
3441: END IF;
3442:

Line 3448: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;

3444: --disable_debug;
3445:
3446: WHEN OTHERS THEN
3447: ROLLBACK TO update_relationship;
3448: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3452: FND_MSG_PUB.ADD;

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

3456: p_data => x_msg_data);
3457:
3458: -- Debug info.
3459: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3461: p_msg_data=>x_msg_data,
3462: p_msg_type=>'SQL ERROR',
3463: p_msg_level=>fnd_log.level_error);
3464:

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

3463: p_msg_level=>fnd_log.level_error);
3464:
3465: END IF;
3466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3467: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3468: p_prefix=>l_debug_prefix,
3469: p_msg_level=>fnd_log.level_procedure);
3470: END IF;
3471: -- Check if API is called in debug mode. If yes, disable debug.

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

3522: --enable_debug;
3523:
3524: -- Debug info.
3525: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3526: hz_utility_v2pub.debug(p_message=>'get_relationship_rec (+)',
3527: p_prefix=>l_debug_prefix,
3528: p_msg_level=>fnd_log.level_procedure);
3529: END IF;
3530:

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

3557: END IF;
3558:
3559: -- Debug info.
3560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3561: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3562: p_prefix =>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_statement);
3564: END IF;
3565:

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

3639: );
3640:
3641: -- Debug info.
3642: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3643: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_V2PUB.get_party_rec',
3644: p_prefix =>l_debug_prefix,
3645: p_msg_level=>fnd_log.level_statement);
3646: END IF;
3647:

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_exception>=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=>'WARNING',
3678: p_msg_level=>fnd_log.level_exception);
3679: END IF;

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

3677: p_msg_type=>'WARNING',
3678: p_msg_level=>fnd_log.level_exception);
3679: END IF;
3680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3681: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',
3682: p_prefix=>l_debug_prefix,
3683: p_msg_level=>fnd_log.level_procedure);
3684: END IF;
3685:

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=>'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 3725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3721: p_data => x_msg_data );
3722:
3723: -- Debug info.
3724: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3725: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3726: p_msg_data=>x_msg_data,
3727: p_msg_type=>'UNEXPECTED ERROR',
3728: p_msg_level=>fnd_log.level_error);
3729:

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

3728: p_msg_level=>fnd_log.level_error);
3729:
3730: END IF;
3731: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3732: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3733: p_prefix=>l_debug_prefix,
3734: p_msg_level=>fnd_log.level_procedure);
3735: END IF;
3736:

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

3750: p_data => x_msg_data );
3751:
3752: -- Debug info.
3753: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3754: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3755: p_msg_data=>x_msg_data,
3756: p_msg_type=>'SQL ERROR',
3757: p_msg_level=>fnd_log.level_error);
3758:

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

3757: p_msg_level=>fnd_log.level_error);
3758:
3759: END IF;
3760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3761: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,
3762: p_prefix=>l_debug_prefix,
3763: p_msg_level=>fnd_log.level_procedure);
3764: END IF;
3765: