6: -- Type : Public
7: -- Function :
8: ************************************************************************************/
9: FUNCTION is_pim_installed RETURN BOOLEAN IS
10: l_pimdl_profile_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
11: BEGIN
12: l_pimdl_profile_value := FND_PROFILE.value('EGO_ENABLE_PIMDL');
13: IF (l_pimdl_profile_value = 1) THEN
14: RETURN TRUE;
8: ************************************************************************************/
9: FUNCTION is_pim_installed RETURN BOOLEAN IS
10: l_pimdl_profile_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
11: BEGIN
12: l_pimdl_profile_value := FND_PROFILE.value('EGO_ENABLE_PIMDL');
13: IF (l_pimdl_profile_value = 1) THEN
14: RETURN TRUE;
15: ELSE
16: RETURN FALSE;
482: l_user_id NUMBER(15);
483: l_resp_id NUMBER(15);
484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
483: l_resp_id NUMBER(15);
484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
496: l_timeout NUMBER;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
496: l_timeout NUMBER;
497: BEGIN
498: IF p_name_value_tbl IS NOT NULL AND p_name_value_tbl.COUNT>0
499: THEN
583: FUNCTION debug_status
584: RETURN boolean
585: IS
586: BEGIN
587: IF (fnd_profile.value('INV_EBI_DEBUG') = 'Y') THEN
588: RETURN true;
589: ELSE
590: RETURN false;
591: END IF;
599: -- Desc:
600: -- -----------------------------------------------------------------
601: PROCEDURE setup(
602: p_filename VARCHAR2 Default NULL) IS
603: l_path varchar2(200) := FND_PROFILE.value('INV_EBI_DEBUG_DIRECTORY');
604: BEGIN
605: INV_EBI_UTIL.g_debug := debug_status;
606:
607: IF (INV_EBI_UTIL.g_debug) THEN