DBA Data[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 1130: fnd_file.put_line

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:

Line 1131: (which => fnd_file.output

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);

Line 1328: fnd_file.put_line

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

Line 1329: (which => fnd_file.log

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

Line 1332: fnd_file.put_line

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

Line 1333: (which => fnd_file.log

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

Line 1336: fnd_file.put_line

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

Line 1337: (which => fnd_file.log

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

Line 1340: fnd_file.put_line

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

Line 1341: (which => fnd_file.log

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

Line 1344: fnd_file.put_line

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;

Line 1345: (which => fnd_file.log

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;

Line 1350: fnd_file.put_line

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

Line 1351: (which => fnd_file.log

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

Line 1354: fnd_file.put_line

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

Line 1355: (which => fnd_file.log

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);

Line 1393: fnd_file.put_line

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

Line 1394: (which => fnd_file.log

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

Line 1397: fnd_file.put_line

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

Line 1398: (which => fnd_file.log

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

Line 1401: fnd_file.put_line

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

Line 1402: (which => fnd_file.log

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

Line 1405: fnd_file.put_line

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

Line 1406: (which => fnd_file.log

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

Line 1409: fnd_file.put_line

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;

Line 1410: (which => fnd_file.log

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;

Line 1416: fnd_file.put_line

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: );

Line 1417: (which => fnd_file.log

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;

Line 1424: fnd_file.put_line

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: );

Line 1425: (which => fnd_file.log

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

Line 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

Line 1430: (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
1434: hr_utility.set_location(l_proc,74);

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

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: