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_HIA_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_hia_pkg.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- Global Variables
10: --
11: TYPE t_pact IS RECORD(

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

37: l_proc_name VARCHAR2(100) := l_package || 'range_code';
38: BEGIN
39:
40: if g_debug then
41: hr_utility.set_location(l_proc_name, 10);
42: end if;
43:
44: p_sqlstr :=
45: 'SELECT DISTINCT person_id

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

48: WHERE ppa.payroll_action_id = :payroll_action_id
49: AND ppa.business_group_id = ppf.business_group_id
50: ORDER BY ppf.person_id';
51: if g_debug then
52: hr_utility.set_location(l_proc_name, 20);
53: end if;
54: end range_code;
55:
56: --------------------------------------------------------------------------------

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

63:
64: begin
65:
66: if g_debug then
67: hr_utility.set_location(l_proc_name, 10);
68: end if;
69:
70: IF g_pact.payroll_Action_id is null then
71: select ppa.payroll_action_id,

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

82: where ppa.payroll_action_id = p_payroll_action_id;
83: END IF;
84:
85: if g_debug then
86: hr_utility.set_location(l_proc_name, 20);
87: end if;
88:
89: EXCEPTION
90: WHEN OTHERS THEN

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

87: end if;
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: hr_utility.set_location('Error in initialization code ',10);
92: RAISE;
93: end initialization_code;
94:
95: --------------------------------------------------------------------------------+

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

151: AND paa.source_action_id IS NULL
152: AND paa.assignment_id = asg.assignment_id);
153: BEGIN
154: if g_debug then
155: hr_utility.set_location(l_proc_name, 10);
156: end if;
157:
158: initialization_code(p_payroll_action_id);
159:

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

171: status => 'U');
172: END LOOP;
173:
174: if g_debug then
175: hr_utility.set_location(l_proc_name, 20);
176: end if;
177:
178: EXCEPTION
179: WHEN OTHERS THEN

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

176: end if;
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: hr_utility.set_location('Error in assignment action code ',10);
181: RAISE;
182: END assignment_action_code;
183: --------------------------------------------------------------------------------+
184: -- Archives item

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

202: l_object_version_number ff_archive_items.object_version_number%TYPE;
203: l_some_warning BOOLEAN;
204: BEGIN
205: if g_debug then
206: hr_utility.set_location('Entering : archive_item',1);
207: end if;
208:
209: OPEN csr_get_user_entity_id (p_item);
210: FETCH csr_get_user_entity_id INTO l_user_entity_id,l_data_type;

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

223: ELSE
224: CLOSE csr_get_user_entity_id;
225:
226: if g_debug then
227: hr_utility.set_location('User entity not found :'||p_item,20);
228: end if;
229:
230: END IF;
231:

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

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

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

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

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

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

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

382: l_defined_balance_id NUMBER(9);
383:
384: BEGIN
385: if g_debug then
386: hr_utility.set_location(l_proc_name, 10);
387: end if;
388: --
389: OPEN csr_get_context_values;
390: FETCH csr_get_context_values INTO l_assignment_id,l_payroll_id,l_establishment_id; -- 3506171

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

390: FETCH csr_get_context_values INTO l_assignment_id,l_payroll_id,l_establishment_id; -- 3506171
391: CLOSE csr_get_context_values;
392:
393: if g_debug then
394: hr_utility.set_location(l_proc_name, 20);
395: end if;
396: -- Bug 3438946
397: open csr_last_year_asg_action;
398: fetch csr_last_year_asg_action into l_last_year_assignment_action;

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

417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:
420: if g_debug then
421: hr_utility.set_location(l_proc_name, 30);
422: end if;
423:
424: /* Start of Archiving Employee Details */
425: -----------------------------------------+

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

513: --
514: --End of changes for Bug 3438946
515: --------------------------------------------------------------
516: if g_debug then
517: hr_utility.set_location('Entering : Archiving emp Details ',1);
518: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
519: end if;
520:
521: OPEN csr_employee_details ;

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

514: --End of changes for Bug 3438946
515: --------------------------------------------------------------
516: if g_debug then
517: hr_utility.set_location('Entering : Archiving emp Details ',1);
518: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
519: end if;
520:
521: OPEN csr_employee_details ;
522: LOOP

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

529: l_arch_tab(6).value;
530: EXIT WHEN csr_employee_details%NOTFOUND;
531:
532: if g_debug then
533: hr_utility.set_location('Creating Archive Item ',3);
534: end if;
535:
536: FOR i IN 1..l_arch_tab.count
537: LOOP

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

542: END LOOP;
543: CLOSE csr_employee_details;
544:
545: if g_debug then
546: hr_utility.set_location('Exiting : Archiving emp Details ',200);
547: end if;
548:
549: EXCEPTION
550: WHEN OTHERS THEN

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

547: end if;
548:
549: EXCEPTION
550: WHEN OTHERS THEN
551: hr_utility.set_location('Error in archiving emp details ',10);
552: RAISE;
553: /* End of Archiving Employee Details */
554: END archive_code;
555: --------------------------------------------------------------------------

Line 592: hr_utility.set_location('Submit report called',1);

588: -- what order the parameters will be in.
589: -- Default the parameters in case they are not found.
590:
591: if g_debug then
592: hr_utility.set_location('Submit report called',1);
593: hr_utility.set_location('payroll action id'||l_payroll_action_id,1);
594: end if;
595:
596: BEGIN

Line 593: hr_utility.set_location('payroll action id'||l_payroll_action_id,1);

589: -- Default the parameters in case they are not found.
590:
591: if g_debug then
592: hr_utility.set_location('Submit report called',1);
593: hr_utility.set_location('payroll action id'||l_payroll_action_id,1);
594: end if;
595:
596: BEGIN
597: LOOP

Line 609: hr_utility.set_location('No data found',1);

605: END IF;
606: END LOOP;
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN
609: hr_utility.set_location('No data found',1);
610: NULL;
611: WHEN VALUE_ERROR THEN
612: hr_utility.set_location('Value error',1);
613: NULL;

Line 612: hr_utility.set_location('Value error',1);

608: WHEN NO_DATA_FOUND THEN
609: hr_utility.set_location('No data found',1);
610: NULL;
611: WHEN VALUE_ERROR THEN
612: hr_utility.set_location('Value error',1);
613: NULL;
614: END;
615: -- Default the number of report copies to 0.
616: l_number_of_copies := 0;

Line 623: hr_utility.set_location('fnd_request.set_print_options',1);

619: FETCH csr_get_print_options INTO rec_print_options;
620: CLOSE csr_get_print_options;
621:
622: if g_debug then
623: hr_utility.set_location('fnd_request.set_print_options',1);
624: end if;
625:
626: l_print_return := fnd_request.set_print_options
627: (printer => rec_print_options.printer,

Line 637: hr_utility.set_location('fnd_request.submit_request',1);

633: -- Submit the report
634: BEGIN
635:
636: if g_debug then
637: hr_utility.set_location('fnd_request.submit_request',1);
638: end if;
639:
640: l_request_id := fnd_request.submit_request
641: (application => 'PAY',

Line 649: hr_utility.set_location('l_request_id : '||l_request_id,1);

645: argument3 => 'P_REPORTED_DATE='||l_reported_date);
646: -- If an error submitting report then get message and put to log.
647:
648: if g_debug then
649: hr_utility.set_location('l_request_id : '||l_request_id,1);
650: end if;
651:
652: IF l_request_id = 0 THEN
653: RAISE e_submit_error;