DBA Data[Home] [Help]

APPS.WIP_SERIAL_ASSOC_VALIDATIONS dependencies on FND_MESSAGE

Line 221: fnd_message.set_name('WIP', 'WIP_JDI_OLD_SERIAL_MISSING');

217: begin
218: x_return_status := fnd_api.g_ret_sts_success;
219: for l_inv_row in c_invalid_rows loop
220: x_return_status := fnd_api.g_ret_sts_error;
221: fnd_message.set_name('WIP', 'WIP_JDI_OLD_SERIAL_MISSING');
222: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
223: if(wip_job_details.std_alone = 1) then
224: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
225: p_text => substr(fnd_message.get,1,500),

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

218: x_return_status := fnd_api.g_ret_sts_success;
219: for l_inv_row in c_invalid_rows loop
220: x_return_status := fnd_api.g_ret_sts_error;
221: fnd_message.set_name('WIP', 'WIP_JDI_OLD_SERIAL_MISSING');
222: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
223: if(wip_job_details.std_alone = 1) then
224: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
225: p_text => substr(fnd_message.get,1,500),
226: p_error_type => wip_jdi_utils.msg_error);

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

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

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

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

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

295: x_err_msg => l_error_msg);
296:
297: if(l_return_status <> fnd_api.g_ret_sts_success) then
298: x_return_status := fnd_api.g_ret_sts_error;
299: fnd_message.set_name('WIP', 'WIP_JDI_SER_CREATION_FAILED');
300: fnd_message.set_token('INTERFACE', l_ser_rec.interface_id);
301: fnd_message.set_token('MESSAGE', l_error_msg);
302: if(wip_job_details.std_alone = 1) then
303: wip_interface_err_Utils.add_error(p_interface_id => l_ser_rec.interface_id,

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

296:
297: if(l_return_status <> fnd_api.g_ret_sts_success) then
298: x_return_status := fnd_api.g_ret_sts_error;
299: fnd_message.set_name('WIP', 'WIP_JDI_SER_CREATION_FAILED');
300: fnd_message.set_token('INTERFACE', l_ser_rec.interface_id);
301: fnd_message.set_token('MESSAGE', l_error_msg);
302: if(wip_job_details.std_alone = 1) then
303: wip_interface_err_Utils.add_error(p_interface_id => l_ser_rec.interface_id,
304: p_text => substr(fnd_message.get,1,500),

Line 301: fnd_message.set_token('MESSAGE', l_error_msg);

297: if(l_return_status <> fnd_api.g_ret_sts_success) then
298: x_return_status := fnd_api.g_ret_sts_error;
299: fnd_message.set_name('WIP', 'WIP_JDI_SER_CREATION_FAILED');
300: fnd_message.set_token('INTERFACE', l_ser_rec.interface_id);
301: fnd_message.set_token('MESSAGE', l_error_msg);
302: if(wip_job_details.std_alone = 1) then
303: wip_interface_err_Utils.add_error(p_interface_id => l_ser_rec.interface_id,
304: p_text => substr(fnd_message.get,1,500),
305: p_error_type => wip_jdi_utils.msg_error);

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

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

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

304: p_text => substr(fnd_message.get,1,500),
305: p_error_type => wip_jdi_utils.msg_error);
306: else
307: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
308: p_text => substr(fnd_message.get,1,500),
309: p_error_type => wip_jdi_utils.msg_error);
310: end if;
311: update wip_job_dtls_interface wjdi
312: set process_status = wip_constants.error

Line 341: fnd_message.set_name('WIP', 'WIP_JDI_NEW_SERIAL_MISSING');

337: begin
338: x_return_status := fnd_api.g_ret_sts_success;
339: for l_inv_row in c_invalid_rows loop
340: x_return_status := fnd_api.g_ret_sts_error;
341: fnd_message.set_name('WIP', 'WIP_JDI_NEW_SERIAL_MISSING');
342: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
343: if(wip_job_details.std_alone = 1) then
344: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
345: p_text => substr(fnd_message.get,1,500),

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

338: x_return_status := fnd_api.g_ret_sts_success;
339: for l_inv_row in c_invalid_rows loop
340: x_return_status := fnd_api.g_ret_sts_error;
341: fnd_message.set_name('WIP', 'WIP_JDI_NEW_SERIAL_MISSING');
342: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
343: if(wip_job_details.std_alone = 1) then
344: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
345: p_text => substr(fnd_message.get,1,500),
346: p_error_type => wip_jdi_utils.msg_error);

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

341: fnd_message.set_name('WIP', 'WIP_JDI_NEW_SERIAL_MISSING');
342: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
343: if(wip_job_details.std_alone = 1) then
344: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
345: p_text => substr(fnd_message.get,1,500),
346: p_error_type => wip_jdi_utils.msg_error);
347: else
348: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
349: p_text => substr(fnd_message.get,1,500),

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

345: p_text => substr(fnd_message.get,1,500),
346: p_error_type => wip_jdi_utils.msg_error);
347: else
348: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
349: p_text => substr(fnd_message.get,1,500),
350: p_error_type => wip_jdi_utils.msg_error);
351: end if;
352: end loop;
353:

Line 401: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_UNUSED_SERIAL');

397: begin
398: x_return_status := fnd_api.g_ret_sts_success;
399: for l_inv_row in c_invalid_rows loop
400: x_return_status := fnd_api.g_ret_sts_error;
401: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_UNUSED_SERIAL');
402: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
403: if(wip_job_details.std_alone = 1) then
404: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
405: p_text => substr(fnd_message.get,1,500),

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

398: x_return_status := fnd_api.g_ret_sts_success;
399: for l_inv_row in c_invalid_rows loop
400: x_return_status := fnd_api.g_ret_sts_error;
401: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_UNUSED_SERIAL');
402: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
403: if(wip_job_details.std_alone = 1) then
404: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
405: p_text => substr(fnd_message.get,1,500),
406: p_error_type => wip_jdi_utils.msg_error);

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

401: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_UNUSED_SERIAL');
402: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
403: if(wip_job_details.std_alone = 1) then
404: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
405: p_text => substr(fnd_message.get,1,500),
406: p_error_type => wip_jdi_utils.msg_error);
407: else
408: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
409: p_text => substr(fnd_message.get,1,500),

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

405: p_text => substr(fnd_message.get,1,500),
406: p_error_type => wip_jdi_utils.msg_error);
407: else
408: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
409: p_text => substr(fnd_message.get,1,500),
410: p_error_type => wip_jdi_utils.msg_error);
411: end if;
412: end loop;
413:

Line 472: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_USED_SERIAL');

468: begin
469: x_return_status := fnd_api.g_ret_sts_success;
470: for l_inv_row in c_invalid_rows loop
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_USED_SERIAL');
473: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
474: if(wip_job_details.std_alone = 1) then
475: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
476: p_text => substr(fnd_message.get,1,500),

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

469: x_return_status := fnd_api.g_ret_sts_success;
470: for l_inv_row in c_invalid_rows loop
471: x_return_status := fnd_api.g_ret_sts_error;
472: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_USED_SERIAL');
473: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
474: if(wip_job_details.std_alone = 1) then
475: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
476: p_text => substr(fnd_message.get,1,500),
477: p_error_type => wip_jdi_utils.msg_error);

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

472: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_USED_SERIAL');
473: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
474: if(wip_job_details.std_alone = 1) then
475: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
476: p_text => substr(fnd_message.get,1,500),
477: p_error_type => wip_jdi_utils.msg_error);
478: else
479: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
480: p_text => substr(fnd_message.get,1,500),

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

476: p_text => substr(fnd_message.get,1,500),
477: p_error_type => wip_jdi_utils.msg_error);
478: else
479: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
480: p_text => substr(fnd_message.get,1,500),
481: p_error_type => wip_jdi_utils.msg_error);
482: end if;
483: end loop;
484:

Line 540: fnd_message.set_name('WIP', 'WIP_JDI_SER_INV_LOAD_TYPE');

536: begin
537: x_return_status := fnd_api.g_ret_sts_success;
538: for l_inv_row in c_invalid_rows loop
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('WIP', 'WIP_JDI_SER_INV_LOAD_TYPE');
541: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
542: if(wip_job_details.std_alone = 1) then
543: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
544: p_text => substr(fnd_message.get,1,500),

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

537: x_return_status := fnd_api.g_ret_sts_success;
538: for l_inv_row in c_invalid_rows loop
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('WIP', 'WIP_JDI_SER_INV_LOAD_TYPE');
541: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
542: if(wip_job_details.std_alone = 1) then
543: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
544: p_text => substr(fnd_message.get,1,500),
545: p_error_type => wip_jdi_utils.msg_error);

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

540: fnd_message.set_name('WIP', 'WIP_JDI_SER_INV_LOAD_TYPE');
541: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
542: if(wip_job_details.std_alone = 1) then
543: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
544: p_text => substr(fnd_message.get,1,500),
545: p_error_type => wip_jdi_utils.msg_error);
546: else
547: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
548: p_text => substr(fnd_message.get,1,500),

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

544: p_text => substr(fnd_message.get,1,500),
545: p_error_type => wip_jdi_utils.msg_error);
546: else
547: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
548: p_text => substr(fnd_message.get,1,500),
549: p_error_type => wip_jdi_utils.msg_error);
550: end if;
551: end loop;
552:

Line 607: fnd_message.set_name('WIP', 'WIP_JDI_SER_JOB_STATUS');

603: begin
604: x_return_status := fnd_api.g_ret_sts_success;
605: for l_inv_row in c_invalid_rows loop
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name('WIP', 'WIP_JDI_SER_JOB_STATUS');
608: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
609: if(wip_job_details.std_alone = 1) then
610: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
611: p_text => substr(fnd_message.get,1,500),

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

604: x_return_status := fnd_api.g_ret_sts_success;
605: for l_inv_row in c_invalid_rows loop
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name('WIP', 'WIP_JDI_SER_JOB_STATUS');
608: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
609: if(wip_job_details.std_alone = 1) then
610: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
611: p_text => substr(fnd_message.get,1,500),
612: p_error_type => wip_jdi_utils.msg_error);

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

607: fnd_message.set_name('WIP', 'WIP_JDI_SER_JOB_STATUS');
608: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
609: if(wip_job_details.std_alone = 1) then
610: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
611: p_text => substr(fnd_message.get,1,500),
612: p_error_type => wip_jdi_utils.msg_error);
613: else
614: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
615: p_text => substr(fnd_message.get,1,500),

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

611: p_text => substr(fnd_message.get,1,500),
612: p_error_type => wip_jdi_utils.msg_error);
613: else
614: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
615: p_text => substr(fnd_message.get,1,500),
616: p_error_type => wip_jdi_utils.msg_error);
617: end if;
618: end loop;
619: