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.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_DEBUG_SV

Line 481: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

477: x_number_of_warnings IN OUT NOCOPY NUMBER,
478: x_return_status OUT NOCOPY VARCHAR2
479: )
480: IS
481: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
482: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'API_POST_CALL';
483: l_msg_type VARCHAR2(1);
484: BEGIN
485: --

Line 487: wsh_debug_sv.push(l_module_name);

483: l_msg_type VARCHAR2(1);
484: BEGIN
485: --
486: IF l_debug_on THEN
487: wsh_debug_sv.push(l_module_name);
488: END IF;
489: x_return_status := p_api_return_status; -- default
490: IF p_api_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
491: THEN

Line 515: WSH_DEBUG_SV.pop(l_module_name);

511: p_delivery_leg_id => p_delivery_leg_id);
512: END IF;
513: End IF;
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.pop(l_module_name);
516: END IF;
517: --
518: EXCEPTION
519: WHEN OTHERS THEN

Line 675: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

671: l_return_status VARCHAR2(30);
672: l_return_status_1 VARCHAR2(30);
673: l_number_of_errors NUMBER;
674: l_number_of_warnings NUMBER;
675: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
676: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_DELIVERY';
677: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DELIVERY';
678:
679: l_check_dlv_shipmethod VARCHAR2(1) := 'N';

Line 686: wsh_debug_sv.push(l_module_name);

682: --
683: x_return_code := G_RC_SUCCESS;
684:
685: IF l_debug_on THEN
686: wsh_debug_sv.push(l_module_name);
687: END IF;
688:
689: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
690: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 936: WSH_DEBUG_SV.pop(l_module_name);

932: raise g_finished_warning;
933: END IF;
934:
935: IF l_debug_on THEN
936: WSH_DEBUG_SV.pop(l_module_name);
937: END IF;
938:
939: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
940:

Line 944: WSH_DEBUG_SV.pop(l_module_name);

940:
941: EXCEPTION
942: WHEN g_finished_warning THEN
943: IF l_debug_on THEN
944: WSH_DEBUG_SV.pop(l_module_name);
945: END IF;
946: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
947: --
948: WHEN FND_API.G_EXC_ERROR THEN

Line 951: WSH_DEBUG_SV.pop(l_module_name);

947: --
948: WHEN FND_API.G_EXC_ERROR THEN
949: x_return_code := G_RC_ERROR;
950: IF l_debug_on THEN
951: WSH_DEBUG_SV.pop(l_module_name);
952: END IF;
953: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
954: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
955: --

Line 959: WSH_DEBUG_SV.pop(l_module_name);

955: --
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_code := G_RC_ERROR;
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.pop(l_module_name);
960: END IF;
961: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
962: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
963: --

Line 968: WSH_DEBUG_SV.pop(l_module_name);

964: WHEN OTHERS THEN
965: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
966: x_return_code := G_RC_ERROR;
967: IF l_debug_on THEN
968: WSH_DEBUG_SV.pop(l_module_name);
969: END IF;
970: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
971: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
972: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 1002: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

998: l_idx NUMBER;
999: --
1000: l_number_of_errors NUMBER;
1001: l_number_of_warnings NUMBER;
1002: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1003: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_TRIP';
1004: --
1005: --
1006: BEGIN

Line 1011: wsh_debug_sv.push(l_module_name);

1007: --
1008: x_return_status := FND_API.G_RET_STS_SUCCESS;
1009: --
1010: IF l_debug_on THEN
1011: wsh_debug_sv.push(l_module_name);
1012: END IF;
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(

Line 1015: WSH_DEBUG_SV.logmsg(

1011: wsh_debug_sv.push(l_module_name);
1012: END IF;
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(
1016: l_module_name,
1017: 'p_delivery_id '||p_delivery_id,
1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: END IF;

Line 1018: WSH_DEBUG_SV.C_PROC_LEVEL);

1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(
1016: l_module_name,
1017: 'p_delivery_id '||p_delivery_id,
1018: WSH_DEBUG_SV.C_PROC_LEVEL);
1019: END IF;
1020:
1021: l_idx := 0;
1022: IF (g_dlv_tab.COUNT >0) THEN

Line 1108: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_leg_id=>'||l_delivery_leg_id

1104: --
1105: END LOOP;
1106: --
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_leg_id=>'||l_delivery_leg_id
1109: ||'l_trip_id=>'||l_trip_id ,WSH_DEBUG_SV.C_PROC_LEVEL);
1110: END IF;
1111: x_delivery_leg_id := l_delivery_leg_id;
1112: x_trip_id := l_trip_id;

Line 1109: ||'l_trip_id=>'||l_trip_id ,WSH_DEBUG_SV.C_PROC_LEVEL);

1105: END LOOP;
1106: --
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_leg_id=>'||l_delivery_leg_id
1109: ||'l_trip_id=>'||l_trip_id ,WSH_DEBUG_SV.C_PROC_LEVEL);
1110: END IF;
1111: x_delivery_leg_id := l_delivery_leg_id;
1112: x_trip_id := l_trip_id;
1113: --

Line 1115: WSH_DEBUG_SV.pop(l_module_name);

1111: x_delivery_leg_id := l_delivery_leg_id;
1112: x_trip_id := l_trip_id;
1113: --
1114: IF l_debug_on THEN
1115: WSH_DEBUG_SV.pop(l_module_name);
1116: END IF;
1117: --
1118: --
1119: EXCEPTION

Line 1123: WSH_DEBUG_SV.pop(l_module_name);

1119: EXCEPTION
1120: WHEN FND_API.G_EXC_ERROR THEN
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: IF l_debug_on THEN
1123: WSH_DEBUG_SV.pop(l_module_name);
1124: END IF;
1125: --
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1129: WSH_DEBUG_SV.pop(l_module_name);

1125: --
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1128: IF l_debug_on THEN
1129: WSH_DEBUG_SV.pop(l_module_name);
1130: END IF;
1131: --
1132: WHEN OTHERS THEN
1133: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.create_trip');

Line 1136: WSH_DEBUG_SV.pop(l_module_name);

1132: WHEN OTHERS THEN
1133: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.create_trip');
1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.pop(l_module_name);
1137: END IF;
1138: --
1139: END create_trip;
1140: --

Line 1171: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1167: l_return_status_1 VARCHAR2(1);
1168: --
1169: l_number_of_errors NUMBER;
1170: l_number_of_warnings NUMBER;
1171: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1172: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UPDATE_SINGLE_TRIP';
1173: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1174: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SINGLE_TRIP';
1175: --

Line 1200: wsh_debug_sv.push(l_module_name);

1196: --
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198: --
1199: IF l_debug_on THEN
1200: wsh_debug_sv.push(l_module_name);
1201: END IF;
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_id=>'||p_trip_id

Line 1204: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_id=>'||p_trip_id

1200: wsh_debug_sv.push(l_module_name);
1201: END IF;
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_id=>'||p_trip_id
1205: ||'p_lane_id=>'||p_lane_id
1206: ||'p_ship_method_code=>'||p_ship_method_code
1207: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: END IF;

Line 1207: ,WSH_DEBUG_SV.C_PROC_LEVEL);

1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'p_trip_id=>'||p_trip_id
1205: ||'p_lane_id=>'||p_lane_id
1206: ||'p_ship_method_code=>'||p_ship_method_code
1207: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1208: END IF;
1209:
1210: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1211: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 1387: WSH_DEBUG_SV.pop(l_module_name);

1383: p_encoded => FND_API.G_FALSE
1384: );
1385: --
1386: IF l_debug_on THEN
1387: WSH_DEBUG_SV.pop(l_module_name);
1388: END IF;
1389: --
1390: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1391: --

Line 1402: WSH_DEBUG_SV.pop(l_module_name);

1398: p_data => x_msg_data,
1399: p_encoded => FND_API.G_FALSE
1400: );
1401: IF l_debug_on THEN
1402: WSH_DEBUG_SV.pop(l_module_name);
1403: END IF;
1404: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
1405: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1406: --

Line 1416: WSH_DEBUG_SV.pop(l_module_name);

1412: p_data => x_msg_data,
1413: p_encoded => FND_API.G_FALSE
1414: );
1415: IF l_debug_on THEN
1416: WSH_DEBUG_SV.pop(l_module_name);
1417: END IF;
1418: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
1419: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1420: --

Line 1431: WSH_DEBUG_SV.pop(l_module_name);

1427: p_data => x_msg_data,
1428: p_encoded => FND_API.G_FALSE
1429: );
1430: IF l_debug_on THEN
1431: WSH_DEBUG_SV.pop(l_module_name);
1432: END IF;
1433: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1434: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1435: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 1455: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1451: l_msg_data VARCHAR2(32767);
1452: --
1453: l_number_of_errors NUMBER;
1454: l_number_of_warnings NUMBER;
1455: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1456: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UPDATE_TRIPS';
1457: --
1458: BEGIN
1459: SAVEPOINT UPDATE_TRIPS;

Line 1464: wsh_debug_sv.push(l_module_name);

1460: --
1461: x_return_status := FND_API.G_RET_STS_SUCCESS;
1462: --
1463: IF l_debug_on THEN
1464: wsh_debug_sv.push(l_module_name);
1465: END IF;
1466: --
1467: IF (p_matched_lanes.COUNT > 0) THEN
1468: FOR i IN p_matched_lanes.FIRST .. p_matched_lanes.LAST

Line 1473: WSH_DEBUG_SV.logmsg(l_module_name,'p_matched_lanes : i =>'||i

1469: LOOP
1470: --
1471:
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.logmsg(l_module_name,'p_matched_lanes : i =>'||i
1474: ||'trip_id=>'||p_matched_lanes(i).trip_id
1475: ||'delivery_leg_id=>'||p_matched_lanes(i).delivery_leg_id
1476: ||'delivery_id=>'||p_matched_lanes(i).delivery_id
1477: ||'lane_id=>'||p_matched_lanes(i).lane_id

Line 1480: ,WSH_DEBUG_SV.C_PROC_LEVEL);

1476: ||'delivery_id=>'||p_matched_lanes(i).delivery_id
1477: ||'lane_id=>'||p_matched_lanes(i).lane_id
1478: ||'ship_method_code=>'||p_matched_lanes(i).ship_method_code
1479: ||'new_match=>'||p_matched_lanes(i).new_match
1480: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1481: END IF;
1482: IF (p_matched_lanes(i).new_match = 'Y') THEN
1483: --
1484: update_single_trip (p_trip_id => p_matched_lanes(i).trip_id,

Line 1522: WSH_DEBUG_SV.pop(l_module_name);

1518: p_encoded => FND_API.G_FALSE
1519: );
1520: --
1521: IF l_debug_on THEN
1522: WSH_DEBUG_SV.pop(l_module_name);
1523: END IF;
1524: --
1525: --
1526: EXCEPTION

Line 1537: WSH_DEBUG_SV.pop(l_module_name);

1533: p_data => x_msg_data,
1534: p_encoded => FND_API.G_FALSE
1535: );
1536: IF l_debug_on THEN
1537: WSH_DEBUG_SV.pop(l_module_name);
1538: END IF;
1539: --
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: ROLLBACK TO UPDATE_TRIPS;

Line 1550: WSH_DEBUG_SV.pop(l_module_name);

1546: p_data => x_msg_data,
1547: p_encoded => FND_API.G_FALSE
1548: );
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.pop(l_module_name);
1551: END IF;
1552: --
1553: WHEN OTHERS THEN
1554: ROLLBACK TO UPDATE_TRIPS;

Line 1564: WSH_DEBUG_SV.pop(l_module_name);

1560: p_data => x_msg_data,
1561: p_encoded => FND_API.G_FALSE
1562: );
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: --
1567: END update_trips;
1568: --

Line 1589: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1585: l_idx NUMBER;
1586:
1587: l_number_of_errors NUMBER;
1588: l_number_of_warnings NUMBER;
1589: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1590: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'UNASSIGN_TRIP';
1591: --
1592: BEGIN
1593: SAVEPOINT UNASSIGN_TRIP;

Line 1598: wsh_debug_sv.push(l_module_name);

1594: --
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596: --
1597: IF l_debug_on THEN
1598: wsh_debug_sv.push(l_module_name);
1599: END IF;
1600: --
1601: l_idx := 0;
1602: IF (g_dlv_tab.COUNT >0) THEN

Line 1661: WSH_DEBUG_SV.pop(l_module_name);

1657: p_encoded => FND_API.G_FALSE
1658: );
1659: --
1660: IF l_debug_on THEN
1661: WSH_DEBUG_SV.pop(l_module_name);
1662: END IF;
1663: --
1664: --
1665: EXCEPTION

Line 1676: WSH_DEBUG_SV.pop(l_module_name);

1672: p_data => x_msg_data,
1673: p_encoded => FND_API.G_FALSE
1674: );
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: --
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO UNASSIGN_TRIP;

Line 1689: WSH_DEBUG_SV.pop(l_module_name);

1685: p_data => x_msg_data,
1686: p_encoded => FND_API.G_FALSE
1687: );
1688: IF l_debug_on THEN
1689: WSH_DEBUG_SV.pop(l_module_name);
1690: END IF;
1691: --
1692: WHEN OTHERS THEN
1693: ROLLBACK TO UNASSIGN_TRIP;

Line 1703: WSH_DEBUG_SV.pop(l_module_name);

1699: p_data => x_msg_data,
1700: p_encoded => FND_API.G_FALSE
1701: );
1702: IF l_debug_on THEN
1703: WSH_DEBUG_SV.pop(l_module_name);
1704: END IF;
1705: --
1706: END unassign_trip;
1707: --

Line 1739: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1735: l_msg_data VARCHAR2(32767);
1736: --
1737: l_number_of_errors NUMBER;
1738: l_number_of_warnings NUMBER;
1739: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1740: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CANCEL_SERVICE';
1741:
1742: cursor c_get_dleg_summ_recs (c_dleg_id NUMBER)
1743: is

Line 1763: wsh_debug_sv.push(l_module_name);

1759: --
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761: --
1762: IF l_debug_on THEN
1763: wsh_debug_sv.push(l_module_name);
1764: END IF;
1765:
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id=>'||p_delivery_id

Line 1767: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id=>'||p_delivery_id

1763: wsh_debug_sv.push(l_module_name);
1764: END IF;
1765:
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id=>'||p_delivery_id
1768: ||'p_action=>'||p_action
1769: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1770: END IF;
1771:

Line 1769: ,WSH_DEBUG_SV.C_PROC_LEVEL);

1765:
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id=>'||p_delivery_id
1768: ||'p_action=>'||p_action
1769: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1770: END IF;
1771:
1772: -- supported actions
1773: IF (p_action <> 'CANCEL') THEN

Line 1837: WSH_DEBUG_SV.logmsg(l_module_name,'g_dlv_tab.COUNT = '||g_dlv_tab.COUNT

1833: --
1834: END LOOP;
1835:
1836: IF l_debug_on THEN
1837: WSH_DEBUG_SV.logmsg(l_module_name,'g_dlv_tab.COUNT = '||g_dlv_tab.COUNT
1838: ||'g_dlv_leg_tab.COUNT = '||g_dlv_leg_tab.COUNT
1839: ||'g_trip_info_tab.COUNT = '||g_trip_info_tab.COUNT
1840: ||'g_dleg_trip_tab.COUNT = '||g_dleg_trip_tab.COUNT
1841: ,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1841: ,WSH_DEBUG_SV.C_PROC_LEVEL);

1837: WSH_DEBUG_SV.logmsg(l_module_name,'g_dlv_tab.COUNT = '||g_dlv_tab.COUNT
1838: ||'g_dlv_leg_tab.COUNT = '||g_dlv_leg_tab.COUNT
1839: ||'g_trip_info_tab.COUNT = '||g_trip_info_tab.COUNT
1840: ||'g_dleg_trip_tab.COUNT = '||g_dleg_trip_tab.COUNT
1841: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1842: END IF;
1843:
1844: IF (g_dlv_tab.COUNT > 0 AND g_dlv_tab.EXISTS(p_delivery_id)) THEN
1845: --

Line 2032: WSH_DEBUG_SV.log(l_module_name,'About to update wfc for delivery_leg_id =>'

2028: )
2029: );
2030:
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.log(l_module_name,'About to update wfc for delivery_leg_id =>'
2033: ||g_dlv_leg_tab(i).delivery_leg_id
2034: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2035: WSH_DEBUG_SV.log(l_module_name,'l_fc_count=>'||l_fc_count
2036: ,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2034: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2030:
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.log(l_module_name,'About to update wfc for delivery_leg_id =>'
2033: ||g_dlv_leg_tab(i).delivery_leg_id
2034: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2035: WSH_DEBUG_SV.log(l_module_name,'l_fc_count=>'||l_fc_count
2036: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2037: END IF;
2038: -- TO DO: handle locking issues

Line 2035: WSH_DEBUG_SV.log(l_module_name,'l_fc_count=>'||l_fc_count

2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.log(l_module_name,'About to update wfc for delivery_leg_id =>'
2033: ||g_dlv_leg_tab(i).delivery_leg_id
2034: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2035: WSH_DEBUG_SV.log(l_module_name,'l_fc_count=>'||l_fc_count
2036: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2037: END IF;
2038: -- TO DO: handle locking issues
2039:

Line 2036: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2032: WSH_DEBUG_SV.log(l_module_name,'About to update wfc for delivery_leg_id =>'
2033: ||g_dlv_leg_tab(i).delivery_leg_id
2034: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2035: WSH_DEBUG_SV.log(l_module_name,'l_fc_count=>'||l_fc_count
2036: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2037: END IF;
2038: -- TO DO: handle locking issues
2039:
2040: IF (l_fc_count >0) THEN

Line 2057: WSH_DEBUG_SV.logmsg(l_module_name,'wfc records deleted : '||l_fc_count

2053:
2054: END IF;
2055:
2056: IF l_debug_on THEN
2057: WSH_DEBUG_SV.logmsg(l_module_name,'wfc records deleted : '||l_fc_count
2058: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2059: END IF;
2060: -- update SUMMARY freight cost record and set freight cost type id to -1
2061:

Line 2058: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2054: END IF;
2055:
2056: IF l_debug_on THEN
2057: WSH_DEBUG_SV.logmsg(l_module_name,'wfc records deleted : '||l_fc_count
2058: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2059: END IF;
2060: -- update SUMMARY freight cost record and set freight cost type id to -1
2061:
2062: l_freight_cost_id := null;

Line 2080: WSH_DEBUG_SV.logmsg(l_module_name,'wfc updated : freight_cost_id =>'||l_freight_cost_id

2076: last_updated_by = FND_GLOBAL.USER_ID
2077: WHERE freight_cost_id = l_freight_cost_id;
2078:
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'wfc updated : freight_cost_id =>'||l_freight_cost_id
2081: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2082: END IF;
2083: END IF;
2084:

Line 2081: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2077: WHERE freight_cost_id = l_freight_cost_id;
2078:
2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'wfc updated : freight_cost_id =>'||l_freight_cost_id
2081: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2082: END IF;
2083: END IF;
2084:
2085: END IF;

Line 2101: WSH_DEBUG_SV.pop(l_module_name);

2097: p_encoded => FND_API.G_FALSE
2098: );
2099: --
2100: IF l_debug_on THEN
2101: WSH_DEBUG_SV.pop(l_module_name);
2102: END IF;
2103: --
2104: --
2105: EXCEPTION

Line 2116: WSH_DEBUG_SV.pop(l_module_name);

2112: p_data => x_msg_data,
2113: p_encoded => FND_API.G_FALSE
2114: );
2115: IF l_debug_on THEN
2116: WSH_DEBUG_SV.pop(l_module_name);
2117: END IF;
2118: --
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: ROLLBACK TO CANCEL_SERVICE;

Line 2129: WSH_DEBUG_SV.pop(l_module_name);

2125: p_data => x_msg_data,
2126: p_encoded => FND_API.G_FALSE
2127: );
2128: IF l_debug_on THEN
2129: WSH_DEBUG_SV.pop(l_module_name);
2130: END IF;
2131: --
2132: WHEN OTHERS THEN
2133: ROLLBACK TO CANCEL_SERVICE;

Line 2143: WSH_DEBUG_SV.pop(l_module_name);

2139: p_data => x_msg_data,
2140: p_encoded => FND_API.G_FALSE
2141: );
2142: IF l_debug_on THEN
2143: WSH_DEBUG_SV.pop(l_module_name);
2144: END IF;
2145:
2146: END Cancel_Service;
2147:

Line 2173: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2169: l_msg_data VARCHAR2(32767);
2170: --
2171: l_number_of_errors NUMBER;
2172: l_number_of_warnings NUMBER;
2173: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2174: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CANCEL_SERVICE2';
2175:
2176:
2177: BEGIN

Line 2190: wsh_debug_sv.push(l_module_name);

2186: --
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;
2188: --
2189: IF l_debug_on THEN
2190: wsh_debug_sv.push(l_module_name);
2191: END IF;
2192:
2193: -- supported actions
2194: IF (p_action <> 'CANCEL') THEN

Line 2229: WSH_DEBUG_SV.logmsg(l_module_name,'>>>Now processing delivery_id = '||l_delivery_id

2225: FOR i in p_delivery_list.FIRST .. p_delivery_list.LAST
2226: LOOP
2227: l_delivery_id := p_delivery_list(i);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'>>>Now processing delivery_id = '||l_delivery_id
2230: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2231: END IF;
2232: Cancel_Service (
2233: p_api_version => 1.0,

Line 2230: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2226: LOOP
2227: l_delivery_id := p_delivery_list(i);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'>>>Now processing delivery_id = '||l_delivery_id
2230: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2231: END IF;
2232: Cancel_Service (
2233: p_api_version => 1.0,
2234: p_delivery_id => l_delivery_id,

Line 2272: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_list.COUNT = '||p_delivery_list.COUNT

2268: END LOOP;
2269: END IF;
2270:
2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_list.COUNT = '||p_delivery_list.COUNT
2273: ||'l_success_cnt = '||l_success_cnt
2274: ||'l_error_cnt = '||l_error_cnt
2275: ||'l_warn_cnt = '||l_warn_cnt
2276: ,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2276: ,WSH_DEBUG_SV.C_PROC_LEVEL);

2272: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_list.COUNT = '||p_delivery_list.COUNT
2273: ||'l_success_cnt = '||l_success_cnt
2274: ||'l_error_cnt = '||l_error_cnt
2275: ||'l_warn_cnt = '||l_warn_cnt
2276: ,WSH_DEBUG_SV.C_PROC_LEVEL);
2277: END IF;
2278:
2279: IF (l_success_cnt = p_delivery_list.COUNT) THEN
2280: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2299: WSH_DEBUG_SV.pop(l_module_name);

2295: p_encoded => FND_API.G_FALSE
2296: );
2297: --
2298: IF l_debug_on THEN
2299: WSH_DEBUG_SV.pop(l_module_name);
2300: END IF;
2301: --
2302: --
2303: EXCEPTION

Line 2314: WSH_DEBUG_SV.pop(l_module_name);

2310: p_data => x_msg_data,
2311: p_encoded => FND_API.G_FALSE
2312: );
2313: IF l_debug_on THEN
2314: WSH_DEBUG_SV.pop(l_module_name);
2315: END IF;
2316: --
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO CANCEL_SERVICE;

Line 2327: WSH_DEBUG_SV.pop(l_module_name);

2323: p_data => x_msg_data,
2324: p_encoded => FND_API.G_FALSE
2325: );
2326: IF l_debug_on THEN
2327: WSH_DEBUG_SV.pop(l_module_name);
2328: END IF;
2329: --
2330: WHEN OTHERS THEN
2331: ROLLBACK TO CANCEL_SERVICE;

Line 2341: WSH_DEBUG_SV.pop(l_module_name);

2337: p_data => x_msg_data,
2338: p_encoded => FND_API.G_FALSE
2339: );
2340: IF l_debug_on THEN
2341: WSH_DEBUG_SV.pop(l_module_name);
2342: END IF;
2343:
2344: END Cancel_Service;
2345:

Line 2550: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2546: PROCEDURE validate_nontl_trip (p_trip_id IN NUMBER,
2547: x_return_code OUT NOCOPY NUMBER)
2548: IS
2549: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
2550: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2551: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_NONTL_TRIP';
2552: l_return_status VARCHAR2(30);
2553: l_return_status_1 VARCHAR2(30);
2554: l_number_of_errors NUMBER;

Line 2577: wsh_debug_sv.push(l_module_name);

2573:
2574: x_return_code := G_RC_SUCCESS;
2575:
2576: IF l_debug_on THEN
2577: wsh_debug_sv.push(l_module_name);
2578: END IF;
2579:
2580: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2581: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 2738: WSH_DEBUG_SV.pop(l_module_name);

2734: END IF;
2735:
2736:
2737: IF l_debug_on THEN
2738: WSH_DEBUG_SV.pop(l_module_name);
2739: END IF;
2740:
2741: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2742:

Line 2746: WSH_DEBUG_SV.pop(l_module_name);

2742:
2743: EXCEPTION
2744: WHEN g_finished_warning THEN
2745: IF l_debug_on THEN
2746: WSH_DEBUG_SV.pop(l_module_name);
2747: END IF;
2748: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2749: --
2750: WHEN FND_API.G_EXC_ERROR THEN

Line 2753: WSH_DEBUG_SV.pop(l_module_name);

2749: --
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: x_return_code := G_RC_ERROR;
2752: IF l_debug_on THEN
2753: WSH_DEBUG_SV.pop(l_module_name);
2754: END IF;
2755: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2756: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2757: --

Line 2761: WSH_DEBUG_SV.pop(l_module_name);

2757: --
2758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2759: x_return_code := G_RC_ERROR;
2760: IF l_debug_on THEN
2761: WSH_DEBUG_SV.pop(l_module_name);
2762: END IF;
2763: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
2764: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2765: --

Line 2770: WSH_DEBUG_SV.pop(l_module_name);

2766: WHEN OTHERS THEN
2767: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
2768: x_return_code := G_RC_ERROR;
2769: IF l_debug_on THEN
2770: WSH_DEBUG_SV.pop(l_module_name);
2771: END IF;
2772: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2773: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2774: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2781: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2777: PROCEDURE validate_tl_trip (p_trip_id IN NUMBER,
2778: x_return_code OUT NOCOPY NUMBER)
2779: IS
2780: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
2781: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2782: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_TL_TRIP';
2783: l_return_status VARCHAR2(30);
2784: l_return_status_1 VARCHAR2(30);
2785: l_number_of_errors NUMBER;

Line 2808: wsh_debug_sv.push(l_module_name);

2804:
2805: x_return_code := G_RC_SUCCESS;
2806:
2807: IF l_debug_on THEN
2808: wsh_debug_sv.push(l_module_name);
2809: END IF;
2810:
2811: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2812: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 2851: WSH_DEBUG_SV.pop(l_module_name);

2847: raise g_finished_warning;
2848: END IF;
2849:
2850: IF l_debug_on THEN
2851: WSH_DEBUG_SV.pop(l_module_name);
2852: END IF;
2853:
2854: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2855:

Line 2859: WSH_DEBUG_SV.pop(l_module_name);

2855:
2856: EXCEPTION
2857: WHEN g_finished_warning THEN
2858: IF l_debug_on THEN
2859: WSH_DEBUG_SV.pop(l_module_name);
2860: END IF;
2861: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2862: --
2863: WHEN FND_API.G_EXC_ERROR THEN

Line 2866: WSH_DEBUG_SV.pop(l_module_name);

2862: --
2863: WHEN FND_API.G_EXC_ERROR THEN
2864: x_return_code := G_RC_ERROR;
2865: IF l_debug_on THEN
2866: WSH_DEBUG_SV.pop(l_module_name);
2867: END IF;
2868: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2869: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2870: --

Line 2874: WSH_DEBUG_SV.pop(l_module_name);

2870: --
2871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2872: x_return_code := G_RC_ERROR;
2873: IF l_debug_on THEN
2874: WSH_DEBUG_SV.pop(l_module_name);
2875: END IF;
2876: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
2877: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2878: --

Line 2883: WSH_DEBUG_SV.pop(l_module_name);

2879: WHEN OTHERS THEN
2880: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
2881: x_return_code := G_RC_ERROR;
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.pop(l_module_name);
2884: END IF;
2885: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2886: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2887: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2934: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2930: l_schedules_tab fte_schedule_tab;
2931:
2932: l_msg VARCHAR2(240);
2933: l_status VARCHAR2(1);
2934: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2935: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'SEARCH_SERVICES';
2936: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_SERVICES';
2937: BEGIN
2938:

Line 2942: wsh_debug_sv.push(l_module_name);

2938:
2939: x_return_status := FND_API.G_RET_STS_SUCCESS;
2940:
2941: IF l_debug_on THEN
2942: wsh_debug_sv.push(l_module_name);
2943: END IF;
2944:
2945: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2946: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 3215: WSH_DEBUG_SV.logmsg(l_module_name,'l_lanes_tab.COUNT =>'||l_lane_count

3211: l_lanes_tab(i) := l_lane_rec;
3212: */
3213: l_lane_count := l_lanes_tab.COUNT;
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.logmsg(l_module_name,'l_lanes_tab.COUNT =>'||l_lane_count
3216: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3217: END IF;
3218:
3219: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'found '||l_lane_count||' lanes');

Line 3216: ,WSH_DEBUG_SV.C_PROC_LEVEL);

3212: */
3213: l_lane_count := l_lanes_tab.COUNT;
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.logmsg(l_module_name,'l_lanes_tab.COUNT =>'||l_lane_count
3216: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3217: END IF;
3218:
3219: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'found '||l_lane_count||' lanes');
3220: IF (l_lane_count > 0) THEN

Line 3270: WSH_DEBUG_SV.pop(l_module_name);

3266: END LOOP;
3267: END IF;
3268:
3269: IF l_debug_on THEN
3270: WSH_DEBUG_SV.pop(l_module_name);
3271: END IF;
3272:
3273: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
3274: EXCEPTION

Line 3278: WSH_DEBUG_SV.pop(l_module_name);

3274: EXCEPTION
3275: WHEN FND_API.G_EXC_ERROR THEN
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277: IF l_debug_on THEN
3278: WSH_DEBUG_SV.pop(l_module_name);
3279: END IF;
3280: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
3281: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
3282: --

Line 3286: WSH_DEBUG_SV.pop(l_module_name);

3282: --
3283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3285: IF l_debug_on THEN
3286: WSH_DEBUG_SV.pop(l_module_name);
3287: END IF;
3288: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
3289: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
3290: --

Line 3295: WSH_DEBUG_SV.pop(l_module_name);

3291: WHEN OTHERS THEN
3292: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
3293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.pop(l_module_name);
3296: END IF;
3297: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3298: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3299: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 4173: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

4169: --
4170: l_number_of_errors NUMBER;
4171: l_number_of_warnings NUMBER;
4172: l_commit VARCHAR2(100) := FND_API.G_FALSE;
4173: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4174: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RATE_TRIP2';
4175:
4176: l_lane_rate NUMBER;
4177: l_lane_rate_uom VARCHAR2(10);

Line 4208: wsh_debug_sv.push(l_module_name);

4204: --
4205: x_return_status := FND_API.G_RET_STS_SUCCESS;
4206: --
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push(l_module_name);
4209: END IF;
4210: IF l_debug_on THEN
4211: WSH_DEBUG_SV.logmsg(
4212: l_module_name,

Line 4211: WSH_DEBUG_SV.logmsg(

4207: IF l_debug_on THEN
4208: wsh_debug_sv.push(l_module_name);
4209: END IF;
4210: IF l_debug_on THEN
4211: WSH_DEBUG_SV.logmsg(
4212: l_module_name,
4213: 'p_trip_id '|| p_trip_id,
4214: WSH_DEBUG_SV.C_PROC_LEVEL);
4215: END IF;

Line 4214: WSH_DEBUG_SV.C_PROC_LEVEL);

4210: IF l_debug_on THEN
4211: WSH_DEBUG_SV.logmsg(
4212: l_module_name,
4213: 'p_trip_id '|| p_trip_id,
4214: WSH_DEBUG_SV.C_PROC_LEVEL);
4215: END IF;
4216:
4217: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4218: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 4673: WSH_DEBUG_SV.pop(l_module_name);

4669:
4670:
4671: --
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.pop(l_module_name);
4674: END IF;
4675: --
4676: --
4677: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 4687: WSH_DEBUG_SV.pop(l_module_name);

4683:
4684: WHEN g_finished_warning THEN
4685:
4686: IF l_debug_on THEN
4687: WSH_DEBUG_SV.pop(l_module_name);
4688: END IF;
4689: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);
4690: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
4691: --

Line 4695: WSH_DEBUG_SV.pop(l_module_name);

4691: --
4692: WHEN g_finished_success THEN
4693:
4694: IF l_debug_on THEN
4695: WSH_DEBUG_SV.pop(l_module_name);
4696: END IF;
4697: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);
4698: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
4699: --

Line 4703: WSH_DEBUG_SV.pop(l_module_name);

4699: --
4700: WHEN FND_API.G_EXC_ERROR THEN
4701: x_return_status := FND_API.G_RET_STS_ERROR;
4702: IF l_debug_on THEN
4703: WSH_DEBUG_SV.pop(l_module_name);
4704: END IF;
4705: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
4706: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
4707: --

Line 4711: WSH_DEBUG_SV.pop(l_module_name);

4707: --
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4710: IF l_debug_on THEN
4711: WSH_DEBUG_SV.pop(l_module_name);
4712: END IF;
4713: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
4714: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
4715: --

Line 4720: WSH_DEBUG_SV.pop(l_module_name);

4716: WHEN OTHERS THEN
4717: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
4718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4719: IF l_debug_on THEN
4720: WSH_DEBUG_SV.pop(l_module_name);
4721: END IF;
4722: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4723: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4724: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 4782: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

4778: --
4779: l_number_of_errors NUMBER;
4780: l_number_of_warnings NUMBER;
4781: l_commit VARCHAR2(100) := FND_API.G_FALSE;
4782: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
4783: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RATE_DELIVERY';
4784:
4785: l_lane_rate NUMBER;
4786: l_lane_rate_uom VARCHAR2(10);

Line 4864: wsh_debug_sv.push(l_module_name);

4860:
4861: x_return_status := FND_API.G_RET_STS_SUCCESS;
4862: --
4863: IF l_debug_on THEN
4864: wsh_debug_sv.push(l_module_name);
4865: END IF;
4866: --
4867: IF l_debug_on THEN
4868: WSH_DEBUG_SV.logmsg(

Line 4868: WSH_DEBUG_SV.logmsg(

4864: wsh_debug_sv.push(l_module_name);
4865: END IF;
4866: --
4867: IF l_debug_on THEN
4868: WSH_DEBUG_SV.logmsg(
4869: l_module_name,
4870: 'p_delivery_id '|| p_delivery_id,
4871: WSH_DEBUG_SV.C_PROC_LEVEL);
4872: END IF;

Line 4871: WSH_DEBUG_SV.C_PROC_LEVEL);

4867: IF l_debug_on THEN
4868: WSH_DEBUG_SV.logmsg(
4869: l_module_name,
4870: 'p_delivery_id '|| p_delivery_id,
4871: WSH_DEBUG_SV.C_PROC_LEVEL);
4872: END IF;
4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.logmsg(
4875: l_module_name,

Line 4874: WSH_DEBUG_SV.logmsg(

4870: 'p_delivery_id '|| p_delivery_id,
4871: WSH_DEBUG_SV.C_PROC_LEVEL);
4872: END IF;
4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.logmsg(
4875: l_module_name,
4876: 'p_trip_id '|| p_trip_id,
4877: WSH_DEBUG_SV.C_PROC_LEVEL);
4878: END IF;

Line 4877: WSH_DEBUG_SV.C_PROC_LEVEL);

4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.logmsg(
4875: l_module_name,
4876: 'p_trip_id '|| p_trip_id,
4877: WSH_DEBUG_SV.C_PROC_LEVEL);
4878: END IF;
4879: IF l_debug_on THEN
4880: WSH_DEBUG_SV.logmsg(
4881: l_module_name,

Line 4880: WSH_DEBUG_SV.logmsg(

4876: 'p_trip_id '|| p_trip_id,
4877: WSH_DEBUG_SV.C_PROC_LEVEL);
4878: END IF;
4879: IF l_debug_on THEN
4880: WSH_DEBUG_SV.logmsg(
4881: l_module_name,
4882: 'p_action '|| p_action,
4883: WSH_DEBUG_SV.C_PROC_LEVEL);
4884: END IF;

Line 4883: WSH_DEBUG_SV.C_PROC_LEVEL);

4879: IF l_debug_on THEN
4880: WSH_DEBUG_SV.logmsg(
4881: l_module_name,
4882: 'p_action '|| p_action,
4883: WSH_DEBUG_SV.C_PROC_LEVEL);
4884: END IF;
4885: IF l_debug_on THEN
4886: WSH_DEBUG_SV.logmsg(
4887: l_module_name,

Line 4886: WSH_DEBUG_SV.logmsg(

4882: 'p_action '|| p_action,
4883: WSH_DEBUG_SV.C_PROC_LEVEL);
4884: END IF;
4885: IF l_debug_on THEN
4886: WSH_DEBUG_SV.logmsg(
4887: l_module_name,
4888: 'p_commit '|| p_commit,
4889: WSH_DEBUG_SV.C_PROC_LEVEL);
4890: END IF;

Line 4889: WSH_DEBUG_SV.C_PROC_LEVEL);

4885: IF l_debug_on THEN
4886: WSH_DEBUG_SV.logmsg(
4887: l_module_name,
4888: 'p_commit '|| p_commit,
4889: WSH_DEBUG_SV.C_PROC_LEVEL);
4890: END IF;
4891:
4892: IF p_init_prc_log = 'Y' THEN
4893: FTE_FREIGHT_PRICING_UTIL.initialize_logging( x_return_status => l_return_status );

Line 5758: WSH_DEBUG_SV.pop(l_module_name);

5754: p_encoded => FND_API.G_FALSE
5755: );
5756: --
5757: IF l_debug_on THEN
5758: WSH_DEBUG_SV.pop(l_module_name);
5759: END IF;
5760: --
5761: --
5762: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 5786: WSH_DEBUG_SV.pop(l_module_name);

5782: p_encoded => FND_API.G_FALSE
5783: );
5784: --
5785: IF l_debug_on THEN
5786: WSH_DEBUG_SV.pop(l_module_name);
5787: END IF;
5788: --
5789: --
5790: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 5813: WSH_DEBUG_SV.pop(l_module_name);

5809: p_encoded => FND_API.G_FALSE
5810: );
5811: --
5812: IF l_debug_on THEN
5813: WSH_DEBUG_SV.pop(l_module_name);
5814: END IF;
5815: --
5816: --
5817: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 5834: WSH_DEBUG_SV.pop(l_module_name);

5830: p_data => x_msg_data,
5831: p_encoded => FND_API.G_FALSE
5832: );
5833: IF l_debug_on THEN
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
5837: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
5838: IF p_init_prc_log = 'Y' THEN

Line 5852: WSH_DEBUG_SV.pop(l_module_name);

5848: p_data => x_msg_data,
5849: p_encoded => FND_API.G_FALSE
5850: );
5851: IF l_debug_on THEN
5852: WSH_DEBUG_SV.pop(l_module_name);
5853: END IF;
5854: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
5855: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
5856: IF p_init_prc_log = 'Y' THEN

Line 5871: WSH_DEBUG_SV.pop(l_module_name);

5867: p_data => x_msg_data,
5868: p_encoded => FND_API.G_FALSE
5869: );
5870: IF l_debug_on THEN
5871: WSH_DEBUG_SV.pop(l_module_name);
5872: END IF;
5873: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5874: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5875: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 5897: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

5893: l_api_name CONSTANT VARCHAR2(30) := 'RATE_DELIVERY';
5894: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
5895: l_return_status VARCHAR2(1);
5896: l_return_status_1 VARCHAR2(1);
5897: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5898: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RATE_DELIVERY';
5899: --
5900: i NUMBER;
5901: l_msg_count NUMBER;

Line 5966: wsh_debug_sv.push(l_module_name);

5962: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Initialize Logging successful ');
5963: END IF;
5964:
5965: IF l_debug_on THEN
5966: wsh_debug_sv.push(l_module_name);
5967: END IF;
5968:
5969: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5970: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 6059: WSH_DEBUG_SV.pop(l_module_name);

6055: );
6056: --
6057: --
6058: IF l_debug_on THEN
6059: WSH_DEBUG_SV.pop(l_module_name);
6060: END IF;
6061: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);
6062:
6063: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 6088: WSH_DEBUG_SV.pop(l_module_name);

6084: p_data => x_msg_data,
6085: p_encoded => FND_API.G_FALSE
6086: );
6087: IF l_debug_on THEN
6088: WSH_DEBUG_SV.pop(l_module_name);
6089: END IF;
6090: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
6091: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
6092: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 6115: WSH_DEBUG_SV.pop(l_module_name);

6111: p_data => x_msg_data,
6112: p_encoded => FND_API.G_FALSE
6113: );
6114: IF l_debug_on THEN
6115: WSH_DEBUG_SV.pop(l_module_name);
6116: END IF;
6117: FTE_FREIGHT_PRICING_UTIL.set_exception(l_module_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_UNEXPECTED_ERROR');
6118: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
6119: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 6143: WSH_DEBUG_SV.pop(l_module_name);

6139: p_data => x_msg_data,
6140: p_encoded => FND_API.G_FALSE
6141: );
6142: IF l_debug_on THEN
6143: WSH_DEBUG_SV.pop(l_module_name);
6144: END IF;
6145: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
6146: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
6147: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);