eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_RT_TRANS_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;
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');
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 133: IF FND_API.To_Boolean( p_commit ) THEN

129:
130: -- Api body ends here
131:
132: -- Standard check of p_commit.
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137: -- Standard call to get message count and IF count is get message info.

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146:
147: EXCEPTION
148: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
149: ROLLBACK TO Create_Rt_Tran;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: -- The definition already exists. No duplicates are allowed.
153: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
154: FND_MSG_PUB.add;

Line 165: WHEN FND_API.G_EXC_ERROR THEN

161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
163: 'EXC_ERROR['||x_msg_data||']');
164: END IF;
165: WHEN FND_API.G_EXC_ERROR THEN
166: ROLLBACK TO Create_Rt_Tran;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: FND_MSG_PUB.Count_And_Get

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: 'EXC_ERROR['||x_msg_data||']');
164: END IF;
165: WHEN FND_API.G_EXC_ERROR THEN
166: ROLLBACK TO Create_Rt_Tran;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count,
171: p_data => x_msg_data );

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
176: 'EXC_ERROR['||x_msg_data||']');
177: END IF;
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO Create_Rt_Tran;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: -- save message in fnd stack

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: END IF;
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO Create_Rt_Tran;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: -- save message in fnd stack
184: IF FND_MSG_PUB.Check_Msg_Level
185: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: END IF;
205:
206: WHEN OTHERS THEN
207: ROLLBACK TO Create_Rt_Tran;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: -- save message in fnd stack
211: IF FND_MSG_PUB.Check_Msg_Level
212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 280: IF NOT FND_API.Compatible_API_Call (lc_api_version,

276: -- Standard Start of API savepoint
277: SAVEPOINT Update_Rt_Tran;
278:
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call (lc_api_version,
281: p_api_version,
282: lc_api_name ,
283: G_PKG_NAME )
284: THEN

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281: p_api_version,
282: lc_api_name ,
283: G_PKG_NAME )
284: THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 289: IF FND_API.to_Boolean( p_init_msg_list ) THEN

285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: 'Entered Update_Rt_Tran');
296: END IF;
297:
298: -- Initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: -- Api body starts
302:
303: -- Check the required parameters

Line 366: IF FND_API.To_Boolean( p_commit ) THEN

362:
363: -- Api body ends here
364:
365: -- Standard check of p_commit.
366: IF FND_API.To_Boolean( p_commit ) THEN
367: COMMIT WORK;
368: END IF;
369:
370: -- Standard call to get message count and IF count is get message info.

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379:
380: EXCEPTION
381: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
382: ROLLBACK TO Update_Rt_Tran;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: -- The definition already exists. No duplicates are allowed.
386: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
387: FND_MSG_PUB.add;

Line 398: WHEN FND_API.G_EXC_ERROR THEN

394: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
396: 'EXC_ERROR['||x_msg_data||']');
397: END IF;
398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO Update_Rt_Tran;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401:
402: FND_MSG_PUB.Count_And_Get

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: 'EXC_ERROR['||x_msg_data||']');
397: END IF;
398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO Update_Rt_Tran;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401:
402: FND_MSG_PUB.Count_And_Get
403: (p_count => x_msg_count,
404: p_data => x_msg_data );

Line 412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

408: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
409: 'EXC_ERROR['||x_msg_data||']');
410: END IF;
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ROLLBACK TO Update_Rt_Tran;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415:
416: IF FND_MSG_PUB.Check_Msg_Level

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

410: END IF;
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ROLLBACK TO Update_Rt_Tran;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415:
416: IF FND_MSG_PUB.Check_Msg_Level
417: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
418: THEN

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: END IF;
437:
438: WHEN OTHERS THEN
439: ROLLBACK TO Update_Rt_Tran;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441:
442: -- save message in fnd stack
443: IF FND_MSG_PUB.Check_Msg_Level
444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 501: IF NOT FND_API.Compatible_API_Call (lc_api_version,

497: -- Standard Start of API savepoint
498: SAVEPOINT Delete_Rt_Tran;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (lc_api_version,
502: p_api_version,
503: lc_api_name ,
504: G_PKG_NAME )
505: THEN

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: p_api_version,
503: lc_api_name ,
504: G_PKG_NAME )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 510: IF FND_API.to_Boolean( p_init_msg_list ) THEN

506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list ) THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: 'Entered Delete_Rt_Tran');
517: END IF;
518:
519: -- Initialize API return status to success
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: -- Api body starts
523:
524: -- Check the required parameters

Line 558: IF FND_API.To_Boolean( p_commit ) THEN

554:
555: -- Api body ends here
556:
557: -- Standard check of p_commit.
558: IF FND_API.To_Boolean( p_commit ) THEN
559: COMMIT WORK;
560: END IF;
561:
562: -- Standard call to get message count and IF count is get message info.

Line 574: WHEN FND_API.G_EXC_ERROR THEN

570: END IF;
571:
572: EXCEPTION
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: ROLLBACK TO Delete_Rt_Tran;
576:
577: x_return_status := FND_API.G_RET_STS_ERROR;
578:

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: ROLLBACK TO Delete_Rt_Tran;
576:
577: x_return_status := FND_API.G_RET_STS_ERROR;
578:
579: FND_MSG_PUB.Count_And_Get
580: (p_count => x_msg_count,
581: p_data => x_msg_data );

Line 589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

585: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
586: 'EXC_ERROR['||x_msg_data||']');
587: END IF;
588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO Delete_Rt_Tran;
591:
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593:

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO Delete_Rt_Tran;
591:
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593:
594: IF FND_MSG_PUB.Check_Msg_Level
595: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615:
616: WHEN OTHERS THEN
617: ROLLBACK TO Delete_Rt_Tran;
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620:
621: -- save message in fnd stack
622: IF FND_MSG_PUB.Check_Msg_Level
623: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 681: IF NOT FND_API.Compatible_API_Call (lc_api_version,

677: -- Standard Start of API savepoint
678: SAVEPOINT Lock_Rt_Tran;
679:
680: -- Standard call to check for call compatibility.
681: IF NOT FND_API.Compatible_API_Call (lc_api_version,
682: p_api_version,
683: lc_api_name ,
684: G_PKG_NAME )
685: THEN

Line 686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

682: p_api_version,
683: lc_api_name ,
684: G_PKG_NAME )
685: THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END IF;
688:
689: -- Initialize message list if p_init_msg_list is set to TRUE.
690: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 690: IF FND_API.to_Boolean( p_init_msg_list ) THEN

686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END IF;
688:
689: -- Initialize message list if p_init_msg_list is set to TRUE.
690: IF FND_API.to_Boolean( p_init_msg_list ) THEN
691: FND_MSG_PUB.initialize;
692: END IF;
693:
694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 700: x_return_status := FND_API.G_RET_STS_SUCCESS;

696: 'Entered Lock_Rt_Tran');
697: END IF;
698:
699: -- Initialize API return status to success
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
701:
702: -- Api body starts
703:
704: -- Check the required parameters

Line 746: IF FND_API.To_Boolean( p_commit ) THEN

742:
743: -- Api body ends here
744:
745: -- Standard check of p_commit.
746: IF FND_API.To_Boolean( p_commit ) THEN
747: COMMIT WORK;
748: END IF;
749:
750: -- Standard call to get message count and IF count is get message info.

Line 762: WHEN FND_API.G_EXC_ERROR THEN

758: END IF;
759:
760: EXCEPTION
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO Lock_Rt_Tran;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
766: FND_MSG_PUB.Count_And_Get

Line 764: x_return_status := FND_API.G_RET_STS_ERROR;

760: EXCEPTION
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO Lock_Rt_Tran;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
766: FND_MSG_PUB.Count_And_Get
767: (p_count => x_msg_count,
768: p_data => x_msg_data );

Line 776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

772: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
773: 'EXC_ERROR['||x_msg_data||']');
774: END IF;
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO Lock_Rt_Tran;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779:
780: IF FND_MSG_PUB.Check_Msg_Level

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: END IF;
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: ROLLBACK TO Lock_Rt_Tran;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779:
780: IF FND_MSG_PUB.Check_Msg_Level
781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
782: THEN

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: END IF;
801:
802: WHEN OTHERS THEN
803: ROLLBACK TO Lock_Rt_Tran;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:
806: -- save message in fnd stack
807: IF FND_MSG_PUB.Check_Msg_Level
808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)