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.OKS_WF_K_PROCESS_PVT dependencies on FND_FILE

Line 8592: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

8588:
8589: BEGIN
8590: retcode := 0; --0 for success, 1 for warning, 2 for error
8591:
8592: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
8593: OPEN c_old_k;
8594: LOOP
8595:
8596: FETCH c_old_k BULK COLLECT INTO l_k_rec_tbl LIMIT 1000;

Line 8597: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bulk fetched '||l_k_rec_tbl.COUNT ||' rows');

8593: OPEN c_old_k;
8594: LOOP
8595:
8596: FETCH c_old_k BULK COLLECT INTO l_k_rec_tbl LIMIT 1000;
8597: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bulk fetched '||l_k_rec_tbl.COUNT ||' rows');
8598:
8599: EXIT WHEN (l_k_rec_tbl.COUNT = 0);
8600: l_rollcount := l_rollcount + l_k_rec_tbl.COUNT;
8601:

Line 8602: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launching Workflow ');

8598:
8599: EXIT WHEN (l_k_rec_tbl.COUNT = 0);
8600: l_rollcount := l_rollcount + l_k_rec_tbl.COUNT;
8601:
8602: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launching Workflow ');
8603:
8604: FOR i IN l_k_rec_tbl.FIRST..l_k_rec_tbl.LAST LOOP
8605: l_wf_attributes_tbl(i).CONTRACT_ID := l_k_rec_tbl(i).chr_id;
8606: l_wf_attributes_tbl(i).CONTRACT_NUMBER := l_k_rec_tbl(i).contract_number;

Line 8635: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));

8631: --try the next batch
8632: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
8633: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8634: FOR j IN 1..l_msg_count LOOP
8635: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8636: END LOOP;
8637: RAISE FND_API.g_exc_unexpected_error;
8638: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
8639: --just log the error and continue

Line 8643: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));

8639: --just log the error and continue
8640: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8641: retcode := 1;
8642: FOR j IN 1..l_msg_count LOOP
8643: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8644: END LOOP;
8645: ELSE
8646: l_wfcount := l_wfcount + l_k_rec_tbl.COUNT;
8647: END IF;

Line 8652: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);

8648:
8649: --delete for the the next loop
8650: l_wf_attributes_tbl.DELETE;
8651: COMMIT;
8652: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8654: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8655:
8656:

Line 8653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);

8649: --delete for the the next loop
8650: l_wf_attributes_tbl.DELETE;
8651: COMMIT;
8652: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8654: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8655:
8656:
8657: END LOOP; -- main cursor loop

Line 8654: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);

8650: l_wf_attributes_tbl.DELETE;
8651: COMMIT;
8652: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8654: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8655:
8656:
8657: END LOOP; -- main cursor loop
8658: CLOSE c_old_k;

Line 8660: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);

8656:
8657: END LOOP; -- main cursor loop
8658: CLOSE c_old_k;
8659:
8660: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8661: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8663:
8664: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);

Line 8661: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);

8657: END LOOP; -- main cursor loop
8658: CLOSE c_old_k;
8659:
8660: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8661: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8663:
8664: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8665:

Line 8662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);

8658: CLOSE c_old_k;
8659:
8660: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8661: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8663:
8664: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8665:
8666: EXCEPTION

Line 8664: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);

8660: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8661: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8663:
8664: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8665:
8666: EXCEPTION
8667: WHEN OTHERS THEN
8668: retcode := 2;

Line 8673: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Error, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);

8669: IF (c_old_k%isopen) THEN
8670: CLOSE c_old_k;
8671: END IF;
8672: errbuf := sqlcode||sqlerrm;
8673: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Error, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8674:
8675: END launch_wf_conc_prog;
8676:
8677: