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_ARC_RSEA_07 dependencies on HR_UTILITY

Line 20: g_debug boolean := hr_utility.debug_enabled;

16: -- Global variables.
17: -- -----------------------------------------------------------------------------
18: --
19: g_xml_element_table t_xml_element_table;
20: g_debug boolean := hr_utility.debug_enabled;
21: g_package VARCHAR2(33) := ' PAY_NO_ARC_RSEA_07.';
22: g_err_num NUMBER;
23: g_errm VARCHAR2(150);
24: --

Line 107: hr_utility.set_location(sqlerrm(sqlcode),110);

103: --
104: EXCEPTION
105: WHEN OTHERS THEN
106: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
107: hr_utility.set_location(sqlerrm(sqlcode),110);
108: --
109: END write_to_clob;
110: --
111: --

Line 166: hr_utility.set_location(sqlerrm(sqlcode),110);

162: --
163: EXCEPTION
164: WHEN OTHERS THEN
165: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
166: hr_utility.set_location(sqlerrm(sqlcode),110);
167: --
168: END write_to_clob_for_xml;
169: --
170: -- -----------------------------------------------------------------------------

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

215: l_proc VARCHAR2(40):= g_package||' get parameter ';
216: BEGIN
217: --
218: IF g_debug THEN
219: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
220: END IF;
221: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
222: --
223: IF l_start_pos = 0 THEN

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

236: END IF;
237: END IF;
238: --
239: IF g_debug THEN
240: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
241: END IF;
242: RETURN l_parameter;
243: END;
244: --

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

282: ,p_employee_id; --14260836
283: CLOSE csr_parameter_info;
284: --
285: IF g_debug THEN
286: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
287: END IF;
288: END GET_ALL_PARAMETERS;
289: --
290: -- -----------------------------------------------------------------------------

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

726: --
727: g_debug:=true;
728: --
729: IF g_debug THEN
730: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
731: END IF;
732: --
733: p_sql :='SELECT DISTINCT person_id
734: FROM per_people_f ppf

Line 939: hr_utility.set_location(' Inside Procedure RANGE_CODE',20);

935: ,p_action_information5 => l_year
936: );
937: --
938: IF g_debug THEN
939: hr_utility.set_location(' Inside Procedure RANGE_CODE',20);
940: END IF;
941: /* Inserting municipal codes for the Legal Employer in a PL/SQL table */
942: IF l_local_unit_id IS NULL THEN
943: --

Line 1067: hr_utility.set_location(' Inside Procedure RANGE_CODE',40);

1063: --
1064: END IF ; -- plsql table now contains all the tax municipal codes
1065: --
1066: IF g_debug THEN
1067: hr_utility.set_location(' Inside Procedure RANGE_CODE',40);
1068: END IF;
1069: --
1070: -- ----------------------- --
1071: -- Withholding Tax Section --

Line 1134: hr_utility.set_location(' Inside Procedure RANGE_CODE',60);

1130: --
1131: END LOOP; -- plsql table for all tax municipal exhausted
1132: --
1133: IF g_debug THEN
1134: hr_utility.set_location(' Inside Procedure RANGE_CODE',60);
1135: END IF;
1136:
1137:
1138: --

Line 1398: hr_utility.set_location(' Leaving Procedure RANGE_CODE',70);

1394: --
1395: END IF; -- Count < 0
1396: --
1397: IF g_debug THEN
1398: hr_utility.set_location(' Leaving Procedure RANGE_CODE',70);
1399: END IF;
1400: --
1401: EXCEPTION
1402: --

Line 1423: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);

1419: IS
1420: BEGIN
1421: --
1422: IF g_debug THEN
1423: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1424: END IF;
1425: --
1426: IF g_debug THEN
1427: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);

Line 1427: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);

1423: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1424: END IF;
1425: --
1426: IF g_debug THEN
1427: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);
1428: END IF;
1429: --
1430: END ASSG_ACTION_CODE;
1431: --

Line 1441: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);

1437: IS
1438: BEGIN
1439: --
1440: IF g_debug THEN
1441: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);
1442: END IF;
1443: --
1444: IF g_debug THEN
1445: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);

Line 1445: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);

1441: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);
1442: END IF;
1443: --
1444: IF g_debug THEN
1445: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);
1446: END IF;
1447: --
1448: EXCEPTION WHEN OTHERS THEN
1449: g_err_num := SQLCODE;

Line 1451: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',120);

1447: --
1448: EXCEPTION WHEN OTHERS THEN
1449: g_err_num := SQLCODE;
1450: IF g_debug THEN
1451: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',120);
1452: END IF;
1453: END INIT_CODE;
1454: --
1455: -- -----------------------------------------------------------------------------

Line 1465: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);

1461: IS
1462: BEGIN
1463: --
1464: IF g_debug THEN
1465: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1466: END IF;
1467: --
1468: IF g_debug THEN
1469: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);

Line 1469: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);

1465: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1466: END IF;
1467: --
1468: IF g_debug THEN
1469: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);
1470: END IF;
1471: --
1472: END ARCHIVE_CODE;
1473: --

Line 1590: hr_utility.set_location('Entering ' || l_proc_name, 10);

1586: rec_amt_grp_by_org_muno csr_amt_grp_by_org_muno%ROWTYPE;
1587: --14260836
1588:
1589: BEGIN
1590: hr_utility.set_location('Entering ' || l_proc_name, 10);
1591: g_xml_element_table.DELETE;
1592: --
1593: IF p_payroll_action_id is null then
1594: BEGIN

Line 2083: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

2079: l_xml_element_count := l_xml_element_count + 1;
2080: --
2081: write_to_clob(p_xml);
2082: --
2083: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2084: --
2085: END get_pdf_rep;
2086: --
2087: -- ------------------------------------------------- --

Line 2250: hr_utility.set_location('Entering ' || l_proc_name, 10);

2246: rec_amt_grp_by_org_muno csr_amt_grp_by_org_muno%ROWTYPE;
2247: --14260836
2248:
2249: BEGIN
2250: hr_utility.set_location('Entering ' || l_proc_name, 10);
2251: g_xml_element_table.DELETE;
2252: --
2253: IF p_payroll_action_id is null then
2254: BEGIN

Line 2654: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

2650: l_xml_element_count := l_xml_element_count + 1;
2651: --
2652: write_to_clob_for_xml(p_xml);
2653: --
2654: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2655: --
2656: END get_xml_rep;
2657: --
2658: END PAY_NO_ARC_RSEA_07;