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

Line 9: -- dimension info from gcs_utility_pkg

5: --
6:
7: -- The API name
8: g_pkg_name CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_WEBADI_PKG';
9: -- dimension info from gcs_utility_pkg
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
11: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
12: -- A newline character. Included for convenience when writing long strings.
13: g_nl VARCHAR2(1) := '

Line 10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;

6:
7: -- The API name
8: g_pkg_name CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_WEBADI_PKG';
9: -- dimension info from gcs_utility_pkg
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
11: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
12: -- A newline character. Included for convenience when writing long strings.
13: g_nl VARCHAR2(1) := '
14: ';

Line 11: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;

7: -- The API name
8: g_pkg_name CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_WEBADI_PKG';
9: -- dimension info from gcs_utility_pkg
10: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info := gcs_utility_pkg.g_dimension_attr_info;
11: g_gcs_dimension_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
12: -- A newline character. Included for convenience when writing long strings.
13: g_nl VARCHAR2(1) := '
14: ';
15:

Line 84: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||

80:
81: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
82: fnd_log.STRING(fnd_log.level_procedure,
83: g_pkg_name || '.' || l_api_name,
84: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
85: '() p_load_id= ' || p_load_id ||
86: ' p_load_name= ' || p_load_name ||
87: ' p_entity_name= ' || p_entity_name ||
88: ' p_balance_type= ' || p_balance_type || ' ' ||

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

177:
178: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
179: fnd_log.STRING(fnd_log.level_procedure,
180: g_pkg_name || '.' || l_api_name,
181: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
182: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
183: END IF;
184:
185:

Line 210: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||

206:
207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
208: fnd_log.STRING(fnd_log.level_procedure,
209: g_pkg_name || '.' || l_api_name,
210: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
211: '() p_hierarchy_id= ' || p_hierarchy_id ||
212: ' p_entity_id= ' || p_entity_id ||
213: ' p_cal_period_id= ' || p_cal_period_id || ' ' ||
214: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 243: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

239: g_pkg_name || '.' || l_api_name,
240: ' UPDATE gcs_historical_rates ghr set update_flag = ''N'', account_type_code = ' || g_nl ||
241: '( select dim_attribute_varchar_member from fem_ln_items_attr ' || g_nl ||
242: ' where attribute_id = ' ||
243: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
244: .attribute_id || g_nl || ' AND version_id = ' ||
245: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
246: .version_id || g_nl ||
247: ' and line_item_id = ghr.line_item_id)' || g_nl ||

Line 245: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

241: '( select dim_attribute_varchar_member from fem_ln_items_attr ' || g_nl ||
242: ' where attribute_id = ' ||
243: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
244: .attribute_id || g_nl || ' AND version_id = ' ||
245: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
246: .version_id || g_nl ||
247: ' and line_item_id = ghr.line_item_id)' || g_nl ||
248: ' WHERE hierarchy_id = ' || p_hierarchy_id || g_nl ||
249: ' AND entity_id = ' || p_entity_id || g_nl ||

Line 258: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

254: SET update_flag = 'N',
255: account_type_code = (select dim_attribute_varchar_member
256: from fem_ln_items_attr
257: where attribute_id =
258: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
259: .attribute_id
260: and version_id =
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
262: .version_id

Line 261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')

257: where attribute_id =
258: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
259: .attribute_id
260: and version_id =
261: gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
262: .version_id
263: and line_item_id = ghr.line_item_id)
264: WHERE hierarchy_id = p_hierarchy_id
265: AND entity_id = p_entity_id

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

302:
303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
304: fnd_log.STRING(fnd_log.level_procedure,
305: g_pkg_name || '.' || l_api_name,
306: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
307: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
308: END IF;
309:
310: EXCEPTION

Line 323: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||

319: -- Write the appropriate information to the execution report
320: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
321: fnd_log.STRING(fnd_log.level_error,
322: g_pkg_name || '.' || l_api_name,
323: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
324: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
325: END IF;
326: END hrate_import;
327:

Line 393: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||

389:
390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
391: fnd_log.STRING(fnd_log.level_procedure,
392: g_pkg_name || '.' || l_api_name,
393: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
394: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
395: END IF;
396:
397: gcs_utility_pkg.init_dimension_info;

Line 397: gcs_utility_pkg.init_dimension_info;

393: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
394: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
395: END IF;
396:
397: gcs_utility_pkg.init_dimension_info;
398:
399: -- Bugfix 5052607: Adding checks for dimension information count
400: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,

Line 402: 'Active dimension count: ' || gcs_utility_pkg.g_gcs_dimension_info.COUNT);

398:
399: -- Bugfix 5052607: Adding checks for dimension information count
400: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
402: 'Active dimension count: ' || gcs_utility_pkg.g_gcs_dimension_info.COUNT);
403: END IF;
404:
405: IF (gcs_utility_pkg.g_gcs_dimension_info.COUNT = 0) THEN
406: --We must skip the rest of the program if the active dimensions haven't been defined

Line 405: IF (gcs_utility_pkg.g_gcs_dimension_info.COUNT = 0) THEN

401: fnd_log.STRING(fnd_log.level_statement, g_pkg_name || '.' || l_api_name,
402: 'Active dimension count: ' || gcs_utility_pkg.g_gcs_dimension_info.COUNT);
403: END IF;
404:
405: IF (gcs_utility_pkg.g_gcs_dimension_info.COUNT = 0) THEN
406: --We must skip the rest of the program if the active dimensions haven't been defined
407: return 'SUCCESS';
408: END IF;
409:

Line 528: IF (gcs_utility_pkg.Get_Fem_Dim_Required(l_index_column_name) = 'Y' and

524: l_index_column_name := l_index_dim_info(l_counter).dim_col;
525:
526:
527: --Ensure the column is required for FEM
528: IF (gcs_utility_pkg.Get_Fem_Dim_Required(l_index_column_name) = 'Y' and
529: l_index_column_name <> 'ENTITY_ID') THEN
530: -- then set the user-chosen dimensions as visible and not-null
531: UPDATE bne_interface_cols_b
532: SET display_flag = 'Y',

Line 553: IF (gcs_utility_pkg.get_dimension_required(l_index_column_name) = 'Y' and

549: END IF;
550:
551:
552: --Ensure the column is required for GCS II
553: IF (gcs_utility_pkg.get_dimension_required(l_index_column_name) = 'Y' and
554: l_index_column_name <> 'ENTITY_ID') THEN
555:
556: --Code for DRM of Spread sheets other than Data Submission
557: g_non_ds_cnt := g_non_ds_cnt + 1;

Line 630: IF (gcs_utility_pkg.get_Hrate_Dim_required(l_index_column_name) = 'Y' and

626:
627:
628: --- Bug Fix : 5707630, HRates Enhancement
629: --- Start of the fix : 5707630
630: IF (gcs_utility_pkg.get_Hrate_Dim_required(l_index_column_name) = 'Y' and
631: l_index_column_name <> 'ENTITY_ID') THEN
632:
633: --Code for DRM of HIstorical Rates Spread sheet
634: l_hrate_drm_cnt := l_hrate_drm_cnt + 1;

Line 862: gcs_utility_pkg.g_nl ||

858: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
859: fnd_log.STRING(fnd_log.level_statement,
860: g_pkg_name || '.' || l_api_name,
861: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
862: gcs_utility_pkg.g_nl ||
863: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_TB_CNT''');
864: END IF;
865:
866: UPDATE bne_stored_sql

Line 930: gcs_utility_pkg.g_nl ||

926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
927: fnd_log.STRING(fnd_log.level_statement,
928: g_pkg_name || '.' || l_api_name,
929: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
930: gcs_utility_pkg.g_nl ||
931: ' WHERE application_id=l_app_id AND content_code=''GCS_AD_ENTRY_CNT''');
932: END IF;
933:
934: UPDATE bne_stored_sql

Line 990: gcs_utility_pkg.g_nl ||

986: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
987: fnd_log.STRING(fnd_log.level_statement,
988: g_pkg_name || '.' || l_api_name,
989: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
990: gcs_utility_pkg.g_nl ||
991: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_RE_CNT''');
992: END IF;
993:
994: UPDATE bne_stored_sql

Line 1048: gcs_utility_pkg.g_nl ||

1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1045: fnd_log.STRING(fnd_log.level_statement,
1046: g_pkg_name || '.' || l_api_name,
1047: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1048: gcs_utility_pkg.g_nl ||
1049: ' WHERE application_id=l_app_id AND content_code=''GCS_HRATE_CNT''');
1050: END IF;
1051:
1052: UPDATE bne_stored_sql

Line 1115: gcs_utility_pkg.g_nl ||

1111: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1112: fnd_log.STRING(fnd_log.level_statement,
1113: g_pkg_name || '.' || l_api_name,
1114: 'UPDATE bne_stored_SQL SET QUERY=' || l_query ||
1115: gcs_utility_pkg.g_nl ||
1116: ' WHERE application_id=l_app_id AND content_code=''GCS_ENTRY_LINES_CNT''');
1117: END IF;
1118:
1119: UPDATE bne_stored_sql

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

1128: -- Write the appropriate information to the execution report
1129: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1130: fnd_log.STRING(fnd_log.level_procedure,
1131: g_pkg_name || '.' || l_api_name,
1132: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1133: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1134: END IF;
1135:
1136: RETURN 'SUCCESS';

Line 1147: gcs_utility_pkg.g_module_failure || ' ' ||

1143: -- Write the appropriate information to the execution report
1144: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1145: fnd_log.STRING(fnd_log.level_error,
1146: g_pkg_name || '.' || l_api_name,
1147: gcs_utility_pkg.g_module_failure || ' ' ||
1148: l_api_name || '() ' ||
1149: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1150: fnd_log.STRING(fnd_log.level_error,
1151: g_pkg_name || '.' || l_api_name,

Line 1210: gcs_utility_pkg.g_module_enter || ' p_sequence_num = ' ||

1206:
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1208: fnd_log.STRING(fnd_log.level_procedure,
1209: g_pkg_name || '.' || l_api_name,
1210: gcs_utility_pkg.g_module_enter || ' p_sequence_num = ' ||
1211: p_sequence_num || ', p_dimension_varchar_label = ' ||
1212: p_dimension_varchar_label || ' ' ||
1213: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1214: END IF;

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

1450: -- Write the appropriate information to the execution report
1451: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1452: fnd_log.STRING(fnd_log.level_error,
1453: g_pkg_name || '.' || l_api_name,
1454: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1455: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1456: END IF;
1457:
1458: -- Bug Fix : 5232709 , End

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

1477: -- Write the appropriate information to the execution report
1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1479: fnd_log.STRING(fnd_log.level_error,
1480: g_pkg_name || '.' || l_api_name,
1481: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1482: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1483: END IF;
1484: END dim_member_import;
1485:

Line 1554: gcs_utility_pkg.g_module_enter ||

1550:
1551: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1552: fnd_log.STRING(fnd_log.level_procedure,
1553: g_pkg_name || '.' || l_api_name,
1554: gcs_utility_pkg.g_module_enter ||
1555: ' p_sequence_num = ' || p_sequence_num ||
1556: ', p_dimension_varchar_label = ' ||
1557: p_dimension_varchar_label || ', p_hierarchy_name = ' ||
1558: p_hierarchy_name || ', p_version_name = ' ||

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

1832:
1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1834: fnd_log.STRING(fnd_log.level_procedure,
1835: g_pkg_name || '.' || l_api_name,
1836: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1837: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1838: END IF;
1839:
1840: EXCEPTION

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

1869: -- Write the appropriate information to the execution report
1870: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1871: fnd_log.STRING(fnd_log.level_error,
1872: g_pkg_name || '.' || l_api_name,
1873: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
1874: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1875: END IF;
1876: END dim_hier_import;
1877: