DBA Data[Home] [Help]

APPS.INV_CALCULATE_EXP_DATE dependencies on FND_PROFILE

Line 5: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1: PACKAGE BODY INV_CALCULATE_EXP_DATE AS
2: /* $Header: INVCEDTB.pls 120.6.12020000.2 2012/07/09 08:04:02 asugandh ship $ */
3:
4: g_pkg_name VARCHAR2(80) := 'INV_CALCULATE_EXP_DATE';
5: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6:
7: PROCEDURE mydebug( p_msg IN VARCHAR2
8: ,p_module IN VARCHAR2 DEFAULT NULL)
9: IS

Line 899: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

895: ,p_table IN NUMBER
896: )IS
897: l_date_format VARCHAR2(30);
898: BEGIN
899: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
900: IF ((l_debug = 1) AND (p_table = 2 )) THEN
901: mydebug(' TRANSACTION_HEADER_ID '||p_mmtt_trx_rec.TRANSACTION_HEADER_ID);
902: mydebug(' TRANSACTION_TEMP_ID '||p_mmtt_trx_rec.TRANSACTION_TEMP_ID);
903: mydebug(' SOURCE_CODE '||p_mmtt_trx_rec.SOURCE_CODE);