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_GENERATE_ACCRUALS_PVT dependencies on FND_FILE

Line 92: fnd_file.put_line (fnd_file.log,p_message);

88:
89: END IF;
90:
91: IF L_DEBUG_ENABLED = 'Y' then
92: fnd_file.put_line (fnd_file.log,p_message);
93: okl_debug_pub.logmessage(p_message);
94: END IF;
95:
96: END WRITE_TO_LOG;

Line 736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||

732:
733: BEGIN
734:
735: -- Create report header
736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
737: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
739: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||

734:
735: -- Create report header
736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
737: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
739: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
741:
742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));

Line 740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
737: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
739: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
741:
742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));

738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
739: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
741:
742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
745:
746: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));

739: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
741:
742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
745:
746: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
747: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')

Line 744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
741:
742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
745:
746: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
747: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
748: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041

Line 746: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

742: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
743: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
744: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
745:
746: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
747: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
748: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041
749: RPAD(' ', 80)
750: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')

Line 752: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')

748: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041
749: RPAD(' ', 80)
750: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
751: ||' '||p_org_name);
752: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
753: ||' '||RPAD(to_char(l_sysdate,'DD-MON-RRRR HH24:MI:SS'), 61)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACCRUAL_DATE')
754: ||' '||p_accrual_date);
755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
756: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')

Line 755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')

751: ||' '||p_org_name);
752: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
753: ||' '||RPAD(to_char(l_sysdate,'DD-MON-RRRR HH24:MI:SS'), 61)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACCRUAL_DATE')
754: ||' '||p_accrual_date);
755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
756: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
757: ||' '||p_batch_name);
758: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
759:

Line 758: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

754: ||' '||p_accrual_date);
755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
756: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
757: ||' '||p_batch_name);
758: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
759:
760: -- Create Report Content
761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
762: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)

Line 761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)

757: ||' '||p_batch_name);
758: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
759:
760: -- Create Report Content
761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
762: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)
763: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),17)
764: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_RULE_STATUS'),20)
765: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_OVRD_STATUS'),16)

Line 770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_LINE'),28)

766: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)
767: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),17) ||
768: LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_REPRESENTATION_TYPE'),15)); -- MGAAP 7263041
769:
770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_LINE'),28)
771: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_LINE'),22)
772: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY_UNDERLINE'),17)
773: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_RUL_STAT_UNDERLINE'),20)
774: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_OVD_STAT_UNDERLINE'),16)

Line 1908: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_kle_id_status is REPEAT but l_inv_item_id is NULL. So no value to assign.');

1904: l_count := l_acc_gen_tbl(x).acc_gen_key_tbl.LAST + 1;
1905: l_acc_gen_tbl(x).acc_gen_key_tbl(l_count).source_table:= 'MTL_SYSTEM_ITEMS_VL';
1906: l_acc_gen_tbl(x).acc_gen_key_tbl(l_count).primary_key_column := l_inv_item_id;
1907: ELSE
1908: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_kle_id_status is REPEAT but l_inv_item_id is NULL. So no value to assign.');
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: END IF; --IF l_lty_code IN ('FREE_FORM1','LINK_SERV_ASSET') THEN
1912: END IF; -- IF kle_id_status = 'NEW'

Line 5430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');

5426: ,l_return_status);
5427:
5428: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
5429: IF p_process_accrual_rec.submission_mode='BATCH' THEN
5430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
5431: END IF;
5432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
5433: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
5434: IF p_process_accrual_rec.submission_mode='BATCH' THEN

Line 5435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

5431: END IF;
5432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
5433: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
5434: IF p_process_accrual_rec.submission_mode='BATCH' THEN
5435: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
5436: END IF;
5437: RAISE Okl_Api.G_EXCEPTION_ERROR;
5438: END IF;
5439:

Line 5825: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

5821: IF p_process_accrual_rec.submission_mode='BATCH' THEN
5822: IF l_can_tcnv_tbl.COUNT > 0 THEN
5823: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
5824: LOOP
5825: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
5826: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
5827: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
5828: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
5829: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 5840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

5836: -- Report content for catchup activity
5837: IF l_tcnv_tbl.COUNT > 0 THEN
5838: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
5839: LOOP
5840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
5841: RPAD(l_tcnv_tbl(x).trx_number,22)||
5842: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
5843: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
5844: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 5891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

5887: IF p_process_accrual_rec.submission_mode='BATCH' THEN
5888: IF l_can_tcnv_tbl.COUNT > 0 THEN
5889: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
5890: LOOP
5891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
5892: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
5893: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
5894: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
5895: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 5906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

5902: -- Report content for catchup activity
5903: IF l_tcnv_tbl.COUNT > 0 THEN
5904: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
5905: LOOP
5906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
5907: RPAD(l_tcnv_tbl(x).trx_number,22)||
5908: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
5909: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
5910: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 5990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

5986: RAISE OKL_API.G_EXCEPTION_ERROR;
5987: END IF;
5988: END IF;
5989: IF p_process_accrual_rec.submission_mode='BATCH' THEN
5990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
5991: RPAD(l_tcnv_rec.trx_number,22)||
5992: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
5993: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
5994: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6069: RAISE OKL_API.G_EXCEPTION_ERROR;
6070: END IF;
6071: END IF;
6072: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6074: RPAD(l_tcnv_rec.trx_number,22)||
6075: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
6076: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6077: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6135: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6136: IF l_can_tcnv_tbl.COUNT > 0 THEN
6137: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6138: LOOP
6139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6140: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6141: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6142: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6143: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6150: -- Report Content for non-accruals
6151: IF l_tcnv_tbl.COUNT > 0 THEN
6152: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6153: LOOP
6154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6155: RPAD(l_tcnv_tbl(x).trx_number,22)||
6156: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6157: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6158: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6203: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6204: IF l_can_tcnv_tbl.COUNT > 0 THEN
6205: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6206: LOOP
6207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6208: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6209: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6210: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6211: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6218: -- Report Content for non-accruals
6219: IF l_tcnv_tbl.COUNT > 0 THEN
6220: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6221: LOOP
6222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6223: RPAD(l_tcnv_tbl(x).trx_number,22)||
6224: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6225: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6226: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6304: END IF;
6305: END IF;
6306:
6307: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6309: RPAD(l_tcnv_rec.trx_number,22)||
6310: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6311: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6312: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6386: END IF;
6387: END IF;
6388:
6389: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6391: RPAD(l_tcnv_rec.trx_number,22)||
6392: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6393: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6394: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6449: END IF; -- bug 2474969 moved end if which was after fnd_file

6445: p_token1 => g_contract_number_token,
6446: p_token1_value => l_contract_number);
6447: RAISE OKL_API.G_EXCEPTION_ERROR;
6448: END IF;
6449: END IF; -- bug 2474969 moved end if which was after fnd_file
6450: -- as a result catchup entries were not printing.
6451:
6452: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6453: --Report content for reversal of non-accrual entries

Line 6457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6453: --Report content for reversal of non-accrual entries
6454: IF l_can_tcnv_tbl.COUNT > 0 THEN
6455: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6456: LOOP
6457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6458: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6459: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6460: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6461: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6468: -- Report content for catchup entries
6469: IF l_tcnv_tbl.COUNT > 0 THEN
6470: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6471: LOOP
6472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6473: RPAD(l_tcnv_tbl(x).trx_number,22)||
6474: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
6475: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6476: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6534: END IF; -- bug 2474969 moved end if which was after fnd_file

6530: p_token1 => g_contract_number_token,
6531: p_token1_value => l_contract_number);
6532: RAISE OKL_API.G_EXCEPTION_ERROR;
6533: END IF;
6534: END IF; -- bug 2474969 moved end if which was after fnd_file
6535: -- as a result catchup entries were not printing.
6536:
6537: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6538: --Report content for reversal of non-accrual entries

Line 6542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6538: --Report content for reversal of non-accrual entries
6539: IF l_can_tcnv_tbl.COUNT > 0 THEN
6540: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6541: LOOP
6542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6543: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6544: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6545: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6546: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6553: -- Report content for catchup entries
6554: IF l_tcnv_tbl.COUNT > 0 THEN
6555: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6556: LOOP
6557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6558: RPAD(l_tcnv_tbl(x).trx_number,22)||
6559: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
6560: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6561: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6635: RAISE OKL_API.G_EXCEPTION_ERROR;
6636: END IF;
6637: END IF;
6638: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6640: RPAD(l_tcnv_rec.trx_number,22)||
6641: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
6642: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6643: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6716: RAISE OKL_API.G_EXCEPTION_ERROR;
6717: END IF;
6718: END IF;
6719: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6721: RPAD(l_tcnv_rec.trx_number,22)||
6722: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
6723: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6724: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6797: END IF;
6798: END IF;
6799:
6800: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6802: RPAD(l_tcnv_rec.trx_number,22)||
6803: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6804: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6805: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6881: END IF;
6882: END IF;
6883:
6884: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6886: RPAD(l_tcnv_rec.trx_number,22)||
6887: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6888: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6889: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 6952: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6948: -- Report Content for reverse accruals
6949: IF l_tcnv_tbl.COUNT > 0 THEN
6950: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6951: LOOP
6952: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6953: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6954: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6955: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6956: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 6967: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

6963: -- Report Content for non-accruals
6964: IF l_tcnv_tbl.COUNT > 0 THEN
6965: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6966: LOOP
6967: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6968: RPAD(l_tcnv_tbl(x).trx_number,22)||
6969: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
6970: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6971: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 7019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7015: -- Report Content for reverse accruals
7016: IF l_tcnv_tbl.COUNT > 0 THEN
7017: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7018: LOOP
7019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7020: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7021: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7022: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7023: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 7034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7030: -- Report Content for non-accruals
7031: IF l_tcnv_tbl.COUNT > 0 THEN
7032: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7033: LOOP
7034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7035: RPAD(l_tcnv_tbl(x).trx_number,22)||
7036: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7037: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7038: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

Line 7119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7115: RAISE OKL_API.G_EXCEPTION_ERROR;
7116: END IF;
7117: END IF;
7118: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7120: RPAD(l_tcnv_rec.trx_number,22)||
7121: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7122: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7123: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7198: RAISE OKL_API.G_EXCEPTION_ERROR;
7199: END IF;
7200: END IF;
7201: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7203: RPAD(l_tcnv_rec.trx_number,22)||
7204: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7205: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7206: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7302: RAISE OKL_API.G_EXCEPTION_ERROR;
7303: END IF;
7304: END IF;
7305: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7307: RPAD(l_tcnv_rec.trx_number,22)||
7308: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7309: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
7310: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 7412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7408: RAISE OKL_API.G_EXCEPTION_ERROR;
7409: END IF;
7410: END IF;
7411: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7413: RPAD(l_tcnv_rec.trx_number,22)||
7414: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7415: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
7416: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 7591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7587: RAISE OKL_API.G_EXCEPTION_ERROR;
7588: END IF;
7589: END IF;
7590: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7592: RPAD(l_tcnv_rec.trx_number,22)||
7593: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7594: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7595: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7638: RAISE OKL_API.G_EXCEPTION_ERROR;
7639: END IF;
7640: END IF;
7641: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7643: RPAD(l_tcnv_rec.trx_number,22)||
7644: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7645: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7646: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7727: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7723: END IF;
7724: END IF;
7725:
7726: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7727: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7728: RPAD(l_tcnv_rec.trx_number,22)||
7729: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7730: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7731: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7775: END IF;
7776: END IF;
7777:
7778: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7780: RPAD(l_tcnv_rec.trx_number,22)||
7781: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7782: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7783: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7860: RAISE OKL_API.G_EXCEPTION_ERROR;
7861: END IF;
7862: END IF;
7863: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7865: RPAD(l_tcnv_rec.trx_number,22)||
7866: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7867: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7868: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7910: RAISE OKL_API.G_EXCEPTION_ERROR;
7911: END IF;
7912: END IF;
7913: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7915: RPAD(l_tcnv_rec.trx_number,22)||
7916: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7917: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7918: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 7999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

7995: RAISE OKL_API.G_EXCEPTION_ERROR;
7996: END IF;
7997: END IF;
7998: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8000: RPAD(l_tcnv_rec.trx_number,22)||
8001: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8002: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8003: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 8049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8045: RAISE OKL_API.G_EXCEPTION_ERROR;
8046: END IF;
8047: END IF;
8048: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8050: RPAD(l_tcnv_rec.trx_number,22)||
8051: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8052: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8053: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 8227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8223: END IF;
8224: END IF;
8225:
8226: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8228: RPAD(l_tcnv_rec.trx_number,22)||
8229: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8230: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8231: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8271: END IF;
8272: END IF;
8273:
8274: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8276: RPAD(l_tcnv_rec.trx_number,22)||
8277: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8278: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8279: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8374: END IF;
8375: END IF;
8376:
8377: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8379: RPAD(l_tcnv_rec.trx_number,22)||
8380: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8381: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8382: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8422: END IF;
8423: END IF;
8424:
8425: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8427: RPAD(l_tcnv_rec.trx_number,22)||
8428: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8429: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8430: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8529: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8525: END IF;
8526: END IF;
8527:
8528: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8529: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8530: RPAD(l_tcnv_rec.trx_number,22)||
8531: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8532: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8533: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8573: END IF;
8574: END IF;
8575:
8576: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8578: RPAD(l_tcnv_rec.trx_number,22)||
8579: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8580: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8581: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

Line 8680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8676: END IF;
8677: END IF;
8678:
8679: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8681: RPAD(l_tcnv_rec.trx_number,22)||
8682: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8683: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8684: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 8729: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||

8725: END IF;
8726: END IF;
8727:
8728: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8729: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8730: RPAD(l_tcnv_rec.trx_number,22)||
8731: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8732: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8733: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

Line 8772: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

8768: ,'_PVT');
8769:
8770: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8771: -- Select the contract for error reporting
8772: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
8773: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
8774: x_return_status);
8775: -- Bug 4700105. Using get_error_msg.
8776: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

Line 8781: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

8777: IF (l_error_msg_tbl.COUNT > 0) THEN
8778: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
8779: LOOP
8780: IF l_error_msg_tbl(i) IS NOT NULL THEN
8781: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8782: END IF;
8783: END LOOP;
8784: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8785: END IF;

Line 8784: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

8780: IF l_error_msg_tbl(i) IS NOT NULL THEN
8781: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8782: END IF;
8783: END LOOP;
8784: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8785: END IF;
8786: END IF;
8787: -- Bug 4700105.
8788: FND_MSG_PUB.Delete_Msg;

Line 8800: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

8796: ,l_msg_data
8797: ,'_PVT');
8798: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8799: -- Select the contract for error reporting
8800: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
8801: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
8802: x_return_status);
8803: -- Bug 4700105. Using get_error_msg.
8804: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

Line 8809: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

8805: IF (l_error_msg_tbl.COUNT > 0) THEN
8806: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
8807: LOOP
8808: IF l_error_msg_tbl(i) IS NOT NULL THEN
8809: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8810: END IF;
8811: END LOOP;
8812: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8813: END IF;

Line 8812: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

8808: IF l_error_msg_tbl(i) IS NOT NULL THEN
8809: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8810: END IF;
8811: END LOOP;
8812: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8813: END IF;
8814: END IF;
8815: -- Bug 4700105.
8816: FND_MSG_PUB.Delete_Msg;

Line 8843: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

8839: ,'_PVT');
8840:
8841: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8842: -- Select the contract for error reporting
8843: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
8844: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
8845: x_return_status);
8846: -- Bug 4700105. Using get_error_msg.
8847: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

Line 8852: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

8848: IF (l_error_msg_tbl.COUNT > 0) THEN
8849: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
8850: LOOP
8851: IF l_error_msg_tbl(i) IS NOT NULL THEN
8852: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8853: END IF;
8854: END LOOP;
8855: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8856: END IF;

Line 8855: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

8851: IF l_error_msg_tbl(i) IS NOT NULL THEN
8852: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
8853: END IF;
8854: END LOOP;
8855: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
8856: END IF;
8857: END IF;
8858: -- Bug 4700105.
8859: FND_MSG_PUB.Delete_Msg;

Line 9200: fnd_file.put_line(fnd_file.log, 'Please specify a value for the profile option OKL: Generate Accrual Concurrent Workers');

9196:
9197: IF l_num_workers IS NULL THEN
9198: Okl_Api.set_message(p_app_name => g_app_name,
9199: p_msg_name => 'OKL_AGN_WORKER_ERROR');
9200: fnd_file.put_line(fnd_file.log, 'Please specify a value for the profile option OKL: Generate Accrual Concurrent Workers');
9201: RAISE OKL_API.G_EXCEPTION_ERROR;
9202: END IF;
9203: -- END SGIYER
9204:

Line 9242: FND_FILE.PUT_LINE(FND_FILE.log, 'No Data Found for criteria passed');

9238: -- reset, ready for use again
9239: l_init_loop := TRUE;
9240:
9241: if l_int_counter = 0 then
9242: FND_FILE.PUT_LINE(FND_FILE.log, 'No Data Found for criteria passed');
9243: end if;
9244:
9245: -- find the maximum line count from the original table and delete it
9246: -- put this as the first element of the new sorted table

Line 9362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launching Process '||l_worker_id||' with Request ID '||l_reqid);

9358: ELSE
9359: errbuf := 'Sub-Request submitted successfully';
9360: retcode := 0 ;
9361: END IF;
9362: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launching Process '||l_worker_id||' with Request ID '||l_reqid);
9363: end loop;
9364:
9365: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
9366: request_data => to_char(i)) ;

Line 9376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No workers assigned due to no data found for prcocesing');

9372: --WHERE process_status = 'PENDING_ASSIGNMENT'
9373: --AND assigned_process = to_char(l_seq_next);
9374: --COMMIT;
9375: else
9376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No workers assigned due to no data found for prcocesing');
9377: end if; -- l_data_found
9378: -- END MDOKAL CODE
9379: END IF;
9380: ELSE

Line 9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9530: l_contract_error_count := l_contract_error_count + 1;
9531: END IF;
9532:
9533: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

Line 9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9531: END IF;
9532:
9533: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

Line 9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9532:
9533: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9540: IF l_contract_error_tbl.COUNT > 0 THEN

Line 9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9533: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9540: IF l_contract_error_tbl.COUNT > 0 THEN
9541: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

Line 9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

9534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9540: IF l_contract_error_tbl.COUNT > 0 THEN
9541: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9542: LOOP

Line 9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

9535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9538: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9540: IF l_contract_error_tbl.COUNT > 0 THEN
9541: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9542: LOOP
9543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

Line 9543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

9539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9540: IF l_contract_error_tbl.COUNT > 0 THEN
9541: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9542: LOOP
9543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9544: END LOOP;
9545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9547: END IF;

Line 9545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9541: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9542: LOOP
9543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9544: END LOOP;
9545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9547: END IF;
9548:
9549: END IF; --IF l_accrual_contracts_tbl.COUNT > 0 THEN

Line 9546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));

9542: LOOP
9543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9544: END LOOP;
9545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9547: END IF;
9548:
9549: END IF; --IF l_accrual_contracts_tbl.COUNT > 0 THEN
9550:

Line 9562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9558: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
9559: l_return_status := Okl_Api.G_RET_STS_ERROR;
9560:
9561: -- print the error message in the log file and output files
9562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9564: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9565: ||' '||l_return_status);
9566: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9559: l_return_status := Okl_Api.G_RET_STS_ERROR;
9560:
9561: -- print the error message in the log file and output files
9562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9564: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9565: ||' '||l_return_status);
9566: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9567: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9564: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9560:
9561: -- print the error message in the log file and output files
9562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9564: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9565: ||' '||l_return_status);
9566: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9567: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9568: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9570: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9566: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9567: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9568: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9569: LOOP
9570: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
9571: END LOOP;
9572: END IF;
9573:
9574: retcode := 2;

Line 9580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9576: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
9577: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9578:
9579: -- print the error message in the log file
9580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9583: ||' '||l_return_status);
9584: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9577: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9578:
9579: -- print the error message in the log file
9580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9583: ||' '||l_return_status);
9584: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9585: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9578:
9579: -- print the error message in the log file
9580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9583: ||' '||l_return_status);
9584: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9585: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9586: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9588: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9584: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9585: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9586: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9587: LOOP
9588: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
9589: END LOOP;
9590: END IF;
9591:
9592: retcode := 2;

Line 9599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9595:
9596: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9597:
9598: -- print the error message in the log file
9599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9601: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9602: ||' '||l_return_status);
9603: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9596: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9597:
9598: -- print the error message in the log file
9599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9601: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9602: ||' '||l_return_status);
9603: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9604: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9601: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9597:
9598: -- print the error message in the log file
9599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9601: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9602: ||' '||l_return_status);
9603: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9604: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9605: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9607: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9603: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9604: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9605: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9606: LOOP
9607: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
9608: END LOOP;
9609: END IF;
9610:
9611: errbuf := SQLERRM;

Line 9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9927: END LOOP;
9928: CLOSE process_accruals_csr;
9929:
9930:
9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

Line 9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9928: CLOSE process_accruals_csr;
9929:
9930:
9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

Line 9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9929:
9930:
9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9937: IF l_contract_error_tbl.COUNT > 0 THEN

Line 9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9930:
9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9937: IF l_contract_error_tbl.COUNT > 0 THEN
9938: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

Line 9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

9931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9937: IF l_contract_error_tbl.COUNT > 0 THEN
9938: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9939: LOOP

Line 9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

9932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9937: IF l_contract_error_tbl.COUNT > 0 THEN
9938: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9939: LOOP
9940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

Line 9940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

9936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
9937: IF l_contract_error_tbl.COUNT > 0 THEN
9938: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9939: LOOP
9940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9941: END LOOP;
9942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9944: END IF;

Line 9942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9938: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
9939: LOOP
9940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9941: END LOOP;
9942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9944: END IF;
9945:
9946: retcode := 0;

Line 9943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));

9939: LOOP
9940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
9941: END LOOP;
9942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
9944: END IF;
9945:
9946: retcode := 0;
9947: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 9954: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9950: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
9951: l_return_status := Okl_Api.G_RET_STS_ERROR;
9952:
9953: -- print the error message in the log file and output files
9954: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9956: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9957: ||' '||l_return_status);
9958: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9951: l_return_status := Okl_Api.G_RET_STS_ERROR;
9952:
9953: -- print the error message in the log file and output files
9954: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9956: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9957: ||' '||l_return_status);
9958: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9959: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9956: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9952:
9953: -- print the error message in the log file and output files
9954: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9956: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9957: ||' '||l_return_status);
9958: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9959: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9960: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9962: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9958: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9959: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9960: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9961: LOOP
9962: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
9963: END LOOP;
9964: END IF;
9965:
9966: retcode := 2;

Line 9972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9968: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
9969: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9970:
9971: -- print the error message in the log file
9972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9974: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9975: ||' '||l_return_status);
9976: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9969: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9970:
9971: -- print the error message in the log file
9972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9974: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9975: ||' '||l_return_status);
9976: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9977: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9974: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9970:
9971: -- print the error message in the log file
9972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9974: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9975: ||' '||l_return_status);
9976: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9977: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9978: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9980: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9976: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9977: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9978: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9979: LOOP
9980: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
9981: END LOOP;
9982: END IF;
9983:
9984: retcode := 2;

Line 9991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

9987:
9988: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9989:
9990: -- print the error message in the log file
9991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9993: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9994: ||' '||l_return_status);
9995: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

Line 9992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

9988: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
9989:
9990: -- print the error message in the log file
9991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9993: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9994: ||' '||l_return_status);
9995: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9996: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

Line 9993: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

9989:
9990: -- print the error message in the log file
9991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
9992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
9993: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
9994: ||' '||l_return_status);
9995: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9996: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9997: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

Line 9999: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

9995: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
9996: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
9997: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
9998: LOOP
9999: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10000: END LOOP;
10001: END IF;
10002:
10003: errbuf := SQLERRM;