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.WSM_LBJ_INTERFACE_PVT dependencies on FND_CONCURRENT

Line 6814: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

6810: if l_error_count <> 0 then
6811: retcode := 1;
6812: errbuf := 'The manager marked at least one row as errored';
6813: fnd_file.put_line(fnd_file.log,errbuf);
6814: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
6815: COMMIT;
6816: end if;
6817:
6818: EXCEPTION

Line 6825: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);

6821: rollback;
6822: retcode := 1;
6823: errbuf := 'Error: process_interface_rows: (#'||l_stmt_num||') fail to launch worker';
6824: fnd_file.put_line(fnd_file.log,errbuf);
6825: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
6826: COMMIT;
6827:
6828: when others then
6829: rollback;

Line 6834: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);

6830: retcode := 1;
6831: errbuf := 'Error: process_interface_rows: (#'||l_stmt_num||') '
6832: || SUBSTR(SQLERRM, 1,240);
6833: fnd_file.put_line(fnd_file.log,errbuf);
6834: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
6835: COMMIT;
6836:
6837: END process_lbji_rows;
6838:

Line 12007: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12003: if l_warning_count <> 0 then
12004: retcode := 1;
12005: errbuf := 'The interface process produced at least one warning message';
12006: fnd_file.put_line(fnd_file.log,errbuf);
12007: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12008: end if;
12009:
12010: if l_error_count <> 0 then
12011: retcode := 1;

Line 12014: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12010: if l_error_count <> 0 then
12011: retcode := 1;
12012: errbuf := 'The interface process marked at least one row as errored';
12013: fnd_file.put_line(fnd_file.log,errbuf);
12014: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12015: end if;
12016:
12017: l_stmt_num := 1060;
12018: -- bulk update wsm_lot_job_interface

Line 12083: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12079: errbuf:= 'Inventory worker returned failure '||
12080: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '
12081: || SUBSTRB(SQLERRM,1,1000);
12082: fnd_file.put_line(fnd_file.log,errbuf);
12083: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12084: update wsm_lot_job_interface
12085: set process_status = 4,
12086: error_code = -2,
12087: error_msg = l_error_msg

Line 12094: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST (

12090: else -- req_id <> 0
12091: l_stmt_num := 1090;
12092: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
12093: ||to_char(l_inv_worker_req_id));
12094: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST (
12095: request_id => l_inv_worker_req_id,
12096: interval => 10, -- 10 seconds interval
12097: max_wait => 36000, -- 10 Hours maximum wait.
12098: phase => req_phase,

Line 12115: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12111: errbuf:= 'Inventory worker returned failure '||
12112: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '||
12113: SUBSTRB(SQLERRM,1,1000);
12114: fnd_file.put_line(fnd_file.log,errbuf);
12115: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12116: end if;
12117:
12118: check_errored_mmtt_records(l_mmtt_txn_hdr_id, l_error_code, l_error_msg);
12119:

Line 12126: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12122: errbuf:= 'Errored Records in mmtt ' ||
12123: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '||
12124: SUBSTRB(SQLERRM,1,1000);
12125: fnd_file.put_line(fnd_file.log,errbuf);
12126: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12127: end if;
12128:
12129: end if; -- req_id
12130: */

Line 12265: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12261: when others then
12262: retcode := 1;
12263: errbuf := 'Deletion of successful rows from interface table(s) failed';
12264: fnd_file.put_line(fnd_file.log,errbuf);
12265: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12266: End;
12267:
12268: COMMIT; -- commit a batch
12269:

Line 12377: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

12373: and organization_id = l_v_d_org_id_err(i);
12374:
12375: errbuf := 'The interface process marked at least one row as errored';
12376: fnd_file.put_line(fnd_file.log,errbuf);
12377: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12378:
12379: end if;
12380: l_stmt_num := 1230;
12381: if(l_d_idx_ok > 1) then

Line 12439: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',errbuf);

12435:
12436: if l_error_count = 0 then
12437: retcode := 0;
12438: errbuf := '';
12439: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',errbuf);
12440: end if;
12441:
12442: COMMIT;
12443:

Line 12452: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);

12448: retcode := 2;
12449: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '
12450: || SUBSTR(SQLERRM, 1,240);
12451: fnd_file.put_line(fnd_file.log,errbuf);
12452: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12453: wsmputil.WRITE_TO_WIE (
12454: 0,
12455: substr(errbuf,1,2000),
12456: fnd_global.conc_request_id,

Line 12470: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);

12466: retcode := 2;
12467: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '
12468: || SUBSTR(SQLERRM, 1,240);
12469: fnd_file.put_line(fnd_file.log,errbuf);
12470: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12471:
12472: wsmputil.WRITE_TO_WIE (
12473: 0,
12474: substr(errbuf,1,2000),