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:

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

393: CLOSE c_check_first_site;
394:
395: -- Debug info.
396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400: END IF;
401:

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

467:
468:
469: -- Debug info.
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
472: 'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;

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

526: END IF;
527:
528: -- Debug info.
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site (-)',
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;
534:

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

655: BEGIN
656:
657: -- Debug info.
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;
663:

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

779: END IF; -- End of account site status check
780: END IF;
781: -- Debug info.
782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
784: p_prefix=>l_debug_prefix,
785: p_msg_level=>fnd_log.level_procedure);
786: END IF;
787:

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

879: END IF;
880:
881: -- Debug info.
882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
883: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
884: p_prefix=>l_debug_prefix,
885: p_msg_level=>fnd_log.level_procedure);
886: END IF;
887:

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

886: END IF;
887:
888: -- Debug info.
889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
890: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
891: p_prefix=>l_debug_prefix,
892: p_msg_level=>fnd_log.level_procedure);
893: END IF;
894:

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

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

Line 1023: HZ_UTILITY_V2PUB.validate_lookup (

1019: -- Create party site use of same type if one does not exist.
1020:
1021: l_message_count := FND_MSG_PUB.Count_Msg();
1022:
1023: HZ_UTILITY_V2PUB.validate_lookup (
1024: p_column => 'site_use_code',
1025: p_lookup_type => 'PARTY_SITE_USE_CODE',
1026: p_column_value => p_cust_site_use_rec.site_use_code,
1027: x_return_status => x_return_status );

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

1027: x_return_status => x_return_status );
1028:
1029: -- Debug info.
1030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1032: 'x_return_status = ' || x_return_status,
1033: p_prefix =>l_debug_prefix,
1034: p_msg_level=>fnd_log.level_statement);
1035: END IF;

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

1075: END IF;
1076:
1077: -- Debug info.
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083:

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

1258: );
1259:
1260: -- Debug info.
1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1263: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;

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

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

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

1432: BEGIN
1433:
1434: -- Debug info.
1435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
1437: p_prefix=>l_debug_prefix,
1438: p_msg_level=>fnd_log.level_procedure);
1439: END IF;
1440:

Line 1495: HZ_UTILITY_V2PUB.validate_lookup (

1491: ---Create party site use of same type if one does not exist.
1492: --Bug No. 5036975
1493: IF p_cust_site_use_rec.status = 'A' THEN
1494: l_message_count := FND_MSG_PUB.Count_Msg();
1495: HZ_UTILITY_V2PUB.validate_lookup (
1496: p_column => 'site_use_code',
1497: p_lookup_type => 'PARTY_SITE_USE_CODE',
1498: p_column_value => p_cust_site_use_rec.site_use_code,
1499: x_return_status => x_return_status );

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

1499: x_return_status => x_return_status );
1500:
1501: -- Debug info.
1502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1503: hz_utility_v2pub.debug(p_message=>'check if site_use_code is a valid site_use_code in party level. ' ||
1504: 'x_return_status = ' || x_return_status,
1505: p_prefix =>l_debug_prefix,
1506: p_msg_level=>fnd_log.level_statement);
1507: END IF;

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

1550: END IF;
1551:
1552: -- Debug info.
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558: --Bug Fix:5036975

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

1568: end if;
1569:
1570: -- Debug info.
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;
1576:

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

1817: );
1818:
1819: -- Debug info.
1820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1822: p_prefix=>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;
1825:

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

1886: END IF;
1887:
1888: -- Debug info.
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;
1894:

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

1929: BEGIN
1930:
1931: -- Debug info.
1932: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_procedure);
1936: END IF;
1937:

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

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

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

2016: --enable_debug;
2017:
2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;
2024:

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

2049: x_cust_acct_site_id,
2050: x_return_status );
2051:
2052: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2053: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2054: -- Invoke business event system.
2055: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_site_event (
2056: l_cust_acct_site_rec );
2057: END IF;

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

2055: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_site_event (
2056: l_cust_acct_site_rec );
2057: END IF;
2058:
2059: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2060: -- populate function for integration service
2061: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2062: p_operation => 'I',
2063: p_cust_acct_site_id => x_cust_acct_site_id );

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

2071: p_data => x_msg_data );
2072:
2073: -- Debug info.
2074: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2075: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2076: p_msg_data=>x_msg_data,
2077: p_msg_type=>'WARNING',
2078: p_msg_level=>fnd_log.level_exception);
2079: END IF;

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

2077: p_msg_type=>'WARNING',
2078: p_msg_level=>fnd_log.level_exception);
2079: END IF;
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: END IF;
2085:

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

2097: p_data => x_msg_data );
2098:
2099: -- Debug info.
2100: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2102: p_msg_data=>x_msg_data,
2103: p_msg_type=>'ERROR',
2104: p_msg_level=>fnd_log.level_error);
2105: END IF;

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

2103: p_msg_type=>'ERROR',
2104: p_msg_level=>fnd_log.level_error);
2105: END IF;
2106: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2107: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2108: p_prefix=>l_debug_prefix,
2109: p_msg_level=>fnd_log.level_procedure);
2110: END IF;
2111:

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

2122: p_data => x_msg_data );
2123:
2124: -- Debug info.
2125: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2126: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2127: p_msg_data=>x_msg_data,
2128: p_msg_type=>'UNEXPECTED ERROR',
2129: p_msg_level=>fnd_log.level_error);
2130: END IF;

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

2128: p_msg_type=>'UNEXPECTED ERROR',
2129: p_msg_level=>fnd_log.level_error);
2130: END IF;
2131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug(p_message=>'create_cust_acct_site (-)',
2133: p_prefix=>l_debug_prefix,
2134: p_msg_level=>fnd_log.level_procedure);
2135: END IF;
2136:

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

2151: p_data => x_msg_data );
2152:
2153: -- Debug info.
2154: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2155: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2156: p_msg_data=>x_msg_data,
2157: p_msg_type=>'SQL ERROR',
2158: p_msg_level=>fnd_log.level_error);
2159: END IF;

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

2157: p_msg_type=>'SQL ERROR',
2158: p_msg_level=>fnd_log.level_error);
2159: END IF;
2160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2161: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_site (-)',
2162: p_prefix=>l_debug_prefix,
2163: p_msg_level=>fnd_log.level_procedure);
2164: END IF;
2165:

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

2222: --enable_debug;
2223:
2224: -- Debug info.
2225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2226: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
2227: p_prefix=>l_debug_prefix,
2228: p_msg_level=>fnd_log.level_procedure);
2229: END IF;
2230:

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

2288: x_return_status );
2289:
2290: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2291: l_old_cust_acct_site_rec.orig_system := l_cust_acct_site_rec.orig_system;
2292: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2293: -- Invoke business event system.
2294: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event (
2295: l_cust_acct_site_rec , l_old_cust_acct_site_rec );
2296: END IF;

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

2294: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event (
2295: l_cust_acct_site_rec , l_old_cust_acct_site_rec );
2296: END IF;
2297:
2298: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2299: -- populate function for integration service
2300: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2301: p_operation => 'U',
2302: p_cust_acct_site_id => l_cust_acct_site_rec.cust_acct_site_id );

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

2310: p_data => x_msg_data );
2311:
2312: -- Debug info.
2313: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2314: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2315: p_msg_data=>x_msg_data,
2316: p_msg_type=>'WARNING',
2317: p_msg_level=>fnd_log.level_exception);
2318: END IF;

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

2316: p_msg_type=>'WARNING',
2317: p_msg_level=>fnd_log.level_exception);
2318: END IF;
2319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2320: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2321: p_prefix=>l_debug_prefix,
2322: p_msg_level=>fnd_log.level_procedure);
2323: END IF;
2324:

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

2336: p_data => x_msg_data );
2337:
2338: -- Debug info.
2339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2341: p_msg_data=>x_msg_data,
2342: p_msg_type=>'ERROR',
2343: p_msg_level=>fnd_log.level_error);
2344: END IF;

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

2342: p_msg_type=>'ERROR',
2343: p_msg_level=>fnd_log.level_error);
2344: END IF;
2345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2346: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2347: p_prefix=>l_debug_prefix,
2348: p_msg_level=>fnd_log.level_procedure);
2349: END IF;
2350:

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

2361: p_data => x_msg_data );
2362:
2363: -- Debug info.
2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'UNEXPECTED ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;

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

2367: p_msg_type=>'UNEXPECTED ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:

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

2390: p_data => x_msg_data );
2391:
2392: -- Debug info.
2393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2395: p_msg_data=>x_msg_data,
2396: p_msg_type=>'SQL ERROR',
2397: p_msg_level=>fnd_log.level_error);
2398: END IF;

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

2396: p_msg_type=>'SQL ERROR',
2397: p_msg_level=>fnd_log.level_error);
2398: END IF;
2399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
2401: p_prefix=>l_debug_prefix,
2402: p_msg_level=>fnd_log.level_procedure);
2403: END IF;
2404:

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

2454: --enable_debug;
2455:
2456: -- Debug info.
2457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2458: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (+)',
2459: p_prefix=>l_debug_prefix,
2460: p_msg_level=>fnd_log.level_procedure);
2461: END IF;
2462:

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

2480: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
2481:
2482: -- Debug info.
2483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2484: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
2485: p_prefix=>l_debug_prefix,
2486: p_msg_level=>fnd_log.level_procedure);
2487: END IF;
2488:

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

2551: );
2552:
2553: -- Debug info.
2554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
2556: p_prefix=>l_debug_prefix,
2557: p_msg_level=>fnd_log.level_procedure);
2558: END IF;
2559:

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

2564: p_data => x_msg_data );
2565:
2566: -- Debug info.
2567: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'WARNING',
2571: p_msg_level=>fnd_log.level_exception);
2572: END IF;

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

2570: p_msg_type=>'WARNING',
2571: p_msg_level=>fnd_log.level_exception);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;
2578:

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

2589: p_data => x_msg_data );
2590:
2591: -- Debug info.
2592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'ERROR',
2596: p_msg_level=>fnd_log.level_error);
2597: END IF;

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

2595: p_msg_type=>'ERROR',
2596: p_msg_level=>fnd_log.level_error);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;
2603:

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

2613: p_data => x_msg_data );
2614:
2615: -- Debug info.
2616: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2617: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2618: p_msg_data=>x_msg_data,
2619: p_msg_type=>'UNEXPECTED ERROR',
2620: p_msg_level=>fnd_log.level_error);
2621: END IF;

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

2619: p_msg_type=>'UNEXPECTED ERROR',
2620: p_msg_level=>fnd_log.level_error);
2621: END IF;
2622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2623: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2624: p_prefix=>l_debug_prefix,
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:

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

2641: p_data => x_msg_data );
2642:
2643: -- Debug info.
2644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2645: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2646: p_msg_data=>x_msg_data,
2647: p_msg_type=>'SQL ERROR',
2648: p_msg_level=>fnd_log.level_error);
2649: END IF;

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

2647: p_msg_type=>'SQL ERROR',
2648: p_msg_level=>fnd_log.level_error);
2649: END IF;
2650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2651: hz_utility_v2pub.debug(p_message=>'get_cust_acct_site_rec (-)',
2652: p_prefix=>l_debug_prefix,
2653: p_msg_level=>fnd_log.level_procedure);
2654: END IF;
2655:

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

2723: --enable_debug;
2724:
2725: -- Debug info.
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (+)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731:

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

2745: x_site_use_id,
2746: x_return_status );
2747:
2748: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2749: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2750: -- Invoke business event system.
2751: HZ_BUSINESS_EVENT_V2PVT.create_cust_site_use_event (
2752: l_cust_site_use_rec,
2753: l_customer_profile_rec,

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

2754: p_create_profile,
2755: p_create_profile_amt );
2756: END IF;
2757:
2758: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2759: -- populate function for integration service
2760: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2761: p_operation => 'I',
2762: p_site_use_id => x_site_use_id );

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

2770: p_data => x_msg_data );
2771:
2772: -- Debug info.
2773: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'WARNING',
2777: p_msg_level=>fnd_log.level_exception);
2778: END IF;

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

2776: p_msg_type=>'WARNING',
2777: p_msg_level=>fnd_log.level_exception);
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2781: p_prefix=>l_debug_prefix,
2782: p_msg_level=>fnd_log.level_procedure);
2783: END IF;
2784: -- Check if API is called in debug mode. If yes, disable debug.

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

2795: p_data => x_msg_data );
2796:
2797: -- Debug info.
2798: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2799: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2800: p_msg_data=>x_msg_data,
2801: p_msg_type=>'ERROR',
2802: p_msg_level=>fnd_log.level_error);
2803: END IF;

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

2801: p_msg_type=>'ERROR',
2802: p_msg_level=>fnd_log.level_error);
2803: END IF;
2804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2806: p_prefix=>l_debug_prefix,
2807: p_msg_level=>fnd_log.level_procedure);
2808: END IF;
2809:

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

2820: p_data => x_msg_data );
2821:
2822: -- Debug info.
2823: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2824: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2825: p_msg_data=>x_msg_data,
2826: p_msg_type=>'UNEXPECTED ERROR',
2827: p_msg_level=>fnd_log.level_error);
2828: END IF;

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

2826: p_msg_type=>'UNEXPECTED ERROR',
2827: p_msg_level=>fnd_log.level_error);
2828: END IF;
2829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2830: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2831: p_prefix=>l_debug_prefix,
2832: p_msg_level=>fnd_log.level_procedure);
2833: END IF;
2834:

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

2849: p_data => x_msg_data );
2850:
2851: -- Debug info.
2852: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2853: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2854: p_msg_data=>x_msg_data,
2855: p_msg_type=>'SQL ERROR',
2856: p_msg_level=>fnd_log.level_error);
2857: END IF;

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

2855: p_msg_type=>'SQL ERROR',
2856: p_msg_level=>fnd_log.level_error);
2857: END IF;
2858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2859: hz_utility_v2pub.debug(p_message=>'create_cust_site_use (-)',
2860: p_prefix=>l_debug_prefix,
2861: p_msg_level=>fnd_log.level_procedure);
2862: END IF;
2863:

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

2921: --enable_debug;
2922:
2923: -- Debug info.
2924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2925: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',
2926: p_prefix=>l_debug_prefix,
2927: p_msg_level=>fnd_log.level_procedure);
2928: END IF;
2929:

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

2972: x_return_status );
2973:
2974: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2975: l_old_cust_site_use_rec.orig_system := l_cust_site_use_rec.orig_system;
2976: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2977: -- Invoke business event system.
2978: HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event (
2979: l_cust_site_use_rec , l_old_cust_site_use_rec);
2980: END IF;

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

2978: HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event (
2979: l_cust_site_use_rec , l_old_cust_site_use_rec);
2980: END IF;
2981:
2982: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2983: -- populate function for integration service
2984: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2985: p_operation => 'U',
2986: p_site_use_id => l_cust_site_use_rec.site_use_id );

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

2994: p_data => x_msg_data );
2995:
2996: -- Debug info.
2997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2999: p_msg_data=>x_msg_data,
3000: p_msg_type=>'WARNING',
3001: p_msg_level=>fnd_log.level_exception);
3002: END IF;

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

3000: p_msg_type=>'WARNING',
3001: p_msg_level=>fnd_log.level_exception);
3002: END IF;
3003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3004: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3005: p_prefix=>l_debug_prefix,
3006: p_msg_level=>fnd_log.level_procedure);
3007: END IF;
3008:

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

3020: p_data => x_msg_data );
3021:
3022: -- Debug info.
3023: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3025: p_msg_data=>x_msg_data,
3026: p_msg_type=>'ERROR',
3027: p_msg_level=>fnd_log.level_error);
3028: END IF;

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

3026: p_msg_type=>'ERROR',
3027: p_msg_level=>fnd_log.level_error);
3028: END IF;
3029: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3030: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3031: p_prefix=>l_debug_prefix,
3032: p_msg_level=>fnd_log.level_procedure);
3033: END IF;
3034:

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

3045: p_data => x_msg_data );
3046:
3047: -- Debug info.
3048: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'UNEXPECTED ERROR',
3052: p_msg_level=>fnd_log.level_error);
3053: END IF;

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

3051: p_msg_type=>'UNEXPECTED ERROR',
3052: p_msg_level=>fnd_log.level_error);
3053: END IF;
3054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3055: hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
3056: p_prefix=>l_debug_prefix,
3057: p_msg_level=>fnd_log.level_procedure);
3058: END IF;
3059:

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

3074: p_data => x_msg_data );
3075:
3076: -- Debug info.
3077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'SQL ERROR',
3081: p_msg_level=>fnd_log.level_error);
3082: END IF;

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

3080: p_msg_type=>'SQL ERROR',
3081: p_msg_level=>fnd_log.level_error);
3082: END IF;
3083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
3085: p_prefix=>l_debug_prefix,
3086: p_msg_level=>fnd_log.level_procedure);
3087: END IF;
3088:

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

3143: --enable_debug;
3144:
3145: -- Debug info.
3146: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3147: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (+)',
3148: p_prefix=>l_debug_prefix,
3149: p_msg_level=>fnd_log.level_procedure);
3150: END IF;
3151:

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

3169: x_cust_site_use_rec.site_use_id := p_site_use_id;
3170:
3171: -- Debug info.
3172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3173: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3174: p_prefix=>l_debug_prefix,
3175: p_msg_level=>fnd_log.level_procedure);
3176: END IF;
3177:

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

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

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

3319: p_data => x_msg_data );
3320:
3321: -- Debug info.
3322: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3323: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3324: p_msg_data=>x_msg_data,
3325: p_msg_type=>'WARNING',
3326: p_msg_level=>fnd_log.level_exception);
3327: END IF;

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

3325: p_msg_type=>'WARNING',
3326: p_msg_level=>fnd_log.level_exception);
3327: END IF;
3328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3329: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3330: p_prefix=>l_debug_prefix,
3331: p_msg_level=>fnd_log.level_procedure);
3332: END IF;
3333:

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

3344: p_data => x_msg_data );
3345:
3346: -- Debug info.
3347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3349: p_msg_data=>x_msg_data,
3350: p_msg_type=>'ERROR',
3351: p_msg_level=>fnd_log.level_error);
3352: END IF;

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

3350: p_msg_type=>'ERROR',
3351: p_msg_level=>fnd_log.level_error);
3352: END IF;
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3358:

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

3368: p_data => x_msg_data );
3369:
3370: -- Debug info.
3371: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3372: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3373: p_msg_data=>x_msg_data,
3374: p_msg_type=>'UNEXPECTED ERROR',
3375: p_msg_level=>fnd_log.level_error);
3376: END IF;

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

3374: p_msg_type=>'UNEXPECTED ERROR',
3375: p_msg_level=>fnd_log.level_error);
3376: END IF;
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'get_cust_site_use_rec (-)',
3379: p_prefix=>l_debug_prefix,
3380: p_msg_level=>fnd_log.level_procedure);
3381: END IF;
3382:

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

3396: p_data => x_msg_data );
3397:
3398: -- Debug info.
3399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3400: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3401: p_msg_data=>x_msg_data,
3402: p_msg_type=>'SQL ERROR',
3403: p_msg_level=>fnd_log.level_error);
3404: END IF;

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

3402: p_msg_type=>'SQL ERROR',
3403: p_msg_level=>fnd_log.level_error);
3404: END IF;
3405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug(p_message=> 'get_cust_site_use_rec (-)',
3407: p_prefix=>l_debug_prefix,
3408: p_msg_level=>fnd_log.level_procedure);
3409: END IF;
3410: