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.WSMPJUPD dependencies on WIP_CONSTANTS

Line 2087: WIP_CONSTANTS.QUEUE,

2083: -- ST : Added the below for bug fix : 4619823
2084: (case
2085: when (wro.operation_seq_num = p_curr_op_seq_num)
2086: then decode(p_txn_intraop_step,
2087: WIP_CONSTANTS.QUEUE,
2088: ROUND( ( (wro.quantity_per_assembly/nvl(wro.component_yield_factor,1)) --LBM enh
2089: *
2090: decode(p_new_rj_qty_tbl(l_job_counter),
2091: 0, 0,

Line 2100: WIP_CONSTANTS.TOMOVE,0)

2096: )
2097: )
2098: , 6
2099: ), --LBM enh
2100: WIP_CONSTANTS.TOMOVE,0)
2101: else
2102: 0
2103: end
2104: ),

Line 2375: AND ( (p_txn_job_intraop = WIP_CONSTANTS.QUEUE

2371: UPDATE wip_operations wo
2372: SET wsm_costed_quantity_completed = decode(wo.count_point_type,3,0, --changed to costed qty completed as part of MES actual qty changes(AH)
2373: wsm_costed_quantity_completed - p_sj_avail_qty_tbl(l_job_counter) + p_new_job_qty_tbl(l_job_counter))
2374: WHERE wip_entity_id = p_wip_entity_id_tbl(l_job_counter)
2375: AND ( (p_txn_job_intraop = WIP_CONSTANTS.QUEUE
2376: AND operation_seq_num < p_txn_job_op_seq_tbl(l_job_counter))
2377: OR
2378: (p_txn_job_intraop = WIP_CONSTANTS.TOMOVE
2379: AND operation_seq_num <= p_txn_job_op_seq_tbl(l_job_counter))

Line 2378: (p_txn_job_intraop = WIP_CONSTANTS.TOMOVE

2374: WHERE wip_entity_id = p_wip_entity_id_tbl(l_job_counter)
2375: AND ( (p_txn_job_intraop = WIP_CONSTANTS.QUEUE
2376: AND operation_seq_num < p_txn_job_op_seq_tbl(l_job_counter))
2377: OR
2378: (p_txn_job_intraop = WIP_CONSTANTS.TOMOVE
2379: AND operation_seq_num <= p_txn_job_op_seq_tbl(l_job_counter))
2380: );
2381:
2382: -- Update WRO using the new qty

Line 3052: IF (l_job_intra_op = WIP_CONSTANTS.QUEUE) THEN

3048:
3049: l_stmt_num := 30;
3050: l_op_seq_num := p_rj_job_rec.STARTING_OPERATION_SEQ_NUM;
3051:
3052: IF (l_job_intra_op = WIP_CONSTANTS.QUEUE) THEN
3053:
3054: l_stmt_num := 40;
3055: x_err_code := 0;
3056: x_err_buf := null;

Line 3200: ELSIF (l_job_intra_op = WIP_CONSTANTS.TOMOVE) THEN

3196:
3197: --=== END: OBSOLETE THE OPERATIONS ===--
3198: -- Start : Additions for APS-WLT--
3199:
3200: ELSIF (l_job_intra_op = WIP_CONSTANTS.TOMOVE) THEN
3201: l_stmt_num := 61;
3202:
3203: l_job_op_start_dt := l_job_op_comp_dt; --Bug 3318382
3204:

Line 3701: if (l_po_creation_time <> WIP_CONSTANTS.MANUAL_CREATION) then

3697: THEN
3698:
3699: WSMPJUPD.g_osp_exists := 1;
3700:
3701: if (l_po_creation_time <> WIP_CONSTANTS.MANUAL_CREATION) then
3702: --if l_request_id is null means online processing so launch import req
3703: -- (i.e) not from the Interface
3704: --Bug 5263262: During online processing l_request_id will be
3705: ---1.Hence check on -1 is also included in the if condition below.

Line 3713: P_Run_ReqImport => WIP_CONSTANTS.YES);

3709: P_Organization_Id => l_org_id,
3710: P_Repetitive_Schedule_Id => null,
3711: P_Operation_Seq_Num => l_new_op_added,
3712: P_Resource_Seq_Num => null,
3713: P_Run_ReqImport => WIP_CONSTANTS.YES);
3714: else
3715: l_stmt_num := 227;
3716: wip_osp.create_requisition( P_Wip_Entity_Id => l_wip_entity_id,
3717: P_Organization_Id => l_org_id,

Line 3721: P_Run_ReqImport => WIP_CONSTANTS.NO);

3717: P_Organization_Id => l_org_id,
3718: P_Repetitive_Schedule_Id => null,
3719: P_Operation_Seq_Num => l_new_op_added,
3720: P_Resource_Seq_Num => null,
3721: P_Run_ReqImport => WIP_CONSTANTS.NO);
3722: end if;
3723: end if;
3724:
3725: END IF;

Line 4047: if p_wltx_resulting_jobs_tbl(l_rj_counter).job_type = WIP_CONSTANTS.STANDARD then

4043: l_stmt_num := 20;
4044:
4045: l_rj_counter := p_wltx_resulting_jobs_tbl.first;
4046:
4047: if p_wltx_resulting_jobs_tbl(l_rj_counter).job_type = WIP_CONSTANTS.STANDARD then
4048: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4049: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4050: else
4051: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).routing_reference_id;

Line 4311: if p_wltx_resulting_jobs_tbl(l_job_counter).job_type = WIP_CONSTANTS.STANDARD then

4307:
4308: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4309: l_stmt_num := 110;
4310:
4311: if p_wltx_resulting_jobs_tbl(l_job_counter).job_type = WIP_CONSTANTS.STANDARD then
4312: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4313: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4314: else
4315: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).routing_reference_id;

Line 4445: if p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).job_type = WIP_CONSTANTS.STANDARD then

4441:
4442: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4443: l_stmt_num := 140;
4444:
4445: if p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).job_type = WIP_CONSTANTS.STANDARD then
4446: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4447: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4448: else
4449: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).routing_reference_id;

Line 4646: SELECT decode(on_rec_path, 'Y', WIP_CONSTANTS.FORWARDS, WIP_CONSTANTS.CURRENT_OP)

4642: l_stmt_num := 10;
4643:
4644: -- ST : Fix for bug 5181364
4645: -- Changed the scheduling path to forwards scheduling instead of midpoint forward
4646: SELECT decode(on_rec_path, 'Y', WIP_CONSTANTS.FORWARDS, WIP_CONSTANTS.CURRENT_OP)
4647: INTO l_schedule_mode
4648: FROM WSM_LOT_BASED_JOBS
4649: WHERE wip_entity_id = p_par_we_id;
4650:

Line 5045: p_status_type => WIP_CONSTANTS.RELEASED,

5041: WSMPLBJI.build_lbji_info
5042: (p_routing_seq_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_routing_sequence_id,
5043: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id,
5044: p_explode_header_detail => 2, --This creates header only (WE, WDJ, WPB)
5045: p_status_type => WIP_CONSTANTS.RELEASED,
5046: p_class_code => p_wltx_starting_jobs_tbl(l_rep_sj_index).class_code,
5047: p_org => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id,
5048: p_wip_entity_id => l_new_we_id, -- this is returned by the API
5049: p_last_updt_date => sysdate,

Line 5178: p_status_type => WIP_CONSTANTS.RELEASED,

5174: -- Create Job Header ONLY
5175: WSM_lbj_interface_PVT.build_job_header_info
5176: (p_common_routing_sequence_id=> p_wltx_resulting_jobs_tbl(l_job_counter).common_routing_sequence_id,
5177: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id,
5178: p_status_type => WIP_CONSTANTS.RELEASED,
5179: p_class_code => p_wltx_starting_jobs_tbl(l_rep_sj_index).class_code,
5180: p_org_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id,
5181: p_wip_entity_id => l_new_we_id, -- this is returned by the API
5182: p_last_updt_date => sysdate,

Line 6538: l_txn_status := WIP_CONSTANTS.COMPLETED;

6534:
6535: l_stmt_num := 400;
6536:
6537:
6538: l_txn_status := WIP_CONSTANTS.COMPLETED;
6539: l_txn_costed := WIP_CONSTANTS.pending;
6540:
6541: elsif p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) then
6542:

Line 6539: l_txn_costed := WIP_CONSTANTS.pending;

6535: l_stmt_num := 400;
6536:
6537:
6538: l_txn_status := WIP_CONSTANTS.COMPLETED;
6539: l_txn_costed := WIP_CONSTANTS.pending;
6540:
6541: elsif p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) then
6542:
6543: l_stmt_num := 500;

Line 6626: l_txn_status := WIP_CONSTANTS.COMPLETED;

6622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6623: END IF;
6624: end if;
6625:
6626: l_txn_status := WIP_CONSTANTS.COMPLETED;
6627: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6628:
6629:
6630: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then

Line 6627: l_txn_costed := WIP_CONSTANTS.COMPLETED;

6623: END IF;
6624: end if;
6625:
6626: l_txn_status := WIP_CONSTANTS.COMPLETED;
6627: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6628:
6629:
6630: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then
6631:

Line 6828: if (l_po_creation_time <> WIP_CONSTANTS.MANUAL_CREATION) then

6824: THEN
6825:
6826: WSMPJUPD.g_osp_exists := 1;
6827:
6828: if (l_po_creation_time <> WIP_CONSTANTS.MANUAL_CREATION) then
6829:
6830: l_stmt_num := 253;
6831:
6832: wip_osp.create_additional_req ( P_Wip_Entity_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

Line 6962: l_txn_status := WIP_CONSTANTS.COMPLETED;

6958:
6959: l_stmt_num := 400;
6960:
6961:
6962: l_txn_status := WIP_CONSTANTS.COMPLETED;
6963: l_txn_costed := WIP_CONSTANTS.pending;
6964:
6965: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
6966:

Line 6963: l_txn_costed := WIP_CONSTANTS.pending;

6959: l_stmt_num := 400;
6960:
6961:
6962: l_txn_status := WIP_CONSTANTS.COMPLETED;
6963: l_txn_costed := WIP_CONSTANTS.pending;
6964:
6965: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
6966:
6967: l_stmt_num := 550;

Line 7013: l_txn_status := WIP_CONSTANTS.COMPLETED;

7009: set wip_entity_name = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_name,
7010: description = p_wltx_resulting_jobs_tbl(l_rj_index).description
7011: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
7012:
7013: l_txn_status := WIP_CONSTANTS.COMPLETED;
7014: l_txn_costed := WIP_CONSTANTS.COMPLETED;
7015:
7016: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
7017: if p_wltx_resulting_jobs_tbl.count > 0 then

Line 7014: l_txn_costed := WIP_CONSTANTS.COMPLETED;

7010: description = p_wltx_resulting_jobs_tbl(l_rj_index).description
7011: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
7012:
7013: l_txn_status := WIP_CONSTANTS.COMPLETED;
7014: l_txn_costed := WIP_CONSTANTS.COMPLETED;
7015:
7016: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
7017: if p_wltx_resulting_jobs_tbl.count > 0 then
7018: l_rj_index := p_wltx_resulting_jobs_tbl.first;

Line 7058: p_status_type => WIP_CONSTANTS.RELEASED,

7054: WSMPLBJI.build_lbji_info
7055: (p_routing_seq_id => p_wltx_resulting_jobs_tbl(l_rj_index).common_routing_sequence_id,
7056: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_rj_index).common_bom_sequence_id,
7057: p_explode_header_detail => null,
7058: p_status_type => WIP_CONSTANTS.RELEASED,
7059: p_class_code => p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
7060: p_org => p_wltx_resulting_jobs_tbl(l_rj_index).organization_id,
7061: p_wip_entity_id => l_new_we_id, -- this is returned by the API
7062: p_last_updt_date => sysdate,

Line 7441: l_txn_status := WIP_CONSTANTS.COMPLETED;

7437:
7438: -- End MES changes--
7439: l_stmt_num := 400;
7440:
7441: l_txn_status := WIP_CONSTANTS.COMPLETED;
7442: l_txn_costed := WIP_CONSTANTS.pending;
7443:
7444: else
7445: -- error out....

Line 7442: l_txn_costed := WIP_CONSTANTS.pending;

7438: -- End MES changes--
7439: l_stmt_num := 400;
7440:
7441: l_txn_status := WIP_CONSTANTS.COMPLETED;
7442: l_txn_costed := WIP_CONSTANTS.pending;
7443:
7444: else
7445: -- error out....
7446: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN