43: fetch c_wdj_invalid_rows into l_interface_id;
44: exit when c_wdj_invalid_rows%NOTFOUND;
45: end if;
46: l_error_exists := true; --loop executes only for invalid rows!
47: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
48: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
49: if(wip_job_details.std_alone = 1) then
50: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
51: p_text => substr(fnd_message.get,1,500),
44: exit when c_wdj_invalid_rows%NOTFOUND;
45: end if;
46: l_error_exists := true; --loop executes only for invalid rows!
47: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
48: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
49: if(wip_job_details.std_alone = 1) then
50: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
51: p_text => substr(fnd_message.get,1,500),
52: p_error_type => wip_jdi_utils.msg_error);
47: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
48: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
49: if(wip_job_details.std_alone = 1) then
50: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
51: p_text => substr(fnd_message.get,1,500),
52: p_error_type => wip_jdi_utils.msg_error);
53: else
54: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
55: p_text => substr(fnd_message.get,1,500),
51: p_text => substr(fnd_message.get,1,500),
52: p_error_type => wip_jdi_utils.msg_error);
53: else
54: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
55: p_text => substr(fnd_message.get,1,500),
56: p_error_type => wip_jdi_utils.msg_error);
57: end if;
58:
59:
119: -- 6: hold, no charges allowed
120: if(wip_job_details.std_alone = 1) then
121: for l_inv_row in c_ml_invalid_rows loop
122: l_error_exists := true; --loop executes only for invalid rows!
123: fnd_message.set_name('WIP', 'WIP_JOB_INVALID_STATUS');
124: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
125: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
126: p_text => substr(fnd_message.get,1,500),
127: p_error_type => wip_jdi_utils.msg_error);
120: if(wip_job_details.std_alone = 1) then
121: for l_inv_row in c_ml_invalid_rows loop
122: l_error_exists := true; --loop executes only for invalid rows!
123: fnd_message.set_name('WIP', 'WIP_JOB_INVALID_STATUS');
124: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
125: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
126: p_text => substr(fnd_message.get,1,500),
127: p_error_type => wip_jdi_utils.msg_error);
128: end loop;
122: l_error_exists := true; --loop executes only for invalid rows!
123: fnd_message.set_name('WIP', 'WIP_JOB_INVALID_STATUS');
124: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
125: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
126: p_text => substr(fnd_message.get,1,500),
127: p_error_type => wip_jdi_utils.msg_error);
128: end loop;
129: end if;
130:
172: -- If firmed, we can't do any further change
173: if(wip_job_details.std_alone = 1) then
174: for l_inv_row in c_invalid_rows loop
175: l_error_exists := true;
176: fnd_message.set_name('WIP', 'WIP_JOB_FIRMED');
177: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
178: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
179: p_text => substr(fnd_message.get,1,500),
180: p_error_type => wip_jdi_utils.msg_error);
173: if(wip_job_details.std_alone = 1) then
174: for l_inv_row in c_invalid_rows loop
175: l_error_exists := true;
176: fnd_message.set_name('WIP', 'WIP_JOB_FIRMED');
177: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
178: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
179: p_text => substr(fnd_message.get,1,500),
180: p_error_type => wip_jdi_utils.msg_error);
181: end loop;
175: l_error_exists := true;
176: fnd_message.set_name('WIP', 'WIP_JOB_FIRMED');
177: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
178: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
179: p_text => substr(fnd_message.get,1,500),
180: p_error_type => wip_jdi_utils.msg_error);
181: end loop;
182: end if;
183:
317: fetch c_wdj_invalid_rows into l_interface_id;
318: exit when c_wdj_invalid_rows%NOTFOUND;
319: end if;
320: l_error_exists := true; --loop executes only for invalid rows!
321: fnd_message.set_name('WIP', 'WIP_OP_NOT_FOUND');
322: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
323: if(wip_job_details.std_alone = 1) then
324: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
325: p_text => substr(fnd_message.get,1,500),
318: exit when c_wdj_invalid_rows%NOTFOUND;
319: end if;
320: l_error_exists := true; --loop executes only for invalid rows!
321: fnd_message.set_name('WIP', 'WIP_OP_NOT_FOUND');
322: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
323: if(wip_job_details.std_alone = 1) then
324: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
325: p_text => substr(fnd_message.get,1,500),
326: p_error_type => wip_jdi_utils.msg_error);
321: fnd_message.set_name('WIP', 'WIP_OP_NOT_FOUND');
322: fnd_message.set_token('INTERFACE', to_char(l_interface_id));
323: if(wip_job_details.std_alone = 1) then
324: wip_interface_err_Utils.add_error(p_interface_id => l_interface_id,
325: p_text => substr(fnd_message.get,1,500),
326: p_error_type => wip_jdi_utils.msg_error);
327: else
328: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
329: p_text => substr(fnd_message.get,1,500),
325: p_text => substr(fnd_message.get,1,500),
326: p_error_type => wip_jdi_utils.msg_error);
327: else
328: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
329: p_text => substr(fnd_message.get,1,500),
330: p_error_type => wip_jdi_utils.msg_error);
331: end if;
332:
333:
410: l_error_exists boolean := false;
411: begin
412: for l_inv_row in c_invalid_rows loop
413: l_error_exists := true;
414: fnd_message.set_name('WIP', 'WIP_INVALID_LOAD_SUB_TYPE');
415: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
416: if(wip_job_details.std_alone = 1) then
417: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
418: p_text => substr(fnd_message.get,1,500),
411: begin
412: for l_inv_row in c_invalid_rows loop
413: l_error_exists := true;
414: fnd_message.set_name('WIP', 'WIP_INVALID_LOAD_SUB_TYPE');
415: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
416: if(wip_job_details.std_alone = 1) then
417: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
418: p_text => substr(fnd_message.get,1,500),
419: p_error_type => wip_jdi_utils.msg_error);
414: fnd_message.set_name('WIP', 'WIP_INVALID_LOAD_SUB_TYPE');
415: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
416: if(wip_job_details.std_alone = 1) then
417: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
418: p_text => substr(fnd_message.get,1,500),
419: p_error_type => wip_jdi_utils.msg_error);
420: else
421: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
422: p_text => substr(fnd_message.get,1,500),
418: p_text => substr(fnd_message.get,1,500),
419: p_error_type => wip_jdi_utils.msg_error);
420: else
421: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
422: p_text => substr(fnd_message.get,1,500),
423: p_error_type => wip_jdi_utils.msg_error);
424: end if;
425: end loop;
426:
465:
466: -- Give an error if NULL or if not a valid user
467: for l_inv_row in c_invalid_rows loop
468: l_error_exists := true;
469: fnd_message.set_name('WIP', 'WIP_ML_LAST_UPDATED_BY');
470: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
471: if(wip_job_details.std_alone = 1) then
472: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
473: p_text => substr(fnd_message.get,1,500),
466: -- Give an error if NULL or if not a valid user
467: for l_inv_row in c_invalid_rows loop
468: l_error_exists := true;
469: fnd_message.set_name('WIP', 'WIP_ML_LAST_UPDATED_BY');
470: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
471: if(wip_job_details.std_alone = 1) then
472: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
473: p_text => substr(fnd_message.get,1,500),
474: p_error_type => wip_jdi_utils.msg_error);
469: fnd_message.set_name('WIP', 'WIP_ML_LAST_UPDATED_BY');
470: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
471: if(wip_job_details.std_alone = 1) then
472: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
473: p_text => substr(fnd_message.get,1,500),
474: p_error_type => wip_jdi_utils.msg_error);
475: else
476: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
477: p_text => substr(fnd_message.get,1,500),
473: p_text => substr(fnd_message.get,1,500),
474: p_error_type => wip_jdi_utils.msg_error);
475: else
476: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
477: p_text => substr(fnd_message.get,1,500),
478: p_error_type => wip_jdi_utils.msg_error);
479: end if;
480: end loop;
481:
520:
521: -- Give an error if NULL or if not a valid user
522: for l_inv_row in c_invalid_rows loop
523: l_error_exists := true;
524: fnd_message.set_name('WIP', 'WIP_ML_CREATED_BY');
525: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
526: if(wip_job_details.std_alone = 1) then
527: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
528: p_text => substr(fnd_message.get,1,500),
521: -- Give an error if NULL or if not a valid user
522: for l_inv_row in c_invalid_rows loop
523: l_error_exists := true;
524: fnd_message.set_name('WIP', 'WIP_ML_CREATED_BY');
525: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
526: if(wip_job_details.std_alone = 1) then
527: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
528: p_text => substr(fnd_message.get,1,500),
529: p_error_type => wip_jdi_utils.msg_error);
524: fnd_message.set_name('WIP', 'WIP_ML_CREATED_BY');
525: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
526: if(wip_job_details.std_alone = 1) then
527: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
528: p_text => substr(fnd_message.get,1,500),
529: p_error_type => wip_jdi_utils.msg_error);
530: else
531: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
532: p_text => substr(fnd_message.get,1,500),
528: p_text => substr(fnd_message.get,1,500),
529: p_error_type => wip_jdi_utils.msg_error);
530: else
531: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
532: p_text => substr(fnd_message.get,1,500),
533: p_error_type => wip_jdi_utils.msg_error);
534: end if;
535: end loop;
536:
580: l_error_exists boolean := false;
581: begin
582: for l_inv_row in c_invalid_rows loop
583: l_error_exists := true;
584: fnd_message.set_name('WIP', 'WIP_JDI_OTHERS_FAILED');
585: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
586: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
587: p_text => substr(fnd_message.get,1,500),
588: p_error_type => wip_jdi_utils.msg_error);
581: begin
582: for l_inv_row in c_invalid_rows loop
583: l_error_exists := true;
584: fnd_message.set_name('WIP', 'WIP_JDI_OTHERS_FAILED');
585: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
586: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
587: p_text => substr(fnd_message.get,1,500),
588: p_error_type => wip_jdi_utils.msg_error);
589: end loop;
583: l_error_exists := true;
584: fnd_message.set_name('WIP', 'WIP_JDI_OTHERS_FAILED');
585: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
586: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
587: p_text => substr(fnd_message.get,1,500),
588: p_error_type => wip_jdi_utils.msg_error);
589: end loop;
590: if(l_error_exists) then
591: update wip_job_dtls_interface wjdi