APPS.IGW_INSTALLMENTS_TBH dependencies on FND_API

Line 43: x_return_status := Fnd_Api.G_Ret_Sts_Success;

39: WHERE proposal_installment_id = x_proposal_installment_id;
40:
41: BEGIN
42:
43: x_return_status := Fnd_Api.G_Ret_Sts_Success;
44:
45: IF p_mode = 'I' THEN
46:
47: l_last_updated_by := 1;

Line 122: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

118: EXCEPTION
119:
120: WHEN others THEN
121:
122: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
123:
124: Fnd_Msg_Pub.Add_Exc_Msg
125: (
126: p_pkg_name => G_PKG_NAME,

Line 130: RAISE Fnd_Api.G_Exc_Unexpected_Error;

126: p_pkg_name => G_PKG_NAME,
127: p_procedure_name => l_api_name
128: );
129:
130: RAISE Fnd_Api.G_Exc_Unexpected_Error;
131:
132: END Insert_Row;
133:
134: ---------------------------------------------------------------------------

Line 164: x_return_status := Fnd_Api.G_Ret_Sts_Success;

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

Line 209: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

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

Line 217: RAISE Fnd_Api.G_Exc_Unexpected_Error;

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

Line 233: x_return_status := Fnd_Api.G_Ret_Sts_Success;

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

Line 250: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

246: EXCEPTION
247:
248: WHEN others THEN
249:
250: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
251:
252: Fnd_Msg_Pub.Add_Exc_Msg
253: (
254: p_pkg_name => G_PKG_NAME,

Line 258: RAISE Fnd_Api.G_Exc_Unexpected_Error;

254: p_pkg_name => G_PKG_NAME,
255: p_procedure_name => l_api_name
256: );
257:
258: RAISE Fnd_Api.G_Exc_Unexpected_Error;
259:
260: END Delete_Row;
261:
262: ---------------------------------------------------------------------------