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

Line 10: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6: --
7:
8: PROCEDURE Rate_Delivery (
9: p_api_version IN NUMBER DEFAULT 1.0,
10: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
12: p_in_param_rec IN rate_del_in_param_rec,
13: x_out_param_rec OUT NOCOPY rate_del_out_param_rec,
14: x_return_status OUT NOCOPY VARCHAR2,

Line 11: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

7:
8: PROCEDURE Rate_Delivery (
9: p_api_version IN NUMBER DEFAULT 1.0,
10: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
12: p_in_param_rec IN rate_del_in_param_rec,
13: x_out_param_rec OUT NOCOPY rate_del_out_param_rec,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
46: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
47: END IF;
48: --
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: SAVEPOINT WSH_Rate_Delivery;
51:
52: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
53: ((p_in_param_rec.delivery_id_list.COUNT > 0) AND p_in_param_rec.action is NOT null) THEN

Line 104: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,

100:
101: -- WSH get_rate_from_FTE demo flow (multiple deliveries)
102: PROCEDURE Cancel_Service (
103: p_api_version IN NUMBER DEFAULT 1.0,
104: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_delivery_list IN WSH_UTIL_CORE.id_tab_type,
106: p_action IN VARCHAR2 DEFAULT 'CANCEL',
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,

Line 107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

103: p_api_version IN NUMBER DEFAULT 1.0,
104: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_delivery_list IN WSH_UTIL_CORE.id_tab_type,
106: p_action IN VARCHAR2 DEFAULT 'CANCEL',
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2)
111: IS

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
140: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
141: END IF;
142: --
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144: SAVEPOINT WSH_Cancel_Service;
145:
146: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
147: (p_delivery_list.COUNT > 0 AND p_action is NOT null) THEN

Line 192: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,

188: END Cancel_Service;
189:
190: PROCEDURE Cancel_Service (
191: p_api_version IN NUMBER DEFAULT 1.0,
192: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_delivery_id IN NUMBER,
194: p_action IN VARCHAR2 DEFAULT 'CANCEL',
195: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,

Line 195: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

191: p_api_version IN NUMBER DEFAULT 1.0,
192: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_delivery_id IN NUMBER,
194: p_action IN VARCHAR2 DEFAULT 'CANCEL',
195: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2)
199: IS

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',p_init_msg_list);
228: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',p_commit);
229: END IF;
230: --
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: SAVEPOINT WSH_Cancel_Service_2;
233:
234: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
235: (p_delivery_id is NOT null AND p_action is NOT null) THEN

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

307: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_LEG_ID',P_DELIVERY_LEG_ID);
308: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
309: END IF;
310: --
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: SAVEPOINT before_changes;
313:
314: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
315: (p_delivery_leg_id is NOT null OR p_trip_id is NOT null) THEN

Line 326: p_init_msg_list => fnd_api.g_false,

322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_PRICING.SHIPMENT_PRICE_CONSOLIDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
323: END IF;
324: --
325: FTE_FREIGHT_PRICING.shipment_price_consolidate (
326: p_init_msg_list => fnd_api.g_false,
327: p_in_attributes => l_in_attributes,
328: x_return_status => l_return_status,
329: x_msg_count => l_msg_count,
330: x_msg_data => l_msg_data );

Line 442: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)

438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
439:
440: --1. Creating Stop
441: IF (p_action = 'ADD'
442: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
443: ) THEN
444: -- Group API Call
445: l_stop_seg_IN.action_type := p_action;
446: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM

Line 446: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM

442: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
443: ) THEN
444: -- Group API Call
445: l_stop_seg_IN.action_type := p_action;
446: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM
447: AND p_stop_rec.stop_location_id IS NOT NULL
448: ) THEN
449:
450: -- old record

Line 470: p_init_msg_list => FND_API.G_FALSE,

466: END IF;
467: --
468: FTE_WSH_INTERFACE_PKG.segment_stop_change
469: ( p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data,

Line 471: p_commit => FND_API.G_FALSE,

467: --
468: FTE_WSH_INTERFACE_PKG.segment_stop_change
469: ( p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data,
475: p_trip_segment_rec => l_stops_trip_rec,

Line 488: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)

484: END IF;
485:
486: --2. Updating Stop
487: ELSIF (p_action = 'UPDATE'
488: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
489: ) THEN
490:
491: l_stop_seg_IN.action_type := p_action;
492: -- Group API Call

Line 493: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM

489: ) THEN
490:
491: l_stop_seg_IN.action_type := p_action;
492: -- Group API Call
493: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM
494: AND p_stop_rec.stop_location_id IS NOT NULL
495: )THEN
496:
497: -- Get details of existing stop from database into l_stop_rec_old

Line 517: p_init_msg_list => FND_API.G_FALSE,

513: END IF;
514: --
515: FTE_WSH_INTERFACE_PKG.segment_stop_change
516: ( p_api_version => 1.0,
517: p_init_msg_list => FND_API.G_FALSE,
518: p_commit => FND_API.G_FALSE,
519: x_return_status => l_return_status,
520: x_msg_count => l_msg_count,
521: x_msg_data => l_msg_data,

Line 518: p_commit => FND_API.G_FALSE,

514: --
515: FTE_WSH_INTERFACE_PKG.segment_stop_change
516: ( p_api_version => 1.0,
517: p_init_msg_list => FND_API.G_FALSE,
518: p_commit => FND_API.G_FALSE,
519: x_return_status => l_return_status,
520: x_msg_count => l_msg_count,
521: x_msg_data => l_msg_data,
522: p_trip_segment_rec => l_stops_trip_rec,

Line 534: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)

530: END IF;
531: END IF;
532: --3. Deleting Stop
533: ELSIF (p_action = 'DELETE'
534: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)
535: ) THEN
536:
537: l_stop_seg_IN.action_type := p_action;
538: -- Group API Call

Line 539: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM

535: ) THEN
536:
537: l_stop_seg_IN.action_type := p_action;
538: -- Group API Call
539: IF (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM
540: AND p_stop_rec.stop_location_id IS NOT NULL
541: ) THEN
542: l_stop_rec_old := p_stop_rec;
543: -- Get trip details into l_stops_trip_rec FOR GROUP

Line 555: p_init_msg_list => FND_API.G_FALSE,

551: END IF;
552: --
553: FTE_WSH_INTERFACE_PKG.segment_stop_change
554: ( p_api_version => 1.0,
555: p_init_msg_list => FND_API.G_FALSE,
556: p_commit => FND_API.G_FALSE,
557: x_return_status => l_return_status,
558: x_msg_count => l_msg_count,
559: x_msg_data => l_msg_data,

Line 556: p_commit => FND_API.G_FALSE,

552: --
553: FTE_WSH_INTERFACE_PKG.segment_stop_change
554: ( p_api_version => 1.0,
555: p_init_msg_list => FND_API.G_FALSE,
556: p_commit => FND_API.G_FALSE,
557: x_return_status => l_return_status,
558: x_msg_count => l_msg_count,
559: x_msg_data => l_msg_data,
560: p_trip_segment_rec => l_stops_trip_rec,

Line 572: AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)

568: END IF;
569: END IF;
570: --4. Updating Trip
571: ELSIF (p_action = 'UPDATE'
572: AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)
573: ) THEN
574:
575: l_trip_seg_IN.action_type := p_action;
576:

Line 577: IF (p_trip_rec.trip_id <> FND_API.G_MISS_NUM

573: ) THEN
574:
575: l_trip_seg_IN.action_type := p_action;
576:
577: IF (p_trip_rec.trip_id <> FND_API.G_MISS_NUM
578: AND p_trip_rec.trip_id IS NOT NULL
579: )THEN
580:
581: -- Get the details of the trip as in the database in l_trip_rec_old

Line 597: p_init_msg_list => FND_API.G_FALSE,

593: END IF;
594: --
595: FTE_WSH_INTERFACE_PKG.trip_segment_change
596: ( p_api_version => 1.0,
597: p_init_msg_list => FND_API.G_FALSE,
598: p_commit => FND_API.G_FALSE,
599: x_return_status => l_return_status,
600: x_msg_count => l_msg_count,
601: x_msg_data => l_msg_data,

Line 598: p_commit => FND_API.G_FALSE,

594: --
595: FTE_WSH_INTERFACE_PKG.trip_segment_change
596: ( p_api_version => 1.0,
597: p_init_msg_list => FND_API.G_FALSE,
598: p_commit => FND_API.G_FALSE,
599: x_return_status => l_return_status,
600: x_msg_count => l_msg_count,
601: x_msg_data => l_msg_data,
602: p_old_trip_segment_rec => l_trip_rec_old,

Line 617: AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)

613: /* anxsharm - as per talk with Nikhil ,WSH will not call FTE for Deletion
614: of Stops within a trip.WSH will call FTE for individual stop deletion
615: and individual trip deletion */
616: ELSIF (p_action = 'DELETE'
617: AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)
618: ) THEN
619: l_trip_seg_IN.action_type := p_action;
620: -- Group API Call
621: IF (p_trip_rec.trip_id <> FND_API.G_MISS_NUM

Line 621: IF (p_trip_rec.trip_id <> FND_API.G_MISS_NUM

617: AND (p_trip_rec.trip_id <> FND_API.G_MISS_NUM)
618: ) THEN
619: l_trip_seg_IN.action_type := p_action;
620: -- Group API Call
621: IF (p_trip_rec.trip_id <> FND_API.G_MISS_NUM
622: AND p_trip_rec.trip_id IS NOT NULL
623: ) THEN
624:
625: l_trip_rec_old := p_trip_rec;

Line 633: p_init_msg_list => FND_API.G_FALSE,

629: END IF;
630: --
631: FTE_WSH_INTERFACE_PKG.trip_segment_change
632: ( p_api_version => 1.0,
633: p_init_msg_list => FND_API.G_FALSE,
634: p_commit => FND_API.G_FALSE,
635: x_return_status => l_return_status,
636: x_msg_count => l_msg_count,
637: x_msg_data => l_msg_data,

Line 634: p_commit => FND_API.G_FALSE,

630: --
631: FTE_WSH_INTERFACE_PKG.trip_segment_change
632: ( p_api_version => 1.0,
633: p_init_msg_list => FND_API.G_FALSE,
634: p_commit => FND_API.G_FALSE,
635: x_return_status => l_return_status,
636: x_msg_count => l_msg_count,
637: x_msg_data => l_msg_data,
638: p_old_trip_segment_rec => l_trip_rec_old,

Line 819: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

815: END;
816:
817: PROCEDURE Rate_Trip (
818: p_api_version IN NUMBER DEFAULT 1.0,
819: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
820: p_action_params IN rating_action_param_rec,
821: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
822: x_return_status OUT NOCOPY VARCHAR2,
823: x_msg_count OUT NOCOPY NUMBER,

Line 821: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

817: PROCEDURE Rate_Trip (
818: p_api_version IN NUMBER DEFAULT 1.0,
819: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
820: p_action_params IN rating_action_param_rec,
821: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
822: x_return_status OUT NOCOPY VARCHAR2,
823: x_msg_count OUT NOCOPY NUMBER,
824: x_msg_data OUT NOCOPY VARCHAR2)
825: IS

Line 884: x_return_status := FND_API.G_RET_STS_SUCCESS;

880: 'p_commit '|| p_commit,
881: WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883:
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885:
886: SAVEPOINT WSH_Rate_Trip;
887:
888: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

Line 974: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

970: --
971: -- +====================================================+
972: PROCEDURE Trip_Action (
973: p_api_version IN NUMBER DEFAULT 1.0,
974: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
975: p_trip_id_tab IN WSH_UTIL_CORE.id_tab_type,
976: p_action_params IN wsh_trip_action_param_rec,
977: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
978: x_action_out_rec OUT NOCOPY wsh_trip_action_out_rec,

Line 977: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

973: p_api_version IN NUMBER DEFAULT 1.0,
974: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
975: p_trip_id_tab IN WSH_UTIL_CORE.id_tab_type,
976: p_action_params IN wsh_trip_action_param_rec,
977: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
978: x_action_out_rec OUT NOCOPY wsh_trip_action_out_rec,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1025: x_return_status := FND_API.G_RET_STS_SUCCESS;

1021: 'p_action_params.action_code '|| p_action_params.action_code,
1022: WSH_DEBUG_SV.C_PROC_LEVEL);
1023: END IF;
1024:
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:
1027: SAVEPOINT WSH_Trip_Action;
1028:
1029: -- Check if FTE is installed

Line 1342: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1338:
1339:
1340: PROCEDURE RANK_LIST_ACTION(
1341: p_api_version IN NUMBER DEFAULT 1.0,
1342: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1343: x_return_status OUT NOCOPY VARCHAR2,
1344: x_msg_count OUT NOCOPY NUMBER,
1345: x_msg_data OUT NOCOPY VARCHAR2,
1346: p_action_code IN VARCHAR2,

Line 1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

1381: WSH_DEBUG_SV.push(l_module_name);
1382: END IF;
1383: --
1384:
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1388:
1389: -- Copy p_ranked_list to FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE

Line 1624: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1620: x_return_message => x_return_message,
1621: x_return_status => x_return_status);
1622:
1623: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1624: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: --
1628: -- Debug Statements

Line 1664: -- FND_API.G_TRUE -> yes

1660: -- x_org_id operating unit identifier
1661: -- p_entity_id entity identifier
1662: -- p_entity_type 'TRIP' or 'DELIVERY'
1663: -- p_org_id_flag flag to optionally get x_org_id
1664: -- FND_API.G_TRUE -> yes
1665: -- FND_API.G_FALSE -> no
1666: --
1667: --
1668: -- COMMENT : This procedure calls FTE to associate a trip with

Line 1665: -- FND_API.G_FALSE -> no

1661: -- p_entity_id entity identifier
1662: -- p_entity_type 'TRIP' or 'DELIVERY'
1663: -- p_org_id_flag flag to optionally get x_org_id
1664: -- FND_API.G_TRUE -> yes
1665: -- FND_API.G_FALSE -> no
1666: --
1667: --
1668: -- COMMENT : This procedure calls FTE to associate a trip with
1669: -- inventory organization and optionally the operating unit.