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

Line 54: IF NOT FND_API.Compatible_API_Call (lc_api_version,

50: -- Standard Start of API savepoint
51: SAVEPOINT Create_Diagnostic_Code;
52:
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call (lc_api_version,
55: p_api_version,
56: lc_api_name ,
57: G_PKG_NAME )
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version,
56: lc_api_name ,
57: G_PKG_NAME )
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 63: IF FND_API.to_Boolean( p_init_msg_list ) THEN

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: IF (lc_proc_level >= lc_debug_level) THEN

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: ( p_diagnostic_code_rec => p_diagnostic_code_rec);
76: END IF;
77:
78: -- Initialize API return status to success
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: -- Api body starts
82:
83: -- Check the required parameters

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: WHEN OTHERS THEN
176: IF ( lc_excep_level >= lc_debug_level) THEN
177: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
178: END IF;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: END;
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: RAISE FND_API.G_EXC_ERROR;

Line 182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

178: END IF;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: END;
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: if (lc_proc_level >= lc_debug_level) then

Line 183: RAISE FND_API.G_EXC_ERROR;

179: x_return_status := FND_API.G_RET_STS_ERROR;
180: END;
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: if (lc_proc_level >= lc_debug_level) then
187: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 194: IF FND_API.To_Boolean( p_commit ) THEN

190:
191: -- Api body ends here
192:
193: -- Standard check of p_commit.
194: IF FND_API.To_Boolean( p_commit ) THEN
195: COMMIT WORK;
196: END IF;
197:
198: -- Standard call to get message count and IF count is get message info.

Line 212: x_return_status := FND_API.G_RET_STS_ERROR ;

208: EXCEPTION
209: WHEN CSD_DC_CODE_EXISTS THEN
210: ROLLBACK TO Create_Diagnostic_Code;
211: -- Diagnostic code already exists
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213:
214: -- save message in fnd stack
215: if (lc_stat_level >= lc_debug_level) then
216: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 232: WHEN FND_API.G_EXC_ERROR THEN

228: FND_LOG.STRING(lc_excep_level, lc_mod_name,
229: 'Diagnostic code already exists');
230: END IF;
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO Create_Diagnostic_Code;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235:
236: FND_MSG_PUB.Count_And_Get

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: END IF;
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO Create_Diagnostic_Code;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235:
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data );

Line 246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: FND_LOG.STRING(lc_excep_level, lc_mod_name,
243: 'EXC_ERROR['||x_msg_data||']');
244: END IF;
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: ROLLBACK TO Create_Diagnostic_Code;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249:
250: -- save message in fnd stack

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244: END IF;
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: ROLLBACK TO Create_Diagnostic_Code;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249:
250: -- save message in fnd stack
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: END IF;
272:
273: WHEN OTHERS THEN
274: ROLLBACK TO Create_Diagnostic_Code;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: -- save message in fnd stack
278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 356: IF NOT FND_API.Compatible_API_Call (lc_api_version,

352: -- Standard Start of API savepoint
353: SAVEPOINT Update_Diagnostic_Code;
354:
355: -- Standard call to check for call compatibility.
356: IF NOT FND_API.Compatible_API_Call (lc_api_version,
357: p_api_version,
358: lc_api_name ,
359: G_PKG_NAME )
360: THEN

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

357: p_api_version,
358: lc_api_name ,
359: G_PKG_NAME )
360: THEN
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: -- Initialize message list if p_init_msg_list is set to TRUE.
365: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 365: IF FND_API.to_Boolean( p_init_msg_list ) THEN

361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: -- Initialize message list if p_init_msg_list is set to TRUE.
365: IF FND_API.to_Boolean( p_init_msg_list ) THEN
366: FND_MSG_PUB.initialize;
367: END IF;
368:
369: IF (lc_proc_level >= lc_debug_level) THEN

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: ( p_diagnostic_code_rec => p_diagnostic_code_rec);
378: END IF;
379:
380: -- Initialize API return status to success
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: -- Api body starts
384:
385: -- Check the required parameters

Line 403: IF (p_diagnostic_code_rec.diagnostic_code = FND_API.G_MISS_CHAR) THEN

399: FND_LOG.STRING(lc_proc_level, lc_mod_name,
400: 'Checking if required parameters are passed in as G_MISS');
401: end if;
402:
403: IF (p_diagnostic_code_rec.diagnostic_code = FND_API.G_MISS_CHAR) THEN
404: RAISE CSD_DC_CODE_MISSING;
405: END IF;
406:
407: -- Check if required parameter is passed in as G_MISS

Line 408: IF (p_diagnostic_code_rec.name = FND_API.G_MISS_CHAR) THEN

404: RAISE CSD_DC_CODE_MISSING;
405: END IF;
406:
407: -- Check if required parameter is passed in as G_MISS
408: IF (p_diagnostic_code_rec.name = FND_API.G_MISS_CHAR) THEN
409: RAISE CSD_DC_NAME_MISSING;
410: END IF;
411:
412: -- Validate the id for diagnostic code

Line 472: IF NVL(p_diagnostic_code_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN

468: end if;
469: END IF;
470:
471: -- Validate if object version number for diagnostic code is same as the one passed in
472: IF NVL(p_diagnostic_code_rec.object_version_number,FND_API.G_MISS_NUM) <> l_obj_ver_num THEN
473: RAISE CSD_DC_OVN_MISMATCH;
474: END IF;
475:
476: -- Validate the code for diagnostic code

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: WHEN OTHERS THEN
556: IF ( lc_excep_level >= lc_debug_level) THEN
557: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
558: END IF;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END;
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;

Line 562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: END IF;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END;
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: if (lc_proc_level >= lc_debug_level) then

Line 563: RAISE FND_API.G_EXC_ERROR;

559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END;
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: if (lc_proc_level >= lc_debug_level) then
567: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 574: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 593: x_return_status := FND_API.G_RET_STS_ERROR ;

589:
590: WHEN CSD_DC_CODE_MISSING THEN
591: ROLLBACK TO Update_Diagnostic_Code;
592: -- Diagnostic code already exists
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594:
595: -- save message in fnd stack
596: if (lc_stat_level >= lc_debug_level) then
597: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 617: x_return_status := FND_API.G_RET_STS_ERROR ;

613:
614: WHEN CSD_DC_NAME_MISSING THEN
615: ROLLBACK TO Update_Diagnostic_Code;
616: -- Diagnostic code name already exists
617: x_return_status := FND_API.G_RET_STS_ERROR ;
618:
619: -- save message in fnd stack
620: if (lc_stat_level >= lc_debug_level) then
621: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 641: x_return_status := FND_API.G_RET_STS_ERROR ;

637:
638: WHEN CSD_DC_ID_INVALID THEN
639: ROLLBACK TO Update_Diagnostic_Code;
640: -- Diagnostic code name already exists
641: x_return_status := FND_API.G_RET_STS_ERROR ;
642:
643: -- save message in fnd stack
644: if (lc_stat_level >= lc_debug_level) then
645: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 664: x_return_status := FND_API.G_RET_STS_ERROR ;

660:
661: WHEN CSD_DC_GET_OVN_ERROR THEN
662: ROLLBACK TO Update_Diagnostic_Code;
663: -- Diagnostic code name already exists
664: x_return_status := FND_API.G_RET_STS_ERROR ;
665:
666: -- save message in fnd stack
667: if (lc_stat_level >= lc_debug_level) then
668: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 687: x_return_status := FND_API.G_RET_STS_ERROR ;

683:
684: WHEN CSD_DC_OVN_MISMATCH THEN
685: ROLLBACK TO Update_Diagnostic_Code;
686: -- Diagnostic code name already exists
687: x_return_status := FND_API.G_RET_STS_ERROR ;
688:
689: -- save message in fnd stack
690: if (lc_stat_level >= lc_debug_level) then
691: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 710: x_return_status := FND_API.G_RET_STS_ERROR ;

706:
707: WHEN CSD_DC_CODE_EXISTS THEN
708: ROLLBACK TO Update_Diagnostic_Code;
709: -- Diagnostic code already exists
710: x_return_status := FND_API.G_RET_STS_ERROR ;
711:
712: -- save message in fnd stack
713: if (lc_stat_level >= lc_debug_level) then
714: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: FND_LOG.STRING(lc_excep_level, lc_mod_name,
727: 'Diagnostic code already exists');
728: END IF;
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO Update_Diagnostic_Code;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733:
734: FND_MSG_PUB.Count_And_Get

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: END IF;
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO Update_Diagnostic_Code;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733:
734: FND_MSG_PUB.Count_And_Get
735: (p_count => x_msg_count,
736: p_data => x_msg_data );

Line 744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

740: FND_LOG.STRING(lc_excep_level, lc_mod_name,
741: 'EXC_ERROR['||x_msg_data||']');
742: END IF;
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: ROLLBACK TO Update_Diagnostic_Code;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747:
748: IF FND_MSG_PUB.Check_Msg_Level

Line 746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

742: END IF;
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: ROLLBACK TO Update_Diagnostic_Code;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747:
748: IF FND_MSG_PUB.Check_Msg_Level
749: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: END IF;
769:
770: WHEN OTHERS THEN
771: ROLLBACK TO Update_Diagnostic_Code;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: -- save message in fnd stack
775: IF FND_MSG_PUB.Check_Msg_Level
776: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 841: IF NOT FND_API.Compatible_API_Call (lc_api_version,

837: -- Standard Start of API savepoint
838: SAVEPOINT Lock_Diagnostic_Code;
839:
840: -- Standard call to check for call compatibility.
841: IF NOT FND_API.Compatible_API_Call (lc_api_version,
842: p_api_version,
843: lc_api_name ,
844: G_PKG_NAME )
845: THEN

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: p_api_version,
843: lc_api_name ,
844: G_PKG_NAME )
845: THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 850: IF FND_API.to_Boolean( p_init_msg_list ) THEN

846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.to_Boolean( p_init_msg_list ) THEN
851: FND_MSG_PUB.initialize;
852: END IF;
853:
854: IF (lc_proc_level >= lc_debug_level) THEN

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: 'Entered Lock_Diagnostic_Code');
857: END IF;
858:
859: -- Initialize API return status to success
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: -- Api body starts
863:
864: -- Check the required parameters

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924: WHEN OTHERS THEN
925: IF ( lc_excep_level >= lc_debug_level) THEN
926: FND_LOG.STRING(lc_excep_level,lc_mod_name,'Others exception in CSD_DIAGNOSTIC_CODES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
927: END IF;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: END;
930:
931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
932: RAISE FND_API.G_EXC_ERROR;

Line 931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

927: END IF;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: END;
930:
931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: if (lc_proc_level >= lc_debug_level) then

Line 932: RAISE FND_API.G_EXC_ERROR;

928: x_return_status := FND_API.G_RET_STS_ERROR;
929: END;
930:
931: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: if (lc_proc_level >= lc_debug_level) then
936: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 943: IF FND_API.To_Boolean( p_commit ) THEN

939:
940: -- Api body ends here
941:
942: -- Standard check of p_commit.
943: IF FND_API.To_Boolean( p_commit ) THEN
944: COMMIT WORK;
945: END IF;
946:
947: -- Standard call to get message count and IF count is get message info.

Line 959: WHEN FND_API.G_EXC_ERROR THEN

955: END IF;
956:
957: EXCEPTION
958:
959: WHEN FND_API.G_EXC_ERROR THEN
960: ROLLBACK TO Lock_Diagnostic_Code;
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get

Line 961: x_return_status := FND_API.G_RET_STS_ERROR;

957: EXCEPTION
958:
959: WHEN FND_API.G_EXC_ERROR THEN
960: ROLLBACK TO Lock_Diagnostic_Code;
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get
964: (p_count => x_msg_count,
965: p_data => x_msg_data );

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: FND_LOG.STRING(lc_excep_level, lc_mod_name,
970: 'EXC_ERROR['||x_msg_data||']');
971: END IF;
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO Lock_Diagnostic_Code;
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976:
977: IF FND_MSG_PUB.Check_Msg_Level

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

971: END IF;
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO Lock_Diagnostic_Code;
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976:
977: IF FND_MSG_PUB.Check_Msg_Level
978: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
979: THEN

Line 1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

997: END IF;
998:
999: WHEN OTHERS THEN
1000: ROLLBACK TO Lock_Diagnostic_Code;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002:
1003: -- save message in fnd stack
1004: IF FND_MSG_PUB.Check_Msg_Level
1005: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)