71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: IF (SQLCODE <> -20001) THEN
75: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
76: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
77: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
78: END IF;
79: APP_EXCEPTION.RAISE_EXCEPTION;
72: EXCEPTION
73: WHEN OTHERS THEN
74: IF (SQLCODE <> -20001) THEN
75: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
76: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
77: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
78: END IF;
79: APP_EXCEPTION.RAISE_EXCEPTION;
80:
73: WHEN OTHERS THEN
74: IF (SQLCODE <> -20001) THEN
75: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
76: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
77: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
78: END IF;
79: APP_EXCEPTION.RAISE_EXCEPTION;
80:
81: END Update_Gain_Loss_Ind;
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
626: END IF;
627: APP_EXCEPTION.RAISE_EXCEPTION;
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
626: END IF;
627: APP_EXCEPTION.RAISE_EXCEPTION;
628:
621: WHEN OTHERS THEN
622: IF (SQLCODE <> -20001) THEN
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
626: END IF;
627: APP_EXCEPTION.RAISE_EXCEPTION;
628:
629: END Prepay_Dist_Appl;
1126:
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: IF (SQLCODE <> -20001) THEN
1130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1133: END IF;
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: IF (SQLCODE <> -20001) THEN
1130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1133: END IF;
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1135:
1128: WHEN OTHERS THEN
1129: IF (SQLCODE <> -20001) THEN
1130: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1131: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1132: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1133: END IF;
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1135:
1136: END Prepay_Dist_Cascade_Adj;
1560:
1561: EXCEPTION
1562: WHEN OTHERS THEN
1563: IF (SQLCODE <> -20001) THEN
1564: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1565: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1566: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1567: END IF;
1568: APP_EXCEPTION.RAISE_EXCEPTION;
1561: EXCEPTION
1562: WHEN OTHERS THEN
1563: IF (SQLCODE <> -20001) THEN
1564: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1565: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1566: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1567: END IF;
1568: APP_EXCEPTION.RAISE_EXCEPTION;
1569:
1562: WHEN OTHERS THEN
1563: IF (SQLCODE <> -20001) THEN
1564: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1565: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1566: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1567: END IF;
1568: APP_EXCEPTION.RAISE_EXCEPTION;
1569:
1570: END Prepay_Dist_Proc;
1762:
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: IF (SQLCODE <> -20001) THEN
1766: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1767: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1768: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1769: END IF;
1770: APP_EXCEPTION.RAISE_EXCEPTION;
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: IF (SQLCODE <> -20001) THEN
1766: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1767: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1768: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1769: END IF;
1770: APP_EXCEPTION.RAISE_EXCEPTION;
1771:
1764: WHEN OTHERS THEN
1765: IF (SQLCODE <> -20001) THEN
1766: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1767: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1768: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1769: END IF;
1770: APP_EXCEPTION.RAISE_EXCEPTION;
1771:
1772: END Prepay_Dist_Tax_Diff;
1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF (SQLCODE <> -20001) THEN
1944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1947: END IF;
1948: APP_EXCEPTION.RAISE_EXCEPTION;
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF (SQLCODE <> -20001) THEN
1944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1947: END IF;
1948: APP_EXCEPTION.RAISE_EXCEPTION;
1949:
1942: WHEN OTHERS THEN
1943: IF (SQLCODE <> -20001) THEN
1944: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1945: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1946: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1947: END IF;
1948: APP_EXCEPTION.RAISE_EXCEPTION;
1949:
1950: END Prepay_Dist_ERV;
2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: IF (SQLCODE <> -20001) THEN
2162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2163: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2165: END IF;
2166: APP_EXCEPTION.RAISE_EXCEPTION;
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: IF (SQLCODE <> -20001) THEN
2162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2163: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2165: END IF;
2166: APP_EXCEPTION.RAISE_EXCEPTION;
2167:
2160: WHEN OTHERS THEN
2161: IF (SQLCODE <> -20001) THEN
2162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2163: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2165: END IF;
2166: APP_EXCEPTION.RAISE_EXCEPTION;
2167:
2168: END Prepay_Dist_Reverse;
2283:
2284: EXCEPTION
2285: WHEN OTHERS THEN
2286: IF (SQLCODE <> -20001) THEN
2287: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2288: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2289: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2290: END IF;
2291: APP_EXCEPTION.RAISE_EXCEPTION;
2284: EXCEPTION
2285: WHEN OTHERS THEN
2286: IF (SQLCODE <> -20001) THEN
2287: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2288: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2289: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2290: END IF;
2291: APP_EXCEPTION.RAISE_EXCEPTION;
2292:
2285: WHEN OTHERS THEN
2286: IF (SQLCODE <> -20001) THEN
2287: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2288: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2289: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2290: END IF;
2291: APP_EXCEPTION.RAISE_EXCEPTION;
2292:
2293: END Prepay_Dist_Insert;
2396: EXCEPTION
2397:
2398: WHEN OTHERS THEN
2399: IF (SQLCODE <> -20001) THEN
2400: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2401: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2402: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2403: END IF;
2404: APP_EXCEPTION.RAISE_EXCEPTION;
2397:
2398: WHEN OTHERS THEN
2399: IF (SQLCODE <> -20001) THEN
2400: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2401: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2402: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2403: END IF;
2404: APP_EXCEPTION.RAISE_EXCEPTION;
2405:
2398: WHEN OTHERS THEN
2399: IF (SQLCODE <> -20001) THEN
2400: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2401: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2402: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2403: END IF;
2404: APP_EXCEPTION.RAISE_EXCEPTION;
2405:
2406: END Delete_Hist_Dists;