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),
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);
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),
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:
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,
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),
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);
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),
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
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),
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);
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),
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:
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),
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);
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),
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:
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),
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);
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),
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:
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),
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);
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),
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:
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),
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);
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),
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: