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

Line 87: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

83: l_sql_err VARCHAR2(32767);
84: --
85: BEGIN
86: --{
87: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
88: --
89: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
90: IF l_debug_on IS NULL THEN
91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 168: wsh_util_core.api_post_call

164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
166: END IF;
167: --
168: wsh_util_core.api_post_call
169: (
170: p_return_status => l_return_status,
171: x_num_warnings => l_num_warnings,
172: x_num_errors => l_num_errors,

Line 202: WSH_UTIL_CORE.api_post_call

198: WSH_DEBUG_SV.log(l_module_name, 'l_sql_err', l_sql_err);
199: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
200: END IF;
201: --
202: WSH_UTIL_CORE.api_post_call
203: (
204: p_return_status => l_return_status,
205: x_num_warnings => l_num_warnings,
206: x_num_errors => l_num_errors

Line 233: WSH_UTIL_CORE.api_post_call

229: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling create_Site', WSH_DEBUG_SV.C_PROC_LEVEL);
230: WSH_DEBUG_SV.log(l_module_name, 'Return Status', l_return_status);
231: END IF;
232: --
233: WSH_UTIL_CORE.api_post_call
234: (
235: p_return_status => l_return_status,
236: x_num_warnings => l_num_warnings,
237: x_num_errors => l_num_errors

Line 246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

242: END LOOP;
243: --
244: IF l_num_errors > 0
245: THEN
246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
247: ELSIF l_num_warnings > 0
248: THEN
249: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
250: ELSE

Line 249: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

245: THEN
246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
247: ELSIF l_num_warnings > 0
248: THEN
249: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
250: ELSE
251: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
252: END IF;
253: --

Line 251: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

247: ELSIF l_num_warnings > 0
248: THEN
249: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
250: ELSE
251: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
252: END IF;
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

259: EXCEPTION
260: --
261: WHEN FND_API.G_EXC_ERROR THEN
262: --
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
264: --
265: IF l_debug_on THEN
266: --
267: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 274: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

270: END IF;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --
274: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
275: --
276: IF l_debug_on THEN
277: --
278: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

281: END IF;
282: --
283: WHEN OTHERS THEN
284: --
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
286: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.InactivatePartySites');
287: --
288: IF l_debug_on THEN
289: --

Line 286: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.InactivatePartySites');

282: --
283: WHEN OTHERS THEN
284: --
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
286: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.InactivatePartySites');
287: --
288: IF l_debug_on THEN
289: --
290: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));

Line 424: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

420: l_count NUMBER;
421: --
422: BEGIN
423: --{
424: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
425: --
426: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
427: IF l_debug_on IS NULL THEN
428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 474: WSH_UTIL_CORE.api_post_call

470: IF l_debug_on THEN
471: wsh_debug_sv.log(l_module_name, 'Return Status from inactivatePartySites', l_return_status);
472: END IF;
473: --
474: WSH_UTIL_CORE.api_post_call
475: (
476: p_return_status => l_return_status,
477: x_num_warnings => l_num_warnings,
478: x_num_errors => l_num_errors

Line 498: WSH_UTIL_CORE.printMsg(l_msg);

494: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
495: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
496: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
497: l_msg := FND_MESSAGE.GET;
498: WSH_UTIL_CORE.printMsg(l_msg);
499: --
500: IF l_debug_on THEN
501: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
502: END IF;

Line 523: wsh_util_core.api_post_call(

519: IF l_debug_on THEN
520: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_XC_UTIL.LOG_EXCEPTION is ', l_return_status);
521: END IF;
522: --
523: wsh_util_core.api_post_call(
524: p_return_status => l_return_status,
525: x_num_warnings => l_num_warnings,
526: x_num_errors => l_num_errors,
527: p_msg_data => l_xc_msg_data

Line 625: wsh_util_core.printMsg( l_msg );

621: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: --
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.pop(l_module_name);

Line 626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

622: fnd_message.set_token( 'LOC_CODE', l_location_code );
623: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
624: l_msg := FND_MESSAGE.GET;
625: wsh_util_core.printMsg( l_msg );
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: --
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.pop(l_module_name);
630: END IF;

Line 664: wsh_util_core.api_post_call(

660: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_SUPPLIER_PARTY.CREATE_HZ_PARTY_SITE is', l_return_status);
661: --
662: END IF;
663: --
664: wsh_util_core.api_post_call(
665: p_return_status => l_return_status,
666: x_num_warnings => l_num_warnings,
667: x_num_errors => l_num_errors
668: );

Line 688: wsh_util_core.api_post_call(

684: wsh_debug_sv.log(l_module_name, 'l_return_status', l_return_status);
685: wsh_debug_sv.log(l_module_name, 'l_party_site_use_id', l_party_site_use_id);
686: END IF;
687: --
688: wsh_util_core.api_post_call(
689: p_return_status => l_return_status,
690: x_num_warnings => l_num_warnings,
691: x_num_errors => l_num_errors
692: );

Line 704: wsh_util_core.api_post_call(

700: p_location_source_code => 'HZ',
701: x_return_status => l_return_status
702: );
703: --
704: wsh_util_core.api_post_call(
705: p_return_status => l_return_status,
706: x_num_warnings => l_num_warnings,
707: x_num_errors => l_num_errors
708: );

Line 730: wsh_util_core.api_post_call(

726: IF l_debug_on THEN
727: wsh_debug_sv.log(l_module_name, 'Return status from InactivatePartySite', l_return_status);
728: END IF;
729: --
730: wsh_util_core.api_post_call(
731: p_return_status => l_return_status,
732: x_num_warnings => l_num_warnings,
733: x_num_errors => l_num_errors
734: );

Line 757: WSH_UTIL_CORE.printMsg(l_msg);

753: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
754: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
755: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
756: l_msg := FND_MESSAGE.GET;
757: WSH_UTIL_CORE.printMsg(l_msg);
758: --
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
761: END IF;

Line 782: wsh_util_core.api_post_call(

778: IF l_debug_on THEN
779: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_XC_UTIL.LOG_EXCEPTION is ', l_return_status);
780: END IF;
781: --
782: wsh_util_core.api_post_call(
783: p_return_status => l_return_status,
784: x_num_warnings => l_num_warnings,
785: x_num_errors => l_num_errors,
786: p_msg_data => l_xc_msg_data

Line 809: wsh_util_core.api_post_call(

805: IF l_debug_on THEN
806: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_SUPPLIER_PARTY.PROCESS_HZ_CONTACT', l_return_status);
807: END IF;
808: --
809: wsh_util_core.api_post_call(
810: p_return_status => l_return_status,
811: x_num_warnings => l_num_warnings,
812: x_num_errors => l_num_errors
813: );

Line 816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

812: x_num_errors => l_num_errors
813: );
814: --
815: IF l_num_errors > 0 THEN
816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
817: ELSIF l_num_warnings > 0 THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
819: END IF;
820: --

Line 818: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

814: --
815: IF l_num_errors > 0 THEN
816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
817: ELSIF l_num_warnings > 0 THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
819: END IF;
820: --
821: IF l_debug_on THEN
822: WSH_DEBUG_SV.pop(l_module_name);

Line 829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

825: EXCEPTION
826: --
827: WHEN FND_API.G_EXC_ERROR THEN
828: --
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
830: --
831: IF l_debug_on THEN
832: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 838: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

834: END IF;
835: --
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: --
838: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
839: --
840: IF l_debug_on THEN
841: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
842: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 847: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

843: END IF;
844: --
845: WHEN OTHERS THEN
846: --
847: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
848: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Create_Site');
849: --
850: IF l_debug_on THEN
851: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));

Line 848: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Create_Site');

844: --
845: WHEN OTHERS THEN
846: --
847: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
848: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Create_Site');
849: --
850: IF l_debug_on THEN
851: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));
852: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 903: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

899:
900: --
901: BEGIN
902: --{
903: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
904: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
905: IF l_debug_on IS NULL THEN
906: --{
907: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1022: wsh_util_core.api_post_call(

1018: P_delivery_name =>l_dlvy_name,
1019: P_location_id =>l_location_id,
1020: x_return_status =>l_return_status
1021: );
1022: wsh_util_core.api_post_call(
1023: p_return_status => l_return_status,
1024: x_num_warnings => l_num_warnings,
1025: x_num_errors => l_num_errors
1026: );

Line 1037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1033: END IF;
1034:
1035: IF l_num_errors > 0 THEN
1036: --{
1037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1038: ELSIF l_num_warnings > 0 THEN
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1040: --}
1041: END IF;

Line 1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1035: IF l_num_errors > 0 THEN
1036: --{
1037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1038: ELSIF l_num_warnings > 0 THEN
1039: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1040: --}
1041: END IF;
1042: --
1043: IF l_debug_on THEN

Line 1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1047: EXCEPTION
1048: --
1049: WHEN FND_API.G_EXC_ERROR THEN
1050: --
1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1052: --
1053: IF l_debug_on THEN
1054: --
1055: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1058: END IF;
1059: --
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: --
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1063: --
1064: IF l_debug_on THEN
1065: --
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1069: END IF;
1070: --
1071: WHEN OTHERS THEN
1072: --
1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1074: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_New_Delivery');
1075: --
1076: IF l_debug_on THEN
1077: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1074: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_New_Delivery');

1070: --
1071: WHEN OTHERS THEN
1072: --
1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1074: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_New_Delivery');
1075: --
1076: IF l_debug_on THEN
1077: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1078: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1197: BEGIN
1198:
1199:
1200: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1202:
1203: IF l_debug_on IS NULL THEN
1204: --{
1205: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1268: wsh_util_core.api_post_call

1264: p_from_supplier_name => p_from_supplier_name,
1265: x_return_status => l_return_status
1266: );
1267: --
1268: wsh_util_core.api_post_call
1269: (
1270: p_return_status => l_return_status,
1271: x_num_warnings => l_num_warnings,
1272: x_num_errors => l_num_errors

Line 1359: wsh_util_core.api_post_call

1355: WSH_DEBUG_SV.log(l_module_name, 'Return status from CAL. API', l_return_status);
1356: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID', l_CalAsgId);
1357: END IF;
1358: --
1359: wsh_util_core.api_post_call
1360: (
1361: p_return_status => l_return_status,
1362: x_num_warnings => l_num_warnings,
1363: x_num_errors => l_num_errors,

Line 1395: wsh_util_core.printMsg( l_msg );

1391: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1392: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1393: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1394: l_msg := FND_MESSAGE.GET;
1395: wsh_util_core.printMsg( l_msg );
1396: --}
1397: END IF;--IF (check_dup_assignment%NOTFOUND)
1398:
1399: CLOSE check_dup_assignment;

Line 1423: wsh_util_core.api_post_call

1419: IF l_debug_on THEN
1420: wsh_debug_sv.log(l_module_name, 'Return Status from InactivatePartySites', l_return_status);
1421: END IF;
1422: --
1423: wsh_util_core.api_post_call
1424: (
1425: p_return_status => l_return_status,
1426: x_num_warnings => l_num_warnings,
1427: x_num_errors => l_num_errors,

Line 1435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1431: END IF;
1432: --
1433: IF l_num_errors > 0 THEN
1434: --{
1435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1436: ELSIF l_num_warnings > 0 THEN
1437: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1438: --}
1439: END IF;

Line 1437: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1433: IF l_num_errors > 0 THEN
1434: --{
1435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1436: ELSIF l_num_warnings > 0 THEN
1437: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1438: --}
1439: END IF;
1440: --
1441: IF l_debug_on THEN

Line 1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1445: EXCEPTION
1446: --
1447: WHEN FND_API.G_EXC_ERROR THEN
1448: --
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: --
1451: IF l_debug_on THEN
1452: --
1453: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1456: END IF;
1457: --
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: --
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1461: --
1462: IF l_debug_on THEN
1463: --
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1467: END IF;
1468: --
1469: WHEN OTHERS THEN
1470: --
1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1472: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_Non_PO_Entities');
1473: --
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1472: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_Non_PO_Entities');

1468: --
1469: WHEN OTHERS THEN
1470: --
1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1472: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_Non_PO_Entities');
1473: --
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1559: l_delivery_list wsh_util_core.id_tab_type;

1555: AND d.delivery_detail_id = w.delivery_detail_id
1556: AND w.delivery_id = wnd.delivery_id(+)
1557: AND nvl(w.type, 'S') IN ('S' ,'O');
1558: --
1559: l_delivery_list wsh_util_core.id_tab_type;
1560: l_dd_list wsh_util_core.id_tab_type;
1561: --
1562:
1563: CURSOR find_delivery IS

Line 1560: l_dd_list wsh_util_core.id_tab_type;

1556: AND w.delivery_id = wnd.delivery_id(+)
1557: AND nvl(w.type, 'S') IN ('S' ,'O');
1558: --
1559: l_delivery_list wsh_util_core.id_tab_type;
1560: l_dd_list wsh_util_core.id_tab_type;
1561: --
1562:
1563: CURSOR find_delivery IS
1564: SELECT distinct delivery_id

Line 1631: l_delivery_detail_tbl wsh_util_core.id_tab_type;

1627: WHERE delivery_id = p_delivery_id
1628: AND operation_type = 'VENDOR_MRG'
1629: AND temp_col IS NULL;
1630: --
1631: l_delivery_detail_tbl wsh_util_core.id_tab_type;
1632: --
1633: CURSOR dlvy_rr_csr(p_delivery_id NUMBER) IS
1634: SELECT wdd.delivery_detail_id,
1635: wdd.routing_req_id,

Line 1688: l_delivery_cache_tbl wsh_util_core.id_tab_type;

1684: l1_revision_number NUMBER;
1685: l1_parent_shipment_header_id NUMBER;
1686: --
1687:
1688: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1689: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1690: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1691: l_dlvy_tbl wsh_util_core.id_tab_type;
1692: l_chk_delivery_id NUMBER :=0;

Line 1689: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;

1685: l1_parent_shipment_header_id NUMBER;
1686: --
1687:
1688: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1689: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1690: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1691: l_dlvy_tbl wsh_util_core.id_tab_type;
1692: l_chk_delivery_id NUMBER :=0;
1693: l_prev_new_rr_id NUMBER :=0;

Line 1691: l_dlvy_tbl wsh_util_core.id_tab_type;

1687:
1688: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1689: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1690: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1691: l_dlvy_tbl wsh_util_core.id_tab_type;
1692: l_chk_delivery_id NUMBER :=0;
1693: l_prev_new_rr_id NUMBER :=0;
1694: l_site_merge BOOLEAN;
1695: l_new_delivery_id NUMBER;

Line 1721: wsh_util_core.g_call_fte_load_tender_api := FALSE;

1717: --
1718: SAVEPOINT WSH_Vendor_Merge;
1719: --
1720: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1721: wsh_util_core.g_call_fte_load_tender_api := FALSE;
1722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1723:
1724: IF l_debug_on IS NULL THEN
1725: --{

Line 1722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1718: SAVEPOINT WSH_Vendor_Merge;
1719: --
1720: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1721: wsh_util_core.g_call_fte_load_tender_api := FALSE;
1722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1723:
1724: IF l_debug_on IS NULL THEN
1725: --{
1726: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1744: wsh_util_core.enable_concurrent_log_print ;

1740: WSH_DEBUG_SV.log(l_module_name,'P_CALLING_MODE', p_calling_mode);
1741: --}
1742: END IF;
1743:
1744: wsh_util_core.enable_concurrent_log_print ;
1745:
1746: -- find out if it is a vendor merge OR vendor site merge
1747: OPEN check_vendor_active(p_vendor_id => p_from_id);
1748: FETCH check_vendor_active INTO l_end_date_active, l_supplier_name;

Line 1761: wsh_util_core.printMsg( l_msg );

1757: END IF;
1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1760: l_msg := FND_MESSAGE.GET;
1761: wsh_util_core.printMsg( l_msg );
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1763: --
1764: IF l_debug_on THEN
1765: WSH_DEBUG_SV.pop(l_module_name);

Line 1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1758: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1759: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1760: l_msg := FND_MESSAGE.GET;
1761: wsh_util_core.printMsg( l_msg );
1762: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1763: --
1764: IF l_debug_on THEN
1765: WSH_DEBUG_SV.pop(l_module_name);
1766: END IF;

Line 1810: wsh_util_core.api_post_call(

1806: p_from_supplier_name => l_supplier_name,
1807: X_return_status => l_return_status
1808: );
1809: --
1810: wsh_util_core.api_post_call(
1811: p_return_status => l_return_status,
1812: x_num_warnings => l_num_warnings,
1813: x_num_errors => l_num_errors
1814: );

Line 1887: wsh_util_core.printMsg( l_msg );

1883: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1884: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1885: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1886: l_msg := FND_MESSAGE.GET;
1887: wsh_util_core.printMsg( l_msg );
1888: --}
1889: END IF;
1890: IF l_debug_on THEN
1891: --{

Line 1996: wsh_util_core.api_post_call(

1992: WSH_DEBUG_SV.log(l_module_name, 'New Delivery ID', l_new_delivery_id);
1993: --}
1994: END IF;
1995:
1996: wsh_util_core.api_post_call(
1997: p_return_status => l_return_status,
1998: x_num_warnings => l_num_warnings,
1999: x_num_errors => l_num_errors
2000: );

Line 2029: wsh_util_core.api_post_call(

2025: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2026: --}
2027: END IF;
2028:
2029: wsh_util_core.api_post_call(
2030: p_return_status => l_return_status,
2031: x_num_warnings => l_num_warnings,
2032: x_num_errors => l_num_errors
2033: );

Line 2069: wsh_util_core.api_post_call(

2065: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_INBOUND_UTIL_PKG.SPLIT_INBOUND_DELIVERY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2066: --}
2067: END IF;
2068:
2069: wsh_util_core.api_post_call(
2070: p_return_status => l_return_status,
2071: x_num_warnings => l_num_warnings,
2072: x_num_errors => l_num_errors
2073: );

Line 2124: wsh_util_core.api_post_call(

2120: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_VENDOR_PARTY_MERGE_PKG.UPDATE_NEW_DELIVERY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2121: --}
2122: END IF;
2123:
2124: wsh_util_core.api_post_call(
2125: p_return_status => l_return_status,
2126: x_num_warnings => l_num_warnings,
2127: x_num_errors => l_num_errors
2128: );

Line 2267: wsh_util_core.printMsg( l_msg );

2263: --
2264: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );
2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2271: --{

Line 2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2265: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2271: --{
2272: wsh_util_core.Reset_stops_for_load_tender(
2273: p_reset_flags=>true,

Line 2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2266: l_msg := FND_MESSAGE.GET;
2267: wsh_util_core.printMsg( l_msg );
2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2271: --{
2272: wsh_util_core.Reset_stops_for_load_tender(
2273: p_reset_flags=>true,
2274: x_return_status=>l_return_status

Line 2272: wsh_util_core.Reset_stops_for_load_tender(

2268:
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2271: --{
2272: wsh_util_core.Reset_stops_for_load_tender(
2273: p_reset_flags=>true,
2274: x_return_status=>l_return_status
2275: );
2276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 2276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2272: wsh_util_core.Reset_stops_for_load_tender(
2273: p_reset_flags=>true,
2274: x_return_status=>l_return_status
2275: );
2276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2277: --{
2278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2279: --}
2280: END IF;

Line 2278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2274: x_return_status=>l_return_status
2275: );
2276: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2277: --{
2278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2279: --}
2280: END IF;
2281: --}
2282: END IF;

Line 2318: wsh_util_core.api_post_call(

2314: --{
2315: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2316: --}
2317: END IF;
2318: wsh_util_core.api_post_call(
2319: p_return_status => l_return_status,
2320: x_num_warnings => l_num_warnings,
2321: x_num_errors => l_num_errors
2322: );

Line 2345: wsh_util_core.api_post_call(

2341: WSH_DEBUG_SV.log(l_module_name, 'New Txn ID', l_new_rr_id);
2342:
2343: --
2344: END IF;
2345: wsh_util_core.api_post_call(
2346: p_return_status => l_return_status,
2347: x_num_warnings => l_num_warnings,
2348: x_num_errors => l_num_errors
2349: );

Line 2365: WSH_UTIL_CORE.printMsg(l_msg);

2361: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2362: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2363: l_msg := FND_MESSAGE.GET;
2364: --
2365: WSH_UTIL_CORE.printMsg(l_msg);
2366: --
2367: l_exception_id := NULL;
2368: --
2369: wsh_xc_util.log_exception (

Line 2390: wsh_util_core.api_post_call(

2386: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_XC_UTIL.LOG_EXCEPTION is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2387: --
2388: END IF;
2389: --
2390: wsh_util_core.api_post_call(
2391: p_return_status => l_return_status,
2392: x_num_warnings => l_num_warnings,
2393: x_num_errors => l_num_errors,
2394: p_msg_data => l_xc_msg_data

Line 2509: wsh_util_core.api_post_call(

2505: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_DELIVERIES_GRP.DELIVERY_ACTION is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2506: --}
2507: END IF;
2508:
2509: wsh_util_core.api_post_call(
2510: p_return_status => l_return_status,
2511: x_num_warnings => l_num_warnings,
2512: x_num_errors => l_num_errors,
2513: p_msg_data => l_msg

Line 2556: wsh_util_core.api_post_call(

2552: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2553: --}
2554: END IF;
2555:
2556: wsh_util_core.api_post_call(
2557: p_return_status => l_return_status,
2558: x_num_warnings => l_num_warnings,
2559: x_num_errors => l_num_errors
2560: );

Line 2595: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2591: --}
2592: -- END IF; --IF (l_option= 'B' OR l_option = 'P')
2593:
2594: --
2595: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2596: --{
2597: wsh_util_core.Process_stops_for_load_tender(
2598: p_reset_flags=>true,
2599: x_return_status=>l_return_status);

Line 2597: wsh_util_core.Process_stops_for_load_tender(

2593:
2594: --
2595: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2596: --{
2597: wsh_util_core.Process_stops_for_load_tender(
2598: p_reset_flags=>true,
2599: x_return_status=>l_return_status);
2600: wsh_util_core.api_post_call(
2601: p_return_status => l_return_status,

Line 2600: wsh_util_core.api_post_call(

2596: --{
2597: wsh_util_core.Process_stops_for_load_tender(
2598: p_reset_flags=>true,
2599: x_return_status=>l_return_status);
2600: wsh_util_core.api_post_call(
2601: p_return_status => l_return_status,
2602: x_num_warnings => l_num_warnings,
2603: x_num_errors => l_num_errors
2604: );

Line 2613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2609: --
2610: IF l_num_errors > 0 THEN
2611: --{
2612: ROLLBACK TO WSH_Vendor_Merge;
2613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2614: ELSIF l_num_warnings > 0 THEN
2615: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2616: --}
2617: END IF;

Line 2615: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2611: --{
2612: ROLLBACK TO WSH_Vendor_Merge;
2613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2614: ELSIF l_num_warnings > 0 THEN
2615: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2616: --}
2617: END IF;
2618: --
2619: --Vendor Merge for RTV Transations

Line 2628: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2624: p_from_site_id => p_from_site_id,
2625: p_to_site_id => p_to_site_id ,
2626: x_return_status => x_return_status );
2627:
2628: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2629: --{
2630: ROLLBACK TO WSH_Vendor_Merge;
2631: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2632: END IF;

Line 2631: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2627:
2628: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2629: --{
2630: ROLLBACK TO WSH_Vendor_Merge;
2631: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2632: END IF;
2633:
2634: --End of Vendor Merge for RTV Transations
2635:

Line 2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2641: EXCEPTION
2642: --
2643: WHEN FND_API.G_EXC_ERROR THEN
2644: --
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2646: ROLLBACK TO WSH_Vendor_Merge;
2647: --
2648: IF l_debug_on THEN
2649: --

Line 2655: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2652: --
2653: END IF;
2654: --
2655: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2656: --
2657: wsh_util_core.Reset_stops_for_load_tender(
2658: p_reset_flags=>true,
2659: x_return_status=>l_return_status);

Line 2657: wsh_util_core.Reset_stops_for_load_tender(

2653: END IF;
2654: --
2655: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2656: --
2657: wsh_util_core.Reset_stops_for_load_tender(
2658: p_reset_flags=>true,
2659: x_return_status=>l_return_status);
2660: --
2661: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 2661: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2657: wsh_util_core.Reset_stops_for_load_tender(
2658: p_reset_flags=>true,
2659: x_return_status=>l_return_status);
2660: --
2661: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2663: END IF;
2664: --
2665: END IF;

Line 2662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2658: p_reset_flags=>true,
2659: x_return_status=>l_return_status);
2660: --
2661: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2663: END IF;
2664: --
2665: END IF;
2666: --

Line 2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2665: END IF;
2666: --
2667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2668: --
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2670: ROLLBACK TO WSH_Vendor_Merge;
2671: --
2672: IF l_debug_on THEN
2673: --

Line 2679: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2676: --
2677: END IF;
2678: --
2679: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2680: --
2681: wsh_util_core.Reset_stops_for_load_tender(
2682: p_reset_flags=>true,
2683: x_return_status=>l_return_status);

Line 2681: wsh_util_core.Reset_stops_for_load_tender(

2677: END IF;
2678: --
2679: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2680: --
2681: wsh_util_core.Reset_stops_for_load_tender(
2682: p_reset_flags=>true,
2683: x_return_status=>l_return_status);
2684: --
2685: END IF;

Line 2689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2685: END IF;
2686: --
2687: WHEN OTHERS THEN
2688: --
2689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2690: ROLLBACK TO WSH_Vendor_Merge;
2691: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Merge');
2692: --
2693: IF l_debug_on THEN

Line 2691: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Merge');

2687: WHEN OTHERS THEN
2688: --
2689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2690: ROLLBACK TO WSH_Vendor_Merge;
2691: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Merge');
2692: --
2693: IF l_debug_on THEN
2694: --
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2700: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2697: --
2698: END IF;
2699: --
2700: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2701: --
2702: wsh_util_core.Reset_stops_for_load_tender(
2703: p_reset_flags=>true,
2704: x_return_status=>l_return_status);

Line 2702: wsh_util_core.Reset_stops_for_load_tender(

2698: END IF;
2699: --
2700: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2701: --
2702: wsh_util_core.Reset_stops_for_load_tender(
2703: p_reset_flags=>true,
2704: x_return_status=>l_return_status);
2705: --
2706: END IF;

Line 2773: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2769: RTV_Exception exception;
2770: l_rec_exists varchar2(1);
2771: BEGIN
2772: --{
2773: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2774: --
2775: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2776: IF l_debug_on IS NULL THEN
2777: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 2856: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2852: END IF;
2853: --
2854: -- For AP, we interpret 'W' as 'S' status.
2855: --
2856: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2858: ELSE
2859: x_return_status := l_return_status;
2860: END IF;

Line 2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2853: --
2854: -- For AP, we interpret 'W' as 'S' status.
2855: --
2856: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2858: ELSE
2859: x_return_status := l_return_status;
2860: END IF;
2861: --

Line 2888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2884: --}
2885: --
2886: WHEN FND_API.G_EXC_ERROR THEN
2887: --
2888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2889: --
2890: IF l_debug_on THEN
2891: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2892: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2893: END IF;
2894: --
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: --
2897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2898: --
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2902: END IF;
2903: --
2904: WHEN OTHERS THEN
2905: --
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2907: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2909: --
2910: IF l_debug_on THEN

Line 2907: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);

2903: --
2904: WHEN OTHERS THEN
2905: --
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2907: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2909: --
2910: IF l_debug_on THEN
2911: WSH_DEBUG_SV.log(l_module_name, 'Unexpected error', substrb(sqlerrm, 1, 200));

Line 2908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);

2904: WHEN OTHERS THEN
2905: --
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2907: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2909: --
2910: IF l_debug_on THEN
2911: WSH_DEBUG_SV.log(l_module_name, 'Unexpected error', substrb(sqlerrm, 1, 200));
2912: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 2976: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2972: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_VENDOR_PARTY_MERGE_PKG.Get_Delivery_Hash()+' || getTimeStamp );
2973: END IF;
2974: --
2975:
2976: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2977: l_hash_count := 0;
2978:
2979: FOR i IN Get_Tmp_Deliveries
2980: LOOP

Line 2994: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

2990: p_group_by_header => 'N',
2991: p_action_code => l_action_code,
2992: x_return_status => l_return_status );
2993:
2994: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2995: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2996: THEN
2997: --
2998: IF ( l_debug_on ) THEN

Line 2995: WSH_UTIL_CORE.G_RET_STS_WARNING) )

2991: p_action_code => l_action_code,
2992: x_return_status => l_return_status );
2993:
2994: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
2995: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2996: THEN
2997: --
2998: IF ( l_debug_on ) THEN
2999: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Create_Hash');

Line 3029: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3025: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_VENDOR_PARTY_MERGE_PKG.Get_Delivery_Hash()+ Update_Hash_Exp - ' || getTimeStamp );
3026: END IF;
3027: --
3028: WHEN OTHERS THEN
3029: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3030: --
3031: IF ( l_debug_on ) THEN
3032: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_VENDOR_PARTY_MERGE_PKG.Get_Delivery_Hash()+ Others - ' || getTimeStamp );
3033: WSH_DEBUG_SV.logmsg(l_module_name,'Error Mesg : ' || SQLERRM );

Line 3072: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;

3068: p_gross_weight IN g_number_tbl_type,
3069: p_volume IN g_number_tbl_type,
3070: x_return_status OUT NOCOPY VARCHAR2 )
3071: IS
3072: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
3073: l_return_status VARCHAR2(10);
3074:
3075: Weight_Volume_Exp EXCEPTION;
3076: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Adjust_Weight_Volume';

Line 3126: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3122: p_diff_fill_volume => -1 * p_volume(wvCnt),
3123: p_check_for_empty => 'Y',
3124: x_return_status => l_return_status );
3125:
3126: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3127: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3128: THEN
3129: --
3130: IF ( l_debug_on ) THEN

Line 3127: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3123: p_check_for_empty => 'Y',
3124: x_return_status => l_return_status );
3125:
3126: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3127: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3128: THEN
3129: --
3130: IF ( l_debug_on ) THEN
3131: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.DD_WV_Post_Process returned error');

Line 3157: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3153: p_check_for_empty => 'Y',
3154: p_leg_id => p_delivery_leg_id(wvCnt),
3155: x_return_status => l_return_status);
3156:
3157: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3158: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3159: THEN
3160: --
3161: IF ( l_debug_on ) THEN

Line 3158: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3154: p_leg_id => p_delivery_leg_id(wvCnt),
3155: x_return_status => l_return_status);
3156:
3157: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3158: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3159: THEN
3160: --
3161: IF ( l_debug_on ) THEN
3162: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Del_WV_Post_Process returned error');

Line 3279: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3275: p_organization_id => p_organization_id(wvCnt),
3276: x_param_info => l_param_info,
3277: x_return_status => l_return_status);
3278:
3279: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3280: --
3281: IF ( l_debug_on ) THEN
3282: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_SHIPPING_PARAMS_PVT.Get returned error');
3283: END IF;

Line 3309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3305: p_vol_uom_code => p_volume_uom(wvCnt),
3306: p_inv_item_id => p_inventory_item_id(wvCnt),
3307: x_return_status => l_return_status);
3308:
3309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3311: THEN
3312: --
3313: IF ( l_debug_on ) THEN

Line 3310: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3306: p_inv_item_id => p_inventory_item_id(wvCnt),
3307: x_return_status => l_return_status);
3308:
3309: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3310: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3311: THEN
3312: --
3313: IF ( l_debug_on ) THEN
3314: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_WV_UTILS.Adjust_Parent_WV returned error');

Line 3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;

3546: l_gross_weight g_number_tbl_type;
3547: l_volume g_number_tbl_type;
3548: l_weight_uom g_char_tbl_type;
3549: l_volume_uom g_char_tbl_type;
3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;
3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;
3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;
3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;

Line 3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;

3547: l_volume g_number_tbl_type;
3548: l_weight_uom g_char_tbl_type;
3549: l_volume_uom g_char_tbl_type;
3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;
3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;
3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;
3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3555: l_delivery_id g_number_tbl_type;

Line 3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;

3548: l_weight_uom g_char_tbl_type;
3549: l_volume_uom g_char_tbl_type;
3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;
3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;
3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;
3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3555: l_delivery_id g_number_tbl_type;
3556: l_initial_pickup_location_id g_number_tbl_type;

Line 3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;

3549: l_volume_uom g_char_tbl_type;
3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;
3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;
3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;
3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3555: l_delivery_id g_number_tbl_type;
3556: l_initial_pickup_location_id g_number_tbl_type;
3557: l_customer_id g_number_tbl_type;

Line 3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;

3550: l_wdd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3551: l_wda_rowid wsh_util_core.COLUMN_TAB_TYPE;
3552: l_wdl_rowid wsh_util_core.COLUMN_TAB_TYPE;
3553: l_tmp_rowid wsh_util_core.COLUMN_TAB_TYPE;
3554: l_wnd_rowid wsh_util_core.COLUMN_TAB_TYPE;
3555: l_delivery_id g_number_tbl_type;
3556: l_initial_pickup_location_id g_number_tbl_type;
3557: l_customer_id g_number_tbl_type;
3558: l_intmed_ship_to_location_id g_number_tbl_type;

Line 3564: l_initial_pickup_date wsh_util_core.date_tab_type;

3560: l_freight_terms_code g_char_tbl_type;
3561: l_ship_method_code g_char_tbl_type;
3562: l_carrier_id g_number_tbl_type;
3563: l_source_header_id g_number_tbl_type;
3564: l_initial_pickup_date wsh_util_core.date_tab_type;
3565: l_ultimate_dropoff_date wsh_util_core.date_tab_type;
3566: l_ignore_for_planning g_char_tbl_type;
3567: l_shipment_direction g_char_tbl_type;
3568: l_shipping_control g_char_tbl_type;

Line 3565: l_ultimate_dropoff_date wsh_util_core.date_tab_type;

3561: l_ship_method_code g_char_tbl_type;
3562: l_carrier_id g_number_tbl_type;
3563: l_source_header_id g_number_tbl_type;
3564: l_initial_pickup_date wsh_util_core.date_tab_type;
3565: l_ultimate_dropoff_date wsh_util_core.date_tab_type;
3566: l_ignore_for_planning g_char_tbl_type;
3567: l_shipment_direction g_char_tbl_type;
3568: l_shipping_control g_char_tbl_type;
3569: l_party_id g_number_tbl_type;

Line 3608: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3604: WSH_DEBUG_SV.log(l_module_name, 'p_from_site_id', p_from_site_id);
3605: WSH_DEBUG_SV.log(l_module_name, 'p_to_site_id', p_to_site_id);
3606: END IF;
3607: --
3608: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3609: OPEN get_loc_for_site ( p_from_vendor_id , p_from_site_id );
3610: FETCH get_loc_for_site INTO l_from_location_id, l_from_party_site_use_id;
3611: --
3612: IF get_loc_for_site%NOTFOUND THEN

Line 3767: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3763: p_volume =>l_volume,
3764: x_return_status =>l_return_status );
3765:
3766:
3767: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3768: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3769: THEN
3770: --
3771: IF ( l_debug_on ) THEN

Line 3768: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3764: x_return_status =>l_return_status );
3765:
3766:
3767: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3768: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3769: THEN
3770: --
3771: IF ( l_debug_on ) THEN
3772: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Weight_Volume');

Line 3807: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3803: p_weight_uom => l_weight_uom,
3804: p_volume_uom => l_volume_uom,
3805: x_return_status => l_return_status );
3806:
3807: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3808: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3809: THEN
3810: --
3811: IF ( l_debug_on ) THEN

Line 3808: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3804: p_volume_uom => l_volume_uom,
3805: x_return_status => l_return_status );
3806:
3807: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3808: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3809: THEN
3810: --
3811: IF ( l_debug_on ) THEN
3812: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Parent_WV');

Line 3863: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3859: p_delivery_detail_id => l_parent_delivery_detail_id(i),
3860: p_error_message => l_message_text
3861: );
3862:
3863: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3864: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3865: THEN
3866: --
3867: IF ( l_debug_on ) THEN

Line 3864: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3860: p_error_message => l_message_text
3861: );
3862:
3863: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3864: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3865: THEN
3866: --
3867: IF ( l_debug_on ) THEN
3868: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');

Line 3961: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3957: p_gross_weight => l_gross_Weight,
3958: p_volume => l_volume,
3959: x_return_status => l_return_status );
3960:
3961: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3962: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3963: THEN
3964: --
3965: IF ( l_debug_on ) THEN

Line 3962: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3958: p_volume => l_volume,
3959: x_return_status => l_return_status );
3960:
3961: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
3962: WSH_UTIL_CORE.G_RET_STS_WARNING) )
3963: THEN
3964: --
3965: IF ( l_debug_on ) THEN
3966: WSH_DEBUG_SV.logmsg(l_module_name,'Error returned from API Adjust_Weight_Volume');

Line 4002: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

3998: p_weight_uom => l_weight_Uom,
3999: p_volume_uom => l_volume_Uom,
4000: x_return_status => l_return_status );
4001:
4002: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4003: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4004: THEN
4005: --
4006: IF ( l_debug_on ) THEN

Line 4003: WSH_UTIL_CORE.G_RET_STS_WARNING) )

3999: p_volume_uom => l_volume_Uom,
4000: x_return_status => l_return_status );
4001:
4002: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4003: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4004: THEN
4005: --
4006: IF ( l_debug_on ) THEN
4007: WSH_DEBUG_SV.log(l_module_name, 'Error returned from API Adjust_Parent_WV');

Line 4069: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4065: p_delivery_detail_id => l_parent_delivery_detail_id(i),
4066: p_error_message => l_message_text
4067: );
4068:
4069: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4070: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4071: THEN
4072: --
4073: IF ( l_debug_on ) THEN

Line 4070: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4066: p_error_message => l_message_text
4067: );
4068:
4069: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4070: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4071: THEN
4072: --
4073: IF ( l_debug_on ) THEN
4074: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');

Line 4115: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4111: p_delivery_id => l_delivery_id(i),
4112: p_delivery_name => l_delivery_name(i),
4113: p_error_message => l_message_text
4114: );
4115: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4116: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4117: THEN
4118: --
4119: IF ( l_debug_on ) THEN

Line 4116: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4112: p_delivery_name => l_delivery_name(i),
4113: p_error_message => l_message_text
4114: );
4115: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4116: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4117: THEN
4118: --
4119: IF ( l_debug_on ) THEN
4120: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');

Line 4201: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4197: x_hash_string_tab => l_hash_string_tab,
4198: x_hash_value_tab => l_hash_value_tab,
4199: x_delivery_id_tab => l_delivery_id_tab,
4200: x_return_status => l_return_status );
4201: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4202: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4203: THEN
4204: --
4205: IF ( l_debug_on ) THEN

Line 4202: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4198: x_hash_value_tab => l_hash_value_tab,
4199: x_delivery_id_tab => l_delivery_id_tab,
4200: x_return_status => l_return_status );
4201: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4202: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4203: THEN
4204: --
4205: IF ( l_debug_on ) THEN
4206: WSH_DEBUG_SV.log(l_module_name,'Error returned from API Get_Delivery_Hash');

Line 4258: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4254: p_gross_weight => l_gross_weight,
4255: p_volume => l_volume,
4256: x_return_status => l_return_status );
4257:
4258: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4259: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4260: THEN
4261: --
4262: IF ( l_debug_on ) THEN

Line 4259: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4255: p_volume => l_volume,
4256: x_return_status => l_return_status );
4257:
4258: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4259: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4260: THEN
4261: --
4262: IF ( l_debug_on ) THEN
4263: WSH_DEBUG_SV.log(l_module_name,'Error returned from API Adjust_Weight_Volume');

Line 4324: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4320: p_trip_id => l_trip_id(i),
4321: p_trip_stop_id => l_trip_stop_id(i),
4322: p_error_message => l_message_text
4323: );
4324: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4325: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4326: THEN
4327: --
4328: IF ( l_debug_on ) THEN

Line 4325: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4321: p_trip_stop_id => l_trip_stop_id(i),
4322: p_error_message => l_message_text
4323: );
4324: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4325: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4326: THEN
4327: --
4328: IF ( l_debug_on ) THEN
4329: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_XC_UTIL.Log_Exception');

Line 4403: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,

4399: p_grouping_attributes => l_grp_attr_tab,
4400: p_group_by_header => 'N',
4401: p_action_code => NULL,
4402: x_return_status => x_return_status);
4403: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4404: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4405: THEN
4406: --
4407: IF ( l_debug_on ) THEN

Line 4404: WSH_UTIL_CORE.G_RET_STS_WARNING) )

4400: p_group_by_header => 'N',
4401: p_action_code => NULL,
4402: x_return_status => x_return_status);
4403: IF ( l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS,
4404: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4405: THEN
4406: --
4407: IF ( l_debug_on ) THEN
4408: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_DELIVERY_AUTOCREATE.Create_Hash');

Line 4495: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4491: CLOSE get_empty_deliveries;
4492: END IF;
4493:
4494: --
4495: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4496: --
4497: IF l_debug_on THEN
4498: --
4499: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4529: IF get_empty_deliveries%ISOPEN THEN
4530: CLOSE get_empty_deliveries;
4531: END IF;
4532: --
4533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4534: --
4535: IF l_debug_on THEN
4536: --
4537: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4539: --
4540: END IF;
4541: --
4542: WHEN OTHERS THEN
4543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4544: IF get_loc_for_site%ISOPEN THEN
4545: CLOSE get_loc_for_site;
4546: END IF;
4547: IF c_check_vendor_wdd%ISOPEN THEN

Line 4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4568: IF get_empty_deliveries%ISOPEN THEN
4569: CLOSE get_empty_deliveries;
4570: END IF;
4571: --
4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4573: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Merge_RTV_Transactions');
4574: --
4575: IF l_debug_on THEN
4576: --

Line 4573: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Merge_RTV_Transactions');

4569: CLOSE get_empty_deliveries;
4570: END IF;
4571: --
4572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4573: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Merge_RTV_Transactions');
4574: --
4575: IF l_debug_on THEN
4576: --
4577: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM, 1, 200));