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 WSMPUTIL

Line 832: wsmputil.WRITE_TO_WIE (

828: dummy_err_msg varchar2(2000);
829:
830: BEGIN
831: fnd_file.put_line(fnd_file.log, 'Warning: ' || p_err_msg);
832: wsmputil.WRITE_TO_WIE (
833: p_header_id,
834: substr(p_err_msg,1,2000),
835: p_request_id,
836: p_program_id,

Line 1200: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then

1196:
1197: end if;
1198:
1199: -- BA: 3512105
1200: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then
1201: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');
1202: x_error_msg := fnd_message.get;
1203: x_error_code := -1;
1204: return;

Line 7625: --l_return_value := wsmputil.CHECK_WMTI( -- CZH.I

7621: End;
7622:
7623: l_stmt_num := 140.3;
7624: -- removed for performance improvement
7625: --l_return_value := wsmputil.CHECK_WMTI( -- CZH.I
7626: -- p_wip_entity_id => null,
7627: -- p_wip_entity_name => v_wlji_job_name(v_idx),
7628: -- p_transaction_date => null,
7629: -- x_err_code => l_error_code,

Line 7641: -- := wsmputil.CHECK_WSMT( -- CZH.I

7637:
7638: l_stmt_num := 140.4;
7639: -- bug 3453139 removed for this is no longer required
7640: --l_return_value
7641: -- := wsmputil.CHECK_WSMT( -- CZH.I
7642: -- p_wip_entity_id => null,
7643: -- p_wip_entity_name => v_wlji_job_name(v_idx),
7644: -- p_transaction_id => null,
7645: -- p_transaction_date => null,

Line 8156: := wsmputil.GET_SCHEDULED_DATE (

8152: IF v_wlji_fusd(v_idx) IS NOT NULL AND
8153: v_wlji_lucd(v_idx) IS NULL THEN
8154: l_stmt_num := 270.3;
8155: v_wlji_lucd(v_idx)
8156: := wsmputil.GET_SCHEDULED_DATE (
8157: v_wlji_org_id(v_idx),
8158: v_wlji_item_id(v_idx),
8159: 'F',
8160: v_wlji_fusd(v_idx),

Line 8174: := wsmputil.GET_SCHEDULED_DATE (

8170: IF v_wlji_fusd(v_idx) IS NULL AND
8171: v_wlji_lucd(v_idx) IS NOT NULL THEN
8172: l_stmt_num := 270.4;
8173: v_wlji_fusd(v_idx)
8174: := wsmputil.GET_SCHEDULED_DATE (
8175: v_wlji_org_id(v_idx),
8176: v_wlji_item_id(v_idx),
8177: 'B',
8178: v_wlji_lucd(v_idx),

Line 8265: wsmputil.validate_non_std_references(

8261: -- 14: Invalid Firm Planned Flag
8262:
8263: l_error_code := 0;
8264: l_error_msg := NULL;
8265: wsmputil.validate_non_std_references(
8266: p_assembly_item_id => v_wlji_item_id(v_idx),
8267: p_routing_reference_id => v_wlji_rtg_ref_id(v_idx),
8268: p_bom_reference_id => v_wlji_bom_ref_id(v_idx),
8269: p_alt_routing_designator => v_wlji_alt_rtg(v_idx),

Line 8301: wsmputil.find_common_routing(

8297: GOTO abort_this_job;
8298: end if;
8299:
8300: -- Get common routing seq id
8301: wsmputil.find_common_routing(
8302: p_routing_sequence_id => l_rtg_seq_id,
8303: p_common_routing_sequence_id => l_common_rtg_seq_id,
8304: x_err_code => l_error_code,
8305: x_err_msg => l_error_msg);

Line 8569: wsmputil.find_common_routing(

8565: END IF;
8566: l_stmt_num := 330.3;
8567: -- Get common routing seq id
8568: l_error_msg := NULL;
8569: wsmputil.find_common_routing(
8570: p_routing_sequence_id => l_rtg_seq_id,
8571: p_common_routing_sequence_id => l_common_rtg_seq_id,
8572: x_err_code => l_error_code,
8573: x_err_msg => l_error_msg);

Line 8958: IF (WSMPUTIL.is_status_applicable(p_wms_installed =>NULL,

8954: null;
8955: end;
8956: --Bug 5182520:Added validation on Material Status
8957: l_stmt_num := 422;
8958: IF (WSMPUTIL.is_status_applicable(p_wms_installed =>NULL,
8959: p_trx_status_enabled => NULL,
8960: p_trx_type_id => 35,
8961: p_lot_status_enabled => NULL,
8962: p_serial_status_enabled => NULL,

Line 9126: wsmputil.find_common_routing(

9122: end;
9123: l_stmt_num := 520;
9124: -- find l_common_rtg_seq_id
9125: l_error_msg := NULL;
9126: wsmputil.find_common_routing(
9127: p_routing_sequence_id => l_rtg_seq_id,
9128: p_common_routing_sequence_id => l_common_rtg_seq_id,
9129: x_err_code => l_error_code,
9130: x_err_msg => l_error_msg);

Line 9469: wsmputil.validate_non_std_references(

9465: then
9466: l_chg_ref_flag := 1;
9467: l_stmt_num:= 610;
9468: if l_chg_bom_ref = 1 then
9469: wsmputil.validate_non_std_references(
9470: p_assembly_item_id => null,
9471: p_routing_reference_id => null,
9472: p_bom_reference_id => v_wlji_bom_ref_id(v_idx),
9473: p_alt_routing_designator => null,

Line 9502: wsmputil.validate_non_std_references(

9498: end if;
9499: end if;
9500: l_stmt_num:= 620;
9501: if l_chg_rtg_ref = 1 then
9502: wsmputil.validate_non_std_references(
9503: p_assembly_item_id => null,
9504: p_routing_reference_id => v_wlji_rtg_ref_id(v_idx),
9505: p_bom_reference_id => null,
9506: p_alt_routing_designator => v_wlji_alt_rtg(v_idx),

Line 9534: wsmputil.find_common_routing(

9530: end if;
9531: l_stmt_num:= 630;
9532: -- find the common rtg seq id
9533: l_error_msg := NULL;
9534: wsmputil.find_common_routing(
9535: p_routing_sequence_id => l_rtg_seq_id,
9536: p_common_routing_sequence_id => l_common_rtg_seq_id,
9537: x_err_code => l_error_code,
9538: x_err_msg => l_error_msg);

Line 9841: l_temp_num := WSMPUTIL.GET_INV_ACCT_PERIOD(

9837: GOTO skip_resched_validations;
9838: end if;
9839:
9840: -- BEGIN: BUG3126650
9841: l_temp_num := WSMPUTIL.GET_INV_ACCT_PERIOD(
9842: x_err_code => l_error_code,
9843: x_err_msg => l_error_msg,
9844: p_organization_id => v_wlji_org_id(v_idx),
9845: p_date => trunc(nvl(v_wlji_date_released(v_idx),sysdate)));

Line 9895: wsmputil.WSM_ESA_ENABLED(

9891: end if;
9892: l_stmt_num := 720.3;
9893: if (l_cur_status_type IN (1,6)) and
9894: (v_wlji_status_type(v_idx) = 3) and
9895: wsmputil.WSM_ESA_ENABLED(
9896: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
9897: err_code => l_error_code,
9898: err_msg => l_error_msg,
9899: p_org_id => '',

Line 9989: if wsmputil.check_osp_operation(

9985: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME
9986: <> WIP_CONSTANTS.MANUAL_CREATION
9987: then
9988: if (v_wlji_status_type(v_idx) = 3 and l_cur_status_type = 1) then
9989: if wsmputil.check_osp_operation(
9990: v_wlji_wip_entity_id(v_idx),
9991: l_osp_op_seq_num,
9992: v_wlji_org_id(v_idx))
9993: then

Line 10198: v_wlji_lucd(v_idx) := wsmputil.GET_SCHEDULED_DATE(

10194: l_error_code := -1;
10195: GOTO skip_resched_validations;
10196: ELSE
10197: l_stmt_num := 760.2;
10198: v_wlji_lucd(v_idx) := wsmputil.GET_SCHEDULED_DATE(
10199: v_wlji_org_id(v_idx),
10200: v_wlji_item_id(v_idx),
10201: 'F',
10202: v_wlji_fusd(v_idx),

Line 10209: v_wlji_fusd(v_idx) := wsmputil.GET_SCHEDULED_DATE (

10205: v_wlji_start_quantity(v_idx)); --Fixed bug # 2313574
10206: END IF;
10207: elsif (v_wlji_lucd(v_idx) is not null) then
10208: l_stmt_num := 760.3;
10209: v_wlji_fusd(v_idx) := wsmputil.GET_SCHEDULED_DATE (
10210: v_wlji_org_id(v_idx),
10211: v_wlji_item_id(v_idx),
10212: 'B',
10213: v_wlji_lucd(v_idx),

Line 10411: if (wsmputil.network_with_disabled_op(

10407: v_new_job := 2;
10408: end if;
10409: l_stmt_num := 820;
10410: -- {{ Check for disabled ops in the network,job_type 1 and 3
10411: if (wsmputil.network_with_disabled_op(
10412: l_common_rtg_seq_id,
10413: v_wlji_rtg_rev_date(v_idx),
10414: l_error_code,
10415: l_error_msg) = 1)

Line 10744: wsmputil.return_att_quantity(

10740: handle_invalid_field('Component Lot Revision', '', l_stmt_num);
10741: GOTO abort_this_job;
10742: end;
10743: l_stmt_num := 880;
10744: wsmputil.return_att_quantity(
10745: p_org_id => v_wlji_org_id(v_idx),
10746: p_item_id => v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10747: p_rev => v_wsli(v_wlji_src_line_id(v_idx)).revision,
10748: p_lot_no => v_wsli(v_wlji_src_line_id(v_idx)).lot_number,

Line 11045: wsmputil.wsm_esa_enabled(

11041: l_stmt_num := 920.3;
11042: -- abb H: optional scrap accounting
11043:
11044: if (l_cur_status_type IN (1,6) and v_wlji_status_type(v_idx) = 3) and
11045: wsmputil.wsm_esa_enabled(
11046: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11047: err_code => l_error_code,
11048: err_msg => l_error_msg,
11049: p_org_id => '',

Line 11867: wsmputil.WRITE_TO_WIE (

11863: -- }} kanban end
11864:
11865: dummy_err_code := 0;
11866: dummy_err_msg := NULL;
11867: wsmputil.WRITE_TO_WIE (
11868: v_wlji_header_id(v_idx),
11869: substr(v_wlji_err_msg(v_idx),1,2000),
11870: v_wlji_request_id(v_idx),
11871: v_wlji_program_id(v_idx),

Line 12349: wsmputil.WRITE_TO_WIE (

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,
12353: fnd_global.conc_program_id,

Line 12368: wsmputil.WRITE_TO_WIE (

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),
12371: fnd_global.conc_request_id,
12372: fnd_global.conc_program_id,

Line 12636: l_bill_sequence_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wip_entity_id);

12632: end if;
12633:
12634: -- BA: BUG: 3341350/3286849
12635: l_stmt_num := 5;
12636: l_bill_sequence_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wip_entity_id);
12637: if(l_bill_sequence_id = -1) then
12638: p_error_msg := 'Fail to get bill sequence id (wip_entity_id='||p_wip_entity_id ||')';
12639: p_error_code := -1;
12640: raise e_build_job_dtl;

Line 12691: wsmputil.FIND_ROUTING_START(

12687: end if;
12688: --Start changes for Bug 5104459
12689: l_stmt_num := 11;
12690:
12691: wsmputil.FIND_ROUTING_START(
12692: p_common_routing_sequence_id,
12693: p_routing_revision_date,
12694: l_op_seq_id,
12695: p_error_code,

Line 12704: wsmputil.FIND_ROUTING_END(

12700: end if;
12701:
12702: l_stmt_num := 12;
12703:
12704: wsmputil.FIND_ROUTING_END(
12705: p_common_routing_sequence_id,
12706: p_routing_revision_date,
12707: l_op_seq_id,
12708: p_error_code,

Line 16693: l_validate_network := WSMPUTIL.validate_job_network(p_wip_entity_id => p_wip_entity_id,

16689: -- Added For LBJ Interface Alcoa Enhancement
16690: ------------------------------------------------
16691: if l_validate_network=0 then
16692:
16693: l_validate_network := WSMPUTIL.validate_job_network(p_wip_entity_id => p_wip_entity_id,
16694: x_err_code => p_error_code,
16695: x_err_msg => p_error_msg);
16696:
16697: if l_validate_network =1 then

Line 20441: --l_inv_period_id := wsmputil.get_inv_acct_period (

20437:
20438: BEGIN
20439:
20440: -- BD: bugfix 3299811, this is a regression of bugfix 3126650
20441: --l_inv_period_id := wsmputil.get_inv_acct_period (
20442: -- x_err_code => p_error_code,
20443: -- x_err_msg => p_err_msg,
20444: -- p_organization_id => p_organization_id,
20445: -- p_date => trunc(nvl(p_release_date, sysdate)) );

Line 20664: if wsmputil.check_po_move (

20660:
20661: l_stmt_num := 30;
20662: -- osp begin
20663: if(l_op_seq_id <> -1) then
20664: if wsmputil.check_po_move (
20665: p_sequence_id => l_op_seq_id,
20666: p_sequence_id_type => 'O',
20667: p_routing_rev_date => p_routing_revision_date,
20668: x_err_code => p_error_code,

Line 20831: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then

20827: -- osp begin -- this has to be put after insertion into wip_entities
20828: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
20829: if p_src_client_server = 1 then
20830: l_stmt_num := 130;
20831: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then
20832: g_num_of_osp_exists := g_num_of_osp_exists + 1;
20833: wip_osp.create_requisition(
20834: p_wip_entity_id => p_wip_entity_id,
20835: p_organization_id => p_org_id,

Line 20845: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then

20841: else
20842: l_stmt_num := 140;
20843: -- if build_job_info is called from form, only then P_Run_ReqImport should be YES, i.e.
20844: -- the requisition import concurrent request should be launched immediately.
20845: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then
20846: g_num_of_osp_exists := g_num_of_osp_exists + 1;
20847: wip_osp.create_requisition(
20848: p_wip_entity_id => p_wip_entity_id,
20849: p_organization_id => p_org_id,

Line 21025: if wsmputil.wsm_esa_enabled(

21021:
21022:
21023: l_stmt_num := 120;
21024: -- check scrap account
21025: if wsmputil.wsm_esa_enabled(
21026: p_wip_entity_id => null,
21027: err_code => p_error_code,
21028: err_msg => p_error_msg,
21029: p_org_id => p_org_id,