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 1410: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

1406:
1407:
1408: BEGIN
1409:
1410: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1411: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.pre_terminate_amount.p_flag',
1412: 'Entering pre_terminate_amount with input parameters p_flag ' ||p_flag||' ,p_id '||p_id||' ,p_terminate_date '||to_char(p_terminate_date));
1413: END IF;
1414:

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

1407:
1408: BEGIN
1409:
1410: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1411: fnd_log.string(fnd_log.level_procedure,G_MODULE_CURRENT||'.pre_terminate_amount.p_flag',
1412: 'Entering pre_terminate_amount with input parameters p_flag ' ||p_flag||' ,p_id '||p_id||' ,p_terminate_date '||to_char(p_terminate_date));
1413: END IF;
1414:
1415: x_return_status := OKC_API.G_RET_STS_SUCCESS ;

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

1447: x_period_start => l_period_start,
1448: x_period_type => l_period_type,
1449: x_price_uom => l_price_uom,
1450: x_return_status => l_return_status);
1451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1452: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.ppc_defaults',
1453: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1454: END IF;
1455: IF l_return_status <> 'S' THEN

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

1448: x_period_type => l_period_type,
1449: x_price_uom => l_price_uom,
1450: x_return_status => l_return_status);
1451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1452: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.ppc_defaults',
1453: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1454: END IF;
1455: IF l_return_status <> 'S' THEN
1456: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1514:
1515:
1516: IF (l_lse_id = 46) THEN
1517:
1518: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1519: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination','Calling Subscription_termination');
1520: END IF;
1521:
1522: IF l_tang THEN

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

1515:
1516: IF (l_lse_id = 46) THEN
1517:
1518: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1519: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination','Calling Subscription_termination');
1520: END IF;
1521:
1522: IF l_tang THEN
1523:

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

1559: END IF;
1560: ELSE
1561: IF (l_term_method = 'VOLUME') THEN
1562:
1563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1564: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.Volume_termination',
1565: 'usage period '||l_usage_period);
1566: END IF;
1567:

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

1560: ELSE
1561: IF (l_term_method = 'VOLUME') THEN
1562:
1563: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1564: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.Volume_termination',
1565: 'usage period '||l_usage_period);
1566: END IF;
1567:
1568: terminate_amount(

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

1598: IF l_period_start IS NOT NULL AND
1599: l_period_type IS NOT NULL
1600: THEN
1601: IF l_lse_id in (12,13) THEN
1602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1603: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1604: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1605: END IF;
1606:

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

1599: l_period_type IS NOT NULL
1600: THEN
1601: IF l_lse_id in (12,13) THEN
1602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1603: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1604: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1605: END IF;
1606:
1607: Get_Terminate_Amount

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

1619: RAISE G_EXCEPTION_HALT_VALIDATION;
1620: END IF;
1621: ELSE
1622:
1623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1624: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1625: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1626: END IF;
1627:

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

1620: END IF;
1621: ELSE
1622:
1623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1624: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.line_termination.PPC',
1625: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1626: END IF;
1627:
1628: Get_Term_Amt_Ppc

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

1668: x_period_start => l_period_start,
1669: x_period_type => l_period_type,
1670: x_price_uom => l_price_uom,
1671: x_return_status => l_return_status);
1672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1673: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.ppc_defaults',
1674: ' After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1675: END IF;
1676:

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

1669: x_period_type => l_period_type,
1670: x_price_uom => l_price_uom,
1671: x_return_status => l_return_status);
1672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1673: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.ppc_defaults',
1674: ' After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
1675: END IF;
1676:
1677: IF l_return_status <> 'S' THEN

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

1795: IF l_period_start IS NOT NULL AND
1796: l_period_type IS NOT NULL
1797: THEN
1798: IF line_rec.lse_id in (12,13) THEN
1799: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1800: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1801: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1802: END IF;
1803: Get_Terminate_Amount

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

1796: l_period_type IS NOT NULL
1797: THEN
1798: IF line_rec.lse_id in (12,13) THEN
1799: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1800: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1801: 'Calling Get_Terminate_Amount for usage with l_cov_line '||l_cov_line);
1802: END IF;
1803: Get_Terminate_Amount
1804: (

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

1814: IF X_return_status <> 'S' THEN
1815: RAISE G_EXCEPTION_HALT_VALIDATION;
1816: END IF;
1817: ELSE
1818: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1819: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1820: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1821: END IF;
1822: Get_Term_Amt_Ppc

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

1815: RAISE G_EXCEPTION_HALT_VALIDATION;
1816: END IF;
1817: ELSE
1818: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1819: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount.hdr_termination.PPC',
1820: 'Calling Get_Term_Amt_Ppc for service with l_cov_line '||l_cov_line);
1821: END IF;
1822: Get_Term_Amt_Ppc
1823: (P_termination_date => l_term_date,

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

1854: END LOOP;
1855: END IF;
1856: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1857: l_currency_code);
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1860: 'Returning Credit amount X_Amount '||X_Amount);
1861: END IF;
1862: EXCEPTION

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

1855: END IF;
1856: X_Amount := OKS_EXTWAR_UTIL_PVT.round_currency_amt(final_amount ,
1857: l_currency_code);
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_amount',
1860: 'Returning Credit amount X_Amount '||X_Amount);
1861: END IF;
1862: EXCEPTION
1863: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

3004: x_period_type => l_period_type,
3005: x_price_uom => l_price_uom,
3006: x_return_status => l_return_status);
3007:
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3009: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_terminate_extwar.ppc_defaults',
3010: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3011: END IF;
3012:

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

3005: x_price_uom => l_price_uom,
3006: x_return_status => l_return_status);
3007:
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3009: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_terminate_extwar.ppc_defaults',
3010: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3011: END IF;
3012:
3013: IF l_return_status <> 'S' THEN

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

3126: -------------------------------------------------------------------------
3127: IF l_period_start is not null AND
3128: l_period_type is not null
3129: THEN
3130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3131: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3132: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3133: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3134: END IF;

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

3127: IF l_period_start is not null AND
3128: l_period_type is not null
3129: THEN
3130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3131: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_Extwar',
3132: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters P_period_start '||l_period_start||', P_period_type '||l_period_type
3133: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3134: END IF;
3135: OKS_BILL_REC_PUB.Terminate_PPC

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

3310: x_period_type => l_period_type,
3311: x_price_uom => l_price_uom,
3312: x_return_status => l_return_status);
3313:
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3315: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_srvc.ppc_defaults',
3316: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3317: END IF;
3318:

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

3311: x_price_uom => l_price_uom,
3312: x_return_status => l_return_status);
3313:
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3315: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.pre_terminate_srvc.ppc_defaults',
3316: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
3317: END IF;
3318:
3319: IF l_return_status <> 'S' THEN

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

3377: l_period_type IS NOT NULL AND
3378: p_termination_amount is NULL --- Bug# 5005401 Overiding the credit amount must overide PPC
3379: THEN
3380: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN /* Modified for Bug#14647106*/
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.Service',
3383: 'calling OKS_BILL_REC_PUB.Terminate_PPC 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.Service',

3378: p_termination_amount is NULL --- Bug# 5005401 Overiding the credit amount must overide PPC
3379: THEN
3380: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN /* Modified for Bug#14647106*/
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.Service',
3383: 'calling OKS_BILL_REC_PUB.Terminate_PPC 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 3405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3401: END IF;
3402: ELSE
3403: --For usage , period start should be SERVICE
3404: -- and amount based termination will be based on billing not on price uom
3405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3406: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',
3407: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3408: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3409: END IF;

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

3402: ELSE
3403: --For usage , period start should be SERVICE
3404: -- and amount based termination will be based on billing not on price uom
3405: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3406: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Pre_Terminate_srvc.Usage',
3407: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
3408: ||' P_override_amount ' ||p_termination_amount||'p_con_terminate_amount '||p_con_termination_amount||' ,P_suppress_credit'||P_suppress_credit);
3409: END IF;
3410:

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

8762: x_period_type => l_period_type,
8763: x_price_uom => l_price_uom,
8764: x_return_status => l_return_status);
8765:
8766: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8767: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.ppc_defaults',
8768: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
8769: END IF;
8770:

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

8763: x_price_uom => l_price_uom,
8764: x_return_status => l_return_status);
8765:
8766: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8767: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.ppc_defaults',
8768: 'After calling OKS_RENEW_UTIL_PUB.Get_Period_Defaults l_period_start ' ||l_period_start||' ,l_period_type '||l_period_type);
8769: END IF;
8770:
8771:

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

8819: IF l_period_start IS NOT NULL AND
8820: l_period_type IS NOT NULL
8821: THEN
8822: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8823: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8824: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8825: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8826: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8827: END IF;

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

8820: l_period_type IS NOT NULL
8821: THEN
8822: IF l_lse_id <> 13 OR nvl(l_usage_type,'XYZ') = 'NPR' THEN
8823: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8824: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Service',
8825: 'calling OKS_BILL_REC_PUB.Terminate_PPC with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8826: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8827: END IF;
8828: OKS_BILL_REC_PUB.Terminate_PPC

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

8840: RAISE G_EXCEPTION_HALT_VALIDATION;
8841: END IF;
8842: ELSE
8843: --This procedure will be called for usage amount based termination
8844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8846: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8847: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8848: END IF;

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

8841: END IF;
8842: ELSE
8843: --This procedure will be called for usage amount based termination
8844: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8845: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_cp.Usage',
8846: 'calling OKS_BILL_REC_PUB.Create_trx_records with parameters l_period_start '||l_period_start||', l_period_type '||l_period_type
8847: ||' P_override_amount ' ||p_override_amount||'p_con_terminate_amount '||p_con_terminate_amount||' ,P_suppress_credit'||P_suppress_credit);
8848: END IF;
8849: Create_trx_records(

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

9376: close l_hdr_curr_code ;
9377: l_header_id:= p_true_value_tbl(1).p_hdr_id;
9378: END IF;
9379:
9380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9381: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9382: ' l_termn_level = ' || l_termn_level);
9383: END IF;
9384:

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

9377: l_header_id:= p_true_value_tbl(1).p_hdr_id;
9378: END IF;
9379:
9380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9381: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9382: ' l_termn_level = ' || l_termn_level);
9383: END IF;
9384:
9385: --npalepu removed the following code for bug # 5335312.

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

9454: END IF;
9455:
9456: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9457:
9458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9459: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9460: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9461: END IF;
9462:

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

9455:
9456: l_true_value := OKS_EXTWAR_UTIL_PVT.round_currency_amt(l_true_value,l_currency_code);
9457:
9458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9459: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9460: 'Before updating okc_k_lines_b for subline l_true_value = ' || l_true_value);
9461: END IF;
9462:
9463: UPDATE OKC_K_LINES_B

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

9544: WHERE dnz_chr_id = l_hdr_id
9545: AND lse_id in ( 1,12,14,19,46))
9546: WHERE id = l_hdr_id ;
9547: End If;
9548: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9549: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9550: 'After updating all tables for true values in case of cp');
9551: END IF;
9552: ELSIF l_termn_level = 'TL' then

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

9545: AND lse_id in ( 1,12,14,19,46))
9546: WHERE id = l_hdr_id ;
9547: End If;
9548: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9549: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9550: 'After updating all tables for true values in case of cp');
9551: END IF;
9552: ELSIF l_termn_level = 'TL' then
9553: -------------------------------------------------------------------------

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

9853: AND lse_id in ( 1,12,14,19,46))
9854: WHERE id = l_hdr_id ;
9855: END IF;
9856: END IF;
9857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9858: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9859: 'After updating all tables for true values in case of top line');
9860: END IF;
9861:

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

9854: WHERE id = l_hdr_id ;
9855: END IF;
9856: END IF;
9857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9858: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9859: 'After updating all tables for true values in case of top line');
9860: END IF;
9861:
9862: ELSIF l_termn_level = 'HD' then

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

9868: FROM OKC_K_LINES_B
9869: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9870: AND lse_id in ( 1,12,14,19,46))
9871: WHERE id = p_true_value_tbl(1).p_hdr_id ;
9872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9873: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9874: 'After updating all tables for true values in case of header');
9875: END IF;
9876:

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

9869: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9870: AND lse_id in ( 1,12,14,19,46))
9871: WHERE id = p_true_value_tbl(1).p_hdr_id ;
9872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9873: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.TRUE_VALUE',
9874: 'After updating all tables for true values in case of header');
9875: END IF;
9876:
9877: END IF;

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

10097: --Loop through the sublines and find the subline details
10098:
10099: FOR cur in covlvl_line(p_top_line_id,p_cp_line_id) LOOP
10100:
10101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10102: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10103: 'p_top_line_id '||p_top_line_id||' ,p_cp_line_id '||p_cp_line_id);
10104: END IF;
10105:

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

10098:
10099: FOR cur in covlvl_line(p_top_line_id,p_cp_line_id) LOOP
10100:
10101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10102: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10103: 'p_top_line_id '||p_top_line_id||' ,p_cp_line_id '||p_cp_line_id);
10104: END IF;
10105:
10106: IF p_termination_date < cur.start_date THEN

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

10211: p_period_start => p_period_start);
10212:
10213: END IF;
10214:
10215: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10216: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10217: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10218: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10219: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);

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

10212:
10213: END IF;
10214:
10215: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10216: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10217: 'After calling OKS_TIME_MEASURES_PUB.get_quantity with end date '||l_line_end_date||' ,p_source_uom '
10218: ||nvl(cur.price_uom,l_uom)||' p_period_start ' ||p_period_start||' ,p_period_type '||p_period_type
10219: ||' l_termination_date '||to_char(l_termination_date)||'result l_quantity '||l_quantity);
10220: END IF;

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

10231: IF l_termination_amount > cur.total_amount and cur.total_amount >0 THEN ----Added the condition cur.total_amount>0 for bug 11773025
10232: l_termination_amount := cur.total_amount;
10233: END IF;
10234:
10235: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10236: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10237: ' l_termination_amount '||l_termination_amount);
10238: END IF;
10239:

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

10232: l_termination_amount := cur.total_amount;
10233: END IF;
10234:
10235: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10236: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10237: ' l_termination_amount '||l_termination_amount);
10238: END IF;
10239:
10240: OPEN total_billed_csr(cur.id);

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

10245:
10246: -- Calculate the unbilled amount
10247: l_unbilled_amount := cur.total_Amount - l_billed_Amount ;
10248:
10249: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10250: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10251: ' l_unbilled_amount '||l_unbilled_amount);
10252: END IF;
10253:

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

10246: -- Calculate the unbilled amount
10247: l_unbilled_amount := cur.total_Amount - l_billed_Amount ;
10248:
10249: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10250: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10251: ' l_unbilled_amount '||l_unbilled_amount);
10252: END IF;
10253:
10254: open l_hdr_curr_code(cur.dnz_chr_id);

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

10273: SET UBT_AMOUNT = l_ubt_amount
10274: WHERE cle_id = cur.id;
10275:
10276:
10277: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10278: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10279: ' l_new_price '||l_new_price);
10280: END IF;
10281: -----Credit Amounts passed to the AR are incorrect in case of Negative Amount Lines.So modified the cond for bug 11773025

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

10274: WHERE cle_id = cur.id;
10275:
10276:
10277: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10278: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10279: ' l_new_price '||l_new_price);
10280: END IF;
10281: -----Credit Amounts passed to the AR are incorrect in case of Negative Amount Lines.So modified the cond for bug 11773025
10282: IF (cur.total_amount <0 and l_unbilled_amount >= l_termination_amount AND l_max_date_billed_to >= l_termination_date)

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

10286: ELSE
10287: l_credit_amount := l_termination_amount - l_unbilled_amount;
10288: END IF;
10289:
10290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10291: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10292: ' l_credit_amount '||l_credit_amount);
10293: END IF;
10294:

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

10287: l_credit_amount := l_termination_amount - l_unbilled_amount;
10288: END IF;
10289:
10290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10291: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10292: ' l_credit_amount '||l_credit_amount);
10293: END IF;
10294:
10295: /*Added for bug 14250216 */

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

10324: l_term_amount := l_term_amount * -1;
10325: END IF;
10326: /*Added for bug 11773025*/
10327:
10328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10329: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10330: ' l_credit_amount '||l_term_amount);
10331: END IF;
10332: Create_trx_records(

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

10325: END IF;
10326: /*Added for bug 11773025*/
10327:
10328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10329: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10330: ' l_credit_amount '||l_term_amount);
10331: END IF;
10332: Create_trx_records(
10333: p_called_from => p_called_from,

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

10355: ELSIF l_termination_amount < l_unbilled_amount AND
10356: l_termination_date <= nvl(l_max_date_billed_to,cur.start_date-1) THEN
10357:
10358: l_invoice_amount := l_unbilled_amount - l_termination_amount;
10359: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10360: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10361: ' l_invoice_amount '||l_invoice_amount);
10362: END IF;
10363: FOR bs_rec in l_line_BS_csr(cur.id,l_max_date_billed_to)

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

10356: l_termination_date <= nvl(l_max_date_billed_to,cur.start_date-1) THEN
10357:
10358: l_invoice_amount := l_unbilled_amount - l_termination_amount;
10359: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10360: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10361: ' l_invoice_amount '||l_invoice_amount);
10362: END IF;
10363: FOR bs_rec in l_line_BS_csr(cur.id,l_max_date_billed_to)
10364: LOOP

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

10371: ELSE
10372: --last iteration: This is a partial amount
10373: l_inv_amount := l_invoice_amount;
10374: END IF;
10375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10376: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10377: ' l_inv_amount '||l_inv_amount);
10378: END IF;
10379: Create_trx_records(

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

10372: --last iteration: This is a partial amount
10373: l_inv_amount := l_invoice_amount;
10374: END IF;
10375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10376: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Terminate_Ppc',
10377: ' l_inv_amount '||l_inv_amount);
10378: END IF;
10379: Create_trx_records(
10380: p_called_from => 1,

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

10636: END IF;
10637:
10638:
10639:
10640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10641: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10642: '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
10643: ||'result l_quantity '||l_quantity);
10644: END IF;

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

10637:
10638:
10639:
10640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10641: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10642: '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
10643: ||'result l_quantity '||l_quantity);
10644: END IF;
10645:

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

10651: IF l_termination_amount > covlvl_rec.total_amount and covlvl_rec.total_amount >0 THEN -----Added the condition covlvl_rec.total_amount for bug 11773025
10652: l_termination_amount := covlvl_rec.total_amount;
10653: END IF;
10654:
10655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10656: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10657: 'l_termination_amount '||l_termination_amount);
10658: END IF;
10659:

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

10652: l_termination_amount := covlvl_rec.total_amount;
10653: END IF;
10654:
10655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10656: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10657: 'l_termination_amount '||l_termination_amount);
10658: END IF;
10659:
10660: --Get the total billed amount and max date Billed to and max date billed from of the

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

10664: l_max_date_billed_from,
10665: l_max_date_billed_to;
10666: CLOSE total_billed_csr;
10667:
10668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10669: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10670: 'l_billed_Amount '||l_billed_Amount||', total amount = '||covlvl_rec.total_Amount);
10671: END IF;
10672:

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

10665: l_max_date_billed_to;
10666: CLOSE total_billed_csr;
10667:
10668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10669: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10670: 'l_billed_Amount '||l_billed_Amount||', total amount = '||covlvl_rec.total_Amount);
10671: END IF;
10672:
10673: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;

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

10671: END IF;
10672:
10673: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;
10674:
10675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10676: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10677: 'l_unbilled_amount '||l_unbilled_amount);
10678: END IF;
10679:

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

10672:
10673: l_unbilled_amount := covlvl_rec.total_Amount - l_billed_Amount;
10674:
10675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10676: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10677: 'l_unbilled_amount '||l_unbilled_amount);
10678: END IF;
10679:
10680: /*Modified the condi for bug 11773025*/

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

10689: x_amount := l_termination_amount - l_unbilled_amount;
10690: END IF;
10691: /*Modified the condi for bug 11773025*/
10692:
10693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10694: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10695: 'x_amount '||x_amount);
10696: END IF;
10697: END IF; --l_line_end_date >= l_termination_date

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

10690: END IF;
10691: /*Modified the condi for bug 11773025*/
10692:
10693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10694: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.cov_line',
10695: 'x_amount '||x_amount);
10696: END IF;
10697: END IF; --l_line_end_date >= l_termination_date
10698:

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

10807:
10808: END IF;
10809:
10810:
10811: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10812: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10813: '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
10814: ||'result l_quantity '||l_quantity);
10815: END IF;

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

10808: END IF;
10809:
10810:
10811: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10812: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10813: '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
10814: ||'result l_quantity '||l_quantity);
10815: END IF;
10816:

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

10825: l_termination_amount := cur.total_amount;
10826: END IF;
10827:
10828:
10829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10830: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10831: 'l_termination_amount '||l_termination_amount);
10832: END IF;
10833: --Get the total billed amount and max date Billed to and max date billed from of the

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

10826: END IF;
10827:
10828:
10829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10830: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10831: 'l_termination_amount '||l_termination_amount);
10832: END IF;
10833: --Get the total billed amount and max date Billed to and max date billed from of the
10834: --subline

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

10854: END IF;
10855: /*Modified the condition for bug 11773025*/
10856:
10857:
10858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10859: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10860: 'l_credit_amount '||l_credit_amount);
10861: End IF;
10862:

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

10855: /*Modified the condition for bug 11773025*/
10856:
10857:
10858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10859: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10860: 'l_credit_amount '||l_credit_amount);
10861: End IF;
10862:
10863: --Sum of credit amounts for all the sublines of the topline

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

10863: --Sum of credit amounts for all the sublines of the topline
10864: x_amount:= nvl(x_amount,0) + nvl(l_credit_amount,0);
10865:
10866:
10867: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10868: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10869: 'x_amount '||x_amount);
10870: End If;
10871: END IF; --l_line_end_date >= l_termination_date

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

10864: x_amount:= nvl(x_amount,0) + nvl(l_credit_amount,0);
10865:
10866:
10867: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10868: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10869: 'x_amount '||x_amount);
10870: End If;
10871: END IF; --l_line_end_date >= l_termination_date
10872: END LOOP;

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

10870: End If;
10871: END IF; --l_line_end_date >= l_termination_date
10872: END LOOP;
10873:
10874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10875: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10876: 'x_amount '||x_amount);
10877: END IF;
10878:

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

10871: END IF; --l_line_end_date >= l_termination_date
10872: END LOOP;
10873:
10874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
10875: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_Term_Amt_Ppc.line',
10876: 'x_amount '||x_amount);
10877: END IF;
10878:
10879: END IF;

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

11082: p_period_type => P_period_type,
11083: p_period_start => p_period_start
11084: );
11085:
11086: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11087: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11088: '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)
11089: ||'result l_quantity '||l_quantity);
11090: END IF;

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

11083: p_period_start => p_period_start
11084: );
11085:
11086: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11087: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11088: '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)
11089: ||'result l_quantity '||l_quantity);
11090: END IF;
11091:

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

11100: p_period_type => P_period_type,
11101: p_period_start => p_period_start
11102: );
11103:
11104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11105: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11106: '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
11107: ||'result l_total_quantity '||l_total_quantity);
11108: END IF;

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

11101: p_period_start => p_period_start
11102: );
11103:
11104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11105: fnd_log.string(fnd_log.level_statement,G_MODULE_CURRENT||'.Get_partial_term_amount',
11106: '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
11107: ||'result l_total_quantity '||l_total_quantity);
11108: END IF;
11109: