DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UTILS dependencies on PA_DEBUG

Line 24: pa_debug.set_err_stack('PA_WORK_TYPE_UTILS.Check_Work_Type_Name_or_ID');

20: ,x_error_message_code OUT NOCOPY VARCHAR2)
21: IS
22: BEGIN
23: -- Set the error stack
24: pa_debug.set_err_stack('PA_WORK_TYPE_UTILS.Check_Work_Type_Name_or_ID');
25:
26: IF p_work_type_id IS NOT NULL THEN
27: -- Validate ID based on the check id flag
28: IF p_check_id_flag = 'Y' THEN

Line 49: pa_debug.reset_err_stack; -- Reset error stack

45: AND NVL(end_date_active,TRUNC(SYSDATE));
46: END IF;
47:
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: pa_debug.reset_err_stack; -- Reset error stack
50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: x_return_status := FND_API.G_RET_STS_ERROR;

Line 56: pa_debug.reset_err_stack; -- Reset error stack

52: WHEN NO_DATA_FOUND THEN
53: x_return_status := FND_API.G_RET_STS_ERROR;
54: x_error_message_code := 'PA_WORK_TYPE_INVALID_AMBIGOUS';
55: x_work_type_id := Null;
56: pa_debug.reset_err_stack; -- Reset error stack
57:
58: WHEN TOO_MANY_ROWS THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;
60: x_error_message_code := 'PA_WORK_TYPE_INVALID_AMBIGOUS';

Line 62: pa_debug.reset_err_stack; -- Reset error stack

58: WHEN TOO_MANY_ROWS THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;
60: x_error_message_code := 'PA_WORK_TYPE_INVALID_AMBIGOUS';
61: x_work_type_id := Null;
62: pa_debug.reset_err_stack; -- Reset error stack
63:
64: WHEN OTHERS THEN
65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: x_error_message_code := Null;

Line 124: -- pa_debug.set_err_stack('PA_WORK_TYPE_UTILS.Check_Work_Type_Name_or_ID');

120: l_proj_task_rec Get_Project_id%ROWTYPE;
121: l_work_type_rec work_type_cur%ROWTYPE;
122: BEGIN
123: -- Set the error stack
124: -- pa_debug.set_err_stack('PA_WORK_TYPE_UTILS.Check_Work_Type_Name_or_ID');
125: IF p_work_type_id IS NOT NULL THEN
126: IF (p_project_id IS NOT NULL AND p_task_id IS NULL)
127: OR (p_project_id IS NOT NULL AND p_task_id IS NOT NULL) THEN
128: l_project_id := p_project_id;

Line 205: pa_debug.reset_err_stack; -- Reset error stack

201: x_error_message_code := 'PA_WORK_TYPE_INVALID';
202: END IF;
203:
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: pa_debug.reset_err_stack; -- Reset error stack
206:
207:
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN

Line 212: pa_debug.reset_err_stack; -- Reset error stack

208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: x_error_message_code := 'PA_WORK_TYPE_INVALID';
212: pa_debug.reset_err_stack; -- Reset error stack
213:
214: WHEN TOO_MANY_ROWS THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: x_error_message_code := 'PA_WORK_TYPE_INVALID';

Line 217: pa_debug.reset_err_stack; -- Reset error stack

213:
214: WHEN TOO_MANY_ROWS THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: x_error_message_code := 'PA_WORK_TYPE_INVALID';
217: pa_debug.reset_err_stack; -- Reset error stack
218:
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: x_error_message_code := Null;