DBA Data[Home] [Help]

APPS.FTE_TRIP_RATING_GRP dependencies on WSH_DEBUG_SV

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

1082:
1083: l_number_of_errors NUMBER;
1084: l_number_of_warnings NUMBER;
1085: l_commit VARCHAR2(100) := FND_API.G_FALSE;
1086: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1087: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RATE_TRIP_INT';
1088: BEGIN
1089:
1090: SAVEPOINT RATE_TRIP_INT;

Line 1095: wsh_debug_sv.push(l_module_name);

1091:
1092: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1093: --
1094: IF l_debug_on THEN
1095: wsh_debug_sv.push(l_module_name);
1096: END IF;
1097: --
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(

Line 1099: WSH_DEBUG_SV.logmsg(

1095: wsh_debug_sv.push(l_module_name);
1096: END IF;
1097: --
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(
1100: l_module_name,
1101: 'p_trip_id'|| p_trip_info_rec.trip_id,
1102: WSH_DEBUG_SV.C_PROC_LEVEL);
1103: END IF;

Line 1102: WSH_DEBUG_SV.C_PROC_LEVEL);

1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(
1100: l_module_name,
1101: 'p_trip_id'|| p_trip_info_rec.trip_id,
1102: WSH_DEBUG_SV.C_PROC_LEVEL);
1103: END IF;
1104: IF l_debug_on THEN
1105: WSH_DEBUG_SV.logmsg(
1106: l_module_name,

Line 1105: WSH_DEBUG_SV.logmsg(

1101: 'p_trip_id'|| p_trip_info_rec.trip_id,
1102: WSH_DEBUG_SV.C_PROC_LEVEL);
1103: END IF;
1104: IF l_debug_on THEN
1105: WSH_DEBUG_SV.logmsg(
1106: l_module_name,
1107: 'p_event'|| p_event,
1108: WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;

Line 1108: WSH_DEBUG_SV.C_PROC_LEVEL);

1104: IF l_debug_on THEN
1105: WSH_DEBUG_SV.logmsg(
1106: l_module_name,
1107: 'p_event'|| p_event,
1108: WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(
1112: l_module_name,

Line 1111: WSH_DEBUG_SV.logmsg(

1107: 'p_event'|| p_event,
1108: WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(
1112: l_module_name,
1113: 'p_rate_mode'|| p_rate_mode,
1114: WSH_DEBUG_SV.C_PROC_LEVEL);
1115: END IF;

Line 1114: WSH_DEBUG_SV.C_PROC_LEVEL);

1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(
1112: l_module_name,
1113: 'p_rate_mode'|| p_rate_mode,
1114: WSH_DEBUG_SV.C_PROC_LEVEL);
1115: END IF;
1116:
1117: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1118: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');

Line 1328: WSH_DEBUG_SV.pop(l_module_name);

1324:
1325: END IF;
1326:
1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.pop(l_module_name);
1329: END IF;
1330: --
1331: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1332: --

Line 1337: WSH_DEBUG_SV.pop(l_module_name);

1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1336: IF l_debug_on THEN
1337: WSH_DEBUG_SV.pop(l_module_name);
1338: END IF;
1339: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1340: --
1341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1344: WSH_DEBUG_SV.pop(l_module_name);

1340: --
1341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1342: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.pop(l_module_name);
1345: END IF;
1346: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1347: --
1348: WHEN OTHERS THEN

Line 1352: WSH_DEBUG_SV.pop(l_module_name);

1348: WHEN OTHERS THEN
1349: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.Rate_Trip_Int');
1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1351: IF l_debug_on THEN
1352: WSH_DEBUG_SV.pop(l_module_name);
1353: END IF;
1354: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1355: --
1356: END Rate_Trip_Int;

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

1417:
1418: l_number_of_errors NUMBER;
1419: l_number_of_warnings NUMBER;
1420: l_commit VARCHAR2(100) := FND_API.G_FALSE;
1421: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1422: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'RATE_TRIP';
1423:
1424: l_warn_count NUMBER :=0;
1425: BEGIN

Line 1450: wsh_debug_sv.push(l_module_name);

1446:
1447: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1448: --
1449: IF l_debug_on THEN
1450: wsh_debug_sv.push(l_module_name);
1451: END IF;
1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.logmsg(

Line 1454: WSH_DEBUG_SV.logmsg(

1450: wsh_debug_sv.push(l_module_name);
1451: END IF;
1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.logmsg(
1455: l_module_name,
1456: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
1457: WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;

Line 1457: WSH_DEBUG_SV.C_PROC_LEVEL);

1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.logmsg(
1455: l_module_name,
1456: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
1457: WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: IF l_debug_on THEN
1460: WSH_DEBUG_SV.logmsg(
1461: l_module_name,

Line 1460: WSH_DEBUG_SV.logmsg(

1456: 'p_action_params.trip_id_list.COUNT '|| p_action_params.trip_id_list.COUNT,
1457: WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: IF l_debug_on THEN
1460: WSH_DEBUG_SV.logmsg(
1461: l_module_name,
1462: 'p_action_params.caller '|| p_action_params.caller,
1463: WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;

Line 1463: WSH_DEBUG_SV.C_PROC_LEVEL);

1459: IF l_debug_on THEN
1460: WSH_DEBUG_SV.logmsg(
1461: l_module_name,
1462: 'p_action_params.caller '|| p_action_params.caller,
1463: WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(
1467: l_module_name,

Line 1466: WSH_DEBUG_SV.logmsg(

1462: 'p_action_params.caller '|| p_action_params.caller,
1463: WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(
1467: l_module_name,
1468: 'p_action_params.event '|| p_action_params.event,
1469: WSH_DEBUG_SV.C_PROC_LEVEL);
1470: END IF;

Line 1469: WSH_DEBUG_SV.C_PROC_LEVEL);

1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(
1467: l_module_name,
1468: 'p_action_params.event '|| p_action_params.event,
1469: WSH_DEBUG_SV.C_PROC_LEVEL);
1470: END IF;
1471: IF l_debug_on THEN
1472: WSH_DEBUG_SV.logmsg(
1473: l_module_name,

Line 1472: WSH_DEBUG_SV.logmsg(

1468: 'p_action_params.event '|| p_action_params.event,
1469: WSH_DEBUG_SV.C_PROC_LEVEL);
1470: END IF;
1471: IF l_debug_on THEN
1472: WSH_DEBUG_SV.logmsg(
1473: l_module_name,
1474: 'p_action_params.action '|| p_action_params.action,
1475: WSH_DEBUG_SV.C_PROC_LEVEL);
1476: END IF;

Line 1475: WSH_DEBUG_SV.C_PROC_LEVEL);

1471: IF l_debug_on THEN
1472: WSH_DEBUG_SV.logmsg(
1473: l_module_name,
1474: 'p_action_params.action '|| p_action_params.action,
1475: WSH_DEBUG_SV.C_PROC_LEVEL);
1476: END IF;
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(
1479: l_module_name,

Line 1478: WSH_DEBUG_SV.logmsg(

1474: 'p_action_params.action '|| p_action_params.action,
1475: WSH_DEBUG_SV.C_PROC_LEVEL);
1476: END IF;
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(
1479: l_module_name,
1480: 'p_commit '|| p_commit,
1481: WSH_DEBUG_SV.C_PROC_LEVEL);
1482: END IF;

Line 1481: WSH_DEBUG_SV.C_PROC_LEVEL);

1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(
1479: l_module_name,
1480: 'p_commit '|| p_commit,
1481: WSH_DEBUG_SV.C_PROC_LEVEL);
1482: END IF;
1483:
1484: IF p_init_prc_log = 'Y' THEN
1485: FTE_FREIGHT_PRICING_UTIL.initialize_logging( x_return_status => l_return_status );

Line 1570: WSH_DEBUG_SV.logmsg(

1566: l_tp_rel_rate_event := 'NONE';
1567: END IF;
1568:
1569: IF l_debug_on THEN
1570: WSH_DEBUG_SV.logmsg(
1571: l_module_name, 'l_tp_rel_rate_event = '||l_tp_rel_rate_event,
1572: WSH_DEBUG_SV.C_PROC_LEVEL);
1573: END IF;
1574: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_tp_rel_rate_event = '||l_tp_rel_rate_event);

Line 1572: WSH_DEBUG_SV.C_PROC_LEVEL);

1568:
1569: IF l_debug_on THEN
1570: WSH_DEBUG_SV.logmsg(
1571: l_module_name, 'l_tp_rel_rate_event = '||l_tp_rel_rate_event,
1572: WSH_DEBUG_SV.C_PROC_LEVEL);
1573: END IF;
1574: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_tp_rel_rate_event = '||l_tp_rel_rate_event);
1575:
1576: -- if calling event is TP-RELEASE, rating needs to be done only if

Line 1656: WSH_DEBUG_SV.logmsg( l_module_name, 'move_id = '||l_trip_info_rec.move_id,

1652:
1653: IF (l_trip_info_rec.move_id IS NOT NULL) THEN
1654: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move_id='||l_trip_info_rec.move_id);
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg( l_module_name, 'move_id = '||l_trip_info_rec.move_id,
1657: WSH_DEBUG_SV.C_PROC_LEVEL);
1658: END IF;
1659: IF l_rated_move_ids.EXISTS(l_trip_info_rec.move_id) THEN
1660: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move already rated - next pass');

Line 1657: WSH_DEBUG_SV.C_PROC_LEVEL);

1653: IF (l_trip_info_rec.move_id IS NOT NULL) THEN
1654: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move_id='||l_trip_info_rec.move_id);
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg( l_module_name, 'move_id = '||l_trip_info_rec.move_id,
1657: WSH_DEBUG_SV.C_PROC_LEVEL);
1658: END IF;
1659: IF l_rated_move_ids.EXISTS(l_trip_info_rec.move_id) THEN
1660: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move already rated - next pass');
1661: IF l_debug_on THEN

Line 1662: WSH_DEBUG_SV.logmsg( l_module_name, 'move already rated - next pass',

1658: END IF;
1659: IF l_rated_move_ids.EXISTS(l_trip_info_rec.move_id) THEN
1660: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move already rated - next pass');
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.logmsg( l_module_name, 'move already rated - next pass',
1663: WSH_DEBUG_SV.C_PROC_LEVEL);
1664: END IF;
1665: GOTO nextpass;
1666: END IF;

Line 1663: WSH_DEBUG_SV.C_PROC_LEVEL);

1659: IF l_rated_move_ids.EXISTS(l_trip_info_rec.move_id) THEN
1660: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move already rated - next pass');
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.logmsg( l_module_name, 'move already rated - next pass',
1663: WSH_DEBUG_SV.C_PROC_LEVEL);
1664: END IF;
1665: GOTO nextpass;
1666: END IF;
1667: END IF;

Line 1861: WSH_DEBUG_SV.logmsg( l_module_name,'tripId:'||l_trip_info_rec.trip_id||' mode: '||l_rate_mode

1857: END IF;
1858:
1859:
1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg( l_module_name,'tripId:'||l_trip_info_rec.trip_id||' mode: '||l_rate_mode
1862: ||' plan:'||l_trip_info_rec.tp_plan_name||' laneId:'||l_trip_info_rec.lane_id
1863: ||' modeTrans:'||l_trip_info_rec.mode_of_transport,
1864: WSH_DEBUG_SV.C_PROC_LEVEL);
1865: END IF;

Line 1864: WSH_DEBUG_SV.C_PROC_LEVEL);

1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg( l_module_name,'tripId:'||l_trip_info_rec.trip_id||' mode: '||l_rate_mode
1862: ||' plan:'||l_trip_info_rec.tp_plan_name||' laneId:'||l_trip_info_rec.lane_id
1863: ||' modeTrans:'||l_trip_info_rec.mode_of_transport,
1864: WSH_DEBUG_SV.C_PROC_LEVEL);
1865: END IF;
1866: -- call rate trip API
1867: IF (l_rate_mode IS NOT NULL AND l_rate_mode <> 'NONE') THEN
1868:

Line 1943: WSH_DEBUG_SV.pop(l_module_name);

1939: p_encoded => FND_API.G_FALSE
1940: );
1941: --
1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.pop(l_module_name);
1944: END IF;
1945: --
1946: --
1947: IF (l_warn_count > 0)

Line 1975: WSH_DEBUG_SV.pop(l_module_name);

1971: p_encoded => FND_API.G_FALSE
1972: );
1973: --
1974: IF l_debug_on THEN
1975: WSH_DEBUG_SV.pop(l_module_name);
1976: END IF;
1977: --
1978: --
1979: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_return_status='||x_return_status);

Line 1996: WSH_DEBUG_SV.pop(l_module_name);

1992: p_data => x_msg_data,
1993: p_encoded => FND_API.G_FALSE
1994: );
1995: IF l_debug_on THEN
1996: WSH_DEBUG_SV.pop(l_module_name);
1997: END IF;
1998: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_module_name,'FND_API.G_EXC_ERROR');
1999: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2000: IF p_init_prc_log = 'Y' THEN

Line 2014: WSH_DEBUG_SV.pop(l_module_name);

2010: p_data => x_msg_data,
2011: p_encoded => FND_API.G_FALSE
2012: );
2013: IF l_debug_on THEN
2014: WSH_DEBUG_SV.pop(l_module_name);
2015: END IF;
2016: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR');
2017: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2018: IF p_init_prc_log = 'Y' THEN

Line 2033: WSH_DEBUG_SV.pop(l_module_name);

2029: p_data => x_msg_data,
2030: p_encoded => FND_API.G_FALSE
2031: );
2032: IF l_debug_on THEN
2033: WSH_DEBUG_SV.pop(l_module_name);
2034: END IF;
2035: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_module_name,'OTHERS');
2036: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2037: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);