DBA Data[Home] [Help]

APPS.FF_DATABASE_ITEMS_PKG dependencies on FND_MESSAGE

Line 346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');

342: if l_debug then
343: hr_utility.set_location('handle_referencing_formulas', 50);
344: end if;
345:
346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

Line 347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

343: hr_utility.set_location('handle_referencing_formulas', 50);
344: end if;
345:
346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

Line 348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);

344: end if;
345:
346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
352: l_encoded_message := fnd_message.get_encoded;

Line 349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);

345:
346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
352: l_encoded_message := fnd_message.get_encoded;
353: else

Line 350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

346: fnd_message.set_name ('FF','FF_33438_OLDDBINAME_IN_SEED_FF');
347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
352: l_encoded_message := fnd_message.get_encoded;
353: else
354:

Line 351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

347: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
352: l_encoded_message := fnd_message.get_encoded;
353: else
354:
355: if l_debug then

Line 352: l_encoded_message := fnd_message.get_encoded;

348: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
349: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
350: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
351: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
352: l_encoded_message := fnd_message.get_encoded;
353: else
354:
355: if l_debug then
356: hr_utility.set_location('handle_referencing_formulas', 60);

Line 359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');

355: if l_debug then
356: hr_utility.set_location('handle_referencing_formulas', 60);
357: end if;
358:
359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

Line 360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

356: hr_utility.set_location('handle_referencing_formulas', 60);
357: end if;
358:
359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

Line 361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);

357: end if;
358:
359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
365: l_encoded_message := fnd_message.get_encoded;

Line 362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);

358:
359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
365: l_encoded_message := fnd_message.get_encoded;
366: end if;

Line 363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

359: fnd_message.set_name ('FF','FF_33440_NEWDBINAME_IN_SEED_FF');
360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
365: l_encoded_message := fnd_message.get_encoded;
366: end if;
367: --

Line 364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

360: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
365: l_encoded_message := fnd_message.get_encoded;
366: end if;
367: --
368: -- Customer Formula case:

Line 365: l_encoded_message := fnd_message.get_encoded;

361: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
362: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
363: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
364: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
365: l_encoded_message := fnd_message.get_encoded;
366: end if;
367: --
368: -- Customer Formula case:
369: --

Line 382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');

378: if l_debug then
379: hr_utility.set_location('handle_referencing_formulas', 80);
380: end if;
381:
382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);

Line 383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

379: hr_utility.set_location('handle_referencing_formulas', 80);
380: end if;
381:
382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

Line 384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);

380: end if;
381:
382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

Line 385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);

381:
382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
389: l_encoded_message := fnd_message.get_encoded;

Line 386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);

382: fnd_message.set_name ('FF','FF_33437_OLDDBINAME_IN_CUST_FF');
383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
389: l_encoded_message := fnd_message.get_encoded;
390: else

Line 387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

383: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
389: l_encoded_message := fnd_message.get_encoded;
390: else
391:

Line 388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

384: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
389: l_encoded_message := fnd_message.get_encoded;
390: else
391:
392: if l_debug then

Line 389: l_encoded_message := fnd_message.get_encoded;

385: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
386: fnd_message.set_token('OLD_DBI_NAME', x_old_tl_name, false);
387: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
388: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
389: l_encoded_message := fnd_message.get_encoded;
390: else
391:
392: if l_debug then
393: hr_utility.set_location('handle_referencing_formulas', 90);

Line 396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');

392: if l_debug then
393: hr_utility.set_location('handle_referencing_formulas', 90);
394: end if;
395:
396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

Line 397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);

393: hr_utility.set_location('handle_referencing_formulas', 90);
394: end if;
395:
396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

Line 398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);

394: end if;
395:
396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
402: l_encoded_message := fnd_message.get_encoded;

Line 399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);

395:
396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
402: l_encoded_message := fnd_message.get_encoded;
403: end if;

Line 400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);

396: fnd_message.set_name ('FF','FF_33439_NEWDBINAME_IN_CUST_FF');
397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
402: l_encoded_message := fnd_message.get_encoded;
403: end if;
404: end if;

Line 401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);

397: fnd_message.set_token('FORMULA', 'FF93_FORMULA', true);
398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
402: l_encoded_message := fnd_message.get_encoded;
403: end if;
404: end if;
405:

Line 402: l_encoded_message := fnd_message.get_encoded;

398: fnd_message.set_token('DBI','FF91_DBITEM_NAME', true);
399: fnd_message.set_token('NEW_DBI_NAME', x_tl_user_name, false);
400: fnd_message.set_token('FF_NAME', l_formula_names(i), false);
401: fnd_message.set_token('EFF_DATE', to_char(l_eff_start_dates(i)), false);
402: l_encoded_message := fnd_message.get_encoded;
403: end if;
404: end if;
405:
406: if l_debug then

Line 546: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');

542: -- New DB item name cannot be same as existing database item visible from
543: -- business group and legislation of current user_entity.
544: --
545: if l_outcome = 'D' then
546: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
547: fnd_message.set_token('1', l_tl_user_name, false);
548: fnd_message.set_token('2','FF91_DBITEM_NAME', true);
549: l_encoded_message := fnd_message.get_encoded;
550:

Line 547: fnd_message.set_token('1', l_tl_user_name, false);

543: -- business group and legislation of current user_entity.
544: --
545: if l_outcome = 'D' then
546: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
547: fnd_message.set_token('1', l_tl_user_name, false);
548: fnd_message.set_token('2','FF91_DBITEM_NAME', true);
549: l_encoded_message := fnd_message.get_encoded;
550:
551: pay_dbitl_update_errors_pkg.insert_row

Line 548: fnd_message.set_token('2','FF91_DBITEM_NAME', true);

544: --
545: if l_outcome = 'D' then
546: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
547: fnd_message.set_token('1', l_tl_user_name, false);
548: fnd_message.set_token('2','FF91_DBITEM_NAME', true);
549: l_encoded_message := fnd_message.get_encoded;
550:
551: pay_dbitl_update_errors_pkg.insert_row
552: (p_user_name => l_user_name

Line 549: l_encoded_message := fnd_message.get_encoded;

545: if l_outcome = 'D' then
546: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
547: fnd_message.set_token('1', l_tl_user_name, false);
548: fnd_message.set_token('2','FF91_DBITEM_NAME', true);
549: l_encoded_message := fnd_message.get_encoded;
550:
551: pay_dbitl_update_errors_pkg.insert_row
552: (p_user_name => l_user_name
553: ,p_user_entity_id => x_user_entity_id

Line 574: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');

570: --
571: -- New DB item name cannot be same as existing context name.
572: --
573: if l_outcome = 'C' then
574: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
575: fnd_message.set_token('1', l_tl_user_name, false);
576: fnd_message.set_token('2','FF92_CONTEXT', true);
577: l_encoded_message := fnd_message.get_encoded;
578:

Line 575: fnd_message.set_token('1', l_tl_user_name, false);

571: -- New DB item name cannot be same as existing context name.
572: --
573: if l_outcome = 'C' then
574: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
575: fnd_message.set_token('1', l_tl_user_name, false);
576: fnd_message.set_token('2','FF92_CONTEXT', true);
577: l_encoded_message := fnd_message.get_encoded;
578:
579: pay_dbitl_update_errors_pkg.insert_row

Line 576: fnd_message.set_token('2','FF92_CONTEXT', true);

572: --
573: if l_outcome = 'C' then
574: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
575: fnd_message.set_token('1', l_tl_user_name, false);
576: fnd_message.set_token('2','FF92_CONTEXT', true);
577: l_encoded_message := fnd_message.get_encoded;
578:
579: pay_dbitl_update_errors_pkg.insert_row
580: (p_user_name => l_user_name

Line 577: l_encoded_message := fnd_message.get_encoded;

573: if l_outcome = 'C' then
574: fnd_message.set_name ('FF','FF52_NAME_ALREADY_USED');
575: fnd_message.set_token('1', l_tl_user_name, false);
576: fnd_message.set_token('2','FF92_CONTEXT', true);
577: l_encoded_message := fnd_message.get_encoded;
578:
579: pay_dbitl_update_errors_pkg.insert_row
580: (p_user_name => l_user_name
581: ,p_user_entity_id => x_user_entity_id