APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on HR_UTILITY

Line 14: g_debug boolean := hr_utility.debug_enabled;

10: g_legal_employer_id NUMBER;
11: g_report_date DATE;
12: g_effective_date DATE;
13: g_archive VARCHAR2(30);
14: g_debug boolean := hr_utility.debug_enabled;
15: g_payroll_action_id NUMBER;
16: g_package VARCHAR2(30) := 'pay_se_stat_office_archive.';
17: g_version VARCHAR2(10);
18: g_start_date DATE;

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

94: CLOSE csr_parameter_info;
95:
96:
97: IF g_debug THEN
98: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
99: END IF;
100: END GET_ALL_PARAMETERS;
101:
102: --

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

187: -- Archive report information.
188: --
189: --
190: IF g_debug THEN
191: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
192: END IF;
193:
194: p_sql := 'SELECT DISTINCT person_id
195: FROM per_people_f ppf

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

323:
324: END IF; -- G_Archive End
325:
326: IF g_debug THEN
327: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
328: END IF; --
329: END range_code;
330: --
331: -- ---------------------------------------------------------------------

Line 354: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);

350: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
351:
352: BEGIN
353: IF g_debug THEN
354: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
355: END IF;
356:
357: OPEN csr_def_bal_id(p_user_name);
358: FETCH csr_def_bal_id INTO l_defined_balance_id;

Line 364: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);

360:
361: RETURN l_defined_balance_id;
362:
363: IF g_debug THEN
364: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
365: END IF;
366: END GET_DEFINED_BALANCE_ID;
367:
368:

Line 1004: hr_utility.set_location('Entering WritetoCLOB ',10);

1000: current_index pls_integer;
1001:
1002: BEGIN
1003:
1004: hr_utility.set_location('Entering WritetoCLOB ',10);
1005:
1006:
1007: l_IANA_charset := HR_SE_UTILITY.get_IANA_charset ;
1008: l_str1 := ' ';

Line 1081: hr_utility.set_location('Leaving WritetoCLOB ',20);

1077: END IF;
1078:
1079: p_xfdf_clob := l_xfdf_string;
1080:
1081: hr_utility.set_location('Leaving WritetoCLOB ',20);
1082:
1083: EXCEPTION
1084: WHEN OTHERS then
1085: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

Line 1085: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

1081: hr_utility.set_location('Leaving WritetoCLOB ',20);
1082:
1083: EXCEPTION
1084: WHEN OTHERS then
1085: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1086: HR_UTILITY.RAISE_ERROR;
1087: END WritetoCLOB;
1088:
1089:

Line 1086: HR_UTILITY.RAISE_ERROR;

1082:
1083: EXCEPTION
1084: WHEN OTHERS then
1085: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1086: HR_UTILITY.RAISE_ERROR;
1087: END WritetoCLOB;
1088:
1089:
1090: --

Line 1215: hr_utility.set_location('Entered Procedure GETDATA',10);

1211: ,g_end_date
1212: ,g_archive
1213: );
1214:
1215: hr_utility.set_location('Entered Procedure GETDATA',10);
1216:
1217:
1218: /* Get the File Header Information */
1219: OPEN csr_legal_employer_details(l_payroll_action_id);

Line 1223: hr_utility.set_location('Before populating pl/sql table',20);

1219: OPEN csr_legal_employer_details(l_payroll_action_id);
1220: FETCH csr_legal_employer_details INTO l_legal_employer_details_rec;
1221: CLOSE csr_legal_employer_details;
1222:
1223: hr_utility.set_location('Before populating pl/sql table',20);
1224:
1225: xml_tab(l_counter).TagName :='ORG_DETAILS';
1226: xml_tab(l_counter).TagValue :='ORG_DETAILS';
1227: l_counter:=l_counter+1;

Line 1322: hr_utility.set_location('After populating pl/sql table',30);

1318: xml_tab(l_counter).TagValue :='END_ORG_DETAILS';
1319: l_counter := l_counter + 1;
1320:
1321:
1322: hr_utility.set_location('After populating pl/sql table',30);
1323: hr_utility.set_location('Entered Procedure GETDATA',10);
1324:
1325:
1326: WritetoCLOB (p_xml );

Line 1323: hr_utility.set_location('Entered Procedure GETDATA',10);

1319: l_counter := l_counter + 1;
1320:
1321:
1322: hr_utility.set_location('After populating pl/sql table',30);
1323: hr_utility.set_location('Entered Procedure GETDATA',10);
1324:
1325:
1326: WritetoCLOB (p_xml );
1327: