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