87: WHEN others THEN
88:
89: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
90:
91: Fnd_Msg_Pub.Add_Exc_Msg
92: (
93: p_pkg_name => G_PKG_NAME,
94: p_procedure_name => l_api_name
95: );
128:
129: ELSIF p_mode <> 'R' THEN
130:
131: Fnd_Message.Set_Name('FND','SYSTEM-INVALID ARGS');
132: Fnd_Msg_Pub.Add;
133: App_Exception.Raise_Exception;
134:
135: END IF;
136:
146:
147: IF SQL%NotFound THEN
148:
149: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
150: Fnd_Msg_Pub.Add;
151: App_Exception.Raise_Exception;
152:
153: END IF;
154:
157: WHEN others THEN
158:
159: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
160:
161: Fnd_Msg_Pub.Add_Exc_Msg
162: (
163: p_pkg_name => G_PKG_NAME,
164: p_procedure_name => l_api_name
165: );
189:
190: IF SQL%NotFound THEN
191:
192: Fnd_Message.Set_Name('IGW','IGW_SS_RECORD_CHANGED');
193: Fnd_Msg_Pub.Add;
194: App_Exception.Raise_Exception;
195:
196: END IF;
197:
200: WHEN others THEN
201:
202: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
203:
204: Fnd_Msg_Pub.Add_Exc_Msg
205: (
206: p_pkg_name => G_PKG_NAME,
207: p_procedure_name => l_api_name
208: );