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_BUILD_EPB_DATA_TR_PKG dependencies on GCS_UTILITY_PKG

Line 72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||

68: BEGIN
69:
70: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||
73: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
74: END IF;
75: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
76:

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

71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||
73: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
74: END IF;
75: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
76:
77:
78: -- Set the epb table name
79: SELECT epb_table_name

Line 351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

347: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
348: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
349: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
350:
351: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
352: -- bugfix 5569522: Added for FND logging.
353: g_api VARCHAR2(200) := ''gcs.plsql.GCS_DYN_EPB_DATATR_PKG'';
354:
355: -- bugfix 5569522: Added p_analysis_cycle_id parameter for launching business

Line 390: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;

386: l_req_id NUMBER := FND_GLOBAL.conc_request_id;
387: l_login_id NUMBER := FND_GLOBAL.login_id;
388: l_user_id NUMBER := FND_GLOBAL.user_id;
389:
390: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
391: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
392:
393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;

Line 391: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;

387: l_login_id NUMBER := FND_GLOBAL.login_id;
388: l_user_id NUMBER := FND_GLOBAL.user_id;
389:
390: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
391: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
392:
393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;

Line 394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;

390: l_end_date_attribute_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
391: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
392:
393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
396: l_basic_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
397: l_basic_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
398:

Line 395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;

391: l_end_date_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
392:
393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
396: l_basic_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
397: l_basic_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
398:
399: l_end_date DATE;

Line 396: l_basic_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;

392:
393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
396: l_basic_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
397: l_basic_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
398:
399: l_end_date DATE;
400:

Line 397: l_basic_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;

393:
394: l_ext_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id;
395: l_ext_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id;
396: l_basic_acct_type_attr_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id;
397: l_basic_acct_type_version_id NUMBER := gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;
398:
399: l_end_date DATE;
400:
401: module VARCHAR2(30) := ''GCS_EPB_TR_DATA'';

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

411:
412: runtimeLogLevel := FND_LOG.g_current_runtime_level;
413:
414: IF (procedureloglevel >= runtimeloglevel ) THEN
415: FND_LOG.STRING(procedureloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data.begin'' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, ''DD-MON-YYYY HH:MI:SS''));
416: END IF;
417: IF (statementloglevel >= runtimeloglevel ) THEN
418: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_hierarchy_id = '' || to_char(p_hierarchy_id));
419: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_balance_type_code = '' || p_balance_type_code);

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

420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );

Line 1059: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;

1055: l_msg_count NUMBER;
1056: l_msg_data VARCHAR2(1000);
1057: l_return_status VARCHAR2(10);
1058: l_end_date_attribute_id NUMBER :=
1059: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1060: l_end_date_version_id NUMBER :=
1061: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1062: l_start_date_attribute_id NUMBER :=
1063: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').attribute_id;

Line 1061: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;

1057: l_return_status VARCHAR2(10);
1058: l_end_date_attribute_id NUMBER :=
1059: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1060: l_end_date_version_id NUMBER :=
1061: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1062: l_start_date_attribute_id NUMBER :=
1063: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').attribute_id;
1064: l_start_date_version_id NUMBER :=
1065: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').version_id;

Line 1063: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').attribute_id;

1059: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').attribute_id;
1060: l_end_date_version_id NUMBER :=
1061: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1062: l_start_date_attribute_id NUMBER :=
1063: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').attribute_id;
1064: l_start_date_version_id NUMBER :=
1065: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').version_id;
1066: l_request_id NUMBER;
1067: l_conc_req_status BOOLEAN;

Line 1065: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').version_id;

1061: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_END_DATE'').version_id;
1062: l_start_date_attribute_id NUMBER :=
1063: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').attribute_id;
1064: l_start_date_version_id NUMBER :=
1065: gcs_utility_pkg.g_dimension_attr_info(''CAL_PERIOD_ID-CAL_PERIOD_START_DATE'').version_id;
1066: l_request_id NUMBER;
1067: l_conc_req_status BOOLEAN;
1068:
1069: BEGIN

Line 1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||

1208: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
1209:
1210: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||
1213: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1214: END IF;
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1216:

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

1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||
1213: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1214: END IF;
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1225: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DATATR_PKG' ||

1221: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1222: SUBSTR(SQLERRM, 1, 255));
1223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1224: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1225: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DATATR_PKG' ||
1226: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1227: END IF;
1228: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1229: 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

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

1224: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1225: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DATATR_PKG' ||
1226: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1227: END IF;
1228: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1229: 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1230: END build_epb_datatr_pkg;
1231:
1232: END GCS_BUILD_EPB_DATA_TR_PKG;