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_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 82: * HZ_UTILITY_V2PUB.enable_debug

78: * DESCRIPTION
79: * Turn on debug mode.
80: *
81: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
82: * HZ_UTILITY_V2PUB.enable_debug
83: *
84: * MODIFICATION HISTORY
85: *
86: * 07-23-2001 Jianying Huang o Created.

Line 100: HZ_UTILITY_V2PUB.enable_debug;

96: IF G_DEBUG_COUNT = 1 THEN
97: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
98: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
99: THEN
100: HZ_UTILITY_V2PUB.enable_debug;
101: G_DEBUG := TRUE;
102: END IF;
103: END IF;
104:

Line 115: * HZ_UTILITY_V2PUB.disable_debug

111: * DESCRIPTION
112: * Turn off debug mode.
113: *
114: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
115: * HZ_UTILITY_V2PUB.disable_debug
116: *
117: * MODIFICATION HISTORY
118: *
119: * 07-23-2001 Jianying Huang o Created.

Line 131: HZ_UTILITY_V2PUB.disable_debug;

127: IF G_DEBUG THEN
128: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
129:
130: IF G_DEBUG_COUNT = 0 THEN
131: HZ_UTILITY_V2PUB.disable_debug;
132: G_DEBUG := FALSE;
133: END IF;
134: END IF;
135:

Line 234: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (+)',

230: BEGIN
231:
232: -- Debug info.
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (+)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238:

Line 330: hz_utility_v2pub.debug(p_message=>'First site created in this org... '||

326: FETCH c_check_first_site INTO l_tmp;
327: IF c_check_first_site%NOTFOUND THEN
328: -- Debug info.
329: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'First site created in this org... '||
331: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id||' '||
332: 'org_id = '||p_cust_acct_site_rec.org_id,
333: p_prefix=>l_debug_prefix,
334: p_msg_level=>fnd_log.level_statement);

Line 344: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||

340:
341: IF l_tmp = 'Y' THEN
342: -- Debug info.
343: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
345: 'cust_account_id = '||p_cust_acct_site_rec.cust_account_id,
346: p_prefix=>l_debug_prefix,
347: p_msg_level=>fnd_log.level_statement);
348: END IF;

Line 366: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||

362: x_msg_data => l_msg_data);
363:
364: -- Debug info.
365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
367: 'l_return_status = '||l_return_status||' '||
368: 'l_msg_count = '||l_msg_count||' '||
369: 'l_msg_data = '||l_msg_data,
370: p_prefix=>l_debug_prefix,

Line 377: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,

373: EXCEPTION
374: WHEN OTHERS THEN
375: -- Debug info.
376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
377: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
378: p_prefix=>l_debug_prefix,
379: p_msg_level=>fnd_log.level_statement);
380: END IF;
381: --Bug14059649

Line 408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',

404: CLOSE c_check_first_site;
405:
406: -- Debug info.
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;
412:

Line 482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||

478:
479:
480: -- Debug info.
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
483: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;

Line 541: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',

537: END IF;
538:
539: -- Debug info.
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545:

Line 618: hz_utility_v2pub.debug(p_message=>'do_unset_prim_cust_site_use - TOO_MANY_ROWS Exception',

614: --To handle such scenario making all existing Primary records to non-primary
615: WHEN TOO_MANY_ROWS THEN
616: -- Debug info.
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'do_unset_prim_cust_site_use - TOO_MANY_ROWS Exception',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:

Line 624: hz_utility_v2pub.debug(p_message=>'Mulitiple rows found for Cust Acct Id '||l_cust_acct_id||' and Site Use Code '||p_site_use_code,

620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Mulitiple rows found for Cust Acct Id '||l_cust_acct_id||' and Site Use Code '||p_site_use_code,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;
628:

Line 636: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Site Use Id '||r_site.site_use_id,

632: LOOP
633: FETCH c_site INTO r_site;
634:
635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Site Use Id '||r_site.site_use_id,
637: p_prefix=>l_debug_prefix,
638: p_msg_level=>fnd_log.level_procedure);
639: END IF;
640:

Line 650: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Denormalization done for Acct Site Id '||r_site.cust_acct_site_id||' and Site use Code '||p_site_use_code,

646: WHERE site_use_id =r_site.site_use_id;
647:
648: denormalize_site_use_flag(r_site.cust_acct_site_id,p_site_use_code,'Y');
649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
650: hz_utility_v2pub.debug(p_message=>'TOO_MANY_ROWS Excp Denormalization done for Acct Site Id '||r_site.cust_acct_site_id||' and Site use Code '||p_site_use_code,
651: p_prefix=>l_debug_prefix,
652: p_msg_level=>fnd_log.level_procedure);
653: END IF;
654: EXIT WHEN c_site%NOTFOUND;

Line 738: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',

734: BEGIN
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;
742:

Line 862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',

858: END IF; -- End of account site status check
859: END IF;
860: -- Debug info.
861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
862: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
863: p_prefix=>l_debug_prefix,
864: p_msg_level=>fnd_log.level_procedure);
865: END IF;
866:

Line 965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',

961: END IF;
962:
963: -- Debug info.
964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
966: p_prefix=>l_debug_prefix,
967: p_msg_level=>fnd_log.level_procedure);
968: END IF;
969:

Line 972: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',

968: END IF;
969:
970: -- Debug info.
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
973: p_prefix=>l_debug_prefix,
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;
976:

Line 1065: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (+)',

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

Line 1115: HZ_UTILITY_V2PUB.validate_lookup (

1111: -- Create party site use of same type if one does not exist.
1112:
1113: l_message_count := FND_MSG_PUB.Count_Msg();
1114:
1115: HZ_UTILITY_V2PUB.validate_lookup (
1116: p_column => 'site_use_code',
1117: p_lookup_type => 'PARTY_SITE_USE_CODE',
1118: p_column_value => p_cust_site_use_rec.site_use_code,
1119: x_return_status => x_return_status );

Line 1123: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||

1119: x_return_status => x_return_status );
1120:
1121: -- Debug info.
1122: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1123: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1124: 'x_return_status = ' || x_return_status,
1125: p_prefix =>l_debug_prefix,
1126: p_msg_level=>fnd_log.level_statement);
1127: END IF;

Line 1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1167: END IF;
1168:
1169: -- Debug info.
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;
1175:

Line 1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||

1350: );
1351:
1352: -- Debug info.
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1355: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;

Line 1382: hz_utility_v2pub.debug(p_message=>'Updated hz_customer_profiles and hz_cust_profiles/amts with site_use_id of DUNNING or STATEMENTS' ,

1378: WHERE cust_account_profile_id = l_cust_account_profile_id ;
1379:
1380: -- Debug info.
1381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug(p_message=>'Updated hz_customer_profiles and hz_cust_profiles/amts with site_use_id of DUNNING or STATEMENTS' ,
1383: p_prefix =>l_debug_prefix,
1384: p_msg_level=>fnd_log.level_statement);
1385: END IF;
1386: -- Debug info.

Line 1388: hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,

1384: p_msg_level=>fnd_log.level_statement);
1385: END IF;
1386: -- Debug info.
1387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,
1389: p_prefix =>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_statement);
1391: END IF;
1392:

Line 1484: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',

1480: x_site_use_id := p_cust_site_use_rec.site_use_id;
1481:
1482: -- Debug info.
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_create_cust_site_use (-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;
1488:

Line 1567: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',

1563: BEGIN
1564:
1565: -- Debug info.
1566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1567: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1568: p_prefix=>l_debug_prefix,
1569: p_msg_level=>fnd_log.level_procedure);
1570: END IF;
1571:

Line 1626: HZ_UTILITY_V2PUB.validate_lookup (

1622: ---Create party site use of same type if one does not exist.
1623: --Bug No. 5036975
1624: IF p_cust_site_use_rec.status = 'A' THEN
1625: l_message_count := FND_MSG_PUB.Count_Msg();
1626: HZ_UTILITY_V2PUB.validate_lookup (
1627: p_column => 'site_use_code',
1628: p_lookup_type => 'PARTY_SITE_USE_CODE',
1629: p_column_value => p_cust_site_use_rec.site_use_code,
1630: x_return_status => x_return_status );

Line 1634: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||

1630: x_return_status => x_return_status );
1631:
1632: -- Debug info.
1633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1634: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1635: 'x_return_status = ' || x_return_status,
1636: p_prefix =>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_statement);
1638: END IF;

Line 1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1681: END IF;
1682:
1683: -- Debug info.
1684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1686: p_prefix=>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_procedure);
1688: END IF;
1689: --Bug Fix:5036975

Line 1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',

1699: end if;
1700:
1701: -- Debug info.
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;
1707:

Line 1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',

1950: );
1951:
1952: -- Debug info.
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:

Line 2023: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',

2019: END IF;
2020:
2021: -- Debug info.
2022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2023: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
2024: p_prefix=>l_debug_prefix,
2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;
2027:

Line 2066: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',

2062: BEGIN
2063:
2064: -- Debug info.
2065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2066: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
2067: p_prefix=>l_debug_prefix,
2068: p_msg_level=>fnd_log.level_procedure);
2069: END IF;
2070:

Line 2094: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',

2090: END IF;
2091:
2092: -- Debug info.
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
2095: p_prefix=>l_debug_prefix,
2096: p_msg_level=>fnd_log.level_procedure);
2097: END IF;
2098:

Line 2159: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',

2155: --enable_debug;
2156:
2157: -- Debug info.
2158: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2159: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2160: p_prefix=>l_debug_prefix,
2161: p_msg_level=>fnd_log.level_procedure);
2162: END IF;
2163:

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

2188: x_cust_acct_site_id,
2189: x_return_status );
2190:
2191: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2192: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2193: -- Invoke business event system.
2194: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_site_event (
2195: l_cust_acct_site_rec );
2196: END IF;

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

2194: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_site_event (
2195: l_cust_acct_site_rec );
2196: END IF;
2197:
2198: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2199: -- populate function for integration service
2200: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2201: p_operation => 'I',
2202: p_cust_acct_site_id => x_cust_acct_site_id );

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

2210: p_data => x_msg_data );
2211:
2212: -- Debug info.
2213: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2215: p_msg_data=>x_msg_data,
2216: p_msg_type=>'WARNING',
2217: p_msg_level=>fnd_log.level_exception);
2218: END IF;

Line 2220: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',

2216: p_msg_type=>'WARNING',
2217: p_msg_level=>fnd_log.level_exception);
2218: END IF;
2219: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2221: p_prefix=>l_debug_prefix,
2222: p_msg_level=>fnd_log.level_procedure);
2223: END IF;
2224:

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

2236: p_data => x_msg_data );
2237:
2238: -- Debug info.
2239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2241: p_msg_data=>x_msg_data,
2242: p_msg_type=>'ERROR',
2243: p_msg_level=>fnd_log.level_error);
2244: END IF;

Line 2246: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',

2242: p_msg_type=>'ERROR',
2243: p_msg_level=>fnd_log.level_error);
2244: END IF;
2245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2246: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2247: p_prefix=>l_debug_prefix,
2248: p_msg_level=>fnd_log.level_procedure);
2249: END IF;
2250:

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

2261: p_data => x_msg_data );
2262:
2263: -- Debug info.
2264: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2265: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2266: p_msg_data=>x_msg_data,
2267: p_msg_type=>'UNEXPECTED ERROR',
2268: p_msg_level=>fnd_log.level_error);
2269: END IF;

Line 2271: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',

2267: p_msg_type=>'UNEXPECTED ERROR',
2268: p_msg_level=>fnd_log.level_error);
2269: END IF;
2270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2271: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2272: p_prefix=>l_debug_prefix,
2273: p_msg_level=>fnd_log.level_procedure);
2274: END IF;
2275:

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

2290: p_data => x_msg_data );
2291:
2292: -- Debug info.
2293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2295: p_msg_data=>x_msg_data,
2296: p_msg_type=>'SQL ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;

Line 2300: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',

2296: p_msg_type=>'SQL ERROR',
2297: p_msg_level=>fnd_log.level_error);
2298: END IF;
2299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2300: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;
2304:

Line 2365: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',

2361: --enable_debug;
2362:
2363: -- Debug info.
2364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2366: p_prefix=>l_debug_prefix,
2367: p_msg_level=>fnd_log.level_procedure);
2368: END IF;
2369:

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

2427: x_return_status );
2428:
2429: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2430: l_old_cust_acct_site_rec.orig_system := l_cust_acct_site_rec.orig_system;
2431: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2432: -- Invoke business event system.
2433: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event (
2434: l_cust_acct_site_rec , l_old_cust_acct_site_rec );
2435: END IF;

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

2433: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event (
2434: l_cust_acct_site_rec , l_old_cust_acct_site_rec );
2435: END IF;
2436:
2437: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2438: -- populate function for integration service
2439: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2440: p_operation => 'U',
2441: p_cust_acct_site_id => l_cust_acct_site_rec.cust_acct_site_id );

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

2449: p_data => x_msg_data );
2450:
2451: -- Debug info.
2452: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2454: p_msg_data=>x_msg_data,
2455: p_msg_type=>'WARNING',
2456: p_msg_level=>fnd_log.level_exception);
2457: END IF;

Line 2459: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',

2455: p_msg_type=>'WARNING',
2456: p_msg_level=>fnd_log.level_exception);
2457: END IF;
2458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2459: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2460: p_prefix=>l_debug_prefix,
2461: p_msg_level=>fnd_log.level_procedure);
2462: END IF;
2463:

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

2475: p_data => x_msg_data );
2476:
2477: -- Debug info.
2478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2480: p_msg_data=>x_msg_data,
2481: p_msg_type=>'ERROR',
2482: p_msg_level=>fnd_log.level_error);
2483: END IF;

Line 2485: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',

2481: p_msg_type=>'ERROR',
2482: p_msg_level=>fnd_log.level_error);
2483: END IF;
2484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2485: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2486: p_prefix=>l_debug_prefix,
2487: p_msg_level=>fnd_log.level_procedure);
2488: END IF;
2489:

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

2500: p_data => x_msg_data );
2501:
2502: -- Debug info.
2503: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2504: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2505: p_msg_data=>x_msg_data,
2506: p_msg_type=>'UNEXPECTED ERROR',
2507: p_msg_level=>fnd_log.level_error);
2508: END IF;

Line 2510: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',

2506: p_msg_type=>'UNEXPECTED ERROR',
2507: p_msg_level=>fnd_log.level_error);
2508: END IF;
2509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2510: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2511: p_prefix=>l_debug_prefix,
2512: p_msg_level=>fnd_log.level_procedure);
2513: END IF;
2514:

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

2529: p_data => x_msg_data );
2530:
2531: -- Debug info.
2532: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2534: p_msg_data=>x_msg_data,
2535: p_msg_type=>'SQL ERROR',
2536: p_msg_level=>fnd_log.level_error);
2537: END IF;

Line 2539: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',

2535: p_msg_type=>'SQL ERROR',
2536: p_msg_level=>fnd_log.level_error);
2537: END IF;
2538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2539: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2540: p_prefix=>l_debug_prefix,
2541: p_msg_level=>fnd_log.level_procedure);
2542: END IF;
2543:

Line 2597: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',

2593: --enable_debug;
2594:
2595: -- Debug info.
2596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2598: p_prefix=>l_debug_prefix,
2599: p_msg_level=>fnd_log.level_procedure);
2600: END IF;
2601:

Line 2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',

2619: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2620:
2621: -- Debug info.
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:

Line 2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',

2690: );
2691:
2692: -- Debug info.
2693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2694: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2695: p_prefix=>l_debug_prefix,
2696: p_msg_level=>fnd_log.level_procedure);
2697: END IF;
2698:

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

2703: p_data => x_msg_data );
2704:
2705: -- Debug info.
2706: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2708: p_msg_data=>x_msg_data,
2709: p_msg_type=>'WARNING',
2710: p_msg_level=>fnd_log.level_exception);
2711: END IF;

Line 2713: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',

2709: p_msg_type=>'WARNING',
2710: p_msg_level=>fnd_log.level_exception);
2711: END IF;
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2714: p_prefix=>l_debug_prefix,
2715: p_msg_level=>fnd_log.level_procedure);
2716: END IF;
2717:

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

2728: p_data => x_msg_data );
2729:
2730: -- Debug info.
2731: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2732: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2733: p_msg_data=>x_msg_data,
2734: p_msg_type=>'ERROR',
2735: p_msg_level=>fnd_log.level_error);
2736: END IF;

Line 2738: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',

2734: p_msg_type=>'ERROR',
2735: p_msg_level=>fnd_log.level_error);
2736: END IF;
2737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2738: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2739: p_prefix=>l_debug_prefix,
2740: p_msg_level=>fnd_log.level_procedure);
2741: END IF;
2742:

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

2752: p_data => x_msg_data );
2753:
2754: -- Debug info.
2755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2757: p_msg_data=>x_msg_data,
2758: p_msg_type=>'UNEXPECTED ERROR',
2759: p_msg_level=>fnd_log.level_error);
2760: END IF;

Line 2762: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',

2758: p_msg_type=>'UNEXPECTED ERROR',
2759: p_msg_level=>fnd_log.level_error);
2760: END IF;
2761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2762: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2763: p_prefix=>l_debug_prefix,
2764: p_msg_level=>fnd_log.level_procedure);
2765: END IF;
2766:

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

2780: p_data => x_msg_data );
2781:
2782: -- Debug info.
2783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'SQL ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;

Line 2790: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',

2786: p_msg_type=>'SQL ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;
2794:

Line 2866: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',

2862: --enable_debug;
2863:
2864: -- Debug info.
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;
2870:

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

2884: x_site_use_id,
2885: x_return_status );
2886:
2887: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2888: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2889: -- Invoke business event system.
2890: HZ_BUSINESS_EVENT_V2PVT.create_cust_site_use_event (
2891: l_cust_site_use_rec,
2892: l_customer_profile_rec,

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

2893: p_create_profile,
2894: p_create_profile_amt );
2895: END IF;
2896:
2897: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2898: -- populate function for integration service
2899: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2900: p_operation => 'I',
2901: p_site_use_id => x_site_use_id );

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

2909: p_data => x_msg_data );
2910:
2911: -- Debug info.
2912: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2914: p_msg_data=>x_msg_data,
2915: p_msg_type=>'WARNING',
2916: p_msg_level=>fnd_log.level_exception);
2917: END IF;

Line 2919: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',

2915: p_msg_type=>'WARNING',
2916: p_msg_level=>fnd_log.level_exception);
2917: END IF;
2918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2919: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2920: p_prefix=>l_debug_prefix,
2921: p_msg_level=>fnd_log.level_procedure);
2922: END IF;
2923: -- Check if API is called in debug mode. If yes, disable debug.

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

2934: p_data => x_msg_data );
2935:
2936: -- Debug info.
2937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;

Line 2944: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',

2940: p_msg_type=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;
2948:

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

2959: p_data => x_msg_data );
2960:
2961: -- Debug info.
2962: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2963: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2964: p_msg_data=>x_msg_data,
2965: p_msg_type=>'UNEXPECTED ERROR',
2966: p_msg_level=>fnd_log.level_error);
2967: END IF;

Line 2969: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',

2965: p_msg_type=>'UNEXPECTED ERROR',
2966: p_msg_level=>fnd_log.level_error);
2967: END IF;
2968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2969: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2970: p_prefix=>l_debug_prefix,
2971: p_msg_level=>fnd_log.level_procedure);
2972: END IF;
2973:

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

2988: p_data => x_msg_data );
2989:
2990: -- Debug info.
2991: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2993: p_msg_data=>x_msg_data,
2994: p_msg_type=>'SQL ERROR',
2995: p_msg_level=>fnd_log.level_error);
2996: END IF;

Line 2998: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',

2994: p_msg_type=>'SQL ERROR',
2995: p_msg_level=>fnd_log.level_error);
2996: END IF;
2997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2998: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2999: p_prefix=>l_debug_prefix,
3000: p_msg_level=>fnd_log.level_procedure);
3001: END IF;
3002:

Line 3064: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',

3060: --enable_debug;
3061:
3062: -- Debug info.
3063: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3064: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',
3065: p_prefix=>l_debug_prefix,
3066: p_msg_level=>fnd_log.level_procedure);
3067: END IF;
3068:

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

3111: x_return_status );
3112:
3113: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3114: l_old_cust_site_use_rec.orig_system := l_cust_site_use_rec.orig_system;
3115: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
3116: -- Invoke business event system.
3117: HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event (
3118: l_cust_site_use_rec , l_old_cust_site_use_rec);
3119: END IF;

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

3117: HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event (
3118: l_cust_site_use_rec , l_old_cust_site_use_rec);
3119: END IF;
3120:
3121: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3122: -- populate function for integration service
3123: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
3124: p_operation => 'U',
3125: p_site_use_id => l_cust_site_use_rec.site_use_id );

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

3133: p_data => x_msg_data );
3134:
3135: -- Debug info.
3136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3138: p_msg_data=>x_msg_data,
3139: p_msg_type=>'WARNING',
3140: p_msg_level=>fnd_log.level_exception);
3141: END IF;

Line 3143: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',

3139: p_msg_type=>'WARNING',
3140: p_msg_level=>fnd_log.level_exception);
3141: END IF;
3142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3143: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3144: p_prefix=>l_debug_prefix,
3145: p_msg_level=>fnd_log.level_procedure);
3146: END IF;
3147:

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

3159: p_data => x_msg_data );
3160:
3161: -- Debug info.
3162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3164: p_msg_data=>x_msg_data,
3165: p_msg_type=>'ERROR',
3166: p_msg_level=>fnd_log.level_error);
3167: END IF;

Line 3169: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',

3165: p_msg_type=>'ERROR',
3166: p_msg_level=>fnd_log.level_error);
3167: END IF;
3168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3170: p_prefix=>l_debug_prefix,
3171: p_msg_level=>fnd_log.level_procedure);
3172: END IF;
3173:

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

3184: p_data => x_msg_data );
3185:
3186: -- Debug info.
3187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;

Line 3194: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',

3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3198:

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

3213: p_data => x_msg_data );
3214:
3215: -- Debug info.
3216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3218: p_msg_data=>x_msg_data,
3219: p_msg_type=>'SQL ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221: END IF;

Line 3223: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',

3219: p_msg_type=>'SQL ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221: END IF;
3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3223: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3224: p_prefix=>l_debug_prefix,
3225: p_msg_level=>fnd_log.level_procedure);
3226: END IF;
3227:

Line 3286: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (+)',

3282: --enable_debug;
3283:
3284: -- Debug info.
3285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3286: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (+)',
3287: p_prefix=>l_debug_prefix,
3288: p_msg_level=>fnd_log.level_procedure);
3289: END IF;
3290:

Line 3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',

3308: x_cust_site_use_rec.site_use_id := p_site_use_id;
3309:
3310: -- Debug info.
3311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3313: p_prefix=>l_debug_prefix,
3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:

Line 3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',

3420: );
3421:
3422: -- Debug info.
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428:

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

3458: p_data => x_msg_data );
3459:
3460: -- Debug info.
3461: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3462: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;

Line 3468: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',

3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;
3467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3468: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3469: p_prefix=>l_debug_prefix,
3470: p_msg_level=>fnd_log.level_procedure);
3471: END IF;
3472:

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

3483: p_data => x_msg_data );
3484:
3485: -- Debug info.
3486: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;

Line 3493: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',

3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497:

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

3507: p_data => x_msg_data );
3508:
3509: -- Debug info.
3510: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3511: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3512: p_msg_data=>x_msg_data,
3513: p_msg_type=>'UNEXPECTED ERROR',
3514: p_msg_level=>fnd_log.level_error);
3515: END IF;

Line 3517: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',

3513: p_msg_type=>'UNEXPECTED ERROR',
3514: p_msg_level=>fnd_log.level_error);
3515: END IF;
3516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3517: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3518: p_prefix=>l_debug_prefix,
3519: p_msg_level=>fnd_log.level_procedure);
3520: END IF;
3521:

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

3535: p_data => x_msg_data );
3536:
3537: -- Debug info.
3538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3540: p_msg_data=>x_msg_data,
3541: p_msg_type=>'SQL ERROR',
3542: p_msg_level=>fnd_log.level_error);
3543: END IF;

Line 3545: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',

3541: p_msg_type=>'SQL ERROR',
3542: p_msg_level=>fnd_log.level_error);
3543: END IF;
3544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3545: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3546: p_prefix=>l_debug_prefix,
3547: p_msg_level=>fnd_log.level_procedure);
3548: END IF;
3549: