APPS.IGW_PROP_USERS_TBH dependencies on FND_API

Line 23: x_return_status := FND_API.G_RET_STS_SUCCESS;

19: l_last_updated_by NUMBER;
20: l_last_update_login NUMBER;
21:
22: BEGIN
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: l_last_update_date := SYSDATE;
26:
27: if(p_mode = 'I') then

Line 84: x_return_status := fnd_api.g_ret_sts_unexp_error;

80: when others then
81: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
82: p_procedure_name => 'INSERT_ROW',
83: p_error_text => SUBSTRB(SQLERRM, 1, 240));
84: x_return_status := fnd_api.g_ret_sts_unexp_error;
85: raise;
86:
87: END INSERT_ROW;
88: ----------------------------------------------------------------------------------------------------

Line 106: x_return_status := fnd_api.g_ret_sts_success;

102: l_last_updated_by NUMBER;
103: l_last_update_login NUMBER;
104:
105: BEGIN
106: x_return_status := fnd_api.g_ret_sts_success;
107:
108: l_last_update_date := SYSDATE;
109: if (p_mode = 'I') then
110: l_last_updated_by := 1;

Line 153: x_return_status := fnd_api.g_ret_sts_unexp_error;

149: when others then
150: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
151: p_procedure_name => 'UPDATE_ROW',
152: p_error_text => SUBSTRB(SQLERRM, 1, 240));
153: x_return_status := fnd_api.g_ret_sts_unexp_error;
154: raise;
155:
156: END UPDATE_ROW;
157: ----------------------------------------------------------------------------------------------------

Line 166: x_return_status := fnd_api.g_ret_sts_success;

162: x_return_status out NOCOPY VARCHAR2
163: ) is
164:
165: BEGIN
166: x_return_status := fnd_api.g_ret_sts_success;
167:
168: delete from IGW_PROP_USERS
169: where rowid = x_rowid
170: and record_version_number = p_record_version_number;

Line 184: x_return_status := fnd_api.g_ret_sts_unexp_error;

180: when others then
181: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USERS_TBH',
182: p_procedure_name => 'DELETE_ROW',
183: p_error_text => SUBSTRB(SQLERRM, 1, 240));
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: raise;
186:
187: END DELETE_ROW;
188: ------------------------------------------------------------------------------------------------------