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

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_NO_K27_REIM_UPLD AS
2: /* $Header: pynok27up.pkb 120.0.12020000.10 2013/03/28 04:40:59 smeduri noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_NO_K27_REIM_UPLD.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;

Line 120: hr_utility.set_location('Entering create_k27_element procedure',501);

116:
117:
118: BEGIN
119:
120: hr_utility.set_location('Entering create_k27_element procedure',501);
121: hr_utility.set_location('p_effective_date:'||p_effective_date,502);
122: hr_utility.set_location('p_reimb_date:'||p_reimb_date,503);
123: --
124: -- Get Element information

Line 121: hr_utility.set_location('p_effective_date:'||p_effective_date,502);

117:
118: BEGIN
119:
120: hr_utility.set_location('Entering create_k27_element procedure',501);
121: hr_utility.set_location('p_effective_date:'||p_effective_date,502);
122: hr_utility.set_location('p_reimb_date:'||p_reimb_date,503);
123: --
124: -- Get Element information
125: --

Line 122: hr_utility.set_location('p_reimb_date:'||p_reimb_date,503);

118: BEGIN
119:
120: hr_utility.set_location('Entering create_k27_element procedure',501);
121: hr_utility.set_location('p_effective_date:'||p_effective_date,502);
122: hr_utility.set_location('p_reimb_date:'||p_reimb_date,503);
123: --
124: -- Get Element information
125: --
126: OPEN element_csr;

Line 167: hr_utility.set_location('l_effective_date:'||l_effective_date,504);

163: FETCH csr_payroll_periods INTO l_effective_date;
164: CLOSE csr_payroll_periods;
165: --
166:
167: hr_utility.set_location('l_effective_date:'||l_effective_date,504);
168:
169: -- Call API To Create element entry.
170: py_element_entry_api.create_element_entry (
171: p_effective_date => nvl(l_effective_date,p_effective_date),

Line 199: hr_utility.set_location('leaving create_k27_element element procedure',505);

195: p_create_warning => l_create_warning
196: );
197:
198: g_element_entry_id := l_element_entry_id;
199: hr_utility.set_location('leaving create_k27_element element procedure',505);
200: END create_k27_element;
201:
202: --
203: FUNCTION get_element_link_id

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

268: l_proc VARCHAR2(40):= g_package||' get parameter ';
269: BEGIN
270: --
271: IF g_debug THEN
272: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
273: END IF;
274: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
275: --
276: IF l_start_pos = 0 THEN

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

299: END IF;
300: END IF;
301: --
302: IF g_debug THEN
303: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
304: END IF;
305:
306: RETURN l_parameter;
307:

Line 347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);

343: ,p_business_group_id
344: ,l_period_date;
345: CLOSE csr_parameter_info;
346: --
347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);
348: hr_utility.set_location(' p_filename:'||p_filename,32);
349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);
350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);
351: hr_utility.set_location(' l_period_date:'||l_period_date,35);

Line 348: hr_utility.set_location(' p_filename:'||p_filename,32);

344: ,l_period_date;
345: CLOSE csr_parameter_info;
346: --
347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);
348: hr_utility.set_location(' p_filename:'||p_filename,32);
349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);
350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);
351: hr_utility.set_location(' l_period_date:'||l_period_date,35);
352:

Line 349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);

345: CLOSE csr_parameter_info;
346: --
347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);
348: hr_utility.set_location(' p_filename:'||p_filename,32);
349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);
350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);
351: hr_utility.set_location(' l_period_date:'||l_period_date,35);
352:
353: p_period_date := fnd_date.canonical_to_date(l_period_date);

Line 350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);

346: --
347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);
348: hr_utility.set_location(' p_filename:'||p_filename,32);
349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);
350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);
351: hr_utility.set_location(' l_period_date:'||l_period_date,35);
352:
353: p_period_date := fnd_date.canonical_to_date(l_period_date);
354:

Line 351: hr_utility.set_location(' l_period_date:'||l_period_date,35);

347: hr_utility.set_location(' p_legal_employer_no:'||p_legal_employer_no,31);
348: hr_utility.set_location(' p_filename:'||p_filename,32);
349: hr_utility.set_location(' p_test_submission:'||p_test_submission,33);
350: hr_utility.set_location(' p_effective_date:'||p_effective_date,34);
351: hr_utility.set_location(' l_period_date:'||l_period_date,35);
352:
353: p_period_date := fnd_date.canonical_to_date(l_period_date);
354:
355: hr_utility.set_location(' p_period_date:'||p_period_date,36);

Line 355: hr_utility.set_location(' p_period_date:'||p_period_date,36);

351: hr_utility.set_location(' l_period_date:'||l_period_date,35);
352:
353: p_period_date := fnd_date.canonical_to_date(l_period_date);
354:
355: hr_utility.set_location(' p_period_date:'||p_period_date,36);
356:
357: IF g_debug THEN
358: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',40);
359: END IF;

Line 358: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',40);

354:
355: hr_utility.set_location(' p_period_date:'||p_period_date,36);
356:
357: IF g_debug THEN
358: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',40);
359: END IF;
360:
361: END GET_ALL_PARAMETERS;
362:

Line 856: hr_utility.set_location( l_pkg ,100);

852:
853: EXCEPTION
854: WHEN e_fatal_error
855: THEN
856: hr_utility.set_location( l_pkg ,100);
857: retcode := 2;
858: errbuf := 'Reading File - Invalid Operation (file not found).';
859:
860: WHEN UTL_FILE.INVALID_OPERATION

Line 864: hr_utility.set_location( l_pkg ,110);

860: WHEN UTL_FILE.INVALID_OPERATION
861: THEN
862:
863: UTL_FILE.FCLOSE(l_file_handle);
864: hr_utility.set_location( l_pkg ,110);
865: retcode:=2;
866: errbuf := 'Reading File - Invalid Operation (file not found).';
867:
868: WHEN UTL_FILE.INTERNAL_ERROR

Line 872: hr_utility.set_location( l_pkg,120);

868: WHEN UTL_FILE.INTERNAL_ERROR
869: THEN
870:
871: UTL_FILE.FCLOSE(l_file_handle);
872: hr_utility.set_location( l_pkg,120);
873: retcode:=2;
874: errbuf := 'Reading File - Internal Error.';
875: WHEN UTL_FILE.INVALID_MODE
876: THEN

Line 879: hr_utility.set_location( l_pkg,130);

875: WHEN UTL_FILE.INVALID_MODE
876: THEN
877:
878: UTL_FILE.FCLOSE(l_file_handle);
879: hr_utility.set_location( l_pkg,130);
880: retcode:=2;
881: errbuf := 'Reading Flat File - Invalid Mode.';
882:
883: WHEN UTL_FILE.INVALID_PATH

Line 887: hr_utility.set_location( l_pkg ||'PAYE Upload',140);

883: WHEN UTL_FILE.INVALID_PATH
884: THEN
885:
886: UTL_FILE.FCLOSE(l_file_handle);
887: hr_utility.set_location( l_pkg ||'PAYE Upload',140);
888: retcode:=2;
889: errbuf := 'Reading File - Invalid Path.';
890:
891: WHEN UTL_FILE.INVALID_FILEHANDLE

Line 895: hr_utility.set_location( l_pkg,150);

891: WHEN UTL_FILE.INVALID_FILEHANDLE
892: THEN
893:
894: UTL_FILE.FCLOSE(l_file_handle);
895: hr_utility.set_location( l_pkg,150);
896: retcode:=2;
897: errbuf := 'Reading File - Invalid File Handle.';
898:
899: WHEN UTL_FILE.READ_ERROR

Line 903: hr_utility.set_location( l_pkg,160);

899: WHEN UTL_FILE.READ_ERROR
900: THEN
901:
902: UTL_FILE.FCLOSE(l_file_handle);
903: hr_utility.set_location( l_pkg,160);
904: retcode:=2;
905: errbuf := 'Reading File - Read Error.';
906:
907: WHEN NO_DATA_FOUND

Line 910: hr_utility.set_location( l_pkg,170);

906:
907: WHEN NO_DATA_FOUND
908: THEN
909: UTL_FILE.FCLOSE(l_file_handle);
910: hr_utility.set_location( l_pkg,170);
911: retcode:=2;
912: errbuf := 'No Data Found.';
913:
914: WHEN INVALID_FILE_FORMAT

Line 917: hr_utility.set_location( l_pkg,180);

913:
914: WHEN INVALID_FILE_FORMAT
915: THEN
916: UTL_FILE.FCLOSE(l_file_handle);
917: hr_utility.set_location( l_pkg,180);
918: retcode:=2;
919: errbuf := 'Reading File - Invalid File Format.';
920:
921: WHEN NO_REC_FOUND_IN_FILE

Line 924: hr_utility.set_location( l_pkg,190);

920:
921: WHEN NO_REC_FOUND_IN_FILE
922: THEN
923: UTL_FILE.FCLOSE(l_file_handle);
924: hr_utility.set_location( l_pkg,190);
925: retcode:=2;
926: errbuf := 'Reading File - No Records found.';
927:
928: WHEN others

Line 932: hr_utility.set_location( l_pkg,210);

928: WHEN others
929: THEN
930: retcode:=2;
931: errbuf := 'Exception occured :'||sqlerrm;
932: hr_utility.set_location( l_pkg,210);
933:
934: END READ_K27_FILE;
935:
936:

Line 1112: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);

1108: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1109:
1110: BEGIN
1111:
1112: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
1113:
1114: IF g_debug THEN
1115: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
1116: END IF;

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

1111:
1112: hr_utility.set_location(' Entering Procedure RANGE_CODE',1);
1113:
1114: IF g_debug THEN
1115: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
1116: END IF;
1117:
1118: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id
1119: AND ppa.business_group_id = ppf.business_group_id and 1=2 ORDER BY ppf.person_id ';

Line 1121: hr_utility.set_location('RANGE_CODE:Before Calling GET_ALL_PARAMETERS',2);

1117:
1118: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id
1119: AND ppa.business_group_id = ppf.business_group_id and 1=2 ORDER BY ppf.person_id ';
1120:
1121: hr_utility.set_location('RANGE_CODE:Before Calling GET_ALL_PARAMETERS',2);
1122: g_payroll_action_id := p_payroll_action_id;
1123:
1124: PAY_NO_K27_REIM_UPLD.GET_ALL_PARAMETERS
1125: ( p_payroll_action_id

Line 1133: hr_utility.set_location('RANGE_CODE:After Calling GET_ALL_PARAMETERS',3);

1129: ,l_test_submission
1130: ,l_filename
1131: ,g_period_date);
1132:
1133: hr_utility.set_location('RANGE_CODE:After Calling GET_ALL_PARAMETERS',3);
1134:
1135: /* Pick up the details belonging to Legal Employer
1136:
1137: OPEN csr_Legal_Emp_Details(g_legal_employer_id);

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

1163: END IF;
1164:
1165:
1166: IF g_debug THEN
1167: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
1168: END IF;
1169:
1170: EXCEPTION
1171: WHEN others THEN

Line 1173: hr_utility.set_location('error raised assignment_action_code ',5);

1169:
1170: EXCEPTION
1171: WHEN others THEN
1172: IF g_debug THEN
1173: hr_utility.set_location('error raised assignment_action_code ',5);
1174: END if;
1175: RAISE;
1176: END RANGE_CODE;
1177:

Line 1192: hr_utility.set_location('error raised assignment_action_code ',5);

1188: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE END 2');
1189: EXCEPTION
1190: WHEN others THEN
1191: IF g_debug THEN
1192: hr_utility.set_location('error raised assignment_action_code ',5);
1193: END if;
1194: RAISE;
1195: END ASSIGNMENT_ACTION_CODE;
1196:

Line 1204: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

1200: IS
1201:
1202: BEGIN
1203: IF g_debug THEN
1204: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
1205: END IF;
1206: IF g_debug THEN
1207: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
1208: END IF;

Line 1207: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

1203: IF g_debug THEN
1204: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
1205: END IF;
1206: IF g_debug THEN
1207: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
1208: END IF;
1209:
1210: EXCEPTION
1211: WHEN others THEN

Line 1213: hr_utility.set_location('error raised initialization code ',5);

1209:
1210: EXCEPTION
1211: WHEN others THEN
1212: IF g_debug THEN
1213: hr_utility.set_location('error raised initialization code ',5);
1214: END if;
1215: RAISE;
1216: END INITIALIZATION_CODE;
1217:

Line 1228: hr_utility.set_location('error raised in archive code ',5);

1224: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE END 2');
1225: EXCEPTION
1226: WHEN others THEN
1227: IF g_debug THEN
1228: hr_utility.set_location('error raised in archive code ',5);
1229: END if;
1230: RAISE;
1231: END ARCHIVE_CODE;
1232:

Line 1241: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',999);

1237: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');
1238: EXCEPTION
1239: WHEN others THEN
1240: IF g_debug THEN
1241: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',999);
1242: END if;
1243: RAISE;
1244: END DEINITIALIZATION_CODE;
1245:

Line 1289: hr_utility.set_location('Entering K27_NOTIFICATION_REP ',800);

1285: and to_date(pai.action_information13,'RRRRMMDD') between papf.effective_start_date and papf.effective_end_date;
1286:
1287:
1288: BEGIN
1289: hr_utility.set_location('Entering K27_NOTIFICATION_REP ',800);
1290:
1291: fnd_file.PUT_LINE(FND_FILE.LOG,'p_legal_employer:'||p_legal_employer);
1292: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_from:'||p_Date_from);
1293: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_to:'||p_Date_to);

Line 1312: hr_utility.set_location('Leaving K27_NOTIFICATION_REP ',888);

1308: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD(I.emp_number,21,' ')||RPAD(I.NI_number,25,' ')||RPAD(I. Reimb_date,26,' ')||I.reimburse_amount);
1309:
1310: END LOOP;
1311:
1312: hr_utility.set_location('Leaving K27_NOTIFICATION_REP ',888);
1313:
1314: EXCEPTION
1315: WHEN others THEN
1316: IF g_debug THEN

Line 1317: hr_utility.set_location('error raised in K27_NOTIFICATION_REP ',888);

1313:
1314: EXCEPTION
1315: WHEN others THEN
1316: IF g_debug THEN
1317: hr_utility.set_location('error raised in K27_NOTIFICATION_REP ',888);
1318: END if;
1319: RAISE;
1320: END k27_notification_rep;
1321: