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_TRIP_RATING_GRP dependencies on FND_API

Line 494: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

490:
491:
492: PROCEDURE Compare_Trip_Rates (
493: p_api_version IN NUMBER DEFAULT 1.0,
494: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
495: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
496: p_trip_id IN NUMBER DEFAULT NULL,
497: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
498: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)

Line 505: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

501: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
502: p_dep_date IN DATE DEFAULT sysdate,
503: p_arr_date IN DATE DEFAULT sysdate,
504: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
505: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
506: x_request_id OUT NOCOPY NUMBER,
507: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
508: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
509: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id

Line 567: IF FND_API.to_Boolean( p_init_msg_list )

563: BEGIN
564: SAVEPOINT COMPARE_TRIP_RATES;
565: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
566:
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:

Line 968: p_encoded => FND_API.G_FALSE

964: FND_MSG_PUB.Count_And_Get
965: (
966: p_count => x_msg_count,
967: p_data => x_msg_data,
968: p_encoded => FND_API.G_FALSE
969: );
970:
971: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>9.2');
972: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Compare_Trip_Rates');

Line 987: IF FND_API.to_Boolean( p_commit )

983:
984: COMMIT; -- Commit Autonomous transaction
985:
986: /*
987: IF FND_API.to_Boolean( p_commit )
988: THEN
989: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>9.5');
990: COMMIT; -- Commit Autonomous transaction
991: ELSE

Line 1030: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1026:
1027:
1028: PROCEDURE Compare_Trip_Rates (
1029: p_api_version IN NUMBER DEFAULT 1.0,
1030: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1031: p_trip_id IN NUMBER DEFAULT NULL,
1032: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE,
1033: p_lane_sched_tab IN FTE_CODE_TAB_TYPE,
1034: p_mode_tab IN FTE_CODE_TAB_TYPE,

Line 1040: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1036: p_vehicle_id_tab IN FTE_ID_TAB_TYPE,
1037: p_dep_date IN DATE DEFAULT sysdate,
1038: p_arr_date IN DATE DEFAULT sysdate,
1039: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
1040: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1041: x_request_id OUT NOCOPY NUMBER,
1042: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
1043: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
1044: x_return_status OUT NOCOPY VARCHAR2,

Line 1085: l_commit VARCHAR2(100) := FND_API.G_FALSE;

1081: l_msg_data VARCHAR2(32767);
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:

Line 1147: RAISE FND_API.G_EXC_ERROR;

1143:
1144: -- error checking
1145: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1146: THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1149: THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1146: THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1149: THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1152: THEN
1153: x_return_status := l_return_status;
1154: END IF;

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165:
1166: -- error checking
1167: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1174: THEN
1175: x_return_status := l_return_status;
1176: END IF;

Line 1208: RAISE FND_API.G_EXC_ERROR;

1204:
1205: -- error checking
1206: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1207: THEN
1208: RAISE FND_API.G_EXC_ERROR;
1209: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1210: THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1207: THEN
1208: RAISE FND_API.G_EXC_ERROR;
1209: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1210: THEN
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1213: THEN
1214: x_return_status := l_return_status;
1215: END IF;

Line 1230: RAISE FND_API.G_EXC_ERROR;

1226:
1227: -- error checking
1228: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1229: THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1232: THEN
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1229: THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1232: THEN
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1235: THEN
1236: x_return_status := l_return_status;
1237: END IF;

Line 1249: p_init_msg_list => FND_API.G_FALSE,

1245:
1246: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'calling Rate_Delivery ');
1247: FTE_FREIGHT_RATING_DLVY_GRP.Rate_Delivery (
1248: p_api_version => 1,
1249: p_init_msg_list => FND_API.G_FALSE,
1250: p_delivery_id => null,
1251: p_trip_id => p_trip_info_rec.trip_id,
1252: p_action => 'RATE',
1253: p_commit => FND_API.G_FALSE,

Line 1253: p_commit => FND_API.G_FALSE,

1249: p_init_msg_list => FND_API.G_FALSE,
1250: p_delivery_id => null,
1251: p_trip_id => p_trip_info_rec.trip_id,
1252: p_action => 'RATE',
1253: p_commit => FND_API.G_FALSE,
1254: p_init_prc_log => 'N',
1255: x_return_status => l_return_status,
1256: x_msg_count => x_msg_count,
1257: x_msg_data => x_msg_data );

Line 1262: RAISE FND_API.G_EXC_ERROR;

1258:
1259: -- error checking
1260: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1261: THEN
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1264: THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: THEN
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1264: THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1267: THEN
1268: x_return_status := l_return_status;
1269: END IF;

Line 1292: RAISE FND_API.G_EXC_ERROR;

1288:
1289: -- error checking
1290: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1297: THEN
1298: x_return_status := l_return_status;
1299: END IF;

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310:
1311: -- error checking
1312: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
1313: THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1316: THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1313: THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1316: THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
1319: THEN
1320: x_return_status := l_return_status;
1321: END IF;

Line 1334: WHEN FND_API.G_EXC_ERROR THEN

1330: --
1331: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1332: --
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;

Line 1341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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
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;

Line 1373: -- p_commit => FND_API.G_FALSE / G_TRUE

1369: -- -> caller -> 'FTE','WSH'
1370: -- -> event -> 'TP-RELEASE','SHIP-CONFIRM','RE-RATING'
1371: -- -> action -> 'RATE'
1372: -- -> trip_id_list -> valid list of wsh trip_id
1373: -- p_commit => FND_API.G_FALSE / G_TRUE
1374: -- Output:
1375: -- x_return_status OUT NOCOPY VARCHAR2 => Return status
1376: --
1377: -- Global dependencies:

Line 1387: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1383:
1384:
1385: PROCEDURE Rate_Trip (
1386: p_api_version IN NUMBER DEFAULT 1.0,
1387: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1388: p_action_params IN FTE_TRIP_RATING_GRP.action_param_rec,
1389: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1390: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
1391: x_return_status OUT NOCOPY VARCHAR2,

Line 1389: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1385: PROCEDURE Rate_Trip (
1386: p_api_version IN NUMBER DEFAULT 1.0,
1387: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1388: p_action_params IN FTE_TRIP_RATING_GRP.action_param_rec,
1389: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1390: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
1391: x_return_status OUT NOCOPY VARCHAR2,
1392: x_msg_count OUT NOCOPY NUMBER,
1393: x_msg_data OUT NOCOPY VARCHAR2)

Line 1420: l_commit VARCHAR2(100) := FND_API.G_FALSE;

1416: l_msg_data VARCHAR2(32767);
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;

Line 1430: IF NOT FND_API.Compatible_API_Call

1426:
1427: SAVEPOINT RATE_TRIP;
1428: --
1429: -- Standard call to check for call compatibility.
1430: IF NOT FND_API.Compatible_API_Call
1431: (
1432: l_api_version,
1433: p_api_version,
1434: l_api_name,

Line 1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1434: l_api_name,
1435: G_PKG_NAME
1436: )
1437: THEN
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: END IF;
1440:
1441: -- Initialize message list if p_init_msg_list is set to TRUE.
1442: IF FND_API.to_Boolean( p_init_msg_list )

Line 1442: IF FND_API.to_Boolean( p_init_msg_list )

1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: END IF;
1440:
1441: -- Initialize message list if p_init_msg_list is set to TRUE.
1442: IF FND_API.to_Boolean( p_init_msg_list )
1443: THEN
1444: FND_MSG_PUB.initialize;
1445: END IF;
1446:

Line 1502: RAISE FND_API.G_EXC_ERROR;

1498: );
1499: --
1500: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1501: THEN
1502: RAISE FND_API.G_EXC_ERROR;
1503: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1504: THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1501: THEN
1502: RAISE FND_API.G_EXC_ERROR;
1503: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1504: THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1507: THEN
1508: x_return_status := l_return_status_1;
1509: END IF;

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: --
1541:
1542: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1543: THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1546: THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1543: THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1546: THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1549: THEN
1550: x_return_status := l_return_status_1;
1551: END IF;

Line 1600: RAISE FND_API.G_EXC_ERROR;

1596: );
1597: --
1598: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1599: THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1602: THEN
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1599: THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1602: THEN
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1605: THEN
1606: x_return_status := l_return_status_1;
1607: RAISE g_finished_success;

Line 1638: RAISE FND_API.G_EXC_ERROR;

1634: );
1635: --
1636: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1637: THEN
1638: RAISE FND_API.G_EXC_ERROR;
1639: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1640: THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: THEN
1638: RAISE FND_API.G_EXC_ERROR;
1639: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1640: THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1643: THEN
1644: x_return_status := l_return_status_1;
1645: END IF;

Line 1694: RAISE FND_API.G_EXC_ERROR;

1690: );
1691: --
1692: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1693: THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1696: THEN
1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1693: THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1696: THEN
1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1698: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1699: THEN
1700: x_return_status := l_return_status_1;
1701: END IF;

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: );
1725: --
1726: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1727: THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1730: THEN
1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1727: THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1730: THEN
1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1733: THEN
1734: x_return_status := l_return_status_1;
1735: END IF;

Line 1780: RAISE FND_API.G_EXC_ERROR;

1776: );
1777: --
1778: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1779: THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1782: THEN
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1779: THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1782: THEN
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1785: THEN
1786: x_return_status := l_return_status_1;
1787: l_warn_count := l_warn_count + 1;

Line 1847: RAISE FND_API.G_EXC_ERROR;

1843: );
1844: --
1845: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1846: THEN
1847: RAISE FND_API.G_EXC_ERROR;
1848: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1846: THEN
1847: RAISE FND_API.G_EXC_ERROR;
1848: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1852: THEN
1853: x_return_status := l_return_status_1;
1854: END IF;

Line 1902: RAISE FND_API.G_EXC_ERROR;

1898: );
1899: --
1900: IF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_ERROR)
1901: THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1904: THEN
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1901: THEN
1902: RAISE FND_API.G_EXC_ERROR;
1903: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1904: THEN
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: ELSIF (l_return_status_1 = WSH_UTIL_CORE.G_RET_STS_WARNING )
1907: THEN
1908: x_return_status := l_return_status_1;
1909: END IF;

Line 1931: IF FND_API.To_Boolean( p_commit ) THEN

1927: i := p_action_params.trip_id_list.NEXT(i);
1928: END LOOP;
1929:
1930: --
1931: IF FND_API.To_Boolean( p_commit ) THEN
1932: COMMIT WORK;
1933: END IF;
1934:
1935: FND_MSG_PUB.Count_And_Get

Line 1939: p_encoded => FND_API.G_FALSE

1935: FND_MSG_PUB.Count_And_Get
1936: (
1937: p_count => x_msg_count,
1938: p_data => x_msg_data,
1939: p_encoded => FND_API.G_FALSE
1940: );
1941: --
1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.pop(l_module_name);

Line 1963: IF FND_API.To_Boolean( p_commit ) THEN

1959:
1960: EXCEPTION
1961: WHEN g_finished_success THEN
1962:
1963: IF FND_API.To_Boolean( p_commit ) THEN
1964: COMMIT WORK;
1965: END IF;
1966:
1967: FND_MSG_PUB.Count_And_Get

Line 1971: p_encoded => FND_API.G_FALSE

1967: FND_MSG_PUB.Count_And_Get
1968: (
1969: p_count => x_msg_count,
1970: p_data => x_msg_data,
1971: p_encoded => FND_API.G_FALSE
1972: );
1973: --
1974: IF l_debug_on THEN
1975: WSH_DEBUG_SV.pop(l_module_name);

Line 1986: WHEN FND_API.G_EXC_ERROR THEN

1982: IF p_init_prc_log = 'Y' THEN
1983: FTE_FREIGHT_PRICING_UTIL.close_logs;
1984: END IF;
1985: --
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: ROLLBACK TO RATE_TRIP;
1988: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1989: FND_MSG_PUB.Count_And_Get
1990: (

Line 1993: p_encoded => FND_API.G_FALSE

1989: FND_MSG_PUB.Count_And_Get
1990: (
1991: p_count => x_msg_count,
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;

Line 1998: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_module_name,'FND_API.G_EXC_ERROR');

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
2001: FTE_FREIGHT_PRICING_UTIL.close_logs;
2002: END IF;

Line 2004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2000: IF p_init_prc_log = 'Y' THEN
2001: FTE_FREIGHT_PRICING_UTIL.close_logs;
2002: END IF;
2003: --
2004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2005: ROLLBACK TO RATE_TRIP;
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2007: FND_MSG_PUB.Count_And_Get
2008: (

Line 2011: p_encoded => FND_API.G_FALSE

2007: FND_MSG_PUB.Count_And_Get
2008: (
2009: p_count => x_msg_count,
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;

Line 2016: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR');

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
2019: FTE_FREIGHT_PRICING_UTIL.close_logs;
2020: END IF;

Line 2030: p_encoded => FND_API.G_FALSE

2026: FND_MSG_PUB.Count_And_Get
2027: (
2028: p_count => x_msg_count,
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;

Line 2080: raise FND_API.G_EXC_ERROR;

2076: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_api_name,'start');
2077:
2078: IF p_trip_id is null AND p_trip_name is null THEN
2079: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'both trip id and trip name are null');
2080: raise FND_API.G_EXC_ERROR;
2081: END IF;
2082:
2083: l_trip_id := null;
2084: IF p_trip_id is not null THEN

Line 2092: raise FND_API.G_EXC_ERROR;

2088: FETCH c_get_trip_id INTO l_trip_id;
2089: CLOSE c_get_trip_id;
2090: IF l_trip_id is null THEN
2091: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'cannot get trip id from trip name');
2092: raise FND_API.G_EXC_ERROR;
2093: END IF;
2094: END IF;
2095:
2096: l_params.caller := 'FTE';

Line 2103: p_commit => FND_API.G_TRUE,

2099: l_params.trip_id_list(1) := l_trip_id;
2100:
2101: Rate_Trip (
2102: p_action_params => l_params,
2103: p_commit => FND_API.G_TRUE,
2104: p_init_prc_log => 'N',
2105: x_msg_count => l_msg_count,
2106: x_msg_data => l_msg_data,
2107: x_return_status => l_return_status );

Line 2127: WHEN FND_API.G_EXC_ERROR THEN

2123: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_status,'');
2124: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2125: FTE_FREIGHT_PRICING_UTIL.close_logs;
2126: EXCEPTION
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
2129: errbuf := 'Trip Rerating is completed with error';
2130: retcode := '2';
2131: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 2199: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;

2195:
2196: l_mode VARCHAR2(30);
2197: l_return_status VARCHAR2(1);
2198: l_rowid VARCHAR2(30);
2199: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
2200: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
2201:
2202: l_warning_count NUMBER:=0;
2203: BEGIN

Line 2269: p_init_msg_list => fnd_api.g_false,

2265:
2266: ELSE
2267:
2268: FTE_FREIGHT_PRICING.Move_fc_temp_to_main (
2269: p_init_msg_list => fnd_api.g_false,
2270: p_init_prc_log => 'N',
2271: p_request_id => p_comparison_request_id,
2272: p_trip_id => p_trip_id,
2273: p_lane_id => p_lane_id,

Line 2346: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;

2342: x_return_status OUT NOCOPY VARCHAR2) IS
2343:
2344: l_return_status VARCHAR2(1);
2345:
2346: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
2347: l_mode VARCHAR2(30);
2348: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
2349:
2350: l_warning_count NUMBER:=0;

Line 3646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3642:
3643:
3644: PROCEDURE Search_Rate_Sort(
3645: p_api_version IN NUMBER DEFAULT 1.0,
3646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3647: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
3648: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3649: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
3650: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

Line 3648: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3644: PROCEDURE Search_Rate_Sort(
3645: p_api_version IN NUMBER DEFAULT 1.0,
3646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3647: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
3648: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3649: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
3650: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3651: p_ss_rate_sort_atr_rec IN FTE_SS_ATTR_REC,
3652: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

Line 3708: IF NOT FND_API.Compatible_API_Call

3704: BEGIN
3705:
3706:
3707: -- Standard call to check for call compatibility.
3708: IF NOT FND_API.Compatible_API_Call
3709: (
3710: l_api_version,
3711: p_api_version,
3712: l_api_name,

Line 3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3712: l_api_name,
3713: G_PKG_NAME
3714: )
3715: THEN
3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;
3718:
3719: -- Initialize message list if p_init_msg_list is set to TRUE.
3720: IF FND_API.to_Boolean( p_init_msg_list )

Line 3720: IF FND_API.to_Boolean( p_init_msg_list )

3716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3717: END IF;
3718:
3719: -- Initialize message list if p_init_msg_list is set to TRUE.
3720: IF FND_API.to_Boolean( p_init_msg_list )
3721: THEN
3722: FND_MSG_PUB.initialize;
3723: END IF;
3724:

Line 3923: p_init_msg_list =>FND_API.G_FALSE,

3919: --Trip Centric
3920:
3921: FTE_TRIP_RATING_GRP.Compare_Trip_Rates (
3922: p_api_version =>1.0,
3923: p_init_msg_list =>FND_API.G_FALSE,
3924: p_init_prc_log =>'N',
3925: p_trip_id =>p_ss_rate_sort_atr_rec.trip_id,
3926: p_lane_sched_id_tab =>l_lane_sched_id_tab,
3927: p_lane_sched_tab =>l_lane_sched_tab,

Line 3978: p_init_msg_list =>fnd_api.g_false,

3974: --Delivery/Leg Centric
3975:
3976:
3977: FTE_FREIGHT_PRICING.shipment_price_compare (
3978: p_init_msg_list =>fnd_api.g_false,
3979: p_init_prc_log =>'N',
3980: p_delivery_id =>p_ss_rate_sort_atr_rec.delivery_id,
3981: p_trip_id =>p_ss_rate_sort_atr_rec.trip_id,
3982: p_lane_sched_id_tab =>l_lane_sched_id_tab,