eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FFDICT dependencies on FFDICT

Line 1: package body ffdict as

1: package body ffdict as
2: /* $Header: ffdict.pkb 120.14.12020000.4 2012/08/28 08:56:10 ranarra ship $ */
3: --
4: -- Temporary storage for UE details to be used in cascade delete of DB items
5: -- to get round mutating ff_user_entities

Line 2: /* $Header: ffdict.pkb 120.14.12020000.4 2012/08/28 08:56:10 ranarra ship $ */

1: package body ffdict as
2: /* $Header: ffdict.pkb 120.14.12020000.4 2012/08/28 08:56:10 ranarra ship $ */
3: --
4: -- Temporary storage for UE details to be used in cascade delete of DB items
5: -- to get round mutating ff_user_entities
6: --

Line 34: hr_utility.set_location('ffdict.fetch_ue_details',1);

30: l_legislation_code varchar2(30);
31: begin
32: g_debug := hr_utility.debug_enabled;
33: if g_debug then
34: hr_utility.set_location('ffdict.fetch_ue_details',1);
35: end if;
36: --
37: if tmp_ue_id is null or tmp_ue_id <> p_user_entity_id then
38: begin

Line 51: hr_utility.set_location('ffdict.fetch_ue_details',2);

47: ;
48: exception
49: when no_data_found then
50: if g_debug then
51: hr_utility.set_location('ffdict.fetch_ue_details',2);
52: end if;
53: --
54: hr_utility.set_message (802, 'FF_33021_ORPHANED_DBITEMS');
55: hr_utility.raise_error;

Line 66: hr_utility.set_location('ffdict.fetch_ue_details',3);

62: );
63: end if;
64: --
65: if g_debug then
66: hr_utility.set_location('ffdict.fetch_ue_details',3);
67: end if;
68: end fetch_ue_details;
69: --
70: --------------------------- set_global_dbi_details ----------------------------

Line 95: hr_utility.set_location('ffdict.set_global_dbi_details',1);

91: l_debug boolean;
92: begin
93: l_debug := hr_utility.debug_enabled;
94: if l_debug then
95: hr_utility.set_location('ffdict.set_global_dbi_details',1);
96: end if;
97:
98: --
99: -- Only fetch the details if necessary.

Line 113: hr_utility.set_location('ffdict.set_global_dbi_details',2);

109: g_glb_ueid := l_glb_ueid;
110: g_glb_dbi := l_glb_dbi;
111: else
112: if l_debug then
113: hr_utility.set_location('ffdict.set_global_dbi_details',2);
114: end if;
115: end if;
116: close csr_ueid;
117: end if;

Line 166: hr_utility.set_location('ffdict.will_clash_with_formula',1);

162: dummy varchar2(1);
163: startup_mode varchar2(10);
164: begin
165: -- set error tracking information
166: hr_utility.set_location('ffdict.will_clash_with_formula',1);
167: --
168: -- get startup_mode based on current business group and legislation
169: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
170: --

Line 223: hr_utility.set_location('ffdict.is_used_in_formula',1);

219: dummy varchar2(1);
220: startup_mode varchar2(10);
221: begin
222: -- set error tracking information
223: hr_utility.set_location('ffdict.is_used_in_formula',1);
224: --
225: -- get startup_mode based on current business group and legislation
226: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
227: --

Line 229: hr_utility.set_location('ffdict.is_used_in_formula',2);

225: -- get startup_mode based on current business group and legislation
226: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
227: --
228: -- set error tracking information
229: hr_utility.set_location('ffdict.is_used_in_formula',2);
230: -- Check if there any rows in FDIU for this item but take into account
231: -- the business group of the formula
232: select 'X' into dummy from dual where exists
233: (select null

Line 292: hr_utility.set_location('ffdict.dbitl_used_in_formula',1);

288: begin
289: g_debug := hr_utility.debug_enabled;
290:
291: if g_debug then
292: hr_utility.set_location('ffdict.dbitl_used_in_formula',1);
293: end if;
294:
295: --
296: -- Get the startup mode based upon the business group and legislation.

Line 303: hr_utility.set_location('ffdict.dbitl_used_in_formula',2);

299: fetch_ue_details(p_user_entity_id);
300: end if;
301:
302: if g_debug then
303: hr_utility.set_location('ffdict.dbitl_used_in_formula',2);
304: end if;
305:
306: startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
307:

Line 350: hr_utility.set_location('ffdict.dbitl_used_in_formula',3);

346: )
347: );
348:
349: if g_debug then
350: hr_utility.set_location('ffdict.dbitl_used_in_formula',3);
351: end if;
352:
353: return TRUE;
354:

Line 358: hr_utility.set_location('ffdict.dbitl_used_in_formula',4);

354:
355: exception
356: when no_data_found then
357: if g_debug then
358: hr_utility.set_location('ffdict.dbitl_used_in_formula',4);
359: end if;
360: return FALSE;
361:
362: end dbitl_used_in_formula;

Line 475: hr_utility.set_location('ffdict.fetch_referencing_formulas',10);

471: begin
472: g_debug := hr_utility.debug_enabled;
473:
474: if g_debug then
475: hr_utility.set_location('ffdict.fetch_referencing_formulas',10);
476: end if;
477:
478: --
479: -- Get the startup mode based upon the business group and legislation.

Line 488: hr_utility.set_location('ffdict.fetch_referencing_formulas',20);

484:
485: l_startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
486:
487: if g_debug then
488: hr_utility.set_location('ffdict.fetch_referencing_formulas',20);
489: hr_utility.trace('BG_ID: ' || tmp_bg_id || ' LEG_CODE: ' || tmp_leg_code);
490: hr_utility.trace('DBI: ' || p_tl_user_name);
491: hr_utility.trace('MODE: ' || l_startup_mode);
492: end if;

Line 513: hr_utility.set_location('ffdict.fetch_referencing_formulas',30);

509:
510: close csr_ref_formulas;
511:
512: if g_debug then
513: hr_utility.set_location('ffdict.fetch_referencing_formulas',30);
514: end if;
515:
516: exception
517: when others then

Line 519: hr_utility.set_location('ffdict.fetch_referencing_formulas',40);

515:
516: exception
517: when others then
518: if g_debug then
519: hr_utility.set_location('ffdict.fetch_referencing_formulas',40);
520: end if;
521:
522: if csr_ref_formulas%isopen then
523: close csr_ref_formulas;

Line 552: hr_utility.set_location('ffdict.dbi_used_in_formula',1);

548: begin
549: g_debug := hr_utility.debug_enabled;
550:
551: if g_debug then
552: hr_utility.set_location('ffdict.dbi_used_in_formula',1);
553: end if;
554:
555: --
556: -- Get the startup mode based upon the business group and legislation.

Line 563: hr_utility.set_location('ffdict.dbi_used_in_formula',2);

559: fetch_ue_details(p_user_entity_id);
560: end if;
561:
562: if g_debug then
563: hr_utility.set_location('ffdict.dbi_used_in_formula',2);
564: end if;
565:
566: startup_mode := ffstup.get_mode(tmp_bg_id, tmp_leg_code);
567:

Line 610: hr_utility.set_location('ffdict.dbi_used_in_formula',3);

606: )
607: );
608:
609: if g_debug then
610: hr_utility.set_location('ffdict.dbi_used_in_formula',3);
611: end if;
612:
613: return TRUE;
614:

Line 618: hr_utility.set_location('ffdict.dbi_used_in_formula',4);

614:
615: exception
616: when no_data_found then
617: if g_debug then
618: hr_utility.set_location('ffdict.dbi_used_in_formula',4);
619: end if;
620: return FALSE;
621: end dbi_used_in_formula;
622: --

Line 655: hr_utility.set_location('ffdict.non_dbi_used_in_formula',1);

651: begin
652: g_debug := hr_utility.debug_enabled;
653:
654: if g_debug then
655: hr_utility.set_location('ffdict.non_dbi_used_in_formula',1);
656: end if;
657:
658: startup_mode := ffstup.get_mode(p_bus_grp, p_leg_code);
659:

Line 703: hr_utility.set_location('ffdict.non_dbi_used_in_formula',2);

699: )
700: );
701:
702: if g_debug then
703: hr_utility.set_location('ffdict.non_dbi_used_in_formula',2);
704: end if;
705:
706: return TRUE;
707:

Line 711: hr_utility.set_location('ffdict.non_dbi_used_in_formula',3);

707:
708: exception
709: when no_data_found then
710: if g_debug then
711: hr_utility.set_location('ffdict.non_dbi_used_in_formula',3);
712: end if;
713: return FALSE;
714:
715: end non_dbi_used_in_formula;

Line 738: hr_utility.set_location('ffdict.will_clash_with_dbitem',1);

734: dummy varchar2(1);
735: startup_mode varchar2(10);
736: begin
737: -- set error tracking information
738: hr_utility.set_location('ffdict.will_clash_with_dbitem',1);
739: --
740: -- get startup_mode based on current business group and legislation
741: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
742:

Line 854: hr_utility.set_location('ffdict.tl_dbi_will_clash',1);

850: begin
851: g_debug := hr_utility.debug_enabled;
852:
853: if g_debug then
854: hr_utility.set_location('ffdict.tl_dbi_will_clash',1);
855: end if;
856:
857: --
858: -- If p_user_name = p_tl_user_name then return FALSE as p_user_name

Line 863: hr_utility.set_location('ffdict.tl_dbi_will_clash',2);

859: -- will already have been validated.
860: --
861: if p_user_name = p_tl_user_name then
862: if g_debug then
863: hr_utility.set_location('ffdict.tl_dbi_will_clash',2);
864: end if;
865: return FALSE;
866: end if;
867:

Line 917: hr_utility.set_location('ffdict.tl_dbi_will_clash',3);

913: ));
914: exception
915: when no_data_found then
916: if g_debug then
917: hr_utility.set_location('ffdict.tl_dbi_will_clash',3);
918: end if;
919:
920: --
921: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.

Line 965: hr_utility.set_location('ffdict.tl_dbi_will_clash',4);

961: --
962: -- There is a clash.
963: --
964: if g_debug then
965: hr_utility.set_location('ffdict.tl_dbi_will_clash',4);
966: end if;
967:
968: return TRUE;
969: exception

Line 972: hr_utility.set_location('ffdict.tl_dbi_will_clash',5);

968: return TRUE;
969: exception
970: when no_data_found then
971: if g_debug then
972: hr_utility.set_location('ffdict.tl_dbi_will_clash',5);
973: end if;
974: return FALSE;
975: end tl_dbi_will_clash;
976: --

Line 998: hr_utility.set_location('ffdict.will_clash_with_global',1);

994: dummy varchar2(1);
995: startup_mode varchar2(10);
996: begin
997: -- set error tracking information
998: hr_utility.set_location('ffdict.will_clash_with_global',1);
999: --
1000: -- get startup_mode based on current business group and legislation
1001: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1002: --

Line 1104: hr_utility.set_location('ffdict.will_clash_with_global:2',1);

1100: l_debug boolean := hr_utility.debug_enabled;
1101: begin
1102: -- set error tracking information
1103: if l_debug then
1104: hr_utility.set_location('ffdict.will_clash_with_global:2',1);
1105: end if;
1106: --
1107: -- get startup_mode based on current business group and legislation
1108: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);

Line 1216: hr_utility.set_location('ffdict.will_clash_with_entity',1);

1212: dummy varchar2(1);
1213: startup_mode varchar2(10);
1214: begin
1215: -- set error tracking information
1216: hr_utility.set_location('ffdict.will_clash_with_entity',1);
1217: --
1218: -- get startup_mode based on current business group and legislation
1219: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1220: --

Line 1286: hr_utility.set_location('ffdict.will_clash_with_function',1);

1282: dummy varchar2(1);
1283: startup_mode varchar2(10);
1284: begin
1285: -- set error tracking information
1286: hr_utility.set_location('ffdict.will_clash_with_function',1);
1287: --
1288: -- get startup_mode based on current business group and legislation
1289: startup_mode := ffstup.get_mode (p_bus_grp,p_leg_code);
1290: --

Line 1353: hr_utility.set_location('ffdict.will_clash_with_context',1);

1349: function will_clash_with_context(p_item_name in varchar2) return boolean is
1350: dummy varchar2(1);
1351: begin
1352: -- set error tracking information
1353: hr_utility.set_location('ffdict.will_clash_with_context',1);
1354: -- Check if there any rows in FF_CONTEXTS for this name
1355: --
1356: select 'X' into dummy from dual where exists
1357: (select null from ff_contexts where context_name = upper(p_item_name));

Line 1384: hr_utility.set_location('ffdict.validate_formula',1);

1380: p_leg_code in varchar2) is
1381: rgeflg varchar2(1);
1382: begin
1383: -- set error tracking information
1384: hr_utility.set_location('ffdict.validate_formula',1);
1385: --
1386: begin
1387: -- Check if name legal format eg no spaces, or special characters
1388: hr_chkfmt.checkformat (p_formula_name, 'DB_ITEM_NAME', p_formula_name,

Line 1398: hr_utility.set_location('ffdict.validate_formula',2);

1394: hr_utility.raise_error;
1395: end;
1396: --
1397: -- set error tracking information
1398: hr_utility.set_location('ffdict.validate_formula',2);
1399: --
1400: if (will_clash_with_formula(p_formula_name, p_formula_type_id,
1401: p_bus_grp,p_leg_code)) then
1402: hr_utility.set_message(802,'FF52_NAME_ALREADY_USED');

Line 1495: hr_utility.set_location('ffdict.validate_formula',1);

1491: --
1492: begin
1493: --
1494: -- set error tracking information
1495: hr_utility.set_location('ffdict.validate_formula',1);
1496: --
1497: --
1498: begin
1499: --

Line 1516: hr_utility.set_location('ffdict.validate_formula',2);

1512: --
1513: end;
1514: --
1515: -- set error tracking information
1516: hr_utility.set_location('ffdict.validate_formula',2);
1517: --
1518: l_startup_mode := ffstup.get_mode(p_bus_grp,p_leg_code);
1519: --
1520: open csr_formula_clash(l_startup_mode);

Line 1569: hr_utility.set_location('ffdict.validate_dbitem',1);

1565: leg_code varchar2(30);
1566: rgeflg varchar2(1);
1567: begin
1568: -- set error tracking information
1569: hr_utility.set_location('ffdict.validate_dbitem',1);
1570: --
1571: -- Check if name legal format eg no spaces, or special characters
1572: begin
1573: -- Check if name legal format eg no spaces, or special characters

Line 1584: hr_utility.set_location('ffdict.validate_dbitem',2);

1580: hr_utility.raise_error;
1581: end;
1582: --
1583: -- set error tracking information
1584: hr_utility.set_location('ffdict.validate_dbitem',2);
1585: --
1586: -- Fetch business group and legislation details for current user entity
1587: select business_group_id, legislation_code
1588: into bg_id, leg_code

Line 1593: hr_utility.set_location('ffdict.validate_dbitem',3);

1589: from ff_user_entities
1590: where user_entity_id = p_user_entity_id;
1591: --
1592: -- set error tracking information
1593: hr_utility.set_location('ffdict.validate_dbitem',3);
1594: --
1595: -- New DB item name cannot be same as existing database item visible from
1596: -- business group and legislation of current user_entity
1597: if (will_clash_with_dbitem(p_dbi_name, bg_id, leg_code)) then

Line 1604: hr_utility.set_location('ffdict.validate_dbitem',4);

1600: hr_utility.set_message_token(802,'2','FF91_DBITEM_NAME');
1601: hr_utility.raise_error;
1602: end if;
1603: -- set error tracking information
1604: hr_utility.set_location('ffdict.validate_dbitem',4);
1605: --
1606: -- New DB item name cannot be same as existing item in any verified formula
1607: if (ffdict.non_dbi_used_in_formula(p_dbi_name, bg_id, leg_code)) then
1608: hr_utility.set_message (802,'FF75_ITEM_USED_IN_FORMULA');

Line 1607: if (ffdict.non_dbi_used_in_formula(p_dbi_name, bg_id, leg_code)) then

1603: -- set error tracking information
1604: hr_utility.set_location('ffdict.validate_dbitem',4);
1605: --
1606: -- New DB item name cannot be same as existing item in any verified formula
1607: if (ffdict.non_dbi_used_in_formula(p_dbi_name, bg_id, leg_code)) then
1608: hr_utility.set_message (802,'FF75_ITEM_USED_IN_FORMULA');
1609: hr_utility.set_message_token('1',p_dbi_name);
1610: hr_utility.raise_error;
1611: end if;

Line 1613: hr_utility.set_location('ffdict.validate_dbitem',5);

1609: hr_utility.set_message_token('1',p_dbi_name);
1610: hr_utility.raise_error;
1611: end if;
1612: -- set error tracking information
1613: hr_utility.set_location('ffdict.validate_dbitem',5);
1614: --
1615: -- New DB item name cannot be same as existing context name
1616: if (ffdict.will_clash_with_context(p_dbi_name)) then
1617: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');

Line 1616: if (ffdict.will_clash_with_context(p_dbi_name)) then

1612: -- set error tracking information
1613: hr_utility.set_location('ffdict.validate_dbitem',5);
1614: --
1615: -- New DB item name cannot be same as existing context name
1616: if (ffdict.will_clash_with_context(p_dbi_name)) then
1617: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
1618: hr_utility.set_message_token('1',p_dbi_name);
1619: hr_utility.set_message_token(802,'2','FF92_CONTEXT');
1620: hr_utility.raise_error;

Line 1639: hr_utility.set_location('ffdict.core_validate_tl_dbi',1);

1635: begin
1636: g_debug := hr_utility.debug_enabled;
1637:
1638: if g_debug then
1639: hr_utility.set_location('ffdict.core_validate_tl_dbi',1);
1640: end if;
1641:
1642: --
1643: -- Initialise outcome to SUCCESS.

Line 1656: hr_utility.set_location('ffdict.core_validate_tl_dbi',2);

1652: ff_dbi_utils_pkg.str2dbiname(p_str => p_tl_user_name);
1653: p_tl_user_name := l_tl_user_name;
1654:
1655: if g_debug then
1656: hr_utility.set_location('ffdict.core_validate_tl_dbi',2);
1657: end if;
1658:
1659: --
1660: -- Fetch business group and legislation details for current user entity.

Line 1679: hr_utility.set_location('ffdict.core_validate_tl_dbi',3);

1675: ,p_legislation_code => tmp_leg_code
1676: ) then
1677:
1678: if g_debug then
1679: hr_utility.set_location('ffdict.core_validate_tl_dbi',3);
1680: end if;
1681:
1682: p_outcome := 'D';
1683: return;

Line 1687: hr_utility.set_location('ffdict.core_validate_tl_dbi',4);

1683: return;
1684: end if;
1685:
1686: if g_debug then
1687: hr_utility.set_location('ffdict.core_validate_tl_dbi',4);
1688: end if;
1689:
1690: --
1691: -- New DB item name cannot be same as a Formula Context name.

Line 1693: if ffdict.will_clash_with_context(l_tl_user_name) then

1689:
1690: --
1691: -- New DB item name cannot be same as a Formula Context name.
1692: --
1693: if ffdict.will_clash_with_context(l_tl_user_name) then
1694:
1695: if g_debug then
1696: hr_utility.set_location('ffdict.core_validate_tl_dbi',5);
1697: end if;

Line 1696: hr_utility.set_location('ffdict.core_validate_tl_dbi',5);

1692: --
1693: if ffdict.will_clash_with_context(l_tl_user_name) then
1694:
1695: if g_debug then
1696: hr_utility.set_location('ffdict.core_validate_tl_dbi',5);
1697: end if;
1698:
1699: p_outcome := 'C';
1700: return;

Line 1704: hr_utility.set_location('ffdict.core_validate_tl_dbi',6);

1700: return;
1701: end if;
1702:
1703: if g_debug then
1704: hr_utility.set_location('ffdict.core_validate_tl_dbi',6);
1705: end if;
1706:
1707: --
1708: -- New DB item name cannot be same as existing item in any verified formula.

Line 1712: if ffdict.non_dbi_used_in_formula

1708: -- New DB item name cannot be same as existing item in any verified formula.
1709: -- Need to ensure that there is no clash with non-DBI and Context item
1710: -- names used by the formula (inputs, outputs, locals).
1711: --
1712: if ffdict.non_dbi_used_in_formula
1713: (p_item_name => l_tl_user_name
1714: ,p_bus_grp => tmp_bg_id
1715: ,p_leg_code => tmp_leg_code
1716: ) then

Line 1718: hr_utility.set_location('ffdict.core_validate_tl_dbi',7);

1714: ,p_bus_grp => tmp_bg_id
1715: ,p_leg_code => tmp_leg_code
1716: ) then
1717: if g_debug then
1718: hr_utility.set_location('ffdict.core_validate_tl_dbi',7);
1719: end if;
1720:
1721: p_outcome := 'F';
1722: return;

Line 1726: hr_utility.set_location('ffdict.core_validate_tl_dbi',8);

1722: return;
1723: end if;
1724:
1725: if g_debug then
1726: hr_utility.set_location('ffdict.core_validate_tl_dbi',8);
1727: end if;
1728:
1729: if g_debug then
1730: hr_utility.set_location('ffdict.core_validate_tl_dbi',9);

Line 1730: hr_utility.set_location('ffdict.core_validate_tl_dbi',9);

1726: hr_utility.set_location('ffdict.core_validate_tl_dbi',8);
1727: end if;
1728:
1729: if g_debug then
1730: hr_utility.set_location('ffdict.core_validate_tl_dbi',9);
1731: end if;
1732: end core_validate_tl_dbitem;
1733: --
1734: ------------------------------ validate_tl_dbi -------------------------------

Line 1747: hr_utility.set_location('ffdict.validate_tl_dbi',1);

1743: begin
1744: g_debug := hr_utility.debug_enabled;
1745:
1746: if g_debug then
1747: hr_utility.set_location('ffdict.validate_tl_dbi',1);
1748: end if;
1749:
1750: l_tl_user_name := p_tl_user_name;
1751:

Line 1753: hr_utility.set_location('ffdict.validate_tl_dbi',2);

1749:
1750: l_tl_user_name := p_tl_user_name;
1751:
1752: if g_debug then
1753: hr_utility.set_location('ffdict.validate_tl_dbi',2);
1754: end if;
1755:
1756: core_validate_tl_dbitem
1757: (p_user_name => p_user_name

Line 1764: hr_utility.set_location('ffdict.validate_tl_dbi',3);

1760: ,p_outcome => l_outcome
1761: );
1762:
1763: if g_debug then
1764: hr_utility.set_location('ffdict.validate_tl_dbi',3);
1765: end if;
1766:
1767: --
1768: -- New DB item name cannot be same as existing database item visible from

Line 1779: hr_utility.set_location('ffdict.validate_tl_dbi',4);

1775: hr_utility.raise_error;
1776: end if;
1777:
1778: if g_debug then
1779: hr_utility.set_location('ffdict.validate_tl_dbi',4);
1780: end if;
1781:
1782: --
1783: -- New DB item name cannot be same as existing context name.

Line 1793: hr_utility.set_location('ffdict.validate_tl_dbi',5);

1789: hr_utility.raise_error;
1790: end if;
1791:
1792: if g_debug then
1793: hr_utility.set_location('ffdict.validate_tl_dbi',5);
1794: end if;
1795:
1796: --
1797: -- New DB item name cannot be same as existing item in any verified

Line 1824: hr_utility.set_location('ffdict.validate_context',1);

1820: procedure validate_context(p_ctx_name in out nocopy varchar2) is
1821: rgeflg varchar2(1);
1822: begin
1823: -- set error tracking information
1824: hr_utility.set_location('ffdict.validate_context',1);
1825: --
1826: -- Check if name legal format eg no spaces, or special characters
1827: begin
1828: -- Check if name legal format eg no spaces, or special characters

Line 1838: hr_utility.set_location('ffdict.validate_context',2);

1834: hr_utility.set_message_token(802,'VALUE_NAME','FF92_CONTEXT');
1835: hr_utility.raise_error;
1836: end;
1837: -- set error tracking information
1838: hr_utility.set_location('ffdict.validate_context',2);
1839: --
1840: -- New DB item name cannot be same as existing context name
1841: if (ffdict.will_clash_with_context(p_ctx_name)) then
1842: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');

Line 1841: if (ffdict.will_clash_with_context(p_ctx_name)) then

1837: -- set error tracking information
1838: hr_utility.set_location('ffdict.validate_context',2);
1839: --
1840: -- New DB item name cannot be same as existing context name
1841: if (ffdict.will_clash_with_context(p_ctx_name)) then
1842: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
1843: hr_utility.set_message_token('1',p_ctx_name);
1844: hr_utility.set_message_token(802,'2','FF92_CONTEXT');
1845: hr_utility.raise_error;

Line 1848: hr_utility.set_location('ffdict.validate_context',3);

1844: hr_utility.set_message_token(802,'2','FF92_CONTEXT');
1845: hr_utility.raise_error;
1846: end if;
1847: -- set error tracking information
1848: hr_utility.set_location('ffdict.validate_context',3);
1849: --
1850: -- Pass null so all formulae are considered
1851: if (ffdict.is_used_in_formula(p_ctx_name, null, null)) then
1852: hr_utility.set_message (802,'FF75_ITEM_USED_IN_FORMULA');

Line 1851: if (ffdict.is_used_in_formula(p_ctx_name, null, null)) then

1847: -- set error tracking information
1848: hr_utility.set_location('ffdict.validate_context',3);
1849: --
1850: -- Pass null so all formulae are considered
1851: if (ffdict.is_used_in_formula(p_ctx_name, null, null)) then
1852: hr_utility.set_message (802,'FF75_ITEM_USED_IN_FORMULA');
1853: hr_utility.set_message_token('1',p_ctx_name);
1854: hr_utility.raise_error;
1855: end if;

Line 1857: hr_utility.set_location('ffdict.validate_context',4);

1853: hr_utility.set_message_token('1',p_ctx_name);
1854: hr_utility.raise_error;
1855: end if;
1856: -- set error tracking information
1857: hr_utility.set_location('ffdict.validate_context',4);
1858: --
1859: -- Pass null bus grp and leg code so all DB items are considered
1860: if (ffdict.will_clash_with_dbitem(p_ctx_name, null, null)) then
1861: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');

Line 1860: if (ffdict.will_clash_with_dbitem(p_ctx_name, null, null)) then

1856: -- set error tracking information
1857: hr_utility.set_location('ffdict.validate_context',4);
1858: --
1859: -- Pass null bus grp and leg code so all DB items are considered
1860: if (ffdict.will_clash_with_dbitem(p_ctx_name, null, null)) then
1861: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
1862: hr_utility.set_message_token('1',p_ctx_name);
1863: hr_utility.set_message_token(802,'2','FF91_DBITEM_NAME');
1864: hr_utility.raise_error;

Line 1885: hr_utility.set_location('ffdict.validate_user_entity',1);

1881: p_leg_code in varchar2) is
1882: rgeflg varchar2(1);
1883: begin
1884: -- set error tracking information
1885: hr_utility.set_location('ffdict.validate_user_entity',1);
1886: --
1887: -- Check if name legal format eg no spaces, or special characters
1888: begin
1889: -- Check if name legal format eg no spaces, or special characters

Line 1899: hr_utility.set_location('ffdict.validate_user_entity',2);

1895: hr_utility.set_message_token(802,'VALUE_NAME','FF94_USER_ENTITY');
1896: hr_utility.raise_error;
1897: end;
1898: -- set error tracking information
1899: hr_utility.set_location('ffdict.validate_user_entity',2);
1900: --
1901: if (will_clash_with_entity(p_ue_name,p_bus_grp,p_leg_code)) then
1902: hr_utility.set_message(802,'FF52_NAME_ALREADY_USED');
1903: hr_utility.set_message_token('1',p_ue_name);

Line 1927: hr_utility.set_location('ffdict.validate_function',1);

1923: p_leg_code in varchar2) is
1924: rgeflg varchar2(1);
1925: begin
1926: -- set error tracking information
1927: hr_utility.set_location('ffdict.validate_function',1);
1928: --
1929: -- Check if name legal format eg no spaces, or special characters
1930: begin
1931: -- Check if name legal format eg no spaces, or special characters

Line 1941: hr_utility.set_location('ffdict.validate_function',2);

1937: hr_utility.set_message_token(802,'VALUE_NAME','FF95_FUNCTION');
1938: hr_utility.raise_error;
1939: end;
1940: -- set error tracking information
1941: hr_utility.set_location('ffdict.validate_function',2);
1942: --
1943: -- Check function name
1944: if (will_clash_with_function(p_func_name,p_class, p_bus_grp,p_leg_code)) then
1945: hr_utility.set_message(802,'FF52_NAME_ALREADY_USED');

Line 1951: hr_utility.set_location('ffdict.validate_function',3);

1947: hr_utility.set_message_token(802,'2','FF95_FUNCTION');
1948: hr_utility.raise_error;
1949: end if;
1950: -- set error tracking information
1951: hr_utility.set_location('ffdict.validate_function',3);
1952: --
1953: -- Check alias - cannot be same as another alias or function name
1954: if (p_alias is not null) then
1955: if (will_clash_with_function(p_alias,p_class, p_bus_grp,p_leg_code)) then

Line 1980: hr_utility.set_location('ffdict.validate_global',1);

1976: p_leg_code in varchar2) is
1977: rgeflg varchar2(1);
1978: begin
1979: -- set error tracking information
1980: hr_utility.set_location('ffdict.validate_global',1);
1981: --
1982: -- Check if name legal format eg no spaces, or special characters
1983: begin
1984: -- Check if name legal format eg no spaces, or special characters

Line 1995: hr_utility.set_location('ffdict.validate_global',2);

1991: hr_utility.raise_error;
1992: end;
1993:
1994: -- set error tracking information
1995: hr_utility.set_location('ffdict.validate_global',2);
1996: --
1997: if (will_clash_with_global(p_glob_name,p_bus_grp,p_leg_code)) then
1998: hr_utility.set_message(802,'FF52_NAME_ALREADY_USED');
1999: hr_utility.set_message_token('1',p_glob_name);

Line 2004: hr_utility.set_location('ffdict.validate_global',3);

2000: hr_utility.set_message_token(802,'2','FF90_GLOBAL_NAME');
2001: hr_utility.raise_error;
2002: end if;
2003: -- set error tracking information
2004: hr_utility.set_location('ffdict.validate_global',3);
2005: --
2006: if (is_used_in_formula(p_glob_name, p_bus_grp, p_leg_code)) then
2007: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
2008: hr_utility.set_message_token('1',p_glob_name);

Line 2012: hr_utility.set_location('ffdict.validate_global',4);

2008: hr_utility.set_message_token('1',p_glob_name);
2009: hr_utility.raise_error;
2010: end if;
2011: -- set error tracking information
2012: hr_utility.set_location('ffdict.validate_global',4);
2013: --
2014: if (will_clash_with_dbitem(p_glob_name, p_bus_grp, p_leg_code)) then
2015: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
2016: hr_utility.set_message_token('1',p_glob_name);

Line 2021: hr_utility.set_location('ffdict.validate_global',5);

2017: hr_utility.set_message_token(802,'2','FF91_DBITEM_NAME');
2018: hr_utility.raise_error;
2019: end if;
2020: -- set error tracking information
2021: hr_utility.set_location('ffdict.validate_global',5);
2022: --
2023: if (will_clash_with_context(p_glob_name)) then
2024: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
2025: hr_utility.set_message_token('1',p_glob_name);

Line 2065: ffdict.validate_tl_dbi

2061: return;
2062: end if;
2063: end if;
2064:
2065: ffdict.validate_tl_dbi
2066: (p_user_name => g_glb_dbi
2067: ,p_user_entity_id => g_glb_ueid
2068: ,p_tl_user_name => l_glob_name
2069: );

Line 2097: if (ffdict.non_dbi_used_in_formula(l_dbi, tmp_bg_id, tmp_leg_code)) then

2093: hr_utility.set_message_token(802,'2','FF91_DBITEM_NAME');
2094: hr_utility.raise_error;
2095: end if;
2096:
2097: if (ffdict.non_dbi_used_in_formula(l_dbi, tmp_bg_id, tmp_leg_code)) then
2098: hr_utility.set_message (802,'FF75_ITEM_USED_IN_FORMULA');
2099: hr_utility.set_message_token('1',l_dbi);
2100: hr_utility.raise_error;
2101: end if;

Line 2103: if (ffdict.will_clash_with_context(l_dbi)) then

2099: hr_utility.set_message_token('1',l_dbi);
2100: hr_utility.raise_error;
2101: end if;
2102:
2103: if (ffdict.will_clash_with_context(l_dbi)) then
2104: hr_utility.set_message (802,'FF52_NAME_ALREADY_USED');
2105: hr_utility.set_message_token('1',l_dbi);
2106: hr_utility.set_message_token(802,'2','FF92_CONTEXT');
2107: hr_utility.raise_error;

Line 2127: hr_utility.set_location('ffdict.validate_rcu',1);

2123: procedure validate_rcu(p_route_id in number) is
2124: dummy varchar2(1);
2125: begin
2126: -- set error tracking information
2127: hr_utility.set_location('ffdict.validate_rcu',1);
2128: --
2129: -- Look for any compiled formulas which use database items based on this
2130: -- route.
2131: select 'X' into dummy from dual

Line 2181: hr_utility.set_location('ffdict.validate_rpv',1);

2177: pragma exception_init (mutating_table, -4091);
2178: pragma exception_init (invalid_cursor, -1001);
2179: begin
2180: -- set error tracking information
2181: hr_utility.set_location('ffdict.validate_rpv',1);
2182: --
2183: -- attempt to get BG details from ff_user_entities, which might be mutating
2184: -- so trap error. If it is mutating, can skip validation because a cascade
2185: -- delete is in progress and the deletion will have been validated already

Line 2193: hr_utility.set_location('ffdict.validate_rpv',2);

2189: from ff_user_entities
2190: where user_entity_id = p_user_entity_id;
2191: --
2192: -- set error tracking information
2193: hr_utility.set_location('ffdict.validate_rpv',2);
2194: -- get startup_mode based on current business group and legislation
2195: startup_mode := ffstup.get_mode (bg_id,leg_code);
2196: --
2197: -- set error tracking information

Line 2198: hr_utility.set_location('ffdict.validate_rpv',3);

2194: -- get startup_mode based on current business group and legislation
2195: startup_mode := ffstup.get_mode (bg_id,leg_code);
2196: --
2197: -- set error tracking information
2198: hr_utility.set_location('ffdict.validate_rpv',3);
2199: -- Look for any compiled formulas which use database items based on this
2200: -- user entity. Need to consider business group and legislation
2201: select 'X' into dummy from dual
2202: where exists

Line 2251: hr_utility.set_location('ffdict.validate_rpv',4);

2247: exception
2248: -- route items not used, so succeed
2249: when no_data_found then
2250: -- set error tracking information
2251: hr_utility.set_location('ffdict.validate_rpv',4);
2252: when mutating_table then
2253: -- set error tracking information
2254: hr_utility.set_location('ffdict.validate_rpv',5);
2255: when invalid_cursor then

Line 2254: hr_utility.set_location('ffdict.validate_rpv',5);

2250: -- set error tracking information
2251: hr_utility.set_location('ffdict.validate_rpv',4);
2252: when mutating_table then
2253: -- set error tracking information
2254: hr_utility.set_location('ffdict.validate_rpv',5);
2255: when invalid_cursor then
2256: hr_utility.set_location('ffdict.validate_rpv',6);
2257: end validate_rpv;
2258: --

Line 2256: hr_utility.set_location('ffdict.validate_rpv',6);

2252: when mutating_table then
2253: -- set error tracking information
2254: hr_utility.set_location('ffdict.validate_rpv',5);
2255: when invalid_cursor then
2256: hr_utility.set_location('ffdict.validate_rpv',6);
2257: end validate_rpv;
2258: --
2259: ---------------------------- create_global_dbitem -----------------------------
2260: --

Line 2281: hr_utility.set_location('ffdict.create_global_dbitem',1);

2277: l_route_parameter_id number;
2278: item_present exception;
2279: begin
2280: -- set error tracking information
2281: hr_utility.set_location('ffdict.create_global_dbitem',1);
2282: --
2283: -- Check whether DB item has already been created for this global
2284: begin
2285: select creator_id

Line 2296: hr_utility.set_location('ffdict.create_global_dbitem',2);

2292: when no_data_found then
2293: null;
2294: end;
2295: -- set error tracking information
2296: hr_utility.set_location('ffdict.create_global_dbitem',2);
2297: --
2298: -- Get route id for globals route. If not exists, create new one.
2299: begin
2300: select route_id

Line 2311: hr_utility.set_location('ffdict.create_global_dbitem',3);

2307: end;
2308: --
2309: if l_route_id is null then
2310: -- set error tracking information
2311: hr_utility.set_location('ffdict.create_global_dbitem',3);
2312: --
2313: insert into ff_routes
2314: (route_id,
2315: route_name,

Line 2333: hr_utility.set_location('ffdict.create_global_dbitem',4);

2329: p_created_by,
2330: p_creation_date
2331: );
2332: -- set error tracking information
2333: hr_utility.set_location('ffdict.create_global_dbitem',4);
2334: --
2335: insert into ff_route_parameters
2336: (route_parameter_id,
2337: route_id,

Line 2350: hr_utility.set_location('ffdict.create_global_dbitem',5);

2346: 'GLOBAL_ID',
2347: 1
2348: );
2349: -- set error tracking information
2350: hr_utility.set_location('ffdict.create_global_dbitem',5);
2351: --
2352: select ff_routes_s.currval, ff_route_parameters_s.currval
2353: into l_route_id, l_route_parameter_id
2354: from sys.dual;

Line 2357: hr_utility.set_location('ffdict.create_global_dbitem',6);

2353: into l_route_id, l_route_parameter_id
2354: from sys.dual;
2355: else
2356: -- set error tracking information
2357: hr_utility.set_location('ffdict.create_global_dbitem',6);
2358: --
2359: -- Route exists so select parameter id (should only be one)
2360: select route_parameter_id
2361: into l_route_parameter_id

Line 2367: hr_utility.set_location('ffdict.create_global_dbitem',7);

2363: where route_id = l_route_id;
2364: end if;
2365: --
2366: -- set error tracking information
2367: hr_utility.set_location('ffdict.create_global_dbitem',7);
2368: --
2369: -- Create user entity for this global
2370: insert into ff_user_entities
2371: (user_entity_id,

Line 2397: hr_utility.set_location('ffdict.create_global_dbitem',8);

2393: p_created_by,
2394: p_creation_date
2395: );
2396: -- set error tracking information
2397: hr_utility.set_location('ffdict.create_global_dbitem',8);
2398: --
2399: -- insert parameter value for this user entity. Don't forget to add quotes
2400: -- for parameter value (global name)
2401: insert into ff_route_parameter_values

Line 2416: hr_utility.set_location('ffdict.create_global_dbitem',9);

2412: p_created_by,
2413: p_creation_date
2414: );
2415: -- set error tracking information
2416: hr_utility.set_location('ffdict.create_global_dbitem',9);
2417: --
2418: insert into ff_database_items
2419: (user_name,
2420: user_entity_id,

Line 2460: hr_utility.set_location('ffdict.delete_global_dbitem',1);

2456: --
2457: procedure delete_global_dbitem(p_global_id in number) is
2458: begin
2459: -- set error tracking information
2460: hr_utility.set_location('ffdict.delete_global_dbitem',1);
2461: --
2462: -- Delete user entity created for this global with a cascade delete of
2463: -- child records in ff_database_items and ff_route_parameter_values
2464: --

Line 2485: hr_utility.set_location('ffdict.delete_ftcu_check',1);

2481: p_context_id in number) is
2482: dummy varchar2(1);
2483: begin
2484: -- set error tracking information
2485: hr_utility.set_location('ffdict.delete_ftcu_check',1);
2486: --
2487: -- Look for any compiled formulas belonging to the formula type passed
2488: -- which use the context
2489: select 'X' into dummy from dual

Line 2527: hr_utility.set_location('ffdict.delete_dbitem_check(2)',1);

2523: p_business_group_id in number,
2524: p_legislation_code in varchar2) is
2525: begin
2526: -- set error tracking information
2527: hr_utility.set_location('ffdict.delete_dbitem_check(2)',1);
2528: --
2529: -- if database item used in a formula, fail
2530: if (ffdict.is_used_in_formula(p_item_name, p_business_group_id,
2531: p_legislation_code)) then

Line 2530: if (ffdict.is_used_in_formula(p_item_name, p_business_group_id,

2526: -- set error tracking information
2527: hr_utility.set_location('ffdict.delete_dbitem_check(2)',1);
2528: --
2529: -- if database item used in a formula, fail
2530: if (ffdict.is_used_in_formula(p_item_name, p_business_group_id,
2531: p_legislation_code)) then
2532: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
2533: hr_utility.set_message_token('1',p_item_name);
2534: hr_utility.raise_error;

Line 2551: hr_utility.set_location('ffdict.delete_dbitem_check',1);

2547: procedure delete_dbitem_check(p_item_name in varchar2,
2548: p_user_entity_id in number) is
2549: begin
2550: -- set error tracking information
2551: hr_utility.set_location('ffdict.delete_dbitem_check',1);
2552:
2553: -- if database item used in a formula, fail
2554: if ffdict.dbi_used_in_formula(p_item_name, p_user_entity_id) then
2555: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');

Line 2554: if ffdict.dbi_used_in_formula(p_item_name, p_user_entity_id) then

2550: -- set error tracking information
2551: hr_utility.set_location('ffdict.delete_dbitem_check',1);
2552:
2553: -- if database item used in a formula, fail
2554: if ffdict.dbi_used_in_formula(p_item_name, p_user_entity_id) then
2555: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
2556: hr_utility.set_message_token('1',p_item_name);
2557: hr_utility.raise_error;
2558: end if;

Line 2575: hr_utility.set_location('ffdict.set_ue_details',1);

2571: business_group_id in number,
2572: legislation_code in varchar2) is
2573: begin
2574: -- set error tracking information
2575: hr_utility.set_location('ffdict.set_ue_details',1);
2576: --
2577: tmp_ue_id := user_entity_id;
2578: tmp_bg_id := business_group_id;
2579: tmp_leg_code := legislation_code;

Line 2594: hr_utility.set_location('ffdict.clear_ue_details',1);

2590: --
2591: procedure clear_ue_details is
2592: begin
2593: -- set error tracking information
2594: hr_utility.set_location('ffdict.clear_ue_details',1);
2595: --
2596: tmp_ue_id := null;
2597: tmp_bg_id := null;
2598: tmp_leg_code := null;

Line 2699: end ffdict;

2695: hr_utility.set_location('Error -'||substr(sqlerrm,1,150),99 ) ;
2696: l_pur_del.delete;
2697: raise;
2698: end pur_asd;
2699: end ffdict;