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_DELIVERY_LEGS_GRP dependencies on WSH_UTIL_CORE

Line 88: l_valid_ids wsh_util_core.id_tab_type;

84:
85: l_ship_method_code VARCHAR2(30);
86: l_bol_number NUMBER;
87:
88: l_valid_ids wsh_util_core.id_tab_type;
89: l_error_ids wsh_util_core.id_tab_type;
90: l_valid_index_tab wsh_util_core.id_tab_type;
91: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
92: l_delivery_leg_id NUMBER;

Line 89: l_error_ids wsh_util_core.id_tab_type;

85: l_ship_method_code VARCHAR2(30);
86: l_bol_number NUMBER;
87:
88: l_valid_ids wsh_util_core.id_tab_type;
89: l_error_ids wsh_util_core.id_tab_type;
90: l_valid_index_tab wsh_util_core.id_tab_type;
91: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
92: l_delivery_leg_id NUMBER;
93: l_delivery_id NUMBER;

Line 90: l_valid_index_tab wsh_util_core.id_tab_type;

86: l_bol_number NUMBER;
87:
88: l_valid_ids wsh_util_core.id_tab_type;
89: l_error_ids wsh_util_core.id_tab_type;
90: l_valid_index_tab wsh_util_core.id_tab_type;
91: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
92: l_delivery_leg_id NUMBER;
93: l_delivery_id NUMBER;
94:

Line 100: l_dummy_id_tab wsh_util_core.id_tab_type;

96: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE; -- OTM R12,glog proj
97:
98: -- Added for bug 4493263
99: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
100: l_dummy_id_tab wsh_util_core.id_tab_type;
101: l_delivery_id_tab wsh_util_core.id_tab_type;
102: l_doc_set_id NUMBER;
103:
104:

Line 101: l_delivery_id_tab wsh_util_core.id_tab_type;

97:
98: -- Added for bug 4493263
99: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
100: l_dummy_id_tab wsh_util_core.id_tab_type;
101: l_delivery_id_tab wsh_util_core.id_tab_type;
102: l_doc_set_id NUMBER;
103:
104:
105: RECORD_LOCKED EXCEPTION;

Line 147: -- changed that to wsh_util_core.g_ret_sts_error below

143: END IF;
144:
145: -- OTM R12, there was no initialization to 'S' for x_return_status
146: -- Also, x_return_status was being used to add message earlier,
147: -- changed that to wsh_util_core.g_ret_sts_error below
148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
149: l_ignore := NULL;
150: l_tms_interface_flag := NULL;
151:

Line 148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

144:
145: -- OTM R12, there was no initialization to 'S' for x_return_status
146: -- Also, x_return_status was being used to add message earlier,
147: -- changed that to wsh_util_core.g_ret_sts_error below
148: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
149: l_ignore := NULL;
150: l_tms_interface_flag := NULL;
151:
152: IF NOT FND_API.compatible_api_call(l_api_version,p_api_version_number,l_api_name,G_PKG_NAME) THEN

Line 166: wsh_util_core.add_message(x_return_status,l_module_name);

162:
163: IF (p_action_prms.caller IS NULL) THEN
164: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
165: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.caller');
166: wsh_util_core.add_message(x_return_status,l_module_name);
167: raise fnd_api.g_exc_error;
168: END IF;
169: IF (p_action_prms.action_code IS NULL ) THEN
170: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 172: wsh_util_core.add_message(x_return_status,l_module_name);

168: END IF;
169: IF (p_action_prms.action_code IS NULL ) THEN
170: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
171: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.action_code');
172: wsh_util_core.add_message(x_return_status,l_module_name);
173: raise fnd_api.g_exc_error;
174: END IF;
175:
176: IF (nvl(p_action_prms.phase,1) < 1) THEN

Line 179: wsh_util_core.add_message(x_return_status,l_module_name);

175:
176: IF (nvl(p_action_prms.phase,1) < 1) THEN
177: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
178: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_action_prms.phase');
179: wsh_util_core.add_message(x_return_status,l_module_name);
180: raise fnd_api.g_exc_error;
181: END IF;
182:
183: IF (x_action_out_rec.x_delivery_id IS NULL) THEN

Line 186: wsh_util_core.add_message(x_return_status,l_module_name);

182:
183: IF (x_action_out_rec.x_delivery_id IS NULL) THEN
184: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
185: FND_MESSAGE.SET_TOKEN('FIELD_NAME','x_action_out_rec.x_delivery_id');
186: wsh_util_core.add_message(x_return_status,l_module_name);
187: raise fnd_api.g_exc_error;
188: END IF;
189:
190: IF (x_action_out_rec.x_trip_id IS NULL) THEN

Line 193: wsh_util_core.add_message(x_return_status,l_module_name);

189:
190: IF (x_action_out_rec.x_trip_id IS NULL) THEN
191: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
192: FND_MESSAGE.SET_TOKEN('FIELD_NAME','x_action_out_rec.x_trip_id');
193: wsh_util_core.add_message(x_return_status,l_module_name);
194: raise fnd_api.g_exc_error;
195: END IF;
196:
197: IF ( p_rec_attr_tab.count < 0 ) THEN

Line 200: wsh_util_core.add_message(x_return_status,l_module_name);

196:
197: IF ( p_rec_attr_tab.count < 0 ) THEN
198: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
199: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_rec_attr_tab.count');
200: wsh_util_core.add_message(x_return_status,l_module_name);
201: raise fnd_api.g_exc_error;
202: END IF;
203:
204: WSH_ACTIONS_LEVELS.set_validation_level (

Line 217: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

213: WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL));
214: WSH_DEBUG_SV.log(l_module_name,'C_TRIP_SMC_LVL',
215: WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_SMC_LVL));
216: END IF;
217: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
218: x_num_warnings =>l_num_warnings,
219: x_num_errors =>l_num_errors);
220:
221: l_index := p_rec_attr_tab.FIRST;

Line 277: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

273: WSH_DELIVERY_LEGS_PVT.Lock_Delivery_Leg(
274: p_rowid => p_rec_attr_tab(l_index).rowid,
275: p_delivery_leg_info => p_rec_attr_tab(l_index));
276:
277: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
278: x_num_warnings =>l_loop_warnings,
279: x_num_errors =>l_num_errors);
280: END IF;
281:

Line 291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

287: /*3301344 : Get the trip name from trip id */
288: l_trip_name := wsh_trips_pvt.get_name(x_action_out_rec.x_trip_id);
289:
290: IF (l_ship_method_code IS NULL ) THEN
291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
292: /*3301344*/
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
295: END IF;

Line 299: wsh_util_core.add_message(l_return_status,l_module_name);

295: END IF;
296:
297: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
298: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
299: wsh_util_core.add_message(l_return_status,l_module_name);
300:
301: RAISE wsh_create_document_error;
302:
303: END IF;

Line 311: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

307: /* IF l_debug_on THEN
308: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
309: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
310: END IF;
311: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
312: x_num_warnings =>l_loop_warnings,
313: x_num_errors =>l_num_errors);
314: */
315: END IF;

Line 362: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

358: IF l_debug_on THEN
359: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
360: END IF;
361:
362: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
363: x_num_warnings =>l_loop_warnings,
364: x_num_errors =>l_num_errors);
365:
366: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_BOL_NUM_LVL) = 1) THEN

Line 377: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

373: AND wdi.status <> 'CANCELLED'
374: AND wdl.delivery_leg_id = l_delivery_leg_id;--p_rec_attr_tab(l_index).delivery_leg_id;
375:
376: IF (l_bol_number > 0 ) THEN
377: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: END IF;
379:
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.log(l_module_name,'l_bol_number',l_bol_number);

Line 384: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

380: IF l_debug_on THEN
381: WSH_DEBUG_SV.log(l_module_name,'l_bol_number',l_bol_number);
382: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
383: END IF;
384: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
385: x_num_warnings =>l_loop_warnings,
386: x_num_errors =>l_num_errors);
387: END IF;
388:

Line 413: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

409: IF l_debug_on THEN
410: WSH_DEBUG_SV.log(l_module_name,' x_action_out_rec.x_bol_number: '|| x_action_out_rec.x_bol_number);
411: WSH_DEBUG_SV.log(l_module_name,'WSH_BOLS_PVT.Insert_Row l_return_status',l_return_status);
412: END IF;
413: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
414: x_num_warnings =>l_loop_warnings,
415: x_num_errors =>l_num_errors);
416:
417: ELSIF (p_action_prms.action_code = 'PRINT-BOL') THEN

Line 504: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

500: x_msg_data => l_msg_data);
501:
502: x_action_out_rec := l_action_out_rec;
503:
504: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
505: x_num_warnings =>l_loop_warnings,
506: x_num_errors =>l_num_errors);
507:
508: -- }

Line 532: wsh_util_core.api_post_call(

528: p_delivery_ids => l_delivery_id_tab,
529: p_document_param_info => l_dummy_doc_set_params,
530: x_return_status => l_return_status);
531:
532: wsh_util_core.api_post_call(
533: p_return_status => l_return_status,
534: x_num_warnings => l_loop_warnings,
535: x_num_errors => l_num_errors,
536: p_msg_data => l_msg_data );

Line 575: x_return_status := wsh_util_core.g_ret_sts_error;

571: ROLLBACK TO action_genbol_sp;
572: ELSIF p_action_prms.action_code = 'PRINT-BOL' THEN
573: ROLLBACK TO action_prnbol_sp;
574: END IF;
575: x_return_status := wsh_util_core.g_ret_sts_error;
576: --
577: -- Debug Statements
578: --
579: IF l_debug_on THEN

Line 670: raise WSH_UTIL_CORE.G_EXC_WARNING;

666:
667: IF (l_num_errors = p_rec_attr_tab.count ) THEN
668: raise FND_API.G_EXC_ERROR;
669: ELSIF (l_num_errors > 0 ) THEN
670: raise WSH_UTIL_CORE.G_EXC_WARNING;
671: ELSIF (l_num_warnings > 0 ) THEN
672: raise WSH_UTIL_CORE.G_EXC_WARNING;
673: ELSE
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 672: raise WSH_UTIL_CORE.G_EXC_WARNING;

668: raise FND_API.G_EXC_ERROR;
669: ELSIF (l_num_errors > 0 ) THEN
670: raise WSH_UTIL_CORE.G_EXC_WARNING;
671: ELSIF (l_num_warnings > 0 ) THEN
672: raise WSH_UTIL_CORE.G_EXC_WARNING;
673: ELSE
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675: END IF;
676:

Line 674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

670: raise WSH_UTIL_CORE.G_EXC_WARNING;
671: ELSIF (l_num_warnings > 0 ) THEN
672: raise WSH_UTIL_CORE.G_EXC_WARNING;
673: ELSE
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675: END IF;
676:
677:
678: IF FND_API.To_Boolean( p_commit ) THEN

Line 695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

691: END IF;
692:
693: EXCEPTION
694: WHEN RECORD_LOCKED THEN
695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
696: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
697: wsh_util_core.add_message(x_return_status,l_module_name);
698: FND_MSG_PUB.Count_And_Get (
699: p_count => x_msg_count,

Line 697: wsh_util_core.add_message(x_return_status,l_module_name);

693: EXCEPTION
694: WHEN RECORD_LOCKED THEN
695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
696: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
697: wsh_util_core.add_message(x_return_status,l_module_name);
698: FND_MSG_PUB.Count_And_Get (
699: p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => FND_API.G_FALSE);

Line 711: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

707: END IF;
708:
709:
710: WHEN FND_API.G_EXC_ERROR THEN
711: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
712: FND_MSG_PUB.Count_And_Get (
713: p_count => x_msg_count,
714: p_data => x_msg_data,
715: p_encoded => FND_API.G_FALSE);

Line 725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

721: END IF;
722:
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
726: FND_MSG_PUB.Count_And_Get (
727: p_count => x_msg_count,
728: p_data => x_msg_data,
729: p_encoded => FND_API.G_FALSE);

Line 738: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
735: END IF;
736:
737:
738: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
739: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
740: FND_MSG_PUB.Count_And_Get (
741: p_count => x_msg_count,
742: p_data => x_msg_data,

Line 739: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

735: END IF;
736:
737:
738: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
739: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
740: FND_MSG_PUB.Count_And_Get (
741: p_count => x_msg_count,
742: p_data => x_msg_data,
743: p_encoded => FND_API.G_FALSE);

Line 747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

743: p_encoded => FND_API.G_FALSE);
744: IF l_debug_on THEN
745: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
746: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
749: END IF;
750:
751:

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

744: IF l_debug_on THEN
745: WSH_DEBUG_SV.log(l_module_name,'Message Count',x_msg_count);
746: WSH_DEBUG_SV.log(l_module_name,'Message Data', x_msg_data);
747: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
749: END IF;
750:
751:
752: WHEN OTHERS THEN

Line 753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

749: END IF;
750:
751:
752: WHEN OTHERS THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');
755: FND_MSG_PUB.Count_And_Get (
756: p_count => x_msg_count,
757: p_data => x_msg_data,

Line 754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');

750:
751:
752: WHEN OTHERS THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');
755: FND_MSG_PUB.Count_And_Get (
756: p_count => x_msg_count,
757: p_data => x_msg_data,
758: p_encoded => FND_API.G_FALSE);

Line 837: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

833: IF l_debug_on THEN
834: WSH_DEBUG_SV.push(l_module_name);
835: END IF;
836:
837: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
838:
839: IF (p_in_rec.action_code= 'UPDATE') THEN
840:
841: FOR l_index in p_delivery_leg_tab.FIRST .. p_delivery_leg_tab.LAST LOOP

Line 885: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

881: x_del_leg_rec => l_delivery_leg_rec,
882: x_return_status => x_return_status);
883:
884:
885: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
886: IF l_debug_on THEN
887: WSH_DEBUG_SV.pop(l_module_name);
888: END IF;
889:

Line 905: WSH_UTIL_CORE.api_post_call(

901:
902: IF l_debug_on THEN
903: WSH_DEBUG_SV.log(l_module_name,'Update_Delivery_Leg x_return_status',l_return_status);
904: END IF;
905: WSH_UTIL_CORE.api_post_call(
906: p_return_status => l_return_status,
907: x_num_warnings => l_num_warnings,
908: x_num_errors => l_num_errors,
909: p_module_name => l_module_name,

Line 926: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

922:
923: EXCEPTION
924:
925: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
926: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
927: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
928: wsh_util_core.add_message(x_return_status,l_module_name);
929: IF l_debug_on THEN
930: wsh_debug_sv.log(l_module_name, 'Could not lock delivery', l_delivery_id);

Line 928: wsh_util_core.add_message(x_return_status,l_module_name);

924:
925: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
926: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
927: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
928: wsh_util_core.add_message(x_return_status,l_module_name);
929: IF l_debug_on THEN
930: wsh_debug_sv.log(l_module_name, 'Could not lock delivery', l_delivery_id);
931: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

Line 941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);

937:
938: IF c_is_final_leg%isopen THEN
939: close c_is_final_leg;
940: END IF;
941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

938: IF c_is_final_leg%isopen THEN
939: close c_is_final_leg;
940: END IF;
941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
946: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1047: IF l_debug_on THEN
1048: WSH_DEBUG_SV.push(l_module_name);
1049: END IF;
1050:
1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1052:
1053: OPEN c_get_leg_record(p_del_leg_rec.delivery_leg_id);
1054: FETCH c_get_leg_record INTO l_dleg_rec;
1055: IF c_get_leg_record%NOTFOUND THEN

Line 1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);

1399:
1400: EXCEPTION
1401:
1402: WHEN others THEN
1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1405: --
1406: IF c_get_leg_record%isopen THEN
1407: CLOSE c_get_leg_record;

Line 1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1400: EXCEPTION
1401:
1402: WHEN others THEN
1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1405: --
1406: IF c_get_leg_record%isopen THEN
1407: CLOSE c_get_leg_record;
1408: END IF;