[Home] [Help]
238: WIP_CONSTANTS.CREATE_NS_JOB)
239: returning wjsi.interface_id bulk collect into l_interfaceTbl;
240:
241: if ( sql%rowcount > 0 ) then
242: fnd_message.set_name('WIP', 'WIP_ML_LOAD_TYPE');
243: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
244: end if;
245:
246: --
239: returning wjsi.interface_id bulk collect into l_interfaceTbl;
240:
241: if ( sql%rowcount > 0 ) then
242: fnd_message.set_name('WIP', 'WIP_ML_LOAD_TYPE');
243: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
244: end if;
245:
246: --
247: --Fix for bug#4186944. Update REQUEST_ID
271: where usr.user_name = wjsi.created_by_name)
272: returning wjsi.interface_id bulk collect into l_interfaceTbl;
273:
274: if ( sql%rowcount > 0 ) then
275: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
276: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
277: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
278: end if;
279:
272: returning wjsi.interface_id bulk collect into l_interfaceTbl;
273:
274: if ( sql%rowcount > 0 ) then
275: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
276: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
277: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
278: end if;
279:
280: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
273:
274: if ( sql%rowcount > 0 ) then
275: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
276: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
277: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
278: end if;
279:
280: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
281:
289: and wjsi.created_by is not null
290: returning wjsi.interface_id bulk collect into l_interfaceTbl;
291:
292: if ( sql%rowcount > 0 ) then
293: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
294: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
295: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
296: end if;
297:
290: returning wjsi.interface_id bulk collect into l_interfaceTbl;
291:
292: if ( sql%rowcount > 0 ) then
293: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
291:
292: if ( sql%rowcount > 0 ) then
293: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
319: and sysdate between usr.start_date and nvl(end_date, sysdate))
320: returning wjsi.interface_id bulk collect into l_interfaceTbl;
321:
322: if ( sql%rowcount > 0 ) then
323: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
324: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
325: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
326: end if;
327:
320: returning wjsi.interface_id bulk collect into l_interfaceTbl;
321:
322: if ( sql%rowcount > 0 ) then
323: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
324: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
325: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
326: end if;
327:
328:
321:
322: if ( sql%rowcount > 0 ) then
323: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
324: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
325: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
326: end if;
327:
328:
329: --
342: where usr.user_name = wjsi.last_updated_by_name)
343: returning wjsi.interface_id bulk collect into l_interfaceTbl;
344:
345: if ( sql%rowcount > 0 ) then
346: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
347: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
348: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
349: end if;
350: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
343: returning wjsi.interface_id bulk collect into l_interfaceTbl;
344:
345: if ( sql%rowcount > 0 ) then
346: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
347: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
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:
344:
345: if ( sql%rowcount > 0 ) then
346: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
347: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
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
359: and wjsi.last_updated_by is not null
360: returning wjsi.interface_id bulk collect into l_interfaceTbl;
361:
362: if ( sql%rowcount > 0 ) then
363: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
364: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
365: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
366: end if;
367:
360: returning wjsi.interface_id bulk collect into l_interfaceTbl;
361:
362: if ( sql%rowcount > 0 ) then
363: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
361:
362: if ( sql%rowcount > 0 ) then
363: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
390: and sysdate between usr.start_date and nvl(end_date, sysdate))
391: returning wjsi.interface_id bulk collect into l_interfaceTbl;
392:
393: if ( sql%rowcount > 0 ) then
394: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
395: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
396: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
397: end if;
398:
391: returning wjsi.interface_id bulk collect into l_interfaceTbl;
392:
393: if ( sql%rowcount > 0 ) then
394: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
395: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
396: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
397: end if;
398:
399:
392:
393: if ( sql%rowcount > 0 ) then
394: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
395: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
396: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
397: end if;
398:
399:
400: --
415: where ood.organization_code = wjsi.organization_code)
416: returning wjsi.interface_id bulk collect into l_interfaceTbl;
417:
418: if ( sql%rowcount > 0 ) then
419: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
420: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
421: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
422: end if;
423:
416: returning wjsi.interface_id bulk collect into l_interfaceTbl;
417:
418: if ( sql%rowcount > 0 ) then
419: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
420: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
421: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
422: end if;
423:
424: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
417:
418: if ( sql%rowcount > 0 ) then
419: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
420: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
421: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
422: end if;
423:
424: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
425:
433: and wjsi.organization_id is not null
434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
435:
436: if ( sql%rowcount > 0 ) then
437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
438: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
440: end if;
441:
434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
435:
436: if ( sql%rowcount > 0 ) then
437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
438: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
440: end if;
441:
442: -- Bug 4890514. Performance Fix
435:
436: if ( sql%rowcount > 0 ) then
437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
438: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
440: end if;
441:
442: -- Bug 4890514. Performance Fix
443: -- saugupta 25th-May-2006
472: and sysdate < nvl(ood.date_to, sysdate + 1))
473: returning wjsi.interface_id bulk collect into l_interfaceTbl;
474:
475: if ( sql%rowcount > 0 ) then
476: fnd_message.set_name('WIP', 'WIP_ML_ORGANIZATION_ID');
477: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
478: end if;
479:
480: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
473: returning wjsi.interface_id bulk collect into l_interfaceTbl;
474:
475: if ( sql%rowcount > 0 ) then
476: fnd_message.set_name('WIP', 'WIP_ML_ORGANIZATION_ID');
477: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
478: end if;
479:
480: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
481:
498: and we.organization_id = wjsi.organization_id)
499: returning wjsi.interface_id bulk collect into l_interfaceTbl;
500:
501: if ( sql%rowcount > 0 ) then
502: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
503: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
504: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
505: end if;
506:
499: returning wjsi.interface_id bulk collect into l_interfaceTbl;
500:
501: if ( sql%rowcount > 0 ) then
502: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
500:
501: if ( sql%rowcount > 0 ) then
502: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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,
516: (wjsi.load_type = WIP_CONSTANTS.CREATE_SCHED) )
517: returning wjsi.interface_id bulk collect into l_interfaceTbl;
518:
519: if ( sql%rowcount > 0 ) then
520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
521: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
523: end if;
524:
517: returning wjsi.interface_id bulk collect into l_interfaceTbl;
518:
519: if ( sql%rowcount > 0 ) then
520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
518:
519: if ( sql%rowcount > 0 ) then
520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
557: and we.organization_id = wjsi.organization_id)
558: returning wjsi.interface_id bulk collect into l_interfaceTbl;
559:
560: if ( sql%rowcount > 0 ) then
561: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
562: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
563: end if;
564:
565: --
558: returning wjsi.interface_id bulk collect into l_interfaceTbl;
559:
560: if ( sql%rowcount > 0 ) then
561: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
562: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
563: end if;
564:
565: --
566: -- validate wip entity id
577: WIP_CONSTANTS.CREATE_SCHED)
578: returning wjsi.interface_id bulk collect into l_interfaceTbl;
579:
580: if ( sql%rowcount > 0 ) then
581: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
582: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);
583: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
584: end if;
585:
578: returning wjsi.interface_id bulk collect into l_interfaceTbl;
579:
580: if ( sql%rowcount > 0 ) then
581: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
579:
580: if ( sql%rowcount > 0 ) then
581: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
611: and we.wip_entity_id = wjsi.wip_entity_id)))
612: returning wjsi.interface_id bulk collect into l_interfaceTbl;
613:
614: if ( sql%rowcount > 0 ) then
615: fnd_message.set_name('WIP', 'WIP_ML_WIP_ENTITY_ID');
616: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
617: end if;
618:
619: --
612: returning wjsi.interface_id bulk collect into l_interfaceTbl;
613:
614: if ( sql%rowcount > 0 ) then
615: fnd_message.set_name('WIP', 'WIP_ML_WIP_ENTITY_ID');
616: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
617: end if;
618:
619: --
620: -- validate for entity type
633: and we.entity_type <> 1)
634: returning wjsi.interface_id bulk collect into l_interfaceTbl;
635:
636: if ( sql%rowcount > 0 ) then
637: fnd_message.set_name('WIP', 'WIP_ML_ENTITY_TYPE');
638: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
639: end if;
640:
641: --
634: returning wjsi.interface_id bulk collect into l_interfaceTbl;
635:
636: if ( sql%rowcount > 0 ) then
637: fnd_message.set_name('WIP', 'WIP_ML_ENTITY_TYPE');
638: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
639: end if;
640:
641: --
642: -- default and validate repetitve_schedule_id
651: and wjsi.repetitive_schedule_id is not null
652: returning wjsi.interface_id bulk collect into l_interfaceTbl;
653:
654: if ( sql%rowcount > 0 ) then
655: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
656: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);
657: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
658: end if;
659:
652: returning wjsi.interface_id bulk collect into l_interfaceTbl;
653:
654: if ( sql%rowcount > 0 ) then
655: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
653:
654: if ( sql%rowcount > 0 ) then
655: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
678: and wjsi.schedule_group_id is not null
679: returning wjsi.interface_id bulk collect into l_interfaceTbl;
680:
681: if ( sql%rowcount > 0 ) then
682: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
683: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);
684: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
685: end if;
686:
679: returning wjsi.interface_id bulk collect into l_interfaceTbl;
680:
681: if ( sql%rowcount > 0 ) then
682: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
680:
681: if ( sql%rowcount > 0 ) then
682: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
695: and wjsi.schedule_group_name is not null
696: returning wjsi.interface_id bulk collect into l_interfaceTbl;
697:
698: if ( sql%rowcount > 0 ) then
699: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
700: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);
701: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
702: end if;
703:
696: returning wjsi.interface_id bulk collect into l_interfaceTbl;
697:
698: if ( sql%rowcount > 0 ) then
699: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
697:
698: if ( sql%rowcount > 0 ) then
699: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
718: and sg.organization_id = wjsi.organization_id)
719: returning wjsi.interface_id bulk collect into l_interfaceTbl;
720:
721: if ( sql%rowcount > 0 ) then
722: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
723: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);
724: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
725: end if;
726:
719: returning wjsi.interface_id bulk collect into l_interfaceTbl;
720:
721: if ( sql%rowcount > 0 ) then
722: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
720:
721: if ( sql%rowcount > 0 ) then
722: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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 =
844: and sg.organization_id = wjsi.organization_id)
845: returning wjsi.interface_id bulk collect into l_interfaceTbl;
846:
847: if ( sql%rowcount > 0 ) then
848: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
849: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
850: end if;
851:
852: --
845: returning wjsi.interface_id bulk collect into l_interfaceTbl;
846:
847: if ( sql%rowcount > 0 ) then
848: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
849: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
850: end if;
851:
852: --
853: -- default build_sequence
862: and wjsi.load_type = wip_constants.create_sched
863: returning wjsi.interface_id bulk collect into l_interfaceTbl;
864:
865: if ( sql%rowcount > 0 ) then
866: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
867: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
868: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
869: end if;
870:
863: returning wjsi.interface_id bulk collect into l_interfaceTbl;
864:
865: if ( sql%rowcount > 0 ) then
866: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
867: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
868: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
869: end if;
870:
871: --
864:
865: if ( sql%rowcount > 0 ) then
866: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
867: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
868: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
869: end if;
870:
871: --
872: -- default and validate line_code and line_id
888: and wl.organization_id = wjsi.organization_id)
889: returning wjsi.interface_id bulk collect into l_interfaceTbl;
890:
891: if ( sql%rowcount > 0 ) then
892: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
893: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
894: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
895: end if;
896: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
889: returning wjsi.interface_id bulk collect into l_interfaceTbl;
890:
891: if ( sql%rowcount > 0 ) then
892: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
893: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
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:
890:
891: if ( sql%rowcount > 0 ) then
892: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
893: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
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
905: and wjsi.line_id is not null
906: returning wjsi.interface_id bulk collect into l_interfaceTbl;
907:
908: if ( sql%rowcount > 0 ) then
909: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
910: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
911: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
912: end if;
913:
906: returning wjsi.interface_id bulk collect into l_interfaceTbl;
907:
908: if ( sql%rowcount > 0 ) then
909: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
907:
908: if ( sql%rowcount > 0 ) then
909: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
938: and wl.organization_id = wjsi.organization_id)
939: returning wjsi.interface_id bulk collect into l_interfaceTbl;
940:
941: if ( sql%rowcount > 0 ) then
942: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
943: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
944: end if;
945:
946: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
939: returning wjsi.interface_id bulk collect into l_interfaceTbl;
940:
941: if ( sql%rowcount > 0 ) then
942: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
943: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
944: end if;
945:
946: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
947:
956: and wjsi.serialization_start_op is not null
957: returning wjsi.interface_id bulk collect into l_interfaceTbl;
958:
959: if ( sql%rowcount > 0 ) then
960: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
961: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
962: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
963: end if;
964:
957: returning wjsi.interface_id bulk collect into l_interfaceTbl;
958:
959: if ( sql%rowcount > 0 ) then
960: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
961: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
962: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
963: end if;
964:
965: --
958:
959: if ( sql%rowcount > 0 ) then
960: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
961: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
962: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
963: end if;
964:
965: --
966: -- default and validate project_number and project_id
975: and wjsi.project_number is not null
976: returning wjsi.interface_id bulk collect into l_interfaceTbl;
977:
978: if ( sql%rowcount > 0 ) then
979: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
980: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
981: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
982: end if;
983:
976: returning wjsi.interface_id bulk collect into l_interfaceTbl;
977:
978: if ( sql%rowcount > 0 ) then
979: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
977:
978: if ( sql%rowcount > 0 ) then
979: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
991: and wjsi.project_id is not null
992: returning wjsi.interface_id bulk collect into l_interfaceTbl;
993:
994: if ( sql%rowcount > 0 ) then
995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
996: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
998: end if;
999:
992: returning wjsi.interface_id bulk collect into l_interfaceTbl;
993:
994: if ( sql%rowcount > 0 ) then
995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
996: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
998: end if;
999:
1000: --
993:
994: if ( sql%rowcount > 0 ) then
995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
996: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
998: end if;
999:
1000: --
1001: -- default and validate task_number and task_id
1010: and wjsi.task_number is not null
1011: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1012:
1013: if ( sql%rowcount > 0 ) then
1014: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1015: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
1016: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1017: end if;
1018:
1011: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1012:
1013: if ( sql%rowcount > 0 ) then
1014: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1012:
1013: if ( sql%rowcount > 0 ) then
1014: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
1026: and wjsi.task_id is not null
1027: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1028:
1029: if ( sql%rowcount > 0 ) then
1030: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1031: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1033: end if;
1034:
1027: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1028:
1029: if ( sql%rowcount > 0 ) then
1030: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1031: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1033: end if;
1034:
1035: --
1028:
1029: if ( sql%rowcount > 0 ) then
1030: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1031: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1033: end if;
1034:
1035: --
1036: -- default and validate firm_planned_flag
1065: or (wjsi.firm_planned_flag not in (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO)))
1066: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1067:
1068: if ( sql%rowcount > 0 ) then
1069: fnd_message.set_name('WIP', 'WIP_ML_FIRM_PLANNED_FLAG');
1070: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1071: end if;
1072: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1073:
1066: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1067:
1068: if ( sql%rowcount > 0 ) then
1069: fnd_message.set_name('WIP', 'WIP_ML_FIRM_PLANNED_FLAG');
1070: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1071: end if;
1072: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1073:
1074: --
1073:
1074: --
1075: -- default description
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,
1074: --
1075: -- default description
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
1075: -- default description
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
1086: and wjsi.description is null
1087: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
1088: WIP_CONSTANTS.CREATE_NS_JOB);
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,
1087: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
1088: WIP_CONSTANTS.CREATE_NS_JOB);
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
1088: WIP_CONSTANTS.CREATE_NS_JOB);
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
1113: and wjsi.primary_item_segments is not null
1114: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1115:
1116: if ( sql%rowcount > 0 ) then
1117: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1118: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1119: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1120: end if;
1121:
1114: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1115:
1116: if ( sql%rowcount > 0 ) then
1117: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1115:
1116: if ( sql%rowcount > 0 ) then
1117: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
1129: and wjsi.primary_item_id is not null
1130: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1131:
1132: if ( sql%rowcount > 0 ) then
1133: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1134: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);
1135: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1136: end if;
1137:
1130: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1131:
1132: if ( sql%rowcount > 0 ) then
1133: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1131:
1132: if ( sql%rowcount > 0 ) then
1133: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1162: and msik.concatenated_segments = wjsi.primary_item_segments)
1163: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1164:
1165: if ( sql%rowcount > 0 ) then
1166: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1167: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1168: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1169: end if;
1170:
1163: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1164:
1165: if ( sql%rowcount > 0 ) then
1166: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
1164:
1165: if ( sql%rowcount > 0 ) then
1166: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
1198: and msi.inventory_item_id = wjsi.primary_item_id)
1199: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1200:
1201: if ( sql%rowcount > 0 ) then
1202: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
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');
1199: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1200:
1201: if ( sql%rowcount > 0 ) then
1202: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
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
1231: and msi.inventory_item_id = wjsi.primary_item_id)))))
1232: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1233:
1234: if ( sql%rowcount > 0 ) then
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
1232: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1233:
1234: if ( sql%rowcount > 0 ) then
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,
1250: and wri.organization_id = wjsi.organization_id)
1251: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1252:
1253: if ( sql%rowcount > 0 ) then
1254: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_ITEM');
1255: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1256: end if;
1257:
1258: /* FP bug 4378684. No need to validate whether ATO item has bill or not.
1251: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1252:
1253: if ( sql%rowcount > 0 ) then
1254: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_ITEM');
1255: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1256: end if;
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 */
1285: and (bom.assembly_type = 1 or l_see_eng_items_flag = 1))
1286: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1287:
1288: if ( sql%rowcount > 0 ) then
1289: fnd_message.set_name('WIP', 'WIP_ML_ATO_ITEM_NO_BOM');
1290: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1291: end if;
1292: */
1293:
1286: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1287:
1288: if ( sql%rowcount > 0 ) then
1289: fnd_message.set_name('WIP', 'WIP_ML_ATO_ITEM_NO_BOM');
1290: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1291: end if;
1292: */
1293:
1294: --
1305: and wjsi.status_type is not null
1306: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1307:
1308: if ( sql%rowcount > 0 ) then
1309: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1310: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);
1311: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1312: end if;
1313:
1306: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1307:
1308: if ( sql%rowcount > 0 ) then
1309: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1307:
1308: if ( sql%rowcount > 0 ) then
1309: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
1354: wip_constants.cancelled)) )
1355: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1356:
1357: if ( sql%rowcount > 0 ) then
1358: fnd_message.set_name('WIP', 'WIP_ML_STATUS_TYPE');
1359: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1360: end if;
1361:
1362: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1355: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1356:
1357: if ( sql%rowcount > 0 ) then
1358: fnd_message.set_name('WIP', 'WIP_ML_STATUS_TYPE');
1359: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1360: end if;
1361:
1362: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1363:
1385: and wdj.organization_id = wjsi.organization_id)
1386: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1387:
1388: if ( sql%rowcount > 0 ) then
1389: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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. */
1386: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1387:
1388: if ( sql%rowcount > 0 ) then
1389: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1387:
1388: if ( sql%rowcount > 0 ) then
1389: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
1407: and wdj.organization_id = wjsi.organization_id)
1408: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1409:
1410: if ( sql%rowcount > 0 ) then
1411: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1412: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1414: end if;
1415:
1408: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1409:
1410: if ( sql%rowcount > 0 ) then
1411: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1412: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1414: end if;
1415:
1416: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1409:
1410: if ( sql%rowcount > 0 ) then
1411: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1412: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
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 */
1435: and msik.concatenated_segments = wjsi.routing_reference_segments)
1436: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1437:
1438: if ( sql%rowcount > 0 ) then
1439: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1440: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1441: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1442: end if;
1443: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1436: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1437:
1438: if ( sql%rowcount > 0 ) then
1439: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1440: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
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. */
1437:
1438: if ( sql%rowcount > 0 ) then
1439: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1440: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
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
1485: and msik.inventory_item_id = wjsi.routing_reference_id)
1486: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1487:
1488: if ( sql%rowcount > 0 ) then
1489: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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 */
1486: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1487:
1488: if ( sql%rowcount > 0 ) then
1489: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
1487:
1488: if ( sql%rowcount > 0 ) then
1489: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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,
1519: and msi.inventory_item_id = wjsi.routing_reference_id)))
1520: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1521:
1522: if ( sql%rowcount > 0 ) then
1523: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REFERENCE_ID');
1524: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1525: end if;
1526: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1527:
1520: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1521:
1522: if ( sql%rowcount > 0 ) then
1523: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REFERENCE_ID');
1524: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1525: end if;
1526: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1527:
1528:
1562: wip_constants.create_ns_job,
1563: wip_constants.create_sched)))
1564: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1565: if ( sql%rowcount > 0 ) then
1566: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
1567: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1568: end if;
1569: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1570:
1563: wip_constants.create_sched)))
1564: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1565: if ( sql%rowcount > 0 ) then
1566: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
1567: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1568: end if;
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.
1605: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1606: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1607:
1608: if ( sql%rowcount > 0 ) then
1609: fnd_message.set_name('WIP', 'WIP_ALTERNATE_ROUTING_NOCHANGE');
1610: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1611: end if;
1612: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1613:
1606: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1607:
1608: if ( sql%rowcount > 0 ) then
1609: fnd_message.set_name('WIP', 'WIP_ALTERNATE_ROUTING_NOCHANGE');
1610: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1611: end if;
1612: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1613:
1614: --
1625: and wjsi.routing_revision is not null
1626: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1627:
1628: if ( sql%rowcount > 0 ) then
1629: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1630: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
1631: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1632: end if;
1633:
1626: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1627:
1628: if ( sql%rowcount > 0 ) then
1629: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1630: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
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.
1627:
1628: if ( sql%rowcount > 0 ) then
1629: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1630: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
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
1663: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1664: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1665:
1666: if ( sql%rowcount > 0 ) then
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
1664: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1665:
1666: if ( sql%rowcount > 0 ) then
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
1699: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1700: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1701:
1702: if ( sql%rowcount > 0 ) then
1703: fnd_message.set_name('WIP', 'WIP_ROUTING_REV_DATE_NOCHANGE');
1704: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1705: end if;
1706: */
1707: --
1700: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1701:
1702: if ( sql%rowcount > 0 ) then
1703: fnd_message.set_name('WIP', 'WIP_ROUTING_REV_DATE_NOCHANGE');
1704: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1705: end if;
1706: */
1707: --
1708: -- default and validate bom_reference and bom_reference_id
1726: and wdj.organization_id = wjsi.organization_id)
1727: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1728:
1729: if ( sql%rowcount > 0 ) then
1730: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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. */
1727: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1728:
1729: if ( sql%rowcount > 0 ) then
1730: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
1728:
1729: if ( sql%rowcount > 0 ) then
1730: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
1748: and wdj.organization_id = wjsi.organization_id)
1749: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1750:
1751: if ( sql%rowcount > 0 ) then
1752: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1753: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1754: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1755: end if;
1756:
1749: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1750:
1751: if ( sql%rowcount > 0 ) then
1752: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1753: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1754: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1755: end if;
1756:
1757:
1750:
1751: if ( sql%rowcount > 0 ) then
1752: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1753: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1754: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1755: end if;
1756:
1757:
1758: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1777: and msik.concatenated_segments = wjsi.bom_reference_segments)
1778: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1779:
1780: if ( sql%rowcount > 0 ) then
1781: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1782: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1783: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1784: end if;
1785: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1778: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1779:
1780: if ( sql%rowcount > 0 ) then
1781: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1782: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
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. */
1779:
1780: if ( sql%rowcount > 0 ) then
1781: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1782: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
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
1827: and msik.inventory_item_id = wjsi.bom_reference_id)
1828: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1829:
1830: if ( sql%rowcount > 0 ) then
1831: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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 */
1828: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1829:
1830: if ( sql%rowcount > 0 ) then
1831: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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
1829:
1830: if ( sql%rowcount > 0 ) then
1831: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
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,
1861: and msi.inventory_item_id = wjsi.bom_reference_id)))
1862: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1863:
1864: if ( sql%rowcount > 0 ) then
1865: fnd_message.set_name('WIP', 'WIP_ML_BOM_REFERENCE_ID');
1866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1867: end if;
1868: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1869:
1862: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1863:
1864: if ( sql%rowcount > 0 ) then
1865: fnd_message.set_name('WIP', 'WIP_ML_BOM_REFERENCE_ID');
1866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1867: end if;
1868: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1869:
1870:
1902: wip_constants.create_sched)))
1903: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1904:
1905: if ( sql%rowcount > 0 ) then
1906: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
1907: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1908: end if;
1909: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1910:
1903: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1904:
1905: if ( sql%rowcount > 0 ) then
1906: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
1907: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1908: end if;
1909: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1910:
1911: /*Modified for bug 5479283. When Null is passed for alt bom designator, old value is maintained.
1945: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1946: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1947:
1948: if ( sql%rowcount > 0 ) then
1949: fnd_message.set_name('WIP', 'WIP_ALTERNATE_BOM_NOCHANGE');
1950: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1951: end if;
1952: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1953:
1946: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1947:
1948: if ( sql%rowcount > 0 ) then
1949: fnd_message.set_name('WIP', 'WIP_ALTERNATE_BOM_NOCHANGE');
1950: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1951: end if;
1952: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1953:
1954: --
1965: and wjsi.bom_revision is not null
1966: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1967:
1968: if ( sql%rowcount > 0 ) then
1969: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1970: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
1971: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1972: end if;
1973:
1966: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1967:
1968: if ( sql%rowcount > 0 ) then
1969: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1970: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
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.
1967:
1968: if ( sql%rowcount > 0 ) then
1969: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1970: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
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
2003: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
2004: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2005:
2006: if ( sql%rowcount > 0 ) then
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
2004: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2005:
2006: if ( sql%rowcount > 0 ) then
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
2039: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
2040: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2041:
2042: if ( sql%rowcount > 0 ) then
2043: fnd_message.set_name('WIP', 'WIP_BOM_REV_DATE_NOCHANGE');
2044: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2045: end if;
2046:
2047: */
2040: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2041:
2042: if ( sql%rowcount > 0 ) then
2043: fnd_message.set_name('WIP', 'WIP_BOM_REV_DATE_NOCHANGE');
2044: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2045: end if;
2046:
2047: */
2048:
2060: and wjsi.wip_supply_type is not null
2061: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2062:
2063: if ( sql%rowcount > 0 ) then
2064: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2065: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);
2066: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2067: end if;
2068:
2061: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2062:
2063: if ( sql%rowcount > 0 ) then
2064: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2062:
2063: if ( sql%rowcount > 0 ) then
2064: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2108: and nvl(cfm_routing_flag, 2) = 2)))
2109: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2110:
2111: if ( sql%rowcount > 0 ) then
2112: fnd_message.set_name('WIP', 'WIP_ML_WIP_SUPPLY_TYPE');
2113: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2114: end if;
2115: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2116:
2109: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2110:
2111: if ( sql%rowcount > 0 ) then
2112: fnd_message.set_name('WIP', 'WIP_ML_WIP_SUPPLY_TYPE');
2113: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2114: end if;
2115: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2116:
2117: --
2136: wip_constants.hold)) )
2137: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2138:
2139: if ( sql%rowcount > 0 ) then
2140: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2141: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
2142: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2143: end if;
2144:
2137: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2138:
2139: if ( sql%rowcount > 0 ) then
2140: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2141: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
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
2138:
2139: if ( sql%rowcount > 0 ) then
2140: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2141: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
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
2162: and wdj.wip_entity_id = wjsi.wip_entity_id)))
2163: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2164:
2165: if ( sql%rowcount > 0 ) then
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
2163: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2164:
2165: if ( sql%rowcount > 0 ) then
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,
2189: and wr.wip_entity_id = wjsi.wip_entity_id)))
2190: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2191:
2192: if ( sql%rowcount > 0 ) then
2193: fnd_message.set_name('WIP', 'WIP_ML_RESCHEDULE_QUANTITY');
2194: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2195: end if;
2196: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2197:
2190: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2191:
2192: if ( sql%rowcount > 0 ) then
2193: fnd_message.set_name('WIP', 'WIP_ML_RESCHEDULE_QUANTITY');
2194: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2195: end if;
2196: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2197:
2198: --
2208: and wjsi.net_quantity is not null
2209: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2210:
2211: if ( sql%rowcount > 0 ) then
2212: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2213: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);
2214: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2215: end if;
2216:
2209: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2210:
2211: if ( sql%rowcount > 0 ) then
2212: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2210:
2211: if ( sql%rowcount > 0 ) then
2212: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2274: and wdj.wip_entity_id = wjsi.wip_entity_id) is null))))
2275: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2276:
2277: if ( sql%rowcount > 0 ) then
2278: fnd_message.set_name('WIP', 'WIP_ML_NET_QUANTITY');
2279: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2280: end if;
2281: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2282:
2275: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2276:
2277: if ( sql%rowcount > 0 ) then
2278: fnd_message.set_name('WIP', 'WIP_ML_NET_QUANTITY');
2279: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2280: end if;
2281: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2282:
2283: --
2295: wjsi.primary_item_id is null))
2296: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2297:
2298: if ( sql%rowcount > 0 ) then
2299: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2300: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);
2301: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2302: end if;
2303:
2296: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2297:
2298: if ( sql%rowcount > 0 ) then
2299: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2297:
2298: if ( sql%rowcount > 0 ) then
2299: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2313: wjsi.primary_item_id is null))
2314: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2315:
2316: if ( sql%rowcount > 0 ) then
2317: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2318: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2319: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2320: end if;
2321:
2314: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2315:
2316: if ( sql%rowcount > 0 ) then
2317: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2318: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2319: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2320: end if;
2321:
2322: --
2315:
2316: if ( sql%rowcount > 0 ) then
2317: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2318: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2319: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2320: end if;
2321:
2322: --
2323: -- default due_date
2332: and wjsi.load_type = wip_constants.create_sched
2333: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2334:
2335: if ( sql%rowcount > 0 ) then
2336: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2337: fnd_message.set_token('COLUMN', 'DUE_DATE', false);
2338: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2339: end if;
2340:
2333: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2334:
2335: if ( sql%rowcount > 0 ) then
2336: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2334:
2335: if ( sql%rowcount > 0 ) then
2336: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2361: and wjsi.status_type = wip_constants.unreleased
2362: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2363:
2364: if ( sql%rowcount > 0 ) then
2365: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2366: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);
2367: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2368: end if;
2369:
2362: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2363:
2364: if ( sql%rowcount > 0 ) then
2365: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2363:
2364: if ( sql%rowcount > 0 ) then
2365: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2377: and wjsi.status_type = wip_constants.released
2378: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2379:
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,
2378: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2379:
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
2413: and oap.period_close_date is null)
2414: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2415:
2416: if ( sql%rowcount > 0 ) then
2417: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2418: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2419: end if;
2420:
2421:
2414: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2415:
2416: if ( sql%rowcount > 0 ) then
2417: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2418: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2419: end if;
2420:
2421:
2422: --
2432: and wjsi.load_type = wip_constants.create_sched
2433: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2434:
2435: if ( sql%rowcount > 0 ) then
2436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2437: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);
2438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2439: end if;
2440:
2433: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2434:
2435: if ( sql%rowcount > 0 ) then
2436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2434:
2435: if ( sql%rowcount > 0 ) then
2436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2461: and wjsi.load_type = wip_constants.create_sched
2462: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2463:
2464: if ( sql%rowcount > 0 ) then
2465: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2466: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2467: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2468: end if;
2469:
2462: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2463:
2464: if ( sql%rowcount > 0 ) then
2465: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2466: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2467: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2468: end if;
2469:
2470: --
2463:
2464: if ( sql%rowcount > 0 ) then
2465: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2466: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2467: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2468: end if;
2469:
2470: --
2471: -- default and validate processing_work_days
2480: and wjsi.load_type <> wip_constants.create_sched
2481: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2482:
2483: if ( sql%rowcount > 0 ) then
2484: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2485: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
2486: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2487: end if;
2488:
2481: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2482:
2483: if ( sql%rowcount > 0 ) then
2484: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2485: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
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
2482:
2483: if ( sql%rowcount > 0 ) then
2484: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2485: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
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
2497: and (wjsi.processing_work_days <= 0 or wjsi.processing_work_days is null)
2498: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2499:
2500: if ( sql%rowcount > 0 ) then
2501: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2502: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2503: end if;
2504: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2505:
2498: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2499:
2500: if ( sql%rowcount > 0 ) then
2501: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2502: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2503: end if;
2504: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2505:
2506: --
2516: and wjsi.load_type <> wip_constants.create_sched
2517: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2518:
2519: if ( sql%rowcount > 0 ) then
2520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2521: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
2522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2523: end if;
2524:
2517: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2518:
2519: if ( sql%rowcount > 0 ) then
2520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2521: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
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
2518:
2519: if ( sql%rowcount > 0 ) then
2520: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2521: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
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
2533: and (wjsi.daily_production_rate <= 0 or wjsi.daily_production_rate is null)
2534: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2535:
2536: if ( sql%rowcount > 0 ) then
2537: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2538: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2539: end if;
2540: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2541:
2534: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2535:
2536: if ( sql%rowcount > 0 ) then
2537: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2538: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2539: end if;
2540: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2541:
2542: --
2552: and wjsi.load_type = wip_constants.resched_job
2553: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2554:
2555: if ( sql%rowcount > 0 ) then
2556: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2557: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);
2558: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2559: end if;
2560:
2553: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2554:
2555: if ( sql%rowcount > 0 ) then
2556: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2554:
2555: if ( sql%rowcount > 0 ) then
2556: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2573: where sdc.demand_class_code = wjsi.demand_class)
2574: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2575:
2576: if ( sql%rowcount > 0 ) then
2577: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
2578: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2579: end if;
2580:
2581: --
2574: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2575:
2576: if ( sql%rowcount > 0 ) then
2577: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
2578: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2579: end if;
2580:
2581: --
2582: -- default and validate completion_subinventory
2592: wip_constants.create_sched)
2593: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2594:
2595: if ( sql%rowcount > 0 ) then
2596: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2597: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);
2598: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2599: end if;
2600:
2593: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2594:
2595: if ( sql%rowcount > 0 ) then
2596: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2594:
2595: if ( sql%rowcount > 0 ) then
2596: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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 =
2630: and wjsi.completion_subinventory is not null
2631: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2632:
2633: if ( sql%rowcount > 0 ) then
2634: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_SUBINVENTORY');
2635: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2636: end if;
2637:
2638: --
2631: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2632:
2633: if ( sql%rowcount > 0 ) then
2634: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_SUBINVENTORY');
2635: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2636: end if;
2637:
2638: --
2639: -- Default completion_locator_id
2649: wip_constants.create_sched)
2650: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2651:
2652: if ( sql%rowcount > 0 ) then
2653: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2654: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);
2655: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2656: end if;
2657:
2650: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2651:
2652: if ( sql%rowcount > 0 ) then
2653: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2651:
2652: if ( sql%rowcount > 0 ) then
2653: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2667: wip_constants.create_ns_job)
2668: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2669:
2670: if ( sql%rowcount > 0 ) then
2671: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2672: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);
2673: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2674: end if;
2675:
2668: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2669:
2670: if ( sql%rowcount > 0 ) then
2671: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2669:
2670: if ( sql%rowcount > 0 ) then
2671: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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 =
2707: and wjsi.completion_locator_id is not null
2708: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2709:
2710: if ( sql%rowcount > 0 ) then
2711: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_LOCATOR');
2712: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2713: end if;
2714:
2715: --
2708: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2709:
2710: if ( sql%rowcount > 0 ) then
2711: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_LOCATOR');
2712: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2713: end if;
2714:
2715: --
2716: -- default and validate lot_number
2725: and wjsi.load_type = wip_constants.create_sched
2726: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2727:
2728: if ( sql%rowcount > 0 ) then
2729: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2730: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2731: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2732: end if;
2733:
2726: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2727:
2728: if ( sql%rowcount > 0 ) then
2729: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2730: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2731: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2732: end if;
2733:
2734: --
2727:
2728: if ( sql%rowcount > 0 ) then
2729: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2730: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2731: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2732: end if;
2733:
2734: --
2735: -- default and validate source_code and source_line_id
2744: and wjsi.load_type = wip_constants.create_sched
2745: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2746:
2747: if ( sql%rowcount > 0 ) then
2748: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2749: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);
2750: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2751: end if;
2752:
2745: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2746:
2747: if ( sql%rowcount > 0 ) then
2748: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
2746:
2747: if ( sql%rowcount > 0 ) then
2748: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
2760: and wjsi.load_type = wip_constants.create_sched
2761: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2762:
2763: if ( sql%rowcount > 0 ) then
2764: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2765: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2766: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2767: end if;
2768:
2761: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2762:
2763: if ( sql%rowcount > 0 ) then
2764: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2765: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2766: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2767: end if;
2768:
2769: --
2762:
2763: if ( sql%rowcount > 0 ) then
2764: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2765: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2766: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2767: end if;
2768:
2769: --
2770: -- default and validate scheduling_method
2779: and wjsi.load_type = wip_constants.create_sched
2780: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2781:
2782: if ( sql%rowcount > 0 ) then
2783: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2784: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
2785: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2786: end if;
2787:
2780: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2781:
2782: if ( sql%rowcount > 0 ) then
2783: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2784: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
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*/
2781:
2782: if ( sql%rowcount > 0 ) then
2783: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2784: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
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
2829: wip_constants.ml_manual)
2830: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2831:
2832: if ( sql%rowcount > 0 ) then
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
2830: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2831:
2832: if ( sql%rowcount > 0 ) then
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,
2858: wjsi.first_unit_start_date > wjsi.last_unit_completion_date)))
2859: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2860:
2861: if ( sql%rowcount > 0 ) then
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
2859: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2860:
2861: if ( sql%rowcount > 0 ) then
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,
2876: wjsi.last_unit_completion_date is null)
2877: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2878:
2879: if ( sql%rowcount > 0 ) then
2880: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD2');
2881: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2882: end if;
2883:
2884: --
2877: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2878:
2879: if ( sql%rowcount > 0 ) then
2880: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD2');
2881: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2882: end if;
2883:
2884: --
2885: -- default and validate allow_explosion
2894: and wjsi.load_type = wip_constants.create_sched
2895: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2896:
2897: if ( sql%rowcount > 0 ) then
2898: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2899: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2900: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2901: end if;
2902:
2895: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2896:
2897: if ( sql%rowcount > 0 ) then
2898: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2899: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2900: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2901: end if;
2902:
2903: --
2896:
2897: if ( sql%rowcount > 0 ) then
2898: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2899: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2900: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2901: end if;
2902:
2903: --
2904: -- default and validate allow_explosion
2913: and wjsi.load_type = wip_constants.create_sched
2914: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2915:
2916: if ( sql%rowcount > 0 ) then
2917: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2918: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2919: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2920: end if;
2921:
2914: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2915:
2916: if ( sql%rowcount > 0 ) then
2917: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2918: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2919: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2920: end if;
2921:
2922: --
2915:
2916: if ( sql%rowcount > 0 ) then
2917: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2918: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2919: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2920: end if;
2921:
2922: --
2923: -- default and validate end_item_unit_number
2933: wip_constants.resched_job)
2934: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2935:
2936: if ( sql%rowcount > 0 ) then
2937: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2938: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2939: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2940: end if;
2941:
2934: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2935:
2936: if ( sql%rowcount > 0 ) then
2937: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2938: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2939: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2940: end if;
2941:
2942: --
2935:
2936: if ( sql%rowcount > 0 ) then
2937: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2938: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2939: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2940: end if;
2941:
2942: --
2943: -- validate schedule dates
3005: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3006:
3007:
3008: if ( sql%rowcount > 0 ) then
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
3006:
3007:
3008: if ( sql%rowcount > 0 ) then
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,
3020: and wjsi.load_type <> wip_constants.create_sched
3021: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3022:
3023: if ( sql%rowcount > 0 ) then
3024: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3025: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);
3026: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3027: end if;
3028:
3021: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3022:
3023: if ( sql%rowcount > 0 ) then
3024: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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
3022:
3023: if ( sql%rowcount > 0 ) then
3024: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
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,
3036: and wjsi.load_type <> wip_constants.create_sched
3037: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3038:
3039: if ( sql%rowcount > 0 ) then
3040: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3041: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3043: end if;
3044: end if;
3037: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3038:
3039: if ( sql%rowcount > 0 ) then
3040: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3041: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3043: end if;
3044: end if;
3045:
3038:
3039: if ( sql%rowcount > 0 ) then
3040: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3041: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3043: end if;
3044: end if;
3045:
3046: --
3056: and wjsi.load_type = wip_constants.create_sched
3057: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3058:
3059: if ( sql%rowcount > 0 ) then
3060: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
3061: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3062: end if;
3063:
3064: if (l_logLevel <= wip_constants.trace_logging) then
3057: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3058:
3059: if ( sql%rowcount > 0 ) then
3060: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
3061: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3062: end if;
3063:
3064: if (l_logLevel <= wip_constants.trace_logging) then
3065: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
3502: end if;
3503: end if;
3504: exception
3505: when others then
3506: fnd_message.set_name('WIP', l_msg);
3507: x_errorMsg := fnd_message.get;
3508: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3509: raise line_validation_error;
3510: end estimateLeadTime;
3503: end if;
3504: exception
3505: when others then
3506: fnd_message.set_name('WIP', l_msg);
3507: x_errorMsg := fnd_message.get;
3508: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3509: raise line_validation_error;
3510: end estimateLeadTime;
3511:
3543: and ppp.organization_id = wjsi_row.organization_id;
3544: end if;
3545: exception
3546: when others then
3547: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3548: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3549: x_errorMsg := fnd_message.get;
3550: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3551: raise line_validation_error;
3544: end if;
3545: exception
3546: when others then
3547: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3548: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3549: x_errorMsg := fnd_message.get;
3550: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3551: raise line_validation_error;
3552: end;
3545: exception
3546: when others then
3547: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3548: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3549: x_errorMsg := fnd_message.get;
3550: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3551: raise line_validation_error;
3552: end;
3553: end if;
3568: and ppp.organization_id = mp.organization_id
3569: and nvl(mp.project_reference_enabled, 2) = wip_constants.yes;
3570: exception
3571: when others then
3572: fnd_message.set_name('WIP', 'WIP_ML_PROJECT_ID');
3573: x_errorMsg := fnd_message.get;
3574: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3575: raise line_validation_error;
3576: end;
3569: and nvl(mp.project_reference_enabled, 2) = wip_constants.yes;
3570: exception
3571: when others then
3572: fnd_message.set_name('WIP', 'WIP_ML_PROJECT_ID');
3573: x_errorMsg := fnd_message.get;
3574: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3575: raise line_validation_error;
3576: end;
3577: end if;
3595: and task_number = wjsi_row.task_number;
3596: end if;
3597: exception
3598: when others then
3599: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3600: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3601: x_errorMsg := fnd_message.get;
3602: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3603: raise line_validation_error;
3596: end if;
3597: exception
3598: when others then
3599: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3600: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3601: x_errorMsg := fnd_message.get;
3602: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3603: raise line_validation_error;
3604: end;
3597: exception
3598: when others then
3599: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3600: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3601: x_errorMsg := fnd_message.get;
3602: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3603: raise line_validation_error;
3604: end;
3605: end if;
3618: end if;
3619:
3620: exception
3621: when others then
3622: fnd_message.set_name('WIP', 'WIP_ML_TASK_ID');
3623: x_errorMsg := fnd_message.get;
3624: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3625: raise line_validation_error;
3626: end;
3619:
3620: exception
3621: when others then
3622: fnd_message.set_name('WIP', 'WIP_ML_TASK_ID');
3623: x_errorMsg := fnd_message.get;
3624: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3625: raise line_validation_error;
3626: end;
3627: end if;
3666: if ( wjsi_row.class_code is not null ) then
3667: if (wjsi_row.load_type = wip_constants.resched_job) and (wjsi_row.class_code <> wdj_row.class_code) then
3668: l_checkClassFlag := 'Y';
3669: elsif wjsi_row.load_type = wip_constants.create_sched then
3670: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3671: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3672: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3673: end if;
3674: end if;
3667: if (wjsi_row.load_type = wip_constants.resched_job) and (wjsi_row.class_code <> wdj_row.class_code) then
3668: l_checkClassFlag := 'Y';
3669: elsif wjsi_row.load_type = wip_constants.create_sched then
3670: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3671: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3672: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3673: end if;
3674: end if;
3675:
3668: l_checkClassFlag := 'Y';
3669: elsif wjsi_row.load_type = wip_constants.create_sched then
3670: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3671: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3672: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3673: end if;
3674: end if;
3675:
3676: -- default the class code
3685: x_err_mesg_2 => l_errMsg2,
3686: x_err_class_1 => l_errClass1,
3687: x_err_class_2 => l_errClass2);
3688: if ( l_errMsg1 is not null) then
3689: fnd_message.set_name('WIP', l_errMsg1);
3690: fnd_message.set_token('class_code', l_errClass1, false);
3691: x_errorMsg := fnd_message.get;
3692: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3693: raise line_validation_error;
3686: x_err_class_1 => l_errClass1,
3687: x_err_class_2 => l_errClass2);
3688: if ( l_errMsg1 is not null) then
3689: fnd_message.set_name('WIP', l_errMsg1);
3690: fnd_message.set_token('class_code', l_errClass1, false);
3691: x_errorMsg := fnd_message.get;
3692: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3693: raise line_validation_error;
3694: end if ;
3687: x_err_class_2 => l_errClass2);
3688: if ( l_errMsg1 is not null) then
3689: fnd_message.set_name('WIP', l_errMsg1);
3690: fnd_message.set_token('class_code', l_errClass1, false);
3691: x_errorMsg := fnd_message.get;
3692: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3693: raise line_validation_error;
3694: end if ;
3695: if (l_errMsg2 is not null) then
3692: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3693: raise line_validation_error;
3694: end if ;
3695: if (l_errMsg2 is not null) then
3696: fnd_message.set_name('WIP', l_errMsg2);
3697: fnd_message.set_token('class_code', l_errClass2, false);
3698: x_errorMsg := fnd_message.get;
3699: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3700: raise line_validation_error;
3693: raise line_validation_error;
3694: end if ;
3695: if (l_errMsg2 is not null) then
3696: fnd_message.set_name('WIP', l_errMsg2);
3697: fnd_message.set_token('class_code', l_errClass2, false);
3698: x_errorMsg := fnd_message.get;
3699: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3700: raise line_validation_error;
3701: end if ;
3694: end if ;
3695: if (l_errMsg2 is not null) then
3696: fnd_message.set_name('WIP', l_errMsg2);
3697: fnd_message.set_token('class_code', l_errClass2, false);
3698: x_errorMsg := fnd_message.get;
3699: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3700: raise line_validation_error;
3701: end if ;
3702: elsif ( wjsi_row.load_type = wip_constants.resched_job ) then
3762: and organization_id = wjsi_row.organization_id);
3763: end if;
3764: exception
3765: when others then
3766: fnd_message.set_name('WIP', 'WIP_ML_CLASS_CODE');
3767: x_errorMsg := fnd_message.get;
3768: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3769: raise line_validation_error;
3770: end;
3763: end if;
3764: exception
3765: when others then
3766: fnd_message.set_name('WIP', 'WIP_ML_CLASS_CODE');
3767: x_errorMsg := fnd_message.get;
3768: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3769: raise line_validation_error;
3770: end;
3771: end validateClassCode;
3806: p_start_date => greatest(nvl(wjsi_row.first_unit_start_date, wjsi_row.last_unit_completion_date), sysdate));
3807: end if;
3808: exception
3809: when others then
3810: fnd_message.set_name('WIP', 'WIP_ML_BOM_REVISION');
3811: x_errorMsg := fnd_message.get;
3812: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3813: raise line_validation_error;
3814: end validateBOMRevision;
3807: end if;
3808: exception
3809: when others then
3810: fnd_message.set_name('WIP', 'WIP_ML_BOM_REVISION');
3811: x_errorMsg := fnd_message.get;
3812: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3813: raise line_validation_error;
3814: end validateBOMRevision;
3815:
3876: end if;
3877: end if;
3878: exception
3879: when others then
3880: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REVISION');
3881: x_errorMsg := fnd_message.get;
3882: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3883: raise line_validation_error;
3884: end validateRoutingRevision;
3877: end if;
3878: exception
3879: when others then
3880: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REVISION');
3881: x_errorMsg := fnd_message.get;
3882: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3883: raise line_validation_error;
3884: end validateRoutingRevision;
3885:
3926: /* bug 5350660. Show warning if job is already pick released */
3927: if ( wip_picking_pub.is_job_pick_released(wjsi_row.wip_entity_id,
3928: wjsi_row.repetitive_schedule_id,
3929: wjsi_row.organization_id)) then
3930: fnd_message.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');
3931: setInterfaceError(p_rowid, wjsi_row.interface_id, substr(fnd_message.get, 1, 500), validationWarning);
3932: end if;
3933: end if;
3934: exception
3927: if ( wip_picking_pub.is_job_pick_released(wjsi_row.wip_entity_id,
3928: wjsi_row.repetitive_schedule_id,
3929: wjsi_row.organization_id)) then
3930: fnd_message.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');
3931: setInterfaceError(p_rowid, wjsi_row.interface_id, substr(fnd_message.get, 1, 500), validationWarning);
3932: end if;
3933: end if;
3934: exception
3935: when others then
3932: end if;
3933: end if;
3934: exception
3935: when others then
3936: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');
3937: x_errorMsg := fnd_message.get;
3938: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3939: raise line_validation_error;
3940: end validateStartQuantity;
3933: end if;
3934: exception
3935: when others then
3936: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');
3937: x_errorMsg := fnd_message.get;
3938: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3939: raise line_validation_error;
3940: end validateStartQuantity;
3941:
4002: end if;
4003:
4004: if ( l_qtyReserved > 0 and
4005: wjsi_row.status_type = wip_constants.comp_chrg) then
4006: fnd_message.set_name('WIP','WIP_SO_EXISTS');
4007: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4008: end if;
4009: -- 13075675 @end
4010:
4003:
4004: if ( l_qtyReserved > 0 and
4005: wjsi_row.status_type = wip_constants.comp_chrg) then
4006: fnd_message.set_name('WIP','WIP_SO_EXISTS');
4007: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4008: end if;
4009: -- 13075675 @end
4010:
4011: if ( wjsi_row.status_type in (wip_constants.cancelled,
4034: p_org_id => wjsi_row.organization_id,
4035: x_return_status => l_retStatus);
4036: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
4037: po_warning_flag := WIP_CONSTANTS.YES;
4038: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4039: end if;
4040: else
4041: -- propagate_job_change_to_po is manual or job status is 'Complete'
4042: po_warning_flag := WIP_CONSTANTS.YES;
4039: end if;
4040: else
4041: -- propagate_job_change_to_po is manual or job status is 'Complete'
4042: po_warning_flag := WIP_CONSTANTS.YES;
4043: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
4044: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4045: end if;
4046: else
4047: -- customer does not have PO patchset J onward, so behave the the old way
4040: else
4041: -- propagate_job_change_to_po is manual or job status is 'Complete'
4042: po_warning_flag := WIP_CONSTANTS.YES;
4043: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
4044: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4045: end if;
4046: else
4047: -- customer does not have PO patchset J onward, so behave the the old way
4048: po_warning_flag := WIP_CONSTANTS.YES;
4045: end if;
4046: else
4047: -- customer does not have PO patchset J onward, so behave the the old way
4048: po_warning_flag := WIP_CONSTANTS.YES;
4049: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
4050: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4051: end if;
4052: end if; -- po/requisiton exist
4053: end if;
4046: else
4047: -- customer does not have PO patchset J onward, so behave the the old way
4048: po_warning_flag := WIP_CONSTANTS.YES;
4049: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
4050: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4051: end if;
4052: end if; -- po/requisiton exist
4053: end if;
4054:
4072: raise fnd_api.g_exc_unexpected_error;
4073: end if;
4074: exception
4075: when others then
4076: fnd_message.set_name('WIP', l_msg);
4077: x_errorMsg := fnd_message.get;
4078: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4079: raise line_validation_error;
4080: end validateStatusType;
4073: end if;
4074: exception
4075: when others then
4076: fnd_message.set_name('WIP', l_msg);
4077: x_errorMsg := fnd_message.get;
4078: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4079: raise line_validation_error;
4080: end validateStatusType;
4081:
4107: p_organization_id => wjsi_row.organization_id,
4108: p_line_id => nvl(wjsi_row.line_id, wdj_row.line_id),
4109: p_schedule_group_id => nvl(wjsi_row.schedule_group_id, wdj_row.schedule_group_id) );
4110: if( not l_retval ) then
4111: fnd_message.set_name('WIP', 'WIP_ML_BUILD_SEQUENCE');
4112: x_errorMsg := fnd_message.get;
4113: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4114: raise line_validation_error;
4115: end if;
4108: p_line_id => nvl(wjsi_row.line_id, wdj_row.line_id),
4109: p_schedule_group_id => nvl(wjsi_row.schedule_group_id, wdj_row.schedule_group_id) );
4110: if( not l_retval ) then
4111: fnd_message.set_name('WIP', 'WIP_ML_BUILD_SEQUENCE');
4112: x_errorMsg := fnd_message.get;
4113: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4114: raise line_validation_error;
4115: end if;
4116: end if;
4147: exception
4148: when too_many_rows then
4149: null; -- the query returning multiple rows is ok
4150: when others then
4151: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4152: x_errorMsg := fnd_message.get;
4153: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4154: raise line_validation_error;
4155: end;
4148: when too_many_rows then
4149: null; -- the query returning multiple rows is ok
4150: when others then
4151: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4152: x_errorMsg := fnd_message.get;
4153: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4154: raise line_validation_error;
4155: end;
4156: end if;
4169:
4170: if (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
4171: -- Unit number is required for unit effective assemblies.
4172: if( l_isUnitEffective and wjsi_row.end_item_unit_number is null) then
4173: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');
4174: x_errorMsg := fnd_message.get;
4175: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4176: raise line_validation_error;
4177: end if;
4170: if (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
4171: -- Unit number is required for unit effective assemblies.
4172: if( l_isUnitEffective and wjsi_row.end_item_unit_number is null) then
4173: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');
4174: x_errorMsg := fnd_message.get;
4175: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4176: raise line_validation_error;
4177: end if;
4178: end if;
4186: from wip_discrete_jobs wdj
4187: where wdj.wip_entity_id = wjsi_row.wip_entity_id;
4188: exception
4189: when others then
4190: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID');
4191: x_errorMsg := fnd_message.get;
4192: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4193: raise line_validation_error;
4194: end;
4187: where wdj.wip_entity_id = wjsi_row.wip_entity_id;
4188: exception
4189: when others then
4190: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID');
4191: x_errorMsg := fnd_message.get;
4192: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4193: raise line_validation_error;
4194: end;
4195: end if;
4204: end if;
4205:
4206: if ( wjsi_row.status_type <> wip_constants.unreleased and
4207: wjsi_row.end_item_unit_number is not null ) then
4208: fnd_message.set_name('WIP', 'END_ITEM_UNIT_NUMBER');
4209: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationWarning);
4210: -- Added by Renga Kannan
4211: -- Fixed for bug 5332672
4212: -- Added code to get the end unit item number from wip_discrete_jobs and populate
4221: where rowid = p_rowid
4222: );
4223: exception
4224: when others then
4225: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4226: WIP_JSI_Utils.record_current_error ;
4227: raise fnd_api.g_exc_unexpected_error;
4228: end ;
4229:
4231: end if;
4232: end if;
4233: exception
4234: when fnd_api.g_exc_unexpected_error then
4235: fnd_message.set_name('WIP', l_msg);
4236: x_errorMsg := fnd_message.get;
4237: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4238: raise line_validation_error;
4239: end validateEndItemUnitNumber;
4232: end if;
4233: exception
4234: when fnd_api.g_exc_unexpected_error then
4235: fnd_message.set_name('WIP', l_msg);
4236: x_errorMsg := fnd_message.get;
4237: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4238: raise line_validation_error;
4239: end validateEndItemUnitNumber;
4240:
4252: from wip_lines_val_v
4253: where line_id = wjsi_row.line_id;
4254:
4255: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4256: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4257: fnd_message.set_token('ENTITY1', l_maxLineRate);
4258: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4259: end if;
4260: end validateDailyProductionRate;
4253: where line_id = wjsi_row.line_id;
4254:
4255: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4256: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4257: fnd_message.set_token('ENTITY1', l_maxLineRate);
4258: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4259: end if;
4260: end validateDailyProductionRate;
4261:
4254:
4255: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4256: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4257: fnd_message.set_token('ENTITY1', l_maxLineRate);
4258: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4259: end if;
4260: end validateDailyProductionRate;
4261:
4262:
4475: end if;
4476: end if;
4477: exception
4478: when others then
4479: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_DATES');
4480: x_errorMsg := fnd_message.get;
4481: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4482: raise line_validation_error;
4483: end validateRepScheduleDates;
4476: end if;
4477: exception
4478: when others then
4479: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_DATES');
4480: x_errorMsg := fnd_message.get;
4481: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4482: raise line_validation_error;
4483: end validateRepScheduleDates;
4484:
4633: end if;
4634: exception
4635: when others then
4636: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4637: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
4638: x_errorMsg := fnd_message.get;
4639: setInterfaceError(p_rowid, l_interfaceID, x_errorMsg, validationError);
4640: end validateSerializationStartOp;
4641:
4634: exception
4635: when others then
4636: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4637: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
4638: x_errorMsg := fnd_message.get;
4639: setInterfaceError(p_rowid, l_interfaceID, x_errorMsg, validationError);
4640: end validateSerializationStartOp;
4641:
4642:
4745: end if;
4746:
4747: exception
4748: when others then
4749: fnd_message.set_name('WIP', l_msg);
4750: x_errorMsg := fnd_message.get;
4751: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4752: raise line_validation_error;
4753: end validateSubinvLocator;
4746:
4747: exception
4748: when others then
4749: fnd_message.set_name('WIP', l_msg);
4750: x_errorMsg := fnd_message.get;
4751: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4752: raise line_validation_error;
4753: end validateSubinvLocator;
4754:
4947: raise fnd_api.g_exc_unexpected_error;
4948: end if ;
4949: exception
4950: when others then
4951: fnd_message.set_name('WIP', l_msg);
4952: x_errorMsg := fnd_message.get;
4953: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4954: raise line_validation_error;
4955: end validateKanban;
4948: end if ;
4949: exception
4950: when others then
4951: fnd_message.set_name('WIP', l_msg);
4952: x_errorMsg := fnd_message.get;
4953: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4954: raise line_validation_error;
4955: end validateKanban;
4956:
5000: end if;
5001: end if;
5002: exception
5003: when others then
5004: fnd_message.set_name('WIP', l_msg);
5005: x_errorMsg := fnd_message.get;
5006: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
5007: raise line_validation_error;
5008: end validateOvercompletion;
5001: end if;
5002: exception
5003: when others then
5004: fnd_message.set_name('WIP', l_msg);
5005: x_errorMsg := fnd_message.get;
5006: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
5007: raise line_validation_error;
5008: end validateOvercompletion;
5009: