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.4 2011/12/08 11:51:00 hchintal ship $ */
3: --
4: --
5: --Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.

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

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

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

1814: ,p_year_from => p_year_from
1815: ,p_dependant_date => p_dependant_date
1816: ,p_br_flag => l_br_flag);
1817:
1818: -- hr_utility.set_location('HRSPINE - Business Rule = '||l_br_flag,55);
1819:
1820: --
1821: -- Check that all the constraints are correct
1822: --

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

1831: hr_utility.trace ('concat string = ' || p_concat_segs);
1832: --
1833: if (p_concat_segs is not null)
1834: then
1835: hr_utility.set_location ('hrspine.spine', 2);
1836: --
1837: BEGIN
1838: select concatenated_segment_delimiter
1839: into l_concat_sep

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

1929: else
1930: hr_utility.trace ('ERROR : unknown application column name');
1931: end if;
1932: end loop;
1933: hr_utility.set_location ('hrspine.spine', 4);
1934: hr_utility.set_location('Seg 1 - '||l_seg1,4);
1935: hr_utility.set_location('Seg 15 - '||l_seg15,4);
1936: end if;
1937: --

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

1959: --
1960: -- fetch standard cursor, no group partial matching
1961: --
1962: /*** vik ***/
1963: hr_utility.set_location ('hrspine.spine', 51);
1964: FETCH C_Spinal_Placements_Cursor
1965: INTO LC_Placement_ID,
1966: LC_Step_ID,
1967: LC_Assignment_ID,

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

1976: l_grade_spine_id;
1977: -- vik
1978: if (C_Spinal_Placements_Cursor%notfound)
1979: then
1980: hr_utility.set_location ('hrspine.spine', 69);
1981: hr_utility.set_location ('no data found', 69);
1982: hr_utility.set_location ('in C_Spinal_Placements_Cursor',69);
1983: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1984: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);

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

1983: hr_utility.set_location ('for'||TO_CHAR(LC_Assignment_ID),69);
1984: hr_utility.set_location ('and for'||TO_CHAR(LC_Placement_ID),69);
1985: hr_utility.set_location ('for'|| P_Parent_Spine_ID,69);
1986: else
1987: hr_utility.set_location ('hrspine.spine', 79);
1988: hr_utility.set_location ('C_Spinal_Placements_Cur success',79);
1989: hr_utility.set_location ('for '||TO_CHAR(LC_Assignment_ID),79);
1990: hr_utility.set_location ('and for '||TO_CHAR(LC_Placement_ID),79);
1991: hr_utility.set_location ('for'|| P_Parent_Spine_ID,79);

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

1998: else
1999: --
2000: -- fetch key cursor, with group partial matching
2001: --
2002: hr_utility.set_location ('hrspine.spine', 6);
2003: FETCH C_Key_Spinal_Placements_Cursor
2004: INTO LC_Placement_ID,
2005: LC_Step_ID,
2006: LC_Assignment_ID,

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

2443: if (p_concat_segs is null) then
2444: --
2445: -- fetch standard cursor, no group partial matching
2446: --
2447: hr_utility.set_location ('hrspine.spine', 52);
2448: FETCH C_Spinal_Placements_Cursor
2449: INTO LC_Placement_ID,
2450: LC_Step_ID,
2451: LC_Assignment_ID,

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

2466: else
2467: --
2468: -- fetch key cursor, with group partial matching
2469: --
2470: hr_utility.set_location ('hrspine.spine', 6);
2471: FETCH C_Key_Spinal_Placements_Cursor
2472: INTO LC_Placement_ID,
2473: LC_Step_ID,
2474: LC_Assignment_ID,

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

2615:
2616: -- -----------------------------------------------------------
2617: -- set last auto inc. date on parent spine
2618: -- -----------------------------------------------------------
2619: hr_utility.set_location ('hrspine.spine', 11);
2620: UPDATE per_parent_spines
2621: SET last_automatic_increment_date = P_Effective_Date,
2622: last_update_date = sysdate,
2623: program_update_date = sysdate

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

2632: --
2633: else
2634: --
2635: p_message_number := null;
2636: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2637: end if;
2638: hr_utility.set_location ('hrspine.spine', 12);
2639: --
2640: END spine;

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

2634: --
2635: p_message_number := null;
2636: hr_utility.set_location ('hrspine.spine shd be sweet', 11);
2637: end if;
2638: hr_utility.set_location ('hrspine.spine', 12);
2639: --
2640: END spine;
2641: --
2642: END hrspine;

Line 2642: END hrspine;

2638: hr_utility.set_location ('hrspine.spine', 12);
2639: --
2640: END spine;
2641: --
2642: END hrspine;