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.37.12010000.4 2008/11/24 10:10:06 amayadav 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 10065: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '

10061: exception
10062: when others then
10063: l_error_code := SQLCODE;
10064: l_error_msg :=
10065: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
10066: ||SUBSTR(SQLERRM, 1,1000);
10067: handle_error(l_error_code, l_error_msg, l_stmt_num);
10068: GOTO skip_resched_validations;
10069: end;

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

10886: exception
10887: when others then
10888: l_error_code := SQLCODE;
10889: l_error_msg :=
10890: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
10891: ||SUBSTR(SQLERRM, 1,1000);
10892: handle_error(l_error_code, l_error_msg, l_stmt_num);
10893: l_error_count := l_error_count + 1;
10894: GOTO abort_this_job;

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

11093: Exception
11094: when others then
11095: l_error_code := SQLCODE;
11096: l_error_msg :=
11097: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11098: ||SUBSTR(SQLERRM, 1,1000);
11099: handle_error(l_error_code, l_error_msg, l_stmt_num);
11100: l_error_count := l_error_count + 1;
11101: GOTO abort_this_job;

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

11375: Exception
11376: when others then
11377: l_error_code := SQLCODE;
11378: l_error_msg :=
11379: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11380: ||SUBSTR(SQLERRM, 1,1000);
11381: handle_error(l_error_code, l_error_msg, l_stmt_num);
11382: l_error_count := l_error_count + 1;
11383: GOTO abort_this_job;

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

11727: Exception -- material transaction
11728: when others then
11729: l_error_code := SQLCODE;
11730: l_error_msg :=
11731: 'WSM_LBJ_INTERFACE_PVT.launch_worker: stmt# '||l_stmt_num||' '
11732: ||SUBSTR(SQLERRM, 1,1000);
11733: handle_error(l_error_code, l_error_msg, l_stmt_num);
11734: GOTO skip_mat_trans;
11735: End; -- material transaction

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

11751: EXCEPTION
11752: when others then
11753: l_error_code := SQLCODE;
11754: l_error_msg :=
11755: 'WSM_LBJ_INTERFACE_PVT.launch_worker (stmt# '||l_stmt_num||') '
11756: ||SUBSTR(SQLERRM, 1,1000);
11757: handle_error(l_error_code, l_error_msg, l_stmt_num);
11758: l_error_count := l_error_count + 1;
11759: END; -- }}} main block

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

11876:
11877: if dummy_err_code <> 0 then
11878: fnd_file.put_line(fnd_file.log, 'WARNING ');
11879: fnd_file.put_line(fnd_file.log,
11880: 'WSM_LBJ_INTERFACE_PVT.launch_worker: '||dummy_err_msg);
11881: l_error_count := l_error_count + 1;
11882: end if;
11883: end if;
11884:

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

12341: EXCEPTION -- for launch_worker
12342: when e_abort_request then
12343: rollback to savepoint_top;
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 (

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

12359:
12360: when others then
12361: rollback to savepoint_top;
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:

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

14688:
14689: exception
14690:
14691: when others then
14692: x_error_msg := 'WSM_LBJ_INTERFACE_PVT : add_resource :: ' || l_stmt_num || ' : ' || substrb(SQLERRM,1,2000);
14693: fnd_file.put_line(fnd_file.log,x_error_msg);
14694: x_error_code := -1;
14695:
14696: end add_resource;

Line 21437: END WSM_LBJ_INTERFACE_PVT;

21433:
21434: END build_job_header_info;
21435:
21436:
21437: END WSM_LBJ_INTERFACE_PVT;