APPS.PA_WORK_TYPE_UTILS dependencies on FND_API

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: AND TRUNC(SYSDATE) BETWEEN start_date_active
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

Line 53: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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:

Line 59: x_return_status := FND_API.G_RET_STS_ERROR;

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';
61: x_work_type_id := Null;
62: pa_debug.reset_err_stack; -- Reset error stack
63:

Line 65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
67: x_work_type_id := Null;
68: Raise;
69:

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191:
192: IF l_proj_typ_class_code = 'INDIRECT'
193: THEN
194: IF l_flag = 'Y' THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: x_error_message_code := 'PA_WORK_TYPE_INVALID';
197: END IF;
198: END IF;
199: ELSE

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: x_error_message_code := 'PA_WORK_TYPE_INVALID';
197: END IF;
198: END IF;
199: ELSE
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_error_message_code := 'PA_WORK_TYPE_INVALID';
202: END IF;
203:
204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS;

200: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206:
207:
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

Line 215: 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';
217: pa_debug.reset_err_stack; -- Reset error stack
218:
219: WHEN OTHERS THEN

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_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;
222: Raise;
223: END;
224: END Check_Work_Type;