249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
256: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'file_control = ' ||
257: X_file_control ||
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
256: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'file_control = ' ||
257: X_file_control ||
258: ' entry_sequential_number = ' ||
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
256: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'file_control = ' ||
257: X_file_control ||
258: ' entry_sequential_number = ' ||
259: X_entry_sequential_number);
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
256: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'file_control = ' ||
257: X_file_control ||
258: ' entry_sequential_number = ' ||
259: X_entry_sequential_number);
260: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
256: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'file_control = ' ||
257: X_file_control ||
258: ' entry_sequential_number = ' ||
259: X_entry_sequential_number);
260: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
261: END IF;
262:
263: APP_EXCEPTION.RAISE_EXCEPTION;
264:
361:
362: IF (C%NOTFOUND) THEN
363: debug_info := 'Close cursor C - DATA NOTFOUND';
364: CLOSE C;
365: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
366: APP_EXCEPTION.Raise_Exception;
367: END IF;
368:
369: debug_info := 'Close cursor C';
547: AND (X_ATTRIBUTE15 IS NULL)))
548: ) THEN
549: RETURN;
550: ELSE
551: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
552: APP_EXCEPTION.Raise_Exception;
553: END IF;
554:
555: EXCEPTION
555: EXCEPTION
556: WHEN OTHERS THEN
557: IF (SQLCODE <> -20001) THEN
558: IF (SQLCODE = -54) THEN
559: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
560: ELSE
561: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
562: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
563: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
557: IF (SQLCODE <> -20001) THEN
558: IF (SQLCODE = -54) THEN
559: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
560: ELSE
561: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
562: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
563: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
564: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
565: X_file_control ||
558: IF (SQLCODE = -54) THEN
559: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
560: ELSE
561: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
562: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
563: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
564: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
565: X_file_control ||
566: ' entry_sequential_number = ' ||
559: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
560: ELSE
561: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
562: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
563: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
564: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
565: X_file_control ||
566: ' entry_sequential_number = ' ||
567: X_entry_sequential_number);
560: ELSE
561: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
562: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
563: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
564: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
565: X_file_control ||
566: ' entry_sequential_number = ' ||
567: X_entry_sequential_number);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
564: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
565: X_file_control ||
566: ' entry_sequential_number = ' ||
567: X_entry_sequential_number);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
569: END IF;
570: END IF;
571:
572: APP_EXCEPTION.RAISE_EXCEPTION;
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF (SQLCODE <> -20001) THEN
740: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
741: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
742: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
743: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
744: X_file_control ||
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF (SQLCODE <> -20001) THEN
740: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
741: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
742: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
743: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
744: X_file_control ||
745: ' entry_sequential_number = ' ||
738: WHEN OTHERS THEN
739: IF (SQLCODE <> -20001) THEN
740: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
741: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
742: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
743: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
744: X_file_control ||
745: ' entry_sequential_number = ' ||
746: X_entry_sequential_number);
739: IF (SQLCODE <> -20001) THEN
740: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
741: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
742: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
743: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
744: X_file_control ||
745: ' entry_sequential_number = ' ||
746: X_entry_sequential_number);
747: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
743: FND_MESSAGE.SET_TOKEN('PARAMETERS','file_control = ' ||
744: X_file_control ||
745: ' entry_sequential_number = ' ||
746: X_entry_sequential_number);
747: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
748: END IF;
749: APP_EXCEPTION.RAISE_EXCEPTION;
750:
751: END Update_Row;
769:
770: EXCEPTION
771: WHEN OTHERS THEN
772: IF (SQLCODE <> -20001) THEN
773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
776: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
770: EXCEPTION
771: WHEN OTHERS THEN
772: IF (SQLCODE <> -20001) THEN
773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
776: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
778: END IF;
771: WHEN OTHERS THEN
772: IF (SQLCODE <> -20001) THEN
773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
776: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
778: END IF;
779: APP_EXCEPTION.RAISE_EXCEPTION;
772: IF (SQLCODE <> -20001) THEN
773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
776: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
778: END IF;
779: APP_EXCEPTION.RAISE_EXCEPTION;
780:
773: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
774: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
775: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
776: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
778: END IF;
779: APP_EXCEPTION.RAISE_EXCEPTION;
780:
781: END Delete_Row;