1: PACKAGE BODY PA_ASSIGNMENTS_HISTORY_PKG AS
2: /*$Header: PARAAPKB.pls 120.1 2005/08/19 16:47:02 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: -- Set the exception Message and the stack
294: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row'
295: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: RAISE;
298: END Insert_Row;
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- Set the exception Message and the stack
496: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Update_Row'
497: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
499: RAISE;
500: END Update_Row;
542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: -- Set the current program unit name in the error stack
546: -- PA_Error_Utils.Set_Error_Stack('PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row');
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: WHEN OTHERS THEN
545: -- Set the current program unit name in the error stack
546: -- PA_Error_Utils.Set_Error_Stack('PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row');
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551: RAISE;
552: END Delete_Row;
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: -- Set the exception Message and the stack
593: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_By_Assignment'
594: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
596: RAISE;
597: END Delete_By_Assignment;
597: END Delete_By_Assignment;
598:
599: --
600: --
601: END PA_ASSIGNMENTS_HISTORY_PKG;