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:
366:
367: EXCEPTION
368: WHEN OTHERS THEN
369: IF (SQLCODE <> -20001) THEN
370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
373: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
374: END IF;
367: EXCEPTION
368: WHEN OTHERS THEN
369: IF (SQLCODE <> -20001) THEN
370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
373: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
374: END IF;
375: APP_EXCEPTION.RAISE_EXCEPTION;
368: WHEN OTHERS THEN
369: IF (SQLCODE <> -20001) THEN
370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
373: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
374: END IF;
375: APP_EXCEPTION.RAISE_EXCEPTION;
376: END getCostCenterOwner;
369: IF (SQLCODE <> -20001) THEN
370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterOwner');
373: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
374: END IF;
375: APP_EXCEPTION.RAISE_EXCEPTION;
376: END getCostCenterOwner;
377:
436: WHEN NO_DATA_FOUND THEN
437: RETURN 0;
438: WHEN OTHERS THEN
439: IF (SQLCODE <> -20001) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
444: END IF;
437: RETURN 0;
438: WHEN OTHERS THEN
439: IF (SQLCODE <> -20001) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
444: END IF;
445: APP_EXCEPTION.RAISE_EXCEPTION;
438: WHEN OTHERS THEN
439: IF (SQLCODE <> -20001) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
444: END IF;
445: APP_EXCEPTION.RAISE_EXCEPTION;
446: END getViolationPercentage;
439: IF (SQLCODE <> -20001) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getViolationPercentage');
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
444: END IF;
445: APP_EXCEPTION.RAISE_EXCEPTION;
446: END getViolationPercentage;
447:
495: WHEN NO_DATA_FOUND THEN
496: RETURN ame_util.booleanAttributeFalse;
497: WHEN OTHERS THEN
498: IF (SQLCODE <> -20001) THEN
499: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
500: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
501: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
502: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
503: END IF;
496: RETURN ame_util.booleanAttributeFalse;
497: WHEN OTHERS THEN
498: IF (SQLCODE <> -20001) THEN
499: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
500: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
501: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
502: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
503: END IF;
504: APP_EXCEPTION.RAISE_EXCEPTION;
497: WHEN OTHERS THEN
498: IF (SQLCODE <> -20001) THEN
499: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
500: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
501: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
502: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
503: END IF;
504: APP_EXCEPTION.RAISE_EXCEPTION;
505: END isMissingReceiptsShortpay;
498: IF (SQLCODE <> -20001) THEN
499: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
500: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
501: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'isMissingReceiptsShortpay');
502: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
503: END IF;
504: APP_EXCEPTION.RAISE_EXCEPTION;
505: END isMissingReceiptsShortpay;
506:
819:
820: EXCEPTION
821: WHEN OTHERS THEN
822: IF (SQLCODE <> -20001) THEN
823: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
824: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
825: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
827: END IF;
820: EXCEPTION
821: WHEN OTHERS THEN
822: IF (SQLCODE <> -20001) THEN
823: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
824: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
825: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
827: END IF;
828: APP_EXCEPTION.RAISE_EXCEPTION;
821: WHEN OTHERS THEN
822: IF (SQLCODE <> -20001) THEN
823: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
824: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
825: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
827: END IF;
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: END InitOieAmeNotifGT;
822: IF (SQLCODE <> -20001) THEN
823: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
824: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
825: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeNotifGT');
826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
827: END IF;
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: END InitOieAmeNotifGT;
830:
948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF (SQLCODE <> -20001) THEN
952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
956: END IF;
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF (SQLCODE <> -20001) THEN
952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
956: END IF;
957: APP_EXCEPTION.RAISE_EXCEPTION;
950: WHEN OTHERS THEN
951: IF (SQLCODE <> -20001) THEN
952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
956: END IF;
957: APP_EXCEPTION.RAISE_EXCEPTION;
958: END InitOieAmeApproverAmtGT;
951: IF (SQLCODE <> -20001) THEN
952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'InitOieAmeApproverAmtGT');
955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
956: END IF;
957: APP_EXCEPTION.RAISE_EXCEPTION;
958: END InitOieAmeApproverAmtGT;
959: