176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF (SQLCODE <> -20001) THEN
180: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
181: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
182: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
183: FND_MESSAGE.SET_TOKEN('PARAMETERS','bank_collection_id = ' ||
184: X_bank_collection_id);
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF (SQLCODE <> -20001) THEN
180: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
181: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
182: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
183: FND_MESSAGE.SET_TOKEN('PARAMETERS','bank_collection_id = ' ||
184: X_bank_collection_id);
185: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
178: WHEN OTHERS THEN
179: IF (SQLCODE <> -20001) THEN
180: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
181: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
182: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
183: FND_MESSAGE.SET_TOKEN('PARAMETERS','bank_collection_id = ' ||
184: X_bank_collection_id);
185: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
186: END IF;
179: IF (SQLCODE <> -20001) THEN
180: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
181: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
182: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
183: FND_MESSAGE.SET_TOKEN('PARAMETERS','bank_collection_id = ' ||
184: X_bank_collection_id);
185: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
186: END IF;
187: APP_EXCEPTION.RAISE_EXCEPTION;
181: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
182: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
183: FND_MESSAGE.SET_TOKEN('PARAMETERS','bank_collection_id = ' ||
184: X_bank_collection_id);
185: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
186: END IF;
187: APP_EXCEPTION.RAISE_EXCEPTION;
188:
189: END Update_Row;
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: IF (SQLCODE <> -20001) THEN
212: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
213: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
214: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
215: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
209: EXCEPTION
210: WHEN OTHERS THEN
211: IF (SQLCODE <> -20001) THEN
212: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
213: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
214: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
215: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
217: END IF;
210: WHEN OTHERS THEN
211: IF (SQLCODE <> -20001) THEN
212: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
213: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
214: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
215: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
217: END IF;
218: APP_EXCEPTION.RAISE_EXCEPTION;
211: IF (SQLCODE <> -20001) THEN
212: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
213: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
214: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
215: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
217: END IF;
218: APP_EXCEPTION.RAISE_EXCEPTION;
219:
212: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
213: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
214: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
215: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
217: END IF;
218: APP_EXCEPTION.RAISE_EXCEPTION;
219:
220: END Delete_Row;