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

Line 254: l_init_msg_list := FND_API.g_false;

250:
251: BEGIN
252:
253: l_api_version := 1.0;
254: l_init_msg_list := FND_API.g_false;
255: l_commit := FND_API.g_false;
256:
257: --Initialize Local Parameters
258: l_rule_set_rules_is_open := FALSE;

Line 255: l_commit := FND_API.g_false;

251: BEGIN
252:
253: l_api_version := 1.0;
254: l_init_msg_list := FND_API.g_false;
255: l_commit := FND_API.g_false;
256:
257: --Initialize Local Parameters
258: l_rule_set_rules_is_open := FALSE;
259: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: --Initialize Local Parameters
258: l_rule_set_rules_is_open := FALSE;
259: z_master_err_state := FEM_UTILS.G_RSM_NO_ERR;
260: -- initialize status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: fem_engines_pkg.tech_message( p_severity => g_log_level_2
264: ,p_module => G_BLOCK||l_api_name
265: ,p_msg_text => 'BEGIN');

Line 268: IF FND_API.To_Boolean(NVL(l_init_msg_list,'F')) THEN

264: ,p_module => G_BLOCK||l_api_name
265: ,p_msg_text => 'BEGIN');
266:
267: -- initialize msg stack?
268: IF FND_API.To_Boolean(NVL(l_init_msg_list,'F')) THEN
269: FND_MSG_PUB.Initialize;
270: END IF;
271:
272: --------------------------------------------------------------------------

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

336: ,p_module => G_BLOCK||'.'||l_api_name
337: ,p_msg_text => 'Status After Process for a single rule '
338: || l_param_rec.return_status);
339:
340: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: -- For Single Aggregation Rule, raise exception to end request
342: -- immediately with a completion status of ERROR,
343: -- regardless of the value for the
344: -- continue_process_on_err_flg parameter.

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

443: ,p_module => G_BLOCK||'.'||l_api_name
444: ,p_msg_text => 'Status After Process for a single rule '
445: || l_param_rec.return_status);
446:
447: IF (l_param_rec.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
448: -- Set the request status to match Aggregation_Rule's
449: -- return status.
450: l_ruleset_status := l_param_rec.return_status;
451: IF (l_param_rec.continue_process_on_err_flg = 'N') THEN

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

458: END LOOP;
459:
460: CLOSE l_rule_set_rules;
461:
462: IF (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: -- Raise exception to end request with a completion status of ERROR,
464: -- if the rule set status is not equal to SUCCESS.
465: RAISE e_pagg_engine_error;
466: END IF;

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

482:
483: --------------------------------------------------------------------------
484: -- STEP 6: Standard API support
485: --------------------------------------------------------------------------
486: IF FND_API.To_Boolean(NVL(l_commit,'F')) THEN
487: COMMIT WORK;
488: END IF;
489:
490: IF (l_rule_set_rules%ISOPEN) THEN

Line 494: x_return_status := FND_API.G_RET_STS_SUCCESS;

490: IF (l_rule_set_rules%ISOPEN) THEN
491: CLOSE l_rule_set_rules;
492: END IF;
493:
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
497: ,p_module => G_BLOCK||'.'||l_api_name
498: ,p_msg_text => 'END');

Line 523: x_return_status := FND_API.G_RET_STS_ERROR;

519: -- p_app_name => G_PFT
520: -- ,p_msg_text => 'Profit Aggregation Engine Error');
521:
522: -- Set the return status to ERROR
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: WHEN OTHERS THEN
526: gv_prg_msg := SQLERRM;
527: gv_callstack := DBMS_UTILITY.Format_Call_Stack;

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: ,p_token1 => 'ERR_MSG'
554: ,p_value1 => gv_prg_msg);
555:
556: -- Set the return status to UNEXP_ERROR
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558:
559: END Process_Request;
560:
561: /*============================================================================+

Line 892: ,p_commit => FND_API.G_FALSE

888: -- Call the FEM_PL_PKG.Register_Request API procedure to register
889: -- the concurrent request in FEM_PL_REQUESTS.
890: FEM_PL_PKG.Register_Request(
891: p_api_version => G_CALLING_API_VERSION
892: ,p_commit => FND_API.G_FALSE
893: ,p_cal_period_id => p_param_rec.output_cal_period_id
894: ,p_ledger_id => p_param_rec.ledger_id
895: ,p_dataset_io_obj_def_id => p_param_rec.dataset_io_obj_def_id
896: ,p_source_system_code => p_param_rec.source_system_code

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

910: ,x_msg_count => l_msg_count
911: ,x_msg_data => l_msg_data
912: ,x_return_status => l_return_status);
913:
914: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
915: Get_Put_Messages ( p_msg_count => l_msg_count
916: ,p_msg_data => l_msg_data);
917:
918: RAISE e_pl_register_request_error;

Line 1000: ,p_commit => FND_API.G_FALSE

996: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
997: -- an object definition lock.
998: FEM_PL_PKG.Register_Object_Def (
999: p_api_version => 1.0
1000: ,p_commit => FND_API.G_FALSE
1001: ,p_request_id => p_param_rec.request_id
1002: ,p_object_id => p_object_id
1003: ,p_object_definition_id => p_obj_def_id
1004: ,p_user_id => p_param_rec.user_id

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

1007: ,x_msg_data => l_msg_data
1008: ,x_return_status => l_return_status);
1009:
1010: -- Object Definition Lock exists
1011: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1012:
1013: Get_Put_Messages ( p_msg_count => l_msg_count
1014: ,p_msg_data => l_msg_data);
1015: RAISE e_register_obj_def_error;

Line 1071: ,p_commit => FND_API.G_FALSE

1067: --Call the FEM_PL_PKG.Register_Object_Def API procedure to register step
1068: -- in fem_pl_obj_steps.
1069: FEM_PL_PKG.Register_Obj_Exec_Step (
1070: p_api_version => 1.0
1071: ,p_commit => FND_API.G_FALSE
1072: ,p_request_id => p_param_rec.request_id
1073: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1074: ,p_exec_step => p_exe_step
1075: ,p_exec_status_code => p_exe_status_code

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

1078: ,x_msg_count => l_msg_count
1079: ,x_msg_data => l_msg_data
1080: ,x_return_status => l_return_status);
1081:
1082: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1083:
1084: Get_Put_Messages ( p_msg_count => l_msg_count
1085: ,p_msg_data => l_msg_data);
1086: RAISE e_register_obj_exe_step_error;

Line 1154: ,p_commit => FND_API.G_FALSE

1150: -- Call the FEM_PL_PKG.Register_Table API procedure to register
1151: -- the specified output table and the statement type that will be used.
1152: FEM_PL_PKG.Register_Table(
1153: p_api_version => 1.0
1154: ,p_commit => FND_API.G_FALSE
1155: ,p_request_id => p_param_rec.request_id
1156: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1157: ,p_table_name => p_tbl_name
1158: ,p_statement_type => p_stmt_type

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

1162: ,x_msg_count => l_msg_count
1163: ,x_msg_data => l_msg_data
1164: ,x_return_status => l_return_status);
1165:
1166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1167:
1168: Get_Put_Messages ( p_msg_count => l_msg_count
1169: ,p_msg_data => l_msg_data);
1170: RAISE e_register_table_error;

Line 1236: ,p_commit => FND_API.G_FALSE

1232:
1233: -- Set the number of output rows for the output table.
1234: FEM_PL_PKG.Update_Num_Of_Output_Rows(
1235: p_api_version => 1.0
1236: ,p_commit => FND_API.G_FALSE
1237: ,p_request_id => p_param_rec.request_id
1238: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1239: ,p_table_name => p_tbl_name
1240: ,p_statement_type => p_stmt_type

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

1244: ,x_msg_count => l_msg_count
1245: ,x_msg_data => l_msg_data
1246: ,x_return_status => l_return_status);
1247:
1248: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1249:
1250: Get_Put_Messages( p_msg_count => l_msg_count
1251: ,p_msg_data => l_msg_data);
1252: RAISE e_upd_num_output_rows_error;

Line 1315: ,p_commit => FND_API.G_FALSE

1311: --Call the FEM_PL_PKG.Update_obj_exec_step_status API procedure
1312: --to update step staus in fem_pl_obj_steps.
1313: FEM_PL_PKG.Update_Obj_Exec_Step_Status(
1314: p_api_version => 1.0
1315: ,p_commit => FND_API.G_FALSE
1316: ,p_request_id => p_param_rec.request_id
1317: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1318: ,p_exec_step => p_exe_step
1319: ,p_exec_status_code => p_exe_status_code

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

1322: ,x_msg_count => l_msg_count
1323: ,x_msg_data => l_msg_data
1324: ,x_return_status => l_return_status);
1325:
1326: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1327: Get_Put_Messages ( p_msg_count => l_msg_count
1328: ,p_msg_data => l_msg_data);
1329: RAISE e_upd_obj_exec_step_stat_error;
1330:

Line 1471: ,p_init_msg_list => FND_API.G_FALSE

1467: ,p_msg_text => 'Step 4.2.1: Rule Set Pre Processing');
1468:
1469: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1470: p_api_version => G_CALLING_API_VERSION
1471: ,p_init_msg_list => FND_API.G_FALSE
1472: ,p_commit => FND_API.G_TRUE
1473: ,p_encoded => FND_API.G_TRUE
1474: ,x_return_status => l_return_status
1475: ,x_msg_count => l_msg_count

Line 1472: ,p_commit => FND_API.G_TRUE

1468:
1469: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1470: p_api_version => G_CALLING_API_VERSION
1471: ,p_init_msg_list => FND_API.G_FALSE
1472: ,p_commit => FND_API.G_TRUE
1473: ,p_encoded => FND_API.G_TRUE
1474: ,x_return_status => l_return_status
1475: ,x_msg_count => l_msg_count
1476: ,x_msg_data => l_msg_data

Line 1473: ,p_encoded => FND_API.G_TRUE

1469: FEM_RULE_SET_MANAGER.Fem_Preprocess_RuleSet_Pvt(
1470: p_api_version => G_CALLING_API_VERSION
1471: ,p_init_msg_list => FND_API.G_FALSE
1472: ,p_commit => FND_API.G_TRUE
1473: ,p_encoded => FND_API.G_TRUE
1474: ,x_return_status => l_return_status
1475: ,x_msg_count => l_msg_count
1476: ,x_msg_data => l_msg_data
1477: ,p_orig_ruleset_object_id => p_param_rec.obj_id

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

1482: ,p_continue_process_on_err_flg => p_param_rec.continue_process_on_err_flg
1483: ,p_execution_mode => 'E'-- Engine Execution Mode
1484: );
1485:
1486: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1487: Get_Put_Messages ( p_msg_count => l_msg_count
1488: ,p_msg_data => l_msg_data);
1489:
1490: RAISE e_pl_preprocess_rule_set_err;

Line 1581: p_param_rec.return_status := fnd_api.G_RET_STS_SUCCESS;

1577:
1578: BEGIN
1579: l_process_table := 'FEM_CUSTOMER_PROFIT';
1580: -- Initialize the return status to SUCCESS
1581: p_param_rec.return_status := fnd_api.G_RET_STS_SUCCESS;
1582:
1583: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1584: ,p_module => G_BLOCK||'.'||l_api_name
1585: ,p_msg_text => 'BEGIN');

Line 1652: ,p_commit => fnd_api.G_TRUE

1648: -- thus obtaining an execution lock.
1649:
1650: FEM_PL_PKG.Register_Object_Execution(
1651: p_api_version => G_CALLING_API_VERSION
1652: ,p_commit => fnd_api.G_TRUE
1653: ,p_request_id => p_param_rec.request_id
1654: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
1655: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
1656: ,p_user_id => p_param_rec.user_id

Line 1665: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS)THEN

1661: ,x_msg_count => l_msg_count
1662: ,x_msg_data => l_msg_data
1663: ,x_return_status => l_return_status);
1664:
1665: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS)THEN
1666: Get_Put_Messages ( p_msg_count => l_msg_count
1667: ,p_msg_data => l_msg_data);
1668: RAISE e_register_rule_error;
1669: END IF;

Line 1683: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;

1679: fem_engines_pkg.user_message (
1680: p_app_name => G_PFT
1681: ,p_msg_name => G_PL_OBJ_EXEC_LOCK_ERR);
1682:
1683: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
1684:
1685: RAISE e_process_single_rule_error;
1686: END;
1687:

Line 2210: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;

2206:
2207: --fem_engines_pkg.user_message (p_app_name => G_PFT
2208: -- ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2209:
2210: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2211:
2212: WHEN e_process_single_rule_error THEN
2213:
2214: Process_Obj_Exec_Step(

Line 2229: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;

2225:
2226: fem_engines_pkg.user_message (p_app_name => G_PFT
2227: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2228:
2229: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2230:
2231: WHEN OTHERS THEN
2232:
2233: Process_Obj_Exec_Step(

Line 2243: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;

2239:
2240: fem_engines_pkg.user_message (p_app_name => G_PFT
2241: ,p_msg_name => G_ENG_SINGLE_RULE_ERR);
2242:
2243: p_param_rec.return_status := fnd_api.G_RET_STS_ERROR;
2244:
2245: END Process_Single_Rule;
2246:
2247: /*=============================================================================+

Line 2331: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

2327: ,x_msg_count => l_msg_count
2328: ,x_msg_data => l_msg_data
2329: ,x_return_status => l_return_status);
2330:
2331: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
2332: Get_Put_Messages ( p_msg_count => l_msg_count
2333: ,p_msg_data => l_msg_data);
2334:
2335: RAISE e_col_population_api_err ;

Line 2510: ,p_commit => FND_API.G_FALSE

2506: ,p_msg_text => 'Step 1: Update Object Execution Status');
2507:
2508: FEM_PL_PKG.Update_Obj_Exec_Status (
2509: p_api_version => 1.0
2510: ,p_commit => FND_API.G_FALSE
2511: ,p_request_id => p_param_rec.request_id
2512: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2513: ,p_exec_status_code => p_exec_status_code
2514: ,p_user_id => p_param_rec.user_id

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

2517: ,x_msg_data => l_msg_data
2518: ,x_return_status => l_return_status);
2519:
2520:
2521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2522: Get_Put_Messages ( p_msg_count => l_msg_count
2523: ,p_msg_data => l_msg_data);
2524: RAISE e_eng_master_post_proc_error;
2525: END IF;

Line 2539: ,p_commit => FND_API.G_FALSE

2535: ,p_msg_text => 'Step 2: Update Object Execution Errors');
2536:
2537: FEM_PL_PKG.Update_Obj_Exec_Errors (
2538: p_api_version => 1.0
2539: ,p_commit => FND_API.G_FALSE
2540: ,p_request_id => p_param_rec.request_id
2541: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2542: ,p_errors_reported => 1
2543: ,p_errors_reprocessed => 0

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

2546: ,x_msg_count => l_msg_count
2547: ,x_msg_data => l_msg_data
2548: ,x_return_status => l_return_status);
2549:
2550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2551: Get_Put_Messages ( p_msg_count => l_msg_count
2552: ,p_msg_data => l_msg_data);
2553: RAISE e_eng_master_post_proc_error;
2554: END IF;

Line 2568: ,p_commit => FND_API.G_FALSE

2564: ,p_msg_text => 'Step 3: Update Request Status');
2565:
2566: FEM_PL_PKG.Update_Request_Status (
2567: p_api_version => 1.0
2568: ,p_commit => FND_API.G_FALSE
2569: ,p_request_id => p_param_rec.request_id
2570: ,p_exec_status_code => p_exec_status_code
2571: ,p_user_id => p_param_rec.user_id
2572: ,p_last_update_login => p_param_rec.login_id

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

2573: ,x_msg_count => l_msg_count
2574: ,x_msg_data => l_msg_data
2575: ,x_return_status => l_return_status);
2576:
2577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2578: Get_Put_Messages ( p_msg_count => l_msg_count
2579: ,p_msg_data => l_msg_data);
2580:
2581: RAISE e_eng_master_post_proc_error;

Line 2722: ,p_encoded => FND_API.G_FALSE

2718: ELSIF (p_msg_count > 1) THEN
2719:
2720: FOR i IN 1..p_msg_count LOOP
2721: FND_MSG_PUB.Get ( p_msg_index => i
2722: ,p_encoded => FND_API.G_FALSE
2723: ,p_data => l_message
2724: ,p_msg_index_out => l_msg_out);
2725:
2726: FEM_ENGINES_PKG.User_Message ( p_msg_text => l_message );

Line 2843: ,p_commit => FND_API.G_TRUE

2839:
2840: -- Register all the Dependent Objects for AGG
2841: FEM_PL_PKG.Register_Dependent_ObjDefs (
2842: p_api_version => G_CALLING_API_VERSION
2843: ,p_commit => FND_API.G_TRUE
2844: ,p_request_id => p_param_rec.request_id
2845: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2846: ,p_exec_object_definition_id => p_param_rec.crnt_proc_child_obj_defn_id
2847: ,p_effective_date => p_param_rec.effective_date

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

2851: ,x_msg_data => l_msg_data
2852: ,x_return_status => l_return_status);
2853:
2854: -- Object Definition Lock exists
2855: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2856: Get_Put_Messages ( p_msg_count => l_msg_count
2857: ,p_msg_data => l_msg_data);
2858: RAISE e_register_dep_obj_def_error;
2859: END IF;

Line 2927: ,p_commit => FND_API.G_TRUE

2923:
2924: -- Set the number of output rows for the output table.
2925: FEM_PL_PKG.Update_Num_Of_Input_Rows(
2926: p_api_version => 1.0
2927: ,p_commit => FND_API.G_TRUE
2928: ,p_request_id => p_param_rec.request_id
2929: ,p_object_id => p_param_rec.crnt_proc_child_obj_id
2930: ,p_num_of_input_rows => p_num_input_rows
2931: ,p_user_id => p_param_rec.user_id

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

2933: ,x_msg_count => l_msg_count
2934: ,x_msg_data => l_msg_data
2935: ,x_return_status => l_return_status);
2936:
2937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2938:
2939: Get_Put_Messages( p_msg_count => l_msg_count
2940: ,p_msg_data => l_msg_data);
2941: RAISE e_upd_num_input_rows_error;