DBA Data[Home] [Help]

APPS.PAY_NO_SC_ARCHIVE dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pynosfca.pkb 120.0.12000000.1 2007/05/20 09:27:43 rlingama 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(50) := ' PAY_NO_SC_ARCHIVE.';
9: g_business_group_id NUMBER;
10: g_legal_employer_id NUMBER;

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

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

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

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

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

86: ,p_business_group_id;
87: CLOSE csr_parameter_info;
88: --
89: IF g_debug THEN
90: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
91: END IF;
92: END GET_ALL_PARAMETERS;
93:
94: /* RANGE CODE */

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

102: BEGIN
103:
104:
105: IF g_debug THEN
106: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
107: END IF;
108:
109:
110:

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

140: AND ppa.business_group_id = ppf.business_group_id
141: ORDER BY ppf.person_id';
142:
143:
144: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
145:
146:
147: EXCEPTION
148: WHEN OTHERS THEN

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

145:
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: hr_utility.set_location('Exception****',70);
150: -- Return cursor that selects no rows
151: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
152: END RANGE_CODE;
153:

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

236: );
237: END LOOP;
238:
239: IF g_debug THEN
240: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
241: END IF;
242: IF g_debug THEN
243: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
244: END IF;

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

239: IF g_debug THEN
240: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
241: END IF;
242: IF g_debug THEN
243: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
244: END IF;
245: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );
246:
247:

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

250: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
251: IS
252: BEGIN
253: -- fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );
254: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
255:
256:
257:
258: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

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

254: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
255:
256:
257:
258: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
259:
260: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
261: EXCEPTION WHEN OTHERS THEN
262: g_err_num := SQLCODE;

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

260: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
261: EXCEPTION WHEN OTHERS THEN
262: g_err_num := SQLCODE;
263: IF g_debug THEN
264: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);
265: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
266: 'In INITIALIZATION_CODE',180);
267: END IF;
268: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );

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

261: EXCEPTION WHEN OTHERS THEN
262: g_err_num := SQLCODE;
263: IF g_debug THEN
264: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);
265: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
266: 'In INITIALIZATION_CODE',180);
267: END IF;
268: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
269: END INITIALIZATION_CODE;

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

347: p_object_version_number=> l_arch_ovn);
348: END LOOP;
349:
350: IF g_debug THEN
351: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
352: END IF;
353: IF g_debug THEN
354: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
355: END IF;

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

350: IF g_debug THEN
351: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
352: END IF;
353: IF g_debug THEN
354: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
355: END IF;
356: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
357: END ARCHIVE_CODE;
358: END PAY_NO_SC_ARCHIVE;