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

Line 66: Fnd_File.PUT_LINE(Fnd_File.LOG, p_message);

62: -- -------------------------------------------------
63: PROCEDURE print_to_log(p_message IN VARCHAR2) IS
64: BEGIN
65:
66: Fnd_File.PUT_LINE(Fnd_File.LOG, p_message);
67:
68: IF(Fnd_Log.level_statement >= Fnd_Log.g_current_runtime_level) THEN
69: Fnd_Log.string(Fnd_Log.level_statement, 'okl_internal_to_external', p_message);
70: END IF;

Line 336: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'esdtl_tbl insert');

332: VALUES esdtl_tbl(indx);
333: END IF;
334:
335: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
336: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'esdtl_tbl insert');
337: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
338: PRINT_TO_LOG('BULK For inserting external details tl, error ' || i || ' occurred during '||
339: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
340: PRINT_TO_LOG('BULK Oracle error is ' ||

Line 360: Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK Status updated!');

356: last_update_login = Fnd_Global.LOGIN_ID
357: WHERE ID = tai_id_tbl(indx);
358:
359: COMMIT;
360: Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK Status updated!');
361: END IF;
362:
363:
364: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK commit commented 1Y');

Line 364: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK commit commented 1Y');

360: Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK Status updated!');
361: END IF;
362:
363:
364: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK commit commented 1Y');
365: l_commit_cnt := 0;
366: PRINT_TO_LOG('BULK error_tbl.count = '||error_tbl.COUNT);
367: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'before the error_tbl print');
368:

Line 367: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'before the error_tbl print');

363:
364: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'BULK commit commented 1Y');
365: l_commit_cnt := 0;
366: PRINT_TO_LOG('BULK error_tbl.count = '||error_tbl.COUNT);
367: --Fnd_File.PUT_LINE (Fnd_File.LOG, 'before the error_tbl print');
368:
369: IF (error_tbl.COUNT > 0) THEN
370: PRINT_TO_LOG('BULK Processing error ...');
371: FOR i IN error_tbl.first..error_tbl.last LOOP

Line 461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);

457: -- Exception handling
458: ------------------------------------------------------------
459:
460: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
461: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
462:
463: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
464: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
465: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

Line 477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

473: x_msg_data => x_msg_data,
474: p_api_type => '_PVT');
475:
476: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
478:
479: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
480: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
481: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);

489: x_msg_data => x_msg_data,
490: p_api_type => '_PVT');
491:
492: WHEN OTHERS THEN
493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
494:
495: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
496: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'bulk_process',
497: 'EXCEPTION :'||'OTHERS');

Line 1038: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );

1034: l_program_update_date
1035: FROM dual;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
1039: END;
1040:
1041:
1042: -- Build table records for bulk processing

Line 1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IXX_ID must be populated WHEN the contract header IS NULL!');

1296: -- Else for contract_id
1297:
1298: IF p_ie_tbl1(k).ixx_id IS NULL THEN
1299: --d*bms_output.put_line ('IXX_ID must be populated WHEN the contract header IS NULL!');
1300: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IXX_ID must be populated WHEN the contract header IS NULL!');
1301: ELSE
1302: xsi_tbl(l_xsi_cnt).customer_id := p_ie_tbl1(k).ixx_id;
1303: END IF;
1304:

Line 1307: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRM_ID must be populated WHEN the contract header IS NULL');

1303: END IF;
1304:
1305: IF p_ie_tbl1(k).irm_id IS NULL THEN
1306: -- d*bms_output.put_line ('IRM_ID must be populated WHEN the contract header IS NULL!');
1307: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRM_ID must be populated WHEN the contract header IS NULL');
1308: ELSE
1309: xsi_tbl(l_xsi_cnt).receipt_method_id := p_ie_tbl1(k).irm_id;
1310: END IF;
1311:

Line 1314: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRT_ID must be populated WHEN the contract header IS NULL');

1310: END IF;
1311:
1312: IF p_ie_tbl1(k).irt_id IS NULL THEN
1313: -- d*bms_output.put_line ('IRT_ID must be populated WHEN the contract header IS NULL!');
1314: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRT_ID must be populated WHEN the contract header IS NULL');
1315: ELSE
1316: xsi_tbl(l_xsi_cnt).term_id := p_ie_tbl1(k).irt_id;
1317: END IF;
1318:

Line 1321: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IBT_ID must be populated WHEN the contract header IS NULL');

1317: END IF;
1318:
1319: IF p_ie_tbl1(k).ibt_id IS NULL THEN
1320: --d*bms_output.put_line ('IBT_ID must be populated WHEN the contract header IS NULL!');
1321: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IBT_ID must be populated WHEN the contract header IS NULL');
1322: ELSE
1323: xsi_tbl(l_xsi_cnt).customer_address_id := p_ie_tbl1(k).ibt_id;
1324: END IF;
1325:

Line 1328: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ORG_ID must be populated WHEN the contract header IS NULL');

1324: END IF;
1325:
1326: IF p_ie_tbl1(k).org_id IS NULL THEN
1327: --d*bms_output.put_line ('ORG_ID must be populated WHEN the contract header IS NULL!');
1328: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ORG_ID must be populated WHEN the contract header IS NULL');
1329: ELSE
1330: --l_xsiv_rec.ORG_ID := ln_dtls_rec.ORG_ID; --TAI
1331: xsi_tbl(l_xsi_cnt).org_id := NULL;
1332: END IF;

Line 1336: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');

1332: END IF;
1333: -- for LE Uptake project 08-11-2006
1334: IF ( p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
1335: --d*bms_output.put_line ('LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL!');
1336: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');
1337: ELSE
1338: xsi_tbl(l_xsi_cnt).legal_entity_id := p_ie_tbl1(k).legal_entity_id;
1339: END IF;
1340: -- for LE Uptake project 08-11-2006

Line 1922: --fnd_file.PUT_LINE('OUT',' NUMBER OF 3 LEVEL RECORD processed = '||TO_CHAR(i));

1918:
1919: print_to_log(' NUMBER OF 3 LEVEL RECORD processed = ' || i);
1920:
1921: --d*bms_output.put_line(' NUMBER OF 3 LEVEL RECORD processed = '||i);
1922: --fnd_file.PUT_LINE('OUT',' NUMBER OF 3 LEVEL RECORD processed = '||TO_CHAR(i));
1923:
1924: l_commit_cnt := 0;
1925:
1926: FOR i IN 1 .. tab_cntr

Line 2396: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IXX_ID must be populated WHEN the contract header IS NULL');

2392: -- Else for contract_id
2393:
2394: IF p_ie_tbl2(h).ixx_id IS NULL THEN
2395: --d*bms_output.put_line ('IXX_ID must be populated WHEN the contract header IS NULL!');
2396: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IXX_ID must be populated WHEN the contract header IS NULL');
2397: ELSE
2398: xsi_tbl(l_xsi_cnt).customer_id := p_ie_tbl2(h).ixx_id;
2399: END IF;
2400:

Line 2403: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRM_ID must be populated WHEN the contract header IS NULL');

2399: END IF;
2400:
2401: IF p_ie_tbl2(h).irm_id IS NULL THEN
2402: --d*bms_output.put_line ('IRM_ID must be populated WHEN the contract header IS NULL!');
2403: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRM_ID must be populated WHEN the contract header IS NULL');
2404: ELSE
2405: xsi_tbl(l_xsi_cnt).receipt_method_id := p_ie_tbl2(h).irm_id;
2406: END IF;
2407:

Line 2410: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRT_ID must be populated WHEN the contract header IS NULL');

2406: END IF;
2407:
2408: IF p_ie_tbl2(h).irt_id IS NULL THEN
2409: --d*bms_output.put_line ('IRT_ID must be populated WHEN the contract header IS NULL!');
2410: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IRT_ID must be populated WHEN the contract header IS NULL');
2411: ELSE
2412: xsi_tbl(l_xsi_cnt).term_id := p_ie_tbl2(h).irt_id;
2413: END IF;
2414:

Line 2417: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IBT_ID must be populated WHEN the contract header IS NULL');

2413: END IF;
2414:
2415: IF p_ie_tbl2(h).ibt_id IS NULL THEN
2416: --d*bms_output.put_line ('IBT_ID must be populated WHEN the contract header IS NULL!');
2417: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'IBT_ID must be populated WHEN the contract header IS NULL');
2418: ELSE
2419: xsi_tbl(l_xsi_cnt).customer_address_id := p_ie_tbl2(h).ibt_id;
2420: END IF;
2421:

Line 2424: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ORG_ID must be populated WHEN the contract header IS NULL');

2420: END IF;
2421:
2422: IF p_ie_tbl2(h).org_id IS NULL THEN
2423: --d*bms_output.put_line ('ORG_ID must be populated WHEN the contract header IS NULL!');
2424: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ORG_ID must be populated WHEN the contract header IS NULL');
2425: ELSE
2426: --l_xsiv_rec.ORG_ID := ln_no_dtls_rec.ORG_ID; --TAI
2427: xsi_tbl(l_xsi_cnt).org_id := NULL;
2428: END IF;

Line 2432: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');

2428: END IF;
2429: -- for LE Uptake project 08-11-2006
2430: IF (p_ie_tbl2(h).legal_entity_id IS NULL OR (p_ie_tbl2(h).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
2431: --d*bms_output.put_line ('LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL!');
2432: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');
2433: ELSE
2434: xsi_tbl(l_xsi_cnt).legal_entity_id := p_ie_tbl2(h).legal_entity_id;
2435: END IF;
2436: -- for LE Uptake project 08-11-2006

Line 3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));

3168: INTO l_op_unit_name;
3169: CLOSE op_unit_csr;
3170:
3171: -- Start New Out File stmathew 15-OCT-2004
3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));
3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

Line 3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3169: CLOSE op_unit_csr;
3170:
3171: -- Start New Out File stmathew 15-OCT-2004
3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));
3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

Line 3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));

3170:
3171: -- Start New Out File stmathew 15-OCT-2004
3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));
3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);

Line 3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));

3171: -- Start New Out File stmathew 15-OCT-2004
3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));
3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));

Line 3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3172: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 54, ' ') || 'Oracle Lease and Finance Management' || lpad(' ', 55, ' '));
3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);

Line 3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3173: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));

Line 3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);

3174: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || 'Prepare Receivables Bills' || lpad(' ', 54, ' '));
3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

Line 3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));

3175: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 53, ' ') || '-------------------------' || lpad(' ', 54, ' '));
3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:

Line 3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);

3176: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));

Line 3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));

3177: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

Line 3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3178: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Operating Unit: ' || l_op_unit_name);
3179: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Request Id: ' || l_request_id || lpad(' ', 74, ' ') || 'Run Date: ' || to_char(sysdate));
3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);

Line 3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));

3180: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Currency: ' || okl_accounting_util.get_func_curr_code);
3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));

Line 3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3181: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad('-', 132, '-'));
3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));
3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

Line 3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);

3182: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));
3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3190:

Line 3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);

3183:
3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));
3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3190:
3191: IF x_msg_count > 0 THEN

Line 3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));

3184: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Processing Details:' || lpad(' ', 113, ' '));
3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));
3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3190:
3191: IF x_msg_count > 0 THEN
3192: FOR i IN 1 .. x_msg_count

Line 3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3185: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3186: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Successful Records: ' || l_succ_cnt);
3187: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Number of Errored Records: ' || l_err_cnt);
3188: fnd_file.PUT_LINE(fnd_file.OUTPUT, ' Total: ' ||(l_succ_cnt + l_err_cnt));
3189: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3190:
3191: IF x_msg_count > 0 THEN
3192: FOR i IN 1 .. x_msg_count
3193: LOOP

Line 3196: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Details of Errored Records:' || lpad(' ', 97, ' '));

3192: FOR i IN 1 .. x_msg_count
3193: LOOP
3194:
3195: IF i = 1 THEN
3196: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Details of Errored Records:' || lpad(' ', 97, ' '));
3197: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3198: END IF;
3199:
3200: fnd_msg_pub.GET(p_msg_index => i, p_encoded => 'F', p_data => lx_msg_data, p_msg_index_out => l_msg_index_out);

Line 3197: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));

3193: LOOP
3194:
3195: IF i = 1 THEN
3196: fnd_file.PUT_LINE(fnd_file.OUTPUT, 'Details of Errored Records:' || lpad(' ', 97, ' '));
3197: fnd_file.PUT_LINE(fnd_file.OUTPUT, rpad(' ', 132, ' '));
3198: END IF;
3199:
3200: fnd_msg_pub.GET(p_msg_index => i, p_encoded => 'F', p_data => lx_msg_data, p_msg_index_out => l_msg_index_out);
3201:

Line 3202: fnd_file.PUT_LINE(fnd_file.OUTPUT, to_char(i) || ': ' || lx_msg_data);

3198: END IF;
3199:
3200: fnd_msg_pub.GET(p_msg_index => i, p_encoded => 'F', p_data => lx_msg_data, p_msg_index_out => l_msg_index_out);
3201:
3202: fnd_file.PUT_LINE(fnd_file.OUTPUT, to_char(i) || ': ' || lx_msg_data);
3203:
3204: IF(fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3205: fnd_log.string(fnd_log.level_exception, 'okl_internal_to_external', to_char(i) || ': ' || lx_msg_data);
3206: END IF;

Line 3569: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).tai_id: '||ie_tbl2(i).tai_id);

3565: PRINT_TO_LOG('IE int_lns_csr4 ie_tbl2 count is: '||ie_tbl2.COUNT);
3566:
3567: /*
3568: FOR i IN ie_tbl2.first..ie_tbl2.last LOOP
3569: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).tai_id: '||ie_tbl2(i).tai_id);
3570: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).kle_id: '||ie_tbl2(i).kle_id);
3571: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).contract_id: '||ie_tbl2(i).contract_id);
3572: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).amount: '||ie_tbl2(i).amount);
3573: END LOOP;

Line 3570: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).kle_id: '||ie_tbl2(i).kle_id);

3566:
3567: /*
3568: FOR i IN ie_tbl2.first..ie_tbl2.last LOOP
3569: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).tai_id: '||ie_tbl2(i).tai_id);
3570: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).kle_id: '||ie_tbl2(i).kle_id);
3571: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).contract_id: '||ie_tbl2(i).contract_id);
3572: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).amount: '||ie_tbl2(i).amount);
3573: END LOOP;
3574: */

Line 3571: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).contract_id: '||ie_tbl2(i).contract_id);

3567: /*
3568: FOR i IN ie_tbl2.first..ie_tbl2.last LOOP
3569: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).tai_id: '||ie_tbl2(i).tai_id);
3570: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).kle_id: '||ie_tbl2(i).kle_id);
3571: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).contract_id: '||ie_tbl2(i).contract_id);
3572: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).amount: '||ie_tbl2(i).amount);
3573: END LOOP;
3574: */
3575: IF ie_tbl2.COUNT > 0 THEN

Line 3572: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).amount: '||ie_tbl2(i).amount);

3568: FOR i IN ie_tbl2.first..ie_tbl2.last LOOP
3569: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).tai_id: '||ie_tbl2(i).tai_id);
3570: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).kle_id: '||ie_tbl2(i).kle_id);
3571: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).contract_id: '||ie_tbl2(i).contract_id);
3572: Fnd_File.PUT_LINE (Fnd_File.LOG, 'IE4 ie_tbl2(i).amount: '||ie_tbl2(i).amount);
3573: END LOOP;
3574: */
3575: IF ie_tbl2.COUNT > 0 THEN
3576: process_ie_tbl

Line 3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));

3694: FETCH op_unit_csr INTO l_op_unit_name;
3695: CLOSE op_unit_csr;
3696:
3697: -- Start New Out File stmathew 15-OCT-2004
3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3695: CLOSE op_unit_csr;
3696:
3697: -- Start New Out File stmathew 15-OCT-2004
3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));

3696:
3697: -- Start New Out File stmathew 15-OCT-2004
3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

Line 3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));

3697: -- Start New Out File stmathew 15-OCT-2004
3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

Line 3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3698: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

Line 3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

Line 3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

3700: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Prepare Receivables Bills'||LPAD(' ', 54, ' '));
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'-------------------------'||LPAD(' ', 54, ' '));
3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:

Line 3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

3702: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

Line 3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

3703: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3704: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3705: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);

Line 3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

3706: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));

Line 3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3707: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));
3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);

3708: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));
3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3716:

Line 3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);

3709:
3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));
3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3716:
3717: total_error_tbl.DELETE;

Line 3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));

3710: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));
3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3716:
3717: total_error_tbl.DELETE;
3718:

Line 3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3711: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3712: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Records: '||l_succ_cnt);
3713: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Records: '||total_error_tbl.COUNT);
3714: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+total_error_tbl.COUNT));
3715: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3716:
3717: total_error_tbl.DELETE;
3718:
3719: -- End New Out File stmathew 15-OCT-2004

Line 3723: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Records:'||LPAD(' ', 97, ' '));

3719: -- End New Out File stmathew 15-OCT-2004
3720: IF x_msg_count > 0 THEN
3721: FOR i IN 1..x_msg_count LOOP
3722: IF i = 1 THEN
3723: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Records:'||LPAD(' ', 97, ' '));
3724: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3725: END IF;
3726: Fnd_Msg_Pub.get (p_msg_index => i,
3727: p_encoded => 'F',

Line 3724: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3720: IF x_msg_count > 0 THEN
3721: FOR i IN 1..x_msg_count LOOP
3722: IF i = 1 THEN
3723: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Records:'||LPAD(' ', 97, ' '));
3724: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3725: END IF;
3726: Fnd_Msg_Pub.get (p_msg_index => i,
3727: p_encoded => 'F',
3728: p_data => lx_msg_data,

Line 3731: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);

3727: p_encoded => 'F',
3728: p_data => lx_msg_data,
3729: p_msg_index_out => l_msg_index_out);
3730:
3731: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3732:
3733: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3734: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_internal_to_external',
3735: TO_CHAR(i) || ': ' || lx_msg_data);

Line 3772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);

3768: ------------------------------------------------------------
3769: -- Exception handling
3770: ------------------------------------------------------------
3771: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3773:
3774: IF p_assigned_process IS NOT NULL THEN
3775: DELETE OKL_PARALLEL_PROCESSES
3776: WHERE assigned_process = p_assigned_process;

Line 3794: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

3790: x_msg_data => x_msg_data,
3791: p_api_type => '_PVT');
3792:
3793: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3794: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3795:
3796: IF p_assigned_process IS NOT NULL THEN
3797: DELETE OKL_PARALLEL_PROCESSES
3798: WHERE assigned_process = p_assigned_process;

Line 3815: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);

3811: x_msg_data => x_msg_data,
3812: p_api_type => '_PVT');
3813:
3814: WHEN OTHERS THEN
3815: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3816:
3817: IF p_assigned_process IS NOT NULL THEN
3818: DELETE OKL_PARALLEL_PROCESSES
3819: WHERE assigned_process = p_assigned_process;