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.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_SOURCE_DATA_LOADER_PKG

Line 1: PACKAGE BODY FEM_SOURCE_DATA_LOADER_PKG AS

1: PACKAGE BODY FEM_SOURCE_DATA_LOADER_PKG AS
2: /* $Header: fem_srcdata_ldr.plb 120.7 2008/01/23 19:08:28 gcheng ship $ */
3:
4: --
5: -- Private Package Variables and exceptions

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';

16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_SOURCE_DATA_LOADER_PKG';
21:
22: G_DEFAULT_DIM_GRP_SIZE CONSTANT NUMBER := 5;
23: G_MAX_DIMS CONSTANT NUMBER := 150;
24: G_INSERT_STMT_TYPE CONSTANT VARCHAR2(10) := 'INSERT';

Line 98: 'fem.plsql.fem_source_data_loader_pkg.main';

94: p_source_system_code IN VARCHAR2
95: ) IS
96:
97: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
98: 'fem.plsql.fem_source_data_loader_pkg.main';
99:
100: l_obj_def_id NUMBER;
101: l_ledger_id NUMBER;
102: l_cal_period_id NUMBER;

Line 311: p_eng_prg => 'FEM_SOURCE_DATA_LOADER_PKG.Process_Data',

307: p_rule_id => l_object_id,
308: p_eng_step => 'ALL',
309: p_data_table => l_interface_table_name,
310: p_eng_sql => null,
311: p_eng_prg => 'FEM_SOURCE_DATA_LOADER_PKG.Process_Data',
312: p_condition => l_condition,
313: p_failed_req_id => l_prev_req_id,
314: p_reuse_slices => l_reuse_slices,
315: p_arg1 => FND_GLOBAL.Conc_Request_Id,

Line 584: 'fem.plsql.fem_source_data_loader_pkg.validate_loader_parameters';

580: ) IS
581: C_OBJECT_TYPE CONSTANT VARCHAR2(18) := 'SOURCE_DATA_LOADER';
582: C_TABLE_CLASSIFICATION CONSTANT VARCHAR2(17) := 'SOURCE_DATA_TABLE';
583: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
584: 'fem.plsql.fem_source_data_loader_pkg.validate_loader_parameters';
585:
586: l_msg_count NUMBER;
587: l_msg_data VARCHAR2(4000);
588: l_ledger_calendar_id NUMBER;

Line 796: 'fem.plsql.fem_source_data_loader_pkg.register_process_execution';

792: x_exec_state OUT NOCOPY VARCHAR2,
793: x_return_status OUT NOCOPY VARCHAR2
794: ) IS
795: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
796: 'fem.plsql.fem_source_data_loader_pkg.register_process_execution';
797: l_obj_exec_failed VARCHAR2(1);
798: l_msg_count NUMBER;
799: l_msg_data VARCHAR2(4000);
800: l_return_status VARCHAR2(1);

Line 1107: 'fem.plsql.fem_source_data_loader_pkg.populate_xdim_info_tbl';

1103: p_ledger_id IN NUMBER,
1104: x_return_status OUT NOCOPY VARCHAR2
1105: ) IS
1106: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1107: 'fem.plsql.fem_source_data_loader_pkg.populate_xdim_info_tbl';
1108:
1109: l_global_vs_combo_id NUMBER;
1110: l_msg_count NUMBER;
1111: l_msg_data VARCHAR2(4000);

Line 1275: 'fem.plsql.fem_source_data_loader_pkg.set_mp_condition';

1271: x_condition OUT NOCOPY VARCHAR2,
1272: x_return_status OUT NOCOPY VARCHAR2
1273: ) IS
1274: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1275: 'fem.plsql.fem_source_data_loader_pkg.set_mp_condition';
1276:
1277: BEGIN
1278: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
1279: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1384: 'fem.plsql.fem_source_data_loader_pkg.prepare_dynamic_sql';

1380: x_insert_target_sql OUT NOCOPY VARCHAR2,
1381: x_return_status OUT NOCOPY VARCHAR2
1382: ) IS
1383: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1384: 'fem.plsql.fem_source_data_loader_pkg.prepare_dynamic_sql';
1385:
1386: TYPE nondim_col_tbl_type IS TABLE OF FEM_TAB_COLUMNS_V.column_name%TYPE;
1387: l_nondim_target_col_tbl nondim_col_tbl_type;
1388: l_nondim_int_col_tbl nondim_col_tbl_type;

Line 2227: 'fem.plsql.fem_source_data_loader_pkg.process_data';

2223: p_schema_name IN VARCHAR2,
2224: p_condition IN VARCHAR2
2225: ) IS
2226: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2227: 'fem.plsql.fem_source_data_loader_pkg.process_data';
2228:
2229: l_slc_id NUMBER;
2230: l_slc_val1 VARCHAR2(240);
2231: l_slc_val2 VARCHAR2(240);

Line 2889: 'fem.plsql.fem_source_data_loader_pkg.post_process';

2885: p_login_id IN NUMBER,
2886: x_return_status OUT NOCOPY VARCHAR2
2887: ) IS
2888: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2889: 'fem.plsql.fem_source_data_loader_pkg.post_process';
2890:
2891: l_num_errors_reprocessed NUMBER;
2892: l_num_rows_loaded NUMBER;
2893: l_num_rows_rejected NUMBER;

Line 3193: 'fem.plsql.fem_source_data_loader_pkg.get_put_messages';

3189: p_msg_data IN VARCHAR2
3190: )
3191: IS
3192: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3193: 'fem.plsql.fem_source_data_loader_pkg.get_put_messages';
3194: l_msg_count NUMBER;
3195: l_msg_data VARCHAR2(4000);
3196: l_msg_out NUMBER;
3197: l_message VARCHAR2(4000);

Line 3282: 'fem.plsql.fem_source_data_loader_pkg.validate_obj_def';

3278: x_msg_data OUT NOCOPY VARCHAR2,
3279: x_return_status OUT NOCOPY VARCHAR2
3280: ) IS
3281: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3282: 'fem.plsql.fem_source_data_loader_pkg.validate_obj_def';
3283: C_API_VERSION CONSTANT NUMBER := 1.0;
3284: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Obj_Def';
3285:
3286: l_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;

Line 3451: 'fem.plsql.fem_source_data_loader_pkg.validate_table';

3447: x_msg_data OUT NOCOPY VARCHAR2,
3448: x_return_status OUT NOCOPY VARCHAR2
3449: ) IS
3450: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3451: 'fem.plsql.fem_source_data_loader_pkg.validate_table';
3452: C_API_VERSION CONSTANT NUMBER := 1.0;
3453: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Table';
3454: l_count NUMBER := 0;
3455: BEGIN

Line 3571: 'fem.plsql.fem_source_data_loader_pkg.validate_exec_mode';

3567: x_msg_data OUT NOCOPY VARCHAR2,
3568: x_return_status OUT NOCOPY VARCHAR2
3569: ) IS
3570: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3571: 'fem.plsql.fem_source_data_loader_pkg.validate_exec_mode';
3572: C_API_VERSION CONSTANT NUMBER := 1.0;
3573: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Exec_Mode';
3574: l_count NUMBER := 0;
3575:

Line 3710: 'fem.plsql.fem_source_data_loader_pkg.validate_ledger';

3706: x_msg_data OUT NOCOPY VARCHAR2,
3707: x_return_status OUT NOCOPY VARCHAR2
3708: ) IS
3709: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3710: 'fem.plsql.fem_source_data_loader_pkg.validate_ledger';
3711: C_API_VERSION CONSTANT NUMBER := 1.0;
3712: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Ledger';
3713: l_ledger_dim_id NUMBER;
3714: l_dim_attr_id NUMBER;

Line 3971: 'fem.plsql.fem_source_data_loader_pkg.validate_cal_period';

3967: x_msg_data OUT NOCOPY VARCHAR2,
3968: x_return_status OUT NOCOPY VARCHAR2
3969: ) IS
3970: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3971: 'fem.plsql.fem_source_data_loader_pkg.validate_cal_period';
3972: C_API_VERSION CONSTANT NUMBER := 1.0;
3973: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Cal_Period';
3974: l_cal_per_calendar_id NUMBER;
3975: l_cal_per_dim_grp_id NUMBER;

Line 4282: 'fem.plsql.fem_source_data_loader_pkg.validate_dataset';

4278: x_msg_data OUT NOCOPY VARCHAR2,
4279: x_return_status OUT NOCOPY VARCHAR2
4280: ) IS
4281: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4282: 'fem.plsql.fem_source_data_loader_pkg.validate_dataset';
4283: C_API_VERSION CONSTANT NUMBER := 1.0;
4284: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Dataset';
4285: l_dataset_dim_id NUMBER;
4286: l_dim_attr_id NUMBER;

Line 4475: 'fem.plsql.fem_source_data_loader_pkg.validate_source_system';

4471: x_msg_data OUT NOCOPY VARCHAR2,
4472: x_return_status OUT NOCOPY VARCHAR2
4473: ) IS
4474: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4475: 'fem.plsql.fem_source_data_loader_pkg.validate_source_system';
4476: C_API_VERSION CONSTANT NUMBER := 1.0;
4477: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Source_System';
4478: BEGIN
4479:

Line 4557: END FEM_SOURCE_DATA_LOADER_PKG;

4553: x_return_status := G_RET_STS_UNEXP_ERROR;
4554:
4555: END Validate_Source_System;
4556:
4557: END FEM_SOURCE_DATA_LOADER_PKG;