77: X_Return_Status_Code => X_Return_Status_Code,
78: X_Error_Message_Code => X_Error_Message_Code
79: );
80:
81: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR
82: THEN
83: RETURN;
84: ELSE
85: -- Fix for Bug 2671135
165: AND NVL(Revenue_Category_Code, 'z')= NVL(Revenue_Category_Code, 'z')
166: AND NVL(Event_Type, 'z') = NVL(Event_Type, 'z');
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: X_Return_Status_Code := FND_API.G_RET_STS_ERROR ;
170: X_Error_Message_Code := 'PA_DATA_ERROR';
171: END;
172:
173: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR
169: X_Return_Status_Code := FND_API.G_RET_STS_ERROR ;
170: X_Error_Message_Code := 'PA_DATA_ERROR';
171: END;
172:
173: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR
174: THEN
175: RETURN;
176: ELSE
177: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;
173: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR
174: THEN
175: RETURN;
176: ELSE
177: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;
178: END IF;
179: EXCEPTION
180: WHEN OTHERS THEN
181: X_Rowid := l_row_id ; --NOCOPY
238: END;
239:
240: IF P_Threshold_Amount < l_Retained_Amount
241: THEN
242: X_Return_Status_Code := FND_API.G_RET_STS_ERROR ;
243: X_Error_Message_Code := 'PA_RETN_THRSHLD_XD_RETAINED';
244: RETURN;
245: END IF;
246:
275: X_RETURN_STATUS_CODE => X_RETURN_STATUS_CODE,
276: X_ERROR_MESSAGE_CODE => X_ERROR_MESSAGE_CODE
277: );
278:
279: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR
280: THEN
281: RETURN;
282: END IF;
283:
303: RowIDToChar(RowID) = P_RowID;
304:
305: IF (SQL%NOTFOUND)
306: THEN
307: X_Return_Status_Code := FND_API.G_RET_STS_ERROR;
308: X_Error_Message_Code := 'PA_DATA_ERROR';
309: ELSE
310: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;
311: X_Error_Message_Code := '';
306: THEN
307: X_Return_Status_Code := FND_API.G_RET_STS_ERROR;
308: X_Error_Message_Code := 'PA_DATA_ERROR';
309: ELSE
310: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;
311: X_Error_Message_Code := '';
312: END IF;
313: EXCEPTION
314: WHEN OTHERS THEN
331: ) IS
332:
333: BEGIN
334:
335: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;
336:
337: DELETE FROM PA_PROJ_RETN_RULES
338: WHERE ROWID = P_RowID;
339: EXCEPTION
337: DELETE FROM PA_PROJ_RETN_RULES
338: WHERE ROWID = P_RowID;
339: EXCEPTION
340: WHEN OTHERS THEN
341: X_Return_Status_Code := FND_API.G_RET_STS_ERROR;
342: X_Error_Message_Code := 'PA_DATA_ERROR';
343:
344: END Delete_Row; -- Delete Row
345: