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

2767: when others then
2768: retcode := 1;
2769: errbuf := 'WSMLBJIB.process_lbji_rows_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);
2770: fnd_file.put_line(fnd_file.log,errbuf);
2771: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
2772:
2773: END process_lbji_rows_1159 ;
2774:
2775:

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

7607: if l_warning_count <> 0 then
7608: retcode := 1;
7609: errbuf := 'The interface process produced atleast one warning message';
7610: fnd_file.put_line(fnd_file.log,errbuf);
7611: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7612: end if;
7613:
7614: if l_error_count <> 0 then
7615: retcode := 1;

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

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

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

7648: retcode := 1;
7649: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7650: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7651: fnd_file.put_line(fnd_file.log,errbuf);
7652: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7653: update wsm_lot_job_interface
7654: set process_status = 4,
7655: error_code = -2,
7656: error_msg = l_error_msg

Line 7663: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST

7659: else -- req_id <> 0
7660:
7661: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
7662: ||to_char(l_inv_worker_req_id));
7663: req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST
7664: (request_id => l_inv_worker_req_id,
7665: interval => 10, -- 10 seconds interval
7666: max_wait => 36000, -- 10 Hours maximum wait.
7667: phase => req_phase,

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

7680: errbuf:= 'WSMPLBJI. Inventory worker returned failure '||
7681: '(Transaction_header_id=' ||txn_header_id||') : '||
7682: SUBSTRB(SQLERRM,1,1000);
7683: fnd_file.put_line(fnd_file.log,errbuf);
7684: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7685: end if;
7686:
7687: check_errored_mmtt_records(txn_header_id, l_error_code, l_error_msg);
7688:

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

7690: retcode := 1;
7691: errbuf:= 'WSMPLBJI. Errored Records in mmtt ' ||
7692: '(Transaction_header_id=' ||txn_header_id||') : '|| SUBSTRB(SQLERRM,1,1000);
7693: fnd_file.put_line(fnd_file.log,errbuf);
7694: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7695: end if;
7696:
7697: end if; -- req_id
7698: end if; -- l_atleast_one_row_in_mmtt

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

7739: when others then
7740: retcode := 1;
7741: errbuf := 'Deletion of successful rows from interface table(s) failed';
7742: fnd_file.put_line(fnd_file.log,errbuf);
7743: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
7744: End;
7745:
7746: commit;
7747:

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

7783:
7784: if l_error_count = 0 then
7785: retcode := 0;
7786: errbuf := '';
7787: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',errbuf);
7788: end if;
7789:
7790:
7791: EXCEPTION -- for launch_worker

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

7793: rollback to back_to_square_one;
7794: retcode := 2;
7795: errbuf := 'WSMLBJIB.launch_worker_1159: stmt num= '||l_stmt_num||' '||SUBSTR(SQLERRM, 1,240);
7796: fnd_file.put_line(fnd_file.log,errbuf);
7797: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
7798: when others then
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);

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:
7805: END launch_worker_1159;
7806:
7807: END WSMPLBJI;