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.OKS_BILL_REC_PUB dependencies on FND_LOG

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

1387:
1388:
1389: BEGIN
1390:
1391: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1392: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.pre_terminate_amount.p_flag',
1393: 'Entering pre_terminate_amount with input parameters p_flag ' ||p_flag||' ,p_id '||p_id||' ,p_terminate_date '||to_char(p_terminate_date));
1394: END IF;
1395:

Line 1392: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.pre_terminate_amount.p_flag',

1388:
1389: BEGIN
1390:
1391: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1392: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.pre_terminate_amount.p_flag',
1393: 'Entering pre_terminate_amount with input parameters p_flag ' ||p_flag||' ,p_id '||p_id||' ,p_terminate_date '||to_char(p_terminate_date));
1394: END IF;
1395:
1396: x_return_status := OKC_API.G_RET_STS_SUCCESS ;

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

1433: x_period_start => l_period_start,
1434: x_period_type => l_period_type,
1435: x_price_uom => l_price_uom,
1436: x_return_status => l_return_status);
1437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1438: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.ppc_defaults',
1439: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1440: END IF;
1441: IF l_return_status <> 'S' THEN

Line 1438: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.ppc_defaults',

1434: x_period_type => l_period_type,
1435: x_price_uom => l_price_uom,
1436: x_return_status => l_return_status);
1437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1438: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.ppc_defaults',
1439: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1440: END IF;
1441: IF l_return_status <> 'S' THEN
1442: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1500:
1501:
1502: IF (l_lse_id = 46) THEN
1503:
1504: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1505: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination','Calling Subscription_termination');
1506: END IF;
1507:
1508: IF l_tang THEN

Line 1505: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination','Calling Subscription_termination');

1501:
1502: IF (l_lse_id = 46) THEN
1503:
1504: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1505: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination','Calling Subscription_termination');
1506: END IF;
1507:
1508: IF l_tang THEN
1509:

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

1545: END IF;
1546: ELSE
1547: IF (l_term_method = 'VOLUME') THEN
1548:
1549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1550: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.Volume_termination',
1551: 'usage period '||l_usage_period);
1552: END IF;
1553:

Line 1550: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.Volume_termination',

1546: ELSE
1547: IF (l_term_method = 'VOLUME') THEN
1548:
1549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1550: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.Volume_termination',
1551: 'usage period '||l_usage_period);
1552: END IF;
1553:
1554: terminate_amount(

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

1584: IF l_period_start IS NOT NULL AND
1585: l_period_type IS NOT NULL
1586: THEN
1587: IF l_lse_id in (12,13) THEN
1588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1589: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1590: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1591: END IF;
1592:

Line 1589: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',

1585: l_period_type IS NOT NULL
1586: THEN
1587: IF l_lse_id in (12,13) THEN
1588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1589: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1590: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1591: END IF;
1592:
1593: Get_Terminate_Amount

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

1605: RAISE G_EXCEPTION_HALT_VALIDATION;
1606: END IF;
1607: ELSE
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1611: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1612: END IF;
1613:

Line 1610: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',

1606: END IF;
1607: ELSE
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1611: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1612: END IF;
1613:
1614: Get_Term_Amt_Ppc

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

1654: x_period_start => l_period_start,
1655: x_period_type => l_period_type,
1656: x_price_uom => l_price_uom,
1657: x_return_status => l_return_status);
1658: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1659: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.ppc_defaults',
1660: ' After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1661: END IF;
1662:

Line 1659: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.ppc_defaults',

1655: x_period_type => l_period_type,
1656: x_price_uom => l_price_uom,
1657: x_return_status => l_return_status);
1658: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1659: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.ppc_defaults',
1660: ' After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1661: END IF;
1662:
1663: IF l_return_status <> 'S' THEN

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

1781: IF l_period_start IS NOT NULL AND
1782: l_period_type IS NOT NULL
1783: THEN
1784: IF line_rec.lse_id in (12,13) THEN
1785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1787: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1788: END IF;
1789: Get_Terminate_Amount

Line 1786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',

1782: l_period_type IS NOT NULL
1783: THEN
1784: IF line_rec.lse_id in (12,13) THEN
1785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1787: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1788: END IF;
1789: Get_Terminate_Amount
1790: (

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

1800: IF X_return_status <> 'S' THEN
1801: RAISE G_EXCEPTION_HALT_VALIDATION;
1802: END IF;
1803: ELSE
1804: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1806: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1807: END IF;
1808: Get_Term_Amt_Ppc

Line 1805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',

1801: RAISE G_EXCEPTION_HALT_VALIDATION;
1802: END IF;
1803: ELSE
1804: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1806: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1807: END IF;
1808: Get_Term_Amt_Ppc
1809: (P_termination_date => l_term_date,

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

1840: END LOOP;
1841: END IF;
1842: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1843: l_currency_code);
1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1846: 'Returning Credit amount X_Amount '||X_Amount);
1847: END IF;
1848: EXCEPTION

Line 1845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',

1841: END IF;
1842: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1843: l_currency_code);
1844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1846: 'Returning Credit amount X_Amount '||X_Amount);
1847: END IF;
1848: EXCEPTION
1849: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

2990: x_period_type => l_period_type,
2991: x_price_uom => l_price_uom,
2992: x_return_status => l_return_status);
2993:
2994: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2995: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_terminate_extwar.ppc_defaults',
2996: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
2997: END IF;
2998:

Line 2995: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_terminate_extwar.ppc_defaults',

2991: x_price_uom => l_price_uom,
2992: x_return_status => l_return_status);
2993:
2994: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2995: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_terminate_extwar.ppc_defaults',
2996: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
2997: END IF;
2998:
2999: IF l_return_status <> 'S' THEN

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

3112: -------------------------------------------------------------------------
3113: IF l_period_start is not null AND
3114: l_period_type is not null
3115: THEN
3116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3118: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3119: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3120: END IF;

Line 3117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',

3113: IF l_period_start is not null AND
3114: l_period_type is not null
3115: THEN
3116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3117: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3118: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3119: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3120: END IF;
3121: OKS_BILL_REC_PUB.Terminate_PPC

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

3286: x_period_type => l_period_type,
3287: x_price_uom => l_price_uom,
3288: x_return_status => l_return_status);
3289:
3290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3291: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_srvc.ppc_defaults',
3292: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3293: END IF;
3294:

Line 3291: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_srvc.ppc_defaults',

3287: x_price_uom => l_price_uom,
3288: x_return_status => l_return_status);
3289:
3290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3291: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_srvc.ppc_defaults',
3292: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3293: END IF;
3294:
3295: IF l_return_status <> 'S' THEN

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

3353: l_period_type IS NOT NULL AND
3354: p_termination_amount is NULL --- Bug# 5005401 Overiding the credit amount must overide PPC
3355: THEN
3356: IF l_date_rec.lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
3357: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3358: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Service',
3359: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3360: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3361: END IF;

Line 3358: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Service',

3354: p_termination_amount is NULL --- Bug# 5005401 Overiding the credit amount must overide PPC
3355: THEN
3356: IF l_date_rec.lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
3357: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3358: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Service',
3359: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3360: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3361: END IF;
3362:

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

3377: END IF;
3378: ELSE
3379: --For usage , period start should be SERVICE
3380: -- and amount based termination will be based on billing not on price uom
3381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3382: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',
3383: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3384: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3385: END IF;

Line 3382: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',

3378: ELSE
3379: --For usage , period start should be SERVICE
3380: -- and amount based termination will be based on billing not on price uom
3381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3382: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',
3383: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3384: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3385: END IF;
3386:

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

8722: x_period_type => l_period_type,
8723: x_price_uom => l_price_uom,
8724: x_return_status => l_return_status);
8725:
8726: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8727: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.ppc_defaults',
8728: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
8729: END IF;
8730:

Line 8727: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.ppc_defaults',

8723: x_price_uom => l_price_uom,
8724: x_return_status => l_return_status);
8725:
8726: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8727: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.ppc_defaults',
8728: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
8729: END IF;
8730:
8731:

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

8779: IF l_period_start IS NOT NULL AND
8780: l_period_type IS NOT NULL
8781: THEN
8782: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8784: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8785: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8786: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8787: END IF;

Line 8784: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',

8780: l_period_type IS NOT NULL
8781: THEN
8782: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8784: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8785: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8786: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8787: END IF;
8788: OKS_BILL_REC_PUB.Terminate_PPC

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

8800: RAISE G_EXCEPTION_HALT_VALIDATION;
8801: END IF;
8802: ELSE
8803: --This procedure will be called for usage amount based termination
8804: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8806: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8807: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8808: END IF;

Line 8805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',

8801: END IF;
8802: ELSE
8803: --This procedure will be called for usage amount based termination
8804: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8805: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8806: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8807: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8808: END IF;
8809: Create_trx_records(

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

9326: close l_hdr_curr_code ;
9327: l_header_id:= p_true_value_tbl(1).p_hdr_id;
9328: END IF;
9329:
9330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9331: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9332: ' l_termn_level = ' || l_termn_level);
9333: END IF;
9334:

Line 9331: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',

9327: l_header_id:= p_true_value_tbl(1).p_hdr_id;
9328: END IF;
9329:
9330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9331: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9332: ' l_termn_level = ' || l_termn_level);
9333: END IF;
9334:
9335: --npalepu removed the following code for bug # 5335312.

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

9402: END IF;
9403:
9404: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9405:
9406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9409: END IF;
9410:

Line 9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',

9403:
9404: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9405:
9406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9407: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9408: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9409: END IF;
9410:
9411: UPDATE OKC_K_LINES_B

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

9482: WHERE dnz_chr_id = l_hdr_id
9483: AND lse_id in ( 1,12,14,19,46))
9484: WHERE id = l_hdr_id ;
9485: End If;
9486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9487: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9488: 'After updating all tables for true values in case of cp');
9489: END IF;
9490: ELSIF l_termn_level = 'TL' then

Line 9487: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',

9483: AND lse_id in ( 1,12,14,19,46))
9484: WHERE id = l_hdr_id ;
9485: End If;
9486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9487: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9488: 'After updating all tables for true values in case of cp');
9489: END IF;
9490: ELSIF l_termn_level = 'TL' then
9491: -------------------------------------------------------------------------

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

9766: AND lse_id in ( 1,12,14,19,46))
9767: WHERE id = l_hdr_id ;
9768: END IF;
9769: END IF;
9770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9771: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9772: 'After updating all tables for true values in case of top line');
9773: END IF;
9774:

Line 9771: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',

9767: WHERE id = l_hdr_id ;
9768: END IF;
9769: END IF;
9770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9771: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9772: 'After updating all tables for true values in case of top line');
9773: END IF;
9774:
9775: ELSIF l_termn_level = 'HD' then

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

9781: FROM OKC_K_LINES_B
9782: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9783: AND lse_id in ( 1,12,14,19,46))
9784: WHERE id = p_true_value_tbl(1).p_hdr_id ;
9785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9787: 'After updating all tables for true values in case of header');
9788: END IF;
9789:

Line 9786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',

9782: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9783: AND lse_id in ( 1,12,14,19,46))
9784: WHERE id = p_true_value_tbl(1).p_hdr_id ;
9785: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9786: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9787: 'After updating all tables for true values in case of header');
9788: END IF;
9789:
9790: END IF;

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

10005: --Loop through the sublines and find the subline details
10006:
10007: FOR cur in covlvl_line(p_top_line_id,p_cp_line_id) LOOP
10008:
10009: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10010: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10011: 'p_top_line_id '||p_top_line_id||' ,p_cp_line_id '||p_cp_line_id);
10012: END IF;
10013:

Line 10010: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10006:
10007: FOR cur in covlvl_line(p_top_line_id,p_cp_line_id) LOOP
10008:
10009: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10010: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10011: 'p_top_line_id '||p_top_line_id||' ,p_cp_line_id '||p_cp_line_id);
10012: END IF;
10013:
10014: IF p_termination_date < cur.start_date THEN

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

10119: p_period_start => p_period_start);
10120:
10121: END IF;
10122:
10123: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10124: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10125: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10126: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10127: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);

Line 10124: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10120:
10121: END IF;
10122:
10123: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10124: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10125: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10126: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10127: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);
10128: END IF;

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

10139: IF l_termination_amount > cur.total_amount THEN
10140: l_termination_amount := cur.total_amount;
10141: END IF;
10142:
10143: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10144: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10145: ' l_termination_amount '||l_termination_amount);
10146: END IF;
10147:

Line 10144: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10140: l_termination_amount := cur.total_amount;
10141: END IF;
10142:
10143: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10144: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10145: ' l_termination_amount '||l_termination_amount);
10146: END IF;
10147:
10148: OPEN total_billed_csr(cur.id);

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

10153:
10154: -- Calculate the unbilled amount
10155: l_unbilled_amount := cur.total_Amount - l_billed_Amount ;
10156:
10157: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10158: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10159: ' l_unbilled_amount '||l_unbilled_amount);
10160: END IF;
10161:

Line 10158: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10154: -- Calculate the unbilled amount
10155: l_unbilled_amount := cur.total_Amount - l_billed_Amount ;
10156:
10157: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10158: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10159: ' l_unbilled_amount '||l_unbilled_amount);
10160: END IF;
10161:
10162: open l_hdr_curr_code(cur.dnz_chr_id);

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

10181: SET UBT_AMOUNT = l_ubt_amount
10182: WHERE cle_id = cur.id;
10183:
10184:
10185: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10186: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10187: ' l_new_price '||l_new_price);
10188: END IF;
10189:

Line 10186: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10182: WHERE cle_id = cur.id;
10183:
10184:
10185: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10186: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10187: ' l_new_price '||l_new_price);
10188: END IF;
10189:
10190: IF l_termination_amount > l_unbilled_amount THEN

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

10189:
10190: IF l_termination_amount > l_unbilled_amount THEN
10191: l_credit_amount := l_termination_amount - l_unbilled_amount;
10192:
10193: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10194: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10195: ' l_credit_amount '||l_credit_amount);
10196: END IF;
10197:

Line 10194: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10190: IF l_termination_amount > l_unbilled_amount THEN
10191: l_credit_amount := l_termination_amount - l_unbilled_amount;
10192:
10193: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10194: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10195: ' l_credit_amount '||l_credit_amount);
10196: END IF;
10197:
10198: --Loop through All the sublines and tie the credit amount

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

10208: ELSE
10209: --last iteration: This is a partial amount
10210: l_term_amount := l_credit_amount;
10211: END IF;
10212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10213: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10214: ' l_credit_amount '||l_term_amount);
10215: END IF;
10216: Create_trx_records(

Line 10213: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10209: --last iteration: This is a partial amount
10210: l_term_amount := l_credit_amount;
10211: END IF;
10212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10213: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10214: ' l_credit_amount '||l_term_amount);
10215: END IF;
10216: Create_trx_records(
10217: p_called_from => p_called_from,

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

10238: ELSIF l_termination_amount < l_unbilled_amount AND
10239: l_termination_date <= nvl(l_max_date_billed_to,cur.start_date-1) THEN
10240:
10241: l_invoice_amount := l_unbilled_amount - l_termination_amount;
10242: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10243: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10244: ' l_invoice_amount '||l_invoice_amount);
10245: END IF;
10246: FOR bs_rec in l_line_BS_csr(cur.id,l_max_date_billed_to)

Line 10243: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10239: l_termination_date <= nvl(l_max_date_billed_to,cur.start_date-1) THEN
10240:
10241: l_invoice_amount := l_unbilled_amount - l_termination_amount;
10242: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10243: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10244: ' l_invoice_amount '||l_invoice_amount);
10245: END IF;
10246: FOR bs_rec in l_line_BS_csr(cur.id,l_max_date_billed_to)
10247: LOOP

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

10254: ELSE
10255: --last iteration: This is a partial amount
10256: l_inv_amount := l_invoice_amount;
10257: END IF;
10258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10259: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10260: ' l_inv_amount '||l_inv_amount);
10261: END IF;
10262: Create_trx_records(

Line 10259: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',

10255: --last iteration: This is a partial amount
10256: l_inv_amount := l_invoice_amount;
10257: END IF;
10258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10259: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10260: ' l_inv_amount '||l_inv_amount);
10261: END IF;
10262: Create_trx_records(
10263: p_called_from => 1,

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

10518: END IF;
10519:
10520:
10521:
10522: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10523: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10524: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '|| nvl(covlvl_rec.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10525: ||'result l_quantity '||l_quantity);
10526: END IF;

Line 10523: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',

10519:
10520:
10521:
10522: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10523: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10524: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '|| nvl(covlvl_rec.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10525: ||'result l_quantity '||l_quantity);
10526: END IF;
10527:

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

10533: IF l_termination_amount > covlvl_rec.total_amount THEN
10534: l_termination_amount := covlvl_rec.total_amount;
10535: END IF;
10536:
10537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10538: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10539: 'l_termination_amount '||l_termination_amount);
10540: END IF;
10541:

Line 10538: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',

10534: l_termination_amount := covlvl_rec.total_amount;
10535: END IF;
10536:
10537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10538: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10539: 'l_termination_amount '||l_termination_amount);
10540: END IF;
10541:
10542: --Get the total billed amount and max date Billed to and max date billed from of the

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

10546: l_max_date_billed_from,
10547: l_max_date_billed_to;
10548: CLOSE total_billed_csr;
10549:
10550: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10551: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10552: 'l_billed_Amount '||l_billed_Amount||', total amount = '||covlvl_rec.total_Amount);
10553: END IF;
10554:

Line 10551: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',

10547: l_max_date_billed_to;
10548: CLOSE total_billed_csr;
10549:
10550: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10551: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10552: 'l_billed_Amount '||l_billed_Amount||', total amount = '||covlvl_rec.total_Amount);
10553: END IF;
10554:
10555: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;

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

10553: END IF;
10554:
10555: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;
10556:
10557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10558: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10559: 'l_unbilled_amount '||l_unbilled_amount);
10560: END IF;
10561:

Line 10558: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',

10554:
10555: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;
10556:
10557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10558: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10559: 'l_unbilled_amount '||l_unbilled_amount);
10560: END IF;
10561:
10562: IF l_termination_amount > l_unbilled_amount THEN

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

10562: IF l_termination_amount > l_unbilled_amount THEN
10563: x_amount := l_termination_amount - l_unbilled_amount;
10564: END IF;
10565:
10566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10567: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10568: 'x_amount '||x_amount);
10569: END IF;
10570: END IF; --l_line_end_date >= l_termination_date

Line 10567: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',

10563: x_amount := l_termination_amount - l_unbilled_amount;
10564: END IF;
10565:
10566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10567: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10568: 'x_amount '||x_amount);
10569: END IF;
10570: END IF; --l_line_end_date >= l_termination_date
10571:

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

10682:
10683: END IF;
10684:
10685:
10686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10687: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10688: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10689: ||'result l_quantity '||l_quantity);
10690: END IF;

Line 10687: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',

10683: END IF;
10684:
10685:
10686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10687: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10688: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom '||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10689: ||'result l_quantity '||l_quantity);
10690: END IF;
10691:

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

10700: l_termination_amount := cur.total_amount;
10701: END IF;
10702:
10703:
10704: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10705: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10706: 'l_termination_amount '||l_termination_amount);
10707: END IF;
10708: --Get the total billed amount and max date Billed to and max date billed from of the

Line 10705: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',

10701: END IF;
10702:
10703:
10704: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10705: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10706: 'l_termination_amount '||l_termination_amount);
10707: END IF;
10708: --Get the total billed amount and max date Billed to and max date billed from of the
10709: --subline

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

10721: x_amount:= nvl(x_amount,0) + nvl(l_credit_amount,0);
10722: END IF; --l_line_end_date >= l_termination_date
10723: END LOOP;
10724:
10725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10726: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10727: 'x_amount '||x_amount);
10728: END IF;
10729:

Line 10726: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',

10722: END IF; --l_line_end_date >= l_termination_date
10723: END LOOP;
10724:
10725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10726: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10727: 'x_amount '||x_amount);
10728: END IF;
10729:
10730: END IF;

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

10933: p_period_type => P_period_type,
10934: p_period_start => p_period_start
10935: );
10936:
10937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10938: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10939: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type||' P_termination_date '||to_char(P_termination_date)
10940: ||'result l_quantity '||l_quantity);
10941: END IF;

Line 10938: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',

10934: p_period_start => p_period_start
10935: );
10936:
10937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10938: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10939: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type||' P_termination_date '||to_char(P_termination_date)
10940: ||'result l_quantity '||l_quantity);
10941: END IF;
10942:

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

10951: p_period_type => P_period_type,
10952: p_period_start => p_period_start
10953: );
10954:
10955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10956: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10957: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10958: ||'result l_total_quantity '||l_total_quantity);
10959: END IF;

Line 10956: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',

10952: p_period_start => p_period_start
10953: );
10954:
10955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10956: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
10957: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with p_source_uom'||P_uom||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10958: ||'result l_total_quantity '||l_total_quantity);
10959: END IF;
10960: