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

Line 113: IF NOT FND_API.Compatible_API_Call ( l_api_version,

109: -- Standard Start of API savepoint
110: SAVEPOINT CREATE_REPAIR_ACTUAL_LINES;
111:
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version,
114: p_api_version,
115: l_api_name,
116: G_PKG_NAME)
117: THEN

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114: p_api_version,
115: l_api_name,
116: G_PKG_NAME)
117: THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 122: IF FND_API.to_Boolean( p_init_msg_list ) THEN

118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list ) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: -- Initialize API return status to success

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: -- Initialize API return status to success
127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: -- Api body starts
130: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
131: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of create_repair_actual_lines');

Line 160: RAISE FND_API.G_EXC_ERROR;

156:
157: -- Validate the repair line ID
158: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
159: ( p_repair_line_id => px_CSD_ACTUAL_LINES_REC.repair_line_id )) THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
164: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 239: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

235: X_Return_Status => x_return_status,
236: X_Msg_Count => x_msg_count,
237: X_Msg_Data => x_msg_data);
238:
239: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
240: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
241: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'csd_repair_actuals_pvt.create_repair_actuals failed');
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;

Line 243: RAISE FND_API.G_EXC_ERROR;

239: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
240: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
241: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'csd_repair_actuals_pvt.create_repair_actuals failed');
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245:
246: -- assign the created actuals header to actual lines record
247: px_CSD_ACTUAL_LINES_REC.repair_actual_id := lx_csd_actuals_rec.REPAIR_ACTUAL_ID;

Line 291: RAISE FND_API.G_EXC_ERROR;

287: FND_MSG_PUB.ADD;
288: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
289: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
290: END IF;
291: RAISE FND_API.G_EXC_ERROR;
292: End IF;
293: -- End check Actuals Header call
294:
295: END IF;

Line 311: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null

307: -- Calling charges API copy actual from estimate to create the record
308: -- in CS_ESTIMATE_DETAILS and will send in estimate_detail_id
309: -- which is the estimate_detail_id of the Actual line
310:
311: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null
312: IF (px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID is null) THEN
313: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
314: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Missing estimate_detail_id for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
315: END IF;

Line 317: RAISE FND_API.G_EXC_ERROR;

313: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
314: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Missing estimate_detail_id for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
315: END IF;
316:
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319:
320: --
321: -- API body

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

406: WHEN OTHERS THEN
407: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
408: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
409: END IF;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: END;
412:
413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;

Line 413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

409: END IF;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: END;
412:
413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: --

Line 414: RAISE FND_API.G_EXC_ERROR;

410: x_return_status := FND_API.G_RET_STS_ERROR;
411: END;
412:
413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: --
418: -- End of API body

Line 429: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null

425: -- Debrief would have created a Charge line in the cs_estimate_details table
426: -- which is the estimate_detail_id of the Actual line
427: -- we link the Debrief createsd charge line to our Actual Line
428:
429: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null
430: IF (px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID is null) THEN
431: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
432: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Missing estimate_detail_id for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
433: END IF;

Line 434: RAISE FND_API.G_EXC_ERROR;

430: IF (px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID is null) THEN
431: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
432: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Missing estimate_detail_id for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
433: END IF;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --
438: -- API body

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: WHEN OTHERS THEN
521: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
522: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
523: END IF;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END;
526:
527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
528: RAISE FND_API.G_EXC_ERROR;

Line 527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

523: END IF;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END;
526:
527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530:
531: --

Line 528: RAISE FND_API.G_EXC_ERROR;

524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END;
526:
527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530:
531: --
532: -- End of API body

Line 547: -- Raise FND_API.G_EXC_ERROR if it fails

543: END IF;
544:
545: -- If the actual_source_code = MANUAL then do validation for the
546: -- actual line record values passed from the Actuals UI
547: -- Raise FND_API.G_EXC_ERROR if it fails
548: --IF (px_CSD_ACTUAL_LINES_REC.actual_source_code in ('MANUAL') ) THEN
549:
550: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
551: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Begin Check reqd parameter');

Line 606: IF NVL(px_CHARGES_REC.business_process_id,FND_API.G_MISS_NUM)

602: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'l_bus_process_id ='||l_bus_process_id);
603: END IF;
604:
605: IF l_bus_process_id < 0 THEN
606: IF NVL(px_CHARGES_REC.business_process_id,FND_API.G_MISS_NUM)
607: <> FND_API.G_MISS_NUM THEN
608: l_bus_process_id := px_CHARGES_REC.business_process_id;
609: ELSE
610: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 607: <> FND_API.G_MISS_NUM THEN

603: END IF;
604:
605: IF l_bus_process_id < 0 THEN
606: IF NVL(px_CHARGES_REC.business_process_id,FND_API.G_MISS_NUM)
607: <> FND_API.G_MISS_NUM THEN
608: l_bus_process_id := px_CHARGES_REC.business_process_id;
609: ELSE
610: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
611: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Business process does not exist');

Line 613: RAISE FND_API.G_EXC_ERROR;

609: ELSE
610: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
611: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Business process does not exist');
612: END IF;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615: END IF;
616:
617: OPEN order_rec(px_CHARGES_REC.incident_id);

Line 629: RAISE FND_API.G_EXC_ERROR;

625: FND_MSG_PUB.ADD;
626: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
627: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
628: END IF;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:
632: IF order_rec%ISOPEN THEN
633: CLOSE order_rec;

Line 651: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

647: x_line_type_id => l_line_type_id,
648: x_line_category_code => l_line_category_code,
649: x_return_status => x_return_status );
650:
651: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 652: RAISE FND_API.G_EXC_ERROR;

648: x_line_category_code => l_line_category_code,
649: x_return_status => x_return_status );
650:
651: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
656: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'line_type_id ='||l_line_type_id);

Line 670: RAISE FND_API.G_EXC_ERROR;

666: FND_MSG_PUB.ADD;
667: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
668: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
669: END IF;
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673: -- Get the currency code
674: IF NVL(px_CHARGES_REC.price_list_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 674: IF NVL(px_CHARGES_REC.price_list_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673: -- Get the currency code
674: IF NVL(px_CHARGES_REC.price_list_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
675: BEGIN
676: SELECT currency_code
677: INTO l_curr_code
678: FROM oe_price_lists

Line 688: RAISE FND_API.G_EXC_ERROR;

684: FND_MSG_PUB.ADD;
685: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
686: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
689: END;
690: END IF;
691:
692: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 704: RAISE FND_API.G_EXC_ERROR;

700: FND_MSG_PUB.ADD;
701: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
702: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
703: END IF;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706:
707: -- assigning values for the charge record
708: px_CHARGES_REC.business_process_id := l_bus_process_id;

Line 730: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

726: -- ( p_estimate_line_rec => px_CSD_ACTUAL_LINES_REC,
727: -- x_charges_rec => lx_charges_rec,
728: -- x_return_status => x_return_status );
729:
730: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733:
734: END IF;

Line 731: RAISE FND_API.G_EXC_ERROR;

727: -- x_charges_rec => lx_charges_rec,
728: -- x_return_status => x_return_status );
729:
730: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733:
734: END IF;
735: -- end check for incident id is not null

Line 749: p_commit => fnd_api.g_false,

745: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines in create mode
746: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
747: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
748: ( p_api_version => 1.0 ,
749: p_commit => fnd_api.g_false,
750: p_init_msg_list => fnd_api.g_true,
751: p_validation_level => fnd_api.g_valid_level_full,
752: p_action => 'CREATE',
753: p_cs_cost_flag => l_cs_cost_flag, -- swai: 12.1 service costing uptake bug 6960295

Line 750: p_init_msg_list => fnd_api.g_true,

746: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
747: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
748: ( p_api_version => 1.0 ,
749: p_commit => fnd_api.g_false,
750: p_init_msg_list => fnd_api.g_true,
751: p_validation_level => fnd_api.g_valid_level_full,
752: p_action => 'CREATE',
753: p_cs_cost_flag => l_cs_cost_flag, -- swai: 12.1 service costing uptake bug 6960295
754: x_Charges_Rec => px_charges_rec,

Line 751: p_validation_level => fnd_api.g_valid_level_full,

747: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
748: ( p_api_version => 1.0 ,
749: p_commit => fnd_api.g_false,
750: p_init_msg_list => fnd_api.g_true,
751: p_validation_level => fnd_api.g_valid_level_full,
752: p_action => 'CREATE',
753: p_cs_cost_flag => l_cs_cost_flag, -- swai: 12.1 service costing uptake bug 6960295
754: x_Charges_Rec => px_charges_rec,
755: x_return_status => x_return_status,

Line 759: -- Raise FND_API.G_EXC_ERROR if it fails

755: x_return_status => x_return_status,
756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data );
758:
759: -- Raise FND_API.G_EXC_ERROR if it fails
760: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
763: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Creating Charge line failed for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);

Line 760: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data );
758:
759: -- Raise FND_API.G_EXC_ERROR if it fails
760: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
763: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Creating Charge line failed for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
764: END IF;

Line 761: RAISE FND_API.G_EXC_ERROR;

757: x_msg_data => x_msg_data );
758:
759: -- Raise FND_API.G_EXC_ERROR if it fails
760: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
763: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Creating Charge line failed for actual_source_code : '||px_CSD_ACTUAL_LINES_REC.actual_source_code);
764: END IF;
765: END IF;

Line 849: x_return_status := FND_API.G_RET_STS_ERROR;

845: WHEN OTHERS THEN
846: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
847: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
848: END IF;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: END;
851:
852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
853: RAISE FND_API.G_EXC_ERROR;

Line 852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

848: END IF;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: END;
851:
852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855:
856: --

Line 853: RAISE FND_API.G_EXC_ERROR;

849: x_return_status := FND_API.G_RET_STS_ERROR;
850: END;
851:
852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855:
856: --
857: -- End of API body

Line 864: IF FND_API.To_Boolean( p_commit ) THEN

860: END IF;
861:
862:
863: -- Standard check of p_commit.
864: IF FND_API.To_Boolean( p_commit ) THEN
865: COMMIT WORK;
866: END IF;
867:
868: -- Standard call to get message count and IF count is get message info.

Line 874: WHEN FND_API.G_EXC_ERROR THEN

870: (p_count => x_msg_count,
871: p_data => x_msg_data );
872:
873: EXCEPTION
874: WHEN FND_API.G_EXC_ERROR THEN
875: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
876: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR ;

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

872:
873: EXCEPTION
874: WHEN FND_API.G_EXC_ERROR THEN
875: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
876: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
880: FND_MSG_PUB.Count_And_Get

Line 878: x_return_status := FND_API.G_RET_STS_ERROR ;

874: WHEN FND_API.G_EXC_ERROR THEN
875: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
876: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
880: FND_MSG_PUB.Count_And_Get
881: (p_count => x_msg_count,
882: p_data => x_msg_data );

Line 883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

879: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
880: FND_MSG_PUB.Count_And_Get
881: (p_count => x_msg_count,
882: p_data => x_msg_data );
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
885: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
886: END IF;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

881: (p_count => x_msg_count,
882: p_data => x_msg_data );
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
885: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
886: END IF;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
889: FND_MSG_PUB.Count_And_Get

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
885: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
886: END IF;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
889: FND_MSG_PUB.Count_And_Get
890: ( p_count => x_msg_count,
891: p_data => x_msg_data );

Line 897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

893: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
894: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
895: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
896: END IF;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: ROLLBACK TO CREATE_REPAIR_ACTUAL_LINES;
899: IF FND_MSG_PUB.Check_Msg_Level
900: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
901: THEN

Line 1000: IF NOT FND_API.Compatible_API_Call ( l_api_version,

996: -- Standard Start of API savepoint
997: SAVEPOINT UPDATE_REPAIR_ACTUAL_LINES;
998:
999: -- Standard call to check for call compatibility.
1000: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1001: p_api_version,
1002: l_api_name,
1003: G_PKG_NAME)
1004: THEN

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: p_api_version,
1002: l_api_name,
1003: G_PKG_NAME)
1004: THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE.
1009: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1009: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE.
1009: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1010: FND_MSG_PUB.initialize;
1011: END IF;
1012:
1013: -- Initialize API return status to success

Line 1014: x_return_status := FND_API.G_RET_STS_SUCCESS;

1010: FND_MSG_PUB.initialize;
1011: END IF;
1012:
1013: -- Initialize API return status to success
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: -- Api body starts
1017: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1018: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of update_repair_actual_lines');

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058:
1059: -- Validate the repair line ID
1060: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
1061: ( p_repair_line_id => px_CSD_ACTUAL_LINES_REC.repair_line_id )) THEN
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064:
1065: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1066: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 1070: -- If it is invalid then raise FND_API.G_EXC_ERROR

1066: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
1067: END IF;
1068:
1069: -- Validate the repair actual line id against csd_repair_actual_lines
1070: -- If it is invalid then raise FND_API.G_EXC_ERROR
1071: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1072:
1073: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);
1074: FETCH repair_actual_lines

Line 1071: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1067: END IF;
1068:
1069: -- Validate the repair actual line id against csd_repair_actual_lines
1070: -- If it is invalid then raise FND_API.G_EXC_ERROR
1071: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1072:
1073: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);
1074: FETCH repair_actual_lines
1075: INTO l_act_obj_ver_num;

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: FND_MSG_PUB.ADD;
1081: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1082: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1083: END IF;
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:
1087: IF repair_actual_lines%ISOPEN THEN
1088: CLOSE repair_actual_lines;

Line 1092: -- If it is invalid then raise FND_API.G_EXC_ERROR

1088: CLOSE repair_actual_lines;
1089: END IF;
1090:
1091: -- Validate the estimate detail id against cs_estimate_details
1092: -- If it is invalid then raise FND_API.G_EXC_ERROR
1093: OPEN charge_lines(px_Charges_Rec.estimate_detail_id);
1094: FETCH charge_lines
1095: INTO l_est_obj_ver_num;
1096:

Line 1104: RAISE FND_API.G_EXC_ERROR;

1100: FND_MSG_PUB.ADD;
1101: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1102: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1103: END IF;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107: IF charge_lines%ISOPEN THEN
1108: CLOSE charge_lines;

Line 1117: IF NVL(px_CSD_ACTUAL_LINES_REC.object_version_number,FND_API.G_MISS_NUM) <> l_act_obj_ver_num THEN

1113: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1114: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number for Charge and Actual Line');
1115: END IF;
1116:
1117: IF NVL(px_CSD_ACTUAL_LINES_REC.object_version_number,FND_API.G_MISS_NUM) <> l_act_obj_ver_num THEN
1118: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1119: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Actual Line Object Version Number does not match'
1120: || ' for the Repair Actual Line ID = ' || px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);
1121: END IF;

Line 1131: RAISE FND_API.G_EXC_ERROR;

1127: FND_MSG_PUB.ADD;
1128: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1129: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1130: END IF;
1131: RAISE FND_API.G_EXC_ERROR;
1132: ELSE
1133: -- Assigning object version number
1134: px_CSD_ACTUAL_LINES_REC.object_version_number := l_act_obj_ver_num+1;
1135: END IF;

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

1231: /*FP Fixed for bug#5117652 end*/
1232:
1233:
1234: -- Initialize API return status to SUCCESS
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: -- --------------------------------------------------------------------
1238: -- Check the Repair_Actual_Lines_Rec.actual_source_code for validations
1239:

Line 1276: p_commit => fnd_api.g_false,

1272: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines in update mode
1273: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
1274: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1275: ( p_api_version => 1.0 ,
1276: p_commit => fnd_api.g_false,
1277: p_init_msg_list => fnd_api.g_true,
1278: p_validation_level => fnd_api.g_valid_level_full,
1279: p_action => 'UPDATE',
1280: -- swai: 12.1 service costing uptake bug 6960295

Line 1277: p_init_msg_list => fnd_api.g_true,

1273: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
1274: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1275: ( p_api_version => 1.0 ,
1276: p_commit => fnd_api.g_false,
1277: p_init_msg_list => fnd_api.g_true,
1278: p_validation_level => fnd_api.g_valid_level_full,
1279: p_action => 'UPDATE',
1280: -- swai: 12.1 service costing uptake bug 6960295
1281: p_cs_cost_flag => l_cs_cost_flag,

Line 1278: p_validation_level => fnd_api.g_valid_level_full,

1274: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1275: ( p_api_version => 1.0 ,
1276: p_commit => fnd_api.g_false,
1277: p_init_msg_list => fnd_api.g_true,
1278: p_validation_level => fnd_api.g_valid_level_full,
1279: p_action => 'UPDATE',
1280: -- swai: 12.1 service costing uptake bug 6960295
1281: p_cs_cost_flag => l_cs_cost_flag,
1282: x_Charges_Rec => px_charges_rec,

Line 1290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1286:
1287: -- The following check was added as a fix for bug 3378602. vkjain
1288: -- We do not want to continue with updating the Actual line if Charges
1289: -- API returned error.
1290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1291: RAISE FND_API.G_EXC_ERROR;
1292: END IF;
1293:
1294: EXCEPTION

Line 1291: RAISE FND_API.G_EXC_ERROR;

1287: -- The following check was added as a fix for bug 3378602. vkjain
1288: -- We do not want to continue with updating the Actual line if Charges
1289: -- API returned error.
1290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1291: RAISE FND_API.G_EXC_ERROR;
1292: END IF;
1293:
1294: EXCEPTION
1295: -- The following exception was added as a fix for bug 3378602. vkjain

Line 1296: WHEN FND_API.G_EXC_ERROR THEN

1292: END IF;
1293:
1294: EXCEPTION
1295: -- The following exception was added as a fix for bug 3378602. vkjain
1296: WHEN FND_API.G_EXC_ERROR THEN
1297: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1298: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Charges API returned error while calling UPDATE.');
1299: END IF;
1300: RAISE FND_API.G_EXC_ERROR;

Line 1300: RAISE FND_API.G_EXC_ERROR;

1296: WHEN FND_API.G_EXC_ERROR THEN
1297: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1298: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Charges API returned error while calling UPDATE.');
1299: END IF;
1300: RAISE FND_API.G_EXC_ERROR;
1301: WHEN OTHERS THEN
1302: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1303: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception error :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1304: END IF;

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: WHEN OTHERS THEN
1302: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1303: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception error :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1304: END IF;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END;
1307:
1308: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
1309: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Update_Row');

Line 1320: ,p_CREATED_BY => FND_API.G_MISS_NUM

1316: ,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
1317: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
1318: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
1319: ,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
1320: ,p_CREATED_BY => FND_API.G_MISS_NUM
1321: ,p_CREATION_DATE => FND_API.G_MISS_DATE
1322: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1323: ,p_LAST_UPDATE_DATE => SYSDATE
1324: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

Line 1321: ,p_CREATION_DATE => FND_API.G_MISS_DATE

1317: ,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
1318: ,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
1319: ,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
1320: ,p_CREATED_BY => FND_API.G_MISS_NUM
1321: ,p_CREATION_DATE => FND_API.G_MISS_DATE
1322: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1323: ,p_LAST_UPDATE_DATE => SYSDATE
1324: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
1325: ,p_ITEM_COST => px_CSD_ACTUAL_LINES_REC.ITEM_COST

Line 1379: RAISE FND_API.G_EXC_ERROR;

1375: WHEN OTHERS THEN
1376: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1377: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row Cal:'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1378: END IF;
1379: RAISE FND_API.G_EXC_ERROR;
1380: END;
1381: --
1382: -- End of API body
1383: --

Line 1386: IF FND_API.To_Boolean( p_commit ) THEN

1382: -- End of API body
1383: --
1384:
1385: -- Standard check of p_commit.
1386: IF FND_API.To_Boolean( p_commit ) THEN
1387: COMMIT WORK;
1388: END IF;
1389:
1390: -- Standard call to get message count and IF count is get message info.

Line 1396: WHEN FND_API.G_EXC_ERROR THEN

1392: (p_count => x_msg_count,
1393: p_data => x_msg_data );
1394:
1395: EXCEPTION
1396: WHEN FND_API.G_EXC_ERROR THEN
1397: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1398: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_ERROR ;

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

1394:
1395: EXCEPTION
1396: WHEN FND_API.G_EXC_ERROR THEN
1397: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1398: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1402: FND_MSG_PUB.Count_And_Get

Line 1400: x_return_status := FND_API.G_RET_STS_ERROR ;

1396: WHEN FND_API.G_EXC_ERROR THEN
1397: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1398: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1402: FND_MSG_PUB.Count_And_Get
1403: (p_count => x_msg_count,
1404: p_data => x_msg_data );

Line 1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1401: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1402: FND_MSG_PUB.Count_And_Get
1403: (p_count => x_msg_count,
1404: p_data => x_msg_data );
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1407: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1408: END IF;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1403: (p_count => x_msg_count,
1404: p_data => x_msg_data );
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1407: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1408: END IF;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1411: FND_MSG_PUB.Count_And_Get

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1407: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1408: END IF;
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_count => x_msg_count,
1413: p_data => x_msg_data );

Line 1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1415: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1416: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
1417: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
1418: END IF;
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
1421: IF FND_MSG_PUB.Check_Msg_Level
1422: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1423: THEN

Line 1515: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1511: -- Standard Start of API savepoint
1512: SAVEPOINT DELETE_REPAIR_ACTUAL_LINES;
1513:
1514: -- Standard call to check for call compatibility.
1515: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1516: p_api_version,
1517: l_api_name,
1518: G_PKG_NAME)
1519: THEN

Line 1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1516: p_api_version,
1517: l_api_name,
1518: G_PKG_NAME)
1519: THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: END IF;
1522:
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1524: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: END IF;
1522:
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1525: FND_MSG_PUB.initialize;
1526: END IF;
1527:
1528: -- Initialize API return status to success

Line 1529: x_return_status := FND_API.G_RET_STS_SUCCESS;

1525: FND_MSG_PUB.initialize;
1526: END IF;
1527:
1528: -- Initialize API return status to success
1529: x_return_status := FND_API.G_RET_STS_SUCCESS;
1530:
1531: -- Api body starts
1532: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1533: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of delete_repair_actual_lines');

Line 1564: RAISE FND_API.G_EXC_ERROR;

1560:
1561: -- Validate the repair line ID
1562: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
1563: ( p_repair_line_id => px_CSD_ACTUAL_LINES_REC.repair_line_id )) THEN
1564: RAISE FND_API.G_EXC_ERROR;
1565: END IF;
1566:
1567: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1568: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');

Line 1582: -- If it is interfaced then raise FND_API.G_EXC_ERROR

1578:
1579: IF (px_CSD_ACTUAL_LINES_REC.actual_source_code in ('MANUAL', 'ESTIMATE')) then
1580:
1581: -- Validate the repair actual line id against csd_repair_actual_lines
1582: -- If it is interfaced then raise FND_API.G_EXC_ERROR
1583: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1584:
1585: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);
1586: FETCH repair_actual_lines

Line 1583: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1579: IF (px_CSD_ACTUAL_LINES_REC.actual_source_code in ('MANUAL', 'ESTIMATE')) then
1580:
1581: -- Validate the repair actual line id against csd_repair_actual_lines
1582: -- If it is interfaced then raise FND_API.G_EXC_ERROR
1583: IF NVL(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1584:
1585: OPEN repair_actual_lines(px_CSD_ACTUAL_LINES_REC.repair_actual_line_id);
1586: FETCH repair_actual_lines
1587: INTO l_actual_line_id,

Line 1597: RAISE FND_API.G_EXC_ERROR;

1593: FND_MSG_PUB.ADD;
1594: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1595: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1596: END IF;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599:
1600: IF repair_actual_lines%ISOPEN THEN
1601: CLOSE repair_actual_lines;

Line 1610: IF NVL(px_CSD_ACTUAL_LINES_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

1606: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1607: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number');
1608: END IF;
1609:
1610: IF NVL(px_CSD_ACTUAL_LINES_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
1611: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1612: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Object Version Number does not match'
1613: || ' for the Repair Actual Line ID = ' || l_actual_line_id);
1614: END IF;

Line 1624: RAISE FND_API.G_EXC_ERROR;

1620: FND_MSG_PUB.ADD;
1621: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1622: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1623: END IF;
1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:
1627: IF (px_Charges_Rec.order_header_id is not null) THEN
1628: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 1638: RAISE FND_API.G_EXC_ERROR;

1634: FND_MSG_PUB.ADD;
1635: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
1636: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
1637: END IF;
1638: RAISE FND_API.G_EXC_ERROR;
1639: END IF;
1640:
1641: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines to
1642: -- delete the record in CS_ESTIMATE_DETAILS

Line 1649: p_commit => fnd_api.g_false,

1645: END IF;
1646:
1647: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1648: ( p_api_version => 1.0 ,
1649: p_commit => fnd_api.g_false,
1650: p_init_msg_list => fnd_api.g_true,
1651: p_validation_level => fnd_api.g_valid_level_full,
1652: p_action => 'DELETE',
1653: -- swai: 12.1 service costing uptake bug 6960295

Line 1650: p_init_msg_list => fnd_api.g_true,

1646:
1647: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1648: ( p_api_version => 1.0 ,
1649: p_commit => fnd_api.g_false,
1650: p_init_msg_list => fnd_api.g_true,
1651: p_validation_level => fnd_api.g_valid_level_full,
1652: p_action => 'DELETE',
1653: -- swai: 12.1 service costing uptake bug 6960295
1654: p_cs_cost_flag => l_cs_cost_flag,

Line 1651: p_validation_level => fnd_api.g_valid_level_full,

1647: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1648: ( p_api_version => 1.0 ,
1649: p_commit => fnd_api.g_false,
1650: p_init_msg_list => fnd_api.g_true,
1651: p_validation_level => fnd_api.g_valid_level_full,
1652: p_action => 'DELETE',
1653: -- swai: 12.1 service costing uptake bug 6960295
1654: p_cs_cost_flag => l_cs_cost_flag,
1655: x_Charges_Rec => px_charges_rec,

Line 1660: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1656: x_return_status => x_return_status,
1657: x_msg_count => x_msg_count,
1658: x_msg_data => x_msg_data);
1659:
1660: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663:
1664: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN

Line 1661: RAISE FND_API.G_EXC_ERROR;

1657: x_msg_count => x_msg_count,
1658: x_msg_data => x_msg_data);
1659:
1660: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663:
1664: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
1665: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row');

Line 1680: x_return_status := FND_API.G_RET_STS_ERROR;

1676: WHEN OTHERS THEN
1677: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1678: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1679: END IF;
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: END;
1682:
1683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1684: RAISE FND_API.G_EXC_ERROR;

Line 1683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1679: END IF;
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: END;
1682:
1683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: END IF;

Line 1684: RAISE FND_API.G_EXC_ERROR;

1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: END;
1682:
1683: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: END IF;
1688: --

Line 1693: IF FND_API.To_Boolean( p_commit ) THEN

1689: -- End of API body
1690: --
1691:
1692: -- Standard check of p_commit.
1693: IF FND_API.To_Boolean( p_commit ) THEN
1694: COMMIT WORK;
1695: END IF;
1696:
1697: -- Standard call to get message count and IF count is get message info.

Line 1702: WHEN FND_API.G_EXC_ERROR THEN

1698: FND_MSG_PUB.Count_And_Get
1699: (p_count => x_msg_count,
1700: p_data => x_msg_data );
1701: EXCEPTION
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1704: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;

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

1700: p_data => x_msg_data );
1701: EXCEPTION
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1704: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1708: FND_MSG_PUB.Count_And_Get

Line 1706: x_return_status := FND_API.G_RET_STS_ERROR ;

1702: WHEN FND_API.G_EXC_ERROR THEN
1703: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1704: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1708: FND_MSG_PUB.Count_And_Get
1709: (p_count => x_msg_count,
1710: p_data => x_msg_data );

Line 1711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1707: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1708: FND_MSG_PUB.Count_And_Get
1709: (p_count => x_msg_count,
1710: p_data => x_msg_data );
1711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1712: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1713: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1714: END IF;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1709: (p_count => x_msg_count,
1710: p_data => x_msg_data );
1711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1712: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1713: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1714: END IF;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1716: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1717: FND_MSG_PUB.Count_And_Get

Line 1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1712: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1713: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1714: END IF;
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1716: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1717: FND_MSG_PUB.Count_And_Get
1718: ( p_count => x_msg_count,
1719: p_data => x_msg_data );

Line 1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1721: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1722: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
1723: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
1724: END IF;
1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1726: ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
1727: IF FND_MSG_PUB.Check_Msg_Level
1728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1729: THEN

Line 1796: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1792: -- Standard Start of API savepoint
1793: SAVEPOINT LOCK_REPAIR_ACTUAL_LINES;
1794:
1795: -- Standard call to check for call compatibility.
1796: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1797: p_api_version,
1798: l_api_name,
1799: G_PKG_NAME)
1800: THEN

Line 1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1797: p_api_version,
1798: l_api_name,
1799: G_PKG_NAME)
1800: THEN
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: END IF;
1803:
1804: -- Initialize message list if p_init_msg_list is set to TRUE.
1805: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1805: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: END IF;
1803:
1804: -- Initialize message list if p_init_msg_list is set to TRUE.
1805: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1806: FND_MSG_PUB.initialize;
1807: END IF;
1808:
1809: -- Initialize API return status to success

Line 1810: x_return_status := FND_API.G_RET_STS_SUCCESS;

1806: FND_MSG_PUB.initialize;
1807: END IF;
1808:
1809: -- Initialize API return status to success
1810: x_return_status := FND_API.G_RET_STS_SUCCESS;
1811:
1812: -- Api body starts
1813: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
1814: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of lock_repair_actual_lines');

Line 1857: x_return_status := FND_API.G_RET_STS_ERROR;

1853: WHEN OTHERS THEN
1854: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1855: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
1856: END IF;
1857: x_return_status := FND_API.G_RET_STS_ERROR;
1858: END;
1859:
1860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: RAISE FND_API.G_EXC_ERROR;

Line 1860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1856: END IF;
1857: x_return_status := FND_API.G_RET_STS_ERROR;
1858: END;
1859:
1860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:
1864: --

Line 1861: RAISE FND_API.G_EXC_ERROR;

1857: x_return_status := FND_API.G_RET_STS_ERROR;
1858: END;
1859:
1860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:
1864: --
1865: -- End of API body

Line 1869: IF FND_API.To_Boolean( p_commit ) THEN

1865: -- End of API body
1866: --
1867:
1868: -- Standard check of p_commit.
1869: IF FND_API.To_Boolean( p_commit ) THEN
1870: COMMIT WORK;
1871: END IF;
1872:
1873: -- Standard call to get message count and IF count is get message info.

Line 1878: WHEN FND_API.G_EXC_ERROR THEN

1874: FND_MSG_PUB.Count_And_Get
1875: (p_count => x_msg_count,
1876: p_data => x_msg_data );
1877: EXCEPTION
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1880: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1881: END IF;
1882: x_return_status := FND_API.G_RET_STS_ERROR ;

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

1876: p_data => x_msg_data );
1877: EXCEPTION
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1880: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1881: END IF;
1882: x_return_status := FND_API.G_RET_STS_ERROR ;
1883: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1884: FND_MSG_PUB.Count_And_Get

Line 1882: x_return_status := FND_API.G_RET_STS_ERROR ;

1878: WHEN FND_API.G_EXC_ERROR THEN
1879: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1880: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_ERROR exception');
1881: END IF;
1882: x_return_status := FND_API.G_RET_STS_ERROR ;
1883: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1884: FND_MSG_PUB.Count_And_Get
1885: (p_count => x_msg_count,
1886: p_data => x_msg_data );

Line 1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1883: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1884: FND_MSG_PUB.Count_And_Get
1885: (p_count => x_msg_count,
1886: p_data => x_msg_data );
1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1889: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1890: END IF;
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1885: (p_count => x_msg_count,
1886: p_data => x_msg_data );
1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1889: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1890: END IF;
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1892: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1893: FND_MSG_PUB.Count_And_Get

Line 1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1888: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1889: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In FND_API.G_EXC_UNEXPECTED_ERROR exception ');
1890: END IF;
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1892: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1893: FND_MSG_PUB.Count_And_Get
1894: ( p_count => x_msg_count,
1895: p_data => x_msg_data );

Line 1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1897: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
1898: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'In OTHERS exception');
1899: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Sql Err Msg :'||SQLERRM );
1900: END IF;
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1902: ROLLBACK TO LOCK_REPAIR_ACTUAL_LINES;
1903: IF FND_MSG_PUB.Check_Msg_Level
1904: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1905: THEN