133: --{ Local variables
134:
135: l_api_name CONSTANT VARCHAR2(30) := 'ADD_HISTORY';
136: l_api_version CONSTANT NUMBER := 1.0;
137: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
138: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' ||
139: l_api_name;
140:
141:
162:
163:
164: SAVEPOINT ADD_HISTORY_PUB;
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.push(l_module_name);
167: END IF;
168:
169: IF FND_API.to_Boolean( p_init_msg_list )
170: THEN
186:
187: SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;
188:
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting',WSH_DEBUG_SV.C_EXCEP_LEVEL);
191: END IF;
192:
193: dbms_output.put_line( ' Testing 1212 ' || p_delivery_leg_activity_rec.activity_type);
194:
255: --
256: --
257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.pop(l_module_name);
260: END IF;
261:
262: --}
263: EXCEPTION
271: p_data => x_msg_data,
272: p_encoded => FND_API.G_FALSE
273: );
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,'Error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name);
277: END IF;
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO ADD_HISTORY_PUB;
272: p_encoded => FND_API.G_FALSE
273: );
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,'Error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name);
277: END IF;
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO ADD_HISTORY_PUB;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: p_data => x_msg_data,
285: p_encoded => FND_API.G_FALSE
286: );
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.logmsg(l_module_name,'Unxepected Error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name);
290: END IF;
291: WHEN OTHERS THEN
292: ROLLBACK TO ADD_HISTORY_PUB;
285: p_encoded => FND_API.G_FALSE
286: );
287: IF l_debug_on THEN
288: WSH_DEBUG_SV.logmsg(l_module_name,'Unxepected Error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name);
290: END IF;
291: WHEN OTHERS THEN
292: ROLLBACK TO ADD_HISTORY_PUB;
293: wsh_util_core.default_handler('FTE_DELIVERY_ACTIVITY.ADD_HISTORY');
298: p_data => x_msg_data,
299: p_encoded => FND_API.G_FALSE
300: );
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'Other error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name);
304: END IF;
305: --}
306: END ADD_HISTORY;
299: p_encoded => FND_API.G_FALSE
300: );
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'Other error Occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name);
304: END IF;
305: --}
306: END ADD_HISTORY;
307: