DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_ACRA dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pyfiacra.pkb 120.6 2006/04/03 05:43:39 dbehera 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_FI_ACC_REP_ARCHIVE.';
9: g_err_num NUMBER;
10: g_errm VARCHAR2(150);

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

20: l_proc VARCHAR2(40):= g_package||' get parameter ';
21: BEGIN
22:
23: IF g_debug THEN
24: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
25: END IF;
26: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
27: --
28: IF l_start_pos = 0 THEN

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

45: END IF;
46: END IF;
47: --
48: IF g_debug THEN
49: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
50: END IF;
51: RETURN l_parameter;
52: END;
53: /* GET ALL PARAMETERS */

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

95: ,p_business_group_id;
96: CLOSE csr_parameter_info;
97: --
98: IF g_debug THEN
99: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
100: END IF;
101: END GET_ALL_PARAMETERS;
102: /* RANGE CODE */
103: PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER

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

264: /* End of Cursors */
265: BEGIN
266:
267: IF g_debug THEN
268: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
269: END IF;
270: p_sql := 'SELECT DISTINCT person_id
271: FROM per_people_f ppf
272: ,pay_payroll_actions ppa

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

595: ,p_action_information11 => l_end_date);
596: END IF;
597: END IF;
598: IF g_debug THEN
599: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
600: END IF;
601: EXCEPTION
602: WHEN OTHERS THEN
603: -- Return cursor that selects no rows

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

612: IS
613: BEGIN
614: -- fnd_file.put_line (fnd_file.LOG, 'Entering Assignment Action Code' );
615: IF g_debug THEN
616: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
617: END IF;
618: IF g_debug THEN
619: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
620: END IF;

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

615: IF g_debug THEN
616: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
617: END IF;
618: IF g_debug THEN
619: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
620: END IF;
621: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );
622: END ASSIGNMENT_ACTION_CODE;
623: /* INITIALIZATION CODE */

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

625: IS
626: BEGIN
627: fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );
628: IF g_debug THEN
629: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
630: END IF;
631: IF g_debug THEN
632: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
633: END IF;

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

628: IF g_debug THEN
629: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
630: END IF;
631: IF g_debug THEN
632: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
633: END IF;
634: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
635: EXCEPTION WHEN OTHERS THEN
636: g_err_num := SQLCODE;

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

634: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
635: EXCEPTION WHEN OTHERS THEN
636: g_err_num := SQLCODE;
637: IF g_debug THEN
638: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
639: 'In INITIALIZATION_CODE',180);
640: END IF;
641: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
642: END INITIALIZATION_CODE;

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

646: IS
647: BEGIN
648: fnd_file.put_line (fnd_file.LOG, 'entering archive code' );
649: IF g_debug THEN
650: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
651: END IF;
652: IF g_debug THEN
653: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
654: END IF;

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

649: IF g_debug THEN
650: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
651: END IF;
652: IF g_debug THEN
653: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
654: END IF;
655: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
656: END ARCHIVE_CODE;
657: END PAY_FI_ARCHIVE_ACRA;