DBA Data[Home] [Help]

APPS.IEX_BANKRUPTCIES_PVT dependencies on FND_API

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

17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18:
19: PROCEDURE Create_bankruptcy(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_bankruptcy_Rec IN bankruptcy_Rec_Type := G_MISS_bankruptcy_REC,
25: X_BANKRUPTCY_ID OUT NOCOPY NUMBER,

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

18:
19: PROCEDURE Create_bankruptcy(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_bankruptcy_Rec IN bankruptcy_Rec_Type := G_MISS_bankruptcy_REC,
25: X_BANKRUPTCY_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,

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

19: PROCEDURE Create_bankruptcy(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_bankruptcy_Rec IN bankruptcy_Rec_Type := G_MISS_bankruptcy_REC,
25: X_BANKRUPTCY_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,

Line 53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

49: -- Standard Start of API savepoint
50: SAVEPOINT CREATE_BANKRUPTCY_PVT;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 63: IF FND_API.to_Boolean( p_init_msg_list )

59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --
72: -- API body
73: --

Line 85: RAISE FND_API.G_EXC_ERROR;

81: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
82: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
83: FND_MSG_PUB.ADD;
84: END IF;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: -- IF PG_DEBUG < 10 THEN
88: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
89: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After Global user Check');

Line 114: (p_bankruptcy_rec.party_id = FND_API.G_MISS_NUM) THEN

110:
111:
112: --check for party_id
113: IF (p_bankruptcy_rec.party_id IS NULL) OR
114: (p_bankruptcy_rec.party_id = FND_API.G_MISS_NUM) THEN
115: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
116: fnd_message.set_token('API_NAME', l_api_name);
117: fnd_message.set_token('MISSING_PARAM', 'party_id');
118: fnd_msg_pub.add;

Line 119: RAISE FND_API.G_EXC_ERROR;

115: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
116: fnd_message.set_token('API_NAME', l_api_name);
117: fnd_message.set_token('MISSING_PARAM', 'party_id');
118: fnd_msg_pub.add;
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: -- IF PG_DEBUG < 10 THEN
122: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
123: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After party_id Check ');

Line 208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After Calling IEX_BANKRUPTCIES_PKG.'||
206: 'Insert_Row and BANKRUPTCY_ID is => '||x_BANKRUPTCY_ID);
207: END IF;
208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212: --

Line 209: RAISE FND_API.G_EXC_ERROR;

205: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After Calling IEX_BANKRUPTCIES_PKG.'||
206: 'Insert_Row and BANKRUPTCY_ID is => '||x_BANKRUPTCY_ID);
207: END IF;
208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212: --
213: -- End of API body

Line 217: IF FND_API.to_Boolean( p_commit )

213: -- End of API body
214: --
215:
216: -- Standard check for p_commit
217: IF FND_API.to_Boolean( p_commit )
218: THEN
219: COMMIT WORK;
220: END IF;
221:

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231: IEX_DEBUG_PUB.LogMessage ('Create_bankruptcy: ' || '********* end of Procedure =>'||
232: 'IEX_BANKRUPTCIES_PVT.create_BANKRUPTCY ******** ');
233: END IF;
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: ,X_MSG_COUNT => X_MSG_COUNT
242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

268:
269:
270: PROCEDURE Update_bankruptcy(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_bankruptcy_Rec IN bankruptcy_Rec_Type,
276: X_Return_Status OUT NOCOPY VARCHAR2,

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

269:
270: PROCEDURE Update_bankruptcy(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_bankruptcy_Rec IN bankruptcy_Rec_Type,
276: X_Return_Status OUT NOCOPY VARCHAR2,
277: X_Msg_Count OUT NOCOPY NUMBER,

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

270: PROCEDURE Update_bankruptcy(
271: P_Api_Version_Number IN NUMBER,
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_bankruptcy_Rec IN bankruptcy_Rec_Type,
276: X_Return_Status OUT NOCOPY VARCHAR2,
277: X_Msg_Count OUT NOCOPY NUMBER,
278: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 296: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

292: -- Standard Start of API savepoint
293: SAVEPOINT UPDATE_BANKRUPTCY_PVT;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
297: p_api_version_number,
298: l_api_name,
299: G_PKG_NAME)
300: THEN

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: p_api_version_number,
298: l_api_name,
299: G_PKG_NAME)
300: THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 306: IF FND_API.to_Boolean( p_init_msg_list )

302: END IF;
303:
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )
307: THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310:

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310:
311:
312:
313: -- Initialize API return status to SUCCESS
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: --
317: -- Api body
318: --

Line 407: IF FND_API.to_Boolean( p_commit )

403: -- End of API body.
404: --
405:
406: -- Standard check for p_commit
407: IF FND_API.to_Boolean( p_commit )
408: THEN
409: COMMIT WORK;
410: END IF;
411: -- Standard call to get message count and if count is 1, get message info.

Line 424: WHEN FND_API.G_EXC_ERROR THEN

420: 'IEX_BANKRUPTCIES_PVT.update_bankruptcy ******** ');
421: END IF;
422:
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME
437: ,P_PKG_NAME => G_PKG_NAME
438: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

457:
458:
459: PROCEDURE Delete_bankruptcy(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_bankruptcy_id IN NUMBER,
465: X_Return_Status OUT NOCOPY VARCHAR2,

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

458:
459: PROCEDURE Delete_bankruptcy(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_bankruptcy_id IN NUMBER,
465: X_Return_Status OUT NOCOPY VARCHAR2,
466: X_Msg_Count OUT NOCOPY NUMBER,

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

459: PROCEDURE Delete_bankruptcy(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_bankruptcy_id IN NUMBER,
465: X_Return_Status OUT NOCOPY VARCHAR2,
466: X_Msg_Count OUT NOCOPY NUMBER,
467: X_Msg_Data OUT NOCOPY VARCHAR2

Line 486: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

482: -- Standard Start of API savepoint
483: SAVEPOINT DELETE_BANKRUPTCY_PVT;
484:
485: -- Standard call to check for call compatibility.
486: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
487: p_api_version_number,
488: l_api_name,
489: G_PKG_NAME)
490: THEN

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: p_api_version_number,
488: l_api_name,
489: G_PKG_NAME)
490: THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494:
495: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 496: IF FND_API.to_Boolean( p_init_msg_list )

492: END IF;
493:
494:
495: -- Initialize message list if p_init_msg_list is set to TRUE.
496: IF FND_API.to_Boolean( p_init_msg_list )
497: THEN
498: FND_MSG_PUB.initialize;
499: END IF;
500:

Line 502: x_return_status := FND_API.G_RET_STS_SUCCESS;

498: FND_MSG_PUB.initialize;
499: END IF;
500:
501: -- Initialize API return status to SUCCESS
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: --
505: -- Api body
506: --

Line 516: IF FND_API.to_Boolean( p_commit )

512: -- End of API body
513: --
514:
515: -- Standard check for p_commit
516: IF FND_API.to_Boolean( p_commit )
517: THEN
518: COMMIT WORK;
519: END IF;
520:

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: 'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');
530: END IF;
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

539: ,X_MSG_COUNT => X_MSG_COUNT
540: ,X_MSG_DATA => X_MSG_DATA
541: ,X_RETURN_STATUS => X_RETURN_STATUS);
542:
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR