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

Line 402: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

398: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(0);
399: ELSE
400: l_org_id := get_one_org_id(p_group_id, WIP_CONSTANTS.PENDING);
401: if (l_org_id = -1) then
402: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
403: 'Error: failed in get_one_org_id');
404: return;
405: end if;
406: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_org_id);

Line 451: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

447: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(0);
448: ELSE
449: l_org_id := get_one_org_id(l_group_id, WIP_CONSTANTS.RUNNING);
450: if (l_org_id = -1) then
451: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
452: 'Error: failed in get_one_org_id');
453: return;
454: end if;
455: l_profile := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_org_id);

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

2773: when others then
2774: retcode := 1;
2775: errbuf := 'WSMLBJIB.process_lbji_rows_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);
2776: fnd_file.put_line(fnd_file.log,errbuf);
2777: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
2778:
2779: END process_lbji_rows_1159 ;
2780:
2781:

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

7613: if l_warning_count <> 0 then
7614: retcode := 1;
7615: errbuf := 'The interface process produced atleast one warning message';
7616: fnd_file.put_line(fnd_file.log,errbuf);
7617: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7618: end if;
7619:
7620: if l_error_count <> 0 then
7621: retcode := 1;

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

7620: if l_error_count <> 0 then
7621: retcode := 1;
7622: errbuf := 'The interface process marked atleast one row as errored';
7623: fnd_file.put_line(fnd_file.log,errbuf);
7624: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7625: end if;
7626:
7627: -- *** bulk update wsm_lot_job_interface ***
7628: forall i in v_wlji_process_status.first..v_wlji_process_status.last

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

7654: retcode := 1;
7655: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7656: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7657: fnd_file.put_line(fnd_file.log,errbuf);
7658: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7659: update wsm_lot_job_interface
7660: set process_status = 4,
7661: error_code = -2,
7662: error_msg = l_error_msg

Line 7669: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST

7665: else -- req_id <> 0
7666:
7667: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
7668: ||to_char(l_inv_worker_req_id));
7669: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST
7670: (request_id => l_inv_worker_req_id,
7671: interval => 10, -- 10 seconds interval
7672: max_wait => 36000, -- 10 Hours maximum wait.
7673: phase => req_phase,

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

7686: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7687: '(Transaction_header_id=' ||txn_header_id||') : '||
7688: SUBSTRB(SQLERRM,1,1000);
7689: fnd_file.put_line(fnd_file.log,errbuf);
7690: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7691: end if;
7692:
7693: check_errored_mmtt_records(txn_header_id, l_error_code, l_error_msg);
7694:

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

7696: retcode := 1;
7697: errbuf:= 'WSMPLBJI. Errored Records in mmtt ' ||
7698: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7699: fnd_file.put_line(fnd_file.log,errbuf);
7700: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7701: end if;
7702:
7703: end if; -- req_id
7704: end if; -- l_atleast_one_row_in_mmtt

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

7745: when others then
7746: retcode := 1;
7747: errbuf := 'Deletion of successful rows from interface table(s) failed';
7748: fnd_file.put_line(fnd_file.log,errbuf);
7749: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7750: End;
7751:
7752: commit;
7753:

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

7789:
7790: if l_error_count = 0 then
7791: retcode := 0;
7792: errbuf := '';
7793: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',errbuf);
7794: end if;
7795:
7796:
7797: EXCEPTION -- for launch_worker

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

7799: rollback to back_to_square_one;
7800: retcode := 2;
7801: errbuf := 'WSMLBJIB.launch_worker_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);
7802: fnd_file.put_line(fnd_file.log,errbuf);
7803: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
7804: when others then
7805: rollback to back_to_square_one;
7806: retcode := 2;
7807: errbuf := 'WSMLBJIB.launch_worker_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);

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

7805: rollback to back_to_square_one;
7806: retcode := 2;
7807: errbuf := 'WSMLBJIB.launch_worker_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);
7808: fnd_file.put_line(fnd_file.log,errbuf);
7809: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
7810:
7811: END launch_worker_1159;
7812:
7813: END WSMPLBJI;