282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: IF (SQLCODE <> -20001) THEN
286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
283: EXCEPTION
284: WHEN OTHERS THEN
285: IF (SQLCODE <> -20001) THEN
286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
291:
284: WHEN OTHERS THEN
285: IF (SQLCODE <> -20001) THEN
286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
291:
292: END Update_Gain_Loss_Ind;
1146: WHEN OTHERS THEN
1147: IF SQLCODE = -20100 THEN
1148: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1149: ELSIF (SQLCODE <> -20001) THEN
1150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1147: IF SQLCODE = -20100 THEN
1148: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1149: ELSIF (SQLCODE <> -20001) THEN
1150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1155: END Primary_Pay_Events;
1148: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1149: ELSIF (SQLCODE <> -20001) THEN
1150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1155: END Primary_Pay_Events;
1156:
1526: WHEN OTHERS THEN
1527: IF SQLCODE = -20100 THEN
1528: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1529: ELSIF (SQLCODE <> -20001) THEN
1530: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1531: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1532: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1533: END IF;
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1527: IF SQLCODE = -20100 THEN
1528: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1529: ELSIF (SQLCODE <> -20001) THEN
1530: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1531: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1532: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1533: END IF;
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1535:
1528: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
1529: ELSIF (SQLCODE <> -20001) THEN
1530: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1531: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1532: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1533: END IF;
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1535:
1536:
1630:
1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: IF (SQLCODE <> -20001) THEN
1634: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1635: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1636: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1637: END IF;
1638: APP_EXCEPTION.RAISE_EXCEPTION;
1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: IF (SQLCODE <> -20001) THEN
1634: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1635: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1636: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1637: END IF;
1638: APP_EXCEPTION.RAISE_EXCEPTION;
1639:
1632: WHEN OTHERS THEN
1633: IF (SQLCODE <> -20001) THEN
1634: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1635: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1636: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1637: END IF;
1638: APP_EXCEPTION.RAISE_EXCEPTION;
1639:
1640: END Cancel_Primary_Pay_Events;
2521: WHEN OTHERS THEN
2522: IF SQLCODE = -20100 THEN
2523: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2524: ELSIF (SQLCODE <> -20001) THEN
2525: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2526: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2528: END IF;
2529: APP_EXCEPTION.RAISE_EXCEPTION;
2522: IF SQLCODE = -20100 THEN
2523: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2524: ELSIF (SQLCODE <> -20001) THEN
2525: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2526: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2528: END IF;
2529: APP_EXCEPTION.RAISE_EXCEPTION;
2530:
2523: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2524: ELSIF (SQLCODE <> -20001) THEN
2525: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2526: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2528: END IF;
2529: APP_EXCEPTION.RAISE_EXCEPTION;
2530:
2531: END Pay_Dist_Cascade_Adj_Events;
3775:
3776: EXCEPTION
3777: WHEN OTHERS THEN
3778: IF (SQLCODE <> -20001) THEN
3779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3782: END IF;
3783: APP_EXCEPTION.RAISE_EXCEPTION;
3776: EXCEPTION
3777: WHEN OTHERS THEN
3778: IF (SQLCODE <> -20001) THEN
3779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3782: END IF;
3783: APP_EXCEPTION.RAISE_EXCEPTION;
3784:
3777: WHEN OTHERS THEN
3778: IF (SQLCODE <> -20001) THEN
3779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3782: END IF;
3783: APP_EXCEPTION.RAISE_EXCEPTION;
3784:
3785: END Pay_Dist_Proc;
4227:
4228: EXCEPTION
4229: WHEN OTHERS THEN
4230: IF (SQLCODE <> -20001) THEN
4231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4234: END IF;
4235: APP_EXCEPTION.RAISE_EXCEPTION;
4228: EXCEPTION
4229: WHEN OTHERS THEN
4230: IF (SQLCODE <> -20001) THEN
4231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4234: END IF;
4235: APP_EXCEPTION.RAISE_EXCEPTION;
4236:
4229: WHEN OTHERS THEN
4230: IF (SQLCODE <> -20001) THEN
4231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4234: END IF;
4235: APP_EXCEPTION.RAISE_EXCEPTION;
4236:
4237: END Pay_Dist_Discount;
4401:
4402: EXCEPTION
4403: WHEN OTHERS THEN
4404: IF (SQLCODE <> -20001) THEN
4405: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4406: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4407: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4408: END IF;
4409: APP_EXCEPTION.RAISE_EXCEPTION;
4402: EXCEPTION
4403: WHEN OTHERS THEN
4404: IF (SQLCODE <> -20001) THEN
4405: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4406: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4407: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4408: END IF;
4409: APP_EXCEPTION.RAISE_EXCEPTION;
4410:
4403: WHEN OTHERS THEN
4404: IF (SQLCODE <> -20001) THEN
4405: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4406: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4407: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4408: END IF;
4409: APP_EXCEPTION.RAISE_EXCEPTION;
4410:
4411: END Pay_Dist_ERV;
4629:
4630: EXCEPTION
4631: WHEN OTHERS THEN
4632: IF (SQLCODE <> -20001) THEN
4633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4636: END IF;
4637: APP_EXCEPTION.RAISE_EXCEPTION;
4630: EXCEPTION
4631: WHEN OTHERS THEN
4632: IF (SQLCODE <> -20001) THEN
4633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4636: END IF;
4637: APP_EXCEPTION.RAISE_EXCEPTION;
4638:
4631: WHEN OTHERS THEN
4632: IF (SQLCODE <> -20001) THEN
4633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4636: END IF;
4637: APP_EXCEPTION.RAISE_EXCEPTION;
4638:
4639: END Pay_Dist_Err_Chrg;
5244:
5245: EXCEPTION
5246: WHEN OTHERS THEN
5247: IF (SQLCODE <> -20001) THEN
5248: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5249: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5250: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5251: END IF;
5252: APP_EXCEPTION.RAISE_EXCEPTION;
5245: EXCEPTION
5246: WHEN OTHERS THEN
5247: IF (SQLCODE <> -20001) THEN
5248: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5249: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5250: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5251: END IF;
5252: APP_EXCEPTION.RAISE_EXCEPTION;
5253:
5246: WHEN OTHERS THEN
5247: IF (SQLCODE <> -20001) THEN
5248: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5249: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5250: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5251: END IF;
5252: APP_EXCEPTION.RAISE_EXCEPTION;
5253:
5254: END Pay_Dist_Reverse;
5362:
5363: EXCEPTION
5364: WHEN OTHERS THEN
5365: IF (SQLCODE <> -20001) THEN
5366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5369: END IF;
5370: APP_EXCEPTION.RAISE_EXCEPTION;
5363: EXCEPTION
5364: WHEN OTHERS THEN
5365: IF (SQLCODE <> -20001) THEN
5366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5369: END IF;
5370: APP_EXCEPTION.RAISE_EXCEPTION;
5371:
5364: WHEN OTHERS THEN
5365: IF (SQLCODE <> -20001) THEN
5366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5369: END IF;
5370: APP_EXCEPTION.RAISE_EXCEPTION;
5371:
5372: END Pay_Dist_Insert;
6335:
6336: EXCEPTION
6337: WHEN OTHERS THEN
6338: IF (SQLCODE <> -20001) THEN
6339: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
6342: END IF;
6343: APP_EXCEPTION.RAISE_EXCEPTION;
6336: EXCEPTION
6337: WHEN OTHERS THEN
6338: IF (SQLCODE <> -20001) THEN
6339: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
6342: END IF;
6343: APP_EXCEPTION.RAISE_EXCEPTION;
6344:
6337: WHEN OTHERS THEN
6338: IF (SQLCODE <> -20001) THEN
6339: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
6342: END IF;
6343: APP_EXCEPTION.RAISE_EXCEPTION;
6344:
6345: END Upg_Dist_Links_Insert;