[Home] [Help]
41: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
42: --
43: IF l_debug_on IS NULL
44: THEN
45: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
46: END IF;
47: --
48: IF l_debug_on THEN
49: WSH_DEBUG_SV.push(l_module_name);
45: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
46: END IF;
47: --
48: IF l_debug_on THEN
49: WSH_DEBUG_SV.push(l_module_name);
50: END IF;
51: --
52: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
53:
190: --
191: -- Debug Statements
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.pop(l_module_name);
195: END IF;
196: --
197: EXCEPTION
198: WHEN create_failure THEN
202: --
203: -- Debug Statements
204: --
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
208: END IF;
209: --
210: END Create_Freight_Cost;
203: -- Debug Statements
204: --
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
208: END IF;
209: --
210: END Create_Freight_Cost;
211:
230: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
231: --
232: IF l_debug_on IS NULL
233: THEN
234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
235: END IF;
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
235: END IF;
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
240: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
241: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id ',p_freight_cost_info.freight_cost_id);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
242: WSH_DEBUG_SV.log(l_module_name,'freight_cost_type_id ',p_freight_cost_info.freight_cost_type_id);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
243: WSH_DEBUG_SV.log(l_module_name,'unit_amount ',p_freight_cost_info.unit_amount);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
244: WSH_DEBUG_SV.log(l_module_name,'calculation_method ',p_freight_cost_info.calculation_method);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
245: WSH_DEBUG_SV.log(l_module_name,'uom ',p_freight_cost_info.uom);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
246: WSH_DEBUG_SV.log(l_module_name,'quantity ',p_freight_cost_info.quantity);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
247: WSH_DEBUG_SV.log(l_module_name,'total_amount ',p_freight_cost_info.total_amount);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
248: WSH_DEBUG_SV.log(l_module_name,'currency_code ',p_freight_cost_info.currency_code);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
249: WSH_DEBUG_SV.log(l_module_name,'conversion_date ',p_freight_cost_info.conversion_date);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
250: WSH_DEBUG_SV.log(l_module_name,'conversion_rate ',p_freight_cost_info.conversion_rate);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
251: WSH_DEBUG_SV.log(l_module_name,'conversion_type_code ',p_freight_cost_info.conversion_type_code);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
252: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_freight_cost_info.trip_id);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
253: WSH_DEBUG_SV.log(l_module_name,'stop_id ',p_freight_cost_info.stop_id);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
254: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_freight_cost_info.delivery_id);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
255: WSH_DEBUG_SV.log(l_module_name,'delivery_leg_id ',p_freight_cost_info.delivery_leg_id);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
256: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id ',p_freight_cost_info.delivery_detail_id);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
257: WSH_DEBUG_SV.log(l_module_name,'attribute_category ',p_freight_cost_info.attribute_category);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
258: WSH_DEBUG_SV.log(l_module_name,'attribute1 ',p_freight_cost_info.attribute1);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
259: WSH_DEBUG_SV.log(l_module_name,'attribute2 ',p_freight_cost_info.attribute2);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
260: WSH_DEBUG_SV.log(l_module_name,'attribute3 ',p_freight_cost_info.attribute3);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
261: WSH_DEBUG_SV.log(l_module_name,'attribute4 ',p_freight_cost_info.attribute4);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
262: WSH_DEBUG_SV.log(l_module_name,'attribute5 ',p_freight_cost_info.attribute5);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
263: WSH_DEBUG_SV.log(l_module_name,'attribute6 ',p_freight_cost_info.attribute6);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
264: WSH_DEBUG_SV.log(l_module_name,'attribute7 ',p_freight_cost_info.attribute7);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
265: WSH_DEBUG_SV.log(l_module_name,'attribute8 ',p_freight_cost_info.attribute8);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
266: WSH_DEBUG_SV.log(l_module_name,'attribute9 ',p_freight_cost_info.attribute9);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
267: WSH_DEBUG_SV.log(l_module_name,'attribute10 ',p_freight_cost_info.attribute10);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
268: WSH_DEBUG_SV.log(l_module_name,'attribute11 ',p_freight_cost_info.attribute11);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
269: WSH_DEBUG_SV.log(l_module_name,'attribute12 ',p_freight_cost_info.attribute12);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
270: WSH_DEBUG_SV.log(l_module_name,'attribute13 ',p_freight_cost_info.attribute13);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
271: WSH_DEBUG_SV.log(l_module_name,'attribute14 ',p_freight_cost_info.attribute14);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
272: WSH_DEBUG_SV.log(l_module_name,'attribute15 ',p_freight_cost_info.attribute15);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
273: WSH_DEBUG_SV.log(l_module_name,'creation_date ',p_freight_cost_info.creation_date);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
274: WSH_DEBUG_SV.log(l_module_name,'created_by ',p_freight_cost_info.created_by);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
275: WSH_DEBUG_SV.log(l_module_name,'last_update_date ',p_freight_cost_info.last_update_date);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
276: WSH_DEBUG_SV.log(l_module_name,'last_updated_by ',p_freight_cost_info.last_updated_by);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
277: WSH_DEBUG_SV.log(l_module_name,'last_update_login ',p_freight_cost_info.last_update_login);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
278: WSH_DEBUG_SV.log(l_module_name,'program_application_id ',p_freight_cost_info.program_application_id);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
279: WSH_DEBUG_SV.log(l_module_name,'program_id ',p_freight_cost_info.program_id);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
280: WSH_DEBUG_SV.log(l_module_name,'program_update_date ',p_freight_cost_info.program_update_date);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
281: WSH_DEBUG_SV.log(l_module_name,'request_id ',p_freight_cost_info.request_id);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
282: WSH_DEBUG_SV.log(l_module_name,'pricing_list_header_id ',p_freight_cost_info.pricing_list_header_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
283: WSH_DEBUG_SV.log(l_module_name,'pricing_list_line_id ',p_freight_cost_info.pricing_list_line_id);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
284: WSH_DEBUG_SV.log(l_module_name,'applied_to_charge_id ',p_freight_cost_info.applied_to_charge_id);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
285: WSH_DEBUG_SV.log(l_module_name,'charge_unit_value ',p_freight_cost_info.charge_unit_value);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
286: WSH_DEBUG_SV.log(l_module_name,'charge_source_code ',p_freight_cost_info.charge_source_code);
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
294: END IF;
287: WSH_DEBUG_SV.log(l_module_name,'line_type_code ',p_freight_cost_info.line_type_code);
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
294: END IF;
295: --
288: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
294: END IF;
295: --
296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
289: WSH_DEBUG_SV.log(l_module_name,'estimated_flag ',p_freight_cost_info.estimated_flag);
290: WSH_DEBUG_SV.log(l_module_name,'commodity_category_id ',p_freight_cost_info.commodity_category_id);
291: WSH_DEBUG_SV.log(l_module_name,'billable_quantity',p_freight_cost_info.billable_quantity);
292: WSH_DEBUG_SV.log(l_module_name,'billable_uom',p_freight_cost_info.billable_uom);
293: WSH_DEBUG_SV.log(l_module_name,'billable_basis',p_freight_cost_info.billable_basis);
294: END IF;
295: --
296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
297:
360: --
361: -- Debug Statements
362: --
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.pop(l_module_name);
365: END IF;
366: --
367: EXCEPTION
368: WHEN OTHERS THEN
368: WHEN OTHERS THEN
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376: END Update_Freight_Cost;
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376: END Update_Freight_Cost;
377:
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376: END Update_Freight_Cost;
377:
378: PROCEDURE Lock_Freight_Cost(
458: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
459: --
460: IF l_debug_on IS NULL
461: THEN
462: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
463: END IF;
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.push(l_module_name);
462: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
463: END IF;
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.push(l_module_name);
467: --
468: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
469: END IF;
470: --
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.push(l_module_name);
467: --
468: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
469: END IF;
470: --
471: OPEN lock_row;
472: FETCH lock_row INTO Recinfo;
474: IF (lock_row%NOTFOUND) THEN
475: CLOSE lock_row;
476: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
477: IF l_debug_on THEN
478: WSH_DEBUG_SV.logmsg(l_module_name,'FORM_RECORD_DELETED Error has occured',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FORM_RECORD_DELETED');
480: END IF;
481: app_exception.raise_exception;
482: END IF;
475: CLOSE lock_row;
476: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
477: IF l_debug_on THEN
478: WSH_DEBUG_SV.logmsg(l_module_name,'FORM_RECORD_DELETED Error has occured',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FORM_RECORD_DELETED');
480: END IF;
481: app_exception.raise_exception;
482: END IF;
483:
618: --
619: -- Debug Statements
620: --
621: IF l_debug_on THEN
622: WSH_DEBUG_SV.pop(l_module_name);
623: END IF;
624: --
625: RETURN;
626: ELSE
625: RETURN;
626: ELSE
627: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.logmsg(l_module_name,'FORM_RECORD_DELETED Error has occured',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FORM_RECORD_CHANGED');
631: END IF;
632: app_exception.raise_exception;
633: END IF;
626: ELSE
627: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.logmsg(l_module_name,'FORM_RECORD_DELETED Error has occured',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FORM_RECORD_CHANGED');
631: END IF;
632: app_exception.raise_exception;
633: END IF;
634:
635: --
636: -- Debug Statements
637: --
638: IF l_debug_on THEN
639: WSH_DEBUG_SV.pop(l_module_name);
640: END IF;
641: --
642: EXCEPTION
643: WHEN others THEN
652: --
653: -- Debug Statements
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
658: END IF;
659: --
660: raise;
653: -- Debug Statements
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
658: END IF;
659: --
660: raise;
661:
662: --
663: -- Debug Statements
664: --
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.pop(l_module_name);
667: END IF;
668: --
669: END Lock_Freight_Cost;
670:
696: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
697: --
698: IF l_debug_on IS NULL
699: THEN
700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
701: END IF;
702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
701: END IF;
702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
707: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_ID',P_FREIGHT_COST_ID);
708: END IF;
702: --
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
707: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_ID',P_FREIGHT_COST_ID);
708: END IF;
709: --
710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.push(l_module_name);
705: --
706: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
707: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_ID',P_FREIGHT_COST_ID);
708: END IF;
709: --
710: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
711: l_freight_cost_id := p_freight_cost_id;
726: --
727: -- Debug Statements
728: --
729: IF l_debug_on THEN
730: WSH_DEBUG_SV.pop(l_module_name);
731: END IF;
732: --
733: EXCEPTION
734: WHEN others THEN
737: --
738: -- Debug Statements
739: --
740: IF l_debug_on THEN
741: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
742: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
743: END IF;
744: --
745: END Delete_Freight_Cost;
738: -- Debug Statements
739: --
740: IF l_debug_on THEN
741: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
742: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
743: END IF;
744: --
745: END Delete_Freight_Cost;
746:
832: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
833: --
834: IF l_debug_on IS NULL
835: THEN
836: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
837: END IF;
838: --
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.push(l_module_name);
836: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
837: END IF;
838: --
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.push(l_module_name);
841: --
842: WSH_DEBUG_SV.log(l_module_name,'P_FROM_FREIGHT_COST_ID',P_FROM_FREIGHT_COST_ID);
843: WSH_DEBUG_SV.log(l_module_name,'P_NEW_DELIVERY_DETAIL_ID',P_NEW_DELIVERY_DETAIL_ID);
844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
838: --
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.push(l_module_name);
841: --
842: WSH_DEBUG_SV.log(l_module_name,'P_FROM_FREIGHT_COST_ID',P_FROM_FREIGHT_COST_ID);
843: WSH_DEBUG_SV.log(l_module_name,'P_NEW_DELIVERY_DETAIL_ID',P_NEW_DELIVERY_DETAIL_ID);
844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
845: WSH_DEBUG_SV.log(l_module_name,'P_SPLIT_REQUESTED_QUANTITY',P_SPLIT_REQUESTED_QUANTITY);
846: END IF;
839: IF l_debug_on THEN
840: WSH_DEBUG_SV.push(l_module_name);
841: --
842: WSH_DEBUG_SV.log(l_module_name,'P_FROM_FREIGHT_COST_ID',P_FROM_FREIGHT_COST_ID);
843: WSH_DEBUG_SV.log(l_module_name,'P_NEW_DELIVERY_DETAIL_ID',P_NEW_DELIVERY_DETAIL_ID);
844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
845: WSH_DEBUG_SV.log(l_module_name,'P_SPLIT_REQUESTED_QUANTITY',P_SPLIT_REQUESTED_QUANTITY);
846: END IF;
847: --
840: WSH_DEBUG_SV.push(l_module_name);
841: --
842: WSH_DEBUG_SV.log(l_module_name,'P_FROM_FREIGHT_COST_ID',P_FROM_FREIGHT_COST_ID);
843: WSH_DEBUG_SV.log(l_module_name,'P_NEW_DELIVERY_DETAIL_ID',P_NEW_DELIVERY_DETAIL_ID);
844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
845: WSH_DEBUG_SV.log(l_module_name,'P_SPLIT_REQUESTED_QUANTITY',P_SPLIT_REQUESTED_QUANTITY);
846: END IF;
847: --
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
841: --
842: WSH_DEBUG_SV.log(l_module_name,'P_FROM_FREIGHT_COST_ID',P_FROM_FREIGHT_COST_ID);
843: WSH_DEBUG_SV.log(l_module_name,'P_NEW_DELIVERY_DETAIL_ID',P_NEW_DELIVERY_DETAIL_ID);
844: WSH_DEBUG_SV.log(l_module_name,'P_REQUESTED_QUANTITY',P_REQUESTED_QUANTITY);
845: WSH_DEBUG_SV.log(l_module_name,'P_SPLIT_REQUESTED_QUANTITY',P_SPLIT_REQUESTED_QUANTITY);
846: END IF;
847: --
848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
849:
865: --
866: -- Debug Statements
867: --
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FC_INTERFACE_PKG.ROUND_COST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;
871: --
872: WSH_FC_INTERFACE_PKG.Round_Cost_Amount(l_new_unit_amount, l_from_freight_cost_rec.CURRENCY_CODE, l_round_unit_amount, l_return_status);
873: -- round the unit_amount
922: l_new_freight_cost_rec.LINE_TYPE_CODE := l_from_freight_cost_rec.line_type_code ;
923: l_new_freight_cost_rec.ESTIMATED_FLAG := l_from_freight_cost_rec.estimated_flag ;
924: l_new_freight_cost_rec.commodity_category_id := l_from_freight_cost_rec.commodity_category_id ;
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Create_Freight_Cost',WSH_DEBUG_SV.C_PROC_LEVEL);
927: END IF;
928: Create_Freight_Cost(
929: p_freight_cost_info => l_new_freight_cost_rec
930: , x_rowid => l_rowid
945: --
946: -- Debug Statements
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.pop(l_module_name);
950: END IF;
951: --
952: EXCEPTION
953:
958: --
959: -- Debug Statements
960: --
961: IF l_debug_on THEN
962: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FC_NOT_FOUND');
964: END IF;
965: --
966: END Split_Freight_Cost;
959: -- Debug Statements
960: --
961: IF l_debug_on THEN
962: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FC_NOT_FOUND');
964: END IF;
965: --
966: END Split_Freight_Cost;
967:
1031: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1032: --
1033: IF l_debug_on IS NULL
1034: THEN
1035: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1036: END IF;
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1035: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1036: END IF;
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: END IF;
1041: --
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1043:
1117: --
1118: -- Debug Statements
1119: --
1120: IF l_debug_on THEN
1121: WSH_DEBUG_SV.pop(l_module_name);
1122: END IF;
1123: --
1124: EXCEPTION
1125:
1127: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1128:
1129: x_total_amount := NULL;
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Total_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1132: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Total_Freight_Cost FILURE');
1133: END IF;
1134:
1135: WHEN OTHERS THEN
1128:
1129: x_total_amount := NULL;
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Total_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1132: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Total_Freight_Cost FILURE');
1133: END IF;
1134:
1135: WHEN OTHERS THEN
1136:
1139: x_total_amount := NULL;
1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
1141:
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1144: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1146: END IF;
1147:
1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
1141:
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1144: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1146: END IF;
1147:
1148:
1141:
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1144: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1146: END IF;
1147:
1148:
1149: END Get_Total_Freight_Cost;
1194: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1195: --
1196: IF l_debug_on IS NULL
1197: THEN
1198: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1199: END IF;
1200: --
1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.push(l_module_name);
1198: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1199: END IF;
1200: --
1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.push(l_module_name);
1203: END IF;
1204: --
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1206:
1244:
1245: x_detail_amount := l_total_amount;
1246:
1247: IF l_debug_on THEN
1248: WSH_DEBUG_SV.log(l_module_name,'amounts detail: '||l_total_amount);
1249: END IF;
1250:
1251: --
1252: -- Debug Statements
1251: --
1252: -- Debug Statements
1253: --
1254: IF l_debug_on THEN
1255: WSH_DEBUG_SV.pop(l_module_name);
1256: END IF;
1257: --
1258: EXCEPTION
1259:
1261: CLOSE freight_cost_at_detail;
1262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1263: x_detail_amount := NULL;
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Detail_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Detail_Freight_Cost FILURE');
1267: END IF;
1268:
1269: WHEN OTHERS THEN
1262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1263: x_detail_amount := NULL;
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Detail_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Detail_Freight_Cost FILURE');
1267: END IF;
1268:
1269: WHEN OTHERS THEN
1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1271: x_detail_amount := NULL;
1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');
1273: IF l_debug_on THEN
1274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1276: END IF;
1277:
1278: END Get_Detail_Freight_Cost;
1271: x_detail_amount := NULL;
1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');
1273: IF l_debug_on THEN
1274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1276: END IF;
1277:
1278: END Get_Detail_Freight_Cost;
1279:
1332: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1333: --
1334: IF l_debug_on IS NULL
1335: THEN
1336: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1337: END IF;
1338: --
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.push(l_module_name);
1336: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1337: END IF;
1338: --
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.push(l_module_name);
1341: END IF;
1342: --
1343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1344:
1407: x_detail_amount := l_detail_amount;
1408: x_lpn_amount := l_lpn_amount;
1409:
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.log(l_module_name,'amounts main lpn, other lpn, detail: '||l_main_lpn_amount||', '||l_lpn_amount||', '||l_detail_amount);
1412: END IF;
1413:
1414: --
1415: -- Debug Statements
1414: --
1415: -- Debug Statements
1416: --
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.pop(l_module_name);
1419: END IF;
1420: --
1421: EXCEPTION
1422: WHEN details_freight_error THEN
1424: x_main_lpn_amount := NULL;
1425: x_lpn_amount := NULL;
1426: x_detail_amount := NULL;
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.logmsg(l_module_name,'Get_LPN_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1429: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_LPN_Freight_Cost FILURE');
1430: END IF;
1431: WHEN OTHERS THEN
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1425: x_lpn_amount := NULL;
1426: x_detail_amount := NULL;
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.logmsg(l_module_name,'Get_LPN_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1429: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_LPN_Freight_Cost FILURE');
1430: END IF;
1431: WHEN OTHERS THEN
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1433: x_main_lpn_amount := NULL;
1434: x_lpn_amount := NULL;
1435: x_detail_amount := NULL;
1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1440: END IF;
1441:
1442: END Get_LPN_Freight_Cost;
1435: x_detail_amount := NULL;
1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1440: END IF;
1441:
1442: END Get_LPN_Freight_Cost;
1443:
1518: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1519: --
1520: IF l_debug_on IS NULL
1521: THEN
1522: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1523: END IF;
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.push(l_module_name);
1522: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1523: END IF;
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.push(l_module_name);
1527: END IF;
1528: --
1529: --bugfix 6692716
1530: --l_container_flag_yes := 'Y'; -- BugFix3788678
1614: x_detail_amount := l_detail_amount;
1615: x_lpn_amount := l_lpn_amount;
1616:
1617: IF l_debug_on THEN
1618: WSH_DEBUG_SV.log(l_module_name,'amounts del, lpn, detail: '||l_total_amount||', '||l_lpn_amount||', '||l_detail_amount);
1619: END IF;
1620:
1621: --
1622: -- Debug Statements
1621: --
1622: -- Debug Statements
1623: --
1624: IF l_debug_on THEN
1625: WSH_DEBUG_SV.pop(l_module_name);
1626: END IF;
1627: --
1628: EXCEPTION
1629: WHEN details_freight_error THEN
1631: x_delivery_amount := NULL;
1632: x_lpn_amount := NULL;
1633: x_detail_amount := NULL;
1634: IF l_debug_on THEN
1635: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Delivery_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1637: END IF;
1638: WHEN convert_amount_error THEN
1639: CLOSE freight_cost_at_delivery;
1632: x_lpn_amount := NULL;
1633: x_detail_amount := NULL;
1634: IF l_debug_on THEN
1635: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Delivery_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1637: END IF;
1638: WHEN convert_amount_error THEN
1639: CLOSE freight_cost_at_delivery;
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1641: x_delivery_amount := NULL;
1642: x_lpn_amount := NULL;
1643: x_detail_amount := NULL;
1644: IF l_debug_on THEN
1645: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Delivery_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1647: END IF;
1648:
1649: WHEN OTHERS THEN
1642: x_lpn_amount := NULL;
1643: x_detail_amount := NULL;
1644: IF l_debug_on THEN
1645: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Delivery_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Delivery_Freight_Cost FILURE');
1647: END IF;
1648:
1649: WHEN OTHERS THEN
1650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1652: x_lpn_amount := NULL;
1653: x_detail_amount := NULL;
1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1658: END IF;
1659:
1660: END Get_Delivery_Freight_Cost;
1653: x_detail_amount := NULL;
1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1658: END IF;
1659:
1660: END Get_Delivery_Freight_Cost;
1661:
1720: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1721: --
1722: IF l_debug_on IS NULL
1723: THEN
1724: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1725: END IF;
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);
1724: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1725: END IF;
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.push(l_module_name);
1729: END IF;
1730: --
1731: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1732:
1773:
1774: x_stop_amount := l_total_amount;
1775:
1776: IF l_debug_on THEN
1777: WSH_DEBUG_SV.log(l_module_name,'amounts stop : '||l_total_amount);
1778: END IF;
1779:
1780: --
1781: -- Debug Statements
1780: --
1781: -- Debug Statements
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.pop(l_module_name);
1785: END IF;
1786: --
1787: EXCEPTION
1788:
1790: CLOSE freight_cost_at_stop;
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: x_stop_amount := NULL;
1793: IF l_debug_on THEN
1794: WSH_DEBUG_SV.logmsg(l_module_name,'Get_stop_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_stop_Freight_Cost FILURE');
1796: END IF;
1797:
1798: WHEN OTHERS THEN
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: x_stop_amount := NULL;
1793: IF l_debug_on THEN
1794: WSH_DEBUG_SV.logmsg(l_module_name,'Get_stop_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_stop_Freight_Cost FILURE');
1796: END IF;
1797:
1798: WHEN OTHERS THEN
1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1800: x_stop_amount := NULL;
1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1804: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1805: END IF;
1806:
1807: END Get_Stop_Freight_Cost;
1800: x_stop_amount := NULL;
1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1804: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1805: END IF;
1806:
1807: END Get_Stop_Freight_Cost;
1808:
1891: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1892: --
1893: IF l_debug_on IS NULL
1894: THEN
1895: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1896: END IF;
1897: --
1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.push(l_module_name);
1895: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1896: END IF;
1897: --
1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.push(l_module_name);
1900: END IF;
1901: --
1902: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1903:
1988: x_detail_amount := l_detail_amount;
1989: x_lpn_amount := l_lpn_amount;
1990:
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.log(l_module_name,'amounts trip, stop, del, lpn, detail: '||l_total_amount||', '||l_stop_amount||', '||l_delivery_amount||', '||l_lpn_amount||', '||l_detail_amount);
1993: END IF;
1994:
1995: --
1996: -- Debug Statements
1995: --
1996: -- Debug Statements
1997: --
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.pop(l_module_name);
2000: END IF;
2001: --
2002: EXCEPTION
2003: WHEN details_freight_error THEN
2007: x_stop_amount := NULL;
2008: x_lpn_amount := NULL;
2009: x_detail_amount := NULL;
2010: IF l_debug_on THEN
2011: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2012: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2013: END IF;
2014: WHEN convert_amount_error THEN
2015: CLOSE freight_cost_at_trip;
2008: x_lpn_amount := NULL;
2009: x_detail_amount := NULL;
2010: IF l_debug_on THEN
2011: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Freight_Cost exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2012: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2013: END IF;
2014: WHEN convert_amount_error THEN
2015: CLOSE freight_cost_at_trip;
2016: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2019: x_delivery_amount := NULL;
2020: x_lpn_amount := NULL;
2021: x_detail_amount := NULL;
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2025: END IF;
2026:
2027: WHEN OTHERS THEN
2020: x_lpn_amount := NULL;
2021: x_detail_amount := NULL;
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FILURE');
2025: END IF;
2026:
2027: WHEN OTHERS THEN
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2032: x_lpn_amount := NULL;
2033: x_detail_amount := NULL;
2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2038: END IF;
2039:
2040: END Get_Trip_Freight_Cost;
2033: x_detail_amount := NULL;
2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2038: END IF;
2039:
2040: END Get_Trip_Freight_Cost;
2041:
2086: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2087: --
2088: IF l_debug_on IS NULL
2089: THEN
2090: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2091: END IF;
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.push(l_module_name);
2090: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2091: END IF;
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.push(l_module_name);
2095: WSH_DEBUG_SV.log(l_module_name,'Entity, entity_id : '||p_entity_level||p_entity_id);
2096: END IF;
2097: --
2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2091: END IF;
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.push(l_module_name);
2095: WSH_DEBUG_SV.log(l_module_name,'Entity, entity_id : '||p_entity_level||p_entity_id);
2096: END IF;
2097: --
2098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2099: l_in_ids(1):=p_entity_id;
2138: x_return_status => l_return_status);
2139: END IF;
2140:
2141: IF l_debug_on THEN
2142: WSH_DEBUG_SV.log(l_module_name,'amounts trip, stop, del, main lpn, lpn, detail: '||l_trip_amount||', '||l_stop_amount||', '||l_delivery_amount||', '||l_main_lpn_amount||', '||l_lpn_amount||', '||l_detail_amount);
2143: END IF;
2144:
2145: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2146: raise total_freight_error;
2158: --
2159: -- Debug Statements
2160: --
2161: IF l_debug_on THEN
2162: WSH_DEBUG_SV.pop(l_module_name);
2163: END IF;
2164: --
2165: EXCEPTION
2166:
2171: x_delivery_amount := NULL;
2172: x_lpn_amount := NULL;
2173: x_detail_amount := NULL;
2174: IF l_debug_on THEN
2175: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Total_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2176: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Total_Freight_Cost FILURE');
2177: END IF;
2178:
2179: WHEN OTHERS THEN
2172: x_lpn_amount := NULL;
2173: x_detail_amount := NULL;
2174: IF l_debug_on THEN
2175: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Total_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2176: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Total_Freight_Cost FILURE');
2177: END IF;
2178:
2179: WHEN OTHERS THEN
2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2185: x_detail_amount := NULL;
2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2190: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2192: END IF;
2193:
2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2190: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2192: END IF;
2193:
2194:
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2190: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2192: END IF;
2193:
2194:
2195: END Get_Total_Freight_Cost;
2262: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2263: --
2264: IF l_debug_on IS NULL
2265: THEN
2266: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2267: END IF;
2268: --
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.push(l_module_name);
2266: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2267: END IF;
2268: --
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.push(l_module_name);
2271: END IF;
2272: --
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2274: x_total_amount := 0;
2324: --
2325: -- Debug Statements
2326: --
2327: IF l_debug_on THEN
2328: WSH_DEBUG_SV.pop(l_module_name);
2329: END IF;
2330: --
2331: EXCEPTION
2332:
2333: WHEN convert_amount_error THEN
2334: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2335:
2336: IF l_debug_on THEN
2337: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Summary_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2338: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Summary_Freight_Cost FILURE');
2339: END IF;
2340:
2341: WHEN OTHERS THEN
2334: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2335:
2336: IF l_debug_on THEN
2337: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Summary_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2338: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Summary_Freight_Cost FILURE');
2339: END IF;
2340:
2341: WHEN OTHERS THEN
2342:
2343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2348: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2350: END IF;
2351:
2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2348: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2350: END IF;
2351:
2352:
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2348: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2350: END IF;
2351:
2352:
2353: END Get_Summary_Freight_Cost;
2381: BEGIN
2382:
2383: --
2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.push(l_module_name);
2386: END IF;
2387: --
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2389:
2390: IF p_amount = 0 THEN
2391: x_converted_amount := 0;
2392: ELSIF p_from_currency = p_to_currency THEN
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.logmsg(l_module_name,'From currency is same as to currency ',WSH_DEBUG_SV.C_PROC_LEVEL);
2395: END IF;
2396: x_converted_amount := p_amount;
2397:
2398: ELSE
2402: --
2403: -- Debug Statements
2404: --
2405: IF l_debug_on THEN
2406: WSH_DEBUG_SV.logmsg(l_module_name, 'Convert' ||p_from_currency||' to '||p_to_currency ||' using fixed rate' );
2407: END IF;
2408:
2409: BEGIN
2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2410: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2411: EXCEPTION
2412: WHEN GL_CURRENCY_API.no_rate THEN
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2415: END IF;
2416: RAISE WSH_NO_RATE;
2417:
2418: WHEN GL_CURRENCY_API.invalid_currency THEN
2416: RAISE WSH_NO_RATE;
2417:
2418: WHEN GL_CURRENCY_API.invalid_currency THEN
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: END IF;
2422: RAISE WSH_INVALID_CURRENCY;
2423:
2424: WHEN others THEN
2422: RAISE WSH_INVALID_CURRENCY;
2423:
2424: WHEN others THEN
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2427: END IF;
2428: RAISE WSH_CONVERT_ERROR;
2429: END;
2430:
2433: --
2434: -- Debug Statements
2435: --
2436: IF l_debug_on THEN
2437: WSH_DEBUG_SV.logmsg(l_module_name, 'Convert amount using user specified rate: ' || to_char(p_conversion_rate) , WSH_DEBUG_SV.C_EXCEP_LEVEL);
2438: END IF;
2439: --
2440: IF p_conversion_rate IS NULL THEN
2441: IF l_debug_on THEN
2438: END IF;
2439: --
2440: IF p_conversion_rate IS NULL THEN
2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.logmsg(l_module_name, 'Conversion Rate is NULL',WSH_DEBUG_SV.C_EXCEP_LEVEL );
2443: END IF;
2444: RAISE WSH_NO_RATE;
2445:
2446: END IF;
2449: --
2450: -- Debug Statements
2451: --
2452: IF l_debug_on THEN
2453: WSH_DEBUG_SV.logmsg(l_module_name, 'Conversion_type is user but no conversion_rate specified, convert_amount failed' );
2454: END IF;
2455:
2456: RAISE WSH_CONVERT_ERROR;
2457: END IF;
2460: --
2461: -- Debug Statements
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.RATE_EXISTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: l_rate_exists := GL_CURRENCY_API.Rate_Exists(
2468: x_from_currency => p_from_currency,
2474: --
2475: -- Debug Statements
2476: --
2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.logmsg(l_module_name, 'Convert amount using floating rate decided by conversion date' || to_char( p_conversion_date) );
2479: END IF;
2480: BEGIN
2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2482: EXCEPTION
2481: x_converted_amount := GL_CURRENCY_API.convert_amount(p_from_currency, p_to_currency, p_conversion_date, p_conversion_type, p_amount);
2482: EXCEPTION
2483: WHEN GL_CURRENCY_API.no_rate THEN
2484: IF l_debug_on THEN
2485: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2486: END IF;
2487: RAISE WSH_NO_RATE;
2488:
2489: WHEN GL_CURRENCY_API.invalid_currency THEN
2487: RAISE WSH_NO_RATE;
2488:
2489: WHEN GL_CURRENCY_API.invalid_currency THEN
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2492: END IF;
2493: RAISE WSH_INVALID_CURRENCY;
2494:
2495: WHEN others THEN
2493: RAISE WSH_INVALID_CURRENCY;
2494:
2495: WHEN others THEN
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2498: END IF;
2499: RAISE WSH_CONVERT_ERROR;
2500: END;
2501: ELSE
2502: --
2503: -- Debug Statements
2504: --
2505: IF l_debug_on THEN
2506: WSH_DEBUG_SV.logmsg(l_module_name, 'No rate exists , convert to closest amount , conversion date:'|| to_char ( p_conversion_date ) );
2507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2508: END IF;
2509: --
2510: BEGIN
2503: -- Debug Statements
2504: --
2505: IF l_debug_on THEN
2506: WSH_DEBUG_SV.logmsg(l_module_name, 'No rate exists , convert to closest amount , conversion date:'|| to_char ( p_conversion_date ) );
2507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT',WSH_DEBUG_SV.C_PROC_LEVEL);
2508: END IF;
2509: --
2510: BEGIN
2511: GL_CURRENCY_API.convert_closest_amount(
2521: x_numerator => l_numerator,
2522: x_rate => l_rate);
2523:
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Converted amount from GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT is: '|| to_char(x_converted_amount),WSH_DEBUG_SV.C_PROC_LEVEL);
2526: END IF;
2527: EXCEPTION
2528: WHEN GL_CURRENCY_API.no_rate THEN
2529: IF l_debug_on THEN
2526: END IF;
2527: EXCEPTION
2528: WHEN GL_CURRENCY_API.no_rate THEN
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) no rate ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2531: END IF;
2532: RAISE WSH_NO_RATE;
2533:
2534: WHEN GL_CURRENCY_API.invalid_currency THEN
2532: RAISE WSH_NO_RATE;
2533:
2534: WHEN GL_CURRENCY_API.invalid_currency THEN
2535: IF l_debug_on THEN
2536: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( ) invalid currency',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2537: END IF;
2538: RAISE WSH_INVALID_CURRENCY;
2539:
2540: WHEN others THEN
2538: RAISE WSH_INVALID_CURRENCY;
2539:
2540: WHEN others THEN
2541: IF l_debug_on THEN
2542: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in GL_CURRENCY_API.Convert_Closest_Amount( )',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2543: END IF;
2544: RAISE WSH_CONVERT_ERROR;
2545: END;
2546: END IF;
2551: --
2552: -- Debug Statements
2553: --
2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.pop(l_module_name);
2556: END IF;
2557: --
2558:
2559:
2562: WHEN WSH_NO_RATE THEN
2563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2564: x_converted_amount := NULL;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. No convertion rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2567: WSH_DEBUG_SV.pop(l_module_name);
2568: END IF;
2569: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2570: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2564: x_converted_amount := NULL;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. No convertion rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2567: WSH_DEBUG_SV.pop(l_module_name);
2568: END IF;
2569: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2570: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2571: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2574: WHEN WSH_INVALID_CURRENCY THEN
2575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2576: x_converted_amount := NULL;
2577: IF l_debug_on THEN
2578: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. Invalid currency.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2579: WSH_DEBUG_SV.pop(l_module_name);
2580: END IF;
2581: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_INVALID_CURRENCY');
2582: WSH_UTIL_CORE.Add_Message(x_return_status);
2575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2576: x_converted_amount := NULL;
2577: IF l_debug_on THEN
2578: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured. Invalid currency.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2579: WSH_DEBUG_SV.pop(l_module_name);
2580: END IF;
2581: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_INVALID_CURRENCY');
2582: WSH_UTIL_CORE.Add_Message(x_return_status);
2583:
2584: WHEN WSH_CONVERT_ERROR THEN
2585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2586: x_converted_amount := NULL;
2587: IF l_debug_on THEN
2588: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2589: WSH_DEBUG_SV.pop(l_module_name);
2590: END IF;
2591: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2592: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2586: x_converted_amount := NULL;
2587: IF l_debug_on THEN
2588: WSH_DEBUG_SV.logmsg(l_module_name,'Convert_Amount exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2589: WSH_DEBUG_SV.pop(l_module_name);
2590: END IF;
2591: FND_MESSAGE.Set_Name('WSH', 'WSH_FC_NO_RATE');
2592: FND_MESSAGE.Set_Token('FROM_CURRENCY', p_from_currency);
2593: FND_MESSAGE.Set_Token('TO_CURRENCY', p_to_currency);
2596: WHEN others THEN
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2598: x_converted_amount := NULL;
2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2601: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2602: END IF;
2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');
2604:
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2598: x_converted_amount := NULL;
2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2601: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2602: END IF;
2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');
2604:
2605: END Convert_Amount;
2640: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2641: --
2642: IF l_debug_on IS NULL
2643: THEN
2644: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2645: END IF;
2646: --
2647: IF l_debug_on THEN
2648: WSH_DEBUG_SV.push(l_module_name);
2644: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2645: END IF;
2646: --
2647: IF l_debug_on THEN
2648: WSH_DEBUG_SV.push(l_module_name);
2649: END IF;
2650:
2651: FOR i in p_delivery_details_tab.FIRST .. p_delivery_details_tab.LAST
2652: LOOP
2650:
2651: FOR i in p_delivery_details_tab.FIRST .. p_delivery_details_tab.LAST
2652: LOOP
2653: IF l_debug_on THEN
2654: WSH_DEBUG_SV.log(l_module_name,'Removing FTE Freight Costs for Delivery Detail: '|| p_delivery_details_tab(i));
2655: END IF;
2656:
2657: OPEN get_freight_costs(p_delivery_details_tab(i));
2658: FETCH get_freight_costs into l_freight_costs_exist ;
2664: FETCH lock_freight_costs INTO l_freight_cost_id;
2665: EXIT WHEN lock_freight_costs%NOTFOUND;
2666: DELETE wsh_freight_costs WHERE freight_cost_id = l_freight_cost_id;
2667: IF l_debug_on THEN
2668: WSH_DEBUG_SV.log(l_module_name,'Removed FTE Freight Costs ID: '|| l_freight_cost_id);
2669: END IF;
2670: END LOOP;
2671: CLOSE lock_freight_costs;
2672: END IF;
2673: CLOSE get_freight_costs;
2674: END LOOP;
2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.pop(l_module_name);
2678: END IF;
2679: EXCEPTION
2680:
2681: WHEN OTHERS THEN
2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);
2685: ROLLBACK TO before_delete;
2686: --
2687: IF l_debug_on THEN
2688: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock the fright cost records '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2691: END IF;
2692:
2685: ROLLBACK TO before_delete;
2686: --
2687: IF l_debug_on THEN
2688: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock the fright cost records '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2691: END IF;
2692:
2693:
2686: --
2687: IF l_debug_on THEN
2688: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock the fright cost records '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2691: END IF;
2692:
2693:
2694: END Remove_FTE_Freight_Costs;
2740: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2741: --
2742: IF l_debug_on IS NULL
2743: THEN
2744: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2745: END IF;
2746: --
2747: IF l_debug_on THEN
2748: WSH_DEBUG_SV.push(l_module_name);
2744: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2745: END IF;
2746: --
2747: IF l_debug_on THEN
2748: WSH_DEBUG_SV.push(l_module_name);
2749: END IF;
2750: --
2751: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2752:
2789:
2790: x_trip_amount:=l_total_amount;
2791:
2792: IF l_debug_on THEN
2793: WSH_DEBUG_SV.log(l_module_name,'Manual freight cost at trip : '||l_total_amount);
2794: END IF;
2795: --
2796: -- Debug Statements
2797: --
2795: --
2796: -- Debug Statements
2797: --
2798: IF l_debug_on THEN
2799: WSH_DEBUG_SV.pop(l_module_name);
2800: END IF;
2801: --
2802: EXCEPTION
2803: WHEN convert_amount_error THEN
2804: CLOSE freight_cost_at_trip;
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2806: x_trip_amount := NULL;
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Manual_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2809: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FAILURE');
2810: END IF;
2811:
2812: WHEN OTHERS THEN
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2806: x_trip_amount := NULL;
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Trip_Manual_Freight_Cost exception has occured. No user rate specified.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2809: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Get_Trip_Freight_Cost FAILURE');
2810: END IF;
2811:
2812: WHEN OTHERS THEN
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2814: x_trip_amount := NULL;
2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2819: END IF;
2820:
2821: END Get_Trip_Manual_Freight_Cost;
2814: x_trip_amount := NULL;
2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2819: END IF;
2820:
2821: END Get_Trip_Manual_Freight_Cost;
2822: