APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on HR_UTILITY

Line 38: g_debug boolean := hr_utility.debug_enabled;

34: g_legal_employer_id NUMBER;
35: g_report_date DATE;
36: g_effective_date DATE;
37: g_archive VARCHAR2(30);
38: g_debug boolean := hr_utility.debug_enabled;
39: g_payroll_action_id NUMBER;
40: g_package VARCHAR2(30) := 'pay_no_sal_statistics_archive.';
41: g_version VARCHAR2(10);
42: g_sp_org_id VARCHAR2(39);

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

117: --fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
118: --fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
119:
120: IF g_debug THEN
121: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
122: END IF;
123: END GET_ALL_PARAMETERS;
124:
125: --

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

231: -- Archive report information.
232: --
233: --
234: IF g_debug THEN
235: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
236: END IF;
237:
238: p_sql := 'SELECT DISTINCT person_id
239: FROM per_people_f ppf

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

428:
429: END IF; -- G_Archive End
430:
431: IF g_debug THEN
432: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
433: END IF; --
434: END range_code;
435: --
436: -- ---------------------------------------------------------------------

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

452: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
453:
454: BEGIN
455: IF g_debug THEN
456: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
457: END IF;
458:
459: OPEN csr_def_bal_id(p_user_name);
460: FETCH csr_def_bal_id INTO l_defined_balance_id;

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

462:
463: RETURN l_defined_balance_id;
464:
465: IF g_debug THEN
466: hr_utility.set_location(' Leaving Function GET_DEFINED_BALANCE_ID',250);
467: END IF;
468: END GET_DEFINED_BALANCE_ID;
469: --
470: -- -----------------------------------------------------------------------------

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

986: current_index pls_integer;
987:
988: BEGIN
989:
990: hr_utility.set_location('Entering WritetoCLOB ',10);
991:
992:
993: l_IANA_charset := HR_NO_UTILITY.get_IANA_charset ;
994: l_str1 := ' ';

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

1069: END IF;
1070:
1071: p_xfdf_clob := l_xfdf_string;
1072:
1073: hr_utility.set_location('Leaving WritetoCLOB ',20);
1074:
1075: EXCEPTION
1076: WHEN OTHERS then
1077: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

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

1073: hr_utility.set_location('Leaving WritetoCLOB ',20);
1074:
1075: EXCEPTION
1076: WHEN OTHERS then
1077: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1078: HR_UTILITY.RAISE_ERROR;
1079: END WritetoCLOB;
1080:
1081: --

Line 1078: HR_UTILITY.RAISE_ERROR;

1074:
1075: EXCEPTION
1076: WHEN OTHERS then
1077: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1078: HR_UTILITY.RAISE_ERROR;
1079: END WritetoCLOB;
1080:
1081: --
1082: --

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

1251: l_payroll_action_id := p_payroll_action_id;
1252:
1253: END IF;
1254:
1255: hr_utility.set_location('Entered Procedure GETDATA',10);
1256:
1257: OPEN csr_version(l_payroll_action_id);
1258: FETCH csr_version INTO l_version_rec;
1259: CLOSE csr_version;

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

1263: OPEN csr_legal_employer_details(l_payroll_action_id);
1264: FETCH csr_legal_employer_details INTO l_legal_employer_details_rec;
1265: CLOSE csr_legal_employer_details;
1266:
1267: hr_utility.set_location('Before populating pl/sql table',20);
1268:
1269: xml_tab(l_counter).TagName :='STATEMENT_PROVIDER';
1270: xml_tab(l_counter).TagValue :='STATEMENT_PROVIDER';
1271: l_counter:=l_counter+1;

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

1630: xml_tab(l_counter).TagValue :='END_STATEMENT_PROVIDER';
1631: l_counter := l_counter + 1;
1632:
1633:
1634: hr_utility.set_location('After populating pl/sql table',30);
1635: hr_utility.set_location('Entered Procedure GETDATA',10);
1636:
1637:
1638: WritetoCLOB (p_xml );

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

1631: l_counter := l_counter + 1;
1632:
1633:
1634: hr_utility.set_location('After populating pl/sql table',30);
1635: hr_utility.set_location('Entered Procedure GETDATA',10);
1636:
1637:
1638: WritetoCLOB (p_xml );
1639: