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_DATA_PREP_PKG dependencies on FND_LOG

Line 103: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

99: l_tgt_dimension_grp_id NUMBER;
100:
101: BEGIN
102:
103: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
104: fnd_log.STRING(fnd_log.level_procedure,
105: g_pkg_name || '.' || l_api_name || '.begin',
106: '<>');
107: END IF;

Line 104: fnd_log.STRING(fnd_log.level_procedure,

100:
101: BEGIN
102:
103: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
104: fnd_log.STRING(fnd_log.level_procedure,
105: g_pkg_name || '.' || l_api_name || '.begin',
106: '<>');
107: END IF;
108:

Line 109: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

105: g_pkg_name || '.' || l_api_name || '.begin',
106: '<>');
107: END IF;
108:
109: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
110: fnd_log.STRING(fnd_log.level_statement,
111: g_pkg_name || '.' || l_api_name,
112: 'Beginning of Parameter Listing');
113: fnd_log.STRING(fnd_log.level_statement,

Line 110: fnd_log.STRING(fnd_log.level_statement,

106: '<>');
107: END IF;
108:
109: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
110: fnd_log.STRING(fnd_log.level_statement,
111: g_pkg_name || '.' || l_api_name,
112: 'Beginning of Parameter Listing');
113: fnd_log.STRING(fnd_log.level_statement,
114: g_pkg_name || '.' || l_api_name,

Line 113: fnd_log.STRING(fnd_log.level_statement,

109: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
110: fnd_log.STRING(fnd_log.level_statement,
111: g_pkg_name || '.' || l_api_name,
112: 'Beginning of Parameter Listing');
113: fnd_log.STRING(fnd_log.level_statement,
114: g_pkg_name || '.' || l_api_name,
115: 'Entity Id : ' || p_entity_id);
116: fnd_log.STRING(fnd_log.level_statement,
117: g_pkg_name || '.' || l_api_name,

Line 116: fnd_log.STRING(fnd_log.level_statement,

112: 'Beginning of Parameter Listing');
113: fnd_log.STRING(fnd_log.level_statement,
114: g_pkg_name || '.' || l_api_name,
115: 'Entity Id : ' || p_entity_id);
116: fnd_log.STRING(fnd_log.level_statement,
117: g_pkg_name || '.' || l_api_name,
118: 'Target Calendar Period Id: ' ||
119: p_target_cal_period_id);
120: fnd_log.STRING(fnd_log.level_statement,

Line 120: fnd_log.STRING(fnd_log.level_statement,

116: fnd_log.STRING(fnd_log.level_statement,
117: g_pkg_name || '.' || l_api_name,
118: 'Target Calendar Period Id: ' ||
119: p_target_cal_period_id);
120: fnd_log.STRING(fnd_log.level_statement,
121: g_pkg_name || '.' || l_api_name,
122: 'Ledger Id : ' || p_ledger_id);
123: fnd_log.STRING(fnd_log.level_statement,
124: g_pkg_name || '.' || l_api_name,

Line 123: fnd_log.STRING(fnd_log.level_statement,

119: p_target_cal_period_id);
120: fnd_log.STRING(fnd_log.level_statement,
121: g_pkg_name || '.' || l_api_name,
122: 'Ledger Id : ' || p_ledger_id);
123: fnd_log.STRING(fnd_log.level_statement,
124: g_pkg_name || '.' || l_api_name,
125: 'End of Parameter Listing');
126: END IF;
127:

Line 148: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

144: ELSE
145: p_period_mapping_required := 'Y';
146: END IF;
147:
148: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
149: fnd_log.STRING(fnd_log.level_procedure,
150: g_pkg_name || '.' || l_api_name || '.end',
151: '<>');
152: END IF;

Line 149: fnd_log.STRING(fnd_log.level_procedure,

145: p_period_mapping_required := 'Y';
146: END IF;
147:
148: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
149: fnd_log.STRING(fnd_log.level_procedure,
150: g_pkg_name || '.' || l_api_name || '.end',
151: '<>');
152: END IF;
153:

Line 191: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

187: --Bugfix 6037112: Added variable
188: l_mapping_required VARCHAR2(1) := 'N';
189:
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 ||

Line 192: fnd_log.STRING(fnd_log.level_procedure,

188: l_mapping_required VARCHAR2(1) := 'N';
189:
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 ||

Line 211: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

207: p_balance_type_code => p_balance_type_code,
208: p_period_mapping_required => l_mapping_required);
209:
210: IF (l_mapping_required = 'Y') THEN
211: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
212: fnd_log.STRING(fnd_log.level_statement,
213: g_pkg_name || '.' || l_api_name,
214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
215: SELECT fdl.cal_period_id, ' ||

Line 212: fnd_log.STRING(fnd_log.level_statement,

208: p_period_mapping_required => l_mapping_required);
209:
210: IF (l_mapping_required = 'Y') THEN
211: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
212: fnd_log.STRING(fnd_log.level_statement,
213: g_pkg_name || '.' || l_api_name,
214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
215: SELECT fdl.cal_period_id, ' ||
216: p_target_cal_period_id || '

Line 341: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

337: -- Bugfix 6072367: Set Year End Values Match to Y
338: p_year_end_values_match := 'Y';
339: /*
340: -- Check if Year Ends Match
341: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
342: fnd_log.STRING(fnd_log.level_statement,
343: g_pkg_name || '.' || l_api_name,
344: 'SELECT decode(COUNT (gcpmd.cal_period_map_id), 0, ''Y'', ''N'')
345: INTO p_year_end_values_match

Line 342: fnd_log.STRING(fnd_log.level_statement,

338: p_year_end_values_match := 'Y';
339: /*
340: -- Check if Year Ends Match
341: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
342: fnd_log.STRING(fnd_log.level_statement,
343: g_pkg_name || '.' || l_api_name,
344: 'SELECT decode(COUNT (gcpmd.cal_period_map_id), 0, ''Y'', ''N'')
345: INTO p_year_end_values_match
346: FROM gcs_cal_period_map_dtls gcpmd,

Line 377: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

373: AND fcpb_tgt.cal_period_id = gcpmg.target_cal_period_id
374: AND gcpm.target_calendar_id = fcpb_tgt.calendar_id
375: AND gcpm.target_dimension_group_id = fcpb_tgt.dimension_group_id;
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 = ' ||

Line 378: fnd_log.STRING(fnd_log.level_procedure,

374: AND gcpm.target_calendar_id = fcpb_tgt.calendar_id
375: AND gcpm.target_dimension_group_id = fcpb_tgt.dimension_group_id;
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 || ' ' ||

Line 398: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

394: END IF;
395:
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN
398: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
399: fnd_log.STRING(fnd_log.level_statement,
400: g_pkg_name || '.' || l_api_name,
401: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id )
402: VALUES (' ||

Line 399: fnd_log.STRING(fnd_log.level_statement,

395:
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN
398: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
399: fnd_log.STRING(fnd_log.level_statement,
400: g_pkg_name || '.' || l_api_name,
401: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id )
402: VALUES (' ||
403: p_target_cal_period_id || ', ' ||

Line 412: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

408: (source_cal_period_id, target_cal_period_id)
409: VALUES
410: (p_target_cal_period_id, p_target_cal_period_id);
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 = ' ||

Line 413: fnd_log.STRING(fnd_log.level_procedure,

409: VALUES
410: (p_target_cal_period_id, p_target_cal_period_id);
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 || ' ' ||

Line 445: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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,
447: g_pkg_name || '.' || l_api_name,
448: gcs_utility_pkg.g_module_enter ||
449: ' p_source_ledger_id = ' || p_source_ledger_id ||

Line 446: fnd_log.STRING(fnd_log.level_procedure,

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,
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 ||

Line 454: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

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'));
453: END IF;
454: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
455: fnd_log.STRING(fnd_log.level_statement,
456: g_pkg_name || '.' || l_api_name,
457: 'SELECT ghb.calendar_id, ghb.dimension_group_id
458: INTO l_calendar_id, l_dimension_grp_id

Line 455: fnd_log.STRING(fnd_log.level_statement,

451: ' p_hierarchy_id = ' || p_hierarchy_id || ' ' ||
452: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
453: END IF;
454: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
455: fnd_log.STRING(fnd_log.level_statement,
456: g_pkg_name || '.' || l_api_name,
457: 'SELECT ghb.calendar_id, ghb.dimension_group_id
458: INTO l_calendar_id, l_dimension_grp_id
459: FROM gcs_hierarchies_b ghb

Line 469: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

465: FROM gcs_hierarchies_b ghb
466: WHERE ghb.hierarchy_id = p_hierarchy_id;
467: -- retrieve the cal_period_map_id according to source data
468: -- (l_source_calendar_id, l_target_cal_period_id)
469: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
470: fnd_log.STRING(fnd_log.level_statement,
471: g_pkg_name || '.' || l_api_name,
472: ' SELECT gcpm.cal_period_map_id
473: INTO l_cal_period_map_id

Line 470: fnd_log.STRING(fnd_log.level_statement,

466: WHERE ghb.hierarchy_id = p_hierarchy_id;
467: -- retrieve the cal_period_map_id according to source data
468: -- (l_source_calendar_id, l_target_cal_period_id)
469: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
470: fnd_log.STRING(fnd_log.level_statement,
471: g_pkg_name || '.' || l_api_name,
472: ' SELECT gcpm.cal_period_map_id
473: INTO l_cal_period_map_id
474: FROM gcs_cal_period_maps gcpm,

Line 498: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

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,
500: g_pkg_name || '.' || l_api_name,
501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
502: SELECT fcpb.cal_period_id, p_source_cal_period_id

Line 499: fnd_log.STRING(fnd_log.level_statement,

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,
500: g_pkg_name || '.' || l_api_name,
501: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
502: SELECT fcpb.cal_period_id, p_source_cal_period_id
503: FROM fem_cal_periods_b fcpb,

Line 575: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

571: 'PRIOR',
572: l_cal_period_record.cal_period_year - 1,
573: 'FOLLOWING',
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'));

Line 576: fnd_log.STRING(fnd_log.level_procedure,

572: l_cal_period_record.cal_period_year - 1,
573: 'FOLLOWING',
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;

Line 588: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

584: INSERT INTO gcs_cal_period_maps_gt
585: (source_cal_period_id, target_cal_period_id)
586: VALUES
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 || '() ' ||

Line 589: fnd_log.STRING(fnd_log.level_procedure,

585: (source_cal_period_id, target_cal_period_id)
586: VALUES
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'));

Line 638: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

634: .version_id;
635: l_request_error_code VARCHAR2(400);
636: BEGIN
637:
638: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
639: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
640: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES.begin',
641: '<>');
642: END IF;

Line 639: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

635: l_request_error_code VARCHAR2(400);
636: BEGIN
637:
638: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
639: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
640: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES.begin',
641: '<>');
642: END IF;
643:

Line 644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

640: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES.begin',
641: '<>');
642: END IF;
643:
644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
646: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
647: 'Beginning of Parameter List');
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

641: '<>');
642: END IF;
643:
644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
646: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
647: 'Beginning of Parameter List');
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
649: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

644: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
646: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
647: 'Beginning of Parameter List');
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
649: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
650: 'Hierarchy Id: ' || p_hierarchy_id);
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

647: 'Beginning of Parameter List');
648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
649: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
650: 'Hierarchy Id: ' || p_hierarchy_id);
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
653: 'Entity Id : ' || p_entity_id);
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
655: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

650: 'Hierarchy Id: ' || p_hierarchy_id);
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
653: 'Entity Id : ' || p_entity_id);
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
655: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
656: 'Balance Type: ' || p_balance_type_code);
657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
658: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

653: 'Entity Id : ' || p_entity_id);
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
655: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
656: 'Balance Type: ' || p_balance_type_code);
657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
658: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
659: 'Prior Calendar Period: ' || p_prior_cal_period_id);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
661: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

656: 'Balance Type: ' || p_balance_type_code);
657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
658: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
659: 'Prior Calendar Period: ' || p_prior_cal_period_id);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
661: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
662: 'Target Calendar Period:' || p_tgt_cal_period_id);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
664: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

659: 'Prior Calendar Period: ' || p_prior_cal_period_id);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
661: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
662: 'Target Calendar Period:' || p_tgt_cal_period_id);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
664: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
665: 'Run Detail Identifier: ' || p_run_detail_id);
666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
667: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

662: 'Target Calendar Period:' || p_tgt_cal_period_id);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
664: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
665: 'Run Detail Identifier: ' || p_run_detail_id);
666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
667: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
668: 'Source Currency Code : ' || p_source_currency_code);
669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
670: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

665: 'Run Detail Identifier: ' || p_run_detail_id);
666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
667: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
668: 'Source Currency Code : ' || p_source_currency_code);
669: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
670: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
671: 'End of Parameter List');
672: END IF;
673:

Line 822: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

818: p_pre_prop_stat_entry_id => NULL,
819: p_request_error_code => l_request_error_code,
820: p_bp_request_error_code => l_request_error_code);
821:
822: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
824: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES.end',
825: '<>');
826: END IF;

Line 823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

819: p_request_error_code => l_request_error_code,
820: p_bp_request_error_code => l_request_error_code);
821:
822: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
824: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES.end',
825: '<>');
826: END IF;
827:

Line 830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

826: END IF;
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
832: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
833: 'Beginning of Exception');
834: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
832: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
833: 'Beginning of Exception');
834: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
835: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 834: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
832: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
833: 'Beginning of Exception');
834: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
835: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
836: SQLERRM);
837: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
838: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',

Line 837: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

833: 'Beginning of Exception');
834: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
835: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
836: SQLERRM);
837: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
838: g_pkg_name || '.RETRIEVE_PRIOR_PERIOD_ENTRIES',
839: 'End of Exception');
840:
841: END IF;

Line 908: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

904: BEGIN
905: -- bug 5071794 fix: we don't need the savepoint anymore since we'll need to commit
906: -- within Data Prep
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 ||

Line 909: fnd_log.STRING(fnd_log.level_procedure,

905: -- bug 5071794 fix: we don't need the savepoint anymore since we'll need to commit
906: -- within Data Prep
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 ||

Line 922: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

918: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
919: END IF;
920: -- Extract source ledger, currency, AND entity type information
921: BEGIN
922: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
923: fnd_log.STRING(fnd_log.level_statement,
924: g_pkg_name || '.' || l_api_name,
925: ' SELECT gea.ledger_id,
926: geca.currency_code,

Line 923: fnd_log.STRING(fnd_log.level_statement,

919: END IF;
920: -- Extract source ledger, currency, AND entity type information
921: BEGIN
922: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
923: fnd_log.STRING(fnd_log.level_statement,
924: g_pkg_name || '.' || l_api_name,
925: ' SELECT gea.ledger_id,
926: geca.currency_code,
927: DECODE (fla.dim_attribute_varchar_member,

Line 1009: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

1005: p_prior_cal_period_id => l_prior_cal_period_id);
1006:
1007: IF (l_prior_cal_period_id IS NULL) THEN
1008:
1009: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1010: fnd_log.STRING(fnd_log.level_statement,
1011: g_pkg_name || '.' || l_api_name,
1012: ' SELECT MAX (source_cal_period_id)
1013: INTO l_max_period

Line 1010: fnd_log.STRING(fnd_log.level_statement,

1006:
1007: IF (l_prior_cal_period_id IS NULL) THEN
1008:
1009: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1010: fnd_log.STRING(fnd_log.level_statement,
1011: g_pkg_name || '.' || l_api_name,
1012: ' SELECT MAX (source_cal_period_id)
1013: INTO l_max_period
1014: FROM gcs_cal_period_maps_gt');

Line 1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

1018: INTO l_max_period
1019: FROM gcs_cal_period_maps_gt;
1020:
1021: BEGIN
1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1023: fnd_log.STRING(fnd_log.level_statement,
1024: g_pkg_name || '.' || l_api_name,
1025: 'SELECT nvl(ownership_percent, 100) * 0.01
1026: INTO l_owner_percentage

Line 1023: fnd_log.STRING(fnd_log.level_statement,

1019: FROM gcs_cal_period_maps_gt;
1020:
1021: BEGIN
1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1023: fnd_log.STRING(fnd_log.level_statement,
1024: g_pkg_name || '.' || l_api_name,
1025: 'SELECT nvl(ownership_percent, 100) * 0.01
1026: INTO l_owner_percentage
1027: FROM gcs_cons_relationships gcr,

Line 1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1044: END;
1045:
1046: --In Full execution mode, we need to perform local to master value set mapping and
1047: --process all the data with source code of system.
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1050: g_pkg_name || '.' || l_api_name,
1051: 'l_source_currency_code : ' ||
1052: l_source_currency_code);

Line 1049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1045:
1046: --In Full execution mode, we need to perform local to master value set mapping and
1047: --process all the data with source code of system.
1048: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1050: g_pkg_name || '.' || l_api_name,
1051: 'l_source_currency_code : ' ||
1052: l_source_currency_code);
1053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1050: g_pkg_name || '.' || l_api_name,
1051: 'l_source_currency_code : ' ||
1052: l_source_currency_code);
1053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1054: g_pkg_name || '.' || l_api_name,
1055: 'p_target_cal_period_id : ' ||
1056: p_target_cal_period_id);
1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1053: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1054: g_pkg_name || '.' || l_api_name,
1055: 'p_target_cal_period_id : ' ||
1056: p_target_cal_period_id);
1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1058: g_pkg_name || '.' || l_api_name,
1059: 'l_max_period : ' || l_max_period);
1060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1061: g_pkg_name || '.' || l_api_name,

Line 1060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1056: p_target_cal_period_id);
1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1058: g_pkg_name || '.' || l_api_name,
1059: 'l_max_period : ' || l_max_period);
1060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1061: g_pkg_name || '.' || l_api_name,
1062: 'l_source_currency_type_code : ' ||
1063: l_source_currency_type_code);
1064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1061: g_pkg_name || '.' || l_api_name,
1062: 'l_source_currency_type_code : ' ||
1063: l_source_currency_type_code);
1064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1065: g_pkg_name || '.' || l_api_name,
1066: 'p_hierarchy_id : ' || p_hierarchy_id);
1067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1068: g_pkg_name || '.' || l_api_name,

Line 1067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1063: l_source_currency_type_code);
1064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1065: g_pkg_name || '.' || l_api_name,
1066: 'p_hierarchy_id : ' || p_hierarchy_id);
1067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1068: g_pkg_name || '.' || l_api_name,
1069: 'p_entity_id : ' || p_entity_id);
1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1071: g_pkg_name || '.' || l_api_name,

Line 1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1066: 'p_hierarchy_id : ' || p_hierarchy_id);
1067: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1068: g_pkg_name || '.' || l_api_name,
1069: 'p_entity_id : ' || p_entity_id);
1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1071: g_pkg_name || '.' || l_api_name,
1072: 'l_source_currency_code : ' ||
1073: l_source_currency_code);
1074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1071: g_pkg_name || '.' || l_api_name,
1072: 'l_source_currency_code : ' ||
1073: l_source_currency_code);
1074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1075: g_pkg_name || '.' || l_api_name,
1076: 'l_source_ledger_id : ' || l_source_ledger_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1078: g_pkg_name || '.' || l_api_name,

Line 1077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1073: l_source_currency_code);
1074: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1075: g_pkg_name || '.' || l_api_name,
1076: 'l_source_ledger_id : ' || l_source_ledger_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1078: g_pkg_name || '.' || l_api_name,
1079: 'l_year_end_match : ' || l_year_end_match);
1080: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1081: g_pkg_name || '.' || l_api_name,

Line 1080: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1076: 'l_source_ledger_id : ' || l_source_ledger_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1078: g_pkg_name || '.' || l_api_name,
1079: 'l_year_end_match : ' || l_year_end_match);
1080: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1081: g_pkg_name || '.' || l_api_name,
1082: 'l_source_currency_type_code : ' ||
1083: l_source_currency_type_code);
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1080: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1081: g_pkg_name || '.' || l_api_name,
1082: 'l_source_currency_type_code : ' ||
1083: l_source_currency_type_code);
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1085: g_pkg_name || '.' || l_api_name,
1086: 'p_balance_type_code : ' || p_balance_type_code);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: g_pkg_name || '.' || l_api_name,

Line 1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1083: l_source_currency_type_code);
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1085: g_pkg_name || '.' || l_api_name,
1086: 'p_balance_type_code : ' || p_balance_type_code);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: g_pkg_name || '.' || l_api_name,
1089: 'l_owner_percentage : ' || l_owner_percentage);
1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1091: g_pkg_name || '.' || l_api_name,

Line 1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1086: 'p_balance_type_code : ' || p_balance_type_code);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: g_pkg_name || '.' || l_api_name,
1089: 'l_owner_percentage : ' || l_owner_percentage);
1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1091: g_pkg_name || '.' || l_api_name,
1092: 'p_run_detail_id : ' || p_run_detail_id);
1093: END IF;
1094:

Line 1120: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1116: p_tgt_cal_period_id => p_target_cal_period_id,
1117: p_run_detail_id => p_run_detail_id,
1118: p_source_currency_code => l_source_currency_code);
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'));

Line 1121: fnd_log.STRING(fnd_log.level_procedure,

1117: p_run_detail_id => p_run_detail_id,
1118: p_source_currency_code => l_source_currency_code);
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;

Line 1134: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1130: -- ROLLBACK TO main_data_prep_start;
1131: fnd_message.set_name('GCS', 'GCS_DP_SRC_LEDGER_ERR');
1132: x_errbuf := fnd_message.get;
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'));

Line 1135: fnd_log.STRING(fnd_log.level_error,

1131: fnd_message.set_name('GCS', 'GCS_DP_SRC_LEDGER_ERR');
1132: x_errbuf := fnd_message.get;
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;

Line 1153: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1149: -- ROLLBACK TO main_data_prep_start;
1150: fnd_message.set_name('GCS', 'GCS_DP_SRC_DATA_ERR');
1151: x_errbuf := fnd_message.get;
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'));

Line 1154: fnd_log.STRING(fnd_log.level_error,

1150: fnd_message.set_name('GCS', 'GCS_DP_SRC_DATA_ERR');
1151: x_errbuf := fnd_message.get;
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;

Line 1167: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1163: p_pre_prop_stat_entry_id => NULL,
1164: p_request_error_code => x_errbuf);
1165: WHEN gcs_dp_dynamic_pkg.gcs_dp_proc_data_error THEN
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'));

Line 1168: fnd_log.STRING(fnd_log.level_error,

1164: p_request_error_code => x_errbuf);
1165: WHEN gcs_dp_dynamic_pkg.gcs_dp_proc_data_error THEN
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;

Line 1185: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1181: -- within Data Prep
1182: -- ROLLBACK TO main_data_prep_start;
1183: x_errbuf := SQLERRM;
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'));

Line 1186: fnd_log.STRING(fnd_log.level_error,

1182: -- ROLLBACK TO main_data_prep_start;
1183: x_errbuf := SQLERRM;
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;

Line 1395: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1391: l_api_name VARCHAR2(30) := ''INIT_LOCAL_TO_MASTER_MAPS'';
1392: l_cal_attribute_id NUMBER;
1393: l_cal_version_id NUMBER;
1394: BEGIN
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

Line 1397: fnd_log.STRING (fnd_log.level_procedure,

1393: l_cal_version_id NUMBER;
1394: BEGIN
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: || '' ''

Line 1409: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

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,
1412: g_pkg_name || ''.'' || l_api_name,
1413: '' SELECT fla.dim_attribute_numeric_member

Line 1411: fnd_log.STRING (fnd_log.level_statement,

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,
1412: g_pkg_name || ''.'' || l_api_name,
1413: '' SELECT fla.dim_attribute_numeric_member
1414: INTO l_source_global_vs_combo
1415: FROM fem_ledgers_attr fla,

Line 1455: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

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
1457: fnd_log.STRING (fnd_log.level_statement,
1458: g_pkg_name || ''.'' || l_api_name,
1459: '' SELECT value_set_id

Line 1457: fnd_log.STRING (fnd_log.level_statement,

1453: )
1454: THEN
1455: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1456: THEN
1457: fnd_log.STRING (fnd_log.level_statement,
1458: g_pkg_name || ''.'' || l_api_name,
1459: '' SELECT value_set_id
1460: INTO l_source_value_set_id
1461: FROM fem_global_vs_combo_defs

Line 1811: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1807: l_where_text := replace(l_where_text,
1808: ''AND fb.company_cost_center_org_id = geco.company_cost_center_org_id'',
1809: ''AND fcoh.parent_id = geco.company_cost_center_org_id'');
1810: end if;
1811: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1812: THEN
1813: fnd_log.STRING (fnd_log.level_statement,
1814: g_pkg_name || ''.'' || l_api_name,
1815: '' g_insert_statement = ''|| g_insert_statement

Line 1813: fnd_log.STRING (fnd_log.level_statement,

1809: ''AND fcoh.parent_id = geco.company_cost_center_org_id'');
1810: end if;
1811: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1812: THEN
1813: fnd_log.STRING (fnd_log.level_statement,
1814: g_pkg_name || ''.'' || l_api_name,
1815: '' g_insert_statement = ''|| g_insert_statement
1816: );
1817: fnd_log.STRING (fnd_log.level_statement,

Line 1817: fnd_log.STRING (fnd_log.level_statement,

1813: fnd_log.STRING (fnd_log.level_statement,
1814: g_pkg_name || ''.'' || l_api_name,
1815: '' g_insert_statement = ''|| g_insert_statement
1816: );
1817: fnd_log.STRING (fnd_log.level_statement,
1818: g_pkg_name || ''.'' || l_api_name,
1819: '' l_from_text = ''|| l_from_text
1820: );
1821: fnd_log.STRING (fnd_log.level_statement,

Line 1821: fnd_log.STRING (fnd_log.level_statement,

1817: fnd_log.STRING (fnd_log.level_statement,
1818: g_pkg_name || ''.'' || l_api_name,
1819: '' l_from_text = ''|| l_from_text
1820: );
1821: fnd_log.STRING (fnd_log.level_statement,
1822: g_pkg_name || ''.'' || l_api_name,
1823: '' l_where_text = ''|| l_where_text
1824: );
1825: END IF;

Line 1830: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

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,
1834: gcs_utility_pkg.g_module_success

Line 1832: fnd_log.STRING (fnd_log.level_procedure,

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,
1834: gcs_utility_pkg.g_module_success
1835: || '' Mapping Required : ''
1836: || l_mapping_required

Line 1848: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

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
1849: THEN
1850: fnd_log.STRING (fnd_log.level_error,
1851: g_pkg_name || ''.'' || l_api_name,
1852: gcs_utility_pkg.g_module_failure

Line 1850: fnd_log.STRING (fnd_log.level_error,

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
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

Line 1863: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

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
1865: fnd_log.STRING (fnd_log.level_error,
1866: g_pkg_name || ''.'' || l_api_name,
1867: gcs_utility_pkg.g_module_failure

Line 1865: fnd_log.STRING (fnd_log.level_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
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

Line 1878: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

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
1880: fnd_log.STRING (fnd_log.level_error,
1881: g_pkg_name || ''.'' || l_api_name,
1882: gcs_utility_pkg.g_module_failure

Line 1880: fnd_log.STRING (fnd_log.level_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
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

Line 1998: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

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
2000: fnd_log.STRING (fnd_log.level_procedure,
2001: g_pkg_name || ''.'' || l_api_name,
2002: gcs_utility_pkg.g_module_enter

Line 2000: fnd_log.STRING (fnd_log.level_procedure,

1996:
1997: BEGIN
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

Line 2031: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2027: THEN
2028: RAISE init_mapping_error;
2029: END IF;
2030:
2031: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2032: THEN
2033: fnd_log.STRING (fnd_log.level_statement,
2034: g_pkg_name || ''.'' || l_api_name,
2035: ''Mapping required flag: '' || l_mapping_required);

Line 2033: fnd_log.STRING (fnd_log.level_statement,

2029: END IF;
2030:
2031: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2032: THEN
2033: fnd_log.STRING (fnd_log.level_statement,
2034: g_pkg_name || ''.'' || l_api_name,
2035: ''Mapping required flag: '' || l_mapping_required);
2036: END IF;
2037:

Line 2056: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2052: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
2053: AND NVL(gea.effective_end_date, fcpa.date_assign_value ) ;
2054:
2055:
2056: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2057: THEN
2058: fnd_log.STRING (fnd_log.level_statement,
2059: g_pkg_name || ''.'' || l_api_name,
2060: ''Source system code: '' || l_source_system_code);

Line 2058: fnd_log.STRING (fnd_log.level_statement,

2054:
2055:
2056: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2057: THEN
2058: fnd_log.STRING (fnd_log.level_statement,
2059: g_pkg_name || ''.'' || l_api_name,
2060: ''Source system code: '' || l_source_system_code);
2061: END IF;
2062: EXCEPTION

Line 2068: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2064: RAISE no_data_error;
2065: END;
2066:
2067: -- bug fix 5074999: remove join to p_balance_type_code, which is redundant and incorrect
2068: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2069: THEN
2070: fnd_log.STRING (fnd_log.level_statement,
2071: g_pkg_name || ''.'' || l_api_name,
2072: ''SELECT cpmgt.source_cal_period_id cal_period_id

Line 2070: fnd_log.STRING (fnd_log.level_statement,

2066:
2067: -- bug fix 5074999: remove join to p_balance_type_code, which is redundant and incorrect
2068: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2069: THEN
2070: fnd_log.STRING (fnd_log.level_statement,
2071: g_pkg_name || ''.'' || l_api_name,
2072: ''SELECT cpmgt.source_cal_period_id cal_period_id
2073: BULK COLLECT INTO l_periods_list
2074: FROM fem_data_locations fdl,

Line 2145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2141:
2142: l_proc_body := '---------------------------------------
2143: -- this is the mapping required case --
2144: ---------------------------------------
2145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2146: THEN
2147: fnd_log.STRING (fnd_log.level_statement,
2148: g_pkg_name || ''.'' || l_api_name,
2149: '' g_insert_statement = ''

Line 2147: fnd_log.STRING (fnd_log.level_statement,

2143: -- this is the mapping required case --
2144: ---------------------------------------
2145: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2146: THEN
2147: fnd_log.STRING (fnd_log.level_statement,
2148: g_pkg_name || ''.'' || l_api_name,
2149: '' g_insert_statement = ''
2150: || g_insert_statement
2151: );

Line 2152: fnd_log.STRING (fnd_log.level_statement,

2148: g_pkg_name || ''.'' || l_api_name,
2149: '' g_insert_statement = ''
2150: || g_insert_statement
2151: );
2152: fnd_log.STRING (fnd_log.level_statement,
2153: g_pkg_name || ''.'' || l_api_name,
2154: '' FORALL counter IN l_periods_list.FIRST..l_periods_list.LAST ''
2155: || g_nl
2156: || '' EXECUTE IMMEDIATE g_insert_statement ''

Line 2324: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2320: l_stat_entry_id := NULL;
2321: END;
2322:
2323: -- insert data into gcs_entry_lines table
2324: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2325: THEN
2326: fnd_log.STRING (fnd_log.level_statement,
2327: g_pkg_name || ''.'' || l_api_name,
2328: ''' ||

Line 2326: fnd_log.STRING (fnd_log.level_statement,

2322:
2323: -- insert data into gcs_entry_lines table
2324: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2325: THEN
2326: fnd_log.STRING (fnd_log.level_statement,
2327: g_pkg_name || ''.'' || l_api_name,
2328: ''' ||
2329: replace(l_insert_from_gt_statement, '''', '''''') || '''
2330: );

Line 2350: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2346: COMMIT;
2347:
2348: -- recalculate P/L AND Retained Earnings accounts if year ends not match
2349: IF (l_entry_id IS NOT NULL AND p_year_end_values_match = ''N'') THEN
2350: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2351: THEN
2352: fnd_log.STRING (fnd_log.level_statement,
2353: g_pkg_name || ''.'' || l_api_name,
2354: '' SELECT decode(count(run_name), 0, ''''Y'''', ''''N'''')

Line 2352: fnd_log.STRING (fnd_log.level_statement,

2348: -- recalculate P/L AND Retained Earnings accounts if year ends not match
2349: IF (l_entry_id IS NOT NULL AND p_year_end_values_match = ''N'') THEN
2350: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2351: THEN
2352: fnd_log.STRING (fnd_log.level_statement,
2353: g_pkg_name || ''.'' || l_api_name,
2354: '' SELECT decode(count(run_name), 0, ''''Y'''', ''''N'''')
2355: INTO l_first_ever_data_prepped
2356: FROM gcs_cons_eng_runs

Line 2375: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2371: OR (cal_period_id = p_cal_period_record.cal_period_id
2372: AND status_code NOT IN (''NOT_STARTED'', ''IN_PROGRESS'')));
2373: IF ( l_first_ever_data_prepped = ''Y'' OR p_cal_period_record.cal_period_number = 1 )
2374: THEN
2375: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2376: THEN
2377: fnd_log.STRING (fnd_log.level_statement,
2378: g_pkg_name || ''.'' || l_api_name,
2379: '' UPDATE gcs_entry_lines gel

Line 2377: fnd_log.STRING (fnd_log.level_statement,

2373: IF ( l_first_ever_data_prepped = ''Y'' OR p_cal_period_record.cal_period_number = 1 )
2374: THEN
2375: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2376: THEN
2377: fnd_log.STRING (fnd_log.level_statement,
2378: g_pkg_name || ''.'' || l_api_name,
2379: '' UPDATE gcs_entry_lines gel
2380: SET gel.ytd_balance_e = gel.xtd_balance_e,
2381: gel.ytd_debit_balance_e = gel.ptd_debit_balance_e,

Line 2413: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2409: AND feata.version_id = g_eatc_batc_ver_id
2410: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
2411: AND gel.line_item_id = flia.line_item_id);
2412: ELSE
2413: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2414: THEN
2415: fnd_log.STRING (fnd_log.level_statement,
2416: g_pkg_name || ''.'' || l_api_name,
2417: '' UPDATE gcs_entry_lines gel

Line 2415: fnd_log.STRING (fnd_log.level_statement,

2411: AND gel.line_item_id = flia.line_item_id);
2412: ELSE
2413: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2414: THEN
2415: fnd_log.STRING (fnd_log.level_statement,
2416: g_pkg_name || ''.'' || l_api_name,
2417: '' UPDATE gcs_entry_lines gel
2418: SET (gel.ytd_balance_e, gel.ytd_credit_balance_e,gel.ytd_debit_balance_e) =
2419: (SELECT NVL (fb.ytd_balance_e, 0)

Line 2478: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2474: -- Suspense accounts
2475: IF l_entry_id IS NOT NULL
2476: THEN
2477: -- check balance criteria
2478: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2479: THEN
2480: fnd_log.STRING (fnd_log.level_statement,
2481: g_pkg_name || ''.'' || l_api_name,
2482: '' SELECT threshold_amount,

Line 2480: fnd_log.STRING (fnd_log.level_statement,

2476: THEN
2477: -- check balance criteria
2478: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2479: THEN
2480: fnd_log.STRING (fnd_log.level_statement,
2481: g_pkg_name || ''.'' || l_api_name,
2482: '' SELECT threshold_amount,
2483: threshold_currency
2484: INTO l_threshold,

Line 2536: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2532: l_proc_body := '
2533: -- bug fix 3800183
2534: IF (l_proportional_entry_id IS NOT NULL or l_stat_proportional_entry_id IS NOT NULL)
2535: THEN
2536: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2537: THEN
2538: fnd_log.STRING (fnd_log.level_statement,
2539: g_pkg_name || ''.'' || l_api_name,
2540: '' SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),

Line 2538: fnd_log.STRING (fnd_log.level_statement,

2534: IF (l_proportional_entry_id IS NOT NULL or l_stat_proportional_entry_id IS NOT NULL)
2535: THEN
2536: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2537: THEN
2538: fnd_log.STRING (fnd_log.level_statement,
2539: g_pkg_name || ''.'' || l_api_name,
2540: '' SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),
2541: NVL (fc_stat.minimum_accountable_unit, POWER (10, -fc_stat.PRECISION))
2542: INTO l_precision,

Line 2629: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2625: FROM gcs_system_options;
2626: -- If enabled then update the above created entry to populate the correct intercompany values according to the line_item value
2627: IF l_imap_enabled_flag = ''Y''
2628: THEN
2629: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2630: THEN
2631: fnd_log.STRING (fnd_log.level_statement,
2632: g_pkg_name || ''.'' || l_api_name,
2633: '' UPDATE gcs_entry_lines gel

Line 2631: fnd_log.STRING (fnd_log.level_statement,

2627: IF l_imap_enabled_flag = ''Y''
2628: THEN
2629: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2630: THEN
2631: fnd_log.STRING (fnd_log.level_statement,
2632: g_pkg_name || ''.'' || l_api_name,
2633: '' UPDATE gcs_entry_lines gel
2634: SET gel.intercompany_id = ( SELECT intercompany_id
2635: FROM gcs_interco_map_dtls gimd

Line 2659: 'IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

2655: END IF;' ||
2656: ------------------------------------------------------------------------------------
2657: --End of the code by Santosh Matam
2658: ------------------------------------------------------------------------------------
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

Line 2661: fnd_log.STRING (fnd_log.level_procedure,

2657: --End of the code by Santosh Matam
2658: ------------------------------------------------------------------------------------
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

Line 2683: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

2679: DELETE FROM gcs_entry_lines
2680: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2681: l_proportional_entry_id, l_stat_proportional_entry_id);
2682:
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

Line 2685: fnd_log.STRING (fnd_log.level_error,

2681: l_proportional_entry_id, l_stat_proportional_entry_id);
2682:
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

Line 2706: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

2702: DELETE FROM gcs_entry_lines
2703: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2704: l_proportional_entry_id, l_stat_proportional_entry_id);
2705:
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

Line 2708: fnd_log.STRING (fnd_log.level_error,

2704: l_proportional_entry_id, l_stat_proportional_entry_id);
2705:
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

Line 2723: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

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,
2725: g_pkg_name || ''.'' || l_api_name,
2726: gcs_utility_pkg.g_module_failure
2727: || '' ''

Line 2724: fnd_log.STRING (fnd_log.level_error,

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,
2725: g_pkg_name || ''.'' || l_api_name,
2726: gcs_utility_pkg.g_module_failure
2727: || '' ''
2728: || errbuf

Line 2753: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

2749: DELETE FROM gcs_entry_lines
2750: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2751: l_proportional_entry_id, l_stat_proportional_entry_id);
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: || '' ''

Line 2754: fnd_log.STRING (fnd_log.level_error,

2750: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
2751: l_proportional_entry_id, l_stat_proportional_entry_id);
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

Line 2807: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

2803: l_mapping_required VARCHAR2 (1);
2804: l_api_name VARCHAR2 (20) := ''PROCESS_INC_DATA'';
2805: l_imap_enabled_flag VARCHAR2 (1);
2806: BEGIN
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

Line 2809: fnd_log.STRING (fnd_log.level_procedure,

2805: l_imap_enabled_flag VARCHAR2 (1);
2806: BEGIN
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

Line 2836: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2832: SELECT gcs_entry_headers_s.NEXTVAL
2833: INTO x_stat_entry_id
2834: FROM DUAL;
2835: IF (l_mapping_required = ''N'') THEN
2836: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2837: THEN
2838: fnd_log.STRING (fnd_log.level_statement,
2839: g_pkg_name || ''.'' || l_api_name,
2840: ''' ||

Line 2838: fnd_log.STRING (fnd_log.level_statement,

2834: FROM DUAL;
2835: IF (l_mapping_required = ''N'') THEN
2836: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2837: THEN
2838: fnd_log.STRING (fnd_log.level_statement,
2839: g_pkg_name || ''.'' || l_api_name,
2840: ''' ||
2841: replace(l_inc_insert_statement, '''', '''''') || '''
2842: );

Line 2846: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

2842: );
2843: END IF;
2844: ' || l_inc_insert_statement || '
2845: ELSE
2846: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2847: THEN
2848: fnd_log.STRING (fnd_log.level_statement,
2849: g_pkg_name || ''.'' || l_api_name,
2850: '' g_insert_statement = ''

Line 2848: fnd_log.STRING (fnd_log.level_statement,

2844: ' || l_inc_insert_statement || '
2845: ELSE
2846: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
2847: THEN
2848: fnd_log.STRING (fnd_log.level_statement,
2849: g_pkg_name || ''.'' || l_api_name,
2850: '' g_insert_statement = ''
2851: || g_insert_statement
2852: );

Line 2853: fnd_log.STRING (fnd_log.level_statement,

2849: g_pkg_name || ''.'' || l_api_name,
2850: '' g_insert_statement = ''
2851: || g_insert_statement
2852: );
2853: fnd_log.STRING (fnd_log.level_statement,
2854: g_pkg_name || ''.'' || l_api_name,
2855: ''EXECUTE IMMEDIATE g_insert_statement ''
2856: || g_nl
2857: || '' USING ''

Line 3057: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

3053: -- Suspense accounts
3054: IF x_entry_id IS NOT NULL
3055: THEN
3056: -- check balance criteria
3057: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
3058: THEN
3059: fnd_log.STRING (fnd_log.level_statement,
3060: g_pkg_name || ''.'' || l_api_name,
3061: '' SELECT threshold_amount, threshold_currency

Line 3059: fnd_log.STRING (fnd_log.level_statement,

3055: THEN
3056: -- check balance criteria
3057: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
3058: THEN
3059: fnd_log.STRING (fnd_log.level_statement,
3060: g_pkg_name || ''.'' || l_api_name,
3061: '' SELECT threshold_amount, threshold_currency
3062: INTO l_threshold, l_threshold_currency
3063: FROM gcs_hierarchies_b

Line 3168: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

3164: FROM gcs_system_options;
3165: -- If enabled then update the above created entry to populate the correct intercompany values according to the line_item value
3166: IF l_imap_enabled_flag = ''Y''
3167: THEN
3168: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
3169: THEN
3170: fnd_log.STRING (fnd_log.level_statement,
3171: g_pkg_name || ''.'' || l_api_name,
3172: '' UPDATE gcs_entry_lines gel

Line 3170: fnd_log.STRING (fnd_log.level_statement,

3166: IF l_imap_enabled_flag = ''Y''
3167: THEN
3168: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
3169: THEN
3170: fnd_log.STRING (fnd_log.level_statement,
3171: g_pkg_name || ''.'' || l_api_name,
3172: '' UPDATE gcs_entry_lines gel
3173: SET gel.intercompany_id = ( SELECT intercompany_id
3174: FROM gcs_interco_map_dtls gimd

Line 3199: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

3195: ------------------------------------------------------------------------------------
3196: --End of the code by Santosh Matam
3197: ------------------------------------------------------------------------------------
3198: '
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

Line 3201: fnd_log.STRING (fnd_log.level_procedure,

3197: ------------------------------------------------------------------------------------
3198: '
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

Line 3215: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

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
3217: fnd_log.STRING (fnd_log.level_error,
3218: g_pkg_name || ''.'' || l_api_name,
3219: gcs_utility_pkg.g_module_failure

Line 3217: fnd_log.STRING (fnd_log.level_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
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

Line 3230: IF fnd_log.g_current_runtime_level <= fnd_log.level_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
3232: fnd_log.STRING (fnd_log.level_error,
3233: g_pkg_name || ''.'' || l_api_name,
3234: gcs_utility_pkg.g_module_failure

Line 3232: fnd_log.STRING (fnd_log.level_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
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

Line 3247: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

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,
3249: g_pkg_name || ''.'' || l_api_name,
3250: gcs_utility_pkg.g_module_failure
3251: || '' ''

Line 3248: fnd_log.STRING (fnd_log.level_error,

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,
3249: g_pkg_name || ''.'' || l_api_name,
3250: gcs_utility_pkg.g_module_failure
3251: || '' ''
3252: || errbuf

Line 3290: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

3286: -- this shouldn't happen because we know for sure at least line_item is required
3287: WHEN NO_DATA_FOUND THEN
3288: ROLLBACK TO create_process_start;
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'));

Line 3291: fnd_log.STRING(fnd_log.level_error,

3287: WHEN NO_DATA_FOUND THEN
3288: ROLLBACK TO create_process_start;
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;

Line 3306: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

3302: WHEN OTHERS THEN
3303: ROLLBACK TO create_process_start;
3304: x_errbuf := SQLERRM;
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'));

Line 3307: fnd_log.STRING(fnd_log.level_error,

3303: ROLLBACK TO create_process_start;
3304: x_errbuf := SQLERRM;
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;

Line 3364: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

3360: l_owner_percentage NUMBER;
3361: l_api_name VARCHAR2(30) := 'GCS_INCREMENTAL_DATA_PREP';
3362: BEGIN
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 ||

Line 3365: fnd_log.STRING(fnd_log.level_procedure,

3361: l_api_name VARCHAR2(30) := 'GCS_INCREMENTAL_DATA_PREP';
3362: BEGIN
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 ||

Line 3399: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

3395: x_prop_entry_id => x_prop_entry_id,
3396: x_stat_prop_entry_id => x_stat_prop_entry_id,
3397: errbuf => x_errbuf,
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'));

Line 3400: fnd_log.STRING(fnd_log.level_procedure,

3396: x_stat_prop_entry_id => x_stat_prop_entry_id,
3397: errbuf => x_errbuf,
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;

Line 3410: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

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 ||
3414: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 3411: fnd_log.STRING(fnd_log.level_error,

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 ||
3414: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3415: END IF;