496: WHEN NO_DATA_FOUND THEN return FALSE;
497: WHEN OTHERS THEN
498: BEGIN
499: IF (SQLCODE <> -20001) THEN
500: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
501: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
502: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
497: WHEN OTHERS THEN
498: BEGIN
499: IF (SQLCODE <> -20001) THEN
500: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
501: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
502: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
505: 'None passed.');
498: BEGIN
499: IF (SQLCODE <> -20001) THEN
500: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
501: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
502: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
505: 'None passed.');
506: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
500: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
501: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
502: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
505: 'None passed.');
506: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
507: APP_EXCEPTION.RAISE_EXCEPTION;
508: ELSE
502: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
505: 'None passed.');
506: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
507: APP_EXCEPTION.RAISE_EXCEPTION;
508: ELSE
509: -- Do not need to set the token since it has been done in the
510: -- child process
537: WHEN NO_DATA_FOUND THEN
538: return FALSE;
539: WHEN OTHERS THEN
540: IF (SQLCODE <> -20001) THEN
541: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
542: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
543: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
545: APP_EXCEPTION.RAISE_EXCEPTION;
538: return FALSE;
539: WHEN OTHERS THEN
540: IF (SQLCODE <> -20001) THEN
541: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
542: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
543: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: ELSE
539: WHEN OTHERS THEN
540: IF (SQLCODE <> -20001) THEN
541: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
542: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
543: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: ELSE
547: -- Do not need to set the token since it has been done in the
540: IF (SQLCODE <> -20001) THEN
541: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
542: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
543: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: ELSE
547: -- Do not need to set the token since it has been done in the
548: -- child process