APPS.IGW_PROP_PERSON_SUPPORT_TBH dependencies on FND_API

Line 63: x_return_status := FND_API.G_RET_STS_SUCCESS;

59: l_last_update_login NUMBER;
60:
61:
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: l_last_update_date := SYSDATE;
66:
67: if(p_mode = 'I') then

Line 204: x_return_status := fnd_api.g_ret_sts_unexp_error;

200: when others then
201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_SUPPORT_TBH',
202: p_procedure_name => 'INSERT_ROW',
203: p_error_text => SUBSTRB(SQLERRM, 1, 240));
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: raise;
206:
207: END INSERT_ROW;
208: ----------------------------------------------------------------------------------------------------

Line 265: x_return_status := fnd_api.g_ret_sts_success;

261: l_last_updated_by NUMBER;
262: l_last_update_login NUMBER;
263:
264: BEGIN
265: x_return_status := fnd_api.g_ret_sts_success;
266:
267:
268: l_last_update_date := SYSDATE;
269: if(p_mode = 'I') then

Line 351: x_return_status := fnd_api.g_ret_sts_unexp_error;

347: when others then
348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_SUPPORT_TBH',
349: p_procedure_name => 'UPDATE_ROW',
350: p_error_text => SUBSTRB(SQLERRM, 1, 240));
351: x_return_status := fnd_api.g_ret_sts_unexp_error;
352: raise;
353:
354: END UPDATE_ROW;
355:

Line 365: x_return_status := fnd_api.g_ret_sts_success;

361: x_return_status out NOCOPY VARCHAR2
362: ) is
363:
364: BEGIN
365: x_return_status := fnd_api.g_ret_sts_success;
366:
367: delete from IGW_PROP_PERSON_SUPPORT
368: where rowid = x_rowid
369: and record_version_number = p_record_version_number;

Line 383: x_return_status := fnd_api.g_ret_sts_unexp_error;

379: when others then
380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSONS_SUPPORT_TBH',
381: p_procedure_name => 'DELETE_ROW',
382: p_error_text => SUBSTRB(SQLERRM, 1, 240));
383: x_return_status := fnd_api.g_ret_sts_unexp_error;
384: raise;
385:
386: END DELETE_ROW;
387: