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.

[Home] [Help]

APPS.GCS_DATA_PREP_PKG dependencies on GCS_UTILITY_PKG

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

38: fnd_file.put_line(fnd_file.log, 'p_suffix := ' || p_suffix);
39: fnd_file.put_line(fnd_file.log, 'p_repeat_flag := ' || p_repeat_flag);
40: fnd_file.put_line(fnd_file.log, 'Beginning of parameters ');
41: fnd_file.put_line(fnd_file.log, 'End of parameters ');
42: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
43: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST) LOOP
44: IF (l_index_column_name <> 'ENTITY_ID' AND
45: gcs_utility_pkg.g_gcs_dimension_info(l_index_column_name)
46: .required_for_gcs = 'Y') THEN

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

39: fnd_file.put_line(fnd_file.log, 'p_repeat_flag := ' || p_repeat_flag);
40: fnd_file.put_line(fnd_file.log, 'Beginning of parameters ');
41: fnd_file.put_line(fnd_file.log, 'End of parameters ');
42: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
43: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST) LOOP
44: IF (l_index_column_name <> 'ENTITY_ID' AND
45: gcs_utility_pkg.g_gcs_dimension_info(l_index_column_name)
46: .required_for_gcs = 'Y') THEN
47: IF (l_dim_text IS NULL) THEN

Line 45: gcs_utility_pkg.g_gcs_dimension_info(l_index_column_name)

41: fnd_file.put_line(fnd_file.log, 'End of parameters ');
42: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
43: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST) LOOP
44: IF (l_index_column_name <> 'ENTITY_ID' AND
45: gcs_utility_pkg.g_gcs_dimension_info(l_index_column_name)
46: .required_for_gcs = 'Y') THEN
47: IF (l_dim_text IS NULL) THEN
48: IF (p_repeat_flag = 'Y') THEN
49: l_dim_text := p_prefix || l_index_column_name || p_suffix ||

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

61: p_suffix || ', ';
62: END IF;
63: END IF;
64: END IF;
65: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.NEXT(l_index_column_name);
66: END LOOP;
67: fnd_file.put_line(fnd_file.log, 'l_dim_text := ' || l_dim_text);
68: fnd_file.put_line(fnd_file.log,
69: 'GCS_DATA_PREP_PKG::get_dimension_text -- Exit');

Line 171: -- p_cal_period_record gcs_utility_pkg.r_cal_period_info

167: -- source_cal_period_id = target_cal_period_id.
168: -- Arguments
169: -- p_source_ledger_id Source ledger Identifier
170: -- p_target_cal_period_id Target Calendar Period Identifier
171: -- p_cal_period_record gcs_utility_pkg.r_cal_period_info
172: -- p_year_end_values_match Detects if Source/Target Calendar Year Ends Match
173: -- p_entity_id Entity Identifier
174: -- p_prior_cal_period_id Previous Period
175: -- Notes

Line 180: p_cal_period_record OUT NOCOPY gcs_utility_pkg.r_cal_period_info,

176: --
177: PROCEDURE explode_calendar_map(p_source_ledger_id IN NUMBER,
178: p_target_cal_period_id IN NUMBER,
179: p_balance_type_code IN VARCHAR2,
180: p_cal_period_record OUT NOCOPY gcs_utility_pkg.r_cal_period_info,
181: p_year_end_values_match OUT NOCOPY VARCHAR2,
182: p_entity_id IN NUMBER,
183: p_prior_cal_period_id OUT NOCOPY NUMBER) IS
184: l_cnt NUMBER(15);

Line 194: gcs_utility_pkg.g_module_enter ||

190: BEGIN
191: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
192: fnd_log.STRING(fnd_log.level_procedure,
193: g_pkg_name || '.' || l_api_name,
194: gcs_utility_pkg.g_module_enter ||
195: ' p_source_ledger_id = ' || p_source_ledger_id ||
196: ' p_target_cal_period_id = ' || p_target_cal_period_id ||
197: ' p_balance_type_code = ' || p_balance_type_code || ' ' ||
198: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 200: gcs_utility_pkg.get_cal_period_details(p_target_cal_period_id,

196: ' p_target_cal_period_id = ' || p_target_cal_period_id ||
197: ' p_balance_type_code = ' || p_balance_type_code || ' ' ||
198: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
199: END IF;
200: gcs_utility_pkg.get_cal_period_details(p_target_cal_period_id,
201: p_cal_period_record);
202:
203: -- Bugfix 6037112: Checking if calendar mapping is required
204: check_calendar_map_required(p_entity_id => p_entity_id,

Line 234: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

230: p_balance_type_code || '''
231: AND fdl.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER ' || '
232: AND fla.ledger_id = fdl.ledger_id' || '
233: AND fla.attribute_id = ' ||
234: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
235: .attribute_id || '
236: AND fla.version_id = ' ||
237: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
238: .version_id || '

Line 237: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

233: AND fla.attribute_id = ' ||
234: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
235: .attribute_id || '
236: AND fla.version_id = ' ||
237: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
238: .version_id || '
239: AND gcpmd.cal_period_map_id = gcpm.cal_period_map_id
240: AND fcpb_src.cal_period_id = fdl.cal_period_id
241: AND gcpm.source_calendar_id = fcpb_src.calendar_id

Line 250: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

246: AND gcpm.target_dimension_group_id = fcpb_tgt.dimension_group_id
247: AND fdl.cal_period_id = fcpa_number.cal_period_id
248: AND fdl.cal_period_id = fcpa_year.cal_period_id
249: AND fcpa_number.attribute_id = ' ||
250: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
251: .attribute_id || '
252: AND fcpa_year.attribute_id = ' ||
253: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
254: .attribute_id || '

Line 253: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

249: AND fcpa_number.attribute_id = ' ||
250: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
251: .attribute_id || '
252: AND fcpa_year.attribute_id = ' ||
253: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
254: .attribute_id || '
255: AND fcpa_number.version_id = ' ||
256: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
257: .version_id || '

Line 256: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

252: AND fcpa_year.attribute_id = ' ||
253: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
254: .attribute_id || '
255: AND fcpa_number.version_id = ' ||
256: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
257: .version_id || '
258: AND fcpa_year.version_id = ' ||
259: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
260: .version_id || '

Line 259: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

255: AND fcpa_number.version_id = ' ||
256: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
257: .version_id || '
258: AND fcpa_year.version_id = ' ||
259: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
260: .version_id || '
261: AND fcpa_number.number_assign_value = gcpmd.source_period_number
262: AND gcpmd.target_period_number = ' ||
263: p_cal_period_record.cal_period_number || '

Line 292: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

288: AND fdl.balance_type_code = p_balance_type_code
289: AND fdl.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER
290: AND fla.ledger_id = fdl.ledger_id
291: AND fla.attribute_id =
292: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
293: .attribute_id
294: AND fla.version_id =
295: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
296: .version_id

Line 295: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')

291: AND fla.attribute_id =
292: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
293: .attribute_id
294: AND fla.version_id =
295: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-SOURCE_SYSTEM_CODE')
296: .version_id
297: AND gcpmd.cal_period_map_id = gcpm.cal_period_map_id
298: AND fcpb_src.cal_period_id = fdl.cal_period_id
299: AND gcpm.source_calendar_id = fcpb_src.calendar_id

Line 307: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

303: AND gcpm.target_dimension_group_id = fcpb_tgt.dimension_group_id
304: AND fdl.cal_period_id = fcpa_number.cal_period_id
305: AND fdl.cal_period_id = fcpa_year.cal_period_id
306: AND fcpa_number.attribute_id =
307: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
308: .attribute_id
309: AND fcpa_year.attribute_id =
310: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
311: .attribute_id

Line 310: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

306: AND fcpa_number.attribute_id =
307: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
308: .attribute_id
309: AND fcpa_year.attribute_id =
310: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
311: .attribute_id
312: AND fcpa_number.version_id =
313: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
314: .version_id

Line 313: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

309: AND fcpa_year.attribute_id =
310: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
311: .attribute_id
312: AND fcpa_number.version_id =
313: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
314: .version_id
315: AND fcpa_year.version_id =
316: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
317: .version_id

Line 316: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

312: AND fcpa_number.version_id =
313: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
314: .version_id
315: AND fcpa_year.version_id =
316: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
317: .version_id
318: AND fcpa_number.number_assign_value = gcpmd.source_period_number
319: AND gcpmd.target_period_number =
320: p_cal_period_record.cal_period_number

Line 380: gcs_utility_pkg.g_module_success ||

376:
377: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
378: fnd_log.STRING(fnd_log.level_procedure,
379: g_pkg_name || '.' || l_api_name,
380: gcs_utility_pkg.g_module_success ||
381: ' p_year_end_values_match = ' ||
382: p_year_end_values_match || ' ' ||
383: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
384: END IF;

Line 415: gcs_utility_pkg.g_module_success ||

411: p_year_end_values_match := 'Y';
412: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
413: fnd_log.STRING(fnd_log.level_procedure,
414: g_pkg_name || '.' || l_api_name,
415: gcs_utility_pkg.g_module_success ||
416: ' p_year_end_values_match = ' ||
417: p_year_end_values_match || ' ' ||
418: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
419: END IF;

Line 432: -- p_cal_period_record gcs_utility_pkg.r_cal_period_info

428: -- source_cal_period_id = target_cal_period_id.
429: -- Arguments
430: -- p_source_ledger_id Source ledger Identifier
431: -- p_target_cal_period_id Target Calendar Period Identifier
432: -- p_cal_period_record gcs_utility_pkg.r_cal_period_info
433: -- Notes
434: --
435: PROCEDURE reverse_explode_calendar_map(p_source_ledger_id IN NUMBER,
436: p_source_cal_period_id IN NUMBER,

Line 442: l_cal_period_record gcs_utility_pkg.r_cal_period_info;

438: l_cal_period_map_id NUMBER(15);
439: l_count_years NUMBER(15);
440: l_calendar_id NUMBER;
441: l_dimension_grp_id NUMBER;
442: l_cal_period_record gcs_utility_pkg.r_cal_period_info;
443: l_api_name VARCHAR2(30) := 'REVERSE_EXPLODE_CALENDAR_MAP';
444: BEGIN
445: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
446: fnd_log.STRING(fnd_log.level_procedure,

Line 448: gcs_utility_pkg.g_module_enter ||

444: BEGIN
445: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
446: fnd_log.STRING(fnd_log.level_procedure,
447: g_pkg_name || '.' || l_api_name,
448: gcs_utility_pkg.g_module_enter ||
449: ' p_source_ledger_id = ' || p_source_ledger_id ||
450: ' p_source_cal_period_id = ' || p_source_cal_period_id ||
451: ' p_hierarchy_id = ' || p_hierarchy_id || ' ' ||
452: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 495: gcs_utility_pkg.get_cal_period_details(p_source_cal_period_id,

491: AND fcpb.cal_period_id = p_source_cal_period_id
492: AND gcpm.source_calendar_id = fcpb.calendar_id
493: AND gcpm.source_dimension_group_id = fcpb.dimension_group_id;
494:
495: gcs_utility_pkg.get_cal_period_details(p_source_cal_period_id,
496: l_cal_period_record);
497: -- insert mapping data into temp table
498: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
499: fnd_log.STRING(fnd_log.level_statement,

Line 516: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

512: l_dimension_grp_id || '
513: AND fcpb.cal_period_id = fcpa_number.cal_period_id
514: AND fcpb.cal_period_id = fcpa_year.cal_period_id
515: AND fcpa_number.attribute_id =' ||
516: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
517: .attribute_id || '
518: AND fcpa_year.attribute_id =' ||
519: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
520: .attribute_id || '

Line 519: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

515: AND fcpa_number.attribute_id =' ||
516: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
517: .attribute_id || '
518: AND fcpa_year.attribute_id =' ||
519: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
520: .attribute_id || '
521: AND fcpa_number.version_id =' ||
522: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
523: .version_id || '

Line 522: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

518: AND fcpa_year.attribute_id =' ||
519: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
520: .attribute_id || '
521: AND fcpa_number.version_id =' ||
522: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
523: .version_id || '
524: AND fcpa_year.version_id =' ||
525: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
526: .version_id || '

Line 525: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

521: AND fcpa_number.version_id =' ||
522: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
523: .version_id || '
524: AND fcpa_year.version_id =' ||
525: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
526: .version_id || '
527: AND fcpa_number.number_assign_value = gcpmd.target_period_number
528: AND gcpmd.source_period_number = ' ||
529: l_cal_period_record.cal_period_number || '

Line 553: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

549: AND fcpb.dimension_group_id = l_dimension_grp_id
550: AND fcpb.cal_period_id = fcpa_number.cal_period_id
551: AND fcpb.cal_period_id = fcpa_year.cal_period_id
552: AND fcpa_number.attribute_id =
553: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
554: .attribute_id
555: AND fcpa_year.attribute_id =
556: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
557: .attribute_id

Line 556: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

552: AND fcpa_number.attribute_id =
553: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
554: .attribute_id
555: AND fcpa_year.attribute_id =
556: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
557: .attribute_id
558: AND fcpa_number.version_id =
559: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
560: .version_id

Line 559: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')

555: AND fcpa_year.attribute_id =
556: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
557: .attribute_id
558: AND fcpa_number.version_id =
559: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
560: .version_id
561: AND fcpa_year.version_id =
562: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
563: .version_id

Line 562: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')

558: AND fcpa_number.version_id =
559: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-GL_PERIOD_NUM')
560: .version_id
561: AND fcpa_year.version_id =
562: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-ACCOUNTING_YEAR')
563: .version_id
564: AND fcpa_number.number_assign_value = gcpmd.target_period_number
565: AND gcpmd.source_period_number =
566: l_cal_period_record.cal_period_number

Line 578: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||

574: l_cal_period_record.cal_period_year + 1);
575: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
576: fnd_log.STRING(fnd_log.level_procedure,
577: g_pkg_name || '.' || l_api_name,
578: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
579: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
580: END IF;
581:
582: EXCEPTION

Line 591: gcs_utility_pkg.g_module_success || ' ' ||

587: (p_source_cal_period_id, p_source_cal_period_id);
588: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
589: fnd_log.STRING(fnd_log.level_procedure,
590: g_pkg_name || '.' || l_api_name,
591: gcs_utility_pkg.g_module_success || ' ' ||
592: l_api_name || '() ' ||
593: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
594: END IF;
595: END reverse_explode_calendar_map;

Line 627: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

623: l_entry_id NUMBER(15);
624: l_stat_entry_id NUMBER(15);
625: l_errbuf VARCHAR2(2000);
626: l_retcode VARCHAR2(2000);
627: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
628: .attribute_id;
629: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
630: .version_id;
631: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 629: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

625: l_errbuf VARCHAR2(2000);
626: l_retcode VARCHAR2(2000);
627: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
628: .attribute_id;
629: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
630: .version_id;
631: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
632: .attribute_id;
633: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

Line 631: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

627: l_line_item_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
628: .attribute_id;
629: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
630: .version_id;
631: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
632: .attribute_id;
633: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
634: .version_id;
635: l_request_error_code VARCHAR2(400);

Line 633: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')

629: l_line_item_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
630: .version_id;
631: l_acct_type_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
632: .attribute_id;
633: l_acct_type_version NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE')
634: .version_id;
635: l_request_error_code VARCHAR2(400);
636: BEGIN
637:

Line 887: l_cal_period_record gcs_utility_pkg.r_cal_period_info;

883: l_source_currency_type_code VARCHAR2(30);
884: l_source_ledger_id NUMBER;
885: l_source_ledger_func_currency VARCHAR2(30);
886: l_max_period NUMBER;
887: l_cal_period_record gcs_utility_pkg.r_cal_period_info;
888: l_year_end_match VARCHAR2(1);
889: l_process_flag VARCHAR2(1);
890: l_owner_percentage NUMBER;
891: gcs_dp_src_data_error EXCEPTION;

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

891: gcs_dp_src_data_error EXCEPTION;
892:
893: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
894: gcs_dp_src_ledger_error EXCEPTION;
895: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
896: .attribute_id;
897: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
898: .version_id;
899: l_api_name VARCHAR2(30) := 'GCS_MAIN_DATA_PREP';

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

893: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
894: gcs_dp_src_ledger_error EXCEPTION;
895: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
896: .attribute_id;
897: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')
898: .version_id;
899: l_api_name VARCHAR2(30) := 'GCS_MAIN_DATA_PREP';
900:
901: --Bugfix 6037112: Added prior calendar period variable

Line 911: gcs_utility_pkg.g_module_enter || ' p_hierarchy_id = ' ||

907: --SAVEPOINT main_data_prep_start;
908: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
909: fnd_log.STRING(fnd_log.level_procedure,
910: g_pkg_name || '.' || l_api_name,
911: gcs_utility_pkg.g_module_enter || ' p_hierarchy_id = ' ||
912: p_hierarchy_id || ' p_entity_id = ' || p_entity_id ||
913: ' p_target_cal_period_id = ' || p_target_cal_period_id ||
914: ' p_run_detail_id = ' || p_run_detail_id ||
915: ' p_cons_rel_id = ' || p_cons_rel_id ||

Line 953: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

949: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
950: AND NVL(gea.effective_end_date, fcpa.date_assign_value )
951: AND gea.ledger_id = fla.ledger_id
952: AND fla.version_id = ' ||
953: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
954: .version_id || '
955: AND fla.attribute_id = ' ||
956: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
957: .attribute_id);

Line 956: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

952: AND fla.version_id = ' ||
953: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
954: .version_id || '
955: AND fla.attribute_id = ' ||
956: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
957: .attribute_id);
958: END IF;
959:
960: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period

Line 986: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

982: AND fcpa.date_assign_value BETWEEN gea.effective_start_date AND
983: NVL(gea.effective_end_date, fcpa.date_assign_value)
984: AND gea.ledger_id = fla.ledger_id
985: AND fla.version_id =
986: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
987: .version_id
988: AND fla.attribute_id =
989: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
990: .attribute_id;

Line 989: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')

985: AND fla.version_id =
986: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
987: .version_id
988: AND fla.attribute_id =
989: gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE')
990: .attribute_id;
991:
992: EXCEPTION
993: -- Bugfix: 5843592, create a new user defined exception

Line 1123: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||

1119: END IF;
1120: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1121: fnd_log.STRING(fnd_log.level_procedure,
1122: g_pkg_name || '.' || l_api_name,
1123: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1124: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1125: END IF;
1126: EXCEPTION
1127: WHEN gcs_dp_src_ledger_error THEN

Line 1137: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

1133: x_retcode := '2';
1134: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1135: fnd_log.STRING(fnd_log.level_error,
1136: g_pkg_name || '.' || l_api_name,
1137: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1138: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1139: END IF;
1140: gcs_cons_eng_run_dtls_pkg.update_entry_headers(p_run_detail_id => p_run_detail_id,
1141: p_entry_id => NULL,

Line 1156: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

1152: x_retcode := '2';
1153: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1154: fnd_log.STRING(fnd_log.level_error,
1155: g_pkg_name || '.' || l_api_name,
1156: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1157: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1158: END IF;
1159: gcs_cons_eng_run_dtls_pkg.update_entry_headers(p_run_detail_id => p_run_detail_id,
1160: p_entry_id => NULL,

Line 1170: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

1166: x_retcode := '2';
1167: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1168: fnd_log.STRING(fnd_log.level_error,
1169: g_pkg_name || '.' || l_api_name,
1170: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1171: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1172: END IF;
1173: gcs_cons_eng_run_dtls_pkg.update_entry_headers(p_run_detail_id => p_run_detail_id,
1174: p_entry_id => NULL,

Line 1188: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

1184: x_retcode := '2';
1185: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1186: fnd_log.STRING(fnd_log.level_error,
1187: g_pkg_name || '.' || l_api_name,
1188: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1189: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1190: END IF;
1191: gcs_cons_eng_run_dtls_pkg.update_entry_headers(p_run_detail_id => p_run_detail_id,
1192: p_entry_id => NULL,

Line 1244: IF (gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID') = 'Y') THEN

1240: '============================================');
1241: fnd_file.put_line(fnd_file.log,
1242: 'GCS_DATA_PREP_PKG::create_process -- Enter');
1243: --Bugfix 5329620: Determine Currency Clause Based on Status of Financial Element
1244: IF (gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID') = 'Y') THEN
1245: l_curr_where_clause := '
1246: AND fb.currency_code IN (p_source_currency_code, ''STAT'')
1247: AND fb.financial_elem_id <> 140';
1248: l_curr_vs_map_where_clause := '

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

1350: g_nl CONSTANT VARCHAR2 (1) := ''
1351: '';
1352: g_insert_statement VARCHAR2(32000);
1353: g_ln_item_vs_id NUMBER;
1354: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1355: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;

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

1351: '';
1352: g_insert_statement VARCHAR2(32000);
1353: g_ln_item_vs_id NUMBER;
1354: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1355: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;

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

1353: g_ln_item_vs_id NUMBER;
1354: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1355: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1360: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id;
1361: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id;

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

1354: g_li_eat_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1355: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1360: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id;
1361: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id;
1362:

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

1355: g_li_eat_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1360: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id;
1361: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id;
1362:
1363: no_re_template_error EXCEPTION;

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

1356:
1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1360: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id;
1361: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id;
1362:
1363: no_re_template_error EXCEPTION;
1364: no_suspense_template_error EXCEPTION;

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

1357: g_eatc_batc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1358: g_eatc_batc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1359: g_li_vs_id NUMBER := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1360: g_ledger_ssc_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').attribute_id;
1361: g_ledger_ssc_ver_id NUMBER := gcs_utility_pkg.g_dimension_attr_info (''LEDGER_ID-SOURCE_SYSTEM_CODE'').version_id;
1362:
1363: no_re_template_error EXCEPTION;
1364: no_suspense_template_error EXCEPTION;
1365: init_mapping_error EXCEPTION;

Line 1399: gcs_utility_pkg.g_module_enter

1395: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1396: THEN
1397: fnd_log.STRING (fnd_log.level_procedure,
1398: g_pkg_name || ''.'' || l_api_name,
1399: gcs_utility_pkg.g_module_enter
1400: || '' p_source_ledger_id = '' || p_source_ledger_id
1401: || '' ''
1402: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1403: );

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

1401: || '' ''
1402: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1403: );
1404: END IF;
1405: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1406: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1407: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1408: BEGIN
1409: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

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

1402: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1403: );
1404: END IF;
1405: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1406: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1407: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1408: BEGIN
1409: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1410: THEN

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

1403: );
1404: END IF;
1405: g_ln_item_vs_id := gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1406: l_cal_attribute_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1407: l_cal_version_id := gcs_utility_pkg.g_dimension_attr_info (''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1408: BEGIN
1409: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1410: THEN
1411: fnd_log.STRING (fnd_log.level_statement,

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

1443: ''''STAT'''',
1444: :l_stat_entry_id,
1445: :l_entry_id), fb.cal_period_id, '';
1446: l_group_text := '' GROUP BY ' || l_fb_dims || ''';
1447: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
1448: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
1449: LOOP
1450: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
1451: AND (l_index_column_name <> ''ENTITY_ID'')

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

1444: :l_stat_entry_id,
1445: :l_entry_id), fb.cal_period_id, '';
1446: l_group_text := '' GROUP BY ' || l_fb_dims || ''';
1447: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
1448: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
1449: LOOP
1450: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
1451: AND (l_index_column_name <> ''ENTITY_ID'')
1452: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = ''Y'')

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

1446: l_group_text := '' GROUP BY ' || l_fb_dims || ''';
1447: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
1448: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
1449: LOOP
1450: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
1451: AND (l_index_column_name <> ''ENTITY_ID'')
1452: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = ''Y'')
1453: )
1454: THEN

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

1448: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST )
1449: LOOP
1450: IF ( (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id IS NOT NULL)
1451: AND (l_index_column_name <> ''ENTITY_ID'')
1452: AND (gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs = ''Y'')
1453: )
1454: THEN
1455: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1456: THEN

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

1459: '' SELECT value_set_id
1460: INTO l_source_value_set_id
1461: FROM fem_global_vs_combo_defs
1462: WHERE global_vs_combo_id = ''||l_source_global_vs_combo||''
1463: AND dimension_id = ''||gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id);
1464: END IF;
1465: SELECT value_set_id
1466: INTO l_source_value_set_id
1467: FROM fem_global_vs_combo_defs

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

1465: SELECT value_set_id
1466: INTO l_source_value_set_id
1467: FROM fem_global_vs_combo_defs
1468: WHERE global_vs_combo_id = l_source_global_vs_combo
1469: AND dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id;
1470:
1471: IF ( (l_source_value_set_id IS NULL)
1472: OR (l_source_value_set_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id)
1473: )

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

1468: WHERE global_vs_combo_id = l_source_global_vs_combo
1469: AND dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id;
1470:
1471: IF ( (l_source_value_set_id IS NULL)
1472: OR (l_source_value_set_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).associated_value_set_id)
1473: )
1474: THEN
1475: g_insert_statement := g_insert_statement || ''fb.'' || l_index_column_name || '', '';
1476: GOTO next_loop;

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

1474: THEN
1475: g_insert_statement := g_insert_statement || ''fb.'' || l_index_column_name || '', '';
1476: GOTO next_loop;
1477: ELSE
1478: gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).detail_value_set_id := l_source_value_set_id;
1479: l_mapping_required := ''Y'';
1480: END IF;
1481:
1482: BEGIN

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

1484: INTO l_hierarchy_obj_def_id
1485: FROM fem_xdim_dimensions fxd,
1486: fem_object_definition_b fod,
1487: fem_cal_periods_attr fcpa
1488: WHERE fxd.dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id
1489: AND fxd.default_mvs_hierarchy_obj_id = fod.object_id
1490: AND fcpa.cal_period_id = p_cal_period_id
1491: AND fcpa.attribute_id = l_cal_attribute_id
1492: AND fcpa.version_id = l_cal_version_id

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

1519: || '' AND fnah.parent_depth_num = fnah.child_depth_num - 1
1520: AND fnah.child_value_set_id = '' || l_source_value_set_id || ''
1521: AND fnah.child_id = fb.NATURAL_ACCOUNT_ID
1522: AND fnah.parent_value_set_id = ''
1523: || gcs_utility_pkg.g_gcs_dimension_info (''NATURAL_ACCOUNT_ID'').associated_value_set_id;
1524: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fnah.parent_id '');
1525: ELSIF (l_index_column_name = ''COMPANY_COST_CENTER_ORG_ID'')
1526: THEN
1527: l_cctr_map_required := TRUE;

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

1533: || '' AND fcoh.parent_depth_num = fcoh.child_depth_num - 1
1534: AND fcoh.child_value_set_id = '' || l_source_value_set_id || ''
1535: AND fcoh.child_id = fb.COMPANY_COST_CENTER_ORG_ID
1536: AND fcoh.parent_value_set_id = ''
1537: || gcs_utility_pkg.g_gcs_dimension_info (''COMPANY_COST_CENTER_ORG_ID'').associated_value_set_id;
1538: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fcoh.parent_id '');
1539: ELSIF (l_index_column_name = ''INTERCOMPANY_ID'')
1540: THEN
1541: g_insert_statement := g_insert_statement

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

1546: AND fcoh_inter.parent_depth_num = fcoh_inter.child_depth_num - 1
1547: AND fcoh_inter.child_value_set_id = '' || l_source_value_set_id || ''
1548: AND fcoh_inter.child_id = fb.INTERCOMPANY_ID
1549: AND fcoh_inter.parent_value_set_id = ''
1550: || gcs_utility_pkg.g_gcs_dimension_info (''INTERCOMPANY_ID'').associated_value_set_id;
1551: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fcoh_inter.parent_id '');
1552: ELSIF (l_index_column_name = ''LINE_ITEM_ID'')
1553: THEN
1554: g_insert_statement := g_insert_statement

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

1559: AND flih.parent_depth_num = flih.child_depth_num - 1
1560: AND flih.child_value_set_id = '' || l_source_value_set_id || ''
1561: AND flih.child_id = fb.LINE_ITEM_ID
1562: AND flih.parent_value_set_id = ''
1563: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id;
1564: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''flih.parent_id '');
1565: g_ln_item_vs_id := l_source_value_set_id;
1566: ELSIF (l_index_column_name = ''PRODUCT_ID'')
1567: THEN

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

1573: AND fpdh.parent_depth_num = fpdh.child_depth_num - 1
1574: AND fpdh.child_value_set_id = '' || l_source_value_set_id || ''
1575: AND fpdh.child_id = fb.PRODUCT_ID
1576: AND fpdh.parent_value_set_id = ''
1577: || gcs_utility_pkg.g_gcs_dimension_info (''PRODUCT_ID'').associated_value_set_id;
1578: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fpdh.parent_id '');
1579: ELSIF (l_index_column_name = ''PROJECT_ID'')
1580: THEN
1581: g_insert_statement := g_insert_statement

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

1586: AND fpjh.parent_depth_num = fpjh.child_depth_num - 1
1587: AND fpjh.child_value_set_id = '' || l_source_value_set_id || ''
1588: AND fpjh.child_id = fb.PROJECT_ID
1589: AND fpjh.parent_value_set_id = ''
1590: || gcs_utility_pkg.g_gcs_dimension_info (''PROJECT_ID'').associated_value_set_id;
1591: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fpjh.parent_id '');
1592: ELSIF (l_index_column_name = ''CHANNEL_ID'')
1593: THEN
1594: g_insert_statement := g_insert_statement

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

1599: AND fchh.parent_depth_num = fchh.child_depth_num - 1
1600: AND fchh.child_value_set_id = '' || l_source_value_set_id || ''
1601: AND fchh.child_id = fb.CHANNEL_ID
1602: AND fchh.parent_value_set_id = ''
1603: || gcs_utility_pkg.g_gcs_dimension_info (''CHANNEL_ID'').associated_value_set_id;
1604: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fchh.parent_id '');
1605: ELSIF (l_index_column_name = ''CUSTOMER_ID'')
1606: THEN
1607: g_insert_statement := g_insert_statement

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

1612: AND fcuh.parent_depth_num = fcuh.child_depth_num - 1
1613: AND fcuh.child_value_set_id = '' || l_source_value_set_id || ''
1614: AND fcuh.child_id = fb.CUSTOMER_ID
1615: AND fcuh.parent_value_set_id = ''
1616: || gcs_utility_pkg.g_gcs_dimension_info (''CUSTOMER_ID'').associated_value_set_id;
1617: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fcuh.parent_id '');
1618: ELSIF (l_index_column_name = ''USER_DIM1_ID'')
1619: THEN
1620: g_insert_statement := g_insert_statement

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

1625: AND fud1h.parent_depth_num = fud1h.child_depth_num - 1
1626: AND fud1h.child_value_set_id = '' || l_source_value_set_id || ''
1627: AND fud1h.child_id = fb.USER_DIM1_ID
1628: AND fud1h.parent_value_set_id = ''
1629: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM1_ID'').associated_value_set_id;
1630: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud1h.parent_id '');
1631: ELSIF (l_index_column_name = ''USER_DIM2_ID'')
1632: THEN
1633: g_insert_statement := g_insert_statement

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

1638: AND fud2h.parent_depth_num = fud2h.child_depth_num - 1
1639: AND fud2h.child_value_set_id = '' || l_source_value_set_id || ''
1640: AND fud2h.child_id = fb.USER_DIM2_ID
1641: AND fud2h.parent_value_set_id = ''
1642: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM2_ID'').associated_value_set_id;
1643: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud2h.parent_id '');
1644: ELSIF (l_index_column_name = ''USER_DIM3_ID'')
1645: THEN
1646: g_insert_statement := g_insert_statement

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

1651: AND fud3h.parent_depth_num = fud3h.child_depth_num - 1
1652: AND fud3h.child_value_set_id = '' || l_source_value_set_id || ''
1653: AND fud3h.child_id = fb.USER_DIM3_ID
1654: AND fud3h.parent_value_set_id = ''
1655: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM3_ID'').associated_value_set_id;
1656: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud3h.parent_id '');
1657: ELSIF (l_index_column_name = ''USER_DIM4_ID'')
1658: THEN
1659: g_insert_statement := g_insert_statement

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

1664: AND fud4h.parent_depth_num = fud4h.child_depth_num - 1
1665: AND fud4h.child_value_set_id = '' || l_source_value_set_id || ''
1666: AND fud4h.child_id = fb.USER_DIM4_ID
1667: AND fud4h.parent_value_set_id = ''
1668: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM4_ID'').associated_value_set_id;
1669: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud4h.parent_id '');
1670: ELSIF (l_index_column_name = ''USER_DIM5_ID'')
1671: THEN
1672: g_insert_statement := g_insert_statement

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

1677: AND fud5h.parent_depth_num = fud5h.child_depth_num - 1
1678: AND fud5h.child_value_set_id = '' || l_source_value_set_id || ''
1679: AND fud5h.child_id = fb.USER_DIM5_ID
1680: AND fud5h.parent_value_set_id = ''
1681: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM5_ID'').associated_value_set_id;
1682: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud5h.parent_id '');
1683: ELSIF (l_index_column_name = ''USER_DIM6_ID'')
1684: THEN
1685: g_insert_statement := g_insert_statement

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

1690: AND fud6h.parent_depth_num = fud6h.child_depth_num - 1
1691: AND fud6h.child_value_set_id = '' || l_source_value_set_id || ''
1692: AND fud6h.child_id = fb.USER_DIM6_ID
1693: AND fud6h.parent_value_set_id = ''
1694: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM6_ID'').associated_value_set_id;
1695: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud7h.parent_id '');
1696: ELSIF (l_index_column_name = ''USER_DIM7_ID'')
1697: THEN
1698: g_insert_statement := g_insert_statement

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

1703: AND fud7h.parent_depth_num = fud7h.child_depth_num - 1
1704: AND fud7h.child_value_set_id = '' || l_source_value_set_id || ''
1705: AND fud7h.child_id = fb.USER_DIM7_ID
1706: AND fud7h.parent_value_set_id = ''
1707: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM7_ID'').associated_value_set_id;
1708: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud7h.parent_id '');
1709: ELSIF (l_index_column_name = ''USER_DIM8_ID'')
1710: THEN
1711: g_insert_statement := g_insert_statement

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

1716: AND fud8h.parent_depth_num = fud8h.child_depth_num - 1
1717: AND fud8h.child_value_set_id = '' || l_source_value_set_id || ''
1718: AND fud8h.child_id = fb.USER_DIM8_ID
1719: AND fud8h.parent_value_set_id = ''
1720: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM8_ID'').associated_value_set_id;
1721: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud8h.parent_id '');
1722: ELSIF (l_index_column_name = ''USER_DIM9_ID'')
1723: THEN
1724: g_insert_statement := g_insert_statement

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

1729: AND fud9h.parent_depth_num = fud9h.child_depth_num - 1
1730: AND fud9h.child_value_set_id = '' || l_source_value_set_id || ''
1731: AND fud9h.child_id = fb.USER_DIM9_ID
1732: AND fud9h.parent_value_set_id = ''
1733: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM9_ID'').associated_value_set_id;
1734: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud9h.parent_id '');
1735: ELSIF (l_index_column_name = ''USER_DIM10_ID'')
1736: THEN
1737: g_insert_statement := g_insert_statement

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

1742: AND fud10h.parent_depth_num = fud10h.child_depth_num - 1
1743: AND fud10h.child_value_set_id = '' || l_source_value_set_id || ''
1744: AND fud10h.child_id = fb.USER_DIM10_ID
1745: AND fud10h.parent_value_set_id = ''
1746: || gcs_utility_pkg.g_gcs_dimension_info (''USER_DIM10_ID'').associated_value_set_id;
1747: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud10h.parent_id '');
1748: END IF;
1749: END IF;
1750: <>

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

1747: l_group_text := replace(l_group_text, ''fb.''||l_index_column_name, ''fud10h.parent_id '');
1748: END IF;
1749: END IF;
1750: <>
1751: l_index_column_name :=gcs_utility_pkg.g_gcs_dimension_info.NEXT (l_index_column_name);
1752: END LOOP;
1753: ';
1754: curr_index := 1;
1755: body_len := LENGTH(l_proc_body);

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

1773: ''
1774: WHERE fb.ledger_id = :p_source_ledger_id
1775: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER
1776: AND fla.ledger_id = fb.ledger_id
1777: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''''LEDGER_ID-SOURCE_SYSTEM_CODE'''').attribute_id
1778: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''''LEDGER_ID-SOURCE_SYSTEM_CODE'''').version_id
1779: AND fb.company_cost_center_org_id = geco.company_cost_center_org_id
1780: AND geco.entity_id = :p_entity_id
1781: AND :p_balance_type_code = DECODE(fb.financial_elem_id, 140, ''''ADB'''', ''''ACTUAL'''')

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

1774: WHERE fb.ledger_id = :p_source_ledger_id
1775: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER
1776: AND fla.ledger_id = fb.ledger_id
1777: AND fla.attribute_id = gcs_utility_pkg.g_dimension_attr_info(''''LEDGER_ID-SOURCE_SYSTEM_CODE'''').attribute_id
1778: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info(''''LEDGER_ID-SOURCE_SYSTEM_CODE'''').version_id
1779: AND fb.company_cost_center_org_id = geco.company_cost_center_org_id
1780: AND geco.entity_id = :p_entity_id
1781: AND :p_balance_type_code = DECODE(fb.financial_elem_id, 140, ''''ADB'''', ''''ACTUAL'''')
1782: AND ((fb.currency_type_code = ''''TRANSLATED'''' AND fb.currency_code in (''''STAT'''', :p_source_currency_code))

Line 1829: retcode := gcs_utility_pkg.g_ret_sts_success;

1825: END IF;
1826: g_insert_statement := g_insert_statement
1827: || l_from_text
1828: || l_where_text;
1829: retcode := gcs_utility_pkg.g_ret_sts_success;
1830: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1831: THEN
1832: fnd_log.STRING (fnd_log.level_procedure,
1833: g_pkg_name || ''.'' || l_api_name,

Line 1834: gcs_utility_pkg.g_module_success

1830: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1831: THEN
1832: fnd_log.STRING (fnd_log.level_procedure,
1833: g_pkg_name || ''.'' || l_api_name,
1834: gcs_utility_pkg.g_module_success
1835: || '' Mapping Required : ''
1836: || l_mapping_required
1837: || '' ''
1838: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 1844: retcode := gcs_utility_pkg.g_ret_sts_error;

1840: END IF;
1841: RETURN l_mapping_required;
1842: EXCEPTION
1843: WHEN gcs_dp_no_hier_obj_def_id THEN
1844: retcode := gcs_utility_pkg.g_ret_sts_error;
1845: fnd_message.set_name(''GCS'', ''GCS_DP_NO_HIER_OBJ_DEF_ERR'');
1846: fnd_message.set_token(''DIMENSION'', l_index_column_name);
1847: errbuf := fnd_message.get;
1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

Line 1852: gcs_utility_pkg.g_module_failure

1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1849: THEN
1850: fnd_log.STRING (fnd_log.level_error,
1851: g_pkg_name || ''.'' || l_api_name,
1852: gcs_utility_pkg.g_module_failure
1853: || '' ''
1854: || errbuf
1855: || '' '' || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1856: );

Line 1860: retcode := gcs_utility_pkg.g_ret_sts_error;

1856: );
1857: END IF;
1858: RETURN retcode;
1859: WHEN global_vs_id_error THEN
1860: retcode := gcs_utility_pkg.g_ret_sts_error;
1861: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_GLOBAL_VS_ERR'');
1862: errbuf := fnd_message.get;
1863: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1864: THEN

Line 1867: gcs_utility_pkg.g_module_failure

1863: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1864: THEN
1865: fnd_log.STRING (fnd_log.level_error,
1866: g_pkg_name || ''.'' || l_api_name,
1867: gcs_utility_pkg.g_module_failure
1868: || '' ''
1869: || errbuf
1870: || '' '' || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1871: );

Line 1875: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;

1871: );
1872: END IF;
1873: RETURN retcode;
1874: WHEN OTHERS THEN
1875: retcode := gcs_utility_pkg.G_RET_STS_UNEXP_ERROR;
1876: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_UNEXP_ERR'');
1877: errbuf := fnd_message.get;
1878: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1879: THEN

Line 1882: gcs_utility_pkg.g_module_failure

1878: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1879: THEN
1880: fnd_log.STRING (fnd_log.level_error,
1881: g_pkg_name || ''.'' || l_api_name,
1882: gcs_utility_pkg.g_module_failure
1883: || '' ''
1884: || errbuf
1885: || '' '' || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
1886: );

Line 1953: p_cal_period_record IN gcs_utility_pkg.r_cal_period_info,

1949: p_hierarchy_id IN NUMBER,
1950: p_entity_id IN NUMBER,
1951: p_source_ledger_id IN NUMBER,
1952: p_year_end_values_match IN VARCHAR2,
1953: p_cal_period_record IN gcs_utility_pkg.r_cal_period_info,
1954: p_balance_type_code IN VARCHAR2,
1955: p_owner_percentage IN NUMBER,
1956: p_run_detail_id IN NUMBER,
1957: p_source_dataset_code IN NUMBER,

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

1978: l_periods_list DBMS_SQL.number_table;
1979:
1980: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
1981:
1982: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'')
1983: .attribute_id;
1984: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'')
1985: .version_id ;
1986:

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

1980: -- Bug Fix: 5843592, Get the attribute id and version id of the CAL_PERIOD_END_DATE of calendar period
1981:
1982: l_period_end_date_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'')
1983: .attribute_id;
1984: l_period_end_date_version NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'')
1985: .version_id ;
1986:
1987: -- Bugfix 6068527: Added account type attributes
1988: l_line_item_type_attr NUMBER(15) :=

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

1985: .version_id ;
1986:
1987: -- Bugfix 6068527: Added account type attributes
1988: l_line_item_type_attr NUMBER(15) :=
1989: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1990: l_line_item_type_version NUMBER(15) :=
1991: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1992: l_acct_type_attr NUMBER(15) :=
1993: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;

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

1987: -- Bugfix 6068527: Added account type attributes
1988: l_line_item_type_attr NUMBER(15) :=
1989: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1990: l_line_item_type_version NUMBER(15) :=
1991: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1992: l_acct_type_attr NUMBER(15) :=
1993: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1994: l_acct_type_version NUMBER(15) :=
1995: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;

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

1989: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
1990: l_line_item_type_version NUMBER(15) :=
1991: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1992: l_acct_type_attr NUMBER(15) :=
1993: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1994: l_acct_type_version NUMBER(15) :=
1995: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1996:
1997: BEGIN

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

1991: gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
1992: l_acct_type_attr NUMBER(15) :=
1993: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
1994: l_acct_type_version NUMBER(15) :=
1995: gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
1996:
1997: BEGIN
1998: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1999: THEN

Line 2002: gcs_utility_pkg.g_module_enter

1998: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1999: THEN
2000: fnd_log.STRING (fnd_log.level_procedure,
2001: g_pkg_name || ''.'' || l_api_name,
2002: gcs_utility_pkg.g_module_enter
2003: || '' p_source_currency_code = '' || p_source_currency_code
2004: || '', p_target_cal_period_id = '' || p_target_cal_period_id
2005: || '', p_max_period = '' || p_max_period
2006: || '', p_currency_type_code = '' || p_currency_type_code

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

2022: p_cal_period_id => p_cal_period_record.cal_period_id,
2023: errbuf => errbuf,
2024: retcode => retcode);
2025:
2026: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
2027: THEN
2028: RAISE init_mapping_error;
2029: END IF;
2030:

Line 2473: retcode := gcs_utility_pkg.g_ret_sts_success;

2469: p_entity_id => p_entity_id,
2470: p_pre_cal_period_id => p_cal_period_record.prev_cal_period_id,
2471: p_first_ever_data_prep => l_first_ever_data_prepped);
2472: END IF;
2473: retcode := gcs_utility_pkg.g_ret_sts_success;
2474: -- Suspense accounts
2475: IF l_entry_id IS NOT NULL
2476: THEN
2477: -- check balance criteria

Line 2595: retcode := gcs_utility_pkg.g_ret_sts_success;

2591: INTO retcode
2592: FROM gcs_entry_headers
2593: WHERE entry_id = l_proportional_entry_id;
2594: ELSE
2595: retcode := gcs_utility_pkg.g_ret_sts_success;
2596: END IF;
2597: gcs_cons_eng_run_dtls_pkg.update_entry_headers
2598: (p_run_detail_id => p_run_detail_id,
2599: p_entry_id => l_proportional_entry_id,

Line 2663: gcs_utility_pkg.g_module_success

2659: 'IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
2660: THEN
2661: fnd_log.STRING (fnd_log.level_procedure,
2662: g_pkg_name || ''.'' || l_api_name,
2663: gcs_utility_pkg.g_module_success
2664: || '' ''
2665: || l_api_name
2666: || ''()''
2667: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 2672: retcode := gcs_utility_pkg.g_ret_sts_error;

2668: );
2669: END IF;
2670: EXCEPTION
2671: WHEN no_suspense_template_error THEN
2672: retcode := gcs_utility_pkg.g_ret_sts_error;
2673: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
2674: errbuf := fnd_message.get;
2675:
2676: DELETE FROM gcs_entry_headers

Line 2687: gcs_utility_pkg.g_module_failure

2683: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2684: THEN
2685: fnd_log.STRING (fnd_log.level_error,
2686: g_pkg_name || ''.'' || l_api_name,
2687: gcs_utility_pkg.g_module_failure
2688: || '' ''
2689: || errbuf
2690: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
2691: );

Line 2695: retcode := gcs_utility_pkg.g_ret_sts_error;

2691: );
2692: END IF;
2693: raise gcs_dp_proc_data_error;
2694: WHEN no_re_template_error THEN
2695: retcode := gcs_utility_pkg.g_ret_sts_error;
2696: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
2697: errbuf := fnd_message.get;
2698:
2699: DELETE FROM gcs_entry_headers

Line 2710: gcs_utility_pkg.g_module_failure

2706: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
2707: THEN
2708: fnd_log.STRING (fnd_log.level_error,
2709: g_pkg_name || ''.'' || l_api_name,
2710: gcs_utility_pkg.g_module_failure
2711: || '' ''
2712: || errbuf
2713: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
2714: );

Line 2720: retcode := gcs_utility_pkg.g_ret_sts_warn;

2716: raise gcs_dp_proc_data_error;
2717: WHEN init_mapping_error THEN
2718: raise gcs_dp_proc_data_error;
2719: WHEN no_data_error THEN
2720: retcode := gcs_utility_pkg.g_ret_sts_warn;
2721: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
2722: errbuf := fnd_message.get;
2723: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2724: fnd_log.STRING (fnd_log.level_error,

Line 2726: gcs_utility_pkg.g_module_failure

2722: errbuf := fnd_message.get;
2723: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2724: fnd_log.STRING (fnd_log.level_error,
2725: g_pkg_name || ''.'' || l_api_name,
2726: gcs_utility_pkg.g_module_failure
2727: || '' ''
2728: || errbuf
2729: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
2730: );

Line 2743: retcode := gcs_utility_pkg.g_ret_sts_error;

2739: p_bp_request_error_code => ''NOT_APPLICABLE''
2740: );
2741: -- bug 5071794 fix: catch unexpected error and reraise it
2742: WHEN others THEN
2743: retcode := gcs_utility_pkg.g_ret_sts_error;
2744: errbuf := SQLERRM;
2745:
2746: DELETE FROM gcs_entry_headers
2747: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 2756: gcs_utility_pkg.g_module_failure

2752:
2753: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
2754: fnd_log.STRING (fnd_log.level_error,
2755: g_pkg_name || ''.'' || l_api_name,
2756: gcs_utility_pkg.g_module_failure
2757: || '' ''
2758: || errbuf
2759: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
2760: );

Line 2811: gcs_utility_pkg.g_module_enter

2807: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
2808: THEN
2809: fnd_log.STRING (fnd_log.level_procedure,
2810: g_pkg_name || ''.'' || l_api_name,
2811: gcs_utility_pkg.g_module_enter
2812: || '' ''
2813: || l_api_name
2814: || ''()''
2815: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

2821: p_cal_period_id => p_target_cal_period_id,
2822: errbuf => errbuf,
2823: retcode => retcode,
2824: p_inc_mode_flag => ''Y'');
2825: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
2826: THEN
2827: RAISE init_mapping_error;
2828: END IF;
2829: SELECT gcs_entry_headers_s.NEXTVAL

Line 3052: retcode := gcs_utility_pkg.g_ret_sts_success;

3048: p_category_code => ''DATAPREPARATION''
3049: );
3050: END IF;
3051: END IF;
3052: retcode := gcs_utility_pkg.g_ret_sts_success;
3053: -- Suspense accounts
3054: IF x_entry_id IS NOT NULL
3055: THEN
3056: -- check balance criteria

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

3086: p_entity_id => p_entity_id,
3087: p_threshold => l_threshold,
3088: p_threshold_currency_code => l_threshold_currency
3089: );
3090: SELECT DECODE(SUSPENSE_EXCEEDED_FLAG, ''Y'', ''WARNING'', gcs_utility_pkg.g_ret_sts_success)
3091: INTO retcode
3092: FROM gcs_entry_headers
3093: WHERE entry_id = x_entry_id;
3094: END IF;

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

3134: p_threshold => l_threshold,
3135: p_threshold_currency_code => l_threshold_currency
3136: );
3137:
3138: SELECT decode(SUSPENSE_EXCEEDED_FLAG, ''Y'', ''WARNING'', gcs_utility_pkg.g_ret_sts_success)
3139: INTO retcode
3140: FROM gcs_entry_headers
3141: WHERE entry_id = x_prop_entry_id;
3142: ELSE

Line 3143: retcode := gcs_utility_pkg.g_ret_sts_success;

3139: INTO retcode
3140: FROM gcs_entry_headers
3141: WHERE entry_id = x_prop_entry_id;
3142: ELSE
3143: retcode := gcs_utility_pkg.g_ret_sts_success;
3144: END IF;
3145: END IF;
3146: ';
3147: curr_index := 1;

Line 3203: gcs_utility_pkg.g_module_success

3199: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
3200: THEN
3201: fnd_log.STRING (fnd_log.level_procedure,
3202: g_pkg_name || ''.'' || l_api_name,
3203: gcs_utility_pkg.g_module_success
3204: || '' ''
3205: || l_api_name
3206: || ''()''
3207: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 3212: retcode := gcs_utility_pkg.g_ret_sts_error;

3208: );
3209: END IF;
3210: EXCEPTION
3211: WHEN no_suspense_template_error THEN
3212: retcode := gcs_utility_pkg.g_ret_sts_error;
3213: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_SUSPENSE_ERR'');
3214: errbuf := fnd_message.get;
3215: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3216: THEN

Line 3219: gcs_utility_pkg.g_module_failure

3215: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3216: THEN
3217: fnd_log.STRING (fnd_log.level_error,
3218: g_pkg_name || ''.'' || l_api_name,
3219: gcs_utility_pkg.g_module_failure
3220: || '' ''
3221: || errbuf
3222: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
3223: );

Line 3227: retcode := gcs_utility_pkg.g_ret_sts_error;

3223: );
3224: END IF;
3225: raise gcs_dp_proc_data_error;
3226: WHEN no_re_template_error THEN
3227: retcode := gcs_utility_pkg.g_ret_sts_error;
3228: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_RE_ERR'');
3229: errbuf := fnd_message.get;
3230: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3231: THEN

Line 3234: gcs_utility_pkg.g_module_failure

3230: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
3231: THEN
3232: fnd_log.STRING (fnd_log.level_error,
3233: g_pkg_name || ''.'' || l_api_name,
3234: gcs_utility_pkg.g_module_failure
3235: || '' ''
3236: || errbuf
3237: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
3238: );

Line 3244: retcode := gcs_utility_pkg.g_ret_sts_warn;

3240: raise gcs_dp_proc_data_error;
3241: WHEN init_mapping_error THEN
3242: raise gcs_dp_proc_data_error;
3243: WHEN no_data_error THEN
3244: retcode := gcs_utility_pkg.g_ret_sts_warn;
3245: FND_MESSAGE.set_name(''GCS'', ''GCS_DP_NO_DATA_ERR'');
3246: errbuf := fnd_message.get;
3247: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
3248: fnd_log.STRING (fnd_log.level_error,

Line 3250: gcs_utility_pkg.g_module_failure

3246: errbuf := fnd_message.get;
3247: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
3248: fnd_log.STRING (fnd_log.level_error,
3249: g_pkg_name || ''.'' || l_api_name,
3250: gcs_utility_pkg.g_module_failure
3251: || '' ''
3252: || errbuf
3253: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')
3254: );

Line 3293: gcs_utility_pkg.g_module_failure || ' ' ||

3289: fnd_message.set_name('GCS', 'GCS_DP_NODIM_ERR');
3290: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3291: fnd_log.STRING(fnd_log.level_error,
3292: g_pkg_name || '.' || l_api_name,
3293: gcs_utility_pkg.g_module_failure || ' ' ||
3294: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3295: END IF;
3296: fnd_file.put_line(fnd_file.log,
3297: 'GCS_DATA_PREP_PKG::create_process -- NO_DATA_FOUND Exception');

Line 3309: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||

3305: fnd_message.set_name('GCS', 'GCS_DP_UNEXP_ERR');
3306: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3307: fnd_log.STRING(fnd_log.level_error,
3308: g_pkg_name || '.' || l_api_name,
3309: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
3310: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3311: END IF;
3312: fnd_file.put_line(fnd_file.log,
3313: 'GCS_DATA_PREP_PKG::create_process -- OTHERS Exception := ' ||

Line 3367: gcs_utility_pkg.g_module_enter ||

3363: SAVEPOINT inc_data_prep_start;
3364: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
3365: fnd_log.STRING(fnd_log.level_procedure,
3366: g_pkg_name || '.' || l_api_name,
3367: gcs_utility_pkg.g_module_enter ||
3368: ' p_source_cal_period_id = ' || p_source_cal_period_id ||
3369: ' p_balance_type_code = ' || p_balance_type_code ||
3370: ' p_ledger_id = ' || p_ledger_id ||
3371: ' p_currency_code = ' || p_currency_code ||

Line 3402: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||

3398: retcode => x_retcode);
3399: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
3400: fnd_log.STRING(fnd_log.level_procedure,
3401: g_pkg_name || '.' || l_api_name,
3402: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
3403: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3404: END IF;
3405: EXCEPTION
3406: WHEN OTHERS THEN

Line 3409: x_retcode := gcs_utility_pkg.g_ret_sts_unexp_error;

3405: EXCEPTION
3406: WHEN OTHERS THEN
3407: ROLLBACK TO inc_data_prep_start;
3408: x_errbuf := SQLERRM;
3409: x_retcode := gcs_utility_pkg.g_ret_sts_unexp_error;
3410: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3411: fnd_log.STRING(fnd_log.level_error,
3412: g_pkg_name || '.' || l_api_name,
3413: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

Line 3413: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||

3409: x_retcode := gcs_utility_pkg.g_ret_sts_unexp_error;
3410: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
3411: fnd_log.STRING(fnd_log.level_error,
3412: g_pkg_name || '.' || l_api_name,
3413: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
3414: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3415: END IF;
3416: END gcs_incremental_data_prep;
3417: END gcs_data_prep_pkg;