APPS.FTE_DIST_UTIL_PKG dependencies on FTE_DIST_UTIL_PKG

Line 1: PACKAGE BODY FTE_DIST_UTIL_PKG AS

1: PACKAGE BODY FTE_DIST_UTIL_PKG AS
2: /* $Header: FTEDISXB.pls 115.1 2003/09/13 19:46:12 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_DIST_UTIL_PKG --

Line 5: -- NAME: FTE_DIST_UTIL_PKG --

1: PACKAGE BODY FTE_DIST_UTIL_PKG AS
2: /* $Header: FTEDISXB.pls 115.1 2003/09/13 19:46:12 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_DIST_UTIL_PKG --
6: -- TYPE: PACKAGE BODY --
7: -- DESCRIPTION: Contains util procedures for mileage integration stuff --
8: -- --
9: -- --

Line 72: l_file_ids FTE_DIST_UTIL_PKG.fte_id_tmp_num_table;

68: select download_file_id
69: from fte_mile_download_files
70: where template_id = cp_template_id;
71:
72: l_file_ids FTE_DIST_UTIL_PKG.fte_id_tmp_num_table;
73:
74:
75: --
76: -- Local Debug Variable Definitions

Line 189: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT );

185: --
186: -- Debug Statements
187: --
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT );
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --

Line 194: WSH_UTIL_CORE.default_handler('FTE_DIST_UTIL_PKG.DELETE_FILES_LINES');

190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
194: WSH_UTIL_CORE.default_handler('FTE_DIST_UTIL_PKG.DELETE_FILES_LINES');
195: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
196: x_return_message := l_error_text;
197: --
198: -- Debug Statements

Line 253: END FTE_DIST_UTIL_PKG;

249: RETURN;
250:
251: END GET_DIST_PROFILE;
252:
253: END FTE_DIST_UTIL_PKG;