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 WSMPLCVA

Line 1004: l_xst := WSMPLCVA.v_org.exists(p_org_id);

1000:
1001: l_stmt_num := 30;
1002: -- now p_org_id is always available
1003: l_xst := true;
1004: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1005: if l_xst = false then
1006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1007: fnd_message.set_token('FLD_NAME', 'Organization ID');
1008: x_error_msg := fnd_message.get;

Line 6355: WSMPLCVA.load_org_table;

6351: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id);
6352:
6353: l_stmt_num := 20;
6354: -- load organization PL/SQL table
6355: WSMPLCVA.load_org_table;
6356:
6357: ----------------------------------------------------------------
6358: -- {{ Check PENDING WLJI records, validate org, job id/name
6359: ----------------------------------------------------------------

Line 7173: WSMPLCVA.load_org_table;

7169: -- ==============================================================================================
7170:
7171: begin
7172: l_stmt_num := 10;
7173: WSMPLCVA.load_org_table;
7174:
7175: l_stmt_num := 20;
7176: WSMPLCVA.load_subinventory;
7177:

Line 7176: WSMPLCVA.load_subinventory;

7172: l_stmt_num := 10;
7173: WSMPLCVA.load_org_table;
7174:
7175: l_stmt_num := 20;
7176: WSMPLCVA.load_subinventory;
7177:
7178: l_stmt_num := 30;
7179: WSMPLCVA.load_class_code;
7180: if lbji_debug = 'Y' then

Line 7179: WSMPLCVA.load_class_code;

7175: l_stmt_num := 20;
7176: WSMPLCVA.load_subinventory;
7177:
7178: l_stmt_num := 30;
7179: WSMPLCVA.load_class_code;
7180: if lbji_debug = 'Y' then
7181: fnd_file.put_line(fnd_file.log,
7182: 'Loading org/subinv/class-code values into memory (once per worker).. OK.');
7183: end if;

Line 8004: l_xst := WSMPLCVA.v_user.exists(v_wlji_last_updt_by(v_idx));

8000: if v_wlji_last_updt_by(v_idx) is NULL then
8001: v_wlji_last_updt_by(v_idx) := l_user;
8002: else
8003: l_num_records := 0;
8004: l_xst := WSMPLCVA.v_user.exists(v_wlji_last_updt_by(v_idx));
8005: if l_xst = false then
8006: begin
8007: select 1
8008: into l_num_records

Line 8023: WSMPLCVA.v_user(v_wlji_last_updt_by(v_idx))

8019: end;
8020: end if;
8021:
8022: if l_xst = false AND l_num_records <> 0 then
8023: WSMPLCVA.v_user(v_wlji_last_updt_by(v_idx))
8024: := v_wlji_last_updt_by(v_idx);
8025: end if;
8026:
8027: if l_error_code <> 0 then

Line 8042: l_xst := WSMPLCVA.v_user.exists(v_wlji_created_by(v_idx));

8038: if v_wlji_created_by(v_idx) is NULL then
8039: v_wlji_created_by(v_idx) := l_user;
8040: else
8041: l_num_records := 0;
8042: l_xst := WSMPLCVA.v_user.exists(v_wlji_created_by(v_idx));
8043: if l_xst = false then
8044: begin
8045: select 1
8046: into l_num_records

Line 8061: WSMPLCVA.v_user(v_wlji_created_by(v_idx))

8057: end;
8058: end if;
8059:
8060: if l_xst = false AND l_num_records <> 0 then
8061: WSMPLCVA.v_user(v_wlji_created_by(v_idx))
8062: := v_wlji_created_by(v_idx);
8063: end if;
8064:
8065: if l_error_code <> 0 then

Line 8206: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).COPRODUCTS_SUPPLY_DEFAULT;

8202: l_stmt_num := 280;
8203: -- Validate coproduct-supply flag (creation)
8204: IF v_wlji_coproducts_supply(v_idx) is NULL THEN
8205: v_wlji_coproducts_supply(v_idx)
8206: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).COPRODUCTS_SUPPLY_DEFAULT;
8207: --Bug 5463925: OR is replaced by AND.
8208: --ELSIF (v_wlji_coproducts_supply(v_idx) <> 1 OR
8209: ELSIF (v_wlji_coproducts_supply(v_idx) <> 1 AND
8210: v_wlji_coproducts_supply(v_idx) <> 2) THEN

Line 8330: l_xst := WSMPLCVA.v_item.exists(v_wlji_item_id(v_idx));

8326:
8327: l_stmt_num := 310;
8328: -- {{ Validate item id (std job creation)
8329: if v_wlji_mode_flag(v_idx) = 1 then
8330: l_xst := WSMPLCVA.v_item.exists(v_wlji_item_id(v_idx));
8331: else -- mode flag 2
8332: hash_str := to_char(v_wlji_item_id(v_idx)) ||
8333: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8334: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

Line 8336: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND

8332: hash_str := to_char(v_wlji_item_id(v_idx)) ||
8333: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8334: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8335:
8336: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8337: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8338: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8339: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8340: = v_wlji_item_id(v_idx));

Line 8337: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID

8333: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8334: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8335:
8336: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8337: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8338: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8339: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8340: = v_wlji_item_id(v_idx));
8341: end if;

Line 8339: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID

8335:
8336: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8337: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8338: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8339: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8340: = v_wlji_item_id(v_idx));
8341: end if;
8342: l_stmt_num := 310.1;
8343: if l_xst = false then

Line 8386: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID

8382: end if; -- l_xst = false
8383:
8384: if l_xst = false AND l_num_records <> 0 then
8385: if v_wlji_mode_flag(v_idx) = 2 then
8386: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8387: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8388: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8389: := v_wlji_item_id(v_idx);
8390: else -- mode flag = 1

Line 8388: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID

8384: if l_xst = false AND l_num_records <> 0 then
8385: if v_wlji_mode_flag(v_idx) = 2 then
8386: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8387: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8388: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8389: := v_wlji_item_id(v_idx);
8390: else -- mode flag = 1
8391: WSMPLCVA.v_item(v_wlji_item_id(v_idx)) := v_wlji_item_id(v_idx);
8392: end if;

Line 8391: WSMPLCVA.v_item(v_wlji_item_id(v_idx)) := v_wlji_item_id(v_idx);

8387: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8388: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8389: := v_wlji_item_id(v_idx);
8390: else -- mode flag = 1
8391: WSMPLCVA.v_item(v_wlji_item_id(v_idx)) := v_wlji_item_id(v_idx);
8392: end if;
8393: end if;
8394:
8395: if l_error_code <> 0 then

Line 8533: if WSMPLCVA.v_subinv.exists(hash_value) then

8529: -- {{ validation of subinv begin
8530: hash_str := to_char(v_wlji_org_id(v_idx))
8531: ||v_wlji_compl_subinv(v_idx);
8532: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8533: if WSMPLCVA.v_subinv.exists(hash_value) then
8534: NULL;
8535: else
8536: l_aux_mesg := '';
8537: handle_invalid_field(

Line 8729: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).DEFAULT_ACCT_CLASS_CODE;

8725: end;
8726:
8727: IF v_wlji_class_code(v_idx) is NULL then
8728: v_wlji_class_code(v_idx)
8729: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).DEFAULT_ACCT_CLASS_CODE;
8730: END IF;
8731: END IF;
8732:
8733: IF v_wlji_class_code(v_idx) IS NULL THEN

Line 8741: if WSMPLCVA.v_class_code.exists(hash_value) then

8737: ELSE
8738: hash_str := to_char(v_wlji_org_id(v_idx))
8739: ||v_wlji_class_code(v_idx);
8740: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8741: if WSMPLCVA.v_class_code.exists(hash_value) then
8742: NULL;
8743: else
8744: raise no_data_found;
8745: end if;

Line 8851: l_xst := WSMPLCVA.v_user.exists(

8847: if v_wlji_mode_flag(v_idx) = 2 then
8848: l_stmt_num := 400;
8849: -- last_updated_by
8850: l_num_records := 0;
8851: l_xst := WSMPLCVA.v_user.exists(
8852: v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by);
8853: if l_xst = false then
8854: begin
8855: select 1

Line 8875: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by)

8871: end;
8872: end if;
8873:
8874: if l_xst = false AND l_num_records <> 0 then
8875: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by)
8876: := v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by;
8877: end if;
8878: l_stmt_num := 410;
8879: -- wsli.created_by

Line 8881: l_xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_src_line_id(v_idx)).created_by);

8877: end if;
8878: l_stmt_num := 410;
8879: -- wsli.created_by
8880: l_num_records := 0;
8881: l_xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_src_line_id(v_idx)).created_by);
8882: if l_xst = false then
8883: begin
8884: select 1
8885: into l_num_records

Line 8904: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).created_by)

8900: end;
8901: end if;
8902:
8903: if l_xst = false AND l_num_records <> 0 then
8904: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).created_by)
8905: := v_wsli(v_wlji_src_line_id(v_idx)).created_by;
8906: end if;
8907:
8908: l_stmt_num := 420;

Line 9156: if WSMPLCVA.v_subinv.exists(hash_value) then

9152:
9153: hash_str := to_char(v_wlji_org_id(v_idx))
9154: ||v_wlji_compl_subinv(v_idx);
9155: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9156: if WSMPLCVA.v_subinv.exists(hash_value) then
9157: NULL;
9158: else
9159: l_aux_mesg := '';
9160: handle_invalid_field(

Line 9345: if WSMPLCVA.v_subinv.exists(hash_value) then

9341:
9342: hash_str := to_char(v_wlji_org_id(v_idx))
9343: ||v_wlji_compl_subinv(v_idx);
9344: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9345: if WSMPLCVA.v_subinv.exists(hash_value) then
9346: NULL;
9347: else
9348: l_aux_mesg := '';
9349: handle_invalid_field(

Line 9985: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME

9981: -- 1. user updates only status from unreleased to released, quantity unchanged
9982: -- 2. user updates only quantity (increases) for a released job, status is unchanged
9983: -- 3. user updates staus to released, and increases quantity.
9984:
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(

Line 10357: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME,

10353: p_overcompl_tol_type => v_wlji_overcompl_tol_type(v_idx),
10354: p_overcompl_tol_value => v_wlji_overcompl_tol_value(v_idx),
10355: p_end_item_unit_number => v_wlji_end_item_unit_number(v_idx),
10356: p_src_client_server => 0,
10357: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME,
10358: p_date_released => v_wlji_date_released(v_idx),
10359: p_error_code => l_error_code,
10360: p_error_msg => l_error_msg);
10361: g_skip_wlbj := NULL; --OPTII-PERF

Line 10814: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME

10810: p_error_code => l_error_code,
10811: p_error_msg => l_error_msg,
10812: -- BA:bug 3311985, call build_job_detail_info with new parameter
10813: p_src_client_server => 0,
10814: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME
10815: -- EA:bug 3311985, call build_job_detail_info with new parameter
10816: );
10817: if l_error_code <> 0 then
10818: handle_error(l_error_code, l_error_msg, l_stmt_num);

Line 11613: IF WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS is null OR

11609: ---------------------------------------------------
11610: -- {{{ Begin: material transaction for mode 2 jobs
11611: ---------------------------------------------------
11612: if v_wlji_mode_flag(v_idx) = 2 then
11613: IF WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS is null OR
11614: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS = 0
11615: then
11616: l_error_code := -1;
11617: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);

Line 11614: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS = 0

11610: -- {{{ Begin: material transaction for mode 2 jobs
11611: ---------------------------------------------------
11612: if v_wlji_mode_flag(v_idx) = 2 then
11613: IF WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS is null OR
11614: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS = 0
11615: then
11616: l_error_code := -1;
11617: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11618: GOTO skip_mat_trans;

Line 11620: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL is null then

11616: l_error_code := -1;
11617: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11618: GOTO skip_mat_trans;
11619: end if;
11620: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL is null then
11621: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL := 1;
11622: end if;
11623:
11624: l_stmt_num := 1010;

Line 11621: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL := 1;

11617: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11618: GOTO skip_mat_trans;
11619: end if;
11620: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL is null then
11621: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL := 1;
11622: end if;
11623:
11624: l_stmt_num := 1010;
11625: Begin -- material transaction

Line 11677: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS,

11673: 35, -- Transaction_Type_Id
11674: 1, -- Transaction_Action_Id
11675: 5, -- Transaction_Source_Type_Id
11676: SYSDATE, -- Transaction_Date
11677: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS,
11678: 'WSM', -- Source_Code
11679: to_char(v_wlji_src_line_id(v_idx)),
11680: 5, -- Wip_Entity_Type
11681: 1, -- Neg Req Flag