DBA Data[Home] [Help]

APPS.BIS_APPLICATION_MEASURE_PVT dependencies on BIS_UTILITIES_PVT

Line 65: BIS_UTILITIES_PVT.Add_Error_Message

61: when others then
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
63: --added last two params
64: l_error_tbl := x_error_Tbl;
65: BIS_UTILITIES_PVT.Add_Error_Message
66: ( p_error_msg_id => SQLCODE
67: , p_error_description => SQLERRM
68: , p_error_proc_name => G_PKG_NAME||'.Create_Application_Measure'
69: , p_error_table => l_error_tbl

Line 209: BIS_UTILITIES_PVT.Add_Error_Message

205: l_error_tbl := x_error_Tbl;
206: IF (c_app_meas%ISOPEN) THEN
207: CLOSE c_app_meas;
208: END IF;
209: BIS_UTILITIES_PVT.Add_Error_Message
210: ( p_error_msg_id => SQLCODE
211: , p_error_description => SQLERRM
212: , p_error_proc_name => G_PKG_NAME||'.Create_Application_Measure'
213: , p_error_table => l_error_tbl

Line 295: BIS_UTILITIES_PVT.Add_Error_Message

291:
292: --added this check
293: if (l_flag = 0) then
294: l_error_tbl := x_error_Tbl;
295: BIS_UTILITIES_PVT.Add_Error_Message
296: ( p_error_msg_name => 'BIS_INVALID_MEASURE_ID'
297: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
298: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Application_Measures'
299: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 328: BIS_UTILITIES_PVT.Add_Error_Message

324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
326: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
327: l_error_tbl := x_error_Tbl;
328: BIS_UTILITIES_PVT.Add_Error_Message
329: ( p_error_msg_id => SQLCODE
330: , p_error_description => SQLERRM
331: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Application_Measures'
332: , p_error_table => l_error_tbl

Line 367: BIS_UTILITIES_PVT.Add_Error_Message

363: when others then
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: --added last two params
366: l_error_tbl := x_error_Tbl;
367: BIS_UTILITIES_PVT.Add_Error_Message
368: ( p_error_msg_id => SQLCODE
369: , p_error_description => SQLERRM
370: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
371: , p_error_table => l_error_tbl

Line 405: BIS_UTILITIES_PVT.Add_Error_Message

401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE
402: ) then
403: --added last two params
404: l_error_tbl := x_error_Tbl;
405: BIS_UTILITIES_PVT.Add_Error_Message
406: ( p_error_msg_name => 'BIS_INVALID_OWNING_APP_VALUE'
407: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
408: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
409: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 487: BIS_UTILITIES_PVT.Add_Error_Message

483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: l_error_tbl := x_error_Tbl;
487: BIS_UTILITIES_PVT.Add_Error_Message
488: ( p_error_msg_id => SQLCODE
489: , p_error_description => SQLERRM
490: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
491: , p_error_table => l_error_tbl

Line 550: BIS_UTILITIES_PVT.Add_Error_Message

546: WHEN NO_DATA_FOUND THEN
547: x_return_status := FND_API.G_RET_STS_ERROR ;
548: --added more params
549: l_error_tbl := x_error_Tbl;
550: BIS_UTILITIES_PVT.Add_Error_Message
551: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'
552: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
553: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
554: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 568: BIS_UTILITIES_PVT.Add_Error_Message

564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: l_error_tbl := x_error_Tbl;
568: BIS_UTILITIES_PVT.Add_Error_Message
569: ( p_error_msg_id => SQLCODE
570: , p_error_description => SQLERRM
571: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
572: , p_error_table => l_error_tbl

Line 616: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

612:
613: EXCEPTION
614: when FND_API.G_EXC_ERROR then
615: l_error_tbl_p := x_error_Tbl;
616: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
617: , l_error_Tbl
618: , x_error_tbl
619: );
620: x_return_status := FND_API.G_RET_STS_ERROR;

Line 638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

634: );
635: EXCEPTION
636: when FND_API.G_EXC_ERROR then
637: l_error_tbl_p := x_error_Tbl;
638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
639: , l_error_Tbl
640: , x_error_tbl
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 659: BIS_UTILITIES_PVT.Add_Error_Message

655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: l_error_tbl_p := x_error_Tbl;
659: BIS_UTILITIES_PVT.Add_Error_Message
660: ( p_error_msg_id => SQLCODE
661: , p_error_description => SQLERRM
662: , p_error_proc_name => G_PKG_NAME||'.Validate_Application_Measure'
663: , p_error_table => l_error_tbl_p

Line 761: BIS_UTILITIES_PVT.Add_Error_Message

757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: l_error_tbl := x_error_Tbl;
761: BIS_UTILITIES_PVT.Add_Error_Message
762: ( p_error_msg_id => SQLCODE
763: , p_error_description => SQLERRM
764: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
765: , p_error_table => l_error_tbl

Line 803: BIS_UTILITIES_PVT.Add_Error_Message

799: WHEN NO_DATA_FOUND THEN
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: --added this message
802: l_error_tbl := x_error_Tbl;
803: BIS_UTILITIES_PVT.Add_Error_Message
804: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'
805: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
806: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
807: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 821: BIS_UTILITIES_PVT.Add_Error_Message

817: -- RAISE;
818: WHEN OTHERS THEN
819: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
820: l_error_tbl := x_error_Tbl;
821: BIS_UTILITIES_PVT.Add_Error_Message
822: ( p_error_table => l_error_Tbl
823: , p_error_msg_id => SQLCODE
824: , p_error_description => SQLERRM
825: , x_error_table => x_error_Tbl

Line 859: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);

855: , x_error_Tbl => x_error_Tbl
856: );
857:
858: IF(p_timestamp IS NOT NULL) THEN
859: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
860: IF(l_form_date = l_last_update_date) THEN
861: x_return_status := FND_API.G_TRUE;
862: ELSE
863: x_return_status := FND_API.G_FALSE;

Line 881: BIS_UTILITIES_PVT.Add_Error_Message

877: --RAISE;
878: WHEN OTHERS THEN
879: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
880: l_error_tbl := x_error_Tbl;
881: BIS_UTILITIES_PVT.Add_Error_Message
882: ( p_error_table => l_error_Tbl
883: , p_error_msg_id => SQLCODE
884: , p_error_description => SQLERRM
885: , x_error_table => x_error_Tbl