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_FLWSTS_TRAN_MILES_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_Flwsts_Tran_Mile;
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_Flwsts_Tran_Mile');
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 123: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 155: WHEN FND_API.G_EXC_ERROR THEN

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

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 270: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 279: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 345: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 377: WHEN FND_API.G_EXC_ERROR THEN

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

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 480: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 489: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 499: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 537: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: END IF;
550:
551: EXCEPTION
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Delete_Flwsts_Tran_Mile;
555:
556: x_return_status := FND_API.G_RET_STS_ERROR;
557:

Line 556: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 660: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 669: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 725: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 741: WHEN FND_API.G_EXC_ERROR THEN

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

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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