eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_UNION_DUES dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_NO_UNION_DUES AS
2: /* $Header: pynouniondues.pkb 120.4.12020000.6 2012/10/31 12:47:40 dakhuran ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_id NUMBER;
6: l_leg_emp_id NUMBER;
7: l_effective_date DATE;
8: l_payee_org NUMBER;

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

23: l_delimiter VARCHAR2(1):=' ';
24:
25: BEGIN
26: IF g_debug THEN
27: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
28: END IF;
29:
30: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
31:

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

49: END IF;
50:
51: RETURN l_parameter;
52: IF g_debug THEN
53: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
54: END IF;
55:
56: END GET_PARAMETER;
57:

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

86: FETCH csr_parameter_info INTO p_legal_employer_id ,p_archive,p_payee_org ,
87: p_fromdate,p_todate,p_effective_date ,p_business_group_id;
88: CLOSE csr_parameter_info;
89: IF g_debug THEN
90: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
91: END IF;
92:
93:
94: END GET_ALL_PARAMETERS;

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

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

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

215:
216: END IF; -- l_archive = 'Y'
217:
218: IF g_debug THEN
219: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
220: END IF;
221: END RANGE_CODE;
222:
223: -------------------------------------------------------------------------------------------------------------------------

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

226: IS
227:
228: BEGIN
229: IF g_debug THEN
230: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
231: END IF;
232: NULL;
233: IF g_debug THEN
234: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

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

230: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
231: END IF;
232: NULL;
233: IF g_debug THEN
234: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
235: END IF;
236:
237: exception when others then
238: g_err_num := SQLCODE;

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

236:
237: exception when others then
238: g_err_num := SQLCODE;
239: IF g_debug THEN
240: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',180);
241: END IF;
242: END INITIALIZATION_CODE;
243:
244: ------------------------------------------------------------------------------------------------

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:
361:
362: -- fetch the data

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: END ASSIGNMENT_ACTION_CODE;
435:
436: ------------------------------------------------------------------------------------------------

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

596:
597:
598: BEGIN
599: IF g_debug THEN
600: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
601: END IF;
602: begin
603: SELECT payroll_action_id
604: INTO l_payroll_action_id

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

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

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

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

Line 940: hr_utility.raise_error;

936: --clob_to_blob(l_xfdf_string,p_xml);
937: exception
938: when others then
939: hr_utility.trace('sqleerm ' || sqlerrm);
940: hr_utility.raise_error;
941:
942: end write_to_clob;
943: ------------------------------------------------------------------------------------------------------------
944: /* Added the function GET_UNION_DUE_GLOBAL for the BUG:14549415 */