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.PQP_GB_T1_PENSION_EXTRACTS dependencies on HR_UTILITY

Line 30: hr_utility.set_location

26: - LEAST(LENGTH(p_trace_message)
27: ,l_MAX_MESSAGE_LENGTH)
28: );
29:
30: hr_utility.set_location
31: (l_padding||
32: SUBSTR(p_trace_message
33: ,GREATEST(-LENGTH(p_trace_message),-l_MAX_MESSAGE_LENGTH))
34: ,p_trace_location);

Line 38: hr_utility.trace(SUBSTR(p_trace_message,1,250));

34: ,p_trace_location);
35:
36: ELSE
37:
38: hr_utility.trace(SUBSTR(p_trace_message,1,250));
39:
40: END IF;
41:
42: END debug;

Line 109: hr_utility.trace_on(NULL,'REQID'); -- Pipe name REQIDnnnnnn

105: IF NVL(p_trace_on,'N') = 'Y'
106: OR
107: g_trace = 'Y' THEN
108:
109: hr_utility.trace_on(NULL,'REQID'); -- Pipe name REQIDnnnnnn
110:
111: END IF; -- NVL(p_trace_on,'N') = 'Y'
112: --
113: END IF; -- if nested level = 0

Line 144: hr_utility.trace_off;

140: )
141: OR
142: NVL(p_trace_off,'N') = 'Y' THEN
143:
144: hr_utility.trace_off;
145:
146: END IF; -- (g_nested_level = 0
147:
148: END debug_exit;

Line 1613: -- hr_utility.set_location('Entering: '||l_proc_name, 5);

1609: --
1610: begin
1611:
1612: --
1613: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
1614: --
1615: debug_enter(l_proc_name);
1616:
1617: open csr_get_pay_bal_id

Line 1630: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);

1626:
1627: debug_exit(l_proc_name);
1628:
1629: --
1630: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);
1631: --
1632: p_legislation_code := l_bal_type_id.legislation_code;
1633:
1634: return l_bal_type_id.balance_type_id;

Line 1665: -- hr_utility.set_location('Entering: '||l_proc_name, 5);

1661: --
1662: begin
1663:
1664: --
1665: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
1666: --
1667:
1668: debug_enter(l_proc_name);
1669:

Line 1930: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

1926: l_seed_flag VARCHAR2(1); -- flag to signify if balance is seeded/user defined
1927: --
1928: begin
1929: --
1930: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
1931: --
1932: debug_enter (l_proc_name);
1933:
1934: -- Get Absence balance name from the UDT

Line 2217: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

2213:
2214: --
2215: begin
2216: --
2217: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
2218: --
2219: debug_enter (l_proc_name);
2220:
2221: g_abs_bal_type_id.DELETE;

Line 2263: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);

2259:
2260: END IF; -- End if of multiple business groups exists check ...
2261:
2262: --
2263: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
2264: --
2265: debug_exit (l_proc_name);
2266:
2267: EXCEPTION

Line 2297: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

2293: l_error number;
2294: --
2295: begin
2296: --
2297: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
2298: --
2299: debug_enter (l_proc_name);
2300:
2301: l_tab_rate_type(1) := 'Other Allowances';

Line 2362: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);

2358: g_sf_rate_type := l_tab_rate_name(3);
2359: g_lon_rate_type := l_tab_rate_name(4);
2360:
2361: --
2362: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
2363: --
2364: debug_exit (l_proc_name);
2365: EXCEPTION
2366: WHEN OTHERS THEN

Line 6037: -- hr_utility.set_location('Entering: '||l_proc_name, 5);

6033: l_larp_spap_count NUMBER;
6034:
6035:
6036: Begin
6037: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
6038: debug_enter(l_proc_name);
6039: debug('p_allowance_type :'||p_allowance_type, 10);
6040: l_count_ele_entries := 0;
6041: For i in 1..4 Loop

Line 6141: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);

6137: End Loop;
6138: End If;
6139: debug('Return value :'||l_return_value, 110);
6140: debug_exit(l_proc_name);
6141: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);
6142:
6143: Return l_return_value;
6144: EXCEPTION
6145: WHEN OTHERS THEN

Line 6176: -- hr_utility.set_location('Entering: '||l_proc_name, 5);

6172: l_proc_name varchar2(60) := g_proc_name || 'Get_Grade_Fasttrack_Info';
6173: l_aat_info csr_get_aat_info%rowtype;
6174: l_return_value char(1):= ' ';
6175: Begin
6176: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
6177: debug_enter(l_proc_name);
6178: Open csr_get_aat_info
6179: (c_assignment_id => p_assignment_id
6180: ,c_effective_date => p_effective_date

Line 6199: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);

6195: Close csr_get_aat_info;
6196:
6197: debug('Return value :'||l_return_value, 20);
6198: debug_exit(l_proc_name);
6199: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);
6200:
6201: Return l_return_value;
6202:
6203: EXCEPTION

Line 6232: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

6228: l_value number := 0;
6229: --
6230: begin
6231: --
6232: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
6233: --
6234: debug_enter (l_proc_name);
6235:
6236: open csr_ele_rate_id (c_rate_name => p_rate_name

Line 6310: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);

6306: end if; -- end if of attribute id not null check ...
6307:
6308: debug('Return Value :'||to_char(l_value), 50);
6309: --
6310: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);
6311: --
6312: debug_exit (l_proc_name);
6313:
6314: return l_value;

Line 6498: --hr_utility.set_location('l_chk_assign_link' ||l_chk_assign_link, 40);

6494:
6495: END IF ; -- IF l_link_to_assign = 'Y'
6496:
6497: debug('l_chk_assign_link' || l_chk_assign_link, 40);
6498: --hr_utility.set_location('l_chk_assign_link' ||l_chk_assign_link, 40);
6499:
6500: IF l_chk_assign_link = 'Y' THEN
6501:
6502: --debug('Element Type Id :'||l_element_set.element_type_id);

Line 6609: -- hr_utility.set_location('Leaving: '||l_proc_name, 60);

6605: p_rate := round(l_total_rate, 5);
6606:
6607: debug('p_rate :'||to_char(p_rate), 60);
6608: --
6609: -- hr_utility.set_location('Leaving: '||l_proc_name, 60);
6610: --
6611: debug_exit(l_proc_name);
6612:
6613: return 0;

Line 6632: debug('error message for contract missing :' || hr_utility.get_message, 98);

6628: if csr_element_set%ISOPEN then -- BUG 4431495 : checking if cursor is open
6629: close csr_element_set;
6630: end if;
6631:
6632: debug('error message for contract missing :' || hr_utility.get_message, 98);
6633:
6634: debug('hr_application_error RAISED in Type1 rates_history function', 70);
6635:
6636: debug('Trying to raise a PQP error message', 98);

Line 7025: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

7021:
7022: --
7023: begin
7024: --
7025: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
7026: --
7027: debug_enter(l_proc_name);
7028:
7029: -- nocopy changes

Line 7196: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);

7192:
7193: debug('Total Annual Rate :'||l_annual_rate);
7194:
7195: --
7196: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);
7197: --
7198: debug_exit(l_proc_name);
7199:
7200: --PERF_ENHANC_3A : performance enhancements

Line 7237: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

7233: l_safeguarded_yn varchar2(1) := 'N';
7234: --
7235: begin
7236: --
7237: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
7238: --
7239: debug_enter(l_proc_name);
7240:
7241: open csr_paa_rate_id (c_assignment_id => p_assignment_id

Line 7255: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);

7251:
7252: end if; -- end if of tp_safeguarded_grade is not null check...
7253:
7254: --
7255: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
7256: --
7257: debug_exit(l_proc_name);
7258:
7259: return l_safeguarded_yn;

Line 8927: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

8923: l_supp_claim number := 0;
8924: --
8925: begin
8926: --
8927: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
8928: --
8929: debug_enter(l_proc_name);
8930:
8931: debug('p_assignment_id :' ||to_char(p_assignment_id),10) ;

Line 8994: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);

8990: END IF;
8991:
8992: debug('l_total_part_time_sal :'||to_char(l_total_part_time_sal),90);
8993: --
8994: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);
8995: --
8996: debug_exit(l_proc_name);
8997:
8998: return l_total_part_time_sal;

Line 9542: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

9538: l_look_for_sec_asg varchar2(1) := 'Y';
9539: --
9540: begin
9541: --
9542: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
9543: --
9544: debug_enter(l_proc_name);
9545: debug('p_assignment_id: '||p_assignment_id);
9546: debug('p_effective_start_date: '||p_effective_start_date);

Line 9695: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);

9691: END IF; -- End if of secondary assignment exists check ...
9692: -- round the pt salary after adding all the asg contributions.
9693: l_part_time_sal := round(l_part_time_sal);
9694: --
9695: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);
9696: --
9697: debug('l_part_time_sal :'||to_char(l_part_time_sal),120);
9698:
9699: -- 4336613 : SAL_VALIDAT_3A : Check whether part time sal value has exceeeded 5 digit limit

Line 9741: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

9737: l_days_worked number := 0;
9738: --
9739: begin
9740: --
9741: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9742: --
9743: debug_enter(l_proc_name);
9744:
9745: -- Call this function only if salary rate is non zero

Line 9769: -- hr_utility.set_location ('Leaving: '||l_proc_name, 20);

9765:
9766: end if; -- end if of annual rate value check ...
9767:
9768: --
9769: -- hr_utility.set_location ('Leaving: '||l_proc_name, 20);
9770: --
9771: debug('l_days_worked :'||to_char(l_days_worked));
9772: debug_exit(l_proc_name);
9773:

Line 9797: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

9793: l_proc_name varchar2(60) := g_proc_name || 'get_eev_info';
9794: --
9795: begin
9796: --
9797: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9798: --
9799: debug_enter(l_proc_name);
9800:
9801: open csr_get_eev_info_date

Line 9811: -- hr_utility.set_location ('Leaving :'||l_proc_name, 20);

9807: fetch csr_get_eev_info_date into p_tab_eev_info;
9808: close csr_get_eev_info_date;
9809:
9810: --
9811: -- hr_utility.set_location ('Leaving :'||l_proc_name, 20);
9812: --
9813: debug_exit(l_proc_name);
9814:
9815: -- Added by tmehra for nocopy changes Feb'03

Line 9847: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

9843: l_ref_date date;
9844: --
9845: begin
9846: --
9847: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9848: --
9849: debug_enter(l_proc_name);
9850:
9851: -- Get input value id for Start Date

Line 9937: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);

9933: close csr_get_eev_info;
9934:
9935: debug('l_total_days :'||to_char(l_total_days), 40);
9936: --
9937: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);
9938: --
9939: debug_exit(l_proc_name);
9940:
9941: return l_total_days;

Line 9966: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);

9962: l_total_days number := 0;
9963: --
9964: begin
9965: --
9966: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9967: --
9968: debug_enter(l_proc_name);
9969:
9970: -- Check element entries exist in absence ele's

Line 10004: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);

10000: close csr_get_eet_info;
10001:
10002: debug('l_total_days :'||to_char(l_total_days), 30);
10003: --
10004: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
10005: --
10006: debug_exit(l_proc_name);
10007:
10008: return l_total_days;

Line 10035: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

10031:
10032: --
10033: begin
10034: --
10035: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
10036: --
10037: debug_enter(l_proc_name);
10038:
10039: -- GAP9: Modified function to incorporate changes for supply teachers

Line 10197: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);

10193: l_days_excluded := floor(l_days_excluded);
10194:
10195: debug ('Total Days Excluded: '|| to_char(l_days_excluded));
10196: --
10197: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
10198: --
10199: debug_exit(l_proc_name);
10200:
10201: return l_days_excluded;

Line 10239: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

10235: l_equal_sal_rate varchar2(1) := 'Y'; -- bug 6275363
10236: --
10237: begin
10238: --
10239: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
10240: --
10241: debug_enter(l_proc_name);
10242: debug(l_proc_name||'p_assignment_id:'||p_assignment_id, 15);
10243: debug(l_proc_name||'p_effective_start_date:'||to_char(p_effective_start_date,'DD/MM/YY'), 15);

Line 10465: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);

10461: else -- secondary asg annual sal rate is in error
10462:
10463: p_days := 0;
10464: --
10465: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10466: --
10467: debug (l_proc_name ||'p_days:'||p_days, 80);
10468: debug (l_proc_name, 80);
10469:

Line 10520: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);

10516: END IF;
10517:
10518: --
10519: --
10520: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10521: --
10522: -- debug_exit(l_proc_name);
10523:
10524: p_days := l_days_excluded;

Line 10552: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);

10548: -------------------------------
10549: else -- primary asg annual sal is in error
10550:
10551: --
10552: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10553: --
10554: debug_exit(l_proc_name);
10555:
10556: p_days := 0;

Line 10599: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

10595: l_error NUMBER;
10596: --
10597: begin
10598: --
10599: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
10600: --
10601: debug_enter(l_proc_name);
10602:
10603: -- Check whether employment category is part time or full time

Line 10771: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);

10767:
10768: debug(l_proc_name||'l_days_excluded:'||l_days_excluded, 70);
10769: debug(l_proc_name||'l_return:'||l_return, 70);
10770: --
10771: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);
10772: --
10773: -- bug 6275363------
10774: IF l_return = -2 THEN
10775: debug(l_proc_name, 71);

Line 12569: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

12565: l_return number;
12566: --
12567: begin
12568: --
12569: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12570: --
12571: debug_enter(l_proc_name);
12572: debug(l_proc_name||' p_assignment_id:'||p_assignment_id, 15);
12573:

Line 12591: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);

12587: ,p_days => l_days_excluded
12588: );
12589:
12590: --
12591: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
12592: --
12593: -- bug 6275363---------
12594: IF l_return = -2 then
12595: p_days_excluded := '+00';

Line 12637: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

12633: l_annual_rate number;
12634: --
12635: begin
12636: --
12637: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12638: --
12639: debug_enter(l_proc_name);
12640:
12641: -- Bugfix 3803760:FTSUPPLY

Line 12658: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);

12654: ,p_rate => l_annual_rate
12655: );
12656:
12657: --
12658: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
12659: --
12660: debug_exit(l_proc_name);
12661:
12662: if l_return <> -1 then

Line 12699: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

12695: l_return number;
12696: --
12697: begin
12698: --
12699: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12700: --
12701: debug_enter(l_proc_name);
12702: debug('p_assignment_id '||p_assignment_id,10) ;
12703:

Line 12983: -- hr_utility.set_location('Entering: '||l_proc_name, 10);

12979: l_error number;
12980: --
12981: begin
12982: --
12983: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12984: --
12985: debug_enter(l_proc_name);
12986:
12987: if g_other_allowance.exists(p_assignment_id) then

Line 13018: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);

13014: end if; -- end if of other allowance exists check...
13015:
13016:
13017: --
13018: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
13019: --
13020: debug_exit(l_proc_name);
13021:
13022: return l_other_allowance;

Line 17717: -- hr_utility.set_location('Entering: '||l_proc_name, 5);

17713: l_count number;
17714: l_proc_name varchar2(60) := g_proc_name || 'Get_Allowance_Code_New';
17715:
17716: Begin
17717: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
17718: debug_enter(l_proc_name);
17719: debug('p_allowance_type :'||p_allowance_type, 10);
17720:
17721: