eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on FND_MESSAGE

Line 30: fnd_message.set_name('WIP', 'WIP_JDI_DEL_REQ_INFO_MISSING');

26: begin
27:
28: for l_inv_row in c_invalid_rows loop
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),

Line 31: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

27:
28: for l_inv_row in c_invalid_rows loop
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);

Line 34: p_text => substr(fnd_message.get,1,500),

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,
38: p_text => substr(fnd_message.get,1,500),

Line 38: p_text => substr(fnd_message.get,1,500),

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;
42:

Line 105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');

101: begin
102:
103: for l_inv_row in c_invalid_rows loop
104: l_error_exists := true;
105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');
106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_id));
109: fnd_message.set_token('OPERATION', to_char(l_inv_row.operation_seq_num));

Line 106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

102:
103: for l_inv_row in c_invalid_rows loop
104: l_error_exists := true;
105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');
106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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);

Line 107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);

103: for l_inv_row in c_invalid_rows loop
104: l_error_exists := true;
105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');
106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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));

Line 108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_id));

104: l_error_exists := true;
105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');
106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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

Line 109: fnd_message.set_token('OPERATION', to_char(l_inv_row.operation_seq_num));

105: fnd_message.set_name('WIP', 'WIP_JDI_REQ_NOT_IN_JOB');
106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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,

Line 110: fnd_message.set_token('ITEM', l_inv_row.item_name);

106: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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),

Line 111: fnd_message.set_token('ITEMID', to_char(l_inv_row.inventory_item_id_old));

107: fnd_message.set_token('JOB', l_inv_row.wip_entity_name);
108: fnd_message.set_token('WEI', to_char(l_inv_row.wip_entity_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);

Line 114: p_text => substr(fnd_message.get,1,500),

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,
118: p_text => substr(fnd_message.get,1,500),

Line 118: p_text => substr(fnd_message.get,1,500),

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;
122:

Line 224: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');

220: begin
221:
222: for l_inv_row in c_invalid_wro_rows loop
223: l_error_exists := true;
224: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
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),

Line 225: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

221:
222: for l_inv_row in c_invalid_wro_rows loop
223: l_error_exists := true;
224: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
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);

Line 228: p_text => substr(fnd_message.get,1,500),

224: fnd_message.set_name('WIP', 'WIP_JDI_QTY_ISSUED');
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),

Line 232: p_text => substr(fnd_message.get,1,500),

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);
234: end if;
235: end loop;
236:

Line 262: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');

258: end if;
259:
260: for l_inv_row in c_invalid_mmtt_rows loop
261: l_error_exists := true;
262: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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),

Line 263: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

259:
260: for l_inv_row in c_invalid_mmtt_rows loop
261: l_error_exists := true;
262: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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);

Line 266: p_text => substr(fnd_message.get,1,500),

262: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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),

Line 270: p_text => substr(fnd_message.get,1,500),

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);
272: end if;
273: end loop;
274:

Line 299: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');

295: end if;
296:
297: for l_inv_row in c_invalid_mmt_rows loop
298: l_error_exists := true;
299: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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),

Line 300: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

296:
297: for l_inv_row in c_invalid_mmt_rows loop
298: l_error_exists := true;
299: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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);

Line 303: p_text => substr(fnd_message.get,1,500),

299: fnd_message.set_name('WIP', 'WIP_JDI_REQ_JOB_PENDING');
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),

Line 307: p_text => substr(fnd_message.get,1,500),

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);
309: end if;
310: end loop;
311:

Line 438: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');

434: begin
435:
436: for l_inv_row in c_invalid_rows loop
437: l_error_exists := true;
438: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
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),

Line 439: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

435:
436: for l_inv_row in c_invalid_rows loop
437: l_error_exists := true;
438: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
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);

Line 442: p_text => substr(fnd_message.get,1,500),

438: fnd_message.set_name('WIP', 'WIP_JDI_ADD_REQ_INFO_MISSING');
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),

Line 446: p_text => substr(fnd_message.get,1,500),

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);
448: end if;
449: end loop;
450:

Line 514: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');

510: begin
511:
512: for l_inv_row in c_invalid_rows loop
513: l_error_exists := true;
514: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
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),

Line 515: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

511:
512: for l_inv_row in c_invalid_rows loop
513: l_error_exists := true;
514: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
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);

Line 518: p_text => substr(fnd_message.get,1,500),

514: fnd_message.set_name('WIP', 'WIP_JDI_REQ_EXIST');
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),

Line 522: p_text => substr(fnd_message.get,1,500),

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);
524: end if;
525: end loop;
526:

Line 679: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');

675: begin
676:
677: for l_inv_row in c_invalid_rows loop
678: l_error_exists := true;
679: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
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),

Line 680: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

676:
677: for l_inv_row in c_invalid_rows loop
678: l_error_exists := true;
679: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
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);

Line 683: p_text => substr(fnd_message.get,1,500),

679: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MTL_REQ');
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),

Line 687: p_text => substr(fnd_message.get,1,500),

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);
689: end if;
690: end loop;
691:

Line 695: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');

691:
692: /* bug#2811687 : begin */
693: for l_inv_row in c_supply_types_invalid_rows loop
694: l_error_exists := true;
695: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
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),

Line 696: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

692: /* bug#2811687 : begin */
693: for l_inv_row in c_supply_types_invalid_rows loop
694: l_error_exists := true;
695: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
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);

Line 699: p_text => substr(fnd_message.get,1,500),

695: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUPPLY_TYPE');
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),

Line 703: p_text => substr(fnd_message.get,1,500),

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);
705: end if;
706: end loop;
707:

Line 710: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');

706: end loop;
707:
708: for l_inv_row in c_mrp_net_flag_invalid_rows loop
709: l_error_exists := true;
710: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
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),

Line 711: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

707:
708: for l_inv_row in c_mrp_net_flag_invalid_rows loop
709: l_error_exists := true;
710: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
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);

Line 714: p_text => substr(fnd_message.get,1,500),

710: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_MRP_NET_FLAG');
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),

Line 718: p_text => substr(fnd_message.get,1,500),

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);
720: end if;
721: end loop;
722:

Line 725: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');

721: end loop;
722:
723: for l_inv_row in c_auto_req_mat_invalid_rows loop
724: l_error_exists := true;
725: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
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),

Line 726: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

722:
723: for l_inv_row in c_auto_req_mat_invalid_rows loop
724: l_error_exists := true;
725: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
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);

Line 729: p_text => substr(fnd_message.get,1,500),

725: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_AUTO_REQ_MAT');
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),

Line 733: p_text => substr(fnd_message.get,1,500),

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);
735: end if;
736: end loop;
737: /* bug#2811687 : end */

Line 742: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');

738:
739: l_profile_value := fnd_profile.value('WIP_SEE_ENG_ITEMS');
740: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
741: l_error_exists := true ;
742: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');
743: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
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,

Line 743: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));

739: l_profile_value := fnd_profile.value('WIP_SEE_ENG_ITEMS');
740: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
741: l_error_exists := true ;
742: fnd_message.set_name('WIP','WIP_JDI_DIRECT_ITEM');
743: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
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),

Line 747: p_text => substr(fnd_message.get,1,500),

743: fnd_message.set_token('INTERFACE',to_char(l_inv_row.interface_id));
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,

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

Line 830: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');

826: begin
827:
828: for l_inv_row in c_supply_types_invalid_rows loop
829: l_error_exists := true;
830: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
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),

Line 831: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

827:
828: for l_inv_row in c_supply_types_invalid_rows loop
829: l_error_exists := true;
830: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
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);

Line 834: p_text => substr(fnd_message.get,1,500),

830: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SUP_TYPE_NO_OP');
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),

Line 838: p_text => substr(fnd_message.get,1,500),

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);
840: end if;
841:
842: update wip_job_dtls_interface wjdi

Line 1012: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');

1008: -- Only do this validation when ADD/CHANGE Requirements
1009:
1010: for l_inv_row in c_invalid_rows loop
1011: l_error_exists := true;
1012: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
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),

Line 1013: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1009:
1010: for l_inv_row in c_invalid_rows loop
1011: l_error_exists := true;
1012: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
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);

Line 1016: p_text => substr(fnd_message.get,1,500),

1012: fnd_message.set_name('WIP', 'WIP_JDI_NULL_SUPPLY_TYPE');
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),

Line 1020: p_text => substr(fnd_message.get,1,500),

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);
1022: end if;
1023: end loop;
1024:

Line 1089: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');

1085: -- Only do this validation when ADD/CHANGE Requirements
1086:
1087: for l_inv_row in c_invalid_rows loop
1088: l_error_exists := true;
1089: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
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),

Line 1090: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1086:
1087: for l_inv_row in c_invalid_rows loop
1088: l_error_exists := true;
1089: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
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);

Line 1093: p_text => substr(fnd_message.get,1,500),

1089: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_REQ_INFO_MISSING');
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),

Line 1097: p_text => substr(fnd_message.get,1,500),

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);
1099: end if;
1100: end loop;
1101: