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

218: begin
219:
220: for l_inv_row in c_invalid_wro_rows loop
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),

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

219:
220: for l_inv_row in c_invalid_wro_rows loop
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);

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

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

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

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

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

256: end if;
257:
258: for l_inv_row in c_invalid_mmtt_rows loop
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),

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

257:
258: for l_inv_row in c_invalid_mmtt_rows loop
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);

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

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

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

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

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

293: end if;
294:
295: for l_inv_row in c_invalid_mmt_rows loop
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),

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

294:
295: for l_inv_row in c_invalid_mmt_rows loop
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);

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

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

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

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

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

432: begin
433:
434: for l_inv_row in c_invalid_rows loop
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),

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

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

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

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

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

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

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

508: begin
509:
510: for l_inv_row in c_invalid_rows loop
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),

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

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

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

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

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

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

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

673: begin
674:
675: for l_inv_row in c_invalid_rows loop
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),

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

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

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

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

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

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

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

689:
690: /* bug#2811687 : begin */
691: for l_inv_row in c_supply_types_invalid_rows loop
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),

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

690: /* bug#2811687 : begin */
691: for l_inv_row in c_supply_types_invalid_rows loop
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);

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

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

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

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

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

704: end loop;
705:
706: for l_inv_row in c_mrp_net_flag_invalid_rows loop
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),

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

705:
706: for l_inv_row in c_mrp_net_flag_invalid_rows loop
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);

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

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

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

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

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

719: end loop;
720:
721: for l_inv_row in c_auto_req_mat_invalid_rows loop
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),

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

720:
721: for l_inv_row in c_auto_req_mat_invalid_rows loop
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);

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

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

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

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;
735: /* bug#2811687 : end */

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

736:
737: l_profile_value := fnd_profile.value('WIP_SEE_ENG_ITEMS');
738: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
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,

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

737: l_profile_value := fnd_profile.value('WIP_SEE_ENG_ITEMS');
738: for l_inv_row in c_direct_item_rows ( l_profile_value ) loop
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),

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

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
748: wip_interface_err_utils.add_error (
749: p_interface_id => wip_jsi_utils.current_interface_id,

Line 750: 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 ;
753: end loop;
754:

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

824: begin
825:
826: for l_inv_row in c_supply_types_invalid_rows loop
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),

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

825:
826: for l_inv_row in c_supply_types_invalid_rows loop
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);

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

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

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

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:
840: update wip_job_dtls_interface wjdi

Line 1044: fnd_message.set_name('WIP', error_tbl(indx).error_msg);

1040: NULL;
1041: END LOOP;
1042: IF error_tbl.COUNT>0 THEN
1043: for indx in error_tbl.first..error_tbl.last loop
1044: fnd_message.set_name('WIP', error_tbl(indx).error_msg);
1045: fnd_message.set_token('INTERFACE', to_char(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);

Line 1045: fnd_message.set_token('INTERFACE', to_char(error_tbl(indx).interface_id));

1041: END LOOP;
1042: IF error_tbl.COUNT>0 THEN
1043: for indx in error_tbl.first..error_tbl.last loop
1044: fnd_message.set_name('WIP', error_tbl(indx).error_msg);
1045: fnd_message.set_token('INTERFACE', to_char(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);

Line 1046: fnd_message.set_token('ITEM_ID', to_char(error_tbl(indx).inventory_item_id));

1042: IF error_tbl.COUNT>0 THEN
1043: for indx in error_tbl.first..error_tbl.last loop
1044: fnd_message.set_name('WIP', error_tbl(indx).error_msg);
1045: fnd_message.set_token('INTERFACE', to_char(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,

Line 1049: fnd_message.set_token('SUBINV', error_tbl(indx).supply_subinventory);

1045: fnd_message.set_token('INTERFACE', to_char(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

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

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
1055: where interface_id = error_tbl(indx).interface_id;

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

1230: -- Only do this validation when ADD/CHANGE Requirements
1231:
1232: for l_inv_row in c_invalid_rows loop
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),

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

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

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

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

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

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

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

1307: -- Only do this validation when ADD/CHANGE Requirements
1308:
1309: for l_inv_row in c_invalid_rows loop
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),

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

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

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

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

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

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