APPS.PAY_NO_TAX_LEVY dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_NO_TAX_LEVY AS
2: /* $Header: pynotaxlevy.pkb 120.4.12000000.1 2007/05/20 08:06:12 rlingama noship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: l_business_id NUMBER;
5: l_leg_emp_id NUMBER;
6: l_effective_date DATE;
7: l_bimonth_term VARCHAR2(10);

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

20: l_delimiter VARCHAR2(1):=' ';
21:
22: BEGIN
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:
47: RETURN l_parameter;
48: IF g_debug THEN
49: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
50: END IF;
51:
52: END GET_PARAMETER;
53:

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

79: OPEN csr_parameter_info (p_payroll_action_id);
80: FETCH csr_parameter_info INTO p_legal_employer_id ,p_bimonth_term ,p_archive,p_payee_org ,p_effective_date ,p_business_group_id;
81: CLOSE csr_parameter_info;
82: IF g_debug THEN
83: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
84: END IF;
85:
86: END GET_ALL_PARAMETERS;
87:

Line 139: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

135:
136:
137: BEGIN
138: IF g_debug THEN
139: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
140: END IF;
141: -- the sql string to return
142: sqlstr := 'SELECT DISTINCT person_id
143: FROM per_people_f ppf

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

208: END IF; -- l_count < 1
209:
210: END IF; -- l_archive = 'Y'
211: IF g_debug THEN
212: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
213: END IF;
214:
215: END RANGE_CODE;
216:

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

220: IS
221:
222: BEGIN
223: IF g_debug THEN
224: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
225: END IF;
226:
227: NULL;
228: IF g_debug THEN

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

225: END IF;
226:
227: NULL;
228: IF g_debug THEN
229: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
230: END IF;
231: exception when others then
232: g_err_num := SQLCODE;
233: IF g_debug THEN

Line 234: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);

230: END IF;
231: exception when others then
232: g_err_num := SQLCODE;
233: IF g_debug THEN
234: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
235: END IF;
236:
237: END INITIALIZATION_CODE;
238:

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

354:
355:
356: BEGIN
357: IF g_debug THEN
358: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
359: END IF;
360: -- fetch the data for the REPORT DETAILS
361: PAY_NO_TAX_LEVY.GET_ALL_PARAMETERS(
362: p_payroll_action_id

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

428:
429: END IF; -- l_archive = 'Y'
430:
431: IF g_debug THEN
432: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
433: END IF;
434:
435: END ASSIGNMENT_ACTION_CODE;
436:

Line 618: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);

614:
615:
616: BEGIN
617: IF g_debug THEN
618: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
619: END IF;
620:
621: -- get the action_information_id and original/main assignment_action_id for this asg_act_id
622: OPEN csr_get_act_info (p_assignment_action_id , p_effective_date );

Line 713: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);

709: END IF; -- l_archive = 'Y'
710:
711:
712: IF g_debug THEN
713: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
714: END IF;
715:
716: END ARCHIVE_CODE;
717:

Line 942: hr_utility.trace('sqleerm ' || sqlerrm);

938: --dbms_lob.createtemporary(p_xml,true);
939: --clob_to_blob(l_xfdf_string,p_xml);
940: exception
941: when others then
942: hr_utility.trace('sqleerm ' || sqlerrm);
943: hr_utility.raise_error;
944:
945: end write_to_clob;
946:

Line 943: hr_utility.raise_error;

939: --clob_to_blob(l_xfdf_string,p_xml);
940: exception
941: when others then
942: hr_utility.trace('sqleerm ' || sqlerrm);
943: hr_utility.raise_error;
944:
945: end write_to_clob;
946:
947: -------------------------------------------------------------------------------------------------------------------------