DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pynohlea.pkb 120.0.12000000.1 2007/05/22 07:29:44 rajesrin noship $ */
3: TYPE lock_rec IS RECORD (
4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
6: g_debug boolean := hr_utility.debug_enabled;
7: g_lock_table lock_table;
8: g_package VARCHAR2(33) := ' PAY_NO_ARC_HOLIDAY_ENTITLEMENT.';
9: g_business_group_id NUMBER;
10: g_legal_employer_id NUMBER;

Line 30: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

26: l_proc VARCHAR2(240):= g_package||' get parameter ';
27: BEGIN
28:
29: IF g_debug THEN
30: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
31: END IF;
32: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
33: --
34: IF l_start_pos = 0 THEN

Line 55: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

51: END IF;
52: END IF;
53: --
54: IF g_debug THEN
55: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
56: END IF;
57: RETURN l_parameter;
58: END;
59: /* GET ALL PARAMETERS */

Line 94: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

90: ,p_business_group_id;
91: CLOSE csr_parameter_info;
92: --
93: IF g_debug THEN
94: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
95: END IF;
96: END GET_ALL_PARAMETERS;
97:
98: /* RANGE CODE */

Line 111: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

107:
108:
109:
110: IF g_debug THEN
111: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
112: END IF;
113:
114:
115:

Line 143: hr_utility.set_location('Report Parameters ***********',30);

139: p_action_information3 => g_employee_id,
140: p_action_information4 => fnd_date.date_to_canonical(g_effective_date),
141: p_action_information5 => g_assignment_set_id);
142:
143: hr_utility.set_location('Report Parameters ***********',30);
144:
145: p_sql := 'SELECT DISTINCT person_id
146: FROM per_people_f ppf
147: ,pay_payroll_actions ppa

Line 153: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

149: AND ppa.business_group_id = ppf.business_group_id
150: ORDER BY ppf.person_id';
151:
152: --IF g_debug THEN
153: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
154: -- END IF;
155:
156: EXCEPTION
157: WHEN OTHERS THEN

Line 158: hr_utility.set_location('Exception****',70);

154: -- END IF;
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: hr_utility.set_location('Exception****',70);
159: -- Return cursor that selects no rows
160: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
161: END RANGE_CODE;
162:

Line 218: hr_utility.trace('Entering Assignment Action Code '||p_payroll_action_id);

214:
215: BEGIN
216:
217:
218: hr_utility.trace('Entering Assignment Action Code '||p_payroll_action_id);
219:
220: PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_ALL_PARAMETERS( p_payroll_action_id
221: ,g_business_group_id
222: ,g_legal_employer_id

Line 251: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

247: );
248: END LOOP;
249:
250: IF g_debug THEN
251: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
252: END IF;
253: IF g_debug THEN
254: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
255: END IF;

Line 254: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

250: IF g_debug THEN
251: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
252: END IF;
253: IF g_debug THEN
254: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
255: END IF;
256: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );
257:
258:

Line 265: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

261: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
262: IS
263: BEGIN
264: -- fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );
265: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
266:
267:
268:
269: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

Line 269: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

265: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
266:
267:
268:
269: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
270:
271: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
272: EXCEPTION WHEN OTHERS THEN
273: g_err_num := SQLCODE;

Line 275: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);

271: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
272: EXCEPTION WHEN OTHERS THEN
273: g_err_num := SQLCODE;
274: IF g_debug THEN
275: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);
276: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
277: 'In INITIALIZATION_CODE',180);
278: END IF;
279: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );

Line 276: hr_utility.set_location('ORA_ERR: ' || g_err_num ||

272: EXCEPTION WHEN OTHERS THEN
273: g_err_num := SQLCODE;
274: IF g_debug THEN
275: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);
276: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
277: 'In INITIALIZATION_CODE',180);
278: END IF;
279: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
280: END INITIALIZATION_CODE;

Line 487: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);

483: p_object_version_number=> l_arch_ovn);
484: END LOOP;
485:
486: IF g_debug THEN
487: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
488: END IF;
489: IF g_debug THEN
490: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
491: END IF;

Line 490: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);

486: IF g_debug THEN
487: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
488: END IF;
489: IF g_debug THEN
490: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
491: END IF;
492: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
493: END ARCHIVE_CODE;
494: END PAY_NO_ARC_HOLIDAY_ENTITLEMENT;