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_POOLCONC_PVT dependencies on OKL_POOL_PVT

Line 8: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;

4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6:
7: G_POOL_NO_MODIFY CONSTANT VARCHAR2(18) := 'OKL_POOL_NO_MODIFY';
8: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
9: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
10: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
11: G_POC_STS_PENDING CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_PENDING;
12: G_POOL_ADD_REPORT CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_REPORT';

Line 9: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;

5: ----------------------------------------------------------------------------
6:
7: G_POOL_NO_MODIFY CONSTANT VARCHAR2(18) := 'OKL_POOL_NO_MODIFY';
8: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
9: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
10: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
11: G_POC_STS_PENDING CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_PENDING;
12: G_POOL_ADD_REPORT CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_REPORT';
13: G_POOL_ELIGIBILITY_CRITERIA CONSTANT VARCHAR2(30) := 'OKL_POOL_ELIGIBILITY_CRITERIA';

Line 10: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;

6:
7: G_POOL_NO_MODIFY CONSTANT VARCHAR2(18) := 'OKL_POOL_NO_MODIFY';
8: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
9: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
10: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
11: G_POC_STS_PENDING CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_PENDING;
12: G_POOL_ADD_REPORT CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_REPORT';
13: G_POOL_ELIGIBILITY_CRITERIA CONSTANT VARCHAR2(30) := 'OKL_POOL_ELIGIBILITY_CRITERIA';
14: G_POOL_ADD_TBL_HDR CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_TBL_HDR';

Line 11: G_POC_STS_PENDING CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_PENDING;

7: G_POOL_NO_MODIFY CONSTANT VARCHAR2(18) := 'OKL_POOL_NO_MODIFY';
8: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
9: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
10: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
11: G_POC_STS_PENDING CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_PENDING;
12: G_POOL_ADD_REPORT CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_REPORT';
13: G_POOL_ELIGIBILITY_CRITERIA CONSTANT VARCHAR2(30) := 'OKL_POOL_ELIGIBILITY_CRITERIA';
14: G_POOL_ADD_TBL_HDR CONSTANT VARCHAR2(30) := 'OKL_POOL_ADD_TBL_HDR';
15: G_REJECT_REASON_CODE CONSTANT VARCHAR2(25) := 'OKL_REJECT_REASON_CODE';

Line 317: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)

313:
314: -- Bug#2829983, v115.13
315: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_pol_id)
316: LOOP
317: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)
318: THEN
319: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));
320: RAISE G_EXCEPTION_ERROR;
321: END IF;

Line 486: Okl_Pool_Pvt.add_pool_contents(

482:
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
484:
485: */
486: Okl_Pool_Pvt.add_pool_contents(
487: p_api_version => l_api_version
488: ,p_init_msg_list => l_init_msg_list
489: ,x_return_status => l_return_status
490: ,x_msg_count => l_msg_count

Line 528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));

524:
525: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || l_row_count);
526:
527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));
529: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
530: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));
532: RAISE G_EXCEPTION_ERROR;

Line 531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));

527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));
529: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
530: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));
532: RAISE G_EXCEPTION_ERROR;
533: END IF;
534: /*
535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));

547: /* v115.16, mvasudev
548: --
549: -- update total principal amount at okl_pools
550: --
551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
552:
553: Okl_Pool_Pvt.recal_tot_princ_amt(
554: p_api_version => l_api_version
555: ,p_init_msg_list => l_init_msg_list

Line 553: Okl_Pool_Pvt.recal_tot_princ_amt(

549: -- update total principal amount at okl_pools
550: --
551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
552:
553: Okl_Pool_Pvt.recal_tot_princ_amt(
554: p_api_version => l_api_version
555: ,p_init_msg_list => l_init_msg_list
556: ,x_return_status => l_return_status
557: ,x_msg_count => l_msg_count

Line 563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);

559: ,x_value => l_amount
560: ,p_pol_id => p_pol_id);
561:
562:
563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

Line 564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);

560: ,p_pol_id => p_pol_id);
561:
562:
563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
569: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
571: RAISE G_EXCEPTION_ERROR;

Line 570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
569: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
571: RAISE G_EXCEPTION_ERROR;
572: END IF;
573: */
574:

Line 865: Okl_Pool_Pvt.recal_tot_princ_amt(

861: OPEN c_pool;
862: FETCH c_pool INTO l_pol_id;
863: CLOSE c_pool;
864:
865: Okl_Pool_Pvt.recal_tot_princ_amt(
866: p_api_version => l_api_version
867: ,p_init_msg_list => l_init_msg_list
868: ,x_return_status => l_return_status
869: ,x_msg_count => l_msg_count

Line 875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

871: ,x_value => l_amount
872: ,p_pol_id => l_pol_id);
873:
874: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
876: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
879: RAISE G_EXCEPTION_ERROR;

Line 878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

874: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
876: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
879: RAISE G_EXCEPTION_ERROR;
880: END IF;
881:
882: i := 1; -- default

Line 896: Okl_Pool_Pvt.recal_tot_princ_amt(

892: l_pol_id;
893:
894: EXIT WHEN c_pol%NOTFOUND;
895:
896: Okl_Pool_Pvt.recal_tot_princ_amt(
897: p_api_version => l_api_version
898: ,p_init_msg_list => l_init_msg_list
899: ,x_return_status => l_return_status
900: ,x_msg_count => l_msg_count

Line 906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

902: ,x_value => l_amount
903: ,p_pol_id => l_pol_id);
904:
905: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
907: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
910: RAISE G_EXCEPTION_ERROR;

Line 909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

905: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
907: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
910: RAISE G_EXCEPTION_ERROR;
911: END IF;
912:
913: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);

Line 1168: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version

1164: i :=0;
1165:
1166: FOR l_okl_pol_rec IN l_okl_pol_csr(p_pool_number)
1167: LOOP
1168: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1169: ,p_init_msg_list => l_init_msg_list
1170: ,p_pol_id => l_okl_pol_rec.id
1171: ,x_return_status => l_return_status
1172: ,x_msg_count => l_msg_count

Line 1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1173: ,x_msg_data => l_msg_data
1174: ,x_reconciled => l_reconciled);
1175:
1176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1178: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1181: RAISE G_EXCEPTION_ERROR;

Line 1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1178: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1181: RAISE G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

Line 1199: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version

1195: ELSE
1196: i := 0;
1197: FOR l_okl_pols_rec IN l_okl_pols_csr
1198: LOOP
1199: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1200: ,p_init_msg_list => l_init_msg_list
1201: ,p_pol_id => l_okl_pols_rec.id
1202: ,x_return_status => l_return_status
1203: ,x_msg_count => l_msg_count

Line 1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1204: ,x_msg_data => l_msg_data
1205: ,x_reconciled => l_reconciled);
1206:
1207: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1209: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1212: RAISE G_EXCEPTION_ERROR;

Line 1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1207: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1209: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1212: RAISE G_EXCEPTION_ERROR;
1213: END IF;
1214:
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

Line 1374: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version

1370: LOOP
1371: IF l_okl_pol_csr%NOTFOUND THEN
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));
1373: ELSE
1374: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1375: ,p_init_msg_list => l_init_msg_list
1376: ,p_pol_id => l_okl_pol_rec.id
1377: ,p_mode => 'ACTIVE'
1378: ,x_return_status => l_return_status

Line 1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1380: ,x_msg_data => l_msg_data
1381: ,x_reconciled => l_reconciled);
1382:
1383: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1385: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1388: RAISE G_EXCEPTION_ERROR;

Line 1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1383: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1385: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1388: RAISE G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

Line 1410: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version

1406: LOOP
1407: IF l_okl_pol_csr%NOTFOUND THEN
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));
1409: ELSE
1410: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1411: ,p_init_msg_list => l_init_msg_list
1412: ,p_pol_id => l_okl_pols_rec.id
1413: ,p_mode => 'ACTIVE'
1414: ,x_return_status => l_return_status

Line 1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1416: ,x_msg_data => l_msg_data
1417: ,x_reconciled => l_reconciled);
1418:
1419: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1421: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1424: RAISE G_EXCEPTION_ERROR;

Line 1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1419: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1421: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1424: RAISE G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

Line 1878: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)

1874: -- Bug#2829983, v115.13
1875: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_pol_id)
1876: LOOP
1877: --Included 'Active' status to allow clean up adjustment pool contents -- varangan-29-11-2007
1878: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)
1879: THEN
1880: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));
1881: RAISE G_EXCEPTION_ERROR;
1882: END IF;

Line 1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN

1883: END LOOP;
1884:
1885: -- Header
1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';
1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN
1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);
1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
1890: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REMOVE);
1891: END IF;

Line 1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN

1885: -- Header
1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';
1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN
1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);
1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
1890: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REMOVE);
1891: END IF;
1892: l_header_len := LENGTH(l_content);
1893: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header

Line 1917: IF l_okl_pol_rec.pool_status = OKL_POOL_PVT.G_POL_STS_ACTIVE THEN

1913:
1914: -- Pool Details
1915: FOR l_okl_pol_rec IN l_okl_pol_csr
1916: LOOP
1917: IF l_okl_pol_rec.pool_status = OKL_POOL_PVT.G_POL_STS_ACTIVE THEN
1918: Okl_Pool_Pvt.get_tot_recei_amt_pend(p_api_version => l_api_version
1919: ,p_init_msg_list => l_init_msg_list
1920: ,x_return_status => l_return_status
1921: ,x_msg_count => l_msg_count

Line 1918: Okl_Pool_Pvt.get_tot_recei_amt_pend(p_api_version => l_api_version

1914: -- Pool Details
1915: FOR l_okl_pol_rec IN l_okl_pol_csr
1916: LOOP
1917: IF l_okl_pol_rec.pool_status = OKL_POOL_PVT.G_POL_STS_ACTIVE THEN
1918: Okl_Pool_Pvt.get_tot_recei_amt_pend(p_api_version => l_api_version
1919: ,p_init_msg_list => l_init_msg_list
1920: ,x_return_status => l_return_status
1921: ,x_msg_count => l_msg_count
1922: ,x_msg_data => l_msg_data

Line 1926: Okl_Pool_Pvt.get_tot_recei_amt(p_api_version => l_api_version

1922: ,x_msg_data => l_msg_data
1923: ,x_value => l_amount
1924: ,p_pol_id => p_pol_id);
1925: ELSE
1926: Okl_Pool_Pvt.get_tot_recei_amt(p_api_version => l_api_version
1927: ,p_init_msg_list => l_init_msg_list
1928: ,x_return_status => l_return_status
1929: ,x_msg_count => l_msg_count
1930: ,x_msg_data => l_msg_data

Line 1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));

1931: ,x_value => l_amount
1932: ,p_pol_id => p_pol_id);
1933: END IF;
1934: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));
1936: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1937: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));
1939: RAISE G_EXCEPTION_ERROR;

Line 1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));

1934: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));
1936: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1937: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));
1939: RAISE G_EXCEPTION_ERROR;
1940: END IF;
1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);

Line 2082: Okl_Pool_Pvt.cleanup_pool_contents(p_api_version => l_api_version

2078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2080: -- count
2081:
2082: Okl_Pool_Pvt.cleanup_pool_contents(p_api_version => l_api_version
2083: ,p_init_msg_list => l_init_msg_list
2084: ,x_return_status => l_return_status
2085: ,x_msg_count => l_msg_count
2086: ,x_msg_data => l_msg_data

Line 2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));

2117: ,x_poc_uv_tbl => lx_poc_uv_tbl
2118: ,p_cust_crd_clf_code => p_cust_crd_clf_code);
2119:
2120: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));
2122: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));
2125: RAISE G_EXCEPTION_ERROR;

Line 2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));

2120: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));
2122: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));
2125: RAISE G_EXCEPTION_ERROR;
2126: END IF;
2127:
2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(fnd_message.get_string(G_APP_NAME,G_TOTAL_ROWS_PROCESSED),l_prompt_len) || ' : ' || lx_poc_uv_tbl.COUNT);

Line 2185: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN

2181:
2182: END LOOP;
2183:
2184: /* v115.16 , mvasudev
2185: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
2187: Okl_Pool_Pvt.recal_tot_princ_amt(p_api_version => l_api_version
2188: ,p_init_msg_list => l_init_msg_list
2189: ,x_return_status => l_return_status

Line 2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));

2182: END LOOP;
2183:
2184: /* v115.16 , mvasudev
2185: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
2187: Okl_Pool_Pvt.recal_tot_princ_amt(p_api_version => l_api_version
2188: ,p_init_msg_list => l_init_msg_list
2189: ,x_return_status => l_return_status
2190: ,x_msg_count => l_msg_count

Line 2187: Okl_Pool_Pvt.recal_tot_princ_amt(p_api_version => l_api_version

2183:
2184: /* v115.16 , mvasudev
2185: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
2187: Okl_Pool_Pvt.recal_tot_princ_amt(p_api_version => l_api_version
2188: ,p_init_msg_list => l_init_msg_list
2189: ,x_return_status => l_return_status
2190: ,x_msg_count => l_msg_count
2191: ,x_msg_data => l_msg_data

Line 2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);

2191: ,x_msg_data => l_msg_data
2192: ,x_value => l_amount
2193: ,p_pol_id => p_pol_id);
2194:
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

Line 2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));

2192: ,x_value => l_amount
2193: ,p_pol_id => p_pol_id);
2194:
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
2203: RAISE G_EXCEPTION_ERROR;

Line 2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
2203: RAISE G_EXCEPTION_ERROR;
2204: END IF; -- status
2205:
2206: END IF; -- action_code