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_FLOW_STATUSES_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_Flow_Status;
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_Flow_Status');
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 141: IF FND_API.To_Boolean( p_commit ) THEN

137:
138: -- Api body ends here
139:
140: -- Standard check of p_commit.
141: IF FND_API.To_Boolean( p_commit ) THEN
142: COMMIT WORK;
143: END IF;
144:
145: -- Standard call to get message count and IF count is get message info.

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154:
155: EXCEPTION
156: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
157: ROLLBACK TO Create_Flow_Status;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159:
160: -- The definition already exists. No duplicates are allowed.
161: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
162: FND_MSG_PUB.add;

Line 174: WHEN FND_API.G_EXC_ERROR THEN

170: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
171: 'EXC_ERROR['||x_msg_data||']');
172: END IF;
173:
174: WHEN FND_API.G_EXC_ERROR THEN
175: ROLLBACK TO Create_Flow_Status;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177:
178: FND_MSG_PUB.Count_And_Get

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: END IF;
173:
174: WHEN FND_API.G_EXC_ERROR THEN
175: ROLLBACK TO Create_Flow_Status;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177:
178: FND_MSG_PUB.Count_And_Get
179: (p_count => x_msg_count,
180: p_data => x_msg_data );

Line 188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

184: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
185: 'EXC_ERROR['||x_msg_data||']');
186: END IF;
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO Create_Flow_Status;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191:
192: -- save message in fnd stack

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: END IF;
187:
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: ROLLBACK TO Create_Flow_Status;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191:
192: -- save message in fnd stack
193: IF FND_MSG_PUB.Check_Msg_Level
194: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213: END IF;
214:
215: WHEN OTHERS THEN
216: ROLLBACK TO Create_Flow_Status;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218:
219: -- save message in fnd stack
220: IF FND_MSG_PUB.Check_Msg_Level
221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 289: IF NOT FND_API.Compatible_API_Call (lc_api_version,

285: -- Standard Start of API savepoint
286: SAVEPOINT Update_Flow_Status;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (lc_api_version,
290: p_api_version,
291: lc_api_name ,
292: G_PKG_NAME )
293: THEN

Line 294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

290: p_api_version,
291: lc_api_name ,
292: G_PKG_NAME )
293: THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 298: IF FND_API.to_Boolean( p_init_msg_list ) THEN

294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304: 'Entered Update_Flow_Status');
305: END IF;
306:
307: -- Initialize API return status to success
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: -- Api body starts
311:
312: -- Check the required parameters

Line 385: IF FND_API.To_Boolean( p_commit ) THEN

381:
382: -- Api body ends here
383:
384: -- Standard check of p_commit.
385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388:
389: -- Standard call to get message count and IF count is get message info.

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398:
399: EXCEPTION
400: WHEN UNIQUE_CONSTRAINT_VIOLATED THEN
401: ROLLBACK TO Update_Flow_Status;
402: x_return_status := FND_API.G_RET_STS_ERROR;
403:
404: -- The definition already exists. No duplicates are allowed.
405: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
406: FND_MSG_PUB.add;

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
415: 'EXC_ERROR['||x_msg_data||']');
416: END IF;
417: WHEN FND_API.G_EXC_ERROR THEN
418: ROLLBACK TO Update_Flow_Status;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: FND_MSG_PUB.Count_And_Get

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: 'EXC_ERROR['||x_msg_data||']');
416: END IF;
417: WHEN FND_API.G_EXC_ERROR THEN
418: ROLLBACK TO Update_Flow_Status;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: FND_MSG_PUB.Count_And_Get
422: (p_count => x_msg_count,
423: p_data => x_msg_data );

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
428: 'EXC_ERROR['||x_msg_data||']');
429: END IF;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO Update_Flow_Status;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: IF FND_MSG_PUB.Check_Msg_Level

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: END IF;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO Update_Flow_Status;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: IF FND_MSG_PUB.Check_Msg_Level
436: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN

Line 459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

455: END IF;
456:
457: WHEN OTHERS THEN
458: ROLLBACK TO Update_Flow_Status;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460:
461: -- save message in fnd stack
462: IF FND_MSG_PUB.Check_Msg_Level
463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 520: IF NOT FND_API.Compatible_API_Call (lc_api_version,

516: -- Standard Start of API savepoint
517: SAVEPOINT Delete_Flow_Status;
518:
519: -- Standard call to check for call compatibility.
520: IF NOT FND_API.Compatible_API_Call (lc_api_version,
521: p_api_version,
522: lc_api_name ,
523: G_PKG_NAME )
524: THEN

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521: p_api_version,
522: lc_api_name ,
523: G_PKG_NAME )
524: THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 529: IF FND_API.to_Boolean( p_init_msg_list ) THEN

525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list ) THEN
530: FND_MSG_PUB.initialize;
531: END IF;
532:
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: 'Entered Delete_Flow_Status');
536: END IF;
537:
538: -- Initialize API return status to success
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: -- Api body starts
542:
543: -- Check the required parameters

Line 577: IF FND_API.To_Boolean( p_commit ) THEN

573:
574: -- Api body ends here
575:
576: -- Standard check of p_commit.
577: IF FND_API.To_Boolean( p_commit ) THEN
578: COMMIT WORK;
579: END IF;
580:
581: -- Standard call to get message count and IF count is get message info.

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589: END IF;
590:
591: EXCEPTION
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO Delete_Flow_Status;
595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597:

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO Delete_Flow_Status;
595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597:
598: FND_MSG_PUB.Count_And_Get
599: (p_count => x_msg_count,
600: p_data => x_msg_data );

Line 608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

604: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
605: 'EXC_ERROR['||x_msg_data||']');
606: END IF;
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO Delete_Flow_Status;
610:
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612:

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO Delete_Flow_Status;
610:
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612:
613: IF FND_MSG_PUB.Check_Msg_Level
614: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634:
635: WHEN OTHERS THEN
636: ROLLBACK TO Delete_Flow_Status;
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639:
640: -- save message in fnd stack
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 700: IF NOT FND_API.Compatible_API_Call (lc_api_version,

696: -- Standard Start of API savepoint
697: SAVEPOINT Lock_Flow_Status;
698:
699: -- Standard call to check for call compatibility.
700: IF NOT FND_API.Compatible_API_Call (lc_api_version,
701: p_api_version,
702: lc_api_name ,
703: G_PKG_NAME )
704: THEN

Line 705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

701: p_api_version,
702: lc_api_name ,
703: G_PKG_NAME )
704: THEN
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END IF;
707:
708: -- Initialize message list if p_init_msg_list is set to TRUE.
709: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 709: IF FND_API.to_Boolean( p_init_msg_list ) THEN

705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END IF;
707:
708: -- Initialize message list if p_init_msg_list is set to TRUE.
709: IF FND_API.to_Boolean( p_init_msg_list ) THEN
710: FND_MSG_PUB.initialize;
711: END IF;
712:
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: 'Entered Lock_Flow_Status');
716: END IF;
717:
718: -- Initialize API return status to success
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: -- Api body starts
722:
723: -- Check the required parameters

Line 766: IF FND_API.To_Boolean( p_commit ) THEN

762:
763: -- Api body ends here
764:
765: -- Standard check of p_commit.
766: IF FND_API.To_Boolean( p_commit ) THEN
767: COMMIT WORK;
768: END IF;
769:
770: -- Standard call to get message count and IF count is get message info.

Line 782: WHEN FND_API.G_EXC_ERROR THEN

778: END IF;
779:
780: EXCEPTION
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO Lock_Flow_Status;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785:
786: FND_MSG_PUB.Count_And_Get

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780: EXCEPTION
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO Lock_Flow_Status;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785:
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data );

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

792: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
793: 'EXC_ERROR['||x_msg_data||']');
794: END IF;
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: ROLLBACK TO Lock_Flow_Status;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799:
800: IF FND_MSG_PUB.Check_Msg_Level

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: END IF;
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: ROLLBACK TO Lock_Flow_Status;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799:
800: IF FND_MSG_PUB.Check_Msg_Level
801: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
802: THEN

Line 824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

820: END IF;
821:
822: WHEN OTHERS THEN
823: ROLLBACK TO Lock_Flow_Status;
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825:
826: -- save message in fnd stack
827: IF FND_MSG_PUB.Check_Msg_Level
828: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)