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.FTE_BULK_DTT_PKG dependencies on FND_FILE

Line 218: Fnd_File.Put_Line(Fnd_File.Log, 'Unexpected Error in Procedure BULK_LOAD_DTT' || sqlerrm);

214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: l_error_text := sqlerrm;
218: Fnd_File.Put_Line(Fnd_File.Log, 'Unexpected Error in Procedure BULK_LOAD_DTT' || sqlerrm);
219:
220: --
221: -- Debug Statements
222: --

Line 294: FND_FILE.PUT_LINE(FND_FILE.log, 'LOAD_DTT_FILE');

290:
291:
292: BEGIN
293:
294: FND_FILE.PUT_LINE(FND_FILE.log, 'LOAD_DTT_FILE');
295:
296: x_status := -1;
297: g_user_debug := p_user_debug;
298: g_first_time := FIRST_TIME;

Line 345: FND_FILE.PUT_LINE(FND_FILE.log, 'Calling READ_DTT_FILE');

341: WSH_DEBUG_SV.logmsg(l_module_name,'This is the first time calling FTE_BULK_DTT_PKG.READ_DTT_FILE');
342: WSH_DEBUG_SV.logmsg(l_module_name,'with parameters: p_src_filedir,p_src_filename,p_load_id');
343: END IF;
344:
345: FND_FILE.PUT_LINE(FND_FILE.log, 'Calling READ_DTT_FILE');
346:
347: FTE_BULK_DTT_PKG.READ_DTT_FILE(p_src_filedir,
348: p_src_filename,
349: p_load_id,

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, '*ERROR '||l_error_text);

398:
399: EXCEPTION
400: WHEN OTHERS THEN
401: l_error_text := SQLERRM;
402: FND_FILE.PUT_LINE(FND_FILE.LOG, '*****ERROR**** '||l_error_text);
403: p_retcode := 2;
404: p_errbuf := p_errbuf || sqlerrm;
405:
406: --

Line 784: FND_FILE.PUT_LINE(FND_FILE.log, 'READ_DTT_FILE');

780: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
781: END IF;
782:
783:
784: FND_FILE.PUT_LINE(FND_FILE.log, 'READ_DTT_FILE');
785:
786: --
787: -- Set the date variable
788: --

Line 827: FND_FILE.PUT_LINE(FND_FILE.log, 'Removing File Extension from file');

823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'Take off the file extension');
825: END IF;
826:
827: FND_FILE.PUT_LINE(FND_FILE.log, 'Removing File Extension from file');
828:
829: l_dtt_file_name := substr(p_source_file_name,1,(instr(p_source_file_name,'.')-1));
830:
831: --

Line 853: FND_FILE.PUT_LINE(FND_FILE.log, 'Retrieving the download file id');

849: RETURN;
850: END IF;
851:
852:
853: FND_FILE.PUT_LINE(FND_FILE.log, 'Retrieving the download file id');
854: --
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.log(l_module_name,'Get the download file id open cursor c_get_file_info l_dtt_file_name = ',l_dtt_file_name);
857: END IF;

Line 1200: FND_FILE.PUT_LINE(FND_FILE.log, 'Retrieving the download lines '||l_download_file_id);

1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.log(l_module_name,'Get the download lines OPEN c_get_download_lines, l_download_file_id = ',l_download_file_id);
1198: END IF;
1199:
1200: FND_FILE.PUT_LINE(FND_FILE.log, 'Retrieving the download lines '||l_download_file_id);
1201: --
1202: -- Get the download lines
1203: --
1204: OPEN c_get_download_lines(l_download_file_id);

Line 1243: FND_FILE.PUT_LINE(FND_FILE.log, 'Number of lines in table = '||to_char(l_number_of_table_lines));

1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.log(l_module_name,'l_number_of_table_lines = ',l_number_of_table_lines);
1241: END IF;
1242:
1243: FND_FILE.PUT_LINE(FND_FILE.log, 'Number of lines in table = '||to_char(l_number_of_table_lines));
1244:
1245:
1246:
1247: --

Line 1250: FND_FILE.PUT_LINE(FND_FILE.log, 'READING FILE ' || p_source_file_directory || '/' || p_source_file_name);

1246:
1247: --
1248: -- Lets read the file
1249: --
1250: FND_FILE.PUT_LINE(FND_FILE.log, 'READING FILE ' || p_source_file_directory || '/' || p_source_file_name);
1251:
1252:
1253: --
1254: -- The file is read in a separate plsql block as when it is finished

Line 1336: FND_FILE.PUT_LINE(FND_FILE.log, 'File Line #'||to_char(l_line_ctr)||': '||l_line);

1332: -- Increment the line counter
1333: --
1334: l_line_ctr := l_line_ctr + 1;
1335:
1336: FND_FILE.PUT_LINE(FND_FILE.log, 'File Line #'||to_char(l_line_ctr)||': '||l_line);
1337:
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.logmsg(l_module_name,'File Line #'||to_char(l_line_ctr)||': '||l_line);
1340: END IF;

Line 1360: FND_FILE.PUT_LINE(FND_FILE.log, 'Converting distance value to a number');

1356: IF l_debug_on THEN
1357: WSH_DEBUG_SV.logmsg(l_module_name,'Converting distance value to a number');
1358: END IF;
1359:
1360: FND_FILE.PUT_LINE(FND_FILE.log, 'Converting distance value to a number');
1361: --
1362: -- Convert the value to a number
1363: --
1364: IF (l_ret_dist_val is not null) THEN

Line 1521: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting 250 records into temp table');

1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'we are going to insert 250 at a time into the global temp table insert into fte_distance_loader_tmp');
1519: END IF;
1520: --
1521: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting 250 records into temp table');
1522: --
1523: -- we are going to insert 250 at a time into the global
1524: -- temp table
1525: --

Line 1614: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TIME FORMAT. '||x_return_message);

1610: END IF;
1611: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TIME_FORMAT');
1612: x_return_status := 2;
1613: x_return_message := FND_MESSAGE.GET;
1614: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TIME FORMAT. '||x_return_message);
1615:
1616: --
1617: -- Close the cursors
1618: --

Line 1674: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV LINE LENGTH. '||x_return_message);

1670: END IF;
1671: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_LINE_LENGTH');
1672: x_return_status := 2;
1673: x_return_message := FND_MESSAGE.GET;
1674: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV LINE LENGTH. '||x_return_message);
1675:
1676: --
1677: -- Close the cursors
1678: --

Line 1736: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished Reading File.');

1732: IF l_debug_on THEN
1733: WSH_DEBUG_SV.logmsg(l_module_name,'Finished reading file');
1734: END IF;
1735:
1736: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished Reading File.');
1737: x_return_status := -1;
1738:
1739:
1740: WHEN UTL_FILE.INVALID_PATH THEN

Line 1749: fnd_file.put_line(FND_FILE.log, x_return_message);

1745: utl_file.fclose(l_dtt_file);
1746: END IF;
1747: x_return_message := 'FILE ' || p_source_file_directory || '/' || p_source_file_name || ' NOT ACCESSIBLE';
1748: x_return_message := x_return_message||' Also please make sure that the directory is accessible to UTL_FILE.';
1749: fnd_file.put_line(FND_FILE.log, x_return_message);
1750: x_return_status := 2;
1751: --
1752: --
1753: -- Close the cursors

Line 1804: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE.'||sqlerrm);

1800: IF (utl_file.is_open(l_dtt_file)) THEN
1801: utl_file.fclose(l_dtt_file);
1802: END IF;
1803:
1804: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE.'||sqlerrm);
1805: FND_FILE.PUT_LINE(FND_FILE.log, 'OFFENDING_LINE: ' || l_line);
1806: FND_FILE.PUT_LINE(FND_FILE.Log, sqlerrm);
1807: x_return_status := 2;
1808: x_return_message := ('UNEXPECTED ERROR IN PROCEDURE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||sqlerrm);

Line 1805: FND_FILE.PUT_LINE(FND_FILE.log, 'OFFENDING_LINE: ' || l_line);

1801: utl_file.fclose(l_dtt_file);
1802: END IF;
1803:
1804: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE.'||sqlerrm);
1805: FND_FILE.PUT_LINE(FND_FILE.log, 'OFFENDING_LINE: ' || l_line);
1806: FND_FILE.PUT_LINE(FND_FILE.Log, sqlerrm);
1807: x_return_status := 2;
1808: x_return_message := ('UNEXPECTED ERROR IN PROCEDURE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||sqlerrm);
1809:

Line 1806: FND_FILE.PUT_LINE(FND_FILE.Log, sqlerrm);

1802: END IF;
1803:
1804: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE.'||sqlerrm);
1805: FND_FILE.PUT_LINE(FND_FILE.log, 'OFFENDING_LINE: ' || l_line);
1806: FND_FILE.PUT_LINE(FND_FILE.Log, sqlerrm);
1807: x_return_status := 2;
1808: x_return_message := ('UNEXPECTED ERROR IN PROCEDURE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||sqlerrm);
1809:
1810: --

Line 1872: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting remainder of records into temp table');

1868: IF l_debug_on THEN
1869: WSH_DEBUG_SV.logmsg(l_module_name,'insert the last few lines that did not sum upto 250 into the Global temp table');
1870: END IF;
1871:
1872: FND_FILE.PUT_LINE(FND_FILE.log, 'Inserting remainder of records into temp table');
1873:
1874: FORALL i in l_location_origin_id.FIRST..l_location_origin_id.LAST
1875: insert into fte_distance_loader_tmp(ORIGIN_ID,
1876: DESTINATION_ID,

Line 1940: FND_FILE.PUT_LINE(FND_FILE.log, 'Number of lines in the table matched the number of lines in the file, inserting and/or updating into the location mileages table');

1936: -- Only insert all records if the number of lines in the file mathes the number of lines in the table
1937: --
1938: IF (l_number_of_table_lines = l_line_ctr) THEN
1939:
1940: FND_FILE.PUT_LINE(FND_FILE.log, 'Number of lines in the table matched the number of lines in the file, inserting and/or updating into the location mileages table');
1941:
1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.logmsg(l_module_name,'Number of lines in the table matched the number of lines in the file, inserting and/or updating into the location mileages table');
1944: END IF;

Line 2034: FND_FILE.PUT_LINE(FND_FILE.log,'Clean up the query collections');

2030: --
2031: -- New code to replace the MERGE statement above for 8i compatibility
2032: --
2033: --
2034: FND_FILE.PUT_LINE(FND_FILE.log,'Clean up the query collections');
2035: --
2036: IF l_debug_on THEN
2037: WSH_DEBUG_SV.logmsg(l_module_name,'Clean up the query collections');
2038: END IF;

Line 2067: FND_FILE.PUT_LINE(FND_FILE.log,'Open the cursor, c_get_merge_data, to get the records to update and/or insert');

2063: -- Set the previous rows counter to zero
2064: --
2065: l_previous_rows := 0;
2066:
2067: FND_FILE.PUT_LINE(FND_FILE.log,'Open the cursor, c_get_merge_data, to get the records to update and/or insert');
2068: --
2069: IF l_debug_on THEN
2070: WSH_DEBUG_SV.logmsg(l_module_name,'Open the cursor, c_get_merge_data, to get the records to update and/or insert');
2071: END IF;

Line 2111: FND_FILE.PUT_LINE(FND_FILE.log,'There are no rows left from the cursor - exit the loop');

2107:
2108:
2109: IF (l_remaining_rows <= 0) then
2110:
2111: FND_FILE.PUT_LINE(FND_FILE.log,'There are no rows left from the cursor - exit the loop');
2112: --
2113: IF l_debug_on THEN
2114: WSH_DEBUG_SV.logmsg(l_module_name,'There are no rows left from the cursor - exit the loop');
2115: END IF;

Line 2135: FND_FILE.PUT_LINE(FND_FILE.log,'cleaning the temp update tables');

2131: -- We have records to insert or update
2132: -- Clean out the Update anbd insert plsql collections
2133: --
2134:
2135: FND_FILE.PUT_LINE(FND_FILE.log,'cleaning the temp update tables');
2136: --
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.logmsg(l_module_name,'cleaning the temp update tables');
2139: END IF;

Line 2157: FND_FILE.PUT_LINE(FND_FILE.log,'cleaning the temp insert tables');

2153: l_u_program_update_date_tab.DELETE;
2154: l_u_request_id_tab.DELETE;
2155:
2156:
2157: FND_FILE.PUT_LINE(FND_FILE.log,'cleaning the temp insert tables');
2158: --
2159: IF l_debug_on THEN
2160: WSH_DEBUG_SV.logmsg(l_module_name,'cleaning the temp insert tables');
2161: END IF;

Line 2194: FND_FILE.PUT_LINE(FND_FILE.log, 'checking for insert and update records');

2190: --
2191: -- Loop through the query return and see which records need
2192: -- to be updated or inserted
2193: --
2194: FND_FILE.PUT_LINE(FND_FILE.log, 'checking for insert and update records');
2195: --
2196: IF l_debug_on THEN
2197: WSH_DEBUG_SV.logmsg(l_module_name,'checking for insert and update records');
2198: END IF;

Line 2203: FND_FILE.PUT_LINE(FND_FILE.log, 'getting insert records');

2199:
2200: IF ((l_old_origin_id_tab(kk) is null) AND
2201: (l_old_destination_id_tab(kk) is null)) THEN
2202:
2203: FND_FILE.PUT_LINE(FND_FILE.log, 'getting insert records');
2204: --
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.logmsg(l_module_name,'getting insert records');
2207: END IF;

Line 2238: FND_FILE.PUT_LINE(FND_FILE.log, 'getting update records');

2234:
2235: ELSIF ((l_old_origin_id_tab(kk) is not null) AND
2236: (l_old_destination_id_tab(kk) is not null)) THEN
2237:
2238: FND_FILE.PUT_LINE(FND_FILE.log, 'getting update records');
2239: --
2240: IF l_debug_on THEN
2241: WSH_DEBUG_SV.logmsg(l_module_name,'getting update records');
2242: END IF;

Line 2290: FND_FILE.PUT_LINE(FND_FILE.log, 'Bulk update of mileage records');

2286: -- Do the update if any
2287: --
2288: IF (l_u_origin_id_tab.COUNT > 0) THEN
2289:
2290: FND_FILE.PUT_LINE(FND_FILE.log, 'Bulk update of mileage records');
2291: --
2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'Bulk update of mileage records');
2294: END IF;

Line 2323: FND_FILE.PUT_LINE(FND_FILE.log, 'Bulk insert of mileage records');

2319: -- now do the insert
2320: --
2321: IF (l_i_origin_id_tab.COUNT > 0) THEN
2322:
2323: FND_FILE.PUT_LINE(FND_FILE.log, 'Bulk insert of mileage records');
2324: --
2325: IF l_debug_on THEN
2326: WSH_DEBUG_SV.logmsg(l_module_name,'Bulk insert of mileage records');
2327: END IF;

Line 2384: FND_FILE.PUT_LINE(FND_FILE.log, 'Updating the Download files table with upload information');

2380: -- [ABLUNDEL][12/08/2003][BUG# 3301222] End of Code Changes for bug
2381: -- ---------------------------------------------------------------------
2382:
2383:
2384: FND_FILE.PUT_LINE(FND_FILE.log, 'Updating the Download files table with upload information');
2385: --
2386: IF l_debug_on THEN
2387: WSH_DEBUG_SV.logmsg(l_module_name,'Updating the Download files table with upload information');
2388: END IF;

Line 2404: FND_FILE.PUT_LINE(FND_FILE.log, 'Deleting data from the Download lines table');

2400: --
2401: commit;
2402:
2403:
2404: FND_FILE.PUT_LINE(FND_FILE.log, 'Deleting data from the Download lines table');
2405: --
2406: IF l_debug_on THEN
2407: WSH_DEBUG_SV.logmsg(l_module_name,'Deleting data from the Download lines table');
2408: END IF;

Line 2420: FND_FILE.PUT_LINE(FND_FILE.log, 'Returning with success');

2416:
2417: commit;
2418:
2419:
2420: FND_FILE.PUT_LINE(FND_FILE.log, 'Returning with success');
2421:
2422: --
2423: IF l_debug_on THEN
2424: WSH_DEBUG_SV.logmsg(l_module_name,'Returning with success');

Line 2481: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP TIME UOM. '||x_return_message);

2477: WHEN FTE_DIST_INV_TEMP_TIME_UOM THEN
2478: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_TIME_UOM');
2479: x_return_status := 2;
2480: x_return_message := FND_MESSAGE.GET;
2481: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP TIME UOM. '||x_return_message);
2482: --
2483: -- Close the file
2484: --
2485: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2541: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO TIME UOM. '||x_return_message);

2537: WHEN FTE_DIST_NO_TIME_UOM THEN
2538: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_TIME_UOM');
2539: x_return_status := 2;
2540: x_return_message := FND_MESSAGE.GET;
2541: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO TIME UOM. '||x_return_message);
2542: --
2543: -- Close the file
2544: --
2545: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2601: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP DIST UOM. '||x_return_message);

2597: WHEN FTE_DIST_INV_TEMP_DIST_UOM THEN
2598: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_TEMP_DIST_UOM');
2599: x_return_status := 2;
2600: x_return_message := FND_MESSAGE.GET;
2601: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INV TEMP DIST UOM. '||x_return_message);
2602: --
2603: -- Close the file
2604: --
2605: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2662: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DISTANCE UOM. '||x_return_message);

2658: WHEN FTE_DIST_NO_DISTANCE_UOM THEN
2659: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DISTANCE_UOM');
2660: x_return_status := 2;
2661: x_return_message := FND_MESSAGE.GET;
2662: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DISTANCE UOM. '||x_return_message);
2663: --
2664: -- Close the file
2665: --
2666: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2723: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - ORIG DEST LOAD ERR. '||x_return_message);

2719: WHEN FTE_DIST_ORIG_DEST_LOAD_ERR THEN
2720: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_ORIG_DEST_LOAD_ERR');
2721: x_return_status := 2;
2722: x_return_message := FND_MESSAGE.GET;
2723: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - ORIG DEST LOAD ERR. '||x_return_message);
2724: --
2725: -- Close the file
2726: --
2727: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2784: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - LESS FILE LINES. '||x_return_message);

2780: WHEN FTE_DIST_LESS_FILE_LINES THEN
2781: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_LESS_FILE_LINES');
2782: x_return_status := 2;
2783: x_return_message := FND_MESSAGE.GET;
2784: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - LESS FILE LINES. '||x_return_message);
2785: --
2786: -- Close the file
2787: --
2788: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2844: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - TOO MANY FILE LINES. '||x_return_message);

2840: WHEN FTE_DIST_MANY_FILE_LINES THEN
2841: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_FILE_LINES');
2842: x_return_status := 2;
2843: x_return_message := FND_MESSAGE.GET;
2844: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - TOO MANY FILE LINES. '||x_return_message);
2845: --
2846: -- Close the file
2847: --
2848: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2905: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NULL FILE NAME. '||x_return_message);

2901: WHEN FTE_DIST_NULL_FILE_NAME THEN
2902: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_FILE_NAME');
2903: x_return_status := 2;
2904: x_return_message := FND_MESSAGE.GET;
2905: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NULL FILE NAME. '||x_return_message);
2906: --
2907: -- Close the file
2908: --
2909: IF (utl_file.is_open(l_dtt_file)) THEN

Line 2966: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INVALID FILE LENGTH. '||x_return_message);

2962: WHEN FTE_DIST_INV_FILENAME_LGTH THEN
2963: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');
2964: x_return_status := 2;
2965: x_return_message := FND_MESSAGE.GET;
2966: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - INVALID FILE LENGTH. '||x_return_message);
2967: --
2968: -- Close the file
2969: --
2970: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3025: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD. '||x_return_message);

3021: WHEN FTE_DIST_NO_FILE_DOWNLOAD THEN
3022: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD');
3023: x_return_status := 2;
3024: x_return_message := FND_MESSAGE.GET;
3025: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD. '||x_return_message);
3026: --
3027: -- Close the file
3028: --
3029: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3084: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE TEMPLATE. '||x_return_message);

3080: WHEN FTE_DIST_NO_FILE_TEMPLATE THEN
3081: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_TEMPLATE');
3082: x_return_status := 2;
3083: x_return_message := FND_MESSAGE.GET;
3084: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE TEMPLATE. '||x_return_message);
3085: --
3086: -- Close the file
3087: --
3088: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3143: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD_DATE. '||x_return_message);

3139: WHEN FTE_DIST_NO_FILE_DOWNLOAD_DATE THEN
3140: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_DOWNLOAD_DATE');
3141: x_return_status := 2;
3142: x_return_message := FND_MESSAGE.GET;
3143: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO FILE DOWNLOAD_DATE. '||x_return_message);
3144: --
3145: -- Close the file
3146: --
3147: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3201: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - PREVIOUS FILE UPLOAD EXISTS. '||x_return_message);

3197: WHEN FTE_DIST_FILE_UPLOAD_DONE_PREV THEN
3198: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_FILE_UPLOAD_DONE_PREV');
3199: x_return_status := 2;
3200: x_return_message := FND_MESSAGE.GET;
3201: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - PREVIOUS FILE UPLOAD EXISTS. '||x_return_message);
3202: --
3203: -- Close the file
3204: --
3205: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3259: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DOWNLOAD LINES. '||x_return_message);

3255: WHEN FTE_DIST_NO_DOWNLOAD_LINES THEN
3256: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DOWNLOAD_LINES');
3257: x_return_status := 2;
3258: x_return_message := FND_MESSAGE.GET;
3259: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO DOWNLOAD LINES. '||x_return_message);
3260: --
3261: -- Close the file
3262: --
3263: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3317: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN DISTANCE COLUMN DATA. '||x_return_message);

3313: WHEN FTE_DIST_RET_DIST_COL_NO_DATA THEN
3314: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_COL_NO_DATA');
3315: x_return_status := 2;
3316: x_return_message := FND_MESSAGE.GET;
3317: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN DISTANCE COLUMN DATA. '||x_return_message);
3318: --
3319: -- Close the file
3320: --
3321: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3374: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN TIME COLUMN DATA. '||x_return_message);

3370: WHEN FTE_DIST_RET_TIME_COL_NO_DATA THEN
3371: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_COL_NO_DATA');
3372: x_return_status := 2;
3373: x_return_message := FND_MESSAGE.GET;
3374: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN TIME COLUMN DATA. '||x_return_message);
3375: --
3376: -- Close the file
3377: --
3378: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3432: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN COLUMNS ENABLED. '||x_return_message);

3428: WHEN FTE_DIST_NO_RET_COL_ENABLED THEN
3429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COL_ENABLED');
3430: x_return_status := 2;
3431: x_return_message := FND_MESSAGE.GET;
3432: FND_FILE.PUT_LINE(FND_FILE.log, 'ERROR IN PROCEDURE READ_DTT_FILE - NO RETURN COLUMNS ENABLED. '||x_return_message);
3433: --
3434: -- Close the file
3435: --
3436: IF (utl_file.is_open(l_dtt_file)) THEN

Line 3488: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE. '|| sqlerrm);

3484:
3485: WHEN OTHERS THEN
3486: x_return_status := 2;
3487: x_return_message := sqlerrm;
3488: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE. '|| sqlerrm);
3489:
3490: --
3491: -- Debug Statements
3492: --

Line 3565: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME');

3561: WSH_DEBUG_SV.logmsg(l_module_name,'---------------FIRST_TIME------------');
3562: END IF;
3563:
3564:
3565: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME');
3566:
3567: req_data := FND_CONC_GLOBAL.request_data;
3568:
3569: IF (req_data IS NULL) THEN

Line 3570: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME returning TRUE');

3566:
3567: req_data := FND_CONC_GLOBAL.request_data;
3568:
3569: IF (req_data IS NULL) THEN
3570: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME returning TRUE');
3571: --
3572: IF l_debug_on THEN
3573: WSH_DEBUG_SV.pop(l_module_name);
3574: END IF;

Line 3578: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME returning FALSE');

3574: END IF;
3575: --
3576: RETURN TRUE;
3577: ELSE
3578: FND_FILE.PUT_LINE(FND_FILE.log, 'FIRST_TIME returning FALSE');
3579: --
3580: IF l_debug_on THEN
3581: WSH_DEBUG_SV.pop(l_module_name);
3582: END IF;

Line 3590: Fnd_File.Put_Line(Fnd_File.Log, 'Unexpected Error in Procedure FIRST_TIME' || sqlerrm);

3586:
3587:
3588: EXCEPTION
3589: WHEN OTHERS THEN
3590: Fnd_File.Put_Line(Fnd_File.Log, 'Unexpected Error in Procedure FIRST_TIME' || sqlerrm);
3591:
3592: --
3593: -- Debug Statements
3594: --