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 FND_LOG_MESSAGES

Line 97: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

93: p_dataset_code IN VARCHAR2,
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;

Line 583: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

579: x_return_status OUT NOCOPY VARCHAR2
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);

Line 795: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

791: x_prev_req_id OUT NOCOPY NUMBER,
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);

Line 1106: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1102: p_table_name IN VARCHAR2,
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;

Line 1274: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1270: p_ledger_dc IN VARCHAR2,
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

Line 1383: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1379: x_update_interim_error_sql OUT NOCOPY VARCHAR2,
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;

Line 2226: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2222: p_source_system_code IN NUMBER,
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);

Line 2888: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2884: p_user_id IN NUMBER,
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;

Line 3192: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3188: p_msg_count IN NUMBER,
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;

Line 3281: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3277: x_msg_count OUT NOCOPY NUMBER,
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:

Line 3450: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3446: x_msg_count OUT NOCOPY NUMBER,
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;

Line 3570: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3566: x_msg_count OUT NOCOPY NUMBER,
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;

Line 3709: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3705: x_msg_count OUT NOCOPY NUMBER,
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;

Line 3970: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3966: x_msg_count OUT NOCOPY NUMBER,
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;

Line 4281: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

4277: x_msg_count OUT NOCOPY NUMBER,
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;

Line 4474: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

4470: x_msg_count OUT NOCOPY NUMBER,
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