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 578: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||

574: END IF;
575:
576: -- Debug info.
577: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
578: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
579: 'v_action = '||v_action||' '||
580: 'v_entity_code = '||v_entity_code||' '||
581: 'v_entity_id = '||v_entity_id,
582: p_prefix=>l_debug_prefix,

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

597: x_msg_data => l_msg_data);
598:
599: -- Debug info.
600: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
601: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
602: 'l_return_status = '||l_return_status||' '||
603: 'l_msg_count = '||l_msg_count||' '||
604: 'l_msg_data = '||l_msg_data,
605: p_prefix=>l_debug_prefix,

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

608: EXCEPTION
609: WHEN OTHERS THEN
610: -- Debug info.
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
613: p_prefix=>l_debug_prefix,
614: p_msg_level=>fnd_log.level_statement);
615: END IF;
616:

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

642: -- Table_handler is taking care of default customer profile to profile class.
643:
644: -- Debug info.
645: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
646: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: END IF;
650:

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

765: x_cust_account_profile_id := p_customer_profile_rec.cust_account_profile_id;
766:
767: -- Debug info.
768: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
769: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
770: 'x_cust_account_profile_id = ' || x_cust_account_profile_id,
771: p_prefix=>l_debug_prefix,
772: p_msg_level=>fnd_log.level_procedure);
773: END IF;

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

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

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

892: );
893:
894: -- Debug info.
895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
896: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
897: p_prefix=>l_debug_prefix,
898: p_msg_level=>fnd_log.level_procedure);
899: END IF;
900:

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

942: END;
943:
944: -- Debug info.
945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
946: hz_utility_v2pub.debug(p_message=>'do_create_customer_profile (-)',
947: p_prefix=>l_debug_prefix,
948: p_msg_level=>fnd_log.level_procedure);
949: END IF;
950:

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

1043: BEGIN
1044:
1045: -- Debug info.
1046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1047: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (+)',
1048: p_prefix=>l_debug_prefix,
1049: p_msg_level=>fnd_log.level_procedure);
1050: END IF;
1051:

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

1273: END IF;
1274:
1275: -- Debug info.
1276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug(p_message=>'Before call OE_HOLDS... '||
1278: 'v_action = '||v_action||' '||
1279: 'v_entity_code = '||v_entity_code||' '||
1280: 'v_entity_id = '||v_entity_id,
1281: p_prefix=>l_debug_prefix,

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

1296: x_msg_data => l_msg_data);
1297:
1298: -- Debug info.
1299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'After call OE_HOLDS... '||
1301: 'l_return_status = '||l_return_status||' '||
1302: 'l_msg_count = '||l_msg_count||' '||
1303: 'l_msg_data = '||l_msg_data,
1304: p_prefix=>l_debug_prefix,

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

1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: -- Debug info.
1310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'Exception raised from OE_HOLDS... '||SQLERRM,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;
1315:

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

1340: -- Table_handler is taking care of default customer profile to profile class.
1341:
1342: -- Debug info.
1343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1344: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
1345: p_prefix=>l_debug_prefix,
1346: p_msg_level=>fnd_log.level_procedure);
1347: END IF;
1348:

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

1462: --raji
1463:
1464: -- Debug info.
1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
1467: p_prefix=>l_debug_prefix,
1468: p_msg_level=>fnd_log.level_procedure);
1469: END IF;
1470:

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

1517: END IF;
1518:
1519: -- Debug info.
1520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1521: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
1522: p_prefix=>l_debug_prefix,
1523: p_msg_level=>fnd_log.level_procedure);
1524: END IF;
1525:

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

1608: );
1609:
1610: -- Debug info.
1611: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1612: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
1613: p_prefix=>l_debug_prefix,
1614: p_msg_level=>fnd_log.level_procedure);
1615: END IF;
1616:

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

1703: END IF;
1704:
1705: -- Debug info.
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (-)',
1708: p_prefix=>l_debug_prefix,
1709: p_msg_level=>fnd_log.level_procedure);
1710: END IF;
1711:

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

1756: BEGIN
1757:
1758: -- Debug info.
1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (+)' ,
1761: p_prefix=>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_procedure);
1763: END IF;
1764:

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

1796: END IF;
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804:

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

1914: x_cust_acct_profile_amt_id := p_cust_profile_amt_rec.cust_acct_profile_amt_id;
1915:
1916: -- Debug info.
1917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||
1919: 'x_cust_acct_profile_amt_id = ' || x_cust_acct_profile_amt_id,
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: END IF;

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

1922: END IF;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1930:

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

1971: BEGIN
1972:
1973: -- Debug info.
1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (+)',
1976: p_prefix=>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_procedure);
1978: END IF;
1979:

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

2043: END IF;
2044:
2045: -- Debug info.
2046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2047: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',
2048: p_prefix=>l_debug_prefix,
2049: p_msg_level=>fnd_log.level_procedure);
2050: END IF;
2051:

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

2140: );
2141:
2142: -- Debug info.
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148:

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

2147: END IF;
2148:
2149: -- Debug info.
2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2151: hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (-)',
2152: p_prefix=>l_debug_prefix,
2153: p_msg_level=>fnd_log.level_procedure);
2154: END IF;
2155:

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

2304: --enable_debug;
2305:
2306: -- Debug info.
2307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2308: hz_utility_v2pub.debug(p_message=>'create_customer_profile (+)',
2309: p_prefix=>l_debug_prefix,
2310: p_msg_level=>fnd_log.level_procedure);
2311: END IF;
2312:

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

2325: x_cust_account_profile_id,
2326: x_return_status );
2327:
2328: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2329: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2330: -- Invoke business event system.
2331: HZ_BUSINESS_EVENT_V2PVT.create_customer_profile_event (
2332: l_customer_profile_rec,
2333: p_create_profile_amt );

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

2332: l_customer_profile_rec,
2333: p_create_profile_amt );
2334: END IF;
2335:
2336: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2337: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2338: p_operation => 'I',
2339: p_cust_account_profile_id => x_cust_account_profile_id);
2340: END IF;

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

2347: p_data => x_msg_data );
2348:
2349: -- Debug info.
2350: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2351: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2352: p_msg_data=>x_msg_data,
2353: p_msg_type=>'WARNING',
2354: p_msg_level=>fnd_log.level_exception);
2355: END IF;

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

2353: p_msg_type=>'WARNING',
2354: p_msg_level=>fnd_log.level_exception);
2355: END IF;
2356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2357: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2358: p_prefix=>l_debug_prefix,
2359: p_msg_level=>fnd_log.level_procedure);
2360: END IF;
2361:

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

2372: p_count => x_msg_count,
2373: p_data => x_msg_data );
2374:
2375: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2376: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2377: p_msg_data=>x_msg_data,
2378: p_msg_type=>'ERROR',
2379: p_msg_level=>fnd_log.level_error);
2380: END IF;

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

2378: p_msg_type=>'ERROR',
2379: p_msg_level=>fnd_log.level_error);
2380: END IF;
2381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2382: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2383: p_prefix=>l_debug_prefix,
2384: p_msg_level=>fnd_log.level_procedure);
2385: END IF;
2386:

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

2396: p_count => x_msg_count,
2397: p_data => x_msg_data );
2398:
2399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2400: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2401: p_msg_data=>x_msg_data,
2402: p_msg_type=>'UNEXPECTED ERROR',
2403: p_msg_level=>fnd_log.level_error);
2404: END IF;

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

2402: p_msg_type=>'UNEXPECTED ERROR',
2403: p_msg_level=>fnd_log.level_error);
2404: END IF;
2405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2406: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2407: p_prefix=>l_debug_prefix,
2408: p_msg_level=>fnd_log.level_procedure);
2409: END IF;
2410:

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

2424: p_count => x_msg_count,
2425: p_data => x_msg_data );
2426:
2427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2429: p_msg_data=>x_msg_data,
2430: p_msg_type=>'SQL ERROR',
2431: p_msg_level=>fnd_log.level_error);
2432: END IF;

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

2430: p_msg_type=>'SQL ERROR',
2431: p_msg_level=>fnd_log.level_error);
2432: END IF;
2433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2434: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2435: p_prefix=>l_debug_prefix,
2436: p_msg_level=>fnd_log.level_procedure);
2437: END IF;
2438:

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

2497: --enable_debug;
2498:
2499: -- Debug info.
2500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2501: hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',
2502: p_prefix=>l_debug_prefix,
2503: p_msg_level=>fnd_log.level_procedure);
2504: END IF;
2505:

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

2531: p_object_version_number,
2532: x_return_status );
2533:
2534: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2535: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2536: -- Invoke business event system.
2537: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2538: l_customer_profile_rec , l_old_customer_profile_rec);
2539: END IF;

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

2537: HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
2538: l_customer_profile_rec , l_old_customer_profile_rec);
2539: END IF;
2540:
2541: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2542: HZ_POPULATE_BOT_PKG.pop_hz_customer_profiles(
2543: p_operation => 'U',
2544: p_cust_account_profile_id => l_customer_profile_rec.cust_account_profile_id);
2545: END IF;

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

2551: p_count => x_msg_count,
2552: p_data => x_msg_data );
2553:
2554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'WARNING',
2558: p_msg_level=>fnd_log.level_exception);
2559: END IF;

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

2557: p_msg_type=>'WARNING',
2558: p_msg_level=>fnd_log.level_exception);
2559: END IF;
2560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2561: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2562: p_prefix=>l_debug_prefix,
2563: p_msg_level=>fnd_log.level_procedure);
2564: END IF;
2565:

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

2576: p_count => x_msg_count,
2577: p_data => x_msg_data );
2578:
2579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2581: p_msg_data=>x_msg_data,
2582: p_msg_type=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);
2584: END IF;

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

2582: p_msg_type=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);
2584: END IF;
2585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2586: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2587: p_prefix=>l_debug_prefix,
2588: p_msg_level=>fnd_log.level_procedure);
2589: END IF;
2590:

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

2600: p_count => x_msg_count,
2601: p_data => x_msg_data );
2602:
2603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2605: p_msg_data=>x_msg_data,
2606: p_msg_type=>'UNEXPECTED ERROR',
2607: p_msg_level=>fnd_log.level_error);
2608: END IF;

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

2606: p_msg_type=>'UNEXPECTED ERROR',
2607: p_msg_level=>fnd_log.level_error);
2608: END IF;
2609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2610: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2611: p_prefix=>l_debug_prefix,
2612: p_msg_level=>fnd_log.level_procedure);
2613: END IF;
2614:

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

2628: p_count => x_msg_count,
2629: p_data => x_msg_data );
2630:
2631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2632: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2633: p_msg_data=>x_msg_data,
2634: p_msg_type=>'SQL ERROR',
2635: p_msg_level=>fnd_log.level_error);
2636: END IF;

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

2634: p_msg_type=>'SQL ERROR',
2635: p_msg_level=>fnd_log.level_error);
2636: END IF;
2637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2639: p_prefix=>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_procedure);
2641: END IF;
2642:

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

2692: --enable_debug;
2693:
2694: -- Debug info.
2695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2696: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (+)',
2697: p_prefix=>l_debug_prefix,
2698: p_msg_level=>fnd_log.level_procedure);
2699: END IF;
2700:

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

2718: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;
2719:
2720: -- Debug info.
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
2723: p_prefix=>l_debug_prefix,
2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;
2726:

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

2839: --raji
2840:
2841: -- Debug info.
2842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2843: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
2844: p_prefix=>l_debug_prefix,
2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2847:

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

2852: p_data => x_msg_data );
2853:
2854: -- Debug info.
2855: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2856: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2857: p_msg_data=>x_msg_data,
2858: p_msg_type=>'WARNING',
2859: p_msg_level=>fnd_log.level_exception);
2860: END IF;

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

2858: p_msg_type=>'WARNING',
2859: p_msg_level=>fnd_log.level_exception);
2860: END IF;
2861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2862: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2863: p_prefix=>l_debug_prefix,
2864: p_msg_level=>fnd_log.level_procedure);
2865: END IF;
2866:

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

2877: p_data => x_msg_data );
2878:
2879: -- Debug info.
2880: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2881: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2882: p_msg_data=>x_msg_data,
2883: p_msg_type=>'ERROR',
2884: p_msg_level=>fnd_log.level_error);
2885: END IF;

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

2883: p_msg_type=>'ERROR',
2884: p_msg_level=>fnd_log.level_error);
2885: END IF;
2886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2887: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2888: p_prefix=>l_debug_prefix,
2889: p_msg_level=>fnd_log.level_procedure);
2890: END IF;
2891:

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

2901: p_data => x_msg_data );
2902:
2903: -- Debug info.
2904: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2905: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2906: p_msg_data=>x_msg_data,
2907: p_msg_type=>'UNEXPECTED ERROR',
2908: p_msg_level=>fnd_log.level_error);
2909: END IF;

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

2907: p_msg_type=>'UNEXPECTED ERROR',
2908: p_msg_level=>fnd_log.level_error);
2909: END IF;
2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2911: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2912: p_prefix=>l_debug_prefix,
2913: p_msg_level=>fnd_log.level_procedure);
2914: END IF;
2915:

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

2929: p_data => x_msg_data );
2930:
2931: -- Debug info.
2932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2933: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2934: p_msg_data=>x_msg_data,
2935: p_msg_type=>'SQL ERROR',
2936: p_msg_level=>fnd_log.level_error);
2937: END IF;

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

2935: p_msg_type=>'SQL ERROR',
2936: p_msg_level=>fnd_log.level_error);
2937: END IF;
2938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2939: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2940: p_prefix=>l_debug_prefix,
2941: p_msg_level=>fnd_log.level_procedure);
2942: END IF;
2943:

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

3005: --enable_debug;
3006:
3007: -- Debug info.
3008: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3009: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (+)',
3010: p_prefix=>l_debug_prefix,
3011: p_msg_level=>fnd_log.level_procedure);
3012: END IF;
3013:

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

3026: x_cust_acct_profile_amt_id,
3027: x_return_status );
3028:
3029: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3030: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3031: -- Invoke business event system.
3032: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
3033: l_cust_profile_amt_rec );
3034: END IF;

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

3032: HZ_BUSINESS_EVENT_V2PVT.create_cust_profile_amt_event (
3033: l_cust_profile_amt_rec );
3034: END IF;
3035:
3036: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3037: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3038: p_operation => 'I',
3039: p_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id);
3040: END IF;

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

3047: p_data => x_msg_data );
3048:
3049: -- Debug info.
3050: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3051: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3052: p_msg_data=>x_msg_data,
3053: p_msg_type=>'WARNING',
3054: p_msg_level=>fnd_log.level_exception);
3055: END IF;

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

3053: p_msg_type=>'WARNING',
3054: p_msg_level=>fnd_log.level_exception);
3055: END IF;
3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3057: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3058: p_prefix=>l_debug_prefix,
3059: p_msg_level=>fnd_log.level_procedure);
3060: END IF;
3061:

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

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

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

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

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

3098: p_data => x_msg_data );
3099:
3100: -- Debug info.
3101: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3103: p_msg_data=>x_msg_data,
3104: p_msg_type=>'UNEXPECTED ERROR',
3105: p_msg_level=>fnd_log.level_error);
3106: END IF;

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

3104: p_msg_type=>'UNEXPECTED ERROR',
3105: p_msg_level=>fnd_log.level_error);
3106: END IF;
3107: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3108: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3109: p_prefix=>l_debug_prefix,
3110: p_msg_level=>fnd_log.level_procedure);
3111: END IF;
3112:

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

3127: p_data => x_msg_data );
3128:
3129: -- Debug info.
3130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3132: p_msg_data=>x_msg_data,
3133: p_msg_type=>'SQL ERROR',
3134: p_msg_level=>fnd_log.level_error);
3135: END IF;

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

3133: p_msg_type=>'SQL ERROR',
3134: p_msg_level=>fnd_log.level_error);
3135: END IF;
3136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3137: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3138: p_prefix=>l_debug_prefix,
3139: p_msg_level=>fnd_log.level_procedure);
3140: END IF;
3141:

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

3199: --enable_debug;
3200:
3201: -- Debug info.
3202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3203: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',
3204: p_prefix=>l_debug_prefix,
3205: p_msg_level=>fnd_log.level_procedure);
3206: END IF;
3207:

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

3233: p_object_version_number,
3234: x_return_status );
3235:
3236: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3237: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3238: -- Invoke business event system.
3239: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3240: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3241: END IF;

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

3239: HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
3240: l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
3241: END IF;
3242:
3243: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3244: HZ_POPULATE_BOT_PKG.pop_hz_cust_profile_amts(
3245: p_operation => 'U',
3246: p_cust_acct_profile_amt_id => l_cust_profile_amt_rec.cust_acct_profile_amt_id);
3247: END IF;

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

3254: p_data => x_msg_data );
3255:
3256: -- Debug info.
3257: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3258: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3259: p_msg_data=>x_msg_data,
3260: p_msg_type=>'WARNING',
3261: p_msg_level=>fnd_log.level_exception);
3262: END IF;

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

3260: p_msg_type=>'WARNING',
3261: p_msg_level=>fnd_log.level_exception);
3262: END IF;
3263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3264: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3265: p_prefix=>l_debug_prefix,
3266: p_msg_level=>fnd_log.level_procedure);
3267: END IF;
3268:

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

3281: p_data => x_msg_data );
3282:
3283: -- Debug info.
3284: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3285: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3286: p_msg_data=>x_msg_data,
3287: p_msg_type=>'ERROR',
3288: p_msg_level=>fnd_log.level_error);
3289: END IF;

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

3287: p_msg_type=>'ERROR',
3288: p_msg_level=>fnd_log.level_error);
3289: END IF;
3290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3291: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3292: p_prefix=>l_debug_prefix,
3293: p_msg_level=>fnd_log.level_procedure);
3294: END IF;
3295:

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

3306: p_data => x_msg_data );
3307:
3308: -- Debug info.
3309: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3310: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3311: p_msg_data=>x_msg_data,
3312: p_msg_type=>'UNEXPECTED ERROR',
3313: p_msg_level=>fnd_log.level_error);
3314: END IF;

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

3312: p_msg_type=>'UNEXPECTED ERROR',
3313: p_msg_level=>fnd_log.level_error);
3314: END IF;
3315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3316: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3317: p_prefix=>l_debug_prefix,
3318: p_msg_level=>fnd_log.level_procedure);
3319: END IF;
3320:

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

3335: p_data => x_msg_data );
3336:
3337: -- Debug info.
3338: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3339: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3340: p_msg_data=>x_msg_data,
3341: p_msg_type=>'SQL ERROR',
3342: p_msg_level=>fnd_log.level_error);
3343: END IF;

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

3341: p_msg_type=>'SQL ERROR',
3342: p_msg_level=>fnd_log.level_error);
3343: END IF;
3344: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3345: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3346: p_prefix=>l_debug_prefix,
3347: p_msg_level=>fnd_log.level_procedure);
3348: END IF;
3349:

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

3399: --enable_debug;
3400:
3401: -- Debug info.
3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3403: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (+)',
3404: p_prefix=>l_debug_prefix,
3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407:

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

3425: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;
3426:
3427: -- Debug info.
3428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
3430: p_prefix=>l_debug_prefix,
3431: p_msg_level=>fnd_log.level_procedure);
3432: END IF;
3433:

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

3520: );
3521:
3522: -- Debug info.
3523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3524: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
3525: p_prefix=>l_debug_prefix,
3526: p_msg_level=>fnd_log.level_procedure);
3527: END IF;
3528:

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

3533: p_data => x_msg_data );
3534:
3535: -- Debug info.
3536: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3537: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3538: p_msg_data=>x_msg_data,
3539: p_msg_type=>'WARNING',
3540: p_msg_level=>fnd_log.level_exception);
3541: END IF;

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

3539: p_msg_type=>'WARNING',
3540: p_msg_level=>fnd_log.level_exception);
3541: END IF;
3542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3543: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3544: p_prefix=>l_debug_prefix,
3545: p_msg_level=>fnd_log.level_procedure);
3546: END IF;
3547:

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

3558: p_data => x_msg_data );
3559:
3560: -- Debug info.
3561: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3562: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3563: p_msg_data=>x_msg_data,
3564: p_msg_type=>'ERROR',
3565: p_msg_level=>fnd_log.level_error);
3566: END IF;

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

3564: p_msg_type=>'ERROR',
3565: p_msg_level=>fnd_log.level_error);
3566: END IF;
3567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3568: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3569: p_prefix=>l_debug_prefix,
3570: p_msg_level=>fnd_log.level_procedure);
3571: END IF;
3572:

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

3582: p_data => x_msg_data );
3583:
3584: -- Debug info.
3585: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3586: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3587: p_msg_data=>x_msg_data,
3588: p_msg_type=>'UNEXPECTED ERROR',
3589: p_msg_level=>fnd_log.level_error);
3590: END IF;

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

3588: p_msg_type=>'UNEXPECTED ERROR',
3589: p_msg_level=>fnd_log.level_error);
3590: END IF;
3591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3592: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3593: p_prefix=>l_debug_prefix,
3594: p_msg_level=>fnd_log.level_procedure);
3595: END IF;
3596:

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

3610: p_data => x_msg_data );
3611:
3612: -- Debug info.
3613: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3614: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3615: p_msg_data=>x_msg_data,
3616: p_msg_type=>'SQL ERROR',
3617: p_msg_level=>fnd_log.level_error);
3618: END IF;

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

3616: p_msg_type=>'SQL ERROR',
3617: p_msg_level=>fnd_log.level_error);
3618: END IF;
3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;
3624: