DBA Data[Home] [Help]

APPS.PA_PROJ_RETN_RULES_PKG dependencies on FND_API

Line 81: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR

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

Line 169: X_Return_Status_Code := FND_API.G_RET_STS_ERROR ;

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

Line 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;

Line 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

Line 242: X_Return_Status_Code := FND_API.G_RET_STS_ERROR ;

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:

Line 279: IF X_Return_Status_Code = FND_API.G_RET_STS_ERROR

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:

Line 307: X_Return_Status_Code := FND_API.G_RET_STS_ERROR;

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 := '';

Line 310: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;

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

Line 335: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;

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

Line 341: X_Return_Status_Code := FND_API.G_RET_STS_ERROR;

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: