130: l_error_exists boolean := false;
131: begin
132: for l_inv_row in c_invalid_rows loop
133: l_error_exists := true;
134: fnd_message.set_name('WIP', 'WIP_NOT_NULL_VAL_LACK');
135: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
136: if(wip_job_details.std_alone = 1) then
137: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
138: p_text => substr(fnd_message.get,1,500),
131: begin
132: for l_inv_row in c_invalid_rows loop
133: l_error_exists := true;
134: fnd_message.set_name('WIP', 'WIP_NOT_NULL_VAL_LACK');
135: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
136: if(wip_job_details.std_alone = 1) then
137: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);
134: fnd_message.set_name('WIP', 'WIP_NOT_NULL_VAL_LACK');
135: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
136: if(wip_job_details.std_alone = 1) then
137: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);
140: else
141: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
142: p_text => substr(fnd_message.get,1,500),
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);
140: else
141: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
142: p_text => substr(fnd_message.get,1,500),
143: p_error_type => wip_jdi_utils.msg_error);
144: end if;
145: end loop;
146:
192: l_error_exists boolean := false;
193: begin
194: for l_inv_row in c_invalid_rows loop
195: l_error_exists := true;
196: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');
197: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
198: if(wip_job_details.std_alone = 1) then
199: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
200: p_text => substr(fnd_message.get,1,500),
193: begin
194: for l_inv_row in c_invalid_rows loop
195: l_error_exists := true;
196: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');
197: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
198: if(wip_job_details.std_alone = 1) then
199: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
200: p_text => substr(fnd_message.get,1,500),
201: p_error_type => wip_jdi_utils.msg_error);
196: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');
197: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
198: if(wip_job_details.std_alone = 1) then
199: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
200: p_text => substr(fnd_message.get,1,500),
201: p_error_type => wip_jdi_utils.msg_error);
202: else
203: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
204: p_text => substr(fnd_message.get,1,500),
200: p_text => substr(fnd_message.get,1,500),
201: p_error_type => wip_jdi_utils.msg_error);
202: else
203: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
204: p_text => substr(fnd_message.get,1,500),
205: p_error_type => wip_jdi_utils.msg_error);
206: end if;
207: end loop;
208:
270: begin
271:
272: for l_inv_row in c_invalid_rows loop
273: l_error_exists := true;
274: fnd_message.set_name('WIP', 'WIP_INV_START_OR_END');
275: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
276: if(wip_job_details.std_alone = 1) then
277: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
278: p_text => substr(fnd_message.get,1,500),
271:
272: for l_inv_row in c_invalid_rows loop
273: l_error_exists := true;
274: fnd_message.set_name('WIP', 'WIP_INV_START_OR_END');
275: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
276: if(wip_job_details.std_alone = 1) then
277: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
278: p_text => substr(fnd_message.get,1,500),
279: p_error_type => wip_jdi_utils.msg_error);
274: fnd_message.set_name('WIP', 'WIP_INV_START_OR_END');
275: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
276: if(wip_job_details.std_alone = 1) then
277: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
278: p_text => substr(fnd_message.get,1,500),
279: p_error_type => wip_jdi_utils.msg_error);
280: else
281: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
282: p_text => substr(fnd_message.get,1,500),
278: p_text => substr(fnd_message.get,1,500),
279: p_error_type => wip_jdi_utils.msg_error);
280: else
281: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
282: p_text => substr(fnd_message.get,1,500),
283: p_error_type => wip_jdi_utils.msg_error);
284: end if;
285:
286: end loop;
337: begin
338:
339: for l_inv_row in c_invalid_rows loop
340: l_error_exists := true;
341: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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:
339: for l_inv_row in c_invalid_rows loop
340: l_error_exists := true;
341: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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_INV_ASSIGNED_UNITS');
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:
396: begin
397:
398: for l_inv_row in c_invalid_res_inst_usage_rows loop
399: l_error_exists := true;
400: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
401: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
402: if(wip_job_details.std_alone = 1) then
403: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
404: p_text => substr(fnd_message.get,1,500),
397:
398: for l_inv_row in c_invalid_res_inst_usage_rows loop
399: l_error_exists := true;
400: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
401: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
402: if(wip_job_details.std_alone = 1) then
403: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
404: p_text => substr(fnd_message.get,1,500),
405: p_error_type => wip_jdi_utils.msg_error);
400: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
401: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
402: if(wip_job_details.std_alone = 1) then
403: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
404: p_text => substr(fnd_message.get,1,500),
405: p_error_type => wip_jdi_utils.msg_error);
406: else
407: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
408: p_text => substr(fnd_message.get,1,500),
404: p_text => substr(fnd_message.get,1,500),
405: p_error_type => wip_jdi_utils.msg_error);
406: else
407: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
408: p_text => substr(fnd_message.get,1,500),
409: p_error_type => wip_jdi_utils.msg_error);
410: end if;
411: end loop;
412:
464: begin
465:
466: for l_inv_row in c_invalid_res_usage_rows loop
467: l_error_exists := true;
468: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
469: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
470: if(wip_job_details.std_alone = 1) then
471: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
472: p_text => substr(fnd_message.get,1,500),
465:
466: for l_inv_row in c_invalid_res_usage_rows loop
467: l_error_exists := true;
468: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
469: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
470: if(wip_job_details.std_alone = 1) then
471: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
472: p_text => substr(fnd_message.get,1,500),
473: p_error_type => wip_jdi_utils.msg_error);
468: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');
469: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
470: if(wip_job_details.std_alone = 1) then
471: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
472: p_text => substr(fnd_message.get,1,500),
473: p_error_type => wip_jdi_utils.msg_error);
474: else
475: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
476: p_text => substr(fnd_message.get,1,500),
472: p_text => substr(fnd_message.get,1,500),
473: p_error_type => wip_jdi_utils.msg_error);
474: else
475: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
476: p_text => substr(fnd_message.get,1,500),
477: p_error_type => wip_jdi_utils.msg_error);
478: end if;
479: end loop;
480:
548: l_error_exists boolean := false;
549: begin
550: for l_inv_row in c_invalid_rows loop
551: l_error_exists := true;
552: fnd_message.set_name('WIP', 'WIP_DATE_NOT_MATCH');
553: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
554: if(wip_job_details.std_alone = 1) then
555: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
556: p_text => substr(fnd_message.get,1,500),
549: begin
550: for l_inv_row in c_invalid_rows loop
551: l_error_exists := true;
552: fnd_message.set_name('WIP', 'WIP_DATE_NOT_MATCH');
553: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
554: if(wip_job_details.std_alone = 1) then
555: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
556: p_text => substr(fnd_message.get,1,500),
557: p_error_type => wip_jdi_utils.msg_error);
552: fnd_message.set_name('WIP', 'WIP_DATE_NOT_MATCH');
553: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
554: if(wip_job_details.std_alone = 1) then
555: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
556: p_text => substr(fnd_message.get,1,500),
557: p_error_type => wip_jdi_utils.msg_error);
558: else
559: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
560: p_text => substr(fnd_message.get,1,500),
556: p_text => substr(fnd_message.get,1,500),
557: p_error_type => wip_jdi_utils.msg_error);
558: else
559: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
560: p_text => substr(fnd_message.get,1,500),
561: p_error_type => wip_jdi_utils.msg_error);
562: end if;
563: end loop;
564: