249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001 ) THEN
253: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
256: END IF;
257:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001 ) THEN
253: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
256: END IF;
257:
258: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001 ) THEN
253: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
256: END IF;
257:
258: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,
406:
407: EXCEPTION
408: WHEN OTHERS THEN
409: IF (SQLCODE <> -20001 ) THEN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
413: END IF;
414:
407: EXCEPTION
408: WHEN OTHERS THEN
409: IF (SQLCODE <> -20001 ) THEN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
413: END IF;
414:
415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
408: WHEN OTHERS THEN
409: IF (SQLCODE <> -20001 ) THEN
410: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
411: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
413: END IF;
414:
415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,