APPS.IGW_PROP_NARRATIVES_TBH dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 99: x_return_status := fnd_api.g_ret_sts_unexp_error;

95: when others then
96: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
97: p_procedure_name => 'INSERT_ROW',
98: p_error_text => SUBSTRB(SQLERRM, 1, 240));
99: x_return_status := fnd_api.g_ret_sts_unexp_error;
100: raise;
101:
102: END INSERT_ROW;
103: ----------------------------------------------------------------------------------------------------

Line 125: x_return_status := fnd_api.g_ret_sts_success;

121: l_last_updated_by NUMBER;
122: l_last_update_login NUMBER;
123:
124: BEGIN
125: x_return_status := fnd_api.g_ret_sts_success;
126:
127:
128: l_last_update_date := SYSDATE;
129: if(p_mode = 'I') then

Line 176: x_return_status := fnd_api.g_ret_sts_unexp_error;

172: when others then
173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
174: p_procedure_name => 'UPDATE_ROW',
175: p_error_text => SUBSTRB(SQLERRM, 1, 240));
176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177: raise;
178:
179: END UPDATE_ROW;
180:

Line 190: x_return_status := fnd_api.g_ret_sts_success;

186: x_return_status out NOCOPY VARCHAR2
187: ) is
188:
189: BEGIN
190: x_return_status := fnd_api.g_ret_sts_success;
191:
192: delete from IGW_PROP_NARRATIVES
193: where rowid = x_rowid
194: and record_version_number = p_record_version_number;

Line 208: x_return_status := fnd_api.g_ret_sts_unexp_error;

204: when others then
205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
206: p_procedure_name => 'DELETE_ROW',
207: p_error_text => SUBSTRB(SQLERRM, 1, 240));
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: raise;
210:
211: END DELETE_ROW;
212: