APPS.IGW_SPONSOR_ACTION_TBH dependencies on FND_API

Line 71: x_return_status := Fnd_Api.G_Ret_Sts_Success;

67: trunc(last_update_date) = trunc(SYSDATE);
68:
69: BEGIN
70:
71: x_return_status := Fnd_Api.G_Ret_Sts_Success;
72:
73: IF p_mode = 'I' THEN
74:
75: l_last_updated_by := 1;

Line 132: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

128: EXCEPTION
129:
130: WHEN others THEN
131:
132: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
133:
134: Fnd_Msg_Pub.Add_Exc_Msg
135: (
136: p_pkg_name => G_PKG_NAME,

Line 140: RAISE Fnd_Api.G_Exc_Unexpected_Error;

136: p_pkg_name => G_PKG_NAME,
137: p_procedure_name => l_api_name
138: );
139:
140: RAISE Fnd_Api.G_Exc_Unexpected_Error;
141:
142: END Insert_Row;
143:
144: ---------------------------------------------------------------------------

Line 167: x_return_status := Fnd_Api.G_Ret_Sts_Success;

163: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
164:
165: BEGIN
166:
167: x_return_status := Fnd_Api.G_Ret_Sts_Success;
168:
169: IF p_mode = 'I' THEN
170:
171: l_last_updated_by := 1;

Line 208: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

204: EXCEPTION
205:
206: WHEN others THEN
207:
208: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
209:
210: Fnd_Msg_Pub.Add_Exc_Msg
211: (
212: p_pkg_name => G_PKG_NAME,

Line 216: RAISE Fnd_Api.G_Exc_Unexpected_Error;

212: p_pkg_name => G_PKG_NAME,
213: p_procedure_name => l_api_name
214: );
215:
216: RAISE Fnd_Api.G_Exc_Unexpected_Error;
217:
218: END Update_Row;
219:
220: ---------------------------------------------------------------------------

Line 234: x_return_status := Fnd_Api.G_Ret_Sts_Success;

230: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
231:
232: BEGIN
233:
234: x_return_status := Fnd_Api.G_Ret_Sts_Success;
235:
236: DELETE igw_prop_comments
237: WHERE rowid = p_rowid
238: AND record_version_number = p_record_version_number;

Line 254: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

250: EXCEPTION
251:
252: WHEN others THEN
253:
254: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
255:
256: Fnd_Msg_Pub.Add_Exc_Msg
257: (
258: p_pkg_name => G_PKG_NAME,

Line 262: RAISE Fnd_Api.G_Exc_Unexpected_Error;

258: p_pkg_name => G_PKG_NAME,
259: p_procedure_name => l_api_name
260: );
261:
262: RAISE Fnd_Api.G_Exc_Unexpected_Error;
263:
264: END Delete_Row;
265:
266: ---------------------------------------------------------------------------