APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_INTERFACE_ERR_UTILS

Line 33: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

29: l_error_exists := true;
30: fnd_message.set_name('WIP', 'WIP_JDI_DEL_REQ_INFO_MISSING');
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,

Line 37: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
40: end if;
41: end loop;

Line 113: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

109: fnd_message.set_token('OPERATION', to_char(l_inv_row.operation_seq_num));
110: fnd_message.set_token('ITEM', l_inv_row.item_name);
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,

Line 117: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
120: end if;
121: end loop;

Line 225: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

221: l_error_exists := true;
222: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
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,

Line 229: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
232: end if;
233: end loop;

Line 263: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

259: l_error_exists := true;
260: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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,

Line 267: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
270: end if;
271: end loop;

Line 300: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

296: l_error_exists := true;
297: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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,

Line 304: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
307: end if;
308: end loop;

Line 439: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

435: l_error_exists := true;
436: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
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,

Line 443: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
446: end if;
447: end loop;

Line 515: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

511: l_error_exists := true;
512: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
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,

Line 519: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
522: end if;
523: end loop;

Line 680: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

676: l_error_exists := true;
677: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
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,

Line 684: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
687: end if;
688: end loop;

Line 696: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

692: l_error_exists := true;
693: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
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,

Line 700: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
703: end if;
704: end loop;

Line 711: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

707: l_error_exists := true;
708: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
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,

Line 715: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
718: end if;
719: end loop;

Line 726: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

722: l_error_exists := true;
723: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
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,

Line 730: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
733: end if;
734: end loop;

Line 743: wip_interface_err_utils.add_error (

739: l_error_exists := true ;
740: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');
741: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
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

Line 748: 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),
751: p_error_type => wip_jdi_utils.msg_error);
752: end if ;

Line 831: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

827: l_error_exists := true;
828: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
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,

Line 835: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
838: end if;
839:

Line 1050: wip_interface_err_Utils.add_error(p_interface_id => error_tbl(indx).interface_id,

1046: fnd_message.set_token('ITEM_ID', to_char(error_tbl(indx).inventory_item_id));
1047: wip_logger.log('Error in Valid_Req_subinvlocator,inventory_item_id='||to_char(error_tbl(indx).inventory_item_id),l_dummy2);
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

Line 1237: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

1233: l_error_exists := true;
1234: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
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,

Line 1241: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
1244: end if;
1245: end loop;

Line 1314: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,

1310: l_error_exists := true;
1311: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
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,

Line 1318: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,

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);
1321: end if;
1322: end loop;