188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: IF (SQLCODE <> -20001) THEN
192: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
194: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
195: END IF;
196: APP_EXCEPTION.RAISE_EXCEPTION;
189: EXCEPTION
190: WHEN OTHERS THEN
191: IF (SQLCODE <> -20001) THEN
192: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
194: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
195: END IF;
196: APP_EXCEPTION.RAISE_EXCEPTION;
197:
190: WHEN OTHERS THEN
191: IF (SQLCODE <> -20001) THEN
192: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
193: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
194: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
195: END IF;
196: APP_EXCEPTION.RAISE_EXCEPTION;
197:
198: END Update_Gain_Loss_Ind;
983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: IF (SQLCODE <> -20001) THEN
987: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
988: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
989: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
990: END IF;
991: APP_EXCEPTION.RAISE_EXCEPTION;
984: EXCEPTION
985: WHEN OTHERS THEN
986: IF (SQLCODE <> -20001) THEN
987: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
988: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
989: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
990: END IF;
991: APP_EXCEPTION.RAISE_EXCEPTION;
992:
985: WHEN OTHERS THEN
986: IF (SQLCODE <> -20001) THEN
987: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
988: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
989: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
990: END IF;
991: APP_EXCEPTION.RAISE_EXCEPTION;
992:
993: END Prepay_Dist_Appl;
1725:
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1732: END IF;
1733: APP_EXCEPTION.RAISE_EXCEPTION;
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1732: END IF;
1733: APP_EXCEPTION.RAISE_EXCEPTION;
1734:
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1732: END IF;
1733: APP_EXCEPTION.RAISE_EXCEPTION;
1734:
1735: END Prepay_Dist_Cascade_Adj;
2227:
2228: EXCEPTION
2229: WHEN OTHERS THEN
2230: IF (SQLCODE <> -20001) THEN
2231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2234: END IF;
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2228: EXCEPTION
2229: WHEN OTHERS THEN
2230: IF (SQLCODE <> -20001) THEN
2231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2234: END IF;
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2236:
2229: WHEN OTHERS THEN
2230: IF (SQLCODE <> -20001) THEN
2231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2234: END IF;
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2236:
2237: END Prepay_Dist_Proc;
2429:
2430: EXCEPTION
2431: WHEN OTHERS THEN
2432: IF (SQLCODE <> -20001) THEN
2433: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2434: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2435: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2436: END IF;
2437: APP_EXCEPTION.RAISE_EXCEPTION;
2430: EXCEPTION
2431: WHEN OTHERS THEN
2432: IF (SQLCODE <> -20001) THEN
2433: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2434: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2435: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2436: END IF;
2437: APP_EXCEPTION.RAISE_EXCEPTION;
2438:
2431: WHEN OTHERS THEN
2432: IF (SQLCODE <> -20001) THEN
2433: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2434: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2435: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2436: END IF;
2437: APP_EXCEPTION.RAISE_EXCEPTION;
2438:
2439: END Prepay_Dist_Tax_Diff;
2607:
2608: EXCEPTION
2609: WHEN OTHERS THEN
2610: IF (SQLCODE <> -20001) THEN
2611: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2612: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2614: END IF;
2615: APP_EXCEPTION.RAISE_EXCEPTION;
2608: EXCEPTION
2609: WHEN OTHERS THEN
2610: IF (SQLCODE <> -20001) THEN
2611: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2612: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2614: END IF;
2615: APP_EXCEPTION.RAISE_EXCEPTION;
2616:
2609: WHEN OTHERS THEN
2610: IF (SQLCODE <> -20001) THEN
2611: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2612: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2614: END IF;
2615: APP_EXCEPTION.RAISE_EXCEPTION;
2616:
2617: END Prepay_Dist_ERV;
2846:
2847: EXCEPTION
2848: WHEN OTHERS THEN
2849: IF (SQLCODE <> -20001) THEN
2850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2853: END IF;
2854: APP_EXCEPTION.RAISE_EXCEPTION;
2847: EXCEPTION
2848: WHEN OTHERS THEN
2849: IF (SQLCODE <> -20001) THEN
2850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2853: END IF;
2854: APP_EXCEPTION.RAISE_EXCEPTION;
2855:
2848: WHEN OTHERS THEN
2849: IF (SQLCODE <> -20001) THEN
2850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2853: END IF;
2854: APP_EXCEPTION.RAISE_EXCEPTION;
2855:
2856: END Prepay_Dist_Reverse;
2971:
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: IF (SQLCODE <> -20001) THEN
2975: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2976: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2977: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2978: END IF;
2979: APP_EXCEPTION.RAISE_EXCEPTION;
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: IF (SQLCODE <> -20001) THEN
2975: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2976: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2977: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2978: END IF;
2979: APP_EXCEPTION.RAISE_EXCEPTION;
2980:
2973: WHEN OTHERS THEN
2974: IF (SQLCODE <> -20001) THEN
2975: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2976: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2977: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2978: END IF;
2979: APP_EXCEPTION.RAISE_EXCEPTION;
2980:
2981: END Prepay_Dist_Insert;
3069: EXCEPTION
3070:
3071: WHEN OTHERS THEN
3072: IF (SQLCODE <> -20001) THEN
3073: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3074: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3075: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3076: END IF;
3077: APP_EXCEPTION.RAISE_EXCEPTION;
3070:
3071: WHEN OTHERS THEN
3072: IF (SQLCODE <> -20001) THEN
3073: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3074: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3075: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3076: END IF;
3077: APP_EXCEPTION.RAISE_EXCEPTION;
3078:
3071: WHEN OTHERS THEN
3072: IF (SQLCODE <> -20001) THEN
3073: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3074: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3075: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3076: END IF;
3077: APP_EXCEPTION.RAISE_EXCEPTION;
3078:
3079: END Delete_Hist_Dists;
3559:
3560: EXCEPTION
3561: WHEN OTHERS THEN
3562: IF (SQLCODE <> -20001) THEN
3563: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3566: END IF;
3567: APP_EXCEPTION.RAISE_EXCEPTION;
3560: EXCEPTION
3561: WHEN OTHERS THEN
3562: IF (SQLCODE <> -20001) THEN
3563: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3566: END IF;
3567: APP_EXCEPTION.RAISE_EXCEPTION;
3568:
3561: WHEN OTHERS THEN
3562: IF (SQLCODE <> -20001) THEN
3563: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3566: END IF;
3567: APP_EXCEPTION.RAISE_EXCEPTION;
3568:
3569: END Upg_Dist_Links_Insert;