DBA Data[Home] [Help]

APPS.PA_DISPLAY_PERIOD_MASKS dependencies on FND_API

Line 1072: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1068: -- and update the version number as well.
1069:
1070: PROCEDURE update_current_pp (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1071: p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE,
1072: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1073: p_bud_rec_ver_num IN pa_budget_versions.record_version_number%TYPE,
1074: p_fp_rec_ver_num IN pa_proj_fp_options.record_version_number%TYPE,
1075: X_Return_Status OUT NOCOPY Varchar2,
1076: X_Msg_Count OUT NOCOPY Number,

Line 1088: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

1084: l_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
1085: l_curr_plan_period PA_BUDGET_VERSIONS.current_planning_period%type;
1086: BEGIN
1087: -- Initialize values
1088: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
1089: X_Msg_Count := 0;
1090: X_Msg_Data := Null;
1091: -- Make sure that the parameter is not null.
1092: if p_current_planning_period is null then

Line 1093: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

1089: X_Msg_Count := 0;
1090: X_Msg_Data := Null;
1091: -- Make sure that the parameter is not null.
1092: if p_current_planning_period is null then
1093: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
1094: X_Msg_Count := 1;
1095: X_Msg_Data := 'PA_NULL_CURR_PLAN_PERIOD';
1096: Pa_Utils.Add_Message
1097: (P_App_Short_Name => 'PA',

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: X_Msg_Data := 'PA_NULL_CURR_PLAN_PERIOD';
1096: Pa_Utils.Add_Message
1097: (P_App_Short_Name => 'PA',
1098: P_Msg_Name => 'PA_NULL_CURR_PLAN_PERIOD');
1099: RAISE FND_API.G_EXC_ERROR;
1100: end if;
1101: -- Fix for Bug 4898791
1102: BEGIN
1103: l_curr_plan_period := null;

Line 1108: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

1104: SELECT DISTINCT(period_name) into l_curr_plan_period FROM gl_periods where period_name=p_current_planning_period;
1105: exception
1106: when no_data_found
1107: then
1108: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
1109: X_Msg_Count := 1;
1110: X_Msg_Data := 'PA_INVALID_CURR_PLAN_PERIOD';
1111: Pa_Utils.Add_Message
1112: (P_App_Short_Name => 'PA',

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: X_Msg_Data := 'PA_INVALID_CURR_PLAN_PERIOD';
1111: Pa_Utils.Add_Message
1112: (P_App_Short_Name => 'PA',
1113: P_Msg_Name => 'PA_INVALID_CURR_PLAN_PERIOD');
1114: RAISE FND_API.G_EXC_ERROR;
1115:
1116: END; -- End of Fix for Bug 4898791
1117:
1118: OPEN get_version_type_csr(p_budget_version_id);

Line 1132: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

1128: WHERE budget_version_id = p_budget_version_id
1129: AND record_version_number = p_bud_rec_ver_num;
1130:
1131: IF sql%rowcount = 0 THEN
1132: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
1133: X_Msg_Count := 1;
1134: X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
1135: Pa_Utils.Add_Message
1136: (P_App_Short_Name => 'PA',

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
1135: Pa_Utils.Add_Message
1136: (P_App_Short_Name => 'PA',
1137: P_Msg_Name => 'PA_RECORD_ALREADY_UPDATED');
1138: RAISE FND_API.G_EXC_ERROR;
1139: END if;
1140:
1141: IF l_version_type = 'COST' THEN
1142: UPDATE pa_proj_fp_options

Line 1162: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

1158: AND record_version_number = p_fp_rec_ver_num;
1159: END IF;
1160:
1161: IF sql%rowcount = 0 THEN
1162: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
1163: X_Msg_Count := 1;
1164: X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
1165: Pa_Utils.Add_Message
1166: (P_App_Short_Name => 'PA',

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: X_Msg_Data := 'PA_RECORD_ALREADY_UPDATED';
1165: Pa_Utils.Add_Message
1166: (P_App_Short_Name => 'PA',
1167: P_Msg_Name => 'PA_RECORD_ALREADY_UPDATED');
1168: RAISE FND_API.G_EXC_ERROR;
1169: END if;
1170:
1171: X_Msg_Data := Null;
1172: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

Line 1172: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

1168: RAISE FND_API.G_EXC_ERROR;
1169: END if;
1170:
1171: X_Msg_Data := Null;
1172: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
1173:
1174: IF FND_API.to_boolean( p_commit )
1175: THEN
1176: COMMIT;

Line 1174: IF FND_API.to_boolean( p_commit )

1170:
1171: X_Msg_Data := Null;
1172: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
1173:
1174: IF FND_API.to_boolean( p_commit )
1175: THEN
1176: COMMIT;
1177: END IF;
1178:

Line 1180: WHEN FND_API.G_EXC_ERROR

1176: COMMIT;
1177: END IF;
1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR
1181: THEN
1182: X_return_status := FND_API.G_RET_STS_ERROR;
1183:
1184: When Others Then

Line 1182: X_return_status := FND_API.G_RET_STS_ERROR;

1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR
1181: THEN
1182: X_return_status := FND_API.G_RET_STS_ERROR;
1183:
1184: When Others Then
1185: Raise;
1186: