[Home] [Help]
58: begin
59:
60: val_null_values(p_group_id => p_group_id,
61: p_parent_header_id => p_parent_header_id, /* Fix for Bug#3636378 */
62: p_sub_type => wip_job_details.wip_add);
63:
64: val_dept(p_group_id => p_group_id,
65: p_wip_entity_id => p_wip_entity_id,
66: p_organization_id => p_organization_id,
63:
64: val_dept(p_group_id => p_group_id,
65: p_wip_entity_id => p_wip_entity_id,
66: p_organization_id => p_organization_id,
67: p_sub_type => wip_job_details.wip_add);
68:
69: val_std_op(p_group_id => p_group_id,
70: p_wip_entity_id => p_wip_entity_id,
71: p_organization_id => p_organization_id,
68:
69: val_std_op(p_group_id => p_group_id,
70: p_wip_entity_id => p_wip_entity_id,
71: p_organization_id => p_organization_id,
72: p_sub_type => wip_job_details.wip_add);
73:
74: val_mtq(p_group_id => p_group_id,
75: p_wip_entity_id => p_wip_entity_id,
76: p_organization_id => p_organization_id,
73:
74: val_mtq(p_group_id => p_group_id,
75: p_wip_entity_id => p_wip_entity_id,
76: p_organization_id => p_organization_id,
77: p_sub_type => wip_job_details.wip_add);
78:
79: val_cnt_pnt(p_group_id => p_group_id,
80: p_wip_entity_id => p_wip_entity_id,
81: p_organization_id => p_organization_id,
78:
79: val_cnt_pnt(p_group_id => p_group_id,
80: p_wip_entity_id => p_wip_entity_id,
81: p_organization_id => p_organization_id,
82: p_sub_type => wip_job_details.wip_add);
83:
84: val_bfl_flag(p_group_id => p_group_id,
85: p_wip_entity_id => p_wip_entity_id,
86: p_organization_id => p_organization_id,
83:
84: val_bfl_flag(p_group_id => p_group_id,
85: p_wip_entity_id => p_wip_entity_id,
86: p_organization_id => p_organization_id,
87: p_sub_type => wip_job_details.wip_add);
88:
89: val_add_op_seq_num(p_group_id => p_group_id,
90: p_wip_entity_id => p_wip_entity_id,
91: p_organization_id => p_organization_id);
116: BEGIN
117:
118: val_null_values(p_group_id => p_group_id,
119: p_parent_header_id => p_parent_header_id, /* Fix for Bug#3636378 */
120: p_sub_type => wip_job_details.wip_change);
121:
122: val_dept(p_group_id => p_group_id,
123: p_wip_entity_id => p_wip_entity_id,
124: p_organization_id => p_organization_id,
121:
122: val_dept(p_group_id => p_group_id,
123: p_wip_entity_id => p_wip_entity_id,
124: p_organization_id => p_organization_id,
125: p_sub_type => wip_job_details.wip_change);
126:
127: /* Fix for Bug#3546027 */
128: val_dept_resources(p_group_id => p_group_id,
129: p_wip_entity_id => p_wip_entity_id,
127: /* Fix for Bug#3546027 */
128: val_dept_resources(p_group_id => p_group_id,
129: p_wip_entity_id => p_wip_entity_id,
130: p_organization_id => p_organization_id,
131: p_sub_type => wip_job_details.wip_change);
132:
133: val_std_op(p_group_id => p_group_id,
134: p_wip_entity_id => p_wip_entity_id,
135: p_organization_id => p_organization_id,
132:
133: val_std_op(p_group_id => p_group_id,
134: p_wip_entity_id => p_wip_entity_id,
135: p_organization_id => p_organization_id,
136: p_sub_type => wip_job_details.wip_change);
137:
138: val_mtq(p_group_id => p_group_id,
139: p_wip_entity_id => p_wip_entity_id,
140: p_organization_id => p_organization_id,
137:
138: val_mtq(p_group_id => p_group_id,
139: p_wip_entity_id => p_wip_entity_id,
140: p_organization_id => p_organization_id,
141: p_sub_type => wip_job_details.wip_change);
142:
143: val_cnt_pnt(p_group_id => p_group_id,
144: p_wip_entity_id => p_wip_entity_id,
145: p_organization_id => p_organization_id,
142:
143: val_cnt_pnt(p_group_id => p_group_id,
144: p_wip_entity_id => p_wip_entity_id,
145: p_organization_id => p_organization_id,
146: p_sub_type => wip_job_details.wip_change);
147:
148: val_bfl_flag(p_group_id => p_group_id,
149: p_wip_entity_id => p_wip_entity_id,
150: p_organization_id => p_organization_id,
147:
148: val_bfl_flag(p_group_id => p_group_id,
149: p_wip_entity_id => p_wip_entity_id,
150: p_organization_id => p_organization_id,
151: p_sub_type => wip_job_details.wip_change);
152:
153: val_change_op_seq_num(p_group_id => p_group_id,
154: p_wip_entity_id => p_wip_entity_id,
155: p_organization_id => p_organization_id);
179: and parent_header_id = p_parent_header_id /* Fix for Bug#3636378 */
180: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
181: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */
182: and substitution_type = p_sub_type
183: and load_type = wip_job_details.wip_operation
184: and ( operation_seq_num is null
185: or department_id is null
186: or first_unit_start_date is null
187: or first_unit_completion_date is null
199: and parent_header_id = p_parent_header_id /* Fix for Bug#3636378 */
200: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
201: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */
202: and substitution_type = p_sub_type
203: and load_type = wip_job_details.wip_operation
204: and operation_seq_num is null;
205:
206: l_error_exists boolean := false;
207: l_interface_id NUMBER;
205:
206: l_error_exists boolean := false;
207: l_interface_id NUMBER;
208: begin
209: if(p_sub_type = wip_job_details.wip_add) then
210: open c_invalid_add_rows;
211: elsif(p_sub_type = wip_job_details.wip_change) then
212: open c_invalid_change_rows;
213: else
207: l_interface_id NUMBER;
208: begin
209: if(p_sub_type = wip_job_details.wip_add) then
210: open c_invalid_add_rows;
211: elsif(p_sub_type = wip_job_details.wip_change) then
212: open c_invalid_change_rows;
213: else
214: return;
215: end if;
214: return;
215: end if;
216:
217: loop
218: if(p_sub_type = wip_job_details.wip_add) then
219: fetch c_invalid_add_rows into l_interface_id;
220: exit when c_invalid_add_rows%NOTFOUND;
221: elsif(p_sub_type = wip_job_details.wip_change) then
222: fetch c_invalid_change_rows into l_interface_id;
217: loop
218: if(p_sub_type = wip_job_details.wip_add) then
219: fetch c_invalid_add_rows into l_interface_id;
220: exit when c_invalid_add_rows%NOTFOUND;
221: elsif(p_sub_type = wip_job_details.wip_change) then
222: fetch c_invalid_change_rows into l_interface_id;
223: exit when c_invalid_change_rows%NOTFOUND;
224: end if;
225:
225:
226: l_error_exists := true;
227: fnd_message.set_name('WIP', 'WIP_ADD_OP_MIS_VAL');
228: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
229: if(wip_job_details.std_alone = 1) then
230: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
231: p_text => substr(fnd_message.get,1,500),
232: p_error_type => wip_jdi_utils.msg_error);
233: else
242: close c_invalid_change_rows;
243: end if;
244:
245: if(l_error_exists) then
246: if(p_sub_type = wip_job_details.wip_add) then
247: update wip_job_dtls_interface wjdi
248: set process_status = wip_constants.error
249: where group_id = p_group_id
250: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
249: where group_id = p_group_id
250: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
251: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */
252: and substitution_type = p_sub_type
253: and load_type = wip_job_details.wip_operation
254: and ( operation_seq_num IS NULL
255: OR department_id IS NULL
256: OR first_unit_start_date IS NULL
257: OR first_unit_completion_date IS NULL
267: where group_id = p_group_id
268: and process_phase = wip_constants.ml_validation /* Bug 2751349 */
269: and process_status in (wip_constants.running, wip_constants.warning) /* Bug 2751349 */
270: and substitution_type = p_sub_type
271: and load_type = wip_job_details.wip_operation
272: and operation_seq_num IS NULL;
273: end if;
274: end if;
275: end val_null_values;
290: where group_id = p_group_id
291: and process_phase = wip_constants.ml_validation
292: and process_status in (wip_constants.running,
293: wip_constants.warning)
294: and load_type = wip_job_details.wip_operation
295: and substitution_type = p_sub_type
296: and wip_entity_id = p_wip_entity_id
297: and organization_id = p_organization_id
298: and ( ( department_id is null --can not add w/null dept
295: and substitution_type = p_sub_type
296: and wip_entity_id = p_wip_entity_id
297: and organization_id = p_organization_id
298: and ( ( department_id is null --can not add w/null dept
299: and p_sub_type = wip_job_details.wip_add
300: )
301: or ( department_id is not null
302: and not exists (select 1
303: from bom_departments
311: for l_inv_row in c_invalid_rows loop
312: l_error_exists := true;
313: fnd_message.set_name('WIP', 'WIP_DEPARTMENT_NOT_EXIST');
314: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
315: if(wip_job_details.std_alone = 1) then
316: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
317: p_text => substr(fnd_message.get,1,500),
318: p_error_type => wip_jdi_utils.msg_error);
319: else
332: wip_constants.warning)
333: and wip_entity_id = p_wip_entity_id
334: and organization_id = p_organization_id
335: and ( ( department_id is null
336: and p_sub_type = wip_job_details.wip_add
337: )
338: or ( department_id is not null
339: and not exists (select 1
340: from bom_departments
357: where group_id = p_group_id
358: and process_phase = wip_constants.ml_validation
359: and process_status in (wip_constants.running,
360: wip_constants.warning)
361: and load_type = wip_job_details.wip_operation
362: and substitution_type = wip_job_details.wip_change
363: and wip_entity_id = p_wip_entity_id
364: and organization_id = p_organization_id
365: and department_id is not null
358: and process_phase = wip_constants.ml_validation
359: and process_status in (wip_constants.running,
360: wip_constants.warning)
361: and load_type = wip_job_details.wip_operation
362: and substitution_type = wip_job_details.wip_change
363: and wip_entity_id = p_wip_entity_id
364: and organization_id = p_organization_id
365: and department_id is not null
366: and exists (select 1
384: l_error_exists := true;
385: fnd_message.set_name('WIP', 'WIP_DEPARTMENT_RESOURCES_EXIST');
386: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
387: fnd_message.set_token('OPERATION_SEQ_NUM', to_char(l_inv_row.operation_seq_num));
388: if(wip_job_details.std_alone = 1) then
389: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
390: p_text => substr(fnd_message.get,1,500),
391: p_error_type => wip_jdi_utils.msg_error);
392: else
402: where group_id = p_group_id
403: and process_phase = wip_constants.ml_validation
404: and process_status in (wip_constants.running,
405: wip_constants.warning)
406: and load_type = wip_job_details.wip_operation
407: and substitution_type = wip_job_details.wip_change
408: and wip_entity_id = p_wip_entity_id
409: and organization_id = p_organization_id
410: and department_id is not null
403: and process_phase = wip_constants.ml_validation
404: and process_status in (wip_constants.running,
405: wip_constants.warning)
406: and load_type = wip_job_details.wip_operation
407: and substitution_type = wip_job_details.wip_change
408: and wip_entity_id = p_wip_entity_id
409: and organization_id = p_organization_id
410: and department_id is not null
411: and exists (select 1
436: where group_id = p_group_id
437: and process_phase = wip_constants.ml_validation
438: and process_status in (wip_constants.running,
439: wip_constants.warning)
440: and load_type = wip_job_details.wip_operation
441: and substitution_type = p_sub_type
442: and wip_entity_id = p_wip_entity_id
443: and organization_id = p_organization_id
444: and standard_operation_id is not null
454: for l_inv_row in c_invalid_rows loop
455: l_error_exists := true;
456: fnd_message.set_name('WIP', 'WIP_STD_OPER_NOT_EXIST');
457: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
458: if(wip_job_details.std_alone = 1) then
459: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
460: p_text => substr(fnd_message.get,1,500),
461: p_error_type => wip_jdi_utils.msg_error);
462: else
472: where group_id = p_group_id
473: and process_phase = wip_constants.ml_validation
474: and process_status in (wip_constants.running,
475: wip_constants.warning)
476: and load_type = wip_job_details.wip_operation
477: and substitution_type = p_sub_type
478: and wip_entity_id = p_wip_entity_id
479: and organization_id = p_organization_id
480: and standard_operation_id is not null
499: where group_id = p_group_id
500: and process_phase = wip_constants.ml_validation
501: and process_status in (wip_constants.running,
502: wip_constants.warning)
503: and load_type = wip_job_details.wip_operation
504: and substitution_type = p_sub_type
505: and wip_entity_id = p_wip_entity_id
506: and organization_id = p_organization_id
507: and ( ( p_sub_type = wip_job_details.wip_add
503: and load_type = wip_job_details.wip_operation
504: and substitution_type = p_sub_type
505: and wip_entity_id = p_wip_entity_id
506: and organization_id = p_organization_id
507: and ( ( p_sub_type = wip_job_details.wip_add
508: and minimum_transfer_quantity is null
509: )
510: or minimum_transfer_quantity < 0);
511:
514: for l_inv_row in c_invalid_rows loop
515: l_error_exists := true;
516: fnd_message.set_name('WIP', 'WIP_INVALID_MIN_XFER_QTY');
517: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
518: if(wip_job_details.std_alone = 1) then
519: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
520: p_text => substr(fnd_message.get,1,500),
521: p_error_type => wip_jdi_utils.msg_error);
522: else
532: where group_id = p_group_id
533: and process_phase = wip_constants.ml_validation
534: and process_status in (wip_constants.running,
535: wip_constants.warning)
536: and load_type = wip_job_details.wip_operation
537: and substitution_type = p_sub_type
538: and wip_entity_id = p_wip_entity_id
539: and organization_id = p_organization_id
540: and ( ( minimum_transfer_quantity is null
537: and substitution_type = p_sub_type
538: and wip_entity_id = p_wip_entity_id
539: and organization_id = p_organization_id
540: and ( ( minimum_transfer_quantity is null
541: and p_sub_type = wip_job_details.wip_add
542: )
543: or minimum_transfer_quantity < 0 );
544: end if;
545: end val_mtq;
557: where group_id = p_group_id
558: and process_phase = wip_constants.ml_validation
559: and process_status in (wip_constants.running,
560: wip_constants.warning)
561: and load_type = wip_job_details.wip_operation
562: and substitution_type = p_sub_type
563: and wip_entity_id = p_wip_entity_id
564: and organization_id = p_organization_id
565: and ( ( count_point_type is null
562: and substitution_type = p_sub_type
563: and wip_entity_id = p_wip_entity_id
564: and organization_id = p_organization_id
565: and ( ( count_point_type is null
566: and p_sub_type = wip_job_details.wip_add
567: )
568: or ( count_point_type is not null
569: and not exists (select 1
570: from mfg_lookups mfg_l
579: for l_inv_row in c_invalid_rows loop
580: l_error_exists := true;
581: fnd_message.set_name('WIP', 'WIP_INVALID_COUNT_POINT');
582: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
583: if(wip_job_details.std_alone = 1) then
584: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
585: p_text => substr(fnd_message.get,1,500),
586: p_error_type => wip_jdi_utils.msg_error);
587: else
597: where group_id = p_group_id
598: and process_phase = wip_constants.ml_validation
599: and process_status in (wip_constants.running,
600: wip_constants.warning)
601: and load_type = wip_job_details.wip_operation
602: and substitution_type = p_sub_type
603: and wip_entity_id = p_wip_entity_id
604: and organization_id = p_organization_id
605: and ( ( count_point_type is null
602: and substitution_type = p_sub_type
603: and wip_entity_id = p_wip_entity_id
604: and organization_id = p_organization_id
605: and ( ( count_point_type is null
606: and p_sub_type = wip_job_details.wip_add
607: )
608: or ( count_point_type is not null
609: and not exists (select 1
610: from mfg_lookups mfg_l
629: where group_id = p_group_id
630: and process_phase = wip_constants.ml_validation
631: and process_status in (wip_constants.running,
632: wip_constants.warning)
633: and load_type = wip_job_details.wip_operation
634: and substitution_type = p_sub_type
635: and wip_entity_id = p_wip_entity_id
636: and organization_id = p_organization_id
637: and ( ( backflush_flag is null
634: and substitution_type = p_sub_type
635: and wip_entity_id = p_wip_entity_id
636: and organization_id = p_organization_id
637: and ( ( backflush_flag is null
638: and p_sub_type = wip_job_details.wip_add
639: )
640: or ( backflush_flag is not null
641: and not exists (select 1
642: from mfg_lookups mfg_l
651: for l_inv_row in c_invalid_rows loop
652: l_error_exists := true;
653: fnd_message.set_name('WIP', 'WIP_INVALID_BF_FLAG');
654: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
655: if(wip_job_details.std_alone = 1) then
656: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
657: p_text => substr(fnd_message.get,1,500),
658: p_error_type => wip_jdi_utils.msg_error);
659: else
666: if(l_error_exists) then
667: update wip_job_dtls_interface wjdi
668: set process_status = wip_constants.error
669: where group_id = p_group_id
670: and load_type = wip_job_details.wip_operation
671: and substitution_type = p_sub_type
672: and process_phase = wip_constants.ml_validation
673: and process_status in (wip_constants.running,
674: wip_constants.warning)
674: wip_constants.warning)
675: and wip_entity_id = p_wip_entity_id
676: and organization_id = p_organization_id
677: and ( ( backflush_flag is null
678: and p_sub_type = wip_job_details.wip_add
679: )
680: or ( backflush_flag is not null
681: and not exists (select 1
682: from mfg_lookups mfg_l
702: where group_id = p_group_id
703: and process_phase = wip_constants.ml_validation
704: and process_status in (wip_constants.running,
705: wip_constants.warning)
706: and load_type = wip_job_details.wip_operation
707: and substitution_type = wip_job_details.wip_add
708: and wip_entity_id = p_wip_entity_id
709: and organization_id = p_organization_id
710: and (exists (select 1
703: and process_phase = wip_constants.ml_validation
704: and process_status in (wip_constants.running,
705: wip_constants.warning)
706: and load_type = wip_job_details.wip_operation
707: and substitution_type = wip_job_details.wip_add
708: and wip_entity_id = p_wip_entity_id
709: and organization_id = p_organization_id
710: and (exists (select 1
711: from wip_operations
726: else
727: fnd_message.set_name('WIP', 'WIP_OPERATION_ALREADY_EXIST');
728: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
729: end if;
730: if(wip_job_details.std_alone = 1) then
731: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
732: p_text => substr(fnd_message.get,1,500),
733: p_error_type => wip_jdi_utils.msg_error);
734: else
741: if(l_error_exists) then
742: update wip_job_dtls_interface wjdi
743: set process_status = wip_constants.error
744: where group_id = p_group_id
745: and load_type = wip_job_details.wip_operation
746: and substitution_type = wip_job_details.wip_add
747: and process_phase = wip_constants.ml_validation
748: and process_status in (wip_constants.running,
749: wip_constants.warning)
742: update wip_job_dtls_interface wjdi
743: set process_status = wip_constants.error
744: where group_id = p_group_id
745: and load_type = wip_job_details.wip_operation
746: and substitution_type = wip_job_details.wip_add
747: and process_phase = wip_constants.ml_validation
748: and process_status in (wip_constants.running,
749: wip_constants.warning)
750: and wip_entity_id = p_wip_entity_id
771: where group_id = p_group_id
772: and process_phase = wip_constants.ml_validation
773: and process_status in (wip_constants.running,
774: wip_constants.warning)
775: and load_type = wip_job_details.wip_operation
776: and substitution_type = wip_job_details.wip_add
777: and wip_entity_id = p_wip_entity_id
778: and organization_id = p_organization_id
779: and parent_header_id = p_parent_header_id
772: and process_phase = wip_constants.ml_validation
773: and process_status in (wip_constants.running,
774: wip_constants.warning)
775: and load_type = wip_job_details.wip_operation
776: and substitution_type = wip_job_details.wip_add
777: and wip_entity_id = p_wip_entity_id
778: and organization_id = p_organization_id
779: and parent_header_id = p_parent_header_id
780: and ( wjdi.first_unit_start_date is null
796: where group_id = p_group_id
797: and process_phase = wip_constants.ml_validation
798: and process_status in (wip_constants.running,
799: wip_constants.warning)
800: and load_type = wip_job_details.wip_operation
801: and substitution_type = wip_job_details.wip_add
802: and wip_entity_id = p_wip_entity_id
803: and organization_id = p_organization_id
804: and ( first_unit_start_date is null
797: and process_phase = wip_constants.ml_validation
798: and process_status in (wip_constants.running,
799: wip_constants.warning)
800: and load_type = wip_job_details.wip_operation
801: and substitution_type = wip_job_details.wip_add
802: and wip_entity_id = p_wip_entity_id
803: and organization_id = p_organization_id
804: and ( first_unit_start_date is null
805: or first_unit_completion_date is null
817: l_interface_id NUMBER;
818: l_error_exists boolean := false;
819: begin
820:
821: if(wip_job_details.std_alone = 0) then
822: open c_ml_invalid_rows;
823: else
824: open c_wdj_invalid_rows;
825: end if;
824: open c_wdj_invalid_rows;
825: end if;
826:
827: loop
828: if(wip_job_details.std_alone = 0) then
829: fetch c_ml_invalid_rows into l_interface_id;
830: exit when c_ml_invalid_rows%NOTFOUND;
831: else
832: fetch c_wdj_invalid_rows into l_interface_id;
834: end if;
835: l_error_exists := true; --loop executes only for invalid rows!
836: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
837: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
838: if(wip_job_details.std_alone = 1) then
839: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
840: p_text => substr(fnd_message.get,1,500),
841: p_error_type => wip_jdi_utils.msg_error);
842: else
853: close c_wdj_invalid_rows;
854: end if;
855:
856: if(l_error_exists) then
857: if(wip_job_details.std_alone = 1) then
858: update wip_job_dtls_interface wjdi
859: set process_status = wip_constants.error
860: where group_id = p_group_id
861: and process_phase = wip_constants.ml_validation
860: where group_id = p_group_id
861: and process_phase = wip_constants.ml_validation
862: and process_status in (wip_constants.running,
863: wip_constants.warning)
864: and load_type = wip_job_details.wip_operation
865: and substitution_type = wip_job_details.wip_add
866: and wip_entity_id = p_wip_entity_id
867: and organization_id = p_organization_id
868: and ( wjdi.first_unit_start_date is null
861: and process_phase = wip_constants.ml_validation
862: and process_status in (wip_constants.running,
863: wip_constants.warning)
864: and load_type = wip_job_details.wip_operation
865: and substitution_type = wip_job_details.wip_add
866: and wip_entity_id = p_wip_entity_id
867: and organization_id = p_organization_id
868: and ( wjdi.first_unit_start_date is null
869: or wjdi.first_unit_completion_date is null
882: where group_id = p_group_id
883: and process_phase = wip_constants.ml_validation
884: and process_status in (wip_constants.running,
885: wip_constants.warning)
886: and load_type = wip_job_details.wip_operation
887: and substitution_type = wip_job_details.wip_add
888: and wip_entity_id = p_wip_entity_id
889: and organization_id = p_organization_id
890: and parent_header_id = p_parent_header_id
883: and process_phase = wip_constants.ml_validation
884: and process_status in (wip_constants.running,
885: wip_constants.warning)
886: and load_type = wip_job_details.wip_operation
887: and substitution_type = wip_job_details.wip_add
888: and wip_entity_id = p_wip_entity_id
889: and organization_id = p_organization_id
890: and parent_header_id = p_parent_header_id
891: and ( wjdi.first_unit_start_date is null
919: where group_id = p_group_id
920: and process_phase = wip_constants.ml_validation
921: and process_status in (wip_constants.running,
922: wip_constants.warning)
923: and load_type = wip_job_details.wip_operation
924: and substitution_type = wip_job_details.wip_change
925: and wip_entity_id = p_wip_entity_id
926: and not exists (select 1
927: from wip_operations
920: and process_phase = wip_constants.ml_validation
921: and process_status in (wip_constants.running,
922: wip_constants.warning)
923: and load_type = wip_job_details.wip_operation
924: and substitution_type = wip_job_details.wip_change
925: and wip_entity_id = p_wip_entity_id
926: and not exists (select 1
927: from wip_operations
928: where wip_entity_id = wjdi.wip_entity_id
935: for l_inv_row in c_invalid_rows loop
936: l_error_exists := true;
937: fnd_message.set_name('WIP', 'WIP_OP_NOT_FOUND');
938: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
939: if(wip_job_details.std_alone = 1) then
940: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
941: p_text => substr(fnd_message.get,1,500),
942: p_error_type => wip_jdi_utils.msg_error);
943: else
976: where group_id = p_group_id
977: and process_phase = wip_constants.ml_validation
978: and process_status in (wip_constants.running,
979: wip_constants.warning)
980: and load_type = wip_job_details.wip_operation
981: and substitution_type = wip_job_details.wip_change
982: and wip_entity_id = p_wip_entity_id
983: and organization_id = p_organization_id
984: and ( wjdi.last_unit_start_date is not null
977: and process_phase = wip_constants.ml_validation
978: and process_status in (wip_constants.running,
979: wip_constants.warning)
980: and load_type = wip_job_details.wip_operation
981: and substitution_type = wip_job_details.wip_change
982: and wip_entity_id = p_wip_entity_id
983: and organization_id = p_organization_id
984: and ( wjdi.last_unit_start_date is not null
985: or wjdi.first_unit_start_date is not null
1013: for l_row in c_invalid_rows loop
1014: l_error_exists := true; --loop executes only for invalid rows!
1015: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
1016: fnd_message.set_token('INTERFACE', to_char(l_row.interface_id));
1017: if(wip_job_details.std_alone = 1) then
1018: wip_interface_err_Utils.add_error(p_interface_id => l_row.interface_id,
1019: p_text => substr(fnd_message.get,1,500),
1020: p_error_type => wip_jdi_utils.msg_error);
1021: else
1031: where group_id = p_group_id
1032: and process_phase = wip_constants.ml_validation
1033: and process_status in (wip_constants.running,
1034: wip_constants.warning)
1035: and load_type = wip_job_details.wip_operation
1036: and substitution_type = wip_job_details.wip_change
1037: and wip_entity_id = p_wip_entity_id
1038: and organization_id = p_organization_id
1039: and ( wjdi.last_unit_start_date is not null
1032: and process_phase = wip_constants.ml_validation
1033: and process_status in (wip_constants.running,
1034: wip_constants.warning)
1035: and load_type = wip_job_details.wip_operation
1036: and substitution_type = wip_job_details.wip_change
1037: and wip_entity_id = p_wip_entity_id
1038: and organization_id = p_organization_id
1039: and ( wjdi.last_unit_start_date is not null
1040: or wjdi.first_unit_start_date is not null