285: WHEN OTHERS THEN
286: IF (SQLCODE = -20100) THEN
287: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
288: ELSIF (SQLCODE <> -20001) THEN
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
292: END IF;
293: APP_EXCEPTION.RAISE_EXCEPTION;
286: IF (SQLCODE = -20100) THEN
287: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
288: ELSIF (SQLCODE <> -20001) THEN
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
292: END IF;
293: APP_EXCEPTION.RAISE_EXCEPTION;
294: END Do_Rounding;
287: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
288: ELSIF (SQLCODE <> -20001) THEN
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
292: END IF;
293: APP_EXCEPTION.RAISE_EXCEPTION;
294: END Do_Rounding;
295:
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF (SQLCODE <> -20001) THEN
771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
774: END IF;
775: APP_EXCEPTION.RAISE_EXCEPTION;
768: EXCEPTION
769: WHEN OTHERS THEN
770: IF (SQLCODE <> -20001) THEN
771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
774: END IF;
775: APP_EXCEPTION.RAISE_EXCEPTION;
776:
769: WHEN OTHERS THEN
770: IF (SQLCODE <> -20001) THEN
771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
774: END IF;
775: APP_EXCEPTION.RAISE_EXCEPTION;
776:
777: END Final_Pay;
2302: WHEN OTHERS THEN
2303: IF (SQLCODE = -20100) THEN
2304: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2305: ELSIF (SQLCODE <> -20001) THEN
2306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2309: END IF;
2310: APP_EXCEPTION.RAISE_EXCEPTION;
2303: IF (SQLCODE = -20100) THEN
2304: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2305: ELSIF (SQLCODE <> -20001) THEN
2306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2309: END IF;
2310: APP_EXCEPTION.RAISE_EXCEPTION;
2311:
2304: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2305: ELSIF (SQLCODE <> -20001) THEN
2306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2309: END IF;
2310: APP_EXCEPTION.RAISE_EXCEPTION;
2311:
2312: END Total_Pay;
2582: WHEN OTHERS THEN
2583: IF (SQLCODE = -20100) THEN
2584: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2585: ELSIF (SQLCODE <> -20001) THEN
2586: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2587: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2588: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2589: END IF;
2590: APP_EXCEPTION.RAISE_EXCEPTION;
2583: IF (SQLCODE = -20100) THEN
2584: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2585: ELSIF (SQLCODE <> -20001) THEN
2586: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2587: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2588: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2589: END IF;
2590: APP_EXCEPTION.RAISE_EXCEPTION;
2591:
2584: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2585: ELSIF (SQLCODE <> -20001) THEN
2586: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2587: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2588: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2589: END IF;
2590: APP_EXCEPTION.RAISE_EXCEPTION;
2591:
2592: END Compare_Pay;
2910: WHEN OTHERS THEN
2911: IF (SQLCODE = -20100) THEN
2912: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2913: ELSIF (SQLCODE <> -20001) THEN
2914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2917: END IF;
2918: APP_EXCEPTION.RAISE_EXCEPTION;
2911: IF (SQLCODE = -20100) THEN
2912: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2913: ELSIF (SQLCODE <> -20001) THEN
2914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2917: END IF;
2918: APP_EXCEPTION.RAISE_EXCEPTION;
2919:
2912: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
2913: ELSIF (SQLCODE <> -20001) THEN
2914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2915: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2916: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2917: END IF;
2918: APP_EXCEPTION.RAISE_EXCEPTION;
2919:
2920: END Total_Appl;
3181: WHEN OTHERS THEN
3182: IF (SQLCODE = -20100) THEN
3183: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3184: ELSIF (SQLCODE <> -20001) THEN
3185: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3186: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3187: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3188: END IF;
3189: APP_EXCEPTION.RAISE_EXCEPTION;
3182: IF (SQLCODE = -20100) THEN
3183: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3184: ELSIF (SQLCODE <> -20001) THEN
3185: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3186: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3187: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3188: END IF;
3189: APP_EXCEPTION.RAISE_EXCEPTION;
3190:
3183: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3184: ELSIF (SQLCODE <> -20001) THEN
3185: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3186: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3187: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3188: END IF;
3189: APP_EXCEPTION.RAISE_EXCEPTION;
3190:
3191: END Final_Appl;
3404: WHEN OTHERS THEN
3405: IF (SQLCODE = -20100) THEN
3406: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3407: ELSIF (SQLCODE <> -20001) THEN
3408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3411: END IF;
3412: APP_EXCEPTION.RAISE_EXCEPTION;
3405: IF (SQLCODE = -20100) THEN
3406: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3407: ELSIF (SQLCODE <> -20001) THEN
3408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3411: END IF;
3412: APP_EXCEPTION.RAISE_EXCEPTION;
3413:
3406: RAISE_APPLICATION_ERROR(-20100, SQLERRM);
3407: ELSIF (SQLCODE <> -20001) THEN
3408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3411: END IF;
3412: APP_EXCEPTION.RAISE_EXCEPTION;
3413:
3414: END Final_Cash;