APPS.IGW_PROP_PERSON_QUESTIONS_TBH dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_last_updated_by NUMBER;
24: l_last_update_login NUMBER;
25:
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: l_last_update_date := SYSDATE;
30:
31: if(p_mode = 'I') then

Line 94: x_return_status := fnd_api.g_ret_sts_unexp_error;

90: when others then
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
92: p_procedure_name => 'INSERT_ROW',
93: p_error_text => SUBSTRB(SQLERRM, 1, 240));
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: raise;
96:
97: END INSERT_ROW;
98: ----------------------------------------------------------------------------------------------------

Line 119: x_return_status := fnd_api.g_ret_sts_success;

115: l_last_updated_by NUMBER;
116: l_last_update_login NUMBER;
117:
118: BEGIN
119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: l_last_update_date := SYSDATE;
122: if (p_mode = 'I') then
123: l_last_updated_by := 1;

Line 169: x_return_status := fnd_api.g_ret_sts_unexp_error;

165: when others then
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
167: p_procedure_name => 'UPDATE_ROW',
168: p_error_text => SUBSTRB(SQLERRM, 1, 240));
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: raise;
171:
172: END UPDATE_ROW;
173: ----------------------------------------------------------------------------------------------------

Line 182: x_return_status := fnd_api.g_ret_sts_success;

178: x_return_status out NOCOPY VARCHAR2
179: ) is
180:
181: BEGIN
182: x_return_status := fnd_api.g_ret_sts_success;
183:
184: delete from IGW_PROP_PERSON_QUESTIONS
185: where rowid = x_rowid
186: and record_version_number = p_record_version_number;

Line 200: x_return_status := fnd_api.g_ret_sts_unexp_error;

196: when others then
197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_QUESTIONS_TBH',
198: p_procedure_name => 'DELETE_ROW',
199: p_error_text => SUBSTRB(SQLERRM, 1, 240));
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: raise;
202:
203: END DELETE_ROW;
204: