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_REPAIR_MILESTONES_PVT dependencies on FND_API

Line 45: IF NOT FND_API.Compatible_API_Call (lc_api_version,

41: -- Standard Start of API savepoint
42: SAVEPOINT Create_Repair_Milestone;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call (lc_api_version,
46: p_api_version,
47: lc_api_name ,
48: G_PKG_NAME )
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: p_api_version,
47: lc_api_name ,
48: G_PKG_NAME )
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 54: IF FND_API.to_Boolean( p_init_msg_list ) THEN

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list ) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: ( p_repair_milestone_rec => p_repair_milestone_rec);
68: END IF;
69: */
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- Api body starts
74:
75: -- Check the required parameters

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name,
125: 'Others exception in CSD_REPAIR_MILESTONES_PKG.Insert_Row Call :' ||
126: SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
127: END IF;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END;
130:
131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
132: RAISE FND_API.G_EXC_ERROR;

Line 131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

127: END IF;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END;
130:
131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 132: RAISE FND_API.G_EXC_ERROR;

128: x_return_status := FND_API.G_RET_STS_ERROR;
129: END;
130:
131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
136: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

Line 143: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154: 'Leaving Create_Repair_Milestone');
155: END IF;
156:
157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO Create_Repair_Milestone;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161:
162: FND_MSG_PUB.Count_And_Get

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156:
157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO Create_Repair_Milestone;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161:
162: FND_MSG_PUB.Count_And_Get
163: (p_count => x_msg_count,
164: p_data => x_msg_data );

Line 172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

170: END IF;
171:
172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO Create_Repair_Milestone;
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175:
176: -- save message in fnd stack
177: IF FND_MSG_PUB.Check_Msg_Level
178: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: END IF;
198:
199: WHEN OTHERS THEN
200: ROLLBACK TO Create_Repair_Milestone;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202:
203: -- save message in fnd stack
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 266: IF NOT FND_API.Compatible_API_Call (lc_api_version,

262: -- Standard Start of API savepoint
263: SAVEPOINT Update_Repair_Milestone;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call (lc_api_version,
267: p_api_version,
268: lc_api_name ,
269: G_PKG_NAME )
270: THEN

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: p_api_version,
268: lc_api_name ,
269: G_PKG_NAME )
270: THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274: -- Initialize message list if p_init_msg_list is set to TRUE.
275: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 275: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 293: x_return_status := FND_API.G_RET_STS_SUCCESS;

289: END IF;
290: */
291:
292: -- Initialize API return status to success
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294:
295: -- Api body starts
296:
297: -- Check the required parameters

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name,
350: 'Others exception in CSD_REPAIR_MILESTONES_PKG.Update_Row Call :' ||
351: SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
352: END IF;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: END;
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: RAISE FND_API.G_EXC_ERROR;

Line 356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

352: END IF;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: END;
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;
359:
360: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 357: RAISE FND_API.G_EXC_ERROR;

353: x_return_status := FND_API.G_RET_STS_ERROR;
354: END;
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;
359:
360: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

Line 368: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: 'Leaving Update_Repair_Milestone');
380: END IF;
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO Update_Repair_Milestone;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: FND_MSG_PUB.Count_And_Get

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO Update_Repair_Milestone;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: FND_MSG_PUB.Count_And_Get
388: (p_count => x_msg_count,
389: p_data => x_msg_data );

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

393: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
394: 'EXC_ERROR['||x_msg_data||']');
395: END IF;
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Update_Repair_Milestone;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: IF FND_MSG_PUB.Check_Msg_Level

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: END IF;
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO Update_Repair_Milestone;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: IF FND_MSG_PUB.Check_Msg_Level
402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

421: END IF;
422:
423: WHEN OTHERS THEN
424: ROLLBACK TO Update_Repair_Milestone;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426:
427: -- save message in fnd stack
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 486: IF NOT FND_API.Compatible_API_Call (lc_api_version,

482: -- Standard Start of API savepoint
483: SAVEPOINT Delete_Repair_Milestone;
484:
485: -- Standard call to check for call compatibility.
486: IF NOT FND_API.Compatible_API_Call (lc_api_version,
487: p_api_version,
488: lc_api_name ,
489: G_PKG_NAME )
490: THEN

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: p_api_version,
488: lc_api_name ,
489: G_PKG_NAME )
490: THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: -- Initialize message list if p_init_msg_list is set to TRUE.
495: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 495: IF FND_API.to_Boolean( p_init_msg_list ) THEN

491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: -- Initialize message list if p_init_msg_list is set to TRUE.
495: IF FND_API.to_Boolean( p_init_msg_list ) THEN
496: FND_MSG_PUB.initialize;
497: END IF;
498:
499: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501: 'Entered Delete_Repair_Milestone');
502: END IF;
503:
504: -- Initialize API return status to success
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: -- Api body starts
508:
509: -- Check the required parameters

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name,
537: 'Others exception in CSD_REPAIR_MILESTONES_PKG.Delete_Row Call :' ||
538: SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
539: END IF;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END;
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: RAISE FND_API.G_EXC_ERROR;

Line 543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

539: END IF;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END;
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:
547: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 544: RAISE FND_API.G_EXC_ERROR;

540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END;
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:
547: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

Line 555: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 571: WHEN FND_API.G_EXC_ERROR THEN

567: END IF;
568:
569: EXCEPTION
570:
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Delete_Repair_Milestone;
573:
574: x_return_status := FND_API.G_RET_STS_ERROR;
575:

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570:
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Delete_Repair_Milestone;
573:
574: x_return_status := FND_API.G_RET_STS_ERROR;
575:
576: FND_MSG_PUB.Count_And_Get
577: (p_count => x_msg_count,
578: p_data => x_msg_data );

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: ROLLBACK TO Delete_Repair_Milestone;
588:
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590:
591: IF FND_MSG_PUB.Check_Msg_Level
592: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN

Line 616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

612:
613: WHEN OTHERS THEN
614: ROLLBACK TO Delete_Repair_Milestone;
615:
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617:
618: -- save message in fnd stack
619: IF FND_MSG_PUB.Check_Msg_Level
620: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 678: IF NOT FND_API.Compatible_API_Call (lc_api_version,

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

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 687: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 697: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name,
737: 'Others exception in CSD_REPAIR_MILESTONES_PKG.Lock_Row Call :' ||
738: SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
739: END IF;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END;
742:
743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;

Line 743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

739: END IF;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END;
742:
743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 744: RAISE FND_API.G_EXC_ERROR;

740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END;
742:
743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name,

Line 755: IF FND_API.To_Boolean( p_commit ) THEN

751:
752: -- Api body ends here
753:
754: -- Standard check of p_commit.
755: IF FND_API.To_Boolean( p_commit ) THEN
756: COMMIT WORK;
757: END IF;
758:
759: -- Standard call to get message count and IF count is get message info.

Line 771: WHEN FND_API.G_EXC_ERROR THEN

767: END IF;
768:
769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: ROLLBACK TO Lock_Repair_Milestone;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774:
775: FND_MSG_PUB.Count_And_Get

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: ROLLBACK TO Lock_Repair_Milestone;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774:
775: FND_MSG_PUB.Count_And_Get
776: (p_count => x_msg_count,
777: p_data => x_msg_data );

Line 785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

781: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
782: 'EXC_ERROR['||x_msg_data||']');
783: END IF;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: ROLLBACK TO Lock_Repair_Milestone;
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788:
789: IF FND_MSG_PUB.Check_Msg_Level

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

783: END IF;
784:
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: ROLLBACK TO Lock_Repair_Milestone;
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788:
789: IF FND_MSG_PUB.Check_Msg_Level
790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

809: END IF;
810:
811: WHEN OTHERS THEN
812: ROLLBACK TO Lock_Repair_Milestone;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814:
815: -- save message in fnd stack
816: IF FND_MSG_PUB.Check_Msg_Level
817: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)