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.

[Home] [Help]

APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on FND_LOG

Line 343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

339:
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;

Line 346: p_msg_level=>fnd_log.level_procedure);

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:
349: -- Default profile_class_id.
350: IF p_customer_profile_rec.profile_class_id IS NULL OR

Line 377: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

373: END;
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;

Line 380: p_msg_level=>fnd_log.level_statement);

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:
383:
384: --{

Line 577: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

573: v_entity_id := p_customer_profile_rec.site_use_id;
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,

Line 583: p_msg_level=>fnd_log.level_statement);

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,
583: p_msg_level=>fnd_log.level_statement);
584: END IF;
585:
586: BEGIN
587: OE_Holds_PUB.Process_Holds (

Line 600: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

596: x_msg_count => l_msg_count,
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,

Line 606: p_msg_level=>fnd_log.level_statement);

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,
606: p_msg_level=>fnd_log.level_statement);
607: END IF;
608: EXCEPTION
609: WHEN OTHERS THEN
610: -- Debug info.

Line 611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

607: END IF;
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;

Line 614: p_msg_level=>fnd_log.level_statement);

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:
617: --Bug14059649
618: --We should remove the code where they are suppressing the error being raise

Line 645: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

641: -- Call table-handler.
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;

Line 648: p_msg_level=>fnd_log.level_procedure);

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:
651: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
652: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,

Line 768: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

764:
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);

Line 772: p_msg_level=>fnd_log.level_procedure);

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;
774:
775: -- Now default in the profile amounts only if
776: -- p_create_profile_amt is TRUE. Otherwise, simply return.

Line 804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

800: l_is_first := FALSE;
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;

Line 807: p_msg_level=>fnd_log.level_procedure);

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:
810: -- Call table-handler.
811: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

Line 895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

891: X_PENALTY_SCHEDULE_ID => l_cust_profile_amt_rec.penalty_schedule_id
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;

Line 898: p_msg_level=>fnd_log.level_procedure);

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:
901: l_cust_profile_amt_rec.cust_acct_profile_amt_id := NULL;
902:

Line 945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

941: RAISE;
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;

Line 948: p_msg_level=>fnd_log.level_procedure);

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:
951: END do_create_customer_profile;
952:

Line 1046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1042:
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;

Line 1049: p_msg_level=>fnd_log.level_procedure);

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:
1052: -- Lock record.
1053: BEGIN

Line 1276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1272: v_entity_id := l_site_use_id;
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,

Line 1282: p_msg_level=>fnd_log.level_statement);

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,
1282: p_msg_level=>fnd_log.level_statement);
1283: END IF;
1284:
1285: BEGIN
1286: OE_Holds_PUB.Process_Holds (

Line 1299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1295: x_msg_count => l_msg_count,
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,

Line 1305: p_msg_level=>fnd_log.level_statement);

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,
1305: p_msg_level=>fnd_log.level_statement);
1306: END IF;
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: -- Debug info.

Line 1310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1306: END IF;
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;

Line 1313: p_msg_level=>fnd_log.level_statement);

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:
1316: --Bug14059649
1317: --We should remove the code where they are suppressing the error being raise

Line 1343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1339: -- Call table-handler.
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;

Line 1346: p_msg_level=>fnd_log.level_procedure);

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:
1349: HZ_CUSTOMER_PROFILES_PKG.Update_Row (
1350: X_Rowid => l_rowid,

Line 1465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1461:
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;

Line 1468: p_msg_level=>fnd_log.level_procedure);

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:
1471: -- When the bill_level at the account profile is changed from 'ACCOUNT' to 'SITE',
1472: -- the bill_level for all the associated BFB enabled site uses should be

Line 1520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1516: l_is_first := FALSE;
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;

Line 1523: p_msg_level=>fnd_log.level_procedure);

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:
1526: -- Call table-handler
1527: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

Line 1611: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1607: X_PENALTY_SCHEDULE_ID => l_cust_profile_amt_rec.penalty_schedule_id
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;

Line 1614: p_msg_level=>fnd_log.level_procedure);

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:
1617: -- Check if a currency code already exist for this profile.
1618: -- If yes, update that amount. If not, create a new amount.

Line 1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1702: END;
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;

Line 1709: p_msg_level=>fnd_log.level_procedure);

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:
1712: END do_update_customer_profile;
1713:

Line 1759: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1755: l_site_use_id HZ_CUST_PROFILE_AMTS.SITE_USE_ID%TYPE;
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;

Line 1762: p_msg_level=>fnd_log.level_procedure);

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:
1765: -- Validate cust profile amt record
1766: HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt (

Line 1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1795: p_cust_profile_amt_rec.penalty_fixed_amount := ROUND(p_cust_profile_amt_rec.penalty_fixed_amount,2);
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;

Line 1802: p_msg_level=>fnd_log.level_procedure);

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:
1805: -- Bug 6472676
1806: -- Changed do_create_cust_profile_amt Procudure to get SITE_USE_ID value from Customer Profiles if

Line 1917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1913:
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);

Line 1921: p_msg_level=>fnd_log.level_procedure);

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;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1921: p_msg_level=>fnd_log.level_procedure);
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;

Line 1928: p_msg_level=>fnd_log.level_procedure);

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:
1931: END do_create_cust_profile_amt;
1932:

Line 1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1970:
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;

Line 1977: p_msg_level=>fnd_log.level_procedure);

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:
1980: -- Lock record.
1981: BEGIN

Line 2046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2042: p_cust_profile_amt_rec.penalty_fixed_amount := ROUND(p_cust_profile_amt_rec.penalty_fixed_amount,2);
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;

Line 2049: p_msg_level=>fnd_log.level_procedure);

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:
2052: -- Call table-handler.
2053: HZ_CUST_PROFILE_AMTS_PKG.Update_Row (

Line 2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2139: X_PENALTY_SCHEDULE_ID => p_cust_profile_amt_rec.penalty_schedule_id
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;

Line 2146: p_msg_level=>fnd_log.level_procedure);

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:
2149: -- Debug info.
2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2146: p_msg_level=>fnd_log.level_procedure);
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;

Line 2153: p_msg_level=>fnd_log.level_procedure);

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:
2156: END do_update_cust_profile_amt;
2157:

Line 2307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2303: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 2310: p_msg_level=>fnd_log.level_procedure);

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:
2313: -- Initialize message list if p_init_msg_list is set to TRUE.
2314: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2350: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2346: p_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);

Line 2354: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 2356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2352: p_msg_data=>x_msg_data,
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;

Line 2359: p_msg_level=>fnd_log.level_procedure);

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:
2362: -- Check if API is called in debug mode. If yes, disable debug.
2363: --disable_debug;

Line 2375: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2371: p_encoded => FND_API.G_FALSE,
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);

Line 2379: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2377: p_msg_data=>x_msg_data,
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;

Line 2384: p_msg_level=>fnd_log.level_procedure);

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:
2387: -- Check if API is called in debug mode. If yes, disable debug.
2388: --disable_debug;

Line 2399: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2395: p_encoded => FND_API.G_FALSE,
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);

Line 2403: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2405: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2401: p_msg_data=>x_msg_data,
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;

Line 2408: p_msg_level=>fnd_log.level_procedure);

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:
2411: -- Check if API is called in debug mode. If yes, disable debug.
2412: --disable_debug;

Line 2427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2423: p_encoded => FND_API.G_FALSE,
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);

Line 2431: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2429: p_msg_data=>x_msg_data,
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;

Line 2436: p_msg_level=>fnd_log.level_procedure);

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:
2439: -- Check if API is called in debug mode. If yes, disable debug.
2440: --disable_debug;

Line 2500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2496: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 2503: p_msg_level=>fnd_log.level_procedure);

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:
2506: -- Initialize message list if p_init_msg_list is set to TRUE.
2507: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2550: p_encoded => FND_API.G_FALSE,
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);

Line 2558: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 2560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2556: p_msg_data=>x_msg_data,
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;

Line 2563: p_msg_level=>fnd_log.level_procedure);

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:
2566: -- Check if API is called in debug mode. If yes, disable debug.
2567: --disable_debug;

Line 2579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2575: p_encoded => FND_API.G_FALSE,
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);

Line 2583: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2581: p_msg_data=>x_msg_data,
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;

Line 2588: p_msg_level=>fnd_log.level_procedure);

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:
2591: -- Check if API is called in debug mode. If yes, disable debug.
2592: --disable_debug;

Line 2603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2599: p_encoded => FND_API.G_FALSE,
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);

Line 2607: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2605: p_msg_data=>x_msg_data,
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;

Line 2612: p_msg_level=>fnd_log.level_procedure);

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:
2615: -- Check if API is called in debug mode. If yes, disable debug.
2616: --disable_debug;

Line 2631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2627: p_encoded => FND_API.G_FALSE,
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);

Line 2635: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2633: p_msg_data=>x_msg_data,
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;

Line 2640: p_msg_level=>fnd_log.level_procedure);

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:
2643: -- Check if API is called in debug mode. If yes, disable debug.
2644: --disable_debug;

Line 2695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2691: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 2698: p_msg_level=>fnd_log.level_procedure);

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:
2701: -- Initialize message list if p_init_msg_list is set to TRUE.
2702: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2717:
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;

Line 2724: p_msg_level=>fnd_log.level_procedure);

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:
2727: -- Call table-handler.
2728: HZ_CUSTOMER_PROFILES_PKG.Select_Row (

Line 2842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2838:
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;

Line 2845: p_msg_level=>fnd_log.level_procedure);

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:
2848: -- Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(

Line 2855: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2851: p_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);

Line 2859: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 2861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2857: p_msg_data=>x_msg_data,
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;

Line 2864: p_msg_level=>fnd_log.level_procedure);

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:
2867: -- Check if API is called in debug mode. If yes, disable debug.
2868: --disable_debug;

Line 2880: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2876: p_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);

Line 2884: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2882: p_msg_data=>x_msg_data,
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;

Line 2889: p_msg_level=>fnd_log.level_procedure);

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:
2892: -- Check if API is called in debug mode. If yes, disable debug.
2893: --disable_debug;

Line 2904: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2900: p_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);

Line 2908: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2910: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2906: p_msg_data=>x_msg_data,
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;

Line 2913: p_msg_level=>fnd_log.level_procedure);

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:
2916: -- Check if API is called in debug mode. If yes, disable debug.
2917: --disable_debug;

Line 2932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2928: p_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);

Line 2936: p_msg_level=>fnd_log.level_error);

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;
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,

Line 2938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2934: p_msg_data=>x_msg_data,
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;

Line 2941: p_msg_level=>fnd_log.level_procedure);

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:
2944: -- Check if API is called in debug mode. If yes, disable debug.
2945: --disable_debug;

Line 3008: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3004: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 3011: p_msg_level=>fnd_log.level_procedure);

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:
3014: -- Initialize message list if p_init_msg_list is set to TRUE.
3015: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3050: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3046: p_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);

Line 3054: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3052: p_msg_data=>x_msg_data,
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;

Line 3059: p_msg_level=>fnd_log.level_procedure);

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:
3062: -- Check if API is called in debug mode. If yes, disable debug.
3063: --disable_debug;

Line 3076: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3072: p_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);

Line 3080: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3082: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3078: p_msg_data=>x_msg_data,
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;

Line 3085: p_msg_level=>fnd_log.level_procedure);

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:
3088: -- Check if API is called in debug mode. If yes, disable debug.
3089: --disable_debug;

Line 3101: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3097: p_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);

Line 3105: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3107: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3103: p_msg_data=>x_msg_data,
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;

Line 3110: p_msg_level=>fnd_log.level_procedure);

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:
3113: -- Check if API is called in debug mode. If yes, disable debug.
3114: --disable_debug;

Line 3130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3126: p_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);

Line 3134: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3132: p_msg_data=>x_msg_data,
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;

Line 3139: p_msg_level=>fnd_log.level_procedure);

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:
3142: -- Check if API is called in debug mode. If yes, disable debug.
3143: --disable_debug;

Line 3202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3198: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 3205: p_msg_level=>fnd_log.level_procedure);

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:
3208: -- Initialize message list if p_init_msg_list is set to TRUE.
3209: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3257: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3253: p_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);

Line 3261: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 3263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3259: p_msg_data=>x_msg_data,
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;

Line 3266: p_msg_level=>fnd_log.level_procedure);

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:
3269:
3270: -- Check if API is called in debug mode. If yes, disable debug.

Line 3284: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3280: p_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);

Line 3288: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3286: p_msg_data=>x_msg_data,
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;

Line 3293: p_msg_level=>fnd_log.level_procedure);

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:
3296: -- Check if API is called in debug mode. If yes, disable debug.
3297: --disable_debug;

Line 3309: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3305: p_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);

Line 3313: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3311: p_msg_data=>x_msg_data,
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;

Line 3318: p_msg_level=>fnd_log.level_procedure);

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:
3321: -- Check if API is called in debug mode. If yes, disable debug.
3322: --disable_debug;

Line 3338: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3334: p_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);

Line 3342: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3344: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3340: p_msg_data=>x_msg_data,
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;

Line 3347: p_msg_level=>fnd_log.level_procedure);

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:
3350: -- Check if API is called in debug mode. If yes, disable debug.
3351: --disable_debug;

Line 3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3398: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 3405: p_msg_level=>fnd_log.level_procedure);

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:
3408: -- Initialize message list if p_init_msg_list is set to TRUE.
3409: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3424:
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;

Line 3431: p_msg_level=>fnd_log.level_procedure);

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:
3434: -- Call table-handler.
3435: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (

Line 3523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3519: X_PENALTY_SCHEDULE_ID => x_cust_profile_amt_rec.penalty_schedule_id
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;

Line 3526: p_msg_level=>fnd_log.level_procedure);

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:
3529: -- Standard call to get message count and if count is 1, get message info.
3530: FND_MSG_PUB.Count_And_Get(

Line 3536: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3532: p_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);

Line 3540: p_msg_level=>fnd_log.level_exception);

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;
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,

Line 3542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3538: p_msg_data=>x_msg_data,
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;

Line 3545: p_msg_level=>fnd_log.level_procedure);

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:
3548: -- Check if API is called in debug mode. If yes, disable debug.
3549: --disable_debug;

Line 3561: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3557: p_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);

Line 3565: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3563: p_msg_data=>x_msg_data,
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;

Line 3570: p_msg_level=>fnd_log.level_procedure);

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:
3573: -- Check if API is called in debug mode. If yes, disable debug.
3574: --disable_debug;

Line 3585: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3581: p_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);

Line 3589: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3587: p_msg_data=>x_msg_data,
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;

Line 3594: p_msg_level=>fnd_log.level_procedure);

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:
3597: -- Check if API is called in debug mode. If yes, disable debug.
3598: --disable_debug;

Line 3613: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3609: p_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);

Line 3617: p_msg_level=>fnd_log.level_error);

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;
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,

Line 3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3615: p_msg_data=>x_msg_data,
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;

Line 3622: p_msg_level=>fnd_log.level_procedure);

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:
3625: -- Check if API is called in debug mode. If yes, disable debug.
3626: --disable_debug;