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
234: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
234: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
235: p_text => substr(fnd_message.get,1,500),
236: p_error_type => wip_jdi_utils.msg_error);
237: end if;
238: end 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
320: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
320: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
321: p_text => substr(fnd_message.get,1,500),
322: p_error_type => wip_jdi_utils.msg_error);
323: end if;
324: end loop;
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
393: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
393: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
394: p_text => substr(fnd_message.get,1,500),
395: p_error_type => wip_jdi_utils.msg_error);
396: end if;
397: end 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
463: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
463: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
464: p_text => substr(fnd_message.get,1,500),
465: p_error_type => wip_jdi_utils.msg_error);
466: end if;
467: end 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
523: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
523: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
524: p_text => substr(fnd_message.get,1,500),
525: p_error_type => wip_jdi_utils.msg_error);
526: end if;
527: end 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
588: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
588: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
589: p_text => substr(fnd_message.get,1,500),
590: p_error_type => wip_jdi_utils.msg_error);
591: end if;
592: end 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
660: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
660: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
661: p_text => substr(fnd_message.get,1,500),
662: p_error_type => wip_jdi_utils.msg_error);
663: end if;
664: end loop;
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
735: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
735: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
736: p_text => substr(fnd_message.get,1,500),
737: p_error_type => wip_jdi_utils.msg_error);
738: end if;
739: end loop;
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
843: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
843: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
844: p_text => substr(fnd_message.get,1,500),
845: p_error_type => wip_jdi_utils.msg_error);
846: end if;
847:
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
944: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
944: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
945: p_text => substr(fnd_message.get,1,500),
946: p_error_type => wip_jdi_utils.msg_error);
947: end if;
948: end 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
1022: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
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
1022: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1023: p_text => substr(fnd_message.get,1,500),
1024: p_error_type => wip_jdi_utils.msg_error);
1025: end if;
1026: end loop;