DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE dependencies on WSH_TRIPS_PVT

Line 276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

272: END IF;
273: END LOOP;
274: IF l_okay='F' THEN -- atleast one of the trips the del is assigned to is not in list of ids
275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:

Line 481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
483: l_num_error:=l_num_error+1;
484: GOTO next_trip;
485: END IF;

Line 512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

508: rollback to before_update;
509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
514: l_num_error:=l_num_error+1;
515: GOTO next_trip;
516: END IF;

Line 565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));

561: rollback to before_update;
562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
567: l_num_error:=l_num_error+1;
568: END IF;
569:

Line 1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1473: x_return_status => x_return_status);
1474: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: wsh_util_core.add_message(x_return_status);
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.pop(l_module_name);

Line 1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.pop(l_module_name);

Line 1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));

1511:
1512: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1513: IF l_deliveries_exist IS null THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1516: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1518: IF l_debug_on THEN
1519: WSH_DEBUG_SV.pop(l_module_name);

Line 1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1555: x_return_status => x_return_status);
1556: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1561: wsh_util_core.add_message(x_return_status);
1562: IF l_debug_on THEN
1563: WSH_DEBUG_SV.pop(l_module_name);

Line 1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1575: IF (SQL%NOTFOUND) THEN
1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: IF l_debug_on THEN
1583: WSH_DEBUG_SV.pop(l_module_name);

Line 1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));

1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.pop(l_module_name);

Line 1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));

1839: IF (SQL%NOTFOUND) THEN
1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.pop(l_module_name);