[Home] [Help]
710: raise fnd_api.g_exc_unexpected_error;
711: elsif(wjsi_row.load_type = wip_constants.create_job and wjsi_row.start_quantity = 0) then
712: raise fnd_api.g_exc_unexpected_error;
713: elsif(wjsi_row.load_type = wip_constants.resched_job) then
714: if(wjsi_row.start_quantity = 0 and wdj_row.job_type = wip_constants.standard) then
715: raise fnd_api.g_exc_unexpected_error;
716: elsif(wjsi_row.start_quantity < wdj_row.quantity_completed) then
717: l_msg := 'WIP_ML_RESCHEDULE_QUANTITY';
718: raise fnd_api.g_exc_unexpected_error;
743: --can't have net qty when creating a ns job w/no item or rescheduling a ns job w/no item
744: elsif(wjsi_row.net_quantity is not null and wjsi_row.net_quantity <> 0 and
745: ((wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.primary_item_id is null) or
746: (wjsi_row.load_type = wip_constants.resched_job and
747: wdj_row.job_type = wip_constants.nonstandard and
748: wdj_row.primary_item_id is null))) then
749: raise fnd_api.g_exc_unexpected_error;
750: end if;
751: end if;
758:
759: procedure firm_planned_flag is begin
760: if((wjsi_row.firm_planned_flag = wip_constants.yes and wjsi_row.load_type = wip_constants.create_ns_job) or
761: (wjsi_row.firm_planned_flag = wip_constants.yes and
762: wdj_row.job_type = wip_constants.nonstandard and
763: wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) or
764: (wjsi_row.firm_planned_flag not in (wip_constants.yes, wip_constants.no))) then
765: raise fnd_api.g_exc_unexpected_error;
766: end if;
1248: if(wjsi_row.alternate_routing_designator is not null) then
1249: if(wjsi_row.load_type = wip_constants.create_ns_job) then
1250: l_rtg_item_id := wjsi_row.routing_reference_id;
1251: elsif(wjsi_row.load_type = wip_constants.resched_job) then
1252: if(wdj_row.job_type = wip_constants.standard) then
1253: l_rtg_item_id := wdj_row.primary_item_id;
1254: else
1255: l_rtg_item_id := wdj_row.routing_reference_id;
1256: end if;
1285: if(wjsi_row.alternate_bom_designator is not null) then
1286: if(wjsi_row.load_type = wip_constants.create_ns_job) then
1287: l_bom_item_id := wjsi_row.bom_reference_id;
1288: elsif(wjsi_row.load_type = wip_constants.resched_job) then
1289: if(wdj_row.job_type = wip_constants.standard) then
1290: l_bom_item_id := wdj_row.primary_item_id;
1291: else
1292: l_bom_item_id := wdj_row.bom_reference_id;
1293: end if;
1403: raise fnd_api.g_exc_unexpected_error;
1404: end if;
1405:
1406: if(wjsi_row.load_type = wip_constants.resched_job and
1407: wdj_row.job_type = wip_constants.nonstandard and
1408: wdj_row.routing_reference_id is null and
1409: (l_date_count = 1)) then
1410: --when rescheduling a ns job and providing one date, it must have a routing
1411: raise fnd_api.g_exc_unexpected_error;
1657: end if;
1658: if(wjsi_row.scheduling_method = wip_constants.leadtime and
1659: ((wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.routing_reference_id is null) or
1660: (wjsi_row.load_type = wip_constants.resched_job and
1661: wdj_row.job_type = wip_constants.nonstandard and
1662: wdj_row.routing_reference_id is null))) then
1663: --can not do lead time for ns jobs that have no routing reference
1664: raise fnd_api.g_exc_unexpected_error;
1665: elsif(wjsi_row.scheduling_method = wip_constants.ml_manual) then
2122: select 1
2123: into g_dummy
2124: from dual
2125: where exists(select 1
2126: from wip_non_standard_classes_val_v
2127: where class_code = wjsi_row.class_code
2128: and organization_id = wjsi_row.organization_id);
2129:
2130: elsif(wjsi_row.load_type = wip_constants.create_eam_job) then