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 3197: ELSIF (l_job_intra_op = WIP_CONSTANTS.TOMOVE) THEN

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

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

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

Line 3707: P_Run_ReqImport => WIP_CONSTANTS.YES);

3703: P_Organization_Id => l_org_id,
3704: P_Repetitive_Schedule_Id => null,
3705: P_Operation_Seq_Num => l_new_op_added,
3706: P_Resource_Seq_Num => null,
3707: P_Run_ReqImport => WIP_CONSTANTS.YES);
3708: else
3709: l_stmt_num := 227;
3710: wip_osp.create_requisition( P_Wip_Entity_Id => l_wip_entity_id,
3711: P_Organization_Id => l_org_id,

Line 3715: P_Run_ReqImport => WIP_CONSTANTS.NO);

3711: P_Organization_Id => l_org_id,
3712: P_Repetitive_Schedule_Id => null,
3713: P_Operation_Seq_Num => l_new_op_added,
3714: P_Resource_Seq_Num => null,
3715: P_Run_ReqImport => WIP_CONSTANTS.NO);
3716: end if;
3717: end if;
3718:
3719: END IF;

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

4037: l_stmt_num := 20;
4038:
4039: l_rj_counter := p_wltx_resulting_jobs_tbl.first;
4040:
4041: if p_wltx_resulting_jobs_tbl(l_rj_counter).job_type = WIP_CONSTANTS.STANDARD then
4042: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4043: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).primary_item_id;
4044: else
4045: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_rj_counter).routing_reference_id;

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

4299:
4300: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4301: l_stmt_num := 110;
4302:
4303: if p_wltx_resulting_jobs_tbl(l_job_counter).job_type = WIP_CONSTANTS.STANDARD then
4304: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4305: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).primary_item_id;
4306: else
4307: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(l_job_counter).routing_reference_id;

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

4433:
4434: IF (p_copy_mode = 1) THEN -- Make copies after each transaction
4435: l_stmt_num := 140;
4436:
4437: if p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).job_type = WIP_CONSTANTS.STANDARD then
4438: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4439: l_res_bill_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).primary_item_id;
4440: else
4441: l_res_rtg_item_id := p_wltx_resulting_jobs_tbl(p_sj_as_rj_index).routing_reference_id;

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

4634: l_stmt_num := 10;
4635:
4636: -- ST : Fix for bug 5181364
4637: -- Changed the scheduling path to forwards scheduling instead of midpoint forward
4638: SELECT decode(on_rec_path, 'Y', WIP_CONSTANTS.FORWARDS, WIP_CONSTANTS.CURRENT_OP)
4639: INTO l_schedule_mode
4640: FROM WSM_LOT_BASED_JOBS
4641: WHERE wip_entity_id = p_par_we_id;
4642:

Line 4981: p_status_type => WIP_CONSTANTS.RELEASED,

4977: WSMPLBJI.build_lbji_info
4978: (p_routing_seq_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_routing_sequence_id,
4979: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id,
4980: p_explode_header_detail => 2, --This creates header only (WE, WDJ, WPB)
4981: p_status_type => WIP_CONSTANTS.RELEASED,
4982: p_class_code => p_wltx_starting_jobs_tbl(l_rep_sj_index).class_code,
4983: p_org => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id,
4984: p_wip_entity_id => l_new_we_id, -- this is returned by the API
4985: p_last_updt_date => sysdate,

Line 5114: p_status_type => WIP_CONSTANTS.RELEASED,

5110: -- Create Job Header ONLY
5111: WSM_lbj_interface_PVT.build_job_header_info
5112: (p_common_routing_sequence_id=> p_wltx_resulting_jobs_tbl(l_job_counter).common_routing_sequence_id,
5113: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_job_counter).common_bom_sequence_id,
5114: p_status_type => WIP_CONSTANTS.RELEASED,
5115: p_class_code => p_wltx_starting_jobs_tbl(l_rep_sj_index).class_code,
5116: p_org_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).organization_id,
5117: p_wip_entity_id => l_new_we_id, -- this is returned by the API
5118: p_last_updt_date => sysdate,

Line 6474: l_txn_status := WIP_CONSTANTS.COMPLETED;

6470:
6471: l_stmt_num := 400;
6472:
6473:
6474: l_txn_status := WIP_CONSTANTS.COMPLETED;
6475: l_txn_costed := WIP_CONSTANTS.pending;
6476:
6477: elsif p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) then
6478:

Line 6475: l_txn_costed := WIP_CONSTANTS.pending;

6471: l_stmt_num := 400;
6472:
6473:
6474: l_txn_status := WIP_CONSTANTS.COMPLETED;
6475: l_txn_costed := WIP_CONSTANTS.pending;
6476:
6477: elsif p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_ASSEMBLY,WSMPCNST.UPDATE_ROUTING) then
6478:
6479: l_stmt_num := 500;

Line 6562: l_txn_status := WIP_CONSTANTS.COMPLETED;

6558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6559: END IF;
6560: end if;
6561:
6562: l_txn_status := WIP_CONSTANTS.COMPLETED;
6563: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6564:
6565:
6566: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then

Line 6563: l_txn_costed := WIP_CONSTANTS.COMPLETED;

6559: END IF;
6560: end if;
6561:
6562: l_txn_status := WIP_CONSTANTS.COMPLETED;
6563: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6564:
6565:
6566: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then
6567:

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

6760: THEN
6761:
6762: WSMPJUPD.g_osp_exists := 1;
6763:
6764: if (l_po_creation_time <> WIP_CONSTANTS.MANUAL_CREATION) then
6765:
6766: l_stmt_num := 253;
6767:
6768: wip_osp.create_additional_req ( P_Wip_Entity_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,

Line 6898: l_txn_status := WIP_CONSTANTS.COMPLETED;

6894:
6895: l_stmt_num := 400;
6896:
6897:
6898: l_txn_status := WIP_CONSTANTS.COMPLETED;
6899: l_txn_costed := WIP_CONSTANTS.pending;
6900:
6901: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
6902:

Line 6899: l_txn_costed := WIP_CONSTANTS.pending;

6895: l_stmt_num := 400;
6896:
6897:
6898: l_txn_status := WIP_CONSTANTS.COMPLETED;
6899: l_txn_costed := WIP_CONSTANTS.pending;
6900:
6901: elsif p_wltx_header.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
6902:
6903: l_stmt_num := 550;

Line 6949: l_txn_status := WIP_CONSTANTS.COMPLETED;

6945: set wip_entity_name = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_name,
6946: description = p_wltx_resulting_jobs_tbl(l_rj_index).description
6947: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
6948:
6949: l_txn_status := WIP_CONSTANTS.COMPLETED;
6950: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6951:
6952: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
6953: if p_wltx_resulting_jobs_tbl.count > 0 then

Line 6950: l_txn_costed := WIP_CONSTANTS.COMPLETED;

6946: description = p_wltx_resulting_jobs_tbl(l_rj_index).description
6947: where wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_index).wip_entity_id;
6948:
6949: l_txn_status := WIP_CONSTANTS.COMPLETED;
6950: l_txn_costed := WIP_CONSTANTS.COMPLETED;
6951:
6952: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
6953: if p_wltx_resulting_jobs_tbl.count > 0 then
6954: l_rj_index := p_wltx_resulting_jobs_tbl.first;

Line 6994: p_status_type => WIP_CONSTANTS.RELEASED,

6990: WSMPLBJI.build_lbji_info
6991: (p_routing_seq_id => p_wltx_resulting_jobs_tbl(l_rj_index).common_routing_sequence_id,
6992: p_common_bill_sequence_id => p_wltx_resulting_jobs_tbl(l_rj_index).common_bom_sequence_id,
6993: p_explode_header_detail => null,
6994: p_status_type => WIP_CONSTANTS.RELEASED,
6995: p_class_code => p_wltx_resulting_jobs_tbl(l_rj_index).class_code,
6996: p_org => p_wltx_resulting_jobs_tbl(l_rj_index).organization_id,
6997: p_wip_entity_id => l_new_we_id, -- this is returned by the API
6998: p_last_updt_date => sysdate,

Line 7377: l_txn_status := WIP_CONSTANTS.COMPLETED;

7373:
7374: -- End MES changes--
7375: l_stmt_num := 400;
7376:
7377: l_txn_status := WIP_CONSTANTS.COMPLETED;
7378: l_txn_costed := WIP_CONSTANTS.pending;
7379:
7380: else
7381: -- error out....

Line 7378: l_txn_costed := WIP_CONSTANTS.pending;

7374: -- End MES changes--
7375: l_stmt_num := 400;
7376:
7377: l_txn_status := WIP_CONSTANTS.COMPLETED;
7378: l_txn_costed := WIP_CONSTANTS.pending;
7379:
7380: else
7381: -- error out....
7382: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN