[Home] [Help]
103:
104: IF (p_LoadType NOT IN ('LTL_ASSOC', 'DTT_DWNLD')) THEN
105: IF p_FileName IS NULL THEN
106: IF (g_debug_on) THEN
107: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'No filename supplied', WSH_DEBUG_SV.c_proc_level);
108: END IF;
109: FTE_UTIL_PKG.Exit_Debug(l_module_name);
110: RETURN 1;
111: END IF;
121: v_FileLocator := BFILENAME('UPLOAD_DIR', p_FileName);
122: v_FileExists := DBMS_LOB.FILEEXISTS(v_FileLocator);
123: IF v_FileExists <> 1 THEN
124: IF (g_debug_on) THEN
125: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'File Not Found', WSH_DEBUG_SV.c_proc_level);
126: END IF;
127: FTE_UTIL_PKG.Exit_Debug(l_module_name);
128: RETURN 1;
129: END IF;
148:
149: IF (length(l_dtt_file_name) <> 8) THEN
150: IF (g_debug_on) THEN
151: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'DTT filename supplied is invalid - invalid length',
152: WSH_DEBUG_SV.c_proc_level);
153: END IF;
154: FTE_UTIL_PKG.Exit_Debug(l_module_name);
155: RETURN 3;
156: END IF;
166: -- Upload File is invalid
167: --+
168: IF (g_debug_on) THEN
169: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'DTT filename supplied is invalid - not associated with a template',
170: WSH_DEBUG_SV.c_proc_level);
171: END IF;
172: FTE_UTIL_PKG.Exit_Debug(l_module_name);
173: RETURN 2;
174: END IF;
1244: --SETUP DEBUGGING
1245: FTE_UTIL_PKG.ENTER_Debug(l_module_name);
1246:
1247: IF (g_debug_on) THEN
1248: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Updating FTE_BUILLOAD_DATA', WSH_DEBUG_SV.c_proc_level);
1249: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'File Name', p_filename);
1250: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Load ID', p_loadid);
1251: END IF;
1252: