DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on FND_MESSAGE

Line 241: fnd_message.set_name('WIP', 'WIP_ML_LOAD_TYPE');

237: WIP_CONSTANTS.CREATE_NS_JOB)
238: returning wjsi.interface_id bulk collect into l_interfaceTbl;
239:
240: if ( sql%rowcount > 0 ) then
241: fnd_message.set_name('WIP', 'WIP_ML_LOAD_TYPE');
242: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
243: end if;
244:
245: --

Line 242: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

238: returning wjsi.interface_id bulk collect into l_interfaceTbl;
239:
240: if ( sql%rowcount > 0 ) then
241: fnd_message.set_name('WIP', 'WIP_ML_LOAD_TYPE');
242: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
243: end if;
244:
245: --
246: --Fix for bug#4186944. Update REQUEST_ID

Line 274: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

270: where usr.user_name = wjsi.created_by_name)
271: returning wjsi.interface_id bulk collect into l_interfaceTbl;
272:
273: if ( sql%rowcount > 0 ) then
274: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
275: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
276: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
277: end if;
278:

Line 275: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);

271: returning wjsi.interface_id bulk collect into l_interfaceTbl;
272:
273: if ( sql%rowcount > 0 ) then
274: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
275: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
276: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
277: end if;
278:
279: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 276: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

272:
273: if ( sql%rowcount > 0 ) then
274: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
275: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
276: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
277: end if;
278:
279: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
280:

Line 292: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

288: and wjsi.created_by is not null
289: returning wjsi.interface_id bulk collect into l_interfaceTbl;
290:
291: if ( sql%rowcount > 0 ) then
292: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
293: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
294: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
295: end if;
296:

Line 293: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);

289: returning wjsi.interface_id bulk collect into l_interfaceTbl;
290:
291: if ( sql%rowcount > 0 ) then
292: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
293: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
294: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
295: end if;
296:
297: update wip_job_schedule_interface wjsi

Line 294: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

290:
291: if ( sql%rowcount > 0 ) then
292: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
293: fnd_message.set_token('COLUMN', 'CREATED_BY_NAME', false);
294: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
295: end if;
296:
297: update wip_job_schedule_interface wjsi
298: set wjsi.created_by = (select usr.user_id

Line 322: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

318: and sysdate between usr.start_date and nvl(end_date, sysdate))
319: returning wjsi.interface_id bulk collect into l_interfaceTbl;
320:
321: if ( sql%rowcount > 0 ) then
322: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
323: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
324: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
325: end if;
326:

Line 323: fnd_message.set_token('COLUMN', 'CREATED_BY', false);

319: returning wjsi.interface_id bulk collect into l_interfaceTbl;
320:
321: if ( sql%rowcount > 0 ) then
322: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
323: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
324: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
325: end if;
326:
327:

Line 324: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

320:
321: if ( sql%rowcount > 0 ) then
322: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
323: fnd_message.set_token('COLUMN', 'CREATED_BY', false);
324: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
325: end if;
326:
327:
328: --

Line 345: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

341: where usr.user_name = wjsi.last_updated_by_name)
342: returning wjsi.interface_id bulk collect into l_interfaceTbl;
343:
344: if ( sql%rowcount > 0 ) then
345: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
346: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
347: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
348: end if;
349: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 346: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);

342: returning wjsi.interface_id bulk collect into l_interfaceTbl;
343:
344: if ( sql%rowcount > 0 ) then
345: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
346: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
347: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
348: end if;
349: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
350:

Line 347: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

343:
344: if ( sql%rowcount > 0 ) then
345: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
346: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
347: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
348: end if;
349: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
350:
351: update wip_job_schedule_interface wjsi

Line 362: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

358: and wjsi.last_updated_by is not null
359: returning wjsi.interface_id bulk collect into l_interfaceTbl;
360:
361: if ( sql%rowcount > 0 ) then
362: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
363: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
364: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
365: end if;
366:

Line 363: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);

359: returning wjsi.interface_id bulk collect into l_interfaceTbl;
360:
361: if ( sql%rowcount > 0 ) then
362: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
363: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
364: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
365: end if;
366:
367: update wip_job_schedule_interface wjsi

Line 364: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

360:
361: if ( sql%rowcount > 0 ) then
362: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
363: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY_NAME', false);
364: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
365: end if;
366:
367: update wip_job_schedule_interface wjsi
368: set wjsi.last_updated_by = (select usr.user_id

Line 393: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

389: and sysdate between usr.start_date and nvl(end_date, sysdate))
390: returning wjsi.interface_id bulk collect into l_interfaceTbl;
391:
392: if ( sql%rowcount > 0 ) then
393: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
394: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
395: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
396: end if;
397:

Line 394: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);

390: returning wjsi.interface_id bulk collect into l_interfaceTbl;
391:
392: if ( sql%rowcount > 0 ) then
393: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
394: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
395: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
396: end if;
397:
398:

Line 395: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

391:
392: if ( sql%rowcount > 0 ) then
393: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
394: fnd_message.set_token('COLUMN', 'LAST_UPDATED_BY', false);
395: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
396: end if;
397:
398:
399: --

Line 418: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

414: where ood.organization_code = wjsi.organization_code)
415: returning wjsi.interface_id bulk collect into l_interfaceTbl;
416:
417: if ( sql%rowcount > 0 ) then
418: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
419: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
420: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
421: end if;
422:

Line 419: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);

415: returning wjsi.interface_id bulk collect into l_interfaceTbl;
416:
417: if ( sql%rowcount > 0 ) then
418: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
419: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
420: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
421: end if;
422:
423: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 420: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

416:
417: if ( sql%rowcount > 0 ) then
418: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
419: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
420: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
421: end if;
422:
423: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
424:

Line 436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

432: and wjsi.organization_id is not null
433: returning wjsi.interface_id bulk collect into l_interfaceTbl;
434:
435: if ( sql%rowcount > 0 ) then
436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
437: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
439: end if;
440:

Line 437: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);

433: returning wjsi.interface_id bulk collect into l_interfaceTbl;
434:
435: if ( sql%rowcount > 0 ) then
436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
437: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
439: end if;
440:
441: -- Bug 4890514. Performance Fix

Line 438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

434:
435: if ( sql%rowcount > 0 ) then
436: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
437: fnd_message.set_token('COLUMN', 'ORGANIZATION_CODE', false);
438: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
439: end if;
440:
441: -- Bug 4890514. Performance Fix
442: -- saugupta 25th-May-2006

Line 475: fnd_message.set_name('WIP', 'WIP_ML_ORGANIZATION_ID');

471: and sysdate < nvl(ood.date_to, sysdate + 1))
472: returning wjsi.interface_id bulk collect into l_interfaceTbl;
473:
474: if ( sql%rowcount > 0 ) then
475: fnd_message.set_name('WIP', 'WIP_ML_ORGANIZATION_ID');
476: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
477: end if;
478:
479: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 476: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

472: returning wjsi.interface_id bulk collect into l_interfaceTbl;
473:
474: if ( sql%rowcount > 0 ) then
475: fnd_message.set_name('WIP', 'WIP_ML_ORGANIZATION_ID');
476: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
477: end if;
478:
479: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
480:

Line 501: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

497: and we.organization_id = wjsi.organization_id)
498: returning wjsi.interface_id bulk collect into l_interfaceTbl;
499:
500: if ( sql%rowcount > 0 ) then
501: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
502: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
503: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
504: end if;
505:

Line 502: fnd_message.set_token('COLUMN', 'JOB_NAME', false);

498: returning wjsi.interface_id bulk collect into l_interfaceTbl;
499:
500: if ( sql%rowcount > 0 ) then
501: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
502: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
503: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
504: end if;
505:
506: update wip_job_schedule_interface wjsi

Line 503: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

499:
500: if ( sql%rowcount > 0 ) then
501: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
502: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
503: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
504: end if;
505:
506: update wip_job_schedule_interface wjsi
507: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 519: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

515: (wjsi.load_type = WIP_CONSTANTS.CREATE_SCHED) )
516: returning wjsi.interface_id bulk collect into l_interfaceTbl;
517:
518: if ( sql%rowcount > 0 ) then
519: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
520: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
521: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
522: end if;
523:

Line 520: fnd_message.set_token('COLUMN', 'JOB_NAME', false);

516: returning wjsi.interface_id bulk collect into l_interfaceTbl;
517:
518: if ( sql%rowcount > 0 ) then
519: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
520: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
521: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
522: end if;
523:
524: update wip_job_schedule_interface wjsi

Line 521: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

517:
518: if ( sql%rowcount > 0 ) then
519: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
520: fnd_message.set_token('COLUMN', 'JOB_NAME', false);
521: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
522: end if;
523:
524: update wip_job_schedule_interface wjsi
525: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,

Line 560: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');

556: and we.organization_id = wjsi.organization_id)
557: returning wjsi.interface_id bulk collect into l_interfaceTbl;
558:
559: if ( sql%rowcount > 0 ) then
560: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
561: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
562: end if;
563:
564: --

Line 561: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

557: returning wjsi.interface_id bulk collect into l_interfaceTbl;
558:
559: if ( sql%rowcount > 0 ) then
560: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
561: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
562: end if;
563:
564: --
565: -- validate wip entity id

Line 580: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

576: WIP_CONSTANTS.CREATE_SCHED)
577: returning wjsi.interface_id bulk collect into l_interfaceTbl;
578:
579: if ( sql%rowcount > 0 ) then
580: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
581: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);
582: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
583: end if;
584:

Line 581: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);

577: returning wjsi.interface_id bulk collect into l_interfaceTbl;
578:
579: if ( sql%rowcount > 0 ) then
580: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
581: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);
582: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
583: end if;
584:
585: update wip_job_schedule_interface wjsi

Line 582: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

578:
579: if ( sql%rowcount > 0 ) then
580: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
581: fnd_message.set_token('COLUMN', 'WIP_ENTITY_ID', false);
582: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
583: end if;
584:
585: update wip_job_schedule_interface wjsi
586: set wip_entity_id = wip_entities_s.nextval,

Line 614: fnd_message.set_name('WIP', 'WIP_ML_WIP_ENTITY_ID');

610: and we.wip_entity_id = wjsi.wip_entity_id)))
611: returning wjsi.interface_id bulk collect into l_interfaceTbl;
612:
613: if ( sql%rowcount > 0 ) then
614: fnd_message.set_name('WIP', 'WIP_ML_WIP_ENTITY_ID');
615: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
616: end if;
617:
618: --

Line 615: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

611: returning wjsi.interface_id bulk collect into l_interfaceTbl;
612:
613: if ( sql%rowcount > 0 ) then
614: fnd_message.set_name('WIP', 'WIP_ML_WIP_ENTITY_ID');
615: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
616: end if;
617:
618: --
619: -- validate for entity type

Line 636: fnd_message.set_name('WIP', 'WIP_ML_ENTITY_TYPE');

632: and we.entity_type <> 1)
633: returning wjsi.interface_id bulk collect into l_interfaceTbl;
634:
635: if ( sql%rowcount > 0 ) then
636: fnd_message.set_name('WIP', 'WIP_ML_ENTITY_TYPE');
637: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
638: end if;
639:
640: --

Line 637: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

633: returning wjsi.interface_id bulk collect into l_interfaceTbl;
634:
635: if ( sql%rowcount > 0 ) then
636: fnd_message.set_name('WIP', 'WIP_ML_ENTITY_TYPE');
637: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
638: end if;
639:
640: --
641: -- default and validate repetitve_schedule_id

Line 654: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

650: and wjsi.repetitive_schedule_id is not null
651: returning wjsi.interface_id bulk collect into l_interfaceTbl;
652:
653: if ( sql%rowcount > 0 ) then
654: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
655: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);
656: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
657: end if;
658:

Line 655: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);

651: returning wjsi.interface_id bulk collect into l_interfaceTbl;
652:
653: if ( sql%rowcount > 0 ) then
654: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
655: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);
656: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
657: end if;
658:
659: update wip_job_schedule_interface wjsi

Line 656: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

652:
653: if ( sql%rowcount > 0 ) then
654: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
655: fnd_message.set_token('COLUMN', 'REPETITIVE_SCHEDULE_ID', false);
656: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
657: end if;
658:
659: update wip_job_schedule_interface wjsi
660: set wjsi.repetitive_schedule_id = wip_repetitive_schedules_s.nextval,

Line 681: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

677: and wjsi.schedule_group_id is not null
678: returning wjsi.interface_id bulk collect into l_interfaceTbl;
679:
680: if ( sql%rowcount > 0 ) then
681: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
682: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);
683: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
684: end if;
685:

Line 682: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);

678: returning wjsi.interface_id bulk collect into l_interfaceTbl;
679:
680: if ( sql%rowcount > 0 ) then
681: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
682: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);
683: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
684: end if;
685:
686: update wip_job_schedule_interface wjsi

Line 683: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

679:
680: if ( sql%rowcount > 0 ) then
681: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
682: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_ID', false);
683: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
684: end if;
685:
686: update wip_job_schedule_interface wjsi
687: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 698: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

694: and wjsi.schedule_group_name is not null
695: returning wjsi.interface_id bulk collect into l_interfaceTbl;
696:
697: if ( sql%rowcount > 0 ) then
698: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
699: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);
700: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
701: end if;
702:

Line 699: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);

695: returning wjsi.interface_id bulk collect into l_interfaceTbl;
696:
697: if ( sql%rowcount > 0 ) then
698: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
699: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);
700: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
701: end if;
702:
703: update wip_job_schedule_interface wjsi

Line 700: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

696:
697: if ( sql%rowcount > 0 ) then
698: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
699: fnd_message.set_token('COLUMN', 'SCHEDULE_GRPUP_NAME', false);
700: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
701: end if;
702:
703: update wip_job_schedule_interface wjsi
704: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 721: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

717: and sg.organization_id = wjsi.organization_id)
718: returning wjsi.interface_id bulk collect into l_interfaceTbl;
719:
720: if ( sql%rowcount > 0 ) then
721: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
722: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);
723: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
724: end if;
725:

Line 722: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);

718: returning wjsi.interface_id bulk collect into l_interfaceTbl;
719:
720: if ( sql%rowcount > 0 ) then
721: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
722: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);
723: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
724: end if;
725:
726: update wip_job_schedule_interface wjsi

Line 723: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

719:
720: if ( sql%rowcount > 0 ) then
721: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
722: fnd_message.set_token('COLUMN', 'SCHEDULE_GROUP_NAME', false);
723: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
724: end if;
725:
726: update wip_job_schedule_interface wjsi
727: set wjsi.schedule_group_id =

Line 846: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');

842: and sg.organization_id = wjsi.organization_id)
843: returning wjsi.interface_id bulk collect into l_interfaceTbl;
844:
845: if ( sql%rowcount > 0 ) then
846: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
847: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
848: end if;
849:
850: --

Line 847: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

843: returning wjsi.interface_id bulk collect into l_interfaceTbl;
844:
845: if ( sql%rowcount > 0 ) then
846: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
847: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
848: end if;
849:
850: --
851: -- default build_sequence

Line 864: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

860: and wjsi.load_type = wip_constants.create_sched
861: returning wjsi.interface_id bulk collect into l_interfaceTbl;
862:
863: if ( sql%rowcount > 0 ) then
864: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
865: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
867: end if;
868:

Line 865: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);

861: returning wjsi.interface_id bulk collect into l_interfaceTbl;
862:
863: if ( sql%rowcount > 0 ) then
864: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
865: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
867: end if;
868:
869: --

Line 866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

862:
863: if ( sql%rowcount > 0 ) then
864: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
865: fnd_message.set_token('COLUMN', 'BUILD_SEQUENCE', false);
866: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
867: end if;
868:
869: --
870: -- default and validate line_code and line_id

Line 890: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

886: and wl.organization_id = wjsi.organization_id)
887: returning wjsi.interface_id bulk collect into l_interfaceTbl;
888:
889: if ( sql%rowcount > 0 ) then
890: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
891: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
892: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
893: end if;
894: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 891: fnd_message.set_token('COLUMN', 'LINE_CODE', false);

887: returning wjsi.interface_id bulk collect into l_interfaceTbl;
888:
889: if ( sql%rowcount > 0 ) then
890: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
891: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
892: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
893: end if;
894: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
895:

Line 892: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

888:
889: if ( sql%rowcount > 0 ) then
890: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
891: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
892: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
893: end if;
894: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
895:
896: update wip_job_schedule_interface wjsi

Line 907: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

903: and wjsi.line_id is not null
904: returning wjsi.interface_id bulk collect into l_interfaceTbl;
905:
906: if ( sql%rowcount > 0 ) then
907: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
908: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
909: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
910: end if;
911:

Line 908: fnd_message.set_token('COLUMN', 'LINE_CODE', false);

904: returning wjsi.interface_id bulk collect into l_interfaceTbl;
905:
906: if ( sql%rowcount > 0 ) then
907: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
908: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
909: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
910: end if;
911:
912: update wip_job_schedule_interface wjsi

Line 909: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

905:
906: if ( sql%rowcount > 0 ) then
907: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
908: fnd_message.set_token('COLUMN', 'LINE_CODE', false);
909: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
910: end if;
911:
912: update wip_job_schedule_interface wjsi
913: set line_id = (select wl.line_id

Line 940: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');

936: and wl.organization_id = wjsi.organization_id)
937: returning wjsi.interface_id bulk collect into l_interfaceTbl;
938:
939: if ( sql%rowcount > 0 ) then
940: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
941: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
942: end if;
943:
944: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 941: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

937: returning wjsi.interface_id bulk collect into l_interfaceTbl;
938:
939: if ( sql%rowcount > 0 ) then
940: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
941: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
942: end if;
943:
944: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
945:

Line 958: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

954: and wjsi.serialization_start_op is not null
955: returning wjsi.interface_id bulk collect into l_interfaceTbl;
956:
957: if ( sql%rowcount > 0 ) then
958: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
959: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
960: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
961: end if;
962:

Line 959: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);

955: returning wjsi.interface_id bulk collect into l_interfaceTbl;
956:
957: if ( sql%rowcount > 0 ) then
958: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
959: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
960: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
961: end if;
962:
963: --

Line 960: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

956:
957: if ( sql%rowcount > 0 ) then
958: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
959: fnd_message.set_token('COLUMN', 'SERIALIZATION_START_OP', false);
960: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
961: end if;
962:
963: --
964: -- default and validate project_number and project_id

Line 977: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

973: and wjsi.project_number is not null
974: returning wjsi.interface_id bulk collect into l_interfaceTbl;
975:
976: if ( sql%rowcount > 0 ) then
977: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
978: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
979: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
980: end if;
981:

Line 978: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);

974: returning wjsi.interface_id bulk collect into l_interfaceTbl;
975:
976: if ( sql%rowcount > 0 ) then
977: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
978: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
979: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
980: end if;
981:
982: update wip_job_schedule_interface wjsi

Line 979: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

975:
976: if ( sql%rowcount > 0 ) then
977: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
978: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
979: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
980: end if;
981:
982: update wip_job_schedule_interface wjsi
983: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 993: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

989: and wjsi.project_id is not null
990: returning wjsi.interface_id bulk collect into l_interfaceTbl;
991:
992: if ( sql%rowcount > 0 ) then
993: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
994: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
995: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
996: end if;
997:

Line 994: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);

990: returning wjsi.interface_id bulk collect into l_interfaceTbl;
991:
992: if ( sql%rowcount > 0 ) then
993: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
994: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
995: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
996: end if;
997:
998: --

Line 995: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

991:
992: if ( sql%rowcount > 0 ) then
993: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
994: fnd_message.set_token('COLUMN', 'PROJECT_ID', false);
995: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
996: end if;
997:
998: --
999: -- default and validate task_number and task_id

Line 1012: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1008: and wjsi.task_number is not null
1009: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1010:
1011: if ( sql%rowcount > 0 ) then
1012: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1013: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
1014: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1015: end if;
1016:

Line 1013: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);

1009: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1010:
1011: if ( sql%rowcount > 0 ) then
1012: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1013: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
1014: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1015: end if;
1016:
1017: update wip_job_schedule_interface wjsi

Line 1014: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1010:
1011: if ( sql%rowcount > 0 ) then
1012: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1013: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
1014: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1015: end if;
1016:
1017: update wip_job_schedule_interface wjsi
1018: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 1028: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1024: and wjsi.task_id is not null
1025: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1026:
1027: if ( sql%rowcount > 0 ) then
1028: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1029: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1030: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1031: end if;
1032:

Line 1029: fnd_message.set_token('COLUMN', 'TASK_ID', false);

1025: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1026:
1027: if ( sql%rowcount > 0 ) then
1028: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1029: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1030: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1031: end if;
1032:
1033: --

Line 1030: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1026:
1027: if ( sql%rowcount > 0 ) then
1028: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1029: fnd_message.set_token('COLUMN', 'TASK_ID', false);
1030: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1031: end if;
1032:
1033: --
1034: -- default and validate firm_planned_flag

Line 1067: fnd_message.set_name('WIP', 'WIP_ML_FIRM_PLANNED_FLAG');

1063: or (wjsi.firm_planned_flag not in (WIP_CONSTANTS.YES, WIP_CONSTANTS.NO)))
1064: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1065:
1066: if ( sql%rowcount > 0 ) then
1067: fnd_message.set_name('WIP', 'WIP_ML_FIRM_PLANNED_FLAG');
1068: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1069: end if;
1070: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1071:

Line 1068: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1064: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1065:
1066: if ( sql%rowcount > 0 ) then
1067: fnd_message.set_name('WIP', 'WIP_ML_FIRM_PLANNED_FLAG');
1068: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1069: end if;
1070: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1071:
1072: --

Line 1075: fnd_message.set_name('WIP','WIP_MLD_DESC');

1071:
1072: --
1073: -- default description
1074: --
1075: fnd_message.set_name('WIP','WIP_MLD_DESC');
1076: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1077: l_description := fnd_message.get;
1078: update wip_job_schedule_interface wjsi
1079: set wjsi.description = l_description,

Line 1076: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);

1072: --
1073: -- default description
1074: --
1075: fnd_message.set_name('WIP','WIP_MLD_DESC');
1076: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1077: l_description := fnd_message.get;
1078: update wip_job_schedule_interface wjsi
1079: set wjsi.description = l_description,
1080: wjsi.last_update_date = sysdate

Line 1077: l_description := fnd_message.get;

1073: -- default description
1074: --
1075: fnd_message.set_name('WIP','WIP_MLD_DESC');
1076: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1077: l_description := fnd_message.get;
1078: update wip_job_schedule_interface wjsi
1079: set wjsi.description = l_description,
1080: wjsi.last_update_date = sysdate
1081: where wjsi.group_id = p_groupID

Line 1088: fnd_message.set_name('WIP','WIP_MLR_DESC');

1084: and wjsi.description is null
1085: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
1086: WIP_CONSTANTS.CREATE_NS_JOB);
1087:
1088: fnd_message.set_name('WIP','WIP_MLR_DESC');
1089: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1090: l_description := fnd_message.get;
1091: update wip_job_schedule_interface wjsi
1092: set wjsi.description = l_description,

Line 1089: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);

1085: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
1086: WIP_CONSTANTS.CREATE_NS_JOB);
1087:
1088: fnd_message.set_name('WIP','WIP_MLR_DESC');
1089: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1090: l_description := fnd_message.get;
1091: update wip_job_schedule_interface wjsi
1092: set wjsi.description = l_description,
1093: wjsi.last_update_date = sysdate

Line 1090: l_description := fnd_message.get;

1086: WIP_CONSTANTS.CREATE_NS_JOB);
1087:
1088: fnd_message.set_name('WIP','WIP_MLR_DESC');
1089: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
1090: l_description := fnd_message.get;
1091: update wip_job_schedule_interface wjsi
1092: set wjsi.description = l_description,
1093: wjsi.last_update_date = sysdate
1094: where wjsi.group_id = p_groupID

Line 1115: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1111: and wjsi.primary_item_segments is not null
1112: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1113:
1114: if ( sql%rowcount > 0 ) then
1115: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1116: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1117: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1118: end if;
1119:

Line 1116: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);

1112: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1113:
1114: if ( sql%rowcount > 0 ) then
1115: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1116: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1117: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1118: end if;
1119:
1120: update wip_job_schedule_interface wjsi

Line 1117: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1113:
1114: if ( sql%rowcount > 0 ) then
1115: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1116: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1117: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1118: end if;
1119:
1120: update wip_job_schedule_interface wjsi
1121: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 1131: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1127: and wjsi.primary_item_id is not null
1128: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1129:
1130: if ( sql%rowcount > 0 ) then
1131: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1132: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);
1133: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1134: end if;
1135:

Line 1132: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);

1128: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1129:
1130: if ( sql%rowcount > 0 ) then
1131: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1132: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);
1133: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1134: end if;
1135:
1136: update wip_job_schedule_interface wjsi

Line 1133: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1129:
1130: if ( sql%rowcount > 0 ) then
1131: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1132: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_ID', false);
1133: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1134: end if;
1135:
1136: update wip_job_schedule_interface wjsi
1137: set primary_item_id = (select wdj.primary_item_id

Line 1164: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

1160: and msik.concatenated_segments = wjsi.primary_item_segments)
1161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1162:
1163: if ( sql%rowcount > 0 ) then
1164: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1165: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1166: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1167: end if;
1168:

Line 1165: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);

1161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1162:
1163: if ( sql%rowcount > 0 ) then
1164: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1165: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1166: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1167: end if;
1168:
1169: update wip_job_schedule_interface wjsi

Line 1166: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1162:
1163: if ( sql%rowcount > 0 ) then
1164: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1165: fnd_message.set_token('COLUMN', 'PRIMARY_ITEM_SEGMENTS', false);
1166: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1167: end if;
1168:
1169: update wip_job_schedule_interface wjsi
1170: set wjsi.primary_item_id = (select msik.inventory_item_id

Line 1200: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');

1196: and msi.inventory_item_id = wjsi.primary_item_id)
1197: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1198:
1199: if ( sql%rowcount > 0 ) then
1200: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1201: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1202: end if;
1203:
1204: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');

Line 1201: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1197: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1198:
1199: if ( sql%rowcount > 0 ) then
1200: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1201: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1202: end if;
1203:
1204: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');
1205: update wip_job_schedule_interface wjsi

Line 1233: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');

1229: and msi.inventory_item_id = wjsi.primary_item_id)))))
1230: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1231:
1232: if ( sql%rowcount > 0 ) then
1233: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1234: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1235: end if;
1236:
1237: update wip_job_schedule_interface wjsi

Line 1234: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1230: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1231:
1232: if ( sql%rowcount > 0 ) then
1233: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1234: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1235: end if;
1236:
1237: update wip_job_schedule_interface wjsi
1238: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 1252: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_ITEM');

1248: and wri.organization_id = wjsi.organization_id)
1249: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1250:
1251: if ( sql%rowcount > 0 ) then
1252: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_ITEM');
1253: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1254: end if;
1255:
1256: /* FP bug 4378684. No need to validate whether ATO item has bill or not.

Line 1253: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1249: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1250:
1251: if ( sql%rowcount > 0 ) then
1252: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_ITEM');
1253: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1254: end if;
1255:
1256: /* FP bug 4378684. No need to validate whether ATO item has bill or not.
1257: This validation is removed per request by CTO team */

Line 1287: fnd_message.set_name('WIP', 'WIP_ML_ATO_ITEM_NO_BOM');

1283: and (bom.assembly_type = 1 or l_see_eng_items_flag = 1))
1284: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1285:
1286: if ( sql%rowcount > 0 ) then
1287: fnd_message.set_name('WIP', 'WIP_ML_ATO_ITEM_NO_BOM');
1288: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1289: end if;
1290: */
1291:

Line 1288: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1284: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1285:
1286: if ( sql%rowcount > 0 ) then
1287: fnd_message.set_name('WIP', 'WIP_ML_ATO_ITEM_NO_BOM');
1288: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1289: end if;
1290: */
1291:
1292: --

Line 1307: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1303: and wjsi.status_type is not null
1304: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1305:
1306: if ( sql%rowcount > 0 ) then
1307: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1308: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);
1309: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1310: end if;
1311:

Line 1308: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);

1304: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1305:
1306: if ( sql%rowcount > 0 ) then
1307: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1308: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);
1309: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1310: end if;
1311:
1312: update wip_job_schedule_interface wjsi

Line 1309: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1305:
1306: if ( sql%rowcount > 0 ) then
1307: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1308: fnd_message.set_token('COLUMN', 'STATUS_TYPE', false);
1309: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1310: end if;
1311:
1312: update wip_job_schedule_interface wjsi
1313: set wjsi.status_type = WIP_CONSTANTS.UNRELEASED,

Line 1356: fnd_message.set_name('WIP', 'WIP_ML_STATUS_TYPE');

1352: wip_constants.cancelled)) )
1353: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1354:
1355: if ( sql%rowcount > 0 ) then
1356: fnd_message.set_name('WIP', 'WIP_ML_STATUS_TYPE');
1357: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1358: end if;
1359:
1360: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 1357: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1353: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1354:
1355: if ( sql%rowcount > 0 ) then
1356: fnd_message.set_name('WIP', 'WIP_ML_STATUS_TYPE');
1357: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1358: end if;
1359:
1360: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1361:

Line 1387: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1383: and wdj.organization_id = wjsi.organization_id)
1384: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1385:
1386: if ( sql%rowcount > 0 ) then
1387: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1388: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1389: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1390: end if;
1391: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */

Line 1388: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);

1384: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1385:
1386: if ( sql%rowcount > 0 ) then
1387: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1388: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1389: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1390: end if;
1391: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1392: update wip_job_schedule_interface wjsi

Line 1389: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1385:
1386: if ( sql%rowcount > 0 ) then
1387: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1388: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1389: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1390: end if;
1391: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1392: update wip_job_schedule_interface wjsi
1393: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 1409: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1405: and wdj.organization_id = wjsi.organization_id)
1406: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1407:
1408: if ( sql%rowcount > 0 ) then
1409: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1410: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1411: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1412: end if;
1413:

Line 1410: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);

1406: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1407:
1408: if ( sql%rowcount > 0 ) then
1409: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1410: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1411: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1412: end if;
1413:
1414: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then

Line 1411: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1407:
1408: if ( sql%rowcount > 0 ) then
1409: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1410: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1411: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1412: end if;
1413:
1414: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
1415: /* Modified for bug 5479283. Validation should happen while re-scheduling non-std job */

Line 1437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

1433: and msik.concatenated_segments = wjsi.routing_reference_segments)
1434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1435:
1436: if ( sql%rowcount > 0 ) then
1437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1438: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1440: end if;
1441: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 1438: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);

1434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1435:
1436: if ( sql%rowcount > 0 ) then
1437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1438: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1440: end if;
1441: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1442: /* Modified for bug 5479283. When Null is passed for routing reference, old value is maintained. */

Line 1439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1435:
1436: if ( sql%rowcount > 0 ) then
1437: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1438: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_SEGMENTS', false);
1439: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1440: end if;
1441: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1442: /* Modified for bug 5479283. When Null is passed for routing reference, old value is maintained. */
1443: update wip_job_schedule_interface wjsi

Line 1487: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

1483: and msik.inventory_item_id = wjsi.routing_reference_id)
1484: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1485:
1486: if ( sql%rowcount > 0 ) then
1487: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1488: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1489: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1490: end if;
1491: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */

Line 1488: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);

1484: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1485:
1486: if ( sql%rowcount > 0 ) then
1487: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1488: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1489: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1490: end if;
1491: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1492: update wip_job_schedule_interface wjsi

Line 1489: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1485:
1486: if ( sql%rowcount > 0 ) then
1487: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1488: fnd_message.set_token('COLUMN', 'ROUTING_REFERENCE_ID', false);
1489: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1490: end if;
1491: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1492: update wip_job_schedule_interface wjsi
1493: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 1521: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REFERENCE_ID');

1517: and msi.inventory_item_id = wjsi.routing_reference_id)))
1518: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1519:
1520: if ( sql%rowcount > 0 ) then
1521: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REFERENCE_ID');
1522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1523: end if;
1524: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1525:

Line 1522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1518: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1519:
1520: if ( sql%rowcount > 0 ) then
1521: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REFERENCE_ID');
1522: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1523: end if;
1524: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1525:
1526:

Line 1564: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');

1560: wip_constants.create_ns_job,
1561: wip_constants.create_sched)))
1562: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1563: if ( sql%rowcount > 0 ) then
1564: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
1565: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1566: end if;
1567: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1568:

Line 1565: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1561: wip_constants.create_sched)))
1562: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1563: if ( sql%rowcount > 0 ) then
1564: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
1565: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1566: end if;
1567: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1568:
1569: /*Modified for bug 5479283. When Null is passed for alt routing designator, old value is maintained.

Line 1607: fnd_message.set_name('WIP', 'WIP_ALTERNATE_ROUTING_NOCHANGE');

1603: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1604: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1605:
1606: if ( sql%rowcount > 0 ) then
1607: fnd_message.set_name('WIP', 'WIP_ALTERNATE_ROUTING_NOCHANGE');
1608: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1609: end if;
1610: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1611:

Line 1608: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1604: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1605:
1606: if ( sql%rowcount > 0 ) then
1607: fnd_message.set_name('WIP', 'WIP_ALTERNATE_ROUTING_NOCHANGE');
1608: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1609: end if;
1610: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1611:
1612: --

Line 1627: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1623: and wjsi.routing_revision is not null
1624: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1625:
1626: if ( sql%rowcount > 0 ) then
1627: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1628: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
1629: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1630: end if;
1631:

Line 1628: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);

1624: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1625:
1626: if ( sql%rowcount > 0 ) then
1627: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1628: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
1629: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1630: end if;
1631:
1632: /* Fix for bug 5020741. Do not default routing revision/revision date while updating jobs.

Line 1629: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1625:
1626: if ( sql%rowcount > 0 ) then
1627: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1628: fnd_message.set_token('COLUMN', 'ROUTING_REVISION', false);
1629: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1630: end if;
1631:
1632: /* Fix for bug 5020741. Do not default routing revision/revision date while updating jobs.
1633: update wip_job_schedule_interface wjsi

Line 1665: fnd_message.set_name('WIP', 'WIP_ROUTING_REVISION_NOCHANGE');

1661: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1662: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1663:
1664: if ( sql%rowcount > 0 ) then
1665: fnd_message.set_name('WIP', 'WIP_ROUTING_REVISION_NOCHANGE');
1666: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1667: end if;
1668:
1669: update wip_job_schedule_interface wjsi

Line 1666: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1662: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1663:
1664: if ( sql%rowcount > 0 ) then
1665: fnd_message.set_name('WIP', 'WIP_ROUTING_REVISION_NOCHANGE');
1666: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1667: end if;
1668:
1669: update wip_job_schedule_interface wjsi
1670: set wjsi.routing_revision_date = (select wdj.routing_revision_date

Line 1701: fnd_message.set_name('WIP', 'WIP_ROUTING_REV_DATE_NOCHANGE');

1697: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1698: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1699:
1700: if ( sql%rowcount > 0 ) then
1701: fnd_message.set_name('WIP', 'WIP_ROUTING_REV_DATE_NOCHANGE');
1702: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1703: end if;
1704: */
1705: --

Line 1702: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1698: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1699:
1700: if ( sql%rowcount > 0 ) then
1701: fnd_message.set_name('WIP', 'WIP_ROUTING_REV_DATE_NOCHANGE');
1702: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1703: end if;
1704: */
1705: --
1706: -- default and validate bom_reference and bom_reference_id

Line 1728: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1724: and wdj.organization_id = wjsi.organization_id)
1725: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1726:
1727: if ( sql%rowcount > 0 ) then
1728: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1729: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1730: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1731: end if;
1732: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */

Line 1729: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);

1725: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1726:
1727: if ( sql%rowcount > 0 ) then
1728: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1729: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1730: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1731: end if;
1732: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1733: update wip_job_schedule_interface wjsi

Line 1730: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1726:
1727: if ( sql%rowcount > 0 ) then
1728: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1729: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1730: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1731: end if;
1732: /* Modified for bug 5479283. while re-scheduling non-std job we do consider reference fields. */
1733: update wip_job_schedule_interface wjsi
1734: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 1750: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1746: and wdj.organization_id = wjsi.organization_id)
1747: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1748:
1749: if ( sql%rowcount > 0 ) then
1750: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1751: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1752: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1753: end if;
1754:

Line 1751: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);

1747: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1748:
1749: if ( sql%rowcount > 0 ) then
1750: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1751: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1752: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1753: end if;
1754:
1755:

Line 1752: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1748:
1749: if ( sql%rowcount > 0 ) then
1750: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1751: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1752: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1753: end if;
1754:
1755:
1756: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then

Line 1779: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

1775: and msik.concatenated_segments = wjsi.bom_reference_segments)
1776: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1777:
1778: if ( sql%rowcount > 0 ) then
1779: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1780: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1781: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1782: end if;
1783: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/

Line 1780: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);

1776: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1777:
1778: if ( sql%rowcount > 0 ) then
1779: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1780: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1781: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1782: end if;
1783: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1784: /*Modified for bug 5479283. When Null is passed for bom reference, old value is maintained. */

Line 1781: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1777:
1778: if ( sql%rowcount > 0 ) then
1779: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1780: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_SEGMENTS', false);
1781: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1782: end if;
1783: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1784: /*Modified for bug 5479283. When Null is passed for bom reference, old value is maintained. */
1785: update wip_job_schedule_interface wjsi

Line 1829: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

1825: and msik.inventory_item_id = wjsi.bom_reference_id)
1826: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1827:
1828: if ( sql%rowcount > 0 ) then
1829: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1830: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1831: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1832: end if;
1833: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */

Line 1830: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);

1826: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1827:
1828: if ( sql%rowcount > 0 ) then
1829: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1830: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1831: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1832: end if;
1833: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1834: update wip_job_schedule_interface wjsi

Line 1831: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1827:
1828: if ( sql%rowcount > 0 ) then
1829: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
1830: fnd_message.set_token('COLUMN', 'BOM_REFERENCE_ID', false);
1831: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1832: end if;
1833: /*Modified for bug 5479283. Validation should happen while re-scheduling non-std job */
1834: update wip_job_schedule_interface wjsi
1835: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 1863: fnd_message.set_name('WIP', 'WIP_ML_BOM_REFERENCE_ID');

1859: and msi.inventory_item_id = wjsi.bom_reference_id)))
1860: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1861:
1862: if ( sql%rowcount > 0 ) then
1863: fnd_message.set_name('WIP', 'WIP_ML_BOM_REFERENCE_ID');
1864: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1865: end if;
1866: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1867:

Line 1864: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1860: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1861:
1862: if ( sql%rowcount > 0 ) then
1863: fnd_message.set_name('WIP', 'WIP_ML_BOM_REFERENCE_ID');
1864: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1865: end if;
1866: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1867:
1868:

Line 1904: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');

1900: wip_constants.create_sched)))
1901: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1902:
1903: if ( sql%rowcount > 0 ) then
1904: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
1905: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1906: end if;
1907: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1908:

Line 1905: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1901: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1902:
1903: if ( sql%rowcount > 0 ) then
1904: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
1905: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1906: end if;
1907: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1908:
1909: /*Modified for bug 5479283. When Null is passed for alt bom designator, old value is maintained.

Line 1947: fnd_message.set_name('WIP', 'WIP_ALTERNATE_BOM_NOCHANGE');

1943: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
1944: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1945:
1946: if ( sql%rowcount > 0 ) then
1947: fnd_message.set_name('WIP', 'WIP_ALTERNATE_BOM_NOCHANGE');
1948: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1949: end if;
1950: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1951:

Line 1948: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

1944: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1945:
1946: if ( sql%rowcount > 0 ) then
1947: fnd_message.set_name('WIP', 'WIP_ALTERNATE_BOM_NOCHANGE');
1948: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1949: end if;
1950: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
1951:
1952: --

Line 1967: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

1963: and wjsi.bom_revision is not null
1964: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1965:
1966: if ( sql%rowcount > 0 ) then
1967: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1968: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
1969: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1970: end if;
1971:

Line 1968: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);

1964: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1965:
1966: if ( sql%rowcount > 0 ) then
1967: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1968: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
1969: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1970: end if;
1971:
1972: /* Fix for bug 5020741. Do not default bom revision/revision date while updating jobs.

Line 1969: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

1965:
1966: if ( sql%rowcount > 0 ) then
1967: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
1968: fnd_message.set_token('COLUMN', 'BOM_REVISION', false);
1969: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
1970: end if;
1971:
1972: /* Fix for bug 5020741. Do not default bom revision/revision date while updating jobs.
1973: update wip_job_schedule_interface wjsi

Line 2005: fnd_message.set_name('WIP', 'WIP_BOM_REVISION_NOCHANGE');

2001: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
2002: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2003:
2004: if ( sql%rowcount > 0 ) then
2005: fnd_message.set_name('WIP', 'WIP_BOM_REVISION_NOCHANGE');
2006: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2007: end if;
2008:
2009: update wip_job_schedule_interface wjsi

Line 2006: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2002: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2003:
2004: if ( sql%rowcount > 0 ) then
2005: fnd_message.set_name('WIP', 'WIP_BOM_REVISION_NOCHANGE');
2006: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2007: end if;
2008:
2009: update wip_job_schedule_interface wjsi
2010: set wjsi.bom_revision_date = (select wdj.bom_revision_date

Line 2041: fnd_message.set_name('WIP', 'WIP_BOM_REV_DATE_NOCHANGE');

2037: and wdj.wip_entity_id = wjsi.wip_entity_id) <> 1
2038: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2039:
2040: if ( sql%rowcount > 0 ) then
2041: fnd_message.set_name('WIP', 'WIP_BOM_REV_DATE_NOCHANGE');
2042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2043: end if;
2044:
2045: */

Line 2042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2038: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2039:
2040: if ( sql%rowcount > 0 ) then
2041: fnd_message.set_name('WIP', 'WIP_BOM_REV_DATE_NOCHANGE');
2042: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2043: end if;
2044:
2045: */
2046:

Line 2062: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2058: and wjsi.wip_supply_type is not null
2059: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2060:
2061: if ( sql%rowcount > 0 ) then
2062: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2063: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);
2064: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2065: end if;
2066:

Line 2063: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);

2059: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2060:
2061: if ( sql%rowcount > 0 ) then
2062: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2063: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);
2064: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2065: end if;
2066:
2067: update wip_job_schedule_interface wjsi

Line 2064: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2060:
2061: if ( sql%rowcount > 0 ) then
2062: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2063: fnd_message.set_token('COLUMN', 'WIP_SUPPLY_TYPE', false);
2064: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2065: end if;
2066:
2067: update wip_job_schedule_interface wjsi
2068: set wjsi.wip_supply_type = wip_constants.based_on_bom,

Line 2110: fnd_message.set_name('WIP', 'WIP_ML_WIP_SUPPLY_TYPE');

2106: and nvl(cfm_routing_flag, 2) = 2)))
2107: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2108:
2109: if ( sql%rowcount > 0 ) then
2110: fnd_message.set_name('WIP', 'WIP_ML_WIP_SUPPLY_TYPE');
2111: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2112: end if;
2113: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2114:

Line 2111: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2107: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2108:
2109: if ( sql%rowcount > 0 ) then
2110: fnd_message.set_name('WIP', 'WIP_ML_WIP_SUPPLY_TYPE');
2111: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2112: end if;
2113: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2114:
2115: --

Line 2138: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2134: wip_constants.hold)) )
2135: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2136:
2137: if ( sql%rowcount > 0 ) then
2138: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2139: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
2140: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2141: end if;
2142:

Line 2139: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);

2135: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2136:
2137: if ( sql%rowcount > 0 ) then
2138: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2139: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
2140: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2141: end if;
2142:
2143: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then

Line 2140: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2136:
2137: if ( sql%rowcount > 0 ) then
2138: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2139: fnd_message.set_token('COLUMN', 'START_QUANTITY', false);
2140: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2141: end if;
2142:
2143: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2144: update wip_job_schedule_interface wjsi

Line 2164: fnd_message.set_name('WIP', 'WIP_ML_START_QUANTITY');

2160: and wdj.wip_entity_id = wjsi.wip_entity_id)))
2161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2162:
2163: if ( sql%rowcount > 0 ) then
2164: fnd_message.set_name('WIP', 'WIP_ML_START_QUANTITY');
2165: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2166: end if;
2167:
2168: update wip_job_schedule_interface wjsi

Line 2165: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2162:
2163: if ( sql%rowcount > 0 ) then
2164: fnd_message.set_name('WIP', 'WIP_ML_START_QUANTITY');
2165: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2166: end if;
2167:
2168: update wip_job_schedule_interface wjsi
2169: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 2191: fnd_message.set_name('WIP', 'WIP_ML_RESCHEDULE_QUANTITY');

2187: and wr.wip_entity_id = wjsi.wip_entity_id)))
2188: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2189:
2190: if ( sql%rowcount > 0 ) then
2191: fnd_message.set_name('WIP', 'WIP_ML_RESCHEDULE_QUANTITY');
2192: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2193: end if;
2194: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2195:

Line 2192: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2188: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2189:
2190: if ( sql%rowcount > 0 ) then
2191: fnd_message.set_name('WIP', 'WIP_ML_RESCHEDULE_QUANTITY');
2192: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2193: end if;
2194: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2195:
2196: --

Line 2210: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2206: and wjsi.net_quantity is not null
2207: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2208:
2209: if ( sql%rowcount > 0 ) then
2210: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2211: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);
2212: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2213: end if;
2214:

Line 2211: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);

2207: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2208:
2209: if ( sql%rowcount > 0 ) then
2210: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2211: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);
2212: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2213: end if;
2214:
2215: update wip_job_schedule_interface wjsi

Line 2212: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2208:
2209: if ( sql%rowcount > 0 ) then
2210: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2211: fnd_message.set_token('COLUMN', 'NET_QUANTITY', false);
2212: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2213: end if;
2214:
2215: update wip_job_schedule_interface wjsi
2216: set wjsi.net_quantity = wjsi.start_quantity,

Line 2273: fnd_message.set_name('WIP', 'WIP_ML_NET_QUANTITY');

2269: and wdj.wip_entity_id = wjsi.wip_entity_id) is null))))
2270: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2271:
2272: if ( sql%rowcount > 0 ) then
2273: fnd_message.set_name('WIP', 'WIP_ML_NET_QUANTITY');
2274: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2275: end if;
2276: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2277:

Line 2274: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2270: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2271:
2272: if ( sql%rowcount > 0 ) then
2273: fnd_message.set_name('WIP', 'WIP_ML_NET_QUANTITY');
2274: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2275: end if;
2276: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2277:
2278: --

Line 2294: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2290: wjsi.primary_item_id is null))
2291: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2292:
2293: if ( sql%rowcount > 0 ) then
2294: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2295: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);
2296: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2297: end if;
2298:

Line 2295: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);

2291: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2292:
2293: if ( sql%rowcount > 0 ) then
2294: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2295: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);
2296: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2297: end if;
2298:
2299: update wip_job_schedule_interface wjsi

Line 2296: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2292:
2293: if ( sql%rowcount > 0 ) then
2294: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2295: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_TYPE', false);
2296: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2297: end if;
2298:
2299: update wip_job_schedule_interface wjsi
2300: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 2312: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2308: wjsi.primary_item_id is null))
2309: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2310:
2311: if ( sql%rowcount > 0 ) then
2312: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2313: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2314: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2315: end if;
2316:

Line 2313: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);

2309: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2310:
2311: if ( sql%rowcount > 0 ) then
2312: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2313: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2314: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2315: end if;
2316:
2317: --

Line 2314: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2310:
2311: if ( sql%rowcount > 0 ) then
2312: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2313: fnd_message.set_token('COLUMN', 'OVERCOMPLETION_TOLERANCE_VALUE', false);
2314: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2315: end if;
2316:
2317: --
2318: -- default due_date

Line 2331: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2327: and wjsi.load_type = wip_constants.create_sched
2328: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2329:
2330: if ( sql%rowcount > 0 ) then
2331: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2332: fnd_message.set_token('COLUMN', 'DUE_DATE', false);
2333: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2334: end if;
2335:

Line 2332: fnd_message.set_token('COLUMN', 'DUE_DATE', false);

2328: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2329:
2330: if ( sql%rowcount > 0 ) then
2331: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2332: fnd_message.set_token('COLUMN', 'DUE_DATE', false);
2333: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2334: end if;
2335:
2336: update wip_job_schedule_interface wjsi

Line 2333: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2329:
2330: if ( sql%rowcount > 0 ) then
2331: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2332: fnd_message.set_token('COLUMN', 'DUE_DATE', false);
2333: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2334: end if;
2335:
2336: update wip_job_schedule_interface wjsi
2337: set wjsi.due_date = wjsi.last_unit_completion_date,

Line 2360: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2356: and wjsi.status_type = wip_constants.unreleased
2357: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2358:
2359: if ( sql%rowcount > 0 ) then
2360: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2361: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);
2362: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2363: end if;
2364:

Line 2361: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);

2357: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2358:
2359: if ( sql%rowcount > 0 ) then
2360: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2361: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);
2362: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2363: end if;
2364:
2365: update wip_job_schedule_interface wjsi

Line 2362: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2358:
2359: if ( sql%rowcount > 0 ) then
2360: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2361: fnd_message.set_token('COLUMN', 'DATE_RELEASED', false);
2362: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2363: end if;
2364:
2365: update wip_job_schedule_interface wjsi
2366: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 2376: fnd_message.set_name('WIP', 'WIP_INVALID_RELEASE_DATE');

2372: and wjsi.status_type = wip_constants.released
2373: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2374:
2375: if ( sql%rowcount > 0 ) then
2376: fnd_message.set_name('WIP', 'WIP_INVALID_RELEASE_DATE');
2377: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2378: -- set it to sysdate
2379: update wip_job_schedule_interface wjsi
2380: set wjsi.date_released = sysdate,

Line 2377: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2373: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2374:
2375: if ( sql%rowcount > 0 ) then
2376: fnd_message.set_name('WIP', 'WIP_INVALID_RELEASE_DATE');
2377: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2378: -- set it to sysdate
2379: update wip_job_schedule_interface wjsi
2380: set wjsi.date_released = sysdate,
2381: wjsi.last_update_date = sysdate

Line 2412: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

2408: and oap.period_close_date is null)
2409: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2410:
2411: if ( sql%rowcount > 0 ) then
2412: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2414: end if;
2415:
2416:

Line 2413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2409: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2410:
2411: if ( sql%rowcount > 0 ) then
2412: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2413: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2414: end if;
2415:
2416:
2417: --

Line 2431: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2427: and wjsi.load_type = wip_constants.create_sched
2428: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2429:
2430: if ( sql%rowcount > 0 ) then
2431: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2432: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);
2433: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2434: end if;
2435:

Line 2432: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);

2428: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2429:
2430: if ( sql%rowcount > 0 ) then
2431: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2432: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);
2433: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2434: end if;
2435:
2436: update wip_job_schedule_interface wjsi

Line 2433: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2429:
2430: if ( sql%rowcount > 0 ) then
2431: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2432: fnd_message.set_token('COLUMN', 'REQUESTED_START_DATE', false);
2433: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2434: end if;
2435:
2436: update wip_job_schedule_interface wjsi
2437: set wjsi.requested_start_date = wjsi.first_unit_start_date,

Line 2460: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2456: and wjsi.load_type = wip_constants.create_sched
2457: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2458:
2459: if ( sql%rowcount > 0 ) then
2460: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2461: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2462: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2463: end if;
2464:

Line 2461: fnd_message.set_token('COLUMN', 'HEADER_ID', false);

2457: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2458:
2459: if ( sql%rowcount > 0 ) then
2460: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2461: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2462: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2463: end if;
2464:
2465: --

Line 2462: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2458:
2459: if ( sql%rowcount > 0 ) then
2460: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2461: fnd_message.set_token('COLUMN', 'HEADER_ID', false);
2462: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2463: end if;
2464:
2465: --
2466: -- default and validate processing_work_days

Line 2479: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2475: and wjsi.load_type <> wip_constants.create_sched
2476: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2477:
2478: if ( sql%rowcount > 0 ) then
2479: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2480: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
2481: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2482: end if;
2483:

Line 2480: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);

2476: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2477:
2478: if ( sql%rowcount > 0 ) then
2479: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2480: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
2481: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2482: end if;
2483:
2484: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then

Line 2481: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2477:
2478: if ( sql%rowcount > 0 ) then
2479: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2480: fnd_message.set_token('COLUMN', 'PROCESSING_WORK_DAYS', false);
2481: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2482: end if;
2483:
2484: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2485: update wip_job_schedule_interface wjsi

Line 2496: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');

2492: and (wjsi.processing_work_days <= 0 or wjsi.processing_work_days is null)
2493: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2494:
2495: if ( sql%rowcount > 0 ) then
2496: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2497: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2498: end if;
2499: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2500:

Line 2497: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2493: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2494:
2495: if ( sql%rowcount > 0 ) then
2496: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2497: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2498: end if;
2499: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2500:
2501: --

Line 2515: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2511: and wjsi.load_type <> wip_constants.create_sched
2512: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2513:
2514: if ( sql%rowcount > 0 ) then
2515: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2516: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
2517: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2518: end if;
2519:

Line 2516: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);

2512: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2513:
2514: if ( sql%rowcount > 0 ) then
2515: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2516: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
2517: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2518: end if;
2519:
2520: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then

Line 2517: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2513:
2514: if ( sql%rowcount > 0 ) then
2515: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2516: fnd_message.set_token('COLUMN', 'DAILY_PRODUCTION_RATE', false);
2517: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2518: end if;
2519:
2520: if(p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)) then
2521: update wip_job_schedule_interface wjsi

Line 2532: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');

2528: and (wjsi.daily_production_rate <= 0 or wjsi.daily_production_rate is null)
2529: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2530:
2531: if ( sql%rowcount > 0 ) then
2532: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2533: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2534: end if;
2535: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2536:

Line 2533: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2529: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2530:
2531: if ( sql%rowcount > 0 ) then
2532: fnd_message.set_name('WIP', 'WIP_ML_PROCESSING_WORK_DAYS');
2533: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2534: end if;
2535: end if; /*p_validationLevel NOT IN (wip_constants.mrp, wip_constants.ato)*/
2536:
2537: --

Line 2551: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2547: and wjsi.load_type = wip_constants.resched_job
2548: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2549:
2550: if ( sql%rowcount > 0 ) then
2551: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2552: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);
2553: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2554: end if;
2555:

Line 2552: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);

2548: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2549:
2550: if ( sql%rowcount > 0 ) then
2551: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2552: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);
2553: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2554: end if;
2555:
2556: update wip_job_schedule_interface wjsi

Line 2553: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2549:
2550: if ( sql%rowcount > 0 ) then
2551: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2552: fnd_message.set_token('COLUMN', 'DEMAND_CLASS', false);
2553: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2554: end if;
2555:
2556: update wip_job_schedule_interface wjsi
2557: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 2572: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');

2568: where sdc.demand_class_code = wjsi.demand_class)
2569: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2570:
2571: if ( sql%rowcount > 0 ) then
2572: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
2573: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2574: end if;
2575:
2576: --

Line 2573: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2569: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2570:
2571: if ( sql%rowcount > 0 ) then
2572: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
2573: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2574: end if;
2575:
2576: --
2577: -- default and validate completion_subinventory

Line 2591: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2587: wip_constants.create_sched)
2588: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2589:
2590: if ( sql%rowcount > 0 ) then
2591: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2592: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);
2593: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2594: end if;
2595:

Line 2592: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);

2588: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2589:
2590: if ( sql%rowcount > 0 ) then
2591: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2592: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);
2593: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2594: end if;
2595:
2596: update wip_job_schedule_interface wjsi

Line 2593: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2589:
2590: if ( sql%rowcount > 0 ) then
2591: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2592: fnd_message.set_token('COLUMN', 'COMPLETION_SUBINVENTORY', false);
2593: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2594: end if;
2595:
2596: update wip_job_schedule_interface wjsi
2597: set wjsi.completion_subinventory =

Line 2624: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_SUBINVENTORY');

2620: and wjsi.completion_subinventory is not null
2621: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2622:
2623: if ( sql%rowcount > 0 ) then
2624: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_SUBINVENTORY');
2625: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2626: end if;
2627:
2628: --

Line 2625: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2621: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2622:
2623: if ( sql%rowcount > 0 ) then
2624: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_SUBINVENTORY');
2625: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2626: end if;
2627:
2628: --
2629: -- Default completion_locator_id

Line 2643: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2639: wip_constants.create_sched)
2640: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2641:
2642: if ( sql%rowcount > 0 ) then
2643: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2644: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);
2645: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2646: end if;
2647:

Line 2644: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);

2640: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2641:
2642: if ( sql%rowcount > 0 ) then
2643: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2644: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);
2645: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2646: end if;
2647:
2648: update wip_job_schedule_interface wjsi

Line 2645: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2641:
2642: if ( sql%rowcount > 0 ) then
2643: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2644: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_ID', false);
2645: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2646: end if;
2647:
2648: update wip_job_schedule_interface wjsi
2649: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 2661: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2657: wip_constants.create_ns_job)
2658: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2659:
2660: if ( sql%rowcount > 0 ) then
2661: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2662: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);
2663: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2664: end if;
2665:

Line 2662: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);

2658: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2659:
2660: if ( sql%rowcount > 0 ) then
2661: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2662: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);
2663: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2664: end if;
2665:
2666: update wip_job_schedule_interface wjsi

Line 2663: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2659:
2660: if ( sql%rowcount > 0 ) then
2661: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2662: fnd_message.set_token('COLUMN', 'COMPLETION_LOCATOR_SEGMENTS', false);
2663: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2664: end if;
2665:
2666: update wip_job_schedule_interface wjsi
2667: set wjsi.completion_locator_id =

Line 2696: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_LOCATOR');

2692: and wjsi.completion_locator_id is not null
2693: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2694:
2695: if ( sql%rowcount > 0 ) then
2696: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_LOCATOR');
2697: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2698: end if;
2699:
2700: --

Line 2697: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2693: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2694:
2695: if ( sql%rowcount > 0 ) then
2696: fnd_message.set_name('WIP', 'WIP_ML_COMPLETION_LOCATOR');
2697: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2698: end if;
2699:
2700: --
2701: -- default and validate lot_number

Line 2714: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2710: and wjsi.load_type = wip_constants.create_sched
2711: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2712:
2713: if ( sql%rowcount > 0 ) then
2714: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2715: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2716: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2717: end if;
2718:

Line 2715: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);

2711: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2712:
2713: if ( sql%rowcount > 0 ) then
2714: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2715: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2716: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2717: end if;
2718:
2719: --

Line 2716: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2712:
2713: if ( sql%rowcount > 0 ) then
2714: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2715: fnd_message.set_token('COLUMN', 'LOT_NUMBER', false);
2716: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2717: end if;
2718:
2719: --
2720: -- default and validate source_code and source_line_id

Line 2733: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2729: and wjsi.load_type = wip_constants.create_sched
2730: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2731:
2732: if ( sql%rowcount > 0 ) then
2733: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2734: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);
2735: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2736: end if;
2737:

Line 2734: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);

2730: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2731:
2732: if ( sql%rowcount > 0 ) then
2733: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2734: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);
2735: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2736: end if;
2737:
2738: update wip_job_schedule_interface wjsi

Line 2735: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2731:
2732: if ( sql%rowcount > 0 ) then
2733: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2734: fnd_message.set_token('COLUMN', 'SOURCE_CODE', false);
2735: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2736: end if;
2737:
2738: update wip_job_schedule_interface wjsi
2739: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 2749: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2745: and wjsi.load_type = wip_constants.create_sched
2746: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2747:
2748: if ( sql%rowcount > 0 ) then
2749: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2750: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2751: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2752: end if;
2753:

Line 2750: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);

2746: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2747:
2748: if ( sql%rowcount > 0 ) then
2749: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2750: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2751: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2752: end if;
2753:
2754: --

Line 2751: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2747:
2748: if ( sql%rowcount > 0 ) then
2749: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2750: fnd_message.set_token('COLUMN', 'SOURCE_LINE_ID', false);
2751: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2752: end if;
2753:
2754: --
2755: -- default and validate scheduling_method

Line 2768: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2764: and wjsi.load_type = wip_constants.create_sched
2765: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2766:
2767: if ( sql%rowcount > 0 ) then
2768: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2769: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
2770: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2771: end if;
2772:

Line 2769: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);

2765: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2766:
2767: if ( sql%rowcount > 0 ) then
2768: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2769: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
2770: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2771: end if;
2772:
2773: update wip_job_schedule_interface wjsi

Line 2770: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2766:
2767: if ( sql%rowcount > 0 ) then
2768: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2769: fnd_message.set_token('COLUMN', 'SCHEDULING_METHOD', false);
2770: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2771: end if;
2772:
2773: update wip_job_schedule_interface wjsi
2774: set wjsi.scheduling_method = wip_constants.routing,

Line 2807: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');

2803: wip_constants.ml_manual)
2804: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2805:
2806: if ( sql%rowcount > 0 ) then
2807: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2808: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2809: end if;
2810:
2811: update wip_job_schedule_interface wjsi

Line 2808: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2804: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2805:
2806: if ( sql%rowcount > 0 ) then
2807: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2808: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2809: end if;
2810:
2811: update wip_job_schedule_interface wjsi
2812: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 2836: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');

2832: wjsi.first_unit_start_date > wjsi.last_unit_completion_date)))
2833: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2834:
2835: if ( sql%rowcount > 0 ) then
2836: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2837: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2838: end if;
2839:
2840: update wip_job_schedule_interface wjsi

Line 2837: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2833: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2834:
2835: if ( sql%rowcount > 0 ) then
2836: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD');
2837: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2838: end if;
2839:
2840: update wip_job_schedule_interface wjsi
2841: set wjsi.process_status = WIP_CONSTANTS.ERROR,

Line 2854: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD2');

2850: wjsi.last_unit_completion_date is null)
2851: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2852:
2853: if ( sql%rowcount > 0 ) then
2854: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD2');
2855: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2856: end if;
2857:
2858: --

Line 2855: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2851: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2852:
2853: if ( sql%rowcount > 0 ) then
2854: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULING_METHOD2');
2855: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2856: end if;
2857:
2858: --
2859: -- default and validate allow_explosion

Line 2872: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2868: and wjsi.load_type = wip_constants.create_sched
2869: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2870:
2871: if ( sql%rowcount > 0 ) then
2872: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2873: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2874: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2875: end if;
2876:

Line 2873: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);

2869: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2870:
2871: if ( sql%rowcount > 0 ) then
2872: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2873: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2874: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2875: end if;
2876:
2877: --

Line 2874: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2870:
2871: if ( sql%rowcount > 0 ) then
2872: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2873: fnd_message.set_token('COLUMN', 'ALLOW_EXPLOSION', false);
2874: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2875: end if;
2876:
2877: --
2878: -- default and validate allow_explosion

Line 2891: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2887: and wjsi.load_type = wip_constants.create_sched
2888: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2889:
2890: if ( sql%rowcount > 0 ) then
2891: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2892: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2893: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2894: end if;
2895:

Line 2892: fnd_message.set_token('COLUMN', 'PRIORITY', false);

2888: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2889:
2890: if ( sql%rowcount > 0 ) then
2891: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2892: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2893: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2894: end if;
2895:
2896: --

Line 2893: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2889:
2890: if ( sql%rowcount > 0 ) then
2891: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2892: fnd_message.set_token('COLUMN', 'PRIORITY', false);
2893: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2894: end if;
2895:
2896: --
2897: -- default and validate end_item_unit_number

Line 2911: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2907: wip_constants.resched_job)
2908: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2909:
2910: if ( sql%rowcount > 0 ) then
2911: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2912: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2913: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2914: end if;
2915:

Line 2912: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);

2908: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2909:
2910: if ( sql%rowcount > 0 ) then
2911: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2912: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2913: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2914: end if;
2915:
2916: --

Line 2913: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2909:
2910: if ( sql%rowcount > 0 ) then
2911: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2912: fnd_message.set_token('COLUMN', 'END_ITEM_UNIT_NUMBER', false);
2913: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2914: end if;
2915:
2916: --
2917: -- validate schedule dates

Line 2980: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_DATES');

2976: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2977:
2978:
2979: if ( sql%rowcount > 0 ) then
2980: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_DATES');
2981: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2982: end if;
2983:
2984: update wip_job_schedule_interface wjsi

Line 2981: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

2977:
2978:
2979: if ( sql%rowcount > 0 ) then
2980: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_DATES');
2981: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
2982: end if;
2983:
2984: update wip_job_schedule_interface wjsi
2985: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 2995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

2991: and wjsi.load_type <> wip_constants.create_sched
2992: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2993:
2994: if ( sql%rowcount > 0 ) then
2995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2996: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);
2997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2998: end if;
2999:

Line 2996: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);

2992: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2993:
2994: if ( sql%rowcount > 0 ) then
2995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2996: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);
2997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2998: end if;
2999:
3000: update wip_job_schedule_interface wjsi

Line 2997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

2993:
2994: if ( sql%rowcount > 0 ) then
2995: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
2996: fnd_message.set_token('COLUMN', 'LAST_UNIT_START_DATE', false);
2997: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
2998: end if;
2999:
3000: update wip_job_schedule_interface wjsi
3001: set wjsi.process_status = WIP_CONSTANTS.WARNING,

Line 3011: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

3007: and wjsi.load_type <> wip_constants.create_sched
3008: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3009:
3010: if ( sql%rowcount > 0 ) then
3011: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3012: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3013: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3014: end if;
3015: end if;

Line 3012: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);

3008: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3009:
3010: if ( sql%rowcount > 0 ) then
3011: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3012: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3013: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3014: end if;
3015: end if;
3016:

Line 3013: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);

3009:
3010: if ( sql%rowcount > 0 ) then
3011: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3012: fnd_message.set_token('COLUMN', 'FIRST_UNIT_COMPLETION_DATE', false);
3013: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
3014: end if;
3015: end if;
3016:
3017: --

Line 3031: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');

3027: and wjsi.load_type = wip_constants.create_sched
3028: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3029:
3030: if ( sql%rowcount > 0 ) then
3031: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
3032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3033: end if;
3034:
3035: if (l_logLevel <= wip_constants.trace_logging) then

Line 3032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);

3028: returning wjsi.interface_id bulk collect into l_interfaceTbl;
3029:
3030: if ( sql%rowcount > 0 ) then
3031: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
3032: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
3033: end if;
3034:
3035: if (l_logLevel <= wip_constants.trace_logging) then
3036: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 3435: fnd_message.set_name('WIP', l_msg);

3431: end if;
3432: end if;
3433: exception
3434: when others then
3435: fnd_message.set_name('WIP', l_msg);
3436: x_errorMsg := fnd_message.get;
3437: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3438: raise line_validation_error;
3439: end estimateLeadTime;

Line 3436: x_errorMsg := fnd_message.get;

3432: end if;
3433: exception
3434: when others then
3435: fnd_message.set_name('WIP', l_msg);
3436: x_errorMsg := fnd_message.get;
3437: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3438: raise line_validation_error;
3439: end estimateLeadTime;
3440:

Line 3466: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

3462: and ppp.organization_id = wjsi_row.organization_id;
3463: end if;
3464: exception
3465: when others then
3466: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3467: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3468: x_errorMsg := fnd_message.get;
3469: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3470: raise line_validation_error;

Line 3467: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);

3463: end if;
3464: exception
3465: when others then
3466: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3467: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3468: x_errorMsg := fnd_message.get;
3469: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3470: raise line_validation_error;
3471: end;

Line 3468: x_errorMsg := fnd_message.get;

3464: exception
3465: when others then
3466: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3467: fnd_message.set_token('COLUMN', 'PROJECT_NUMBER', false);
3468: x_errorMsg := fnd_message.get;
3469: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3470: raise line_validation_error;
3471: end;
3472: end if;

Line 3491: fnd_message.set_name('WIP', 'WIP_ML_PROJECT_ID');

3487: and ppp.organization_id = mp.organization_id
3488: and nvl(mp.project_reference_enabled, 2) = wip_constants.yes;
3489: exception
3490: when others then
3491: fnd_message.set_name('WIP', 'WIP_ML_PROJECT_ID');
3492: x_errorMsg := fnd_message.get;
3493: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3494: raise line_validation_error;
3495: end;

Line 3492: x_errorMsg := fnd_message.get;

3488: and nvl(mp.project_reference_enabled, 2) = wip_constants.yes;
3489: exception
3490: when others then
3491: fnd_message.set_name('WIP', 'WIP_ML_PROJECT_ID');
3492: x_errorMsg := fnd_message.get;
3493: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3494: raise line_validation_error;
3495: end;
3496: end if;

Line 3518: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');

3514: and task_number = wjsi_row.task_number;
3515: end if;
3516: exception
3517: when others then
3518: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3519: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3520: x_errorMsg := fnd_message.get;
3521: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3522: raise line_validation_error;

Line 3519: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);

3515: end if;
3516: exception
3517: when others then
3518: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3519: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3520: x_errorMsg := fnd_message.get;
3521: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3522: raise line_validation_error;
3523: end;

Line 3520: x_errorMsg := fnd_message.get;

3516: exception
3517: when others then
3518: fnd_message.set_name('WIP', 'WIP_ML_FIELD_INVALID');
3519: fnd_message.set_token('COLUMN', 'TASK_NUMBER', false);
3520: x_errorMsg := fnd_message.get;
3521: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3522: raise line_validation_error;
3523: end;
3524: end if;

Line 3541: fnd_message.set_name('WIP', 'WIP_ML_TASK_ID');

3537: end if;
3538:
3539: exception
3540: when others then
3541: fnd_message.set_name('WIP', 'WIP_ML_TASK_ID');
3542: x_errorMsg := fnd_message.get;
3543: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3544: raise line_validation_error;
3545: end;

Line 3542: x_errorMsg := fnd_message.get;

3538:
3539: exception
3540: when others then
3541: fnd_message.set_name('WIP', 'WIP_ML_TASK_ID');
3542: x_errorMsg := fnd_message.get;
3543: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3544: raise line_validation_error;
3545: end;
3546: end if;

Line 3584: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');

3580: begin
3581: if ( wjsi_row.class_code is not null and
3582: wjsi_row.load_type in (wip_constants.resched_job,
3583: wip_constants.create_sched)) then
3584: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3585: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3586: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3587: end if;
3588:

Line 3585: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);

3581: if ( wjsi_row.class_code is not null and
3582: wjsi_row.load_type in (wip_constants.resched_job,
3583: wip_constants.create_sched)) then
3584: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3585: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3586: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3587: end if;
3588:
3589: -- default the class code

Line 3586: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);

3582: wjsi_row.load_type in (wip_constants.resched_job,
3583: wip_constants.create_sched)) then
3584: fnd_message.set_name('WIP', 'WIP_ML_FIELD_IGNORED');
3585: fnd_message.set_token('COLUMN', 'CLASS_CODE', false);
3586: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3587: end if;
3588:
3589: -- default the class code
3590: if ( wjsi_row.class_code is null ) then

Line 3602: fnd_message.set_name('WIP', l_errMsg1);

3598: x_err_mesg_2 => l_errMsg2,
3599: x_err_class_1 => l_errClass1,
3600: x_err_class_2 => l_errClass2);
3601: if ( l_errMsg1 is not null) then
3602: fnd_message.set_name('WIP', l_errMsg1);
3603: fnd_message.set_token('class_code', l_errClass1, false);
3604: x_errorMsg := fnd_message.get;
3605: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3606: raise line_validation_error;

Line 3603: fnd_message.set_token('class_code', l_errClass1, false);

3599: x_err_class_1 => l_errClass1,
3600: x_err_class_2 => l_errClass2);
3601: if ( l_errMsg1 is not null) then
3602: fnd_message.set_name('WIP', l_errMsg1);
3603: fnd_message.set_token('class_code', l_errClass1, false);
3604: x_errorMsg := fnd_message.get;
3605: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3606: raise line_validation_error;
3607: end if ;

Line 3604: x_errorMsg := fnd_message.get;

3600: x_err_class_2 => l_errClass2);
3601: if ( l_errMsg1 is not null) then
3602: fnd_message.set_name('WIP', l_errMsg1);
3603: fnd_message.set_token('class_code', l_errClass1, false);
3604: x_errorMsg := fnd_message.get;
3605: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3606: raise line_validation_error;
3607: end if ;
3608: if (l_errMsg2 is not null) then

Line 3609: fnd_message.set_name('WIP', l_errMsg2);

3605: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3606: raise line_validation_error;
3607: end if ;
3608: if (l_errMsg2 is not null) then
3609: fnd_message.set_name('WIP', l_errMsg2);
3610: fnd_message.set_token('class_code', l_errClass2, false);
3611: x_errorMsg := fnd_message.get;
3612: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3613: raise line_validation_error;

Line 3610: fnd_message.set_token('class_code', l_errClass2, false);

3606: raise line_validation_error;
3607: end if ;
3608: if (l_errMsg2 is not null) then
3609: fnd_message.set_name('WIP', l_errMsg2);
3610: fnd_message.set_token('class_code', l_errClass2, false);
3611: x_errorMsg := fnd_message.get;
3612: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3613: raise line_validation_error;
3614: end if ;

Line 3611: x_errorMsg := fnd_message.get;

3607: end if ;
3608: if (l_errMsg2 is not null) then
3609: fnd_message.set_name('WIP', l_errMsg2);
3610: fnd_message.set_token('class_code', l_errClass2, false);
3611: x_errorMsg := fnd_message.get;
3612: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3613: raise line_validation_error;
3614: end if ;
3615: elsif ( wjsi_row.load_type = wip_constants.resched_job ) then

Line 3660: fnd_message.set_name('WIP', 'WIP_ML_CLASS_CODE');

3656: and organization_id = wjsi_row.organization_id);
3657: end if;
3658: exception
3659: when others then
3660: fnd_message.set_name('WIP', 'WIP_ML_CLASS_CODE');
3661: x_errorMsg := fnd_message.get;
3662: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3663: raise line_validation_error;
3664: end;

Line 3661: x_errorMsg := fnd_message.get;

3657: end if;
3658: exception
3659: when others then
3660: fnd_message.set_name('WIP', 'WIP_ML_CLASS_CODE');
3661: x_errorMsg := fnd_message.get;
3662: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3663: raise line_validation_error;
3664: end;
3665: end validateClassCode;

Line 3704: fnd_message.set_name('WIP', 'WIP_ML_BOM_REVISION');

3700: p_start_date => greatest(nvl(wjsi_row.first_unit_start_date, wjsi_row.last_unit_completion_date), sysdate));
3701: end if;
3702: exception
3703: when others then
3704: fnd_message.set_name('WIP', 'WIP_ML_BOM_REVISION');
3705: x_errorMsg := fnd_message.get;
3706: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3707: raise line_validation_error;
3708: end validateBOMRevision;

Line 3705: x_errorMsg := fnd_message.get;

3701: end if;
3702: exception
3703: when others then
3704: fnd_message.set_name('WIP', 'WIP_ML_BOM_REVISION');
3705: x_errorMsg := fnd_message.get;
3706: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3707: raise line_validation_error;
3708: end validateBOMRevision;
3709:

Line 3774: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REVISION');

3770: end if;
3771: end if;
3772: exception
3773: when others then
3774: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REVISION');
3775: x_errorMsg := fnd_message.get;
3776: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3777: raise line_validation_error;
3778: end validateRoutingRevision;

Line 3775: x_errorMsg := fnd_message.get;

3771: end if;
3772: exception
3773: when others then
3774: fnd_message.set_name('WIP', 'WIP_ML_ROUTING_REVISION');
3775: x_errorMsg := fnd_message.get;
3776: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3777: raise line_validation_error;
3778: end validateRoutingRevision;
3779:

Line 3824: fnd_message.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');

3820: /* bug 5350660. Show warning if job is already pick released */
3821: if ( wip_picking_pub.is_job_pick_released(wjsi_row.wip_entity_id,
3822: wjsi_row.repetitive_schedule_id,
3823: wjsi_row.organization_id)) then
3824: fnd_message.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');
3825: setInterfaceError(p_rowid, wjsi_row.interface_id, substr(fnd_message.get, 1, 500), validationWarning);
3826: end if;
3827: end if;
3828: exception

Line 3825: setInterfaceError(p_rowid, wjsi_row.interface_id, substr(fnd_message.get, 1, 500), validationWarning);

3821: if ( wip_picking_pub.is_job_pick_released(wjsi_row.wip_entity_id,
3822: wjsi_row.repetitive_schedule_id,
3823: wjsi_row.organization_id)) then
3824: fnd_message.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');
3825: setInterfaceError(p_rowid, wjsi_row.interface_id, substr(fnd_message.get, 1, 500), validationWarning);
3826: end if;
3827: end if;
3828: exception
3829: when others then

Line 3830: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');

3826: end if;
3827: end if;
3828: exception
3829: when others then
3830: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');
3831: x_errorMsg := fnd_message.get;
3832: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3833: raise line_validation_error;
3834: end validateStartQuantity;

Line 3831: x_errorMsg := fnd_message.get;

3827: end if;
3828: exception
3829: when others then
3830: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');
3831: x_errorMsg := fnd_message.get;
3832: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3833: raise line_validation_error;
3834: end validateStartQuantity;
3835:

Line 3910: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);

3906: p_org_id => wjsi_row.organization_id,
3907: x_return_status => l_retStatus);
3908: if ( l_retStatus <> fnd_api.g_ret_sts_success ) then
3909: po_warning_flag := WIP_CONSTANTS.YES;
3910: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3911: end if;
3912: else
3913: -- propagate_job_change_to_po is manual or job status is 'Complete'
3914: po_warning_flag := WIP_CONSTANTS.YES;

Line 3915: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

3911: end if;
3912: else
3913: -- propagate_job_change_to_po is manual or job status is 'Complete'
3914: po_warning_flag := WIP_CONSTANTS.YES;
3915: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
3916: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3917: end if;
3918: else
3919: -- customer does not have PO patchset J onward, so behave the the old way

Line 3916: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);

3912: else
3913: -- propagate_job_change_to_po is manual or job status is 'Complete'
3914: po_warning_flag := WIP_CONSTANTS.YES;
3915: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
3916: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3917: end if;
3918: else
3919: -- customer does not have PO patchset J onward, so behave the the old way
3920: po_warning_flag := WIP_CONSTANTS.YES;

Line 3921: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

3917: end if;
3918: else
3919: -- customer does not have PO patchset J onward, so behave the the old way
3920: po_warning_flag := WIP_CONSTANTS.YES;
3921: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
3922: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3923: end if;
3924: end if; -- po/requisiton exist
3925: end if;

Line 3922: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);

3918: else
3919: -- customer does not have PO patchset J onward, so behave the the old way
3920: po_warning_flag := WIP_CONSTANTS.YES;
3921: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
3922: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
3923: end if;
3924: end if; -- po/requisiton exist
3925: end if;
3926:

Line 3948: fnd_message.set_name('WIP', l_msg);

3944: raise fnd_api.g_exc_unexpected_error;
3945: end if;
3946: exception
3947: when others then
3948: fnd_message.set_name('WIP', l_msg);
3949: x_errorMsg := fnd_message.get;
3950: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3951: raise line_validation_error;
3952: end validateStatusType;

Line 3949: x_errorMsg := fnd_message.get;

3945: end if;
3946: exception
3947: when others then
3948: fnd_message.set_name('WIP', l_msg);
3949: x_errorMsg := fnd_message.get;
3950: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3951: raise line_validation_error;
3952: end validateStatusType;
3953:

Line 3983: fnd_message.set_name('WIP', 'WIP_ML_BUILD_SEQUENCE');

3979: p_organization_id => wjsi_row.organization_id,
3980: p_line_id => nvl(wjsi_row.line_id, wdj_row.line_id),
3981: p_schedule_group_id => nvl(wjsi_row.schedule_group_id, wdj_row.schedule_group_id) );
3982: if( not l_retval ) then
3983: fnd_message.set_name('WIP', 'WIP_ML_BUILD_SEQUENCE');
3984: x_errorMsg := fnd_message.get;
3985: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3986: raise line_validation_error;
3987: end if;

Line 3984: x_errorMsg := fnd_message.get;

3980: p_line_id => nvl(wjsi_row.line_id, wdj_row.line_id),
3981: p_schedule_group_id => nvl(wjsi_row.schedule_group_id, wdj_row.schedule_group_id) );
3982: if( not l_retval ) then
3983: fnd_message.set_name('WIP', 'WIP_ML_BUILD_SEQUENCE');
3984: x_errorMsg := fnd_message.get;
3985: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
3986: raise line_validation_error;
3987: end if;
3988: end if;

Line 4022: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;

4018: exception
4019: when too_many_rows then
4020: null; -- the query returning multiple rows is ok
4021: when others then
4022: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4023: x_errorMsg := fnd_message.get;
4024: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4025: raise line_validation_error;
4026: end;

Line 4023: x_errorMsg := fnd_message.get;

4019: when too_many_rows then
4020: null; -- the query returning multiple rows is ok
4021: when others then
4022: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4023: x_errorMsg := fnd_message.get;
4024: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4025: raise line_validation_error;
4026: end;
4027: end if;

Line 4044: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');

4040:
4041: if (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
4042: -- Unit number is required for unit effective assemblies.
4043: if( l_isUnitEffective and wjsi_row.end_item_unit_number is null) then
4044: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');
4045: x_errorMsg := fnd_message.get;
4046: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4047: raise line_validation_error;
4048: end if;

Line 4045: x_errorMsg := fnd_message.get;

4041: if (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
4042: -- Unit number is required for unit effective assemblies.
4043: if( l_isUnitEffective and wjsi_row.end_item_unit_number is null) then
4044: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER REQUIRED');
4045: x_errorMsg := fnd_message.get;
4046: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4047: raise line_validation_error;
4048: end if;
4049: end if;

Line 4061: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID');

4057: from wip_discrete_jobs wdj
4058: where wdj.wip_entity_id = wjsi_row.wip_entity_id;
4059: exception
4060: when others then
4061: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID');
4062: x_errorMsg := fnd_message.get;
4063: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4064: raise line_validation_error;
4065: end;

Line 4062: x_errorMsg := fnd_message.get;

4058: where wdj.wip_entity_id = wjsi_row.wip_entity_id;
4059: exception
4060: when others then
4061: fnd_message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID');
4062: x_errorMsg := fnd_message.get;
4063: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4064: raise line_validation_error;
4065: end;
4066: end if;

Line 4079: fnd_message.set_name('WIP', 'END_ITEM_UNIT_NUMBER');

4075: end if;
4076:
4077: if ( wjsi_row.status_type <> wip_constants.unreleased and
4078: wjsi_row.end_item_unit_number is not null ) then
4079: fnd_message.set_name('WIP', 'END_ITEM_UNIT_NUMBER');
4080: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationWarning);
4081: -- Added by Renga Kannan
4082: -- Fixed for bug 5332672
4083: -- Added code to get the end unit item number from wip_discrete_jobs and populate

Line 4096: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;

4092: where rowid = p_rowid
4093: );
4094: exception
4095: when others then
4096: FND_Message.set_name('PJM', 'UEFF-UNIT NUMBER INVALID') ;
4097: WIP_JSI_Utils.record_current_error ;
4098: raise fnd_api.g_exc_unexpected_error;
4099: end ;
4100:

Line 4106: fnd_message.set_name('WIP', l_msg);

4102: end if;
4103: end if;
4104: exception
4105: when fnd_api.g_exc_unexpected_error then
4106: fnd_message.set_name('WIP', l_msg);
4107: x_errorMsg := fnd_message.get;
4108: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4109: raise line_validation_error;
4110: end validateEndItemUnitNumber;

Line 4107: x_errorMsg := fnd_message.get;

4103: end if;
4104: exception
4105: when fnd_api.g_exc_unexpected_error then
4106: fnd_message.set_name('WIP', l_msg);
4107: x_errorMsg := fnd_message.get;
4108: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4109: raise line_validation_error;
4110: end validateEndItemUnitNumber;
4111:

Line 4127: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');

4123: from wip_lines_val_v
4124: where line_id = wjsi_row.line_id;
4125:
4126: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4127: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4128: fnd_message.set_token('ENTITY1', l_maxLineRate);
4129: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4130: end if;
4131: end validateDailyProductionRate;

Line 4128: fnd_message.set_token('ENTITY1', l_maxLineRate);

4124: where line_id = wjsi_row.line_id;
4125:
4126: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4127: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4128: fnd_message.set_token('ENTITY1', l_maxLineRate);
4129: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4130: end if;
4131: end validateDailyProductionRate;
4132:

Line 4129: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);

4125:
4126: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4127: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');
4128: fnd_message.set_token('ENTITY1', l_maxLineRate);
4129: setInterfaceError(p_rowid, wjsi_row.interface_id, fnd_message.get, validationWarning);
4130: end if;
4131: end validateDailyProductionRate;
4132:
4133:

Line 4350: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_DATES');

4346: end if;
4347: end if;
4348: exception
4349: when others then
4350: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_DATES');
4351: x_errorMsg := fnd_message.get;
4352: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4353: raise line_validation_error;
4354: end validateRepScheduleDates;

Line 4351: x_errorMsg := fnd_message.get;

4347: end if;
4348: exception
4349: when others then
4350: fnd_message.set_name('WIP', 'WIP_ML_REPETITIVE_DATES');
4351: x_errorMsg := fnd_message.get;
4352: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4353: raise line_validation_error;
4354: end validateRepScheduleDates;
4355:

Line 4508: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');

4504: end if;
4505: exception
4506: when others then
4507: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4508: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
4509: x_errorMsg := fnd_message.get;
4510: setInterfaceError(p_rowid, l_interfaceID, x_errorMsg, validationError);
4511: end validateSerializationStartOp;
4512:

Line 4509: x_errorMsg := fnd_message.get;

4505: exception
4506: when others then
4507: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
4508: fnd_message.set_name('WIP', 'WIP_ML_SERIAL_START_OP');
4509: x_errorMsg := fnd_message.get;
4510: setInterfaceError(p_rowid, l_interfaceID, x_errorMsg, validationError);
4511: end validateSerializationStartOp;
4512:
4513:

Line 4620: fnd_message.set_name('WIP', l_msg);

4616: end if;
4617:
4618: exception
4619: when others then
4620: fnd_message.set_name('WIP', l_msg);
4621: x_errorMsg := fnd_message.get;
4622: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4623: raise line_validation_error;
4624: end validateSubinvLocator;

Line 4621: x_errorMsg := fnd_message.get;

4617:
4618: exception
4619: when others then
4620: fnd_message.set_name('WIP', l_msg);
4621: x_errorMsg := fnd_message.get;
4622: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4623: raise line_validation_error;
4624: end validateSubinvLocator;
4625:

Line 4809: fnd_message.set_name('WIP', l_msg);

4805: raise fnd_api.g_exc_unexpected_error;
4806: end if ;
4807: exception
4808: when others then
4809: fnd_message.set_name('WIP', l_msg);
4810: x_errorMsg := fnd_message.get;
4811: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4812: raise line_validation_error;
4813: end validateKanban;

Line 4810: x_errorMsg := fnd_message.get;

4806: end if ;
4807: exception
4808: when others then
4809: fnd_message.set_name('WIP', l_msg);
4810: x_errorMsg := fnd_message.get;
4811: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4812: raise line_validation_error;
4813: end validateKanban;
4814:

Line 4862: fnd_message.set_name('WIP', l_msg);

4858: end if;
4859: end if;
4860: exception
4861: when others then
4862: fnd_message.set_name('WIP', l_msg);
4863: x_errorMsg := fnd_message.get;
4864: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4865: raise line_validation_error;
4866: end validateOvercompletion;

Line 4863: x_errorMsg := fnd_message.get;

4859: end if;
4860: exception
4861: when others then
4862: fnd_message.set_name('WIP', l_msg);
4863: x_errorMsg := fnd_message.get;
4864: setInterfaceError(p_rowid, wjsi_row.interface_id, x_errorMsg, validationError);
4865: raise line_validation_error;
4866: end validateOvercompletion;
4867: