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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Constants
5: --
6: l_package varchar2(31) := ' pay_kr_npa_pkg.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- Global Variables
10: --
11: TYPE t_pact IS RECORD(

Line 32: hr_utility.set_location(l_proc_name, 10);

28: IS
29: l_proc_name VARCHAR2(100) := l_package || 'range_code';
30: BEGIN
31: if g_debug then
32: hr_utility.set_location(l_proc_name, 10);
33: end if;
34:
35: p_sqlstr :=
36: 'SELECT DISTINCT ppf.person_id

Line 44: hr_utility.set_location(l_proc_name, 20);

40: AND ppa.business_group_id = ppf.business_group_id
41: ORDER BY ppf.person_id';
42:
43: if g_debug then
44: hr_utility.set_location(l_proc_name, 20);
45: end if;
46: END range_code;
47: --------------------------------------------------------------------------------+
48: -- Cache ARCHIVE payroll action parameters

Line 56: hr_utility.set_location(l_proc_name, 10);

52: IS
53: l_proc_name VARCHAR2(100) := l_package || 'initialization_code';
54: BEGIN
55: if g_debug then
56: hr_utility.set_location(l_proc_name, 10);
57: end if;
58:
59: SELECT ppa.payroll_action_id,
60: ppa.report_type,

Line 71: hr_utility.set_location(l_proc_name, 20);

67: FROM pay_payroll_actions ppa
68: WHERE ppa.payroll_action_id = p_payroll_action_id;
69:
70: if g_debug then
71: hr_utility.set_location(l_proc_name, 20);
72: end if;
73:
74: EXCEPTION
75: WHEN OTHERS THEN

Line 76: hr_utility.set_location('Error in initialization code ',10);

72: end if;
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: hr_utility.set_location('Error in initialization code ',10);
77: RAISE;
78: END initialization_code;
79:
80: --------------------------------------------------------------------------------+

Line 157: hr_utility.set_location(l_proc_name, 10);

153: );
154:
155: BEGIN
156: if g_debug then
157: hr_utility.set_location(l_proc_name, 10);
158: end if;
159:
160: initialization_code(p_payroll_action_id);
161:

Line 180: hr_utility.set_location(l_proc_name, 20);

176: status => 'U');
177: END LOOP;
178:
179: if g_debug then
180: hr_utility.set_location(l_proc_name, 20);
181: end if;
182:
183: EXCEPTION
184: WHEN OTHERS THEN

Line 185: hr_utility.set_location('Error in assignment action code ',10);

181: end if;
182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: hr_utility.set_location('Error in assignment action code ',10);
186: RAISE;
187: END assignment_action_code;
188: --------------------------------------------------------------------------------+
189: -- Archives item

Line 211: hr_utility.set_location('Entering : archive_item',1);

207: l_object_version_number ff_archive_items.object_version_number%TYPE;
208: l_some_warning BOOLEAN;
209: BEGIN
210: if g_debug then
211: hr_utility.set_location('Entering : archive_item',1);
212: end if;
213:
214: OPEN csr_get_user_entity_id (p_item);
215: FETCH csr_get_user_entity_id INTO l_user_entity_id,l_data_type;

Line 231: hr_utility.set_location('User entity not found :'||p_item,20);

227: ,p_some_warning => l_some_warning); -- boolean out
228: ELSE
229: CLOSE csr_get_user_entity_id;
230: if g_debug then
231: hr_utility.set_location('User entity not found :'||p_item,20);
232: end if;
233: END IF;
234:
235: if g_debug then

Line 236: hr_utility.set_location('Leaving : archive_item',1);

232: end if;
233: END IF;
234:
235: if g_debug then
236: hr_utility.set_location('Leaving : archive_item',1);
237: end if;
238:
239: EXCEPTION
240: WHEN OTHERS THEN

Line 243: hr_utility.set_location('closing..',117);

239: EXCEPTION
240: WHEN OTHERS THEN
241: IF csr_get_user_entity_id%isopen THEN
242: CLOSE csr_get_user_entity_id;
243: hr_utility.set_location('closing..',117);
244: END IF;
245:
246: hr_utility.set_location('Error in archive_item',20);
247: RAISE;

Line 246: hr_utility.set_location('Error in archive_item',20);

242: CLOSE csr_get_user_entity_id;
243: hr_utility.set_location('closing..',117);
244: END IF;
245:
246: hr_utility.set_location('Error in archive_item',20);
247: RAISE;
248: END archive_item;
249:
250: --------------------------------------------------------------------------------+

Line 302: hr_utility.set_location(l_proc_name, 10);

298: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
299:
300: BEGIN
301: if g_debug then
302: hr_utility.set_location(l_proc_name, 10);
303: end if;
304:
305: OPEN csr_get_context_values;
306: FETCH csr_get_context_values INTO l_assignment_id,l_payroll_id, l_est_id; -- Bug 3506172

Line 310: hr_utility.set_location(l_proc_name, 20);

306: FETCH csr_get_context_values INTO l_assignment_id,l_payroll_id, l_est_id; -- Bug 3506172
307: CLOSE csr_get_context_values;
308:
309: if g_debug then
310: hr_utility.set_location(l_proc_name, 20);
311: end if;
312:
313: pay_archive.g_context_values.name(1) := 'BUSINESS_GROUP_ID';
314: pay_archive.g_context_values.value(1) := to_char(g_pact.business_group_id);

Line 330: hr_utility.set_location(l_proc_name, 30);

326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328:
329: if g_debug then
330: hr_utility.set_location(l_proc_name, 30);
331: end if;
332:
333: /* Start of Archiving Employee Details */
334: -----------------------------------------+

Line 346: hr_utility.set_location('Entering : Archiving emp Details ',1);

342: l_arch_tab(3).item := 'X_KR_NPA_BRANCH_CODE';
343: l_arch_tab(4).item := 'X_KR_NPA_COMPUTERIZATION_CODE';
344:
345: if g_debug then
346: hr_utility.set_location('Entering : Archiving emp Details ',1);
347: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
348: end if;
349:
350: OPEN csr_employee_details ;

Line 347: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);

343: l_arch_tab(4).item := 'X_KR_NPA_COMPUTERIZATION_CODE';
344:
345: if g_debug then
346: hr_utility.set_location('Entering : Archiving emp Details ',1);
347: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
348: end if;
349:
350: OPEN csr_employee_details ;
351: LOOP

Line 360: hr_utility.set_location('Creating Archive Item ',3);

356: l_arch_tab(4).value ;
357: EXIT WHEN csr_employee_details%NOTFOUND;
358:
359: if g_debug then
360: hr_utility.set_location('Creating Archive Item ',3);
361: end if;
362:
363: FOR i IN 1..l_arch_tab.count
364: LOOP

Line 373: hr_utility.set_location('Exiting : Archiving emp Details ',200);

369: END LOOP;
370: CLOSE csr_employee_details;
371:
372: if g_debug then
373: hr_utility.set_location('Exiting : Archiving emp Details ',200);
374: end if;
375:
376: EXCEPTION
377: WHEN OTHERS THEN

Line 378: hr_utility.set_location('Error in archiving emp details ',10);

374: end if;
375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: hr_utility.set_location('Error in archiving emp details ',10);
379: RAISE;
380: /* End of Archiving Employee Details */
381: END archive_code;
382:

Line 408: hr_utility.set_location('Error in return_header ',10);

404: RAISE no_lookup;
405: END IF;
406: EXCEPTION
407: WHEN OTHERS THEN
408: hr_utility.set_location('Error in return_header ',10);
409: RAISE;
410: END;
411:
412: END pay_kr_npa_pkg;