DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_VALIDATIONS dependencies on FND_MESSAGE

Line 47: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');

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

Line 48: fnd_message.set_token('INTERFACE', to_char(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),
52: p_error_type => wip_jdi_utils.msg_error);

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

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

Line 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:

Line 123: fnd_message.set_name('WIP', 'WIP_JOB_INVALID_STATUS');

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

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

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;

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

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:

Line 176: fnd_message.set_name('WIP', 'WIP_JOB_FIRMED');

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

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

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;

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

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:

Line 321: fnd_message.set_name('WIP', 'WIP_OP_NOT_FOUND');

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

Line 322: fnd_message.set_token('INTERFACE', to_char(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),
326: p_error_type => wip_jdi_utils.msg_error);

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

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

Line 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:

Line 414: fnd_message.set_name('WIP', 'WIP_INVALID_LOAD_SUB_TYPE');

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

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

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

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

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

Line 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:

Line 469: fnd_message.set_name('WIP', 'WIP_ML_LAST_UPDATED_BY');

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

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

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

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

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

Line 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:

Line 524: fnd_message.set_name('WIP', 'WIP_ML_CREATED_BY');

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

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

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

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

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

Line 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:

Line 584: fnd_message.set_name('WIP', 'WIP_JDI_OTHERS_FAILED');

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

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

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;

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

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