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);
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);
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;
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
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:
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
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);
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);
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);
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;
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;
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: --
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:
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: --
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);
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);
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);
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;
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
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:
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
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);
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);
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);
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;
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;
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;
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:
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
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:
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
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
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
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:
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
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
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