DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on FND_MESSAGE

Line 172: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');

168:
169:
170: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
171: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
172: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
173: fnd_file.put_line(fnd_file.log, fnd_message.get);
174:
175: return;
176: ELSE

Line 173: fnd_file.put_line(fnd_file.log, fnd_message.get);

169:
170: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
171: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
172: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
173: fnd_file.put_line(fnd_file.log, fnd_message.get);
174:
175: return;
176: ELSE
177: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove

Line 199: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');

195: AND ((p_cancelled_jobs = 2) OR (p_cancelled_jobs IS NULL)) -- No
196: -- Added to fix bug #3483253 --
197: THEN
198: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
199: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
200: fnd_file.put_line(fnd_file.log, fnd_message.get);
201:
202: return;
203: END IF;

Line 200: fnd_file.put_line(fnd_file.log, fnd_message.get);

196: -- Added to fix bug #3483253 --
197: THEN
198: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
199: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
200: fnd_file.put_line(fnd_file.log, fnd_message.get);
201:
202: return;
203: END IF;
204:

Line 230: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');

226:
227: IF (p_refresh_all_open_jobs = 1) -- Yes
228: THEN
229: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
230: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
231: fnd_file.put_line(fnd_file.log, fnd_message.get);
232:
233: -- Set parameters to their default values
234: l_from_job_name := NULL;

Line 231: fnd_file.put_line(fnd_file.log, fnd_message.get);

227: IF (p_refresh_all_open_jobs = 1) -- Yes
228: THEN
229: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
230: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
231: fnd_file.put_line(fnd_file.log, fnd_message.get);
232:
233: -- Set parameters to their default values
234: l_from_job_name := NULL;
235: l_to_job_name := NULL;

Line 268: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

264: AND nvl(alternate_bom_designator, '-1') =
265: nvl(l_alt_bom_designator, '-1');
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
269: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271: return;
272:

Line 269: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');

265: nvl(l_alt_bom_designator, '-1');
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
269: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271: return;
272:
273: WHEN OTHERS THEN

Line 270: fnd_file.put_line(fnd_file.log, fnd_message.get);

266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
269: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271: return;
272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

Line 274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271: return;
272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
275: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
276: fnd_file.put_line(fnd_file.log, fnd_message.get);
277: return;
278: END;

Line 275: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');

271: return;
272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
275: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
276: fnd_file.put_line(fnd_file.log, fnd_message.get);
277: return;
278: END;
279: END IF;

Line 276: fnd_file.put_line(fnd_file.log, fnd_message.get);

272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
275: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
276: fnd_file.put_line(fnd_file.log, fnd_message.get);
277: return;
278: END;
279: END IF;
280:

Line 295: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

291: AND nvl(alternate_routing_designator, '-1') =
292: nvl(l_alt_rtg_designator, '-1');
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
296: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
297: fnd_file.put_line(fnd_file.log, fnd_message.get);
298: return;
299:

Line 296: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');

292: nvl(l_alt_rtg_designator, '-1');
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
296: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
297: fnd_file.put_line(fnd_file.log, fnd_message.get);
298: return;
299:
300: WHEN OTHERS THEN

Line 297: fnd_file.put_line(fnd_file.log, fnd_message.get);

293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
296: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
297: fnd_file.put_line(fnd_file.log, fnd_message.get);
298: return;
299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

Line 301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

297: fnd_file.put_line(fnd_file.log, fnd_message.get);
298: return;
299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
302: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
303: fnd_file.put_line(fnd_file.log, fnd_message.get);
304: return;
305: END;

Line 302: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');

298: return;
299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
302: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
303: fnd_file.put_line(fnd_file.log, fnd_message.get);
304: return;
305: END;
306: END IF;

Line 303: fnd_file.put_line(fnd_file.log, fnd_message.get);

299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
302: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
303: fnd_file.put_line(fnd_file.log, fnd_message.get);
304: return;
305: END;
306: END IF;
307:

Line 600: fnd_message.set_name('WSM', 'WSM_JOB_LIST');

596: END IF;
597: IF (x_err_code = 0) OR (x_err_code IS NULL)THEN
598: l_stmt_num := 90;
599: --"Organization: ORG_NAME Job: JOB_NAME"
600: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
601: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
602: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
603: '('||cur_refresh_jobs.wip_entity_id||')');
604: l_msg := fnd_message.get;

Line 601: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);

597: IF (x_err_code = 0) OR (x_err_code IS NULL)THEN
598: l_stmt_num := 90;
599: --"Organization: ORG_NAME Job: JOB_NAME"
600: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
601: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
602: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
603: '('||cur_refresh_jobs.wip_entity_id||')');
604: l_msg := fnd_message.get;
605:

Line 602: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||

598: l_stmt_num := 90;
599: --"Organization: ORG_NAME Job: JOB_NAME"
600: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
601: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
602: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
603: '('||cur_refresh_jobs.wip_entity_id||')');
604: l_msg := fnd_message.get;
605:
606: --"Job Copies STATUS Refreshed."

Line 604: l_msg := fnd_message.get;

600: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
601: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
602: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
603: '('||cur_refresh_jobs.wip_entity_id||')');
604: l_msg := fnd_message.get;
605:
606: --"Job Copies STATUS Refreshed."
607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
608: fnd_message.set_token('STATUS', NULL);

Line 607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');

603: '('||cur_refresh_jobs.wip_entity_id||')');
604: l_msg := fnd_message.get;
605:
606: --"Job Copies STATUS Refreshed."
607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
608: fnd_message.set_token('STATUS', NULL);
609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
610: );
611:

Line 608: fnd_message.set_token('STATUS', NULL);

604: l_msg := fnd_message.get;
605:
606: --"Job Copies STATUS Refreshed."
607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
608: fnd_message.set_token('STATUS', NULL);
609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
610: );
611:
612: commit; -- Added to fix bug #3465125

Line 609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get

605:
606: --"Job Copies STATUS Refreshed."
607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
608: fnd_message.set_token('STATUS', NULL);
609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
610: );
611:
612: commit; -- Added to fix bug #3465125
613:

Line 617: fnd_message.set_name('WSM', 'WSM_JOB_LIST');

613:
614: ELSIF (x_err_code = -1) THEN -- Warning
615: l_stmt_num := 100;
616: --"Organization: ORG_NAME Job: JOB_NAME"
617: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
618: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
619: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
620: '('||cur_refresh_jobs.wip_entity_id||')');
621: l_msg := fnd_message.get;

Line 618: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);

614: ELSIF (x_err_code = -1) THEN -- Warning
615: l_stmt_num := 100;
616: --"Organization: ORG_NAME Job: JOB_NAME"
617: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
618: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
619: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
620: '('||cur_refresh_jobs.wip_entity_id||')');
621: l_msg := fnd_message.get;
622:

Line 619: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||

615: l_stmt_num := 100;
616: --"Organization: ORG_NAME Job: JOB_NAME"
617: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
618: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
619: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
620: '('||cur_refresh_jobs.wip_entity_id||')');
621: l_msg := fnd_message.get;
622:
623: --"Job Copies STATUS Refreshed."

Line 621: l_msg := fnd_message.get;

617: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
618: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
619: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
620: '('||cur_refresh_jobs.wip_entity_id||')');
621: l_msg := fnd_message.get;
622:
623: --"Job Copies STATUS Refreshed."
624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
625: fnd_message.set_token('STATUS', NULL);

Line 624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');

620: '('||cur_refresh_jobs.wip_entity_id||')');
621: l_msg := fnd_message.get;
622:
623: --"Job Copies STATUS Refreshed."
624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
625: fnd_message.set_token('STATUS', NULL);
626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
627: );
628:

Line 625: fnd_message.set_token('STATUS', NULL);

621: l_msg := fnd_message.get;
622:
623: --"Job Copies STATUS Refreshed."
624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
625: fnd_message.set_token('STATUS', NULL);
626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
627: );
628:
629: commit; -- Added to fix bug #3465125

Line 626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf

622:
623: --"Job Copies STATUS Refreshed."
624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
625: fnd_message.set_token('STATUS', NULL);
626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
627: );
628:
629: commit; -- Added to fix bug #3465125
630:

Line 634: fnd_message.set_name('WSM', 'WSM_JOB_LIST');

630:
631: ELSE -- Error
632: l_stmt_num := 110;
633: --"Organization: ORG_NAME Job: JOB_NAME"
634: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
635: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
636: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
637: '('||cur_refresh_jobs.wip_entity_id||')');
638: l_msg := fnd_message.get;

Line 635: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);

631: ELSE -- Error
632: l_stmt_num := 110;
633: --"Organization: ORG_NAME Job: JOB_NAME"
634: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
635: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
636: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
637: '('||cur_refresh_jobs.wip_entity_id||')');
638: l_msg := fnd_message.get;
639:

Line 636: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||

632: l_stmt_num := 110;
633: --"Organization: ORG_NAME Job: JOB_NAME"
634: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
635: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
636: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
637: '('||cur_refresh_jobs.wip_entity_id||')');
638: l_msg := fnd_message.get;
639:
640: --"Job Copies STATUS Refreshed."

Line 638: l_msg := fnd_message.get;

634: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
635: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
636: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
637: '('||cur_refresh_jobs.wip_entity_id||')');
638: l_msg := fnd_message.get;
639:
640: --"Job Copies STATUS Refreshed."
641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
642: fnd_message.set_token('STATUS', 'Not');

Line 641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');

637: '('||cur_refresh_jobs.wip_entity_id||')');
638: l_msg := fnd_message.get;
639:
640: --"Job Copies STATUS Refreshed."
641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
642: fnd_message.set_token('STATUS', 'Not');
643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
644: );
645:

Line 642: fnd_message.set_token('STATUS', 'Not');

638: l_msg := fnd_message.get;
639:
640: --"Job Copies STATUS Refreshed."
641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
642: fnd_message.set_token('STATUS', 'Not');
643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
644: );
645:
646: rollback; -- Added to fix bug #3465125

Line 643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf

639:
640: --"Job Copies STATUS Refreshed."
641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
642: fnd_message.set_token('STATUS', 'Not');
643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
644: );
645:
646: rollback; -- Added to fix bug #3465125
647: