DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_JDI_UTILS

Line 35: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 115: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 229: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 267: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 304: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 443: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 519: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 684: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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 */

Line 700: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 715: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 730: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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:

Line 748: p_error_type => wip_jdi_utils.msg_error);

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),

Line 753: 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),
753: p_error_type => wip_jdi_utils.msg_error);
754: end if ;
755: end loop;
756:
757: if(l_error_exists) then

Line 835: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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

Line 1017: p_error_type => wip_jdi_utils.msg_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);

Line 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

Line 1094: p_error_type => wip_jdi_utils.msg_error);

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);

Line 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