[Home] [Help]
1: PACKAGE BODY pa_job_utils AS
2: -- $Header: PAJBUTLB.pls 120.5.12010000.4 2009/04/21 05:50:33 snizam ship $
3:
4:
5: --------------------------------------------------------------------------------------------------------------
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: x_error_message_code := 'PA_JOB_INVALID_AMBIGUOUS';
77: WHEN OTHERS THEN
78: --PA_Error_Utils.Set_Error_Stack
79: -- (`pa_job_utils.check_jobname_or_id');
80: -- This sets the current program unit name in the
81: -- error stack. Helpful in Debugging
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83:
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: x_error_message_code := 'PA_JOBLEVEL_INVALID_AMBIGUOUS';
131: WHEN OTHERS THEN
132: --PA_Error_Utils.Set_Error_Stack
133: -- (`pa_job_utils.check_jobname_or_id');
134: -- This sets the current program unit name in the
135: -- error stack. Helpful in Debugging
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
137:
257:
258:
259: BEGIN
260: -- Initialize the Error stack
261: PA_DEBUG.init_err_stack('PA_JOB_UTILS.validate_job_relationship');
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263: SELECT job_group_id
264: INTO v_job_group_id
265: FROM per_jobs
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: WHEN OTHERS THEN
285: -- Set the exception Message and the stack
286: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_JOB_UTILS.validate_job_relationship'
287: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
289: raise;
290: END validate_job_relationship;
720:
721: Close C1;
722: END check_job_relationships;
723:
724: END pa_job_utils ;
725: