1: PACKAGE BODY FII_SETUP_VAL_C AS
2: /* $Header: FIISVALB.pls 120.2.12000000.3 2007/10/16 04:05:05 wywong noship $ */
3:
4: g_retcode VARCHAR2(20) := NULL;
5: g_phase VARCHAR2(120);
73:
74: EXCEPTION
75: WHEN others THEN
76: fii_util.write_log('Exception in detect_unmapped_local_vs: ' || sqlerrm );
77: fii_message.func_fail('FII_SETUP_VAL_C.detect_unmapped_local_vs');
78: RETURN -1;
79: END detect_unmapped_local_vs;
80:
81: -------------------------------------------------------------------------------
158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: fii_util.write_log('Exception in find_dup_ccc_org: ' || sqlerrm );
162: fii_message.func_fail('FII_SETUP_VAL_C.find_dup_ccc_org');
163: RETURN -1;
164:
165: END FIND_DUP_CCC_ORG;
166:
383: -- 08-30-06 W Wong Created
384: -- Arguments
385: -- X_User User Name used for checking user setup
386: -- Example
387: -- result := FII_SETUP_VAL_C.Main(Errbuf, Retcode, X_User);
388: -- Notes
389: --
390: PROCEDURE Main (Errbuf IN OUT NOCOPY VARCHAR2,
391: Retcode IN OUT NOCOPY VARCHAR2,
1153: fii_util.put_line('Dimension Enabled: '|| l_dim_name);
1154: fii_util.put_line('--------------------------------------------------');
1155:
1156: -- Check if we have unmapped local value set for this dimension
1157: l_cnt := FII_SETUP_VAL_C.detect_unmapped_local_vs(l_dim_short_name);
1158:
1159: fii_util.put_line(' ');
1160: IF l_cnt > 0 THEN
1161: fii_util.put_line('DIAGNOSIS: Please map the above Local Value Sets to a Master Value Set');
2290:
2291: END Main;
2292:
2293:
2294: END FII_SETUP_VAL_C;