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_PPROFCAL_MASTER_PUB dependencies on FND_API

Line 232: l_init_msg_list := FND_API.G_FALSE;

228:
229: BEGIN
230:
231: l_api_version := 1.0;
232: l_init_msg_list := FND_API.G_FALSE;
233: l_commit := FND_API.G_FALSE;
234:
235: --Initialize Local Parameters
236: l_rule_set_rules_is_open := FALSE;

Line 233: l_commit := FND_API.G_FALSE;

229: BEGIN
230:
231: l_api_version := 1.0;
232: l_init_msg_list := FND_API.G_FALSE;
233: l_commit := FND_API.G_FALSE;
234:
235: --Initialize Local Parameters
236: l_rule_set_rules_is_open := FALSE;
237: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235: --Initialize Local Parameters
236: l_rule_set_rules_is_open := FALSE;
237: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
238: -- initialize status to success
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
242: ,p_module => G_BLOCK||l_api_name
243: ,p_msg_text => 'BEGIN');

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

310: ,p_module => G_BLOCK||'.'||l_api_name
311: ,p_msg_text => 'Status After Process for a single rule '
312: || l_param_rec.return_status);
313:
314: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
315: -- For Single Consolidation Rule, raise exception to end request
316: -- immediately with a completion status of ERROR, regardless of the
317: -- value for the continue_process_on_err_flg parameter.
318: RAISE e_pc_engine_error;

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

407: ,p_module => G_BLOCK||'.'||l_api_name
408: ,p_msg_text => 'Status After Process for a single rule '
409: || l_param_rec.return_status);
410:
411: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
412: -- Set the request status to match Calculation Rule's
413: -- return status.
414: l_ruleset_status := l_param_rec.return_status;
415: IF (l_param_rec.continue_process_on_err_flg = 'N') THEN

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

422: END LOOP;
423:
424: CLOSE l_rule_set_rules;
425:
426: IF (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) THEN
427: -- Raise exception to end request with a completion status of ERROR,
428: -- if the rule set status is not equal to SUCCESS.
429: RAISE e_pc_engine_error;
430: END IF;

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

446:
447: --------------------------------------------------------------------------
448: -- STEP 6: Standard API support
449: --------------------------------------------------------------------------
450: IF FND_API.To_Boolean(NVL(l_commit,'F')) THEN
451: COMMIT WORK;
452: END IF;
453:
454: /* IF (l_rule_set_rules_is_open) THEN

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457: IF (l_rule_set_rules%ISOPEN) THEN
458: CLOSE l_rule_set_rules;
459: END IF;
460:
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
464: ,p_module => G_BLOCK||'.'||l_api_name
465: ,p_msg_text => 'END');

Line 873: ,p_commit => FND_API.G_FALSE

869: -- Call the FEM_PL_PKG.Register_Request API procedure to register
870: -- the concurrent request in FEM_PL_REQUESTS.
871: FEM_PL_PKG.Register_Request(
872: p_api_version => G_CALLING_API_VERSION
873: ,p_commit => FND_API.G_FALSE
874: ,p_cal_period_id => p_param_rec.output_cal_period_id
875: ,p_ledger_id => p_param_rec.ledger_id
876: ,p_dataset_io_obj_def_id => p_param_rec.dataset_io_obj_def_id
877: ,p_source_system_code => p_param_rec.source_system_code

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

890: ,x_msg_count => l_msg_count
891: ,x_msg_data => l_msg_data
892: ,x_return_status => l_return_status);
893:
894: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
895: Get_Put_Messages ( p_msg_count => l_msg_count
896: ,p_msg_data => l_msg_data);
897:
898: RAISE e_pl_register_request_error;

Line 981: ,p_commit => FND_API.G_FALSE

977: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
978: -- an object definition lock.
979: FEM_PL_PKG.Register_Object_Def (
980: p_api_version => 1.0
981: ,p_commit => FND_API.G_FALSE
982: ,p_request_id => p_param_rec.request_id
983: ,p_object_id => p_object_id
984: ,p_object_definition_id => p_obj_def_id
985: ,p_user_id => p_param_rec.user_id

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

988: ,x_msg_data => l_msg_data
989: ,x_return_status => l_return_status);
990:
991: -- Object Definition Lock exists
992: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
993:
994: Get_Put_Messages ( p_msg_count => l_msg_count
995: ,p_msg_data => l_msg_data);
996: RAISE e_register_obj_def_error;

Line 1053: ,p_commit => FND_API.G_FALSE

1049: -- Call the FEM_PL_PKG.Register_Object_Def API procedure to register step
1050: -- in fem_pl_obj_steps.
1051: FEM_PL_PKG.Register_Obj_Exec_Step (
1052: p_api_version => 1.0
1053: ,p_commit => FND_API.G_FALSE
1054: ,p_request_id => p_param_rec.request_id
1055: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1056: ,p_exec_step => p_exe_step
1057: ,p_exec_status_code => p_exe_status_code

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

1060: ,x_msg_count => l_msg_count
1061: ,x_msg_data => l_msg_data
1062: ,x_return_status => l_return_status);
1063:
1064: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1065:
1066: Get_Put_Messages ( p_msg_count => l_msg_count
1067: ,p_msg_data => l_msg_data);
1068: RAISE e_register_obj_exe_step_error;

Line 1131: ,p_init_msg_list => FND_API.G_FALSE

1127: ,p_msg_text => 'BEGIN');
1128:
1129: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1130: p_api_version => G_CALLING_API_VERSION
1131: ,p_init_msg_list => FND_API.G_FALSE
1132: ,p_commit => FND_API.G_TRUE
1133: ,p_encoded => FND_API.G_TRUE
1134: ,p_orig_ruleset_object_id => p_param_rec.obj_id
1135: ,p_ds_io_def_id => p_param_rec.dataset_io_obj_def_id

Line 1132: ,p_commit => FND_API.G_TRUE

1128:
1129: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1130: p_api_version => G_CALLING_API_VERSION
1131: ,p_init_msg_list => FND_API.G_FALSE
1132: ,p_commit => FND_API.G_TRUE
1133: ,p_encoded => FND_API.G_TRUE
1134: ,p_orig_ruleset_object_id => p_param_rec.obj_id
1135: ,p_ds_io_def_id => p_param_rec.dataset_io_obj_def_id
1136: ,p_rule_effective_date => p_param_rec.effective_date_varchar

Line 1133: ,p_encoded => FND_API.G_TRUE

1129: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1130: p_api_version => G_CALLING_API_VERSION
1131: ,p_init_msg_list => FND_API.G_FALSE
1132: ,p_commit => FND_API.G_TRUE
1133: ,p_encoded => FND_API.G_TRUE
1134: ,p_orig_ruleset_object_id => p_param_rec.obj_id
1135: ,p_ds_io_def_id => p_param_rec.dataset_io_obj_def_id
1136: ,p_rule_effective_date => p_param_rec.effective_date_varchar
1137: ,p_output_period_id => p_param_rec.output_cal_period_id

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

1141: ,x_return_status => l_return_status
1142: ,x_msg_count => l_msg_count
1143: ,x_msg_data => l_msg_data);
1144:
1145: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1146: Get_Put_Messages ( p_msg_count => l_msg_count
1147: ,p_msg_data => l_msg_data);
1148:
1149: RAISE e_pl_preprocess_rule_set_err ;

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

1226: e_register_rule_error EXCEPTION;
1227:
1228: BEGIN
1229: -- Initialize the return status to SUCCESS
1230: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1233: ,p_module => G_BLOCK||'.'||l_api_name
1234: ,p_msg_text => 'BEGIN');

Line 1316: ,p_commit => FND_API.G_TRUE

1312: SAVEPOINT register_rule_pub;
1313:
1314: FEM_PL_PKG.Register_Object_Execution(
1315: p_api_version => G_CALLING_API_VERSION
1316: ,p_commit => FND_API.G_TRUE
1317: ,p_request_id => p_param_rec.request_id
1318: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1319: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
1320: ,p_user_id => p_param_rec.user_id

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

1325: ,x_msg_count => l_msg_count
1326: ,x_msg_data => l_msg_data
1327: ,x_return_status => l_return_status);
1328:
1329: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1330: Get_Put_Messages (p_msg_count => l_msg_count
1331: ,p_msg_data => l_msg_data);
1332:
1333: RAISE e_register_rule_error;

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

1346: FEM_ENGINES_PKG.User_Message (
1347: p_app_name => G_PFT
1348: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1349:
1350: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: RAISE e_process_single_rule_error;
1353: END;
1354:

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

1449: ,p_customer_level => l_customer_level
1450: ,p_exec_state => l_exec_state
1451: ,x_return_status => l_return_status);
1452:
1453: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1454: Get_Put_Messages (p_msg_count => l_msg_count
1455: ,p_msg_data => l_msg_data);
1456:
1457: FEM_ENGINES_PKG.User_Message (

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

1460:
1461: RAISE e_process_single_rule_error;
1462: END IF;
1463:
1464: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1465:
1466: ELSE
1467: FEM_ENGINES_PKG.Tech_Message (
1468: p_severity => g_log_level_3

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

1582: ,p_customer_level => l_customer_level
1583: ,p_exec_state => l_exec_state
1584: ,x_return_status => l_return_status);
1585:
1586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1587: Get_Put_Messages (p_msg_count => l_msg_count
1588: ,p_msg_data => l_msg_data);
1589:
1590: FEM_ENGINES_PKG.User_Message (

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

1593:
1594: RAISE e_process_single_rule_error;
1595: END IF;
1596:
1597: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1598: ELSE
1599: FEM_ENGINES_PKG.Tech_Message (
1600: p_severity => g_log_level_3
1601: ,p_module => G_BLOCK||'.'||l_api_name

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

1662: ,p_output_column => l_output_column
1663: ,p_exec_state => l_exec_state
1664: ,x_return_status => l_return_status);
1665:
1666: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1667: Get_Put_Messages (p_msg_count => l_msg_count
1668: ,p_msg_data => l_msg_data);
1669:
1670: FEM_ENGINES_PKG.User_Message (

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

1674: RAISE e_process_single_rule_error;
1675:
1676: END IF;
1677:
1678: p_param_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: END IF;
1681:
1682: --Check whether Prospect Identification is selected

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

1721: ,p_source_system_code => p_param_rec.source_system_code
1722: ,p_exec_state => l_exec_state
1723: ,x_return_status => l_return_status);
1724:
1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1726: Get_Put_Messages (p_msg_count => l_msg_count
1727: ,p_msg_data => l_msg_data);
1728:
1729: FEM_ENGINES_PKG.User_Message (

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

1744:
1745: -- FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1746: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1747:
1748: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1749:
1750: WHEN OTHERS THEN
1751:
1752: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT

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

1751:
1752: FEM_ENGINES_PKG.User_Message (p_app_name => G_PFT
1753: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
1754:
1755: p_param_rec.return_status := FND_API.G_RET_STS_ERROR;
1756:
1757: END Process_Single_Rule;
1758:
1759: /*===========================================================================+==

Line 1848: ,p_commit => FND_API.G_FALSE

1844: ,p_msg_text => 'Step 1: Update Object Execution Status');
1845:
1846: FEM_PL_PKG.Update_Obj_Exec_Status (
1847: p_api_version => 1.0
1848: ,p_commit => FND_API.G_FALSE
1849: ,p_request_id => p_param_rec.request_id
1850: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1851: ,p_exec_status_code => p_exec_status_code
1852: ,p_user_id => p_param_rec.user_id

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

1854: ,x_msg_count => l_msg_count
1855: ,x_msg_data => l_msg_data
1856: ,x_return_status => l_return_status);
1857:
1858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1859: Get_Put_Messages ( p_msg_count => l_msg_count
1860: ,p_msg_data => l_msg_data);
1861: RAISE e_eng_master_post_proc_error;
1862: END IF;

Line 1876: ,p_commit => FND_API.G_FALSE

1872: ,p_msg_text => 'Step 2: Update Object Execution Errors');
1873:
1874: FEM_PL_PKG.Update_Obj_Exec_Errors (
1875: p_api_version => 1.0
1876: ,p_commit => FND_API.G_FALSE
1877: ,p_request_id => p_param_rec.request_id
1878: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1879: ,p_errors_reported => 1 --todo: verify
1880: ,p_errors_reprocessed => 0 --todo: verify

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

1883: ,x_msg_count => l_msg_count
1884: ,x_msg_data => l_msg_data
1885: ,x_return_status => l_return_status);
1886:
1887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1888: Get_Put_Messages ( p_msg_count => l_msg_count
1889: ,p_msg_data => l_msg_data);
1890: RAISE e_eng_master_post_proc_error;
1891: END IF;

Line 1905: ,p_commit => FND_API.G_FALSE

1901: ,p_msg_text => 'Step 3: Update Request Status');
1902:
1903: FEM_PL_PKG.Update_Request_Status (
1904: p_api_version => 1.0
1905: ,p_commit => FND_API.G_FALSE
1906: ,p_request_id => p_param_rec.request_id
1907: ,p_exec_status_code => p_exec_status_code
1908: ,p_user_id => p_param_rec.user_id
1909: ,p_last_update_login => p_param_rec.login_id

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

1910: ,x_msg_count => l_msg_count
1911: ,x_msg_data => l_msg_data
1912: ,x_return_status => l_return_status);
1913:
1914: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1915: Get_Put_Messages ( p_msg_count => l_msg_count
1916: ,p_msg_data => l_msg_data);
1917: RAISE e_eng_master_post_proc_error;
1918: END IF;

Line 2044: ,p_encoded => FND_API.G_FALSE

2040:
2041: FOR i IN 1..p_msg_count LOOP
2042:
2043: FND_MSG_PUB.Get ( p_msg_index => i
2044: ,p_encoded => FND_API.G_FALSE
2045: ,p_data => l_message
2046: ,p_msg_index_out => l_msg_out);
2047:
2048: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );

Line 2103: ,p_commit => FND_API.G_TRUE

2099:
2100: -- Register all the Dependent Objects for CALC
2101: FEM_PL_PKG.Register_Dependent_ObjDefs (
2102: p_api_version => G_CALLING_API_VERSION
2103: ,p_commit => FND_API.G_TRUE
2104: ,p_request_id => p_param_rec.request_id
2105: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2106: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
2107: ,p_effective_date => p_param_rec.effective_date

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

2111: ,x_msg_data => l_msg_data
2112: ,x_return_status => l_return_status);
2113:
2114: -- Object Definition Lock exists
2115: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2116: Get_Put_Messages ( p_msg_count => l_msg_count
2117: ,p_msg_data => l_msg_data);
2118: RAISE e_register_dep_obj_def_error;
2119: END IF;

Line 2188: ,p_commit => FND_API.G_TRUE

2184:
2185: -- Set the number of output rows for the output table.
2186: FEM_PL_PKG.Update_Num_Of_Input_Rows(
2187: p_api_version => 1.0
2188: ,p_commit => FND_API.G_TRUE
2189: ,p_request_id => p_param_rec.request_id
2190: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2191: ,p_num_of_input_rows => p_num_input_rows
2192: ,p_user_id => p_param_rec.user_id

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

2194: ,x_msg_count => l_msg_count
2195: ,x_msg_data => l_msg_data
2196: ,x_return_status => l_return_status);
2197:
2198: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2199:
2200: Get_Put_Messages( p_msg_count => l_msg_count
2201: ,p_msg_data => l_msg_data);
2202: RAISE e_upd_num_input_rows_error;

Line 2271: ,p_commit => FND_API.G_FALSE

2267: -- Call the FEM_PL_PKG.Register_Table API procedure to register
2268: -- the specified output table and the statement type that will be used.
2269: FEM_PL_PKG.Register_Table(
2270: p_api_version => 1.0
2271: ,p_commit => FND_API.G_FALSE
2272: ,p_request_id => p_param_rec.request_id
2273: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2274: ,p_table_name => p_tbl_name
2275: ,p_statement_type => p_stmt_type

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

2279: ,x_msg_count => l_msg_count
2280: ,x_msg_data => l_msg_data
2281: ,x_return_status => l_return_status);
2282:
2283: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2284:
2285: Get_Put_Messages ( p_msg_count => l_msg_count
2286: ,p_msg_data => l_msg_data);
2287: RAISE e_register_table_error;

Line 2354: ,p_commit => FND_API.G_TRUE

2350:
2351: -- Set the number of output rows for the output table.
2352: FEM_PL_PKG.register_updated_column(
2353: p_api_version => 1.0
2354: ,p_commit => FND_API.G_TRUE
2355: ,p_request_id => p_param_rec.request_id
2356: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2357: ,p_table_name => p_table_name
2358: ,p_statement_type => p_statement_type

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

2362: ,x_msg_count => l_msg_count
2363: ,x_msg_data => l_msg_data
2364: ,x_return_status => l_return_status);
2365:
2366: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2367:
2368: Get_Put_Messages( p_msg_count => l_msg_count
2369: ,p_msg_data => l_msg_data);
2370: RAISE e_reg_updated_column_error;