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_TP_TYPE2_FUNCTIONS dependencies on HR_UTILITY

Line 37: hr_utility.set_location (l_padding || substr(p_trace_message

33: - least(length(p_trace_message)
34: ,l_max_message_length)
35: );
36:
37: hr_utility.set_location (l_padding || substr(p_trace_message
38: ,greatest(-length(p_trace_message),-l_max_message_length))
39: ,p_trace_location);
40:
41: Else

Line 43: hr_utility.trace(substr(p_trace_message,1,250));

39: ,p_trace_location);
40:
41: Else
42:
43: hr_utility.trace(substr(p_trace_message,1,250));
44:
45: End If;
46: --
47:

Line 101: -- hr_utility.trace_on(null,'REQID'); -- Pipe name REQIDnnnnnn

97: -- If g_nested_level = 0 -- swtich tracing on/off at the top level only
98: -- And nvl(p_trace_on,'N') = 'Y'
99: -- Then
100: --
101: -- hr_utility.trace_on(null,'REQID'); -- Pipe name REQIDnnnnnn
102:
103: -- End If; -- if nested level = 0
104: --
105: -- --Uncomment this code to run the extract with a debug trace

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

167: IF NVL(p_trace_on,'N') = 'Y'
168: OR
169: g_trace = 'Y' THEN
170:
171: hr_utility.trace_on(NULL,'REQID'); -- Pipe name REQIDnnnnnn
172: debug(':Switching on the Trace: ',000);
173:
174: END IF; -- NVL(p_trace_on,'N') = 'Y'
175: --

Line 209: hr_utility.trace_off;

205: )
206: OR
207: NVL(p_trace_off,'N') = 'Y' THEN
208: debug(':Switching off the Trace: ',000);
209: hr_utility.trace_off;
210:
211: END IF; -- (g_nested_level = 0
212:
213: END debug_exit;

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

226: --
227: Begin
228:
229: --
230: hr_utility.set_location('Entering: '||l_proc_name, 5);
231: --
232: debug_enter(l_proc_name);
233:
234: If to_number(to_char(g_effective_date, 'MM'))

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

266:
267:
268: --debug(':g_header_system_element:'||g_header_system_element,530);
269: --
270: hr_utility.set_location('Leaving: '||l_proc_name, 15);
271: --
272: debug_exit(l_proc_name);
273:
274:

Line 375: hr_utility.set_location('Entering excep:'||l_proc_name, 25);

371: -- Added by tmehra for nocopy changes Feb'03
372:
373: EXCEPTION
374: WHEN OTHERS THEN
375: hr_utility.set_location('Entering excep:'||l_proc_name, 25);
376:
377: p_tab_ele_ids.delete;
378:
379: RAISE;

Line 1091: hr_utility.set_location('Entering excep:'||l_proc_name, 35);

1087: --
1088: EXCEPTION
1089: WHEN OTHERS THEN
1090:
1091: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1092: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1093: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1094: debug_exit(' Others in '||l_proc_name);
1095: RAISE;

Line 1092: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);

1088: EXCEPTION
1089: WHEN OTHERS THEN
1090:
1091: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1092: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1093: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1094: debug_exit(' Others in '||l_proc_name);
1095: RAISE;
1096: END; -- get_all_secondary_asgs

Line 1093: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);

1089: WHEN OTHERS THEN
1090:
1091: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1092: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1093: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1094: debug_exit(' Others in '||l_proc_name);
1095: RAISE;
1096: END; -- get_all_secondary_asgs
1097:

Line 1465: hr_utility.set_location('Leaving: '||l_proc_name, 360);

1461:
1462: l_inclusion_flag := g_inclusion_flag;
1463: --
1464: debug(':l_inclusion_flag:'||l_inclusion_flag, 350 );
1465: hr_utility.set_location('Leaving: '||l_proc_name, 360);
1466: --
1467:
1468: IF l_inclusion_flag = 'Y' THEN
1469:

Line 1510: hr_utility.set_location('Entering excep:'||l_proc_name, 35);

1506: if l_effective_start_date is not null
1507: then
1508: g_effective_start_date := l_effective_start_date;
1509: end if;
1510: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1511: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1512: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1513: p_error_number := SQLCODE;
1514: p_error_text := SQLERRM;

Line 1511: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);

1507: then
1508: g_effective_start_date := l_effective_start_date;
1509: end if;
1510: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1511: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1512: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1513: p_error_number := SQLCODE;
1514: p_error_text := SQLERRM;
1515: debug_exit(' Others in '||l_proc_name

Line 1512: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);

1508: g_effective_start_date := l_effective_start_date;
1509: end if;
1510: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1511: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1512: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1513: p_error_number := SQLCODE;
1514: p_error_text := SQLERRM;
1515: debug_exit(' Others in '||l_proc_name
1516: ,'Y' -- turn trace off

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

1577: --
1578: Begin
1579:
1580: --
1581: hr_utility.set_location('Entering: '||l_proc_name, 5);
1582: --
1583: debug_enter(l_proc_name);
1584: debug(':p_assignment_id:'||p_assignment_id, 1150 );
1585:

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

1591: End If;
1592:
1593: debug(':l_add_cont_ind:'||l_add_cont_ind, 1160 );
1594: --
1595: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1596: --
1597: debug_exit(l_proc_name);
1598:
1599: Return l_add_cont_ind;

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

1611: --
1612: Begin
1613:
1614: --
1615: hr_utility.set_location('Entering: '||l_proc_name, 5);
1616: --
1617: debug_enter(l_proc_name);
1618:
1619: l_financial_year := TO_CHAR(g_effective_end_date, 'YY');

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

1618:
1619: l_financial_year := TO_CHAR(g_effective_end_date, 'YY');
1620:
1621: --
1622: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1623: --
1624: debug_exit(l_proc_name);
1625:
1626: Return l_financial_year;

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

1650: --
1651: Begin
1652:
1653: --
1654: hr_utility.set_location('Entering: '||l_proc_name, 5);
1655: --
1656: debug_enter(l_proc_name);
1657:
1658: -- 11.5.10_CU2: Performance fix :

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

1682:
1683: debug(':l_total_add_cont:'||l_total_add_cont, 40);
1684:
1685: --
1686: hr_utility.set_location('Leaving: '||l_proc_name, 50);
1687: --
1688: debug_exit(l_proc_name);
1689:
1690: Return l_total_add_cont;

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

1706: --
1707: Begin
1708:
1709: --
1710: hr_utility.set_location('Entering: '||l_proc_name, 5);
1711: --
1712: debug_enter(l_proc_name);
1713:
1714: Open csr_get_total_add_cont_sign;

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

1716: Close csr_get_total_add_cont_sign;
1717:
1718: debug(':l_total_refund_ind:'||l_total_refund_ind, 1200 );
1719: --
1720: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1721: --
1722: debug_exit(l_proc_name);
1723:
1724: Return l_total_refund_ind;

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

1736: --
1737: Begin
1738:
1739: --
1740: hr_utility.set_location('Entering: '||l_proc_name, 5);
1741: --
1742: debug_enter(l_proc_name);
1743:
1744: If pqp_gb_tp_pension_extracts.g_estb_number = '0000' Then

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

1746: End If; -- End if of estb number check...
1747:
1748: debug(':l_lea_run:'||l_lea_run, 1300 );
1749: --
1750: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1751: --
1752: debug_exit(l_proc_name);
1753:
1754: Return l_lea_run;