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_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 1085: hr_utility.set_location('Entering excep:'||l_proc_name, 35);

1081: --
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084:
1085: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1086: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1087: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1088: debug_exit(' Others in '||l_proc_name);
1089: RAISE;

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

1082: EXCEPTION
1083: WHEN OTHERS THEN
1084:
1085: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1086: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1087: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1088: debug_exit(' Others in '||l_proc_name);
1089: RAISE;
1090: END; -- get_all_secondary_asgs

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

1083: WHEN OTHERS THEN
1084:
1085: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1086: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1087: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1088: debug_exit(' Others in '||l_proc_name);
1089: RAISE;
1090: END; -- get_all_secondary_asgs
1091:

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

1453:
1454: l_inclusion_flag := g_inclusion_flag;
1455: --
1456: debug(':l_inclusion_flag:'||l_inclusion_flag, 350 );
1457: hr_utility.set_location('Leaving: '||l_proc_name, 360);
1458: --
1459:
1460: IF l_inclusion_flag = 'Y' THEN
1461:

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

1491: -- Added by tmehra for nocopy changes Feb'03
1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1496: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1497: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1498: p_error_number := SQLCODE;
1499: p_error_text := SQLERRM;

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

1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1496: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1497: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1498: p_error_number := SQLCODE;
1499: p_error_text := SQLERRM;
1500: debug_exit(' Others in '||l_proc_name

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

1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: hr_utility.set_location('Entering excep:'||l_proc_name, 35);
1496: hr_utility.set_location('SQLCODE :'||SQLCODE, 40);
1497: hr_utility.set_location('SQLERRM :'||SQLERRM, 50);
1498: p_error_number := SQLCODE;
1499: p_error_text := SQLERRM;
1500: debug_exit(' Others in '||l_proc_name
1501: ,'Y' -- turn trace off

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

1559: --
1560: Begin
1561:
1562: --
1563: hr_utility.set_location('Entering: '||l_proc_name, 5);
1564: --
1565: debug_enter(l_proc_name);
1566: debug(':p_assignment_id:'||p_assignment_id, 1150 );
1567:

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

1571: Close csr_translate_sign;
1572:
1573: debug(':l_add_cont_ind:'||l_add_cont_ind, 1160 );
1574: --
1575: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1576: --
1577: debug_exit(l_proc_name);
1578:
1579: Return l_add_cont_ind;

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

1591: --
1592: Begin
1593:
1594: --
1595: hr_utility.set_location('Entering: '||l_proc_name, 5);
1596: --
1597: debug_enter(l_proc_name);
1598:
1599: l_financial_year := TO_CHAR(g_effective_end_date, 'YY');

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

1598:
1599: l_financial_year := TO_CHAR(g_effective_end_date, 'YY');
1600:
1601: --
1602: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1603: --
1604: debug_exit(l_proc_name);
1605:
1606: Return l_financial_year;

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

1630: --
1631: Begin
1632:
1633: --
1634: hr_utility.set_location('Entering: '||l_proc_name, 5);
1635: --
1636: debug_enter(l_proc_name);
1637:
1638: -- 11.5.10_CU2: Performance fix :

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

1662:
1663: debug(':l_total_add_cont:'||l_total_add_cont, 40);
1664:
1665: --
1666: hr_utility.set_location('Leaving: '||l_proc_name, 50);
1667: --
1668: debug_exit(l_proc_name);
1669:
1670: Return l_total_add_cont;

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

1686: --
1687: Begin
1688:
1689: --
1690: hr_utility.set_location('Entering: '||l_proc_name, 5);
1691: --
1692: debug_enter(l_proc_name);
1693:
1694: Open csr_get_total_add_cont_sign;

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

1696: Close csr_get_total_add_cont_sign;
1697:
1698: debug(':l_total_refund_ind:'||l_total_refund_ind, 1200 );
1699: --
1700: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1701: --
1702: debug_exit(l_proc_name);
1703:
1704: Return l_total_refund_ind;

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

1716: --
1717: Begin
1718:
1719: --
1720: hr_utility.set_location('Entering: '||l_proc_name, 5);
1721: --
1722: debug_enter(l_proc_name);
1723:
1724: If pqp_gb_tp_pension_extracts.g_estb_number = '0000' Then

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

1726: End If; -- End if of estb number check...
1727:
1728: debug(':l_lea_run:'||l_lea_run, 1300 );
1729: --
1730: hr_utility.set_location('Leaving: '||l_proc_name, 15);
1731: --
1732: debug_exit(l_proc_name);
1733:
1734: Return l_lea_run;