APPS.PON_RESPONSE_IMPORT_PKG dependencies on FND_PROFILE

Line 41: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

37:
38: g_attr_need_by_date_seq CONSTANT NUMBER := -10;
39:
40: -- These will be used for debugging the code
41: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
42: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_RESPONSE_IMPORT_PKG';
43: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
44:
45:

Line 488: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');

484: UPDATE pon_bid_attr_values_interface bai
485: SET bai.line_number = g_error_int
486: WHERE bai.batch_id = p_batch_id;
487:
488: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
489: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');
490: l_decimal_separator_character := SUBSTR(l_numeric_characters, 1, 1);
491: l_grouping_separator_character := SUBSTR(l_numeric_characters, 2, 1);
492:

Line 489: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');

485: SET bai.line_number = g_error_int
486: WHERE bai.batch_id = p_batch_id;
487:
488: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
489: l_numeric_characters := fnd_profile.value('ICX_NUMERIC_CHARACTERS');
490: l_decimal_separator_character := SUBSTR(l_numeric_characters, 1, 1);
491: l_grouping_separator_character := SUBSTR(l_numeric_characters, 2, 1);
492:
493: IF(l_numeric_characters IS NOT NULL) THEN