eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_INTEGRATION dependencies on WSH_DEBUG_SV

Line 38: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

34: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
35: --
36: IF l_debug_on IS NULL
37: THEN
38: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
39: END IF;
40: --
41: IF l_debug_on THEN
42: WSH_DEBUG_SV.push(l_module_name);

Line 42: WSH_DEBUG_SV.push(l_module_name);

38: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
39: END IF;
40: --
41: IF l_debug_on THEN
42: WSH_DEBUG_SV.push(l_module_name);
43: --
44: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

Line 44: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);

40: --
41: IF l_debug_on THEN
42: WSH_DEBUG_SV.push(l_module_name);
43: --
44: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
47: END IF;
48: --

Line 45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);

41: IF l_debug_on THEN
42: WSH_DEBUG_SV.push(l_module_name);
43: --
44: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
47: END IF;
48: --
49: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

42: WSH_DEBUG_SV.push(l_module_name);
43: --
44: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
47: END IF;
48: --
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: SAVEPOINT WSH_Rate_Delivery;

Line 57: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.RATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

53: ((p_in_param_rec.delivery_id_list.COUNT > 0) AND p_in_param_rec.action is NOT null) THEN
54:
55: --
56: IF l_debug_on THEN
57: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.RATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
58: END IF;
59: --
60:
61: l_in_param_rec.delivery_id_list := p_in_param_rec.delivery_id_list;

Line 84: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

80: x_out_param_rec.failed_delivery_id_list := l_out_param_rec.failed_delivery_id_list;
81: END IF;
82: --
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
85: WSH_DEBUG_SV.pop(l_module_name);
86: END IF;
87: --
88: EXCEPTION

Line 85: WSH_DEBUG_SV.pop(l_module_name);

81: END IF;
82: --
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
85: WSH_DEBUG_SV.pop(l_module_name);
86: END IF;
87: --
88: EXCEPTION
89: WHEN others THEN

Line 95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

91: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
96: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
97: END IF;
98: --
99: END Rate_Delivery;

Line 96: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
96: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
97: END IF;
98: --
99: END Rate_Delivery;
100:

Line 130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

126: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
127: --
128: IF l_debug_on IS NULL
129: THEN
130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
131: END IF;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);

Line 134: WSH_DEBUG_SV.push(l_module_name);

130: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
131: END IF;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);

Line 136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);

132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

Line 137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);

133: IF l_debug_on THEN
134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
141: END IF;

Line 138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);

134: WSH_DEBUG_SV.push(l_module_name);
135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
141: END IF;
142: --

Line 139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);

135: --
136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
141: END IF;
142: --
143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

136: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LIST.COUNT',p_delivery_list.COUNT);
137: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
138: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
141: END IF;
142: --
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144: SAVEPOINT WSH_Cancel_Service;

Line 151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.CANCEL_SERVICE',WSH_DEBUG_SV.C_PROC_LEVEL);

147: (p_delivery_list.COUNT > 0 AND p_action is NOT null) THEN
148:
149: --
150: IF l_debug_on THEN
151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.CANCEL_SERVICE',WSH_DEBUG_SV.C_PROC_LEVEL);
152: END IF;
153: --
154:
155: FTE_FREIGHT_RATING_DLVY_GRP.Cancel_Service (

Line 173: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

169: x_msg_data := l_msg_data;
170: END IF;
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
174: WSH_DEBUG_SV.pop(l_module_name);
175: END IF;
176: --
177: EXCEPTION

Line 174: WSH_DEBUG_SV.pop(l_module_name);

170: END IF;
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
174: WSH_DEBUG_SV.pop(l_module_name);
175: END IF;
176: --
177: EXCEPTION
178: WHEN others THEN

Line 184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
186: END IF;
187: --
188: END Cancel_Service;

Line 185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
186: END IF;
187: --
188: END Cancel_Service;
189:

Line 218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

214: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
215: --
216: IF l_debug_on IS NULL
217: THEN
218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
219: END IF;
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);

Line 222: WSH_DEBUG_SV.push(l_module_name);

218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
219: END IF;
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);

Line 224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);

220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

Line 225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);

221: IF l_debug_on THEN
222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
229: END IF;

Line 226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);

222: WSH_DEBUG_SV.push(l_module_name);
223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
229: END IF;
230: --

Line 227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);

223: --
224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
229: END IF;
230: --
231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);

224: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',p_delivery_id);
225: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',p_action);
226: WSH_DEBUG_SV.log(l_module_name,'P_API_VERION',p_api_version);
227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
229: END IF;
230: --
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: SAVEPOINT WSH_Cancel_Service_2;

Line 239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.CANCEL_SERVICE',WSH_DEBUG_SV.C_PROC_LEVEL);

235: (p_delivery_id is NOT null AND p_action is NOT null) THEN
236:
237: --
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_DLVY_GRP.CANCEL_SERVICE',WSH_DEBUG_SV.C_PROC_LEVEL);
240: END IF;
241: --
242:
243: FTE_FREIGHT_RATING_DLVY_GRP.Cancel_Service (

Line 261: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

257: x_msg_data := l_msg_data;
258: END IF;
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
262: WSH_DEBUG_SV.pop(l_module_name);
263: END IF;
264: --
265: EXCEPTION

Line 262: WSH_DEBUG_SV.pop(l_module_name);

258: END IF;
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
262: WSH_DEBUG_SV.pop(l_module_name);
263: END IF;
264: --
265: EXCEPTION
266: WHEN others THEN

Line 272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
273: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
274: END IF;
275: --
276: END Cancel_Service;

Line 273: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
273: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
274: END IF;
275: --
276: END Cancel_Service;
277:

Line 301: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

297: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
298: --
299: IF l_debug_on IS NULL
300: THEN
301: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
302: END IF;
303: --
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.push(l_module_name);

Line 305: WSH_DEBUG_SV.push(l_module_name);

301: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
302: END IF;
303: --
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.push(l_module_name);
306: --
307: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LEG_ID',P_DELIVERY_LEG_ID);
308: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
309: END IF;

Line 307: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LEG_ID',P_DELIVERY_LEG_ID);

303: --
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.push(l_module_name);
306: --
307: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LEG_ID',P_DELIVERY_LEG_ID);
308: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
309: END IF;
310: --
311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 308: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

304: IF l_debug_on THEN
305: WSH_DEBUG_SV.push(l_module_name);
306: --
307: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LEG_ID',P_DELIVERY_LEG_ID);
308: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
309: END IF;
310: --
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: SAVEPOINT before_changes;

Line 322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_PRICING.SHIPMENT_PRICE_CONSOLIDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

318: l_in_attributes.delivery_leg_id := p_delivery_leg_id;
319: l_in_attributes.segment_id := p_trip_id;
320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_PRICING.SHIPMENT_PRICE_CONSOLIDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
323: END IF;
324: --
325: FTE_FREIGHT_PRICING.shipment_price_consolidate (
326: p_init_msg_list => fnd_api.g_false,

Line 337: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

333: END IF;
334: END IF;
335: --
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
338: WSH_DEBUG_SV.pop(l_module_name);
339: END IF;
340: --
341: EXCEPTION

Line 338: WSH_DEBUG_SV.pop(l_module_name);

334: END IF;
335: --
336: IF l_debug_on THEN
337: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
338: WSH_DEBUG_SV.pop(l_module_name);
339: END IF;
340: --
341: EXCEPTION
342: WHEN others THEN

Line 348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

344: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);
346: --
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
350: END IF;
351: --
352: END Shipment_Price_Consolidate;

Line 349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);
346: --
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
350: END IF;
351: --
352: END Shipment_Price_Consolidate;
353:

Line 409: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

405: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
406: --
407: IF l_debug_on IS NULL
408: THEN
409: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
410: END IF;
411: --
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.push(l_module_name);

Line 413: WSH_DEBUG_SV.push(l_module_name);

409: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
410: END IF;
411: --
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.push(l_module_name);
414: --
415: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
416: END IF;
417: --

Line 415: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

411: --
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.push(l_module_name);
414: --
415: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
416: END IF;
417: --
418: l_stop_rec_old := l_stop_rec_null;
419: l_stop_rec_new := l_stop_rec_null;

Line 430: WSH_DEBUG_SV.log(l_module_name,'FTE NOT INSTALLE');

426: FND_MESSAGE.SET_NAME('WSH','FTE NOT INSTALLED');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'FTE NOT INSTALLE');
431: WSH_DEBUG_SV.pop(l_module_name);
432: END IF;
433: --
434: RETURN;

Line 431: WSH_DEBUG_SV.pop(l_module_name);

427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'FTE NOT INSTALLE');
431: WSH_DEBUG_SV.pop(l_module_name);
432: END IF;
433: --
434: RETURN;
435: END IF;

Line 456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

452: l_stop_rec_new := p_stop_rec;
453: -- Get trip details into l_stops_trip_rec FOR GROUP
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
457: END IF;
458: --
459: wsh_trips_grp.get_trip_details_pvt(p_trip_id => p_stop_rec.trip_id,
460: x_trip_rec => l_stops_trip_rec,

Line 465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);

461: x_return_status => l_return_status);
462:
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);
466: END IF;
467: --
468: FTE_WSH_INTERFACE_PKG.segment_stop_change
469: ( p_api_version => 1.0,

Line 482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

478: p_segmentStopChangeInRec => l_stop_seg_IN,
479: p_segmentStopChangeOutRec => l_stop_seg_OUT
480: );
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484: END IF;
485:
486: --2. Updating Stop

Line 512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);

508: x_return_status => l_return_status);
509:
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);
513: END IF;
514: --
515: FTE_WSH_INTERFACE_PKG.segment_stop_change
516: ( p_api_version => 1.0,

Line 529: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

525: p_segmentStopChangeInRec => l_stop_seg_IN,
526: p_segmentStopChangeOutRec => l_stop_seg_OUT
527: );
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
530: END IF;
531: END IF;
532: --3. Deleting Stop
533: ELSIF (p_action = 'DELETE'

Line 550: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);

546: p_trip_id => p_stop_rec.trip_id,
547: x_trip_rec => l_stops_trip_rec,
548: x_return_status => l_return_status);
549: IF l_debug_on THEN
550: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.SEGMENT_STOP_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);
551: END IF;
552: --
553: FTE_WSH_INTERFACE_PKG.segment_stop_change
554: ( p_api_version => 1.0,

Line 567: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

563: p_segmentStopChangeInRec => l_stop_seg_IN,
564: p_segmentStopChangeOutRec => l_stop_seg_OUT
565: );
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
568: END IF;
569: END IF;
570: --4. Updating Trip
571: ELSIF (p_action = 'UPDATE'

Line 592: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);

588: -- Map the new values to the record l_trip_rec_new
589: l_trip_rec_new := p_trip_rec;
590: --
591: IF l_debug_on THEN
592: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);
593: END IF;
594: --
595: FTE_WSH_INTERFACE_PKG.trip_segment_change
596: ( p_api_version => 1.0,

Line 608: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

604: p_tripSegmentChangeInRec => l_trip_seg_IN,
605: p_tripSegmentChangeOutRec => l_trip_seg_OUT
606: );
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
609: END IF;
610: END IF;
611:
612: --5. Deleting Trip

Line 628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);

624:
625: l_trip_rec_old := p_trip_rec;
626: --
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WSH_INTERFACE_PKG.TRIP_SEGMENT_CHANGE',WSH_DEBUG_SV.C_PROC_LEVEL);
629: END IF;
630: --
631: FTE_WSH_INTERFACE_PKG.trip_segment_change
632: ( p_api_version => 1.0,

Line 644: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

640: p_tripSegmentChangeInRec => l_trip_seg_IN,
641: p_tripSegmentChangeOutRec => l_trip_seg_OUT
642: );
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
645: END IF;
646: END IF;
647:
648: ELSE

Line 655: WSH_DEBUG_SV.log(l_module_name,'WSH_INVALID_CALL_TO_FTE');

651: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
652: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
653: ELSE
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.log(l_module_name,'WSH_INVALID_CALL_TO_FTE');
656: END IF;
657: END IF;
658: END IF;
659:

Line 666: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

662: END IF;
663:
664: --
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
667: WSH_DEBUG_SV.pop(l_module_name);
668: END IF;
669: --
670: EXCEPTION

Line 667: WSH_DEBUG_SV.pop(l_module_name);

663:
664: --
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
667: WSH_DEBUG_SV.pop(l_module_name);
668: END IF;
669: --
670: EXCEPTION
671: WHEN OTHERS THEN

Line 676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
678: END IF;
679: --
680: END trip_stop_validations;

Line 677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
678: END IF;
679: --
680: END trip_stop_validations;
681:

Line 712: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

708:
709: --
710: -- Variables used for debugging
711: --
712: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
713: --
714: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_cc_object_name';
715: --
716:

Line 723: WSH_DEBUG_SV.push(l_module_name);

719: BEGIN
720:
721: --
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.push(l_module_name);
724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_COMP_CONSTRAINT_UTIL.get_object_name',WSH_DEBUG_SV.C_PROC_LEVEL);
725: END IF;
726: --
727:

Line 724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_COMP_CONSTRAINT_UTIL.get_object_name',WSH_DEBUG_SV.C_PROC_LEVEL);

720:
721: --
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.push(l_module_name);
724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_COMP_CONSTRAINT_UTIL.get_object_name',WSH_DEBUG_SV.C_PROC_LEVEL);
725: END IF;
726: --
727:
728: l_result := FTE_COMP_CONSTRAINT_UTIL.get_object_name(

Line 742: WSH_DEBUG_SV.log(l_module_name,'Returning object_name : ',l_result);

738: END IF;
739:
740: --
741: IF l_debug_on THEN
742: WSH_DEBUG_SV.log(l_module_name,'Returning object_name : ',l_result);
743: WSH_DEBUG_SV.pop(l_module_name);
744: END IF;
745: --
746: RETURN l_result;

Line 743: WSH_DEBUG_SV.pop(l_module_name);

739:
740: --
741: IF l_debug_on THEN
742: WSH_DEBUG_SV.log(l_module_name,'Returning object_name : ',l_result);
743: WSH_DEBUG_SV.pop(l_module_name);
744: END IF;
745: --
746: RETURN l_result;
747:

Line 755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );

751: l_error_text := SQLERRM;
752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: --

Line 756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: --
760: RETURN l_unexp_char;

Line 757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: --
760: RETURN l_unexp_char;
761:

Line 846: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

842: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
843: --
844: IF l_debug_on IS NULL
845: THEN
846: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
847: END IF;
848: --
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.push(l_module_name);

Line 850: WSH_DEBUG_SV.push(l_module_name);

846: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
847: END IF;
848: --
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.push(l_module_name);
851: END IF;
852: --
853: IF l_debug_on THEN
854: WSH_DEBUG_SV.logmsg(

Line 854: WSH_DEBUG_SV.logmsg(

850: WSH_DEBUG_SV.push(l_module_name);
851: END IF;
852: --
853: IF l_debug_on THEN
854: WSH_DEBUG_SV.logmsg(
855: l_module_name,
856: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
857: WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;

Line 857: WSH_DEBUG_SV.C_PROC_LEVEL);

853: IF l_debug_on THEN
854: WSH_DEBUG_SV.logmsg(
855: l_module_name,
856: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
857: WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.logmsg(
861: l_module_name,

Line 860: WSH_DEBUG_SV.logmsg(

856: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
857: WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.logmsg(
861: l_module_name,
862: 'p_action_params.caller '|| p_action_params.caller,
863: WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;

Line 863: WSH_DEBUG_SV.C_PROC_LEVEL);

859: IF l_debug_on THEN
860: WSH_DEBUG_SV.logmsg(
861: l_module_name,
862: 'p_action_params.caller '|| p_action_params.caller,
863: WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(
867: l_module_name,

Line 866: WSH_DEBUG_SV.logmsg(

862: 'p_action_params.caller '|| p_action_params.caller,
863: WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(
867: l_module_name,
868: 'p_action_params.event '|| p_action_params.event,
869: WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;

Line 869: WSH_DEBUG_SV.C_PROC_LEVEL);

865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(
867: l_module_name,
868: 'p_action_params.event '|| p_action_params.event,
869: WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(
873: l_module_name,

Line 872: WSH_DEBUG_SV.logmsg(

868: 'p_action_params.event '|| p_action_params.event,
869: WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(
873: l_module_name,
874: 'p_action_params.action '|| p_action_params.action,
875: WSH_DEBUG_SV.C_PROC_LEVEL);
876: END IF;

Line 875: WSH_DEBUG_SV.C_PROC_LEVEL);

871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(
873: l_module_name,
874: 'p_action_params.action '|| p_action_params.action,
875: WSH_DEBUG_SV.C_PROC_LEVEL);
876: END IF;
877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(
879: l_module_name,

Line 878: WSH_DEBUG_SV.logmsg(

874: 'p_action_params.action '|| p_action_params.action,
875: WSH_DEBUG_SV.C_PROC_LEVEL);
876: END IF;
877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(
879: l_module_name,
880: 'p_commit '|| p_commit,
881: WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;

Line 881: WSH_DEBUG_SV.C_PROC_LEVEL);

877: IF l_debug_on THEN
878: WSH_DEBUG_SV.logmsg(
879: l_module_name,
880: 'p_commit '|| p_commit,
881: WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883:
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885:

Line 894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_TRIP_RATING_GRP.RATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

890: AND p_action_params.action is not null) THEN
891:
892: --
893: IF l_debug_on THEN
894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_TRIP_RATING_GRP.RATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
895: END IF;
896: --
897: l_action_param_rec.caller := p_action_params.caller;
898: l_action_param_rec.event := p_action_params.event;

Line 945: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

941: x_msg_data := l_msg_data;
942: END IF;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
946: WSH_DEBUG_SV.pop(l_module_name);
947: END IF;
948: --
949: EXCEPTION

Line 946: WSH_DEBUG_SV.pop(l_module_name);

942: END IF;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
946: WSH_DEBUG_SV.pop(l_module_name);
947: END IF;
948: --
949: EXCEPTION
950: WHEN others THEN

Line 956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
958: END IF;
959: --
960: END Rate_Trip;

Line 957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
958: END IF;
959: --
960: END Rate_Trip;
961:

Line 1007: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1003: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1004: --
1005: IF l_debug_on IS NULL
1006: THEN
1007: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1008: END IF;
1009: --
1010: IF l_debug_on THEN
1011: WSH_DEBUG_SV.push(l_module_name);

Line 1011: WSH_DEBUG_SV.push(l_module_name);

1007: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1008: END IF;
1009: --
1010: IF l_debug_on THEN
1011: WSH_DEBUG_SV.push(l_module_name);
1012: END IF;
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(

Line 1015: WSH_DEBUG_SV.logmsg(

1011: WSH_DEBUG_SV.push(l_module_name);
1012: END IF;
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(
1016: l_module_name,
1017: 'p_trip_id_tab.COUNT '|| p_trip_id_tab.COUNT,
1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: WSH_DEBUG_SV.logmsg(

Line 1018: WSH_DEBUG_SV.C_PROC_LEVEL);

1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(
1016: l_module_name,
1017: 'p_trip_id_tab.COUNT '|| p_trip_id_tab.COUNT,
1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: WSH_DEBUG_SV.logmsg(
1020: l_module_name,
1021: 'p_action_params.action_code '|| p_action_params.action_code,
1022: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1019: WSH_DEBUG_SV.logmsg(

1015: WSH_DEBUG_SV.logmsg(
1016: l_module_name,
1017: 'p_trip_id_tab.COUNT '|| p_trip_id_tab.COUNT,
1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: WSH_DEBUG_SV.logmsg(
1020: l_module_name,
1021: 'p_action_params.action_code '|| p_action_params.action_code,
1022: WSH_DEBUG_SV.C_PROC_LEVEL);
1023: END IF;

Line 1022: WSH_DEBUG_SV.C_PROC_LEVEL);

1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: WSH_DEBUG_SV.logmsg(
1020: l_module_name,
1021: 'p_action_params.action_code '|| p_action_params.action_code,
1022: WSH_DEBUG_SV.C_PROC_LEVEL);
1023: END IF;
1024:
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:

Line 1036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

1032: p_action_params.action_code = 'TENDER') THEN
1033:
1034: --
1035: IF l_debug_on THEN
1036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1037: END IF;
1038: --
1039: l_fte_trip_id_tab := FTE_ID_TAB_TYPE();
1040: -- Convert Variables required as Input for FTE API

Line 1046: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling program unit FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

1042: x_fte_id_tab => l_fte_trip_id_tab);
1043:
1044: --
1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling program unit FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1047: END IF;
1048: --
1049: IF l_debug_on THEN
1050: WSH_DEBUG_SV.logmsg( l_module_name, 'trip_id_tab.COUNT '|| l_fte_trip_id_tab.COUNT,

Line 1050: WSH_DEBUG_SV.logmsg( l_module_name, 'trip_id_tab.COUNT '|| l_fte_trip_id_tab.COUNT,

1046: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling program unit FTE_MLS_UTIL.COPY_WSH_ID_TO_FTE_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1047: END IF;
1048: --
1049: IF l_debug_on THEN
1050: WSH_DEBUG_SV.logmsg( l_module_name, 'trip_id_tab.COUNT '|| l_fte_trip_id_tab.COUNT,
1051: WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;
1053: -- As agreed with Harish, only populating the action code 'TENDER'
1054: -- other parameters are left null

Line 1051: WSH_DEBUG_SV.C_PROC_LEVEL);

1047: END IF;
1048: --
1049: IF l_debug_on THEN
1050: WSH_DEBUG_SV.logmsg( l_module_name, 'trip_id_tab.COUNT '|| l_fte_trip_id_tab.COUNT,
1051: WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;
1053: -- As agreed with Harish, only populating the action code 'TENDER'
1054: -- other parameters are left null
1055: l_fte_trip_action_param_rec := FTE_TRIP_ACTION_PARAM_REC(null,'TENDER',

Line 1062: WSH_DEBUG_SV.logmsg(l_module_name,'After populating FTE_TRIP_ACTION_PARAM_REC',WSH_DEBUG_SV.C_PROC_LEVEL);

1058: null,null);
1059: l_fte_trip_action_param_rec.action_code := p_action_params.action_code;
1060: --
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'After populating FTE_TRIP_ACTION_PARAM_REC',WSH_DEBUG_SV.C_PROC_LEVEL);
1063: END IF;
1064: --
1065: --
1066: IF l_debug_on THEN

Line 1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_WRAPPER.TRIP_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1063: END IF;
1064: --
1065: --
1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_WRAPPER.TRIP_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069: --
1070:
1071: -- Call FTE API

Line 1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_UTIL.COPY_FTE_ID_TO_WSH_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

1088: x_msg_data := l_msg_data;
1089:
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_MLS_UTIL.COPY_FTE_ID_TO_WSH_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: -- Convert Variables which are Output from FTE API
1096: FTE_MLS_UTIL.COPY_FTE_ID_TO_WSH_ID (p_fte_id_tab => l_fte_action_out_rec.result_id_tab,

Line 1103: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1099: FTE_MLS_UTIL.COPY_FTE_ID_TO_WSH_ID (p_fte_id_tab => l_fte_action_out_rec.valid_ids_tab,
1100: x_wsh_id_tab => l_wsh_valid_id_tab);
1101: --
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1104: WSH_DEBUG_SV.log(l_module_name,'Result id tab Count',l_wsh_result_id_tab.count);
1105: WSH_DEBUG_SV.log(l_module_name,'Valid id tab Count',l_wsh_valid_id_tab.count);
1106: END IF;
1107: --

Line 1104: WSH_DEBUG_SV.log(l_module_name,'Result id tab Count',l_wsh_result_id_tab.count);

1100: x_wsh_id_tab => l_wsh_valid_id_tab);
1101: --
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1104: WSH_DEBUG_SV.log(l_module_name,'Result id tab Count',l_wsh_result_id_tab.count);
1105: WSH_DEBUG_SV.log(l_module_name,'Valid id tab Count',l_wsh_valid_id_tab.count);
1106: END IF;
1107: --
1108:

Line 1105: WSH_DEBUG_SV.log(l_module_name,'Valid id tab Count',l_wsh_valid_id_tab.count);

1101: --
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1104: WSH_DEBUG_SV.log(l_module_name,'Result id tab Count',l_wsh_result_id_tab.count);
1105: WSH_DEBUG_SV.log(l_module_name,'Valid id tab Count',l_wsh_valid_id_tab.count);
1106: END IF;
1107: --
1108:
1109: -- Transfer the ids to Output Data Structure

Line 1119: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

1115: END IF;
1116:
1117: --
1118: IF l_debug_on THEN
1119: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1120: WSH_DEBUG_SV.pop(l_module_name);
1121: END IF;
1122: --
1123: EXCEPTION

Line 1120: WSH_DEBUG_SV.pop(l_module_name);

1116:
1117: --
1118: IF l_debug_on THEN
1119: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1120: WSH_DEBUG_SV.pop(l_module_name);
1121: END IF;
1122: --
1123: EXCEPTION
1124: WHEN others THEN

Line 1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1132: END IF;
1133:
1134: END Trip_Action;

Line 1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1132: END IF;
1133:
1134: END Trip_Action;
1135:

Line 1184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1180: --
1181:
1182: IF l_debug_on IS NULL
1183: THEN
1184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1185: END IF;
1186: --
1187:
1188: IF l_debug_on THEN

Line 1189: WSH_DEBUG_SV.push(l_module_name);

1185: END IF;
1186: --
1187:
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: END IF;
1191:
1192: --
1193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);

1234: --
1235: -- Call carrier selection module
1236: --
1237: IF l_debug_on THEN
1238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);
1239: END IF;
1240: --
1241:
1242: FTE_ACS_PKG.GET_ROUTING_RESULTS( --p_start_search_level_flag => p_start_search_level_flag,

Line 1312: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

1308: x_return_status := l_return_status;
1309:
1310: --
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1313: WSH_DEBUG_SV.pop(l_module_name);
1314: END IF;
1315: --
1316: RETURN;

Line 1313: WSH_DEBUG_SV.pop(l_module_name);

1309:
1310: --
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1313: WSH_DEBUG_SV.pop(l_module_name);
1314: END IF;
1315: --
1316: RETURN;
1317:

Line 1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );

1320: l_error_code := SQLCODE;
1321: l_error_text := SQLERRM;
1322: --
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );
1325: END IF;
1326: --
1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1329: x_return_message := l_error_text;
1330: --
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1334: END IF;
1335: --
1336: RETURN;

Line 1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1329: x_return_message := l_error_text;
1330: --
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1334: END IF;
1335: --
1336: RETURN;
1337: END CARRIER_SELECTION;

Line 1377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1373: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1374: --
1375: IF l_debug_on IS NULL
1376: THEN
1377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1378: END IF;
1379: --
1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.push(l_module_name);

Line 1381: WSH_DEBUG_SV.push(l_module_name);

1377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1378: END IF;
1379: --
1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.push(l_module_name);
1382: END IF;
1383: --
1384:
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1460: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

1456: END IF;
1457:
1458: --
1459: IF l_debug_on THEN
1460: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1461: WSH_DEBUG_SV.pop(l_module_name);
1462: END IF;
1463: --
1464: EXCEPTION

Line 1461: WSH_DEBUG_SV.pop(l_module_name);

1457:
1458: --
1459: IF l_debug_on THEN
1460: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1461: WSH_DEBUG_SV.pop(l_module_name);
1462: END IF;
1463: --
1464: EXCEPTION
1465: WHEN OTHERS THEN

Line 1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );

1466: l_error_code := SQLCODE;
1467: l_error_text := SQLERRM;
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );
1471: END IF;
1472: --
1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1478: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1475: x_msg_data := l_error_text;
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1480: END IF;
1481: --
1482: END RANK_LIST_ACTION;

Line 1479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1475: x_msg_data := l_error_text;
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1480: END IF;
1481: --
1482: END RANK_LIST_ACTION;
1483:

Line 1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1507: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1508: --
1509: IF l_debug_on IS NULL
1510: THEN
1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.push(l_module_name);

Line 1515: WSH_DEBUG_SV.push(l_module_name);

1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.push(l_module_name);
1516: WSH_DEBUG_SV.logmsg(l_module_name, 'trip id : ' ||p_trip_id );
1517: END IF;
1518: --
1519:

Line 1516: WSH_DEBUG_SV.logmsg(l_module_name, 'trip id : ' ||p_trip_id );

1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.push(l_module_name);
1516: WSH_DEBUG_SV.logmsg(l_module_name, 'trip id : ' ||p_trip_id );
1517: END IF;
1518: --
1519:
1520: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN

Line 1541: WSH_DEBUG_SV.pop(l_module_name);

1537: END IF;
1538:
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.pop(l_module_name);
1542: END IF;
1543: --
1544: RETURN l_move_id;
1545:

Line 1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );

1551: l_error_code := SQLCODE;
1552: l_error_text := SQLERRM;
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );
1556: END IF;
1557: --
1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --

Line 1561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1557: --
1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1563: END IF;
1564: --
1565: RETURN -1;

Line 1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1563: END IF;
1564: --
1565: RETURN -1;
1566: END GET_TRIP_MOVE;

Line 1606: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1602: BEGIN
1603: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1604: --
1605: IF l_debug_on IS NULL THEN
1606: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1607: END IF;
1608: --
1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.push(l_module_name);

Line 1610: WSH_DEBUG_SV.push(l_module_name);

1606: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1607: END IF;
1608: --
1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.push(l_module_name);
1611: END IF;
1612:
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1614:

Line 1631: WSH_DEBUG_SV.pop(l_module_name);

1627: --
1628: -- Debug Statements
1629: --
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.pop(l_module_name);
1632: END IF;
1633:
1634: EXCEPTION
1635:

Line 1642: WSH_DEBUG_SV.pop(l_module_name,'When Others');

1638:
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.pop(l_module_name,'When Others');
1643: END IF;
1644:
1645: END CARRIER_SEL_CREATE_TRIP;
1646:

Line 1697: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1693: BEGIN
1694: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1695: --
1696: IF l_debug_on IS NULL THEN
1697: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1698: END IF;
1699: --
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.push(l_module_name);

Line 1701: WSH_DEBUG_SV.push(l_module_name);

1697: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1698: END IF;
1699: --
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.push(l_module_name);
1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);

Line 1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);

1698: END IF;
1699: --
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.push(l_module_name);
1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,

Line 1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);

1699: --
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.push(l_module_name);
1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,
1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',

Line 1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);

1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.push(l_module_name);
1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,
1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',
1708: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);

1701: WSH_DEBUG_SV.push(l_module_name);
1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,
1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',
1708: WSH_DEBUG_SV.C_PROC_LEVEL);
1709: END IF;

Line 1706: WSH_DEBUG_SV.logmsg(l_module_name,

1702: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list', p_init_msg_list);
1703: WSH_DEBUG_SV.log(l_module_name, 'p_entity_id', p_entity_id);
1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,
1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',
1708: WSH_DEBUG_SV.C_PROC_LEVEL);
1709: END IF;
1710:

Line 1708: WSH_DEBUG_SV.C_PROC_LEVEL);

1704: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type);
1705: WSH_DEBUG_SV.log(l_module_name, 'p_org_id_flag', p_org_id_flag);
1706: WSH_DEBUG_SV.logmsg(l_module_name,
1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',
1708: WSH_DEBUG_SV.C_PROC_LEVEL);
1709: END IF;
1710:
1711: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1712:

Line 1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

1722: p_org_id_flag => p_org_id_flag
1723: );
1724:
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);

Line 1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);

1723: );
1724:
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);
1731: WSH_DEBUG_SV.pop(l_module_name);

Line 1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);

1724:
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);
1731: WSH_DEBUG_SV.pop(l_module_name);
1732: END IF;

Line 1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);

1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);
1731: WSH_DEBUG_SV.pop(l_module_name);
1732: END IF;
1733:

Line 1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);

1726: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);
1731: WSH_DEBUG_SV.pop(l_module_name);
1732: END IF;
1733:
1734: EXCEPTION

Line 1731: WSH_DEBUG_SV.pop(l_module_name);

1727: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1728: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1729: WSH_DEBUG_SV.log(l_module_name, 'x_organization_id', x_organization_id);
1730: WSH_DEBUG_SV.log(l_module_name, 'x_org_id', x_org_id);
1731: WSH_DEBUG_SV.pop(l_module_name);
1732: END IF;
1733:
1734: EXCEPTION
1735:

Line 1744: WSH_DEBUG_SV.logmsg(l_module_name,

1740: 'WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO',
1741: l_module_name);
1742:
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.logmsg(l_module_name,
1745: 'Unexpected error has occured. Oracle error message is '
1746: || SQLERRM,
1747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.logmsg(l_module_name,
1745: 'Unexpected error has occured. Oracle error message is '
1746: || SQLERRM,
1747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1749: END IF;
1750:
1751: END GET_ORG_ORGANIZATION_INFO;

Line 1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1744: WSH_DEBUG_SV.logmsg(l_module_name,
1745: 'Unexpected error has occured. Oracle error message is '
1746: || SQLERRM,
1747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1749: END IF;
1750:
1751: END GET_ORG_ORGANIZATION_INFO;
1752:

Line 1800: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1796: BEGIN
1797: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1798: --
1799: IF l_debug_on IS NULL THEN
1800: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1801: END IF;
1802: --
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.push(l_module_name);

Line 1804: WSH_DEBUG_SV.push(l_module_name);

1800: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1801: END IF;
1802: --
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.push(l_module_name);
1805: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number',
1806: p_api_version_number);
1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',
1808: p_init_msg_list);

Line 1805: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number',

1801: END IF;
1802: --
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.push(l_module_name);
1805: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number',
1806: p_api_version_number);
1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',
1808: p_init_msg_list);
1809: WSH_DEBUG_SV.log(l_module_name, 'p_source',

Line 1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',

1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.push(l_module_name);
1805: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number',
1806: p_api_version_number);
1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',
1808: p_init_msg_list);
1809: WSH_DEBUG_SV.log(l_module_name, 'p_source',
1810: p_source);
1811: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id_tab.COUNT',

Line 1809: WSH_DEBUG_SV.log(l_module_name, 'p_source',

1805: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number',
1806: p_api_version_number);
1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',
1808: p_init_msg_list);
1809: WSH_DEBUG_SV.log(l_module_name, 'p_source',
1810: p_source);
1811: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id_tab.COUNT',
1812: p_trip_id_tab.COUNT);
1813: END IF;

Line 1811: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id_tab.COUNT',

1807: WSH_DEBUG_SV.log(l_module_name, 'p_init_msg_list',
1808: p_init_msg_list);
1809: WSH_DEBUG_SV.log(l_module_name, 'p_source',
1810: p_source);
1811: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id_tab.COUNT',
1812: p_trip_id_tab.COUNT);
1813: END IF;
1814:
1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1821: WSH_DEBUG_SV.logmsg(l_module_name,

1817: IF p_trip_id_tab.COUNT > 0
1818: AND (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1819:
1820: IF l_debug_on THEN
1821: WSH_DEBUG_SV.logmsg(l_module_name,
1822: 'Selecting WSH_TRIPS into rank list');
1823: END IF;
1824:
1825: FOR i IN p_trip_id_tab.FIRST .. p_trip_id_tab.LAST LOOP

Line 1905: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',

1901: WHERE trip_id = p_trip_id_tab(i);
1902: END LOOP;
1903:
1904: IF l_debug_on THEN
1905: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1906: l_ranklist.trip_id.COUNT);
1907: WSH_DEBUG_SV.logmsg(l_module_name,
1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',
1909: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1907: WSH_DEBUG_SV.logmsg(l_module_name,

1903:
1904: IF l_debug_on THEN
1905: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1906: l_ranklist.trip_id.COUNT);
1907: WSH_DEBUG_SV.logmsg(l_module_name,
1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',
1909: WSH_DEBUG_SV.C_PROC_LEVEL);
1910: END IF;
1911:

Line 1909: WSH_DEBUG_SV.C_PROC_LEVEL);

1905: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1906: l_ranklist.trip_id.COUNT);
1907: WSH_DEBUG_SV.logmsg(l_module_name,
1908: 'Calling FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK',
1909: WSH_DEBUG_SV.C_PROC_LEVEL);
1910: END IF;
1911:
1912: FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK(
1913: p_api_version_number => p_api_version_number,

Line 1924: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',

1920:
1921: END IF;
1922:
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',
1925: x_return_status);
1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1927: l_ranklist.trip_id.count);
1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);

Line 1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',

1922:
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',
1925: x_return_status);
1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1927: l_ranklist.trip_id.count);
1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1929: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1930: WSH_DEBUG_SV.pop(l_module_name);

Line 1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);

1924: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',
1925: x_return_status);
1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1927: l_ranklist.trip_id.count);
1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1929: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1930: WSH_DEBUG_SV.pop(l_module_name);
1931: END IF;
1932:

Line 1929: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);

1925: x_return_status);
1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1927: l_ranklist.trip_id.count);
1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1929: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1930: WSH_DEBUG_SV.pop(l_module_name);
1931: END IF;
1932:
1933: EXCEPTION

Line 1930: WSH_DEBUG_SV.pop(l_module_name);

1926: WSH_DEBUG_SV.log(l_module_name, 'l_ranklist.trip_id.COUNT',
1927: l_ranklist.trip_id.count);
1928: WSH_DEBUG_SV.log(l_module_name, 'x_msg_count', x_msg_count);
1929: WSH_DEBUG_SV.log(l_module_name, 'x_msg_data', x_msg_data);
1930: WSH_DEBUG_SV.pop(l_module_name);
1931: END IF;
1932:
1933: EXCEPTION
1934:

Line 1943: WSH_DEBUG_SV.logmsg(l_module_name,

1939: 'WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK',
1940: l_module_name);
1941:
1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.logmsg(l_module_name,
1944: 'Unexpected error has occured. Oracle error message is '
1945: || SQLERRM,
1946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.logmsg(l_module_name,
1944: 'Unexpected error has occured. Oracle error message is '
1945: || SQLERRM,
1946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1948: END IF;
1949:
1950:

Line 1947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1943: WSH_DEBUG_SV.logmsg(l_module_name,
1944: 'Unexpected error has occured. Oracle error message is '
1945: || SQLERRM,
1946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1948: END IF;
1949:
1950:
1951: END CREATE_RANK_LIST_BULK;