DBA Data[Home] [Help]

APPS.GCS_BUILD_EPB_DIM_TR_PKG dependencies on GCS_UTILITY_PKG

Line 93: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIM_TR_PKG' ||

89: BEGIN
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
93: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIM_TR_PKG' ||
94: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
95: END IF;
96: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
97:

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
93: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIM_TR_PKG' ||
94: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
95: END IF;
96: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
97:
98:
99: --Bugfix 5308890: Comment out the check for intercompany, natural account, and financial element as they are now supported in EPB
100: /*

Line 103: l_felm_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('FINANCIAL_ELEM_ID').associated_value_set_id;

99: --Bugfix 5308890: Comment out the check for intercompany, natural account, and financial element as they are now supported in EPB
100: /*
101: -- Set the value sets
102: begin
103: l_felm_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('FINANCIAL_ELEM_ID').associated_value_set_id;
104: exception
105: when no_data_found then
106: l_felm_value_set_id := -1;
107: end;

Line 110: l_interco_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('INTERCOMPANY_ID').associated_value_set_id;

106: l_felm_value_set_id := -1;
107: end;
108:
109: begin
110: l_interco_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('INTERCOMPANY_ID').associated_value_set_id;
111: exception
112: when no_data_found then
113: l_interco_value_set_id := -1;
114: end;

Line 117: l_na_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('NATURAL_ACCOUNT_ID').associated_value_set_id;

113: l_interco_value_set_id := -1;
114: end;
115:
116: begin
117: l_na_value_set_id := gcs_utility_pkg.g_gcs_dimension_info ('NATURAL_ACCOUNT_ID').associated_value_set_id;
118: exception
119: when no_data_found then
120: l_na_value_set_id := -1;
121: end;

Line 340: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

336: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
337: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
338: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
339:
340: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
341:
342: DIM_LOAD_ERROR EXCEPTION;
343:
344:

Line 362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));

358:
359: runtimeLogLevel := FND_LOG.g_current_runtime_level;
360:
361: IF (procedureloglevel >= runtimeloglevel ) THEN
362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
363: END IF;
364:
365: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Dim'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
366:

Line 365: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Dim'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

361: IF (procedureloglevel >= runtimeloglevel ) THEN
362: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_dim_tr_pkg.gcs_epb_tr_dim.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
363: END IF;
364:
365: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Dim'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
366:
367: ';
368:
369: curr_pos := 1;

Line 823: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' ||

819: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
820:
821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIMTR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
823: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' ||
824: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
825: END IF;
826: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
827:

Line 826: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DIMTR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
823: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' ||
824: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
825: END IF;
826: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 836: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DIMTR_PKG' ||

832: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
833: SUBSTR(SQLERRM, 1, 255));
834: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
835: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
836: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DIMTR_PKG' ||
837: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
838: END IF;
839: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
840: 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 839: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

835: 'GCS_BUILD_EPB_DIM_TR_PKG' || '.' || 'BUILD_EPB_DIMTR_PKG',
836: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DIMTR_PKG' ||
837: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
838: END IF;
839: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
840: 'BUILD_EPB_DIMTR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
841:
842: END build_epb_dimtr_pkg;
843: