DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on FND_MESSAGE

Line 388: fnd_message.set_name('FLM','FLM_SCHED_NO_ACCT_CLOSE_PERIOD');

384: and open_flag = 'N'
385: and period_close_date IS NOT NULL;
386:
387: if (l_account_close_date is null) then
388: fnd_message.set_name('FLM','FLM_SCHED_NO_ACCT_CLOSE_PERIOD');
389: MRP_UTIL.MRP_LOG(fnd_message.get);
390: return;
391: end if;
392:

Line 389: MRP_UTIL.MRP_LOG(fnd_message.get);

385: and period_close_date IS NOT NULL;
386:
387: if (l_account_close_date is null) then
388: fnd_message.set_name('FLM','FLM_SCHED_NO_ACCT_CLOSE_PERIOD');
389: MRP_UTIL.MRP_LOG(fnd_message.get);
390: return;
391: end if;
392:
393: FOR Purge_Rec IN Purge(l_cutoff_date) LOOP --fix bug#3170105

Line 407: fnd_message.set_name('FLM','FLM_SCHED_CLOSED_PERIOD');

403: l_organization_id := Purge_rec.Organization_id;
404: l_auto_replenish := Purge_rec.Auto_Replenish;
405:
406: if (l_completion_date > l_account_close_date) then
407: fnd_message.set_name('FLM','FLM_SCHED_CLOSED_PERIOD');
408: fnd_message.set_token('SCHEDULE',l_schedule_number);
409: MRP_UTIL.MRP_LOG(fnd_message.get);
410: l_flag := FALSE;
411: end if;

Line 408: fnd_message.set_token('SCHEDULE',l_schedule_number);

404: l_auto_replenish := Purge_rec.Auto_Replenish;
405:
406: if (l_completion_date > l_account_close_date) then
407: fnd_message.set_name('FLM','FLM_SCHED_CLOSED_PERIOD');
408: fnd_message.set_token('SCHEDULE',l_schedule_number);
409: MRP_UTIL.MRP_LOG(fnd_message.get);
410: l_flag := FALSE;
411: end if;
412:

Line 409: MRP_UTIL.MRP_LOG(fnd_message.get);

405:
406: if (l_completion_date > l_account_close_date) then
407: fnd_message.set_name('FLM','FLM_SCHED_CLOSED_PERIOD');
408: fnd_message.set_token('SCHEDULE',l_schedule_number);
409: MRP_UTIL.MRP_LOG(fnd_message.get);
410: l_flag := FALSE;
411: end if;
412:
413: l_stmt_num := 200;

Line 418: fnd_message.set_name('FLM','FLM_SCHED_NOT_CLOSED');

414:
415: if (l_flag) then
416: if ((l_status <> G_CLOSED_STATUS)
417: or (l_close_date IS NULL)) then
418: fnd_message.set_name('FLM','FLM_SCHED_NOT_CLOSED');
419: fnd_message.set_token('SCHEDULE',l_schedule_number);
420: MRP_UTIL.MRP_LOG(fnd_message.get);
421: l_flag := FALSE;
422: end if;

Line 419: fnd_message.set_token('SCHEDULE',l_schedule_number);

415: if (l_flag) then
416: if ((l_status <> G_CLOSED_STATUS)
417: or (l_close_date IS NULL)) then
418: fnd_message.set_name('FLM','FLM_SCHED_NOT_CLOSED');
419: fnd_message.set_token('SCHEDULE',l_schedule_number);
420: MRP_UTIL.MRP_LOG(fnd_message.get);
421: l_flag := FALSE;
422: end if;
423: end if;

Line 420: MRP_UTIL.MRP_LOG(fnd_message.get);

416: if ((l_status <> G_CLOSED_STATUS)
417: or (l_close_date IS NULL)) then
418: fnd_message.set_name('FLM','FLM_SCHED_NOT_CLOSED');
419: fnd_message.set_token('SCHEDULE',l_schedule_number);
420: MRP_UTIL.MRP_LOG(fnd_message.get);
421: l_flag := FALSE;
422: end if;
423: end if;
424:

Line 483: fnd_message.set_name('FLM','FLM_SCHEDULE_FKEY_REFERENCE');

479: end if;
480:
481:
482: if (l_return_value = G_WARNING) and (l_flag) then
483: fnd_message.set_name('FLM','FLM_SCHEDULE_FKEY_REFERENCE');
484: fnd_message.set_token('SCHEDULE',l_schedule_number);
485: fnd_message.set_token('TABLES',l_table_name);
486: MRP_UTIL.MRP_LOG(fnd_message.get);
487: l_flag := FALSE;

Line 484: fnd_message.set_token('SCHEDULE',l_schedule_number);

480:
481:
482: if (l_return_value = G_WARNING) and (l_flag) then
483: fnd_message.set_name('FLM','FLM_SCHEDULE_FKEY_REFERENCE');
484: fnd_message.set_token('SCHEDULE',l_schedule_number);
485: fnd_message.set_token('TABLES',l_table_name);
486: MRP_UTIL.MRP_LOG(fnd_message.get);
487: l_flag := FALSE;
488: elsif (l_return_value = G_ERROR) then

Line 485: fnd_message.set_token('TABLES',l_table_name);

481:
482: if (l_return_value = G_WARNING) and (l_flag) then
483: fnd_message.set_name('FLM','FLM_SCHEDULE_FKEY_REFERENCE');
484: fnd_message.set_token('SCHEDULE',l_schedule_number);
485: fnd_message.set_token('TABLES',l_table_name);
486: MRP_UTIL.MRP_LOG(fnd_message.get);
487: l_flag := FALSE;
488: elsif (l_return_value = G_ERROR) then
489: APP_EXCEPTION.RAISE_EXCEPTION;

Line 486: MRP_UTIL.MRP_LOG(fnd_message.get);

482: if (l_return_value = G_WARNING) and (l_flag) then
483: fnd_message.set_name('FLM','FLM_SCHEDULE_FKEY_REFERENCE');
484: fnd_message.set_token('SCHEDULE',l_schedule_number);
485: fnd_message.set_token('TABLES',l_table_name);
486: MRP_UTIL.MRP_LOG(fnd_message.get);
487: l_flag := FALSE;
488: elsif (l_return_value = G_ERROR) then
489: APP_EXCEPTION.RAISE_EXCEPTION;
490: end if;

Line 527: fnd_message.set_name('FLM','FLM_SCHEDULE_NOT_FOUND');

523: COMMIT;
524: end if;
525:
526: if (l_tot_rec_purge = G_ZERO) then
527: fnd_message.set_name('FLM','FLM_SCHEDULE_NOT_FOUND');
528: MRP_UTIL.MRP_LOG(fnd_message.get);
529: else
530: /* Added for Enhancement # 3321626
531: * Modified the message to be shown in the log file, depending upon the Purge Option

Line 528: MRP_UTIL.MRP_LOG(fnd_message.get);

524: end if;
525:
526: if (l_tot_rec_purge = G_ZERO) then
527: fnd_message.set_name('FLM','FLM_SCHEDULE_NOT_FOUND');
528: MRP_UTIL.MRP_LOG(fnd_message.get);
529: else
530: /* Added for Enhancement # 3321626
531: * Modified the message to be shown in the log file, depending upon the Purge Option
532: */

Line 534: fnd_message.set_name('FLM','FLM_PURGE_RESOURCE_TXNS');

530: /* Added for Enhancement # 3321626
531: * Modified the message to be shown in the log file, depending upon the Purge Option
532: */
533: if (arg_purge_option = 2) then
534: fnd_message.set_name('FLM','FLM_PURGE_RESOURCE_TXNS');
535: fnd_message.set_token('NUMBER',l_tot_rec_purge);
536: MRP_UTIL.MRP_LOG(fnd_message.get);
537:
538: elsif (arg_purge_option = 3) then

Line 535: fnd_message.set_token('NUMBER',l_tot_rec_purge);

531: * Modified the message to be shown in the log file, depending upon the Purge Option
532: */
533: if (arg_purge_option = 2) then
534: fnd_message.set_name('FLM','FLM_PURGE_RESOURCE_TXNS');
535: fnd_message.set_token('NUMBER',l_tot_rec_purge);
536: MRP_UTIL.MRP_LOG(fnd_message.get);
537:
538: elsif (arg_purge_option = 3) then
539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');

Line 536: MRP_UTIL.MRP_LOG(fnd_message.get);

532: */
533: if (arg_purge_option = 2) then
534: fnd_message.set_name('FLM','FLM_PURGE_RESOURCE_TXNS');
535: fnd_message.set_token('NUMBER',l_tot_rec_purge);
536: MRP_UTIL.MRP_LOG(fnd_message.get);
537:
538: elsif (arg_purge_option = 3) then
539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');
540: fnd_message.set_token('NUMBER',l_tot_rec_purge);

Line 539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');

535: fnd_message.set_token('NUMBER',l_tot_rec_purge);
536: MRP_UTIL.MRP_LOG(fnd_message.get);
537:
538: elsif (arg_purge_option = 3) then
539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');
540: fnd_message.set_token('NUMBER',l_tot_rec_purge);
541: MRP_UTIL.MRP_LOG(fnd_message.get);
542:
543: else

Line 540: fnd_message.set_token('NUMBER',l_tot_rec_purge);

536: MRP_UTIL.MRP_LOG(fnd_message.get);
537:
538: elsif (arg_purge_option = 3) then
539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');
540: fnd_message.set_token('NUMBER',l_tot_rec_purge);
541: MRP_UTIL.MRP_LOG(fnd_message.get);
542:
543: else
544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');

Line 541: MRP_UTIL.MRP_LOG(fnd_message.get);

537:
538: elsif (arg_purge_option = 3) then
539: fnd_message.set_name('FLM','FLM_PURGE_EXECUTION_HISTORY');
540: fnd_message.set_token('NUMBER',l_tot_rec_purge);
541: MRP_UTIL.MRP_LOG(fnd_message.get);
542:
543: else
544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
545: fnd_message.set_token('NUMBER',l_tot_rec_purge);

Line 544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');

540: fnd_message.set_token('NUMBER',l_tot_rec_purge);
541: MRP_UTIL.MRP_LOG(fnd_message.get);
542:
543: else
544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
545: fnd_message.set_token('NUMBER',l_tot_rec_purge);
546: MRP_UTIL.MRP_LOG(fnd_message.get);
547: end if;
548: end if;

Line 545: fnd_message.set_token('NUMBER',l_tot_rec_purge);

541: MRP_UTIL.MRP_LOG(fnd_message.get);
542:
543: else
544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
545: fnd_message.set_token('NUMBER',l_tot_rec_purge);
546: MRP_UTIL.MRP_LOG(fnd_message.get);
547: end if;
548: end if;
549:

Line 546: MRP_UTIL.MRP_LOG(fnd_message.get);

542:
543: else
544: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
545: fnd_message.set_token('NUMBER',l_tot_rec_purge);
546: MRP_UTIL.MRP_LOG(fnd_message.get);
547: end if;
548: end if;
549:
550: EXCEPTION WHEN OTHERS THEN