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_MLS_WRAPPER dependencies on FTE_TENDER_PVT

Line 1368: IF (p_action IS NULL OR p_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED)

1364:
1365:
1366: -- This is to make sure we do not udpate anything for update tender event
1367:
1368: IF (p_action IS NULL OR p_action <> FTE_TENDER_PVT.S_SHIPPER_UPDATED)
1369: THEN
1370: --call wsh public API
1371: WSH_INTERFACE_GRP.Create_Update_Trip
1372: (

Line 1447: FTE_TENDER_PVT.S_SOURCE_CP, -- response source

1443: p_rec_VEHICLE_NUMBER, -- vehicle number
1444: p_operator, -- operator
1445: p_rec_carrier_ref_number, -- carrier ref number
1446: null, -- shipment status header id
1447: FTE_TENDER_PVT.S_SOURCE_CP, -- response source
1448: null); -- transaction id
1449:
1450:
1451: Trip_Action

Line 2614: l_trip_action_rec := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_SHIPPER_CANCELLED,

2610: x_wFItemKey => l_wFItemKey))
2611: THEN
2612: --{
2613:
2614: l_trip_action_rec := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
2615: null,null,null,null,null,null,
2616: null,null,null,null,null,null,
2617: null,null);
2618:

Line 2623: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status

2619: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2620: p_trip_id_tab(i), -- TripId
2621: null, -- Trip Name
2622: p_trip_id_tab(i), --tender id
2623: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status
2624: null,-- car_contact_id
2625: null, -- car contact name
2626: null, -- auto_accept
2627: null, -- auto tender

Line 2695: FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT(

2691: p_raise_error_flag => FALSE);
2692:
2693: -- delete tender snapshot
2694:
2695: FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT(
2696: p_init_msg_list => FND_API.G_FALSE,
2697: p_tender_id => p_trip_id_tab(i),
2698: x_return_status => l_return_status,
2699: x_msg_count => l_number_of_errors,

Line 5922: FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST(

5918:
5919: l_tender_action := p_action_prms.action_code;
5920: --{
5921: --{ Call validate tender request to check the action
5922: FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST(
5923: p_api_version_number => p_api_version_number,
5924: p_init_msg_list => FND_API.G_FALSE,
5925: x_return_status => l_return_status,
5926: x_msg_count => l_msg_count,

Line 5947: IF l_tender_action = FTE_TENDER_PVT.S_TENDERED THEN

5943: x_num_errors =>l_number_of_errors,
5944: p_msg_data =>l_msg_data);
5945: --}
5946:
5947: IF l_tender_action = FTE_TENDER_PVT.S_TENDERED THEN
5948: --{
5949:
5950: l_item_key := FTE_TENDER_PVT.GET_ITEM_KEY(p_trip_info_rec.trip_id);
5951:

Line 5950: l_item_key := FTE_TENDER_PVT.GET_ITEM_KEY(p_trip_info_rec.trip_id);

5946:
5947: IF l_tender_action = FTE_TENDER_PVT.S_TENDERED THEN
5948: --{
5949:
5950: l_item_key := FTE_TENDER_PVT.GET_ITEM_KEY(p_trip_info_rec.trip_id);
5951:
5952: SELECT SHIP_METHOD_CODE,MODE_OF_TRANSPORT
5953: INTO l_db_sm_code,db_mode_of_transport FROM WSH_TRIPS
5954: WHERE TRIP_ID = p_trip_info_rec.trip_id;

Line 5960: FTE_TENDER_PVT.S_TENDERED, -- status

5956: l_trip_info_rec := FTE_TENDER_ATTR_REC(
5957: p_trip_info_rec.trip_id, -- TripId
5958: p_trip_info_rec.trip_name, -- Trip Name
5959: p_trip_info_rec.tender_id, --tender id
5960: FTE_TENDER_PVT.S_TENDERED, -- status
5961: p_trip_info_rec.car_contact_id,-- car_contact_id
5962: p_trip_info_rec.car_contact_name, -- car contact name
5963: null, -- auto_accept
5964: null, -- auto tender

Line 5983: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_TENDERED;

5979: p_trip_info.wf_name := l_trip_info_rec.WF_NAME;
5980: p_trip_info.wf_process_name := l_trip_info_rec.wf_process_name;
5981: p_trip_info.wf_item_key := l_trip_info_rec.wf_item_key;
5982: p_trip_info.load_Tender_number := l_trip_info_rec.trip_id;
5983: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_TENDERED;
5984: p_trip_info.carrier_contact_id := l_trip_info_rec.car_contact_id;
5985: p_trip_info.carrier_response := null;
5986: p_trip_info.carrier_reference_number := null;
5987: p_trip_info.operator := null;

Line 6080: WSH_DEBUG_SV.logmsg(l_module_name,' Call FTE_TENDER_PVT.RAISE_TENDER_EVENT ',

6076: --}
6077:
6078: IF l_debug_on
6079: THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,' Call FTE_TENDER_PVT.RAISE_TENDER_EVENT ',
6081: WSH_DEBUG_SV.C_PROC_LEVEL);
6082: END IF;
6083:
6084:

Line 6085: FTE_TENDER_PVT.RAISE_TENDER_EVENT(

6081: WSH_DEBUG_SV.C_PROC_LEVEL);
6082: END IF;
6083:
6084:
6085: FTE_TENDER_PVT.RAISE_TENDER_EVENT(
6086: p_init_msg_list => FND_API.G_FALSE,
6087: x_return_status => l_return_status,
6088: x_msg_count => l_msg_count,
6089: x_msg_data => l_msg_data,

Line 6096: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_TENDER_PVT.RAISE_TENDER_EVENT '

6092:
6093:
6094: IF l_debug_on
6095: THEN
6096: WSH_DEBUG_SV.logmsg(l_module_name,' FTE_TENDER_PVT.RAISE_TENDER_EVENT '
6097: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6098: END IF;
6099:
6100:

Line 6110: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED OR

6106:
6107:
6108:
6109: --}
6110: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED OR
6111: l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN
6112: --{
6113:
6114: IF l_debug_on

Line 6111: l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN

6107:
6108:
6109: --}
6110: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED OR
6111: l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN
6112: --{
6113:
6114: IF l_debug_on
6115: THEN

Line 6124: IF (l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN

6120:
6121: select wf_item_key into l_item_key from wsh_trips
6122: where trip_id = p_trip_info_rec.trip_id;
6123:
6124: IF (l_tender_action = FTE_TENDER_PVT.S_REJECTED) THEN
6125: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6126: p_trip_info_rec.trip_id, -- TripId
6127: p_trip_info_rec.trip_name, -- Trip Name
6128: p_trip_info_rec.trip_id, --tender id

Line 6129: FTE_TENDER_PVT.S_REJECTED, -- status

6125: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6126: p_trip_info_rec.trip_id, -- TripId
6127: p_trip_info_rec.trip_name, -- Trip Name
6128: p_trip_info_rec.trip_id, --tender id
6129: FTE_TENDER_PVT.S_REJECTED, -- status
6130: null,-- car_contact_id
6131: null, -- car contact name
6132: null, -- auto_accept
6133: null, -- auto tender

Line 6143: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED) THEN

6139: p_trip_info_rec.remarks,
6140: null,null,null,null,
6141: null,null,
6142: p_trip_info_rec.response_source,null);
6143: ELSIF (l_tender_action = FTE_TENDER_PVT.S_ACCEPTED) THEN
6144: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6145: p_trip_info_rec.trip_id, -- TripId
6146: p_trip_info_rec.trip_name, -- Trip Name
6147: p_trip_info_rec.trip_id, --tender id

Line 6148: FTE_TENDER_PVT.S_ACCEPTED, -- status

6144: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6145: p_trip_info_rec.trip_id, -- TripId
6146: p_trip_info_rec.trip_name, -- Trip Name
6147: p_trip_info_rec.trip_id, --tender id
6148: FTE_TENDER_PVT.S_ACCEPTED, -- status
6149: null,-- car_contact_id
6150: null, -- car contact name
6151: null, -- auto_accept
6152: null, -- auto tender

Line 6169: FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE(

6165: END IF;
6166:
6167:
6168:
6169: FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE(
6170: p_init_msg_list => FND_API.G_FALSE,
6171: x_return_status => l_return_status,
6172: x_msg_count => l_msg_count,
6173: x_msg_data => l_msg_data,

Line 6182: ELSIF (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE) THEN

6178: x_num_warnings =>l_number_of_warnings,
6179: x_num_errors =>l_number_of_errors,
6180: p_msg_data =>l_msg_data);
6181: --}
6182: ELSIF (l_tender_action = FTE_TENDER_PVT.S_NORESPONSE) THEN
6183: --{
6184:
6185: IF l_debug_on
6186: THEN

Line 6199: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_NORESPONSE;

6195: p_trip_info.wf_name := p_trip_info_rec.WF_NAME;
6196: p_trip_info.wf_process_name := p_trip_info_rec.wf_process_name;
6197: p_trip_info.wf_item_key := p_trip_info_rec.wf_item_key;
6198: p_trip_info.load_Tender_number := p_trip_info_rec.tender_id;
6199: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_NORESPONSE;
6200:
6201: p_trip_info_tab(1) :=p_trip_info;
6202: p_trip_in_rec.caller :=G_PKG_NAME;
6203: p_trip_in_rec.phase :=NULL;

Line 6239: ELSIF (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED) THEN

6235: x_num_warnings =>l_number_of_warnings,
6236: x_num_errors =>l_number_of_errors,
6237: p_msg_data =>l_msg_data);
6238:
6239: ELSIF (l_tender_action = FTE_TENDER_PVT.S_AUTO_ACCEPTED) THEN
6240: --{
6241:
6242: IF l_debug_on
6243: THEN

Line 6256: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_AUTO_ACCEPTED;

6252: p_trip_info.wf_name := p_trip_info_rec.WF_NAME;
6253: p_trip_info.wf_process_name := p_trip_info_rec.wf_process_name;
6254: p_trip_info.wf_item_key := p_trip_info_rec.wf_item_key;
6255: p_trip_info.load_Tender_number := p_trip_info_rec.tender_id;
6256: p_trip_info.load_tender_status := FTE_TENDER_PVT.S_AUTO_ACCEPTED;
6257:
6258: p_trip_info_tab(1) :=p_trip_info;
6259: p_trip_in_rec.caller :=G_PKG_NAME;
6260: p_trip_in_rec.phase :=NULL;

Line 6296: ELSIF (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED) THEN

6292: x_num_warnings =>l_number_of_warnings,
6293: x_num_errors =>l_number_of_errors,
6294: p_msg_data =>l_msg_data);
6295:
6296: ELSIF (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_CANCELLED) THEN
6297: --{
6298:
6299: IF l_debug_on
6300: THEN

Line 6313: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status

6309: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6310: p_trip_info_rec.trip_id, -- TripId
6311: p_trip_info_rec.trip_name, -- Trip Name
6312: p_trip_info_rec.trip_id, --tender id
6313: FTE_TENDER_PVT.S_SHIPPER_CANCELLED, -- status
6314: null,-- car_contact_id
6315: null, -- car contact name
6316: null, -- auto_accept
6317: null, -- auto tender

Line 6328: FTE_TENDER_PVT.HANDLE_CANCEL_TENDER(

6324: null,null,null,null,
6325: null,null,
6326: p_trip_info_rec.response_source,null);
6327:
6328: FTE_TENDER_PVT.HANDLE_CANCEL_TENDER(
6329: p_init_msg_list => FND_API.G_FALSE,
6330: x_return_status => l_return_status,
6331: x_msg_count => l_msg_count,
6332: x_msg_data => l_msg_data,

Line 6342: ELSIF (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED) THEN

6338: x_num_errors =>l_number_of_errors,
6339: p_msg_data =>l_msg_data);
6340:
6341: --}
6342: ELSIF (l_tender_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED) THEN
6343: --{
6344:
6345: IF l_debug_on
6346: THEN

Line 6359: FTE_TENDER_PVT.S_SHIPPER_UPDATED, -- status

6355: l_trip_info_rec := FTE_TENDER_ATTR_REC(
6356: p_trip_info_rec.trip_id, -- TripId
6357: p_trip_info_rec.trip_name, -- Trip Name
6358: p_trip_info_rec.trip_id, --tender id
6359: FTE_TENDER_PVT.S_SHIPPER_UPDATED, -- status
6360: null,-- car_contact_id
6361: null, -- car contact name
6362: null, -- auto_accept
6363: null, -- auto tender

Line 6375: FTE_TENDER_PVT.HANDLE_UPDATE_TENDER(

6371: null,null,
6372: null,null);
6373:
6374:
6375: FTE_TENDER_PVT.HANDLE_UPDATE_TENDER(
6376: p_init_msg_list => FND_API.G_FALSE,
6377: x_return_status => l_return_status,
6378: x_msg_count => l_msg_count,
6379: x_msg_data => l_msg_data,

Line 6530: IF p_action_prms.action_code = FTE_TENDER_PVT.S_TENDERED THEN

6526: WSH_DEBUG_SV.logmsg(l_module_name,' Action to be performed ' || p_action_prms.action_code);
6527: END IF;
6528:
6529:
6530: IF p_action_prms.action_code = FTE_TENDER_PVT.S_TENDERED THEN
6531: --{
6532: l_trip_id_tab := FTE_ID_TAB_TYPE();
6533: l_trip_id_tab.EXTEND;
6534: l_trip_id_tab(l_trip_id_tab.COUNT) := p_tripId;