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

Line 193: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

189:
190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : START ');
191:
192: IF (G_DEBUG_ENABLED = 'Y') THEN
193: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
194: END IF;
195:
196: SAVEPOINT UPDATE_CRT;
197: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 199: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure_reports');

195:
196: SAVEPOINT UPDATE_CRT;
197: IF (G_IS_DEBUG_STATEMENT_ON = true)
198: THEN
199: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure_reports');
200: END IF;
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:

Line 235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);

231: THEN
232: Get_Messages (l_msg_count,l_message);
233: IF (G_IS_DEBUG_STATEMENT_ON = true)
234: THEN
235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);
236: END IF;
237: raise FND_API.G_EXC_ERROR;
238: ELSE
239: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');

237: raise FND_API.G_EXC_ERROR;
238: ELSE
239: IF (G_IS_DEBUG_STATEMENT_ON = true)
240: THEN
241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
242: END IF;
243: FND_MSG_PUB.initialize;
244: END IF;
245:

Line 253: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

249: );
250:
251: IF (G_IS_DEBUG_STATEMENT_ON = true)
252: THEN
253: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
254: , G_MODULE,
255: ' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CRT');
256: END IF;
257:

Line 326: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

322: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : START ');
323:
324: IF (G_DEBUG_ENABLED = 'Y')
325: THEN
326: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
327: END IF;
328:
329: SAVEPOINT UPDATE_CAM;
330:

Line 333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure amounts');

329: SAVEPOINT UPDATE_CAM;
330:
331: IF (G_IS_DEBUG_STATEMENT_ON = true)
332: THEN
333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure amounts');
334: END IF;
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: -- update Cure amounts table set error message,so this will be prefixed before

Line 370: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

366: IF (l_rule_value = 'Yes')
367: THEN
368: IF (G_IS_DEBUG_STATEMENT_ON = true)
369: THEN
370: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
371: , G_MODULE
372: ,' Short fund rule is applicable');
373: END IF;
374: lp_camv_rec.short_fund_amount := nvl(l_cure_amount,0)

Line 421: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);

417: THEN
418: Get_Messages (l_msg_count,l_message);
419: IF (G_IS_DEBUG_STATEMENT_ON = true)
420: THEN
421: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);
422: END IF;
423: raise FND_API.G_EXC_ERROR;
424: ELSE
425: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure amounts table ');

423: raise FND_API.G_EXC_ERROR;
424: ELSE
425: IF (G_IS_DEBUG_STATEMENT_ON = true)
426: THEN
427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure amounts table ');
428: END IF;
429: END IF;
430:
431: END LOOP;

Line 440: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

436: p_data => x_msg_data
437: );
438:
439: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
440: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
441: , G_MODULE
442: ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CAM');
443:
444: END IF;

Line 531: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

527: SAVEPOINT UPDATE_INVOICE_HDR_LINES;
528:
529: IF (G_IS_DEBUG_STATEMENT_ON = true)
530: THEN
531: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
532: , G_MODULE
533: , 'start UPDATE_INVOICE_HDR_LINES');
534: END IF;
535: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 577: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

573: THEN
574: Get_Messages (l_msg_count,l_message);
575: IF (G_IS_DEBUG_STATEMENT_ON = true)
576: THEN
577: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
578: , G_MODULE
579: ,'Error in updating okl_trx_ar_invoices_b '||l_message);
580: END IF;
581: raise FND_API.G_EXC_ERROR;

Line 615: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

611: THEN
612: Get_Messages (l_msg_count,l_message);
613: IF (G_IS_DEBUG_STATEMENT_ON = true)
614: THEN
615: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
616: , G_MODULE
617: ,'Error in updating okl_txl_ar_inv_lns '||l_message);
618: END IF;
619: raise FND_API.G_EXC_ERROR;

Line 670: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

666: );
667:
668: IF (G_IS_DEBUG_STATEMENT_ON = true)
669: THEN
670: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
671: , G_MODULE
672: ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_INVOICE_HDR_LINES');
673: END IF;
674:

Line 759: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

755: BEGIN
756: -- Set API savepoint
757: SAVEPOINT additional_tld_attr;
758: IF (G_DEBUG_ENABLED = 'Y') THEN
759: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
760: END IF;
761:
762: --Print Input Variables
763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);

760: END IF;
761:
762: --Print Input Variables
763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);
765: END IF;
766: -- Check for call compatibility
767: IF (NOT FND_API.Compatible_API_Call (l_api_version,
768: p_api_version,

Line 1020: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

1016:
1017: SAVEPOINT INSERT_INVOICE_HDR_LINES;
1018: IF (G_IS_DEBUG_STATEMENT_ON = true)
1019: THEN
1020: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
1021: , G_MODULE
1022: , 'start INSERT_INVOICE_HDR_LINES');
1023: END IF;
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1078: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'khrid '||lp_taiv_rec.khr_id);

1074: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.org_id : '||lp_taiv_rec.org_id);
1075:
1076: IF (G_IS_DEBUG_STATEMENT_ON = true)
1077: THEN
1078: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'khrid '||lp_taiv_rec.khr_id);
1079: END IF;
1080:
1081: IF lp_taiv_rec.khr_id IS NULL
1082: THEN

Line 1098: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'trxid '||lp_taiv_rec.try_id);

1094: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.try_id : '||lp_taiv_rec.try_id);
1095:
1096: IF (G_IS_DEBUG_STATEMENT_ON = true)
1097: THEN
1098: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'trxid '||lp_taiv_rec.try_id);
1099: END IF;
1100:
1101: IF lp_taiv_rec.try_id IS NULL
1102: THEN

Line 1124: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'sty_id '||lp_tilv_rec.sty_id);

1120: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_tilv_rec.sty_id : '||lp_tilv_rec.sty_id);
1121:
1122: IF (G_IS_DEBUG_STATEMENT_ON = true)
1123: THEN
1124: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'sty_id '||lp_tilv_rec.sty_id);
1125: END IF;
1126:
1127: IF lp_tilv_rec.sty_id IS NULL
1128: THEN

Line 1157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'program Id' ||l_program_id);

1153: END IF;
1154:
1155: IF (G_IS_DEBUG_STATEMENT_ON = true)
1156: THEN
1157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'program Id' ||l_program_id);
1158: END IF;
1159:
1160: -- New code for bill to address START
1161: OPEN bill_to_csr (l_program_id);

Line 1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Bill To Address Id failed');

1167: IF trunc(l_bill_to_address_id) IS NULL
1168: THEN
1169: IF (G_IS_DEBUG_STATEMENT_ON = true)
1170: THEN
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Bill To Address Id failed');
1172: END IF;
1173: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
1174: p_msg_name => 'OKL_REQUIRED_VALUE',
1175: p_token1 => 'COL_NAME',

Line 1184: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill to address id from rule is ' || l_btc_id);

1180: l_btc_id :=l_bill_to_address_id;
1181:
1182: IF (G_IS_DEBUG_STATEMENT_ON = true)
1183: THEN
1184: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill to address id from rule is ' || l_btc_id);
1185: END IF;
1186:
1187: -- *****************************************************
1188: -- Extract Customer, Bill To and Payment Term from rules

Line 1207: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'value of irt' ||lp_taiv_rec.irt_id);

1203: IF lp_taiv_rec.irt_id IS NULL OR lp_taiv_rec.irt_id = FND_API.G_MISS_NUM
1204: THEN
1205: IF (G_IS_DEBUG_STATEMENT_ON = true)
1206: THEN
1207: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'value of irt' ||lp_taiv_rec.irt_id);
1208: END IF;
1209: OPEN l_std_terms_csr ( l_site_use_rec.cust_account_id,
1210: l_btc_id);
1211: FETCH l_std_terms_csr

Line 1236: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'value of irt--->' ||lp_taiv_rec.irt_id);

1232: END IF;
1233:
1234: IF (G_IS_DEBUG_STATEMENT_ON = true)
1235: THEN
1236: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'value of irt--->' ||lp_taiv_rec.irt_id);
1237: END IF;
1238:
1239: IF lp_taiv_rec.irt_id IS NULL OR lp_taiv_rec.irt_id = FND_API.G_MISS_NUM
1240: THEN

Line 1266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Payment method from rule is ' || l_id1);

1262: THEN
1263: lp_taiv_rec.irm_id :=l_id1;
1264: IF (G_IS_DEBUG_STATEMENT_ON = true)
1265: THEN
1266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Payment method from rule is ' || l_id1);
1267: END IF;
1268: ELSE
1269: IF (G_IS_DEBUG_STATEMENT_ON = true)
1270: THEN

Line 1271: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');

1267: END IF;
1268: ELSE
1269: IF (G_IS_DEBUG_STATEMENT_ON = true)
1270: THEN
1271: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Retrieval of Payment Method Id failed');
1272: END IF;
1273: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
1274: p_msg_name => 'OKL_REQUIRED_VALUE',
1275: p_token1 => 'COL_NAME',

Line 1290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'receipt method id is not found');

1286: IF lp_taiv_rec.irm_id IS NULL OR lp_taiv_rec.irm_id = FND_API.G_MISS_NUM
1287: THEN
1288: IF (G_IS_DEBUG_STATEMENT_ON = true)
1289: THEN
1290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'receipt method id is not found');
1291: END IF;
1292: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
1293: p_msg_name => 'OKL_REQUIRED_VALUE',
1294: p_token1 => 'COL_NAME',

Line 1325: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1321: -- R12 Changes - END
1322:
1323: IF (G_IS_DEBUG_STATEMENT_ON = true)
1324: THEN
1325: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1326: G_MODULE,
1327: 'taiv_rec.cpy_id' ||lp_taiv_rec.cpy_id ||
1328: ' taiv_rec.try_id' ||lp_taiv_rec.try_id||
1329: ' taiv_rec.khr_id' ||lp_taiv_rec.khr_id||

Line 1353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1349: THEN
1350: Get_Messages (l_msg_count,l_message);
1351: IF (G_IS_DEBUG_STATEMENT_ON = true)
1352: THEN
1353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1354: G_MODULE,
1355: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1356: END IF;
1357: raise FND_API.G_EXC_ERROR;

Line 1380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1376: -- R12 Change - END
1377:
1378: IF (G_IS_DEBUG_STATEMENT_ON = true)
1379: THEN
1380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1381: G_MODULE,
1382: 'tilv_rec.tai_id' ||lp_tilv_rec.tai_id||
1383: 'tilv_rec.amount' ||lp_tilv_rec.amount||
1384: 'tilv_rec.sty_id' ||lp_tilv_rec.sty_id);

Line 1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1398: THEN
1399: Get_Messages (l_msg_count,l_message);
1400: IF (G_IS_DEBUG_STATEMENT_ON = true)
1401: THEN
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1403: G_MODULE,
1404: 'Error in updating okl_txl_ar_inv_lns '||l_message);
1405: END IF;
1406: raise FND_API.G_EXC_ERROR;

Line 1500: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

1496: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1497: p_data => x_msg_data );
1498:
1499: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1500: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
1501: , G_MODULE
1502: ,' End of Procedure => OKL_PAY_RECON_PVT.INSERT_INVOICE_HDR_LINES');
1503: END IF;
1504:

Line 1571: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start TERMINATE_QUOTE');

1567:
1568: SAVEPOINT TERMINATE_QUOTE;
1569: IF (G_IS_DEBUG_STATEMENT_ON = true)
1570: THEN
1571: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start TERMINATE_QUOTE');
1572: END IF;
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: --set error message,so this will be prefixed before the actual message, so it

Line 1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1601: THEN
1602: Get_Messages (l_msg_count,l_message);
1603: IF (G_IS_DEBUG_STATEMENT_ON = true)
1604: THEN
1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1606: G_MODULE,
1607: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1609: G_MODULE,

Line 1608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1604: THEN
1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1606: G_MODULE,
1607: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1609: G_MODULE,
1610: 'Error from the API : ' ||l_err_msg);
1611: END IF;
1612: raise FND_API.G_EXC_ERROR;

Line 1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1615: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1616: p_data => x_msg_data );
1617: IF (G_IS_DEBUG_STATEMENT_ON = true)
1618: THEN
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1620: G_MODULE,
1621: ' End of Procedure =>OKL_PAY_RECON_PVT.TERMINATE_QUOTE');
1622: END IF;
1623:

Line 1683: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1679: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : START ');
1680:
1681: IF (G_DEBUG_ENABLED = 'Y')
1682: THEN
1683: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1684: END IF;
1685:
1686: SAVEPOINT UPDATE_TAI_TIL;
1687: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 1689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_TAI_TIL');

1685:
1686: SAVEPOINT UPDATE_TAI_TIL;
1687: IF (G_IS_DEBUG_STATEMENT_ON = true)
1688: THEN
1689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_TAI_TIL');
1690: END IF;
1691: x_return_status := FND_API.G_RET_STS_SUCCESS;
1692:
1693: -- if cpy_id is populated then we will update the TAI tables

Line 1752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1748: THEN
1749: Get_Messages (l_msg_count,l_message);
1750: IF (G_IS_DEBUG_STATEMENT_ON = true)
1751: THEN
1752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1753: G_MODULE,
1754: 'Error in update tai_til :' ||l_message);
1755: END IF;
1756: raise FND_API.G_EXC_ERROR;

Line 1775: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1771: THEN
1772: Get_Messages (l_msg_count,l_message);
1773: IF (G_IS_DEBUG_STATEMENT_ON = true)
1774: THEN
1775: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1776: G_MODULE,
1777: 'Error in Termination of Quote :' ||l_message);
1778: END IF;
1779: raise FND_API.G_EXC_ERROR;

Line 1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1787: p_data => x_msg_data);
1788:
1789: IF (G_IS_DEBUG_STATEMENT_ON = true)
1790: THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1792: G_MODULE,
1793: ' End of Procedure =>OKL_PAY_RECON_PVT.UPDATE_TAI_TIL');
1794: END IF;
1795:

Line 1848: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1844: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_report_id : '||p_report_id);
1845: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_invoice_date : '||p_invoice_date);
1846:
1847: IF (G_DEBUG_ENABLED = 'Y') THEN
1848: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1849: END IF;
1850:
1851: -- step 1 create TAI ab
1852: -- step 2 update CAM

Line 1863: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_INVOICES');

1859:
1860: SAVEPOINT UPDATE_INVOICES;
1861: IF (G_IS_DEBUG_STATEMENT_ON = true)
1862: THEN
1863: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_INVOICES');
1864: END IF;
1865: x_return_status := FND_API.G_RET_STS_SUCCESS;
1866:
1867: UPDATE_TAI_TIL(p_cam_tbl =>p_cam_tbl,

Line 1879: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1875: THEN
1876: Get_Messages (l_msg_count,l_message);
1877: IF (G_IS_DEBUG_STATEMENT_ON = true)
1878: THEN
1879: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1880: G_MODULE,
1881: 'Error in updating cure amounts:'||l_message);
1882: END IF;
1883: raise FND_API.G_EXC_ERROR;

Line 1897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1893: THEN
1894: Get_Messages (l_msg_count,l_message);
1895: IF (G_IS_DEBUG_STATEMENT_ON = true)
1896: THEN
1897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1898: G_MODULE,
1899: 'Error in updating cure amounts:'||l_message);
1900: END IF;
1901: raise FND_API.G_EXC_ERROR;

Line 1915: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);

1911: THEN
1912: Get_Messages (l_msg_count,l_message);
1913: IF (G_IS_DEBUG_STATEMENT_ON = true)
1914: THEN
1915: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);
1916: END IF;
1917: raise FND_API.G_EXC_ERROR;
1918: ELSE
1919: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 1921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');

1917: raise FND_API.G_EXC_ERROR;
1918: ELSE
1919: IF (G_IS_DEBUG_STATEMENT_ON = true)
1920: THEN
1921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
1922: END IF;
1923: END IF;
1924:
1925: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1930: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

1926: p_data => x_msg_data );
1927:
1928: IF (G_IS_DEBUG_STATEMENT_ON = true)
1929: THEN
1930: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
1931: G_MODULE,
1932: ' End of Procedure =>OKL_PAY_RECON_PVT.update_invoices');
1933: END IF;
1934:

Line 2124: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2120:
2121: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : START ');
2122:
2123: IF (G_DEBUG_ENABLED = 'Y') THEN
2124: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2125: END IF;
2126:
2127: SAVEPOINT CREATE_ACCOUNTING;
2128: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 2130: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start submit_cure_invoices');

2126:
2127: SAVEPOINT CREATE_ACCOUNTING;
2128: IF (G_IS_DEBUG_STATEMENT_ON = true)
2129: THEN
2130: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start submit_cure_invoices');
2131: END IF;
2132: x_return_status := FND_API.G_RET_STS_SUCCESS;
2133:
2134: FOR i in p_cam_tbl.FIRST..p_cam_tbl.LAST

Line 2277: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2273: raise FND_API.G_EXC_ERROR;
2274: ELSE
2275: IF (G_IS_DEBUG_STATEMENT_ON = true)
2276: THEN
2277: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2278: G_MODULE,
2279: 'l_acc_gen_primary_key_tbl'
2280: --||l_acc_gen_primary_key_tbl(1).count
2281: ||l_acc_gen_primary_key_tbl(1).primary_key_column

Line 2411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);

2407: THEN
2408: Get_Messages (l_msg_count,l_message);
2409: IF (G_IS_DEBUG_STATEMENT_ON = true)
2410: THEN
2411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error' ||l_message);
2412: END IF;
2413: raise FND_API.G_EXC_ERROR;
2414: ELSE
2415: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 2417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);

2413: raise FND_API.G_EXC_ERROR;
2414: ELSE
2415: IF (G_IS_DEBUG_STATEMENT_ON = true)
2416: THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);
2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);
2419: END IF;
2420: FND_MSG_PUB.initialize;
2421: END IF;

Line 2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);

2414: ELSE
2415: IF (G_IS_DEBUG_STATEMENT_ON = true)
2416: THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);
2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);
2419: END IF;
2420: FND_MSG_PUB.initialize;
2421: END IF;
2422: END IF ;-- IF p.cam.tbl(i).Process ='CURE'

Line 2427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2423: END LOOP;
2424:
2425: IF (G_IS_DEBUG_STATEMENT_ON = true)
2426: THEN
2427: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2428: G_MODULE,
2429: 'after accounting dist '||l_return_status);
2430: END IF;
2431:

Line 2436: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2432: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2433: p_data => x_msg_data );
2434: IF (G_IS_DEBUG_STATEMENT_ON = true)
2435: THEN
2436: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2437: G_MODULE,
2438: ' End of Procedure =>OKL_PAY_RECON_PVT.CREATE_ACCOUNTING');
2439: END IF;
2440:

Line 2492: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2488:
2489: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : START ');
2490:
2491: IF (G_DEBUG_ENABLED = 'Y') THEN
2492: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2493: END IF;
2494:
2495: SAVEPOINT SUBMIT_INVOICES;
2496: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 2498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start submit_cure_invoices');

2494:
2495: SAVEPOINT SUBMIT_INVOICES;
2496: IF (G_IS_DEBUG_STATEMENT_ON = true)
2497: THEN
2498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start submit_cure_invoices');
2499: END IF;
2500: x_return_status := FND_API.G_RET_STS_SUCCESS;
2501:
2502: UPDATE_TAI_TIL(p_cam_tbl =>p_cam_tbl,

Line 2516: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2512: THEN
2513: Get_Messages (l_msg_count,l_message);
2514: IF (G_IS_DEBUG_STATEMENT_ON = true)
2515: THEN
2516: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2517: G_MODULE,
2518: 'Error in updating cure amounts:'||l_message);
2519: END IF;
2520: raise FND_API.G_EXC_ERROR;

Line 2535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2531: THEN
2532: Get_Messages (l_msg_count,l_message);
2533: IF (G_IS_DEBUG_STATEMENT_ON = true)
2534: THEN
2535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2536: G_MODULE,
2537: 'Error in Creating distributions'||l_message);
2538: END IF;
2539: raise FND_API.G_EXC_ERROR;

Line 2555: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2551: THEN
2552: Get_Messages (l_msg_count,l_message);
2553: IF (G_IS_DEBUG_STATEMENT_ON = true)
2554: THEN
2555: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2556: G_MODULE,
2557: 'Error in updating cure amounts:'||l_message);
2558: END IF;
2559: raise FND_API.G_EXC_ERROR;

Line 2575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);

2571: THEN
2572: Get_Messages (l_msg_count,l_message);
2573: IF (G_IS_DEBUG_STATEMENT_ON = true)
2574: THEN
2575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);
2576: END IF;
2577: raise FND_API.G_EXC_ERROR;
2578: ELSE
2579: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 2581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');

2577: raise FND_API.G_EXC_ERROR;
2578: ELSE
2579: IF (G_IS_DEBUG_STATEMENT_ON = true)
2580: THEN
2581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
2582: END IF;
2583: END IF;
2584:
2585: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2586: p_data => x_msg_data );
2587:
2588: IF (G_IS_DEBUG_STATEMENT_ON = true)
2589: THEN
2590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2591: G_MODULE,
2592: ' End of Procedure => OKL_PAY_RECON_PVT.submit_Cure_invoices');
2593:
2594: END IF;

Line 2650: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2646: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : START ');
2647:
2648: IF (G_DEBUG_ENABLED = 'Y')
2649: THEN
2650: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2651: END IF;
2652:
2653: SAVEPOINT UPDATE_CURE_INVOICE_PVT;
2654: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2660: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Operation is Update');

2656: IF p_operation ='UPDATE'
2657: THEN
2658: IF (G_IS_DEBUG_STATEMENT_ON = true)
2659: THEN
2660: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Operation is Update');
2661: END IF;
2662: Update_invoices (p_cam_tbl =>p_cam_tbl,
2663: p_report_id =>p_report_id,
2664: p_invoice_date =>p_invoice_date,

Line 2674: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Operation is Submit');

2670:
2671: ELSE
2672: IF (G_IS_DEBUG_STATEMENT_ON = true)
2673: THEN
2674: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Operation is Submit');
2675: END IF;
2676: submit_invoices(p_cam_tbl =>p_cam_tbl,
2677: p_report_id =>p_report_id,
2678: --p_invoice_date =>SYSDATE,

Line 2692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);

2688: THEN
2689: Get_Messages (l_msg_count,l_message);
2690: IF (G_IS_DEBUG_STATEMENT_ON = true)
2691: THEN
2692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error is :' ||l_message);
2693: END IF;
2694: raise FND_API.G_EXC_ERROR;
2695: ELSE
2696: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 2698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices updated');

2694: raise FND_API.G_EXC_ERROR;
2695: ELSE
2696: IF (G_IS_DEBUG_STATEMENT_ON = true)
2697: THEN
2698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices updated');
2699: END IF;
2700: END IF;
2701:
2702: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2707: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

2703: p_data => x_msg_data);
2704:
2705: IF (G_IS_DEBUG_STATEMENT_ON = true)
2706: THEN
2707: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,
2708: G_MODULE,
2709: ' End of Procedure => OKL_PAY_RECON_PVT.update_Cure_invoices');
2710: END IF;
2711: