eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_UTILITY_PKG

Line 12: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;

8: g_nl CONSTANT VARCHAR2 (1) := '
9: ';
10: g_insert_statement VARCHAR2(32000);
11: g_ln_item_vs_id NUMBER;
12: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

Line 13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

9: ';
10: g_insert_statement VARCHAR2(32000);
11: g_ln_item_vs_id NUMBER;
12: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

Line 15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

11: g_ln_item_vs_id NUMBER;
12: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;
19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;

Line 16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

12: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;
19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;
20:

Line 17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

13: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;
19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;
20:
21: no_re_template_error EXCEPTION;

Line 18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;

14:
15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;
19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;
20:
21: no_re_template_error EXCEPTION;
22: no_suspense_template_error EXCEPTION;

Line 19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;

15: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
16: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
17: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
18: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').attribute_id;
19: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info ('LEDGER_ID-SOURCE_SYSTEM_CODE').version_id;
20:
21: no_re_template_error EXCEPTION;
22: no_suspense_template_error EXCEPTION;
23: init_mapping_error EXCEPTION;

Line 57: gcs_utility_pkg.g_module_enter

53: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
54: THEN
55: fnd_log.STRING (fnd_log.level_procedure,
56: g_pkg_name || '.' || l_api_name,
57: gcs_utility_pkg.g_module_enter
58: || ' p_source_ledger_id = ' || p_source_ledger_id
59: || ' '
60: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
61: );

Line 63: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

59: || ' '
60: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
61: );
62: END IF;
63: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
64: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
65: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
66: BEGIN
67: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 64: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;

60: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
61: );
62: END IF;
63: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
64: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
65: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
66: BEGIN
67: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
68: THEN

Line 65: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;

61: );
62: END IF;
63: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
64: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id;
65: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;
66: BEGIN
67: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
68: THEN
69: fnd_log.STRING (fnd_log.level_statement,

Line 113: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;

109: ''STAT'',
110: :l_stat_entry_id,
111: :l_entry_id), fb.cal_period_id, ';
112: l_group_text := ' GROUP BY ';
113: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
114: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
115: LOOP
116: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
117: AND (l_index_column_name <> 'ENTITY_ID')

Line 114: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )

110: :l_stat_entry_id,
111: :l_entry_id), fb.cal_period_id, ';
112: l_group_text := ' GROUP BY ';
113: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
114: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
115: LOOP
116: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
117: AND (l_index_column_name <> 'ENTITY_ID')
118: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = 'Y')

Line 116: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)

112: l_group_text := ' GROUP BY ';
113: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
114: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
115: LOOP
116: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
117: AND (l_index_column_name <> 'ENTITY_ID')
118: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = 'Y')
119: )
120: THEN

Line 118: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = 'Y')

114: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
115: LOOP
116: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
117: AND (l_index_column_name <> 'ENTITY_ID')
118: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = 'Y')
119: )
120: THEN
121: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
122: THEN

Line 129: AND dimension_id = '||gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id);

125: ' SELECT value_set_id
126: INTO l_source_value_set_id
127: FROM fem_global_vs_combo_defs
128: WHERE global_vs_combo_id = '||l_source_global_vs_combo||'
129: AND dimension_id = '||gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id);
130: END IF;
131: SELECT value_set_id
132: INTO l_source_value_set_id
133: FROM fem_global_vs_combo_defs

Line 135: AND dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id;

131: SELECT value_set_id
132: INTO l_source_value_set_id
133: FROM fem_global_vs_combo_defs
134: WHERE global_vs_combo_id = l_source_global_vs_combo
135: AND dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id;
136:
137: IF ( (l_source_value_set_id IS NULL)
138: OR (l_source_value_set_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id)
139: )

Line 138: OR (l_source_value_set_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id)

134: WHERE global_vs_combo_id = l_source_global_vs_combo
135: AND dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id;
136:
137: IF ( (l_source_value_set_id IS NULL)
138: OR (l_source_value_set_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id)
139: )
140: THEN
141: g_insert_statement := g_insert_statement || 'fb.' || l_index_column_name || ', ';
142: GOTO next_loop;

Line 144: gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).detail_value_set_id := l_source_value_set_id;

140: THEN
141: g_insert_statement := g_insert_statement || 'fb.' || l_index_column_name || ', ';
142: GOTO next_loop;
143: ELSE
144: gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).detail_value_set_id := l_source_value_set_id;
145: l_mapping_required := 'Y';
146: END IF;
147:
148: BEGIN

Line 154: WHERE fxd.dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id

150: INTO l_hierarchy_obj_def_id
151: FROM fem_xdim_dimensions fxd,
152: fem_object_definition_b fod,
153: fem_cal_periods_attr fcpa
154: WHERE fxd.dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id
155: AND fxd.default_mvs_hierarchy_obj_id = fod.object_id
156: AND fcpa.cal_period_id = p_cal_period_id
157: AND fcpa.attribute_id = l_cal_attribute_id
158: AND fcpa.version_id = l_cal_version_id

Line 176: || gcs_utility_pkg.g_gcs_dimension_info ('NATURAL_ACCOUNT_ID').associated_value_set_id;

172: || ' AND fnah.parent_depth_num = fnah.child_depth_num - 1
173: AND fnah.child_value_set_id = ' || l_source_value_set_id || '
174: AND fnah.child_id = fb.NATURAL_ACCOUNT_ID
175: AND fnah.parent_value_set_id = '
176: || gcs_utility_pkg.g_gcs_dimension_info ('NATURAL_ACCOUNT_ID').associated_value_set_id;
177: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fnah.parent_id ');
178: ELSIF (l_index_column_name = 'COMPANY_COST_CENTER_ORG_ID')
179: THEN
180: l_cctr_map_required := TRUE;

Line 190: || gcs_utility_pkg.g_gcs_dimension_info ('COMPANY_COST_CENTER_ORG_ID').associated_value_set_id;

186: || ' AND fcoh.parent_depth_num = fcoh.child_depth_num - 1
187: AND fcoh.child_value_set_id = ' || l_source_value_set_id || '
188: AND fcoh.child_id = fb.COMPANY_COST_CENTER_ORG_ID
189: AND fcoh.parent_value_set_id = '
190: || gcs_utility_pkg.g_gcs_dimension_info ('COMPANY_COST_CENTER_ORG_ID').associated_value_set_id;
191: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fcoh.parent_id ');
192: ELSIF (l_index_column_name = 'INTERCOMPANY_ID')
193: THEN
194: g_insert_statement := g_insert_statement

Line 203: || gcs_utility_pkg.g_gcs_dimension_info ('INTERCOMPANY_ID').associated_value_set_id;

199: AND fcoh_inter.parent_depth_num = fcoh_inter.child_depth_num - 1
200: AND fcoh_inter.child_value_set_id = ' || l_source_value_set_id || '
201: AND fcoh_inter.child_id = fb.INTERCOMPANY_ID
202: AND fcoh_inter.parent_value_set_id = '
203: || gcs_utility_pkg.g_gcs_dimension_info ('INTERCOMPANY_ID').associated_value_set_id;
204: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fcoh_inter.parent_id ');
205: ELSIF (l_index_column_name = 'LINE_ITEM_ID')
206: THEN
207: g_insert_statement := g_insert_statement

Line 216: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;

212: AND flih.parent_depth_num = flih.child_depth_num - 1
213: AND flih.child_value_set_id = ' || l_source_value_set_id || '
214: AND flih.child_id = fb.LINE_ITEM_ID
215: AND flih.parent_value_set_id = '
216: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id;
217: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'flih.parent_id ');
218: g_ln_item_vs_id := l_source_value_set_id;
219: ELSIF (l_index_column_name = 'PRODUCT_ID')
220: THEN

Line 230: || gcs_utility_pkg.g_gcs_dimension_info ('PRODUCT_ID').associated_value_set_id;

226: AND fpdh.parent_depth_num = fpdh.child_depth_num - 1
227: AND fpdh.child_value_set_id = ' || l_source_value_set_id || '
228: AND fpdh.child_id = fb.PRODUCT_ID
229: AND fpdh.parent_value_set_id = '
230: || gcs_utility_pkg.g_gcs_dimension_info ('PRODUCT_ID').associated_value_set_id;
231: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fpdh.parent_id ');
232: ELSIF (l_index_column_name = 'PROJECT_ID')
233: THEN
234: g_insert_statement := g_insert_statement

Line 243: || gcs_utility_pkg.g_gcs_dimension_info ('PROJECT_ID').associated_value_set_id;

239: AND fpjh.parent_depth_num = fpjh.child_depth_num - 1
240: AND fpjh.child_value_set_id = ' || l_source_value_set_id || '
241: AND fpjh.child_id = fb.PROJECT_ID
242: AND fpjh.parent_value_set_id = '
243: || gcs_utility_pkg.g_gcs_dimension_info ('PROJECT_ID').associated_value_set_id;
244: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fpjh.parent_id ');
245: ELSIF (l_index_column_name = 'CHANNEL_ID')
246: THEN
247: g_insert_statement := g_insert_statement

Line 256: || gcs_utility_pkg.g_gcs_dimension_info ('CHANNEL_ID').associated_value_set_id;

252: AND fchh.parent_depth_num = fchh.child_depth_num - 1
253: AND fchh.child_value_set_id = ' || l_source_value_set_id || '
254: AND fchh.child_id = fb.CHANNEL_ID
255: AND fchh.parent_value_set_id = '
256: || gcs_utility_pkg.g_gcs_dimension_info ('CHANNEL_ID').associated_value_set_id;
257: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fchh.parent_id ');
258: ELSIF (l_index_column_name = 'CUSTOMER_ID')
259: THEN
260: g_insert_statement := g_insert_statement

Line 269: || gcs_utility_pkg.g_gcs_dimension_info ('CUSTOMER_ID').associated_value_set_id;

265: AND fcuh.parent_depth_num = fcuh.child_depth_num - 1
266: AND fcuh.child_value_set_id = ' || l_source_value_set_id || '
267: AND fcuh.child_id = fb.CUSTOMER_ID
268: AND fcuh.parent_value_set_id = '
269: || gcs_utility_pkg.g_gcs_dimension_info ('CUSTOMER_ID').associated_value_set_id;
270: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fcuh.parent_id ');
271: ELSIF (l_index_column_name = 'USER_DIM1_ID')
272: THEN
273: g_insert_statement := g_insert_statement

Line 282: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM1_ID').associated_value_set_id;

278: AND fud1h.parent_depth_num = fud1h.child_depth_num - 1
279: AND fud1h.child_value_set_id = ' || l_source_value_set_id || '
280: AND fud1h.child_id = fb.USER_DIM1_ID
281: AND fud1h.parent_value_set_id = '
282: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM1_ID').associated_value_set_id;
283: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud1h.parent_id ');
284: ELSIF (l_index_column_name = 'USER_DIM2_ID')
285: THEN
286: g_insert_statement := g_insert_statement

Line 295: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM2_ID').associated_value_set_id;

291: AND fud2h.parent_depth_num = fud2h.child_depth_num - 1
292: AND fud2h.child_value_set_id = ' || l_source_value_set_id || '
293: AND fud2h.child_id = fb.USER_DIM2_ID
294: AND fud2h.parent_value_set_id = '
295: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM2_ID').associated_value_set_id;
296: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud2h.parent_id ');
297: ELSIF (l_index_column_name = 'USER_DIM3_ID')
298: THEN
299: g_insert_statement := g_insert_statement

Line 308: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM3_ID').associated_value_set_id;

304: AND fud3h.parent_depth_num = fud3h.child_depth_num - 1
305: AND fud3h.child_value_set_id = ' || l_source_value_set_id || '
306: AND fud3h.child_id = fb.USER_DIM3_ID
307: AND fud3h.parent_value_set_id = '
308: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM3_ID').associated_value_set_id;
309: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud3h.parent_id ');
310: ELSIF (l_index_column_name = 'USER_DIM4_ID')
311: THEN
312: g_insert_statement := g_insert_statement

Line 321: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM4_ID').associated_value_set_id;

317: AND fud4h.parent_depth_num = fud4h.child_depth_num - 1
318: AND fud4h.child_value_set_id = ' || l_source_value_set_id || '
319: AND fud4h.child_id = fb.USER_DIM4_ID
320: AND fud4h.parent_value_set_id = '
321: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM4_ID').associated_value_set_id;
322: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud4h.parent_id ');
323: ELSIF (l_index_column_name = 'USER_DIM5_ID')
324: THEN
325: g_insert_statement := g_insert_statement

Line 334: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM5_ID').associated_value_set_id;

330: AND fud5h.parent_depth_num = fud5h.child_depth_num - 1
331: AND fud5h.child_value_set_id = ' || l_source_value_set_id || '
332: AND fud5h.child_id = fb.USER_DIM5_ID
333: AND fud5h.parent_value_set_id = '
334: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM5_ID').associated_value_set_id;
335: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud5h.parent_id ');
336: ELSIF (l_index_column_name = 'USER_DIM6_ID')
337: THEN
338: g_insert_statement := g_insert_statement

Line 347: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM6_ID').associated_value_set_id;

343: AND fud6h.parent_depth_num = fud6h.child_depth_num - 1
344: AND fud6h.child_value_set_id = ' || l_source_value_set_id || '
345: AND fud6h.child_id = fb.USER_DIM6_ID
346: AND fud6h.parent_value_set_id = '
347: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM6_ID').associated_value_set_id;
348: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud7h.parent_id ');
349: ELSIF (l_index_column_name = 'USER_DIM7_ID')
350: THEN
351: g_insert_statement := g_insert_statement

Line 360: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM7_ID').associated_value_set_id;

356: AND fud7h.parent_depth_num = fud7h.child_depth_num - 1
357: AND fud7h.child_value_set_id = ' || l_source_value_set_id || '
358: AND fud7h.child_id = fb.USER_DIM7_ID
359: AND fud7h.parent_value_set_id = '
360: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM7_ID').associated_value_set_id;
361: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud7h.parent_id ');
362: ELSIF (l_index_column_name = 'USER_DIM8_ID')
363: THEN
364: g_insert_statement := g_insert_statement

Line 373: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM8_ID').associated_value_set_id;

369: AND fud8h.parent_depth_num = fud8h.child_depth_num - 1
370: AND fud8h.child_value_set_id = ' || l_source_value_set_id || '
371: AND fud8h.child_id = fb.USER_DIM8_ID
372: AND fud8h.parent_value_set_id = '
373: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM8_ID').associated_value_set_id;
374: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud8h.parent_id ');
375: ELSIF (l_index_column_name = 'USER_DIM9_ID')
376: THEN
377: g_insert_statement := g_insert_statement

Line 386: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM9_ID').associated_value_set_id;

382: AND fud9h.parent_depth_num = fud9h.child_depth_num - 1
383: AND fud9h.child_value_set_id = ' || l_source_value_set_id || '
384: AND fud9h.child_id = fb.USER_DIM9_ID
385: AND fud9h.parent_value_set_id = '
386: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM9_ID').associated_value_set_id;
387: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud9h.parent_id ');
388: ELSIF (l_index_column_name = 'USER_DIM10_ID')
389: THEN
390: g_insert_statement := g_insert_statement

Line 399: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM10_ID').associated_value_set_id;

395: AND fud10h.parent_depth_num = fud10h.child_depth_num - 1
396: AND fud10h.child_value_set_id = ' || l_source_value_set_id || '
397: AND fud10h.child_id = fb.USER_DIM10_ID
398: AND fud10h.parent_value_set_id = '
399: || gcs_utility_pkg.g_gcs_dimension_info ('USER_DIM10_ID').associated_value_set_id;
400: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud10h.parent_id ');
401: END IF;
402: END IF;
403: <>

Line 404: l_index_column_name :=gcs_utility_pkg.g_gcs_dimension_info.NEXT (l_index_column_name);

400: l_group_text := replace(l_group_text, 'fb.'||l_index_column_name, 'fud10h.parent_id ');
401: END IF;
402: END IF;
403: <>
404: l_index_column_name :=gcs_utility_pkg.g_gcs_dimension_info.NEXT (l_index_column_name);
405: END LOOP;
406:
407: IF (p_inc_mode_flag = 'Y') THEN
408: g_insert_statement := g_insert_statement || '

Line 431: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id

427: '
428: WHERE fb.ledger_id = :p_source_ledger_id
429: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER
430: AND fla.ledger_id = fb.ledger_id
431: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id
432: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id
433: AND fb.company_cost_center_org_id = geco.company_cost_center_org_id
434: AND geco.entity_id = :p_entity_id
435: AND :p_balance_type_code = DECODE(fb.financial_elem_id, 140, ''ADB'', ''ACTUAL'')

Line 432: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id

428: WHERE fb.ledger_id = :p_source_ledger_id
429: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER
430: AND fla.ledger_id = fb.ledger_id
431: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id
432: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id
433: AND fb.company_cost_center_org_id = geco.company_cost_center_org_id
434: AND geco.entity_id = :p_entity_id
435: AND :p_balance_type_code = DECODE(fb.financial_elem_id, 140, ''ADB'', ''ACTUAL'')
436: AND ((fb.currency_type_code = ''TRANSLATED'' AND fb.currency_code in (''STAT'', :p_source_currency_code))

Line 495: retcode := gcs_utility_pkg.g_ret_sts_success;

491: END IF;
492: g_insert_statement := g_insert_statement
493: || l_from_text
494: || l_where_text;
495: retcode := gcs_utility_pkg.g_ret_sts_success;
496: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
497: THEN
498: fnd_log.STRING (fnd_log.level_procedure,
499: g_pkg_name || '.' || l_api_name,

Line 500: gcs_utility_pkg.g_module_success

496: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
497: THEN
498: fnd_log.STRING (fnd_log.level_procedure,
499: g_pkg_name || '.' || l_api_name,
500: gcs_utility_pkg.g_module_success
501: || ' Mapping Required : '
502: || l_mapping_required
503: || ' '
504: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 510: retcode := gcs_utility_pkg.g_ret_sts_error;

506: END IF;
507: RETURN l_mapping_required;
508: EXCEPTION
509: WHEN gcs_dp_no_hier_obj_def_id THEN
510: retcode := gcs_utility_pkg.g_ret_sts_error;
511: fnd_message.set_name('GCS', 'GCS_DP_NO_HIER_OBJ_DEF_ERR');
512: fnd_message.set_token('DIMENSION', l_index_column_name);
513: errbuf := fnd_message.get;
514: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

Line 518: gcs_utility_pkg.g_module_failure

514: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
515: THEN
516: fnd_log.STRING (fnd_log.level_error,
517: g_pkg_name || '.' || l_api_name,
518: gcs_utility_pkg.g_module_failure
519: || ' '
520: || errbuf
521: || ' ' || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
522: );

Line 526: retcode := gcs_utility_pkg.g_ret_sts_error;

522: );
523: END IF;
524: RETURN retcode;
525: WHEN global_vs_id_error THEN
526: retcode := gcs_utility_pkg.g_ret_sts_error;
527: FND_MESSAGE.set_name('GCS', 'GCS_DP_GLOBAL_VS_ERR');
528: errbuf := fnd_message.get;
529: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
530: THEN

Line 533: gcs_utility_pkg.g_module_failure

529: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
530: THEN
531: fnd_log.STRING (fnd_log.level_error,
532: g_pkg_name || '.' || l_api_name,
533: gcs_utility_pkg.g_module_failure
534: || ' '
535: || errbuf
536: || ' ' || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
537: );

Line 541: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;

537: );
538: END IF;
539: RETURN retcode;
540: WHEN OTHERS THEN
541: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;
542: FND_MESSAGE.set_name('GCS', 'GCS_DP_UNEXP_ERR');
543: errbuf := fnd_message.get;
544: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
545: THEN

Line 548: gcs_utility_pkg.g_module_failure

544: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
545: THEN
546: fnd_log.STRING (fnd_log.level_error,
547: g_pkg_name || '.' || l_api_name,
548: gcs_utility_pkg.g_module_failure
549: || ' '
550: || errbuf
551: || ' ' || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
552: );

Line 569: p_cal_period_record IN gcs_utility_pkg.r_cal_period_info,

565: p_hierarchy_id IN NUMBER,
566: p_entity_id IN NUMBER,
567: p_source_ledger_id IN NUMBER,
568: p_year_end_values_match IN VARCHAR2,
569: p_cal_period_record IN gcs_utility_pkg.r_cal_period_info,
570: p_balance_type_code IN VARCHAR2,
571: p_owner_percentage IN NUMBER,
572: p_run_detail_id IN NUMBER,
573: p_source_dataset_code IN NUMBER,

Line 598: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

594: l_periods_list DBMS_SQL.number_table;
595:
596: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
597:
598: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
599: .attribute_id;
600: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
601: .version_id ;
602:

Line 600: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

596: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
597:
598: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
599: .attribute_id;
600: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
601: .version_id ;
602:
603: -- Bugfix 6068527: Added account type attributes
604: l_line_item_type_attr NUMBER(15) :=

Line 605: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;

601: .version_id ;
602:
603: -- Bugfix 6068527: Added account type attributes
604: l_line_item_type_attr NUMBER(15) :=
605: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
606: l_line_item_type_version NUMBER(15) :=
607: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
608: l_acct_type_attr NUMBER(15) :=
609: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

Line 607: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;

603: -- Bugfix 6068527: Added account type attributes
604: l_line_item_type_attr NUMBER(15) :=
605: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
606: l_line_item_type_version NUMBER(15) :=
607: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
608: l_acct_type_attr NUMBER(15) :=
609: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
610: l_acct_type_version NUMBER(15) :=
611: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

Line 609: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;

605: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
606: l_line_item_type_version NUMBER(15) :=
607: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
608: l_acct_type_attr NUMBER(15) :=
609: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
610: l_acct_type_version NUMBER(15) :=
611: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
612:
613: BEGIN

Line 611: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;

607: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
608: l_acct_type_attr NUMBER(15) :=
609: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
610: l_acct_type_version NUMBER(15) :=
611: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
612:
613: BEGIN
614: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
615: THEN

Line 618: gcs_utility_pkg.g_module_enter

614: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
615: THEN
616: fnd_log.STRING (fnd_log.level_procedure,
617: g_pkg_name || '.' || l_api_name,
618: gcs_utility_pkg.g_module_enter
619: || ' p_source_currency_code = ' || p_source_currency_code
620: || ', p_target_cal_period_id = ' || p_target_cal_period_id
621: || ', p_max_period = ' || p_max_period
622: || ', p_currency_type_code = ' || p_currency_type_code

Line 642: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)

638: p_cal_period_id => p_cal_period_record.cal_period_id,
639: errbuf => errbuf,
640: retcode => retcode);
641:
642: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
643: THEN
644: RAISE init_mapping_error;
645: END IF;
646:

Line 1262: retcode := gcs_utility_pkg.g_ret_sts_success;

1258: p_entity_id => p_entity_id,
1259: p_pre_cal_period_id => p_cal_period_record.prev_cal_period_id,
1260: p_first_ever_data_prep => l_first_ever_data_prepped);
1261: END IF;
1262: retcode := gcs_utility_pkg.g_ret_sts_success;
1263: -- Suspense accounts
1264: IF l_entry_id IS NOT NULL
1265: THEN
1266: -- check balance criteria

Line 1371: retcode := gcs_utility_pkg.g_ret_sts_success;

1367: INTO retcode
1368: FROM gcs_entry_headers
1369: WHERE entry_id = l_proportional_entry_id;
1370: ELSE
1371: retcode := gcs_utility_pkg.g_ret_sts_success;
1372: END IF;
1373: gcs_cons_eng_run_dtls_pkg.update_entry_headers
1374: (p_run_detail_id => p_run_detail_id,
1375: p_entry_id => l_proportional_entry_id,

Line 1430: gcs_utility_pkg.g_module_success

1426: END IF;IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1427: THEN
1428: fnd_log.STRING (fnd_log.level_procedure,
1429: g_pkg_name || '.' || l_api_name,
1430: gcs_utility_pkg.g_module_success
1431: || ' '
1432: || l_api_name
1433: || '()'
1434: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1439: retcode := gcs_utility_pkg.g_ret_sts_error;

1435: );
1436: END IF;
1437: EXCEPTION
1438: WHEN no_suspense_template_error THEN
1439: retcode := gcs_utility_pkg.g_ret_sts_error;
1440: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_SUSPENSE_ERR');
1441: errbuf := fnd_message.get;
1442:
1443: DELETE FROM gcs_entry_headers

Line 1454: gcs_utility_pkg.g_module_failure

1450: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1451: THEN
1452: fnd_log.STRING (fnd_log.level_error,
1453: g_pkg_name || '.' || l_api_name,
1454: gcs_utility_pkg.g_module_failure
1455: || ' '
1456: || errbuf
1457: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1458: );

Line 1462: retcode := gcs_utility_pkg.g_ret_sts_error;

1458: );
1459: END IF;
1460: raise gcs_dp_proc_data_error;
1461: WHEN no_re_template_error THEN
1462: retcode := gcs_utility_pkg.g_ret_sts_error;
1463: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_RE_ERR');
1464: errbuf := fnd_message.get;
1465:
1466: DELETE FROM gcs_entry_headers

Line 1477: gcs_utility_pkg.g_module_failure

1473: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1474: THEN
1475: fnd_log.STRING (fnd_log.level_error,
1476: g_pkg_name || '.' || l_api_name,
1477: gcs_utility_pkg.g_module_failure
1478: || ' '
1479: || errbuf
1480: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1481: );

Line 1487: retcode := gcs_utility_pkg.g_ret_sts_warn;

1483: raise gcs_dp_proc_data_error;
1484: WHEN init_mapping_error THEN
1485: raise gcs_dp_proc_data_error;
1486: WHEN no_data_error THEN
1487: retcode := gcs_utility_pkg.g_ret_sts_warn;
1488: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_DATA_ERR');
1489: errbuf := fnd_message.get;
1490: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1491: fnd_log.STRING (fnd_log.level_error,

Line 1493: gcs_utility_pkg.g_module_failure

1489: errbuf := fnd_message.get;
1490: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1491: fnd_log.STRING (fnd_log.level_error,
1492: g_pkg_name || '.' || l_api_name,
1493: gcs_utility_pkg.g_module_failure
1494: || ' '
1495: || errbuf
1496: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1497: );

Line 1510: retcode := gcs_utility_pkg.g_ret_sts_error;

1506: p_bp_request_error_code => 'NOT_APPLICABLE'
1507: );
1508: -- bug 5071794 fix: catch unexpected error and reraise it
1509: WHEN others THEN
1510: retcode := gcs_utility_pkg.g_ret_sts_error;
1511: errbuf := SQLERRM;
1512:
1513: DELETE FROM gcs_entry_headers
1514: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 1523: gcs_utility_pkg.g_module_failure

1519:
1520: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1521: fnd_log.STRING (fnd_log.level_error,
1522: g_pkg_name || '.' || l_api_name,
1523: gcs_utility_pkg.g_module_failure
1524: || ' '
1525: || errbuf
1526: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1527: );

Line 1568: gcs_utility_pkg.g_module_enter

1564: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1565: THEN
1566: fnd_log.STRING (fnd_log.level_procedure,
1567: g_pkg_name || '.' || l_api_name,
1568: gcs_utility_pkg.g_module_enter
1569: || ' '
1570: || l_api_name
1571: || '()'
1572: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1582: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)

1578: p_cal_period_id => p_target_cal_period_id,
1579: errbuf => errbuf,
1580: retcode => retcode,
1581: p_inc_mode_flag => 'Y');
1582: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
1583: THEN
1584: RAISE init_mapping_error;
1585: END IF;
1586: SELECT gcs_entry_headers_s.NEXTVAL

Line 1883: retcode := gcs_utility_pkg.g_ret_sts_success;

1879: p_category_code => 'DATAPREPARATION'
1880: );
1881: END IF;
1882: END IF;
1883: retcode := gcs_utility_pkg.g_ret_sts_success;
1884: -- Suspense accounts
1885: IF x_entry_id IS NOT NULL
1886: THEN
1887: -- check balance criteria

Line 1921: SELECT DECODE(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)

1917: p_entity_id => p_entity_id,
1918: p_threshold => l_threshold,
1919: p_threshold_currency_code => l_threshold_currency
1920: );
1921: SELECT DECODE(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)
1922: INTO retcode
1923: FROM gcs_entry_headers
1924: WHERE entry_id = x_entry_id;
1925: END IF;

Line 1969: SELECT decode(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)

1965: p_threshold => l_threshold,
1966: p_threshold_currency_code => l_threshold_currency
1967: );
1968:
1969: SELECT decode(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)
1970: INTO retcode
1971: FROM gcs_entry_headers
1972: WHERE entry_id = x_prop_entry_id;
1973: ELSE

Line 1974: retcode := gcs_utility_pkg.g_ret_sts_success;

1970: INTO retcode
1971: FROM gcs_entry_headers
1972: WHERE entry_id = x_prop_entry_id;
1973: ELSE
1974: retcode := gcs_utility_pkg.g_ret_sts_success;
1975: END IF;
1976: END IF;
1977:
1978: -- Check the GCS_SYSTEM_OPTIONS.INTERCO_MAP_ENABLED_FLAG.

Line 2016: gcs_utility_pkg.g_module_success

2012: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
2013: THEN
2014: fnd_log.STRING (fnd_log.level_procedure,
2015: g_pkg_name || '.' || l_api_name,
2016: gcs_utility_pkg.g_module_success
2017: || ' '
2018: || l_api_name
2019: || '()'
2020: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 2025: retcode := gcs_utility_pkg.g_ret_sts_error;

2021: );
2022: END IF;
2023: EXCEPTION
2024: WHEN no_suspense_template_error THEN
2025: retcode := gcs_utility_pkg.g_ret_sts_error;
2026: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_SUSPENSE_ERR');
2027: errbuf := fnd_message.get;
2028: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2029: THEN

Line 2032: gcs_utility_pkg.g_module_failure

2028: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2029: THEN
2030: fnd_log.STRING (fnd_log.level_error,
2031: g_pkg_name || '.' || l_api_name,
2032: gcs_utility_pkg.g_module_failure
2033: || ' '
2034: || errbuf
2035: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
2036: );

Line 2040: retcode := gcs_utility_pkg.g_ret_sts_error;

2036: );
2037: END IF;
2038: raise gcs_dp_proc_data_error;
2039: WHEN no_re_template_error THEN
2040: retcode := gcs_utility_pkg.g_ret_sts_error;
2041: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_RE_ERR');
2042: errbuf := fnd_message.get;
2043: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2044: THEN

Line 2047: gcs_utility_pkg.g_module_failure

2043: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2044: THEN
2045: fnd_log.STRING (fnd_log.level_error,
2046: g_pkg_name || '.' || l_api_name,
2047: gcs_utility_pkg.g_module_failure
2048: || ' '
2049: || errbuf
2050: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
2051: );

Line 2057: retcode := gcs_utility_pkg.g_ret_sts_warn;

2053: raise gcs_dp_proc_data_error;
2054: WHEN init_mapping_error THEN
2055: raise gcs_dp_proc_data_error;
2056: WHEN no_data_error THEN
2057: retcode := gcs_utility_pkg.g_ret_sts_warn;
2058: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_DATA_ERR');
2059: errbuf := fnd_message.get;
2060: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2061: fnd_log.STRING (fnd_log.level_error,

Line 2063: gcs_utility_pkg.g_module_failure

2059: errbuf := fnd_message.get;
2060: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2061: fnd_log.STRING (fnd_log.level_error,
2062: g_pkg_name || '.' || l_api_name,
2063: gcs_utility_pkg.g_module_failure
2064: || ' '
2065: || errbuf
2066: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
2067: );