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_ACCOUNTING_PROCESS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 26: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;

22:
23: l_trx_err_tbl trx_err_tbl_type;
24: l_total_headers NUMBER := 0;
25: l_total_lines NUMBER := 0;
26: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
27:
28:
29:
30: --Added by Keerthi for formating the output in the report

Line 381: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);

377: EXCEPTION
378:
379: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
380:
381: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
382: IF (l_error_msg_rec.COUNT > 0) THEN
383: FOR m IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
384: LOOP
385: Fnd_File.PUT_LINE(Fnd_File.LOG, l_error_msg_rec(m));

Line 760: l_ccid_valid := Okl_Accounting_Util.validate_gl_ccid(dist_rec.code_combination_id);

756: l_aelv_tbl_in(i).ACCOUNT_OVERLAY_SOURCE_ID := NULL;
757: l_aelv_tbl_in(i).SUBLEDGER_DOC_SEQUENCE_VALUE := NULL;
758: l_aelv_tbl_in(i).TAX_CODE_ID := NULL;
759:
760: l_ccid_valid := Okl_Accounting_Util.validate_gl_ccid(dist_rec.code_combination_id);
761:
762: IF (l_ccid_valid = Okl_Api.G_FALSE) THEN
763: l_aelv_tbl_in(i).accounting_error_code := 'INVALID_ACCOUNT';
764: -- l_aelv_tbl_in(i).code_combination_id := -1;

Line 978: l_chart_of_accounts_id NUMBER := Okl_Accounting_Util.get_chart_of_accounts_id;

974:
975:
976: IS
977:
978: l_chart_of_accounts_id NUMBER := Okl_Accounting_Util.get_chart_of_accounts_id;
979: l_set_of_books_name VARCHAR2(300);
980: l_structure_name VARCHAR2(300);
981: l_org_name VARCHAR2(240);
982: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 1042: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,

1038: ael.ae_line_number line_number,
1039: aeh.accounting_date accounting_date,
1040: DECODE(ael.accounted_cr,NULL,'DR','CR') dr_cr_flag,
1041: DECODE(ael.accounted_dr,NULL,ael.accounted_cr, ael.accounted_dr) accounted_amount,
1042: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1043: ael.currency_code currency_code,
1044: aeh.ae_category ae_category
1045: FROM okl_ae_lines ael,
1046: okl_ae_headers aeh,

Line 1121: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,

1117: ael.ae_line_number,
1118: aeh.accounting_date,
1119: DECODE(ael.accounted_cr,NULL,'DR','CR') dr_cr_flag,
1120: DECODE(ael.accounted_dr, NULL,ael.accounted_cr, ael.accounted_dr) accounted_amount,
1121: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1122: ael.currency_code,
1123: aeh.ae_category
1124: FROM
1125: okl_ae_lines ael,

Line 1216: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,

1212: ael.ae_line_number,
1213: aeh.accounting_date,
1214: DECODE(ael.accounted_cr, NULL, 'DR', 'CR') dr_cr_flag,
1215: DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
1216: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1217: ael.currency_code
1218: FROM
1219: okl_ae_lines ael,
1220: okl_ae_headers aeh

Line 1238: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,

1234: ael.ae_line_number line_number,
1235: aeh.accounting_date accounting_date,
1236: DECODE(ael.accounted_cr, NULL, 'DR', 'CR') dr_cr_flag,
1237: DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
1238: Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
1239: ael.currency_code currency_code
1240: FROM
1241: okl_ae_headers aeh,
1242: okl_ae_lines ael

Line 1256: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCT_LEASE_MANAGEMENT')

1252: BEGIN
1253: -- santonyr
1254:
1255: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 47 , ' ' ) ||
1256: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCT_LEASE_MANAGEMENT')
1257: || RPAD(' ', 48 , ' ' ));
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 42 , ' ' ) || Okl_Accounting_Util.get_message_token
1260: ('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCT_PROCESS_REPORT') || RPAD(' ', 43 , ' ' ));

Line 1259: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 42 , ' ' ) || Okl_Accounting_Util.get_message_token

1255: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 47 , ' ' ) ||
1256: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCT_LEASE_MANAGEMENT')
1257: || RPAD(' ', 48 , ' ' ));
1258:
1259: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 42 , ' ' ) || Okl_Accounting_Util.get_message_token
1260: ('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCT_PROCESS_REPORT') || RPAD(' ', 43 , ' ' ));
1261: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ',42 , ' ' ) || '-----------------------------------' || RPAD(' ', 43 , ' ' ));
1262: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1263:

Line 1266: l_set_of_books_name := Okl_Accounting_Util.get_set_of_books_name (Okl_Accounting_Util.get_set_of_books_id);

1262: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1263:
1264: -- Derive the org name and print it on the report.
1265:
1266: l_set_of_books_name := Okl_Accounting_Util.get_set_of_books_name (Okl_Accounting_Util.get_set_of_books_id);
1267:
1268: FOR org_rec IN org_csr (l_org_id)
1269: LOOP
1270: l_org_name := org_rec.name;

Line 1285: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_SET_OF_BOOKS') ||': '||

1281:
1282: i := 0;
1283:
1284:
1285: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_SET_OF_BOOKS') ||': '||
1286: RPAD(SUBSTR(l_set_of_books_name, 1, 60), 60, ' ') || LPAD(' ', 18 , ' ' )
1287: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||':' ||
1288: SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'), 1, 27));
1289: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')

Line 1287: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||':' ||

1283:
1284:
1285: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_SET_OF_BOOKS') ||': '||
1286: RPAD(SUBSTR(l_set_of_books_name, 1, 60), 60, ' ') || LPAD(' ', 18 , ' ' )
1287: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||':' ||
1288: SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'), 1, 27));
1289: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')
1290: ||':'|| SUBSTR(l_org_name, 1, 30) );
1291:

Line 1289: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')

1285: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_SET_OF_BOOKS') ||': '||
1286: RPAD(SUBSTR(l_set_of_books_name, 1, 60), 60, ' ') || LPAD(' ', 18 , ' ' )
1287: || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_RUN_DATE') ||':' ||
1288: SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'), 1, 27));
1289: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')
1290: ||':'|| SUBSTR(l_org_name, 1, 30) );
1291:
1292: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

Line 1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

1289: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_OPERUNIT')
1290: ||':'|| SUBSTR(l_org_name, 1, 30) );
1291:
1292: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||

Line 1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

1290: ||':'|| SUBSTR(l_org_name, 1, 30) );
1291:
1292: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));

Line 1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||

1292: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));
1299: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length, '-' ));
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||

Line 1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||

1293: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));
1299: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length, '-' ));
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||
1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||

Line 1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));

1294: 'OKL_START_DATE'), 25 , ' ' ) || RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1295: 'OKL_END_DATE'), 25 , ' ' ) ||
1296: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_STATUS'), 30 , ' ' ) ||
1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));
1299: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length, '-' ));
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||
1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||
1302: LPAD(l_total_headers, 20 , ' ' ) || LPAD(l_total_lines, 20 , ' ' ));

Line 1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||

1297: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_HEADERS'), 20 , ' ' ) ||
1298: LPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AE_LINES'), 20 , ' ' ));
1299: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length, '-' ));
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||
1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||
1302: LPAD(l_total_headers, 20 , ' ' ) || LPAD(l_total_lines, 20 , ' ' ));
1303: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 25 , ' ' ) || RPAD(' ', 25 , ' ' ) ||
1304: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_SUCCESS'), 30 , ' ' ) ||
1305: LPAD((l_total_headers - l_error_ae_headers), 20 , ' ' ) || LPAD((l_total_lines - l_error_ae_lines), 20 , ' ' ));

Line 1304: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_SUCCESS'), 30 , ' ' ) ||

1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, GET_PROPER_LENGTH(p_start_date,25,'TITLE') || GET_PROPER_LENGTH(p_end_date, 25 ,'TITLE' ) ||
1301: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), 30 , ' ' ) ||
1302: LPAD(l_total_headers, 20 , ' ' ) || LPAD(l_total_lines, 20 , ' ' ));
1303: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 25 , ' ' ) || RPAD(' ', 25 , ' ' ) ||
1304: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_SUCCESS'), 30 , ' ' ) ||
1305: LPAD((l_total_headers - l_error_ae_headers), 20 , ' ' ) || LPAD((l_total_lines - l_error_ae_lines), 20 , ' ' ));
1306: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 25 , ' ' ) || RPAD(' ', 25 , ' ' ) ||
1307: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_ERROR'), 30 , ' ' ) ||
1308: LPAD((l_error_ae_headers), 20 , ' ' ) || LPAD((l_error_ae_lines), 20 , ' ' ));

Line 1307: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_ERROR'), 30 , ' ' ) ||

1303: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 25 , ' ' ) || RPAD(' ', 25 , ' ' ) ||
1304: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_SUCCESS'), 30 , ' ' ) ||
1305: LPAD((l_total_headers - l_error_ae_headers), 20 , ' ' ) || LPAD((l_total_lines - l_error_ae_lines), 20 , ' ' ));
1306: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', 25 , ' ' ) || RPAD(' ', 25 , ' ' ) ||
1307: RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED_ERROR'), 30 , ' ' ) ||
1308: LPAD((l_error_ae_headers), 20 , ' ' ) || LPAD((l_error_ae_lines), 20 , ' ' ));
1309:
1310:
1311: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));

Line 1316: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),

1312: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('=', l_line_length , '=' ));
1313: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1314:
1315: header_report_rec.transaction_date := GET_PROPER_LENGTH(
1316: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1317: l_transaction_date_len, 'TITLE');
1318: header_report_rec.contract_number := GET_PROPER_LENGTH(
1319: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1320: l_contract_number_len, 'TITLE');

Line 1319: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),

1315: header_report_rec.transaction_date := GET_PROPER_LENGTH(
1316: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1317: l_transaction_date_len, 'TITLE');
1318: header_report_rec.contract_number := GET_PROPER_LENGTH(
1319: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1320: l_contract_number_len, 'TITLE');
1321: header_report_rec.transaction_number := GET_PROPER_LENGTH(
1322: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1323: l_transaction_number_len, 'TITLE');

Line 1322: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),

1318: header_report_rec.contract_number := GET_PROPER_LENGTH(
1319: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1320: l_contract_number_len, 'TITLE');
1321: header_report_rec.transaction_number := GET_PROPER_LENGTH(
1322: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1323: l_transaction_number_len, 'TITLE');
1324: header_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1325: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1326: l_transaction_line_number_len,'TITLE');

Line 1325: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),

1321: header_report_rec.transaction_number := GET_PROPER_LENGTH(
1322: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1323: l_transaction_number_len, 'TITLE');
1324: header_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1325: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1326: l_transaction_line_number_len,'TITLE');
1327: header_report_rec.accounting_date := GET_PROPER_LENGTH(
1328: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1329: l_Accounting_date_len, 'TITLE');

Line 1328: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),

1324: header_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1325: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1326: l_transaction_line_number_len,'TITLE');
1327: header_report_rec.accounting_date := GET_PROPER_LENGTH(
1328: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1329: l_Accounting_date_len, 'TITLE');
1330: header_report_rec.dr_cr_flag := GET_PROPER_LENGTH(
1331: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DR_CR_FLAG'),
1332: l_dr_cr_flag_len, 'TITLE');

Line 1331: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DR_CR_FLAG'),

1327: header_report_rec.accounting_date := GET_PROPER_LENGTH(
1328: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1329: l_Accounting_date_len, 'TITLE');
1330: header_report_rec.dr_cr_flag := GET_PROPER_LENGTH(
1331: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DR_CR_FLAG'),
1332: l_dr_cr_flag_len, 'TITLE');
1333: header_report_rec.accounted_Amount := GET_PROPER_LENGTH(
1334: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED'),
1335: l_accounted_amount_len, 'TITLE');

Line 1334: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED'),

1330: header_report_rec.dr_cr_flag := GET_PROPER_LENGTH(
1331: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DR_CR_FLAG'),
1332: l_dr_cr_flag_len, 'TITLE');
1333: header_report_rec.accounted_Amount := GET_PROPER_LENGTH(
1334: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED'),
1335: l_accounted_amount_len, 'TITLE');
1336: /* header_report_rec.account := GET_PROPER_LENGTH(
1337: okl_accounting_util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT'),
1338: l_account_len, 'TITLE');*/

Line 1337: okl_accounting_util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT'),

1333: header_report_rec.accounted_Amount := GET_PROPER_LENGTH(
1334: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNTED'),
1335: l_accounted_amount_len, 'TITLE');
1336: /* header_report_rec.account := GET_PROPER_LENGTH(
1337: okl_accounting_util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT'),
1338: l_account_len, 'TITLE');*/
1339: header_report_rec.account :=
1340: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT');
1341:

Line 1340: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT');

1336: /* header_report_rec.account := GET_PROPER_LENGTH(
1337: okl_accounting_util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT'),
1338: l_account_len, 'TITLE');*/
1339: header_report_rec.account :=
1340: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT');
1341:
1342: header_report_rec.currency := GET_PROPER_LENGTH(
1343: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),
1344: l_currency_len, 'TITLE');

Line 1343: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),

1339: header_report_rec.account :=
1340: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT');
1341:
1342: header_report_rec.currency := GET_PROPER_LENGTH(
1343: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),
1344: l_currency_len, 'TITLE');
1345:
1346: header_report_rec2.transaction_date := GET_PROPER_LENGTH(
1347: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),

Line 1347: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),

1343: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),
1344: l_currency_len, 'TITLE');
1345:
1346: header_report_rec2.transaction_date := GET_PROPER_LENGTH(
1347: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1348: l_transaction_date_len, 'TITLE');
1349: header_report_rec2.contract_number := GET_PROPER_LENGTH(
1350: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1351: l_contract_number_len, 'TITLE');

Line 1350: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1346: header_report_rec2.transaction_date := GET_PROPER_LENGTH(
1347: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1348: l_transaction_date_len, 'TITLE');
1349: header_report_rec2.contract_number := GET_PROPER_LENGTH(
1350: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1351: l_contract_number_len, 'TITLE');
1352: header_report_rec2.transaction_number := GET_PROPER_LENGTH(
1353: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1354: l_transaction_number_len, 'TITLE');

Line 1353: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1349: header_report_rec2.contract_number := GET_PROPER_LENGTH(
1350: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1351: l_contract_number_len, 'TITLE');
1352: header_report_rec2.transaction_number := GET_PROPER_LENGTH(
1353: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1354: l_transaction_number_len, 'TITLE');
1355: header_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1356: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1357: l_transaction_line_number_len,'TITLE');

Line 1356: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1352: header_report_rec2.transaction_number := GET_PROPER_LENGTH(
1353: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1354: l_transaction_number_len, 'TITLE');
1355: header_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1356: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1357: l_transaction_line_number_len,'TITLE');
1358: header_report_rec2.accounting_date := GET_PROPER_LENGTH(
1359: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1360: l_Accounting_date_len, 'TITLE');

Line 1359: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),

1355: header_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1356: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1357: l_transaction_line_number_len,'TITLE');
1358: header_report_rec2.accounting_date := GET_PROPER_LENGTH(
1359: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1360: l_Accounting_date_len, 'TITLE');
1361:
1362: header_report_rec2.dr_cr_flag := GET_PROPER_LENGTH(NULL,l_dr_cr_flag_len, 'TITLE');
1363:

Line 1365: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),

1361:
1362: header_report_rec2.dr_cr_flag := GET_PROPER_LENGTH(NULL,l_dr_cr_flag_len, 'TITLE');
1363:
1364: header_report_rec2.accounted_Amount := GET_PROPER_LENGTH(
1365: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),
1366: l_accounted_amount_len, 'TITLE');
1367: -- header_report_rec2.account := GET_PROPER_LENGTH(NULL, l_account_len, 'TITLE');
1368: header_report_rec2.currency := GET_PROPER_LENGTH(NULL, l_currency_len, 'TITLE');
1369:

Line 1374: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ERROR_LOG'), l_line_length , ' ' ));

1370:
1371: --- Error Section Begins ------------------------
1372:
1373: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1374: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ERROR_LOG'), l_line_length , ' ' ));
1375: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('---------', l_line_length , ' ' ));
1376: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1377:
1378:

Line 1379: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_lookup_meaning('OKL_ACCOUNTING_ERROR_CODE',

1375: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('---------', l_line_length , ' ' ));
1376: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1377:
1378:
1379: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_lookup_meaning('OKL_ACCOUNTING_ERROR_CODE',
1380: 'DEBIT_NOT_EQUAL_TO_CREDIT') , l_line_length, ' ' ));
1381: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('---------------------------', l_line_length , ' ' ));
1382: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1383:

Line 1418: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));

1414: OPEN dr_cr_unequal_dst_csr(l_request_id);
1415: FETCH dr_cr_unequal_dst_csr INTO dr_cr_unequal_dst_rec;
1416: IF (dr_cr_unequal_dst_csr%NOTFOUND) THEN
1417: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
1418: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));
1419: ELSE
1420: NULL;
1421: END IF;
1422:

Line 1451: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(

1447: GET_PROPER_LENGTH(dr_cr_unequal_dst_rec.accounting_date,l_accounting_date_len,'DATA');
1448: dr_cr_report_rec.dr_cr_flag :=
1449: GET_PROPER_LENGTH(dr_cr_unequal_dst_rec.dr_Cr_flag,l_dr_Cr_flag_len,'DATA');
1450: dr_cr_report_rec.accounted_amount :=
1451: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1452: dr_cr_unequal_dst_rec.accounted_amount, dr_cr_unequal_dst_rec.currency_code),
1453: l_accounted_amount_len,'DATA');
1454: -- Modified by kthiruva for Bug 3861943
1455: /*

Line 1488: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_lookup_meaning('OKL_ACCOUNTING_ERROR_CODE',

1484: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1485: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1486: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1487:
1488: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_lookup_meaning('OKL_ACCOUNTING_ERROR_CODE',
1489: 'INVALID_ACCOUNT'), l_line_length, ' ' ));
1490: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('---------------', l_line_length , ' ' ));
1491: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1492:

Line 1526: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));

1522: OPEN invalid_acc_dst_csr(l_request_id);
1523: FETCH invalid_acc_dst_csr INTO invalid_acc_dst_rec;
1524: IF (invalid_Acc_dst_csr%NOTFOUND) THEN
1525: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
1526: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));
1527: ELSE
1528: NULL;
1529: END IF;
1530: CLOSE invalid_acc_Dst_csr;

Line 1557: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(invalid_acc_dst_rec.accounted_amount,

1553: := GET_PROPER_LENGTH(invalid_acc_dst_rec.accounting_date, l_accounting_date_len, 'DATA');
1554: invalid_acc_report_rec.dr_Cr_Flag
1555: := GET_PROPER_LENGTH(invalid_acc_dst_rec.dr_Cr_flag, l_dr_Cr_flag_len, 'DATA');
1556: invalid_acc_report_rec.accounted_amount
1557: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(invalid_acc_dst_rec.accounted_amount,
1558: invalid_Acc_dst_rec.currency_code), l_accounted_amount_len, 'DATA');
1559: -- Modified by kthiruva for Bug 3861943
1560: /*
1561: invalid_acc_report_rec.account

Line 1593: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

1589: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1590: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1591: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1592:
1593: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1594: 'OKL_NON_PROCESSED_ENTRIES'), l_line_length , ' ' ));
1595: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('---------------------', l_line_length , ' ' ));
1596: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1597:

Line 1602: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),

1598: --Assigning the headers for non-processed entries
1599:
1600:
1601: header_err_report_rec.transaction_date := GET_PROPER_LENGTH(
1602: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1603: l_transaction_date_len, 'TITLE');
1604: header_err_report_rec.contract_number := GET_PROPER_LENGTH(
1605: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1606: l_contract_number_len, 'TITLE');

Line 1605: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),

1601: header_err_report_rec.transaction_date := GET_PROPER_LENGTH(
1602: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1603: l_transaction_date_len, 'TITLE');
1604: header_err_report_rec.contract_number := GET_PROPER_LENGTH(
1605: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1606: l_contract_number_len, 'TITLE');
1607: header_err_report_rec.transaction_number := GET_PROPER_LENGTH(
1608: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1609: l_transaction_number_len, 'TITLE');

Line 1608: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),

1604: header_err_report_rec.contract_number := GET_PROPER_LENGTH(
1605: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CONTRACT'),
1606: l_contract_number_len, 'TITLE');
1607: header_err_report_rec.transaction_number := GET_PROPER_LENGTH(
1608: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1609: l_transaction_number_len, 'TITLE');
1610: header_err_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1611: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1612: l_transaction_line_number_len,'TITLE');

Line 1611: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),

1607: header_err_report_rec.transaction_number := GET_PROPER_LENGTH(
1608: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TRANSACTION'),
1609: l_transaction_number_len, 'TITLE');
1610: header_err_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1611: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1612: l_transaction_line_number_len,'TITLE');
1613: header_err_report_rec.accounting_date := GET_PROPER_LENGTH(
1614: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1615: l_Accounting_date_len, 'TITLE');

Line 1614: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),

1610: header_err_report_rec.transaction_line_number := GET_PROPER_LENGTH(
1611: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACC_LINE'),
1612: l_transaction_line_number_len,'TITLE');
1613: header_err_report_rec.accounting_date := GET_PROPER_LENGTH(
1614: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1615: l_Accounting_date_len, 'TITLE');
1616: header_err_report_rec.accounting_period := GET_PROPER_LENGTH(
1617: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1618: l_accounting_period_len, 'TITLE');

Line 1617: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),

1613: header_err_report_rec.accounting_date := GET_PROPER_LENGTH(
1614: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1615: l_Accounting_date_len, 'TITLE');
1616: header_err_report_rec.accounting_period := GET_PROPER_LENGTH(
1617: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1618: l_accounting_period_len, 'TITLE');
1619: header_err_report_rec.amount := GET_PROPER_LENGTH(
1620: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),
1621: l_amount_len, 'TITLE');

Line 1620: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),

1616: header_err_report_rec.accounting_period := GET_PROPER_LENGTH(
1617: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_ACCOUNT_ING'),
1618: l_accounting_period_len, 'TITLE');
1619: header_err_report_rec.amount := GET_PROPER_LENGTH(
1620: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),
1621: l_amount_len, 'TITLE');
1622: header_err_report_rec.currency := GET_PROPER_LENGTH(
1623: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),
1624: l_currency_len, 'TITLE');

Line 1623: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),

1619: header_err_report_rec.amount := GET_PROPER_LENGTH(
1620: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_AMOUNT'),
1621: l_amount_len, 'TITLE');
1622: header_err_report_rec.currency := GET_PROPER_LENGTH(
1623: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CURRENCY'),
1624: l_currency_len, 'TITLE');
1625:
1626:
1627: header_err_report_rec2.transaction_date := GET_PROPER_LENGTH(

Line 1628: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),

1624: l_currency_len, 'TITLE');
1625:
1626:
1627: header_err_report_rec2.transaction_date := GET_PROPER_LENGTH(
1628: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1629: l_transaction_date_len, 'TITLE');
1630: header_err_report_rec2.contract_number := GET_PROPER_LENGTH(
1631: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1632: l_contract_number_len, 'TITLE');

Line 1631: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1627: header_err_report_rec2.transaction_date := GET_PROPER_LENGTH(
1628: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1629: l_transaction_date_len, 'TITLE');
1630: header_err_report_rec2.contract_number := GET_PROPER_LENGTH(
1631: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1632: l_contract_number_len, 'TITLE');
1633: header_err_report_rec2.transaction_number := GET_PROPER_LENGTH(
1634: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1635: l_transaction_number_len, 'TITLE');

Line 1634: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1630: header_err_report_rec2.contract_number := GET_PROPER_LENGTH(
1631: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1632: l_contract_number_len, 'TITLE');
1633: header_err_report_rec2.transaction_number := GET_PROPER_LENGTH(
1634: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1635: l_transaction_number_len, 'TITLE');
1636: header_err_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1637: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1638: l_transaction_line_number_len,'TITLE');

Line 1637: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),

1633: header_err_report_rec2.transaction_number := GET_PROPER_LENGTH(
1634: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1635: l_transaction_number_len, 'TITLE');
1636: header_err_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1637: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1638: l_transaction_line_number_len,'TITLE');
1639: header_err_report_rec2.accounting_date := GET_PROPER_LENGTH(
1640: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1641: l_Accounting_date_len, 'TITLE');

Line 1640: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),

1636: header_err_report_rec2.transaction_line_number := GET_PROPER_LENGTH(
1637: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NUMBER'),
1638: l_transaction_line_number_len,'TITLE');
1639: header_err_report_rec2.accounting_date := GET_PROPER_LENGTH(
1640: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1641: l_Accounting_date_len, 'TITLE');
1642: header_err_report_rec2.accounting_period := GET_PROPER_LENGTH(
1643: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PERIOD'),
1644: l_accounting_period_len, 'TITLE');

Line 1643: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PERIOD'),

1639: header_err_report_rec2.accounting_date := GET_PROPER_LENGTH(
1640: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DATE'),
1641: l_Accounting_date_len, 'TITLE');
1642: header_err_report_rec2.accounting_period := GET_PROPER_LENGTH(
1643: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PERIOD'),
1644: l_accounting_period_len, 'TITLE');
1645: header_err_report_rec2.amount := GET_PROPER_LENGTH(NULL,l_amount_len, 'TITLE');
1646: header_err_report_rec2.currency := GET_PROPER_LENGTH(NULL,l_currency_len, 'TITLE');
1647:

Line 1676: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));

1672:
1673: IF (l_trx_err_tbl.COUNT < 1) THEN
1674:
1675: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
1676: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));
1677: END IF;
1678:
1679: --- Process the non-processed Entries
1680:

Line 1689: Okl_Accounting_Util.get_period_info(l_trx_err_tbl(i).gl_date,l_temp_period_name,l_temp_start_date,l_temp_end_date);

1685: OPEN details_csr(l_trx_err_tbl(i).source_id);
1686: FETCH details_csr INTO details_rec;
1687: CLOSE details_csr;
1688:
1689: Okl_Accounting_Util.get_period_info(l_trx_err_tbl(i).gl_date,l_temp_period_name,l_temp_start_date,l_temp_end_date);
1690:
1691: non_proc_report_rec.transaction_date
1692: := GET_PROPER_LENGTH(details_rec.transaction_date, l_transaction_date_len, 'DATA');
1693:

Line 1714: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(details_rec.amount, details_rec.currency_code)

1710: non_proc_report_rec.accounting_period
1711: := GET_PROPER_LENGTH(l_temp_period_name, l_accounting_period_len, 'DATA');
1712:
1713: non_proc_report_rec.amount
1714: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(details_rec.amount, details_rec.currency_code)
1715: , l_amount_len, 'DATA');
1716:
1717: non_proc_report_rec.currency
1718: := GET_PROPER_LENGTH(details_rec.currency_code, l_currency_len, 'DATA');

Line 1744: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), l_line_length, ' ' ));

1740: --processed records only if rpt_format is ALL.
1741: IF (p_rpt_format = 'ALL') THEN
1742:
1743: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length, ' ' ));
1744: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_PROCESSED_ENTRIES'), l_line_length, ' ' ));
1745: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-----------------', l_line_length, ' ' ));
1746: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1747:
1748:

Line 1779: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));

1775: header_report_rec2.currency);
1776:
1777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));
1778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
1779: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_NO_RECORDS'));
1780: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));
1781: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1782: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));
1783: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(' ', l_line_length , ' ' ));

Line 1795: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

1791: FOR ae_category_rec IN ae_category_csr(l_request_id)
1792:
1793: LOOP -- For each journal category
1794:
1795: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1796: 'OKL_JOURNAL_CATEGORY') || ' : ' || ae_category_rec.ae_category || ' ' ||
1797: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1798: 'OKL_TRANSACTION_TYPE') ||' : ' || ae_category_rec.try_name , l_line_length ,' '));
1799:

Line 1797: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',

1793: LOOP -- For each journal category
1794:
1795: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1796: 'OKL_JOURNAL_CATEGORY') || ' : ' || ae_category_rec.ae_category || ' ' ||
1797: Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS',
1798: 'OKL_TRANSACTION_TYPE') ||' : ' || ae_category_rec.try_name , l_line_length ,' '));
1799:
1800: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,RPAD(' ',l_line_length,' '));
1801:

Line 1856: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(

1852: := GET_PROPER_LENGTH(proc_dst_rec.accounting_date,l_accounting_date_len,'DATA');
1853: proc_report_rec.dr_cr_flag
1854: := GET_PROPER_LENGTH(proc_dst_rec.dr_cr_flag,l_dr_cr_flag_len,'DATA');
1855: proc_report_rec.accounted_amount
1856: := GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1857: proc_dst_rec.accounted_amount,proc_dst_rec.currency_code),l_accounted_amount_len,'DATA');
1858: -- Modified by kthiruva for Bug 3861943
1859: /* proc_report_rec.account
1860: := GET_PROPER_LENGTH(proc_dst_rec.account,l_account_len,'DATA');*/

Line 1886: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')

1882:
1883: END LOOP; -- Of records for a particular journal category
1884:
1885: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));
1886: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1887: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DEBIT'),l_total_offset,' ') ||
1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);

Line 1887: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DEBIT'),l_total_offset,' ') ||

1883: END LOOP; -- Of records for a particular journal category
1884:
1885: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));
1886: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1887: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DEBIT'),l_total_offset,' ') ||
1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);
1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')

Line 1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(

1884:
1885: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));
1886: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1887: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DEBIT'),l_total_offset,' ') ||
1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);
1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1892: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CREDIT_AMT'),l_total_offset,' ') ||

Line 1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')

1887: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_DEBIT'),l_total_offset,' ') ||
1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);
1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1892: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CREDIT_AMT'),l_total_offset,' ') ||
1893: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1894: ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA')||
1895: ae_category_rec.currency_code);

Line 1892: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CREDIT_AMT'),l_total_offset,' ') ||

1888: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);
1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1892: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CREDIT_AMT'),l_total_offset,' ') ||
1893: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1894: ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA')||
1895: ae_category_rec.currency_code);
1896:

Line 1893: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(

1889: ae_category_rec.total_dr, ae_category_rec.currency_code), l_accounted_amount_len,'DATA') ||
1890: ae_category_rec.currency_code);
1891: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD(Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_TOTAL')
1892: || ' ' || Okl_Accounting_Util.get_message_token('OKL_LP_ACCOUNTING_PROCESS','OKL_CREDIT_AMT'),l_total_offset,' ') ||
1893: GET_PROPER_LENGTH(Okl_Accounting_Util.format_amount(
1894: ae_category_rec.total_cr,ae_category_rec.currency_code), l_accounted_amount_len,'DATA')||
1895: ae_category_rec.currency_code);
1896:
1897: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, RPAD('-', l_line_length , '-' ));