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(sysdate), 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(sysdate), 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(sysdate), 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 1212: elsif(wjsi_row.load_type in (wip_constants.create_sched,

1208: and bor.assembly_item_id = wjsi_row.primary_item_id
1209: and nvl(bor.alternate_routing_designator,'@@@') =
1210: nvl(wjsi_row.alternate_routing_designator,'@@@');
1211: end if;
1212: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1213: wip_constants.resched_job,
1214: wip_constants.resched_eam_job)) then
1215: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1216: end if;

Line 1213: wip_constants.resched_job,

1209: and nvl(bor.alternate_routing_designator,'@@@') =
1210: nvl(wjsi_row.alternate_routing_designator,'@@@');
1211: end if;
1212: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1213: wip_constants.resched_job,
1214: wip_constants.resched_eam_job)) then
1215: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1216: end if;
1217: exception

Line 1214: wip_constants.resched_eam_job)) then

1210: nvl(wjsi_row.alternate_routing_designator,'@@@');
1211: end if;
1212: elsif(wjsi_row.load_type in (wip_constants.create_sched,
1213: wip_constants.resched_job,
1214: wip_constants.resched_eam_job)) then
1215: wip_jsi_utils.record_ignored_column_warning('COMPLETION_SUBINVENTORY');
1216: end if;
1217: exception
1218: when no_data_found then

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

1226: --note deriving locator id from segments is
1227: -- done in validation package as a part of the wip_locator pkg
1228: if(wjsi_row.completion_locator_id is null and
1229: wjsi_row.completion_locator_segments is null) then
1230: if((wjsi_row.load_type = wip_constants.create_job) or
1231: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1232: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1233: select bor.completion_locator_id
1234: into wjsi_row.completion_locator_id

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

1227: -- done in validation package as a part of the wip_locator pkg
1228: if(wjsi_row.completion_locator_id is null and
1229: wjsi_row.completion_locator_segments is null) then
1230: if((wjsi_row.load_type = wip_constants.create_job) or
1231: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1232: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1233: select bor.completion_locator_id
1234: into wjsi_row.completion_locator_id
1235: from bom_operational_routings bor

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

1247: */
1248: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1249: end if;
1250: else
1251: if(wjsi_row.load_type in (wip_constants.create_job,
1252: wip_constants.create_ns_job,
1253: wip_constants.create_eam_job)) then
1254: if(wjsi_row.completion_locator_id is not null and
1255: wjsi_row.completion_locator_segments is not null) then

Line 1252: wip_constants.create_ns_job,

1248: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1249: end if;
1250: else
1251: if(wjsi_row.load_type in (wip_constants.create_job,
1252: wip_constants.create_ns_job,
1253: wip_constants.create_eam_job)) then
1254: if(wjsi_row.completion_locator_id is not null and
1255: wjsi_row.completion_locator_segments is not null) then
1256: wip_jsi_utils.record_ignored_column_warning('COMPLETION_LOCATOR_SEGMENTS');

Line 1253: wip_constants.create_eam_job)) then

1249: end if;
1250: else
1251: if(wjsi_row.load_type in (wip_constants.create_job,
1252: wip_constants.create_ns_job,
1253: wip_constants.create_eam_job)) then
1254: if(wjsi_row.completion_locator_id is not null and
1255: wjsi_row.completion_locator_segments is not null) then
1256: wip_jsi_utils.record_ignored_column_warning('COMPLETION_LOCATOR_SEGMENTS');
1257: end if;

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

1297: wip_jsi_utils.abort_request;
1298: end created_by_name;
1299:
1300: procedure priority is begin
1301: if(wjsi_row.load_type = wip_constants.create_sched and
1302: wjsi_row.priority is not null) then
1303: wip_jsi_utils.record_ignored_column_warning('PRIORITY');
1304: end if;
1305: end priority;

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

1309: --if both are still null then try to default requested_start_date
1310: procedure due_date is begin
1311: if(wjsi_row.due_date is null) then
1312: if(wjsi_row.requested_start_date is null and
1313: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1314: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1315: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1316: end if;
1317: elsif(wjsi_row.load_type = wip_constants.create_sched) then

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

1310: procedure due_date is begin
1311: if(wjsi_row.due_date is null) then
1312: if(wjsi_row.requested_start_date is null and
1313: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1314: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1315: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1316: end if;
1317: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1318: wip_jsi_utils.record_ignored_column_warning('DUE_DATE');

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

1313: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1314: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1315: wjsi_row.due_date := wjsi_row.last_unit_completion_date;
1316: end if;
1317: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1318: wip_jsi_utils.record_ignored_column_warning('DUE_DATE');
1319: end if;
1320: end due_date;
1321:

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

1319: end if;
1320: end due_date;
1321:
1322: procedure date_released is begin
1323: if(wjsi_row.status_type = wip_constants.unreleased and
1324: wjsi_row.date_released is not null) then
1325: wip_jsi_utils.record_ignored_column_warning('DATE_RELEASED');
1326: end if;
1327: end date_released;

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

1328:
1329: procedure requested_start_date is begin
1330: if(wjsi_row.requested_start_date is null) then
1331: if(wjsi_row.due_date is null and
1332: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1333: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1334: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1335: end if;
1336: elsif(wjsi_row.load_type = wip_constants.create_sched) then

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

1329: procedure requested_start_date is begin
1330: if(wjsi_row.requested_start_date is null) then
1331: if(wjsi_row.due_date is null and
1332: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1333: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1334: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1335: end if;
1336: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1337: wip_jsi_utils.record_ignored_column_warning('REQUESTED_START_DATE');

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

1332: (wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job) OR
1333: (wjsi_row.load_type = wip_constants.create_eam_job and wjsi_row.pm_schedule_id is not null))) then
1334: wjsi_row.requested_start_date := wjsi_row.first_unit_start_date;
1335: end if;
1336: elsif(wjsi_row.load_type = wip_constants.create_sched) then
1337: wip_jsi_utils.record_ignored_column_warning('REQUESTED_START_DATE');
1338: end if;
1339: end requested_start_date;
1340:

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

1338: end if;
1339: end requested_start_date;
1340:
1341: procedure header_id is begin
1342: if(wjsi_row.load_type = wip_constants.create_sched and
1343: wjsi_row.header_id is not null) then
1344: wip_jsi_utils.record_ignored_column_warning('HEADER_ID');
1345: end if;
1346: end header_id;

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

1345: end if;
1346: end header_id;
1347:
1348: procedure end_item_unit_number is begin
1349: if ((wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job,
1350: wip_constants.resched_eam_job)) and
1351: (wjsi_row.end_item_unit_number is not null)) then
1352: wip_jsi_utils.record_ignored_column_warning('END_ITEM_UNIT_NUMBER');
1353: end if;

Line 1350: wip_constants.resched_eam_job)) and

1346: end header_id;
1347:
1348: procedure end_item_unit_number is begin
1349: if ((wjsi_row.load_type in (wip_constants.create_sched, wip_constants.resched_job,
1350: wip_constants.resched_eam_job)) and
1351: (wjsi_row.end_item_unit_number is not null)) then
1352: wip_jsi_utils.record_ignored_column_warning('END_ITEM_UNIT_NUMBER');
1353: end if;
1354: end end_item_unit_number;

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

1353: end if;
1354: end end_item_unit_number;
1355:
1356: procedure asset_number is begin
1357: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1358: wip_constants.resched_job, wip_constants.resched_eam_job,
1359: wip_constants.create_ns_job) and
1360: wjsi_row.asset_number is not null) then
1361: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');

Line 1358: wip_constants.resched_job, wip_constants.resched_eam_job,

1354: end end_item_unit_number;
1355:
1356: procedure asset_number is begin
1357: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1358: wip_constants.resched_job, wip_constants.resched_eam_job,
1359: wip_constants.create_ns_job) and
1360: wjsi_row.asset_number is not null) then
1361: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');
1362: end if;

Line 1359: wip_constants.create_ns_job) and

1355:
1356: procedure asset_number is begin
1357: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1358: wip_constants.resched_job, wip_constants.resched_eam_job,
1359: wip_constants.create_ns_job) and
1360: wjsi_row.asset_number is not null) then
1361: wip_jsi_utils.record_ignored_column_warning('ASSET_NUMBER');
1362: end if;
1363: end asset_number;

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

1363: end asset_number;
1364:
1365: procedure asset_group is begin
1366: if(wjsi_row.asset_group_id is not null and
1367: wjsi_row.load_type <> wip_constants.create_eam_job) then
1368: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_ID');
1369: end if;
1370:
1371: if(wjsi_row.asset_group_segments is not null and

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

1368: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_ID');
1369: end if;
1370:
1371: if(wjsi_row.asset_group_segments is not null and
1372: wjsi_row.load_type <> wip_constants.create_eam_job) then
1373: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_SEGMENTS');
1374: elsif(wjsi_row.asset_group_segments is not null) then
1375: if(wjsi_row.asset_group_id is null) then
1376: select inventory_item_id

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

1388: wip_jsi_utils.abort_request;
1389: end asset_group;
1390:
1391: procedure parent_job_name is begin
1392: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1393: wjsi_row.parent_job_name is not null) then
1394: wip_jsi_utils.record_ignored_column_warning('PARENT_JOB_NAME');
1395: elsif(wjsi_row.parent_job_name is not null) then
1396: if(wjsi_row.parent_wip_entity_id is null) then

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

1409: wip_jsi_utils.abort_request;
1410: end parent_job_name;
1411:
1412: procedure parent_wip_entity_id is begin
1413: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1414: wjsi_row.parent_wip_entity_id is not null) then
1415: wip_jsi_utils.record_ignored_column_warning('PARENT_WIP_ENTITY_ID');
1416: end if;
1417: end parent_wip_entity_id;

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

1416: end if;
1417: end parent_wip_entity_id;
1418:
1419: procedure rebuild_item is begin
1420: if(wjsi_row.load_type <> wip_constants.create_eam_job) then
1421: if(wjsi_row.rebuild_item_segments is not null) then
1422: wip_jsi_utils.record_ignored_column_warning('REBUILD_ITEM_SEGMENTS');
1423: end if;
1424: if(wjsi_row.rebuild_item_id is not null) then

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

1442: wip_jsi_utils.abort_request;
1443: end rebuild_item;
1444:
1445: procedure rebuild_serial_number is begin
1446: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1447: wjsi_row.rebuild_serial_number is not null) then
1448: wip_jsi_utils.record_ignored_column_warning('REBUILD_SERIAL_NUMBER');
1449: end if;
1450: end rebuild_serial_number;

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

1449: end if;
1450: end rebuild_serial_number;
1451:
1452: procedure manual_rebuild_flag is begin
1453: if(wjsi_row.load_type <> wip_constants.create_eam_job and
1454: wjsi_row.manual_rebuild_flag is not null) then
1455: wip_jsi_utils.record_ignored_column_warning('MANUAL_REBUILD_FLAG');
1456: end if;
1457: end manual_rebuild_flag;

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

1460: l_returnMsg VARCHAR2(200);
1461: l_msgCount NUMBER;
1462: l_errMsg VARCHAR2(30);
1463: begin
1464: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
1465: if(wjsi_row.owning_department_code is not null) then
1466: wip_jsi_utils.record_ignored_column_warning('OWNING_DEPARTMENT_CODE');
1467: end if;
1468: if(wjsi_row.owning_department is not null) then

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

1508: l_returnMsg VARCHAR2(200);
1509: l_msgCount NUMBER;
1510: l_errMsg VARCHAR2(30);
1511: begin
1512: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1513: wjsi_row.notification_required is not null) then
1514: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1515: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1516: wjsi_row.notification_required is null) then

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

1511: begin
1512: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1513: wjsi_row.notification_required is not null) then
1514: wip_jsi_utils.record_ignored_column_warning('NOTIFICATION_REQUIRED');
1515: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1516: wjsi_row.notification_required is null) then
1517: wip_eamworkorder_pvt.get_eam_notification_default(p_api_version => 1.0,
1518: p_init_msg_list => null,
1519: p_commit => null,

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

1544: l_returnMsg VARCHAR2(200);
1545: l_msgCount NUMBER;
1546: l_errMsg VARCHAR2(30);
1547: begin
1548: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1549: wjsi_row.shutdown_type is not null) then
1550: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1551: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1552: wjsi_row.shutdown_type is null) then

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

1547: begin
1548: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1549: wjsi_row.shutdown_type is not null) then
1550: wip_jsi_utils.record_ignored_column_warning('SHUTDOWN_TYPE');
1551: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1552: wjsi_row.shutdown_type is null) then
1553: wip_eamworkorder_pvt.get_eam_shutdown_default(p_api_version => 1.0,
1554: p_init_msg_list => null,
1555: p_commit => null,

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

1576: wip_jsi_utils.abort_request;
1577: end shutdown_type;
1578:
1579: procedure work_order_type is begin
1580: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1581: wjsi_row.work_order_type is not null) then
1582: wip_jsi_utils.record_ignored_column_warning('WORK_ORDER_TYPE');
1583: end if;
1584: end work_order_type;

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

1587: l_returnMsg VARCHAR2(200);
1588: l_msgCount NUMBER;
1589: l_errMsg VARCHAR2(30);
1590: begin
1591: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1592: wjsi_row.tagout_required is not null) then
1593: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1594: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1595: wjsi_row.tagout_required is null) then

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

1590: begin
1591: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1592: wjsi_row.tagout_required is not null) then
1593: wip_jsi_utils.record_ignored_column_warning('TAGOUT_REQUIRED');
1594: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1595: wjsi_row.tagout_required is null) then
1596: wip_eamworkorder_pvt.get_eam_tagout_default(p_api_version => 1.0,
1597: p_init_msg_list => null,
1598: p_commit => null,

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

1619: wip_jsi_utils.abort_request;
1620: end tagout_required;
1621:
1622: procedure plan_maintenance is begin
1623: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1624: wjsi_row.plan_maintenance is not null) then
1625: wip_jsi_utils.record_ignored_column_warning('PLAN_MAINTENANCE');
1626: elsif(wjsi_row.pm_schedule_id is not null) then
1627: wjsi_row.plan_maintenance := 'Y';

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

1632: l_returnMsg VARCHAR2(200);
1633: l_msgCount NUMBER;
1634: l_errMsg VARCHAR2(30);
1635: begin
1636: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1637: wjsi_row.activity_type is not null) then
1638: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1639: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1640: wjsi_row.activity_type is null) then

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

1635: begin
1636: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1637: wjsi_row.activity_type is not null) then
1638: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_TYPE');
1639: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1640: wjsi_row.activity_type is null) then
1641: wip_eamworkorder_pvt.get_eam_act_type_default(p_api_version => 1.0,
1642: p_init_msg_list => null,
1643: p_commit => null,

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

1668: l_returnMsg VARCHAR2(200);
1669: l_msgCount NUMBER;
1670: l_errMsg VARCHAR2(30);
1671: begin
1672: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1673: wjsi_row.activity_cause is not null) then
1674: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1675: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1676: wjsi_row.activity_cause is null) then

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

1671: begin
1672: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1673: wjsi_row.activity_cause is not null) then
1674: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_CAUSE');
1675: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1676: wjsi_row.activity_cause is null) then
1677: wip_eamworkorder_pvt.get_eam_act_cause_default(p_api_version => 1.0,
1678: p_init_msg_list => null,
1679: p_commit => null,

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

1701: end activity_cause;
1702:
1703: procedure serialization_start_op is
1704: begin
1705: if(wjsi_row.load_type not in (wip_constants.create_job, wip_constants.create_ns_job, wip_constants.resched_job) and
1706: wjsi_row.serialization_start_op is not null) then
1707: wip_jsi_utils.record_ignored_column_warning('SERIALIZATION_START_OP');
1708: end if;
1709: end serialization_start_op;

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

1710:
1711: procedure material_issue_by_mo is
1712: l_wms_enabled_flag VARCHAR(1);
1713: begin
1714: if (wjsi_row.load_type <> wip_constants.create_eam_job and
1715: (wjsi_row.load_type <> wip_constants.resched_eam_job or wjsi_row.status_type <> wip_constants.draft)
1716: and wjsi_row.material_issue_by_mo is not null) then
1717:
1718: wip_jsi_utils.record_ignored_column_warning('MATERIAL_ISSUE_BY_MO');

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

1711: procedure material_issue_by_mo is
1712: l_wms_enabled_flag VARCHAR(1);
1713: begin
1714: if (wjsi_row.load_type <> wip_constants.create_eam_job and
1715: (wjsi_row.load_type <> wip_constants.resched_eam_job or wjsi_row.status_type <> wip_constants.draft)
1716: and wjsi_row.material_issue_by_mo is not null) then
1717:
1718: wip_jsi_utils.record_ignored_column_warning('MATERIAL_ISSUE_BY_MO');
1719:

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

1722: from wip_discrete_jobs
1723: where wip_entity_id = wjsi_row.wip_entity_id
1724: and organization_id = wjsi_row.organization_id;
1725:
1726: elsif (wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job)) then
1727: select wms_enabled_flag
1728: into l_wms_enabled_flag
1729: from mtl_parameters
1730: where organization_id = wjsi_row.organization_id;

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

1743:
1744: procedure maintenance_object_type is
1745: l_serial_number_control_code NUMBER;
1746: begin
1747: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1748: wjsi_row.maintenance_object_type is not null) then
1749: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_TYPE');
1750: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1751: wjsi_row.maintenance_object_type is null) then

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

1746: begin
1747: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1748: wjsi_row.maintenance_object_type is not null) then
1749: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_TYPE');
1750: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1751: wjsi_row.maintenance_object_type is null) then
1752: if(wjsi_row.rebuild_item_id is null) then
1753: wjsi_row.maintenance_object_type := 1; --MSN
1754: else

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

1777: end maintenance_object_type;
1778:
1779: procedure maintenance_object_id is
1780: begin
1781: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1782: wjsi_row.maintenance_object_id is not null) then
1783: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_ID');
1784: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1785: wjsi_row.maintenance_object_id is null) then

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

1780: begin
1781: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1782: wjsi_row.maintenance_object_id is not null) then
1783: wip_jsi_utils.record_ignored_column_warning('MAINTENANCE_OBJECT_ID');
1784: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1785: wjsi_row.maintenance_object_id is null) then
1786: if(wjsi_row.maintenance_object_type = 1) then
1787: if(wjsi_row.rebuild_item_id is null) then
1788: select gen_object_id

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

1813: wip_jsi_utils.abort_request;
1814: end maintenance_object_id;
1815:
1816: procedure maintenance_object_source is begin
1817: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1818: wjsi_row.maintenance_object_source is not null) then
1819: wip_jsi_utils.record_ignored_column_warning('MAITENANCE_OBJECT_SOURCE');
1820: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1821: wjsi_row.maintenance_object_source is null) then

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

1816: procedure maintenance_object_source is begin
1817: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1818: wjsi_row.maintenance_object_source is not null) then
1819: wip_jsi_utils.record_ignored_column_warning('MAITENANCE_OBJECT_SOURCE');
1820: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1821: wjsi_row.maintenance_object_source is null) then
1822: wjsi_row.maintenance_object_source := 1; --EAM
1823: end if;
1824:

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

1832: l_returnMsg VARCHAR2(200);
1833: l_msgCount NUMBER;
1834: l_errMsg VARCHAR2(30);
1835: begin
1836: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1837: wjsi_row.activity_source is not null) then
1838: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1839: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1840: wjsi_row.activity_source is null) then

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

1835: begin
1836: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1837: wjsi_row.activity_source is not null) then
1838: wip_jsi_utils.record_ignored_column_warning('ACTIVITY_SOURCE');
1839: elsif(wjsi_row.load_type in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1840: wjsi_row.activity_source is null) then
1841: wip_eamworkorder_pvt.get_eam_act_source_default(p_api_version => 1.0,
1842: p_init_msg_list => null,
1843: p_commit => null,

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

1864: wip_jsi_utils.abort_request;
1865: end activity_source;
1866:
1867: procedure pm_schedule_id is begin
1868: if(wjsi_row.load_type not in (wip_constants.create_eam_job, wip_constants.resched_eam_job) and
1869: wjsi_row.pm_schedule_id is not null) then
1870: wip_jsi_utils.record_ignored_column_warning('PM_SCHEDULE_ID');
1871: end if;
1872: end pm_schedule_id;