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.

[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on FND_FILE

Line 122: fnd_file.put_line(fnd_file.LOG, l_text);

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;

Line 127: 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;
127: fnd_file.put_line(fnd_file.LOG, l_text);
128: END IF;
129: END IF;
130: CLOSE c_get_requester_code;
131:

Line 143: fnd_file.put_line(fnd_file.LOG, l_text);

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;

Line 148: 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;
148: fnd_file.put_line(fnd_file.LOG, l_text);
149: END IF;
150: END IF;
151: CLOSE c_get_requester_code;
152:

Line 676: fnd_file.put_line(fnd_file.log,SQLERRM);

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

Line 1150: fnd_file.put_line

1146: || l_delimiter -- BUG4447245
1147: ;
1148: hr_utility.trace('l_buff = ' || l_buff);
1149:
1150: fnd_file.put_line
1151: (which => fnd_file.output
1152: ,buff => l_buff
1153: );
1154:

Line 1151: (which => fnd_file.output

1147: ;
1148: hr_utility.trace('l_buff = ' || l_buff);
1149:
1150: fnd_file.put_line
1151: (which => fnd_file.output
1152: ,buff => l_buff
1153: );
1154:
1155: utl_file.put(g_file_id,l_buff);

Line 1348: fnd_file.put_line

1344:
1345: hr_utility.set_location(l_proc,50);
1346: utl_file.fclose(g_file_id);
1347: if l_header = 0 then
1348: fnd_file.put_line
1349: (which => fnd_file.log
1350: ,buff => ' '
1351: );
1352: fnd_file.put_line

Line 1349: (which => fnd_file.log

1345: hr_utility.set_location(l_proc,50);
1346: utl_file.fclose(g_file_id);
1347: if l_header = 0 then
1348: fnd_file.put_line
1349: (which => fnd_file.log
1350: ,buff => ' '
1351: );
1352: fnd_file.put_line
1353: (which => fnd_file.log

Line 1352: fnd_file.put_line

1348: fnd_file.put_line
1349: (which => fnd_file.log
1350: ,buff => ' '
1351: );
1352: fnd_file.put_line
1353: (which => fnd_file.log
1354: ,buff => ' EVS Report Summary '
1355: );
1356: fnd_file.put_line

Line 1353: (which => fnd_file.log

1349: (which => fnd_file.log
1350: ,buff => ' '
1351: );
1352: fnd_file.put_line
1353: (which => fnd_file.log
1354: ,buff => ' EVS Report Summary '
1355: );
1356: fnd_file.put_line
1357: (which => fnd_file.log

Line 1356: fnd_file.put_line

1352: fnd_file.put_line
1353: (which => fnd_file.log
1354: ,buff => ' EVS Report Summary '
1355: );
1356: fnd_file.put_line
1357: (which => fnd_file.log
1358: ,buff => ' '
1359: );
1360: fnd_file.put_line

Line 1357: (which => fnd_file.log

1353: (which => fnd_file.log
1354: ,buff => ' EVS Report Summary '
1355: );
1356: fnd_file.put_line
1357: (which => fnd_file.log
1358: ,buff => ' '
1359: );
1360: fnd_file.put_line
1361: (which => fnd_file.log

Line 1360: fnd_file.put_line

1356: fnd_file.put_line
1357: (which => fnd_file.log
1358: ,buff => ' '
1359: );
1360: fnd_file.put_line
1361: (which => fnd_file.log
1362: ,buff => ' GRE Name Total number '
1363: );
1364: fnd_file.put_line

Line 1361: (which => fnd_file.log

1357: (which => fnd_file.log
1358: ,buff => ' '
1359: );
1360: fnd_file.put_line
1361: (which => fnd_file.log
1362: ,buff => ' GRE Name Total number '
1363: );
1364: fnd_file.put_line
1365: (which => fnd_file.log

Line 1364: fnd_file.put_line

1360: fnd_file.put_line
1361: (which => fnd_file.log
1362: ,buff => ' GRE Name Total number '
1363: );
1364: fnd_file.put_line
1365: (which => fnd_file.log
1366: ,buff => ' ------------------- ------------- '
1367: );
1368: l_header := 1;

Line 1365: (which => fnd_file.log

1361: (which => fnd_file.log
1362: ,buff => ' GRE Name Total number '
1363: );
1364: fnd_file.put_line
1365: (which => fnd_file.log
1366: ,buff => ' ------------------- ------------- '
1367: );
1368: l_header := 1;
1369: end if;

Line 1370: fnd_file.put_line

1366: ,buff => ' ------------------- ------------- '
1367: );
1368: l_header := 1;
1369: end if;
1370: fnd_file.put_line
1371: (which => fnd_file.log
1372: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1373: );
1374: fnd_file.put_line

Line 1371: (which => fnd_file.log

1367: );
1368: l_header := 1;
1369: end if;
1370: fnd_file.put_line
1371: (which => fnd_file.log
1372: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1373: );
1374: fnd_file.put_line
1375: (which => fnd_file.log

Line 1374: fnd_file.put_line

1370: fnd_file.put_line
1371: (which => fnd_file.log
1372: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1373: );
1374: fnd_file.put_line
1375: (which => fnd_file.log
1376: ,buff => ' '
1377: );
1378: else

Line 1375: (which => fnd_file.log

1371: (which => fnd_file.log
1372: ,buff => ' ' || rpad(l_gre_name,20,' ') || ' ' || to_char(l_gre_count)
1373: );
1374: fnd_file.put_line
1375: (which => fnd_file.log
1376: ,buff => ' '
1377: );
1378: else
1379: hr_utility.set_location(l_proc,60);

Line 1413: fnd_file.put_line

1409:
1410: hr_utility.set_location(l_proc,70);
1411:
1412: if l_header = 0 then
1413: fnd_file.put_line
1414: (which => fnd_file.log
1415: ,buff => ' '
1416: );
1417: fnd_file.put_line

Line 1414: (which => fnd_file.log

1410: hr_utility.set_location(l_proc,70);
1411:
1412: if l_header = 0 then
1413: fnd_file.put_line
1414: (which => fnd_file.log
1415: ,buff => ' '
1416: );
1417: fnd_file.put_line
1418: (which => fnd_file.log

Line 1417: fnd_file.put_line

1413: fnd_file.put_line
1414: (which => fnd_file.log
1415: ,buff => ' '
1416: );
1417: fnd_file.put_line
1418: (which => fnd_file.log
1419: ,buff => ' EVS Report Summary '
1420: );
1421: fnd_file.put_line

Line 1418: (which => fnd_file.log

1414: (which => fnd_file.log
1415: ,buff => ' '
1416: );
1417: fnd_file.put_line
1418: (which => fnd_file.log
1419: ,buff => ' EVS Report Summary '
1420: );
1421: fnd_file.put_line
1422: (which => fnd_file.log

Line 1421: fnd_file.put_line

1417: fnd_file.put_line
1418: (which => fnd_file.log
1419: ,buff => ' EVS Report Summary '
1420: );
1421: fnd_file.put_line
1422: (which => fnd_file.log
1423: ,buff => ' '
1424: );
1425: fnd_file.put_line

Line 1422: (which => fnd_file.log

1418: (which => fnd_file.log
1419: ,buff => ' EVS Report Summary '
1420: );
1421: fnd_file.put_line
1422: (which => fnd_file.log
1423: ,buff => ' '
1424: );
1425: fnd_file.put_line
1426: (which => fnd_file.log

Line 1425: fnd_file.put_line

1421: fnd_file.put_line
1422: (which => fnd_file.log
1423: ,buff => ' '
1424: );
1425: fnd_file.put_line
1426: (which => fnd_file.log
1427: ,buff => ' GRE Name Total number '
1428: );
1429: fnd_file.put_line

Line 1426: (which => fnd_file.log

1422: (which => fnd_file.log
1423: ,buff => ' '
1424: );
1425: fnd_file.put_line
1426: (which => fnd_file.log
1427: ,buff => ' GRE Name Total number '
1428: );
1429: fnd_file.put_line
1430: (which => fnd_file.log

Line 1429: fnd_file.put_line

1425: fnd_file.put_line
1426: (which => fnd_file.log
1427: ,buff => ' GRE Name Total number '
1428: );
1429: fnd_file.put_line
1430: (which => fnd_file.log
1431: ,buff => ' ------------------- ------------- '
1432: );
1433: l_header := 1;

Line 1430: (which => fnd_file.log

1426: (which => fnd_file.log
1427: ,buff => ' GRE Name Total number '
1428: );
1429: fnd_file.put_line
1430: (which => fnd_file.log
1431: ,buff => ' ------------------- ------------- '
1432: );
1433: l_header := 1;
1434: end if;

Line 1436: fnd_file.put_line

1432: );
1433: l_header := 1;
1434: end if;
1435: hr_utility.set_location(l_proc,71);
1436: fnd_file.put_line
1437: (which => fnd_file.log
1438: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1439: ' ' || to_char(l_gre_count)
1440: );

Line 1437: (which => fnd_file.log

1433: l_header := 1;
1434: end if;
1435: hr_utility.set_location(l_proc,71);
1436: fnd_file.put_line
1437: (which => fnd_file.log
1438: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1439: ' ' || to_char(l_gre_count)
1440: );
1441: l_all_count := l_all_count + l_gre_count;

Line 1444: fnd_file.put_line

1440: );
1441: l_all_count := l_all_count + l_gre_count;
1442: END LOOP;
1443: hr_utility.set_location(l_proc,72);
1444: fnd_file.put_line
1445: (which => fnd_file.log
1446: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1447: ' ' || to_char(l_all_count)
1448: );

Line 1445: (which => fnd_file.log

1441: l_all_count := l_all_count + l_gre_count;
1442: END LOOP;
1443: hr_utility.set_location(l_proc,72);
1444: fnd_file.put_line
1445: (which => fnd_file.log
1446: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1447: ' ' || to_char(l_all_count)
1448: );
1449: fnd_file.put_line

Line 1449: fnd_file.put_line

1445: (which => fnd_file.log
1446: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1447: ' ' || to_char(l_all_count)
1448: );
1449: fnd_file.put_line
1450: (which => fnd_file.log
1451: ,buff => ' '
1452: );
1453: -- utl_file.fclose(g_file_id); -- 08-JUL-2005

Line 1450: (which => fnd_file.log

1446: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1447: ' ' || to_char(l_all_count)
1448: );
1449: fnd_file.put_line
1450: (which => fnd_file.log
1451: ,buff => ' '
1452: );
1453: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1454: hr_utility.set_location(l_proc,74);

Line 1461: fnd_file.put_line(fnd_file.log,SQLERRM);

1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
1461: fnd_file.put_line(fnd_file.log,SQLERRM);
1462: RAISE;
1463:
1464: end evs_mag_report_main;
1465: