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 1009: l_xst := WSMPLCVA.v_org.exists(p_org_id);

1005:
1006: l_stmt_num := 30;
1007: -- now p_org_id is always available
1008: l_xst := true;
1009: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1010: if l_xst = false then
1011: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1012: fnd_message.set_token('FLD_NAME', 'Organization ID');
1013: x_error_msg := fnd_message.get;

Line 6371: WSMPLCVA.load_org_table;

6367: --fnd_global.apps_initialize(l_user_id, l_resp_id, l_resp_appl_id);
6368:
6369: l_stmt_num := 20;
6370: -- load organization PL/SQL table
6371: WSMPLCVA.load_org_table;
6372:
6373: ----------------------------------------------------------------
6374: -- {{ Check PENDING WLJI records, validate org, job id/name
6375: ----------------------------------------------------------------

Line 7189: WSMPLCVA.load_org_table;

7185: -- ==============================================================================================
7186:
7187: begin
7188: l_stmt_num := 10;
7189: WSMPLCVA.load_org_table;
7190:
7191: l_stmt_num := 20;
7192: WSMPLCVA.load_subinventory;
7193:

Line 7192: WSMPLCVA.load_subinventory;

7188: l_stmt_num := 10;
7189: WSMPLCVA.load_org_table;
7190:
7191: l_stmt_num := 20;
7192: WSMPLCVA.load_subinventory;
7193:
7194: l_stmt_num := 30;
7195: WSMPLCVA.load_class_code;
7196: if lbji_debug = 'Y' then

Line 7195: WSMPLCVA.load_class_code;

7191: l_stmt_num := 20;
7192: WSMPLCVA.load_subinventory;
7193:
7194: l_stmt_num := 30;
7195: WSMPLCVA.load_class_code;
7196: if lbji_debug = 'Y' then
7197: fnd_file.put_line(fnd_file.log,
7198: 'Loading org/subinv/class-code values into memory (once per worker).. OK.');
7199: end if;

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

8098: if v_wlji_last_updt_by(v_idx) is NULL then
8099: v_wlji_last_updt_by(v_idx) := l_user;
8100: else
8101: l_num_records := 0;
8102: l_xst := WSMPLCVA.v_user.exists(v_wlji_last_updt_by(v_idx));
8103: if l_xst = false then
8104: begin
8105: select 1
8106: into l_num_records

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

8117: end;
8118: end if;
8119:
8120: if l_xst = false AND l_num_records <> 0 then
8121: WSMPLCVA.v_user(v_wlji_last_updt_by(v_idx))
8122: := v_wlji_last_updt_by(v_idx);
8123: end if;
8124:
8125: if l_error_code <> 0 then

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

8136: if v_wlji_created_by(v_idx) is NULL then
8137: v_wlji_created_by(v_idx) := l_user;
8138: else
8139: l_num_records := 0;
8140: l_xst := WSMPLCVA.v_user.exists(v_wlji_created_by(v_idx));
8141: if l_xst = false then
8142: begin
8143: select 1
8144: into l_num_records

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

8155: end;
8156: end if;
8157:
8158: if l_xst = false AND l_num_records <> 0 then
8159: WSMPLCVA.v_user(v_wlji_created_by(v_idx))
8160: := v_wlji_created_by(v_idx);
8161: end if;
8162:
8163: if l_error_code <> 0 then

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

8300: l_stmt_num := 280;
8301: -- Validate coproduct-supply flag (creation)
8302: IF v_wlji_coproducts_supply(v_idx) is NULL THEN
8303: v_wlji_coproducts_supply(v_idx)
8304: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).COPRODUCTS_SUPPLY_DEFAULT;
8305: --Bug 5463925: OR is replaced by AND.
8306: --ELSIF (v_wlji_coproducts_supply(v_idx) <> 1 OR
8307: ELSIF (v_wlji_coproducts_supply(v_idx) <> 1 AND
8308: v_wlji_coproducts_supply(v_idx) <> 2) THEN

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

8424:
8425: l_stmt_num := 310;
8426: -- {{ Validate item id (std job creation)
8427: if v_wlji_mode_flag(v_idx) = 1 then
8428: l_xst := WSMPLCVA.v_item.exists(v_wlji_item_id(v_idx));
8429: else -- mode flag 2
8430: hash_str := to_char(v_wlji_item_id(v_idx)) ||
8431: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8432: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);

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

8430: hash_str := to_char(v_wlji_item_id(v_idx)) ||
8431: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8432: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8433:
8434: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8435: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8436: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8437: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8438: = v_wlji_item_id(v_idx));

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

8431: to_char(v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id);
8432: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8433:
8434: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8435: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8436: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8437: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8438: = v_wlji_item_id(v_idx));
8439: end if;

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

8433:
8434: l_xst := WSMPLCVA.v_mode2_item.exists(hash_value) AND
8435: (WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8436: = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id) AND
8437: (WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8438: = v_wlji_item_id(v_idx));
8439: end if;
8440: l_stmt_num := 310.1;
8441: if l_xst = false then

Line 8484: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID

8480: end if; -- l_xst = false
8481:
8482: if l_xst = false AND l_num_records <> 0 then
8483: if v_wlji_mode_flag(v_idx) = 2 then
8484: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8485: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8486: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8487: := v_wlji_item_id(v_idx);
8488: else -- mode flag = 1

Line 8486: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID

8482: if l_xst = false AND l_num_records <> 0 then
8483: if v_wlji_mode_flag(v_idx) = 2 then
8484: WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID
8485: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8486: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8487: := v_wlji_item_id(v_idx);
8488: else -- mode flag = 1
8489: WSMPLCVA.v_item(v_wlji_item_id(v_idx)) := v_wlji_item_id(v_idx);
8490: end if;

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

8485: := v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
8486: WSMPLCVA.v_mode2_item(hash_value).PRIMARY_ITEM_ID
8487: := v_wlji_item_id(v_idx);
8488: else -- mode flag = 1
8489: WSMPLCVA.v_item(v_wlji_item_id(v_idx)) := v_wlji_item_id(v_idx);
8490: end if;
8491: end if;
8492:
8493: if l_error_code <> 0 then

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

8627: -- {{ validation of subinv begin
8628: hash_str := to_char(v_wlji_org_id(v_idx))
8629: ||v_wlji_compl_subinv(v_idx);
8630: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8631: if WSMPLCVA.v_subinv.exists(hash_value) then
8632: NULL;
8633: else
8634: l_aux_mesg := '';
8635: handle_invalid_field(

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

8823: end;
8824:
8825: IF v_wlji_class_code(v_idx) is NULL then
8826: v_wlji_class_code(v_idx)
8827: := WSMPLCVA.v_org(v_wlji_org_id(v_idx)).DEFAULT_ACCT_CLASS_CODE;
8828: END IF;
8829: END IF;
8830:
8831: IF v_wlji_class_code(v_idx) IS NULL THEN

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

8835: ELSE
8836: hash_str := to_char(v_wlji_org_id(v_idx))
8837: ||v_wlji_class_code(v_idx);
8838: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
8839: if WSMPLCVA.v_class_code.exists(hash_value) then
8840: NULL;
8841: else
8842: raise no_data_found;
8843: end if;

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

8945: if v_wlji_mode_flag(v_idx) = 2 then
8946: l_stmt_num := 400;
8947: -- last_updated_by
8948: l_num_records := 0;
8949: l_xst := WSMPLCVA.v_user.exists(
8950: v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by);
8951: if l_xst = false then
8952: begin
8953: select 1

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

8969: end;
8970: end if;
8971:
8972: if l_xst = false AND l_num_records <> 0 then
8973: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by)
8974: := v_wsli(v_wlji_src_line_id(v_idx)).last_updated_by;
8975: end if;
8976: l_stmt_num := 410;
8977: -- wsli.created_by

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

8975: end if;
8976: l_stmt_num := 410;
8977: -- wsli.created_by
8978: l_num_records := 0;
8979: l_xst := WSMPLCVA.v_user.exists(v_wsli(v_wlji_src_line_id(v_idx)).created_by);
8980: if l_xst = false then
8981: begin
8982: select 1
8983: into l_num_records

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

8998: end;
8999: end if;
9000:
9001: if l_xst = false AND l_num_records <> 0 then
9002: WSMPLCVA.v_user(v_wsli(v_wlji_src_line_id(v_idx)).created_by)
9003: := v_wsli(v_wlji_src_line_id(v_idx)).created_by;
9004: end if;
9005:
9006: l_stmt_num := 420;

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

9250:
9251: hash_str := to_char(v_wlji_org_id(v_idx))
9252: ||v_wlji_compl_subinv(v_idx);
9253: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9254: if WSMPLCVA.v_subinv.exists(hash_value) then
9255: NULL;
9256: else
9257: l_aux_mesg := '';
9258: handle_invalid_field(

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

9439:
9440: hash_str := to_char(v_wlji_org_id(v_idx))
9441: ||v_wlji_compl_subinv(v_idx);
9442: hash_value := dbms_utility.get_hash_value(hash_str, 37, 1073741824);
9443: if WSMPLCVA.v_subinv.exists(hash_value) then
9444: NULL;
9445: else
9446: l_aux_mesg := '';
9447: handle_invalid_field(

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

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

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

10451: p_overcompl_tol_type => v_wlji_overcompl_tol_type(v_idx),
10452: p_overcompl_tol_value => v_wlji_overcompl_tol_value(v_idx),
10453: p_end_item_unit_number => v_wlji_end_item_unit_number(v_idx),
10454: p_src_client_server => 0,
10455: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME,
10456: p_date_released => v_wlji_date_released(v_idx),
10457: p_error_code => l_error_code,
10458: p_error_msg => l_error_msg);
10459: g_skip_wlbj := NULL; --OPTII-PERF

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

10912: p_error_code => l_error_code,
10913: p_error_msg => l_error_msg,
10914: -- BA:bug 3311985, call build_job_detail_info with new parameter
10915: p_src_client_server => 0,
10916: p_po_creation_time => WSMPLCVA.v_org(v_wlji_org_id(v_idx)).PO_CREATION_TIME
10917: -- EA:bug 3311985, call build_job_detail_info with new parameter
10918: );
10919: if l_error_code <> 0 then
10920: handle_error(l_error_code, l_error_msg, l_stmt_num);

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

11713: ---------------------------------------------------
11714: -- {{{ Begin: material transaction for mode 2 jobs
11715: ---------------------------------------------------
11716: if v_wlji_mode_flag(v_idx) = 2 then
11717: IF WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS is null OR
11718: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS = 0
11719: then
11720: l_error_code := -1;
11721: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);

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

11714: -- {{{ Begin: material transaction for mode 2 jobs
11715: ---------------------------------------------------
11716: if v_wlji_mode_flag(v_idx) = 2 then
11717: IF WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS is null OR
11718: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS = 0
11719: then
11720: l_error_code := -1;
11721: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11722: GOTO skip_mat_trans;

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

11720: l_error_code := -1;
11721: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11722: GOTO skip_mat_trans;
11723: end if;
11724: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL is null then
11725: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL := 1;
11726: end if;
11727:
11728: l_stmt_num := 1010;

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

11721: handle_errmsg_name('WIP', 'WIP_NO_ACCT_PERIOD', l_stmt_num);
11722: GOTO skip_mat_trans;
11723: end if;
11724: if WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL is null then
11725: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_STK_LOC_CNTRL := 1;
11726: end if;
11727:
11728: l_stmt_num := 1010;
11729: Begin -- material transaction

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

11777: 35, -- Transaction_Type_Id
11778: 1, -- Transaction_Action_Id
11779: 5, -- Transaction_Source_Type_Id
11780: SYSDATE, -- Transaction_Date
11781: WSMPLCVA.v_org(v_wlji_org_id(v_idx)).MAX_ORG_ACC_PERIODS,
11782: 'WSM', -- Source_Code
11783: to_char(v_wlji_src_line_id(v_idx)),
11784: 5, -- Wip_Entity_Type
11785: 1, -- Neg Req Flag