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

Line 79: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

75: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
76: --
77: END IF;
78: --
79: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
80: --
81:
82: OPEN c_get_seq_num(p_trip_id);
83: FETCH c_get_seq_num INTO x_sequence_number;

Line 107: x_return_status := wsh_util_core.g_ret_sts_error;

103: END IF;
104:
105: FND_MESSAGE.SET_NAME('WSH','WSH_MBOL_NULL_FREIGHT_CODE');
106: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
107: x_return_status := wsh_util_core.g_ret_sts_error;
108: wsh_util_core.add_message(x_return_status);
109: RAISE wsh_create_document_error;
110: END IF;
111:

Line 108: wsh_util_core.add_message(x_return_status);

104:
105: FND_MESSAGE.SET_NAME('WSH','WSH_MBOL_NULL_FREIGHT_CODE');
106: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
107: x_return_status := wsh_util_core.g_ret_sts_error;
108: wsh_util_core.add_message(x_return_status);
109: RAISE wsh_create_document_error;
110: END IF;
111:
112: WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO(

Line 122: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

118: x_org_id => l_org_id,
119: p_entity_id => p_trip_id,
120: p_entity_type => WSH_FTE_INTEGRATION.C_ORG_INFO_TRIP,
121: p_org_id_flag => FND_API.G_TRUE);
122: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
123: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
124: --
125: IF l_debug_on THEN
126: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID not found, so MBOL cannot be Created.');

Line 123: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

119: p_entity_id => p_trip_id,
120: p_entity_type => WSH_FTE_INTEGRATION.C_ORG_INFO_TRIP,
121: p_org_id_flag => FND_API.G_TRUE);
122: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
123: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
124: --
125: IF l_debug_on THEN
126: WSH_DEBUG_SV.logmsg(l_module_name, 'ORG_ID not found, so MBOL cannot be Created.');
127: END IF;

Line 137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

133: -- if operating unit/organization cannot be associated with the trip,
134: -- let the user know what to do in order to generate MBOL.
135: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_NO_ORG_FOR_MBOL');
136: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
138: wsh_util_core.add_message(x_return_status);
139: RAISE wsh_create_document_error;
140: END IF;
141:

Line 138: wsh_util_core.add_message(x_return_status);

134: -- let the user know what to do in order to generate MBOL.
135: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_NO_ORG_FOR_MBOL');
136: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
138: wsh_util_core.add_message(x_return_status);
139: RAISE wsh_create_document_error;
140: END IF;
141:
142:

Line 146: WSH_UTIL_CORE.Get_Ledger_id_Func_Currency(

142:
143: -- LE Uptake
144: --R12: MOAC passing ORG_ID
145: --Get Ledger ID into l_ledger_id.
146: WSH_UTIL_CORE.Get_Ledger_id_Func_Currency(
147: p_org_id => l_org_id,
148: x_ledger_id => l_ledger_id,
149: x_func_currency => l_func_currency,
150: x_return_status => l_return_status);

Line 152: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

148: x_ledger_id => l_ledger_id,
149: x_func_currency => l_func_currency,
150: x_return_status => l_return_status);
151:
152: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
153: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name, 'Ledger ID not found, so MBOL cannot be Created.');

Line 153: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

149: x_func_currency => l_func_currency,
150: x_return_status => l_return_status);
151:
152: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
153: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
154: --
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name, 'Ledger ID not found, so MBOL cannot be Created.');
157: END IF;

Line 197: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

193: , x_document_number => l_document_number);
194:
195: x_sequence_number := l_document_number;
196:
197: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
198: RAISE wsh_create_document_error;
199: END IF;
200:
201: Generate_Bols( p_trip_id => p_trip_id,

Line 204: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

200:
201: Generate_Bols( p_trip_id => p_trip_id,
202: x_return_status => l_return_status );
203:
204: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
205: RAISE wsh_create_document_error;
206: END IF;
207: --
208: --

Line 218: x_return_status := wsh_util_core.g_ret_sts_error;

214: --
215: EXCEPTION
216: WHEN wsh_create_document_error THEN
217: ROLLBACK TO Print_Mbol_Pvt;
218: x_return_status := wsh_util_core.g_ret_sts_error;
219: --
220: -- Debug Statements
221: --
222: IF l_debug_on THEN

Line 228: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_MBOL',l_module_name);

224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
225: END IF;
226: --
227: WHEN OTHERS THEN
228: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_MBOL',l_module_name);
229: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.pop(l_module_name,'When Others');
232: END IF;

Line 229: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

225: END IF;
226: --
227: WHEN OTHERS THEN
228: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_MBOL',l_module_name);
229: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.pop(l_module_name,'When Others');
232: END IF;
233:

Line 309: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

305: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
306: --
307: END IF;
308: --
309: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
310: --
311:
312: OPEN c_get_delivery_info(p_trip_id);
313: LOOP

Line 333: x_return_status := wsh_util_core.g_ret_sts_error;

329:
330: IF l_ship_method_code IS NULL THEN
331: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
332: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
333: x_return_status := wsh_util_core.g_ret_sts_error;
334: wsh_util_core.add_message(x_return_status);
335: CLOSE c_get_delivery_info;
336: RAISE wsh_create_document_error;
337: END IF;

Line 334: wsh_util_core.add_message(x_return_status);

330: IF l_ship_method_code IS NULL THEN
331: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
332: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
333: x_return_status := wsh_util_core.g_ret_sts_error;
334: wsh_util_core.add_message(x_return_status);
335: CLOSE c_get_delivery_info;
336: RAISE wsh_create_document_error;
337: END IF;
338:

Line 343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

339: OPEN c_get_ledger_id(l_delivery_id);
340: FETCH c_get_ledger_id INTO l_ledger_id;
341: IF c_get_ledger_id%NOTFOUND THEN
342: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
344: wsh_util_core.add_message(x_return_status);
345: CLOSE c_get_delivery_info;
346: RAISE wsh_create_document_error;
347: END IF;

Line 344: wsh_util_core.add_message(x_return_status);

340: FETCH c_get_ledger_id INTO l_ledger_id;
341: IF c_get_ledger_id%NOTFOUND THEN
342: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
344: wsh_util_core.add_message(x_return_status);
345: CLOSE c_get_delivery_info;
346: RAISE wsh_create_document_error;
347: END IF;
348: IF c_get_ledger_id%ISOPEN THEN

Line 371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

367: , p_consolidate_option => 'BOTH'
368: , p_manual_sequence_number => 200
369: , x_document_number => l_document_number);
370:
371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
372: CLOSE c_get_delivery_info;
373: RAISE wsh_create_document_error;
374: END IF;
375: --

Line 391: x_return_status := wsh_util_core.g_ret_sts_error;

387: END IF;
388: --
389: EXCEPTION
390: WHEN wsh_create_document_error THEN
391: x_return_status := wsh_util_core.g_ret_sts_error;
392: --
393: -- Debug Statements
394: --
395: IF l_debug_on THEN

Line 401: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_BOLs',l_module_name);

397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
398: END IF;
399: --
400: WHEN OTHERS THEN
401: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_BOLs',l_module_name);
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.pop(l_module_name,'When Others');
405: END IF;

Line 402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

398: END IF;
399: --
400: WHEN OTHERS THEN
401: wsh_util_core.default_handler('WSH_MBOLS_PVT.Generate_BOLs',l_module_name);
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.pop(l_module_name,'When Others');
405: END IF;
406:

Line 477: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

473: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
474: --
475: END IF;
476: --
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
478: --
479:
480:
481:

Line 591: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

587: raise err_mbol_submission;
588: ELSE
589: FND_MESSAGE.SET_NAME('WSH', 'WSH_MBOL_SUBMITTED');
590: FND_MESSAGE.SET_TOKEN('REQ_ID', to_char(l_request_id));
591: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
592: END if;
593:
594: --
595: -- Debug Statements

Line 604: x_return_status := wsh_util_core.g_ret_sts_error;

600: --
601:
602: EXCEPTION
603: WHEN err_mbol_submission THEN
604: x_return_status := wsh_util_core.g_ret_sts_error;
605: fnd_message.set_name('WSH', 'WSH_MBOL_FAILED');
606: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.logmsg(l_module_name,'err_mbol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 606: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

602: EXCEPTION
603: WHEN err_mbol_submission THEN
604: x_return_status := wsh_util_core.g_ret_sts_error;
605: fnd_message.set_name('WSH', 'WSH_MBOL_FAILED');
606: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.logmsg(l_module_name,'err_mbol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_mbol_submission');
610: END IF;

Line 613: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);

609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_mbol_submission');
610: END IF;
611: --
612: WHEN OTHERS THEN
613: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
617: END IF;

Line 614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

610: END IF;
611: --
612: WHEN OTHERS THEN
613: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
617: END IF;
618:

Line 694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

690: wsh_debug_sv.log(l_module_name, 'p_conc_request_id', p_conc_request_id );
691: --
692: END IF;
693: --
694: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
695: --
696:
697:
698: OPEN c_conc_prog_csr('WSHRDBOL');

Line 803: WSH_UTIL_CORE.PrintMsg('Bill of Lading concurrent request submitted for request ID:' || to_char(l_request_id) );

799:
800: IF (l_request_id = 0) THEN
801: raise err_bol_submission;
802: ELSE
803: WSH_UTIL_CORE.PrintMsg('Bill of Lading concurrent request submitted for request ID:' || to_char(l_request_id) );
804: END IF;
805:
806: --
807: -- Debug Statements

Line 815: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

811: END IF;
812: --
813: EXCEPTION
814: WHEN err_bol_submission THEN
815: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
816: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to submit Bill of Lading concurrent request');
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name,'err_bol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');

Line 816: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to submit Bill of Lading concurrent request');

812: --
813: EXCEPTION
814: WHEN err_bol_submission THEN
815: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
816: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to submit Bill of Lading concurrent request');
817: IF l_debug_on THEN
818: WSH_DEBUG_SV.logmsg(l_module_name,'err_bol_submission exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');
820: END IF;

Line 823: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);

819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:err_bol_submission');
820: END IF;
821: --
822: WHEN OTHERS THEN
823: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
827: END IF;

Line 824: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

820: END IF;
821: --
822: WHEN OTHERS THEN
823: wsh_util_core.default_handler('WSH_MBOLS_PVT.Print_MBOL',l_module_name);
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
827: END IF;
828: END Print_BOLs;

Line 890: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

886: --
887: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
888: END IF;
889: --
890: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
891:
892: SAVEPOINT cancel_mbol1;
893:
894: OPEN mbol_num_cur(p_trip_id);

Line 931: IF (l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

927: p_entity_id => p_trip_id,
928: p_document_type => 'MBOL'
929: );
930:
931: IF (l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
932: raise wsh_cancel_mbol_error;
933: END IF;
934: END LOOP;
935: END IF;

Line 943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

939: IF l_debug_on THEN
940: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
941: END IF;
942: ELSE
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
944: END IF;
945:
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.pop(l_module_name);

Line 953: x_return_status := wsh_util_core.g_ret_sts_error;

949: --
950: EXCEPTION
951: WHEN wsh_cancel_mbol_error THEN
952: ROLLBACK TO cancel_mbol1;
953: x_return_status := wsh_util_core.g_ret_sts_error;
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_MBOL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_MBOL_ERROR');

Line 961: x_return_status := wsh_util_core.g_ret_sts_error;

957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_MBOL_ERROR');
958: END IF;
959: --
960: WHEN record_locked THEN
961: x_return_status := wsh_util_core.g_ret_sts_error;
962: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
963: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
964: --
965: IF l_debug_on THEN

Line 963: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);

959: --
960: WHEN record_locked THEN
961: x_return_status := wsh_util_core.g_ret_sts_error;
962: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
963: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

Line 972: wsh_util_core.default_handler('WSH_MBOLS_PVT.cancel_mbol',l_module_name);

968: END IF;
969: --
970: WHEN OTHERS THEN
971: ROLLBACK TO cancel_mbol1;
972: wsh_util_core.default_handler('WSH_MBOLS_PVT.cancel_mbol',l_module_name);
973: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 973: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

969: --
970: WHEN OTHERS THEN
971: ROLLBACK TO cancel_mbol1;
972: wsh_util_core.default_handler('WSH_MBOLS_PVT.cancel_mbol',l_module_name);
973: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1034: --
1035: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1036: END IF;
1037: --
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1039:
1040: open get_shipments_type_flag;
1041: fetch get_shipments_type_flag into l_shipments_type_flag;
1042: close get_shipments_type_flag;

Line 1094: wsh_util_core.default_handler('WSH_MBOLS_PVT.Get_Organization_of_MBOL',l_module_name);

1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093:
1094: wsh_util_core.default_handler('WSH_MBOLS_PVT.Get_Organization_of_MBOL',l_module_name);
1095: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1096: --
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1095: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1091: EXCEPTION
1092: WHEN OTHERS THEN
1093:
1094: wsh_util_core.default_handler('WSH_MBOLS_PVT.Get_Organization_of_MBOL',l_module_name);
1095: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1096: --
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');