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_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_Flwsts_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_Flwsts_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 134: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 166: WHEN FND_API.G_EXC_ERROR THEN

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

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 281: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 290: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 369: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 401: WHEN FND_API.G_EXC_ERROR THEN

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

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: END IF;
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Flwsts_Tran;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419: IF FND_MSG_PUB.Check_Msg_Level
420: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: END IF;
440:
441: WHEN OTHERS THEN
442: ROLLBACK TO Update_Flwsts_Tran;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444:
445: -- save message in fnd stack
446: IF FND_MSG_PUB.Check_Msg_Level
447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 504: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 513: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 523: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 561: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 577: WHEN FND_API.G_EXC_ERROR THEN

573: END IF;
574:
575: EXCEPTION
576:
577: WHEN FND_API.G_EXC_ERROR THEN
578: ROLLBACK TO Delete_Flwsts_Tran;
579:
580: x_return_status := FND_API.G_RET_STS_ERROR;
581:

Line 580: x_return_status := FND_API.G_RET_STS_ERROR;

576:
577: WHEN FND_API.G_EXC_ERROR THEN
578: ROLLBACK TO Delete_Flwsts_Tran;
579:
580: x_return_status := FND_API.G_RET_STS_ERROR;
581:
582: FND_MSG_PUB.Count_And_Get
583: (p_count => x_msg_count,
584: p_data => x_msg_data );

Line 592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591:
592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ROLLBACK TO Delete_Flwsts_Tran;
594:
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596:
597: IF FND_MSG_PUB.Check_Msg_Level
598: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618:
619: WHEN OTHERS THEN
620: ROLLBACK TO Delete_Flwsts_Tran;
621:
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623:
624: -- save message in fnd stack
625: IF FND_MSG_PUB.Check_Msg_Level
626: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 684: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 749: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 765: WHEN FND_API.G_EXC_ERROR THEN

761: END IF;
762:
763: EXCEPTION
764:
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO Lock_Flwsts_Tran;
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: FND_MSG_PUB.Count_And_Get

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: EXCEPTION
764:
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO Lock_Flwsts_Tran;
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: FND_MSG_PUB.Count_And_Get
770: (p_count => x_msg_count,
771: p_data => x_msg_data );

Line 779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: END IF;
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO Lock_Flwsts_Tran;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: IF FND_MSG_PUB.Check_Msg_Level
784: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN

Line 807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

803: END IF;
804:
805: WHEN OTHERS THEN
806: ROLLBACK TO Lock_Flwsts_Tran;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808:
809: -- save message in fnd stack
810: IF FND_MSG_PUB.Check_Msg_Level
811: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)