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 80: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

76: l_sql_err VARCHAR2(32767);
77: --
78: BEGIN
79: --{
80: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
81: --
82: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
83: IF l_debug_on IS NULL THEN
84: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 161: wsh_util_core.api_post_call

157: IF l_debug_on THEN
158: 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);
159: END IF;
160: --
161: wsh_util_core.api_post_call
162: (
163: p_return_status => l_return_status,
164: x_num_warnings => l_num_warnings,
165: x_num_errors => l_num_errors,

Line 195: WSH_UTIL_CORE.api_post_call

191: WSH_DEBUG_SV.log(l_module_name, 'l_sql_err', l_sql_err);
192: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
193: END IF;
194: --
195: WSH_UTIL_CORE.api_post_call
196: (
197: p_return_status => l_return_status,
198: x_num_warnings => l_num_warnings,
199: x_num_errors => l_num_errors

Line 226: WSH_UTIL_CORE.api_post_call

222: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling create_Site', WSH_DEBUG_SV.C_PROC_LEVEL);
223: WSH_DEBUG_SV.log(l_module_name, 'Return Status', l_return_status);
224: END IF;
225: --
226: WSH_UTIL_CORE.api_post_call
227: (
228: p_return_status => l_return_status,
229: x_num_warnings => l_num_warnings,
230: x_num_errors => l_num_errors

Line 239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

235: END LOOP;
236: --
237: IF l_num_errors > 0
238: THEN
239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
240: ELSIF l_num_warnings > 0
241: THEN
242: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
243: ELSE

Line 242: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

238: THEN
239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
240: ELSIF l_num_warnings > 0
241: THEN
242: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
243: ELSE
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
245: END IF;
246: --

Line 244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

240: ELSIF l_num_warnings > 0
241: THEN
242: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
243: ELSE
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
245: END IF;
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

252: EXCEPTION
253: --
254: WHEN FND_API.G_EXC_ERROR THEN
255: --
256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
257: --
258: IF l_debug_on THEN
259: --
260: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

263: END IF;
264: --
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: --
267: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
268: --
269: IF l_debug_on THEN
270: --
271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

274: END IF;
275: --
276: WHEN OTHERS THEN
277: --
278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
279: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.InactivatePartySites');
280: --
281: IF l_debug_on THEN
282: --

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

275: --
276: WHEN OTHERS THEN
277: --
278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
279: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.InactivatePartySites');
280: --
281: IF l_debug_on THEN
282: --
283: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));

Line 417: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

413: l_count NUMBER;
414: --
415: BEGIN
416: --{
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
418: --
419: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
420: IF l_debug_on IS NULL THEN
421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 467: WSH_UTIL_CORE.api_post_call

463: IF l_debug_on THEN
464: wsh_debug_sv.log(l_module_name, 'Return Status from inactivatePartySites', l_return_status);
465: END IF;
466: --
467: WSH_UTIL_CORE.api_post_call
468: (
469: p_return_status => l_return_status,
470: x_num_warnings => l_num_warnings,
471: x_num_errors => l_num_errors

Line 491: WSH_UTIL_CORE.printMsg(l_msg);

487: fnd_message.set_token( 'L_LOCATION_CODE' , g_LocChangeTab(i).old_loc_code);
488: fnd_message.set_token( 'L_NEW_LOCATION_CODE', g_LocChangeTab(i).new_loc_code);
489: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
490: l_msg := FND_MESSAGE.GET;
491: WSH_UTIL_CORE.printMsg(l_msg);
492: --
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
495: END IF;

Line 516: wsh_util_core.api_post_call(

512: IF l_debug_on THEN
513: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_XC_UTIL.LOG_EXCEPTION is ', l_return_status);
514: END IF;
515: --
516: wsh_util_core.api_post_call(
517: p_return_status => l_return_status,
518: x_num_warnings => l_num_warnings,
519: x_num_errors => l_num_errors,
520: p_msg_data => l_xc_msg_data

Line 618: wsh_util_core.printMsg( l_msg );

614: fnd_message.set_name ( 'WSH', 'WSH_IB_SF_LOCN_CODE_CONFLICT' );
615: fnd_message.set_token( 'LOC_CODE', l_location_code );
616: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
617: l_msg := FND_MESSAGE.GET;
618: wsh_util_core.printMsg( l_msg );
619: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
620: --
621: IF l_debug_on THEN
622: WSH_DEBUG_SV.pop(l_module_name);

Line 619: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

615: fnd_message.set_token( 'LOC_CODE', l_location_code );
616: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name );
617: l_msg := FND_MESSAGE.GET;
618: wsh_util_core.printMsg( l_msg );
619: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
620: --
621: IF l_debug_on THEN
622: WSH_DEBUG_SV.pop(l_module_name);
623: END IF;

Line 657: wsh_util_core.api_post_call(

653: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_SUPPLIER_PARTY.CREATE_HZ_PARTY_SITE is', l_return_status);
654: --
655: END IF;
656: --
657: wsh_util_core.api_post_call(
658: p_return_status => l_return_status,
659: x_num_warnings => l_num_warnings,
660: x_num_errors => l_num_errors
661: );

Line 681: wsh_util_core.api_post_call(

677: wsh_debug_sv.log(l_module_name, 'l_return_status', l_return_status);
678: wsh_debug_sv.log(l_module_name, 'l_party_site_use_id', l_party_site_use_id);
679: END IF;
680: --
681: wsh_util_core.api_post_call(
682: p_return_status => l_return_status,
683: x_num_warnings => l_num_warnings,
684: x_num_errors => l_num_errors
685: );

Line 697: wsh_util_core.api_post_call(

693: p_location_source_code => 'HZ',
694: x_return_status => l_return_status
695: );
696: --
697: wsh_util_core.api_post_call(
698: p_return_status => l_return_status,
699: x_num_warnings => l_num_warnings,
700: x_num_errors => l_num_errors
701: );

Line 723: wsh_util_core.api_post_call(

719: IF l_debug_on THEN
720: wsh_debug_sv.log(l_module_name, 'Return status from InactivatePartySite', l_return_status);
721: END IF;
722: --
723: wsh_util_core.api_post_call(
724: p_return_status => l_return_status,
725: x_num_warnings => l_num_warnings,
726: x_num_errors => l_num_errors
727: );

Line 750: WSH_UTIL_CORE.printMsg(l_msg);

746: fnd_message.set_token( 'L_LOCATION_CODE' , l_location_code );
747: fnd_message.set_token( 'L_NEW_LOCATION_CODE', l_new_location_code );
748: fnd_message.set_token( 'DELIVERY_NAME' , p_delivery_name );
749: l_msg := FND_MESSAGE.GET;
750: WSH_UTIL_CORE.printMsg(l_msg);
751: --
752: IF l_debug_on THEN
753: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
754: END IF;

Line 775: wsh_util_core.api_post_call(

771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_XC_UTIL.LOG_EXCEPTION is ', l_return_status);
773: END IF;
774: --
775: wsh_util_core.api_post_call(
776: p_return_status => l_return_status,
777: x_num_warnings => l_num_warnings,
778: x_num_errors => l_num_errors,
779: p_msg_data => l_xc_msg_data

Line 802: wsh_util_core.api_post_call(

798: IF l_debug_on THEN
799: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_SUPPLIER_PARTY.PROCESS_HZ_CONTACT', l_return_status);
800: END IF;
801: --
802: wsh_util_core.api_post_call(
803: p_return_status => l_return_status,
804: x_num_warnings => l_num_warnings,
805: x_num_errors => l_num_errors
806: );

Line 809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

805: x_num_errors => l_num_errors
806: );
807: --
808: IF l_num_errors > 0 THEN
809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
810: ELSIF l_num_warnings > 0 THEN
811: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
812: END IF;
813: --

Line 811: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

807: --
808: IF l_num_errors > 0 THEN
809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
810: ELSIF l_num_warnings > 0 THEN
811: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
812: END IF;
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.pop(l_module_name);

Line 822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

818: EXCEPTION
819: --
820: WHEN FND_API.G_EXC_ERROR THEN
821: --
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
823: --
824: IF l_debug_on THEN
825: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

827: END IF;
828: --
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: --
831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
832: --
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 840: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

836: END IF;
837: --
838: WHEN OTHERS THEN
839: --
840: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
841: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Create_Site');
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));

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

837: --
838: WHEN OTHERS THEN
839: --
840: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
841: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Create_Site');
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.log(l_module_name,'Unexpected error has occured. Oracle error message is ', SUBSTRB(SQLERRM,1,200));
845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 896: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

892:
893: --
894: BEGIN
895: --{
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
897: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
898: IF l_debug_on IS NULL THEN
899: --{
900: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1015: wsh_util_core.api_post_call(

1011: P_delivery_name =>l_dlvy_name,
1012: P_location_id =>l_location_id,
1013: x_return_status =>l_return_status
1014: );
1015: wsh_util_core.api_post_call(
1016: p_return_status => l_return_status,
1017: x_num_warnings => l_num_warnings,
1018: x_num_errors => l_num_errors
1019: );

Line 1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1026: END IF;
1027:
1028: IF l_num_errors > 0 THEN
1029: --{
1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1031: ELSIF l_num_warnings > 0 THEN
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1033: --}
1034: END IF;

Line 1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1028: IF l_num_errors > 0 THEN
1029: --{
1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1031: ELSIF l_num_warnings > 0 THEN
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1033: --}
1034: END IF;
1035: --
1036: IF l_debug_on THEN

Line 1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1040: EXCEPTION
1041: --
1042: WHEN FND_API.G_EXC_ERROR THEN
1043: --
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1045: --
1046: IF l_debug_on THEN
1047: --
1048: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1051: END IF;
1052: --
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: --
1055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1056: --
1057: IF l_debug_on THEN
1058: --
1059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1062: END IF;
1063: --
1064: WHEN OTHERS THEN
1065: --
1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1067: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_New_Delivery');
1068: --
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1063: --
1064: WHEN OTHERS THEN
1065: --
1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1067: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_New_Delivery');
1068: --
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1071: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1190: BEGIN
1191:
1192:
1193: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1195:
1196: IF l_debug_on IS NULL THEN
1197: --{
1198: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1261: wsh_util_core.api_post_call

1257: p_from_supplier_name => p_from_supplier_name,
1258: x_return_status => l_return_status
1259: );
1260: --
1261: wsh_util_core.api_post_call
1262: (
1263: p_return_status => l_return_status,
1264: x_num_warnings => l_num_warnings,
1265: x_num_errors => l_num_errors

Line 1352: wsh_util_core.api_post_call

1348: WSH_DEBUG_SV.log(l_module_name, 'Return status from CAL. API', l_return_status);
1349: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID', l_CalAsgId);
1350: END IF;
1351: --
1352: wsh_util_core.api_post_call
1353: (
1354: p_return_status => l_return_status,
1355: x_num_warnings => l_num_warnings,
1356: x_num_errors => l_num_errors,

Line 1388: wsh_util_core.printMsg( l_msg );

1384: fnd_message.set_token( 'SUPPLIER_NAME' , p_from_supplier_name );
1385: fnd_message.set_token( 'CAL_TYPE' , check_site_calendar_rec.calendar_type );
1386: fnd_message.set_token( 'SITE_CODE' , check_site_calendar_rec.vendor_site_code );
1387: l_msg := FND_MESSAGE.GET;
1388: wsh_util_core.printMsg( l_msg );
1389: --}
1390: END IF;--IF (check_dup_assignment%NOTFOUND)
1391:
1392: CLOSE check_dup_assignment;

Line 1416: wsh_util_core.api_post_call

1412: IF l_debug_on THEN
1413: wsh_debug_sv.log(l_module_name, 'Return Status from InactivatePartySites', l_return_status);
1414: END IF;
1415: --
1416: wsh_util_core.api_post_call
1417: (
1418: p_return_status => l_return_status,
1419: x_num_warnings => l_num_warnings,
1420: x_num_errors => l_num_errors,

Line 1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1424: END IF;
1425: --
1426: IF l_num_errors > 0 THEN
1427: --{
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1429: ELSIF l_num_warnings > 0 THEN
1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1431: --}
1432: END IF;

Line 1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1426: IF l_num_errors > 0 THEN
1427: --{
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1429: ELSIF l_num_warnings > 0 THEN
1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1431: --}
1432: END IF;
1433: --
1434: IF l_debug_on THEN

Line 1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1438: EXCEPTION
1439: --
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: --
1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1443: --
1444: IF l_debug_on THEN
1445: --
1446: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1449: END IF;
1450: --
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1452: --
1453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1454: --
1455: IF l_debug_on THEN
1456: --
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1460: END IF;
1461: --
1462: WHEN OTHERS THEN
1463: --
1464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1465: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_Non_PO_Entities');
1466: --
1467: IF l_debug_on THEN
1468: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1461: --
1462: WHEN OTHERS THEN
1463: --
1464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1465: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Update_Non_PO_Entities');
1466: --
1467: IF l_debug_on THEN
1468: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1469: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1552: l_delivery_list wsh_util_core.id_tab_type;

1548: AND d.delivery_detail_id = w.delivery_detail_id
1549: AND w.delivery_id = wnd.delivery_id(+)
1550: AND nvl(w.type, 'S') IN ('S' ,'O');
1551: --
1552: l_delivery_list wsh_util_core.id_tab_type;
1553: l_dd_list wsh_util_core.id_tab_type;
1554: --
1555:
1556: CURSOR find_delivery IS

Line 1553: l_dd_list wsh_util_core.id_tab_type;

1549: AND w.delivery_id = wnd.delivery_id(+)
1550: AND nvl(w.type, 'S') IN ('S' ,'O');
1551: --
1552: l_delivery_list wsh_util_core.id_tab_type;
1553: l_dd_list wsh_util_core.id_tab_type;
1554: --
1555:
1556: CURSOR find_delivery IS
1557: SELECT distinct delivery_id

Line 1624: l_delivery_detail_tbl wsh_util_core.id_tab_type;

1620: WHERE delivery_id = p_delivery_id
1621: AND operation_type = 'VENDOR_MRG'
1622: AND temp_col IS NULL;
1623: --
1624: l_delivery_detail_tbl wsh_util_core.id_tab_type;
1625: --
1626: CURSOR dlvy_rr_csr(p_delivery_id NUMBER) IS
1627: SELECT wdd.delivery_detail_id,
1628: wdd.routing_req_id,

Line 1681: l_delivery_cache_tbl wsh_util_core.id_tab_type;

1677: l1_revision_number NUMBER;
1678: l1_parent_shipment_header_id NUMBER;
1679: --
1680:
1681: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1682: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1683: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1684: l_dlvy_tbl wsh_util_core.id_tab_type;
1685: l_chk_delivery_id NUMBER :=0;

Line 1682: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;

1678: l1_parent_shipment_header_id NUMBER;
1679: --
1680:
1681: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1682: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1683: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1684: l_dlvy_tbl wsh_util_core.id_tab_type;
1685: l_chk_delivery_id NUMBER :=0;
1686: l_prev_new_rr_id NUMBER :=0;

Line 1684: l_dlvy_tbl wsh_util_core.id_tab_type;

1680:
1681: l_delivery_cache_tbl wsh_util_core.id_tab_type;
1682: l_dlvy_rr_cache_tbl wsh_util_core.id_tab_type;
1683: l_dlvy_rr_tbl wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
1684: l_dlvy_tbl wsh_util_core.id_tab_type;
1685: l_chk_delivery_id NUMBER :=0;
1686: l_prev_new_rr_id NUMBER :=0;
1687: l_site_merge BOOLEAN;
1688: l_new_delivery_id NUMBER;

Line 1714: wsh_util_core.g_call_fte_load_tender_api := FALSE;

1710: --
1711: SAVEPOINT WSH_Vendor_Merge;
1712: --
1713: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1714: wsh_util_core.g_call_fte_load_tender_api := FALSE;
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1716:
1717: IF l_debug_on IS NULL THEN
1718: --{

Line 1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1711: SAVEPOINT WSH_Vendor_Merge;
1712: --
1713: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1714: wsh_util_core.g_call_fte_load_tender_api := FALSE;
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1716:
1717: IF l_debug_on IS NULL THEN
1718: --{
1719: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 1737: wsh_util_core.enable_concurrent_log_print ;

1733: WSH_DEBUG_SV.log(l_module_name,'P_CALLING_MODE', p_calling_mode);
1734: --}
1735: END IF;
1736:
1737: wsh_util_core.enable_concurrent_log_print ;
1738:
1739: -- find out if it is a vendor merge OR vendor site merge
1740: OPEN check_vendor_active(p_vendor_id => p_from_id);
1741: FETCH check_vendor_active INTO l_end_date_active, l_supplier_name;

Line 1754: wsh_util_core.printMsg( l_msg );

1750: END IF;
1751: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1752: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1753: l_msg := FND_MESSAGE.GET;
1754: wsh_util_core.printMsg( l_msg );
1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1756: --
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.pop(l_module_name);

Line 1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1751: fnd_message.set_name ( 'WSH', 'WSH_IB_VENDOR_NOT_EXISTS' );
1752: fnd_message.set_token( 'VENDOR_ID' , to_char(p_from_id) );
1753: l_msg := FND_MESSAGE.GET;
1754: wsh_util_core.printMsg( l_msg );
1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1756: --
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.pop(l_module_name);
1759: END IF;

Line 1803: wsh_util_core.api_post_call(

1799: p_from_supplier_name => l_supplier_name,
1800: X_return_status => l_return_status
1801: );
1802: --
1803: wsh_util_core.api_post_call(
1804: p_return_status => l_return_status,
1805: x_num_warnings => l_num_warnings,
1806: x_num_errors => l_num_errors
1807: );

Line 1880: wsh_util_core.printMsg( l_msg );

1876: fnd_message.set_name ( 'WSH', 'WSH_IB_DLY_DET_UPDT_MISMATCH' );
1877: fnd_message.set_token( 'NUM_DETAILS_AFFECTED' , to_char(l_dd_list.count) );
1878: fnd_message.set_token( 'NUM_DETAILS_UPDATED' , to_char(SQL%ROWCOUNT) );
1879: l_msg := FND_MESSAGE.GET;
1880: wsh_util_core.printMsg( l_msg );
1881: --}
1882: END IF;
1883: IF l_debug_on THEN
1884: --{

Line 1989: wsh_util_core.api_post_call(

1985: WSH_DEBUG_SV.log(l_module_name, 'New Delivery ID', l_new_delivery_id);
1986: --}
1987: END IF;
1988:
1989: wsh_util_core.api_post_call(
1990: p_return_status => l_return_status,
1991: x_num_warnings => l_num_warnings,
1992: x_num_errors => l_num_errors
1993: );

Line 2022: wsh_util_core.api_post_call(

2018: 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);
2019: --}
2020: END IF;
2021:
2022: wsh_util_core.api_post_call(
2023: p_return_status => l_return_status,
2024: x_num_warnings => l_num_warnings,
2025: x_num_errors => l_num_errors
2026: );

Line 2062: wsh_util_core.api_post_call(

2058: 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);
2059: --}
2060: END IF;
2061:
2062: wsh_util_core.api_post_call(
2063: p_return_status => l_return_status,
2064: x_num_warnings => l_num_warnings,
2065: x_num_errors => l_num_errors
2066: );

Line 2117: wsh_util_core.api_post_call(

2113: 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);
2114: --}
2115: END IF;
2116:
2117: wsh_util_core.api_post_call(
2118: p_return_status => l_return_status,
2119: x_num_warnings => l_num_warnings,
2120: x_num_errors => l_num_errors
2121: );

Line 2260: wsh_util_core.printMsg( l_msg );

2256: --
2257: fnd_message.set_name ( 'WSH', 'WSH_IB_RR_NUMBER_CONFLICT' );
2258: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2259: l_msg := FND_MESSAGE.GET;
2260: wsh_util_core.printMsg( l_msg );
2261:
2262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2263: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2264: --{

Line 2262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2258: fnd_message.set_token( 'SUPPLIER_NAME', l_supplier_name);
2259: l_msg := FND_MESSAGE.GET;
2260: wsh_util_core.printMsg( l_msg );
2261:
2262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2263: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2264: --{
2265: wsh_util_core.Reset_stops_for_load_tender(
2266: p_reset_flags=>true,

Line 2263: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2259: l_msg := FND_MESSAGE.GET;
2260: wsh_util_core.printMsg( l_msg );
2261:
2262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2263: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2264: --{
2265: wsh_util_core.Reset_stops_for_load_tender(
2266: p_reset_flags=>true,
2267: x_return_status=>l_return_status

Line 2265: wsh_util_core.Reset_stops_for_load_tender(

2261:
2262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2263: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2264: --{
2265: wsh_util_core.Reset_stops_for_load_tender(
2266: p_reset_flags=>true,
2267: x_return_status=>l_return_status
2268: );
2269: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 2269: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2265: wsh_util_core.Reset_stops_for_load_tender(
2266: p_reset_flags=>true,
2267: x_return_status=>l_return_status
2268: );
2269: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2270: --{
2271: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2272: --}
2273: END IF;

Line 2271: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2267: x_return_status=>l_return_status
2268: );
2269: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2270: --{
2271: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2272: --}
2273: END IF;
2274: --}
2275: END IF;

Line 2311: wsh_util_core.api_post_call(

2307: --{
2308: 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);
2309: --}
2310: END IF;
2311: wsh_util_core.api_post_call(
2312: p_return_status => l_return_status,
2313: x_num_warnings => l_num_warnings,
2314: x_num_errors => l_num_errors
2315: );

Line 2338: wsh_util_core.api_post_call(

2334: WSH_DEBUG_SV.log(l_module_name, 'New Txn ID', l_new_rr_id);
2335:
2336: --
2337: END IF;
2338: wsh_util_core.api_post_call(
2339: p_return_status => l_return_status,
2340: x_num_warnings => l_num_warnings,
2341: x_num_errors => l_num_errors
2342: );

Line 2358: WSH_UTIL_CORE.printMsg(l_msg);

2354: fnd_message.set_token( 'NEW_RR_NUMBER', to_char( l_new_rr_number ) );
2355: fnd_message.set_token( 'DELIVERY_NAME', l_dlvy_rr_rec.name );
2356: l_msg := FND_MESSAGE.GET;
2357: --
2358: WSH_UTIL_CORE.printMsg(l_msg);
2359: --
2360: l_exception_id := NULL;
2361: --
2362: wsh_xc_util.log_exception (

Line 2383: wsh_util_core.api_post_call(

2379: 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);
2380: --
2381: END IF;
2382: --
2383: wsh_util_core.api_post_call(
2384: p_return_status => l_return_status,
2385: x_num_warnings => l_num_warnings,
2386: x_num_errors => l_num_errors,
2387: p_msg_data => l_xc_msg_data

Line 2502: wsh_util_core.api_post_call(

2498: 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);
2499: --}
2500: END IF;
2501:
2502: wsh_util_core.api_post_call(
2503: p_return_status => l_return_status,
2504: x_num_warnings => l_num_warnings,
2505: x_num_errors => l_num_errors,
2506: p_msg_data => l_msg

Line 2549: wsh_util_core.api_post_call(

2545: 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);
2546: --}
2547: END IF;
2548:
2549: wsh_util_core.api_post_call(
2550: p_return_status => l_return_status,
2551: x_num_warnings => l_num_warnings,
2552: x_num_errors => l_num_errors
2553: );

Line 2588: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2584: --}
2585: -- END IF; --IF (l_option= 'B' OR l_option = 'P')
2586:
2587: --
2588: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2589: --{
2590: wsh_util_core.Process_stops_for_load_tender(
2591: p_reset_flags=>true,
2592: x_return_status=>l_return_status);

Line 2590: wsh_util_core.Process_stops_for_load_tender(

2586:
2587: --
2588: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2589: --{
2590: wsh_util_core.Process_stops_for_load_tender(
2591: p_reset_flags=>true,
2592: x_return_status=>l_return_status);
2593: wsh_util_core.api_post_call(
2594: p_return_status => l_return_status,

Line 2593: wsh_util_core.api_post_call(

2589: --{
2590: wsh_util_core.Process_stops_for_load_tender(
2591: p_reset_flags=>true,
2592: x_return_status=>l_return_status);
2593: wsh_util_core.api_post_call(
2594: p_return_status => l_return_status,
2595: x_num_warnings => l_num_warnings,
2596: x_num_errors => l_num_errors
2597: );

Line 2606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2602: --
2603: IF l_num_errors > 0 THEN
2604: --{
2605: ROLLBACK TO WSH_Vendor_Merge;
2606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2607: ELSIF l_num_warnings > 0 THEN
2608: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2609: --}
2610: END IF;

Line 2608: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2604: --{
2605: ROLLBACK TO WSH_Vendor_Merge;
2606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2607: ELSIF l_num_warnings > 0 THEN
2608: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2609: --}
2610: END IF;
2611: --
2612: IF l_debug_on THEN

Line 2621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2617: EXCEPTION
2618: --
2619: WHEN FND_API.G_EXC_ERROR THEN
2620: --
2621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2622: ROLLBACK TO WSH_Vendor_Merge;
2623: --
2624: IF l_debug_on THEN
2625: --

Line 2631: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2628: --
2629: END IF;
2630: --
2631: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2632: --
2633: wsh_util_core.Reset_stops_for_load_tender(
2634: p_reset_flags=>true,
2635: x_return_status=>l_return_status);

Line 2633: wsh_util_core.Reset_stops_for_load_tender(

2629: END IF;
2630: --
2631: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2632: --
2633: wsh_util_core.Reset_stops_for_load_tender(
2634: p_reset_flags=>true,
2635: x_return_status=>l_return_status);
2636: --
2637: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 2637: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2633: wsh_util_core.Reset_stops_for_load_tender(
2634: p_reset_flags=>true,
2635: x_return_status=>l_return_status);
2636: --
2637: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2639: END IF;
2640: --
2641: END IF;

Line 2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2634: p_reset_flags=>true,
2635: x_return_status=>l_return_status);
2636: --
2637: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2639: END IF;
2640: --
2641: END IF;
2642: --

Line 2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2641: END IF;
2642: --
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: --
2645: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_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_UNEXPECTED_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: END IF;

Line 2665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2661: END IF;
2662: --
2663: WHEN OTHERS THEN
2664: --
2665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2666: ROLLBACK TO WSH_Vendor_Merge;
2667: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Merge');
2668: --
2669: IF l_debug_on THEN

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

2663: WHEN OTHERS THEN
2664: --
2665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2666: ROLLBACK TO WSH_Vendor_Merge;
2667: wsh_util_core.default_handler('WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Merge');
2668: --
2669: IF l_debug_on THEN
2670: --
2671: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2676: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN

2672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2673: --
2674: END IF;
2675: --
2676: IF NOT(wsh_util_core.g_call_fte_load_tender_api) THEN
2677: --
2678: wsh_util_core.Reset_stops_for_load_tender(
2679: p_reset_flags=>true,
2680: x_return_status=>l_return_status);

Line 2678: wsh_util_core.Reset_stops_for_load_tender(

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

Line 2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2743: WHERE vendor_id = p_vendorId;
2744: --
2745: BEGIN
2746: --{
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2748: --
2749: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2750: IF l_debug_on IS NULL THEN
2751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 2824: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2820: END IF;
2821: --
2822: -- For AP, we interpret 'W' as 'S' status.
2823: --
2824: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2826: ELSE
2827: x_return_status := l_return_status;
2828: END IF;

Line 2825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2821: --
2822: -- For AP, we interpret 'W' as 'S' status.
2823: --
2824: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2826: ELSE
2827: x_return_status := l_return_status;
2828: END IF;
2829: --

Line 2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2842: EXCEPTION
2843: --
2844: WHEN FND_API.G_EXC_ERROR THEN
2845: --
2846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2847: --
2848: IF l_debug_on THEN
2849: WSH_DEBUG_SV.logmsg(l_module_name,'Error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_EXCEP_LEVEL);
2850: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2851: END IF;
2852: --
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: --
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2856: --
2857: IF l_debug_on THEN
2858: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2864: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2860: END IF;
2861: --
2862: WHEN OTHERS THEN
2863: --
2864: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2865: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2866: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2867: --
2868: IF l_debug_on THEN

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

2861: --
2862: WHEN OTHERS THEN
2863: --
2864: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2865: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2866: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2867: --
2868: IF l_debug_on THEN
2869: WSH_DEBUG_SV.log(l_module_name, 'Unexpected error', substrb(sqlerrm, 1, 200));

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

2862: WHEN OTHERS THEN
2863: --
2864: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2865: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status, l_module_name);
2866: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_VENDOR_PARTY_MERGE_PKG.VENDOR_PARTY_MERGE',l_module_name);
2867: --
2868: IF l_debug_on THEN
2869: WSH_DEBUG_SV.log(l_module_name, 'Unexpected error', substrb(sqlerrm, 1, 200));
2870: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);