118: FETCH c_get_requester_code INTO l_requester_code,l_org_name;
119: IF c_get_requester_code%NOTFOUND THEN
120: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
121: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
122: fnd_file.put_line(fnd_file.LOG, l_text);
123: ELSE
124: IF l_requester_code IS NULL THEN
125: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
126: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
123: ELSE
124: IF l_requester_code IS NULL THEN
125: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
126: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
127: fnd_file.put_line(fnd_file.LOG, l_text);
128: END IF;
129: END IF;
130: CLOSE c_get_requester_code;
131:
139: FETCH c_get_requester_code INTO l_requester_code,l_org_name;
140: IF c_get_requester_code%NOTFOUND THEN
141: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
142: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
143: fnd_file.put_line(fnd_file.LOG, l_text);
144: ELSE
145: IF l_requester_code IS NULL THEN
146: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
147: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
144: ELSE
145: IF l_requester_code IS NULL THEN
146: l_text := 'ERROR:Requester Identification Code is a mandatory field for the report. '||
147: 'Please enter Requester Identification Code in EVS Filing for '||l_gre_name;
148: fnd_file.put_line(fnd_file.LOG, l_text);
149: END IF;
150: END IF;
151: CLOSE c_get_requester_code;
152:
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
676: fnd_file.put_line(fnd_file.log,SQLERRM);
677: END get_root_dir;
678:
679: ---------------------------------------------------------------------------
680: -- EVS_MAG_REPORT
1126: || l_delimiter -- BUG4447245
1127: ;
1128: hr_utility.trace('l_buff = ' || l_buff);
1129:
1130: fnd_file.put_line
1131: (which => fnd_file.output
1132: ,buff => l_buff
1133: );
1134:
1127: ;
1128: hr_utility.trace('l_buff = ' || l_buff);
1129:
1130: fnd_file.put_line
1131: (which => fnd_file.output
1132: ,buff => l_buff
1133: );
1134:
1135: utl_file.put(g_file_id,l_buff);
1324:
1325: hr_utility.set_location(l_proc,50);
1326: utl_file.fclose(g_file_id);
1327: if l_header = 0 then
1328: fnd_file.put_line
1329: (which => fnd_file.log
1330: ,buff => ' '
1331: );
1332: fnd_file.put_line
1325: hr_utility.set_location(l_proc,50);
1326: utl_file.fclose(g_file_id);
1327: if l_header = 0 then
1328: fnd_file.put_line
1329: (which => fnd_file.log
1330: ,buff => ' '
1331: );
1332: fnd_file.put_line
1333: (which => fnd_file.log
1328: fnd_file.put_line
1329: (which => fnd_file.log
1330: ,buff => ' '
1331: );
1332: fnd_file.put_line
1333: (which => fnd_file.log
1334: ,buff => ' EVS Report Summary '
1335: );
1336: fnd_file.put_line
1329: (which => fnd_file.log
1330: ,buff => ' '
1331: );
1332: fnd_file.put_line
1333: (which => fnd_file.log
1334: ,buff => ' EVS Report Summary '
1335: );
1336: fnd_file.put_line
1337: (which => fnd_file.log
1332: fnd_file.put_line
1333: (which => fnd_file.log
1334: ,buff => ' EVS Report Summary '
1335: );
1336: fnd_file.put_line
1337: (which => fnd_file.log
1338: ,buff => ' '
1339: );
1340: fnd_file.put_line
1333: (which => fnd_file.log
1334: ,buff => ' EVS Report Summary '
1335: );
1336: fnd_file.put_line
1337: (which => fnd_file.log
1338: ,buff => ' '
1339: );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1336: fnd_file.put_line
1337: (which => fnd_file.log
1338: ,buff => ' '
1339: );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => ' GRE Name Total number '
1343: );
1344: fnd_file.put_line
1337: (which => fnd_file.log
1338: ,buff => ' '
1339: );
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => ' GRE Name Total number '
1343: );
1344: fnd_file.put_line
1345: (which => fnd_file.log
1340: fnd_file.put_line
1341: (which => fnd_file.log
1342: ,buff => ' GRE Name Total number '
1343: );
1344: fnd_file.put_line
1345: (which => fnd_file.log
1346: ,buff => ' ------------------- ------------- '
1347: );
1348: l_header := 1;
1341: (which => fnd_file.log
1342: ,buff => ' GRE Name Total number '
1343: );
1344: fnd_file.put_line
1345: (which => fnd_file.log
1346: ,buff => ' ------------------- ------------- '
1347: );
1348: l_header := 1;
1349: end if;
1346: ,buff => ' ------------------- ------------- '
1347: );
1348: l_header := 1;
1349: end if;
1350: fnd_file.put_line
1351: (which => fnd_file.log
1352: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1353: );
1354: fnd_file.put_line
1347: );
1348: l_header := 1;
1349: end if;
1350: fnd_file.put_line
1351: (which => fnd_file.log
1352: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1353: );
1354: fnd_file.put_line
1355: (which => fnd_file.log
1350: fnd_file.put_line
1351: (which => fnd_file.log
1352: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1353: );
1354: fnd_file.put_line
1355: (which => fnd_file.log
1356: ,buff => ' '
1357: );
1358: else
1351: (which => fnd_file.log
1352: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1353: );
1354: fnd_file.put_line
1355: (which => fnd_file.log
1356: ,buff => ' '
1357: );
1358: else
1359: hr_utility.set_location(l_proc,60);
1389:
1390: hr_utility.set_location(l_proc,70);
1391:
1392: if l_header = 0 then
1393: fnd_file.put_line
1394: (which => fnd_file.log
1395: ,buff => ' '
1396: );
1397: fnd_file.put_line
1390: hr_utility.set_location(l_proc,70);
1391:
1392: if l_header = 0 then
1393: fnd_file.put_line
1394: (which => fnd_file.log
1395: ,buff => ' '
1396: );
1397: fnd_file.put_line
1398: (which => fnd_file.log
1393: fnd_file.put_line
1394: (which => fnd_file.log
1395: ,buff => ' '
1396: );
1397: fnd_file.put_line
1398: (which => fnd_file.log
1399: ,buff => ' EVS Report Summary '
1400: );
1401: fnd_file.put_line
1394: (which => fnd_file.log
1395: ,buff => ' '
1396: );
1397: fnd_file.put_line
1398: (which => fnd_file.log
1399: ,buff => ' EVS Report Summary '
1400: );
1401: fnd_file.put_line
1402: (which => fnd_file.log
1397: fnd_file.put_line
1398: (which => fnd_file.log
1399: ,buff => ' EVS Report Summary '
1400: );
1401: fnd_file.put_line
1402: (which => fnd_file.log
1403: ,buff => ' '
1404: );
1405: fnd_file.put_line
1398: (which => fnd_file.log
1399: ,buff => ' EVS Report Summary '
1400: );
1401: fnd_file.put_line
1402: (which => fnd_file.log
1403: ,buff => ' '
1404: );
1405: fnd_file.put_line
1406: (which => fnd_file.log
1401: fnd_file.put_line
1402: (which => fnd_file.log
1403: ,buff => ' '
1404: );
1405: fnd_file.put_line
1406: (which => fnd_file.log
1407: ,buff => ' GRE Name Total number '
1408: );
1409: fnd_file.put_line
1402: (which => fnd_file.log
1403: ,buff => ' '
1404: );
1405: fnd_file.put_line
1406: (which => fnd_file.log
1407: ,buff => ' GRE Name Total number '
1408: );
1409: fnd_file.put_line
1410: (which => fnd_file.log
1405: fnd_file.put_line
1406: (which => fnd_file.log
1407: ,buff => ' GRE Name Total number '
1408: );
1409: fnd_file.put_line
1410: (which => fnd_file.log
1411: ,buff => ' ------------------- ------------- '
1412: );
1413: l_header := 1;
1406: (which => fnd_file.log
1407: ,buff => ' GRE Name Total number '
1408: );
1409: fnd_file.put_line
1410: (which => fnd_file.log
1411: ,buff => ' ------------------- ------------- '
1412: );
1413: l_header := 1;
1414: end if;
1412: );
1413: l_header := 1;
1414: end if;
1415: hr_utility.set_location(l_proc,71);
1416: fnd_file.put_line
1417: (which => fnd_file.log
1418: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1419: ' ' || to_char(l_gre_count)
1420: );
1413: l_header := 1;
1414: end if;
1415: hr_utility.set_location(l_proc,71);
1416: fnd_file.put_line
1417: (which => fnd_file.log
1418: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1419: ' ' || to_char(l_gre_count)
1420: );
1421: l_all_count := l_all_count + l_gre_count;
1420: );
1421: l_all_count := l_all_count + l_gre_count;
1422: END LOOP;
1423: hr_utility.set_location(l_proc,72);
1424: fnd_file.put_line
1425: (which => fnd_file.log
1426: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1427: ' ' || to_char(l_all_count)
1428: );
1421: l_all_count := l_all_count + l_gre_count;
1422: END LOOP;
1423: hr_utility.set_location(l_proc,72);
1424: fnd_file.put_line
1425: (which => fnd_file.log
1426: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1427: ' ' || to_char(l_all_count)
1428: );
1429: fnd_file.put_line
1425: (which => fnd_file.log
1426: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1427: ' ' || to_char(l_all_count)
1428: );
1429: fnd_file.put_line
1430: (which => fnd_file.log
1431: ,buff => ' '
1432: );
1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1426: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1427: ' ' || to_char(l_all_count)
1428: );
1429: fnd_file.put_line
1430: (which => fnd_file.log
1431: ,buff => ' '
1432: );
1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1434: hr_utility.set_location(l_proc,74);
1437:
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
1441: fnd_file.put_line(fnd_file.log,SQLERRM);
1442: RAISE;
1443:
1444: end evs_mag_report_main;
1445: