DBA Data[Home] [Help]

APPS.WIP_RES_USAGE_VALIDATE dependencies on FND_MESSAGE

Line 134: fnd_message.set_name('WIP', 'WIP_NOT_NULL_VAL_LACK');

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

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

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

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

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

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

Line 196: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');

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

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

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

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

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

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

Line 274: fnd_message.set_name('WIP', 'WIP_INV_START_OR_END');

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

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

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

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

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

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

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

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

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

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

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

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

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 400: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');

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

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

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

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

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

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

Line 468: fnd_message.set_name('WIP', 'WIP_TIME_OVERLAPPED');

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

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

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

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

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

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

Line 552: fnd_message.set_name('WIP', 'WIP_DATE_NOT_MATCH');

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

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

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

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

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

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