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 WSM_LBJ_INTERFACE_PVT

Line 1: PACKAGE BODY WSM_LBJ_INTERFACE_PVT AS

1: PACKAGE BODY WSM_LBJ_INTERFACE_PVT AS
2: /* $Header: WSMVLJIB.pls 120.44.12020000.5 2013/02/22 09:12:49 kswarna ship $ */
3:
4: -- BUG 3934661
5: -- when calling dbms_utility.get_hash_value use larger seed number

Line 10: -- PACKAGE: WSM_LBJ_INTERFACE_PVT (OSFM 11.5.10 and above)

6: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
7: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
8:
9: -- **********************************************************************************************
10: -- PACKAGE: WSM_LBJ_INTERFACE_PVT (OSFM 11.5.10 and above)
11: -- (1) This is to handle WSM Lot Based Job Interface
12: -- WSM_LOT_JOB_INTERFACE and WSM_LOT_JOB_DTL_INTERFACE
13: -- (2) The {{{ and }}} in the comments are used to allow better nevigation within
14: -- the source code, {{{ or {{ is the beginning of a block, }}} or }} is the end

Line 10163: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

10159: exception
10160: when others then
10161: l_error_code := SQLCODE;
10162: l_error_msg :=
10163: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
10164: ||SUBSTR(SQLERRM, 1,1000);
10165: handle_error(l_error_code, l_error_msg, l_stmt_num);
10166: GOTO skip_resched_validations;
10167: end;

Line 10992: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

10988: exception
10989: when others then
10990: l_error_code := SQLCODE;
10991: l_error_msg :=
10992: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
10993: ||SUBSTR(SQLERRM, 1,1000);
10994: handle_error(l_error_code, l_error_msg, l_stmt_num);
10995: l_error_count := l_error_count + 1;
10996: GOTO abort_this_job;

Line 11199: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

11195: Exception
11196: when others then
11197: l_error_code := SQLCODE;
11198: l_error_msg :=
11199: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11200: ||SUBSTR(SQLERRM, 1,1000);
11201: handle_error(l_error_code, l_error_msg, l_stmt_num);
11202: l_error_count := l_error_count + 1;
11203: GOTO abort_this_job;

Line 11482: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

11478: Exception
11479: when others then
11480: l_error_code := SQLCODE;
11481: l_error_msg :=
11482: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11483: ||SUBSTR(SQLERRM, 1,1000);
11484: handle_error(l_error_code, l_error_msg, l_stmt_num);
11485: l_error_count := l_error_count + 1;
11486: GOTO abort_this_job;

Line 11835: 'WSM_LBJ_INTERFACE_PVT.launch_worker: stmt# '||l_stmt_num||' '

11831: Exception -- material transaction
11832: when others then
11833: l_error_code := SQLCODE;
11834: l_error_msg :=
11835: 'WSM_LBJ_INTERFACE_PVT.launch_worker: stmt# '||l_stmt_num||' '
11836: ||SUBSTR(SQLERRM, 1,1000);
11837: handle_error(l_error_code, l_error_msg, l_stmt_num);
11838: GOTO skip_mat_trans;
11839: End; -- material transaction

Line 11859: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

11855: EXCEPTION
11856: when others then
11857: l_error_code := SQLCODE;
11858: l_error_msg :=
11859: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11860: ||SUBSTR(SQLERRM, 1,1000);
11861: handle_error(l_error_code, l_error_msg, l_stmt_num);
11862: l_error_count := l_error_count + 1;
11863: END; -- }}} main block

Line 11984: 'WSM_LBJ_INTERFACE_PVT.launch_worker: '||dummy_err_msg);

11980:
11981: if dummy_err_code <> 0 then
11982: fnd_file.put_line(fnd_file.log, 'WARNING ');
11983: fnd_file.put_line(fnd_file.log,
11984: 'WSM_LBJ_INTERFACE_PVT.launch_worker: '||dummy_err_msg);
11985: l_error_count := l_error_count + 1;
11986: end if;
11987: end if;
11988:

Line 12449: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '

12445: EXCEPTION -- for launch_worker
12446: when e_abort_request then
12447: rollback to savepoint_top;
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 (

Line 12467: errbuf := 'WSM_LBJ_INTERFACE_PVT.launch_worker (#'||l_stmt_num||') '

12463:
12464: when others then
12465: rollback to savepoint_top;
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:

Line 14796: x_error_msg := 'WSM_LBJ_INTERFACE_PVT : add_resource :: ' || l_stmt_num || ' : ' || substrb(SQLERRM,1,2000);

14792:
14793: exception
14794:
14795: when others then
14796: x_error_msg := 'WSM_LBJ_INTERFACE_PVT : add_resource :: ' || l_stmt_num || ' : ' || substrb(SQLERRM,1,2000);
14797: fnd_file.put_line(fnd_file.log,x_error_msg);
14798: x_error_code := -1;
14799:
14800: end add_resource;

Line 22103: END WSM_LBJ_INTERFACE_PVT;

22099:
22100: END build_job_header_info;
22101:
22102:
22103: END WSM_LBJ_INTERFACE_PVT;