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 280: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

276: ,p_business_group_id;
277: CLOSE csr_parameter_info;
278: --
279: IF g_debug THEN
280: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
281: END IF;
282: END GET_ALL_PARAMETERS;
283: --
284: -- -----------------------------------------------------------------------------

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

687: --
688: g_debug:=true;
689: --
690: IF g_debug THEN
691: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
692: END IF;
693: --
694: p_sql :='SELECT DISTINCT person_id
695: FROM per_people_f ppf

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

853: ,p_action_information5 => l_year
854: );
855: --
856: IF g_debug THEN
857: hr_utility.set_location(' Inside Procedure RANGE_CODE',20);
858: END IF;
859: /* Inserting municipal codes for the Legal Employer in a PL/SQL table */
860: IF l_local_unit_id IS NULL THEN
861: --

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

980: --
981: END IF ; -- plsql table now contains all the tax municipal codes
982: --
983: IF g_debug THEN
984: hr_utility.set_location(' Inside Procedure RANGE_CODE',40);
985: END IF;
986: --
987: -- ----------------------- --
988: -- Withholding Tax Section --

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

1042: --
1043: END LOOP; -- plsql table for all tax municipal exhausted
1044: --
1045: IF g_debug THEN
1046: hr_utility.set_location(' Inside Procedure RANGE_CODE',60);
1047: END IF;
1048: --
1049: -- ----------------------------- --
1050: -- Employer Contribution Section --

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

1270: --
1271: END IF; -- Count < 0
1272: --
1273: IF g_debug THEN
1274: hr_utility.set_location(' Leaving Procedure RANGE_CODE',70);
1275: END IF;
1276: --
1277: EXCEPTION
1278: --

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

1295: IS
1296: BEGIN
1297: --
1298: IF g_debug THEN
1299: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1300: END IF;
1301: --
1302: IF g_debug THEN
1303: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);

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

1299: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',80);
1300: END IF;
1301: --
1302: IF g_debug THEN
1303: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',90);
1304: END IF;
1305: --
1306: END ASSG_ACTION_CODE;
1307: --

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

1313: IS
1314: BEGIN
1315: --
1316: IF g_debug THEN
1317: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);
1318: END IF;
1319: --
1320: IF g_debug THEN
1321: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);

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

1317: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',100);
1318: END IF;
1319: --
1320: IF g_debug THEN
1321: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',110);
1322: END IF;
1323: --
1324: EXCEPTION WHEN OTHERS THEN
1325: g_err_num := SQLCODE;

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

1323: --
1324: EXCEPTION WHEN OTHERS THEN
1325: g_err_num := SQLCODE;
1326: IF g_debug THEN
1327: hr_utility.set_location('ORA_ERR: ' || g_err_num || 'In INITIALIZATION_CODE',120);
1328: END IF;
1329: END INIT_CODE;
1330: --
1331: -- -----------------------------------------------------------------------------

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

1337: IS
1338: BEGIN
1339: --
1340: IF g_debug THEN
1341: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1342: END IF;
1343: --
1344: IF g_debug THEN
1345: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);

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

1341: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',130);
1342: END IF;
1343: --
1344: IF g_debug THEN
1345: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',140);
1346: END IF;
1347: --
1348: END ARCHIVE_CODE;
1349: --

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

1432: l_ec_amt_total NUMBER := 0;
1433: l_wt_total NUMBER := 0;
1434: --
1435: BEGIN
1436: hr_utility.set_location('Entering ' || l_proc_name, 10);
1437: g_xml_element_table.DELETE;
1438: --
1439: IF p_payroll_action_id is null then
1440: BEGIN

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

1851: l_xml_element_count := l_xml_element_count + 1;
1852: --
1853: write_to_clob(p_xml);
1854: --
1855: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
1856: --
1857: END get_pdf_rep;
1858: --
1859: -- ------------------------------------------------- --

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

1945: l_payroll_action_id NUMBER;
1946: l_wt_total NUMBER := 0;
1947: --
1948: BEGIN
1949: hr_utility.set_location('Entering ' || l_proc_name, 10);
1950: g_xml_element_table.DELETE;
1951: --
1952: IF p_payroll_action_id is null then
1953: BEGIN

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

2315: l_xml_element_count := l_xml_element_count + 1;
2316: --
2317: write_to_clob_for_xml(p_xml);
2318: --
2319: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2320: --
2321: END get_xml_rep;
2322: --
2323: END PAY_NO_ARC_RSEA_07;