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 1979: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(

1975: IS
1976: l_return_value VARCHAR2(1) := 'N';
1977: BEGIN
1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1980: p_project_type_id => p_project_type_id ), 0 ) <> 0
1981: THEN
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: x_error_message_code :='PA_CI_PROJ_TYPE_IN_USE';

Line 2005: IF NVL(Pa_Control_items_utils.Check_Class_Category_In_Use

2001: IS
2002:
2003: BEGIN
2004: x_return_status :='S';
2005: IF NVL(Pa_Control_items_utils.Check_Class_Category_In_Use
2006: (p_class_category=>p_class_category),0)=1
2007: THEN
2008: x_return_status := 'F' ;
2009: x_error_message_code := 'PA_CI_CLASS_CAT_IN_USE';

Line 2029: IF NVL(Pa_Control_items_utils.Check_Class_Code_In_Use

2025: IS
2026:
2027: BEGIN
2028: x_return_status :='S';
2029: IF NVL(Pa_Control_items_utils.Check_Class_Code_In_Use
2030: (p_class_category=>p_class_category,
2031: P_class_code => p_class_code ),0)=1
2032: THEN
2033: x_return_status := 'F' ;