242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: END IF;
250: APP_EXCEPTION.RAISE_EXCEPTION;
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: END IF;
250: APP_EXCEPTION.RAISE_EXCEPTION;
251:
244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: END IF;
250: APP_EXCEPTION.RAISE_EXCEPTION;
251:
252: END Update_Gain_Loss_Ind;
846:
847: EXCEPTION
848: WHEN OTHERS THEN
849: IF (SQLCODE <> -20001) THEN
850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
853: END IF;
854: APP_EXCEPTION.RAISE_EXCEPTION;
847: EXCEPTION
848: WHEN OTHERS THEN
849: IF (SQLCODE <> -20001) THEN
850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
853: END IF;
854: APP_EXCEPTION.RAISE_EXCEPTION;
855:
848: WHEN OTHERS THEN
849: IF (SQLCODE <> -20001) THEN
850: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
851: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
852: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
853: END IF;
854: APP_EXCEPTION.RAISE_EXCEPTION;
855:
856: END Primary_Pay_Events;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF (SQLCODE <> -20001) THEN
1156: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1157: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1158: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1159: END IF;
1160: APP_EXCEPTION.RAISE_EXCEPTION;
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF (SQLCODE <> -20001) THEN
1156: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1157: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1158: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1159: END IF;
1160: APP_EXCEPTION.RAISE_EXCEPTION;
1161:
1154: WHEN OTHERS THEN
1155: IF (SQLCODE <> -20001) THEN
1156: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1157: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1158: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1159: END IF;
1160: APP_EXCEPTION.RAISE_EXCEPTION;
1161:
1162:
1253:
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: IF (SQLCODE <> -20001) THEN
1257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1260: END IF;
1261: APP_EXCEPTION.RAISE_EXCEPTION;
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: IF (SQLCODE <> -20001) THEN
1257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1260: END IF;
1261: APP_EXCEPTION.RAISE_EXCEPTION;
1262:
1255: WHEN OTHERS THEN
1256: IF (SQLCODE <> -20001) THEN
1257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1260: END IF;
1261: APP_EXCEPTION.RAISE_EXCEPTION;
1262:
1263: END Cancel_Primary_Pay_Events;
1976:
1977: EXCEPTION
1978: WHEN OTHERS THEN
1979: IF (SQLCODE <> -20001) THEN
1980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1983: END IF;
1984: APP_EXCEPTION.RAISE_EXCEPTION;
1977: EXCEPTION
1978: WHEN OTHERS THEN
1979: IF (SQLCODE <> -20001) THEN
1980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1983: END IF;
1984: APP_EXCEPTION.RAISE_EXCEPTION;
1985:
1978: WHEN OTHERS THEN
1979: IF (SQLCODE <> -20001) THEN
1980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1983: END IF;
1984: APP_EXCEPTION.RAISE_EXCEPTION;
1985:
1986: END Pay_Dist_Cascade_Adj_Events;
2915:
2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: IF (SQLCODE <> -20001) THEN
2919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2922: END IF;
2923: APP_EXCEPTION.RAISE_EXCEPTION;
2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: IF (SQLCODE <> -20001) THEN
2919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2922: END IF;
2923: APP_EXCEPTION.RAISE_EXCEPTION;
2924:
2917: WHEN OTHERS THEN
2918: IF (SQLCODE <> -20001) THEN
2919: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2920: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2921: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2922: END IF;
2923: APP_EXCEPTION.RAISE_EXCEPTION;
2924:
2925: END Pay_Dist_Proc;
3345:
3346: EXCEPTION
3347: WHEN OTHERS THEN
3348: IF (SQLCODE <> -20001) THEN
3349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3352: END IF;
3353: APP_EXCEPTION.RAISE_EXCEPTION;
3346: EXCEPTION
3347: WHEN OTHERS THEN
3348: IF (SQLCODE <> -20001) THEN
3349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3352: END IF;
3353: APP_EXCEPTION.RAISE_EXCEPTION;
3354:
3347: WHEN OTHERS THEN
3348: IF (SQLCODE <> -20001) THEN
3349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3352: END IF;
3353: APP_EXCEPTION.RAISE_EXCEPTION;
3354:
3355: END Pay_Dist_Discount;
3513:
3514: EXCEPTION
3515: WHEN OTHERS THEN
3516: IF (SQLCODE <> -20001) THEN
3517: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3518: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3519: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3520: END IF;
3521: APP_EXCEPTION.RAISE_EXCEPTION;
3514: EXCEPTION
3515: WHEN OTHERS THEN
3516: IF (SQLCODE <> -20001) THEN
3517: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3518: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3519: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3520: END IF;
3521: APP_EXCEPTION.RAISE_EXCEPTION;
3522:
3515: WHEN OTHERS THEN
3516: IF (SQLCODE <> -20001) THEN
3517: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3518: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3519: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3520: END IF;
3521: APP_EXCEPTION.RAISE_EXCEPTION;
3522:
3523: END Pay_Dist_ERV;
3751:
3752: EXCEPTION
3753: WHEN OTHERS THEN
3754: IF (SQLCODE <> -20001) THEN
3755: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3756: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3757: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3758: END IF;
3759: APP_EXCEPTION.RAISE_EXCEPTION;
3752: EXCEPTION
3753: WHEN OTHERS THEN
3754: IF (SQLCODE <> -20001) THEN
3755: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3756: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3757: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3758: END IF;
3759: APP_EXCEPTION.RAISE_EXCEPTION;
3760:
3753: WHEN OTHERS THEN
3754: IF (SQLCODE <> -20001) THEN
3755: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3756: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3757: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3758: END IF;
3759: APP_EXCEPTION.RAISE_EXCEPTION;
3760:
3761: END Pay_Dist_Err_Chrg;
4253:
4254: EXCEPTION
4255: WHEN OTHERS THEN
4256: IF (SQLCODE <> -20001) THEN
4257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4260: END IF;
4261: APP_EXCEPTION.RAISE_EXCEPTION;
4254: EXCEPTION
4255: WHEN OTHERS THEN
4256: IF (SQLCODE <> -20001) THEN
4257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4260: END IF;
4261: APP_EXCEPTION.RAISE_EXCEPTION;
4262:
4255: WHEN OTHERS THEN
4256: IF (SQLCODE <> -20001) THEN
4257: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4258: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4259: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4260: END IF;
4261: APP_EXCEPTION.RAISE_EXCEPTION;
4262:
4263: END Pay_Dist_Reverse;
4371:
4372: EXCEPTION
4373: WHEN OTHERS THEN
4374: IF (SQLCODE <> -20001) THEN
4375: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4376: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4377: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4378: END IF;
4379: APP_EXCEPTION.RAISE_EXCEPTION;
4372: EXCEPTION
4373: WHEN OTHERS THEN
4374: IF (SQLCODE <> -20001) THEN
4375: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4376: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4377: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4378: END IF;
4379: APP_EXCEPTION.RAISE_EXCEPTION;
4380:
4373: WHEN OTHERS THEN
4374: IF (SQLCODE <> -20001) THEN
4375: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4376: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4377: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4378: END IF;
4379: APP_EXCEPTION.RAISE_EXCEPTION;
4380:
4381: END Pay_Dist_Insert;
4789:
4790: EXCEPTION
4791: WHEN OTHERS THEN
4792: IF (SQLCODE <> -20001) THEN
4793: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4794: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4795: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4796: END IF;
4797: APP_EXCEPTION.RAISE_EXCEPTION;
4790: EXCEPTION
4791: WHEN OTHERS THEN
4792: IF (SQLCODE <> -20001) THEN
4793: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4794: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4795: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4796: END IF;
4797: APP_EXCEPTION.RAISE_EXCEPTION;
4798:
4791: WHEN OTHERS THEN
4792: IF (SQLCODE <> -20001) THEN
4793: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4794: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4795: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4796: END IF;
4797: APP_EXCEPTION.RAISE_EXCEPTION;
4798:
4799: END Upg_Dist_Links_Insert;