DBA Data[Home] [Help]

APPS.IGW_PROJECT_FUNDINGS_TBH dependencies on FND_API

Line 36: x_return_status := Fnd_Api.G_Ret_Sts_Success;

32: WHERE proposal_funding_id = x_proposal_funding_id;
33:
34: BEGIN
35:
36: x_return_status := Fnd_Api.G_Ret_Sts_Success;
37:
38: IF p_mode = 'I' THEN
39:
40: l_last_updated_by := 1;

Line 101: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

97: EXCEPTION
98:
99: WHEN others THEN
100:
101: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
102:
103: Fnd_Msg_Pub.Add_Exc_Msg
104: (
105: p_pkg_name => G_PKG_NAME,

Line 109: RAISE Fnd_Api.G_Exc_Unexpected_Error;

105: p_pkg_name => G_PKG_NAME,
106: p_procedure_name => l_api_name
107: );
108:
109: RAISE Fnd_Api.G_Exc_Unexpected_Error;
110:
111: END Insert_Row;
112:
113: ---------------------------------------------------------------------------

Line 136: x_return_status := Fnd_Api.G_Ret_Sts_Success;

132: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
133:
134: BEGIN
135:
136: x_return_status := Fnd_Api.G_Ret_Sts_Success;
137:
138: IF p_mode = 'I' THEN
139:
140: l_last_updated_by := 1;

Line 175: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

171: EXCEPTION
172:
173: WHEN others THEN
174:
175: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
176:
177: Fnd_Msg_Pub.Add_Exc_Msg
178: (
179: p_pkg_name => G_PKG_NAME,

Line 183: RAISE Fnd_Api.G_Exc_Unexpected_Error;

179: p_pkg_name => G_PKG_NAME,
180: p_procedure_name => l_api_name
181: );
182:
183: RAISE Fnd_Api.G_Exc_Unexpected_Error;
184:
185: END Update_Row;
186:
187: ---------------------------------------------------------------------------

Line 199: x_return_status := Fnd_Api.G_Ret_Sts_Success;

195: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
196:
197: BEGIN
198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Success;
200:
201: DELETE igw_project_fundings
202: WHERE rowid = p_rowid;
203:

Line 216: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

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

Line 224: RAISE Fnd_Api.G_Exc_Unexpected_Error;

220: p_pkg_name => G_PKG_NAME,
221: p_procedure_name => l_api_name
222: );
223:
224: RAISE Fnd_Api.G_Exc_Unexpected_Error;
225:
226: END Delete_Row;
227:
228: ---------------------------------------------------------------------------