eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_JSI_DEFAULTER dependencies on WIP_CONSTANTS

Line 197: if(l_loadType in (wip_constants.create_job, wip_constants.create_ns_job)) then

193: return;
194: end if;
195: --warnings are populated in default values as to provide messages to the
196: --user asap
197: if(l_loadType in (wip_constants.create_job, wip_constants.create_ns_job)) then
198: if(p_rtgVal is not null) then
199: update wip_discrete_jobs
200: set serialization_start_op = p_rtgVal
201: where wip_entity_id = l_wipID

Line 206: and serial_number_control_code = wip_constants.full_sn);

202: and exists (select 1
203: from mtl_system_items
204: where inventory_item_id = l_primaryItem
205: and organization_id = l_orgID
206: and serial_number_control_code = wip_constants.full_sn);
207:
208: elsif(l_default = wip_constants.yes) then
209: update wip_discrete_jobs
210: set serialization_start_op = (select nvl(min(operation_seq_num), 1)

Line 208: elsif(l_default = wip_constants.yes) then

204: where inventory_item_id = l_primaryItem
205: and organization_id = l_orgID
206: and serial_number_control_code = wip_constants.full_sn);
207:
208: elsif(l_default = wip_constants.yes) then
209: update wip_discrete_jobs
210: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
211: from wip_operations
212: where wip_entity_id = l_wipID)

Line 218: and serial_number_control_code = wip_constants.full_sn);

214: and exists (select 1
215: from mtl_system_items
216: where inventory_item_id = l_primaryItem
217: and organization_id = l_orgID
218: and serial_number_control_code = wip_constants.full_sn);
219: end if;
220: end if;
221: end default_serialization_op;
222:

Line 264: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then

260: procedure job_name is begin
261: --wip_entity_name defaulting
262:
263: --if rescheduling job default name, warn if both name and id provided
264: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
265: if(wjsi_row.wip_entity_id is null) then
266: select wip_entity_id
267: into wjsi_row.wip_entity_id
268: from wip_entities

Line 275: elsif(wjsi_row.load_type = wip_constants.create_sched) then

271: elsif(wjsi_row.job_name is not null) then
272: WIP_JSI_Utils.record_ignored_column_warning('JOB_NAME');
273: end if;
274: --if rep sched, name is ignored
275: elsif(wjsi_row.load_type = wip_constants.create_sched) then
276: if(wjsi_row.job_name is not null) then
277: WIP_JSI_Utils.record_ignored_column_warning('JOB_NAME');
278: end if;
279: --when creating a job, if name isn't provided, create one

Line 282: if (wjsi_row.load_type = wip_constants.create_eam_job) then

278: end if;
279: --when creating a job, if name isn't provided, create one
280: elsif(wjsi_row.job_name is null) then
281: /* Fix for Bug#2994658 */
282: if (wjsi_row.load_type = wip_constants.create_eam_job) then
283: select WORK_ORDER_PREFIX || wip_job_number_s.nextval
284: into wjsi_row.job_name
285: from wip_eam_parameters
286: where organization_id = wjsi_row.organization_id ;

Line 302: if(wjsi_row.load_type = wip_constants.create_sched) then

298:
299: procedure wip_entity_id is
300: l_dummy NUMBER;
301: begin
302: if(wjsi_row.load_type = wip_constants.create_sched) then
303: if(wjsi_row.wip_entity_id is not null) then
304: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
305: end if;
306: --if create job request, then ignore interface wip_entity and default from sequence

Line 307: elsif(wjsi_row.load_type in (wip_constants.create_job,

303: if(wjsi_row.wip_entity_id is not null) then
304: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
305: end if;
306: --if create job request, then ignore interface wip_entity and default from sequence
307: elsif(wjsi_row.load_type in (wip_constants.create_job,
308: wip_constants.create_ns_job,
309: wip_constants.create_eam_job)) then
310: if(wjsi_row.wip_entity_id is not null) then
311: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');

Line 308: wip_constants.create_ns_job,

304: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
305: end if;
306: --if create job request, then ignore interface wip_entity and default from sequence
307: elsif(wjsi_row.load_type in (wip_constants.create_job,
308: wip_constants.create_ns_job,
309: wip_constants.create_eam_job)) then
310: if(wjsi_row.wip_entity_id is not null) then
311: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
312: end if;

Line 309: wip_constants.create_eam_job)) then

305: end if;
306: --if create job request, then ignore interface wip_entity and default from sequence
307: elsif(wjsi_row.load_type in (wip_constants.create_job,
308: wip_constants.create_ns_job,
309: wip_constants.create_eam_job)) then
310: if(wjsi_row.wip_entity_id is not null) then
311: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
312: end if;
313: select wip_entities_s.nextval

Line 331: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

327: end wip_entity_id;
328:
329: procedure schedule_group is begin
330: --schedule group defaulting
331: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
332: if(wjsi_row.schedule_group_id is not null) then
333: wip_jsi_utils.record_ignored_column_warning('SCHEDULE_GROUP_ID');
334: end if;
335: if(wjsi_row.schedule_group_name is not null) then

Line 353: if(wjsi_row.load_type = wip_constants.resched_job and

349: else
350: wip_jsi_utils.record_ignored_column_warning('SCHEDULE_GROUP_NAME');
351: end if;
352: --if still null, default from job
353: if(wjsi_row.load_type = wip_constants.resched_job and
354: wjsi_row.schedule_group_id is null) then
355: begin
356: select schedule_group_id
357: into wjsi_row.schedule_group_id

Line 429: if(wjsi_row.load_type = wip_constants.create_sched) then

425: wip_jsi_utils.abort_request;
426: end line_code;
427:
428: procedure project_number is begin
429: if(wjsi_row.load_type = wip_constants.create_sched) then
430: if(wjsi_row.project_number is not null) then
431: WIP_JSI_Utils.record_ignored_column_warning('PROJECT_NUMBER');
432: end if;
433: if(wjsi_row.project_id is not null) then

Line 442: elsif(wjsi_row.load_type not in (wip_constants.resched_job, wip_constants.resched_eam_job) and

438: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
439: select pjm_project.val_proj_numtoid(wjsi_row.project_number, wjsi_row.organization_id)
440: into wjsi_row.project_id
441: from dual;
442: elsif(wjsi_row.load_type not in (wip_constants.resched_job, wip_constants.resched_eam_job) and
443: wjsi_row.task_number is not null
444: and wjsi_row.task_id is not null) then
445: raise fnd_api.g_exc_unexpected_error;
446: end if;

Line 454: if(wjsi_row.load_type = wip_constants.create_sched) then

450: wip_jsi_utils.abort_request;
451: end project_number;
452:
453: procedure task_number is begin
454: if(wjsi_row.load_type = wip_constants.create_sched) then
455: if(wjsi_row.task_number is not null) then
456: WIP_JSI_Utils.record_ignored_column_warning('TASK_NUMBER');
457: end if;
458: if(wjsi_row.task_id is not null) then

Line 462: if(wjsi_row.load_type = wip_constants.resched_job) then

458: if(wjsi_row.task_id is not null) then
459: WIP_JSI_Utils.record_ignored_column_warning('TASK_ID');
460: end if;
461: elsif(wjsi_row.task_number is not null and wjsi_row.task_id is null) then
462: if(wjsi_row.load_type = wip_constants.resched_job) then
463: select pa.task_id
464: into wjsi_row.task_id
465: from pa_tasks_expend_v pa, wip_discrete_jobs wdj
466: where wdj.wip_entity_id = wjsi_row.wip_entity_id

Line 487: wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,

483: end task_number;
484:
485: procedure firm_planned_flag is begin
486: if(wjsi_row.firm_planned_flag is null and
487: wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
488: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
489: wjsi_row.firm_planned_flag := wip_constants.no;
490: end if;
491: end firm_planned_flag;

Line 488: wip_constants.create_ns_job, wip_constants.create_eam_job)) then

484:
485: procedure firm_planned_flag is begin
486: if(wjsi_row.firm_planned_flag is null and
487: wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
488: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
489: wjsi_row.firm_planned_flag := wip_constants.no;
490: end if;
491: end firm_planned_flag;
492:

Line 489: wjsi_row.firm_planned_flag := wip_constants.no;

485: procedure firm_planned_flag is begin
486: if(wjsi_row.firm_planned_flag is null and
487: wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
488: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
489: wjsi_row.firm_planned_flag := wip_constants.no;
490: end if;
491: end firm_planned_flag;
492:
493: procedure demand_class is begin

Line 494: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

490: end if;
491: end firm_planned_flag;
492:
493: procedure demand_class is begin
494: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
495: wjsi_row.demand_class is not null) then
496: wip_jsi_utils.record_ignored_column_warning('DEMAND_CLASS');
497: end if;
498: end demand_class;

Line 502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then

498: end demand_class;
499:
500: procedure description is begin
501: if(wjsi_row.description is null) then
502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(dateval => sysdate,calendar_aware => 2), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then

Line 506: elsif(wjsi_row.load_type = wip_constants.create_sched) then

502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(dateval => sysdate,calendar_aware => 2), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(dateval => sysdate,calendar_aware => 2), false);
509: wjsi_row.description := fnd_message.get;
510: end if;

Line 515: if(wjsi_row.load_type = wip_constants.create_sched and

511: end if;
512: end description;
513:
514: procedure build_sequence is begin
515: if(wjsi_row.load_type = wip_constants.create_sched and
516: wjsi_row.build_sequence is not null) then
517: wip_jsi_utils.record_ignored_column_warning('BUILD_SEQUENCE');
518: end if;
519: end build_sequence;

Line 522: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.status_type is not null) then

518: end if;
519: end build_sequence;
520:
521: procedure status_type is begin
522: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.status_type is not null) then
523: wip_jsi_utils.record_ignored_column_warning('STATUS_TYPE');
524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,
525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
526: wjsi_row.status_type := wip_constants.unreleased;

Line 524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,

520:
521: procedure status_type is begin
522: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.status_type is not null) then
523: wip_jsi_utils.record_ignored_column_warning('STATUS_TYPE');
524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,
525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
526: wjsi_row.status_type := wip_constants.unreleased;
527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
528: wjsi_row.status_type is null) then

Line 525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then

521: procedure status_type is begin
522: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.status_type is not null) then
523: wip_jsi_utils.record_ignored_column_warning('STATUS_TYPE');
524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,
525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
526: wjsi_row.status_type := wip_constants.unreleased;
527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
528: wjsi_row.status_type is null) then
529: select wdj.status_type

Line 526: wjsi_row.status_type := wip_constants.unreleased;

522: if(wjsi_row.load_type = wip_constants.create_sched and wjsi_row.status_type is not null) then
523: wip_jsi_utils.record_ignored_column_warning('STATUS_TYPE');
524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,
525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
526: wjsi_row.status_type := wip_constants.unreleased;
527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
528: wjsi_row.status_type is null) then
529: select wdj.status_type
530: into wjsi_row.status_type

Line 527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

523: wip_jsi_utils.record_ignored_column_warning('STATUS_TYPE');
524: elsif(wjsi_row.status_type is null and wjsi_row.load_type in (wip_constants.create_job,
525: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
526: wjsi_row.status_type := wip_constants.unreleased;
527: elsif (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
528: wjsi_row.status_type is null) then
529: select wdj.status_type
530: into wjsi_row.status_type
531: from wip_discrete_jobs wdj

Line 538: if(wjsi_row.load_type <> wip_constants.create_sched and

534: end if;
535: end status_type;
536:
537: procedure processing_work_days is begin
538: if(wjsi_row.load_type <> wip_constants.create_sched and
539: wjsi_row.processing_work_days is not null) then
540: wip_jsi_utils.record_ignored_column_warning('PROCESSING_WORK_DAYS');
541: end if;
542: end processing_work_days;

Line 545: if(wjsi_row.load_type <> wip_constants.create_sched and

541: end if;
542: end processing_work_days;
543:
544: procedure daily_production_rate is begin
545: if(wjsi_row.load_type <> wip_constants.create_sched and
546: wjsi_row.daily_production_rate is not null) then
547: wip_jsi_utils.record_ignored_column_warning('DAILY_PRODUCTION_RATE');
548: end if;
549: end daily_production_rate;

Line 552: if(wjsi_row.load_type = wip_constants.create_sched) then

548: end if;
549: end daily_production_rate;
550:
551: procedure repetitive_schedule_id is begin
552: if(wjsi_row.load_type = wip_constants.create_sched) then
553: if(wjsi_row.repetitive_schedule_id is null) then
554: select wip_repetitive_schedules_s.nextval
555: into wjsi_row.repetitive_schedule_id
556: from dual;

Line 569: if(wjsi_row.kanban_card_id is null or wip_jsi_utils.validation_level <> wip_constants.inv) then

565: l_defaulted_job WIP_Work_Order_Pub.DiscreteJob_Rec_Type ;
566: l_raw_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
567: l_defaulted_sched WIP_Work_Order_Pub.RepSchedule_Rec_Type ;
568: begin
569: if(wjsi_row.kanban_card_id is null or wip_jsi_utils.validation_level <> wip_constants.inv) then
570: return;
571: end if;
572:
573:

Line 574: if(wjsi_row.load_type = wip_constants.create_job) then

570: return;
571: end if;
572:
573:
574: if(wjsi_row.load_type = wip_constants.create_job) then
575: l_raw_job := WIP_Work_Order_Pub.G_MISS_DISCRETEJOB_REC ;
576:
577: l_raw_job.organization_id := wjsi_row.organization_id ;
578: l_raw_job.kanban_card_id := wjsi_row.kanban_card_id ;

Line 595: elsif(wjsi_row.load_type = wip_constants.create_sched) then

591: wjsi_row.primary_item_id := l_defaulted_job.primary_item_id;
592: wjsi_row.completion_subinventory := l_defaulted_job.completion_subinventory;
593: wjsi_row.completion_locator_id := l_defaulted_job.completion_locator_id;
594: wjsi_row.start_quantity := l_defaulted_job.start_quantity;
595: elsif(wjsi_row.load_type = wip_constants.create_sched) then
596: l_raw_sched := WIP_Work_Order_Pub.G_MISS_REPSCHEDULE_REC ;
597:
598: l_raw_sched.organization_id := wjsi_row.organization_id ;
599: l_raw_sched.kanban_card_id := wjsi_row.kanban_card_id ;

Line 626: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then

622: wip_jsi_utils.abort_request ;
623: end kanban_card_id ;
624:
625: procedure primary_item is begin
626: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
627: if(wjsi_row.primary_item_segments is not null) then
628: wip_jsi_utils.record_ignored_column_warning('PRIMARY_ITEM_SEGMENTS');
629: end if;
630: if(wjsi_row.primary_item_id is not null) then

Line 651: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

647: wip_jsi_utils.abort_request;
648: end primary_item;
649:
650: procedure start_quantity is begin
651: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
652: if(wjsi_row.start_quantity is not null) then
653: wip_jsi_utils.record_ignored_column_warning('START_QUANTITY');
654: end if;
655: wjsi_row.start_quantity := 1;

Line 656: elsif(wjsi_row.load_type = wip_constants.create_sched and

652: if(wjsi_row.start_quantity is not null) then
653: wip_jsi_utils.record_ignored_column_warning('START_QUANTITY');
654: end if;
655: wjsi_row.start_quantity := 1;
656: elsif(wjsi_row.load_type = wip_constants.create_sched and
657: wjsi_row.start_quantity is not null) then
658: wip_jsi_utils.record_ignored_column_warning('START_QUANTITY');
659: end if;
660: end start_quantity;

Line 664: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then

660: end start_quantity;
661:
662: procedure net_quantity is begin
663: if(wjsi_row.net_quantity is null) then
664: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
665: wjsi_row.net_quantity := wjsi_row.start_quantity;
666: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
667: select decode(wdj.net_quantity,
668: wdj.start_quantity, wjsi_row.start_quantity,

Line 666: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then

662: procedure net_quantity is begin
663: if(wjsi_row.net_quantity is null) then
664: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
665: wjsi_row.net_quantity := wjsi_row.start_quantity;
666: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
667: select decode(wdj.net_quantity,
668: wdj.start_quantity, wjsi_row.start_quantity,
669: least(wdj.net_quantity, nvl(wjsi_row.start_quantity, wdj.net_quantity)))
670: into wjsi_row.net_quantity

Line 674: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then

670: into wjsi_row.net_quantity
671: from wip_discrete_jobs wdj
672: where wdj.wip_entity_id = wjsi_row.wip_entity_id
673: and wdj.organization_id = wjsi_row.organization_id;
674: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then
675: wjsi_row.net_quantity := 0;
676: end if;
677: else
678: if(wjsi_row.load_type = wip_constants.create_sched) then

Line 678: if(wjsi_row.load_type = wip_constants.create_sched) then

674: elsif(wjsi_row.load_type = wip_constants.create_ns_job) then
675: wjsi_row.net_quantity := 0;
676: end if;
677: else
678: if(wjsi_row.load_type = wip_constants.create_sched) then
679: wip_jsi_utils.record_ignored_column_warning('NET_QUANTITY');
680: end if;
681: end if;
682: exception

Line 693: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job, wip_constants.create_sched)) then

689: l_tolType NUMBER;
690: l_tolValue NUMBER;
691: l_primaryItemId NUMBER;
692: begin
693: if(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job, wip_constants.create_sched)) then
694: if(wjsi_row.overcompletion_tolerance_type is not null) then
695: wip_jsi_utils.record_ignored_column_warning ('OVERCOMPLETION_TOLERANCE_TYPE');
696: end if;
697: if(wjsi_row.overcompletion_tolerance_value is not null) then

Line 700: elsif(wjsi_row.load_type = wip_constants.create_ns_job and

696: end if;
697: if(wjsi_row.overcompletion_tolerance_value is not null) then
698: wip_jsi_utils.record_ignored_column_warning ('OVERCOMPLETION_TOLERANCE_VALUE');
699: end if;
700: elsif(wjsi_row.load_type = wip_constants.create_ns_job and
701: wjsi_row.primary_item_id is null) then
702: if(wjsi_row.overcompletion_tolerance_type is not null) then
703: wip_jsi_utils.record_ignored_column_warning ('OVERCOMPLETION_TOLERANCE_TYPE');
704: end if;

Line 709: if(wjsi_row.load_type = wip_constants.resched_job) then

705: if(wjsi_row.overcompletion_tolerance_value is not null) then
706: wip_jsi_utils.record_ignored_column_warning ('OVERCOMPLETION_TOLERANCE_VALUE');
707: end if;
708: else
709: if(wjsi_row.load_type = wip_constants.resched_job) then
710: select overcompletion_tolerance_type, overcompletion_tolerance_value, primary_item_id
711: into l_tolType, l_tolValue, l_primaryItemId
712: from wip_discrete_jobs
713: where wip_entity_id = wjsi_row.wip_entity_id;

Line 741: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then

737: wip_jsi_utils.abort_request;
738: end overcompletion;
739:
740: procedure wip_supply_type is begin
741: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
742: if(wjsi_row.wip_supply_type is null) then
743: wjsi_row.wip_supply_type := wip_constants.based_on_bom;
744: end if;
745: elsif(wjsi_row.wip_supply_type is not null) then

Line 743: wjsi_row.wip_supply_type := wip_constants.based_on_bom;

739:
740: procedure wip_supply_type is begin
741: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
742: if(wjsi_row.wip_supply_type is null) then
743: wjsi_row.wip_supply_type := wip_constants.based_on_bom;
744: end if;
745: elsif(wjsi_row.wip_supply_type is not null) then
746: wip_jsi_utils.record_ignored_column_warning ('WIP_SUPPLY_TYPE');
747: end if;

Line 768: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then

764: if(wjsi_row.class_code is not null) then
765: return;
766: end if;
767:
768: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
769: if(wjsi_row.load_type = wip_constants.create_job) then
770: l_entityType := wip_constants.discrete;
771: wjsi_row.class_code := wip_common.default_acc_class(x_org_id => wjsi_row.organization_id,
772: x_item_id => wjsi_row.primary_item_id,

Line 769: if(wjsi_row.load_type = wip_constants.create_job) then

765: return;
766: end if;
767:
768: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
769: if(wjsi_row.load_type = wip_constants.create_job) then
770: l_entityType := wip_constants.discrete;
771: wjsi_row.class_code := wip_common.default_acc_class(x_org_id => wjsi_row.organization_id,
772: x_item_id => wjsi_row.primary_item_id,
773: x_entity_type => l_entityType,

Line 770: l_entityType := wip_constants.discrete;

766: end if;
767:
768: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
769: if(wjsi_row.load_type = wip_constants.create_job) then
770: l_entityType := wip_constants.discrete;
771: wjsi_row.class_code := wip_common.default_acc_class(x_org_id => wjsi_row.organization_id,
772: x_item_id => wjsi_row.primary_item_id,
773: x_entity_type => l_entityType,
774: x_project_id => wjsi_row.project_id,

Line 780: l_entityType := wip_constants.eam;

776: x_err_mesg_2 => l_errMsg2,
777: x_err_class_1 => l_errClass1,
778: x_err_class_2 => l_errClass2);
779: else
780: l_entityType := wip_constants.eam;
781:
782: if (wjsi_row.rebuild_item_id is null) then
783: l_job_type := 1; -- maintenance WO
784: l_asset_number := wjsi_row.asset_number;

Line 814: elsif(wjsi_row.load_type in (wip_constants.resched_job,

810: fnd_message.set_name('WIP', l_errMsg2);
811: fnd_message.set_token('class_code', l_errClass2, false);
812: wip_jsi_utils.record_current_error ;
813: end if ;
814: elsif(wjsi_row.load_type in (wip_constants.resched_job,
815: wip_constants.resched_eam_job,
816: wip_constants.create_sched)) then
817: if (wjsi_row.class_code is not null) then
818: wip_jsi_utils.record_ignored_column_warning ('CLASS_CODE');

Line 815: wip_constants.resched_eam_job,

811: fnd_message.set_token('class_code', l_errClass2, false);
812: wip_jsi_utils.record_current_error ;
813: end if ;
814: elsif(wjsi_row.load_type in (wip_constants.resched_job,
815: wip_constants.resched_eam_job,
816: wip_constants.create_sched)) then
817: if (wjsi_row.class_code is not null) then
818: wip_jsi_utils.record_ignored_column_warning ('CLASS_CODE');
819: return;

Line 816: wip_constants.create_sched)) then

812: wip_jsi_utils.record_current_error ;
813: end if ;
814: elsif(wjsi_row.load_type in (wip_constants.resched_job,
815: wip_constants.resched_eam_job,
816: wip_constants.create_sched)) then
817: if (wjsi_row.class_code is not null) then
818: wip_jsi_utils.record_ignored_column_warning ('CLASS_CODE');
819: return;
820: end if;

Line 822: if (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

818: wip_jsi_utils.record_ignored_column_warning ('CLASS_CODE');
819: return;
820: end if;
821:
822: if (wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
823: wjsi_row.class_code is NULL) then
824: select class_code
825: into wjsi_row.class_code
826: from wip_discrete_jobs

Line 834: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,

830: end if;
831: end class_code;
832:
833: procedure routing_reference is begin
834: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,
835: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
836: if(wjsi_row.routing_reference_segments is not null) then
837: wip_jsi_utils.record_ignored_column_warning ('ROUTING_REFERENCE_SEGMENTS');
838: end if;

Line 835: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

831: end class_code;
832:
833: procedure routing_reference is begin
834: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,
835: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
836: if(wjsi_row.routing_reference_segments is not null) then
837: wip_jsi_utils.record_ignored_column_warning ('ROUTING_REFERENCE_SEGMENTS');
838: end if;
839: if(wjsi_row.routing_reference_id is not null) then

Line 860: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,

856: wip_jsi_utils.abort_request;
857: end routing_reference;
858:
859: procedure bom_reference is begin
860: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,
861: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
862: if(wjsi_row.bom_reference_segments is not null) then
863: wip_jsi_utils.record_ignored_column_warning ('BOM_REFERENCE_SEGMENTS');
864: end if;

Line 861: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

857: end routing_reference;
858:
859: procedure bom_reference is begin
860: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched, wip_constants.resched_job,
861: wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
862: if(wjsi_row.bom_reference_segments is not null) then
863: wip_jsi_utils.record_ignored_column_warning ('BOM_REFERENCE_SEGMENTS');
864: end if;
865: if(wjsi_row.bom_reference_id is not null) then

Line 886: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job, wip_constants.resched_eam_job) and

882: wip_jsi_utils.abort_request;
883: end bom_reference;
884:
885: procedure alternate_routing_designator is begin
886: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job, wip_constants.resched_eam_job) and
887: wjsi_row.alternate_routing_designator is not null) then
888: wip_jsi_utils.record_ignored_column_warning ('ALTERNATE_ROUTING_DESIGNATOR');
889: end if;
890: end alternate_routing_designator;

Line 893: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job, wip_constants.resched_eam_job) and

889: end if;
890: end alternate_routing_designator;
891:
892: procedure alternate_bom_designator is begin
893: if(wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job, wip_constants.resched_eam_job) and
894: wjsi_row.alternate_bom_designator is not null) then
895: wip_jsi_utils.record_ignored_column_warning ('ALTERNATE_BOM_DESIGNATOR');
896: end if;
897: end alternate_bom_designator;

Line 900: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

896: end if;
897: end alternate_bom_designator;
898:
899: procedure bom_revision is begin
900: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
901: wjsi_row.bom_revision is not null) then
902: wip_jsi_utils.record_ignored_column_warning('BOM_REVISION');
903: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
904: if(wjsi_row.bom_revision_date is not null and wjsi_row.bom_revision is not null) then

Line 903: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then

899: procedure bom_revision is begin
900: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
901: wjsi_row.bom_revision is not null) then
902: wip_jsi_utils.record_ignored_column_warning('BOM_REVISION');
903: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
904: if(wjsi_row.bom_revision_date is not null and wjsi_row.bom_revision is not null) then
905: wip_jsi_utils.record_ignored_column_warning('BOM_REVISION');
906: end if;
907: end if;

Line 911: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

907: end if;
908: end bom_revision;
909:
910: procedure bom_revision_date is begin
911: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
912: wjsi_row.bom_revision_date is not null) then
913: wip_jsi_utils.record_ignored_column_warning('BOM_REVISION_DATE');
914: end if;
915: end bom_revision_date;

Line 918: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

914: end if;
915: end bom_revision_date;
916:
917: procedure routing_revision is begin
918: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
919: wjsi_row.routing_revision is not null) then
920: wip_jsi_utils.record_ignored_column_warning('ROUTING_REVISION');
921: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
922: if(wjsi_row.routing_revision_date is not null and wjsi_row.routing_revision is not null) then

Line 921: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then

917: procedure routing_revision is begin
918: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
919: wjsi_row.routing_revision is not null) then
920: wip_jsi_utils.record_ignored_column_warning('ROUTING_REVISION');
921: elsif(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.create_eam_job)) then
922: if(wjsi_row.routing_revision_date is not null and wjsi_row.routing_revision is not null) then
923: wip_jsi_utils.record_ignored_column_warning('ROUTING_REVISION');
924: end if;
925: end if;

Line 929: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and

925: end if;
926: end routing_revision;
927:
928: procedure routing_revision_date is begin
929: if(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job) and
930: wjsi_row.routing_revision_date is not null) then
931: wip_jsi_utils.record_ignored_column_warning('ROUTING_REVISION_DATE');
932: end if;
933: end routing_revision_date;

Line 939: if(wjsi_row.load_type = wip_constants.create_sched and

935: procedure lot_number is
936: l_primary_item_id NUMBER;
937: l_wip_name VARCHAR2(240);
938: begin
939: if(wjsi_row.load_type = wip_constants.create_sched and
940: wjsi_row.lot_number is not null) then
941: wip_jsi_utils.record_ignored_column_warning('LOT_NUMBER');
942: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
943: select primary_item_id, wip_entity_name

Line 942: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then

938: begin
939: if(wjsi_row.load_type = wip_constants.create_sched and
940: wjsi_row.lot_number is not null) then
941: wip_jsi_utils.record_ignored_column_warning('LOT_NUMBER');
942: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
943: select primary_item_id, wip_entity_name
944: into l_primary_item_id, l_wip_name
945: from wip_entities
946: where wip_entity_id = wjsi_row.wip_entity_id;

Line 968: if(wjsi_row.load_type = wip_constants.create_sched and

964: wip_jsi_utils.abort_request;
965: end lot_number;
966:
967: procedure source_code is begin
968: if(wjsi_row.load_type = wip_constants.create_sched and
969: wjsi_row.source_code is not null) then
970: WIP_JSI_Utils.Record_Ignored_Column_Warning ('SOURCE_CODE');
971: end if;
972: end source_code;

Line 975: if(wjsi_row.load_type = wip_constants.create_sched and

971: end if;
972: end source_code;
973:
974: procedure source_line_id is begin
975: if(wjsi_row.load_type = wip_constants.create_sched and
976: wjsi_row.source_line_id is not null) then
977: WIP_JSI_Utils.Record_Ignored_Column_Warning ('SOURCE_LINE_ID');
978: end if;
979: end source_line_id;

Line 987: wjsi_row.load_type = wip_constants.create_sched) then

983: /* Fix for Bug#5912951-FP of 5891243. Following if condition needs to be
984: commented out as this will happen in scheduling_dates in wipjsivb.pls
985:
986: if(wjsi_row.first_unit_start_date is null and
987: wjsi_row.load_type = wip_constants.create_sched) then
988: --if no routing used work days and last unit comp date to determine fusd
989: select calendar_date
990: into wjsi_row.first_unit_start_date
991: from bom_calendar_dates bcd, mtl_parameters mp

Line 1023: wjsi_row.load_type = wip_constants.resched_job and

1019: Populate original job start date as fusd. This will ensure that completed operation
1020: dates are updated as original job start date in update_routing procedure in wipschdb.pls .
1021: */
1022: if (wjsi_row.source_code = 'MSC' and
1023: wjsi_row.load_type = wip_constants.resched_job and
1024: wjsi_row.scheduling_method = wip_constants.ml_manual) then
1025: select wdj.scheduled_start_date
1026: into wjsi_row.first_unit_start_date
1027: from wip_discrete_jobs wdj

Line 1024: wjsi_row.scheduling_method = wip_constants.ml_manual) then

1020: dates are updated as original job start date in update_routing procedure in wipschdb.pls .
1021: */
1022: if (wjsi_row.source_code = 'MSC' and
1023: wjsi_row.load_type = wip_constants.resched_job and
1024: wjsi_row.scheduling_method = wip_constants.ml_manual) then
1025: select wdj.scheduled_start_date
1026: into wjsi_row.first_unit_start_date
1027: from wip_discrete_jobs wdj
1028: where wdj.wip_entity_id = wjsi_row.wip_entity_id

Line 1054: wjsi_row.load_type = wip_constants.create_sched) then

1050: end first_unit_start_date;
1051:
1052: procedure last_unit_start_date is begin
1053: if(wjsi_row.last_unit_start_date is null and
1054: wjsi_row.load_type = wip_constants.create_sched) then
1055: --if no routing used work days and first unit comp date to determine fusd
1056: select calendar_date
1057: into wjsi_row.last_unit_start_date
1058: from bom_calendar_dates bcd, mtl_parameters mp

Line 1094: wjsi_row.load_type = wip_constants.create_sched) then

1090: end last_unit_start_date;
1091:
1092: procedure first_unit_completion_date is begin
1093: if(wjsi_row.first_unit_completion_date is null and
1094: wjsi_row.load_type = wip_constants.create_sched) then
1095: select calendar_date
1096: into wjsi_row.first_unit_completion_date
1097: from bom_calendar_dates bcd, mtl_parameters mp
1098: where mp.organization_id = wjsi_row.organization_id

Line 1132: wjsi_row.load_type = wip_constants.create_sched) then

1128: end first_unit_completion_date;
1129:
1130: procedure last_unit_completion_date is begin
1131: if(wjsi_row.last_unit_completion_date is null and
1132: wjsi_row.load_type = wip_constants.create_sched) then
1133: select calendar_date
1134: into wjsi_row.last_unit_completion_date
1135: from bom_calendar_dates bcd, mtl_parameters mp
1136: where mp.organization_id = wjsi_row.organization_id

Line 1178: if(wjsi_row.load_type = wip_constants.create_sched and

1174: last_unit_completion_date;
1175: end schedule_dates;
1176:
1177: procedure allow_explosion is begin
1178: if(wjsi_row.load_type = wip_constants.create_sched and
1179: wjsi_row.allow_explosion is not null) then
1180: wip_jsi_utils.record_ignored_column_warning('ALLOW_EXPLOSION');
1181: end if;
1182: end allow_explosion;

Line 1185: if(wjsi_row.load_type = wip_constants.create_sched and

1181: end if;
1182: end allow_explosion;
1183:
1184: procedure scheduling_method is begin
1185: if(wjsi_row.load_type = wip_constants.create_sched and
1186: wjsi_row.scheduling_method is not null) then
1187: wip_jsi_utils.record_ignored_column_warning('SCHEDULING_METHOD');
1188: elsif(wjsi_row.scheduling_method is null) then
1189: if(wjsi_row.allow_explosion is null or

Line 1191: wjsi_row.scheduling_method := wip_constants.routing;

1187: wip_jsi_utils.record_ignored_column_warning('SCHEDULING_METHOD');
1188: elsif(wjsi_row.scheduling_method is null) then
1189: if(wjsi_row.allow_explosion is null or
1190: upper(wjsi_row.allow_explosion) <> 'N') then
1191: wjsi_row.scheduling_method := wip_constants.routing;
1192: else
1193: wjsi_row.scheduling_method := wip_constants.ml_manual;
1194: end if;
1195: end if;

Line 1193: wjsi_row.scheduling_method := wip_constants.ml_manual;

1189: if(wjsi_row.allow_explosion is null or
1190: upper(wjsi_row.allow_explosion) <> 'N') then
1191: wjsi_row.scheduling_method := wip_constants.routing;
1192: else
1193: wjsi_row.scheduling_method := wip_constants.ml_manual;
1194: end if;
1195: end if;
1196: end scheduling_method;
1197:

Line 1200: if((wjsi_row.load_type = wip_constants.create_job) or

1196: end scheduling_method;
1197:
1198: procedure completion_subinventory is begin
1199: if(wjsi_row.completion_subinventory is null) then
1200: if((wjsi_row.load_type = wip_constants.create_job) or
1201: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1202: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1203: select bor.completion_subinventory
1204: into wjsi_row.completion_subinventory

Line 1201: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only

1197:
1198: procedure completion_subinventory is begin
1199: if(wjsi_row.completion_subinventory is null) then
1200: if((wjsi_row.load_type = wip_constants.create_job) or
1201: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1202: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1203: select bor.completion_subinventory
1204: into wjsi_row.completion_subinventory
1205: from bom_operational_routings bor

Line 1213: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then

1209: and nvl(bor.alternate_routing_designator,'@@@') =
1210: nvl(wjsi_row.alternate_routing_designator,'@@@');
1211: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Subinventory based on routing_reference_id
1212: for a Non-Standard Job*/
1213: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1214: select bor.completion_subinventory
1215: into wjsi_row.completion_subinventory
1216: from bom_operational_routings bor
1217: where bor.organization_id = wjsi_row.organization_id

Line 1224: elsif(wjsi_row.load_type in (wip_constants.create_sched,

1220: and nvl(bor.alternate_routing_designator,'@@@') =
1221: nvl(wjsi_row.alternate_routing_designator,'@@@');
1222:
1223: end if;
1224: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1225: wip_constants.resched_job,
1226: wip_constants.resched_eam_job)) then
1227: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1228: end if;

Line 1225: wip_constants.resched_job,

1221: nvl(wjsi_row.alternate_routing_designator,'@@@');
1222:
1223: end if;
1224: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1225: wip_constants.resched_job,
1226: wip_constants.resched_eam_job)) then
1227: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1228: end if;
1229: exception

Line 1226: wip_constants.resched_eam_job)) then

1222:
1223: end if;
1224: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1225: wip_constants.resched_job,
1226: wip_constants.resched_eam_job)) then
1227: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1228: end if;
1229: exception
1230: when no_data_found then

Line 1242: if((wjsi_row.load_type = wip_constants.create_job) or

1238: --note deriving locator id from segments is
1239: -- done in validation package as a part of the wip_locator pkg
1240: if(wjsi_row.completion_locator_id is null and
1241: wjsi_row.completion_locator_segments is null) then
1242: if((wjsi_row.load_type = wip_constants.create_job) or
1243: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1244: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1245: select bor.completion_locator_id
1246: into wjsi_row.completion_locator_id

Line 1243: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only

1239: -- done in validation package as a part of the wip_locator pkg
1240: if(wjsi_row.completion_locator_id is null and
1241: wjsi_row.completion_locator_segments is null) then
1242: if((wjsi_row.load_type = wip_constants.create_job) or
1243: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1244: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1245: select bor.completion_locator_id
1246: into wjsi_row.completion_locator_id
1247: from bom_operational_routings bor

Line 1263: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then

1259: */
1260: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1261: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Locator based on routing_reference_id
1262: for a Non-Standard Job*/
1263: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1264: select bor.completion_locator_id
1265: into wjsi_row.completion_locator_id
1266: from bom_operational_routings bor
1267: where bor.organization_id = wjsi_row.organization_id

Line 1275: if(wjsi_row.load_type in (wip_constants.create_job,

1271: nvl(wjsi_row.alternate_routing_designator,'@@@')
1272: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1273: end if;
1274: else
1275: if(wjsi_row.load_type in (wip_constants.create_job,
1276: wip_constants.create_ns_job,
1277: wip_constants.create_eam_job)) then
1278: if(wjsi_row.completion_locator_id is not null and
1279: wjsi_row.completion_locator_segments is not null) then

Line 1276: wip_constants.create_ns_job,

1272: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1273: end if;
1274: else
1275: if(wjsi_row.load_type in (wip_constants.create_job,
1276: wip_constants.create_ns_job,
1277: wip_constants.create_eam_job)) then
1278: if(wjsi_row.completion_locator_id is not null and
1279: wjsi_row.completion_locator_segments is not null) then
1280: wip_jsi_utils.record_ignored_column_warning('COMPLETION_LOCATOR_SEGMENTS');

Line 1277: wip_constants.create_eam_job)) then

1273: end if;
1274: else
1275: if(wjsi_row.load_type in (wip_constants.create_job,
1276: wip_constants.create_ns_job,
1277: wip_constants.create_eam_job)) then
1278: if(wjsi_row.completion_locator_id is not null and
1279: wjsi_row.completion_locator_segments is not null) then
1280: wip_jsi_utils.record_ignored_column_warning('COMPLETION_LOCATOR_SEGMENTS');
1281: end if;

Line 1325: if(wjsi_row.load_type = wip_constants.create_sched and

1321: wip_jsi_utils.abort_request;
1322: end created_by_name;
1323:
1324: procedure priority is begin
1325: if(wjsi_row.load_type = wip_constants.create_sched and
1326: wjsi_row.priority is not null) then
1327: wip_jsi_utils.record_ignored_column_warning('PRIORITY');
1328: end if;
1329: end priority;

Line 1337: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR

1333: --if both are still null then try to default requested_start_date
1334: procedure due_date is begin
1335: if(wjsi_row.due_date is null) then
1336: if(wjsi_row.requested_start_date is null and
1337: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1338: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1339: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1340: end if;
1341: elsif(wjsi_row.load_type = wip_constants.create_sched) then

Line 1338: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then

1334: procedure due_date is begin
1335: if(wjsi_row.due_date is null) then
1336: if(wjsi_row.requested_start_date is null and
1337: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1338: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1339: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1340: end if;
1341: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1342: wip_jsi_utils.record_ignored_column_warning('DUE_DATE');

Line 1341: elsif(wjsi_row.load_type = wip_constants.create_sched) then

1337: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1338: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1339: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1340: end if;
1341: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1342: wip_jsi_utils.record_ignored_column_warning('DUE_DATE');
1343: end if;
1344: end due_date;
1345:

Line 1347: if(wjsi_row.status_type = wip_constants.unreleased and

1343: end if;
1344: end due_date;
1345:
1346: procedure date_released is begin
1347: if(wjsi_row.status_type = wip_constants.unreleased and
1348: wjsi_row.date_released is not null) then
1349: wip_jsi_utils.record_ignored_column_warning('DATE_RELEASED');
1350: end if;
1351: end date_released;

Line 1356: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR

1352:
1353: procedure requested_start_date is begin
1354: if(wjsi_row.requested_start_date is null) then
1355: if(wjsi_row.due_date is null and
1356: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1357: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1358: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1359: end if;
1360: elsif(wjsi_row.load_type = wip_constants.create_sched) then

Line 1357: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then

1353: procedure requested_start_date is begin
1354: if(wjsi_row.requested_start_date is null) then
1355: if(wjsi_row.due_date is null and
1356: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1357: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1358: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1359: end if;
1360: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1361: wip_jsi_utils.record_ignored_column_warning('REQUESTED_START_DATE');

Line 1360: elsif(wjsi_row.load_type = wip_constants.create_sched) then

1356: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1357: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1358: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1359: end if;
1360: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1361: wip_jsi_utils.record_ignored_column_warning('REQUESTED_START_DATE');
1362: end if;
1363: end requested_start_date;
1364:

Line 1366: if(wjsi_row.load_type = wip_constants.create_sched and

1362: end if;
1363: end requested_start_date;
1364:
1365: procedure header_id is begin
1366: if(wjsi_row.load_type = wip_constants.create_sched and
1367: wjsi_row.header_id is not null) then
1368: wip_jsi_utils.record_ignored_column_warning('HEADER_ID');
1369: end if;
1370: end header_id;

Line 1373: if ((wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job,

1369: end if;
1370: end header_id;
1371:
1372: procedure end_item_unit_number is begin
1373: if ((wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job,
1374: wip_constants.resched_eam_job)) and
1375: (wjsi_row.end_item_unit_number is not null)) then
1376: wip_jsi_utils.record_ignored_column_warning('END_ITEM_UNIT_NUMBER');
1377: end if;

Line 1374: wip_constants.resched_eam_job)) and

1370: end header_id;
1371:
1372: procedure end_item_unit_number is begin
1373: if ((wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job,
1374: wip_constants.resched_eam_job)) and
1375: (wjsi_row.end_item_unit_number is not null)) then
1376: wip_jsi_utils.record_ignored_column_warning('END_ITEM_UNIT_NUMBER');
1377: end if;
1378: end end_item_unit_number;

Line 1381: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,

1377: end if;
1378: end end_item_unit_number;
1379:
1380: procedure asset_number is begin
1381: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1382: wip_constants.resched_job, wip_constants.resched_eam_job,
1383: wip_constants.create_ns_job) and
1384: wjsi_row.asset_number is not null) then
1385: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');

Line 1382: wip_constants.resched_job, wip_constants.resched_eam_job,

1378: end end_item_unit_number;
1379:
1380: procedure asset_number is begin
1381: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1382: wip_constants.resched_job, wip_constants.resched_eam_job,
1383: wip_constants.create_ns_job) and
1384: wjsi_row.asset_number is not null) then
1385: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');
1386: end if;

Line 1383: wip_constants.create_ns_job) and

1379:
1380: procedure asset_number is begin
1381: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1382: wip_constants.resched_job, wip_constants.resched_eam_job,
1383: wip_constants.create_ns_job) and
1384: wjsi_row.asset_number is not null) then
1385: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');
1386: end if;
1387: end asset_number;

Line 1391: wjsi_row.load_type <> wip_constants.create_eam_job) then

1387: end asset_number;
1388:
1389: procedure asset_group is begin
1390: if(wjsi_row.asset_group_id is not null and
1391: wjsi_row.load_type <> wip_constants.create_eam_job) then
1392: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_ID');
1393: end if;
1394:
1395: if(wjsi_row.asset_group_segments is not null and

Line 1396: wjsi_row.load_type <> wip_constants.create_eam_job) then

1392: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_ID');
1393: end if;
1394:
1395: if(wjsi_row.asset_group_segments is not null and
1396: wjsi_row.load_type <> wip_constants.create_eam_job) then
1397: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_SEGMENTS');
1398: elsif(wjsi_row.asset_group_segments is not null) then
1399: if(wjsi_row.asset_group_id is null) then
1400: select inventory_item_id

Line 1416: if(wjsi_row.load_type <> wip_constants.create_eam_job and

1412: wip_jsi_utils.abort_request;
1413: end asset_group;
1414:
1415: procedure parent_job_name is begin
1416: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1417: wjsi_row.parent_job_name is not null) then
1418: wip_jsi_utils.record_ignored_column_warning('PARENT_JOB_NAME');
1419: elsif(wjsi_row.parent_job_name is not null) then
1420: if(wjsi_row.parent_wip_entity_id is null) then

Line 1437: if(wjsi_row.load_type <> wip_constants.create_eam_job and

1433: wip_jsi_utils.abort_request;
1434: end parent_job_name;
1435:
1436: procedure parent_wip_entity_id is begin
1437: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1438: wjsi_row.parent_wip_entity_id is not null) then
1439: wip_jsi_utils.record_ignored_column_warning('PARENT_WIP_ENTITY_ID');
1440: end if;
1441: end parent_wip_entity_id;

Line 1444: if(wjsi_row.load_type <> wip_constants.create_eam_job) then

1440: end if;
1441: end parent_wip_entity_id;
1442:
1443: procedure rebuild_item is begin
1444: if(wjsi_row.load_type <> wip_constants.create_eam_job) then
1445: if(wjsi_row.rebuild_item_segments is not null) then
1446: wip_jsi_utils.record_ignored_column_warning('REBUILD_ITEM_SEGMENTS');
1447: end if;
1448: if(wjsi_row.rebuild_item_id is not null) then

Line 1470: if(wjsi_row.load_type <> wip_constants.create_eam_job and

1466: wip_jsi_utils.abort_request;
1467: end rebuild_item;
1468:
1469: procedure rebuild_serial_number is begin
1470: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1471: wjsi_row.rebuild_serial_number is not null) then
1472: wip_jsi_utils.record_ignored_column_warning('REBUILD_SERIAL_NUMBER');
1473: end if;
1474: end rebuild_serial_number;

Line 1477: if(wjsi_row.load_type <> wip_constants.create_eam_job and

1473: end if;
1474: end rebuild_serial_number;
1475:
1476: procedure manual_rebuild_flag is begin
1477: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1478: wjsi_row.manual_rebuild_flag is not null) then
1479: wip_jsi_utils.record_ignored_column_warning('MANUAL_REBUILD_FLAG');
1480: end if;
1481: end manual_rebuild_flag;

Line 1488: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

1484: l_returnMsg VARCHAR2(200);
1485: l_msgCount NUMBER;
1486: l_errMsg VARCHAR2(30);
1487: begin
1488: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
1489: if(wjsi_row.owning_department_code is not null) then
1490: wip_jsi_utils.record_ignored_column_warning('OWNING_DEPARTMENT_CODE');
1491: end if;
1492: if(wjsi_row.owning_department is not null) then

Line 1536: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1532: l_returnMsg VARCHAR2(200);
1533: l_msgCount NUMBER;
1534: l_errMsg VARCHAR2(30);
1535: begin
1536: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1537: wjsi_row.notification_required is not null) then
1538: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1539: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1540: wjsi_row.notification_required is null) then

Line 1539: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1535: begin
1536: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1537: wjsi_row.notification_required is not null) then
1538: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1539: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1540: wjsi_row.notification_required is null) then
1541: wip_eamworkorder_pvt.get_eam_notification_default(p_api_version => 1.0,
1542: p_init_msg_list => null,
1543: p_commit => null,

Line 1572: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1568: l_returnMsg VARCHAR2(200);
1569: l_msgCount NUMBER;
1570: l_errMsg VARCHAR2(30);
1571: begin
1572: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1573: wjsi_row.shutdown_type is not null) then
1574: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1575: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1576: wjsi_row.shutdown_type is null) then

Line 1575: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1571: begin
1572: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1573: wjsi_row.shutdown_type is not null) then
1574: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1575: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1576: wjsi_row.shutdown_type is null) then
1577: wip_eamworkorder_pvt.get_eam_shutdown_default(p_api_version => 1.0,
1578: p_init_msg_list => null,
1579: p_commit => null,

Line 1604: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1600: wip_jsi_utils.abort_request;
1601: end shutdown_type;
1602:
1603: procedure work_order_type is begin
1604: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1605: wjsi_row.work_order_type is not null) then
1606: wip_jsi_utils.record_ignored_column_warning('WORK_ORDER_TYPE');
1607: end if;
1608: end work_order_type;

Line 1615: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1611: l_returnMsg VARCHAR2(200);
1612: l_msgCount NUMBER;
1613: l_errMsg VARCHAR2(30);
1614: begin
1615: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1616: wjsi_row.tagout_required is not null) then
1617: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1618: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1619: wjsi_row.tagout_required is null) then

Line 1618: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1614: begin
1615: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1616: wjsi_row.tagout_required is not null) then
1617: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1618: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1619: wjsi_row.tagout_required is null) then
1620: wip_eamworkorder_pvt.get_eam_tagout_default(p_api_version => 1.0,
1621: p_init_msg_list => null,
1622: p_commit => null,

Line 1647: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1643: wip_jsi_utils.abort_request;
1644: end tagout_required;
1645:
1646: procedure plan_maintenance is begin
1647: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1648: wjsi_row.plan_maintenance is not null) then
1649: wip_jsi_utils.record_ignored_column_warning('PLAN_MAINTENANCE');
1650: elsif(wjsi_row.pm_schedule_id is not null) then
1651: wjsi_row.plan_maintenance := 'Y';

Line 1660: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1656: l_returnMsg VARCHAR2(200);
1657: l_msgCount NUMBER;
1658: l_errMsg VARCHAR2(30);
1659: begin
1660: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1661: wjsi_row.activity_type is not null) then
1662: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1663: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1664: wjsi_row.activity_type is null) then

Line 1663: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1659: begin
1660: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1661: wjsi_row.activity_type is not null) then
1662: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1663: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1664: wjsi_row.activity_type is null) then
1665: wip_eamworkorder_pvt.get_eam_act_type_default(p_api_version => 1.0,
1666: p_init_msg_list => null,
1667: p_commit => null,

Line 1696: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1692: l_returnMsg VARCHAR2(200);
1693: l_msgCount NUMBER;
1694: l_errMsg VARCHAR2(30);
1695: begin
1696: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1697: wjsi_row.activity_cause is not null) then
1698: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1699: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1700: wjsi_row.activity_cause is null) then

Line 1699: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1695: begin
1696: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1697: wjsi_row.activity_cause is not null) then
1698: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1699: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1700: wjsi_row.activity_cause is null) then
1701: wip_eamworkorder_pvt.get_eam_act_cause_default(p_api_version => 1.0,
1702: p_init_msg_list => null,
1703: p_commit => null,

Line 1729: if(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.resched_job) and

1725: end activity_cause;
1726:
1727: procedure serialization_start_op is
1728: begin
1729: if(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.resched_job) and
1730: wjsi_row.serialization_start_op is not null) then
1731: wip_jsi_utils.record_ignored_column_warning('SERIALIZATION_START_OP');
1732: end if;
1733: end serialization_start_op;

Line 1738: if (wjsi_row.load_type <> wip_constants.create_eam_job and

1734:
1735: procedure material_issue_by_mo is
1736: l_wms_enabled_flag VARCHAR(1);
1737: begin
1738: if (wjsi_row.load_type <> wip_constants.create_eam_job and
1739: (wjsi_row.load_type <> wip_constants.resched_eam_job or wjsi_row.status_type <> wip_constants.draft)
1740: and wjsi_row.material_issue_by_mo is not null) then
1741:
1742: wip_jsi_utils.record_ignored_column_warning('MATERIAL_ISSUE_BY_MO');

Line 1739: (wjsi_row.load_type <> wip_constants.resched_eam_job or wjsi_row.status_type <> wip_constants.draft)

1735: procedure material_issue_by_mo is
1736: l_wms_enabled_flag VARCHAR(1);
1737: begin
1738: if (wjsi_row.load_type <> wip_constants.create_eam_job and
1739: (wjsi_row.load_type <> wip_constants.resched_eam_job or wjsi_row.status_type <> wip_constants.draft)
1740: and wjsi_row.material_issue_by_mo is not null) then
1741:
1742: wip_jsi_utils.record_ignored_column_warning('MATERIAL_ISSUE_BY_MO');
1743:

Line 1750: elsif (wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then

1746: from wip_discrete_jobs
1747: where wip_entity_id = wjsi_row.wip_entity_id
1748: and organization_id = wjsi_row.organization_id;
1749:
1750: elsif (wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
1751: select wms_enabled_flag
1752: into l_wms_enabled_flag
1753: from mtl_parameters
1754: where organization_id = wjsi_row.organization_id;

Line 1771: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1767:
1768: procedure maintenance_object_type is
1769: l_serial_number_control_code NUMBER;
1770: begin
1771: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1772: wjsi_row.maintenance_object_type is not null) then
1773: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_TYPE');
1774: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1775: wjsi_row.maintenance_object_type is null) then

Line 1774: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1770: begin
1771: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1772: wjsi_row.maintenance_object_type is not null) then
1773: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_TYPE');
1774: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1775: wjsi_row.maintenance_object_type is null) then
1776: if(wjsi_row.rebuild_item_id is null) then
1777: wjsi_row.maintenance_object_type := 1; --MSN
1778: else

Line 1805: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1801: end maintenance_object_type;
1802:
1803: procedure maintenance_object_id is
1804: begin
1805: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1806: wjsi_row.maintenance_object_id is not null) then
1807: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_ID');
1808: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1809: wjsi_row.maintenance_object_id is null) then

Line 1808: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1804: begin
1805: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1806: wjsi_row.maintenance_object_id is not null) then
1807: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_ID');
1808: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1809: wjsi_row.maintenance_object_id is null) then
1810: if(wjsi_row.maintenance_object_type = 1) then
1811: if(wjsi_row.rebuild_item_id is null) then
1812: select gen_object_id

Line 1841: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1837: wip_jsi_utils.abort_request;
1838: end maintenance_object_id;
1839:
1840: procedure maintenance_object_source is begin
1841: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1842: wjsi_row.maintenance_object_source is not null) then
1843: wip_jsi_utils.record_ignored_column_warning('MAITENANCE_OBJECT_SOURCE');
1844: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1845: wjsi_row.maintenance_object_source is null) then

Line 1844: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1840: procedure maintenance_object_source is begin
1841: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1842: wjsi_row.maintenance_object_source is not null) then
1843: wip_jsi_utils.record_ignored_column_warning('MAITENANCE_OBJECT_SOURCE');
1844: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1845: wjsi_row.maintenance_object_source is null) then
1846: wjsi_row.maintenance_object_source := 1; --EAM
1847: end if;
1848:

Line 1860: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1856: l_returnMsg VARCHAR2(200);
1857: l_msgCount NUMBER;
1858: l_errMsg VARCHAR2(30);
1859: begin
1860: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1861: wjsi_row.activity_source is not null) then
1862: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1863: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1864: wjsi_row.activity_source is null) then

Line 1863: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1859: begin
1860: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1861: wjsi_row.activity_source is not null) then
1862: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1863: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1864: wjsi_row.activity_source is null) then
1865: wip_eamworkorder_pvt.get_eam_act_source_default(p_api_version => 1.0,
1866: p_init_msg_list => null,
1867: p_commit => null,

Line 1892: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and

1888: wip_jsi_utils.abort_request;
1889: end activity_source;
1890:
1891: procedure pm_schedule_id is begin
1892: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1893: wjsi_row.pm_schedule_id is not null) then
1894: wip_jsi_utils.record_ignored_column_warning('PM_SCHEDULE_ID');
1895: end if;
1896: end pm_schedule_id;