DBA Data[Home] [Help]

APPS.IEX_STRATEGY_PVT dependencies on FND_API

Line 14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE Create_strategy(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
18: X_STRATEGY_ID OUT NOCOPY NUMBER,

Line 15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

11:
12: PROCEDURE Create_strategy(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
18: X_STRATEGY_ID OUT NOCOPY NUMBER,
19: X_Return_Status OUT NOCOPY VARCHAR2,

Line 16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

12: PROCEDURE Create_strategy(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
18: X_STRATEGY_ID OUT NOCOPY NUMBER,
19: X_Return_Status OUT NOCOPY VARCHAR2,
20: X_Msg_Count OUT NOCOPY NUMBER,

Line 45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

41: END IF;
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_STRATEGY_PVT;
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52: -- IF PG_DEBUG < 10 THEN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After Compatibility Check');

Line 58: IF FND_API.to_Boolean( p_init_msg_list )

54: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After Compatibility Check');
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )
59: THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: END IF;
62:
63:
64: -- Initialize API return status to SUCCESS
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: --
67: -- API body
68: --
69: -- ******************************************************************

Line 80: RAISE FND_API.G_EXC_ERROR;

76: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
77: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
78: FND_MSG_PUB.ADD;
79: END IF;
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82: -- IF PG_DEBUG < 10 THEN
83: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
84: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After Global user Check');

Line 115: RAISE FND_API.G_EXC_ERROR;

111: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
112: fnd_message.set_token('API_NAME', l_api_name);
113: fnd_message.set_token('MISSING_PARAM', 'delinquency_id');
114: fnd_msg_pub.add;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117: end if;
118:
119: */

Line 166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

162:
163:
164: x_STRATEGY_ID := v_STRATEGY_ID;
165:
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: --

Line 167: RAISE FND_API.G_EXC_ERROR;

163:
164: x_STRATEGY_ID := v_STRATEGY_ID;
165:
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: --
171: -- End of API body

Line 175: IF FND_API.to_Boolean( p_commit )

171: -- End of API body
172: --
173:
174: -- Standard check for p_commit
175: IF FND_API.to_Boolean( p_commit )
176: THEN
177: COMMIT WORK;
178: END IF;
179:

Line 193: WHEN FND_API.G_EXC_ERROR THEN

189: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
190: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_PVT.create_STRATEGY ******** ');
191: END IF;
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
195: P_API_NAME => L_API_NAME
196: ,P_PKG_NAME => G_PKG_NAME
197: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

199: ,X_MSG_COUNT => X_MSG_COUNT
200: ,X_MSG_DATA => X_MSG_DATA
201: ,X_RETURN_STATUS => X_RETURN_STATUS);
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
205: P_API_NAME => L_API_NAME
206: ,P_PKG_NAME => G_PKG_NAME
207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

226:
227: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
228: PROCEDURE Update_strategy(
229: P_Api_Version_Number IN NUMBER,
230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
234: X_Return_Status OUT NOCOPY VARCHAR2,

Line 231: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

227: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
228: PROCEDURE Update_strategy(
229: P_Api_Version_Number IN NUMBER,
230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
234: X_Return_Status OUT NOCOPY VARCHAR2,
235: X_Msg_Count OUT NOCOPY NUMBER,

Line 232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

228: PROCEDURE Update_strategy(
229: P_Api_Version_Number IN NUMBER,
230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: P_STRATEGY_Rec IN STRATEGY_Rec_Type,
234: X_Return_Status OUT NOCOPY VARCHAR2,
235: X_Msg_Count OUT NOCOPY NUMBER,
236: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 281: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

277: -- Standard Start of API savepoint
278: SAVEPOINT UPDATE_STRATEGY_PVT;
279:
280: -- Standard call to check for call compatibility.
281: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
282: p_api_version_number,
283: l_api_name,
284: G_PKG_NAME)
285: THEN

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: p_api_version_number,
283: l_api_name,
284: G_PKG_NAME)
285: THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 291: IF FND_API.to_Boolean( p_init_msg_list )

287: END IF;
288:
289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291: IF FND_API.to_Boolean( p_init_msg_list )
292: THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: --
300: -- API body
301: --

Line 354: IF FND_API.to_Boolean( p_commit )

350: -- End of API body.
351: --
352:
353: -- Standard check for p_commit
354: IF FND_API.to_Boolean( p_commit )
355: THEN
356: COMMIT WORK;
357: END IF;
358:

Line 369: WHEN FND_API.G_EXC_ERROR THEN

365: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
366: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_strategy_PVT.Update_strategy ******** ');
367: END IF;
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
371: P_API_NAME => L_API_NAME
372: ,P_PKG_NAME => G_PKG_NAME
373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: ,X_MSG_COUNT => X_MSG_COUNT
376: ,X_MSG_DATA => X_MSG_DATA
377: ,X_RETURN_STATUS => X_RETURN_STATUS);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
381: P_API_NAME => L_API_NAME
382: ,P_PKG_NAME => G_PKG_NAME
383: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 407: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

403: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
404: -- The Master delete procedure may not be needed depends on different business requirements.
405: PROCEDURE Delete_strategy(
406: P_Api_Version_Number IN NUMBER,
407: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
408: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: P_STRATEGY_ID IN NUMBER,
411: X_Return_Status OUT NOCOPY VARCHAR2,

Line 408: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

404: -- The Master delete procedure may not be needed depends on different business requirements.
405: PROCEDURE Delete_strategy(
406: P_Api_Version_Number IN NUMBER,
407: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
408: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: P_STRATEGY_ID IN NUMBER,
411: X_Return_Status OUT NOCOPY VARCHAR2,
412: X_Msg_Count OUT NOCOPY NUMBER,

Line 409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

405: PROCEDURE Delete_strategy(
406: P_Api_Version_Number IN NUMBER,
407: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
408: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
410: P_STRATEGY_ID IN NUMBER,
411: X_Return_Status OUT NOCOPY VARCHAR2,
412: X_Msg_Count OUT NOCOPY NUMBER,
413: X_Msg_Data OUT NOCOPY VARCHAR2 )

Line 424: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

420: -- Standard Start of API savepoint
421: SAVEPOINT DELETE_STRATEGY_PVT;
422:
423: -- Standard call to check for call compatibility.
424: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
425: p_api_version_number,
426: l_api_name,
427: G_PKG_NAME)
428: THEN

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: p_api_version_number,
426: l_api_name,
427: G_PKG_NAME)
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431:
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 434: IF FND_API.to_Boolean( p_init_msg_list )

430: END IF;
431:
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list )
435: THEN
436: FND_MSG_PUB.initialize;
437: END IF;
438:

Line 443: x_return_status := FND_API.G_RET_STS_SUCCESS;

439:
440:
441:
442: -- Initialize API return status to SUCCESS
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: --
446: -- Api body
447: --

Line 456: IF FND_API.to_Boolean( p_commit )

452: -- End of API body
453: --
454:
455: -- Standard check for p_commit
456: IF FND_API.to_Boolean( p_commit )
457: THEN
458: COMMIT WORK;
459: END IF;
460:

Line 471: WHEN FND_API.G_EXC_ERROR THEN

467: p_data => x_msg_data
468: );
469:
470: EXCEPTION
471: WHEN FND_API.G_EXC_ERROR THEN
472: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
473: P_API_NAME => L_API_NAME
474: ,P_PKG_NAME => G_PKG_NAME
475: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

477: ,X_MSG_COUNT => X_MSG_COUNT
478: ,X_MSG_DATA => X_MSG_DATA
479: ,X_RETURN_STATUS => X_RETURN_STATUS);
480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
483: P_API_NAME => L_API_NAME
484: ,P_PKG_NAME => G_PKG_NAME
485: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR