239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
250: ||', Key_Value1 = '||to_char(p_key_value1));
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
250: ||', Key_Value1 = '||to_char(p_key_value1));
251: END IF;
409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: IF (SQLCODE <> -20001) THEN
413: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
414: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
415: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
417: END IF;
410: EXCEPTION
411: WHEN OTHERS THEN
412: IF (SQLCODE <> -20001) THEN
413: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
414: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
415: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
411: WHEN OTHERS THEN
412: IF (SQLCODE <> -20001) THEN
413: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
414: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
415: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
419:
412: IF (SQLCODE <> -20001) THEN
413: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
414: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
415: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
416: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
419:
420: