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

Line 8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;

4: --
5: -- Private Package Variables and exceptions
6: --
7:
8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;
9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;
10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;

Line 9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;

5: -- Private Package Variables and exceptions
6: --
7:
8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;
9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;
10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:

Line 10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;

6: --
7:
8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;
9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;
10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;

Line 11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;

7:
8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;
9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;
10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;

8: G_LOG_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.level_statement;
9: G_LOG_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.level_procedure;
10: G_LOG_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.level_event;
11: G_LOG_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.level_error;
12: G_LOG_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.level_unexpected;
13:
14: G_API_VERSION CONSTANT NUMBER := 1.0;
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

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 135: g_log_current_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

131:
132: e_exp_error EXCEPTION;
133: BEGIN
134: -- set value of debug log current level
135: g_log_current_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
136: l_request_id := FND_GLOBAL.Conc_Request_Id;
137:
138: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
139: FEM_ENGINES_PKG.TECH_MESSAGE(

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 1678: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1674: p_msg_count => l_msg_count,
1675: p_msg_data => l_msg_data);
1676: END IF;
1677:
1678: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1679: FEM_ENGINES_PKG.TECH_MESSAGE(
1680: p_severity => FND_LOG.level_statement,
1681: p_module => C_MODULE,
1682: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');

Line 1680: p_severity => FND_LOG.level_statement,

1676: END IF;
1677:
1678: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1679: FEM_ENGINES_PKG.TECH_MESSAGE(
1680: p_severity => FND_LOG.level_statement,
1681: p_module => C_MODULE,
1682: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1683: END IF;
1684: RAISE e_unexp_error;

Line 1686: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1682: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1683: END IF;
1684: RAISE e_unexp_error;
1685: ELSE
1686: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1687: FEM_ENGINES_PKG.TECH_MESSAGE(
1688: p_severity => FND_LOG.level_statement,
1689: p_module => C_MODULE,
1690: p_msg_text => 'l_db_tab_name = '||l_db_tab_name);

Line 1688: p_severity => FND_LOG.level_statement,

1684: RAISE e_unexp_error;
1685: ELSE
1686: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1687: FEM_ENGINES_PKG.TECH_MESSAGE(
1688: p_severity => FND_LOG.level_statement,
1689: p_module => C_MODULE,
1690: p_msg_text => 'l_db_tab_name = '||l_db_tab_name);
1691: END IF;
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1688: p_severity => FND_LOG.level_statement,
1689: p_module => C_MODULE,
1690: p_msg_text => 'l_db_tab_name = '||l_db_tab_name);
1691: END IF;
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1693: FEM_ENGINES_PKG.TECH_MESSAGE(
1694: p_severity => FND_LOG.level_statement,
1695: p_module => C_MODULE,
1696: p_msg_text => 'l_tab_owner = '||l_tab_owner);

Line 1694: p_severity => FND_LOG.level_statement,

1690: p_msg_text => 'l_db_tab_name = '||l_db_tab_name);
1691: END IF;
1692: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1693: FEM_ENGINES_PKG.TECH_MESSAGE(
1694: p_severity => FND_LOG.level_statement,
1695: p_module => C_MODULE,
1696: p_msg_text => 'l_tab_owner = '||l_tab_owner);
1697: END IF;
1698: END IF;

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 2260: g_log_current_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2256: l_request_status VARCHAR2(10);
2257: l_return_status VARCHAR2(2);
2258: BEGIN
2259: -- set value of debug log current level
2260: g_log_current_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2261:
2262: IF G_LOG_LEVEL_PROCEDURE >= g_log_current_level THEN
2263: FEM_ENGINES_PKG.TECH_MESSAGE(
2264: p_severity => G_LOG_LEVEL_PROCEDURE,

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