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: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string

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

533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
539: l_num_error:=l_num_error+1;
540: goto next_trip;
541: END IF;

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

555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
561: l_num_error:=l_num_error+1;
562: goto next_trip;
563: END IF;

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

578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
584: l_num_error:=l_num_error+1;
585: goto next_trip;
586: END IF;

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

634: rollback to before_update;
635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
640: l_num_error:=l_num_error+1;
641: END IF;
642:

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

1618: x_return_status => x_return_status);
1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1624: wsh_util_core.add_message(x_return_status);
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.pop(l_module_name);

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

1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.pop(l_module_name);

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

1656:
1657: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1658: IF l_deliveries_exist IS null THEN
1659: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1660: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.pop(l_module_name);

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

1700: x_return_status => x_return_status);
1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.pop(l_module_name);

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

1720: IF (SQL%NOTFOUND) THEN
1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.pop(l_module_name);

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

1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);
1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.pop(l_module_name);

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

1984: IF (SQL%NOTFOUND) THEN
1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.pop(l_module_name);