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

Line 195: * HZ_UTILITY_V2PUB.enable_debug

191: * DESCRIPTION
192: * Turn on debug mode.
193: *
194: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
195: * HZ_UTILITY_V2PUB.enable_debug
196: *
197: * MODIFICATION HISTORY
198: *
199: * 07-23-2001 Jianying Huang o Created.

Line 213: HZ_UTILITY_V2PUB.enable_debug;

209: IF G_DEBUG_COUNT = 1 THEN
210: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
211: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
212: THEN
213: HZ_UTILITY_V2PUB.enable_debug;
214: G_DEBUG := TRUE;
215: END IF;
216: END IF;
217:

Line 229: * HZ_UTILITY_V2PUB.disable_debug

225: * DESCRIPTION
226: * Turn off debug mode.
227: *
228: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
229: * HZ_UTILITY_V2PUB.disable_debug
230: *
231: * MODIFICATION HISTORY
232: *
233: * 07-23-2001 Jianying Huang o Created.

Line 245: HZ_UTILITY_V2PUB.disable_debug;

241: IF G_DEBUG THEN
242: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
243:
244: IF G_DEBUG_COUNT = 0 THEN
245: HZ_UTILITY_V2PUB.disable_debug;
246: G_DEBUG := FALSE;
247: END IF;
248: END IF;
249:

Line 344: hz_utility_v2pub.debug(p_message=>'do_create_customer_profile (+)',

340: BEGIN
341:
342: -- Debug info.
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'do_create_customer_profile (+)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;
348:

Line 378: hz_utility_v2pub.debug(p_message=>'get default active profile class (id = 0)',

374: END IF;
375:
376: -- Debug info.
377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'get default active profile class (id = 0)',
379: p_prefix =>l_debug_prefix,
380: p_msg_level=>fnd_log.level_statement);
381: END IF;
382:

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

557: END IF;
558:
559: -- Debug info.
560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
562: 'v_action = '||v_action||' '||
563: 'v_entity_code = '||v_entity_code||' '||
564: 'v_entity_id = '||v_entity_id,
565: p_prefix=>l_debug_prefix,

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

580: x_msg_data => l_msg_data);
581:
582: -- Debug info.
583: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
585: 'l_return_status = '||l_return_status||' '||
586: 'l_msg_count = '||l_msg_count||' '||
587: 'l_msg_data = '||l_msg_data,
588: p_prefix=>l_debug_prefix,

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

591: EXCEPTION
592: WHEN OTHERS THEN
593: -- Debug info.
594: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
596: p_prefix=>l_debug_prefix,
597: p_msg_level=>fnd_log.level_statement);
598: END IF;
599:

Line 616: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',

612: -- Table_handler is taking care of default customer profile to profile class.
613:
614: -- Debug info.
615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
617: p_prefix=>l_debug_prefix,
618: p_msg_level=>fnd_log.level_procedure);
619: END IF;
620:

Line 738: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||

734: x_cust_account_profile_id := p_customer_profile_rec.cust_account_profile_id;
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
739: 'x_cust_account_profile_id = ' || x_cust_account_profile_id,
740: p_prefix=>l_debug_prefix,
741: p_msg_level=>fnd_log.level_procedure);
742: END IF;

Line 774: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',

770: END IF;
771:
772: -- Debug info.
773: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
774: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
775: p_prefix=>l_debug_prefix,
776: p_msg_level=>fnd_log.level_procedure);
777: END IF;
778:

Line 865: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',

861: );
862:
863: -- Debug info.
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
866: p_prefix=>l_debug_prefix,
867: p_msg_level=>fnd_log.level_procedure);
868: END IF;
869:

Line 915: hz_utility_v2pub.debug(p_message=>'do_create_customer_profile (-)',

911: END;
912:
913: -- Debug info.
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_message=>'do_create_customer_profile (-)',
916: p_prefix=>l_debug_prefix,
917: p_msg_level=>fnd_log.level_procedure);
918: END IF;
919:

Line 1015: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (+)',

1011: BEGIN
1012:
1013: -- Debug info.
1014: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1015: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (+)',
1016: p_prefix=>l_debug_prefix,
1017: p_msg_level=>fnd_log.level_procedure);
1018: END IF;
1019:

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

1223: END IF;
1224:
1225: -- Debug info.
1226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1227: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
1228: 'v_action = '||v_action||' '||
1229: 'v_entity_code = '||v_entity_code||' '||
1230: 'v_entity_id = '||v_entity_id,
1231: p_prefix=>l_debug_prefix,

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

1246: x_msg_data => l_msg_data);
1247:
1248: -- Debug info.
1249: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
1251: 'l_return_status = '||l_return_status||' '||
1252: 'l_msg_count = '||l_msg_count||' '||
1253: 'l_msg_data = '||l_msg_data,
1254: p_prefix=>l_debug_prefix,

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

1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: -- Debug info.
1260: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1261: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_statement);
1264: END IF;
1265:

Line 1282: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',

1278: -- Table_handler is taking care of default customer profile to profile class.
1279:
1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;
1286:

Line 1403: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',

1399: --raji
1400:
1401: -- Debug info.
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407:

Line 1458: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',

1454: END IF;
1455:
1456: -- Debug info.
1457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
1459: p_prefix=>l_debug_prefix,
1460: p_msg_level=>fnd_log.level_procedure);
1461: END IF;
1462:

Line 1549: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',

1545: );
1546:
1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;
1553:

Line 1644: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (-)',

1640: END IF;
1641:
1642: -- Debug info.
1643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1644: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (-)',
1645: p_prefix=>l_debug_prefix,
1646: p_msg_level=>fnd_log.level_procedure);
1647: END IF;
1648:

Line 1697: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (+)' ,

1693: BEGIN
1694:
1695: -- Debug info.
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (+)' ,
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1701:

Line 1737: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',

1733: END IF;
1734:
1735: -- Debug info.
1736: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
1738: p_prefix=>l_debug_prefix,
1739: p_msg_level=>fnd_log.level_procedure);
1740: END IF;
1741:

Line 1855: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||

1851: x_cust_acct_profile_amt_id := p_cust_profile_amt_rec.cust_acct_profile_amt_id;
1852:
1853: -- Debug info.
1854: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1855: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||
1856: 'x_cust_acct_profile_amt_id = ' || x_cust_acct_profile_amt_id,
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure);
1859: END IF;

Line 1863: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (-)',

1859: END IF;
1860:
1861: -- Debug info.
1862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1863: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (-)',
1864: p_prefix=>l_debug_prefix,
1865: p_msg_level=>fnd_log.level_procedure);
1866: END IF;
1867:

Line 1912: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (+)',

1908: BEGIN
1909:
1910: -- Debug info.
1911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1912: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (+)',
1913: p_prefix=>l_debug_prefix,
1914: p_msg_level=>fnd_log.level_procedure);
1915: END IF;
1916:

Line 1984: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',

1980: END IF;
1981:
1982: -- Debug info.
1983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1984: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',
1985: p_prefix=>l_debug_prefix,
1986: p_msg_level=>fnd_log.level_procedure);
1987: END IF;
1988:

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

2077: );
2078:
2079: -- Debug info.
2080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2081: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: END IF;
2085:

Line 2088: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (-)',

2084: END IF;
2085:
2086: -- Debug info.
2087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (-)',
2089: p_prefix=>l_debug_prefix,
2090: p_msg_level=>fnd_log.level_procedure);
2091: END IF;
2092:

Line 2245: hz_utility_v2pub.debug(p_message=>'create_customer_profile (+)',

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

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

2262: x_cust_account_profile_id,
2263: x_return_status );
2264:
2265: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2266: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2267: -- Invoke business event system.
2268: HZ_BUSINESS_EVENT_V2PVT.create_customer_profile_event (
2269: l_customer_profile_rec,
2270: p_create_profile_amt );

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

2269: l_customer_profile_rec,
2270: p_create_profile_amt );
2271: END IF;
2272:
2273: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2274: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2275: p_operation => 'I',
2276: p_cust_account_profile_id => x_cust_account_profile_id);
2277: END IF;

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

2284: p_data => x_msg_data );
2285:
2286: -- Debug info.
2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;

Line 2294: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',

2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2295: p_prefix=>l_debug_prefix,
2296: p_msg_level=>fnd_log.level_procedure);
2297: END IF;
2298:

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

2309: p_count => x_msg_count,
2310: p_data => x_msg_data );
2311:
2312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2313: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2314: p_msg_data=>x_msg_data,
2315: p_msg_type=>'ERROR',
2316: p_msg_level=>fnd_log.level_error);
2317: END IF;

Line 2319: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',

2315: p_msg_type=>'ERROR',
2316: p_msg_level=>fnd_log.level_error);
2317: END IF;
2318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2320: p_prefix=>l_debug_prefix,
2321: p_msg_level=>fnd_log.level_procedure);
2322: END IF;
2323:

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

2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335:
2336: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2337: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2338: p_msg_data=>x_msg_data,
2339: p_msg_type=>'UNEXPECTED ERROR',
2340: p_msg_level=>fnd_log.level_error);
2341: END IF;

Line 2343: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',

2339: p_msg_type=>'UNEXPECTED ERROR',
2340: p_msg_level=>fnd_log.level_error);
2341: END IF;
2342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2343: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2344: p_prefix=>l_debug_prefix,
2345: p_msg_level=>fnd_log.level_procedure);
2346: END IF;
2347:

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

2361: p_count => x_msg_count,
2362: p_data => x_msg_data );
2363:
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=>'SQL ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;

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

2367: p_msg_type=>'SQL 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=>'create_customer_profile (-)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:

Line 2438: hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',

2434: --enable_debug;
2435:
2436: -- Debug info.
2437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2438: hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',
2439: p_prefix=>l_debug_prefix,
2440: p_msg_level=>fnd_log.level_procedure);
2441: END IF;
2442:

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

2468: p_object_version_number,
2469: x_return_status );
2470:
2471: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2472: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2473: -- Invoke business event system.
2474: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2475: l_customer_profile_rec , l_old_customer_profile_rec);
2476: END IF;

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

2474: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2475: l_customer_profile_rec , l_old_customer_profile_rec);
2476: END IF;
2477:
2478: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2479: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2480: p_operation => 'U',
2481: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2482: END IF;

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

2488: p_count => x_msg_count,
2489: p_data => x_msg_data );
2490:
2491: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2493: p_msg_data=>x_msg_data,
2494: p_msg_type=>'WARNING',
2495: p_msg_level=>fnd_log.level_exception);
2496: END IF;

Line 2498: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',

2494: p_msg_type=>'WARNING',
2495: p_msg_level=>fnd_log.level_exception);
2496: END IF;
2497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2498: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2499: p_prefix=>l_debug_prefix,
2500: p_msg_level=>fnd_log.level_procedure);
2501: END IF;
2502:

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

2513: p_count => x_msg_count,
2514: p_data => x_msg_data );
2515:
2516: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2517: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2518: p_msg_data=>x_msg_data,
2519: p_msg_type=>'ERROR',
2520: p_msg_level=>fnd_log.level_error);
2521: END IF;

Line 2523: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',

2519: p_msg_type=>'ERROR',
2520: p_msg_level=>fnd_log.level_error);
2521: END IF;
2522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2523: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2524: p_prefix=>l_debug_prefix,
2525: p_msg_level=>fnd_log.level_procedure);
2526: END IF;
2527:

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

2537: p_count => x_msg_count,
2538: p_data => x_msg_data );
2539:
2540: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2541: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2542: p_msg_data=>x_msg_data,
2543: p_msg_type=>'UNEXPECTED ERROR',
2544: p_msg_level=>fnd_log.level_error);
2545: END IF;

Line 2547: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',

2543: p_msg_type=>'UNEXPECTED ERROR',
2544: p_msg_level=>fnd_log.level_error);
2545: END IF;
2546: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2547: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2548: p_prefix=>l_debug_prefix,
2549: p_msg_level=>fnd_log.level_procedure);
2550: END IF;
2551:

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

2565: p_count => x_msg_count,
2566: p_data => x_msg_data );
2567:
2568: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2570: p_msg_data=>x_msg_data,
2571: p_msg_type=>'SQL ERROR',
2572: p_msg_level=>fnd_log.level_error);
2573: END IF;

Line 2575: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',

2571: p_msg_type=>'SQL ERROR',
2572: p_msg_level=>fnd_log.level_error);
2573: END IF;
2574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2575: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2576: p_prefix=>l_debug_prefix,
2577: p_msg_level=>fnd_log.level_procedure);
2578: END IF;
2579:

Line 2633: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (+)',

2629: --enable_debug;
2630:
2631: -- Debug info.
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (+)',
2634: p_prefix=>l_debug_prefix,
2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;
2637:

Line 2659: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',

2655: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2656:
2657: -- Debug info.
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
2660: p_prefix=>l_debug_prefix,
2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;
2663:

Line 2779: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',

2775: --raji
2776:
2777: -- Debug info.
2778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2779: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
2780: p_prefix=>l_debug_prefix,
2781: p_msg_level=>fnd_log.level_procedure);
2782: END IF;
2783:

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

2788: p_data => x_msg_data );
2789:
2790: -- Debug info.
2791: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2792: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2793: p_msg_data=>x_msg_data,
2794: p_msg_type=>'WARNING',
2795: p_msg_level=>fnd_log.level_exception);
2796: END IF;

Line 2798: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',

2794: p_msg_type=>'WARNING',
2795: p_msg_level=>fnd_log.level_exception);
2796: END IF;
2797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2799: p_prefix=>l_debug_prefix,
2800: p_msg_level=>fnd_log.level_procedure);
2801: END IF;
2802:

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

2813: p_data => x_msg_data );
2814:
2815: -- Debug info.
2816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2817: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2818: p_msg_data=>x_msg_data,
2819: p_msg_type=>'ERROR',
2820: p_msg_level=>fnd_log.level_error);
2821: END IF;

Line 2823: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',

2819: p_msg_type=>'ERROR',
2820: p_msg_level=>fnd_log.level_error);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2824: p_prefix=>l_debug_prefix,
2825: p_msg_level=>fnd_log.level_procedure);
2826: END IF;
2827:

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

2837: p_data => x_msg_data );
2838:
2839: -- Debug info.
2840: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'UNEXPECTED ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;

Line 2847: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',

2843: p_msg_type=>'UNEXPECTED ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2848: p_prefix=>l_debug_prefix,
2849: p_msg_level=>fnd_log.level_procedure);
2850: END IF;
2851:

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

2865: p_data => x_msg_data );
2866:
2867: -- Debug info.
2868: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2870: p_msg_data=>x_msg_data,
2871: p_msg_type=>'SQL ERROR',
2872: p_msg_level=>fnd_log.level_error);
2873: END IF;

Line 2875: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',

2871: p_msg_type=>'SQL ERROR',
2872: p_msg_level=>fnd_log.level_error);
2873: END IF;
2874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2875: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2876: p_prefix=>l_debug_prefix,
2877: p_msg_level=>fnd_log.level_procedure);
2878: END IF;
2879:

Line 2945: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (+)',

2941: --enable_debug;
2942:
2943: -- Debug info.
2944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2945: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (+)',
2946: p_prefix=>l_debug_prefix,
2947: p_msg_level=>fnd_log.level_procedure);
2948: END IF;
2949:

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

2962: x_cust_acct_profile_amt_id,
2963: x_return_status );
2964:
2965: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2966: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2967: -- Invoke business event system.
2968: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
2969: l_cust_profile_amt_rec );
2970: END IF;

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

2968: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
2969: l_cust_profile_amt_rec );
2970: END IF;
2971:
2972: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2973: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
2974: p_operation => 'I',
2975: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
2976: END IF;

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

2983: p_data => x_msg_data );
2984:
2985: -- Debug info.
2986: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2987: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2988: p_msg_data=>x_msg_data,
2989: p_msg_type=>'WARNING',
2990: p_msg_level=>fnd_log.level_exception);
2991: END IF;

Line 2993: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',

2989: p_msg_type=>'WARNING',
2990: p_msg_level=>fnd_log.level_exception);
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;
2997:

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

3009: p_data => x_msg_data );
3010:
3011: -- Debug info.
3012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3014: p_msg_data=>x_msg_data,
3015: p_msg_type=>'ERROR',
3016: p_msg_level=>fnd_log.level_error);
3017: END IF;

Line 3019: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',

3015: p_msg_type=>'ERROR',
3016: p_msg_level=>fnd_log.level_error);
3017: END IF;
3018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3019: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3020: p_prefix=>l_debug_prefix,
3021: p_msg_level=>fnd_log.level_procedure);
3022: END IF;
3023:

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

3034: p_data => x_msg_data );
3035:
3036: -- Debug info.
3037: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3038: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3039: p_msg_data=>x_msg_data,
3040: p_msg_type=>'UNEXPECTED ERROR',
3041: p_msg_level=>fnd_log.level_error);
3042: END IF;

Line 3044: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',

3040: p_msg_type=>'UNEXPECTED ERROR',
3041: p_msg_level=>fnd_log.level_error);
3042: END IF;
3043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3044: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3045: p_prefix=>l_debug_prefix,
3046: p_msg_level=>fnd_log.level_procedure);
3047: END IF;
3048:

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

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

Line 3073: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',

3069: p_msg_type=>'SQL ERROR',
3070: p_msg_level=>fnd_log.level_error);
3071: END IF;
3072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3073: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3074: p_prefix=>l_debug_prefix,
3075: p_msg_level=>fnd_log.level_procedure);
3076: END IF;
3077:

Line 3139: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',

3135: --enable_debug;
3136:
3137: -- Debug info.
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;
3143:

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

3169: p_object_version_number,
3170: x_return_status );
3171:
3172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3173: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3174: -- Invoke business event system.
3175: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3176: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3177: END IF;

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

3175: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3176: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3177: END IF;
3178:
3179: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3180: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3181: p_operation => 'U',
3182: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3183: END IF;

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

3190: p_data => x_msg_data );
3191:
3192: -- Debug info.
3193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3195: p_msg_data=>x_msg_data,
3196: p_msg_type=>'WARNING',
3197: p_msg_level=>fnd_log.level_exception);
3198: END IF;

Line 3200: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',

3196: p_msg_type=>'WARNING',
3197: p_msg_level=>fnd_log.level_exception);
3198: END IF;
3199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3200: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3201: p_prefix=>l_debug_prefix,
3202: p_msg_level=>fnd_log.level_procedure);
3203: END IF;
3204:

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

3217: p_data => x_msg_data );
3218:
3219: -- Debug info.
3220: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3221: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3222: p_msg_data=>x_msg_data,
3223: p_msg_type=>'ERROR',
3224: p_msg_level=>fnd_log.level_error);
3225: END IF;

Line 3227: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',

3223: p_msg_type=>'ERROR',
3224: p_msg_level=>fnd_log.level_error);
3225: END IF;
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3228: p_prefix=>l_debug_prefix,
3229: p_msg_level=>fnd_log.level_procedure);
3230: END IF;
3231:

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

3242: p_data => x_msg_data );
3243:
3244: -- Debug info.
3245: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3246: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3247: p_msg_data=>x_msg_data,
3248: p_msg_type=>'UNEXPECTED ERROR',
3249: p_msg_level=>fnd_log.level_error);
3250: END IF;

Line 3252: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',

3248: p_msg_type=>'UNEXPECTED ERROR',
3249: p_msg_level=>fnd_log.level_error);
3250: END IF;
3251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3252: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3253: p_prefix=>l_debug_prefix,
3254: p_msg_level=>fnd_log.level_procedure);
3255: END IF;
3256:

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

3271: p_data => x_msg_data );
3272:
3273: -- Debug info.
3274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3275: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3276: p_msg_data=>x_msg_data,
3277: p_msg_type=>'SQL ERROR',
3278: p_msg_level=>fnd_log.level_error);
3279: END IF;

Line 3281: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',

3277: p_msg_type=>'SQL ERROR',
3278: p_msg_level=>fnd_log.level_error);
3279: END IF;
3280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3281: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3282: p_prefix=>l_debug_prefix,
3283: p_msg_level=>fnd_log.level_procedure);
3284: END IF;
3285:

Line 3339: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (+)',

3335: --enable_debug;
3336:
3337: -- Debug info.
3338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3339: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (+)',
3340: p_prefix=>l_debug_prefix,
3341: p_msg_level=>fnd_log.level_procedure);
3342: END IF;
3343:

Line 3365: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',

3361: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3362:
3363: -- Debug info.
3364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3365: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
3366: p_prefix=>l_debug_prefix,
3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:

Line 3460: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',

3456: );
3457:
3458: -- Debug info.
3459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
3461: p_prefix=>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_procedure);
3463: END IF;
3464:

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

3469: p_data => x_msg_data );
3470:
3471: -- Debug info.
3472: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3474: p_msg_data=>x_msg_data,
3475: p_msg_type=>'WARNING',
3476: p_msg_level=>fnd_log.level_exception);
3477: END IF;

Line 3479: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',

3475: p_msg_type=>'WARNING',
3476: p_msg_level=>fnd_log.level_exception);
3477: END IF;
3478: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3479: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3480: p_prefix=>l_debug_prefix,
3481: p_msg_level=>fnd_log.level_procedure);
3482: END IF;
3483:

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

3494: p_data => x_msg_data );
3495:
3496: -- Debug info.
3497: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3498: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3499: p_msg_data=>x_msg_data,
3500: p_msg_type=>'ERROR',
3501: p_msg_level=>fnd_log.level_error);
3502: END IF;

Line 3504: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',

3500: p_msg_type=>'ERROR',
3501: p_msg_level=>fnd_log.level_error);
3502: END IF;
3503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3504: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3505: p_prefix=>l_debug_prefix,
3506: p_msg_level=>fnd_log.level_procedure);
3507: END IF;
3508:

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

3518: p_data => x_msg_data );
3519:
3520: -- Debug info.
3521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3523: p_msg_data=>x_msg_data,
3524: p_msg_type=>'UNEXPECTED ERROR',
3525: p_msg_level=>fnd_log.level_error);
3526: END IF;

Line 3528: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',

3524: p_msg_type=>'UNEXPECTED ERROR',
3525: p_msg_level=>fnd_log.level_error);
3526: END IF;
3527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3528: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3529: p_prefix=>l_debug_prefix,
3530: p_msg_level=>fnd_log.level_procedure);
3531: END IF;
3532:

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

3546: p_data => x_msg_data );
3547:
3548: -- Debug info.
3549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3550: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3551: p_msg_data=>x_msg_data,
3552: p_msg_type=>'SQL ERROR',
3553: p_msg_level=>fnd_log.level_error);
3554: END IF;

Line 3556: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',

3552: p_msg_type=>'SQL ERROR',
3553: p_msg_level=>fnd_log.level_error);
3554: END IF;
3555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3556: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3557: p_prefix=>l_debug_prefix,
3558: p_msg_level=>fnd_log.level_procedure);
3559: END IF;
3560: