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.

[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on HR_UTILITY

Line 31: hr_utility.set_location

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

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

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

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

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

Line 145: hr_utility.trace_off;

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

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

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

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

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

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

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

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

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

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

2186:
2187: --
2188: begin
2189: --
2190: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
2191: --
2192: debug_enter (l_proc_name);
2193:
2194: g_abs_bal_type_id.DELETE;

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

2231:
2232: END IF; -- End if of multiple business groups exists check ...
2233:
2234: --
2235: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
2236: --
2237: debug_exit (l_proc_name);
2238:
2239: EXCEPTION

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

2265: l_error number;
2266: --
2267: begin
2268: --
2269: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
2270: --
2271: debug_enter (l_proc_name);
2272:
2273: l_tab_rate_type(1) := 'Other Allowances';

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

2330: g_sf_rate_type := l_tab_rate_name(3);
2331: g_lon_rate_type := l_tab_rate_name(4);
2332:
2333: --
2334: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
2335: --
2336: debug_exit (l_proc_name);
2337: EXCEPTION
2338: WHEN OTHERS THEN

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

6005: l_larp_spap_count NUMBER;
6006:
6007:
6008: Begin
6009: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
6010: debug_enter(l_proc_name);
6011: debug('p_allowance_type :'||p_allowance_type, 10);
6012: l_count_ele_entries := 0;
6013: For i in 1..4 Loop

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

6109: End Loop;
6110: End If;
6111: debug('Return value :'||l_return_value, 110);
6112: debug_exit(l_proc_name);
6113: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);
6114:
6115: Return l_return_value;
6116: EXCEPTION
6117: WHEN OTHERS THEN

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

6144: l_proc_name varchar2(60) := g_proc_name || 'Get_Grade_Fasttrack_Info';
6145: l_aat_info csr_get_aat_info%rowtype;
6146: l_return_value char(1):= ' ';
6147: Begin
6148: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
6149: debug_enter(l_proc_name);
6150: Open csr_get_aat_info
6151: (c_assignment_id => p_assignment_id
6152: ,c_effective_date => p_effective_date

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

6167: Close csr_get_aat_info;
6168:
6169: debug('Return value :'||l_return_value, 20);
6170: debug_exit(l_proc_name);
6171: -- hr_utility.set_location('Leaving: '||l_proc_name, 15);
6172:
6173: Return l_return_value;
6174:
6175: EXCEPTION

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

6200: l_value number := 0;
6201: --
6202: begin
6203: --
6204: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
6205: --
6206: debug_enter (l_proc_name);
6207:
6208: open csr_ele_rate_id (c_rate_name => p_rate_name

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

6278: end if; -- end if of attribute id not null check ...
6279:
6280: debug('Return Value :'||to_char(l_value), 50);
6281: --
6282: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);
6283: --
6284: debug_exit (l_proc_name);
6285:
6286: return l_value;

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

6466:
6467: END IF ; -- IF l_link_to_assign = 'Y'
6468:
6469: debug('l_chk_assign_link' || l_chk_assign_link, 40);
6470: --hr_utility.set_location('l_chk_assign_link' ||l_chk_assign_link, 40);
6471:
6472: IF l_chk_assign_link = 'Y' THEN
6473:
6474: --debug('Element Type Id :'||l_element_set.element_type_id);

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

6577: p_rate := round(l_total_rate, 5);
6578:
6579: debug('p_rate :'||to_char(p_rate), 60);
6580: --
6581: -- hr_utility.set_location('Leaving: '||l_proc_name, 60);
6582: --
6583: debug_exit(l_proc_name);
6584:
6585: return 0;

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

6600: if csr_element_set%ISOPEN then -- BUG 4431495 : checking if cursor is open
6601: close csr_element_set;
6602: end if;
6603:
6604: debug('error message for contract missing :' || hr_utility.get_message, 98);
6605:
6606: debug('hr_application_error RAISED in Type1 rates_history function', 70);
6607:
6608: debug('Trying to raise a PQP error message', 98);

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

6993:
6994: --
6995: begin
6996: --
6997: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
6998: --
6999: debug_enter(l_proc_name);
7000:
7001: -- nocopy changes

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

7164:
7165: debug('Total Annual Rate :'||l_annual_rate);
7166:
7167: --
7168: -- hr_utility.set_location('Leaving: '||l_proc_name, 50);
7169: --
7170: debug_exit(l_proc_name);
7171:
7172: --PERF_ENHANC_3A : performance enhancements

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

7205: l_safeguarded_yn varchar2(1) := 'N';
7206: --
7207: begin
7208: --
7209: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
7210: --
7211: debug_enter(l_proc_name);
7212:
7213: open csr_paa_rate_id (c_assignment_id => p_assignment_id

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

7223:
7224: end if; -- end if of tp_safeguarded_grade is not null check...
7225:
7226: --
7227: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
7228: --
7229: debug_exit(l_proc_name);
7230:
7231: return l_safeguarded_yn;

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

8872: l_supp_claim number := 0;
8873: --
8874: begin
8875: --
8876: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
8877: --
8878: debug_enter(l_proc_name);
8879:
8880: debug('p_assignment_id :' ||to_char(p_assignment_id),10) ;

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

8939: END IF;
8940:
8941: debug('l_total_part_time_sal :'||to_char(l_total_part_time_sal),90);
8942: --
8943: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);
8944: --
8945: debug_exit(l_proc_name);
8946:
8947: return l_total_part_time_sal;

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

9418: l_look_for_sec_asg varchar2(1) := 'Y';
9419: --
9420: begin
9421: --
9422: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
9423: --
9424: debug_enter(l_proc_name);
9425: debug('p_assignment_id: '||p_assignment_id);
9426: debug('p_effective_start_date: '||p_effective_start_date);

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

9571: END IF; -- End if of secondary assignment exists check ...
9572: -- round the pt salary after adding all the asg contributions.
9573: l_part_time_sal := round(l_part_time_sal);
9574: --
9575: -- hr_utility.set_location('Leaving: '||l_proc_name, 30);
9576: --
9577: debug('l_part_time_sal :'||to_char(l_part_time_sal),120);
9578:
9579: -- 4336613 : SAL_VALIDAT_3A : Check whether part time sal value has exceeeded 5 digit limit

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

9617: l_days_worked number := 0;
9618: --
9619: begin
9620: --
9621: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9622: --
9623: debug_enter(l_proc_name);
9624:
9625: -- Call this function only if salary rate is non zero

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

9645:
9646: end if; -- end if of annual rate value check ...
9647:
9648: --
9649: -- hr_utility.set_location ('Leaving: '||l_proc_name, 20);
9650: --
9651: debug('l_days_worked :'||to_char(l_days_worked));
9652: debug_exit(l_proc_name);
9653:

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

9673: l_proc_name varchar2(60) := g_proc_name || 'get_eev_info';
9674: --
9675: begin
9676: --
9677: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9678: --
9679: debug_enter(l_proc_name);
9680:
9681: open csr_get_eev_info_date

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

9687: fetch csr_get_eev_info_date into p_tab_eev_info;
9688: close csr_get_eev_info_date;
9689:
9690: --
9691: -- hr_utility.set_location ('Leaving :'||l_proc_name, 20);
9692: --
9693: debug_exit(l_proc_name);
9694:
9695: -- Added by tmehra for nocopy changes Feb'03

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

9723: l_ref_date date;
9724: --
9725: begin
9726: --
9727: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9728: --
9729: debug_enter(l_proc_name);
9730:
9731: -- Get input value id for Start Date

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

9813: close csr_get_eev_info;
9814:
9815: debug('l_total_days :'||to_char(l_total_days), 40);
9816: --
9817: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);
9818: --
9819: debug_exit(l_proc_name);
9820:
9821: return l_total_days;

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

9842: l_total_days number := 0;
9843: --
9844: begin
9845: --
9846: -- hr_utility.set_location ('Entering: '||l_proc_name, 10);
9847: --
9848: debug_enter(l_proc_name);
9849:
9850: -- Check element entries exist in absence ele's

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

9880: close csr_get_eet_info;
9881:
9882: debug('l_total_days :'||to_char(l_total_days), 30);
9883: --
9884: -- hr_utility.set_location ('Leaving: '||l_proc_name, 30);
9885: --
9886: debug_exit(l_proc_name);
9887:
9888: return l_total_days;

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

9911:
9912: --
9913: begin
9914: --
9915: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
9916: --
9917: debug_enter(l_proc_name);
9918:
9919: -- GAP9: Modified function to incorporate changes for supply teachers

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

10029: l_days_excluded := floor(l_days_excluded);
10030:
10031: debug ('Total Days Excluded: '|| to_char(l_days_excluded));
10032: --
10033: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
10034: --
10035: debug_exit(l_proc_name);
10036:
10037: return l_days_excluded;

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

10071: l_equal_sal_rate varchar2(1) := 'Y'; -- bug 6275363
10072: --
10073: begin
10074: --
10075: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
10076: --
10077: debug_enter(l_proc_name);
10078:
10079: -- Proceed only if primary assignment qualifies

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

10294: else -- secondary asg annual sal rate is in error
10295:
10296: p_days := 0;
10297: --
10298: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10299: --
10300: debug (l_proc_name, 80);
10301:
10302: debug_exit(l_proc_name);

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

10340: END IF;
10341:
10342: --
10343: --
10344: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10345: --
10346: debug_exit(l_proc_name);
10347:
10348: p_days := l_days_excluded;

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

10357: -------------------------------
10358: else -- primary asg annual sal is in error
10359:
10360: --
10361: -- hr_utility.set_location ('Leaving: '||l_proc_name, 80);
10362: --
10363: debug_exit(l_proc_name);
10364:
10365: p_days := 0;

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

10404: l_error NUMBER;
10405: --
10406: begin
10407: --
10408: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
10409: --
10410: debug_enter(l_proc_name);
10411:
10412: -- Check whether employment category is part time or full time

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

10570:
10571: -- end if; -- end if of employment category check ...
10572:
10573: --
10574: -- hr_utility.set_location ('Leaving: '||l_proc_name, 40);
10575: --
10576: -- bug 6275363------
10577: IF l_return = -2 THEN
10578: debug(l_proc_name, 71);

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

12367: l_return number;
12368: --
12369: begin
12370: --
12371: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12372: --
12373: debug_enter(l_proc_name);
12374:
12375: -- Bugfix 3803760:FTSUPPLY

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

12388: ,p_days => l_days_excluded
12389: );
12390:
12391: --
12392: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
12393: --
12394: -- bug 6275363---------
12395: IF l_return = -2 then
12396: p_days_excluded := '+00';

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

12434: l_annual_rate number;
12435: --
12436: begin
12437: --
12438: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12439: --
12440: debug_enter(l_proc_name);
12441:
12442: -- Bugfix 3803760:FTSUPPLY

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

12455: ,p_rate => l_annual_rate
12456: );
12457:
12458: --
12459: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
12460: --
12461: debug_exit(l_proc_name);
12462:
12463: if l_return <> -1 then

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

12496: l_return number;
12497: --
12498: begin
12499: --
12500: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12501: --
12502: debug_enter(l_proc_name);
12503: debug('p_assignment_id '||p_assignment_id,10) ;
12504:

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

12780: l_error number;
12781: --
12782: begin
12783: --
12784: -- hr_utility.set_location('Entering: '||l_proc_name, 10);
12785: --
12786: debug_enter(l_proc_name);
12787:
12788: if g_other_allowance.exists(p_assignment_id) then

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

12815: end if; -- end if of other allowance exists check...
12816:
12817:
12818: --
12819: -- hr_utility.set_location('Leaving: '||l_proc_name, 20);
12820: --
12821: debug_exit(l_proc_name);
12822:
12823: return l_other_allowance;

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

17344: l_count number;
17345: l_proc_name varchar2(60) := g_proc_name || 'Get_Allowance_Code_New';
17346:
17347: Begin
17348: -- hr_utility.set_location('Entering: '||l_proc_name, 5);
17349: debug_enter(l_proc_name);
17350: debug('p_allowance_type :'||p_allowance_type, 10);
17351:
17352: