DBA Data[Home] [Help]

APPS.QP_DATA_COMPARE_PVT dependencies on FND_FILE

Line 82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

78: BEGIN
79: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'w');
80: EXCEPTION
81: WHEN UTL_FILE.INVALID_PATH THEN
82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
84: RETURN;
85: END;
86:

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

79: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'w');
80: EXCEPTION
81: WHEN UTL_FILE.INVALID_PATH THEN
82: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
84: RETURN;
85: END;
86:
87: utl_file.put(l_file,'LIST_HEADERS');

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

288: BEGIN
289: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
290: EXCEPTION
291: WHEN UTL_FILE.INVALID_PATH THEN
292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
294: RETURN;
295: END;
296:

Line 293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

289: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
290: EXCEPTION
291: WHEN UTL_FILE.INVALID_PATH THEN
292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
294: RETURN;
295: END;
296:
297: utl_file.new_line(l_file);

Line 557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

553: BEGIN
554: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
555: EXCEPTION
556: WHEN UTL_FILE.INVALID_PATH THEN
557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
559: RETURN;
560: END;
561:

Line 558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

554: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
555: EXCEPTION
556: WHEN UTL_FILE.INVALID_PATH THEN
557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
559: RETURN;
560: END;
561:
562: utl_file.new_line(l_file);

Line 818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

814: BEGIN
815: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
816: EXCEPTION
817: WHEN UTL_FILE.INVALID_PATH THEN
818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
820: RETURN;
821: END;
822:

Line 819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

815: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
816: EXCEPTION
817: WHEN UTL_FILE.INVALID_PATH THEN
818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
820: RETURN;
821: END;
822:
823: utl_file.new_line(l_file);

Line 973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

969: BEGIN
970: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
971: EXCEPTION
972: WHEN UTL_FILE.INVALID_PATH THEN
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
975: RETURN;
976: END;
977:

Line 974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

970: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
971: EXCEPTION
972: WHEN UTL_FILE.INVALID_PATH THEN
973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
975: RETURN;
976: END;
977:
978: utl_file.new_line(l_file);

Line 1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1066: BEGIN
1067: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1068: EXCEPTION
1069: WHEN UTL_FILE.INVALID_PATH THEN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1072: RETURN;
1073: END;
1074:

Line 1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1067: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1068: EXCEPTION
1069: WHEN UTL_FILE.INVALID_PATH THEN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1072: RETURN;
1073: END;
1074:
1075: utl_file.new_line(l_file);

Line 1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1172: BEGIN
1173: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'w');
1174: EXCEPTION
1175: WHEN UTL_FILE.INVALID_PATH THEN
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1178: RETURN;
1179: END;
1180:

Line 1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1173: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'w');
1174: EXCEPTION
1175: WHEN UTL_FILE.INVALID_PATH THEN
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1178: RETURN;
1179: END;
1180:
1181: utl_file.new_line(l_file);

Line 1262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1258: BEGIN
1259: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1260: EXCEPTION
1261: WHEN UTL_FILE.INVALID_PATH THEN
1262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1264: RETURN;
1265: END;
1266:

Line 1263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1259: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1260: EXCEPTION
1261: WHEN UTL_FILE.INVALID_PATH THEN
1262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1264: RETURN;
1265: END;
1266:
1267: OPEN csr_get_pricing_phase_id(p_list_line_id);

Line 1355: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1351: BEGIN
1352: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1353: EXCEPTION
1354: WHEN UTL_FILE.INVALID_PATH THEN
1355: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1357: RETURN;
1358: END;
1359:

Line 1356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1352: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1353: EXCEPTION
1354: WHEN UTL_FILE.INVALID_PATH THEN
1355: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1357: RETURN;
1358: END;
1359:
1360: utl_file.new_line(l_file);

Line 1496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1492: BEGIN
1493: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1494: EXCEPTION
1495: WHEN UTL_FILE.INVALID_PATH THEN
1496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1498: RETURN;
1499: END;
1500:

Line 1497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1493: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1494: EXCEPTION
1495: WHEN UTL_FILE.INVALID_PATH THEN
1496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1498: RETURN;
1499: END;
1500:
1501: IF (p_pattern_type = 'PRODUCT') THEN

Line 1692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1688: BEGIN
1689: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1690: EXCEPTION
1691: WHEN UTL_FILE.INVALID_PATH THEN
1692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1694: RETURN;
1695: END;
1696:

Line 1693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1689: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1690: EXCEPTION
1691: WHEN UTL_FILE.INVALID_PATH THEN
1692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1694: RETURN;
1695: END;
1696:
1697: IF (p_pattern_type = 'PRODUCT') THEN

Line 1889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');

1885: BEGIN
1886: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1887: EXCEPTION
1888: WHEN UTL_FILE.INVALID_PATH THEN
1889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1890: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1891: RETURN;
1892: END;
1893:

Line 1890: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

1886: l_file := UTL_FILE.fopen(p_file_dir, l_filename, 'a');
1887: EXCEPTION
1888: WHEN UTL_FILE.INVALID_PATH THEN
1889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Log directory, '||p_file_dir||' is not accessible');
1890: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');
1891: RETURN;
1892: END;
1893:
1894: OPEN csr_get_profile_value('QP_HVOP_PRICING_SETUP');