DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on FND_MESSAGE

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

155:
156:
157: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
158: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
159: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
160: fnd_file.put_line(fnd_file.log, fnd_message.get);
161:
162: return;
163: ELSE

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

156:
157: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
158: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
159: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
160: fnd_file.put_line(fnd_file.log, fnd_message.get);
161:
162: return;
163: ELSE
164: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove

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

182: AND ((p_cancelled_jobs = 2) OR (p_cancelled_jobs IS NULL)) -- No
183: -- Added to fix bug #3483253 --
184: THEN
185: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
186: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
187: fnd_file.put_line(fnd_file.log, fnd_message.get);
188:
189: return;
190: END IF;

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

183: -- Added to fix bug #3483253 --
184: THEN
185: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
186: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
187: fnd_file.put_line(fnd_file.log, fnd_message.get);
188:
189: return;
190: END IF;
191:

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

213:
214: IF (p_refresh_all_open_jobs = 1) -- Yes
215: THEN
216: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
217: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
218: fnd_file.put_line(fnd_file.log, fnd_message.get);
219:
220: -- Set parameters to their default values
221: l_from_job_name := NULL;

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

214: IF (p_refresh_all_open_jobs = 1) -- Yes
215: THEN
216: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
217: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
218: fnd_file.put_line(fnd_file.log, fnd_message.get);
219:
220: -- Set parameters to their default values
221: l_from_job_name := NULL;
222: l_to_job_name := NULL;

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

251: AND nvl(alternate_bom_designator, '-1') =
252: nvl(l_alt_bom_designator, '-1');
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
256: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
257: fnd_file.put_line(fnd_file.log, fnd_message.get);
258: return;
259:

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

252: nvl(l_alt_bom_designator, '-1');
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
256: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
257: fnd_file.put_line(fnd_file.log, fnd_message.get);
258: return;
259:
260: WHEN OTHERS THEN

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

253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
256: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
257: fnd_file.put_line(fnd_file.log, fnd_message.get);
258: return;
259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

257: fnd_file.put_line(fnd_file.log, fnd_message.get);
258: return;
259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
262: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
263: fnd_file.put_line(fnd_file.log, fnd_message.get);
264: return;
265: END;

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

258: return;
259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
262: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
263: fnd_file.put_line(fnd_file.log, fnd_message.get);
264: return;
265: END;
266: END IF;

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

259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
262: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
263: fnd_file.put_line(fnd_file.log, fnd_message.get);
264: return;
265: END;
266: END IF;
267:

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

278: AND nvl(alternate_routing_designator, '-1') =
279: nvl(l_alt_rtg_designator, '-1');
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
283: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: return;
286:

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

279: nvl(l_alt_rtg_designator, '-1');
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
283: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: return;
286:
287: WHEN OTHERS THEN

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

280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
283: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: return;
286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: return;
286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
289: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
290: fnd_file.put_line(fnd_file.log, fnd_message.get);
291: return;
292: END;

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

285: return;
286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
289: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
290: fnd_file.put_line(fnd_file.log, fnd_message.get);
291: return;
292: END;
293: END IF;

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

286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
289: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
290: fnd_file.put_line(fnd_file.log, fnd_message.get);
291: return;
292: END;
293: END IF;
294:

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

647: END IF;
648: IF (x_err_code = 0) OR (x_err_code IS NULL)THEN
649: l_stmt_num := 90;
650: --"Organization: ORG_NAME Job: JOB_NAME"
651: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
652: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
653: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
654: '('||cur_refresh_jobs.wip_entity_id||')');
655: l_msg := fnd_message.get;

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

648: IF (x_err_code = 0) OR (x_err_code IS NULL)THEN
649: l_stmt_num := 90;
650: --"Organization: ORG_NAME Job: JOB_NAME"
651: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
652: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
653: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
654: '('||cur_refresh_jobs.wip_entity_id||')');
655: l_msg := fnd_message.get;
656:

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

649: l_stmt_num := 90;
650: --"Organization: ORG_NAME Job: JOB_NAME"
651: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
652: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
653: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
654: '('||cur_refresh_jobs.wip_entity_id||')');
655: l_msg := fnd_message.get;
656:
657: --"Job Copies STATUS Refreshed."

Line 655: l_msg := fnd_message.get;

651: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
652: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
653: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
654: '('||cur_refresh_jobs.wip_entity_id||')');
655: l_msg := fnd_message.get;
656:
657: --"Job Copies STATUS Refreshed."
658: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
659: fnd_message.set_token('STATUS', NULL);

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

654: '('||cur_refresh_jobs.wip_entity_id||')');
655: l_msg := fnd_message.get;
656:
657: --"Job Copies STATUS Refreshed."
658: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
659: fnd_message.set_token('STATUS', NULL);
660: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
661: );
662:

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

655: l_msg := fnd_message.get;
656:
657: --"Job Copies STATUS Refreshed."
658: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
659: fnd_message.set_token('STATUS', NULL);
660: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
661: );
662:
663: commit; -- Added to fix bug #3465125

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

656:
657: --"Job Copies STATUS Refreshed."
658: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
659: fnd_message.set_token('STATUS', NULL);
660: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
661: );
662:
663: commit; -- Added to fix bug #3465125
664:

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

664:
665: ELSIF (x_err_code = -1) THEN -- Warning
666: l_stmt_num := 100;
667: --"Organization: ORG_NAME Job: JOB_NAME"
668: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
669: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
670: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
671: '('||cur_refresh_jobs.wip_entity_id||')');
672: l_msg := fnd_message.get;

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

665: ELSIF (x_err_code = -1) THEN -- Warning
666: l_stmt_num := 100;
667: --"Organization: ORG_NAME Job: JOB_NAME"
668: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
669: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
670: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
671: '('||cur_refresh_jobs.wip_entity_id||')');
672: l_msg := fnd_message.get;
673:

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

666: l_stmt_num := 100;
667: --"Organization: ORG_NAME Job: JOB_NAME"
668: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
669: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
670: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
671: '('||cur_refresh_jobs.wip_entity_id||')');
672: l_msg := fnd_message.get;
673:
674: --"Job Copies STATUS Refreshed."

Line 672: l_msg := fnd_message.get;

668: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
669: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
670: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
671: '('||cur_refresh_jobs.wip_entity_id||')');
672: l_msg := fnd_message.get;
673:
674: --"Job Copies STATUS Refreshed."
675: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
676: fnd_message.set_token('STATUS', NULL);

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

671: '('||cur_refresh_jobs.wip_entity_id||')');
672: l_msg := fnd_message.get;
673:
674: --"Job Copies STATUS Refreshed."
675: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
676: fnd_message.set_token('STATUS', NULL);
677: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
678: );
679:

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

672: l_msg := fnd_message.get;
673:
674: --"Job Copies STATUS Refreshed."
675: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
676: fnd_message.set_token('STATUS', NULL);
677: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
678: );
679:
680: commit; -- Added to fix bug #3465125

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

673:
674: --"Job Copies STATUS Refreshed."
675: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
676: fnd_message.set_token('STATUS', NULL);
677: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
678: );
679:
680: commit; -- Added to fix bug #3465125
681:

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

681:
682: ELSE -- Error
683: l_stmt_num := 110;
684: --"Organization: ORG_NAME Job: JOB_NAME"
685: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
686: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
687: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
688: '('||cur_refresh_jobs.wip_entity_id||')');
689: l_msg := fnd_message.get;

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

682: ELSE -- Error
683: l_stmt_num := 110;
684: --"Organization: ORG_NAME Job: JOB_NAME"
685: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
686: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
687: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
688: '('||cur_refresh_jobs.wip_entity_id||')');
689: l_msg := fnd_message.get;
690:

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

683: l_stmt_num := 110;
684: --"Organization: ORG_NAME Job: JOB_NAME"
685: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
686: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
687: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
688: '('||cur_refresh_jobs.wip_entity_id||')');
689: l_msg := fnd_message.get;
690:
691: --"Job Copies STATUS Refreshed."

Line 689: l_msg := fnd_message.get;

685: fnd_message.set_name('WSM', 'WSM_JOB_LIST');
686: fnd_message.set_token('ORG_NAME', cur_refresh_jobs.organization_id);
687: fnd_message.set_token('JOB_NAME', cur_refresh_jobs.wip_entity_name||
688: '('||cur_refresh_jobs.wip_entity_id||')');
689: l_msg := fnd_message.get;
690:
691: --"Job Copies STATUS Refreshed."
692: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
693: fnd_message.set_token('STATUS', 'Not');

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

688: '('||cur_refresh_jobs.wip_entity_id||')');
689: l_msg := fnd_message.get;
690:
691: --"Job Copies STATUS Refreshed."
692: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
693: fnd_message.set_token('STATUS', 'Not');
694: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
695: );
696: -- Modified for 11064947.

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

689: l_msg := fnd_message.get;
690:
691: --"Job Copies STATUS Refreshed."
692: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
693: fnd_message.set_token('STATUS', 'Not');
694: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
695: );
696: -- Modified for 11064947.
697: l_err_count := l_err_count+1;

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

690:
691: --"Job Copies STATUS Refreshed."
692: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
693: fnd_message.set_token('STATUS', 'Not');
694: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
695: );
696: -- Modified for 11064947.
697: l_err_count := l_err_count+1;
698: rollback; -- Added to fix bug #3465125