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_TRIPS_PUB dependencies on WSH_DEBUG_SV

Line 74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

70: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
71: --
72: IF l_debug_on IS NULL
73: THEN
74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);

Line 78: wsh_debug_sv.push (l_module_name);

74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',
80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);

Line 79: wsh_debug_sv.log (l_module_name,'p_api_version_number',

75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',
80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);

Line 81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);

77: IF l_debug_on THEN
78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',
80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',

Line 82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);

78: wsh_debug_sv.push (l_module_name);
79: wsh_debug_sv.log (l_module_name,'p_api_version_number',
80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',
86: p_wv_override_flag);

Line 83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);

79: wsh_debug_sv.log (l_module_name,'p_api_version_number',
80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',
86: p_wv_override_flag);
87: wsh_debug_sv.log (l_module_name,'p_report_set_name',

Line 84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);

80: p_api_version_number);
81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',
86: p_wv_override_flag);
87: wsh_debug_sv.log (l_module_name,'p_report_set_name',
88: p_report_set_name);

Line 85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',

81: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
82: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',
86: p_wv_override_flag);
87: wsh_debug_sv.log (l_module_name,'p_report_set_name',
88: p_report_set_name);
89: END IF;

Line 87: wsh_debug_sv.log (l_module_name,'p_report_set_name',

83: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
84: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
85: wsh_debug_sv.log (l_module_name,'p_wv_override_flag',
86: p_wv_override_flag);
87: wsh_debug_sv.log (l_module_name,'p_report_set_name',
88: p_report_set_name);
89: END IF;
90:
91: IF NOT FND_API.Compatible_API_Call

Line 126: wsh_debug_sv.log (l_module_name,'l_report_set_id',l_report_set_id);

122: p_report_set_name => p_report_set_name,
123: x_return_status => x_return_status);
124:
125: IF l_debug_on THEN
126: wsh_debug_sv.log (l_module_name,'l_report_set_id',l_report_set_id);
127: END IF;
128:
129: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
130: raise trip_action_error;

Line 168: WSH_DEBUG_SV.pop(l_module_name);

164: ,p_encoded => FND_API.G_FALSE
165: );
166:
167: IF l_debug_on THEN
168: WSH_DEBUG_SV.pop(l_module_name);
169: END IF;
170:
171:
172: EXCEPTION

Line 185: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');

181: , p_data => x_msg_data
182: ,p_encoded => FND_API.G_FALSE
183: );
184: IF l_debug_on THEN
185: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
186: WSH_DEBUG_SV.pop(l_module_name);
187: END IF;
188:
189: WHEN FND_API.G_EXC_ERROR THEN

Line 186: WSH_DEBUG_SV.pop(l_module_name);

182: ,p_encoded => FND_API.G_FALSE
183: );
184: IF l_debug_on THEN
185: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
186: WSH_DEBUG_SV.pop(l_module_name);
187: END IF;
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;

Line 198: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

194: , p_data => x_msg_data
195: ,p_encoded => FND_API.G_FALSE
196: );
197: IF l_debug_on THEN
198: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
199: WSH_DEBUG_SV.pop(l_module_name);
200: END IF;
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 199: WSH_DEBUG_SV.pop(l_module_name);

195: ,p_encoded => FND_API.G_FALSE
196: );
197: IF l_debug_on THEN
198: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
199: WSH_DEBUG_SV.pop(l_module_name);
200: END IF;
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 211: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');

207: , p_data => x_msg_data
208: ,p_encoded => FND_API.G_FALSE
209: );
210: IF l_debug_on THEN
211: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
212: WSH_DEBUG_SV.pop(l_module_name);
213: END IF;
214:
215: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 212: WSH_DEBUG_SV.pop(l_module_name);

208: ,p_encoded => FND_API.G_FALSE
209: );
210: IF l_debug_on THEN
211: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
212: WSH_DEBUG_SV.pop(l_module_name);
213: END IF;
214:
215: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
216:

Line 225: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');

221: , p_data => x_msg_data
222: ,p_encoded => FND_API.G_FALSE
223: );
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
226: WSH_DEBUG_SV.pop(l_module_name);
227: END IF;
228:
229:

Line 226: WSH_DEBUG_SV.pop(l_module_name);

222: ,p_encoded => FND_API.G_FALSE
223: );
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
226: WSH_DEBUG_SV.pop(l_module_name);
227: END IF;
228:
229:
230: WHEN OTHERS THEN

Line 246: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));

242: , p_data => x_msg_data
243: ,p_encoded => FND_API.G_FALSE
244: );
245: IF l_debug_on THEN
246: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
247: WSH_DEBUG_SV.pop(l_module_name);
248: END IF;
249:
250: END Trip_Action;

Line 247: WSH_DEBUG_SV.pop(l_module_name);

243: ,p_encoded => FND_API.G_FALSE
244: );
245: IF l_debug_on THEN
246: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
247: WSH_DEBUG_SV.pop(l_module_name);
248: END IF;
249:
250: END Trip_Action;
251:

Line 313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

309: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
310: --
311: IF l_debug_on IS NULL
312: THEN
313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
314: END IF;
315: --
316: IF l_debug_on THEN
317: wsh_debug_sv.push (l_module_name);

Line 317: wsh_debug_sv.push (l_module_name);

313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
314: END IF;
315: --
316: IF l_debug_on THEN
317: wsh_debug_sv.push (l_module_name);
318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);

Line 318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);

314: END IF;
315: --
316: IF l_debug_on THEN
317: wsh_debug_sv.push (l_module_name);
318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);

Line 319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);

315: --
316: IF l_debug_on THEN
317: wsh_debug_sv.push (l_module_name);
318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);

Line 320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);

316: IF l_debug_on THEN
317: wsh_debug_sv.push (l_module_name);
318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);

Line 321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);

317: wsh_debug_sv.push (l_module_name);
318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);

Line 322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);

318: wsh_debug_sv.log (l_module_name,'p_api_version_number', p_api_version_number);
319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);

Line 323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);

319: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);

Line 324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);

320: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);

Line 325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);

321: wsh_debug_sv.log (l_module_name,'action_code',p_action_param_rec.action_code);
322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);

Line 326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);

322: wsh_debug_sv.log (l_module_name,'organization_id',p_action_param_rec.organization_id);
323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);

Line 327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);

323: wsh_debug_sv.log (l_module_name,'report_set_name',p_action_param_rec.report_set_name);
324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);

Line 328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);

324: wsh_debug_sv.log (l_module_name,'report_set_id',p_action_param_rec.report_set_id);
325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);

Line 329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);

325: wsh_debug_sv.log (l_module_name,'override_flag',p_action_param_rec.override_flag);
326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);

Line 330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);

326: wsh_debug_sv.log (l_module_name,'actual_date',p_action_param_rec.actual_date);
327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);

Line 331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);

327: wsh_debug_sv.log (l_module_name,'action_flag',p_action_param_rec.action_flag);
328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);

Line 332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);

328: wsh_debug_sv.log (l_module_name,'autointransit_flag',p_action_param_rec.autointransit_flag);
329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);

Line 333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);

329: wsh_debug_sv.log (l_module_name,'autoclose_flag',p_action_param_rec.autoclose_flag);
330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
337: END IF;

Line 334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);

330: wsh_debug_sv.log (l_module_name,'stage_del_flag',p_action_param_rec.stage_del_flag);
331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
337: END IF;
338:

Line 335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);

331: wsh_debug_sv.log (l_module_name,'ship_method',p_action_param_rec.ship_method);
332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
337: END IF;
338:
339: IF NOT FND_API.Compatible_API_Call

Line 336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);

332: wsh_debug_sv.log (l_module_name,'bill_of_lading_flag',p_action_param_rec.bill_of_lading_flag);
333: wsh_debug_sv.log (l_module_name,'defer_interface_flag',p_action_param_rec.defer_interface_flag);
334: wsh_debug_sv.log (l_module_name,'actual_departure_date',p_action_param_rec.actual_departure_date);
335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
337: END IF;
338:
339: IF NOT FND_API.Compatible_API_Call
340: ( l_api_version_number

Line 388: wsh_debug_sv.log (l_module_name,'l_report_set_id',l_report_set_id);

384:
385: END IF;
386:
387: IF l_debug_on THEN
388: wsh_debug_sv.log (l_module_name,'l_report_set_id',l_report_set_id);
389: END IF;
390:
391: l_entity_id_tab(1) := l_trip_id;
392: l_action_prms.action_code := p_action_param_rec.action_code;

Line 435: WSH_DEBUG_SV.pop(l_module_name);

431: COMMIT;
432: END IF;
433:
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.pop(l_module_name);
436: END IF;
437:
438:
439: EXCEPTION

Line 452: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');

448: , p_data => x_msg_data
449: ,p_encoded => FND_API.G_FALSE
450: );
451: IF l_debug_on THEN
452: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
453: WSH_DEBUG_SV.pop(l_module_name);
454: END IF;
455:
456: WHEN FND_API.G_EXC_ERROR THEN

Line 453: WSH_DEBUG_SV.pop(l_module_name);

449: ,p_encoded => FND_API.G_FALSE
450: );
451: IF l_debug_on THEN
452: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
453: WSH_DEBUG_SV.pop(l_module_name);
454: END IF;
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;

Line 465: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');

461: , p_data => x_msg_data
462: ,p_encoded => FND_API.G_FALSE
463: );
464: IF l_debug_on THEN
465: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
466: WSH_DEBUG_SV.pop(l_module_name);
467: END IF;
468:
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 466: WSH_DEBUG_SV.pop(l_module_name);

462: ,p_encoded => FND_API.G_FALSE
463: );
464: IF l_debug_on THEN
465: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
466: WSH_DEBUG_SV.pop(l_module_name);
467: END IF;
468:
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 478: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');

474: , p_data => x_msg_data
475: ,p_encoded => FND_API.G_FALSE
476: );
477: IF l_debug_on THEN
478: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
479: WSH_DEBUG_SV.pop(l_module_name);
480: END IF;
481:
482: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 479: WSH_DEBUG_SV.pop(l_module_name);

475: ,p_encoded => FND_API.G_FALSE
476: );
477: IF l_debug_on THEN
478: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
479: WSH_DEBUG_SV.pop(l_module_name);
480: END IF;
481:
482: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
483:

Line 492: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');

488: , p_data => x_msg_data
489: ,p_encoded => FND_API.G_FALSE
490: );
491: IF l_debug_on THEN
492: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
493: WSH_DEBUG_SV.pop(l_module_name);
494: END IF;
495:
496:

Line 493: WSH_DEBUG_SV.pop(l_module_name);

489: ,p_encoded => FND_API.G_FALSE
490: );
491: IF l_debug_on THEN
492: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
493: WSH_DEBUG_SV.pop(l_module_name);
494: END IF;
495:
496:
497: WHEN OTHERS THEN

Line 513: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));

509: , p_data => x_msg_data
510: ,p_encoded => FND_API.G_FALSE
511: );
512: IF l_debug_on THEN
513: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
514: WSH_DEBUG_SV.pop(l_module_name);
515: END IF;
516:
517: END Trip_Action;

Line 514: WSH_DEBUG_SV.pop(l_module_name);

510: ,p_encoded => FND_API.G_FALSE
511: );
512: IF l_debug_on THEN
513: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
514: WSH_DEBUG_SV.pop(l_module_name);
515: END IF;
516:
517: END Trip_Action;
518:

Line 541: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

537: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
538: --
539: IF l_debug_on IS NULL
540: THEN
541: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
542: END IF;
543: --
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.push(l_module_name);

Line 545: WSH_DEBUG_SV.push(l_module_name);

541: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
542: END IF;
543: --
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.push(l_module_name);
546: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.TRIP_ID',p_pub_trip_rec.TRIP_ID);
547: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.NAME',p_pub_trip_rec.NAME);
548: END IF;
549: --

Line 546: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.TRIP_ID',p_pub_trip_rec.TRIP_ID);

542: END IF;
543: --
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.push(l_module_name);
546: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.TRIP_ID',p_pub_trip_rec.TRIP_ID);
547: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.NAME',p_pub_trip_rec.NAME);
548: END IF;
549: --
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 547: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.NAME',p_pub_trip_rec.NAME);

543: --
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.push(l_module_name);
546: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.TRIP_ID',p_pub_trip_rec.TRIP_ID);
547: WSH_DEBUG_SV.log(l_module_name,'p_pub_trip_rec.NAME',p_pub_trip_rec.NAME);
548: END IF;
549: --
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551:

Line 603: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_freight_terms',l_return_status);

599: p_freight_terms_name => p_pub_trip_rec.freight_terms_name,
600: x_return_status => l_return_status);
601: --
602: IF l_debug_on THEN
603: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_freight_terms',l_return_status);
604: END IF;
605: --
606: WSH_UTIL_CORE.api_post_call(
607: p_return_status => l_return_status,

Line 638: WSH_DEBUG_SV.pop(l_module_name);

634: x_pvt_trip_rec.CARRIER_REFERENCE_NUMBER := p_pub_trip_rec.CARRIER_REFERENCE_NUMBER;
635: x_pvt_trip_rec.CONSIGNEE_CARRIER_AC_NO := p_pub_trip_rec.CONSIGNEE_CARRIER_AC_NO;
636:
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.pop(l_module_name);
639: END IF;
640: --
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN

Line 646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

642: WHEN FND_API.G_EXC_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: -- caller will handle this exception
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
657: END IF;
658: --
659:

Line 656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

652: -- caller will handle this exception
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
657: END IF;
658: --
659:
660: WHEN OTHERS THEN

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

661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_trippub_to_pvt',l_module_name);
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
667: END IF;
668: --
669: END;

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

662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
667: END IF;
668: --
669: END;
670:

Line 721: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

717: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
718: --
719: IF l_debug_on IS NULL
720: THEN
721: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
722: END IF;
723: --
724: IF l_debug_on THEN
725: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');

Line 725: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');

721: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
722: END IF;
723: --
724: IF l_debug_on THEN
725: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');
726: END IF;
727:
728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 789: wsh_debug_sv.log (l_module_name,'WSH_INTERFACE_GRP.Create_Update_Trip x_return_status',x_return_status);

785: p_In_rec => l_In_rec,
786: x_Out_tab => l_Out_Tab);
787:
788: IF l_debug_on THEN
789: wsh_debug_sv.log (l_module_name,'WSH_INTERFACE_GRP.Create_Update_Trip x_return_status',x_return_status);
790: END IF;
791: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_Out_Tab.count > 0) THEN
792: x_trip_id := l_out_tab(l_out_tab.FIRST).trip_id;
793: x_trip_name := l_out_tab(l_out_tab.FIRST).trip_name;

Line 801: WSH_DEBUG_SV.pop(l_module_name);

797: p_count => x_msg_count,
798: p_data => x_msg_data);
799:
800: IF l_debug_on THEN
801: WSH_DEBUG_SV.pop(l_module_name);
802: END IF;
803:
804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN

Line 812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

808: p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:

Line 813: WSH_DEBUG_SV.C_EXCEP_LEVEL);

809: p_data => x_msg_data,
810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

820: p_count => x_msg_count,
821: p_data => x_msg_data,
822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:

Line 825: WSH_DEBUG_SV.C_EXCEP_LEVEL);

821: p_data => x_msg_data,
822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:
829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:
829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',

832: p_count => x_msg_count,
833: p_data => x_msg_data,
834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:

Line 837: WSH_DEBUG_SV.C_EXCEP_LEVEL);

833: p_data => x_msg_data,
834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:
841: WHEN OTHERS THEN

Line 838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
839: END IF;
840:
841: WHEN OTHERS THEN
842: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

845: p_count => x_msg_count,
846: p_data => x_msg_data,
847: p_encoded => FND_API.G_FALSE);
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
850: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
852: END IF;
853:

Line 850: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

846: p_data => x_msg_data,
847: p_encoded => FND_API.G_FALSE);
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
850: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
852: END IF;
853:
854: END Create_Update_Trip;

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

847: p_encoded => FND_API.G_FALSE);
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
850: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
852: END IF;
853:
854: END Create_Update_Trip;
855: --Harmonizing Project **heali