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 8896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

8892:
8893: BEGIN
8894: retcode := 0; --0 for success, 1 for warning, 2 for error
8895:
8896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
8897: OPEN c_old_k;
8898: LOOP
8899:
8900: FETCH c_old_k BULK COLLECT INTO l_k_rec_tbl LIMIT 1000;

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

8897: OPEN c_old_k;
8898: LOOP
8899:
8900: FETCH c_old_k BULK COLLECT INTO l_k_rec_tbl LIMIT 1000;
8901: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bulk fetched '||l_k_rec_tbl.COUNT ||' rows');
8902:
8903: EXIT WHEN (l_k_rec_tbl.COUNT = 0);
8904: l_rollcount := l_rollcount + l_k_rec_tbl.COUNT;
8905:

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

8902:
8903: EXIT WHEN (l_k_rec_tbl.COUNT = 0);
8904: l_rollcount := l_rollcount + l_k_rec_tbl.COUNT;
8905:
8906: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launching Workflow ');
8907:
8908: FOR i IN l_k_rec_tbl.FIRST..l_k_rec_tbl.LAST LOOP
8909: l_wf_attributes_tbl(i).CONTRACT_ID := l_k_rec_tbl(i).chr_id;
8910: l_wf_attributes_tbl(i).CONTRACT_NUMBER := l_k_rec_tbl(i).contract_number;

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

8935: --try the next batch
8936: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
8937: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8938: FOR j IN 1..l_msg_count LOOP
8939: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8940: END LOOP;
8941: RAISE FND_API.g_exc_unexpected_error;
8942: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
8943: --just log the error and continue

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

8943: --just log the error and continue
8944: l_errcount := l_errcount + l_k_rec_tbl.COUNT;
8945: retcode := 1;
8946: FOR j IN 1..l_msg_count LOOP
8947: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(j, 'F'));
8948: END LOOP;
8949: ELSE
8950: l_wfcount := l_wfcount + l_k_rec_tbl.COUNT;
8951: END IF;

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

8952:
8953: --delete for the the next loop
8954: l_wf_attributes_tbl.DELETE;
8955: COMMIT;
8956: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8957: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8958: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8959:
8960:

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

8953: --delete for the the next loop
8954: l_wf_attributes_tbl.DELETE;
8955: COMMIT;
8956: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8957: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8958: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8959:
8960:
8961: END LOOP; -- main cursor loop

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

8954: l_wf_attributes_tbl.DELETE;
8955: COMMIT;
8956: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows processed so far: ' || l_rollcount);
8957: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows errored so far: ' || l_errcount);
8958: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rows successful so far: '|| l_wfcount);
8959:
8960:
8961: END LOOP; -- main cursor loop
8962: CLOSE c_old_k;

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

8960:
8961: END LOOP; -- main cursor loop
8962: CLOSE c_old_k;
8963:
8964: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8967:
8968: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);

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

8961: END LOOP; -- main cursor loop
8962: CLOSE c_old_k;
8963:
8964: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8967:
8968: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8969:

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

8962: CLOSE c_old_k;
8963:
8964: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8967:
8968: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8969:
8970: EXCEPTION

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

8964: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows processed: '|| l_rollcount);
8965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows errored: '|| l_errcount);
8966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total Rows succesful: '|| l_wfcount);
8967:
8968: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8969:
8970: EXCEPTION
8971: WHEN OTHERS THEN
8972: retcode := 2;

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

8973: IF (c_old_k%isopen) THEN
8974: CLOSE c_old_k;
8975: END IF;
8976: errbuf := sqlcode||sqlerrm;
8977: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Error, time: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')||' ,retcode='||retcode);
8978:
8979: END launch_wf_conc_prog;
8980:
8981: