355: EXCEPTION
356:
357: WHEN OTHERS THEN
358: IF (SQLCODE <> -20001) THEN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
362: END IF;
363: APP_EXCEPTION.RAISE_EXCEPTION;
356:
357: WHEN OTHERS THEN
358: IF (SQLCODE <> -20001) THEN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
362: END IF;
363: APP_EXCEPTION.RAISE_EXCEPTION;
364:
357: WHEN OTHERS THEN
358: IF (SQLCODE <> -20001) THEN
359: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
360: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
361: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
362: END IF;
363: APP_EXCEPTION.RAISE_EXCEPTION;
364:
365: END Do_Pay_Accounting;
410: EXCEPTION
411:
412: WHEN OTHERS THEN
413: IF (SQLCODE <> -20001) THEN
414: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
415: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
416: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
411:
412: WHEN OTHERS THEN
413: IF (SQLCODE <> -20001) THEN
414: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
415: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
416: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
419:
412: WHEN OTHERS THEN
413: IF (SQLCODE <> -20001) THEN
414: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
415: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
416: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
417: END IF;
418: APP_EXCEPTION.RAISE_EXCEPTION;
419:
420: END Delete_Hist_Dists;
901: EXCEPTION
902:
903: WHEN OTHERS THEN
904: IF (SQLCODE <> -20001) THEN
905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
902:
903: WHEN OTHERS THEN
904: IF (SQLCODE <> -20001) THEN
905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
903: WHEN OTHERS THEN
904: IF (SQLCODE <> -20001) THEN
905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
911: END Get_Pay_Sum;
1062: EXCEPTION
1063:
1064: WHEN OTHERS THEN
1065: IF (SQLCODE <> -20001) THEN
1066: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1067: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1068: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1069: END IF;
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1063:
1064: WHEN OTHERS THEN
1065: IF (SQLCODE <> -20001) THEN
1066: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1067: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1068: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1069: END IF;
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071:
1064: WHEN OTHERS THEN
1065: IF (SQLCODE <> -20001) THEN
1066: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1067: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1068: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1069: END IF;
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071:
1072: END Get_Pay_Base_Sum;
1166: EXCEPTION
1167:
1168: WHEN OTHERS THEN
1169: IF (SQLCODE <> -20001) THEN
1170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1173: END IF;
1174: APP_EXCEPTION.RAISE_EXCEPTION;
1167:
1168: WHEN OTHERS THEN
1169: IF (SQLCODE <> -20001) THEN
1170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1173: END IF;
1174: APP_EXCEPTION.RAISE_EXCEPTION;
1175:
1168: WHEN OTHERS THEN
1169: IF (SQLCODE <> -20001) THEN
1170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1173: END IF;
1174: APP_EXCEPTION.RAISE_EXCEPTION;
1175:
1176: END Get_Prepay_Base_Sum;
1758:
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: IF (SQLCODE <> -20001) THEN
1762: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1763: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1764: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1765: END IF;
1766: APP_EXCEPTION.RAISE_EXCEPTION;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: IF (SQLCODE <> -20001) THEN
1762: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1763: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1764: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1765: END IF;
1766: APP_EXCEPTION.RAISE_EXCEPTION;
1767: END;
1760: WHEN OTHERS THEN
1761: IF (SQLCODE <> -20001) THEN
1762: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1763: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1764: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1765: END IF;
1766: APP_EXCEPTION.RAISE_EXCEPTION;
1767: END;
1768: