DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on PA_CONTROL_ITEMS_UTILS

Line 1169: IF PA_CONTROL_ITEMS_UTILS.check_control_item_exists( p_project_id => x_project_id ) <> 0

1165: --end of ORG-FORECASTING check.
1166:
1167: --PA K Build 3
1168: x_err_stage := 'Check Control items exist for project '|| x_project_id;
1169: IF PA_CONTROL_ITEMS_UTILS.check_control_item_exists( p_project_id => x_project_id ) <> 0
1170: THEN
1171: x_err_code := 200;
1172: x_err_stage := 'PA_CI_PROJ_TASK_IN_USE';
1173: return;

Line 1177: IF PA_CONTROL_ITEMS_UTILS.CheckNonDraftCI( p_project_id => x_project_id ) = 'Y'

1173: return;
1174: end if;
1175:
1176: x_err_stage := 'Check Non Draft Control items exist for project '|| x_project_id;
1177: IF PA_CONTROL_ITEMS_UTILS.CheckNonDraftCI( p_project_id => x_project_id ) = 'Y'
1178: THEN
1179: x_err_code := 210;
1180: x_err_stage := 'PA_CI_ITEMS_EXIST';
1181: return;

Line 1967: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(

1963: IS
1964: l_return_value VARCHAR2(1) := 'N';
1965: BEGIN
1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1968: p_project_type_id => p_project_type_id ), 0 ) <> 0
1969: THEN
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: x_error_message_code :='PA_CI_PROJ_TYPE_IN_USE';

Line 1993: IF NVL(Pa_Control_items_utils.Check_Class_Category_In_Use

1989: IS
1990:
1991: BEGIN
1992: x_return_status :='S';
1993: IF NVL(Pa_Control_items_utils.Check_Class_Category_In_Use
1994: (p_class_category=>p_class_category),0)=1
1995: THEN
1996: x_return_status := 'F' ;
1997: x_error_message_code := 'PA_CI_CLASS_CAT_IN_USE';

Line 2017: IF NVL(Pa_Control_items_utils.Check_Class_Code_In_Use

2013: IS
2014:
2015: BEGIN
2016: x_return_status :='S';
2017: IF NVL(Pa_Control_items_utils.Check_Class_Code_In_Use
2018: (p_class_category=>p_class_category,
2019: P_class_code => p_class_code ),0)=1
2020: THEN
2021: x_return_status := 'F' ;