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

Line 517: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

513: ,p_input_ds_b_where_clause => l_input_ds_b_where_clause
514: ,x_return_status => l_return_status
515: );
516:
517: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
518: raise g_act_rate_request_error;
519: end if;
520:
521: else

Line 543: ,p_init_msg_list => FND_API.G_FALSE

539: );
540:
541: FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT (
542: p_api_version => 1.0
543: ,p_init_msg_list => FND_API.G_FALSE
544: ,p_commit => FND_API.G_TRUE
545: ,p_encoded => FND_API.G_TRUE
546: ,x_return_status => l_return_status
547: ,x_msg_count => l_msg_count

Line 544: ,p_commit => FND_API.G_TRUE

540:
541: FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT (
542: p_api_version => 1.0
543: ,p_init_msg_list => FND_API.G_FALSE
544: ,p_commit => FND_API.G_TRUE
545: ,p_encoded => FND_API.G_TRUE
546: ,x_return_status => l_return_status
547: ,x_msg_count => l_msg_count
548: ,x_msg_data => l_msg_data

Line 545: ,p_encoded => FND_API.G_TRUE

541: FEM_RULE_SET_MANAGER.FEM_Preprocess_RuleSet_PVT (
542: p_api_version => 1.0
543: ,p_init_msg_list => FND_API.G_FALSE
544: ,p_commit => FND_API.G_TRUE
545: ,p_encoded => FND_API.G_TRUE
546: ,x_return_status => l_return_status
547: ,x_msg_count => l_msg_count
548: ,x_msg_data => l_msg_data
549: ,p_orig_ruleset_object_id => l_request_rec.ruleset_obj_id

Line 558: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

554: ,p_continue_process_on_err_flg => l_request_rec.continue_process_on_err_flg
555: ,p_execution_mode => 'E' --This is engine execution mode
556: );
557:
558: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
559: Get_Put_Messages (
560: p_msg_count => l_msg_count
561: ,p_msg_data => l_msg_data
562: );

Line 576: l_ruleset_status := FND_API.G_RET_STS_SUCCESS;

572: ,p_msg_text => 'Step 3.2.b: Loop through all Rule Set Rules'
573: );
574:
575: -- Initialize the rule set status to SUCCESS
576: l_ruleset_status := FND_API.G_RET_STS_SUCCESS;
577:
578: open l_ruleset_rules_csr (
579: p_request_id => l_request_rec.request_id
580: ,p_ruleset_obj_id => l_request_rec.ruleset_obj_id

Line 617: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

613: ,p_input_ds_b_where_clause => l_input_ds_b_where_clause
614: ,x_return_status => l_return_status
615: );
616:
617: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
618: l_ruleset_status := l_return_status;
619: if (l_request_rec.continue_process_on_err_flg = 'N') then
620: raise g_act_rate_request_error;
621: end if;

Line 630: if (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) then

626: end loop;
627:
628: close l_ruleset_rules_csr;
629:
630: if (l_ruleset_status <> FND_API.G_RET_STS_SUCCESS) then
631: raise g_act_rate_request_error;
632: end if;
633:
634: end if;

Line 940: ,p_init_msg_list => FND_API.G_FALSE

936: ------------------------------------------------------------------------------
937: -- Validation added with bug 4475839
938: FEM_SETUP_PKG.Validate_Proc_Key (
939: p_api_version => 1.0
940: ,p_init_msg_list => FND_API.G_FALSE
941: ,p_commit => FND_API.G_FALSE
942: ,p_encoded => FND_API.G_TRUE
943: ,x_return_status => l_return_status
944: ,x_msg_count => l_msg_count

Line 941: ,p_commit => FND_API.G_FALSE

937: -- Validation added with bug 4475839
938: FEM_SETUP_PKG.Validate_Proc_Key (
939: p_api_version => 1.0
940: ,p_init_msg_list => FND_API.G_FALSE
941: ,p_commit => FND_API.G_FALSE
942: ,p_encoded => FND_API.G_TRUE
943: ,x_return_status => l_return_status
944: ,x_msg_count => l_msg_count
945: ,x_msg_data => l_msg_data

Line 942: ,p_encoded => FND_API.G_TRUE

938: FEM_SETUP_PKG.Validate_Proc_Key (
939: p_api_version => 1.0
940: ,p_init_msg_list => FND_API.G_FALSE
941: ,p_commit => FND_API.G_FALSE
942: ,p_encoded => FND_API.G_TRUE
943: ,x_return_status => l_return_status
944: ,x_msg_count => l_msg_count
945: ,x_msg_data => l_msg_data
946: ,p_dimension_varchar_label => l_dimension_varchar_label

Line 950: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

946: ,p_dimension_varchar_label => l_dimension_varchar_label
947: ,p_table_name => 'FEM_BALANCES'
948: );
949:
950: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
951: Get_Put_Messages (
952: p_msg_count => l_msg_count
953: ,p_msg_data => l_msg_data
954: );

Line 1041: ,p_init_msg_list => FND_API.G_FALSE

1037: -- Call the Where Clause Generator for source data in FEM_BALANCES
1038: ------------------------------------------------------------------------------
1039: FEM_DS_WHERE_CLAUSE_GENERATOR.FEM_Gen_DS_WClause_PVT (
1040: p_api_version => 1.0
1041: ,p_init_msg_list => FND_API.G_FALSE
1042: ,p_encoded => FND_API.G_TRUE
1043: ,x_return_status => l_return_status
1044: ,x_msg_count => l_msg_count
1045: ,x_msg_data => l_msg_data

Line 1042: ,p_encoded => FND_API.G_TRUE

1038: ------------------------------------------------------------------------------
1039: FEM_DS_WHERE_CLAUSE_GENERATOR.FEM_Gen_DS_WClause_PVT (
1040: p_api_version => 1.0
1041: ,p_init_msg_list => FND_API.G_FALSE
1042: ,p_encoded => FND_API.G_TRUE
1043: ,x_return_status => l_return_status
1044: ,x_msg_count => l_msg_count
1045: ,x_msg_data => l_msg_data
1046: ,p_ds_io_def_id => x_request_rec.dataset_grp_obj_def_id

Line 1054: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1050: ,p_ledger_id => x_request_rec.ledger_id
1051: ,p_where_clause => x_input_ds_b_where_clause
1052: );
1053:
1054: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1055: Get_Put_Messages (
1056: p_msg_count => l_msg_count
1057: ,p_msg_data => l_msg_data
1058: );

Line 1459: ,p_commit => FND_API.G_FALSE

1455: -- Call the FEM_PL_PKG.Register_Request API procedure to register
1456: -- the concurrent request in FEM_PL_REQUESTS.
1457: FEM_PL_PKG.Register_Request (
1458: p_api_version => 1.0
1459: ,p_commit => FND_API.G_FALSE
1460: ,p_cal_period_id => p_request_rec.output_cal_period_id
1461: ,p_ledger_id => p_request_rec.ledger_id
1462: ,p_dataset_io_obj_def_id => p_request_rec.dataset_grp_obj_def_id
1463: ,p_output_dataset_code => p_request_rec.output_dataset_code

Line 1484: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1480: ,x_return_status => l_return_status
1481: );
1482:
1483: -- Request Lock exists
1484: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1485: Get_Put_Messages (
1486: p_msg_count => l_msg_count
1487: ,p_msg_data => l_msg_data
1488: );

Line 1585: x_return_status := FND_API.G_RET_STS_SUCCESS;

1581: );
1582:
1583: -- Initialize the return status to SUCCESS
1584:
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586:
1587: ------------------------------------------------------------------------------
1588: -- STEP 1: Rule Pre Processing
1589: ------------------------------------------------------------------------------

Line 1727: x_return_status := FND_API.G_RET_STS_ERROR;

1723:
1724: -- Proper handling of continue processing on error
1725: -- raise g_act_rate_request_error;
1726:
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: when g_act_rate_request_error then
1730:
1731: -- Rule Post Processing

Line 1742: x_return_status := FND_API.G_RET_STS_ERROR;

1738:
1739: -- Proper handling of continue processing on error
1740: -- raise g_act_rate_request_error;
1741:
1742: x_return_status := FND_API.G_RET_STS_ERROR;
1743:
1744: when others then
1745:
1746: g_prg_msg := SQLERRM;

Line 1774: x_return_status := FND_API.G_RET_STS_ERROR;

1770:
1771: -- Proper handling of continue processing on error
1772: -- raise g_act_rate_request_error;
1773:
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775:
1776: END Act_Rate_Rule;
1777:
1778:

Line 1858: ,p_init_msg_list => FND_API.G_FALSE

1854:
1855: --todo: MP integration (???)
1856: FEM_COMPOSITE_DIM_UTILS_PVT.Populate_Activity_Id (
1857: p_api_version => 1.0
1858: ,p_init_msg_list => FND_API.G_FALSE
1859: ,p_commit => FND_API.G_TRUE
1860: ,x_return_status => l_return_status
1861: ,x_msg_count => l_msg_count
1862: ,x_msg_data => l_msg_data

Line 1859: ,p_commit => FND_API.G_TRUE

1855: --todo: MP integration (???)
1856: FEM_COMPOSITE_DIM_UTILS_PVT.Populate_Activity_Id (
1857: p_api_version => 1.0
1858: ,p_init_msg_list => FND_API.G_FALSE
1859: ,p_commit => FND_API.G_TRUE
1860: ,x_return_status => l_return_status
1861: ,x_msg_count => l_msg_count
1862: ,x_msg_data => l_msg_data
1863: ,p_object_type_code => p_rule_rec.act_rate_obj_type_code

Line 1875: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1871: ,p_ledger_id => p_request_rec.ledger_id
1872: );
1873:
1874: -- Check the return status after calling FEM_COMPOSITE_DIM_UTILS_PVT API's
1875: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1876: Get_Put_Messages (
1877: p_msg_count => l_msg_count
1878: ,p_msg_data => l_msg_data
1879: );

Line 2822: ,p_commit => FND_API.G_FALSE

2818: -- the activity rate object execution in FEM_PL_OBJECT_EXECUTIONS, thus obtaining
2819: -- an execution lock.
2820: FEM_PL_PKG.Register_Object_Execution (
2821: p_api_version => 1.0
2822: ,p_commit => FND_API.G_FALSE
2823: ,p_request_id => p_request_rec.request_id
2824: ,p_object_id => p_rule_rec.act_rate_obj_id
2825: ,p_exec_object_definition_id => p_rule_rec.act_rate_obj_def_id
2826: ,p_user_id => p_request_rec.user_id

Line 2836: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

2832: ,x_msg_data => l_msg_data
2833: ,x_return_status => l_return_status
2834: );
2835:
2836: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2837: Get_Put_Messages (
2838: p_msg_count => l_msg_count
2839: ,p_msg_data => l_msg_data
2840: );

Line 2854: ,p_commit => FND_API.G_FALSE

2850:
2851: -- Register all the Dependent Objects for the activity rate Object Definition
2852: FEM_PL_PKG.Register_Dependent_ObjDefs (
2853: p_api_version => 1.0
2854: ,p_commit => FND_API.G_FALSE
2855: ,p_request_id => p_request_rec.request_id
2856: ,p_object_id => p_rule_rec.act_rate_obj_id
2857: ,p_exec_object_definition_id => p_rule_rec.act_rate_obj_def_id
2858: ,p_effective_date => p_request_rec.effective_date

Line 2866: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

2862: ,x_msg_data => l_msg_data
2863: ,x_return_status => l_return_status
2864: );
2865:
2866: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2867: Get_Put_Messages (
2868: p_msg_count => l_msg_count
2869: ,p_msg_data => l_msg_data
2870: );

Line 2990: ,p_commit => FND_API.G_FALSE

2986: -- the specified object definition in FEM_PL_OBJECT_DEFS, thus obtaining
2987: -- an object definition lock.
2988: FEM_PL_PKG.Register_Object_Def (
2989: p_api_version => 1.0
2990: ,p_commit => FND_API.G_FALSE
2991: ,p_request_id => p_request_rec.request_id
2992: ,p_object_id => p_rule_rec.act_rate_obj_id
2993: ,p_object_definition_id => p_obj_def_id
2994: ,p_user_id => p_request_rec.user_id

Line 3002: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

2998: ,x_return_status => l_return_status
2999: );
3000:
3001: -- Object Definition Lock exists
3002: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3003: Get_Put_Messages (
3004: p_msg_count => l_msg_count
3005: ,p_msg_data => l_msg_data
3006: );

Line 3071: ,p_commit => FND_API.G_FALSE

3067: -- Call the FEM_PL_PKG.Register_Table API procedure to register
3068: -- the specified output table and the statement type that will be used.
3069: FEM_PL_PKG.Register_Table (
3070: p_api_version => 1.0
3071: ,p_commit => FND_API.G_FALSE
3072: ,p_request_id => p_request_rec.request_id
3073: ,p_object_id => p_rule_rec.act_rate_obj_id
3074: ,p_table_name => p_table_name
3075: ,p_statement_type => p_statement_type

Line 3084: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3080: ,x_msg_data => l_msg_data
3081: ,x_return_status => l_return_status
3082: );
3083:
3084: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3085: Get_Put_Messages (
3086: p_msg_count => l_msg_count
3087: ,p_msg_data => l_msg_data
3088: );

Line 3151: ,p_commit => FND_API.G_FALSE

3147: );
3148:
3149: FEM_PL_PKG.Register_Obj_Exec_Step (
3150: p_api_version => 1.0
3151: ,p_commit => FND_API.G_FALSE
3152: ,p_request_id => p_request_rec.request_id
3153: ,p_object_id => p_rule_rec.act_rate_obj_id
3154: ,p_exec_step => p_exec_step
3155: ,p_exec_status_code => p_exec_status_code

Line 3163: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3159: ,x_msg_data => l_msg_data
3160: ,x_return_status => l_return_status
3161: );
3162:
3163: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3164: Get_Put_Messages (
3165: p_msg_count => l_msg_count
3166: ,p_msg_data => l_msg_data
3167: );

Line 3232: ,p_commit => FND_API.G_FALSE

3228: );
3229:
3230: FEM_PL_PKG.Update_Obj_Exec_Step_Status (
3231: p_api_version => 1.0
3232: ,p_commit => FND_API.G_FALSE
3233: ,p_request_id => p_request_rec.request_id
3234: ,p_object_id => p_rule_rec.act_rate_obj_id
3235: ,p_exec_step => p_exec_step
3236: ,p_exec_status_code => p_exec_status_code

Line 3244: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3240: ,x_msg_data => l_msg_data
3241: ,x_return_status => l_return_status
3242: );
3243:
3244: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3245: Get_Put_Messages (
3246: p_msg_count => l_msg_count
3247: ,p_msg_data => l_msg_data
3248: );

Line 3331: ,p_commit => FND_API.G_FALSE

3327:
3328: -- Register Temp Sequence in PL Framework
3329: FEM_PL_PKG.Register_Temp_Object (
3330: p_api_version => 1.0
3331: ,p_commit => FND_API.G_FALSE
3332: ,p_request_id => p_request_rec.request_id
3333: ,p_object_id => p_rule_rec.act_rate_obj_id
3334: ,p_object_type => 'SEQUENCE'
3335: ,p_object_name => p_rule_rec.rate_sequence_name

Line 3344: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3340: ,x_msg_data => l_msg_data
3341: );
3342:
3343: -- Check return status
3344: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3345: Get_Put_Messages (
3346: p_msg_count => l_msg_count
3347: ,p_msg_data => l_msg_data
3348: );

Line 3376: ,p_commit => FND_API.G_FALSE

3372:
3373: -- Register Temp Sequence in PL Framework
3374: FEM_PL_PKG.Register_Temp_Object (
3375: p_api_version => 1.0
3376: ,p_commit => FND_API.G_FALSE
3377: ,p_request_id => p_request_rec.request_id
3378: ,p_object_id => p_rule_rec.act_rate_obj_id
3379: ,p_object_type => 'SEQUENCE'
3380: ,p_object_name => p_rule_rec.drv_sequence_name

Line 3389: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3385: ,x_msg_data => l_msg_data
3386: );
3387:
3388: -- Check return status
3389: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3390: Get_Put_Messages (
3391: p_msg_count => l_msg_count
3392: ,p_msg_data => l_msg_data
3393: );

Line 3678: ,p_init_msg_list => FND_API.G_FALSE

3674: if (p_rule_rec.cond_exists) then
3675:
3676: FEM_CONDITIONS_API.Generate_Condition_Predicate (
3677: p_api_version => 1.0
3678: ,p_init_msg_list => FND_API.G_FALSE
3679: ,p_commit => FND_API.G_FALSE
3680: ,p_encoded => FND_API.G_TRUE
3681: ,x_return_status => l_return_status
3682: ,x_msg_count => l_msg_count

Line 3679: ,p_commit => FND_API.G_FALSE

3675:
3676: FEM_CONDITIONS_API.Generate_Condition_Predicate (
3677: p_api_version => 1.0
3678: ,p_init_msg_list => FND_API.G_FALSE
3679: ,p_commit => FND_API.G_FALSE
3680: ,p_encoded => FND_API.G_TRUE
3681: ,x_return_status => l_return_status
3682: ,x_msg_count => l_msg_count
3683: ,x_msg_data => l_msg_data

Line 3680: ,p_encoded => FND_API.G_TRUE

3676: FEM_CONDITIONS_API.Generate_Condition_Predicate (
3677: p_api_version => 1.0
3678: ,p_init_msg_list => FND_API.G_FALSE
3679: ,p_commit => FND_API.G_FALSE
3680: ,p_encoded => FND_API.G_TRUE
3681: ,x_return_status => l_return_status
3682: ,x_msg_count => l_msg_count
3683: ,x_msg_data => l_msg_data
3684: ,p_condition_obj_id => p_rule_rec.cond_obj_id

Line 3694: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3690: ,p_logging_turned_on => 'N'
3691: ,x_predicate_string => l_act_cond_where_clause
3692: );
3693:
3694: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3695: Get_Put_Messages (
3696: p_msg_count => l_msg_count
3697: ,p_msg_data => l_msg_data
3698: );

Line 4234: ,p_init_msg_list => FND_API.G_FALSE

4230: -- Call the Where Clause Generator for source data in FEM_BALANCES
4231: ------------------------------------------------------------------------
4232: FEM_DS_WHERE_CLAUSE_GENERATOR.FEM_Gen_DS_WClause_PVT (
4233: p_api_version => 1.0
4234: ,p_init_msg_list => FND_API.G_FALSE
4235: ,p_encoded => FND_API.G_TRUE
4236: ,x_return_status => l_return_status
4237: ,x_msg_count => l_msg_count
4238: ,x_msg_data => l_msg_data

Line 4235: ,p_encoded => FND_API.G_TRUE

4231: ------------------------------------------------------------------------
4232: FEM_DS_WHERE_CLAUSE_GENERATOR.FEM_Gen_DS_WClause_PVT (
4233: p_api_version => 1.0
4234: ,p_init_msg_list => FND_API.G_FALSE
4235: ,p_encoded => FND_API.G_TRUE
4236: ,x_return_status => l_return_status
4237: ,x_msg_count => l_msg_count
4238: ,x_msg_data => l_msg_data
4239: ,p_ds_io_def_id => p_dataset_grp_obj_def_id

Line 4247: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

4243: ,p_ledger_id => p_ledger_id
4244: ,p_where_clause => l_input_ds_d_where_clause
4245: );
4246:
4247: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4248: Get_Put_Messages (
4249: p_msg_count => l_msg_count
4250: ,p_msg_data => l_msg_data
4251: );

Line 4269: ,p_init_msg_list => FND_API.G_FALSE

4265: if (l_drv_condition_obj_id_tbl(i) is not null) then
4266:
4267: FEM_CONDITIONS_API.Generate_Condition_Predicate (
4268: p_api_version => 1.0
4269: ,p_init_msg_list => FND_API.G_FALSE
4270: ,p_commit => FND_API.G_FALSE
4271: ,p_encoded => FND_API.G_TRUE
4272: ,x_return_status => l_return_status
4273: ,x_msg_count => l_msg_count

Line 4270: ,p_commit => FND_API.G_FALSE

4266:
4267: FEM_CONDITIONS_API.Generate_Condition_Predicate (
4268: p_api_version => 1.0
4269: ,p_init_msg_list => FND_API.G_FALSE
4270: ,p_commit => FND_API.G_FALSE
4271: ,p_encoded => FND_API.G_TRUE
4272: ,x_return_status => l_return_status
4273: ,x_msg_count => l_msg_count
4274: ,x_msg_data => l_msg_data

Line 4271: ,p_encoded => FND_API.G_TRUE

4267: FEM_CONDITIONS_API.Generate_Condition_Predicate (
4268: p_api_version => 1.0
4269: ,p_init_msg_list => FND_API.G_FALSE
4270: ,p_commit => FND_API.G_FALSE
4271: ,p_encoded => FND_API.G_TRUE
4272: ,x_return_status => l_return_status
4273: ,x_msg_count => l_msg_count
4274: ,x_msg_data => l_msg_data
4275: ,p_condition_obj_id => l_drv_condition_obj_id_tbl(i)

Line 4285: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

4281: ,p_logging_turned_on => 'N'
4282: ,x_predicate_string => l_drv_cond_where_clause
4283: );
4284:
4285: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4286: Get_Put_Messages (
4287: p_msg_count => l_msg_count
4288: ,p_msg_data => l_msg_data
4289: );

Line 4698: ,p_commit => FND_API.G_FALSE

4694: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
4695: -- the specified chain.
4696: FEM_PL_PKG.Register_Chain (
4697: p_api_version => 1.0
4698: ,p_commit => FND_API.G_FALSE
4699: ,p_request_id => p_request_id
4700: ,p_object_id => p_act_rate_obj_id
4701: ,p_source_created_by_request_id => l_created_by_request_id_tbl(i)
4702: ,p_source_created_by_object_id => l_created_by_object_id_tbl(i)

Line 4710: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

4706: ,x_msg_data => l_msg_data
4707: ,x_return_status => l_return_status
4708: );
4709:
4710: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4711: Get_Put_Messages (
4712: p_msg_count => l_msg_count
4713: ,p_msg_data => l_msg_data
4714: );

Line 4895: ,p_commit => FND_API.G_FALSE

4891: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
4892: -- the specified chain.
4893: FEM_PL_PKG.Register_Chain (
4894: p_api_version => 1.0
4895: ,p_commit => FND_API.G_FALSE
4896: ,p_request_id => p_request_id
4897: ,p_object_id => p_act_rate_obj_id
4898: ,p_source_created_by_request_id => t_created_by_request_id(i)
4899: ,p_source_created_by_object_id => t_created_by_object_id(i)

Line 4907: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

4903: ,x_msg_data => l_msg_data
4904: ,x_return_status => l_return_status
4905: );
4906:
4907: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
4908: Get_Put_Messages (
4909: p_msg_count => l_msg_count
4910: ,p_msg_data => l_msg_data
4911: );

Line 5087: ,p_commit => FND_API.G_FALSE

5083: ,p_rule_rec.act_rate_obj_id;
5084:
5085: FEM_PL_PKG.Update_Num_Of_Input_Rows (
5086: p_api_version => 1.0
5087: ,p_commit => FND_API.G_FALSE
5088: ,p_request_id => p_request_rec.request_id
5089: ,p_object_id => p_rule_rec.act_rate_obj_id
5090: ,p_num_of_input_rows => l_num_of_input_rows
5091: ,p_user_id => p_request_rec.user_id

Line 5098: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5094: ,x_msg_data => l_msg_data
5095: ,x_return_status => l_return_status
5096: );
5097:
5098: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5099: Get_Put_Messages (
5100: p_msg_count => l_msg_count
5101: ,p_msg_data => l_msg_data
5102: );

Line 5176: ,p_commit => FND_API.G_FALSE

5172:
5173: -- Set the number of output rows for the FEM_BALANCES output table.
5174: FEM_PL_PKG.Update_Num_Of_Output_Rows (
5175: p_api_version => 1.0
5176: ,p_commit => FND_API.G_FALSE
5177: ,p_request_id => p_request_rec.request_id
5178: ,p_object_id => p_rule_rec.act_rate_obj_id
5179: ,p_table_name => 'FEM_BALANCES'
5180: ,p_statement_type => 'INSERT'

Line 5189: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5185: ,x_msg_data => l_msg_data
5186: ,x_return_status => l_return_status
5187: );
5188:
5189: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5190: Get_Put_Messages (
5191: p_msg_count => l_msg_count
5192: ,p_msg_data => l_msg_data
5193: );

Line 5208: ,p_commit => FND_API.G_FALSE

5204: );
5205:
5206: FEM_PL_PKG.Update_Obj_Exec_Status (
5207: p_api_version => 1.0
5208: ,p_commit => FND_API.G_FALSE
5209: ,p_request_id => p_request_rec.request_id
5210: ,p_object_id => p_rule_rec.act_rate_obj_id
5211: ,p_exec_status_code => p_exec_status_code
5212: ,p_user_id => p_request_rec.user_id

Line 5219: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5215: ,x_msg_data => l_msg_data
5216: ,x_return_status => l_return_status
5217: );
5218:
5219: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5220: Get_Put_Messages (
5221: p_msg_count => l_msg_count
5222: ,p_msg_data => l_msg_data
5223: );

Line 5241: ,p_commit => FND_API.G_FALSE

5237:
5238: -- An Activity Rate Rule is an all or nothing deal, so only 1 error can be reported
5239: FEM_PL_PKG.Update_Obj_Exec_Errors (
5240: p_api_version => 1.0
5241: ,p_commit => FND_API.G_FALSE
5242: ,p_request_id => p_request_rec.request_id
5243: ,p_object_id => p_rule_rec.act_rate_obj_id
5244: ,p_errors_reported => 1
5245: ,p_errors_reprocessed => 0

Line 5253: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5249: ,x_msg_data => l_msg_data
5250: ,x_return_status => l_return_status
5251: );
5252:
5253: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5254: Get_Put_Messages (
5255: p_msg_count => l_msg_count
5256: ,p_msg_data => l_msg_data
5257: );

Line 5338: ,p_init_msg_list => FND_API.G_FALSE

5334: );
5335:
5336: FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT (
5337: p_api_version => 1.0
5338: ,p_init_msg_list => FND_API.G_FALSE
5339: ,p_commit => FND_API.G_TRUE
5340: ,p_encoded => FND_API.G_TRUE
5341: ,x_return_status => l_return_status
5342: ,x_msg_count => l_msg_count

Line 5339: ,p_commit => FND_API.G_TRUE

5335:
5336: FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT (
5337: p_api_version => 1.0
5338: ,p_init_msg_list => FND_API.G_FALSE
5339: ,p_commit => FND_API.G_TRUE
5340: ,p_encoded => FND_API.G_TRUE
5341: ,x_return_status => l_return_status
5342: ,x_msg_count => l_msg_count
5343: ,x_msg_data => l_msg_data

Line 5340: ,p_encoded => FND_API.G_TRUE

5336: FEM_RULE_SET_MANAGER.FEM_DeleteFlatRuleList_PVT (
5337: p_api_version => 1.0
5338: ,p_init_msg_list => FND_API.G_FALSE
5339: ,p_commit => FND_API.G_TRUE
5340: ,p_encoded => FND_API.G_TRUE
5341: ,x_return_status => l_return_status
5342: ,x_msg_count => l_msg_count
5343: ,x_msg_data => l_msg_data
5344: ,p_ruleset_object_id => p_request_rec.ruleset_obj_id

Line 5347: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5343: ,x_msg_data => l_msg_data
5344: ,p_ruleset_object_id => p_request_rec.ruleset_obj_id
5345: );
5346:
5347: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5348: Get_Put_Messages (
5349: p_msg_count => l_msg_count
5350: ,p_msg_data => l_msg_data
5351: );

Line 5368: ,p_commit => FND_API.G_FALSE

5364: );
5365:
5366: FEM_PL_PKG.Update_Request_Status (
5367: p_api_version => 1.0
5368: ,p_commit => FND_API.G_FALSE
5369: ,p_request_id => p_request_rec.request_id
5370: ,p_exec_status_code => p_exec_status_code
5371: ,p_user_id => p_request_rec.user_id
5372: ,p_last_update_login => p_request_rec.login_id

Line 5378: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

5374: ,x_msg_data => l_msg_data
5375: ,x_return_status => l_return_status
5376: );
5377:
5378: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5379: Get_Put_Messages (
5380: p_msg_count => l_msg_count
5381: ,p_msg_data => l_msg_data
5382: );

Line 5533: ,p_encoded => FND_API.G_FALSE

5529: for i in 1..p_msg_count loop
5530:
5531: FND_MSG_PUB.Get (
5532: p_msg_index => i
5533: ,p_encoded => FND_API.G_FALSE
5534: ,p_data => l_message
5535: ,p_msg_index_out => l_msg_out
5536: );
5537: