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

Line 72: IF NOT FND_API.Compatible_API_Call ( l_api_version,

68: -- Standard Start of API savepoint
69: SAVEPOINT CREATE_REPAIR_ACTUALS;
70:
71: -- Standard call to check for call compatibility.
72: IF NOT FND_API.Compatible_API_Call ( l_api_version,
73: p_api_version,
74: l_api_name,
75: G_PKG_NAME)
76: THEN

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: p_api_version,
74: l_api_name,
75: G_PKG_NAME)
76: THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 81: IF FND_API.to_Boolean( p_init_msg_list ) THEN

77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE.
81: IF FND_API.to_Boolean( p_init_msg_list ) THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: -- Api body starts
89: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
90: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of create_repair_actuals');

Line 119: RAISE FND_API.G_EXC_ERROR;

115:
116: -- Validate the repair line ID
117: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
118: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
123: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 152: RAISE FND_API.G_EXC_ERROR;

148: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
149: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
150: END IF;
151:
152: RAISE FND_API.G_EXC_ERROR;
153: End IF;
154:
155: -- Assigning object version number
156: px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER := 1;

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199: WHEN OTHERS THEN
200: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
201: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception n CSD_REPAIR_ACTUALS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
202: END IF;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END;
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;

Line 206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

202: END IF;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END;
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: --

Line 207: RAISE FND_API.G_EXC_ERROR;

203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END;
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: --
211: -- End of API body

Line 215: IF FND_API.To_Boolean( p_commit ) THEN

211: -- End of API body
212: --
213:
214: -- Standard check of p_commit.
215: IF FND_API.To_Boolean( p_commit ) THEN
216: COMMIT WORK;
217: END IF;
218:
219: -- Standard call to get message count and IF count is get message info.

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220: FND_MSG_PUB.Count_And_Get
221: (p_count => x_msg_count,
222: p_data => x_msg_data );
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
226: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
227: END IF;
228: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 226: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');

222: p_data => x_msg_data );
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
226: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
227: END IF;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229: ROLLBACK TO CREATE_REPAIR_ACTUALS;
230: FND_MSG_PUB.Count_And_Get

Line 228: x_return_status := FND_API.G_RET_STS_ERROR ;

224: WHEN FND_API.G_EXC_ERROR THEN
225: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
226: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
227: END IF;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229: ROLLBACK TO CREATE_REPAIR_ACTUALS;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count,
232: p_data => x_msg_data );

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: ROLLBACK TO CREATE_REPAIR_ACTUALS;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count,
232: p_data => x_msg_data );
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
235: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
236: END IF;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 235: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');

231: (p_count => x_msg_count,
232: p_data => x_msg_data );
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
235: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
236: END IF;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: ROLLBACK TO CREATE_REPAIR_ACTUALS;
239: FND_MSG_PUB.Count_And_Get

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
235: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
236: END IF;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: ROLLBACK TO CREATE_REPAIR_ACTUALS;
239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data );

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
244: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
245: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
246: END IF;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: ROLLBACK TO CREATE_REPAIR_ACTUALS;
249: IF FND_MSG_PUB.Check_Msg_Level
250: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
251: THEN

Line 331: IF NOT FND_API.Compatible_API_Call ( l_api_version,

327: -- Standard Start of API savepoint
328: SAVEPOINT UPDATE_REPAIR_ACTUALS;
329:
330: -- Standard call to check for call compatibility.
331: IF NOT FND_API.Compatible_API_Call ( l_api_version,
332: p_api_version,
333: l_api_name,
334: G_PKG_NAME)
335: THEN

Line 336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

332: p_api_version,
333: l_api_name,
334: G_PKG_NAME)
335: THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 340: IF FND_API.to_Boolean( p_init_msg_list ) THEN

336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Api body starts
348: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
349: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of update_repair_actual_lines');

Line 370: RAISE FND_API.G_EXC_ERROR;

366:
367: -- Validate the repair line ID
368: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
369: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
374: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 377: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

373: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
374: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
375: END IF;
376:
377: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
378:
379: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
380: FETCH repair_actual
381: INTO l_actual_id,

Line 391: RAISE FND_API.G_EXC_ERROR;

387: FND_MSG_PUB.ADD;
388: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
389: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
390: END IF;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: IF repair_actual%ISOPEN THEN
395: CLOSE repair_actual;

Line 404: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

400: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
401: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number');
402: END IF;
403:
404: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
405:
406: -- Modified the message name for bugfix 3281321. vkjain.
407: -- FND_MESSAGE.SET_NAME('CSD','CSD_OBJ_VER_MISMATCH');
408: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_OBJ_VER_MISMATCH');

Line 414: RAISE FND_API.G_EXC_ERROR;

410: FND_MSG_PUB.ADD;
411: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
412: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
413: END IF;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417:
418: -- Assigning object version number

Line 435: ,p_CREATED_BY => FND_API.G_MISS_NUM

431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM
436: ,p_CREATION_DATE => FND_API.G_MISS_DATE
437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
438: ,p_LAST_UPDATE_DATE => SYSDATE
439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 436: ,p_CREATION_DATE => FND_API.G_MISS_DATE

432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM
436: ,p_CREATION_DATE => FND_API.G_MISS_DATE
437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
438: ,p_LAST_UPDATE_DATE => SYSDATE
439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: WHEN OTHERS THEN
466: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
467: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
468: END IF;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END;
471:
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: RAISE FND_API.G_EXC_ERROR;

Line 472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

468: END IF;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END;
471:
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: --

Line 473: RAISE FND_API.G_EXC_ERROR;

469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END;
471:
472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: --
477: -- End of API body

Line 481: IF FND_API.To_Boolean( p_commit ) THEN

477: -- End of API body
478: --
479:
480: -- Standard check of p_commit.
481: IF FND_API.To_Boolean( p_commit ) THEN
482: COMMIT WORK;
483: END IF;
484:
485: -- Standard call to get message count and IF count is get message info.

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: FND_MSG_PUB.Count_And_Get
487: (p_count => x_msg_count,
488: p_data => x_msg_data );
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
492: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
493: END IF;
494: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 492: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');

488: p_data => x_msg_data );
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
492: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
493: END IF;
494: x_return_status := FND_API.G_RET_STS_ERROR ;
495: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
496: FND_MSG_PUB.Count_And_Get

Line 494: x_return_status := FND_API.G_RET_STS_ERROR ;

490: WHEN FND_API.G_EXC_ERROR THEN
491: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
492: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
493: END IF;
494: x_return_status := FND_API.G_RET_STS_ERROR ;
495: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count,
498: p_data => x_msg_data );

Line 499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

495: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count,
498: p_data => x_msg_data );
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
501: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
502: END IF;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 501: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');

497: (p_count => x_msg_count,
498: p_data => x_msg_data );
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
501: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
502: END IF;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
505: FND_MSG_PUB.Count_And_Get

Line 503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
501: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
502: END IF;
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
505: FND_MSG_PUB.Count_And_Get
506: ( p_count => x_msg_count,
507: p_data => x_msg_data );

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

509: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
510: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
511: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
512: END IF;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: ROLLBACK TO UPDATE_REPAIR_ACTUALS;
515: IF FND_MSG_PUB.Check_Msg_Level
516: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN

Line 596: IF NOT FND_API.Compatible_API_Call ( l_api_version,

592: -- Standard Start of API savepoint
593: SAVEPOINT DELETE_REPAIR_ACTUALS;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version,
597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)
600: THEN

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)
600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list if p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 605: IF FND_API.to_Boolean( p_init_msg_list ) THEN

601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list if p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list ) THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success

Line 610: x_return_status := FND_API.G_RET_STS_SUCCESS;

606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612: -- Api body starts
613: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
614: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of delete_repair_actual_lines');

Line 644: RAISE FND_API.G_EXC_ERROR;

640:
641: -- Validate the repair line ID
642: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
643: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646:
647: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
648: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 651: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

647: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
648: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
649: END IF;
650:
651: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
652:
653: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
654: FETCH repair_actual
655: INTO l_actual_id,

Line 665: RAISE FND_API.G_EXC_ERROR;

661: FND_MSG_PUB.ADD;
662: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
663: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668: IF repair_actual%ISOPEN THEN
669: CLOSE repair_actual;

Line 678: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

674: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
675: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number');
676: END IF;
677:
678: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
679: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
680: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Object Version Number does not match'
681: || ' for the Repair Actual ID = ' || l_actual_id);
682: END IF;

Line 692: RAISE FND_API.G_EXC_ERROR;

688: FND_MSG_PUB.ADD;
689: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
690: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
691: END IF;
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694:
695:
696: BEGIN

Line 719: RAISE FND_API.G_EXC_ERROR;

715: FND_MSG_PUB.ADD;
716: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
717: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
718: END IF;
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722:
723: --

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738: WHEN OTHERS THEN
739: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
740: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception error :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
741: END IF;
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: END;
744:
745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
746: RAISE FND_API.G_EXC_ERROR;

Line 745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

741: END IF;
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: END;
744:
745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748:
749: --

Line 746: RAISE FND_API.G_EXC_ERROR;

742: x_return_status := FND_API.G_RET_STS_ERROR;
743: END;
744:
745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748:
749: --
750: -- End of API body

Line 754: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 763: WHEN FND_API.G_EXC_ERROR THEN

759: FND_MSG_PUB.Count_And_Get
760: (p_count => x_msg_count,
761: p_data => x_msg_data );
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
765: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
766: END IF;
767: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 765: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');

761: p_data => x_msg_data );
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
765: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
766: END IF;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: ROLLBACK TO DELETE_REPAIR_ACTUALS;
769: FND_MSG_PUB.Count_And_Get

Line 767: x_return_status := FND_API.G_RET_STS_ERROR ;

763: WHEN FND_API.G_EXC_ERROR THEN
764: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
765: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
766: END IF;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: ROLLBACK TO DELETE_REPAIR_ACTUALS;
769: FND_MSG_PUB.Count_And_Get
770: (p_count => x_msg_count,
771: p_data => x_msg_data );

Line 772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

768: ROLLBACK TO DELETE_REPAIR_ACTUALS;
769: FND_MSG_PUB.Count_And_Get
770: (p_count => x_msg_count,
771: p_data => x_msg_data );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
774: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
775: END IF;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 774: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');

770: (p_count => x_msg_count,
771: p_data => x_msg_data );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
774: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
775: END IF;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: ROLLBACK TO DELETE_REPAIR_ACTUALS;
778: FND_MSG_PUB.Count_And_Get

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
774: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
775: END IF;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: ROLLBACK TO DELETE_REPAIR_ACTUALS;
778: FND_MSG_PUB.Count_And_Get
779: ( p_count => x_msg_count,
780: p_data => x_msg_data );

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

782: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
783: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
784: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
785: END IF;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: ROLLBACK TO DELETE_REPAIR_ACTUALS;
788: IF FND_MSG_PUB.Check_Msg_Level
789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN

Line 854: IF NOT FND_API.Compatible_API_Call ( l_api_version,

850: -- Standard Start of API savepoint
851: SAVEPOINT LOCK_REPAIR_ACTUALS;
852:
853: -- Standard call to check for call compatibility.
854: IF NOT FND_API.Compatible_API_Call ( l_api_version,
855: p_api_version,
856: l_api_name,
857: G_PKG_NAME)
858: THEN

Line 859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

855: p_api_version,
856: l_api_name,
857: G_PKG_NAME)
858: THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 863: IF FND_API.to_Boolean( p_init_msg_list ) THEN

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: -- Initialize API return status to success

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: -- Initialize API return status to success
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: -- Api body starts
871: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
872: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of lock_repair_actual_lines');

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: WHEN OTHERS THEN
912: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
913: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
914: END IF;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END;
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;

Line 918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: END IF;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END;
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: --

Line 919: RAISE FND_API.G_EXC_ERROR;

915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END;
917:
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: --
923: -- End of API body

Line 927: IF FND_API.To_Boolean( p_commit ) THEN

923: -- End of API body
924: --
925:
926: -- Standard check of p_commit.
927: IF FND_API.To_Boolean( p_commit ) THEN
928: COMMIT WORK;
929: END IF;
930:
931: -- Standard call to get message count and IF count is get message info.

Line 936: WHEN FND_API.G_EXC_ERROR THEN

932: FND_MSG_PUB.Count_And_Get
933: (p_count => x_msg_count,
934: p_data => x_msg_data );
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
938: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
939: END IF;
940: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 938: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');

934: p_data => x_msg_data );
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
938: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
939: END IF;
940: x_return_status := FND_API.G_RET_STS_ERROR ;
941: ROLLBACK TO LOCK_REPAIR_ACTUALS;
942: FND_MSG_PUB.Count_And_Get

Line 940: x_return_status := FND_API.G_RET_STS_ERROR ;

936: WHEN FND_API.G_EXC_ERROR THEN
937: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
938: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
939: END IF;
940: x_return_status := FND_API.G_RET_STS_ERROR ;
941: ROLLBACK TO LOCK_REPAIR_ACTUALS;
942: FND_MSG_PUB.Count_And_Get
943: (p_count => x_msg_count,
944: p_data => x_msg_data );

Line 945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

941: ROLLBACK TO LOCK_REPAIR_ACTUALS;
942: FND_MSG_PUB.Count_And_Get
943: (p_count => x_msg_count,
944: p_data => x_msg_data );
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
947: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
948: END IF;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 947: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');

943: (p_count => x_msg_count,
944: p_data => x_msg_data );
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
947: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
948: END IF;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
950: ROLLBACK TO LOCK_REPAIR_ACTUALS;
951: FND_MSG_PUB.Count_And_Get

Line 949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
947: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
948: END IF;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
950: ROLLBACK TO LOCK_REPAIR_ACTUALS;
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count,
953: p_data => x_msg_data );

Line 959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

955: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
956: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
957: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
960: ROLLBACK TO LOCK_REPAIR_ACTUALS;
961: IF FND_MSG_PUB.Check_Msg_Level
962: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN