122: RETURN NULL;
123:
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getAwardManagerID');
129: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
130: END IF;
123:
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getAwardManagerID');
129: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
130: END IF;
131: APP_EXCEPTION.RAISE_EXCEPTION;
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getAwardManagerID');
129: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
130: END IF;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END getAwardManagerID;
125: IF (SQLCODE <> -20001) THEN
126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getAwardManagerID');
129: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
130: END IF;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END getAwardManagerID;
133:
185: RETURN NULL;
186:
187: WHEN OTHERS THEN
188: IF (SQLCODE <> -20001) THEN
189: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
190: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
191: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getProjectManagerID');
192: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
193: END IF;
186:
187: WHEN OTHERS THEN
188: IF (SQLCODE <> -20001) THEN
189: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
190: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
191: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getProjectManagerID');
192: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
193: END IF;
194: APP_EXCEPTION.RAISE_EXCEPTION;
187: WHEN OTHERS THEN
188: IF (SQLCODE <> -20001) THEN
189: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
190: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
191: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getProjectManagerID');
192: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
193: END IF;
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END getProjectManagerID;
188: IF (SQLCODE <> -20001) THEN
189: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
190: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
191: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getProjectManagerID');
192: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
193: END IF;
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: END getProjectManagerID;
196:
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: IF (SQLCODE <> -20001) THEN
364: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
365: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
366: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
367: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
368: END IF;
361: EXCEPTION
362: WHEN OTHERS THEN
363: IF (SQLCODE <> -20001) THEN
364: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
365: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
366: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
367: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
368: END IF;
369: APP_EXCEPTION.RAISE_EXCEPTION;
362: WHEN OTHERS THEN
363: IF (SQLCODE <> -20001) THEN
364: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
365: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
366: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
367: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
368: END IF;
369: APP_EXCEPTION.RAISE_EXCEPTION;
370: END getCostCenterOwner;
363: IF (SQLCODE <> -20001) THEN
364: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
365: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
366: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
367: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
368: END IF;
369: APP_EXCEPTION.RAISE_EXCEPTION;
370: END getCostCenterOwner;
371:
430: WHEN NO_DATA_FOUND THEN
431: RETURN 0;
432: WHEN OTHERS THEN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
437: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
438: END IF;
431: RETURN 0;
432: WHEN OTHERS THEN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
437: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
438: END IF;
439: APP_EXCEPTION.RAISE_EXCEPTION;
432: WHEN OTHERS THEN
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
437: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
438: END IF;
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END getViolationPercentage;
433: IF (SQLCODE <> -20001) THEN
434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
437: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
438: END IF;
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END getViolationPercentage;
441:
489: WHEN NO_DATA_FOUND THEN
490: RETURN ame_util.booleanAttributeFalse;
491: WHEN OTHERS THEN
492: IF (SQLCODE <> -20001) THEN
493: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
494: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
495: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
496: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
497: END IF;
490: RETURN ame_util.booleanAttributeFalse;
491: WHEN OTHERS THEN
492: IF (SQLCODE <> -20001) THEN
493: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
494: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
495: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
496: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
497: END IF;
498: APP_EXCEPTION.RAISE_EXCEPTION;
491: WHEN OTHERS THEN
492: IF (SQLCODE <> -20001) THEN
493: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
494: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
495: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
496: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
497: END IF;
498: APP_EXCEPTION.RAISE_EXCEPTION;
499: END isMissingReceiptsShortpay;
492: IF (SQLCODE <> -20001) THEN
493: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
494: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
495: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
496: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
497: END IF;
498: APP_EXCEPTION.RAISE_EXCEPTION;
499: END isMissingReceiptsShortpay;
500:
813:
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF (SQLCODE <> -20001) THEN
817: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
818: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
819: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
820: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
821: END IF;
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF (SQLCODE <> -20001) THEN
817: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
818: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
819: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
820: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
821: END IF;
822: APP_EXCEPTION.RAISE_EXCEPTION;
815: WHEN OTHERS THEN
816: IF (SQLCODE <> -20001) THEN
817: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
818: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
819: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
820: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
821: END IF;
822: APP_EXCEPTION.RAISE_EXCEPTION;
823: END InitOieAmeNotifGT;
816: IF (SQLCODE <> -20001) THEN
817: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
818: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
819: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
820: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
821: END IF;
822: APP_EXCEPTION.RAISE_EXCEPTION;
823: END InitOieAmeNotifGT;
824:
918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF (SQLCODE <> -20001) THEN
922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
926: END IF;
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF (SQLCODE <> -20001) THEN
922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
926: END IF;
927: APP_EXCEPTION.RAISE_EXCEPTION;
920: WHEN OTHERS THEN
921: IF (SQLCODE <> -20001) THEN
922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
926: END IF;
927: APP_EXCEPTION.RAISE_EXCEPTION;
928: END InitOieAmeApproverAmtGT;
921: IF (SQLCODE <> -20001) THEN
922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
926: END IF;
927: APP_EXCEPTION.RAISE_EXCEPTION;
928: END InitOieAmeApproverAmtGT;
929: