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,
112: p_procedure_name => l_api_name
113: );
151:
152: ELSIF p_mode <> 'R' THEN
153:
154: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
155: Fnd_Msg_Pub.Add;
156: App_Exception.Raise_Exception;
157:
158: END IF;
159:
175:
176: IF SQL%NotFound THEN
177:
178: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
179: Fnd_Msg_Pub.Add;
180: App_Exception.Raise_Exception;
181:
182: END IF;
183:
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,
193: p_procedure_name => l_api_name
194: );
218:
219: IF SQL%NotFound THEN
220:
221: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
222: Fnd_Msg_Pub.Add;
223: App_Exception.Raise_Exception;
224:
225: END IF;
226:
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,
236: p_procedure_name => l_api_name
237: );