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 FND_API

Line 272: l_init_msg_list := FND_API.g_false;

268:
269: BEGIN
270:
271: l_api_version := 1.0;
272: l_init_msg_list := FND_API.g_false;
273: l_commit := FND_API.g_false;
274:
275: --Initialize Local Parameters
276: l_rule_set_rules_is_open := FALSE;

Line 273: l_commit := FND_API.g_false;

269: BEGIN
270:
271: l_api_version := 1.0;
272: l_init_msg_list := FND_API.g_false;
273: l_commit := FND_API.g_false;
274:
275: --Initialize Local Parameters
276: l_rule_set_rules_is_open := FALSE;
277: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: l_rule_set_rules_is_open := FALSE;
277: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
278:
279: -- initialize status to success
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: fem_engines_pkg.tech_message( p_severity => g_log_level_2
283: ,p_module => G_BLOCK||l_api_name
284: ,p_msg_text => 'BEGIN');

Line 287: IF FND_API.to_Boolean(NVL(l_init_msg_list,'F')) THEN

283: ,p_module => G_BLOCK||l_api_name
284: ,p_msg_text => 'BEGIN');
285:
286: -- initialize msg stack?
287: IF FND_API.to_Boolean(NVL(l_init_msg_list,'F')) THEN
288: FND_MSG_PUB.Initialize;
289: END IF;
290:
291: ---------------------------------------------------------------------------

Line 356: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

352: ,p_module => G_BLOCK||'.'||l_api_name
353: ,p_msg_text => 'Status After Process for a single rule '
354: || l_param_rec.return_status);
355:
356: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
357: -- For Single Consolidation Rule, raise exception to end request
358: -- immediately with a completion status of ERROR,
359: -- regardless of the value for the continue_process_on_err_flg
360: -- parameter.

Line 462: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

458: ,p_module => G_BLOCK||'.'||l_api_name
459: ,p_msg_text => 'Status After Process for a single rule '
460: || l_param_rec.return_status);
461:
462: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: -- Set the request status to match Consolidation Rule's
464: -- return status.
465: l_ruleset_status := l_param_rec.return_status;
466: IF (l_param_rec.continue_process_on_err_flg = 'N') THEN

Line 477: IF (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) THEN

473: END LOOP;
474:
475: CLOSE l_rule_set_rules;
476:
477: IF (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: -- Raise exception to end request with a completion status of ERROR,
479: -- if the rule set status is not equal to SUCCESS.
480: RAISE e_arc_engine_error;
481: END IF;

Line 501: IF FND_API.To_Boolean(NVL(l_commit,'F')) THEN

497:
498: ---------------------------------------------------------------------------
499: -- STEP 6: Standard API support
500: ---------------------------------------------------------------------------
501: IF FND_API.To_Boolean(NVL(l_commit,'F')) THEN
502: COMMIT WORK;
503: END IF;
504:
505: /* IF (l_rule_set_rules_is_open) THEN

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS;

508: IF (l_rule_set_rules%ISOPEN) THEN
509: CLOSE l_rule_set_rules;
510: END IF;
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
515: ,p_module => G_BLOCK||'.'||l_api_name
516: ,p_msg_text => 'END');

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: -- p_app_name => G_PFT
546: -- ,p_msg_text => 'Account consolidation Engine Error');
547:
548: -- Set the return status to ERROR
549: x_return_status := FND_API.G_RET_STS_ERROR;
550:
551: WHEN OTHERS THEN
552: gv_prg_msg := SQLERRM;
553: gv_callstack := DBMS_UTILITY.Format_Call_Stack;

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: ,p_token1 => 'ERR_MSG'
589: ,p_value1 => gv_prg_msg);
590:
591: -- Set the return status to UNEXP_ERROR
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593:
594: END Process_Request;
595:
596: /*============================================================================+

Line 943: ,p_commit => FND_API.G_FALSE

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
946: ,p_dataset_io_obj_def_id => p_param_rec.dataset_io_obj_def_id
947: ,p_output_dataset_code => p_param_rec.output_dataset_code

Line 965: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

961: ,x_msg_count => l_msg_count
962: ,x_msg_data => l_msg_data
963: ,x_return_status => l_return_status);
964:
965: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
966: Get_Put_Messages ( p_msg_count => l_msg_count
967: ,p_msg_data => l_msg_data);
968:
969: RAISE e_pl_register_request_error;

Line 1052: ,p_commit => FND_API.G_TRUE

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
1055: ,p_object_definition_id => p_obj_def_id
1056: ,p_user_id => p_param_rec.user_id

Line 1063: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1059: ,x_msg_data => l_msg_data
1060: ,x_return_status => l_return_status);
1061:
1062: -- Object Definition Lock exists
1063: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1064:
1065: Get_Put_Messages ( p_msg_count => l_msg_count
1066: ,p_msg_data => l_msg_data);
1067: RAISE e_register_obj_def_error;

Line 1123: ,p_commit => FND_API.G_TRUE

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
1126: ,p_exec_step => p_exe_step
1127: ,p_exec_status_code => p_exe_status_code

Line 1134: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1130: ,x_msg_count => l_msg_count
1131: ,x_msg_data => l_msg_data
1132: ,x_return_status => l_return_status);
1133:
1134: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1135:
1136: Get_Put_Messages ( p_msg_count => l_msg_count
1137: ,p_msg_data => l_msg_data);
1138: RAISE e_register_obj_exe_step_error;

Line 1205: ,p_commit => FND_API.G_TRUE

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
1208: ,p_table_name => p_tbl_name
1209: ,p_statement_type => p_stmt_type

Line 1217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1213: ,x_msg_count => l_msg_count
1214: ,x_msg_data => l_msg_data
1215: ,x_return_status => l_return_status);
1216:
1217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1218:
1219: Get_Put_Messages ( p_msg_count => l_msg_count
1220: ,p_msg_data => l_msg_data);
1221: RAISE e_register_table_error;

Line 1288: ,p_commit => FND_API.G_TRUE

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
1291: ,p_table_name => p_tbl_name
1292: ,p_statement_type => p_stmt_type

Line 1300: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1296: ,x_msg_count => l_msg_count
1297: ,x_msg_data => l_msg_data
1298: ,x_return_status => l_return_status);
1299:
1300: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1301:
1302: Get_Put_Messages( p_msg_count => l_msg_count
1303: ,p_msg_data => l_msg_data);
1304:

Line 1368: ,p_commit => FND_API.G_TRUE

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
1371: ,p_exec_step => p_exe_step
1372: ,p_exec_status_code => p_exe_status_code

Line 1379: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1375: ,x_msg_count => l_msg_count
1376: ,x_msg_data => l_msg_data
1377: ,x_return_status => l_return_status);
1378:
1379: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1380:
1381: Get_Put_Messages ( p_msg_count => l_msg_count
1382: ,p_msg_data => l_msg_data);
1383: RAISE e_upd_obj_exec_step_stat_error;

Line 1598: ,p_init_msg_list => FND_API.G_FALSE

1594: ,p_msg_text => 'BEGIN');
1595:
1596: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1597: p_api_version => G_CALLING_API_VERSION
1598: ,p_init_msg_list => FND_API.G_FALSE
1599: ,p_commit => FND_API.G_TRUE
1600: ,p_encoded => FND_API.G_TRUE
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count

Line 1599: ,p_commit => FND_API.G_TRUE

1595:
1596: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1597: p_api_version => G_CALLING_API_VERSION
1598: ,p_init_msg_list => FND_API.G_FALSE
1599: ,p_commit => FND_API.G_TRUE
1600: ,p_encoded => FND_API.G_TRUE
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count
1603: ,x_msg_data => l_msg_data

Line 1600: ,p_encoded => FND_API.G_TRUE

1596: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1597: p_api_version => G_CALLING_API_VERSION
1598: ,p_init_msg_list => FND_API.G_FALSE
1599: ,p_commit => FND_API.G_TRUE
1600: ,p_encoded => FND_API.G_TRUE
1601: ,x_return_status => l_return_status
1602: ,x_msg_count => l_msg_count
1603: ,x_msg_data => l_msg_data
1604: ,p_orig_ruleset_object_id => p_param_rec.obj_id

Line 1613: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1609: ,p_continue_process_on_err_flg => p_param_rec.continue_process_on_err_flg
1610: ,p_execution_mode => 'E'-- Engine Execution Mode
1611: );
1612:
1613: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1614: Get_Put_Messages ( p_msg_count => l_msg_count
1615: ,p_msg_data => l_msg_data);
1616:
1617: RAISE e_pl_preprocess_rule_set_err ;

Line 1697: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1693: e_register_rule_error EXCEPTION;
1694:
1695: BEGIN
1696: -- Initialize the return status to SUCCESS
1697: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1698:
1699: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1700: ,p_module => G_BLOCK||'.'||l_api_name
1701: ,p_msg_text => 'BEGIN');

Line 1857: ,p_commit => FND_API.G_TRUE

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
1860: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
1861: ,p_user_id => p_param_rec.user_id

Line 1870: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1866: ,x_msg_count => l_msg_count
1867: ,x_msg_data => l_msg_data
1868: ,x_return_status => l_return_status);
1869:
1870: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1871: Get_Put_Messages (p_msg_count => l_msg_count
1872: ,p_msg_data => l_msg_data);
1873:
1874: RAISE e_register_rule_error;

Line 1892: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;

1888: fem_engines_pkg.user_message (
1889: p_app_name => G_PFT
1890: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1891:
1892: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: RAISE e_process_single_rule_error;
1895:
1896: END;

Line 2071: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;

2067:
2068: --fem_engines_pkg.user_message (p_app_name => G_PFT
2069: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2070:
2071: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
2072:
2073: WHEN OTHERS THEN
2074:
2075: fem_engines_pkg.user_message (p_app_name => G_PFT

Line 2078: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;

2074:
2075: fem_engines_pkg.user_message (p_app_name => G_PFT
2076: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2077:
2078: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
2079:
2080: END Process_Single_Rule;
2081:
2082: /*=============================================================================+

Line 2171: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2167: ,x_msg_count => l_msg_count
2168: ,x_msg_data => l_msg_data
2169: ,x_return_status => l_return_status);
2170:
2171: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2172: Get_Put_Messages ( p_msg_count => l_msg_count
2173: ,p_msg_data => l_msg_data);
2174:
2175: RAISE e_col_population_api_err ;

Line 2312: ,p_commit => FND_API.G_TRUE

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
2315: ,p_exec_status_code => p_exec_status_code
2316: ,p_user_id => p_param_rec.user_id

Line 2322: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2318: ,x_msg_count => l_msg_count
2319: ,x_msg_data => l_msg_data
2320: ,x_return_status => l_return_status);
2321:
2322: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2323: Get_Put_Messages ( p_msg_count => l_msg_count
2324: ,p_msg_data => l_msg_data);
2325: RAISE e_eng_master_post_proc_error;
2326: END IF;

Line 2340: ,p_commit => FND_API.G_TRUE

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
2343: ,p_errors_reported => 1 --todo: verify
2344: ,p_errors_reprocessed => 0 --todo: verify

Line 2351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2347: ,x_msg_count => l_msg_count
2348: ,x_msg_data => l_msg_data
2349: ,x_return_status => l_return_status);
2350:
2351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2352: Get_Put_Messages ( p_msg_count => l_msg_count
2353: ,p_msg_data => l_msg_data);
2354: RAISE e_eng_master_post_proc_error;
2355: END IF;

Line 2369: ,p_commit => FND_API.G_TRUE

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
2372: ,p_user_id => p_param_rec.user_id
2373: ,p_last_update_login => p_param_rec.login_id

Line 2378: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2374: ,x_msg_count => l_msg_count
2375: ,x_msg_data => l_msg_data
2376: ,x_return_status => l_return_status);
2377:
2378: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2379: Get_Put_Messages ( p_msg_count => l_msg_count
2380: ,p_msg_data => l_msg_data);
2381: RAISE e_eng_master_post_proc_error;
2382: END IF;

Line 2516: ,p_encoded => FND_API.G_FALSE

2512:
2513: FOR i IN 1..p_msg_count LOOP
2514:
2515: FND_MSG_PUB.Get ( p_msg_index => i
2516: ,p_encoded => FND_API.G_FALSE
2517: ,p_data => l_message
2518: ,p_msg_index_out => l_msg_out);
2519:
2520: fem_engines_pkg.user_message ( p_msg_text => l_message );

Line 2646: ,p_commit => FND_API.G_TRUE

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
2649: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
2650: ,p_effective_date => p_param_rec.effective_date

Line 2658: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2654: ,x_msg_data => l_msg_data
2655: ,x_return_status => l_return_status);
2656:
2657: -- Object Definition Lock exists
2658: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2659:
2660: Get_Put_Messages ( p_msg_count => l_msg_count
2661: ,p_msg_data => l_msg_data);
2662: RAISE e_register_dep_obj_def_error;

Line 2731: ,p_commit => FND_API.G_TRUE

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
2734: ,p_num_of_input_rows => p_num_input_rows
2735: ,p_user_id => p_param_rec.user_id

Line 2741: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2737: ,x_msg_count => l_msg_count
2738: ,x_msg_data => l_msg_data
2739: ,x_return_status => l_return_status);
2740:
2741: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2742:
2743: Get_Put_Messages( p_msg_count => l_msg_count
2744: ,p_msg_data => l_msg_data);
2745: RAISE e_upd_num_input_rows_error;