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_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_Flwsts_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_Flwsts_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 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_Resp;
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_Resp;
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_Resp;
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_Resp;
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_Resp;
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_Resp;
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_Resp;
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_Resp');
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 346: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 378: WHEN FND_API.G_EXC_ERROR THEN

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

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 481: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 490: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 500: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 538: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 554: WHEN FND_API.G_EXC_ERROR THEN

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

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 661: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 670: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 726: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 742: WHEN FND_API.G_EXC_ERROR THEN

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

Line 744: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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