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 227: p_error_type => wip_jdi_utils.msg_error);

223: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
224: if(wip_job_details.std_alone = 1) then
225: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
226: p_text => substr(fnd_message.get,1,500),
227: p_error_type => wip_jdi_utils.msg_error);
228: else
229: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
230: p_text => substr(fnd_message.get,1,500),
231: p_error_type => wip_jdi_utils.msg_error);

Line 231: p_error_type => wip_jdi_utils.msg_error);

227: p_error_type => wip_jdi_utils.msg_error);
228: else
229: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
230: p_text => substr(fnd_message.get,1,500),
231: p_error_type => wip_jdi_utils.msg_error);
232: end if;
233: end loop;
234:
235: if(l_error_exists) then

Line 265: p_error_type => wip_jdi_utils.msg_error);

261: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
262: if(wip_job_details.std_alone = 1) then
263: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
264: p_text => substr(fnd_message.get,1,500),
265: p_error_type => wip_jdi_utils.msg_error);
266: else
267: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
268: p_text => substr(fnd_message.get,1,500),
269: p_error_type => wip_jdi_utils.msg_error);

Line 269: p_error_type => wip_jdi_utils.msg_error);

265: p_error_type => wip_jdi_utils.msg_error);
266: else
267: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
268: p_text => substr(fnd_message.get,1,500),
269: p_error_type => wip_jdi_utils.msg_error);
270: end if;
271: end loop;
272:
273: if(l_error_exists) then

Line 302: p_error_type => wip_jdi_utils.msg_error);

298: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
299: if(wip_job_details.std_alone = 1) then
300: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
301: p_text => substr(fnd_message.get,1,500),
302: p_error_type => wip_jdi_utils.msg_error);
303: else
304: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
305: p_text => substr(fnd_message.get,1,500),
306: p_error_type => wip_jdi_utils.msg_error);

Line 306: p_error_type => wip_jdi_utils.msg_error);

302: p_error_type => wip_jdi_utils.msg_error);
303: else
304: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
305: p_text => substr(fnd_message.get,1,500),
306: p_error_type => wip_jdi_utils.msg_error);
307: end if;
308: end loop;
309:
310: if(l_error_exists) then

Line 441: p_error_type => wip_jdi_utils.msg_error);

437: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
438: if(wip_job_details.std_alone = 1) then
439: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
440: p_text => substr(fnd_message.get,1,500),
441: p_error_type => wip_jdi_utils.msg_error);
442: else
443: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
444: p_text => substr(fnd_message.get,1,500),
445: p_error_type => wip_jdi_utils.msg_error);

Line 445: p_error_type => wip_jdi_utils.msg_error);

441: p_error_type => wip_jdi_utils.msg_error);
442: else
443: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
444: p_text => substr(fnd_message.get,1,500),
445: p_error_type => wip_jdi_utils.msg_error);
446: end if;
447: end loop;
448:
449: if(l_error_exists) then

Line 517: p_error_type => wip_jdi_utils.msg_error);

513: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
514: if(wip_job_details.std_alone = 1) then
515: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
516: p_text => substr(fnd_message.get,1,500),
517: p_error_type => wip_jdi_utils.msg_error);
518: else
519: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
520: p_text => substr(fnd_message.get,1,500),
521: p_error_type => wip_jdi_utils.msg_error);

Line 521: p_error_type => wip_jdi_utils.msg_error);

517: p_error_type => wip_jdi_utils.msg_error);
518: else
519: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
520: p_text => substr(fnd_message.get,1,500),
521: p_error_type => wip_jdi_utils.msg_error);
522: end if;
523: end loop;
524:
525: if(l_error_exists) then

Line 682: p_error_type => wip_jdi_utils.msg_error);

678: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
679: if(wip_job_details.std_alone = 1) then
680: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
681: p_text => substr(fnd_message.get,1,500),
682: p_error_type => wip_jdi_utils.msg_error);
683: else
684: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
685: p_text => substr(fnd_message.get,1,500),
686: p_error_type => wip_jdi_utils.msg_error);

Line 686: p_error_type => wip_jdi_utils.msg_error);

682: p_error_type => wip_jdi_utils.msg_error);
683: else
684: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
685: p_text => substr(fnd_message.get,1,500),
686: p_error_type => wip_jdi_utils.msg_error);
687: end if;
688: end loop;
689:
690: /* bug#2811687 : begin */

Line 698: p_error_type => wip_jdi_utils.msg_error);

694: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
695: if(wip_job_details.std_alone = 1) then
696: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
697: p_text => substr(fnd_message.get,1,500),
698: p_error_type => wip_jdi_utils.msg_error);
699: else
700: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
701: p_text => substr(fnd_message.get,1,500),
702: p_error_type => wip_jdi_utils.msg_error);

Line 702: p_error_type => wip_jdi_utils.msg_error);

698: p_error_type => wip_jdi_utils.msg_error);
699: else
700: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
701: p_text => substr(fnd_message.get,1,500),
702: p_error_type => wip_jdi_utils.msg_error);
703: end if;
704: end loop;
705:
706: for l_inv_row in c_mrp_net_flag_invalid_rows loop

Line 713: p_error_type => wip_jdi_utils.msg_error);

709: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
710: if(wip_job_details.std_alone = 1) then
711: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
712: p_text => substr(fnd_message.get,1,500),
713: p_error_type => wip_jdi_utils.msg_error);
714: else
715: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
716: p_text => substr(fnd_message.get,1,500),
717: p_error_type => wip_jdi_utils.msg_error);

Line 717: p_error_type => wip_jdi_utils.msg_error);

713: p_error_type => wip_jdi_utils.msg_error);
714: else
715: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
716: p_text => substr(fnd_message.get,1,500),
717: p_error_type => wip_jdi_utils.msg_error);
718: end if;
719: end loop;
720:
721: for l_inv_row in c_auto_req_mat_invalid_rows loop

Line 728: p_error_type => wip_jdi_utils.msg_error);

724: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
725: if(wip_job_details.std_alone = 1) then
726: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
727: p_text => substr(fnd_message.get,1,500),
728: p_error_type => wip_jdi_utils.msg_error);
729: else
730: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
731: p_text => substr(fnd_message.get,1,500),
732: p_error_type => wip_jdi_utils.msg_error);

Line 732: p_error_type => wip_jdi_utils.msg_error);

728: p_error_type => wip_jdi_utils.msg_error);
729: else
730: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
731: p_text => substr(fnd_message.get,1,500),
732: p_error_type => wip_jdi_utils.msg_error);
733: end if;
734: end loop;
735: /* bug#2811687 : end */
736:

Line 746: p_error_type => wip_jdi_utils.msg_error);

742: if(wip_job_details.std_alone =1 ) then
743: wip_interface_err_utils.add_error (
744: p_interface_id => l_inv_row.interface_id,
745: p_text => substr(fnd_message.get,1,500),
746: p_error_type => wip_jdi_utils.msg_error);
747: else
748: wip_interface_err_utils.add_error (
749: p_interface_id => wip_jsi_utils.current_interface_id,
750: p_text => substr(fnd_message.get,1,500),

Line 751: p_error_type => wip_jdi_utils.msg_error);

747: else
748: wip_interface_err_utils.add_error (
749: p_interface_id => wip_jsi_utils.current_interface_id,
750: p_text => substr(fnd_message.get,1,500),
751: p_error_type => wip_jdi_utils.msg_error);
752: end if ;
753: end loop;
754:
755: if(l_error_exists) then

Line 833: p_error_type => wip_jdi_utils.msg_error);

829: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
830: if(wip_job_details.std_alone = 1) then
831: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
832: p_text => substr(fnd_message.get,1,500),
833: p_error_type => wip_jdi_utils.msg_error);
834: else
835: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
836: p_text => substr(fnd_message.get,1,500),
837: p_error_type => wip_jdi_utils.msg_error);

Line 837: p_error_type => wip_jdi_utils.msg_error);

833: p_error_type => wip_jdi_utils.msg_error);
834: else
835: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
836: p_text => substr(fnd_message.get,1,500),
837: p_error_type => wip_jdi_utils.msg_error);
838: end if;
839:
840: update wip_job_dtls_interface wjdi
841: set process_status = wip_constants.error

Line 1052: p_error_type => wip_jdi_utils.msg_error);

1048: wip_logger.log('Error in Valid_Req_subinvlocator,error_tbl(indx).error_msg='||error_tbl(indx).error_msg||';interface_id='||to_char(error_tbl(indx).interface_id),l_dummy2);
1049: fnd_message.set_token('SUBINV', error_tbl(indx).supply_subinventory);
1050: wip_interface_err_Utils.add_error(p_interface_id => error_tbl(indx).interface_id,
1051: p_text => substr(fnd_message.get,1,500),
1052: p_error_type => wip_jdi_utils.msg_error);
1053: update wip_job_dtls_interface wjdi
1054: set process_status = wip_constants.error
1055: where interface_id = error_tbl(indx).interface_id;
1056:

Line 1239: p_error_type => wip_jdi_utils.msg_error);

1235: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1236: if(wip_job_details.std_alone = 1) then
1237: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1238: p_text => substr(fnd_message.get,1,500),
1239: p_error_type => wip_jdi_utils.msg_error);
1240: else
1241: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1242: p_text => substr(fnd_message.get,1,500),
1243: p_error_type => wip_jdi_utils.msg_error);

Line 1243: p_error_type => wip_jdi_utils.msg_error);

1239: p_error_type => wip_jdi_utils.msg_error);
1240: else
1241: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1242: p_text => substr(fnd_message.get,1,500),
1243: p_error_type => wip_jdi_utils.msg_error);
1244: end if;
1245: end loop;
1246:
1247: if(l_error_exists) then

Line 1316: p_error_type => wip_jdi_utils.msg_error);

1312: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1313: if(wip_job_details.std_alone = 1) then
1314: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1315: p_text => substr(fnd_message.get,1,500),
1316: p_error_type => wip_jdi_utils.msg_error);
1317: else
1318: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1319: p_text => substr(fnd_message.get,1,500),
1320: p_error_type => wip_jdi_utils.msg_error);

Line 1320: p_error_type => wip_jdi_utils.msg_error);

1316: p_error_type => wip_jdi_utils.msg_error);
1317: else
1318: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1319: p_text => substr(fnd_message.get,1,500),
1320: p_error_type => wip_jdi_utils.msg_error);
1321: end if;
1322: end loop;
1323:
1324: if(l_error_exists) then