APPS.IGW_AWARDS_TBH dependencies on FND_API

Line 75: x_return_status := Fnd_Api.G_Ret_Sts_Success;

71: WHERE proposal_award_id = x_proposal_award_id;
72:
73: BEGIN
74:
75: x_return_status := Fnd_Api.G_Ret_Sts_Success;
76:
77: IF p_mode = 'I' THEN
78:
79: l_last_updated_by := 1;

Line 218: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

214: EXCEPTION
215:
216: WHEN others THEN
217:
218: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
219:
220: Fnd_Msg_Pub.Add_Exc_Msg
221: (
222: p_pkg_name => G_PKG_NAME,

Line 226: RAISE Fnd_Api.G_Exc_Unexpected_Error;

222: p_pkg_name => G_PKG_NAME,
223: p_procedure_name => l_api_name
224: );
225:
226: RAISE Fnd_Api.G_Exc_Unexpected_Error;
227:
228: END Insert_Row;
229:
230: ---------------------------------------------------------------------------

Line 292: x_return_status := Fnd_Api.G_Ret_Sts_Success;

288: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
289:
290: BEGIN
291:
292: x_return_status := Fnd_Api.G_Ret_Sts_Success;
293:
294: IF p_mode = 'I' THEN
295:
296: l_last_updated_by := 1;

Line 368: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

364: EXCEPTION
365:
366: WHEN others THEN
367:
368: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
369:
370: Fnd_Msg_Pub.Add_Exc_Msg
371: (
372: p_pkg_name => G_PKG_NAME,

Line 376: RAISE Fnd_Api.G_Exc_Unexpected_Error;

372: p_pkg_name => G_PKG_NAME,
373: p_procedure_name => l_api_name
374: );
375:
376: RAISE Fnd_Api.G_Exc_Unexpected_Error;
377:
378: END Update_Row;
379:
380: ---------------------------------------------------------------------------

Line 392: x_return_status := Fnd_Api.G_Ret_Sts_Success;

388: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
389:
390: BEGIN
391:
392: x_return_status := Fnd_Api.G_Ret_Sts_Success;
393:
394: DELETE igw_project_fundings
395: WHERE proposal_installment_id IN
396: ( SELECT proposal_installment_id

Line 410: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

406: EXCEPTION
407:
408: WHEN others THEN
409:
410: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
411:
412: Fnd_Msg_Pub.Add_Exc_Msg
413: (
414: p_pkg_name => G_PKG_NAME,

Line 418: RAISE Fnd_Api.G_Exc_Unexpected_Error;

414: p_pkg_name => G_PKG_NAME,
415: p_procedure_name => l_api_name
416: );
417:
418: RAISE Fnd_Api.G_Exc_Unexpected_Error;
419:
420: END Delete_Row;
421:
422: ---------------------------------------------------------------------------