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

Line 11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
13: := gcs_utility_pkg.g_dimension_attr_info;
14:
15: no_proc_data_err EXCEPTION;

Line 12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info

8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
13: := gcs_utility_pkg.g_dimension_attr_info;
14:
15: no_proc_data_err EXCEPTION;
16:

Line 13: := gcs_utility_pkg.g_dimension_attr_info;

9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
13: := gcs_utility_pkg.g_dimension_attr_info;
14:
15: no_proc_data_err EXCEPTION;
16:
17:

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

749: IF (procedureloglevel >= runtimeloglevel ) THEN
750: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_MERGE.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
751: END IF;
752:
753: -- FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
754:
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: IF (unexpectedloglevel >= runtimeloglevel ) THEN

Line 760: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

756: WHEN NO_DATA_FOUND THEN
757: IF (unexpectedloglevel >= runtimeloglevel ) THEN
758: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');
759: END IF;
760: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
761: -- 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
762: retcode := '0';
763: errbuf := 'GCS_NO_DATA_FOUND';
764: RAISE NO_DATA_FOUND;

Line 771: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

767: errbuf := substr( SQLERRM, 1, 2000);
768: IF (unexpectedloglevel >= runtimeloglevel ) THEN
769: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);
770: END IF;
771: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
772: -- 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
773: retcode := '0';
774: RAISE;
775:

Line 796: l_cal_period_info GCS_UTILITY_PKG.r_cal_period_info;

792: p_entry_id NUMBER,
793: p_hier_dataset_code NUMBER) IS
794:
795: l_ledger_id NUMBER;
796: l_cal_period_info GCS_UTILITY_PKG.r_cal_period_info;
797: l_cal_period_year NUMBER;
798: l_object_id NUMBER;
799: module VARCHAR2(30) := 'GCS_FEM_POST';
800:

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

808:
809: runtimeLogLevel := FND_LOG.g_current_runtime_level;
810:
811: IF (procedureloglevel >= runtimeloglevel ) THEN
812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;
814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));

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

819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));
821: END IF;
822:
823: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
824:
825: -- get ledger_id
826: SELECT fem_ledger_id
827: INTO l_ledger_id

Line 832: GCS_UTILITY_PKG.get_cal_period_details(p_cal_period_id, l_cal_period_info);

828: FROM GCS_HIERARCHIES_B
829: WHERE hierarchy_id = p_hierarchy_id;
830:
831: -- Get current and previous period information.
832: GCS_UTILITY_PKG.get_cal_period_details(p_cal_period_id, l_cal_period_info);
833:
834: l_cal_period_year := l_cal_period_info.cal_period_year;
835:
836: -- Get object_id

Line 942: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

938:
939: IF (procedureloglevel >= runtimeloglevel ) THEN
940: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
941: END IF;
942: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
943: -- 'gcs_fem_post' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
944: EXCEPTION
945: WHEN NO_DATA_FOUND THEN
946: IF (unexpectedloglevel >= runtimeloglevel ) THEN

Line 949: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

945: WHEN NO_DATA_FOUND THEN
946: IF (unexpectedloglevel >= runtimeloglevel ) THEN
947: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');
948: END IF;
949: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
950: -- 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
951: retcode := '0';
952: errbuf := 'GCS_NO_DATA_FOUND';
953: RAISE NO_DATA_FOUND;

Line 956: retcode := gcs_utility_pkg.g_ret_sts_warn;

952: errbuf := 'GCS_NO_DATA_FOUND';
953: RAISE NO_DATA_FOUND;
954:
955: WHEN no_proc_data_err THEN
956: retcode := gcs_utility_pkg.g_ret_sts_warn;
957: errbuf := 'No processing data found.';
958: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
959: fnd_log.STRING (fnd_log.level_error,
960: 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST',

Line 961: gcs_utility_pkg.g_module_failure

957: errbuf := 'No processing data found.';
958: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
959: fnd_log.STRING (fnd_log.level_error,
960: 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST',
961: gcs_utility_pkg.g_module_failure
962: || ' '
963: || errbuf
964: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
965: );

Line 973: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

969: errbuf := substr( SQLERRM, 1, 2000);
970: IF (unexpectedloglevel >= runtimeloglevel ) THEN
971: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);
972: END IF;
973: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
974: -- 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
975: retcode := '0';
976: RAISE;
977:

Line 993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;

989: l_ledger_id NUMBER;
990: l_objects_id DBMS_SQL.NUMBER_TABLE;
991: l_oper_entity_id NUMBER;
992: l_elim_entity_id NUMBER;
993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
995: g_oper_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN

Line 994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;

990: l_objects_id DBMS_SQL.NUMBER_TABLE;
991: l_oper_entity_id NUMBER;
992: l_elim_entity_id NUMBER;
993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
995: g_oper_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN
998:

Line 995: g_oper_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;

991: l_oper_entity_id NUMBER;
992: l_elim_entity_id NUMBER;
993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
995: g_oper_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN
998:
999: IF (procedureloglevel >= runtimeloglevel ) THEN

Line 996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;

992: l_elim_entity_id NUMBER;
993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;
995: g_oper_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').version_id;
996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN
998:
999: IF (procedureloglevel >= runtimeloglevel ) THEN
1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

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

996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN
998:
999: IF (procedureloglevel >= runtimeloglevel ) THEN
1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1001: END IF;
1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));

Line 1095: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

1091: WHEN NO_DATA_FOUND THEN
1092: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1093: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'GCS_NO_DATA_FOUND');
1094: END IF;
1095: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1096: -- 'GCS_FEM_DELETE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1097: retcode := '0';
1098: errbuf := 'GCS_NO_DATA_FOUND';
1099: RAISE NO_DATA_FOUND;

Line 1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

1102: errbuf := substr( SQLERRM, 1, 2000);
1103: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1104: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', errbuf);
1105: END IF;
1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1107: -- 'GCS_FEM_DELETE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1108: retcode := '0';
1109: RAISE;
1110: