26: EXCEPTION
27: WHEN OTHERS THEN
28: IF (SQLCODE <> -20001) THEN
29: IF (SQLCODE = -54) THEN
30: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
31: ELSE
32: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
33: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
34: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
28: IF (SQLCODE <> -20001) THEN
29: IF (SQLCODE = -54) THEN
30: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
31: ELSE
32: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
33: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
34: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
35: l_current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS',
29: IF (SQLCODE = -54) THEN
30: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
31: ELSE
32: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
33: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
34: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
35: l_current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS',
37: 'X_FEED_LINE_ID = '||X_FEED_LINE_ID
30: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
31: ELSE
32: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
33: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
34: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
35: l_current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS',
37: 'X_FEED_LINE_ID = '||X_FEED_LINE_ID
38: ||', X_TOTAL = '||X_TOTAL
32: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
33: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
34: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
35: l_current_calling_sequence);
36: FND_MESSAGE.SET_TOKEN('PARAMETERS',
37: 'X_FEED_LINE_ID = '||X_FEED_LINE_ID
38: ||', X_TOTAL = '||X_TOTAL
39: ||', X_TOTAL_RTOT_DB = '||X_TOTAL_RTOT_DB
40: );
37: 'X_FEED_LINE_ID = '||X_FEED_LINE_ID
38: ||', X_TOTAL = '||X_TOTAL
39: ||', X_TOTAL_RTOT_DB = '||X_TOTAL_RTOT_DB
40: );
41: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
42: END IF;
43: END IF;
44: APP_EXCEPTION.RAISE_EXCEPTION;
45: