223: l_temp VARCHAR2(1);
224: l_temp_id NUMBER;
225: l_encoded VARCHAR2(1) := 'F';
226: l_index NUMBER;
227: l_stop_cache wsh_util_core.id_tab_type;
228:
229: BEGIN
230: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
231:
261: IF l_debug_on THEN
262: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');
263: END IF;
264:
265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
266:
267: --Bulk fetch detail_rec_csr into record of table.
268: OPEN detail_rec_csr;
269: FETCH detail_rec_csr BULK COLLECT
362: END IF;
363:
364: EXCEPTION
365: WHEN no_data_found THEN
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'No Record found to complete interface',WSH_DEBUG_SV.C_EXCEP_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name);
370: END IF;