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.5.12020000.2 2012/08/10 08:25:26 smeduri ship $ */
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 359: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

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

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

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

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

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

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

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

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

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

Line 945: hr_utility.raise_error;

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