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.FTE_FREIGHT_RATING_DLVY_GRP dependencies on FTE_CARRIER_RANK_LIST_PVT

Line 3612: p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,

3608:
3609: END Tender_Trip;
3610:
3611: PROCEDURE Sequential_Tender(
3612: p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec,
3613: p_vehicle_type IN NUMBER,
3614: x_return_status OUT NOCOPY VARCHAR2)
3615: IS
3616:

Line 3636: l_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3632: where v.vehicle_type_id = c_vehicle_type_id;
3633:
3634:
3635: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'Sequential_Tender';
3636: l_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3637: l_out_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3638: l_rank_id NUMBER;
3639: l_append_flag VARCHAR2(1);
3640: l_msg_count NUMBER;

Line 3637: l_out_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;

3633:
3634:
3635: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'Sequential_Tender';
3636: l_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3637: l_out_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3638: l_rank_id NUMBER;
3639: l_append_flag VARCHAR2(1);
3640: l_msg_count NUMBER;
3641: l_msg_data VARCHAR2(32767);

Line 3726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION UPDATE');

3722:
3723: IF(l_rank_id IS NOT NULL)
3724: THEN
3725:
3726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION UPDATE');
3727: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3728: p_api_version_number =>1,
3729: p_init_msg_list =>FND_API.G_FALSE,
3730: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_UPDATE,

Line 3727: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(

3723: IF(l_rank_id IS NOT NULL)
3724: THEN
3725:
3726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION UPDATE');
3727: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3728: p_api_version_number =>1,
3729: p_init_msg_list =>FND_API.G_FALSE,
3730: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_UPDATE,
3731: p_ranklist =>l_rank_tab,

Line 3730: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_UPDATE,

3726: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION UPDATE');
3727: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3728: p_api_version_number =>1,
3729: p_init_msg_list =>FND_API.G_FALSE,
3730: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_UPDATE,
3731: p_ranklist =>l_rank_tab,
3732: p_trip_id =>p_rank_rec.trip_id,
3733: p_rank_id =>l_rank_id,
3734: x_return_status =>l_return_status,

Line 3740: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION CREATE');

3736: x_msg_data =>l_msg_data);
3737:
3738: ELSE
3739:
3740: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION CREATE');
3741:
3742: l_rank_tab(1).rank_sequence:=1;
3743: l_rank_tab(1).is_current:='Y';
3744: l_rank_tab(1).source:=FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;

Line 3744: l_rank_tab(1).source:=FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;

3740: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Before calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION CREATE');
3741:
3742: l_rank_tab(1).rank_sequence:=1;
3743: l_rank_tab(1).is_current:='Y';
3744: l_rank_tab(1).source:=FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;
3745:
3746: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3747: p_api_version_number =>1,
3748: p_init_msg_list =>FND_API.G_FALSE,

Line 3746: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(

3742: l_rank_tab(1).rank_sequence:=1;
3743: l_rank_tab(1).is_current:='Y';
3744: l_rank_tab(1).source:=FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;
3745:
3746: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3747: p_api_version_number =>1,
3748: p_init_msg_list =>FND_API.G_FALSE,
3749: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_CREATE,
3750: p_ranklist =>l_rank_tab,

Line 3749: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_CREATE,

3745:
3746: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
3747: p_api_version_number =>1,
3748: p_init_msg_list =>FND_API.G_FALSE,
3749: p_action_code =>FTE_CARRIER_RANK_LIST_PVT.S_CREATE,
3750: p_ranklist =>l_rank_tab,
3751: p_trip_id =>p_rank_rec.trip_id,
3752: p_rank_id =>NULL,
3753: x_return_status =>l_return_status,

Line 3760: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION Return status:'||l_return_status||' Message:'||l_msg_data);

3756:
3757:
3758: END IF;
3759:
3760: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION Return status:'||l_return_status||' Message:'||l_msg_data);
3761: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3762: THEN
3763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3764: THEN

Line 3773: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION'||l_rank_id);

3769: IF ((l_out_rank_tab.FIRST IS NOT NULL) AND(l_out_rank_tab(l_out_rank_tab.FIRST).rank_id IS NOT NULL))
3770: THEN
3771:
3772: l_rank_id:=l_out_rank_tab(l_out_rank_tab.FIRST).rank_id;
3773: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION'||l_rank_id);
3774: ELSE
3775:
3776: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'NO RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');
3777: --Commenting out as Rank list API handles update of rank on trip

Line 3776: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'NO RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');

3772: l_rank_id:=l_out_rank_tab(l_out_rank_tab.FIRST).rank_id;
3773: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION'||l_rank_id);
3774: ELSE
3775:
3776: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'NO RANK ID After calling FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');
3777: --Commenting out as Rank list API handles update of rank on trip
3778: --raise FTE_FREIGHT_PRICING_UTIL.g_rank_list_update_fail;
3779:
3780: END IF;

Line 3908: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
3905: l_carrier_id NUMBER;
3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
3907: l_service_level wsh_carrier_services.service_level%type;
3908: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
3909:
3910: BEGIN
3911:
3912: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4199: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

4195: l_service_level wsh_carrier_services.service_level%type;
4196:
4197: l_org_manifest_enabled VARCHAR2(1);
4198: l_carrier_manifest_enabled VARCHAR2(1);
4199: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
4200:
4201:
4202: --
4203: BEGIN

Line 4811: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

4807:
4808: l_tl_lane_rate NUMBER;
4809: l_tl_lane_curr VARCHAR2(10);
4810: l_lowest_tl_lane_index NUMBER;
4811: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
4812:
4813:
4814: c_carr_srv_rec c_carrier_services%ROWTYPE;
4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;