DBA Data[Home] [Help]

APPS.CSD_RT_TRAN_RESPS_PVT dependencies on FND_API

Line 51: IF NOT FND_API.Compatible_API_Call (lc_api_version,

47: -- Standard Start of API savepoint
48: SAVEPOINT Create_Rt_Tran_Resp;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (lc_api_version,
52: p_api_version,
53: lc_api_name ,
54: G_PKG_NAME )
55: THEN

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: p_api_version,
53: lc_api_name ,
54: G_PKG_NAME )
55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 60: IF FND_API.to_Boolean( p_init_msg_list ) THEN

56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: 'Entered Create_Rt_Tran_Resp');
67: END IF;
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Api body starts
73:
74: -- Check the required parameters

Line 124: IF FND_API.To_Boolean( p_commit ) THEN

120:
121: -- Api body ends here
122:
123: -- Standard check of p_commit.
124: IF FND_API.To_Boolean( p_commit ) THEN
125: COMMIT WORK;
126: END IF;
127:
128: -- Standard call to get message count and IF count is get message info.

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137:
138: EXCEPTION
139: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
140: ROLLBACK TO Create_Rt_Tran_Resp;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142:
143: -- The definition already exists. No duplicates are allowed.
144: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
145: FND_MSG_PUB.add;

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
154: 'EXC_ERROR['||x_msg_data||']');
155: END IF;
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO Create_Rt_Tran_Resp;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159:
160: FND_MSG_PUB.Count_And_Get

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154: 'EXC_ERROR['||x_msg_data||']');
155: END IF;
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO Create_Rt_Tran_Resp;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159:
160: FND_MSG_PUB.Count_And_Get
161: (p_count => x_msg_count,
162: p_data => x_msg_data );

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
167: 'EXC_ERROR['||x_msg_data||']');
168: END IF;
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Create_Rt_Tran_Resp;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: -- save message in fnd stack

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: END IF;
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Create_Rt_Tran_Resp;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: -- save message in fnd stack
175: IF FND_MSG_PUB.Check_Msg_Level
176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: END IF;
196:
197: WHEN OTHERS THEN
198: ROLLBACK TO Create_Rt_Tran_Resp;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: -- save message in fnd stack
202: IF FND_MSG_PUB.Check_Msg_Level
203: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 271: IF NOT FND_API.Compatible_API_Call (lc_api_version,

267: -- Standard Start of API savepoint
268: SAVEPOINT Update_Rt_Tran_Resp;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call (lc_api_version,
272: p_api_version,
273: lc_api_name ,
274: G_PKG_NAME )
275: THEN

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: p_api_version,
273: lc_api_name ,
274: G_PKG_NAME )
275: THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 280: IF FND_API.to_Boolean( p_init_msg_list ) THEN

276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.to_Boolean( p_init_msg_list ) THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: 'Entered Update_Rt_Tran_Resp');
287: END IF;
288:
289: -- Initialize API return status to success
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: -- Api body starts
293:
294: -- Check the required parameters

Line 347: IF FND_API.To_Boolean( p_commit ) THEN

343:
344: -- Api body ends here
345:
346: -- Standard check of p_commit.
347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
351: -- Standard call to get message count and IF count is get message info.

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360:
361: EXCEPTION
362: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
363: ROLLBACK TO Update_Rt_Tran_Resp;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365:
366: -- The definition already exists. No duplicates are allowed.
367: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
368: FND_MSG_PUB.add;

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
377: 'EXC_ERROR['||x_msg_data||']');
378: END IF;
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO Update_Rt_Tran_Resp;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: FND_MSG_PUB.Count_And_Get

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377: 'EXC_ERROR['||x_msg_data||']');
378: END IF;
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO Update_Rt_Tran_Resp;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: FND_MSG_PUB.Count_And_Get
384: (p_count => x_msg_count,
385: p_data => x_msg_data );

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
390: 'EXC_ERROR['||x_msg_data||']');
391: END IF;
392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO Update_Rt_Tran_Resp;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
397: IF FND_MSG_PUB.Check_Msg_Level

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: END IF;
392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO Update_Rt_Tran_Resp;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
397: IF FND_MSG_PUB.Check_Msg_Level
398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

417: END IF;
418:
419: WHEN OTHERS THEN
420: ROLLBACK TO Update_Rt_Tran_Resp;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422:
423: -- save message in fnd stack
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 482: IF NOT FND_API.Compatible_API_Call (lc_api_version,

478: -- Standard Start of API savepoint
479: SAVEPOINT Delete_Rt_Tran_Resp;
480:
481: -- Standard call to check for call compatibility.
482: IF NOT FND_API.Compatible_API_Call (lc_api_version,
483: p_api_version,
484: lc_api_name ,
485: G_PKG_NAME )
486: THEN

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: p_api_version,
484: lc_api_name ,
485: G_PKG_NAME )
486: THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 491: IF FND_API.to_Boolean( p_init_msg_list ) THEN

487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.to_Boolean( p_init_msg_list ) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 501: x_return_status := FND_API.G_RET_STS_SUCCESS;

497: 'Entered Delete_Rt_Tran_Resp');
498: END IF;
499:
500: -- Initialize API return status to success
501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502:
503: -- Api body starts
504:
505: -- Check the required parameters

Line 539: IF FND_API.To_Boolean( p_commit ) THEN

535:
536: -- Api body ends here
537:
538: -- Standard check of p_commit.
539: IF FND_API.To_Boolean( p_commit ) THEN
540: COMMIT WORK;
541: END IF;
542:
543: -- Standard call to get message count and IF count is get message info.

Line 555: WHEN FND_API.G_EXC_ERROR THEN

551: END IF;
552:
553: EXCEPTION
554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Delete_Rt_Tran_Resp;
557:
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:

Line 558: x_return_status := FND_API.G_RET_STS_ERROR;

554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Delete_Rt_Tran_Resp;
557:
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data );

Line 570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

566: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
567: 'EXC_ERROR['||x_msg_data||']');
568: END IF;
569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: ROLLBACK TO Delete_Rt_Tran_Resp;
572:
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: ROLLBACK TO Delete_Rt_Tran_Resp;
572:
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: IF FND_MSG_PUB.Check_Msg_Level
576: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN

Line 600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

596:
597: WHEN OTHERS THEN
598: ROLLBACK TO Delete_Rt_Tran_Resp;
599:
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: -- save message in fnd stack
603: IF FND_MSG_PUB.Check_Msg_Level
604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 662: IF NOT FND_API.Compatible_API_Call (lc_api_version,

658: -- Standard Start of API savepoint
659: SAVEPOINT Lock_Rt_Tran_Resp;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT FND_API.Compatible_API_Call (lc_api_version,
663: p_api_version,
664: lc_api_name ,
665: G_PKG_NAME )
666: THEN

Line 667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

663: p_api_version,
664: lc_api_name ,
665: G_PKG_NAME )
666: THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: -- Initialize message list if p_init_msg_list is set to TRUE.
671: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 671: IF FND_API.to_Boolean( p_init_msg_list ) THEN

667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: -- Initialize message list if p_init_msg_list is set to TRUE.
671: IF FND_API.to_Boolean( p_init_msg_list ) THEN
672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: 'Entered Lock_Rt_Tran_Resp');
678: END IF;
679:
680: -- Initialize API return status to success
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: -- Api body starts
684:
685: -- Check the required parameters

Line 727: IF FND_API.To_Boolean( p_commit ) THEN

723:
724: -- Api body ends here
725:
726: -- Standard check of p_commit.
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730:
731: -- Standard call to get message count and IF count is get message info.

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: END IF;
740:
741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO Lock_Rt_Tran_Resp;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: FND_MSG_PUB.Count_And_Get

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO Lock_Rt_Tran_Resp;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: FND_MSG_PUB.Count_And_Get
748: (p_count => x_msg_count,
749: p_data => x_msg_data );

Line 757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

753: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
754: 'EXC_ERROR['||x_msg_data||']');
755: END IF;
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO Lock_Rt_Tran_Resp;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760:
761: IF FND_MSG_PUB.Check_Msg_Level

Line 759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

755: END IF;
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO Lock_Rt_Tran_Resp;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760:
761: IF FND_MSG_PUB.Check_Msg_Level
762: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: END IF;
782:
783: WHEN OTHERS THEN
784: ROLLBACK TO Lock_Rt_Tran_Resp;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:
787: -- save message in fnd stack
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)