41: WHEN no_data_found THEN
42:
43: x_return_status := Fnd_Api.G_Ret_Sts_Error;
44: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
45: Fnd_Msg_Pub.Add;
46:
47: WHEN others THEN
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
47: WHEN others THEN
48:
49: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
50:
51: Fnd_Msg_Pub.Add_Exc_Msg
52: (
53: p_pkg_name => G_PKG_NAME,
54: p_procedure_name => l_api_name
55: );
158: x_return_status := Fnd_Api.G_Ret_Sts_Success;
159:
160: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
161:
162: Fnd_Msg_Pub.Initialize;
163:
164: END IF;
165:
166:
181: );
182:
183: END IF;
184:
185: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
186:
187: RAISE Fnd_Api.G_Exc_Error;
188:
189: END IF;
203: = 'N' THEN
204:
205: x_return_status := Fnd_Api.G_Ret_Sts_Error;
206: Fnd_Message.Set_Name('IGW','IGW_SS_SEC_NO_MODIFY_RIGHTS');
207: Fnd_Msg_Pub.Add;
208: RAISE Fnd_Api.G_Exc_Error;
209:
210: END IF;
211:
209:
210: END IF;
211:
212: */
213: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
214:
215: RAISE Fnd_Api.G_Exc_Error;
216:
217: END IF;
234: ** the earlier stages
235: */
236:
237:
238: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
239:
240: RAISE Fnd_Api.G_Exc_Error;
241:
242: END IF;
266: ** Discontinue processing if any error has been encountered during
267: ** the earlier stages
268: */
269:
270: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
271:
272: RAISE Fnd_Api.G_Exc_Error;
273:
274: END IF;
335: ROLLBACK TO Update_Prop_Abstract_Pvt;
336:
337: x_return_status := Fnd_Api.G_Ret_Sts_Error;
338:
339: Fnd_Msg_Pub.Count_And_Get
340: (
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );
347: ROLLBACK TO Update_Prop_Abstract_Pvt;
348:
349: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
350:
351: Fnd_Msg_Pub.Count_And_Get
352: (
353: p_count => x_msg_count,
354: p_data => x_msg_data
355: );
359: ROLLBACK TO Update_Prop_Abstract_Pvt;
360:
361: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
362:
363: Fnd_Msg_Pub.Add_Exc_Msg
364: (
365: p_pkg_name => G_PKG_NAME,
366: p_procedure_name => l_api_name
367: );
365: p_pkg_name => G_PKG_NAME,
366: p_procedure_name => l_api_name
367: );
368:
369: Fnd_Msg_Pub.Count_And_Get
370: (
371: p_count => x_msg_count,
372: p_data => x_msg_data
373: );