APPS.IGW_PROP_SPECIAL_REVIEWS_TBH dependencies on FND_API

Line 41: x_return_status := Fnd_Api.G_Ret_Sts_Success;

37: special_review_code = p_special_review_code;
38:
39: BEGIN
40:
41: x_return_status := Fnd_Api.G_Ret_Sts_Success;
42:
43: IF p_mode = 'I' THEN
44:
45: l_last_updated_by := 1;

Line 107: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

103: EXCEPTION
104:
105: WHEN others THEN
106:
107: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
108:
109: Fnd_Msg_Pub.Add_Exc_Msg
110: (
111: p_pkg_name => G_PKG_NAME,

Line 115: RAISE Fnd_Api.G_Exc_Unexpected_Error;

111: p_pkg_name => G_PKG_NAME,
112: p_procedure_name => l_api_name
113: );
114:
115: RAISE Fnd_Api.G_Exc_Unexpected_Error;
116:
117: END Insert_Row;
118:
119: ---------------------------------------------------------------------------

Line 145: x_return_status := Fnd_Api.G_Ret_Sts_Success;

141: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
142:
143: BEGIN
144:
145: x_return_status := Fnd_Api.G_Ret_Sts_Success;
146:
147: IF p_mode = 'I' THEN
148:
149: l_last_updated_by := 1;

Line 188: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

184: EXCEPTION
185:
186: WHEN others THEN
187:
188: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
189:
190: Fnd_Msg_Pub.Add_Exc_Msg
191: (
192: p_pkg_name => G_PKG_NAME,

Line 196: RAISE Fnd_Api.G_Exc_Unexpected_Error;

192: p_pkg_name => G_PKG_NAME,
193: p_procedure_name => l_api_name
194: );
195:
196: RAISE Fnd_Api.G_Exc_Unexpected_Error;
197:
198: END Update_Row;
199:
200: ---------------------------------------------------------------------------

Line 213: x_return_status := Fnd_Api.G_Ret_Sts_Success;

209: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
210:
211: BEGIN
212:
213: x_return_status := Fnd_Api.G_Ret_Sts_Success;
214:
215: DELETE igw_prop_special_reviews
216: WHERE rowid = p_rowid
217: AND record_version_number = p_record_version_number;

Line 231: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

227: EXCEPTION
228:
229: WHEN others THEN
230:
231: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
232:
233: Fnd_Msg_Pub.Add_Exc_Msg
234: (
235: p_pkg_name => G_PKG_NAME,

Line 239: RAISE Fnd_Api.G_Exc_Unexpected_Error;

235: p_pkg_name => G_PKG_NAME,
236: p_procedure_name => l_api_name
237: );
238:
239: RAISE Fnd_Api.G_Exc_Unexpected_Error;
240:
241: END Delete_Row;
242:
243: ---------------------------------------------------------------------------