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 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 560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

Line 566: p_msg_level=>fnd_log.level_statement);

562: 'v_action = '||v_action||' '||
563: 'v_entity_code = '||v_entity_code||' '||
564: 'v_entity_id = '||v_entity_id,
565: p_prefix=>l_debug_prefix,
566: p_msg_level=>fnd_log.level_statement);
567: END IF;
568:
569: BEGIN
570: OE_Holds_PUB.Process_Holds (

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

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

Line 589: p_msg_level=>fnd_log.level_statement);

585: 'l_return_status = '||l_return_status||' '||
586: 'l_msg_count = '||l_msg_count||' '||
587: 'l_msg_data = '||l_msg_data,
588: p_prefix=>l_debug_prefix,
589: p_msg_level=>fnd_log.level_statement);
590: END IF;
591: EXCEPTION
592: WHEN OTHERS THEN
593: -- Debug info.

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

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

Line 597: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 618: p_msg_level=>fnd_log.level_procedure);

614: -- Debug info.
615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
617: p_prefix=>l_debug_prefix,
618: p_msg_level=>fnd_log.level_procedure);
619: END IF;
620:
621: HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
622: X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,

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

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

Line 741: p_msg_level=>fnd_log.level_procedure);

737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
739: 'x_cust_account_profile_id = ' || x_cust_account_profile_id,
740: p_prefix=>l_debug_prefix,
741: p_msg_level=>fnd_log.level_procedure);
742: END IF;
743:
744: -- Now default in the profile amounts only if
745: -- p_create_profile_amt is TRUE. Otherwise, simply return.

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

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

Line 776: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 867: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 917: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1017: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1232: p_msg_level=>fnd_log.level_statement);

1228: 'v_action = '||v_action||' '||
1229: 'v_entity_code = '||v_entity_code||' '||
1230: 'v_entity_id = '||v_entity_id,
1231: p_prefix=>l_debug_prefix,
1232: p_msg_level=>fnd_log.level_statement);
1233: END IF;
1234:
1235: BEGIN
1236: OE_Holds_PUB.Process_Holds (

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

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

Line 1255: p_msg_level=>fnd_log.level_statement);

1251: 'l_return_status = '||l_return_status||' '||
1252: 'l_msg_count = '||l_msg_count||' '||
1253: 'l_msg_data = '||l_msg_data,
1254: p_prefix=>l_debug_prefix,
1255: p_msg_level=>fnd_log.level_statement);
1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: -- Debug info.

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

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

Line 1263: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 1284: p_msg_level=>fnd_log.level_procedure);

1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;
1286:
1287: HZ_CUSTOMER_PROFILES_PKG.Update_Row (
1288: X_Rowid => l_rowid,

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

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

Line 1405: p_msg_level=>fnd_log.level_procedure);

1401: -- Debug info.
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407:
1408: -- When the bill_level at the account profile is changed from 'ACCOUNT' to 'SITE',
1409: -- the bill_level for all the associated BFB enabled site uses should be

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

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

Line 1460: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1551: p_msg_level=>fnd_log.level_procedure);

1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;
1553:
1554: -- Check if a currency code already exist for this profile.
1555: -- If yes, update that amount. If not, create a new amount.

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

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

Line 1646: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1699: p_msg_level=>fnd_log.level_procedure);

1695: -- Debug info.
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'do_create_cust_profile_amt (+)' ,
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1701:
1702: -- Validate cust profile amt record
1703: HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt (

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

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

Line 1739: p_msg_level=>fnd_log.level_procedure);

1735: -- Debug info.
1736: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
1738: p_prefix=>l_debug_prefix,
1739: p_msg_level=>fnd_log.level_procedure);
1740: END IF;
1741:
1742: -- Bug 6472676
1743: -- Changed do_create_cust_profile_amt Procudure to get SITE_USE_ID value from Customer Profiles if

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

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

Line 1858: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1865: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1914: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 1986: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2083: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2090: p_msg_level=>fnd_log.level_procedure);

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

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

2240: -- Check if API is called in debug mode. If yes, enable debug.
2241: --enable_debug;
2242:
2243: -- Debug info.
2244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2245: hz_utility_v2pub.debug(p_message=>'create_customer_profile (+)',
2246: p_prefix=>l_debug_prefix,
2247: p_msg_level=>fnd_log.level_procedure);
2248: END IF;

Line 2247: p_msg_level=>fnd_log.level_procedure);

2243: -- Debug info.
2244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2245: hz_utility_v2pub.debug(p_message=>'create_customer_profile (+)',
2246: p_prefix=>l_debug_prefix,
2247: p_msg_level=>fnd_log.level_procedure);
2248: END IF;
2249:
2250: -- Initialize message list if p_init_msg_list is set to TRUE.
2251: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 2291: p_msg_level=>fnd_log.level_exception);

2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2295: p_prefix=>l_debug_prefix,

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

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

Line 2296: p_msg_level=>fnd_log.level_procedure);

2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2295: p_prefix=>l_debug_prefix,
2296: p_msg_level=>fnd_log.level_procedure);
2297: END IF;
2298:
2299: -- Check if API is called in debug mode. If yes, disable debug.
2300: --disable_debug;

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

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

Line 2316: p_msg_level=>fnd_log.level_error);

2312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2313: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2314: p_msg_data=>x_msg_data,
2315: p_msg_type=>'ERROR',
2316: p_msg_level=>fnd_log.level_error);
2317: END IF;
2318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2320: p_prefix=>l_debug_prefix,

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

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

Line 2321: p_msg_level=>fnd_log.level_procedure);

2317: END IF;
2318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2320: p_prefix=>l_debug_prefix,
2321: p_msg_level=>fnd_log.level_procedure);
2322: END IF;
2323:
2324: -- Check if API is called in debug mode. If yes, disable debug.
2325: --disable_debug;

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

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

Line 2340: p_msg_level=>fnd_log.level_error);

2336: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2337: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2338: p_msg_data=>x_msg_data,
2339: p_msg_type=>'UNEXPECTED ERROR',
2340: p_msg_level=>fnd_log.level_error);
2341: END IF;
2342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2343: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2344: p_prefix=>l_debug_prefix,

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

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

Line 2345: p_msg_level=>fnd_log.level_procedure);

2341: END IF;
2342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2343: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2344: p_prefix=>l_debug_prefix,
2345: p_msg_level=>fnd_log.level_procedure);
2346: END IF;
2347:
2348: -- Check if API is called in debug mode. If yes, disable debug.
2349: --disable_debug;

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

2360: p_encoded => FND_API.G_FALSE,
2361: p_count => x_msg_count,
2362: p_data => x_msg_data );
2363:
2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'SQL ERROR',
2368: p_msg_level=>fnd_log.level_error);

Line 2368: p_msg_level=>fnd_log.level_error);

2364: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2366: p_msg_data=>x_msg_data,
2367: p_msg_type=>'SQL ERROR',
2368: p_msg_level=>fnd_log.level_error);
2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2372: p_prefix=>l_debug_prefix,

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

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

Line 2373: p_msg_level=>fnd_log.level_procedure);

2369: END IF;
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'create_customer_profile (-)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:
2376: -- Check if API is called in debug mode. If yes, disable debug.
2377: --disable_debug;

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

2433: -- Check if API is called in debug mode. If yes, enable debug.
2434: --enable_debug;
2435:
2436: -- Debug info.
2437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2438: hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',
2439: p_prefix=>l_debug_prefix,
2440: p_msg_level=>fnd_log.level_procedure);
2441: END IF;

Line 2440: p_msg_level=>fnd_log.level_procedure);

2436: -- Debug info.
2437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2438: hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',
2439: p_prefix=>l_debug_prefix,
2440: p_msg_level=>fnd_log.level_procedure);
2441: END IF;
2442:
2443: -- Initialize message list if p_init_msg_list is set to TRUE.
2444: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 2495: p_msg_level=>fnd_log.level_exception);

2491: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2493: p_msg_data=>x_msg_data,
2494: p_msg_type=>'WARNING',
2495: p_msg_level=>fnd_log.level_exception);
2496: END IF;
2497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2498: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2499: p_prefix=>l_debug_prefix,

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

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

Line 2500: p_msg_level=>fnd_log.level_procedure);

2496: END IF;
2497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2498: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2499: p_prefix=>l_debug_prefix,
2500: p_msg_level=>fnd_log.level_procedure);
2501: END IF;
2502:
2503: -- Check if API is called in debug mode. If yes, disable debug.
2504: --disable_debug;

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

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

Line 2520: p_msg_level=>fnd_log.level_error);

2516: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2517: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2518: p_msg_data=>x_msg_data,
2519: p_msg_type=>'ERROR',
2520: p_msg_level=>fnd_log.level_error);
2521: END IF;
2522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2523: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2524: p_prefix=>l_debug_prefix,

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

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

Line 2525: p_msg_level=>fnd_log.level_procedure);

2521: END IF;
2522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2523: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2524: p_prefix=>l_debug_prefix,
2525: p_msg_level=>fnd_log.level_procedure);
2526: END IF;
2527:
2528: -- Check if API is called in debug mode. If yes, disable debug.
2529: --disable_debug;

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

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

Line 2544: p_msg_level=>fnd_log.level_error);

2540: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2541: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2542: p_msg_data=>x_msg_data,
2543: p_msg_type=>'UNEXPECTED ERROR',
2544: p_msg_level=>fnd_log.level_error);
2545: END IF;
2546: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2547: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2548: p_prefix=>l_debug_prefix,

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

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

Line 2549: p_msg_level=>fnd_log.level_procedure);

2545: END IF;
2546: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2547: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2548: p_prefix=>l_debug_prefix,
2549: p_msg_level=>fnd_log.level_procedure);
2550: END IF;
2551:
2552: -- Check if API is called in debug mode. If yes, disable debug.
2553: --disable_debug;

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

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

Line 2572: p_msg_level=>fnd_log.level_error);

2568: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2570: p_msg_data=>x_msg_data,
2571: p_msg_type=>'SQL ERROR',
2572: p_msg_level=>fnd_log.level_error);
2573: END IF;
2574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2575: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2576: p_prefix=>l_debug_prefix,

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

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

Line 2577: p_msg_level=>fnd_log.level_procedure);

2573: END IF;
2574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2575: hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
2576: p_prefix=>l_debug_prefix,
2577: p_msg_level=>fnd_log.level_procedure);
2578: END IF;
2579:
2580: -- Check if API is called in debug mode. If yes, disable debug.
2581: --disable_debug;

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

2628: -- Check if API is called in debug mode. If yes, enable debug.
2629: --enable_debug;
2630:
2631: -- Debug info.
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (+)',
2634: p_prefix=>l_debug_prefix,
2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;

Line 2635: p_msg_level=>fnd_log.level_procedure);

2631: -- Debug info.
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (+)',
2634: p_prefix=>l_debug_prefix,
2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;
2637:
2638: -- Initialize message list if p_init_msg_list is set to TRUE.
2639: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 2661: p_msg_level=>fnd_log.level_procedure);

2657: -- Debug info.
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
2660: p_prefix=>l_debug_prefix,
2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;
2663:
2664: -- Call table-handler.
2665: HZ_CUSTOMER_PROFILES_PKG.Select_Row (

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

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

Line 2781: p_msg_level=>fnd_log.level_procedure);

2777: -- Debug info.
2778: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2779: hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
2780: p_prefix=>l_debug_prefix,
2781: p_msg_level=>fnd_log.level_procedure);
2782: END IF;
2783:
2784: -- Standard call to get message count and if count is 1, get message info.
2785: FND_MSG_PUB.Count_And_Get(

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

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

Line 2795: p_msg_level=>fnd_log.level_exception);

2791: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2792: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2793: p_msg_data=>x_msg_data,
2794: p_msg_type=>'WARNING',
2795: p_msg_level=>fnd_log.level_exception);
2796: END IF;
2797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2799: p_prefix=>l_debug_prefix,

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

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

Line 2800: p_msg_level=>fnd_log.level_procedure);

2796: END IF;
2797: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2799: p_prefix=>l_debug_prefix,
2800: p_msg_level=>fnd_log.level_procedure);
2801: END IF;
2802:
2803: -- Check if API is called in debug mode. If yes, disable debug.
2804: --disable_debug;

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

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

Line 2820: p_msg_level=>fnd_log.level_error);

2816: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2817: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2818: p_msg_data=>x_msg_data,
2819: p_msg_type=>'ERROR',
2820: p_msg_level=>fnd_log.level_error);
2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2824: p_prefix=>l_debug_prefix,

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

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

Line 2825: p_msg_level=>fnd_log.level_procedure);

2821: END IF;
2822: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2823: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2824: p_prefix=>l_debug_prefix,
2825: p_msg_level=>fnd_log.level_procedure);
2826: END IF;
2827:
2828: -- Check if API is called in debug mode. If yes, disable debug.
2829: --disable_debug;

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

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

Line 2844: p_msg_level=>fnd_log.level_error);

2840: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'UNEXPECTED ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2848: p_prefix=>l_debug_prefix,

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

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

Line 2849: p_msg_level=>fnd_log.level_procedure);

2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2848: p_prefix=>l_debug_prefix,
2849: p_msg_level=>fnd_log.level_procedure);
2850: END IF;
2851:
2852: -- Check if API is called in debug mode. If yes, disable debug.
2853: --disable_debug;

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

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

Line 2872: p_msg_level=>fnd_log.level_error);

2868: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2870: p_msg_data=>x_msg_data,
2871: p_msg_type=>'SQL ERROR',
2872: p_msg_level=>fnd_log.level_error);
2873: END IF;
2874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2875: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2876: p_prefix=>l_debug_prefix,

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

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

Line 2877: p_msg_level=>fnd_log.level_procedure);

2873: END IF;
2874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2875: hz_utility_v2pub.debug(p_message=>'get_customer_profile_rec (-)',
2876: p_prefix=>l_debug_prefix,
2877: p_msg_level=>fnd_log.level_procedure);
2878: END IF;
2879:
2880: -- Check if API is called in debug mode. If yes, disable debug.
2881: --disable_debug;

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

2940: -- Check if API is called in debug mode. If yes, enable debug.
2941: --enable_debug;
2942:
2943: -- Debug info.
2944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2945: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (+)',
2946: p_prefix=>l_debug_prefix,
2947: p_msg_level=>fnd_log.level_procedure);
2948: END IF;

Line 2947: p_msg_level=>fnd_log.level_procedure);

2943: -- Debug info.
2944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2945: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (+)',
2946: p_prefix=>l_debug_prefix,
2947: p_msg_level=>fnd_log.level_procedure);
2948: END IF;
2949:
2950: -- Initialize message list if p_init_msg_list is set to TRUE.
2951: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 2990: p_msg_level=>fnd_log.level_exception);

2986: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2987: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2988: p_msg_data=>x_msg_data,
2989: p_msg_type=>'WARNING',
2990: p_msg_level=>fnd_log.level_exception);
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
2994: p_prefix=>l_debug_prefix,

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

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

Line 2995: p_msg_level=>fnd_log.level_procedure);

2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;
2997:
2998: -- Check if API is called in debug mode. If yes, disable debug.
2999: --disable_debug;

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

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

Line 3016: p_msg_level=>fnd_log.level_error);

3012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3014: p_msg_data=>x_msg_data,
3015: p_msg_type=>'ERROR',
3016: p_msg_level=>fnd_log.level_error);
3017: END IF;
3018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3019: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3020: p_prefix=>l_debug_prefix,

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

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

Line 3021: p_msg_level=>fnd_log.level_procedure);

3017: END IF;
3018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3019: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3020: p_prefix=>l_debug_prefix,
3021: p_msg_level=>fnd_log.level_procedure);
3022: END IF;
3023:
3024: -- Check if API is called in debug mode. If yes, disable debug.
3025: --disable_debug;

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

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

Line 3041: p_msg_level=>fnd_log.level_error);

3037: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3038: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3039: p_msg_data=>x_msg_data,
3040: p_msg_type=>'UNEXPECTED ERROR',
3041: p_msg_level=>fnd_log.level_error);
3042: END IF;
3043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3044: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3045: p_prefix=>l_debug_prefix,

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

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

Line 3046: p_msg_level=>fnd_log.level_procedure);

3042: END IF;
3043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3044: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3045: p_prefix=>l_debug_prefix,
3046: p_msg_level=>fnd_log.level_procedure);
3047: END IF;
3048:
3049: -- Check if API is called in debug mode. If yes, disable debug.
3050: --disable_debug;

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

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

Line 3070: p_msg_level=>fnd_log.level_error);

3066: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3068: p_msg_data=>x_msg_data,
3069: p_msg_type=>'SQL ERROR',
3070: p_msg_level=>fnd_log.level_error);
3071: END IF;
3072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3073: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3074: p_prefix=>l_debug_prefix,

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

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

Line 3075: p_msg_level=>fnd_log.level_procedure);

3071: END IF;
3072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3073: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amt (-)',
3074: p_prefix=>l_debug_prefix,
3075: p_msg_level=>fnd_log.level_procedure);
3076: END IF;
3077:
3078: -- Check if API is called in debug mode. If yes, disable debug.
3079: --disable_debug;

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

3134: -- Check if API is called in debug mode. If yes, enable debug.
3135: --enable_debug;
3136:
3137: -- Debug info.
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;

Line 3141: p_msg_level=>fnd_log.level_procedure);

3137: -- Debug info.
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;
3143:
3144: -- Initialize message list if p_init_msg_list is set to TRUE.
3145: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 3197: p_msg_level=>fnd_log.level_exception);

3193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3195: p_msg_data=>x_msg_data,
3196: p_msg_type=>'WARNING',
3197: p_msg_level=>fnd_log.level_exception);
3198: END IF;
3199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3200: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3201: p_prefix=>l_debug_prefix,

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

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

Line 3202: p_msg_level=>fnd_log.level_procedure);

3198: END IF;
3199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3200: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3201: p_prefix=>l_debug_prefix,
3202: p_msg_level=>fnd_log.level_procedure);
3203: END IF;
3204:
3205:
3206: -- Check if API is called in debug mode. If yes, disable debug.

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

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

Line 3224: p_msg_level=>fnd_log.level_error);

3220: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3221: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3222: p_msg_data=>x_msg_data,
3223: p_msg_type=>'ERROR',
3224: p_msg_level=>fnd_log.level_error);
3225: END IF;
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3228: p_prefix=>l_debug_prefix,

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

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

Line 3229: p_msg_level=>fnd_log.level_procedure);

3225: END IF;
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3228: p_prefix=>l_debug_prefix,
3229: p_msg_level=>fnd_log.level_procedure);
3230: END IF;
3231:
3232: -- Check if API is called in debug mode. If yes, disable debug.
3233: --disable_debug;

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

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

Line 3249: p_msg_level=>fnd_log.level_error);

3245: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3246: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3247: p_msg_data=>x_msg_data,
3248: p_msg_type=>'UNEXPECTED ERROR',
3249: p_msg_level=>fnd_log.level_error);
3250: END IF;
3251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3252: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3253: p_prefix=>l_debug_prefix,

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

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

Line 3254: p_msg_level=>fnd_log.level_procedure);

3250: END IF;
3251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3252: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3253: p_prefix=>l_debug_prefix,
3254: p_msg_level=>fnd_log.level_procedure);
3255: END IF;
3256:
3257: -- Check if API is called in debug mode. If yes, disable debug.
3258: --disable_debug;

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

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

Line 3278: p_msg_level=>fnd_log.level_error);

3274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3275: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3276: p_msg_data=>x_msg_data,
3277: p_msg_type=>'SQL ERROR',
3278: p_msg_level=>fnd_log.level_error);
3279: END IF;
3280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3281: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3282: p_prefix=>l_debug_prefix,

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

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

Line 3283: p_msg_level=>fnd_log.level_procedure);

3279: END IF;
3280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3281: hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
3282: p_prefix=>l_debug_prefix,
3283: p_msg_level=>fnd_log.level_procedure);
3284: END IF;
3285:
3286: -- Check if API is called in debug mode. If yes, disable debug.
3287: --disable_debug;

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

3334: -- Check if API is called in debug mode. If yes, enable debug.
3335: --enable_debug;
3336:
3337: -- Debug info.
3338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3339: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (+)',
3340: p_prefix=>l_debug_prefix,
3341: p_msg_level=>fnd_log.level_procedure);
3342: END IF;

Line 3341: p_msg_level=>fnd_log.level_procedure);

3337: -- Debug info.
3338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3339: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (+)',
3340: p_prefix=>l_debug_prefix,
3341: p_msg_level=>fnd_log.level_procedure);
3342: END IF;
3343:
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 3367: p_msg_level=>fnd_log.level_procedure);

3363: -- Debug info.
3364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3365: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
3366: p_prefix=>l_debug_prefix,
3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:
3370: -- Call table-handler.
3371: HZ_CUST_PROFILE_AMTS_PKG.Select_Row (

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

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

Line 3462: p_msg_level=>fnd_log.level_procedure);

3458: -- Debug info.
3459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
3461: p_prefix=>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_procedure);
3463: END IF;
3464:
3465: -- Standard call to get message count and if count is 1, get message info.
3466: FND_MSG_PUB.Count_And_Get(

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

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

Line 3476: p_msg_level=>fnd_log.level_exception);

3472: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3474: p_msg_data=>x_msg_data,
3475: p_msg_type=>'WARNING',
3476: p_msg_level=>fnd_log.level_exception);
3477: END IF;
3478: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3479: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3480: p_prefix=>l_debug_prefix,

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

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

Line 3481: p_msg_level=>fnd_log.level_procedure);

3477: END IF;
3478: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3479: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3480: p_prefix=>l_debug_prefix,
3481: p_msg_level=>fnd_log.level_procedure);
3482: END IF;
3483:
3484: -- Check if API is called in debug mode. If yes, disable debug.
3485: --disable_debug;

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

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

Line 3501: p_msg_level=>fnd_log.level_error);

3497: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3498: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3499: p_msg_data=>x_msg_data,
3500: p_msg_type=>'ERROR',
3501: p_msg_level=>fnd_log.level_error);
3502: END IF;
3503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3504: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3505: p_prefix=>l_debug_prefix,

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

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

Line 3506: p_msg_level=>fnd_log.level_procedure);

3502: END IF;
3503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3504: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3505: p_prefix=>l_debug_prefix,
3506: p_msg_level=>fnd_log.level_procedure);
3507: END IF;
3508:
3509: -- Check if API is called in debug mode. If yes, disable debug.
3510: --disable_debug;

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

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

Line 3525: p_msg_level=>fnd_log.level_error);

3521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3523: p_msg_data=>x_msg_data,
3524: p_msg_type=>'UNEXPECTED ERROR',
3525: p_msg_level=>fnd_log.level_error);
3526: END IF;
3527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3528: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3529: p_prefix=>l_debug_prefix,

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

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

Line 3530: p_msg_level=>fnd_log.level_procedure);

3526: END IF;
3527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3528: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3529: p_prefix=>l_debug_prefix,
3530: p_msg_level=>fnd_log.level_procedure);
3531: END IF;
3532:
3533: -- Check if API is called in debug mode. If yes, disable debug.
3534: --disable_debug;

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

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

Line 3553: p_msg_level=>fnd_log.level_error);

3549: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3550: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3551: p_msg_data=>x_msg_data,
3552: p_msg_type=>'SQL ERROR',
3553: p_msg_level=>fnd_log.level_error);
3554: END IF;
3555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3556: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3557: p_prefix=>l_debug_prefix,

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

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

Line 3558: p_msg_level=>fnd_log.level_procedure);

3554: END IF;
3555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3556: hz_utility_v2pub.debug(p_message=>'get_cust_profile_amt_rec (-)',
3557: p_prefix=>l_debug_prefix,
3558: p_msg_level=>fnd_log.level_procedure);
3559: END IF;
3560:
3561: -- Check if API is called in debug mode. If yes, disable debug.
3562: --disable_debug;