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 6798: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);

6794: if l_error_count <> 0 then
6795: retcode := 1;
6796: errbuf := 'The manager marked at least one row as errored';
6797: fnd_file.put_line(fnd_file.log,errbuf);
6798: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
6799: COMMIT;
6800: end if;
6801:
6802: EXCEPTION

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

6805: rollback;
6806: retcode := 1;
6807: errbuf := 'Error: process_interface_rows: (#'||l_stmt_num||') fail to launch worker';
6808: fnd_file.put_line(fnd_file.log,errbuf);
6809: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
6810: COMMIT;
6811:
6812: when others then
6813: rollback;

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

6814: retcode := 1;
6815: errbuf := 'Error: process_interface_rows: (#'||l_stmt_num||') '
6816: || SUBSTR(SQLERRM, 1,240);
6817: fnd_file.put_line(fnd_file.log,errbuf);
6818: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
6819: COMMIT;
6820:
6821: END process_lbji_rows;
6822:

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

11899: if l_warning_count <> 0 then
11900: retcode := 1;
11901: errbuf := 'The interface process produced at least one warning message';
11902: fnd_file.put_line(fnd_file.log,errbuf);
11903: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
11904: end if;
11905:
11906: if l_error_count <> 0 then
11907: retcode := 1;

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

11906: if l_error_count <> 0 then
11907: retcode := 1;
11908: errbuf := 'The interface process marked at least one row as errored';
11909: fnd_file.put_line(fnd_file.log,errbuf);
11910: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
11911: end if;
11912:
11913: l_stmt_num := 1060;
11914: -- bulk update wsm_lot_job_interface

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

11975: errbuf:= 'Inventory worker returned failure '||
11976: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '
11977: || SUBSTRB(SQLERRM,1,1000);
11978: fnd_file.put_line(fnd_file.log,errbuf);
11979: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
11980: update wsm_lot_job_interface
11981: set process_status = 4,
11982: error_code = -2,
11983: error_msg = l_error_msg

Line 11990: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST (

11986: else -- req_id <> 0
11987: l_stmt_num := 1090;
11988: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
11989: ||to_char(l_inv_worker_req_id));
11990: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST (
11991: request_id => l_inv_worker_req_id,
11992: interval => 10, -- 10 seconds interval
11993: max_wait => 36000, -- 10 Hours maximum wait.
11994: phase => req_phase,

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

12007: errbuf:= 'Inventory worker returned failure '||
12008: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '||
12009: SUBSTRB(SQLERRM,1,1000);
12010: fnd_file.put_line(fnd_file.log,errbuf);
12011: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12012: end if;
12013:
12014: check_errored_mmtt_records(l_mmtt_txn_hdr_id, l_error_code, l_error_msg);
12015:

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

12018: errbuf:= 'Errored Records in mmtt ' ||
12019: '(Transaction_header_id=' ||l_mmtt_txn_hdr_id||') : '||
12020: SUBSTRB(SQLERRM,1,1000);
12021: fnd_file.put_line(fnd_file.log,errbuf);
12022: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12023: end if;
12024:
12025: end if; -- req_id
12026: */

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

12157: when others then
12158: retcode := 1;
12159: errbuf := 'Deletion of successful rows from interface table(s) failed';
12160: fnd_file.put_line(fnd_file.log,errbuf);
12161: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12162: End;
12163:
12164: COMMIT; -- commit a batch
12165:

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

12269: and organization_id = l_v_d_org_id_err(i);
12270:
12271: errbuf := 'The interface process marked at least one row as errored';
12272: fnd_file.put_line(fnd_file.log,errbuf);
12273: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
12274:
12275: end if;
12276: l_stmt_num := 1230;
12277: if(l_d_idx_ok > 1) then

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

12331:
12332: if l_error_count = 0 then
12333: retcode := 0;
12334: errbuf := '';
12335: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',errbuf);
12336: end if;
12337:
12338: COMMIT;
12339:

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

12344: retcode := 2;
12345: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '
12346: || SUBSTR(SQLERRM, 1,240);
12347: fnd_file.put_line(fnd_file.log,errbuf);
12348: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12349: wsmputil.WRITE_TO_WIE (
12350: 0,
12351: substr(errbuf,1,2000),
12352: fnd_global.conc_request_id,

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

12362: retcode := 2;
12363: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '
12364: || SUBSTR(SQLERRM, 1,240);
12365: fnd_file.put_line(fnd_file.log,errbuf);
12366: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
12367:
12368: wsmputil.WRITE_TO_WIE (
12369: 0,
12370: substr(errbuf,1,2000),