432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: IF (SQLCODE <> -20001) THEN
436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
439: ;
440: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
433: EXCEPTION
434: WHEN OTHERS THEN
435: IF (SQLCODE <> -20001) THEN
436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
439: ;
440: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
441: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
434: WHEN OTHERS THEN
435: IF (SQLCODE <> -20001) THEN
436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
439: ;
440: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
441: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
442: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
439: ;
440: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
441: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
442: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
443: END IF;
444: APP_EXCEPTION.RAISE_EXCEPTION;
438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
439: ;
440: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
441: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
442: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
443: END IF;
444: APP_EXCEPTION.RAISE_EXCEPTION;
445:
446: END Insert_Row;
722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF (SQLCODE <> -20001) THEN
726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
729: ;
730: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF (SQLCODE <> -20001) THEN
726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
729: ;
730: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
731: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
724: WHEN OTHERS THEN
725: IF (SQLCODE <> -20001) THEN
726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
729: ;
730: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
731: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
729: ;
730: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
731: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
733: END IF;
734: APP_EXCEPTION.RAISE_EXCEPTION;
728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
729: ;
730: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid ||
731: ', CHECK_ID = ' || TO_CHAR(p_Check_Id));
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
733: END IF;
734: APP_EXCEPTION.RAISE_EXCEPTION;
735:
736: END Update_Row;
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: IF (SQLCODE <> -20001) THEN
764: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
765: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
766: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
767: ;
768: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid);
761: EXCEPTION
762: WHEN OTHERS THEN
763: IF (SQLCODE <> -20001) THEN
764: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
765: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
766: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
767: ;
768: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid);
769: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
762: WHEN OTHERS THEN
763: IF (SQLCODE <> -20001) THEN
764: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
765: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
766: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
767: ;
768: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid);
769: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
770: END IF;
764: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
765: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
766: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
767: ;
768: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid);
769: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
770: END IF;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772:
765: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
766: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence)
767: ;
768: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_Rowid);
769: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
770: END IF;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772:
773: END Delete_Row;
804: Exception
805: WHEN OTHERS then
806:
807: if (SQLCODE <> -20001 ) then
808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
811: FND_MESSAGE.SET_TOKEN('PARAMETERS'
812: ,' Check_Id = '||TO_CHAR(P_Check_id)
805: WHEN OTHERS then
806:
807: if (SQLCODE <> -20001 ) then
808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
811: FND_MESSAGE.SET_TOKEN('PARAMETERS'
812: ,' Check_Id = '||TO_CHAR(P_Check_id)
813: ||', Amount = '||TO_CHAR(P_amount)
806:
807: if (SQLCODE <> -20001 ) then
808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
811: FND_MESSAGE.SET_TOKEN('PARAMETERS'
812: ,' Check_Id = '||TO_CHAR(P_Check_id)
813: ||', Amount = '||TO_CHAR(P_amount)
814: ||', Base_Amount = '||TO_CHAR(P_Base_Amount));
807: if (SQLCODE <> -20001 ) then
808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
811: FND_MESSAGE.SET_TOKEN('PARAMETERS'
812: ,' Check_Id = '||TO_CHAR(P_Check_id)
813: ||', Amount = '||TO_CHAR(P_amount)
814: ||', Base_Amount = '||TO_CHAR(P_Base_Amount));
815:
812: ,' Check_Id = '||TO_CHAR(P_Check_id)
813: ||', Amount = '||TO_CHAR(P_amount)
814: ||', Base_Amount = '||TO_CHAR(P_Base_Amount));
815:
816: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
817: end if;
818:
819: APP_EXCEPTION.RAISE_EXCEPTION;
820: