476: WHEN NO_DATA_FOUND THEN return FALSE;
477: WHEN OTHERS THEN
478: BEGIN
479: IF (SQLCODE <> -20001) THEN
480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
483: 'IsCustomCalculateEnabled');
484: FND_MESSAGE.SET_TOKEN('PARAMETERS',
477: WHEN OTHERS THEN
478: BEGIN
479: IF (SQLCODE <> -20001) THEN
480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
483: 'IsCustomCalculateEnabled');
484: FND_MESSAGE.SET_TOKEN('PARAMETERS',
485: 'None passed.');
478: BEGIN
479: IF (SQLCODE <> -20001) THEN
480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
483: 'IsCustomCalculateEnabled');
484: FND_MESSAGE.SET_TOKEN('PARAMETERS',
485: 'None passed.');
486: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
481: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
483: 'IsCustomCalculateEnabled');
484: FND_MESSAGE.SET_TOKEN('PARAMETERS',
485: 'None passed.');
486: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
487: APP_EXCEPTION.RAISE_EXCEPTION;
488: ELSE
482: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
483: 'IsCustomCalculateEnabled');
484: FND_MESSAGE.SET_TOKEN('PARAMETERS',
485: 'None passed.');
486: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
487: APP_EXCEPTION.RAISE_EXCEPTION;
488: ELSE
489: -- Do not need to set the token since it has been done in the
490: -- child process
517: WHEN NO_DATA_FOUND THEN
518: return FALSE;
519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
524: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
525: APP_EXCEPTION.RAISE_EXCEPTION;
518: return FALSE;
519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
524: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
525: APP_EXCEPTION.RAISE_EXCEPTION;
526: ELSE
519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
524: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
525: APP_EXCEPTION.RAISE_EXCEPTION;
526: ELSE
527: -- Do not need to set the token since it has been done in the
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
524: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
525: APP_EXCEPTION.RAISE_EXCEPTION;
526: ELSE
527: -- Do not need to set the token since it has been done in the
528: -- child process