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 837: wsmputil.WRITE_TO_WIE (

833: dummy_err_msg varchar2(2000);
834:
835: BEGIN
836: fnd_file.put_line(fnd_file.log, 'Warning: ' || p_err_msg);
837: wsmputil.WRITE_TO_WIE (
838: p_header_id,
839: substr(p_err_msg,1,2000),
840: p_request_id,
841: p_program_id,

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

1201:
1202: end if;
1203:
1204: -- BA: 3512105
1205: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then
1206: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');
1207: x_error_msg := fnd_message.get;
1208: x_error_code := -1;
1209: return;

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

7637: End;
7638:
7639: l_stmt_num := 140.3;
7640: -- removed for performance improvement
7641: --l_return_value := wsmputil.CHECK_WMTI( -- CZH.I
7642: -- p_wip_entity_id => null,
7643: -- p_wip_entity_name => v_wlji_job_name(v_idx),
7644: -- p_transaction_date => null,
7645: -- x_err_code => l_error_code,

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

7653:
7654: l_stmt_num := 140.4;
7655: -- bug 3453139 removed for this is no longer required
7656: --l_return_value
7657: -- := wsmputil.CHECK_WSMT( -- CZH.I
7658: -- p_wip_entity_id => null,
7659: -- p_wip_entity_name => v_wlji_job_name(v_idx),
7660: -- p_transaction_id => null,
7661: -- p_transaction_date => null,

Line 8254: := wsmputil.GET_SCHEDULED_DATE (

8250: IF v_wlji_fusd(v_idx) IS NOT NULL AND
8251: v_wlji_lucd(v_idx) IS NULL THEN
8252: l_stmt_num := 270.3;
8253: v_wlji_lucd(v_idx)
8254: := wsmputil.GET_SCHEDULED_DATE (
8255: v_wlji_org_id(v_idx),
8256: v_wlji_item_id(v_idx),
8257: 'F',
8258: v_wlji_fusd(v_idx),

Line 8272: := wsmputil.GET_SCHEDULED_DATE (

8268: IF v_wlji_fusd(v_idx) IS NULL AND
8269: v_wlji_lucd(v_idx) IS NOT NULL THEN
8270: l_stmt_num := 270.4;
8271: v_wlji_fusd(v_idx)
8272: := wsmputil.GET_SCHEDULED_DATE (
8273: v_wlji_org_id(v_idx),
8274: v_wlji_item_id(v_idx),
8275: 'B',
8276: v_wlji_lucd(v_idx),

Line 8363: wsmputil.validate_non_std_references(

8359: -- 14: Invalid Firm Planned Flag
8360:
8361: l_error_code := 0;
8362: l_error_msg := NULL;
8363: wsmputil.validate_non_std_references(
8364: p_assembly_item_id => v_wlji_item_id(v_idx),
8365: p_routing_reference_id => v_wlji_rtg_ref_id(v_idx),
8366: p_bom_reference_id => v_wlji_bom_ref_id(v_idx),
8367: p_alt_routing_designator => v_wlji_alt_rtg(v_idx),

Line 8399: wsmputil.find_common_routing(

8395: GOTO abort_this_job;
8396: end if;
8397:
8398: -- Get common routing seq id
8399: wsmputil.find_common_routing(
8400: p_routing_sequence_id => l_rtg_seq_id,
8401: p_common_routing_sequence_id => l_common_rtg_seq_id,
8402: x_err_code => l_error_code,
8403: x_err_msg => l_error_msg);

Line 8667: wsmputil.find_common_routing(

8663: END IF;
8664: l_stmt_num := 330.3;
8665: -- Get common routing seq id
8666: l_error_msg := NULL;
8667: wsmputil.find_common_routing(
8668: p_routing_sequence_id => l_rtg_seq_id,
8669: p_common_routing_sequence_id => l_common_rtg_seq_id,
8670: x_err_code => l_error_code,
8671: x_err_msg => l_error_msg);

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

9052: null;
9053: end;
9054: --Bug 5182520:Added validation on Material Status
9055: l_stmt_num := 422;
9056: IF (WSMPUTIL.is_status_applicable(p_wms_installed =>NULL,
9057: p_trx_status_enabled => NULL,
9058: p_trx_type_id => 35,
9059: p_lot_status_enabled => NULL,
9060: p_serial_status_enabled => NULL,

Line 9224: wsmputil.find_common_routing(

9220: end;
9221: l_stmt_num := 520;
9222: -- find l_common_rtg_seq_id
9223: l_error_msg := NULL;
9224: wsmputil.find_common_routing(
9225: p_routing_sequence_id => l_rtg_seq_id,
9226: p_common_routing_sequence_id => l_common_rtg_seq_id,
9227: x_err_code => l_error_code,
9228: x_err_msg => l_error_msg);

Line 9567: wsmputil.validate_non_std_references(

9563: then
9564: l_chg_ref_flag := 1;
9565: l_stmt_num:= 610;
9566: if l_chg_bom_ref = 1 then
9567: wsmputil.validate_non_std_references(
9568: p_assembly_item_id => null,
9569: p_routing_reference_id => null,
9570: p_bom_reference_id => v_wlji_bom_ref_id(v_idx),
9571: p_alt_routing_designator => null,

Line 9600: wsmputil.validate_non_std_references(

9596: end if;
9597: end if;
9598: l_stmt_num:= 620;
9599: if l_chg_rtg_ref = 1 then
9600: wsmputil.validate_non_std_references(
9601: p_assembly_item_id => null,
9602: p_routing_reference_id => v_wlji_rtg_ref_id(v_idx),
9603: p_bom_reference_id => null,
9604: p_alt_routing_designator => v_wlji_alt_rtg(v_idx),

Line 9632: wsmputil.find_common_routing(

9628: end if;
9629: l_stmt_num:= 630;
9630: -- find the common rtg seq id
9631: l_error_msg := NULL;
9632: wsmputil.find_common_routing(
9633: p_routing_sequence_id => l_rtg_seq_id,
9634: p_common_routing_sequence_id => l_common_rtg_seq_id,
9635: x_err_code => l_error_code,
9636: x_err_msg => l_error_msg);

Line 9939: l_temp_num := WSMPUTIL.GET_INV_ACCT_PERIOD(

9935: GOTO skip_resched_validations;
9936: end if;
9937:
9938: -- BEGIN: BUG3126650
9939: l_temp_num := WSMPUTIL.GET_INV_ACCT_PERIOD(
9940: x_err_code => l_error_code,
9941: x_err_msg => l_error_msg,
9942: p_organization_id => v_wlji_org_id(v_idx),
9943: p_date => trunc(nvl(v_wlji_date_released(v_idx),sysdate)));

Line 9993: wsmputil.WSM_ESA_ENABLED(

9989: end if;
9990: l_stmt_num := 720.3;
9991: if (l_cur_status_type IN (1,6)) and
9992: (v_wlji_status_type(v_idx) = 3) and
9993: wsmputil.WSM_ESA_ENABLED(
9994: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
9995: err_code => l_error_code,
9996: err_msg => l_error_msg,
9997: p_org_id => '',

Line 10087: if wsmputil.check_osp_operation(

10083: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME
10084: <> WIP_CONSTANTS.MANUAL_CREATION
10085: then
10086: if (v_wlji_status_type(v_idx) = 3 and l_cur_status_type = 1) then
10087: if wsmputil.check_osp_operation(
10088: v_wlji_wip_entity_id(v_idx),
10089: l_osp_op_seq_num,
10090: v_wlji_org_id(v_idx))
10091: then

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

10292: l_error_code := -1;
10293: GOTO skip_resched_validations;
10294: ELSE
10295: l_stmt_num := 760.2;
10296: v_wlji_lucd(v_idx) := wsmputil.GET_SCHEDULED_DATE(
10297: v_wlji_org_id(v_idx),
10298: v_wlji_item_id(v_idx),
10299: 'F',
10300: v_wlji_fusd(v_idx),

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

10303: v_wlji_start_quantity(v_idx)); --Fixed bug # 2313574
10304: END IF;
10305: elsif (v_wlji_lucd(v_idx) is not null) then
10306: l_stmt_num := 760.3;
10307: v_wlji_fusd(v_idx) := wsmputil.GET_SCHEDULED_DATE (
10308: v_wlji_org_id(v_idx),
10309: v_wlji_item_id(v_idx),
10310: 'B',
10311: v_wlji_lucd(v_idx),

Line 10509: if (wsmputil.network_with_disabled_op(

10505: v_new_job := 2;
10506: end if;
10507: l_stmt_num := 820;
10508: -- {{ Check for disabled ops in the network,job_type 1 and 3
10509: if (wsmputil.network_with_disabled_op(
10510: l_common_rtg_seq_id,
10511: v_wlji_rtg_rev_date(v_idx),
10512: l_error_code,
10513: l_error_msg) = 1)

Line 10846: wsmputil.return_att_quantity(

10842: handle_invalid_field('Component Lot Revision', '', l_stmt_num);
10843: GOTO abort_this_job;
10844: end;
10845: l_stmt_num := 880;
10846: wsmputil.return_att_quantity(
10847: p_org_id => v_wlji_org_id(v_idx),
10848: p_item_id => v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10849: p_rev => v_wsli(v_wlji_src_line_id(v_idx)).revision,
10850: p_lot_no => v_wsli(v_wlji_src_line_id(v_idx)).lot_number,

Line 11147: wsmputil.wsm_esa_enabled(

11143: l_stmt_num := 920.3;
11144: -- abb H: optional scrap accounting
11145:
11146: if (l_cur_status_type IN (1,6) and v_wlji_status_type(v_idx) = 3) and
11147: wsmputil.wsm_esa_enabled(
11148: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11149: err_code => l_error_code,
11150: err_msg => l_error_msg,
11151: p_org_id => '',

Line 11971: wsmputil.WRITE_TO_WIE (

11967: -- }} kanban end
11968:
11969: dummy_err_code := 0;
11970: dummy_err_msg := NULL;
11971: wsmputil.WRITE_TO_WIE (
11972: v_wlji_header_id(v_idx),
11973: substr(v_wlji_err_msg(v_idx),1,2000),
11974: v_wlji_request_id(v_idx),
11975: v_wlji_program_id(v_idx),

Line 12453: wsmputil.WRITE_TO_WIE (

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 (
12454: 0,
12455: substr(errbuf,1,2000),
12456: fnd_global.conc_request_id,
12457: fnd_global.conc_program_id,

Line 12472: wsmputil.WRITE_TO_WIE (

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:
12472: wsmputil.WRITE_TO_WIE (
12473: 0,
12474: substr(errbuf,1,2000),
12475: fnd_global.conc_request_id,
12476: fnd_global.conc_program_id,

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

12736: end if;
12737:
12738: -- BA: BUG: 3341350/3286849
12739: l_stmt_num := 5;
12740: l_bill_sequence_id := WSMPUTIL.GET_JOB_BOM_SEQ_ID(p_wip_entity_id);
12741: if(l_bill_sequence_id = -1) then
12742: p_error_msg := 'Fail to get bill sequence id (wip_entity_id='||p_wip_entity_id ||')';
12743: p_error_code := -1;
12744: raise e_build_job_dtl;

Line 12795: wsmputil.FIND_ROUTING_START(

12791: end if;
12792: --Start changes for Bug 5104459
12793: l_stmt_num := 11;
12794:
12795: wsmputil.FIND_ROUTING_START(
12796: p_common_routing_sequence_id,
12797: p_routing_revision_date,
12798: l_op_seq_id,
12799: p_error_code,

Line 12808: wsmputil.FIND_ROUTING_END(

12804: end if;
12805:
12806: l_stmt_num := 12;
12807:
12808: wsmputil.FIND_ROUTING_END(
12809: p_common_routing_sequence_id,
12810: p_routing_revision_date,
12811: l_op_seq_id,
12812: p_error_code,

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

17083: -- Added For LBJ Interface Alcoa Enhancement
17084: ------------------------------------------------
17085: if l_validate_network=0 then
17086:
17087: l_validate_network := WSMPUTIL.validate_job_network(p_wip_entity_id => p_wip_entity_id,
17088: x_err_code => p_error_code,
17089: x_err_msg => p_error_msg);
17090:
17091: if l_validate_network =1 then

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

21102:
21103: BEGIN
21104:
21105: -- BD: bugfix 3299811, this is a regression of bugfix 3126650
21106: --l_inv_period_id := wsmputil.get_inv_acct_period (
21107: -- x_err_code => p_error_code,
21108: -- x_err_msg => p_err_msg,
21109: -- p_organization_id => p_organization_id,
21110: -- p_date => trunc(nvl(p_release_date, sysdate)) );

Line 21329: if wsmputil.check_po_move (

21325:
21326: l_stmt_num := 30;
21327: -- osp begin
21328: if(l_op_seq_id <> -1) then
21329: if wsmputil.check_po_move (
21330: p_sequence_id => l_op_seq_id,
21331: p_sequence_id_type => 'O',
21332: p_routing_rev_date => p_routing_revision_date,
21333: x_err_code => p_error_code,

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

21492: -- osp begin -- this has to be put after insertion into wip_entities
21493: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
21494: if p_src_client_server = 1 then
21495: l_stmt_num := 130;
21496: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then
21497: g_num_of_osp_exists := g_num_of_osp_exists + 1;
21498: wip_osp.create_requisition(
21499: p_wip_entity_id => p_wip_entity_id,
21500: p_organization_id => p_org_id,

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

21506: else
21507: l_stmt_num := 140;
21508: -- if build_job_info is called from form, only then P_Run_ReqImport should be YES, i.e.
21509: -- the requisition import concurrent request should be launched immediately.
21510: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then
21511: g_num_of_osp_exists := g_num_of_osp_exists + 1;
21512: wip_osp.create_requisition(
21513: p_wip_entity_id => p_wip_entity_id,
21514: p_organization_id => p_org_id,

Line 21690: if wsmputil.wsm_esa_enabled(

21686:
21687:
21688: l_stmt_num := 120;
21689: -- check scrap account
21690: if wsmputil.wsm_esa_enabled(
21691: p_wip_entity_id => null,
21692: err_code => p_error_code,
21693: err_msg => p_error_msg,
21694: p_org_id => p_org_id,