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 846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||

842:
843: BEGIN
844:
845: -- Create report header
846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
847: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
849: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

844:
845: -- Create report header
846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
847: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
849: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
851:
852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));

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

846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
847: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'),1)||LPAD(l_space,43));
848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
849: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
851:
852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
853: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
854: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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

848: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_space,43)||
849: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
851:
852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
853: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
854: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
855:
856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

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

849: SUBSTR(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'),1)||LPAD(l_space,43));
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
851:
852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
853: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
854: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
855:
856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
857: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')

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

850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
851:
852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
853: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
854: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
855:
856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
857: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
858: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041

Line 856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

852: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER'));
853: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_HEADER_UNDERLINE'));
854: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
855:
856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
857: --FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
858: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041
859: RPAD(' ', 80)
860: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')

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

858: --||' '||RPAD(p_sob_name, 65) MGAAP 7263041
859: RPAD(' ', 80)
860: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
861: ||' '||p_org_name);
862: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
863: ||' '||RPAD(to_char(l_sysdate,'DD-MON-RRRR HH24:MI:SS'), 61)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACCRUAL_DATE')
864: ||' '||p_accrual_date);
865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
866: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')

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

861: ||' '||p_org_name);
862: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
863: ||' '||RPAD(to_char(l_sysdate,'DD-MON-RRRR HH24:MI:SS'), 61)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACCRUAL_DATE')
864: ||' '||p_accrual_date);
865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
866: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
867: ||' '||p_batch_name);
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
869:

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

864: ||' '||p_accrual_date);
865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
866: ||' '||RPAD(p_func_curr_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
867: ||' '||p_batch_name);
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
869:
870: -- Create Report Content
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
872: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)

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

867: ||' '||p_batch_name);
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
869:
870: -- Create Report Content
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE'),28)
872: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_NUM_TITLE'),22)
873: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),17)
874: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_RULE_STATUS'),20)
875: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_OVRD_STATUS'),16)

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

876: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY'),9)
877: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),17) ||
878: LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_REPRESENTATION_TYPE'),15)); -- MGAAP 7263041
879:
880: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_LINE'),28)
881: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_TRX_LINE'),22)
882: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY_UNDERLINE'),17)
883: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_RUL_STAT_UNDERLINE'),20)
884: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_OVD_STAT_UNDERLINE'),16)

Line 2021: 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.');

2017: l_count := l_acc_gen_tbl(x).acc_gen_key_tbl.LAST + 1;
2018: l_acc_gen_tbl(x).acc_gen_key_tbl(l_count).source_table:= 'MTL_SYSTEM_ITEMS_VL';
2019: l_acc_gen_tbl(x).acc_gen_key_tbl(l_count).primary_key_column := l_inv_item_id;
2020: ELSE
2021: 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.');
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: END IF; --IF l_lty_code IN ('FREE_FORM1','LINK_SERV_ASSET') THEN
2025: END IF; -- IF kle_id_status = 'NEW'

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

6336: ,l_return_status);
6337:
6338: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6339: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
6341: END IF;
6342: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6343: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
6344: IF p_process_accrual_rec.submission_mode='BATCH' THEN

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

6341: END IF;
6342: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6343: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
6344: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6345: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
6346: END IF;
6347: RAISE Okl_Api.G_EXCEPTION_ERROR;
6348: END IF;
6349:

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

6731: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6732: IF l_can_tcnv_tbl.COUNT > 0 THEN
6733: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6734: LOOP
6735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6736: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6737: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6738: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6739: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

6746: -- Report content for catchup activity
6747: IF l_tcnv_tbl.COUNT > 0 THEN
6748: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6749: LOOP
6750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6751: RPAD(l_tcnv_tbl(x).trx_number,22)||
6752: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
6753: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6754: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

6797: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6798: IF l_can_tcnv_tbl.COUNT > 0 THEN
6799: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
6800: LOOP
6801: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6802: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
6803: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
6804: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6805: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

6812: -- Report content for catchup activity
6813: IF l_tcnv_tbl.COUNT > 0 THEN
6814: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
6815: LOOP
6816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6817: RPAD(l_tcnv_tbl(x).trx_number,22)||
6818: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
6819: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
6820: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

6896: RAISE OKL_API.G_EXCEPTION_ERROR;
6897: END IF;
6898: END IF;
6899: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6901: RPAD(l_tcnv_rec.trx_number,22)||
6902: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
6903: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6904: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

6979: RAISE OKL_API.G_EXCEPTION_ERROR;
6980: END IF;
6981: END IF;
6982: IF p_process_accrual_rec.submission_mode='BATCH' THEN
6983: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
6984: RPAD(l_tcnv_rec.trx_number,22)||
6985: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
6986: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
6987: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7045: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7046: IF l_can_tcnv_tbl.COUNT > 0 THEN
7047: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7048: LOOP
7049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7050: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7051: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7052: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7053: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7060: -- Report Content for non-accruals
7061: IF l_tcnv_tbl.COUNT > 0 THEN
7062: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7063: LOOP
7064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7065: RPAD(l_tcnv_tbl(x).trx_number,22)||
7066: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7067: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7068: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7113: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7114: IF l_can_tcnv_tbl.COUNT > 0 THEN
7115: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7116: LOOP
7117: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7118: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7119: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7120: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7121: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7128: -- Report Content for non-accruals
7129: IF l_tcnv_tbl.COUNT > 0 THEN
7130: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7131: LOOP
7132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7133: RPAD(l_tcnv_tbl(x).trx_number,22)||
7134: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7135: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7136: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7214: END IF;
7215: END IF;
7216:
7217: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7219: RPAD(l_tcnv_rec.trx_number,22)||
7220: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7221: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7222: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7296: END IF;
7297: END IF;
7298:
7299: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7301: RPAD(l_tcnv_rec.trx_number,22)||
7302: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7303: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7304: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7355: p_token1 => g_contract_number_token,
7356: p_token1_value => l_contract_number);
7357: RAISE OKL_API.G_EXCEPTION_ERROR;
7358: END IF;
7359: END IF; -- bug 2474969 moved end if which was after fnd_file
7360: -- as a result catchup entries were not printing.
7361:
7362: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7363: --Report content for reversal of non-accrual entries

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

7363: --Report content for reversal of non-accrual entries
7364: IF l_can_tcnv_tbl.COUNT > 0 THEN
7365: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7366: LOOP
7367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7368: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7369: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7370: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7371: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7378: -- Report content for catchup entries
7379: IF l_tcnv_tbl.COUNT > 0 THEN
7380: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7381: LOOP
7382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7383: RPAD(l_tcnv_tbl(x).trx_number,22)||
7384: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
7385: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7386: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7440: p_token1 => g_contract_number_token,
7441: p_token1_value => l_contract_number);
7442: RAISE OKL_API.G_EXCEPTION_ERROR;
7443: END IF;
7444: END IF; -- bug 2474969 moved end if which was after fnd_file
7445: -- as a result catchup entries were not printing.
7446:
7447: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7448: --Report content for reversal of non-accrual entries

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

7448: --Report content for reversal of non-accrual entries
7449: IF l_can_tcnv_tbl.COUNT > 0 THEN
7450: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7451: LOOP
7452: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7453: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7454: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7455: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7456: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7463: -- Report content for catchup entries
7464: IF l_tcnv_tbl.COUNT > 0 THEN
7465: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7466: LOOP
7467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7468: RPAD(l_tcnv_tbl(x).trx_number,22)||
7469: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CATCHUP_REVENUE'),17)||
7470: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7471: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7545: RAISE OKL_API.G_EXCEPTION_ERROR;
7546: END IF;
7547: END IF;
7548: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7550: RPAD(l_tcnv_rec.trx_number,22)||
7551: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7552: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7553: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7626: RAISE OKL_API.G_EXCEPTION_ERROR;
7627: END IF;
7628: END IF;
7629: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7631: RPAD(l_tcnv_rec.trx_number,22)||
7632: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
7633: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7634: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7707: END IF;
7708: END IF;
7709:
7710: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7711: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7712: RPAD(l_tcnv_rec.trx_number,22)||
7713: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7714: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7715: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7791: END IF;
7792: END IF;
7793:
7794: IF p_process_accrual_rec.submission_mode='BATCH' THEN
7795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7796: RPAD(l_tcnv_rec.trx_number,22)||
7797: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7798: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
7799: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

7858: -- Report Content for reverse accruals
7859: IF l_tcnv_tbl.COUNT > 0 THEN
7860: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7861: LOOP
7862: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7863: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7864: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7865: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7866: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7873: -- Report Content for non-accruals
7874: IF l_tcnv_tbl.COUNT > 0 THEN
7875: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7876: LOOP
7877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7878: RPAD(l_tcnv_tbl(x).trx_number,22)||
7879: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7880: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7881: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7925: -- Report Content for reverse accruals
7926: IF l_tcnv_tbl.COUNT > 0 THEN
7927: FOR x IN l_can_tcnv_tbl.FIRST..l_can_tcnv_tbl.LAST
7928: LOOP
7929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7930: RPAD(l_can_tcnv_tbl(x).trx_number,22)||
7931: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVERSE'),17)||
7932: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7933: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_can_tcnv_tbl(x).update_status_yn,0,0),16)||

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

7940: -- Report Content for non-accruals
7941: IF l_tcnv_tbl.COUNT > 0 THEN
7942: FOR x IN l_tcnv_tbl.FIRST..l_tcnv_tbl.LAST
7943: LOOP
7944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
7945: RPAD(l_tcnv_tbl(x).trx_number,22)||
7946: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
7947: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).accrual_status_yn,0,0),20)||
7948: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_tbl(x).update_status_yn,0,0),16)||

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

8025: RAISE OKL_API.G_EXCEPTION_ERROR;
8026: END IF;
8027: END IF;
8028: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8030: RPAD(l_tcnv_rec.trx_number,22)||
8031: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8032: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8033: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8108: RAISE OKL_API.G_EXCEPTION_ERROR;
8109: END IF;
8110: END IF;
8111: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8113: RPAD(l_tcnv_rec.trx_number,22)||
8114: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8115: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8116: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8212: RAISE OKL_API.G_EXCEPTION_ERROR;
8213: END IF;
8214: END IF;
8215: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8217: RPAD(l_tcnv_rec.trx_number,22)||
8218: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8219: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8220: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

8324: RAISE OKL_API.G_EXCEPTION_ERROR;
8325: END IF;
8326: END IF;
8327: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8329: RPAD(l_tcnv_rec.trx_number,22)||
8330: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8331: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8332: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

8551: RAISE OKL_API.G_EXCEPTION_ERROR;
8552: END IF;
8553: END IF;
8554: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8556: RPAD(l_tcnv_rec.trx_number,22)||
8557: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8558: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8559: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8603: RAISE OKL_API.G_EXCEPTION_ERROR;
8604: END IF;
8605: END IF;
8606: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8608: RPAD(l_tcnv_rec.trx_number,22)||
8609: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8610: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8611: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8693: END IF;
8694: END IF;
8695:
8696: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8698: RPAD(l_tcnv_rec.trx_number,22)||
8699: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8700: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8701: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8746: END IF;
8747: END IF;
8748:
8749: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8751: RPAD(l_tcnv_rec.trx_number,22)||
8752: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8753: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8754: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8836: RAISE OKL_API.G_EXCEPTION_ERROR;
8837: END IF;
8838: END IF;
8839: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8841: RPAD(l_tcnv_rec.trx_number,22)||
8842: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8843: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8844: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8887: RAISE OKL_API.G_EXCEPTION_ERROR;
8888: END IF;
8889: END IF;
8890: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8892: RPAD(l_tcnv_rec.trx_number,22)||
8893: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
8894: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
8895: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

8977: RAISE OKL_API.G_EXCEPTION_ERROR;
8978: END IF;
8979: END IF;
8980: IF p_process_accrual_rec.submission_mode='BATCH' THEN
8981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
8982: RPAD(l_tcnv_rec.trx_number,22)||
8983: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
8984: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
8985: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

9028: RAISE OKL_API.G_EXCEPTION_ERROR;
9029: END IF;
9030: END IF;
9031: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9033: RPAD(l_tcnv_rec.trx_number,22)||
9034: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
9035: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
9036: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

9210: END IF;
9211: END IF;
9212:
9213: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9215: RPAD(l_tcnv_rec.trx_number,22)||
9216: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
9217: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9218: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9259: END IF;
9260: END IF;
9261:
9262: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9264: RPAD(l_tcnv_rec.trx_number,22)||
9265: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
9266: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9267: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9363: END IF;
9364: END IF;
9365:
9366: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9368: RPAD(l_tcnv_rec.trx_number,22)||
9369: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
9370: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9371: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9412: END IF;
9413: END IF;
9414:
9415: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9417: RPAD(l_tcnv_rec.trx_number,22)||
9418: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
9419: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9420: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9517: END IF;
9518: END IF;
9519:
9520: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9521: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9522: RPAD(l_tcnv_rec.trx_number,22)||
9523: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
9524: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9525: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9566: END IF;
9567: END IF;
9568:
9569: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9570: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9571: RPAD(l_tcnv_rec.trx_number,22)||
9572: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_NON_REVENUE'),17)||
9573: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.accrual_status_yn,0,0),20)||
9574: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('YES_NO',l_tcnv_rec.update_status_yn,0,0),16)||

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

9671: END IF;
9672: END IF;
9673:
9674: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9676: RPAD(l_tcnv_rec.trx_number,22)||
9677: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
9678: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
9679: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

9721: END IF;
9722: END IF;
9723:
9724: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_contract_number,28)||
9726: RPAD(l_tcnv_rec.trx_number,22)||
9727: RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_REVENUE'),17)||
9728: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),20)||
9729: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NOT APPLICABLE',540,0),16)||

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

9764: ,'_PVT');
9765:
9766: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9767: -- Select the contract for error reporting
9768: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
9769: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
9770: x_return_status);
9771: -- Bug 4700105. Using get_error_msg.
9772: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

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

9773: IF (l_error_msg_tbl.COUNT > 0) THEN
9774: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
9775: LOOP
9776: IF l_error_msg_tbl(i) IS NOT NULL THEN
9777: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9778: END IF;
9779: END LOOP;
9780: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9781: END IF;

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

9776: IF l_error_msg_tbl(i) IS NOT NULL THEN
9777: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9778: END IF;
9779: END LOOP;
9780: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9781: END IF;
9782: END IF;
9783: -- Bug 4700105.
9784: FND_MSG_PUB.Delete_Msg;

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

9792: ,l_msg_data
9793: ,'_PVT');
9794: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9795: -- Select the contract for error reporting
9796: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
9797: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
9798: x_return_status);
9799: -- Bug 4700105. Using get_error_msg.
9800: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

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

9801: IF (l_error_msg_tbl.COUNT > 0) THEN
9802: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
9803: LOOP
9804: IF l_error_msg_tbl(i) IS NOT NULL THEN
9805: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9806: END IF;
9807: END LOOP;
9808: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9809: END IF;

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

9804: IF l_error_msg_tbl(i) IS NOT NULL THEN
9805: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9806: END IF;
9807: END LOOP;
9808: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9809: END IF;
9810: END IF;
9811: -- Bug 4700105.
9812: FND_MSG_PUB.Delete_Msg;

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

9835: ,'_PVT');
9836:
9837: IF p_process_accrual_rec.submission_mode='BATCH' THEN
9838: -- Select the contract for error reporting
9839: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
9840: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
9841: x_return_status);
9842: -- Bug 4700105. Using get_error_msg.
9843: Okl_Accounting_Util.GET_ERROR_MSG(l_error_msg_tbl);

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

9844: IF (l_error_msg_tbl.COUNT > 0) THEN
9845: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
9846: LOOP
9847: IF l_error_msg_tbl(i) IS NOT NULL THEN
9848: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9849: END IF;
9850: END LOOP;
9851: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9852: END IF;

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

9847: IF l_error_msg_tbl(i) IS NOT NULL THEN
9848: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
9849: END IF;
9850: END LOOP;
9851: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
9852: END IF;
9853: END IF;
9854: -- Bug 4700105.
9855: FND_MSG_PUB.Delete_Msg;

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

10192:
10193: IF l_num_workers IS NULL THEN
10194: Okl_Api.set_message(p_app_name => g_app_name,
10195: p_msg_name => 'OKL_AGN_WORKER_ERROR');
10196: fnd_file.put_line(fnd_file.log, 'Please specify a value for the profile option OKL: Generate Accrual Concurrent Workers');
10197: RAISE OKL_API.G_EXCEPTION_ERROR;
10198: END IF;
10199: -- END SGIYER
10200:

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

10234: -- reset, ready for use again
10235: l_init_loop := TRUE;
10236:
10237: if l_int_counter = 0 then
10238: FND_FILE.PUT_LINE(FND_FILE.log, 'No Data Found for criteria passed');
10239: end if;
10240:
10241: -- find the maximum line count from the original table and delete it
10242: -- put this as the first element of the new sorted table

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

10354: ELSE
10355: errbuf := 'Sub-Request submitted successfully';
10356: retcode := 0 ;
10357: END IF;
10358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Launching Process '||l_worker_id||' with Request ID '||l_reqid);
10359: end loop;
10360:
10361: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',
10362: request_data => to_char(i)) ;

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

10368: --WHERE process_status = 'PENDING_ASSIGNMENT'
10369: --AND assigned_process = to_char(l_seq_next);
10370: --COMMIT;
10371: else
10372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No workers assigned due to no data found for prcocesing');
10373: end if; -- l_data_found
10374: -- END MDOKAL CODE
10375: END IF;
10376: ELSE

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

10526: l_contract_error_count := l_contract_error_count + 1;
10527: END IF;
10528:
10529: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
10530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

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

10527: END IF;
10528:
10529: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
10530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

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

10528:
10529: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
10530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10536: IF l_contract_error_tbl.COUNT > 0 THEN

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

10529: END LOOP; -- For y IN l_accrual_contracts_tbl.FIRST
10530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10536: IF l_contract_error_tbl.COUNT > 0 THEN
10537: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

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

10530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10536: IF l_contract_error_tbl.COUNT > 0 THEN
10537: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10538: LOOP

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

10531: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10536: IF l_contract_error_tbl.COUNT > 0 THEN
10537: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10538: LOOP
10539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

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

10535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10536: IF l_contract_error_tbl.COUNT > 0 THEN
10537: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10538: LOOP
10539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10540: END LOOP;
10541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10543: END IF;

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

10537: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10538: LOOP
10539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10540: END LOOP;
10541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10543: END IF;
10544:
10545: END IF; --IF l_accrual_contracts_tbl.COUNT > 0 THEN

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

10538: LOOP
10539: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10540: END LOOP;
10541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10542: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10543: END IF;
10544:
10545: END IF; --IF l_accrual_contracts_tbl.COUNT > 0 THEN
10546:

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

10554: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
10555: l_return_status := Okl_Api.G_RET_STS_ERROR;
10556:
10557: -- print the error message in the log file and output files
10558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10561: ||' '||l_return_status);
10562: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10555: l_return_status := Okl_Api.G_RET_STS_ERROR;
10556:
10557: -- print the error message in the log file and output files
10558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10561: ||' '||l_return_status);
10562: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10563: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10556:
10557: -- print the error message in the log file and output files
10558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10561: ||' '||l_return_status);
10562: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10563: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10564: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10562: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10563: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10564: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10565: LOOP
10566: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10567: END LOOP;
10568: END IF;
10569:
10570: retcode := 2;

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

10572: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
10573: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10574:
10575: -- print the error message in the log file
10576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10579: ||' '||l_return_status);
10580: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10573: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10574:
10575: -- print the error message in the log file
10576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10579: ||' '||l_return_status);
10580: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10581: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10574:
10575: -- print the error message in the log file
10576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10579: ||' '||l_return_status);
10580: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10581: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10582: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10580: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10581: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10582: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10583: LOOP
10584: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10585: END LOOP;
10586: END IF;
10587:
10588: retcode := 2;

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

10591:
10592: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10593:
10594: -- print the error message in the log file
10595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10597: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10598: ||' '||l_return_status);
10599: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10592: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10593:
10594: -- print the error message in the log file
10595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10597: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10598: ||' '||l_return_status);
10599: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10600: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10593:
10594: -- print the error message in the log file
10595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10597: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10598: ||' '||l_return_status);
10599: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10600: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10601: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10599: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10600: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10601: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10602: LOOP
10603: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10604: END LOOP;
10605: END IF;
10606:
10607: errbuf := SQLERRM;

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

10923: END LOOP;
10924: CLOSE process_accruals_csr;
10925:
10926:
10927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

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

10924: CLOSE process_accruals_csr;
10925:
10926:
10927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

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

10925:
10926:
10927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10933: IF l_contract_error_tbl.COUNT > 0 THEN

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

10926:
10927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10933: IF l_contract_error_tbl.COUNT > 0 THEN
10934: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

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

10927: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10933: IF l_contract_error_tbl.COUNT > 0 THEN
10934: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10935: LOOP

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

10928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10933: IF l_contract_error_tbl.COUNT > 0 THEN
10934: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10935: LOOP
10936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

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

10932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
10933: IF l_contract_error_tbl.COUNT > 0 THEN
10934: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10935: LOOP
10936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10937: END LOOP;
10938: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10940: END IF;

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

10934: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
10935: LOOP
10936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10937: END LOOP;
10938: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10940: END IF;
10941:
10942: retcode := 0;

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

10935: LOOP
10936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
10937: END LOOP;
10938: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
10940: END IF;
10941:
10942: retcode := 0;
10943: l_return_status := OKL_API.G_RET_STS_SUCCESS;

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

10946: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
10947: l_return_status := Okl_Api.G_RET_STS_ERROR;
10948:
10949: -- print the error message in the log file and output files
10950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10951: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10953: ||' '||l_return_status);
10954: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10947: l_return_status := Okl_Api.G_RET_STS_ERROR;
10948:
10949: -- print the error message in the log file and output files
10950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10951: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10953: ||' '||l_return_status);
10954: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10955: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10948:
10949: -- print the error message in the log file and output files
10950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10951: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10953: ||' '||l_return_status);
10954: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10955: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10956: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10954: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10955: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10956: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10957: LOOP
10958: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10959: END LOOP;
10960: END IF;
10961:
10962: retcode := 2;

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

10964: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
10965: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10966:
10967: -- print the error message in the log file
10968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10970: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10971: ||' '||l_return_status);
10972: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10965: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10966:
10967: -- print the error message in the log file
10968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10970: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10971: ||' '||l_return_status);
10972: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10973: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10966:
10967: -- print the error message in the log file
10968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10970: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10971: ||' '||l_return_status);
10972: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10973: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10974: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10972: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10973: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10974: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10975: LOOP
10976: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10977: END LOOP;
10978: END IF;
10979:
10980: retcode := 2;

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

10983:
10984: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10985:
10986: -- print the error message in the log file
10987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10989: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10990: ||' '||l_return_status);
10991: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

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

10984: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
10985:
10986: -- print the error message in the log file
10987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10989: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10990: ||' '||l_return_status);
10991: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10992: IF (l_outer_error_msg_tbl.COUNT > 0) THEN

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

10985:
10986: -- print the error message in the log file
10987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
10988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
10989: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
10990: ||' '||l_return_status);
10991: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10992: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10993: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST

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

10991: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
10992: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
10993: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
10994: LOOP
10995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
10996: END LOOP;
10997: END IF;
10998:
10999: errbuf := SQLERRM;