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.FEM_CONDITIONS_API dependencies on FND_API

Line 304: p_commit => FND_API.G_FALSE,

300: ELSE
301:
302: FEM_DATABASE_UTIL_PKG.Get_Table_Owner(
303: p_api_version => 1.0,
304: p_commit => FND_API.G_FALSE,
305: p_init_msg_list => FND_API.G_TRUE,
306: p_encoded => FND_API.G_TRUE,
307: x_return_status => l_returnStatus,
308: x_msg_count => l_msgCount,

Line 305: p_init_msg_list => FND_API.G_TRUE,

301:
302: FEM_DATABASE_UTIL_PKG.Get_Table_Owner(
303: p_api_version => 1.0,
304: p_commit => FND_API.G_FALSE,
305: p_init_msg_list => FND_API.G_TRUE,
306: p_encoded => FND_API.G_TRUE,
307: x_return_status => l_returnStatus,
308: x_msg_count => l_msgCount,
309: x_msg_data => l_msgData,

Line 306: p_encoded => FND_API.G_TRUE,

302: FEM_DATABASE_UTIL_PKG.Get_Table_Owner(
303: p_api_version => 1.0,
304: p_commit => FND_API.G_FALSE,
305: p_init_msg_list => FND_API.G_TRUE,
306: p_encoded => FND_API.G_TRUE,
307: x_return_status => l_returnStatus,
308: x_msg_count => l_msgCount,
309: x_msg_data => l_msgData,
310: p_syn_name => p_synonymName,

Line 3018: p_encoded => FND_API.G_FALSE,

3014: FOR i IN 1..l_msg_count
3015: LOOP
3016: FND_MSG_PUB.Get(
3017: p_msg_index => i,
3018: p_encoded => FND_API.G_FALSE,
3019: p_data => l_message,
3020: p_msg_index_out => l_msg_out);
3021:
3022: FEM_ENGINES_PKG.User_Message(

Line 3525: if not FND_API.Compatible_API_Call (

3521: -- Standard Start of API Savepoint
3522: savepoint Generate_Dim_Hier_Query_PVT;
3523:
3524: -- Standard call to check for call compatibility
3525: if not FND_API.Compatible_API_Call (
3526: p_current_version_number => l_api_version
3527: ,p_caller_version_number => p_api_version
3528: ,p_api_name => l_api_name
3529: ,p_pkg_name => G_PKG_NAME

Line 3531: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3527: ,p_caller_version_number => p_api_version
3528: ,p_api_name => l_api_name
3529: ,p_pkg_name => G_PKG_NAME
3530: ) then
3531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3532: end if;
3533:
3534: -- Initialize Message Stack on FND_MSG_PUB
3535: if (FND_API.To_Boolean(p_init_msg_list)) then

Line 3535: if (FND_API.To_Boolean(p_init_msg_list)) then

3531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3532: end if;
3533:
3534: -- Initialize Message Stack on FND_MSG_PUB
3535: if (FND_API.To_Boolean(p_init_msg_list)) then
3536: FND_MSG_PUB.Initialize;
3537: end if;
3538:
3539: FEM_ENGINES_PKG.Tech_Message (

Line 3546: x_return_status := FND_API.G_RET_STS_SUCCESS;

3542: ,p_msg_text => 'BEGIN'
3543: );
3544:
3545: -- Initialize API return status to success
3546: x_return_status := FND_API.G_RET_STS_SUCCESS;
3547:
3548: if (p_dimension_id is null) then
3549: FEM_ENGINES_PKG.PUT_MESSAGE (
3550: p_app_name => G_FEM

Line 3555: raise FND_API.G_EXC_ERROR;

3551: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3552: ,p_token1 => G_PARAM_TOKEN
3553: ,p_value1 => 'p_dimension_id'
3554: );
3555: raise FND_API.G_EXC_ERROR;
3556: end if;
3557:
3558: if (p_hierarchy_object_id is null) then
3559: FEM_ENGINES_PKG.PUT_MESSAGE (

Line 3565: raise FND_API.G_EXC_ERROR;

3561: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3562: ,p_token1 => G_PARAM_TOKEN
3563: ,p_value1 => 'p_hierarchy_object_id'
3564: );
3565: raise FND_API.G_EXC_ERROR;
3566: end if;
3567:
3568: if (p_effective_date is null) then
3569: FEM_ENGINES_PKG.PUT_MESSAGE (

Line 3575: raise FND_API.G_EXC_ERROR;

3571: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3572: ,p_token1 => G_PARAM_TOKEN
3573: ,p_value1 => 'p_effective_date'
3574: );
3575: raise FND_API.G_EXC_ERROR;
3576: end if;
3577:
3578: if (p_relation_code is null) then
3579: FEM_ENGINES_PKG.PUT_MESSAGE (

Line 3585: raise FND_API.G_EXC_ERROR;

3581: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3582: ,p_token1 => G_PARAM_TOKEN
3583: ,p_value1 => 'p_relation_code'
3584: );
3585: raise FND_API.G_EXC_ERROR;
3586: end if;
3587:
3588: if (p_node_id is null) then
3589: FEM_ENGINES_PKG.PUT_MESSAGE (

Line 3595: raise FND_API.G_EXC_ERROR;

3591: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3592: ,p_token1 => G_PARAM_TOKEN
3593: ,p_value1 => 'p_node_id'
3594: );
3595: raise FND_API.G_EXC_ERROR;
3596: end if;
3597:
3598: -- get hierarchy obj def id for object
3599: Fem_Rule_Set_Manager.Get_ValidDefinition_Pub (

Line 3610: raise FND_API.G_EXC_ERROR;

3606:
3607: -- error check: halt processing on this step if valid hier def not found.
3608: if (l_err_code <> 0) then
3609: --Message has been logged in Fem_Rule_Set_Manager.Get_ValidDefinition_Pub
3610: raise FND_API.G_EXC_ERROR;
3611: end if;
3612:
3613: -- Check to see if this is a valid hierarchy dimension
3614: begin

Line 3632: raise FND_API.G_EXC_ERROR;

3628: ,p_msg_name => G_BAD_DIM_ID_ERR
3629: ,p_token1 => G_DIM_ID_TOKEN
3630: ,p_value1 => p_dimension_id
3631: );
3632: raise FND_API.G_EXC_ERROR;
3633: end;
3634:
3635: if (l_hierarchy_table_name is null) then
3636: -- Invalid Dimension

Line 3643: raise FND_API.G_EXC_ERROR;

3639: ,p_msg_name => G_DIM_BAD_DIM_LABEL
3640: ,p_token1 => G_DIM_LABEL_TOKEN
3641: ,p_value1 => l_dimension_varchar_label
3642: );
3643: raise FND_API.G_EXC_ERROR;
3644: end if;
3645:
3646: -- Validate the Value Set Id for VSR dimensions
3647: if (l_value_set_required_flag = 'Y') then

Line 3666: raise FND_API.G_EXC_ERROR;

3662: ,p_msg_name => G_NULL_PARAM_VALUE_ERR
3663: ,p_token1 => G_PARAM_TOKEN
3664: ,p_value1 => 'p_value_set_id'
3665: );
3666: raise FND_API.G_EXC_ERROR;
3667:
3668: end if;
3669:
3670: end if;

Line 3693: raise FND_API.G_EXC_ERROR;

3689: FEM_ENGINES_PKG.PUT_MESSAGE (
3690: p_app_name => G_FEM
3691: ,p_msg_name => G_HIER_FLATTENED
3692: );
3693: raise FND_API.G_EXC_ERROR;
3694: end if;
3695:
3696: end if;
3697:

Line 3724: raise FND_API.G_EXC_ERROR;

3720: ,p_token2 => G_HIERARCHY_TOKEN
3721: ,p_value2 => l_hierarchy_obj_def_name
3722: );
3723:
3724: raise FND_API.G_EXC_ERROR;
3725:
3726: end if;
3727:
3728: if (l_flattened_flag = 'Y') then

Line 3760: raise FND_API.G_EXC_ERROR;

3756: ,p_token1 => G_RELATION_TOKEN
3757: ,p_value1 => p_relation_code
3758: );
3759:
3760: raise FND_API.G_EXC_ERROR;
3761:
3762: end if;
3763:
3764: x_query_string := l_query_string;

Line 3770: if FND_API.To_Boolean(p_commit) then

3766: -----------------------
3767: -- Finalize API Call --
3768: -----------------------
3769: -- Standard check of p_commit
3770: if FND_API.To_Boolean(p_commit) then
3771: commit work;
3772: end if;
3773:
3774: -- Standard call to get message count and if count is 1, get message info

Line 3788: when FND_API.G_EXC_ERROR then

3784: );
3785:
3786: EXCEPTION
3787:
3788: when FND_API.G_EXC_ERROR then
3789: rollback to Generate_Dim_Hier_Query_PVT;
3790: x_return_status := FND_API.G_RET_STS_ERROR;
3791: FND_MSG_PUB.Count_And_Get(
3792: p_count => x_msg_count

Line 3790: x_return_status := FND_API.G_RET_STS_ERROR;

3786: EXCEPTION
3787:
3788: when FND_API.G_EXC_ERROR then
3789: rollback to Generate_Dim_Hier_Query_PVT;
3790: x_return_status := FND_API.G_RET_STS_ERROR;
3791: FND_MSG_PUB.Count_And_Get(
3792: p_count => x_msg_count
3793: ,p_data => x_msg_data
3794: );

Line 3796: when FND_API.G_EXC_UNEXPECTED_ERROR then

3792: p_count => x_msg_count
3793: ,p_data => x_msg_data
3794: );
3795:
3796: when FND_API.G_EXC_UNEXPECTED_ERROR then
3797: rollback to Generate_Dim_Hier_Query_PVT;
3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3799: FND_MSG_PUB.Count_And_Get(
3800: p_count => x_msg_count

Line 3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3794: );
3795:
3796: when FND_API.G_EXC_UNEXPECTED_ERROR then
3797: rollback to Generate_Dim_Hier_Query_PVT;
3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3799: FND_MSG_PUB.Count_And_Get(
3800: p_count => x_msg_count
3801: ,p_data => x_msg_data
3802: );

Line 3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3802: );
3803:
3804: when others then
3805: rollback to Generate_Dim_Hier_Query_PVT;
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807: if (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) then
3808: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3809: end if;
3810: FND_MSG_PUB.Count_And_Get(