APPS.IGW_PROP_USER_ROLES_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 82: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 103: x_return_status := fnd_api.g_ret_sts_success;

99: l_last_updated_by NUMBER;
100: l_last_update_login NUMBER;
101:
102: BEGIN
103: x_return_status := fnd_api.g_ret_sts_success;
104:
105:
106: l_last_update_date := SYSDATE;
107: if(p_mode = 'I') then

Line 149: x_return_status := fnd_api.g_ret_sts_unexp_error;

145: when others then
146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',
147: p_procedure_name => 'UPDATE_ROW',
148: p_error_text => SUBSTRB(SQLERRM, 1, 240));
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: raise;
151:
152: END UPDATE_ROW;
153: ----------------------------------------------------------------------------------------------------

Line 162: x_return_status := fnd_api.g_ret_sts_success;

158: x_return_status out NOCOPY VARCHAR2
159: ) is
160:
161: BEGIN
162: x_return_status := fnd_api.g_ret_sts_success;
163:
164: delete from IGW_PROP_USER_ROLES
165: where rowid = x_rowid
166: and record_version_number = p_record_version_number;

Line 180: x_return_status := fnd_api.g_ret_sts_unexp_error;

176: when others then
177: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_USER_ROLES_TBH',
178: p_procedure_name => 'DELETE_ROW',
179: p_error_text => SUBSTRB(SQLERRM, 1, 240));
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: raise;
182:
183: END DELETE_ROW;
184: ------------------------------------------------------------------------------------------------------