DBA Data[Home] [Help]

APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on FND_MSG_PUB

Line 1379: FND_MSG_PUB.Count_And_Get

1375: x_return_status := l_return_status_1;
1376: END IF;
1377:
1378: --
1379: FND_MSG_PUB.Count_And_Get
1380: (
1381: p_count => x_msg_count,
1382: p_data => x_msg_data,
1383: p_encoded => FND_API.G_FALSE

Line 1395: FND_MSG_PUB.Count_And_Get

1391: --
1392: EXCEPTION
1393: WHEN FND_API.G_EXC_ERROR THEN
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: FND_MSG_PUB.Count_And_Get
1396: (
1397: p_count => x_msg_count,
1398: p_data => x_msg_data,
1399: p_encoded => FND_API.G_FALSE

Line 1409: FND_MSG_PUB.Count_And_Get

1405: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
1406: --
1407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1408: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1409: FND_MSG_PUB.Count_And_Get
1410: (
1411: p_count => x_msg_count,
1412: p_data => x_msg_data,
1413: p_encoded => FND_API.G_FALSE

Line 1424: FND_MSG_PUB.Count_And_Get

1420: --
1421: WHEN OTHERS THEN
1422: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
1423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.Count_And_Get
1425: (
1426: p_count => x_msg_count,
1427: p_data => x_msg_data,
1428: p_encoded => FND_API.G_FALSE

Line 1514: FND_MSG_PUB.Count_And_Get

1510: --
1511: END LOOP;
1512: END IF;
1513: --
1514: FND_MSG_PUB.Count_And_Get
1515: (
1516: p_count => x_msg_count,
1517: p_data => x_msg_data,
1518: p_encoded => FND_API.G_FALSE

Line 1530: FND_MSG_PUB.Count_And_Get

1526: EXCEPTION
1527: WHEN FND_API.G_EXC_ERROR THEN
1528: ROLLBACK TO UPDATE_TRIPS;
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: FND_MSG_PUB.Count_And_Get
1531: (
1532: p_count => x_msg_count,
1533: p_data => x_msg_data,
1534: p_encoded => FND_API.G_FALSE

Line 1543: FND_MSG_PUB.Count_And_Get

1539: --
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: ROLLBACK TO UPDATE_TRIPS;
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1543: FND_MSG_PUB.Count_And_Get
1544: (
1545: p_count => x_msg_count,
1546: p_data => x_msg_data,
1547: p_encoded => FND_API.G_FALSE

Line 1557: FND_MSG_PUB.Count_And_Get

1553: WHEN OTHERS THEN
1554: ROLLBACK TO UPDATE_TRIPS;
1555: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.update_trips');
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1557: FND_MSG_PUB.Count_And_Get
1558: (
1559: p_count => x_msg_count,
1560: p_data => x_msg_data,
1561: p_encoded => FND_API.G_FALSE

Line 1653: FND_MSG_PUB.Count_And_Get

1649: THEN
1650: x_return_status := l_return_status_1;
1651: END IF;
1652:
1653: FND_MSG_PUB.Count_And_Get
1654: (
1655: p_count => x_msg_count,
1656: p_data => x_msg_data,
1657: p_encoded => FND_API.G_FALSE

Line 1669: FND_MSG_PUB.Count_And_Get

1665: EXCEPTION
1666: WHEN FND_API.G_EXC_ERROR THEN
1667: ROLLBACK TO UNASSIGN_TRIP;
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669: FND_MSG_PUB.Count_And_Get
1670: (
1671: p_count => x_msg_count,
1672: p_data => x_msg_data,
1673: p_encoded => FND_API.G_FALSE

Line 1682: FND_MSG_PUB.Count_And_Get

1678: --
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO UNASSIGN_TRIP;
1681: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1682: FND_MSG_PUB.Count_And_Get
1683: (
1684: p_count => x_msg_count,
1685: p_data => x_msg_data,
1686: p_encoded => FND_API.G_FALSE

Line 1696: FND_MSG_PUB.Count_And_Get

1692: WHEN OTHERS THEN
1693: ROLLBACK TO UNASSIGN_TRIP;
1694: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.Unassign_Trip');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1696: FND_MSG_PUB.Count_And_Get
1697: (
1698: p_count => x_msg_count,
1699: p_data => x_msg_data,
1700: p_encoded => FND_API.G_FALSE

Line 2093: FND_MSG_PUB.Count_And_Get

2089: IF FND_API.To_Boolean( p_commit ) THEN
2090: COMMIT WORK;
2091: END IF;
2092:
2093: FND_MSG_PUB.Count_And_Get
2094: (
2095: p_count => x_msg_count,
2096: p_data => x_msg_data,
2097: p_encoded => FND_API.G_FALSE

Line 2109: FND_MSG_PUB.Count_And_Get

2105: EXCEPTION
2106: WHEN FND_API.G_EXC_ERROR THEN
2107: ROLLBACK TO CANCEL_SERVICE;
2108: x_return_status := FND_API.G_RET_STS_ERROR;
2109: FND_MSG_PUB.Count_And_Get
2110: (
2111: p_count => x_msg_count,
2112: p_data => x_msg_data,
2113: p_encoded => FND_API.G_FALSE

Line 2122: FND_MSG_PUB.Count_And_Get

2118: --
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: ROLLBACK TO CANCEL_SERVICE;
2121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2122: FND_MSG_PUB.Count_And_Get
2123: (
2124: p_count => x_msg_count,
2125: p_data => x_msg_data,
2126: p_encoded => FND_API.G_FALSE

Line 2136: FND_MSG_PUB.Count_And_Get

2132: WHEN OTHERS THEN
2133: ROLLBACK TO CANCEL_SERVICE;
2134: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.Cancel_Service');
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2136: FND_MSG_PUB.Count_And_Get
2137: (
2138: p_count => x_msg_count,
2139: p_data => x_msg_data,
2140: p_encoded => FND_API.G_FALSE

Line 2291: FND_MSG_PUB.Count_And_Get

2287: IF FND_API.To_Boolean( p_commit ) THEN
2288: COMMIT WORK;
2289: END IF;
2290:
2291: FND_MSG_PUB.Count_And_Get
2292: (
2293: p_count => x_msg_count,
2294: p_data => x_msg_data,
2295: p_encoded => FND_API.G_FALSE

Line 2307: FND_MSG_PUB.Count_And_Get

2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: ROLLBACK TO CANCEL_SERVICE;
2306: x_return_status := FND_API.G_RET_STS_ERROR;
2307: FND_MSG_PUB.Count_And_Get
2308: (
2309: p_count => x_msg_count,
2310: p_data => x_msg_data,
2311: p_encoded => FND_API.G_FALSE

Line 2320: FND_MSG_PUB.Count_And_Get

2316: --
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO CANCEL_SERVICE;
2319: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2320: FND_MSG_PUB.Count_And_Get
2321: (
2322: p_count => x_msg_count,
2323: p_data => x_msg_data,
2324: p_encoded => FND_API.G_FALSE

Line 2334: FND_MSG_PUB.Count_And_Get

2330: WHEN OTHERS THEN
2331: ROLLBACK TO CANCEL_SERVICE;
2332: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.Cancel_Service');
2333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2334: FND_MSG_PUB.Count_And_Get
2335: (
2336: p_count => x_msg_count,
2337: p_data => x_msg_data,
2338: p_encoded => FND_API.G_FALSE

Line 4858: FND_MSG_PUB.initialize;

4854:
4855: -- Initialize message list if p_init_msg_list is set to TRUE.
4856: IF FND_API.to_Boolean( p_init_msg_list )
4857: THEN
4858: FND_MSG_PUB.initialize;
4859: END IF;
4860:
4861: x_return_status := FND_API.G_RET_STS_SUCCESS;
4862: --

Line 5565: FND_MSG_PUB.ADD;

5561: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LCSS_MANIFEST');
5562: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrier_name);
5563: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',l_mode_of_transport2);
5564: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',l_service_level2);
5565: FND_MSG_PUB.ADD;
5566:
5567: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'least cost service is from manifesting enabled carrier and del org is manifesting enabled, do not save trip or rate.');
5568:
5569: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'updating shipmethod on delivery...');

Line 5750: FND_MSG_PUB.Count_And_Get

5746: IF FND_API.To_Boolean( p_commit ) THEN
5747: COMMIT WORK;
5748: END IF;
5749:
5750: FND_MSG_PUB.Count_And_Get
5751: (
5752: p_count => x_msg_count,
5753: p_data => x_msg_data,
5754: p_encoded => FND_API.G_FALSE

Line 5778: FND_MSG_PUB.Count_And_Get

5774: IF FND_API.To_Boolean( p_commit ) THEN
5775: COMMIT WORK;
5776: END IF;
5777:
5778: FND_MSG_PUB.Count_And_Get
5779: (
5780: p_count => x_msg_count,
5781: p_data => x_msg_data,
5782: p_encoded => FND_API.G_FALSE

Line 5805: FND_MSG_PUB.Count_And_Get

5801: IF FND_API.To_Boolean( p_commit ) THEN
5802: COMMIT WORK;
5803: END IF;
5804:
5805: FND_MSG_PUB.Count_And_Get
5806: (
5807: p_count => x_msg_count,
5808: p_data => x_msg_data,
5809: p_encoded => FND_API.G_FALSE

Line 5827: FND_MSG_PUB.Count_And_Get

5823: --
5824: WHEN FND_API.G_EXC_ERROR THEN
5825: ROLLBACK TO RATE_DELIVERY;
5826: x_return_status := FND_API.G_RET_STS_ERROR;
5827: FND_MSG_PUB.Count_And_Get
5828: (
5829: p_count => x_msg_count,
5830: p_data => x_msg_data,
5831: p_encoded => FND_API.G_FALSE

Line 5845: FND_MSG_PUB.Count_And_Get

5841: --
5842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5843: ROLLBACK TO RATE_DELIVERY;
5844: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5845: FND_MSG_PUB.Count_And_Get
5846: (
5847: p_count => x_msg_count,
5848: p_data => x_msg_data,
5849: p_encoded => FND_API.G_FALSE

Line 5864: FND_MSG_PUB.Count_And_Get

5860: WHEN OTHERS THEN
5861: ROLLBACK TO RATE_DELIVERY;
5862: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
5863: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5864: FND_MSG_PUB.Count_And_Get
5865: (
5866: p_count => x_msg_count,
5867: p_data => x_msg_data,
5868: p_encoded => FND_API.G_FALSE

Line 5928: FND_MSG_PUB.initialize;

5924:
5925: -- Initialize message list if p_init_msg_list is set to TRUE.
5926: IF FND_API.to_Boolean( p_init_msg_list )
5927: THEN
5928: FND_MSG_PUB.initialize;
5929: END IF;
5930:
5931: x_return_status := FND_API.G_RET_STS_SUCCESS;
5932: FTE_FREIGHT_PRICING_UTIL.initialize_logging( x_return_status => l_return_status );

Line 6029: FND_MSG_PUB.ADD;

6025: x_out_param_rec.failed_delivery_id_list := l_failed_delivery_id_list;
6026:
6027: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6028: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
6029: FND_MSG_PUB.ADD;
6030:
6031: FTE_FREIGHT_PRICING_UTIL.setmsg(
6032: p_api => l_api_name,
6033: p_exc => ' ',

Line 6050: FND_MSG_PUB.Count_And_Get

6046: COMMIT WORK;
6047: END IF;
6048: END IF;
6049:
6050: FND_MSG_PUB.Count_And_Get
6051: (
6052: p_count => x_msg_count,
6053: p_data => x_msg_data,
6054: p_encoded => FND_API.G_FALSE

Line 6070: FND_MSG_PUB.ADD;

6066: EXCEPTION
6067: WHEN FND_API.G_EXC_ERROR THEN
6068: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6069: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
6070: FND_MSG_PUB.ADD;
6071:
6072: FTE_FREIGHT_PRICING_UTIL.setmsg(
6073: p_api => l_api_name,
6074: p_exc => ' ',

Line 6081: FND_MSG_PUB.Count_And_Get

6077:
6078: --fix bug3715247
6079: --ROLLBACK TO RATE_MULTIPLE_DELIVERY;
6080: x_return_status := FND_API.G_RET_STS_ERROR;
6081: FND_MSG_PUB.Count_And_Get
6082: (
6083: p_count => x_msg_count,
6084: p_data => x_msg_data,
6085: p_encoded => FND_API.G_FALSE

Line 6097: FND_MSG_PUB.ADD;

6093: --
6094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6095: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6096: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
6097: FND_MSG_PUB.ADD;
6098:
6099: FTE_FREIGHT_PRICING_UTIL.setmsg(
6100: p_api => l_api_name,
6101: p_exc => ' ',

Line 6108: FND_MSG_PUB.Count_And_Get

6104:
6105: --fix bug3715247
6106: --ROLLBACK TO RATE_MULTIPLE_DELIVERY;
6107: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6108: FND_MSG_PUB.Count_And_Get
6109: (
6110: p_count => x_msg_count,
6111: p_data => x_msg_data,
6112: p_encoded => FND_API.G_FALSE

Line 6124: FND_MSG_PUB.ADD;

6120: --
6121: WHEN OTHERS THEN
6122: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6123: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
6124: FND_MSG_PUB.ADD;
6125:
6126: FTE_FREIGHT_PRICING_UTIL.setmsg(
6127: p_api => l_api_name,
6128: p_exc => ' ',

Line 6136: FND_MSG_PUB.Count_And_Get

6132: --fix bug3715247
6133: --ROLLBACK TO RATE_MULTIPLE_DELIVERY;
6134: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);
6135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6136: FND_MSG_PUB.Count_And_Get
6137: (
6138: p_count => x_msg_count,
6139: p_data => x_msg_data,
6140: p_encoded => FND_API.G_FALSE

Line 6191: FND_MSG_PUB.initialize;

6187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6188: END IF;
6189:
6190: IF FND_API.to_Boolean(p_init_msg_list) THEN
6191: FND_MSG_PUB.initialize;
6192: END IF;
6193:
6194: IF p_init_prc_log = 'Y' THEN
6195: FTE_FREIGHT_PRICING_UTIL.initialize_logging( x_return_status => l_return_status );

Line 6288: FND_MSG_PUB.ADD;

6284: CLOSE c_get_dleg_id;
6285: IF l_leg_count > 1 THEN
6286: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_DLV_MNY_TRP');-- todo PM new msg
6287: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_in_rec.name);
6288: FND_MSG_PUB.ADD;
6289: RAISE FND_API.G_EXC_ERROR;
6290: END IF;
6291:
6292: -- if delivery is on one trip, trip has multiple deliveries, error out

Line 6305: FND_MSG_PUB.ADD;

6301:
6302: IF (l_leg_count > 1) THEN
6303: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_TRP_MNY_DLV');
6304: FND_MESSAGE.SET_TOKEN('TRIP_ID', l_trip_id);
6305: FND_MSG_PUB.ADD;
6306: RAISE FND_API.G_EXC_ERROR;
6307: END IF;
6308:
6309: IF (l_carrier_id is not null) or (l_mode_of_transport is not null)

Line 6324: --FND_MSG_PUB.ADD;

6320: -- if cancel service adds the message to the stack,
6321: -- we do not need to add again.
6322: --FND_MESSAGE.SET_NAME('FTE','FTE_PRC_CAN_SRV_FL');
6323: --FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_in_rec.name);
6324: --FND_MSG_PUB.ADD;
6325: RAISE FND_API.G_EXC_ERROR;
6326: END IF;
6327:
6328: END IF;

Line 6345: FND_MSG_PUB.ADD;

6341: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
6342: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_RERATE_SHIPMENT_FAIL');
6343: FND_MESSAGE.SET_TOKEN('DEL_NAMES', p_delivery_in_rec.name);
6344: FND_MESSAGE.SET_TOKEN('LOGFILE',FTE_FREIGHT_PRICING_UTIL.get_log_file_name());
6345: FND_MSG_PUB.ADD;
6346: RAISE FND_API.G_EXC_ERROR;
6347: END IF;
6348:
6349: -- End of API body

Line 6355: FND_MSG_PUB.Count_And_Get (

6351: IF FND_API.To_Boolean( p_commit ) THEN
6352: COMMIT WORK;
6353: END IF;
6354:
6355: FND_MSG_PUB.Count_And_Get (
6356: p_count => x_msg_count,
6357: p_data => x_msg_data,
6358: p_encoded => FND_API.G_FALSE
6359: );

Line 6374: FND_MSG_PUB.Count_And_Get (

6370: EXCEPTION
6371: WHEN FND_API.G_EXC_ERROR THEN
6372: ROLLBACK TO RATE_DELIVERY2;
6373: x_return_status := FND_API.G_RET_STS_ERROR;
6374: FND_MSG_PUB.Count_And_Get (
6375: p_count => x_msg_count,
6376: p_data => x_msg_data,
6377: p_encoded => FND_API.G_FALSE
6378: );

Line 6389: FND_MSG_PUB.Count_And_Get (

6385: END IF;
6386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6387: ROLLBACK TO RATE_DELIVERY2;
6388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6389: FND_MSG_PUB.Count_And_Get (
6390: p_count => x_msg_count,
6391: p_data => x_msg_data,
6392: p_encoded => FND_API.G_FALSE
6393: );

Line 6404: IF FND_MSG_PUB.Check_Msg_Level

6400: END IF;
6401: WHEN OTHERS THEN
6402: ROLLBACK TO RATE_DELIVERY2;
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6404: IF FND_MSG_PUB.Check_Msg_Level
6405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6406: THEN
6407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6408: END IF;

Line 6405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6401: WHEN OTHERS THEN
6402: ROLLBACK TO RATE_DELIVERY2;
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6404: IF FND_MSG_PUB.Check_Msg_Level
6405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6406: THEN
6407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6408: END IF;
6409: FND_MSG_PUB.Count_And_Get (

Line 6407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6404: IF FND_MSG_PUB.Check_Msg_Level
6405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6406: THEN
6407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6408: END IF;
6409: FND_MSG_PUB.Count_And_Get (
6410: p_count => x_msg_count,
6411: p_data => x_msg_data,

Line 6409: FND_MSG_PUB.Count_And_Get (

6405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6406: THEN
6407: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6408: END IF;
6409: FND_MSG_PUB.Count_And_Get (
6410: p_count => x_msg_count,
6411: p_data => x_msg_data,
6412: p_encoded => FND_API.G_FALSE
6413: );