117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
122: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
123: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_fn);
124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
125: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_base_ccid: '
118: EXCEPTION
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
122: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
123: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_fn);
124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
125: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_base_ccid: '
126: ||TO_CHAR(P_base_ccid)
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
122: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
123: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_fn);
124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
125: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_base_ccid: '
126: ||TO_CHAR(P_base_ccid)
127: ||',P_coa_id: '
120: IF (SQLCODE <> -20001) THEN
121: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
122: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
123: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_fn);
124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
125: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_base_ccid: '
126: ||TO_CHAR(P_base_ccid)
127: ||',P_coa_id: '
128: ||P_coa_id );
121: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
122: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
123: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_fn);
124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
125: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_base_ccid: '
126: ||TO_CHAR(P_base_ccid)
127: ||',P_coa_id: '
128: ||P_coa_id );
129: