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 OKL_CURE_RECON_PVT

Line 1: PACKAGE BODY OKL_CURE_RECON_PVT AS

1: PACKAGE BODY OKL_CURE_RECON_PVT AS
2: /* $Header: OKLRRCOB.pls 120.16 2008/05/12 10:08:39 akrangan noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.cure.request.OKL_CURE_RECON_PVT';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 4: G_MODULE VARCHAR2(255) := 'okl.cure.request.OKL_CURE_RECON_PVT';

1: PACKAGE BODY OKL_CURE_RECON_PVT AS
2: /* $Header: OKLRRCOB.pls 120.16 2008/05/12 10:08:39 akrangan noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.cure.request.OKL_CURE_RECON_PVT';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7:
8: --private procedure

Line 190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : START ');

186: xp_crtv_rec OKL_crt_pvt.crtv_rec_type;
187:
188: BEGIN
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;

Line 216: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.cure_report_id : '||lp_crtv_rec.cure_report_id);

212: OPEN c_get_obj_ver(p_report_id);
213: FETCH c_get_obj_ver INTO lp_crtv_rec.object_version_number;
214: CLOSE c_get_obj_ver;
215:
216: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.cure_report_id : '||lp_crtv_rec.cure_report_id);
217: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.approval_status : '||lp_crtv_rec.approval_status);
218:
219: okl_cure_reports_pub.update_cure_reports(
220: p_api_version =>1.0

Line 217: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.approval_status : '||lp_crtv_rec.approval_status);

213: FETCH c_get_obj_ver INTO lp_crtv_rec.object_version_number;
214: CLOSE c_get_obj_ver;
215:
216: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.cure_report_id : '||lp_crtv_rec.cure_report_id);
217: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.approval_status : '||lp_crtv_rec.approval_status);
218:
219: okl_cure_reports_pub.update_cure_reports(
220: p_api_version =>1.0
221: ,p_init_msg_list =>FND_API.G_FALSE

Line 228: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : okl_cure_reports_pub.update_cure_reports : '||l_return_status);

224: ,x_msg_data =>l_msg_data
225: ,p_crtv_rec =>lp_crtv_rec
226: ,x_crtv_rec =>xp_crtv_rec);
227:
228: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : okl_cure_reports_pub.update_cure_reports : '||l_return_status);
229:
230: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
231: THEN
232: Get_Messages (l_msg_count,l_message);

Line 258: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : END ');

254: , G_MODULE,
255: ' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CRT');
256: END IF;
257:
258: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : END ');
259:
260: EXCEPTION
261: WHEN Fnd_Api.G_EXC_ERROR THEN
262: ROLLBACK TO UPDATE_CRT;

Line 322: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : START ');

318: l_id2 VARCHAR2(200);
319:
320: BEGIN
321:
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);

Line 362: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_contract_info.get_rule_value : '||l_return_status);

358: ,x_id1 => l_id1
359: ,x_id2 => l_id2
360: ,x_value => l_rule_value);
361:
362: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_contract_info.get_rule_value : '||l_return_status);
363:
364: IF l_return_status =FND_Api.G_RET_STS_SUCCESS
365: THEN
366: IF (l_rule_value = 'Yes')

Line 388: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.cure_amount_id : '||lp_camv_rec.cure_amount_id);

384: lp_camv_rec.cure_amount_id :=p_cam_tbl(i).cam_id;
385: lp_camv_rec.negotiated_amount :=p_cam_tbl(i).negotiated_amount;
386: lp_camv_rec.crt_id :=p_report_id;
387:
388: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.cure_amount_id : '||lp_camv_rec.cure_amount_id);
389: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.negotiated_amount : '||lp_camv_rec.negotiated_amount);
390: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.crt_id : '||lp_camv_rec.crt_id);
391:
392: --jsanju 09/24/03

Line 389: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.negotiated_amount : '||lp_camv_rec.negotiated_amount);

385: lp_camv_rec.negotiated_amount :=p_cam_tbl(i).negotiated_amount;
386: lp_camv_rec.crt_id :=p_report_id;
387:
388: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.cure_amount_id : '||lp_camv_rec.cure_amount_id);
389: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.negotiated_amount : '||lp_camv_rec.negotiated_amount);
390: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.crt_id : '||lp_camv_rec.crt_id);
391:
392: --jsanju 09/24/03
393: -- new column in cure amounts table ,indicating what action has been done.

Line 390: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.crt_id : '||lp_camv_rec.crt_id);

386: lp_camv_rec.crt_id :=p_report_id;
387:
388: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.cure_amount_id : '||lp_camv_rec.cure_amount_id);
389: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.negotiated_amount : '||lp_camv_rec.negotiated_amount);
390: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.crt_id : '||lp_camv_rec.crt_id);
391:
392: --jsanju 09/24/03
393: -- new column in cure amounts table ,indicating what action has been done.
394: -- possible values are 'CURE','REPURCHASE' & 'DONOTPROCESS'

Line 403: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.process : '||lp_camv_rec.process);

399: ELSE
400: lp_camv_rec.process := 'CURE';
401: END IF;
402:
403: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.process : '||lp_camv_rec.process);
404:
405: okl_cure_amounts_pub.update_cure_amounts(
406: p_api_version =>1.0
407: ,p_init_msg_list =>FND_API.G_FALSE

Line 414: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_cure_amounts_pub.update_cure_amounts : '||l_return_status);

410: ,x_msg_data =>l_msg_data
411: ,p_camv_rec =>lp_camv_rec
412: ,x_camv_rec =>xp_camv_rec);
413:
414: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_cure_amounts_pub.update_cure_amounts : '||l_return_status);
415:
416: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
417: THEN
418: Get_Messages (l_msg_count,l_message);

Line 446: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : END ');

442: ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CAM');
443:
444: END IF;
445:
446: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : END ');
447:
448: EXCEPTION
449: WHEN Fnd_Api.G_EXC_ERROR THEN
450: ROLLBACK TO UPDATE_CAM;

Line 521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');

517: xp_tldv_rec okl_tld_pvt.tldv_rec_type;
518:
519: BEGIN
520:
521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);

Line 522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);

518:
519: BEGIN
520:
521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
526:

Line 523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);

519: BEGIN
520:
521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
526:
527: SAVEPOINT UPDATE_INVOICE_HDR_LINES;

Line 524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);

520:
521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
526:
527: SAVEPOINT UPDATE_INVOICE_HDR_LINES;
528:

Line 525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);

521: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
522: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
523: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
524: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
525: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
526:
527: SAVEPOINT UPDATE_INVOICE_HDR_LINES;
528:
529: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 570: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);

566: x_msg_data => l_msg_data,
567: p_taiv_rec => lp_taiv_rec,
568: x_taiv_rec => xp_taiv_rec);
569:
570: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);
571:
572: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
573: THEN
574: Get_Messages (l_msg_count,l_message);

Line 608: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.update_txl_ar_inv_lns : '||l_return_status);

604: x_msg_data => l_msg_data,
605: p_tilv_rec => lp_tilv_rec,
606: x_tilv_rec => xp_tilv_rec);
607:
608: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.update_txl_ar_inv_lns : '||l_return_status);
609:
610: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
611: THEN
612: Get_Messages (l_msg_count,l_message);

Line 644: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_tld_pvt.update_row : '||l_return_status);

640: x_msg_data => x_msg_data,
641: p_tldv_rec => lp_tldv_rec,
642: x_tldv_rec => xp_tldv_rec);
643:
644: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_tld_pvt.update_row : '||l_return_status);
645:
646: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)
647: THEN
648: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR)

Line 675: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : END ');

671: , G_MODULE
672: ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_INVOICE_HDR_LINES');
673: END IF;
674:
675: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : END ');
676:
677: EXCEPTION
678: WHEN Fnd_Api.G_EXC_ERROR
679: THEN

Line 1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');

1007: l_bill_to_address_id NUMBER;
1008:
1009: BEGIN
1010:
1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);

Line 1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);

1008:
1009: BEGIN
1010:
1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
1016:

Line 1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);

1009: BEGIN
1010:
1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
1016:
1017: SAVEPOINT INSERT_INVOICE_HDR_LINES;

Line 1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);

1010:
1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
1016:
1017: SAVEPOINT INSERT_INVOICE_HDR_LINES;
1018: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);

1011: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
1012: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
1013: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
1014: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
1015: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
1016:
1017: SAVEPOINT INSERT_INVOICE_HDR_LINES;
1018: IF (G_IS_DEBUG_STATEMENT_ON = true)
1019: THEN

Line 1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);

1065: END IF;
1066:
1067: -- vdamerla end: added the code to get the currency conversion details
1068:
1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);

Line 1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);

1066:
1067: -- vdamerla end: added the code to get the currency conversion details
1068:
1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
1074: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.org_id : '||lp_taiv_rec.org_id);

Line 1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);

1067: -- vdamerla end: added the code to get the currency conversion details
1068:
1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
1074: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.org_id : '||lp_taiv_rec.org_id);
1075:

Line 1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);

1068:
1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
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)

Line 1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);

1069: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
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

Line 1074: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.org_id : '||lp_taiv_rec.org_id);

1070: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
1071: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
1072: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
1073: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
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);

Line 1094: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.try_id : '||lp_taiv_rec.try_id);

1090: OPEN get_trx_id;
1091: FETCH get_trx_id INTO lp_taiv_rec.try_id;
1092: CLOSE get_trx_id;
1093:
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);

Line 1120: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_tilv_rec.sty_id : '||lp_tilv_rec.sty_id);

1116: x_primary_sty_id => x_primary_sty_id);
1117:
1118: lp_tilv_rec.sty_id := x_primary_sty_id;
1119:
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);

Line 1144: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_program_id : '||l_program_id);

1140: OPEN c_program_id(lp_taiv_rec.khr_id);
1141: FETCH c_program_id INTO l_program_id;
1142: CLOSE c_program_id;
1143:
1144: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_program_id : '||l_program_id);
1145:
1146: IF l_program_id IS NULL
1147: THEN
1148: OKL_API.SET_MESSAGE (p_app_name => 'OKL',

Line 1165: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_bill_to_address_id : '||l_bill_to_address_id);

1161: OPEN bill_to_csr (l_program_id);
1162: FETCH bill_to_csr INTO l_bill_to_address_id;
1163: CLOSE bill_to_csr;
1164:
1165: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_bill_to_address_id : '||l_bill_to_address_id);
1166:
1167: IF trunc(l_bill_to_address_id) IS NULL
1168: THEN
1169: IF (G_IS_DEBUG_STATEMENT_ON = true)

Line 1199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ibt_id : '||lp_taiv_rec.ibt_id);

1195: lp_taiv_rec.ibt_id := l_site_use_rec.cust_acct_site_id;
1196: lp_taiv_rec.ixx_id := l_site_use_rec.cust_account_id;
1197: lp_taiv_rec.irt_id := l_site_use_rec.payment_term_id;
1198:
1199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ibt_id : '||lp_taiv_rec.ibt_id);
1200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ixx_id : '||lp_taiv_rec.ixx_id);
1201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irt_id : '||lp_taiv_rec.irt_id);
1202:
1203: IF lp_taiv_rec.irt_id IS NULL OR lp_taiv_rec.irt_id = FND_API.G_MISS_NUM

Line 1200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ixx_id : '||lp_taiv_rec.ixx_id);

1196: lp_taiv_rec.ixx_id := l_site_use_rec.cust_account_id;
1197: lp_taiv_rec.irt_id := l_site_use_rec.payment_term_id;
1198:
1199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ibt_id : '||lp_taiv_rec.ibt_id);
1200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ixx_id : '||lp_taiv_rec.ixx_id);
1201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irt_id : '||lp_taiv_rec.irt_id);
1202:
1203: IF lp_taiv_rec.irt_id IS NULL OR lp_taiv_rec.irt_id = FND_API.G_MISS_NUM
1204: THEN

Line 1201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irt_id : '||lp_taiv_rec.irt_id);

1197: lp_taiv_rec.irt_id := l_site_use_rec.payment_term_id;
1198:
1199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ibt_id : '||lp_taiv_rec.ibt_id);
1200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ixx_id : '||lp_taiv_rec.ixx_id);
1201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irt_id : '||lp_taiv_rec.irt_id);
1202:
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)

Line 1284: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irm_id : '||lp_taiv_rec.irm_id);

1280: OPEN l_rcpt_mthd_csr (l_id1);
1281: FETCH l_rcpt_mthd_csr INTO lp_taiv_rec.irm_id;
1282: CLOSE l_rcpt_mthd_csr;
1283:
1284: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irm_id : '||lp_taiv_rec.irm_id);
1285:
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)

Line 1320: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.cust_trx_type_id : '||lp_taiv_rec.cust_trx_type_id);

1316: open ra_cust_csr;
1317: fetch ra_cust_csr into lp_taiv_rec.cust_trx_type_id;
1318: close ra_cust_csr;
1319:
1320: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.cust_trx_type_id : '||lp_taiv_rec.cust_trx_type_id);
1321: -- R12 Changes - END
1322:
1323: IF (G_IS_DEBUG_STATEMENT_ON = true)
1324: THEN

Line 1346: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices : '||l_return_status);

1342: x_msg_data => l_msg_data,
1343: p_taiv_rec => lp_taiv_rec,
1344: x_taiv_rec => xp_taiv_rec);
1345:
1346: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices : '||l_return_status);
1347:
1348: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
1349: THEN
1350: Get_Messages (l_msg_count,l_message);

Line 1395: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns : '||l_return_status);

1391: x_msg_data => l_msg_data,
1392: p_tilv_rec => lp_tilv_rec,
1393: x_tilv_rec => xp_tilv_rec);
1394:
1395: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns : '||l_return_status);
1396:
1397: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
1398: THEN
1399: Get_Messages (l_msg_count,l_message);

Line 1437: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);

1433: ,p_sty_id => lp_tldv_rec.STY_ID
1434: ,x_invoice_format_type => lp_tldv_rec.invoice_format_type
1435: ,x_invoice_format_line_type => lp_tldv_rec.invoice_format_line_type);
1436:
1437: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);
1438:
1439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1440: THEN
1441: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1456: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : additional_tld_attr : '||l_return_status);

1452: x_msg_data => x_msg_data,
1453: p_tldv_rec => lp_tldv_rec,
1454: x_tldv_rec => xp_tldv_rec);
1455:
1456: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : additional_tld_attr : '||l_return_status);
1457:
1458: lp_tldv_rec := xp_tldv_rec;
1459:
1460: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)

Line 1478: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_tld_pvt.insert_row : '||l_return_status);

1474: x_msg_data => x_msg_data,
1475: p_tldv_rec => lp_tldv_rec,
1476: x_tldv_rec => xp_tldv_rec);
1477:
1478: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_tld_pvt.insert_row : '||l_return_status);
1479:
1480: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)
1481: THEN
1482: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR)

Line 1505: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : END ');

1501: , G_MODULE
1502: ,' End of Procedure => OKL_PAY_RECON_PVT.INSERT_INVOICE_HDR_LINES');
1503: END IF;
1504:
1505: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : END ');
1506:
1507: EXCEPTION
1508:
1509: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1566: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : START ');

1562: l_err_msg VARCHAR2(2000);
1563:
1564: BEGIN
1565:
1566: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : START ');
1567:
1568: SAVEPOINT TERMINATE_QUOTE;
1569: IF (G_IS_DEBUG_STATEMENT_ON = true)
1570: THEN

Line 1586: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : lp_term_rec.id : '||lp_term_rec.id);

1582: CLOSE c_get_qte_id;
1583:
1584: lp_term_rec.accepted_yn := 'Y';
1585:
1586: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : lp_term_rec.id : '||lp_term_rec.id);
1587:
1588: OKL_AM_TERMNT_QUOTE_PUB.TERMINATE_QUOTE(
1589: p_api_version => 1.0
1590: ,p_init_msg_list => 'T'

Line 1598: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : OKL_AM_TERMNT_QUOTE_PUB.TERMINATE_QUOTE : '||l_return_status);

1594: ,p_term_rec => lp_term_rec
1595: ,x_term_rec => lx_term_rec
1596: ,x_err_msg => l_err_msg);
1597:
1598: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : OKL_AM_TERMNT_QUOTE_PUB.TERMINATE_QUOTE : '||l_return_status);
1599:
1600: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
1601: THEN
1602: Get_Messages (l_msg_count,l_message);

Line 1624: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : END ');

1620: G_MODULE,
1621: ' End of Procedure =>OKL_PAY_RECON_PVT.TERMINATE_QUOTE');
1622: END IF;
1623:
1624: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : TERMINATE_QUOTE : END ');
1625:
1626: EXCEPTION
1627: WHEN Fnd_Api.G_EXC_ERROR THEN
1628: ROLLBACK TO TERMINATE_QUOTE;

Line 1679: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : START ');

1675: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1676: l_process OKL_CURE_AMOUNTS.process%TYPE;
1677: BEGIN
1678:
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);

Line 1796: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : END ');

1792: G_MODULE,
1793: ' End of Procedure =>OKL_PAY_RECON_PVT.UPDATE_TAI_TIL');
1794: END IF;
1795:
1796: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : END ');
1797:
1798: EXCEPTION
1799: WHEN Fnd_Api.G_EXC_ERROR THEN
1800: ROLLBACK TO UPDATE_TAI_TIL;

Line 1843: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : START ');

1839: || l_api_name;
1840:
1841: BEGIN
1842:
1843: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : START ');
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

Line 1844: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_report_id : '||p_report_id);

1840:
1841: BEGIN
1842:
1843: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : START ');
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);

Line 1845: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_invoice_date : '||p_invoice_date);

1841: BEGIN
1842:
1843: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : START ');
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;

Line 1935: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : END ');

1931: G_MODULE,
1932: ' End of Procedure =>OKL_PAY_RECON_PVT.update_invoices');
1933: END IF;
1934:
1935: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : END ');
1936:
1937: EXCEPTION
1938: WHEN Fnd_Api.G_EXC_ERROR THEN
1939: ROLLBACK TO UPDATE_INVOICES;

Line 2121: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : START ');

2117: --Bug# 4622198 :For special accounting treatment - END
2118:
2119: BEGIN
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;

Line 2149: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_process : '||l_process);

2145: ELSE
2146: l_process :='CURE';
2147: END IF;
2148:
2149: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_process : '||l_process);
2150:
2151: IF l_process ='CURE'
2152: THEN
2153: OPEN get_product_id(p_cam_tbl(i).cam_id);

Line 2168: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_factoring_synd : '||l_factoring_synd);

2164: raise FND_API.G_EXC_ERROR;
2165: END IF;
2166:
2167: l_factoring_synd := get_factor_synd(l_khr_id);
2168: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_factoring_synd : '||l_factoring_synd);
2169:
2170: OPEN c_get_Accounting(p_cam_tbl(i).cam_id);
2171: FETCH c_get_Accounting
2172: INTO l_tai_id

Line 2189: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).transaction_type_id : '||l_tmpl_identify_tbl(1).transaction_type_id);

2185: l_tmpl_identify_tbl(1).SYNDICATION_CODE := NULL;
2186: l_tmpl_identify_tbl(1).FACTORING_CODE := NULL;
2187: l_tmpl_identify_tbl(1).MEMO_YN := 'N';
2188: l_tmpl_identify_tbl(1).PRIOR_YEAR_YN := 'N';
2189: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).transaction_type_id : '||l_tmpl_identify_tbl(1).transaction_type_id);
2190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).stream_type_id : '||l_tmpl_identify_tbl(1).stream_type_id);
2191:
2192: l_dist_info_tbl(1).source_id := l_line_id;
2193: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';

Line 2190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).stream_type_id : '||l_tmpl_identify_tbl(1).stream_type_id);

2186: l_tmpl_identify_tbl(1).FACTORING_CODE := NULL;
2187: l_tmpl_identify_tbl(1).MEMO_YN := 'N';
2188: l_tmpl_identify_tbl(1).PRIOR_YEAR_YN := 'N';
2189: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).transaction_type_id : '||l_tmpl_identify_tbl(1).transaction_type_id);
2190: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).stream_type_id : '||l_tmpl_identify_tbl(1).stream_type_id);
2191:
2192: l_dist_info_tbl(1).source_id := l_line_id;
2193: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';
2194: l_dist_info_tbl(1).accounting_date := l_date_invoiced;

Line 2198: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_id : '||l_dist_info_tbl(1).source_id);

2194: l_dist_info_tbl(1).accounting_date := l_date_invoiced;
2195: l_dist_info_tbl(1).gl_reversal_flag :='N';
2196: l_dist_info_tbl(1).post_to_gl :='N';
2197: l_dist_info_tbl(1).contract_id :=l_khr_id;
2198: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_id : '||l_dist_info_tbl(1).source_id);
2199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_table : '||l_dist_info_tbl(1).source_table);
2200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).accounting_date : '||l_dist_info_tbl(1).accounting_date);
2201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).contract_id : '||l_dist_info_tbl(1).contract_id);
2202:

Line 2199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_table : '||l_dist_info_tbl(1).source_table);

2195: l_dist_info_tbl(1).gl_reversal_flag :='N';
2196: l_dist_info_tbl(1).post_to_gl :='N';
2197: l_dist_info_tbl(1).contract_id :=l_khr_id;
2198: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_id : '||l_dist_info_tbl(1).source_id);
2199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_table : '||l_dist_info_tbl(1).source_table);
2200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).accounting_date : '||l_dist_info_tbl(1).accounting_date);
2201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).contract_id : '||l_dist_info_tbl(1).contract_id);
2202:
2203: -- New Accounting call Start set accounting call required values

Line 2200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).accounting_date : '||l_dist_info_tbl(1).accounting_date);

2196: l_dist_info_tbl(1).post_to_gl :='N';
2197: l_dist_info_tbl(1).contract_id :=l_khr_id;
2198: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_id : '||l_dist_info_tbl(1).source_id);
2199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_table : '||l_dist_info_tbl(1).source_table);
2200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).accounting_date : '||l_dist_info_tbl(1).accounting_date);
2201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).contract_id : '||l_dist_info_tbl(1).contract_id);
2202:
2203: -- New Accounting call Start set accounting call required values
2204: -- Fetch the functional currency

Line 2201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).contract_id : '||l_dist_info_tbl(1).contract_id);

2197: l_dist_info_tbl(1).contract_id :=l_khr_id;
2198: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_id : '||l_dist_info_tbl(1).source_id);
2199: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).source_table : '||l_dist_info_tbl(1).source_table);
2200: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).accounting_date : '||l_dist_info_tbl(1).accounting_date);
2201: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).contract_id : '||l_dist_info_tbl(1).contract_id);
2202:
2203: -- New Accounting call Start set accounting call required values
2204: -- Fetch the functional currency
2205:

Line 2253: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).amount : '||l_dist_info_tbl(1).amount);

2249: l_dist_info_tbl(1).amount:= okl_accounting_util.cross_currency_round_amount
2250: (p_amount => l_amount,
2251: p_currency_code => l_contract_currency);
2252:
2253: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_dist_info_tbl(1).amount : '||l_dist_info_tbl(1).amount);
2254:
2255: --set error message,so this will be prefixed before the
2256: --actual message, so it makes more sense than displaying an
2257: -- OKL message.

Line 2347: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : OKL_SECURITIZATION_PVT.Check_Khr_ia_associated : '||x_return_status);

2343: x_fact_synd_code => l_fact_synd_code,
2344: x_inv_acct_code => l_inv_acct_code
2345: );
2346:
2347: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : OKL_SECURITIZATION_PVT.Check_Khr_ia_associated : '||x_return_status);
2348:
2349: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
2350: THEN
2351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2359: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).factoring_synd_flag : '||l_tmpl_identify_tbl(1).factoring_synd_flag);

2355: END IF;
2356:
2357: l_tmpl_identify_tbl(1).factoring_synd_flag := l_fact_synd_code;
2358: l_tmpl_identify_tbl(1).investor_code := l_inv_acct_code;
2359: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).factoring_synd_flag : '||l_tmpl_identify_tbl(1).factoring_synd_flag);
2360: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).investor_code : '||l_tmpl_identify_tbl(1).investor_code);
2361:
2362:
2363: --Bug# 4622198 :For special accounting treatment - END

Line 2360: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).investor_code : '||l_tmpl_identify_tbl(1).investor_code);

2356:
2357: l_tmpl_identify_tbl(1).factoring_synd_flag := l_fact_synd_code;
2358: l_tmpl_identify_tbl(1).investor_code := l_inv_acct_code;
2359: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).factoring_synd_flag : '||l_tmpl_identify_tbl(1).factoring_synd_flag);
2360: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : l_tmpl_identify_tbl(1).investor_code : '||l_tmpl_identify_tbl(1).investor_code);
2361:
2362:
2363: --Bug# 4622198 :For special accounting treatment - END
2364:

Line 2402: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);

2398: x_amount_tbl => l_amount_tbl,
2399: p_trx_header_id => l_tai_id,
2400: p_trx_header_table => 'OKL_TRX_AR_INVOICES_B');
2401:
2402: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : okl_account_dist_pvt.create_accounting_dist : '||l_return_status);
2403:
2404: -- R12 CHANGE - END
2405:
2406: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 2441: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : END ');

2437: G_MODULE,
2438: ' End of Procedure =>OKL_PAY_RECON_PVT.CREATE_ACCOUNTING');
2439: END IF;
2440:
2441: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : CREATE_ACCOUNTING : END ');
2442:
2443: EXCEPTION
2444: WHEN Fnd_Api.G_EXC_ERROR THEN
2445: ROLLBACK TO CREATE_ACCOUNTING;

Line 2489: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : START ');

2485: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'|| l_api_name;
2486:
2487: BEGIN
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;

Line 2509: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_TAI_TIL : '||l_return_status);

2505: x_return_status =>l_return_status,
2506: x_msg_count =>l_msg_count,
2507: x_msg_data =>l_msg_data);
2508:
2509: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_TAI_TIL : '||l_return_status);
2510:
2511: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
2512: THEN
2513: Get_Messages (l_msg_count,l_message);

Line 2528: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : CREATE_ACCOUNTING : '||l_return_status);

2524: x_return_status =>l_return_status,
2525: x_msg_count =>l_msg_count,
2526: x_msg_data =>l_msg_data);
2527:
2528: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : CREATE_ACCOUNTING : '||l_return_status);
2529:
2530: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
2531: THEN
2532: Get_Messages (l_msg_count,l_message);

Line 2548: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CAM : '||l_return_status);

2544: x_return_status =>l_return_status,
2545: x_msg_count =>l_msg_count,
2546: x_msg_data =>l_msg_data);
2547:
2548: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CAM : '||l_return_status);
2549:
2550: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
2551: THEN
2552: Get_Messages (l_msg_count,l_message);

Line 2568: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CRT : '||l_return_status);

2564: x_return_status =>l_return_status,
2565: x_msg_count =>l_msg_count,
2566: x_msg_data =>l_msg_data);
2567:
2568: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CRT : '||l_return_status);
2569:
2570: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
2571: THEN
2572: Get_Messages (l_msg_count,l_message);

Line 2596: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : END ');

2592: ' End of Procedure => OKL_PAY_RECON_PVT.submit_Cure_invoices');
2593:
2594: END IF;
2595:
2596: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : END ');
2597:
2598: EXCEPTION
2599: WHEN Fnd_Api.G_EXC_ERROR THEN
2600: ROLLBACK TO SUBMIT_INVOICES;

Line 2646: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : START ');

2642: l_message VARCHAR2(32627);
2643:
2644: BEGIN
2645:
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);

Line 2669: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : Update_invoices : '||l_return_status);

2665: x_return_status =>l_return_status,
2666: x_msg_count =>l_msg_count,
2667: x_msg_data =>l_msg_data);
2668:
2669: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : Update_invoices : '||l_return_status);
2670:
2671: ELSE
2672: IF (G_IS_DEBUG_STATEMENT_ON = true)
2673: THEN

Line 2684: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : submit_invoices : '||l_return_status);

2680: x_return_status =>l_return_status,
2681: x_msg_count =>l_msg_count,
2682: x_msg_data =>l_msg_data);
2683:
2684: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : submit_invoices : '||l_return_status);
2685: END IF;
2686:
2687: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
2688: THEN

Line 2712: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : END ');

2708: G_MODULE,
2709: ' End of Procedure => OKL_PAY_RECON_PVT.update_Cure_invoices');
2710: END IF;
2711:
2712: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : END ');
2713:
2714: EXCEPTION
2715: WHEN Fnd_Api.G_EXC_ERROR THEN
2716: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;

Line 2736: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');

2732: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
2733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2734: x_msg_count := l_msg_count ;
2735: x_msg_data := l_msg_data ;
2736: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');
2737: Fnd_Msg_Pub.count_and_get(
2738: p_count => x_msg_count
2739: ,p_data => x_msg_data);
2740:

Line 2743: END OKL_CURE_RECON_PVT;

2739: ,p_data => x_msg_data);
2740:
2741: END UPDATE_CURE_INVOICE;
2742:
2743: END OKL_CURE_RECON_PVT;