4: --
5: -- PRIVATE GLOBAL VARIABLES
6: --
7: g_api VARCHAR2(40) := 'gcs.plsql.GCS_PERIOD_INIT_DYNAMIC_PKG';
8: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
9: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
10: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
11: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
12: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
6: --
7: g_api VARCHAR2(40) := 'gcs.plsql.GCS_PERIOD_INIT_DYNAMIC_PKG';
8: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
9: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
10: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
11: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
12: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
13: ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
14: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
8: g_li_eat_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
9: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id;
10: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
11: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
12: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
13: ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
14: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
15: ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
16:
10: g_li_eat_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
11: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id;
12: g_acct_type_attr_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
13: ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id;
14: g_acct_type_ver_id NUMBER := GCS_UTILITY_PKG.g_dimension_attr_info
15: ('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
16:
17:
18: --
64: BEGIN
65: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
67: g_api || '.' || fn_name,
68: GCS_UTILITY_PKG.g_module_enter || fn_name ||
69: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
70: END IF;
71:
72: --Bugfix 5449718: Adding information on key parameters
361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Processing for Next Year with Net to RE set to N');
362: END IF;
363:
364: -- find default org id for RE, in case bal_by_org is 'N'
365: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,
366: p_hierarchy_id);
367:
368: -- find default intercompany id for RE if specified
369: SELECT specific_intercompany_id
460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.' || fn_name, 'Processing for Next Year with Net to RE set to Y');
461: END IF;
462:
463: -- find default org id for RE, in case bal_by_org is 'N'
464: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_entity_id,
465: p_hierarchy_id);
466:
467: -- find default intercompany id for RE if specified
468: SELECT specific_intercompany_id
668:
669: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
670: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
671: g_api || '.' || fn_name,
672: GCS_UTILITY_PKG.g_module_success || fn_name ||
673: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
674: END IF;
675: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
676: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
671: g_api || '.' || fn_name,
672: GCS_UTILITY_PKG.g_module_success || fn_name ||
673: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
674: END IF;
675: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
676: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
677:
678: EXCEPTION
679: WHEN OTHERS THEN
679: WHEN OTHERS THEN
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
682: g_api || '.' || fn_name,
683: GCS_UTILITY_PKG.g_module_failure || fn_name ||
684: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
685: END IF;
686: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
687: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
682: g_api || '.' || fn_name,
683: GCS_UTILITY_PKG.g_module_failure || fn_name ||
684: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
685: END IF;
686: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
687: fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
688: RAISE;
689: END insert_entry_lines;
690: