39: RETURN 'Y';
40: END IF;
41: EXCEPTION
42: WHEN OTHERS THEN
43: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
44: fnd_message.set_token('ERROR',sqlerrm);
45: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.EBD_CHECK');
46: fnd_message.set_token('PARAMETERS','X_BATCH_NAME = '||x_batch_name||' X_INVOICE_ID = '||to_char(x_invoice_id)||' X_CHECK_DATE = '||to_char(x_check_date,'dd-MM-YYYY')||' X_INV_DUE_DATE = '||to_char(x_inv_due_date,'dd-MON-YYYY'));
47: fnd_message.set_token('DEBUG_INFO','FV EBD Code Hook');
40: END IF;
41: EXCEPTION
42: WHEN OTHERS THEN
43: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
44: fnd_message.set_token('ERROR',sqlerrm);
45: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.EBD_CHECK');
46: fnd_message.set_token('PARAMETERS','X_BATCH_NAME = '||x_batch_name||' X_INVOICE_ID = '||to_char(x_invoice_id)||' X_CHECK_DATE = '||to_char(x_check_date,'dd-MM-YYYY')||' X_INV_DUE_DATE = '||to_char(x_inv_due_date,'dd-MON-YYYY'));
47: fnd_message.set_token('DEBUG_INFO','FV EBD Code Hook');
48: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
41: EXCEPTION
42: WHEN OTHERS THEN
43: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
44: fnd_message.set_token('ERROR',sqlerrm);
45: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.EBD_CHECK');
46: fnd_message.set_token('PARAMETERS','X_BATCH_NAME = '||x_batch_name||' X_INVOICE_ID = '||to_char(x_invoice_id)||' X_CHECK_DATE = '||to_char(x_check_date,'dd-MM-YYYY')||' X_INV_DUE_DATE = '||to_char(x_inv_due_date,'dd-MON-YYYY'));
47: fnd_message.set_token('DEBUG_INFO','FV EBD Code Hook');
48: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
49:
42: WHEN OTHERS THEN
43: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
44: fnd_message.set_token('ERROR',sqlerrm);
45: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.EBD_CHECK');
46: fnd_message.set_token('PARAMETERS','X_BATCH_NAME = '||x_batch_name||' X_INVOICE_ID = '||to_char(x_invoice_id)||' X_CHECK_DATE = '||to_char(x_check_date,'dd-MM-YYYY')||' X_INV_DUE_DATE = '||to_char(x_inv_due_date,'dd-MON-YYYY'));
47: fnd_message.set_token('DEBUG_INFO','FV EBD Code Hook');
48: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
49:
50: app_exception.raise_exception;
43: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
44: fnd_message.set_token('ERROR',sqlerrm);
45: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.EBD_CHECK');
46: fnd_message.set_token('PARAMETERS','X_BATCH_NAME = '||x_batch_name||' X_INVOICE_ID = '||to_char(x_invoice_id)||' X_CHECK_DATE = '||to_char(x_check_date,'dd-MM-YYYY')||' X_INV_DUE_DATE = '||to_char(x_inv_due_date,'dd-MON-YYYY'));
47: fnd_message.set_token('DEBUG_INFO','FV EBD Code Hook');
48: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
49:
50: app_exception.raise_exception;
51:
143: l_module_name,'FV Interest Amount is NULL');
144:
145: WHEN OTHERS THEN
146:
147: fnd_message.set_name('SQLAP','AP_DEBUG');
148: fnd_message.set_token('ERROR',sqlerrm);
149: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.FV_CALCULATE_INTEREST');
150: fnd_message.set_token('PARAMETERS','X_INVOICE_ID = '||x_invoice_id||' X_CHECK_DATE = '||to_char(x_check_date));
151: fnd_message.set_token('DEBUG_INFO','FV INTEREST Code Hook');
144:
145: WHEN OTHERS THEN
146:
147: fnd_message.set_name('SQLAP','AP_DEBUG');
148: fnd_message.set_token('ERROR',sqlerrm);
149: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.FV_CALCULATE_INTEREST');
150: fnd_message.set_token('PARAMETERS','X_INVOICE_ID = '||x_invoice_id||' X_CHECK_DATE = '||to_char(x_check_date));
151: fnd_message.set_token('DEBUG_INFO','FV INTEREST Code Hook');
152: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
145: WHEN OTHERS THEN
146:
147: fnd_message.set_name('SQLAP','AP_DEBUG');
148: fnd_message.set_token('ERROR',sqlerrm);
149: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.FV_CALCULATE_INTEREST');
150: fnd_message.set_token('PARAMETERS','X_INVOICE_ID = '||x_invoice_id||' X_CHECK_DATE = '||to_char(x_check_date));
151: fnd_message.set_token('DEBUG_INFO','FV INTEREST Code Hook');
152: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
153: l_module_name,'Error in Calculating FV Interest Amount');
146:
147: fnd_message.set_name('SQLAP','AP_DEBUG');
148: fnd_message.set_token('ERROR',sqlerrm);
149: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.FV_CALCULATE_INTEREST');
150: fnd_message.set_token('PARAMETERS','X_INVOICE_ID = '||x_invoice_id||' X_CHECK_DATE = '||to_char(x_check_date));
151: fnd_message.set_token('DEBUG_INFO','FV INTEREST Code Hook');
152: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
153: l_module_name,'Error in Calculating FV Interest Amount');
154:
147: fnd_message.set_name('SQLAP','AP_DEBUG');
148: fnd_message.set_token('ERROR',sqlerrm);
149: fnd_message.set_token('CALLING_SEQUENCE','FV_ECON_BENF_DISC.FV_CALCULATE_INTEREST');
150: fnd_message.set_token('PARAMETERS','X_INVOICE_ID = '||x_invoice_id||' X_CHECK_DATE = '||to_char(x_check_date));
151: fnd_message.set_token('DEBUG_INFO','FV INTEREST Code Hook');
152: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
153: l_module_name,'Error in Calculating FV Interest Amount');
154:
155: app_exception.raise_exception;