DBA Data[Home] [Help]

APPS.WMS_TRIPSTOPS_STAGELANES_PUB dependencies on FND_MSG_PUB

Line 99: FND_MSG_PUB.ADD;

95: --If a staging lane already exists for this trip stop, then return the staging lane id to the calling
96: --program.
97: THEN
98: FND_MESSAGE.SET_NAME('WMS', 'WMS_STGLN_ASSIGNED');
99: FND_MSG_PUB.ADD;
100: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
102:
103: IF (l_debug = 1) THEN

Line 101: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

97: THEN
98: FND_MESSAGE.SET_NAME('WMS', 'WMS_STGLN_ASSIGNED');
99: FND_MSG_PUB.ADD;
100: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
102:
103: IF (l_debug = 1) THEN
104: trace('Staging lane already exists for this trip stop');
105: END IF;

Line 130: FND_MSG_PUB.ADD;

126: ELSIF ((l_dock_id = 0) AND (l_staging_lane_id <> 0))
127: --check if the trip stop has a dock door assigned.
128: THEN
129: FND_MESSAGE.SET_NAME('WMS', 'WMS_DKDR_NOT_EXISTS');
130: FND_MSG_PUB.ADD;
131: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
133:
134: IF (l_debug = 1) THEN

Line 132: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

128: THEN
129: FND_MESSAGE.SET_NAME('WMS', 'WMS_DKDR_NOT_EXISTS');
130: FND_MSG_PUB.ADD;
131: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
133:
134: IF (l_debug = 1) THEN
135: trace('Dock Door not associated to trip stop');
136: END IF;

Line 235: FND_MSG_PUB.ADD;

231: IF (l_debug = 1) THEN
232: trace('No staging lanes assigned to Dock Door');
233: END IF;
234: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_ASSIGNED_STGLNS_FOR_DKDR');
235: FND_MSG_PUB.ADD;
236: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
238:
239:

Line 237: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

233: END IF;
234: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_ASSIGNED_STGLNS_FOR_DKDR');
235: FND_MSG_PUB.ADD;
236: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
238:
239:
240: CLOSE get_stglanes_for_dkdr_cur;
241:

Line 502: FND_MSG_PUB.ADD;

498: IF (l_debug = 1) THEN
499: trace('There is no trip stop with this number' || p_trip_stop );
500: END IF;
501: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_TRIPSTOP_EXISTS');
502: FND_MSG_PUB.ADD;
503: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
504: FND_MSG_PUB.Count_And_Get
505: (
506: p_count => x_msg_count

Line 504: FND_MSG_PUB.Count_And_Get

500: END IF;
501: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_TRIPSTOP_EXISTS');
502: FND_MSG_PUB.ADD;
503: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
504: FND_MSG_PUB.Count_And_Get
505: (
506: p_count => x_msg_count
507: , p_data => x_msg_data
508: );

Line 528: FND_MSG_PUB.ADD;

524: IF (l_debug = 1) THEN
525: trace('There is more than one record which matches this trip stop');
526: END IF;
527: FND_MESSAGE.SET_NAME('WMS', 'WMS_DUP_TRIPSTOPS');
528: FND_MSG_PUB.ADD;
529: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: FND_MSG_PUB.Count_And_Get
531: (
532: p_count => x_msg_count

Line 530: FND_MSG_PUB.Count_And_Get

526: END IF;
527: FND_MESSAGE.SET_NAME('WMS', 'WMS_DUP_TRIPSTOPS');
528: FND_MSG_PUB.ADD;
529: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: FND_MSG_PUB.Count_And_Get
531: (
532: p_count => x_msg_count
533: , p_data => x_msg_data
534: );

Line 598: FND_MSG_PUB.ADD;

594: ROLLBACK TO update_dock_sp;
595: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596:
597: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_FAIL');
598: FND_MSG_PUB.ADD;
599:
600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,p_data => x_msg_data);
601:
602: END update_staging_lane_id;

Line 600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,p_data => x_msg_data);

596:
597: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_FAIL');
598: FND_MSG_PUB.ADD;
599:
600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,p_data => x_msg_data);
601:
602: END update_staging_lane_id;
603:
604:

Line 654: FND_MSG_PUB.ADD;

650: trace('FUNCTION get_subinventory_code Organization Id = ' || p_org_id);
651: END IF;
652:
653: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_SUBINV_ASSIGNED_TO_LOCATION');
654: FND_MSG_PUB.ADD;
655: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
657: RETURN l_sub_code;
658:

Line 656: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

652:
653: FND_MESSAGE.SET_NAME('WMS', 'WMS_NO_SUBINV_ASSIGNED_TO_LOCATION');
654: FND_MSG_PUB.ADD;
655: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
657: RETURN l_sub_code;
658:
659: WHEN too_many_rows THEN
660: l_sub_code := null;

Line 662: FND_MSG_PUB.ADD;

658:
659: WHEN too_many_rows THEN
660: l_sub_code := null;
661: FND_MESSAGE.SET_NAME('WMS', 'WMS_TOO_MANY_ROWS');
662: FND_MSG_PUB.ADD;
663: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
665:
666: RETURN l_sub_code;

Line 664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

660: l_sub_code := null;
661: FND_MESSAGE.SET_NAME('WMS', 'WMS_TOO_MANY_ROWS');
662: FND_MSG_PUB.ADD;
663: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
665:
666: RETURN l_sub_code;
667:
668: END get_subinventory_code;