APPS.PA_TASK_TYPE_PKG dependencies on FND_API

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: ------------------------------------------------------------------------------------------------------------
61: BEGIN
62:
63: -- Initialize the return status to success
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: -----------------------------------------------------------------------------------------------------------
66: --3279978 FP M Development avaithia 29-Dec-2003
67: --If p_task_type_id is zero then take the value from sequence
68: IF (p_task_type_id =0)

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

191: -- Set the excetption Message and the stack
192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.insert_row'
193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
194: --
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: RAISE;
197:
198: END insert_row;
199:

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250:
251: BEGIN
252:
253: -- Initialize the return status to success
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: UPDATE pa_task_types
257: SET
258: task_type = p_task_type

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

305: -- Set the excetption Message and the stack
306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.update_row'
307: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
308: --
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE;
311:
312: END update_row;
313:

Line 327: x_return_status := FND_API.G_RET_STS_SUCCESS;

323:
324: BEGIN
325:
326: -- Initialize the return status to success
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:
329: IF(p_record_version_number =0) THEN
330: DELETE FROM pa_task_types
331: WHERE task_type_id = p_task_type_id;

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338: IF (SQL%NOTFOUND) THEN
339:
340: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
341: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
342: x_return_status := FND_API.G_RET_STS_ERROR;
343:
344: END IF;
345:
346: EXCEPTION

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

347: WHEN OTHERS THEN
348: -- Set the excetption Message and the stack
349: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.delete_row'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: RAISE;
353:
354: END delete_row;
355: