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

Line 178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

174:
175: -- Initialize the Procedure Specific Variables
176: l_header_index := 0;
177:
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179:
180: IF (x_source_header_tab.COUNT > 0 AND x_source_line_tab.COUNT > 0) THEN--{
181: l_header_index := x_source_header_tab.FIRST;
182: LOOP--{

Line 330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

326: IF c_get_line_dates_csr%ISOPEN THEN
327: CLOSE c_get_line_dates_csr;
328: END IF;
329:
330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
331: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_OTM_RIQ_XML.DERIVE_RIQ_DATES',l_module_name);
332:
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 331: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_OTM_RIQ_XML.DERIVE_RIQ_DATES',l_module_name);

327: CLOSE c_get_line_dates_csr;
328: END IF;
329:
330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
331: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_OTM_RIQ_XML.DERIVE_RIQ_DATES',l_module_name);
332:
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
335: WSH_DEBUG_SV.logmsg(l_module_name,

Line 422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
419: END IF;
420:
421: WHEN others THEN
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
423: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_CLOB',l_module_name);
424:
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 423: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_CLOB',l_module_name);

419: END IF;
420:
421: WHEN others THEN
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
423: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_CLOB',l_module_name);
424:
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
427: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
547: END IF;
548:
549: WHEN others THEN
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
551: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_line_tab',l_module_name);
552:
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 551: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_line_tab',l_module_name);

547: END IF;
548:
549: WHEN others THEN
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
551: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_line_tab',l_module_name);
552:
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
657: END IF;
658:
659: WHEN others THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_header_tab',l_module_name);
662:
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 661: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_header_tab',l_module_name);

657: END IF;
658:
659: WHEN others THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_header_tab',l_module_name);
662:
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
770: END IF;
771:
772: WHEN others THEN
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
774: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
775:
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 774: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);

770: END IF;
771:
772: WHEN others THEN
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
774: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
775:
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
882: END IF;
883:
884: WHEN others THEN
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
887:
888: IF l_debug_on THEN
889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 886: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);

882: END IF;
883:
884: WHEN others THEN
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
887:
888: IF l_debug_on THEN
889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1059: END IF;
1060:
1061: WHEN others THEN
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1063: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Carrier',l_module_name);
1064:
1065: IF l_debug_on THEN
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 1063: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Carrier',l_module_name);

1059: END IF;
1060:
1061: WHEN others THEN
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1063: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Carrier',l_module_name);
1064:
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1146: END IF;
1147:
1148: WHEN others THEN
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1150: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Look_Up_NoCase',l_module_name);
1151:
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1150: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Look_Up_NoCase',l_module_name);

1146: END IF;
1147:
1148: WHEN others THEN
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1150: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Look_Up_NoCase',l_module_name);
1151:
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253:
1254: WHEN others THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1256: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_OTM_To_EBS_UOM',l_module_name);
1257:
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1256: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_OTM_To_EBS_UOM',l_module_name);

1252: END IF;
1253:
1254: WHEN others THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1256: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_OTM_To_EBS_UOM',l_module_name);
1257:
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1342: END IF;
1343:
1344: WHEN others THEN
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1346: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM',l_module_name);
1347:
1348: IF l_debug_on THEN
1349: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1346: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM',l_module_name);

1342: END IF;
1343:
1344: WHEN others THEN
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1346: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM',l_module_name);
1347:
1348: IF l_debug_on THEN
1349: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1350: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1424: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1425: END IF;
1426:
1427: WHEN others THEN
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1429: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Carrier_Info',l_module_name);
1430:
1431: IF l_debug_on THEN
1432: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1429: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Carrier_Info',l_module_name);

1425: END IF;
1426:
1427: WHEN others THEN
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1429: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Carrier_Info',l_module_name);
1430:
1431: IF l_debug_on THEN
1432: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1433: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1537: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1538: END IF;
1539:
1540: WHEN others THEN
1541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1542: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Sort',l_module_name);
1543: --
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1542: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Sort',l_module_name);

1538: END IF;
1539:
1540: WHEN others THEN
1541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1542: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Sort',l_module_name);
1543: --
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1592: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1588: p_uom=>x_transit_time_uom,
1589: p_uom_class=>g_global_time_class,
1590: x_uom=>l_transit_time_uom,
1591: x_return_status=>l_return_status);
1592: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1593: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1594: IF l_debug_on
1595: THEN
1596:

Line 1593: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1589: p_uom_class=>g_global_time_class,
1590: x_uom=>l_transit_time_uom,
1591: x_return_status=>l_return_status);
1592: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1593: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1594: IF l_debug_on
1595: THEN
1596:
1597: WSH_DEBUG_SV.log(l_module_name,'Get_OTM_To_EBS_UOM Failed');

Line 1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1639: END IF;
1640:
1641: WHEN others THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1643: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Transit_Time',l_module_name);
1644:
1645: IF l_debug_on THEN
1646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1643: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Transit_Time',l_module_name);

1639: END IF;
1640:
1641: WHEN others THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1643: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Transit_Time',l_module_name);
1644:
1645: IF l_debug_on THEN
1646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727: WHEN others THEN
1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1729: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Ship_Method_Code',l_module_name);
1730:
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1729: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Ship_Method_Code',l_module_name);

1725: END IF;
1726:
1727: WHEN others THEN
1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1729: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Ship_Method_Code',l_module_name);
1730:
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1906: END IF;
1907: --
1908: EXCEPTION
1909: WHEN others THEN
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1911: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Location_Info',l_module_name);
1912: --
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1911: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Location_Info',l_module_name);

1907: --
1908: EXCEPTION
1909: WHEN others THEN
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1911: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Location_Info',l_module_name);
1912: --
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1946: l_line_tab WSH_UTIL_CORE.Id_Tab_Type;

1942: l_height NUMBER;
1943: l_dim_uom VARCHAR2(30);
1944: l_otm_dim_uom VARCHAR2(30);
1945:
1946: l_line_tab WSH_UTIL_CORE.Id_Tab_Type;
1947: l_all_lines_tab WSH_UTIL_CORE.Id_Tab_Type;
1948: l_dummy NUMBER;
1949:
1950: l_debug_on BOOLEAN;

Line 1947: l_all_lines_tab WSH_UTIL_CORE.Id_Tab_Type;

1943: l_dim_uom VARCHAR2(30);
1944: l_otm_dim_uom VARCHAR2(30);
1945:
1946: l_line_tab WSH_UTIL_CORE.Id_Tab_Type;
1947: l_all_lines_tab WSH_UTIL_CORE.Id_Tab_Type;
1948: l_dummy NUMBER;
1949:
1950: l_debug_on BOOLEAN;
1951: l_return_status VARCHAR2(1);

Line 1998: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1994: Get_EBS_To_OTM_UOM(
1995: p_uom=>p_source_line_tab(i).weight_uom_code,
1996: x_uom=>x_source_line_tab(j).WeightUOM,
1997: x_return_status=>l_return_status);
1998: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1999: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2000: IF l_debug_on
2001: THEN
2002: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1999: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1995: p_uom=>p_source_line_tab(i).weight_uom_code,
1996: x_uom=>x_source_line_tab(j).WeightUOM,
1997: x_return_status=>l_return_status);
1998: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1999: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2000: IF l_debug_on
2001: THEN
2002: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
2003: END IF;

Line 2023: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2019: Get_EBS_To_OTM_UOM(
2020: p_uom=>p_source_line_tab(i).volume_uom_code,
2021: x_uom=>x_source_line_tab(j).VolumeUOM,
2022: x_return_status=>l_return_status);
2023: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2024: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2025: IF l_debug_on
2026: THEN
2027: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');

Line 2024: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2020: p_uom=>p_source_line_tab(i).volume_uom_code,
2021: x_uom=>x_source_line_tab(j).VolumeUOM,
2022: x_return_status=>l_return_status);
2023: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2024: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2025: IF l_debug_on
2026: THEN
2027: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');
2028: END IF;

Line 2072: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2068: Get_EBS_To_OTM_UOM(
2069: p_uom=>l_dim_uom,
2070: x_uom=>l_otm_dim_uom,
2071: x_return_status=>l_return_status);
2072: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2073: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2074: IF l_debug_on
2075: THEN
2076: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Dim Failed');

Line 2073: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2069: p_uom=>l_dim_uom,
2070: x_uom=>l_otm_dim_uom,
2071: x_return_status=>l_return_status);
2072: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2073: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2074: IF l_debug_on
2075: THEN
2076: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Dim Failed');
2077: END IF;

Line 2129: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2125: x_length => x_source_line_tab(j).Length,
2126: x_height => x_source_line_tab(j).Height,
2127: x_width => x_source_line_tab(j).Width,
2128: x_return_status =>l_return_status );
2129: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2130: IF l_debug_on THEN
2131: WSH_DEBUG_SV.log(l_module_name,'WSH_CUSTOM_PUB.Override_RIQ_XML_Attribute Failed');
2132: END IF;
2133: RAISE FND_API.G_EXC_ERROR;

Line 2176: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2172: x_length => l_dummy,
2173: x_height => l_dummy,
2174: x_width => l_dummy,
2175: x_return_status => l_return_status );
2176: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2177: IF l_debug_on THEN
2178: WSH_DEBUG_SV.log(l_module_name,'WSH_CUSTOM_PUB.Override_RIQ_XML_Attribute Failed');
2179: END IF;
2180: RAISE FND_API.G_EXC_ERROR;

Line 2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2201: END IF;
2202:
2203: WHEN others THEN
2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2205: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Format_Line_Input_For_Xml',l_module_name);
2206:
2207: IF l_debug_on THEN
2208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2205: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Format_Line_Input_For_Xml',l_module_name);

2201: END IF;
2202:
2203: WHEN others THEN
2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2205: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Format_Line_Input_For_Xml',l_module_name);
2206:
2207: IF l_debug_on THEN
2208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2360: x_corporation_xid=>x_source_header_tab(i).SourceCorporationId,
2361: x_corporation_domain=>x_source_header_tab(i).SourceCorporationDomain,
2362: x_return_status=>l_return_status);
2363:
2364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2366: IF l_debug_on
2367: THEN
2368:

Line 2365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2361: x_corporation_domain=>x_source_header_tab(i).SourceCorporationDomain,
2362: x_return_status=>l_return_status);
2363:
2364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2366: IF l_debug_on
2367: THEN
2368:
2369: WSH_DEBUG_SV.log(l_module_name,'Source Location Get Info Failed');

Line 2410: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2406: x_corporation_xid=>x_source_header_tab(i).DestCorporationId,
2407: x_corporation_domain=>x_source_header_tab(i).DestCorporationDomain,
2408: x_return_status=>l_return_status);
2409:
2410: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2411: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2412:
2413: IF l_debug_on
2414: THEN

Line 2411: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2407: x_corporation_domain=>x_source_header_tab(i).DestCorporationDomain,
2408: x_return_status=>l_return_status);
2409:
2410: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2411: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2412:
2413: IF l_debug_on
2414: THEN
2415:

Line 2463: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2459: x_generic=>l_generic_carrier,
2460: x_carrier_freight_code=>l_carrier_freight_code,
2461: x_return_status=>l_return_status);
2462:
2463: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2464: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2465: IF l_debug_on
2466: THEN
2467: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');

Line 2464: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2460: x_carrier_freight_code=>l_carrier_freight_code,
2461: x_return_status=>l_return_status);
2462:
2463: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2464: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2465: IF l_debug_on
2466: THEN
2467: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');
2468: END IF;

Line 2531: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2527: Get_EBS_To_OTM_UOM(
2528: p_uom=>p_source_header_tab(i).weight_uom_code,
2529: x_uom=>x_source_header_tab(i).TotalWeightUOM,
2530: x_return_status=>l_return_status);
2531: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2532: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2533: IF l_debug_on
2534: THEN
2535: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 2532: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2528: p_uom=>p_source_header_tab(i).weight_uom_code,
2529: x_uom=>x_source_header_tab(i).TotalWeightUOM,
2530: x_return_status=>l_return_status);
2531: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2532: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2533: IF l_debug_on
2534: THEN
2535: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
2536: END IF;

Line 2556: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

2552: Get_EBS_To_OTM_UOM(
2553: p_uom=>p_source_header_tab(i).volume_uom_code,
2554: x_uom=>x_source_header_tab(i).TotalVolumeUOM,
2555: x_return_status=>l_return_status);
2556: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2557: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2558: IF l_debug_on
2559: THEN
2560: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');

Line 2557: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

2553: p_uom=>p_source_header_tab(i).volume_uom_code,
2554: x_uom=>x_source_header_tab(i).TotalVolumeUOM,
2555: x_return_status=>l_return_status);
2556: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
2557: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2558: IF l_debug_on
2559: THEN
2560: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');
2561: END IF;

Line 2591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2588: END IF;
2589:
2590: WHEN others THEN
2591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2592: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.FORMAT_HEADER_INPUT_FOR_XML',l_module_name);
2593:
2594: IF l_debug_on THEN
2595: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2592: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.FORMAT_HEADER_INPUT_FOR_XML',l_module_name);

2588: END IF;
2589:
2590: WHEN others THEN
2591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2592: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.FORMAT_HEADER_INPUT_FOR_XML',l_module_name);
2593:
2594: IF l_debug_on THEN
2595: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3213: END IF;
3214:
3215: WHEN others THEN
3216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3217: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Create_RIQ_XML',l_module_name);
3218:
3219: IF l_debug_on THEN
3220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3217: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Create_RIQ_XML',l_module_name);

3213: END IF;
3214:
3215: WHEN others THEN
3216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3217: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Create_RIQ_XML',l_module_name);
3218:
3219: IF l_debug_on THEN
3220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3279: END IF;
3280:
3281: WHEN others THEN
3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3283: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Fetch_XML_Match',l_module_name);
3284: --
3285: IF l_debug_on THEN
3286: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3283: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Fetch_XML_Match',l_module_name);

3279: END IF;
3280:
3281: WHEN others THEN
3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3283: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Fetch_XML_Match',l_module_name);
3284: --
3285: IF l_debug_on THEN
3286: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

3402: p_xpath=>p_xpath_prefix||G_XPATH_MESSAGES,
3403: x_xml_seq=>l_xml_seq,
3404: x_return_status=>l_return_status);
3405:
3406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3408: IF l_debug_on
3409: THEN
3410:

Line 3407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

3403: x_xml_seq=>l_xml_seq,
3404: x_return_status=>l_return_status);
3405:
3406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3408: IF l_debug_on
3409: THEN
3410:
3411: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');

Line 3449: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3446: END IF;
3447:
3448: WHEN others THEN
3449: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3450: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Check_Response_Status',l_module_name);
3451: --
3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3450: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Check_Response_Status',l_module_name);

3446: END IF;
3447:
3448: WHEN others THEN
3449: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3450: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Check_Response_Status',l_module_name);
3451: --
3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3552: wsh_util_core.get_currency_conversion_type(

3548: IF l_debug_on THEN
3549: WSH_DEBUG_SV.log(l_module_name,'negative:l_rate',l_rate);
3550: END IF;
3551: END IF;
3552: wsh_util_core.get_currency_conversion_type(
3553: x_curr_conv_type => l_currency_conversion_type,
3554: x_return_status => l_return_status);
3555:
3556: IF l_debug_on THEN

Line 3561: if (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) then

3557: WSH_DEBUG_SV.log(l_module_name,'x_curr_conv_type',l_currency_conversion_type);
3558: WSH_DEBUG_SV.log(l_module_name,'x_return_status',l_return_status);
3559: END IF;
3560:
3561: if (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
3562: l_rate:=GL_CURRENCY_API.convert_amount(
3563: x_from_currency => l_currency,
3564: x_to_currency => p_currency,
3565: x_conversion_date => SYSDATE,

Line 3610: -- l_return_status is set from wsh_util_core.get_currency_conversion_type

3606:
3607: WHEN FND_API.G_EXC_ERROR THEN
3608: x_return_status := FND_API.G_RET_STS_ERROR;
3609:
3610: -- l_return_status is set from wsh_util_core.get_currency_conversion_type
3611: -- if it's success, gl_currency_api.convert_amount failed
3612: -- otherwise, error message is already set in the api, so no need to set it
3613: if (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
3614:

Line 3613: if (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) then

3609:
3610: -- l_return_status is set from wsh_util_core.get_currency_conversion_type
3611: -- if it's success, gl_currency_api.convert_amount failed
3612: -- otherwise, error message is already set in the api, so no need to set it
3613: if (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) then
3614:
3615: -- Bug 5886042
3616: -- currency conversion_type in the error message should be
3617: -- user_conversion_type

Line 3644: wsh_util_core.add_message(x_return_status);

3640: fnd_message.set_name('WSH', 'WSH_CURR_CONV_ERROR');
3641: fnd_message.set_token('FROM_CURR', l_currency);
3642: fnd_message.set_token('TO_CURR', p_currency);
3643: fnd_message.set_token('CONV_TYPE', l_user_conv_type);
3644: wsh_util_core.add_message(x_return_status);
3645: end if;
3646:
3647: IF l_debug_on THEN
3648: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3654: END IF;
3655:
3656: WHEN others THEN
3657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3658: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Single_Cost',l_module_name);
3659: --
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3658: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Single_Cost',l_module_name);

3654: END IF;
3655:
3656: WHEN others THEN
3657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3658: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Single_Cost',l_module_name);
3659: --
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3717: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

3713: p_currency=>p_currency,
3714: x_cost=>l_summary_rate,
3715: x_return_status=>l_return_status);
3716:
3717: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3718: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3719: IF l_debug_on
3720: THEN
3721:

Line 3718: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

3714: x_cost=>l_summary_rate,
3715: x_return_status=>l_return_status);
3716:
3717: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3718: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3719: IF l_debug_on
3720: THEN
3721:
3722: WSH_DEBUG_SV.log(l_module_name,'Extract_Single_Cost Failed');

Line 3750: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

3746: p_xpath=>p_xpath_prefix||G_XPATH_COST_DETAILS,
3747: x_xml_seq=>l_xml_seq,
3748: x_return_status=>l_return_status);
3749:
3750: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3751: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3752: IF l_debug_on
3753: THEN
3754:

Line 3751: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

3747: x_xml_seq=>l_xml_seq,
3748: x_return_status=>l_return_status);
3749:
3750: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3751: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3752: IF l_debug_on
3753: THEN
3754:
3755: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');

Line 3797: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

3793: p_currency=>p_currency,
3794: x_cost=>l_rate_detail,
3795: x_return_status=>l_return_status);
3796:
3797: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3798: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3799: IF l_debug_on
3800: THEN
3801:

Line 3798: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

3794: x_cost=>l_rate_detail,
3795: x_return_status=>l_return_status);
3796:
3797: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
3798: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3799: IF l_debug_on
3800: THEN
3801:
3802: WSH_DEBUG_SV.log(l_module_name,'Extract_Single_Cost Failed');

Line 3889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3886: END IF;
3887:
3888: WHEN others THEN
3889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3890: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Rate',l_module_name);
3891: --
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3890: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Rate',l_module_name);

3886: END IF;
3887:
3888: WHEN others THEN
3889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3890: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Rate',l_module_name);
3891: --
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3894: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4084: END IF;
4085:
4086: WHEN others THEN
4087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4088: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Ship_Method',l_module_name);
4089: --
4090: IF l_debug_on THEN
4091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4088: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Ship_Method',l_module_name);

4084: END IF;
4085:
4086: WHEN others THEN
4087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4088: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Ship_Method',l_module_name);
4089: --
4090: IF l_debug_on THEN
4091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4154: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4150:
4151: Validate_Carrier(
4152: p_carrier_id=>p_carrier_id,
4153: x_return_status=>l_return_status);
4154: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4155: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4156: IF l_debug_on
4157: THEN
4158:

Line 4155: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4151: Validate_Carrier(
4152: p_carrier_id=>p_carrier_id,
4153: x_return_status=>l_return_status);
4154: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4155: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4156: IF l_debug_on
4157: THEN
4158:
4159: WSH_DEBUG_SV.log(l_module_name,'Validate_Carrier Failed');

Line 4176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4172: p_lookup_type=>'WSH_SERVICE_LEVELS',
4173: p_lookup_code=>p_service_level,
4174: x_lookup_code=>x_result_service_level_tab(i),
4175: x_return_status=>l_return_status);
4176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4178: IF l_debug_on
4179: THEN
4180:

Line 4177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4173: p_lookup_code=>p_service_level,
4174: x_lookup_code=>x_result_service_level_tab(i),
4175: x_return_status=>l_return_status);
4176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4178: IF l_debug_on
4179: THEN
4180:
4181: WSH_DEBUG_SV.log(l_module_name,'Validate WSH_SERVICE_LEVELS Failed');

Line 4195: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4191: p_lookup_type=>'FREIGHT_TERMS',
4192: p_lookup_code=>l_freight_terms_code,
4193: x_lookup_code=>x_result_freight_term_tab(i),
4194: x_return_status=>l_return_status);
4195: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4196: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4197: IF l_debug_on
4198: THEN
4199:

Line 4196: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4192: p_lookup_code=>l_freight_terms_code,
4193: x_lookup_code=>x_result_freight_term_tab(i),
4194: x_return_status=>l_return_status);
4195: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4196: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4197: IF l_debug_on
4198: THEN
4199:
4200: WSH_DEBUG_SV.log(l_module_name,'Validate FREIGHT_TERMS Failed');

Line 4210: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4206: p_lookup_type=>'WSH_MODE_OF_TRANSPORT',
4207: p_lookup_code=>p_mode,
4208: x_lookup_code=>x_result_mode_of_transport_tab(i),
4209: x_return_status=>l_return_status);
4210: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4211: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4212: IF l_debug_on
4213: THEN
4214:

Line 4211: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4207: p_lookup_code=>p_mode,
4208: x_lookup_code=>x_result_mode_of_transport_tab(i),
4209: x_return_status=>l_return_status);
4210: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4211: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4212: IF l_debug_on
4213: THEN
4214:
4215: WSH_DEBUG_SV.log(l_module_name,'Validate WSH_MODE_OF_TRANSPORT Failed');

Line 4233: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4229: p_service_level=>p_service_level,
4230: x_ship_method_code=>l_ship_method_code,
4231: x_return_status=>l_return_status);
4232:
4233: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4234: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4235: IF l_debug_on
4236: THEN
4237:

Line 4234: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4230: x_ship_method_code=>l_ship_method_code,
4231: x_return_status=>l_return_status);
4232:
4233: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4234: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4235: IF l_debug_on
4236: THEN
4237:
4238: WSH_DEBUG_SV.log(l_module_name,'Get_Ship_Method_Code Failed');

Line 4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4262: END IF;
4263:
4264: WHEN others THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4266: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_SM_Result',l_module_name);
4267: --
4268: IF l_debug_on THEN
4269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4266: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_SM_Result',l_module_name);

4262: END IF;
4263:
4264: WHEN others THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4266: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_SM_Result',l_module_name);
4267: --
4268: IF l_debug_on THEN
4269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4270: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4521: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519:
4520: WHEN others THEN
4521: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4522: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Allocate_rates',l_module_name);
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4522: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Allocate_rates',l_module_name);

4518: END IF;
4519:
4520: WHEN others THEN
4521: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4522: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Allocate_rates',l_module_name);
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4611: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4607: x_generic=>l_generic_carrier,
4608: x_carrier_freight_code=>l_carrier_freight_code,
4609: x_return_status=>l_return_status);
4610:
4611: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4612: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4613: IF l_debug_on
4614: THEN
4615: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');

Line 4612: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4608: x_carrier_freight_code=>l_carrier_freight_code,
4609: x_return_status=>l_return_status);
4610:
4611: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4612: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4613: IF l_debug_on
4614: THEN
4615: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');
4616: END IF;

Line 4646: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4642: p_source_line_tab=>p_source_line_tab,
4643: x_source_line_rates_tab=>x_source_line_rates_tab,
4644: x_return_status=>l_return_status);
4645:
4646: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4647: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4648: IF l_debug_on
4649: THEN
4650:

Line 4647: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4643: x_source_line_rates_tab=>x_source_line_rates_tab,
4644: x_return_status=>l_return_status);
4645:
4646: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4647: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4648: IF l_debug_on
4649: THEN
4650:
4651: WSH_DEBUG_SV.log(l_module_name,'Allocate_rates Failed');

Line 4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4672: END IF;
4673:
4674: WHEN others THEN
4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4676: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_FC_Result',l_module_name);
4677: --
4678: IF l_debug_on THEN
4679: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4676: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_FC_Result',l_module_name);

4672: END IF;
4673:
4674: WHEN others THEN
4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4676: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_FC_Result',l_module_name);
4677: --
4678: IF l_debug_on THEN
4679: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4680: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4778: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4774: x_generic=>l_generic_carrier,
4775: x_carrier_freight_code=>l_carrier_freight_code,
4776: x_return_status=>l_return_status);
4777:
4778: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4779: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4780: IF l_debug_on
4781: THEN
4782: WSH_DEBUG_SV.log(l_module_name,'Get_Carrier_Info Failed');

Line 4779: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4775: x_carrier_freight_code=>l_carrier_freight_code,
4776: x_return_status=>l_return_status);
4777:
4778: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4779: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4780: IF l_debug_on
4781: THEN
4782: WSH_DEBUG_SV.log(l_module_name,'Get_Carrier_Info Failed');
4783: END IF;

Line 4817: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4813: p_source_line_tab=>p_source_line_tab,
4814: x_source_line_rates_tab=>x_source_line_rates_tab,
4815: x_return_status=>l_return_status);
4816:
4817: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4818: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4819: IF l_debug_on
4820: THEN
4821:

Line 4818: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4814: x_source_line_rates_tab=>x_source_line_rates_tab,
4815: x_return_status=>l_return_status);
4816:
4817: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4818: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4819: IF l_debug_on
4820: THEN
4821:
4822: WSH_DEBUG_SV.log(l_module_name,'Allocate_rates Failed');

Line 4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4854: END IF;
4855:
4856: WHEN others THEN
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Choose_SM_Result',l_module_name);
4859: --
4860: IF l_debug_on THEN
4861: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4858: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Choose_SM_Result',l_module_name);

4854: END IF;
4855:
4856: WHEN others THEN
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Choose_SM_Result',l_module_name);
4859: --
4860: IF l_debug_on THEN
4861: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4928: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4924: p_xml=>p_xml_output,
4925: p_xpath=>G_XPATH_GET_SM_RESULT,
4926: x_xml_seq=>l_xml_seq,
4927: x_return_status=>l_return_status);
4928: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4929: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4930: IF l_debug_on
4931: THEN
4932:

Line 4929: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4925: p_xpath=>G_XPATH_GET_SM_RESULT,
4926: x_xml_seq=>l_xml_seq,
4927: x_return_status=>l_return_status);
4928: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4929: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4930: IF l_debug_on
4931: THEN
4932:
4933: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');

Line 4963: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

4959: x_transit_time=>l_transit_time,
4960: x_transit_time_UOM=>l_transit_time_uom,
4961: x_return_status=>l_return_status);
4962:
4963: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4964: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4965: IF l_debug_on
4966: THEN
4967:

Line 4964: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

4960: x_transit_time_UOM=>l_transit_time_uom,
4961: x_return_status=>l_return_status);
4962:
4963: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
4964: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
4965: IF l_debug_on
4966: THEN
4967:
4968: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');

Line 5008: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5004: x_result_transit_time_max_tab=>x_result_transit_time_max_tab,
5005: x_ship_method_code_tab=>x_ship_method_code_tab,
5006: x_return_status=>l_return_status);
5007:
5008: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5009: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5010: IF l_debug_on
5011: THEN
5012:

Line 5009: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5005: x_ship_method_code_tab=>x_ship_method_code_tab,
5006: x_return_status=>l_return_status);
5007:
5008: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5009: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5010: IF l_debug_on
5011: THEN
5012:
5013: WSH_DEBUG_SV.log(l_module_name,'Populate_Get_SM_Result Failed');

Line 5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5043: END IF;
5044:
5045: WHEN others THEN
5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5047: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_SM_Response',l_module_name);
5048: --
5049: IF l_debug_on THEN
5050: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5047: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_SM_Response',l_module_name);

5043: END IF;
5044:
5045: WHEN others THEN
5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5047: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_SM_Response',l_module_name);
5048: --
5049: IF l_debug_on THEN
5050: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5144: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5140: x_summary_rate=>l_summary_rate,
5141: x_base_rate=>l_base_rate,
5142: x_charge_rate=>l_charge_rate,
5143: x_return_status=>l_return_status);
5144: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5145: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5146: IF l_debug_on
5147: THEN
5148:

Line 5145: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5141: x_base_rate=>l_base_rate,
5142: x_charge_rate=>l_charge_rate,
5143: x_return_status=>l_return_status);
5144: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5145: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5146: IF l_debug_on
5147: THEN
5148:
5149: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');

Line 5176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5172: x_source_line_rates_tab=>x_source_line_rates_tab,
5173: x_source_header_rates_tab=>x_source_header_rates_tab,
5174: x_return_status=>l_return_status);
5175:
5176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5178: IF l_debug_on
5179: THEN
5180:

Line 5177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5173: x_source_header_rates_tab=>x_source_header_rates_tab,
5174: x_return_status=>l_return_status);
5175:
5176: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5177: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5178: IF l_debug_on
5179: THEN
5180:
5181: WSH_DEBUG_SV.log(l_module_name,'Populate_Get_FC_Result Failed');

Line 5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5223: END IF;
5224:
5225: WHEN others THEN
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5227: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_FC_Response',l_module_name);
5228: -- in case the exception occured while working on
5229: -- cursor c_get_currency
5230: IF c_get_currency%ISOPEN THEN

Line 5227: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_FC_Response',l_module_name);

5223: END IF;
5224:
5225: WHEN others THEN
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5227: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_FC_Response',l_module_name);
5228: -- in case the exception occured while working on
5229: -- cursor c_get_currency
5230: IF c_get_currency%ISOPEN THEN
5231: CLOSE c_get_currency;

Line 5303: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5299: p_xpath=>G_XPATH_SM_OPTION,
5300: x_xml_seq=>l_xml_seq,
5301: x_return_status=>l_return_status);
5302:
5303: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5304: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5305: IF l_debug_on
5306: THEN
5307:

Line 5304: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5300: x_xml_seq=>l_xml_seq,
5301: x_return_status=>l_return_status);
5302:
5303: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5304: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5305: IF l_debug_on
5306: THEN
5307:
5308: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');

Line 5333: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5329: x_transit_time=>l_sm_rec.transit_time,
5330: x_transit_time_UOM=>l_sm_rec.transit_time_uom,
5331: x_return_status=>l_return_status);
5332:
5333: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5334: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5335: IF l_debug_on
5336: THEN
5337: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');

Line 5334: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5330: x_transit_time_UOM=>l_sm_rec.transit_time_uom,
5331: x_return_status=>l_return_status);
5332:
5333: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5334: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5335: IF l_debug_on
5336: THEN
5337: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');
5338: END IF;

Line 5378: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5374: p_service_level=>l_sm_rec.service_level,
5375: x_ship_method_code=>l_sm_rec.ship_method_code,
5376: x_return_status=>l_return_status);
5377:
5378: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5379: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5380:
5381: IF l_debug_on
5382: THEN

Line 5379: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5375: x_ship_method_code=>l_sm_rec.ship_method_code,
5376: x_return_status=>l_return_status);
5377:
5378: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5379: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5380:
5381: IF l_debug_on
5382: THEN
5383: WSH_DEBUG_SV.log(l_module_name,'Get_Ship_Method_Code Failed');

Line 5406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5402: x_summary_rate=>l_sm_rec.summary_rate,
5403: x_base_rate=>l_sm_rec.base_rate,
5404: x_charge_rate=>l_sm_rec.charge_rate,
5405: x_return_status=>l_return_status);
5406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5408: IF l_debug_on
5409: THEN
5410: WSH_DEBUG_SV.log(l_module_name,'Extract_Rate Failed');

Line 5407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5403: x_base_rate=>l_sm_rec.base_rate,
5404: x_charge_rate=>l_sm_rec.charge_rate,
5405: x_return_status=>l_return_status);
5406: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5407: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5408: IF l_debug_on
5409: THEN
5410: WSH_DEBUG_SV.log(l_module_name,'Extract_Rate Failed');
5411: END IF;

Line 5429: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5425: Validate_Transit_Time(
5426: x_transit_time=>l_sm_rec.transit_time,
5427: x_transit_time_uom=>l_sm_rec.transit_time_uom,
5428: x_return_status=>l_return_status);
5429: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5430: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5431: IF l_debug_on
5432: THEN
5433: WSH_DEBUG_SV.log(l_module_name,'Validate_Transit_Time Failed');

Line 5430: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5426: x_transit_time=>l_sm_rec.transit_time,
5427: x_transit_time_uom=>l_sm_rec.transit_time_uom,
5428: x_return_status=>l_return_status);
5429: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5430: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5431: IF l_debug_on
5432: THEN
5433: WSH_DEBUG_SV.log(l_module_name,'Validate_Transit_Time Failed');
5434:

Line 5497: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5493: x_source_line_rates_tab=>x_source_line_rates_tab,
5494: x_source_header_rates_tab=>x_source_header_rates_tab,
5495: x_return_status=>l_return_status);
5496:
5497: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5498: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5499: IF l_debug_on
5500: THEN
5501: WSH_DEBUG_SV.log(l_module_name,'Populate_Choose_SM_Result Failed');

Line 5498: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5494: x_source_header_rates_tab=>x_source_header_rates_tab,
5495: x_return_status=>l_return_status);
5496:
5497: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5498: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5499: IF l_debug_on
5500: THEN
5501: WSH_DEBUG_SV.log(l_module_name,'Populate_Choose_SM_Result Failed');
5502: END IF;

Line 5517: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5513: Sort(
5514: x_source_header_rates_tab=>x_source_header_rates_tab,
5515: x_return_status=>l_return_status);
5516:
5517: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5518: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5519: IF l_debug_on
5520: THEN
5521:

Line 5518: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5514: x_source_header_rates_tab=>x_source_header_rates_tab,
5515: x_return_status=>l_return_status);
5516:
5517: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5518: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5519: IF l_debug_on
5520: THEN
5521:
5522: WSH_DEBUG_SV.log(l_module_name,'Sort Failed');

Line 5558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5555: END IF;
5556:
5557: WHEN others THEN
5558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5559: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Choose_SM_Response',l_module_name);
5560: --
5561: IF l_debug_on THEN
5562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5559: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Choose_SM_Response',l_module_name);

5555: END IF;
5556:
5557: WHEN others THEN
5558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5559: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Choose_SM_Response',l_module_name);
5560: --
5561: IF l_debug_on THEN
5562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5635: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5631: Check_Response_Status(
5632: p_xpath_prefix=>l_xpath_status_prefix,
5633: p_xml_output=>p_xml_output,
5634: x_return_status=>l_return_status);
5635: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5636: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5637: IF l_debug_on
5638: THEN
5639:

Line 5636: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5632: p_xpath_prefix=>l_xpath_status_prefix,
5633: p_xml_output=>p_xml_output,
5634: x_return_status=>l_return_status);
5635: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5636: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5637: IF l_debug_on
5638: THEN
5639:
5640: WSH_DEBUG_SV.log(l_module_name,'Check_Response_Status Failed');

Line 5660: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5656: x_source_line_rates_tab=>x_source_line_rates_tab,
5657: x_source_header_rates_tab=>x_source_header_rates_tab,
5658: x_return_status=>l_return_status);
5659:
5660: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5661: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5662: IF l_debug_on
5663: THEN
5664:

Line 5661: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5657: x_source_header_rates_tab=>x_source_header_rates_tab,
5658: x_return_status=>l_return_status);
5659:
5660: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5661: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5662: IF l_debug_on
5663: THEN
5664:
5665: WSH_DEBUG_SV.log(l_module_name,'Handle_Choose_SM_Response Failed');

Line 5684: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5680: x_source_line_rates_tab=>x_source_line_rates_tab,
5681: x_source_header_rates_tab=>x_source_header_rates_tab,
5682: x_return_status=>l_return_status);
5683:
5684: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5685: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5686: IF l_debug_on
5687: THEN
5688:

Line 5685: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5681: x_source_header_rates_tab=>x_source_header_rates_tab,
5682: x_return_status=>l_return_status);
5683:
5684: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5685: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5686: IF l_debug_on
5687: THEN
5688:
5689: WSH_DEBUG_SV.log(l_module_name,'Handle_Get_FC_Response Failed');

Line 5714: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

5710: x_result_transit_time_max_tab=>x_result_transit_time_max_tab,
5711: x_ship_method_code_tab=>x_ship_method_code_tab,
5712: x_return_status=>l_return_status);
5713:
5714: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5715: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5716: IF l_debug_on
5717: THEN
5718:

Line 5715: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5711: x_ship_method_code_tab=>x_ship_method_code_tab,
5712: x_return_status=>l_return_status);
5713:
5714: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
5715: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5716: IF l_debug_on
5717: THEN
5718:
5719: WSH_DEBUG_SV.log(l_module_name,'Handle_Get_FC_Response Failed');

Line 5747: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5744: END IF;
5745:
5746: WHEN others THEN
5747: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5748: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Parse_RIQ_Output_XML',l_module_name);
5749: --
5750: IF l_debug_on THEN
5751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5748: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Parse_RIQ_Output_XML',l_module_name);

5744: END IF;
5745:
5746: WHEN others THEN
5747: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5748: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Parse_RIQ_Output_XML',l_module_name);
5749: --
5750: IF l_debug_on THEN
5751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5870: END IF;
5871:
5872: WHEN others THEN
5873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5874: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Init_Globals',l_module_name);
5875: --
5876: IF l_debug_on THEN
5877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5874: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Init_Globals',l_module_name);

5870: END IF;
5871:
5872: WHEN others THEN
5873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5874: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Init_Globals',l_module_name);
5875: --
5876: IF l_debug_on THEN
5877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5933: END IF;
5934:
5935: WHEN others THEN
5936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5937: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Clear_Globals',l_module_name);
5938: --
5939: IF l_debug_on THEN
5940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5937: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Clear_Globals',l_module_name);

5933: END IF;
5934:
5935: WHEN others THEN
5936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5937: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Clear_Globals',l_module_name);
5938: --
5939: IF l_debug_on THEN
5940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5941: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6036: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6032: END IF;
6033: i:=x_source_line_tab.NEXT(i);
6034: END LOOP;
6035:
6036: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6037: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6038: IF l_debug_on
6039: THEN
6040:

Line 6037: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6033: i:=x_source_line_tab.NEXT(i);
6034: END LOOP;
6035:
6036: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6037: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6038: IF l_debug_on
6039: THEN
6040:
6041: WSH_DEBUG_SV.log(l_module_name,'Format_Line_Input_For_Xml Failed');

Line 6057: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6053: p_action=>p_action,
6054: x_xml_input=>l_xml_input,
6055: x_return_status=>l_return_status);
6056:
6057: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6058: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6059: IF l_debug_on
6060: THEN
6061:

Line 6058: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6054: x_xml_input=>l_xml_input,
6055: x_return_status=>l_return_status);
6056:
6057: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6058: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6059: IF l_debug_on
6060: THEN
6061:
6062: WSH_DEBUG_SV.log(l_module_name,'Create_RIQ_XML Failed');

Line 6076: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6072:
6073: print_CLOB(p_CLOB=>l_xml_input.getClobVal(),
6074: x_return_status=>l_return_status);
6075:
6076: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6077: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6078: IF l_debug_on
6079: THEN
6080: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');

Line 6077: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6073: print_CLOB(p_CLOB=>l_xml_input.getClobVal(),
6074: x_return_status=>l_return_status);
6075:
6076: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6077: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6078: IF l_debug_on
6079: THEN
6080: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');
6081: END IF;

Line 6103: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6099: p_request=>l_xml_input,
6100: x_response=>l_xmlCLOB,
6101: x_return_status=>l_return_status);
6102:
6103: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6104: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6105: IF l_debug_on
6106: THEN
6107:

Line 6104: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6100: x_response=>l_xmlCLOB,
6101: x_return_status=>l_return_status);
6102:
6103: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6104: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6105: IF l_debug_on
6106: THEN
6107:
6108: WSH_DEBUG_SV.log(l_module_name,'POST_REQUEST_TO_OTM Failed');

Line 6140: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6136:
6137: print_CLOB(p_CLOB=>l_xmlCLOB,
6138: x_return_status=>l_return_status);
6139:
6140: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6141: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6142: IF l_debug_on
6143: THEN
6144: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');

Line 6141: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6137: print_CLOB(p_CLOB=>l_xmlCLOB,
6138: x_return_status=>l_return_status);
6139:
6140: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6141: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6142: IF l_debug_on
6143: THEN
6144: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');
6145: END IF;

Line 6185: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6181: x_result_transit_time_max_tab=>x_result_transit_time_max_tab,
6182: x_ship_method_code_tab=>x_ship_method_code_tab,
6183: x_return_status=>l_return_status);
6184:
6185: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6186: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6187: IF l_debug_on
6188: THEN
6189: WSH_DEBUG_SV.log(l_module_name,'Parse_RIQ_Output_XML Failed');

Line 6186: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6182: x_ship_method_code_tab=>x_ship_method_code_tab,
6183: x_return_status=>l_return_status);
6184:
6185: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6186: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6187: IF l_debug_on
6188: THEN
6189: WSH_DEBUG_SV.log(l_module_name,'Parse_RIQ_Output_XML Failed');
6190: END IF;

Line 6219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6216: END IF;
6217:
6218: WHEN others THEN
6219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6220: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Process_One_Header',l_module_name);
6221: --
6222: IF l_debug_on THEN
6223: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 6220: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Process_One_Header',l_module_name);

6216: END IF;
6217:
6218: WHEN others THEN
6219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6220: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Process_One_Header',l_module_name);
6221: --
6222: IF l_debug_on THEN
6223: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6304: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

6300: WSH_DEBUG_SV.log(l_module_name,'Return Status after call to DERIVE_RIQ_DATES ', x_return_status );
6301: END IF;
6302:
6303: -- Handle Return Status for Error or Unexpected error.
6304: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6305: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6306: -- standard error raising, as used in this API
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;

Line 6305: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

6301: END IF;
6302:
6303: -- Handle Return Status for Error or Unexpected error.
6304: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6305: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6306: -- standard error raising, as used in this API
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;
6309: --ECO 5516007 changes end, FP to R12

Line 6319: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6315: THEN
6316: print_source_line_tab (
6317: p_source_line_tab=>x_source_line_tab,
6318: x_return_status=>l_return_status);
6319: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6320: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6321: IF l_debug_on
6322: THEN
6323: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');

Line 6320: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6316: print_source_line_tab (
6317: p_source_line_tab=>x_source_line_tab,
6318: x_return_status=>l_return_status);
6319: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6320: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6321: IF l_debug_on
6322: THEN
6323: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');
6324: END IF;

Line 6331: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6327:
6328: print_source_header_tab (
6329: p_source_header_tab=>x_source_header_tab,
6330: x_return_status=>l_return_status);
6331: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6332: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6333: IF l_debug_on
6334: THEN
6335: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');

Line 6332: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6328: print_source_header_tab (
6329: p_source_header_tab=>x_source_header_tab,
6330: x_return_status=>l_return_status);
6331: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6332: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6333: IF l_debug_on
6334: THEN
6335: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6336: END IF;

Line 6344: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6340: END IF;
6341:
6342: Init_Globals(
6343: x_return_status=>l_return_status);
6344: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6345: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6346: IF l_debug_on
6347: THEN
6348: WSH_DEBUG_SV.log(l_module_name,'Init_Globals Failed');

Line 6345: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6341:
6342: Init_Globals(
6343: x_return_status=>l_return_status);
6344: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6345: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6346: IF l_debug_on
6347: THEN
6348: WSH_DEBUG_SV.log(l_module_name,'Init_Globals Failed');
6349: END IF;

Line 6364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6360: p_action=>p_action,
6361: x_source_header_tab=>l_source_header_tab_xml,
6362: x_return_status=>l_return_status);
6363:
6364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6366: IF l_debug_on
6367: THEN
6368:

Line 6365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6361: x_source_header_tab=>l_source_header_tab_xml,
6362: x_return_status=>l_return_status);
6363:
6364: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6365: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6366: IF l_debug_on
6367: THEN
6368:
6369: WSH_DEBUG_SV.log(l_module_name,'Format_Header_Input_For_Xml Failed');

Line 6395: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,

6391: 'RAMS_PVT.Get l_return_status ',l_return_status);
6392: WSH_DEBUG_SV.log(l_module_name,'Ship param not defined for org',
6393: x_source_header_tab(i).ship_from_org_id);
6394: END IF;
6395: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
6396: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399: END IF; --}

Line 6396: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

6392: WSH_DEBUG_SV.log(l_module_name,'Ship param not defined for org',
6393: x_source_header_tab(i).ship_from_org_id);
6394: END IF;
6395: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
6396: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399: END IF; --}
6400: --OTM R12 End

Line 6421: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6417: x_result_transit_time_max_tab=>x_result_transit_time_max_tab,
6418: x_ship_method_code_tab=>x_ship_method_code_tab,
6419: x_return_status=>l_return_status);
6420:
6421: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6422: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6423: IF l_debug_on
6424: THEN
6425: WSH_DEBUG_SV.log(l_module_name,'Process_One_Header Failed');

Line 6422: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6418: x_ship_method_code_tab=>x_ship_method_code_tab,
6419: x_return_status=>l_return_status);
6420:
6421: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6422: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6423: IF l_debug_on
6424: THEN
6425: WSH_DEBUG_SV.log(l_module_name,'Process_One_Header Failed');
6426: END IF;

Line 6444: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6440: --Perform any post processing on the output
6441:
6442: Clear_Globals(
6443: x_return_status=>l_return_status);
6444: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6445: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6446: IF l_debug_on
6447: THEN
6448: WSH_DEBUG_SV.log(l_module_name,'Clear_Globals Failed');

Line 6445: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6441:
6442: Clear_Globals(
6443: x_return_status=>l_return_status);
6444: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6445: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6446: IF l_debug_on
6447: THEN
6448: WSH_DEBUG_SV.log(l_module_name,'Clear_Globals Failed');
6449: END IF;

Line 6460: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6456:
6457: print_source_line_tab (
6458: p_source_line_tab=>x_source_line_tab,
6459: x_return_status=>l_return_status);
6460: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6461: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6462: IF l_debug_on
6463: THEN
6464: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');

Line 6461: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6457: print_source_line_tab (
6458: p_source_line_tab=>x_source_line_tab,
6459: x_return_status=>l_return_status);
6460: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6461: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6462: IF l_debug_on
6463: THEN
6464: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');
6465: END IF;

Line 6472: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6468:
6469: print_source_header_tab (
6470: p_source_header_tab=>x_source_header_tab,
6471: x_return_status=>l_return_status);
6472: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6473: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6474: IF l_debug_on
6475: THEN
6476: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');

Line 6473: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6469: print_source_header_tab (
6470: p_source_header_tab=>x_source_header_tab,
6471: x_return_status=>l_return_status);
6472: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6473: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6474: IF l_debug_on
6475: THEN
6476: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6477: END IF;

Line 6486: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6482: print_rates_tab (
6483: p_source_line_rates_tab=>x_source_line_rates_tab,
6484: p_source_header_rates_tab=>x_source_header_rates_tab,
6485: x_return_status=>l_return_status);
6486: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6487: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6488: IF l_debug_on
6489: THEN
6490: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');

Line 6487: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6483: p_source_line_rates_tab=>x_source_line_rates_tab,
6484: p_source_header_rates_tab=>x_source_header_rates_tab,
6485: x_return_status=>l_return_status);
6486: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6487: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6488: IF l_debug_on
6489: THEN
6490: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6491: END IF;

Line 6505: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

6501: p_result_transit_time_min_tab=>x_result_transit_time_min_tab,
6502: p_result_transit_time_max_tab=>x_result_transit_time_max_tab,
6503: p_ship_method_code_tab=>x_ship_method_code_tab,
6504: x_return_status=>l_return_status);
6505: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6506: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6507: IF l_debug_on
6508: THEN
6509: WSH_DEBUG_SV.log(l_module_name,'print_CS_Results Failed');

Line 6506: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

6502: p_result_transit_time_max_tab=>x_result_transit_time_max_tab,
6503: p_ship_method_code_tab=>x_ship_method_code_tab,
6504: x_return_status=>l_return_status);
6505: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
6506: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6507: IF l_debug_on
6508: THEN
6509: WSH_DEBUG_SV.log(l_module_name,'print_CS_Results Failed');
6510: END IF;

Line 6521: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6517:
6518:
6519: IF (l_failed_header_count = l_total_header_count)
6520: THEN
6521: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6522: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6523: IF l_debug_on
6524: THEN
6525: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

Line 6541: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6537:
6538: FND_MSG_PUB.ADD;
6539: ELSIF (l_failed_header_count = 0)
6540: THEN
6541: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6542:
6543: ELSE -- partial failure
6544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6545: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

Line 6544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6540: THEN
6541: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6542:
6543: ELSE -- partial failure
6544: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6545: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6546: IF l_debug_on
6547: THEN
6548: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

Line 6609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6605: ELSE
6606: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
6607: END IF;
6608: FND_MSG_PUB.ADD;
6609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6610: FND_MSG_PUB.Count_And_Get
6611: (
6612: p_count => x_msg_count,
6613: p_data => x_msg_data,

Line 6641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6637: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RATE_MUL_OMDEL_FL');
6638: END IF;
6639:
6640: FND_MSG_PUB.ADD;
6641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6642: FND_MSG_PUB.Count_And_Get
6643: (
6644: p_count => x_msg_count,
6645: p_data => x_msg_data,

Line 6648: --wsh_util_core.default_handler('WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM',l_module_name);

6644: p_count => x_msg_count,
6645: p_data => x_msg_data,
6646: p_encoded => FND_API.G_FALSE
6647: );
6648: --wsh_util_core.default_handler('WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM',l_module_name);
6649: --
6650: IF l_debug_on THEN
6651: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
6652: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);