31: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
32: if(wip_job_details.std_alone = 1) then
33: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
34: p_text => substr(fnd_message.get,1,500),
35: p_error_type => wip_jdi_utils.msg_error);
36: else
37: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
38: p_text => substr(fnd_message.get,1,500),
39: p_error_type => wip_jdi_utils.msg_error);
35: p_error_type => wip_jdi_utils.msg_error);
36: else
37: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
38: p_text => substr(fnd_message.get,1,500),
39: p_error_type => wip_jdi_utils.msg_error);
40: end if;
41: end loop;
42:
43: if(l_error_exists) then
111: fnd_message.set_token('ITEMID', to_char(l_inv_row.inventory_item_id_old));
112: if(wip_job_details.std_alone = 1) then
113: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
114: p_text => substr(fnd_message.get,1,500),
115: p_error_type => wip_jdi_utils.msg_error);
116: else
117: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
118: p_text => substr(fnd_message.get,1,500),
119: p_error_type => wip_jdi_utils.msg_error);
115: p_error_type => wip_jdi_utils.msg_error);
116: else
117: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
118: p_text => substr(fnd_message.get,1,500),
119: p_error_type => wip_jdi_utils.msg_error);
120: end if;
121: end loop;
122:
123: if(l_error_exists) then
225: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
226: if(wip_job_details.std_alone = 1) then
227: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
228: p_text => substr(fnd_message.get,1,500),
229: p_error_type => wip_jdi_utils.msg_error);
230: else
231: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
232: p_text => substr(fnd_message.get,1,500),
233: p_error_type => wip_jdi_utils.msg_error);
229: p_error_type => wip_jdi_utils.msg_error);
230: else
231: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
232: p_text => substr(fnd_message.get,1,500),
233: p_error_type => wip_jdi_utils.msg_error);
234: end if;
235: end loop;
236:
237: if(l_error_exists) then
263: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
264: if(wip_job_details.std_alone = 1) then
265: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
266: p_text => substr(fnd_message.get,1,500),
267: p_error_type => wip_jdi_utils.msg_error);
268: else
269: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
270: p_text => substr(fnd_message.get,1,500),
271: p_error_type => wip_jdi_utils.msg_error);
267: p_error_type => wip_jdi_utils.msg_error);
268: else
269: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
270: p_text => substr(fnd_message.get,1,500),
271: p_error_type => wip_jdi_utils.msg_error);
272: end if;
273: end loop;
274:
275: if(l_error_exists) then
300: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
301: if(wip_job_details.std_alone = 1) then
302: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
303: p_text => substr(fnd_message.get,1,500),
304: p_error_type => wip_jdi_utils.msg_error);
305: else
306: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
307: p_text => substr(fnd_message.get,1,500),
308: p_error_type => wip_jdi_utils.msg_error);
304: p_error_type => wip_jdi_utils.msg_error);
305: else
306: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
307: p_text => substr(fnd_message.get,1,500),
308: p_error_type => wip_jdi_utils.msg_error);
309: end if;
310: end loop;
311:
312: if(l_error_exists) then
439: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
440: if(wip_job_details.std_alone = 1) then
441: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
442: p_text => substr(fnd_message.get,1,500),
443: p_error_type => wip_jdi_utils.msg_error);
444: else
445: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
446: p_text => substr(fnd_message.get,1,500),
447: p_error_type => wip_jdi_utils.msg_error);
443: p_error_type => wip_jdi_utils.msg_error);
444: else
445: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
446: p_text => substr(fnd_message.get,1,500),
447: p_error_type => wip_jdi_utils.msg_error);
448: end if;
449: end loop;
450:
451: if(l_error_exists) then
515: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
516: if(wip_job_details.std_alone = 1) then
517: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
518: p_text => substr(fnd_message.get,1,500),
519: p_error_type => wip_jdi_utils.msg_error);
520: else
521: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
522: p_text => substr(fnd_message.get,1,500),
523: p_error_type => wip_jdi_utils.msg_error);
519: p_error_type => wip_jdi_utils.msg_error);
520: else
521: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
522: p_text => substr(fnd_message.get,1,500),
523: p_error_type => wip_jdi_utils.msg_error);
524: end if;
525: end loop;
526:
527: if(l_error_exists) then
680: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
681: if(wip_job_details.std_alone = 1) then
682: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
683: p_text => substr(fnd_message.get,1,500),
684: p_error_type => wip_jdi_utils.msg_error);
685: else
686: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
687: p_text => substr(fnd_message.get,1,500),
688: p_error_type => wip_jdi_utils.msg_error);
684: p_error_type => wip_jdi_utils.msg_error);
685: else
686: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
687: p_text => substr(fnd_message.get,1,500),
688: p_error_type => wip_jdi_utils.msg_error);
689: end if;
690: end loop;
691:
692: /* bug#2811687 : begin */
696: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
697: if(wip_job_details.std_alone = 1) then
698: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
699: p_text => substr(fnd_message.get,1,500),
700: p_error_type => wip_jdi_utils.msg_error);
701: else
702: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
703: p_text => substr(fnd_message.get,1,500),
704: p_error_type => wip_jdi_utils.msg_error);
700: p_error_type => wip_jdi_utils.msg_error);
701: else
702: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
703: p_text => substr(fnd_message.get,1,500),
704: p_error_type => wip_jdi_utils.msg_error);
705: end if;
706: end loop;
707:
708: for l_inv_row in c_mrp_net_flag_invalid_rows loop
711: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
712: if(wip_job_details.std_alone = 1) then
713: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
714: p_text => substr(fnd_message.get,1,500),
715: p_error_type => wip_jdi_utils.msg_error);
716: else
717: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
718: p_text => substr(fnd_message.get,1,500),
719: p_error_type => wip_jdi_utils.msg_error);
715: p_error_type => wip_jdi_utils.msg_error);
716: else
717: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
718: p_text => substr(fnd_message.get,1,500),
719: p_error_type => wip_jdi_utils.msg_error);
720: end if;
721: end loop;
722:
723: for l_inv_row in c_auto_req_mat_invalid_rows loop
726: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
727: if(wip_job_details.std_alone = 1) then
728: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
729: p_text => substr(fnd_message.get,1,500),
730: p_error_type => wip_jdi_utils.msg_error);
731: else
732: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
733: p_text => substr(fnd_message.get,1,500),
734: p_error_type => wip_jdi_utils.msg_error);
730: p_error_type => wip_jdi_utils.msg_error);
731: else
732: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
733: p_text => substr(fnd_message.get,1,500),
734: p_error_type => wip_jdi_utils.msg_error);
735: end if;
736: end loop;
737: /* bug#2811687 : end */
738:
744: if(wip_job_details.std_alone =1 ) then
745: wip_interface_err_utils.add_error (
746: p_interface_id => l_inv_row.interface_id,
747: p_text => substr(fnd_message.get,1,500),
748: p_error_type => wip_jdi_utils.msg_error);
749: else
750: wip_interface_err_utils.add_error (
751: p_interface_id => wip_jsi_utils.current_interface_id,
752: p_text => substr(fnd_message.get,1,500),
749: else
750: wip_interface_err_utils.add_error (
751: p_interface_id => wip_jsi_utils.current_interface_id,
752: p_text => substr(fnd_message.get,1,500),
753: p_error_type => wip_jdi_utils.msg_error);
754: end if ;
755: end loop;
756:
757: if(l_error_exists) then
831: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
832: if(wip_job_details.std_alone = 1) then
833: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
834: p_text => substr(fnd_message.get,1,500),
835: p_error_type => wip_jdi_utils.msg_error);
836: else
837: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
838: p_text => substr(fnd_message.get,1,500),
839: p_error_type => wip_jdi_utils.msg_error);
835: p_error_type => wip_jdi_utils.msg_error);
836: else
837: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
838: p_text => substr(fnd_message.get,1,500),
839: p_error_type => wip_jdi_utils.msg_error);
840: end if;
841:
842: update wip_job_dtls_interface wjdi
843: set process_status = wip_constants.error
1013: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1014: if(wip_job_details.std_alone = 1) then
1015: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1016: p_text => substr(fnd_message.get,1,500),
1017: p_error_type => wip_jdi_utils.msg_error);
1018: else
1019: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1020: p_text => substr(fnd_message.get,1,500),
1021: p_error_type => wip_jdi_utils.msg_error);
1017: p_error_type => wip_jdi_utils.msg_error);
1018: else
1019: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1020: p_text => substr(fnd_message.get,1,500),
1021: p_error_type => wip_jdi_utils.msg_error);
1022: end if;
1023: end loop;
1024:
1025: if(l_error_exists) then
1090: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1091: if(wip_job_details.std_alone = 1) then
1092: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1093: p_text => substr(fnd_message.get,1,500),
1094: p_error_type => wip_jdi_utils.msg_error);
1095: else
1096: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1097: p_text => substr(fnd_message.get,1,500),
1098: p_error_type => wip_jdi_utils.msg_error);
1094: p_error_type => wip_jdi_utils.msg_error);
1095: else
1096: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1097: p_text => substr(fnd_message.get,1,500),
1098: p_error_type => wip_jdi_utils.msg_error);
1099: end if;
1100: end loop;
1101:
1102: if(l_error_exists) then