DBA Data[Home] [Help]

APPS.WIP_JSI_PROCESSOR dependencies on WIP_PICKING_PUB

Line 27: l_allocTbl wip_picking_pub.allocate_tbl_t;

23: l_plan_maint varchar2(1);
24: l_status VARCHAR2(1);
25: l_msg_data VARCHAR2(2000);
26: l_move_order_required VARCHAR2(1);
27: l_allocTbl wip_picking_pub.allocate_tbl_t;
28: l_task_id NUMBER;
29: l_project_id NUMBER;
30:
31: BEGIN

Line 644: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and

640: ) ;
641: end if ;
642:
643: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and
644: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and
645: x_old_start_quantity <> x_new_start_quantity) then
646: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
647: wip_jsi_utils.record_current_error(TRUE);
648:

Line 649: wip_picking_pub.Update_Job_BackOrdQty (p_wip_entity_id => x_entity_id,

645: x_old_start_quantity <> x_new_start_quantity) then
646: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
647: wip_jsi_utils.record_current_error(TRUE);
648:
649: wip_picking_pub.Update_Job_BackOrdQty (p_wip_entity_id => x_entity_id,
650: p_repetitive_schedule_id => x_rep_sched_id,
651: p_new_job_qty => x_new_start_quantity,
652: x_return_status => l_status,
653: x_msg_data => l_msg_data);

Line 658: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);

654:
655: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
656: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
657: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
658: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
659: wip_jsi_utils.record_current_error;
660: end if;
661: end if;
662:

Line 673: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);

669: x_msg_data => l_msg_data);
670: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
671: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
672: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
673: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
674: wip_jsi_utils.record_current_error;
675: end if;
676: end if;
677: