DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

544: MRP_UTIL.MRP_LOG(fnd_message.get);
545:
546: else
547: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
548: fnd_message.set_token('NUMBER',l_tot_rec_purge);
549: MRP_UTIL.MRP_LOG(fnd_message.get);
550: end if;
551: end if;
552: l_stmt_num := 900;

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

545:
546: else
547: fnd_message.set_name('FLM','FLM_SCHEDULES_PURGED');
548: fnd_message.set_token('NUMBER',l_tot_rec_purge);
549: MRP_UTIL.MRP_LOG(fnd_message.get);
550: end if;
551: end if;
552: l_stmt_num := 900;
553: EXCEPTION WHEN OTHERS THEN