[Home] [Help]
121:
122: select *
123: into wjsi_row
124: from wip_job_schedule_interface
125: where rowid = wip_jsi_utils.current_rowid;
126:
127: -- Save Original org context
128: orig_org_context := nvl(fnd_profile.value('ORG_ID'), -1) ;
129:
159: setup;
160:
161: --only perform a subset of the validations, mostly those odd cases in which the validation procedures
162: --modify or insert date
163: if(wip_jsi_utils.validation_level in (wip_constants.mrp, wip_constants.ato)) then
164: job_name;
165: job_id;
166: entity_type;
167: schedule_group_id;
321: REQUEST_ID = decode(x_request_id,-1,REQUEST_ID,x_request_id),
322: PROGRAM_ID = decode(x_program_id,-1,PROGRAM_ID,x_program_id),
323: PROGRAM_UPDATE_DATE = SYSDATE,
324: PROGRAM_APPLICATION_ID = decode(x_application_id,-1,PROGRAM_APPLICATION_ID, x_application_id)
325: where rowid = wip_jsi_utils.current_rowid;
326:
327: -- Set Original org context since org context might have
328: -- different for pjm validation
329: if (orig_org_context <> -1) then
331: end if ;
332:
333: /* Fixed for Bug#3060266
334: Abort if any errors were detected. */
335: if (WIP_JSI_Utils.any_nonwarning_errors) then
336: WIP_JSI_Utils.abort_request ;
337: end if ;
338:
339: end validate;
332:
333: /* Fixed for Bug#3060266
334: Abort if any errors were detected. */
335: if (WIP_JSI_Utils.any_nonwarning_errors) then
336: WIP_JSI_Utils.abort_request ;
337: end if ;
338:
339: end validate;
340:
361: begin
362: select wip_entity_id, serialization_start_op, load_type, primary_item_id
363: into l_wipID, l_serialOp, l_loadType, l_primaryItemID
364: from wip_job_schedule_interface wjsi
365: where wjsi.rowid = wip_jsi_utils.current_rowid;
366:
367:
368: if(l_serialOp is null) then
369: --in this case, we may need to clear the serialization op if the routing was re-exploded
431: and status_type = wip_constants.unreleased;
432: end if;
433: exception
434: when others then
435: wip_jsi_utils.record_error('WIP_ML_SERIAL_START_OP');
436: wip_jsi_utils.abort_request;
437: end validate_serialization_op;
438:
439:
432: end if;
433: exception
434: when others then
435: wip_jsi_utils.record_error('WIP_ML_SERIAL_START_OP');
436: wip_jsi_utils.abort_request;
437: end validate_serialization_op;
438:
439:
440: /* private procedures */
544: raise fnd_api.g_exc_unexpected_error;
545: end if;
546: exception
547: when others then
548: wip_jsi_utils.record_error('WIP_ML_LOAD_TYPE');
549: wip_jsi_utils.abort_request;
550: end load_type;
551:
552: procedure organization_id is
545: end if;
546: exception
547: when others then
548: wip_jsi_utils.record_error('WIP_ML_LOAD_TYPE');
549: wip_jsi_utils.abort_request;
550: end load_type;
551:
552: procedure organization_id is
553: l_disable_date date;
575: raise fnd_api.g_exc_unexpected_error;
576: end if;
577: exception
578: when others then
579: wip_jsi_utils.record_error('WIP_ML_ORGANIZATION_ID');
580: wip_jsi_utils.abort_request;
581: end organization_id;
582:
583: procedure job_name is
576: end if;
577: exception
578: when others then
579: wip_jsi_utils.record_error('WIP_ML_ORGANIZATION_ID');
580: wip_jsi_utils.abort_request;
581: end organization_id;
582:
583: procedure job_name is
584: l_count NUMBER;
595: end if;
596: end if;
597: exception
598: when others then
599: wip_jsi_utils.record_error('WIP_ML_JOB_NAME');
600: wip_jsi_utils.abort_request;
601: end job_name;
602:
603: procedure entity_type is
596: end if;
597: exception
598: when others then
599: wip_jsi_utils.record_error('WIP_ML_JOB_NAME');
600: wip_jsi_utils.abort_request;
601: end job_name;
602:
603: procedure entity_type is
604: begin
609: end if;
610:
611: exception
612: when others then
613: wip_jsi_utils.record_error('WIP_ML_ENTITY_TYPE');
614: wip_jsi_utils.abort_request;
615: end entity_type;
616:
617: procedure job_id is
610:
611: exception
612: when others then
613: wip_jsi_utils.record_error('WIP_ML_ENTITY_TYPE');
614: wip_jsi_utils.abort_request;
615: end entity_type;
616:
617: procedure job_id is
618: l_count NUMBER;
627: end if;
628: end if;
629: exception
630: when others then
631: WIP_JSI_Utils.record_error('WIP_ML_WIP_ENTITY_ID') ;
632: wip_jsi_utils.abort_request;
633: end job_id;
634:
635: procedure kanban_card_id is
628: end if;
629: exception
630: when others then
631: WIP_JSI_Utils.record_error('WIP_ML_WIP_ENTITY_ID') ;
632: wip_jsi_utils.abort_request;
633: end job_id;
634:
635: procedure kanban_card_id is
636: l_doc_type NUMBER;
641: if(wjsi_row.kanban_card_id is null) then
642: return;
643: end if;
644:
645: if (wip_jsi_utils.validation_level <> wip_constants.inv) then
646: raise fnd_api.g_exc_unexpected_error;
647: end if ;
648:
649: l_msg := 'WIP_ML_KB_UPDATE_FAILED';
674: raise fnd_api.g_exc_unexpected_error;
675: end if ;
676: exception
677: when others then
678: WIP_JSI_Utils.record_error(l_msg) ;
679: WIP_JSI_Utils.abort_request ;
680: end kanban_card_id ;
681:
682: procedure created_by is begin
675: end if ;
676: exception
677: when others then
678: WIP_JSI_Utils.record_error(l_msg) ;
679: WIP_JSI_Utils.abort_request ;
680: end kanban_card_id ;
681:
682: procedure created_by is begin
683: select 1
686: where user_id = wjsi_row.created_by
687: and sysdate between start_date and nvl(end_date, sysdate);
688: exception
689: when others then
690: wip_jsi_utils.record_error('WIP_ML_CREATED_BY');
691: WIP_JSI_Utils.abort_request ;
692: end created_by;
693:
694: procedure last_updated_by is begin
687: and sysdate between start_date and nvl(end_date, sysdate);
688: exception
689: when others then
690: wip_jsi_utils.record_error('WIP_ML_CREATED_BY');
691: WIP_JSI_Utils.abort_request ;
692: end created_by;
693:
694: procedure last_updated_by is begin
695: select 1
698: where user_id = wjsi_row.last_updated_by
699: and sysdate between start_date and nvl(end_date, sysdate);
700: exception
701: when others then
702: wip_jsi_utils.record_error('WIP_ML_LAST_UPDATED_BY');
703: WIP_JSI_Utils.abort_request ;
704: end last_updated_by;
705:
706: procedure start_quantity is
699: and sysdate between start_date and nvl(end_date, sysdate);
700: exception
701: when others then
702: wip_jsi_utils.record_error('WIP_ML_LAST_UPDATED_BY');
703: WIP_JSI_Utils.abort_request ;
704: end last_updated_by;
705:
706: procedure start_quantity is
707: l_reserved_qty NUMBER;
735: end if;
736: end if;
737: exception
738: when others then
739: wip_jsi_utils.record_error(l_msg);
740: wip_jsi_utils.abort_request;
741: end start_quantity;
742:
743: procedure net_quantity is begin
736: end if;
737: exception
738: when others then
739: wip_jsi_utils.record_error(l_msg);
740: wip_jsi_utils.abort_request;
741: end start_quantity;
742:
743: procedure net_quantity is begin
744:
755: end if;
756: end if;
757: exception
758: when others then
759: wip_jsi_utils.record_error('WIP_ML_NET_QUANTITY');
760: wip_jsi_utils.abort_request;
761:
762: end net_quantity;
763:
756: end if;
757: exception
758: when others then
759: wip_jsi_utils.record_error('WIP_ML_NET_QUANTITY');
760: wip_jsi_utils.abort_request;
761:
762: end net_quantity;
763:
764: procedure firm_planned_flag is begin
770: raise fnd_api.g_exc_unexpected_error;
771: end if;
772: exception
773: when others then
774: wip_jsi_utils.record_error('WIP_ML_FIRM_PLANNED_FLAG');
775: end firm_planned_flag;
776:
777: procedure repetitive_schedule_id is
778: l_rep_sched_count NUMBER;
792: end if;
793: end if;
794: exception
795: when others then
796: wip_jsi_utils.record_error('WIP_ML_REPETITIVE_SCHEDULE_ID');
797: wip_jsi_utils.abort_request;
798: end repetitive_schedule_id;
799:
800: procedure demand_class is begin
793: end if;
794: exception
795: when others then
796: wip_jsi_utils.record_error('WIP_ML_REPETITIVE_SCHEDULE_ID');
797: wip_jsi_utils.abort_request;
798: end repetitive_schedule_id;
799:
800: procedure demand_class is begin
801: if(wjsi_row.demand_class is not null and wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
806: where demand_class_code = wjsi_row.demand_class;
807: end if;
808: exception
809: when others then
810: wip_jsi_utils.record_error('WIP_ML_DEMAND_CLASS');
811: end demand_class;
812:
813: procedure line_id is begin
814: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.line_id is null) then
821: and organization_id = wjsi_row.organization_id;
822: end if;
823: exception
824: when others then
825: wip_jsi_utils.record_error('WIP_ML_LINE_ID');
826: wip_jsi_utils.abort_request;
827: end line_id;
828:
829: procedure schedule_group_id is begin
822: end if;
823: exception
824: when others then
825: wip_jsi_utils.record_error('WIP_ML_LINE_ID');
826: wip_jsi_utils.abort_request;
827: end line_id;
828:
829: procedure schedule_group_id is begin
830: if(wjsi_row.schedule_group_id is not null and
835: where schedule_group_id = wjsi_row.schedule_group_id
836: and organization_id = wjsi_row.organization_id;
837: end if; exception
838: when others then
839: wip_jsi_utils.record_error('WIP_ML_SCHEDULE_GROUP');
840: end schedule_group_id;
841:
842: procedure build_sequence is
843: l_retval boolean;
854: end if;
855: end if;
856: exception
857: when others then
858: wip_jsi_utils.record_error('WIP_ML_BUILD_SEQUENCE');
859: end build_sequence;
860:
861: procedure status_type is
862: l_msg varchar2(30) := 'WIP_ML_STATUS_TYPE';
942:
943: if ( l_qty_reserved > 0 and
944: wjsi_row.status_type = wip_constants.comp_chrg) then
945: fnd_message.set_name('WIP','WIP_SO_EXISTS');
946: wip_jsi_utils.record_current_error(p_warning_only => true);
947: end if;
948:
949: /* End fix of 3927677 */
950:
975: -- If we are unable to cancel all PO/requisition associated
976: -- to this job, we will try to cancel as much as we can,
977: -- then user need to manually cancel the rest.
978: po_warning_flag := WIP_CONSTANTS.YES;
979: wip_jsi_utils.record_current_error(p_warning_only => true);
980: END IF; -- check return status
981: ELSE
982: -- propagate_job_change_to_po is manual or job status is
983: -- 'Complete'
982: -- propagate_job_change_to_po is manual or job status is
983: -- 'Complete'
984: po_warning_flag := WIP_CONSTANTS.YES;
985: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
986: wip_jsi_utils.record_current_error(p_warning_only => true);
987: END IF;
988: ELSE
989: -- customer does not have PO patchset J onward, so behave the
990: -- old way
989: -- customer does not have PO patchset J onward, so behave the
990: -- old way
991: po_warning_flag := WIP_CONSTANTS.YES;
992: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
993: wip_jsi_utils.record_current_error(p_warning_only => true);
994: END IF;
995: END IF; -- PO/requisition exists
996: END IF; -- status is either 'Cancel','Complete', or 'Complete-no-charge'
997:
1000: for which source code is populated as MSC */
1001: if ( wjsi_row.source_code = 'MSC' and wdj_row.status_type in
1002: (wip_constants.comp_chrg, wip_constants.comp_nochrg,
1003: wip_constants.cancelled, wip_constants.closed) ) then
1004: wip_jsi_utils.record_error('WIP_CANT_UPDATE_JOB');
1005: wip_jsi_utils.abort_request;
1006: end if;
1007:
1008: -- bug# 3436646: job cannot be changed to unreleased if it's been pick released
1001: if ( wjsi_row.source_code = 'MSC' and wdj_row.status_type in
1002: (wip_constants.comp_chrg, wip_constants.comp_nochrg,
1003: wip_constants.cancelled, wip_constants.closed) ) then
1004: wip_jsi_utils.record_error('WIP_CANT_UPDATE_JOB');
1005: wip_jsi_utils.abort_request;
1006: end if;
1007:
1008: -- bug# 3436646: job cannot be changed to unreleased if it's been pick released
1009: if ( wjsi_row.status_type = WIP_CONSTANTS.UNRELEASED and
1017: end if; -- JOB RESCHED : END
1018:
1019: exception
1020: when others then
1021: wip_jsi_utils.record_error(l_msg);
1022: wip_jsi_utils.abort_request;
1023: end status_type;
1024:
1025: procedure processing_work_days is begin
1018:
1019: exception
1020: when others then
1021: wip_jsi_utils.record_error(l_msg);
1022: wip_jsi_utils.abort_request;
1023: end status_type;
1024:
1025: procedure processing_work_days is begin
1026: if(wjsi_row.load_type = wip_constants.create_sched and
1028: raise fnd_api.g_exc_unexpected_error;
1029: end if;
1030: exception
1031: when others then
1032: wip_jsi_utils.record_error('WIP_ML_PROCESSING_WORK_DAYS');
1033: end processing_work_days;
1034:
1035: procedure daily_production_rate is
1036: l_max_line_rate NUMBER;
1047:
1048: if(l_max_line_rate < wjsi_row.daily_production_rate) then
1049: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
1050: fnd_message.set_token('ENTITY1', l_max_line_rate);
1051: wip_jsi_utils.record_current_error(p_warning_only => true);
1052: end if;
1053: end if;
1054: exception
1055: when others then
1052: end if;
1053: end if;
1054: exception
1055: when others then
1056: wip_jsi_utils.record_error('WIP_ML_DAILY_PRODUCTION_RATE');
1057: end daily_production_rate;
1058:
1059: procedure primary_item_id is
1060: l_see_eng_items_flag VARCHAR2(1);
1112: l_dummy := 0;
1113: end;
1114:
1115: if (l_dummy = 1) then
1116: wip_jsi_utils.record_error('WIP_ML_ATO_ITEM_NO_BOM');
1117: wip_jsi_utils.abort_request;
1118: end if;
1119: end if;
1120: elsif(wjsi_row.load_type = wip_constants.create_eam_job and
1113: end;
1114:
1115: if (l_dummy = 1) then
1116: wip_jsi_utils.record_error('WIP_ML_ATO_ITEM_NO_BOM');
1117: wip_jsi_utils.abort_request;
1118: end if;
1119: end if;
1120: elsif(wjsi_row.load_type = wip_constants.create_eam_job and
1121: wjsi_row.primary_item_id is not null) then
1175:
1176: end if;
1177: exception
1178: when others then
1179: wip_jsi_utils.record_error(l_msg);
1180: wip_jsi_utils.abort_request;
1181: end primary_item_id;
1182:
1183: procedure wip_supply_type is
1176: end if;
1177: exception
1178: when others then
1179: wip_jsi_utils.record_error(l_msg);
1180: wip_jsi_utils.abort_request;
1181: end primary_item_id;
1182:
1183: procedure wip_supply_type is
1184: l_routing_count NUMBER;
1209: end if;
1210: end if;
1211: exception
1212: when others then
1213: wip_jsi_utils.record_error('WIP_ML_WIP_SUPPLY_TYPE');
1214: end wip_supply_type;
1215:
1216: procedure routing_reference_id is begin
1217: if(wjsi_row.load_type = wip_constants.create_ns_job and
1222: raise fnd_api.g_exc_unexpected_error;
1223: end if;
1224: exception
1225: when others then
1226: wip_jsi_utils.record_error('WIP_ML_ROUTING_REFERENCE_ID');
1227: wip_jsi_utils.abort_request;
1228: end routing_reference_id;
1229:
1230: procedure bom_reference_id is begin
1223: end if;
1224: exception
1225: when others then
1226: wip_jsi_utils.record_error('WIP_ML_ROUTING_REFERENCE_ID');
1227: wip_jsi_utils.abort_request;
1228: end routing_reference_id;
1229:
1230: procedure bom_reference_id is begin
1231: if(wjsi_row.load_type = wip_constants.create_ns_job and
1240: and eng_item_flag = 'N';
1241: end if;
1242: exception
1243: when others then
1244: wip_jsi_utils.record_error('WIP_ML_BOM_REFERENCE_ID');
1245: wip_jsi_utils.abort_request;
1246: end bom_reference_id;
1247:
1248: procedure alternate_routing_designator is
1241: end if;
1242: exception
1243: when others then
1244: wip_jsi_utils.record_error('WIP_ML_BOM_REFERENCE_ID');
1245: wip_jsi_utils.abort_request;
1246: end bom_reference_id;
1247:
1248: procedure alternate_routing_designator is
1249: l_is_flow_rtg NUMBER;
1280: and routing_type = 1;
1281: end if;
1282: exception
1283: when others then
1284: wip_jsi_utils.record_error(l_msg);
1285: end alternate_routing_designator;
1286:
1287: procedure alternate_bom_designator is
1288: l_bom_item_id NUMBER;
1309: and assembly_type = 1;
1310: end if;
1311: exception
1312: when others then
1313: wip_jsi_utils.record_error('WIP_ML_ALTERNATE_BOM');
1314: end alternate_bom_designator;
1315:
1316: procedure project_id is begin
1317: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job) and
1330: and nvl(mp.project_reference_enabled, 2) = wip_constants.yes;
1331: end if;
1332: exception
1333: when others then
1334: wip_jsi_utils.record_error('WIP_ML_PROJECT_ID');
1335: end project_id;
1336:
1337: procedure task_id is
1338: l_project_id NUMBER;
1351:
1352: end if;
1353: exception
1354: when others then
1355: wip_jsi_utils.record_error('WIP_ML_TASK_ID');
1356: end task_id;
1357:
1358: procedure project_task_id is
1359: l_result VARCHAR2(1);
1379: when others then
1380: wip_utilities.get_message_stack(p_delete_stack => 'T',
1381: p_msg => l_message);
1382: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then
1383: wip_jsi_utils.record_error_text(l_message, false);
1384: wip_jsi_utils.abort_request;
1385: else
1386: wip_jsi_utils.record_error_text(l_message, true);
1387: end if;
1380: wip_utilities.get_message_stack(p_delete_stack => 'T',
1381: p_msg => l_message);
1382: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then
1383: wip_jsi_utils.record_error_text(l_message, false);
1384: wip_jsi_utils.abort_request;
1385: else
1386: wip_jsi_utils.record_error_text(l_message, true);
1387: end if;
1388: end project_task_id;
1382: if (l_result = PJM_PROJECT.G_VALIDATE_FAILURE) then
1383: wip_jsi_utils.record_error_text(l_message, false);
1384: wip_jsi_utils.abort_request;
1385: else
1386: wip_jsi_utils.record_error_text(l_message, true);
1387: end if;
1388: end project_task_id;
1389:
1390: procedure schedule_dates is
1456: --include repetitive dates in date provided count
1457: if(wjsi_row.last_unit_start_date is not null) then
1458: l_date_count := l_date_count + 1;
1459: if(wjsi_row.load_type <> wip_constants.create_sched) then
1460: wip_jsi_utils.record_ignored_column_warning('LAST_UNIT_START_DATE');
1461: end if;
1462: end if;
1463:
1464: if(wjsi_row.first_unit_completion_date is not null) then
1463:
1464: if(wjsi_row.first_unit_completion_date is not null) then
1465: l_date_count := l_date_count + 1;
1466: if(wjsi_row.load_type <> wip_constants.create_sched) then
1467: wip_jsi_utils.record_ignored_column_warning('FIRST_UNIT_COMPLETION_DATE');
1468: end if;
1469: end if;
1470:
1471: if(wjsi_row.load_type = wip_constants.create_sched) then
1647: end if;
1648: end if;
1649: exception
1650: when others then
1651: wip_jsi_utils.record_error(l_msg);
1652: wip_jsi_utils.abort_request;
1653: end schedule_dates;
1654:
1655: procedure scheduling_method is
1648: end if;
1649: exception
1650: when others then
1651: wip_jsi_utils.record_error(l_msg);
1652: wip_jsi_utils.abort_request;
1653: end schedule_dates;
1654:
1655: procedure scheduling_method is
1656: l_msg_code VARCHAR2(30) := 'WIP_ML_SCHEDULING_METHOD';
1683: end if;
1684: end if;
1685: exception
1686: when others then
1687: wip_jsi_utils.record_error(l_msg_code);
1688: wip_jsi_utils.abort_request;
1689: end scheduling_method;
1690:
1691: procedure completion_subinventory is
1684: end if;
1685: exception
1686: when others then
1687: wip_jsi_utils.record_error(l_msg_code);
1688: wip_jsi_utils.abort_request;
1689: end scheduling_method;
1690:
1691: procedure completion_subinventory is
1692: l_inv_item_id NUMBER;
1756: end if;
1757: */
1758: exception
1759: when others then
1760: wip_jsi_utils.record_error('WIP_ML_COMPLETION_SUBINVENTORY');
1761: wip_jsi_utils.abort_request;
1762: end completion_subinventory;
1763:
1764: procedure completion_locator_id is
1757: */
1758: exception
1759: when others then
1760: wip_jsi_utils.record_error('WIP_ML_COMPLETION_SUBINVENTORY');
1761: wip_jsi_utils.abort_request;
1762: end completion_subinventory;
1763:
1764: procedure completion_locator_id is
1765: l_prj_loc_id NUMBER;
1884: raise fnd_api.g_exc_unexpected_error;
1885: end if;
1886: end if;
1887: exception when others then
1888: wip_jsi_utils.record_error(l_msg);
1889: /* Fixed Bug#3060266 - should abort request if Invalid Locator */
1890: wip_jsi_utils.abort_request;
1891: end completion_locator_id;
1892:
1886: end if;
1887: exception when others then
1888: wip_jsi_utils.record_error(l_msg);
1889: /* Fixed Bug#3060266 - should abort request if Invalid Locator */
1890: wip_jsi_utils.abort_request;
1891: end completion_locator_id;
1892:
1893: procedure due_date is begin
1894: if(wjsi_row.load_type = wip_constants.create_eam_job) then
1901: end if;
1902: end if;
1903: exception
1904: when others then
1905: wip_jsi_utils.record_error('WIP_ML_DUE_DATE');
1906: wip_jsi_utils.abort_request;
1907: end due_date;
1908:
1909: procedure date_released is begin
1902: end if;
1903: exception
1904: when others then
1905: wip_jsi_utils.record_error('WIP_ML_DUE_DATE');
1906: wip_jsi_utils.abort_request;
1907: end due_date;
1908:
1909: procedure date_released is begin
1910: if(wjsi_row.date_released > sysdate and
1911: wjsi_row.status_type = wip_constants.released) then
1912: raise fnd_api.g_exc_unexpected_error;
1913: end if;
1914: exception when others then
1915: wip_jsi_utils.record_error('WIP_ML_INVALID_RELEASE_DATE');
1916: wip_jsi_utils.abort_request;
1917: end date_released;
1918:
1919: procedure requested_start_date is begin
1912: raise fnd_api.g_exc_unexpected_error;
1913: end if;
1914: exception when others then
1915: wip_jsi_utils.record_error('WIP_ML_INVALID_RELEASE_DATE');
1916: wip_jsi_utils.abort_request;
1917: end date_released;
1918:
1919: procedure requested_start_date is begin
1920: if(wjsi_row.load_type = wip_constants.create_eam_job) then
1927: end if;
1928: end if;
1929: exception
1930: when others then
1931: wip_jsi_utils.record_error('WIP_ML_REQUESTED_START_DATE');
1932: wip_jsi_utils.abort_request;
1933: end requested_start_date;
1934:
1935: procedure end_item_unit_number is
1928: end if;
1929: exception
1930: when others then
1931: wip_jsi_utils.record_error('WIP_ML_REQUESTED_START_DATE');
1932: wip_jsi_utils.abort_request;
1933: end requested_start_date;
1934:
1935: procedure end_item_unit_number is
1936: is_unit_effective_item boolean;
1964: when too_many_rows then
1965: null; -- the query returning multiple rows is ok
1966: when others then
1967: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
1968: wip_jsi_utils.record_current_error ;
1969: end;
1970: end if;
1971:
1972: -- You cannot create a repetitive schedule for a unit effective assembly.
1971:
1972: -- You cannot create a repetitive schedule for a unit effective assembly.
1973: if(wjsi_row.load_type = wip_constants.create_sched and
1974: is_unit_effective_item) then
1975: wip_jsi_utils.record_error('WIP_ML_NO_UNIT_EFF_SCHED');
1976: raise fnd_api.g_exc_unexpected_error;
1977: end if;
1978:
1979: -- If this is a discrete job load...
1980: if (wjsi_row.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB))
1981: then
1982: -- It is an error to provide unit number for non-unit effective assemblies.
1983: if(not is_unit_effective_item and wjsi_row.end_item_unit_number is not null) then
1984: wip_jsi_utils.record_error('WIP_ML_UNIT_NUM_MEANINGLESS');
1985: end if;
1986:
1987: -- Unit number is required for unit effective assemblies.
1988: if(is_unit_effective_item and wjsi_row.end_item_unit_number is null) then
1986:
1987: -- Unit number is required for unit effective assemblies.
1988: if(is_unit_effective_item and wjsi_row.end_item_unit_number is null) then
1989: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');
1990: wip_jsi_utils.record_current_error;
1991: raise fnd_api.g_exc_unexpected_error;
1992: end if;
1993: end if;
1994:
1999: -- added for bug#2766839, added check when the assembly is not is_unit_effective_item
2000: if(not is_unit_effective_item) then
2001: -- It is an error to provide unit number for non-unit effective assemblies.
2002: if ( wjsi_row.end_item_unit_number is not null) then
2003: wip_jsi_utils.record_error('WIP_ML_UNIT_NUM_MEANINGLESS');
2004: end if;
2005: wjsi_row.end_item_unit_number := null;
2006:
2007: -- if status is unreleased, the end_item_unit_number can be modified
2012: from wip_discrete_jobs
2013: where wip_entity_id =
2014: (select wip_entity_id
2015: from wip_job_schedule_interface
2016: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2017: );
2018: exception
2019: when others then
2020: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
2017: );
2018: exception
2019: when others then
2020: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
2021: WIP_JSI_Utils.record_current_error ;
2022: raise fnd_api.g_exc_unexpected_error;
2023: end ;
2024: else
2025: begin
2029: where wip_entity_id = wjsi_row.wip_entity_id;
2030: exception
2031: when others then
2032: FND_Message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID') ;
2033: WIP_JSI_Utils.record_current_error ;
2034: raise fnd_api.g_exc_unexpected_error;
2035: end ;
2036: end if;
2037:
2037:
2038: -- if status is not unreleased, end_item_unit_number is ignored.
2039: else
2040: if (wjsi_row.end_item_unit_number is not null) then
2041: wip_jsi_utils.record_ignored_column_warning('END_ITEM_UNIT_NUMBER');
2042: end if;
2043:
2044: begin
2045: select end_item_unit_number into wjsi_row.end_item_unit_number
2046: from wip_discrete_jobs
2047: where wip_entity_id =
2048: (select wip_entity_id
2049: from wip_job_schedule_interface
2050: where rowid = WIP_JSI_UTILS.CURRENT_ROWID
2051: );
2052: exception
2053: when others then
2054: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
2051: );
2052: exception
2053: when others then
2054: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
2055: WIP_JSI_Utils.record_current_error ;
2056: raise fnd_api.g_exc_unexpected_error;
2057: end ;
2058: end if;
2059: end if ;
2059: end if ;
2060:
2061: exception
2062: when others then
2063: wip_jsi_utils.abort_request;
2064:
2065: end end_item_unit_number;
2066:
2067: procedure overcompletion is
2086: end if;
2087: end if;
2088: exception
2089: when others then
2090: wip_jsi_utils.record_error(l_msg);
2091: end overcompletion;
2092:
2093: procedure class_code is begin
2094: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job) and
2162: end if;
2163: end if;
2164: exception
2165: when others then
2166: wip_jsi_utils.record_error('WIP_ML_CLASS_CODE');
2167: end class_code;
2168:
2169: procedure estimate_lead_time is
2170: l_entity_type NUMBER;
2281: end if;
2282: end if;
2283: exception
2284: when others then
2285: wip_jsi_utils.record_error(l_msg);
2286: end estimate_lead_time;
2287:
2288: procedure bom_revision is
2289: l_start_date DATE;
2304: p_start_date => l_start_date);
2305: end if;
2306: exception
2307: when others then
2308: WIP_JSI_Utils.record_error('WIP_ML_BOM_REVISION') ;
2309: /* Fixed for bug#3063147
2310: When No valid bom revision exists for an item then mass load should be
2311: aborted.
2312: */
2309: /* Fixed for bug#3063147
2310: When No valid bom revision exists for an item then mass load should be
2311: aborted.
2312: */
2313: wip_jsi_utils.abort_request;
2314:
2315: end bom_revision;
2316:
2317: procedure routing_revision is
2343: end if;
2344: end if;
2345: exception
2346: when others then
2347: WIP_JSI_Utils.record_error('WIP_ML_ROUTING_REVISION');
2348: end routing_revision;
2349:
2350: procedure asset_group_id is begin
2351: if(wjsi_row.load_type = wip_constants.create_eam_job) then
2361: end if;
2362: end if;
2363: exception
2364: when others then
2365: wip_jsi_utils.record_error('WIP_ML_EAM_ASSET_GROUP');
2366: wip_jsi_utils.abort_request;
2367: end asset_group_id;
2368:
2369: procedure asset_number is
2362: end if;
2363: exception
2364: when others then
2365: wip_jsi_utils.record_error('WIP_ML_EAM_ASSET_GROUP');
2366: wip_jsi_utils.abort_request;
2367: end asset_group_id;
2368:
2369: procedure asset_number is
2370: l_msg VARCHAR2(30);
2390: end if;
2391: end if;
2392: exception
2393: when others then
2394: wip_jsi_utils.record_error(l_msg);
2395: end asset_number;
2396:
2397: procedure rebuild_item_id is begin
2398: if(wjsi_row.load_type = wip_constants.create_eam_job and
2405: and eam_item_type = 3;
2406: end if;
2407: exception
2408: when others then
2409: wip_jsi_utils.record_error('WIP_ML_EAM_REBUILD_ITEM');
2410: wip_jsi_utils.abort_request;
2411: end rebuild_item_id;
2412:
2413: procedure rebuild_serial_number is begin
2406: end if;
2407: exception
2408: when others then
2409: wip_jsi_utils.record_error('WIP_ML_EAM_REBUILD_ITEM');
2410: wip_jsi_utils.abort_request;
2411: end rebuild_item_id;
2412:
2413: procedure rebuild_serial_number is begin
2414: if(wjsi_row.load_type = wip_constants.create_eam_job) then
2449: end if;
2450: end if;
2451: exception
2452: when others then
2453: wip_jsi_utils.record_error('WIP_ML_EAM_REBUILD_SERIAL');
2454: end rebuild_serial_number;
2455:
2456: procedure parent_wip_entity_id is begin
2457: -- Per EAM Enh. for H, this field is no longer mandatory
2464: and entity_type = wip_constants.eam;
2465: end if;
2466: exception
2467: when others then
2468: wip_jsi_utils.record_error('WIP_ML_EAM_PARENT_ENTITY');
2469: end parent_wip_entity_id;
2470:
2471: procedure manual_rebuild_flag is begin
2472: if(wjsi_row.load_type = wip_constants.create_eam_job) then
2482: end if;
2483: end if;
2484: exception
2485: when others then
2486: wip_jsi_utils.record_error('WIP_ML_EAM_REBUILD_FLAG');
2487: end manual_rebuild_flag;
2488:
2489: procedure owning_department is
2490: l_job_date DATE;
2505: end if;
2506: end if;
2507: exception
2508: when others then
2509: wip_jsi_utils.record_error('WIP_ML_EAM_OWNING_DEPT');
2510: end owning_department;
2511:
2512: procedure notification_required is begin
2513: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2516: raise fnd_api.g_exc_unexpected_error;
2517: end if;
2518: exception
2519: when others then
2520: wip_jsi_utils.record_error('WIP_ML_EAM_NOTIF_REQ');
2521: end notification_required;
2522:
2523: procedure shutdown_type is begin
2524: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2531: and enabled_flag = 'Y';
2532: end if;
2533: exception
2534: when others then
2535: wip_jsi_utils.record_error('WIP_ML_EAM_SHUTDOWN_TYPE');
2536: end shutdown_type;
2537:
2538: procedure tagout_required is begin
2539: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2542: raise fnd_api.g_exc_unexpected_error;
2543: end if;
2544: exception
2545: when others then
2546: wip_jsi_utils.record_error('WIP_ML_EAM_TAGOUT_REQUIRED');
2547: end tagout_required;
2548:
2549: procedure plan_maintenance is begin
2550: if(wjsi_row.load_type = wip_constants.create_eam_job and
2553: raise fnd_api.g_exc_unexpected_error;
2554: end if;
2555: exception
2556: when others then
2557: wip_jsi_utils.record_error('WIP_ML_EAM_PLAN_MAINTENANCE');
2558: end plan_maintenance;
2559:
2560: procedure work_order_type is begin
2561: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2568: and enabled_flag = 'Y';
2569: end if;
2570: exception
2571: when others then
2572: wip_jsi_utils.record_error('WIP_ML_EAM_WORK_ORDER_TYPE');
2573: end work_order_type;
2574:
2575: procedure activity_type is begin
2576: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2583: and enabled_flag = 'Y';
2584: end if;
2585: exception
2586: when others then
2587: wip_jsi_utils.record_error('WIP_ML_EAM_ACTIVITY_TYPE');
2588: end activity_type;
2589:
2590: procedure activity_cause is begin
2591: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job,
2598: and enabled_flag = 'Y';
2599: end if;
2600: exception
2601: when others then
2602: wip_jsi_utils.record_error('WIP_ML_EAM_ACTIVITY_CAUSE');
2603: end activity_cause;
2604:
2605: procedure maintenance_object_type is
2606: l_serial_number_control_code NUMBER;
2628: end if;
2629: end if;
2630: exception
2631: when others then
2632: wip_jsi_utils.record_error('WIP_ML_EAM_MAINT_OBJECT_TYPE');
2633: end maintenance_object_type;
2634:
2635: procedure maintenance_object_source is begin
2636: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2648: end if;
2649: end if;
2650: exception
2651: when others then
2652: wip_jsi_utils.record_error('WIP_ML_EAM_MAINT_OBJECT_SOURCE');
2653: end maintenance_object_source;
2654:
2655: procedure maintenance_object_id is begin
2656: if(wjsi_row.load_type = wip_constants.create_eam_job and
2688: end if;
2689:
2690: exception
2691: when others then
2692: wip_jsi_utils.record_error('WIP_ML_EAM_MAINT_OBJECT_ID');
2693: end maintenance_object_id;
2694:
2695: procedure pm_schedule_id is begin
2696: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2699: raise fnd_api.g_exc_unexpected_error;
2700: end if;
2701: exception
2702: when others then
2703: wip_jsi_utils.record_error('WIP_ML_EAM_PM_SCHEDULE_ID');
2704: end pm_schedule_id;
2705:
2706: procedure activity_source is begin
2707: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
2714: and enabled_flag = 'Y';
2715: end if;
2716: exception
2717: when others then
2718: wip_jsi_utils.record_error('WIP_ML_EAM_ACTIVITY_SOURCE');
2719: end activity_source;
2720:
2721:
2722: PROCEDURE validate_date_released is
2726: x_period_exists varchar2(1);
2727: BEGIN
2728: If (wjsi_row.status_type = WIP_CONSTANTS.UNRELEASED) then
2729: if (wjsi_row.date_released is not null) then
2730: WIP_JSI_Utils.record_ignored_column_warning ('DATE_RELEASED') ;
2731: end if ;
2732: Elsif (wjsi_row.status_type = WIP_CONSTANTS.RELEASED) then
2733: if (nvl(wjsi_row.date_released,sysdate) > sysdate) then
2734: WIP_JSI_Utils.record_error('WIP_INVALID_RELEASE_DATE',TRUE) ;
2730: WIP_JSI_Utils.record_ignored_column_warning ('DATE_RELEASED') ;
2731: end if ;
2732: Elsif (wjsi_row.status_type = WIP_CONSTANTS.RELEASED) then
2733: if (nvl(wjsi_row.date_released,sysdate) > sysdate) then
2734: WIP_JSI_Utils.record_error('WIP_INVALID_RELEASE_DATE',TRUE) ;
2735:
2736: update wip_job_schedule_interface
2737: set date_released = sysdate
2738: where rowid = WIP_JSI_Utils.current_rowid ;
2734: WIP_JSI_Utils.record_error('WIP_INVALID_RELEASE_DATE',TRUE) ;
2735:
2736: update wip_job_schedule_interface
2737: set date_released = sysdate
2738: where rowid = WIP_JSI_Utils.current_rowid ;
2739: end if;
2740:
2741: --else
2742: /* fix for bug 2424987 */
2748: and trunc(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(wjsi_row.date_released,sysdate),wjsi_row.organization_id)) between PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
2749: and period_close_date is NULL;
2750: Exception
2751: When others then
2752: WIP_JSI_Utils.record_error('WIP_NO_ACCT_PERIOD',FALSE) ;
2753: WIP_JSI_Utils.abort_request;
2754: End;
2755: --end if;
2756:
2749: and period_close_date is NULL;
2750: Exception
2751: When others then
2752: WIP_JSI_Utils.record_error('WIP_NO_ACCT_PERIOD',FALSE) ;
2753: WIP_JSI_Utils.abort_request;
2754: End;
2755: --end if;
2756:
2757: End if;