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.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 44: wjsi_row wip_job_schedule_interface%ROWTYPE;

40: location_control_code NUMBER,
41: fixed_lead_time NUMBER,
42: variable_lead_time NUMBER);
43:
44: wjsi_row wip_job_schedule_interface%ROWTYPE;
45: wdj_row wdj_rec_t;
46: primary_item_row item_rec_t;
47:
48: procedure loadInterfaceError(p_interfaceTbl in out nocopy num_tbl_t,

Line 115: -- This procedure defaults and validates all the columns in wip_job_schedule_interface table.

111: p_validationLevel in number,
112: x_errorMsg out nocopy varchar2);
113:
114: --
115: -- This procedure defaults and validates all the columns in wip_job_schedule_interface table.
116: -- It does group validation where it can and does line validation otherwise. For a particular
117: -- column, the default and validation logic might be splitted in two different places if it needs
118: -- both line and group validation.
119: -- The only exception is for column serialization_start_op. The default and validation has to be

Line 229: update wip_job_schedule_interface wjsi

225:
226: --
227: -- validate load type
228: --
229: update wip_job_schedule_interface wjsi
230: set wjsi.process_status = WIP_CONSTANTS.ERROR,
231: wjsi.last_update_date = sysdate
232: where wjsi.group_id = p_groupID
233: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 249: update wip_job_schedule_interface wjsi

245:
246: --
247: --Fix for bug#4186944. Update REQUEST_ID
248: --
249: update wip_job_schedule_interface wjsi
250: set wjsi.request_id = decode(x_request_id,-1,wjsi.request_id,x_request_id),
251: wjsi.program_id = decode(x_program_id,-1,wjsi.program_id,x_program_id),
252: wjsi.program_application_id = decode(x_application_id,-1,wjsi.program_application_id, x_application_id)
253: where wjsi.group_id = p_groupID

Line 261: update wip_job_schedule_interface wjsi

257:
258: --
259: -- default and validate column created_by, created_by_name
260: --
261: update wip_job_schedule_interface wjsi
262: set wjsi.process_status = WIP_CONSTANTS.ERROR,
263: wjsi.last_update_date = sysdate
264: where wjsi.group_id = p_groupID
265: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 282: update wip_job_schedule_interface wjsi

278: end if;
279:
280: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
281:
282: update wip_job_schedule_interface wjsi
283: set wjsi.process_status = WIP_CONSTANTS.WARNING,
284: wjsi.last_update_date = sysdate
285: where wjsi.group_id = p_groupID
286: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 298: update wip_job_schedule_interface wjsi

294: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
295: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
296: end if;
297:
298: update wip_job_schedule_interface wjsi
299: set wjsi.created_by = (select usr.user_id
300: from fnd_user usr
301: where usr.user_name = wjsi.created_by_name),
302: wjsi.last_update_date = sysdate

Line 310: update wip_job_schedule_interface wjsi

306: and wjsi.created_by_name is not null
307: and wjsi.created_by is null;
308:
309: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
310: update wip_job_schedule_interface wjsi
311: set wjsi.process_status = WIP_CONSTANTS.ERROR,
312: wjsi.last_update_date = sysdate
313: where wjsi.group_id = p_groupID
314: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 332: update wip_job_schedule_interface wjsi

328:
329: --
330: -- default and validate last_updated_by_name and last_updated_by
331: --
332: update wip_job_schedule_interface wjsi
333: set wjsi.process_status = WIP_CONSTANTS.ERROR,
334: wjsi.last_update_date = sysdate
335: where wjsi.group_id = p_groupID
336: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 352: update wip_job_schedule_interface wjsi

348: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
349: end if;
350: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
351:
352: update wip_job_schedule_interface wjsi
353: set wjsi.process_status = WIP_CONSTANTS.WARNING,
354: wjsi.last_update_date = sysdate
355: where wjsi.group_id = p_groupID
356: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 368: update wip_job_schedule_interface wjsi

364: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
365: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
366: end if;
367:
368: update wip_job_schedule_interface wjsi
369: set wjsi.last_updated_by = (select usr.user_id
370: from fnd_user usr
371: where usr.user_name = wjsi.last_updated_by_name),
372: wjsi.last_update_date = sysdate

Line 381: update wip_job_schedule_interface wjsi

377: and wjsi.last_updated_by is null;
378:
379: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
380:
381: update wip_job_schedule_interface wjsi
382: set wjsi.process_status = WIP_CONSTANTS.ERROR,
383: wjsi.last_update_date = sysdate
384: where wjsi.group_id = p_groupID
385: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 405: update wip_job_schedule_interface wjsi

401: -- default and validate organization_code and organization_id
402: --
403: -- Bug 4890514. Performance Fix
404: -- saugupta 25th-May-2006
405: update wip_job_schedule_interface wjsi
406: set wjsi.process_status = WIP_CONSTANTS.ERROR,
407: wjsi.last_update_date = sysdate
408: where wjsi.group_id = p_groupID
409: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 426: update wip_job_schedule_interface wjsi

422: end if;
423:
424: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
425:
426: update wip_job_schedule_interface wjsi
427: set wjsi.process_status = WIP_CONSTANTS.WARNING,
428: wjsi.last_update_date = sysdate
429: where wjsi.group_id = p_groupID
430: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 444: update wip_job_schedule_interface wjsi

440: end if;
441:
442: -- Bug 4890514. Performance Fix
443: -- saugupta 25th-May-2006
444: update wip_job_schedule_interface wjsi
445: set wjsi.organization_id = (select ood.organization_id
446: from mtl_parameters ood
447: where ood.organization_code = wjsi.organization_code),
448: wjsi.last_update_date = sysdate

Line 459: update wip_job_schedule_interface wjsi

455:
456: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
457: -- Bug 4890514. Performance Fix
458: -- saugupta 25th-May-2006
459: update wip_job_schedule_interface wjsi
460: set wjsi.process_status = WIP_CONSTANTS.ERROR,
461: wjsi.last_update_date = sysdate
462: where wjsi.group_id = p_groupID
463: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 486: update wip_job_schedule_interface wjsi

482:
483: --
484: -- default and validate job_name and wip_entity_id column
485: --
486: update wip_job_schedule_interface wjsi
487: set wjsi.process_status = WIP_CONSTANTS.ERROR,
488: wjsi.last_update_date = sysdate
489: where wjsi.group_id = p_groupID
490: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 507: update wip_job_schedule_interface wjsi

503: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
504: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
505: end if;
506:
507: update wip_job_schedule_interface wjsi
508: set wjsi.process_status = WIP_CONSTANTS.WARNING,
509: wjsi.last_update_date = sysdate
510: where wjsi.group_id = p_groupID
511: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 525: update wip_job_schedule_interface wjsi

521: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
523: end if;
524:
525: update wip_job_schedule_interface wjsi
526: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,
527: wjsi.last_update_date = sysdate
528: where wjsi.group_id = p_groupID
529: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 534: update wip_job_schedule_interface wjsi

530: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
531: and wjsi.job_name is null
532: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB);
533:
534: update wip_job_schedule_interface wjsi
535: set wjsi.wip_entity_id = (select we.wip_entity_id
536: from wip_entities we
537: where we.wip_entity_name = wjsi.job_name
538: and we.organization_id = wjsi.organization_id),

Line 547: update wip_job_schedule_interface wjsi

543: and wjsi.job_name is not null
544: and wjsi.wip_entity_id is null
545: and wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB;
546:
547: update wip_job_schedule_interface wjsi
548: set wjsi.process_status = WIP_CONSTANTS.ERROR,
549: wjsi.last_update_date = sysdate
550: where wjsi.group_id = p_groupID
551: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 568: update wip_job_schedule_interface wjsi

564:
565: --
566: -- validate wip entity id
567: --
568: update wip_job_schedule_interface wjsi
569: set wjsi.process_status = WIP_CONSTANTS.WARNING,
570: wjsi.last_update_date = sysdate
571: where wjsi.group_id = p_groupID
572: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 586: update wip_job_schedule_interface wjsi

582: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);
583: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
584: end if;
585:
586: update wip_job_schedule_interface wjsi
587: set wip_entity_id = wip_entities_s.nextval,
588: last_update_date = sysdate
589: where wjsi.group_id = p_groupID
590: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 596: update wip_job_schedule_interface wjsi

592: and wjsi.wip_entity_id is null
593: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
594: WIP_CONSTANTS.CREATE_NS_JOB);
595:
596: update wip_job_schedule_interface wjsi
597: set wjsi.process_status = WIP_CONSTANTS.ERROR,
598: wjsi.last_update_date = sysdate
599: where wjsi.group_id = p_groupID
600: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 622: update wip_job_schedule_interface wjsi

618:
619: --
620: -- validate for entity type
621: --
622: update wip_job_schedule_interface wjsi
623: set wjsi.process_status = WIP_CONSTANTS.ERROR,
624: wjsi.last_update_date = sysdate
625: where wjsi.group_id = p_groupID
626: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 644: update wip_job_schedule_interface wjsi

640:
641: --
642: -- default and validate repetitve_schedule_id
643: --
644: update wip_job_schedule_interface wjsi
645: set wjsi.process_status = WIP_CONSTANTS.WARNING,
646: wjsi.last_update_date = sysdate
647: where wjsi.group_id = p_groupID
648: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 660: update wip_job_schedule_interface wjsi

656: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);
657: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
658: end if;
659:
660: update wip_job_schedule_interface wjsi
661: set wjsi.repetitive_schedule_id = wip_repetitive_schedules_s.nextval,
662: wjsi.last_update_date = sysdate
663: where wjsi.group_id = p_groupID
664: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 671: update wip_job_schedule_interface wjsi

667:
668: --
669: -- default and validate schedule_group_id and schedule_group_name
670: --
671: update wip_job_schedule_interface wjsi
672: set wjsi.process_status = WIP_CONSTANTS.WARNING,
673: wjsi.last_update_date = sysdate
674: where wjsi.group_id = p_groupID
675: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 687: update wip_job_schedule_interface wjsi

683: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);
684: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
685: end if;
686:
687: update wip_job_schedule_interface wjsi
688: set wjsi.process_status = WIP_CONSTANTS.WARNING,
689: wjsi.last_update_date = sysdate
690: where wjsi.group_id = p_groupID
691: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 704: update wip_job_schedule_interface wjsi

700: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);
701: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
702: end if;
703:
704: update wip_job_schedule_interface wjsi
705: set wjsi.process_status = WIP_CONSTANTS.ERROR,
706: wjsi.last_update_date = sysdate
707: where wjsi.group_id = p_groupID
708: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 727: update wip_job_schedule_interface wjsi

723: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);
724: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
725: end if;
726:
727: update wip_job_schedule_interface wjsi
728: set wjsi.schedule_group_id =
729: (select sg.schedule_group_id
730: from wip_schedule_groups_val_v sg
731: where sg.schedule_group_name = wjsi.schedule_group_name

Line 745: /* update wip_job_schedule_interface wjsi

741: and wjsi.schedule_group_name is not null;
742:
743: -- if still null, default from job if load type is reschedule job
744: -- Bug 15903332
745: /* update wip_job_schedule_interface wjsi
746: set wjsi.schedule_group_id =
747: (select wdj.schedule_group_id
748: from wip_discrete_jobs wdj
749: where wdj.wip_entity_id = wjsi.wip_entity_id

Line 759: update wip_job_schedule_interface wjsi

755: and wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB
756: and wjsi.schedule_group_id is null; */
757:
758: -- if still null, try to default from the delivery_id provided
759: update wip_job_schedule_interface wjsi
760: set wjsi.schedule_group_id =
761: (select wsg.schedule_group_id
762: from wip_schedule_groups wsg,
763: wsh_new_deliveries wds

Line 787: from wip_job_schedule_interface wjsi

783:
784: -- if still null and loading from CTO, insert new groups
785: select wjsi.interface_id
786: bulk collect into l_interfaceTbl
787: from wip_job_schedule_interface wjsi
788: where wjsi.group_id = p_groupID
789: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
790: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
791: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,

Line 819: wip_job_schedule_interface wjsi

815: fnd_global.user_id,
816: sysdate,
817: sysdate
818: from wsh_new_deliveries wds,
819: wip_job_schedule_interface wjsi
820: where wds.delivery_id = wjsi.delivery_id
821: and wjsi.interface_id = l_interfaceTbl(i);
822:
823: update wip_job_schedule_interface

Line 823: update wip_job_schedule_interface

819: wip_job_schedule_interface wjsi
820: where wds.delivery_id = wjsi.delivery_id
821: and wjsi.interface_id = l_interfaceTbl(i);
822:
823: update wip_job_schedule_interface
824: set schedule_group_id = l_schedGroupID,
825: last_update_date = sysdate
826: where interface_id = l_interfaceTbl(i);
827: end loop;

Line 831: update wip_job_schedule_interface wjsi

827: end loop;
828: l_interfaceTbl.delete;
829: end if;
830:
831: update wip_job_schedule_interface wjsi
832: set wjsi.process_status = WIP_CONSTANTS.ERROR,
833: wjsi.last_update_date = sysdate
834: where wjsi.group_id = p_groupID
835: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 855: update wip_job_schedule_interface wjsi

851:
852: --
853: -- default build_sequence
854: --
855: update wip_job_schedule_interface wjsi
856: set wjsi.process_status = WIP_CONSTANTS.WARNING,
857: wjsi.last_update_date = sysdate
858: where wjsi.group_id = p_groupID
859: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 877: update wip_job_schedule_interface wjsi

873: --
874:
875: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
876:
877: update wip_job_schedule_interface wjsi
878: set wjsi.process_status = WIP_CONSTANTS.ERROR,
879: wjsi.last_update_date = sysdate
880: where wjsi.group_id = p_groupID
881: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 898: update wip_job_schedule_interface wjsi

894: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
895: end if;
896: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
897:
898: update wip_job_schedule_interface wjsi
899: set wjsi.process_status = WIP_CONSTANTS.WARNING,
900: wjsi.last_update_date = sysdate
901: where wjsi.group_id = p_groupID
902: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 914: update wip_job_schedule_interface wjsi

910: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
911: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
912: end if;
913:
914: update wip_job_schedule_interface wjsi
915: set line_id = (select wl.line_id
916: from wip_lines_val_v wl
917: where wl.line_code = wjsi.line_code
918: and wl.organization_id = wjsi.organization_id),

Line 928: update wip_job_schedule_interface wjsi

924: and line_id is null;
925:
926: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
927:
928: update wip_job_schedule_interface wjsi
929: set wjsi.process_status = WIP_CONSTANTS.ERROR,
930: wjsi.last_update_date = sysdate
931: where wjsi.group_id = p_groupID
932: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 949: update wip_job_schedule_interface wjsi

945:
946: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
947:
948: -- ignore serialization_start_op for repetitive
949: update wip_job_schedule_interface wjsi
950: set wjsi.process_status = WIP_CONSTANTS.WARNING,
951: wjsi.last_update_date = sysdate
952: where wjsi.group_id = p_groupID
953: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 968: update wip_job_schedule_interface wjsi

964:
965: --
966: -- default and validate project_number and project_id
967: --
968: update wip_job_schedule_interface wjsi
969: set wjsi.process_status = WIP_CONSTANTS.WARNING,
970: wjsi.last_update_date = sysdate
971: where wjsi.group_id = p_groupID
972: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 984: update wip_job_schedule_interface wjsi

980: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
981: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
982: end if;
983:
984: update wip_job_schedule_interface wjsi
985: set wjsi.process_status = WIP_CONSTANTS.WARNING,
986: wjsi.last_update_date = sysdate
987: where wjsi.group_id = p_groupID
988: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1003: update wip_job_schedule_interface wjsi

999:
1000: --
1001: -- default and validate task_number and task_id
1002: --
1003: update wip_job_schedule_interface wjsi
1004: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1005: wjsi.last_update_date = sysdate
1006: where wjsi.group_id = p_groupID
1007: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1019: update wip_job_schedule_interface wjsi

1015: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
1016: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1017: end if;
1018:
1019: update wip_job_schedule_interface wjsi
1020: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1021: wjsi.last_update_date = sysdate
1022: where wjsi.group_id = p_groupID
1023: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1038: update wip_job_schedule_interface wjsi

1034:
1035: --
1036: -- default and validate firm_planned_flag
1037: --
1038: update wip_job_schedule_interface wjsi
1039: set wjsi.firm_planned_flag = WIP_CONSTANTS.NO,
1040: wjsi.last_update_date = sysdate
1041: where wjsi.group_id = p_groupID
1042: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1051: update wip_job_schedule_interface wjsi

1047: WIP_CONSTANTS.CREATE_SCHED);
1048:
1049: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1050:
1051: update wip_job_schedule_interface wjsi
1052: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1053: wjsi.last_update_date = sysdate
1054: where wjsi.group_id = p_groupID
1055: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1080: update wip_job_schedule_interface wjsi

1076: --
1077: fnd_message.set_name('WIP','WIP_MLD_DESC');
1078: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(dateval => sysdate,calendar_aware => 2), false);
1079: l_description := fnd_message.get;
1080: update wip_job_schedule_interface wjsi
1081: set wjsi.description = l_description,
1082: wjsi.last_update_date = sysdate
1083: where wjsi.group_id = p_groupID
1084: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1093: update wip_job_schedule_interface wjsi

1089:
1090: fnd_message.set_name('WIP','WIP_MLR_DESC');
1091: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(dateval => sysdate,calendar_aware => 2), false);
1092: l_description := fnd_message.get;
1093: update wip_job_schedule_interface wjsi
1094: set wjsi.description = l_description,
1095: wjsi.last_update_date = sysdate
1096: where wjsi.group_id = p_groupID
1097: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1105: update wip_job_schedule_interface wjsi

1101:
1102: --
1103: -- default and validate primary_item_id and primary_item_segments
1104: --
1105: update wip_job_schedule_interface wjsi
1106: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1107: wjsi.last_update_date = sysdate
1108: where wjsi.group_id = p_groupID
1109: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1122: update wip_job_schedule_interface wjsi

1118: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1119: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1120: end if;
1121:
1122: update wip_job_schedule_interface wjsi
1123: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1124: wjsi.last_update_date = sysdate
1125: where wjsi.group_id = p_groupID
1126: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1138: update wip_job_schedule_interface wjsi

1134: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);
1135: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1136: end if;
1137:
1138: update wip_job_schedule_interface wjsi
1139: set primary_item_id = (select wdj.primary_item_id
1140: from wip_discrete_jobs wdj
1141: where wdj.organization_id = wjsi.organization_id
1142: and wdj.wip_entity_id = wjsi.wip_entity_id)

Line 1148: update wip_job_schedule_interface wjsi

1144: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1145: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1146: and wjsi.load_type = wip_constants.resched_job;
1147:
1148: update wip_job_schedule_interface wjsi
1149: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1150: wjsi.last_update_date = sysdate
1151: where wjsi.group_id = p_groupID
1152: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1171: update wip_job_schedule_interface wjsi

1167: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1168: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1169: end if;
1170:
1171: update wip_job_schedule_interface wjsi
1172: set wjsi.primary_item_id = (select msik.inventory_item_id
1173: from mtl_system_items_kfv msik
1174: where msik.organization_id = wjsi.organization_id
1175: and msik.concatenated_segments = wjsi.primary_item_segments),

Line 1186: update wip_job_schedule_interface wjsi

1182: wip_constants.create_sched)
1183: and wjsi.primary_item_segments is not null
1184: and wjsi.primary_item_id is null;
1185:
1186: update wip_job_schedule_interface wjsi
1187: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1188: wjsi.last_update_date = sysdate
1189: where wjsi.group_id = p_groupID
1190: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1207: update wip_job_schedule_interface wjsi

1203: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1204: end if;
1205:
1206: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');
1207: update wip_job_schedule_interface wjsi
1208: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1209: wjsi.last_update_date = sysdate
1210: where wjsi.group_id = p_groupID
1211: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1239: update wip_job_schedule_interface wjsi

1235: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1236: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1237: end if;
1238:
1239: update wip_job_schedule_interface wjsi
1240: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1241: wjsi.last_update_date = sysdate
1242: where wjsi.group_id = p_groupID
1243: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1261: /* update wip_job_schedule_interface wjsi

1257:
1258: /* FP bug 4378684. No need to validate whether ATO item has bill or not.
1259: This validation is removed per request by CTO team */
1260:
1261: /* update wip_job_schedule_interface wjsi
1262: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1263: wjsi.last_update_date = sysdate
1264: where wjsi.group_id = p_groupID
1265: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1298: update wip_job_schedule_interface wjsi

1294: --
1295: -- default and validate status_type
1296: -- more validation code in the validate line procedure
1297: --
1298: update wip_job_schedule_interface wjsi
1299: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1300: wjsi.last_update_date = sysdate
1301: where wjsi.group_id = p_groupID
1302: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1314: update wip_job_schedule_interface wjsi

1310: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);
1311: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1312: end if;
1313:
1314: update wip_job_schedule_interface wjsi
1315: set wjsi.status_type = WIP_CONSTANTS.UNRELEASED,
1316: wjsi.last_update_date = sysdate
1317: where wjsi.group_id = p_groupID
1318: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1323: update wip_job_schedule_interface wjsi

1319: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1320: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB)
1321: and wjsi.status_type is null;
1322:
1323: update wip_job_schedule_interface wjsi
1324: set wjsi.status_type = (select wdj.status_type
1325: from wip_discrete_jobs wdj
1326: where wdj.wip_entity_id = wjsi.wip_entity_id
1327: and wdj.organization_id = wjsi.organization_id),

Line 1337: update wip_job_schedule_interface wjsi

1333: and wjsi.status_type is null;
1334:
1335: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1336:
1337: update wip_job_schedule_interface wjsi
1338: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1339: wjsi.last_update_date = sysdate
1340: where wjsi.group_id = p_groupID
1341: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1370: update wip_job_schedule_interface wjsi

1366: --
1367: -- default and validate routing_reference and routing_reference_id
1368: --
1369: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1370: update wip_job_schedule_interface wjsi
1371: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1372: wjsi.last_update_date = sysdate
1373: where wjsi.group_id = p_groupID
1374: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1394: update wip_job_schedule_interface wjsi

1390: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1391: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1392: end if;
1393: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1394: update wip_job_schedule_interface wjsi
1395: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1396: wjsi.last_update_date = sysdate
1397: where wjsi.group_id = p_groupID
1398: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1418: update wip_job_schedule_interface wjsi

1414: end if;
1415:
1416: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1417: /* Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1418: update wip_job_schedule_interface wjsi
1419: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1420: wjsi.last_update_date = sysdate
1421: where wjsi.group_id = p_groupID
1422: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1445: update wip_job_schedule_interface wjsi

1441: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1442: end if;
1443: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1444: /* Modified for bug 5479283. When Null is passed for routing reference, old value is maintained. */
1445: update wip_job_schedule_interface wjsi
1446: set routing_reference_id = decode(wjsi.routing_reference_segments,null,(select wdj.routing_reference_id
1447: from wip_discrete_jobs wdj
1448: where wdj.wip_entity_id = wjsi.wip_entity_id
1449: and wdj.organization_id = wjsi.organization_id),

Line 1469: update wip_job_schedule_interface wjsi

1465: and wjsi.routing_reference_id is null ;
1466:
1467: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1468: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1469: update wip_job_schedule_interface wjsi
1470: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1471: wjsi.last_update_date = sysdate
1472: where wjsi.group_id = p_groupID
1473: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1494: update wip_job_schedule_interface wjsi

1490: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1491: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1492: end if;
1493: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1494: update wip_job_schedule_interface wjsi
1495: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1496: wjsi.last_update_date = sysdate
1497: where wjsi.group_id = p_groupID
1498: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1537: update wip_job_schedule_interface wjsi

1533: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1534:
1535: /*Modified for bug 5479283. When Null is passed for alt routing designator, old value is maintained.
1536: When g_miss_char is passed for alt routing designator, updated to primary routing/bom.*/
1537: update wip_job_schedule_interface wjsi
1538: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1539: wjsi.last_update_date = sysdate
1540: where wjsi.group_id = p_groupID
1541: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1573: update wip_job_schedule_interface wjsi

1569: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1570:
1571: /*Modified for bug 5479283. When Null is passed for alt routing designator, old value is maintained.
1572: When g_miss_char is passed for alt routing designator, updated to primary routing/bom.*/
1573: update wip_job_schedule_interface wjsi
1574: set wjsi.alternate_routing_designator = decode(wjsi.alternate_routing_designator,fnd_api.g_miss_char,null,null,(select wdj.alternate_routing_designator
1575: from wip_discrete_jobs wdj
1576: where wdj.organization_id = wjsi.organization_id
1577: and wdj.wip_entity_id = wjsi.wip_entity_id),wjsi.alternate_routing_designator),

Line 1590: update wip_job_schedule_interface wjsi

1586:
1587: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1588:
1589: -- you can not change the routing designator for jobs not in unreleased status
1590: update wip_job_schedule_interface wjsi
1591: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1592: wjsi.last_update_date = sysdate
1593: where wjsi.group_id = p_groupID
1594: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1617: update wip_job_schedule_interface wjsi

1613:
1614: --
1615: -- default routing_revision and routing_revision_date
1616: --
1617: update wip_job_schedule_interface wjsi
1618: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1619: wjsi.last_update_date = sysdate
1620: where wjsi.group_id = p_groupID
1621: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1635: update wip_job_schedule_interface wjsi

1631: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1632: end if;
1633:
1634: /* Fix for bug 5020741. Do not default routing revision/revision date while updating jobs.
1635: update wip_job_schedule_interface wjsi
1636: set wjsi.routing_revision = (select wdj.routing_revision
1637: from wip_discrete_jobs wdj
1638: where wdj.organization_id = wjsi.organization_id
1639: and wdj.wip_entity_id = wjsi.wip_entity_id),

Line 1648: update wip_job_schedule_interface wjsi

1644: and wjsi.load_type = wip_constants.resched_job
1645: and (wjsi.bom_revision = fnd_api.g_miss_char
1646: or wjsi.bom_revision is null);
1647:
1648: update wip_job_schedule_interface wjsi
1649: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1650: wjsi.last_update_date = sysdate
1651: where wjsi.group_id = p_groupID
1652: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1671: update wip_job_schedule_interface wjsi

1667: fnd_message.set_name('WIP', 'WIP_ROUTING_REVISION_NOCHANGE');
1668: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1669: end if;
1670:
1671: update wip_job_schedule_interface wjsi
1672: set wjsi.routing_revision_date = (select wdj.routing_revision_date
1673: from wip_discrete_jobs wdj
1674: where wdj.organization_id = wjsi.organization_id
1675: and wdj.wip_entity_id = wjsi.wip_entity_id),

Line 1684: update wip_job_schedule_interface wjsi

1680: and wjsi.load_type = wip_constants.resched_job
1681: and ( wjsi.routing_revision_date is null
1682: or wjsi.routing_revision_date = fnd_api.g_miss_date);
1683:
1684: update wip_job_schedule_interface wjsi
1685: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1686: wjsi.last_update_date = sysdate
1687: where wjsi.group_id = p_groupID
1688: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1711: update wip_job_schedule_interface wjsi

1707: --
1708: -- default and validate bom_reference and bom_reference_id
1709: --
1710: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1711: update wip_job_schedule_interface wjsi
1712: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1713: wjsi.last_update_date = sysdate
1714: where wjsi.group_id = p_groupID
1715: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1735: update wip_job_schedule_interface wjsi

1731: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1732: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1733: end if;
1734: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1735: update wip_job_schedule_interface wjsi
1736: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1737: wjsi.last_update_date = sysdate
1738: where wjsi.group_id = p_groupID
1739: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1760: update wip_job_schedule_interface wjsi

1756:
1757:
1758: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1759: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1760: update wip_job_schedule_interface wjsi
1761: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1762: wjsi.last_update_date = sysdate
1763: where wjsi.group_id = p_groupID
1764: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1787: update wip_job_schedule_interface wjsi

1783: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1784: end if;
1785: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1786: /*Modified for bug 5479283. When Null is passed for bom reference, old value is maintained. */
1787: update wip_job_schedule_interface wjsi
1788: set bom_reference_id = decode(wjsi.bom_reference_segments,null,(select wdj.bom_reference_id
1789: from wip_discrete_jobs wdj
1790: where wdj.wip_entity_id = wjsi.wip_entity_id
1791: and wdj.organization_id = wjsi.organization_id),

Line 1811: update wip_job_schedule_interface wjsi

1807: and (wjsi.bom_reference_id is null or wjsi.bom_reference_id=fnd_api.g_miss_num);
1808:
1809: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1810: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1811: update wip_job_schedule_interface wjsi
1812: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1813: wjsi.last_update_date = sysdate
1814: where wjsi.group_id = p_groupID
1815: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1836: update wip_job_schedule_interface wjsi

1832: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1833: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1834: end if;
1835: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1836: update wip_job_schedule_interface wjsi
1837: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1838: wjsi.last_update_date = sysdate
1839: where wjsi.group_id = p_groupID
1840: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1877: update wip_job_schedule_interface wjsi

1873: --
1874: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1875: /*Modified for bug 5479283. When Null is passed for alt bom designator, old value is maintained.
1876: When g_miss_char is passed for alt bom designator, updated to primary routing/bom. */
1877: update wip_job_schedule_interface wjsi
1878: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1879: wjsi.last_update_date = sysdate
1880: where wjsi.group_id = p_groupID
1881: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1914: update wip_job_schedule_interface wjsi

1910:
1911: /*Modified for bug 5479283. When Null is passed for alt bom designator, old value is maintained.
1912: When g_miss_char is passed for alt bom designator, updated to primary routing/bom. */
1913:
1914: update wip_job_schedule_interface wjsi
1915: set wjsi.alternate_bom_designator = decode(wjsi.alternate_bom_designator,fnd_api.g_miss_char,null,null,
1916: (select wdj.alternate_bom_designator
1917: from wip_discrete_jobs wdj
1918: where wdj.organization_id = wjsi.organization_id

Line 1930: update wip_job_schedule_interface wjsi

1926: or wjsi.alternate_bom_designator =fnd_api.g_miss_char);
1927:
1928: -- you can not change the bom designator for jobs not in unreleased status
1929: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1930: update wip_job_schedule_interface wjsi
1931: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1932: wjsi.last_update_date = sysdate
1933: where wjsi.group_id = p_groupID
1934: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1957: update wip_job_schedule_interface wjsi

1953:
1954: --
1955: -- default bom_revision and bom_revision_date
1956: --
1957: update wip_job_schedule_interface wjsi
1958: set wjsi.process_status = WIP_CONSTANTS.WARNING,
1959: wjsi.last_update_date = sysdate
1960: where wjsi.group_id = p_groupID
1961: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 1975: update wip_job_schedule_interface wjsi

1971: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1972: end if;
1973:
1974: /* Fix for bug 5020741. Do not default bom revision/revision date while updating jobs.
1975: update wip_job_schedule_interface wjsi
1976: set wjsi.bom_revision = (select wdj.bom_revision
1977: from wip_discrete_jobs wdj
1978: where wdj.organization_id = wjsi.organization_id
1979: and wdj.wip_entity_id = wjsi.wip_entity_id),

Line 1988: update wip_job_schedule_interface wjsi

1984: and wjsi.load_type = wip_constants.resched_job
1985: and (wjsi.bom_revision = fnd_api.g_miss_char
1986: or wjsi.bom_revision is null);
1987:
1988: update wip_job_schedule_interface wjsi
1989: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1990: wjsi.last_update_date = sysdate
1991: where wjsi.group_id = p_groupID
1992: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2011: update wip_job_schedule_interface wjsi

2007: fnd_message.set_name('WIP', 'WIP_BOM_REVISION_NOCHANGE');
2008: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2009: end if;
2010:
2011: update wip_job_schedule_interface wjsi
2012: set wjsi.bom_revision_date = (select wdj.bom_revision_date
2013: from wip_discrete_jobs wdj
2014: where wdj.organization_id = wjsi.organization_id
2015: and wdj.wip_entity_id = wjsi.wip_entity_id),

Line 2024: update wip_job_schedule_interface wjsi

2020: and wjsi.load_type = wip_constants.resched_job
2021: and ( wjsi.bom_revision_date = fnd_api.g_miss_date
2022: or wjsi.bom_revision_date is null);
2023:
2024: update wip_job_schedule_interface wjsi
2025: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2026: wjsi.last_update_date = sysdate
2027: where wjsi.group_id = p_groupID
2028: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2053: update wip_job_schedule_interface wjsi

2049:
2050: --
2051: -- default and validate wip_supply_type
2052: --
2053: update wip_job_schedule_interface wjsi
2054: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2055: wjsi.last_update_date = sysdate
2056: where wjsi.group_id = p_groupID
2057: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2069: update wip_job_schedule_interface wjsi

2065: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);
2066: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2067: end if;
2068:
2069: update wip_job_schedule_interface wjsi
2070: set wjsi.wip_supply_type = wip_constants.based_on_bom,
2071: wjsi.last_update_date = sysdate
2072: where wjsi.group_id = p_groupID
2073: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2079: update wip_job_schedule_interface wjsi

2075: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB)
2076: and wjsi.wip_supply_type is null;
2077:
2078: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2079: update wip_job_schedule_interface wjsi
2080: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2081: wjsi.last_update_date = sysdate
2082: where wjsi.group_id = p_groupID
2083: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2120: update wip_job_schedule_interface wjsi

2116:
2117: --
2118: -- default and validate start_quantity
2119: --
2120: update wip_job_schedule_interface wjsi
2121: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2122: wjsi.last_update_date = sysdate
2123: where wjsi.group_id = p_groupID
2124: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2146: update wip_job_schedule_interface wjsi

2142: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2143: end if;
2144:
2145: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2146: update wip_job_schedule_interface wjsi
2147: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2148: wjsi.last_update_date = sysdate
2149: where wjsi.group_id = p_groupID
2150: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2170: update wip_job_schedule_interface wjsi

2166: fnd_message.set_name('WIP', 'WIP_ML_START_QUANTITY');
2167: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2168: end if;
2169:
2170: update wip_job_schedule_interface wjsi
2171: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2172: wjsi.last_update_date = sysdate
2173: where wjsi.group_id = p_groupID
2174: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2201: update wip_job_schedule_interface wjsi

2197:
2198: --
2199: -- default and validate net_quantity
2200: --
2201: update wip_job_schedule_interface wjsi
2202: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2203: wjsi.last_update_date = sysdate
2204: where wjsi.group_id = p_groupID
2205: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2217: update wip_job_schedule_interface wjsi

2213: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);
2214: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2215: end if;
2216:
2217: update wip_job_schedule_interface wjsi
2218: set wjsi.net_quantity = wjsi.start_quantity,
2219: wjsi.last_update_date = sysdate
2220: where wjsi.group_id = p_groupID
2221: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2226: update wip_job_schedule_interface wjsi

2222: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2223: and wjsi.load_type = wip_constants.create_job
2224: and wjsi.net_quantity is null;
2225:
2226: update wip_job_schedule_interface wjsi
2227: set wjsi.net_quantity = (select decode(wdj.net_quantity,
2228: wdj.start_quantity, wjsi.start_quantity,
2229: least(wdj.net_quantity, nvl(wjsi.start_quantity, wdj.net_quantity)))
2230: from wip_discrete_jobs wdj

Line 2240: update wip_job_schedule_interface wjsi

2236: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2237: and wjsi.load_type = wip_constants.resched_job
2238: and wjsi.net_quantity is null;
2239:
2240: update wip_job_schedule_interface wjsi
2241: set wjsi.net_quantity = 0,
2242: wjsi.last_update_date = sysdate
2243: where wjsi.group_id = p_groupID
2244: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2250: update wip_job_schedule_interface wjsi

2246: and wjsi.load_type = wip_constants.create_ns_job
2247: and wjsi.net_quantity is null;
2248:
2249: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2250: update wip_job_schedule_interface wjsi
2251: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2252: wjsi.last_update_date = sysdate
2253: where wjsi.group_id = p_groupID
2254: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2286: update wip_job_schedule_interface wjsi

2282:
2283: --
2284: -- overcompletion_tolerance_type and overcompletion_tolerance_value
2285: --
2286: update wip_job_schedule_interface wjsi
2287: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2288: wjsi.last_update_date = sysdate
2289: where wjsi.group_id = p_groupID
2290: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2304: update wip_job_schedule_interface wjsi

2300: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);
2301: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2302: end if;
2303:
2304: update wip_job_schedule_interface wjsi
2305: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2306: wjsi.last_update_date = sysdate
2307: where wjsi.group_id = p_groupID
2308: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2325: update wip_job_schedule_interface wjsi

2321:
2322: --
2323: -- default due_date
2324: --
2325: update wip_job_schedule_interface wjsi
2326: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2327: wjsi.last_update_date = sysdate
2328: where wjsi.group_id = p_groupID
2329: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2341: update wip_job_schedule_interface wjsi

2337: fnd_message.set_token('COLUMN', 'DUE_DATE', false);
2338: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2339: end if;
2340:
2341: update wip_job_schedule_interface wjsi
2342: set wjsi.due_date = wjsi.last_unit_completion_date,
2343: wjsi.last_update_date = sysdate
2344: where wjsi.group_id = p_groupID
2345: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2354: update wip_job_schedule_interface wjsi

2350:
2351: --
2352: -- validate date_released
2353: --
2354: update wip_job_schedule_interface wjsi
2355: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2356: wjsi.last_update_date = sysdate
2357: where wjsi.group_id = p_groupID
2358: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2370: update wip_job_schedule_interface wjsi

2366: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);
2367: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2368: end if;
2369:
2370: update wip_job_schedule_interface wjsi
2371: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2372: wjsi.last_update_date = sysdate
2373: where wjsi.group_id = p_groupID
2374: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2384: update wip_job_schedule_interface wjsi

2380: if ( sql%rowcount > 0 ) then
2381: fnd_message.set_name('WIP', 'WIP_INVALID_RELEASE_DATE');
2382: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2383: -- set it to sysdate
2384: update wip_job_schedule_interface wjsi
2385: set wjsi.date_released = sysdate,
2386: wjsi.last_update_date = sysdate
2387: where wjsi.group_id = p_groupID
2388: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2394: update wip_job_schedule_interface wjsi

2390: and wjsi.date_released > sysdate
2391: and wjsi.status_type = wip_constants.released;
2392: end if;
2393:
2394: update wip_job_schedule_interface wjsi
2395: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2396: wjsi.last_update_date = sysdate
2397: where wjsi.group_id = p_groupID
2398: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2425: update wip_job_schedule_interface wjsi

2421:
2422: --
2423: -- requested_start_date
2424: --
2425: update wip_job_schedule_interface wjsi
2426: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2427: wjsi.last_update_date = sysdate
2428: where wjsi.group_id = p_groupID
2429: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2441: update wip_job_schedule_interface wjsi

2437: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);
2438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2439: end if;
2440:
2441: update wip_job_schedule_interface wjsi
2442: set wjsi.requested_start_date = wjsi.first_unit_start_date,
2443: wjsi.last_update_date = sysdate
2444: where wjsi.group_id = p_groupID
2445: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2454: update wip_job_schedule_interface wjsi

2450:
2451: --
2452: -- header_id
2453: --
2454: update wip_job_schedule_interface wjsi
2455: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2456: wjsi.last_update_date = sysdate
2457: where wjsi.group_id = p_groupID
2458: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2473: update wip_job_schedule_interface wjsi

2469:
2470: --
2471: -- default and validate processing_work_days
2472: --
2473: update wip_job_schedule_interface wjsi
2474: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2475: wjsi.last_update_date = sysdate
2476: where wjsi.group_id = p_groupID
2477: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2490: update wip_job_schedule_interface wjsi

2486: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2487: end if;
2488:
2489: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2490: update wip_job_schedule_interface wjsi
2491: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2492: wjsi.last_update_date = sysdate
2493: where wjsi.group_id = p_groupID
2494: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2509: update wip_job_schedule_interface wjsi

2505:
2506: --
2507: -- default and validate daily_production_rate
2508: --
2509: update wip_job_schedule_interface wjsi
2510: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2511: wjsi.last_update_date = sysdate
2512: where wjsi.group_id = p_groupID
2513: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2526: update wip_job_schedule_interface wjsi

2522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2523: end if;
2524:
2525: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2526: update wip_job_schedule_interface wjsi
2527: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2528: wjsi.last_update_date = sysdate
2529: where wjsi.group_id = p_groupID
2530: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2545: update wip_job_schedule_interface wjsi

2541:
2542: --
2543: -- default and validate demand_class
2544: --
2545: update wip_job_schedule_interface wjsi
2546: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2547: wjsi.last_update_date = sysdate
2548: where wjsi.group_id = p_groupID
2549: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2561: update wip_job_schedule_interface wjsi

2557: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);
2558: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2559: end if;
2560:
2561: update wip_job_schedule_interface wjsi
2562: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2563: wjsi.last_update_date = sysdate
2564: where wjsi.group_id = p_groupID
2565: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2584: update wip_job_schedule_interface wjsi

2580:
2581: --
2582: -- default and validate completion_subinventory
2583: --
2584: update wip_job_schedule_interface wjsi
2585: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2586: wjsi.last_update_date = sysdate
2587: where wjsi.group_id = p_groupID
2588: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2601: update wip_job_schedule_interface wjsi

2597: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);
2598: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2599: end if;
2600:
2601: update wip_job_schedule_interface wjsi
2602: set wjsi.completion_subinventory =
2603: (select bor.completion_subinventory
2604: from bom_operational_routings bor
2605: where bor.organization_id = wjsi.organization_id

Line 2622: update wip_job_schedule_interface wjsi

2618: and wjsi.completion_subinventory is null
2619: and wjsi.load_type IN (wip_constants.create_job,
2620: wip_constants.create_ns_job) ; -- Bug 9765343 for ns job
2621:
2622: update wip_job_schedule_interface wjsi
2623: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2624: wjsi.last_update_date = sysdate
2625: where wjsi.group_id = p_groupID
2626: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2641: update wip_job_schedule_interface wjsi

2637:
2638: --
2639: -- Default completion_locator_id
2640: --
2641: update wip_job_schedule_interface wjsi
2642: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2643: wjsi.last_update_date = sysdate
2644: where wjsi.group_id = p_groupID
2645: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2658: update wip_job_schedule_interface wjsi

2654: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);
2655: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2656: end if;
2657:
2658: update wip_job_schedule_interface wjsi
2659: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2660: wjsi.last_update_date = sysdate
2661: where wjsi.group_id = p_groupID
2662: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2676: update wip_job_schedule_interface wjsi

2672: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);
2673: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2674: end if;
2675:
2676: update wip_job_schedule_interface wjsi
2677: set wjsi.completion_locator_id =
2678: (select bor.completion_locator_id
2679: from bom_operational_routings bor
2680: where bor.organization_id = wjsi.organization_id

Line 2699: update wip_job_schedule_interface wjsi

2695: and wjsi.completion_locator_segments is null
2696: and wjsi.load_type IN (wip_constants.create_job,
2697: wip_constants.create_ns_job) ; -- Bug 9765343 for ns job
2698:
2699: update wip_job_schedule_interface wjsi
2700: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2701: wjsi.last_update_date = sysdate
2702: where wjsi.group_id = p_groupID
2703: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2718: update wip_job_schedule_interface wjsi

2714:
2715: --
2716: -- default and validate lot_number
2717: --
2718: update wip_job_schedule_interface wjsi
2719: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2720: wjsi.last_update_date = sysdate
2721: where wjsi.group_id = p_groupID
2722: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2737: update wip_job_schedule_interface wjsi

2733:
2734: --
2735: -- default and validate source_code and source_line_id
2736: --
2737: update wip_job_schedule_interface wjsi
2738: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2739: wjsi.last_update_date = sysdate
2740: where wjsi.group_id = p_groupID
2741: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2753: update wip_job_schedule_interface wjsi

2749: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);
2750: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2751: end if;
2752:
2753: update wip_job_schedule_interface wjsi
2754: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2755: wjsi.last_update_date = sysdate
2756: where wjsi.group_id = p_groupID
2757: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2772: update wip_job_schedule_interface wjsi

2768:
2769: --
2770: -- default and validate scheduling_method
2771: --
2772: update wip_job_schedule_interface wjsi
2773: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2774: wjsi.last_update_date = sysdate
2775: where wjsi.group_id = p_groupID
2776: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2789: update wip_job_schedule_interface wjsi

2785: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2786: end if;
2787:
2788: /*bug 7568044: setting scheduling_method to be manual for a non-standard discrete job in case when no routing reference is provided*/
2789: update wip_job_schedule_interface wjsi
2790: set wjsi.scheduling_method = wip_constants.ml_manual,
2791: wjsi.last_update_date = sysdate
2792: where wjsi.group_id = p_groupID
2793: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2799: update wip_job_schedule_interface wjsi

2795: and wjsi.scheduling_method is null
2796: and wjsi.load_type = WIP_CONSTANTS.CREATE_NS_JOB
2797: and wjsi.routing_reference_id is null;
2798:
2799: update wip_job_schedule_interface wjsi
2800: set wjsi.scheduling_method = wip_constants.routing,
2801: wjsi.last_update_date = sysdate
2802: where wjsi.group_id = p_groupID
2803: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2809: update wip_job_schedule_interface wjsi

2805: and wjsi.scheduling_method is null
2806: and ( wjsi.allow_explosion is null
2807: or upper(wjsi.allow_explosion) <> 'N');
2808:
2809: update wip_job_schedule_interface wjsi
2810: set wjsi.scheduling_method = wip_constants.ml_manual,
2811: wjsi.last_update_date = sysdate
2812: where wjsi.group_id = p_groupID
2813: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2818: update wip_job_schedule_interface wjsi

2814: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
2815: and wjsi.scheduling_method is null
2816: and upper(wjsi.allow_explosion) = 'N';
2817:
2818: update wip_job_schedule_interface wjsi
2819: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2820: wjsi.last_update_date = sysdate
2821: where wjsi.group_id = p_groupID
2822: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2837: update wip_job_schedule_interface wjsi

2833: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2834: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2835: end if;
2836:
2837: update wip_job_schedule_interface wjsi
2838: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2839: wjsi.last_update_date = sysdate
2840: where wjsi.group_id = p_groupID
2841: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2866: update wip_job_schedule_interface wjsi

2862: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2863: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2864: end if;
2865:
2866: update wip_job_schedule_interface wjsi
2867: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2868: wjsi.last_update_date = sysdate
2869: where wjsi.group_id = p_groupID
2870: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2887: update wip_job_schedule_interface wjsi

2883:
2884: --
2885: -- default and validate allow_explosion
2886: --
2887: update wip_job_schedule_interface wjsi
2888: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2889: wjsi.last_update_date = sysdate
2890: where wjsi.group_id = p_groupID
2891: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2906: update wip_job_schedule_interface wjsi

2902:
2903: --
2904: -- default and validate allow_explosion
2905: --
2906: update wip_job_schedule_interface wjsi
2907: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2908: wjsi.last_update_date = sysdate
2909: where wjsi.group_id = p_groupID
2910: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2925: update wip_job_schedule_interface wjsi

2921:
2922: --
2923: -- default and validate end_item_unit_number
2924: --
2925: update wip_job_schedule_interface wjsi
2926: set wjsi.process_status = WIP_CONSTANTS.WARNING,
2927: wjsi.last_update_date = sysdate
2928: where wjsi.group_id = p_groupID
2929: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 2947: update wip_job_schedule_interface wjsi

2943: -- validate schedule dates
2944: --
2945: if ( p_validationLevel not in (wip_constants.mrp, wip_constants.ato) ) then
2946: /* Modified For bug 5479283. To check against current value of routing reference id.*/
2947: update wip_job_schedule_interface wjsi
2948: set wjsi.process_status = WIP_CONSTANTS.ERROR,
2949: wjsi.last_update_date = sysdate
2950: where wjsi.group_id = p_groupID
2951: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3013: update wip_job_schedule_interface wjsi

3009: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_DATES');
3010: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3011: end if;
3012:
3013: update wip_job_schedule_interface wjsi
3014: set wjsi.process_status = WIP_CONSTANTS.WARNING,
3015: wjsi.last_update_date = sysdate
3016: where wjsi.group_id = p_groupID
3017: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3029: update wip_job_schedule_interface wjsi

3025: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);
3026: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3027: end if;
3028:
3029: update wip_job_schedule_interface wjsi
3030: set wjsi.process_status = WIP_CONSTANTS.WARNING,
3031: wjsi.last_update_date = sysdate
3032: where wjsi.group_id = p_groupID
3033: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3049: update wip_job_schedule_interface wjsi

3045:
3046: --
3047: -- validate serialization_start_op
3048: --
3049: update wip_job_schedule_interface wjsi
3050: set wjsi.process_status = WIP_CONSTANTS.ERROR,
3051: wjsi.last_update_date = sysdate
3052: where wjsi.group_id = p_groupID
3053: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 3103: from wip_job_schedule_interface

3099:
3100: cursor c_line is
3101: select rowid,
3102: interface_id
3103: from wip_job_schedule_interface
3104: where group_id = p_groupID
3105: and process_phase = WIP_CONSTANTS.ML_VALIDATION
3106: and process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING);
3107: begin

Line 3202: update wip_job_schedule_interface

3198: end if;
3199: end;
3200: --Bug#13483213:bom_revision_Date and routing_revision_date are no longer truncated to the seconds. The actual timestamp is updated.
3201:
3202: update wip_job_schedule_interface
3203: set project_id = wjsi_row.project_id,
3204: task_id = wjsi_row.task_id,
3205: status_type = wjsi_row.status_type,
3206: class_code = wjsi_row.class_code,

Line 3264: from wip_job_schedule_interface

3260: l_primaryItemID number;
3261: begin
3262: select *
3263: into wjsi_row
3264: from wip_job_schedule_interface
3265: where rowid = p_rowid;
3266:
3267: if ( wjsi_row.load_type = wip_constants.resched_job ) then
3268: select we.wip_entity_name,

Line 4220: from wip_job_schedule_interface

4216: select end_item_unit_number into wjsi_row.end_item_unit_number
4217: from wip_discrete_jobs
4218: where wip_entity_id =
4219: (select wip_entity_id
4220: from wip_job_schedule_interface
4221: where rowid = p_rowid
4222: );
4223: exception
4224: when others then

Line 4511: from wip_parameters wp, wip_job_schedule_interface wjsi

4507: l_startOp,
4508: l_wipID,
4509: l_primaryItem,
4510: l_orgID
4511: from wip_parameters wp, wip_job_schedule_interface wjsi
4512: where wjsi.rowid = p_rowid
4513: and wjsi.organization_id = wp.organization_id;
4514:
4515: if( l_startOp is not null or l_primaryItem is null ) then

Line 4574: from wip_job_schedule_interface wjsi

4570: serialization_start_op,
4571: load_type,
4572: interface_id
4573: into l_wipEntityID, l_serialOp, l_loadType, l_interfaceID
4574: from wip_job_schedule_interface wjsi
4575: where wjsi.rowid = p_rowid;
4576:
4577: if ( l_serialOp is null ) then
4578: if ( wjsi_row.load_type = wip_constants.resched_job ) then

Line 5052: update wip_job_schedule_interface

5048: if ( p_type = validationWarning ) then
5049: l_processStatus := wip_constants.warning;
5050: end if;
5051:
5052: update wip_job_schedule_interface
5053: set process_status = l_processStatus,
5054: last_update_date = sysdate
5055: where rowid = p_rowid;
5056: /*Bug 16529960: error message p_text passed in can be larger than the database's maximum column width.