APPS.PAY_FI_TELR dependencies on HR_UTILITY

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

197: l_payroll_action_id :=p_payroll_action_id;
198:
199: END IF;
200:
201: hr_utility.set_location('Entered Procedure GETDATA',10);
202:
203: /* Pick up the details belonging to Header */
204: OPEN CSR_REPORT_DETAILS( l_payroll_action_id);
205: FETCH CSR_REPORT_DETAILS INTO LR_REPORT_DETAILS;

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

206: CLOSE CSR_REPORT_DETAILS;
207:
208:
209:
210: hr_utility.set_location('Before populating pl/sql table',20);
211: FOR lr_TEL_PERSON_DETAILS IN csr_TEL_PERSON_DETAILS( l_payroll_action_id)
212: LOOP
213: l_TIME_RECORD_1 :=false;
214: l_TIME_RECORD_2 :=false;

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

1033: --fnd_file.put_line(fnd_file.log,'END OF A PERSON ' );
1034: --fnd_file.put_line(fnd_file.log,'+++++++++++++++++++++++++END+++++++++++++++++++++++++++++++++++++++++++++++' );
1035:
1036: END LOOP;
1037: hr_utility.set_location('After populating pl/sql table',30);
1038: commit;
1039:
1040: WritetoCLOB (p_xml );
1041:

Line 1065: --hr_utility.trace_on(NULL,'SR1');

1061:
1062: l_IANA_charset VARCHAR2 (50);
1063: BEGIN
1064: l_IANA_charset :=hr_fi_utility.get_IANA_charset ;
1065: --hr_utility.trace_on(NULL,'SR1');
1066: l_str1 := ' ';
1067: l_str2 := '<';
1068: l_str3 := '>';
1069: l_str4 := '

Line 1177: --hr_utility.trace(l_xfdf_string);

1173:
1174: p_xfdf_clob := l_xfdf_string;
1175:
1176:
1177: --hr_utility.trace(l_xfdf_string);
1178:
1179: --clob_to_blob(l_xfdf_string,p_xfdf_blob);
1180:
1181:

Line 1182: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

1178:
1179: --clob_to_blob(l_xfdf_string,p_xfdf_blob);
1180:
1181:
1182: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1183:
1184: --return p_xfdf_blob;
1185: EXCEPTION
1186: WHEN OTHERS then

Line 1187: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1183:
1184: --return p_xfdf_blob;
1185: EXCEPTION
1186: WHEN OTHERS then
1187: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1188: HR_UTILITY.RAISE_ERROR;
1189: END WritetoCLOB;
1190: -------------------------------------------------------------------------------------------------------------------------
1191:

Line 1188: HR_UTILITY.RAISE_ERROR;

1184: --return p_xfdf_blob;
1185: EXCEPTION
1186: WHEN OTHERS then
1187: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1188: HR_UTILITY.RAISE_ERROR;
1189: END WritetoCLOB;
1190: -------------------------------------------------------------------------------------------------------------------------
1191:
1192: END PAY_FI_TELR;