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.HRSPINE dependencies on HRSPINE

Line 1: package body hrspine as

1: package body hrspine as
2: /* $Header: pespines.pkb 120.2.12010000.2 2008/08/06 09:38:02 ubhat ship $ */
3: --
4: --
5: --Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.

Line 1105: hr_utility.set_location ('hrspine.spine', 1222);

1101: ||l_future_sequence_id, 1700);
1102: hr_utility.set_location('l_grade_max_sequence '
1103: ||l_grade_max_sequence, 1700);
1104: END;
1105: hr_utility.set_location ('hrspine.spine', 1222);
1106: hr_utility.set_location ('count(sps.sequence):'||L_Max_Count,12222);
1107: -- ------------------------------------------------------------------
1108: -- Checks the increment by number is not greater than
1109: -- the max number of steps left for the grade

Line 1811: -- hr_utility.set_location('HRSPINE - Business Rule = '||l_br_flag,55);

1807: ,p_year_from => p_year_from
1808: ,p_dependant_date => p_dependant_date
1809: ,p_br_flag => l_br_flag);
1810:
1811: -- hr_utility.set_location('HRSPINE - Business Rule = '||l_br_flag,55);
1812:
1813: --
1814: -- Check that all the constraints are correct
1815: --

Line 1828: hr_utility.set_location ('hrspine.spine', 2);

1824: hr_utility.trace ('concat string = ' || p_concat_segs);
1825: --
1826: if (p_concat_segs is not null)
1827: then
1828: hr_utility.set_location ('hrspine.spine', 2);
1829: --
1830: BEGIN
1831: select concatenated_segment_delimiter
1832: into l_concat_sep

Line 1926: hr_utility.set_location ('hrspine.spine', 4);

1922: else
1923: hr_utility.trace ('ERROR : unknown application column name');
1924: end if;
1925: end loop;
1926: hr_utility.set_location ('hrspine.spine', 4);
1927: hr_utility.set_location('Seg 1 - '||l_seg1,4);
1928: hr_utility.set_location('Seg 15 - '||l_seg15,4);
1929: end if;
1930: --

Line 1956: hr_utility.set_location ('hrspine.spine', 51);

1952: --
1953: -- fetch standard cursor, no group partial matching
1954: --
1955: /*** vik ***/
1956: hr_utility.set_location ('hrspine.spine', 51);
1957: FETCH C_Spinal_Placements_Cursor
1958: INTO LC_Placement_ID,
1959: LC_Step_ID,
1960: LC_Assignment_ID,

Line 1973: hr_utility.set_location ('hrspine.spine', 69);

1969: l_grade_spine_id;
1970: -- vik
1971: if (C_Spinal_Placements_Cursor%notfound)
1972: then
1973: hr_utility.set_location ('hrspine.spine', 69);
1974: hr_utility.set_location ('no data found', 69);
1975: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);

Line 1980: hr_utility.set_location ('hrspine.spine', 79);

1976: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1977: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1978: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1979: else
1980: hr_utility.set_location ('hrspine.spine', 79);
1981: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1982: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1983: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1984: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);

Line 1995: hr_utility.set_location ('hrspine.spine', 6);

1991: else
1992: --
1993: -- fetch key cursor, with group partial matching
1994: --
1995: hr_utility.set_location ('hrspine.spine', 6);
1996: FETCH C_Key_Spinal_Placements_Cursor
1997: INTO LC_Placement_ID,
1998: LC_Step_ID,
1999: LC_Assignment_ID,

Line 2440: hr_utility.set_location ('hrspine.spine', 52);

2436: if (p_concat_segs is null) then
2437: --
2438: -- fetch standard cursor, no group partial matching
2439: --
2440: hr_utility.set_location ('hrspine.spine', 52);
2441: FETCH C_Spinal_Placements_Cursor
2442: INTO LC_Placement_ID,
2443: LC_Step_ID,
2444: LC_Assignment_ID,

Line 2463: hr_utility.set_location ('hrspine.spine', 6);

2459: else
2460: --
2461: -- fetch key cursor, with group partial matching
2462: --
2463: hr_utility.set_location ('hrspine.spine', 6);
2464: FETCH C_Key_Spinal_Placements_Cursor
2465: INTO LC_Placement_ID,
2466: LC_Step_ID,
2467: LC_Assignment_ID,

Line 2612: hr_utility.set_location ('hrspine.spine', 11);

2608:
2609: -- -----------------------------------------------------------
2610: -- set last auto inc. date on parent spine
2611: -- -----------------------------------------------------------
2612: hr_utility.set_location ('hrspine.spine', 11);
2613: UPDATE per_parent_spines
2614: SET last_automatic_increment_date = P_Effective_Date,
2615: last_update_date = sysdate,
2616: program_update_date = sysdate

Line 2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);

2625: --
2626: else
2627: --
2628: p_message_number := null;
2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2630: end if;
2631: hr_utility.set_location ('hrspine.spine', 12);
2632: --
2633: END spine;

Line 2631: hr_utility.set_location ('hrspine.spine', 12);

2627: --
2628: p_message_number := null;
2629: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2630: end if;
2631: hr_utility.set_location ('hrspine.spine', 12);
2632: --
2633: END spine;
2634: --
2635: END hrspine;

Line 2635: END hrspine;

2631: hr_utility.set_location ('hrspine.spine', 12);
2632: --
2633: END spine;
2634: --
2635: END hrspine;