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,
223: p_procedure_name => l_api_name
224: );
298:
299: ELSIF p_mode <> 'R' THEN
300:
301: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
302: Fnd_Msg_Pub.Add;
303: App_Exception.Raise_Exception;
304:
305: END IF;
306:
355:
356: IF SQL%NotFound THEN
357:
358: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
359: Fnd_Msg_Pub.Add;
360: App_Exception.Raise_Exception;
361:
362: END IF;
363:
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,
373: p_procedure_name => l_api_name
374: );
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,
415: p_procedure_name => l_api_name
416: );