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.WMS_TRIPSTOPS_STAGELANES_PUB dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: l_stg_ln_id NUMBER := 0;
24:
25: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: IF (l_debug = 1) THEN
30: trace('in getstgln for tripstop');
31: trace('org id ' || to_char(p_org_id));

Line 100: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
104: trace('Staging lane already exists for this trip stop');

Line 131: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
135: trace('Dock Door not associated to trip stop');

Line 236: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
240: CLOSE get_stglanes_for_dkdr_cur;

Line 494: x_return_status := FND_API.G_RET_STS_SUCCESS; --returns success value

490: trace('FUNCTION check_dockdoor_tripstop_exists staging lane id ' || x_staging_lane_id);
491: END IF;
492:
493: x_dkdr_trpstp_exists := TRUE ;
494: x_return_status := FND_API.G_RET_STS_SUCCESS; --returns success value
495:
496: EXCEPTION
497: WHEN no_data_found THEN
498: IF (l_debug = 1) THEN

Line 503: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
507: , p_data => x_msg_data

Line 529: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
533: , p_data => x_msg_data

Line 570: --x_return_status := FND_API.G_RET_STS_SUCCESS;

566: IS
567: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
568: BEGIN
569: SAVEPOINT update_dock_sp;
570: --x_return_status := FND_API.G_RET_STS_SUCCESS;
571: IF (l_debug = 1) THEN
572: trace('Before update PROCEDURE update_staging_lane_id = ' || p_stage_lane_id);
573: trace('Before update PROCEDURE update_staging_lane_id = ' || p_trip_stop);
574: trace('Before update PROCEDURE update_staging_lane_id = ' || p_dock_id);

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: LAST_UPDATE_LOGIN = 1
582: WHERE DOCK_ID = p_dock_id
583: AND TRIP_STOP = p_trip_stop;
584:
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: IF (l_debug = 1) THEN
587: trace('After update PROCEDURE update_staging_lane_id');
588: END IF;
589:

Line 595: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591:
592: EXCEPTION
593: WHEN OTHERS THEN
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:

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS; -- returns success values

633: trace('FUNCTION get_subinventory_code subinventory_code = ' || l_sub_code);
634: trace('FUNCTION get_subinventory_code Organization Id = ' || p_org_id);
635: END IF;
636:
637: x_return_status := FND_API.G_RET_STS_SUCCESS; -- returns success values
638: RETURN l_sub_code;
639:
640: EXCEPTION
641: WHEN no_data_found THEN

Line 655: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
659: WHEN too_many_rows THEN

Line 663: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
667: