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.PFT_ACCTRELCONS_PUB dependencies on FEM_PL_PKG

Line 15: --Constants for output table names being registered with fem_pl_pkg

11: -- Constants for p_exec_status_code
12: g_exec_status_error_rerun CONSTANT VARCHAR2(30) := 'ERROR_RERUN';
13: g_exec_status_success CONSTANT VARCHAR2(30) := 'SUCCESS';
14:
15: --Constants for output table names being registered with fem_pl_pkg
16: -- API register_table method.
17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';
18:
19: --constant for sql_stmt_type

Line 939: -- Call the FEM_PL_PKG.Register_Request API procedure to register

935: ,p_msg_text => 'BEGIN');
936:
937: SAVEPOINT register_request_pub;
938:
939: -- Call the FEM_PL_PKG.Register_Request API procedure to register
940: -- the concurrent request in FEM_PL_REQUESTS.
941: FEM_PL_PKG.Register_Request(
942: p_api_version => G_CALLING_API_VERSION
943: ,p_commit => FND_API.G_FALSE

Line 941: FEM_PL_PKG.Register_Request(

937: SAVEPOINT register_request_pub;
938:
939: -- Call the FEM_PL_PKG.Register_Request API procedure to register
940: -- the concurrent request in FEM_PL_REQUESTS.
941: FEM_PL_PKG.Register_Request(
942: p_api_version => G_CALLING_API_VERSION
943: ,p_commit => FND_API.G_FALSE
944: ,p_cal_period_id => p_param_rec.output_cal_period_id
945: ,p_ledger_id => p_param_rec.ledger_id

Line 1047: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register

1043: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1044: ,p_module => G_BLOCK||'.'||l_api_name
1045: ,p_msg_text => 'BEGIN');
1046:
1047: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register
1048: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
1049: -- an object definition lock.
1050: FEM_PL_PKG.Register_Object_Def (
1051: p_api_version => 1.0

Line 1050: FEM_PL_PKG.Register_Object_Def (

1046:
1047: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register
1048: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
1049: -- an object definition lock.
1050: FEM_PL_PKG.Register_Object_Def (
1051: p_api_version => 1.0
1052: ,p_commit => FND_API.G_TRUE
1053: ,p_request_id => p_param_rec.request_id
1054: ,p_object_id => p_object_id

Line 1119: -- Call the FEM_PL_PKG.Register_Obj_Exec_Step API procedure

1115: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1116: ,p_module => G_BLOCK||'.'||l_api_name
1117: ,p_msg_text => 'BEGIN');
1118:
1119: -- Call the FEM_PL_PKG.Register_Obj_Exec_Step API procedure
1120: -- to register step in fem_pl_obj_steps.
1121: FEM_PL_PKG.Register_Obj_Exec_Step (
1122: p_api_version => 1.0
1123: ,p_commit => FND_API.G_TRUE

Line 1121: FEM_PL_PKG.Register_Obj_Exec_Step (

1117: ,p_msg_text => 'BEGIN');
1118:
1119: -- Call the FEM_PL_PKG.Register_Obj_Exec_Step API procedure
1120: -- to register step in fem_pl_obj_steps.
1121: FEM_PL_PKG.Register_Obj_Exec_Step (
1122: p_api_version => 1.0
1123: ,p_commit => FND_API.G_TRUE
1124: ,p_request_id => p_param_rec.request_id
1125: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1201: -- Call the FEM_PL_PKG.Register_Table API procedure to register

1197: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1198: ,p_module => G_BLOCK||'.'||l_api_name
1199: ,p_msg_text => 'BEGIN');
1200:
1201: -- Call the FEM_PL_PKG.Register_Table API procedure to register
1202: -- the specified output table and the statement type that will be used.
1203: FEM_PL_PKG.Register_Table(
1204: p_api_version => 1.0
1205: ,p_commit => FND_API.G_TRUE

Line 1203: FEM_PL_PKG.Register_Table(

1199: ,p_msg_text => 'BEGIN');
1200:
1201: -- Call the FEM_PL_PKG.Register_Table API procedure to register
1202: -- the specified output table and the statement type that will be used.
1203: FEM_PL_PKG.Register_Table(
1204: p_api_version => 1.0
1205: ,p_commit => FND_API.G_TRUE
1206: ,p_request_id => p_param_rec.request_id
1207: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1260: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.

1256: | Update_Num_Of_Output_Rows
1257: |
1258: | DESCRIPTION
1259: | Updates the rows successfully processed by calling
1260: | fem_pl_pkg.Update_Num_Of_Output_Rows in fem_pl_tables.
1261: |
1262: | SCOPE - PRIVATE
1263: |
1264: +============================================================================*/

Line 1286: FEM_PL_PKG.Update_Num_Of_Output_Rows(

1282: ,p_module => G_BLOCK||'.'||l_api_name
1283: ,p_msg_text => 'BEGIN');
1284:
1285: -- Set the number of output rows for the output table.
1286: FEM_PL_PKG.Update_Num_Of_Output_Rows(
1287: p_api_version => 1.0
1288: ,p_commit => FND_API.G_TRUE
1289: ,p_request_id => p_param_rec.request_id
1290: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1340: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.

1336: | Update_Obj_Exec_Step_Status
1337: |
1338: | DESCRIPTION
1339: | Updates the status of the executuon of the object by calling
1340: | fem_pl_pkg.Update_obj_exec_step_status in fem_pl_obj_steps.
1341: |
1342: | SCOPE - PRIVATE
1343: |
1344: +============================================================================*/

Line 1364: --Call the FEM_PL_PKG.Update_Obj_Exec_Step_status API procedure

1360: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1361: ,p_module => G_BLOCK||'.'||l_api_name
1362: ,p_msg_text => 'BEGIN');
1363:
1364: --Call the FEM_PL_PKG.Update_Obj_Exec_Step_status API procedure
1365: --to update step staus in fem_pl_obj_steps.
1366: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
1367: p_api_version => 1.0
1368: ,p_commit => FND_API.G_TRUE

Line 1366: FEM_PL_PKG.Update_Obj_Exec_Step_Status(

1362: ,p_msg_text => 'BEGIN');
1363:
1364: --Call the FEM_PL_PKG.Update_Obj_Exec_Step_status API procedure
1365: --to update step staus in fem_pl_obj_steps.
1366: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
1367: p_api_version => 1.0
1368: ,p_commit => FND_API.G_TRUE
1369: ,p_request_id => p_param_rec.request_id
1370: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1532: -- Call FEM_PL_PKG.update_num_of_input_rows();

1528: ,p_tbl_name => p_tbl_name
1529: ,p_stmt_type => g_insert );
1530:
1531: -----------------------------------------------------------------------
1532: -- Call FEM_PL_PKG.update_num_of_input_rows();
1533: -----------------------------------------------------------------------
1534:
1535: fem_engines_pkg.tech_message(
1536: p_severity => g_log_level_1,

Line 1849: -- Call the FEM_PL_PKG.Register_Object_Execution API procedure

1845: RAISE e_process_single_rule_error;
1846: END;
1847:
1848: BEGIN
1849: -- Call the FEM_PL_PKG.Register_Object_Execution API procedure
1850: -- to register the rollup object execution in FEM_PL_OBJECT_EXECUTIONS,
1851: -- thus obtaining an execution lock.
1852:
1853: SAVEPOINT register_rule_pub;

Line 1855: FEM_PL_PKG.Register_Object_Execution(

1851: -- thus obtaining an execution lock.
1852:
1853: SAVEPOINT register_rule_pub;
1854:
1855: FEM_PL_PKG.Register_Object_Execution(
1856: p_api_version => G_CALLING_API_VERSION
1857: ,p_commit => FND_API.G_TRUE
1858: ,p_request_id => p_param_rec.request_id
1859: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 1920: --call to FEM_PL_PKG.register_dependent_objdefs

1916: l_reuse_slices := 'N';
1917: END IF;
1918:
1919: --------------------------------------------------------------------------
1920: --call to FEM_PL_PKG.register_dependent_objdefs
1921: --------------------------------------------------------------------------
1922:
1923: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1924: ,p_module => G_BLOCK||'.'||l_api_name

Line 1930: -- Call FEM_PL_PKG.Register_Table()

1926:
1927: Register_Dependent_Objects(p_param_rec => p_param_rec);
1928:
1929: --------------------------------------------------------------------------
1930: -- Call FEM_PL_PKG.Register_Table()
1931: --------------------------------------------------------------------------
1932: fem_engines_pkg.tech_message( p_severity => g_log_level_3
1933: ,p_module => G_BLOCK||'.'||l_api_name
1934: ,p_msg_text => 'Register table ');

Line 2310: FEM_PL_PKG.Update_Obj_Exec_Status (

2306: p_severity => g_log_level_1
2307: ,p_module => G_BLOCK||'.'||l_api_name
2308: ,p_msg_text => 'Step 1: Update Object Execution Status');
2309:
2310: FEM_PL_PKG.Update_Obj_Exec_Status (
2311: p_api_version => 1.0
2312: ,p_commit => FND_API.G_TRUE
2313: ,p_request_id => p_param_rec.request_id
2314: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2338: FEM_PL_PKG.Update_Obj_Exec_Errors (

2334: p_severity => g_log_level_1
2335: ,p_module => G_BLOCK||'.'||l_api_name
2336: ,p_msg_text => 'Step 2: Update Object Execution Errors');
2337:
2338: FEM_PL_PKG.Update_Obj_Exec_Errors (
2339: p_api_version => 1.0
2340: ,p_commit => FND_API.G_TRUE
2341: ,p_request_id => p_param_rec.request_id
2342: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2367: FEM_PL_PKG.Update_Request_Status (

2363: p_severity => g_log_level_1
2364: ,p_module => G_BLOCK||'.'||l_api_name
2365: ,p_msg_text => 'Step 3: Update Request Status');
2366:
2367: FEM_PL_PKG.Update_Request_Status (
2368: p_api_version => 1.0
2369: ,p_commit => FND_API.G_TRUE
2370: ,p_request_id => p_param_rec.request_id
2371: ,p_exec_status_code => p_exec_status_code

Line 2644: FEM_PL_PKG.Register_Dependent_ObjDefs (

2640: ,p_module => G_BLOCK||'.'||l_api_name
2641: ,p_msg_text => 'BEGIN');
2642:
2643: -- Register all the Dependent Objects for ARC
2644: FEM_PL_PKG.Register_Dependent_ObjDefs (
2645: p_api_version => G_CALLING_API_VERSION
2646: ,p_commit => FND_API.G_TRUE
2647: ,p_request_id => p_param_rec.request_id
2648: ,p_object_id => p_param_rec.crnt_proc_child_obj_id

Line 2729: FEM_PL_PKG.Update_Num_Of_Input_Rows(

2725: ,p_module => G_BLOCK||'.'||l_api_name
2726: ,p_msg_text => 'BEGIN');
2727:
2728: -- Set the number of output rows for the output table.
2729: FEM_PL_PKG.Update_Num_Of_Input_Rows(
2730: p_api_version => 1.0
2731: ,p_commit => FND_API.G_TRUE
2732: ,p_request_id => p_param_rec.request_id
2733: ,p_object_id => p_param_rec.crnt_proc_child_obj_id