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

Line 152: IF P_TENDER_STATUS NOT IN (FTE_TENDER_PVT.S_ACCEPTED,FTE_TENDER_PVT.S_REJECTED) THEN

148:
149: ---------------------------------------------
150: -- Check for Load Tender Status
151: ---------------------------------------------
152: IF P_TENDER_STATUS NOT IN (FTE_TENDER_PVT.S_ACCEPTED,FTE_TENDER_PVT.S_REJECTED) THEN
153:
154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
155:
156: FTE_FPA_UTIL.LOG_FAILURE_REASON(

Line 636: avalue => FTE_TENDER_PVT.S_TENDERED);

632:
633: wf_engine.SetItemAttrText(itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'TENDER_STATUS',
636: avalue => FTE_TENDER_PVT.S_TENDERED);
637:
638:
639: wf_engine.SetItemAttrNumber(itemtype => itemtype,
640: itemkey => itemkey,

Line 908: IF p_tender_status = FTE_TENDER_PVT.S_ACCEPTED THEN

904:
905: WSH_DEBUG_SV.log(l_module_name,' ************ Parameters ********************* ');
906: WSH_DEBUG_SV.log(l_module_name,' p_tender_status ',p_tender_status);
907:
908: IF p_tender_status = FTE_TENDER_PVT.S_ACCEPTED THEN
909: l_tender_process := 'TENDER_ACCEPT_PROCESS';
910: ELSIF p_tender_status = FTE_TENDER_PVT.S_REJECTED THEN
911: l_tender_process := 'TENDER_REJECT_PROCESS';
912: END IF;

Line 910: ELSIF p_tender_status = FTE_TENDER_PVT.S_REJECTED THEN

906: WSH_DEBUG_SV.log(l_module_name,' p_tender_status ',p_tender_status);
907:
908: IF p_tender_status = FTE_TENDER_PVT.S_ACCEPTED THEN
909: l_tender_process := 'TENDER_ACCEPT_PROCESS';
910: ELSIF p_tender_status = FTE_TENDER_PVT.S_REJECTED THEN
911: l_tender_process := 'TENDER_REJECT_PROCESS';
912: END IF;
913:
914: WSH_DEBUG_SV.log(l_module_name,' l_tender_process ',l_tender_process);

Line 937: FTE_TENDER_PVT.S_SOURCE_XML,

933: p_vehicle_number,
934: p_operator,
935: p_carrier_ref_number,
936: null,
937: FTE_TENDER_PVT.S_SOURCE_XML,
938: null);
939:
940: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,p_tender_status,
941: 204,null,null,null,null,null,

Line 1094: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR

1090: WSH_DEBUG_SV.C_PROC_LEVEL);
1091: END IF;
1092:
1093:
1094: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR
1095: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)
1096: THEN
1097: RETURN; -- We already have response.
1098: END IF;

Line 1095: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)

1091: END IF;
1092:
1093:
1094: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR
1095: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)
1096: THEN
1097: RETURN; -- We already have response.
1098: END IF;
1099:

Line 1107: l_tender_status := FTE_TENDER_PVT.S_ACCEPTED;

1103: -- TBD
1104: l_trip_id := l_tender_id;
1105: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');
1106:
1107: l_tender_status := FTE_TENDER_PVT.S_ACCEPTED;
1108: l_initial_pickup_date := wf_engine.GetItemAttrDate(itemtype,itemkey,'INITIAL_PICKUP_DATE');
1109: l_ultimate_dropoff_date := wf_engine.GetItemAttrDate(itemtype,itemkey,'ULTIMATE_DROPOFF_DATE');
1110: --l_carrier_reference_number := wf_engine.GetItemAttrText(itemtype,itemkey,'Z_CARRIER_REFERENCE_NUMBER');
1111: l_vehicle_number := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_NUMBER');

Line 1118: FTE_TENDER_PVT.S_ACCEPTED, -- status

1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1115: l_trip_id, -- TripId
1116: null, -- Trip Name
1117: l_tender_id, --tender id
1118: FTE_TENDER_PVT.S_ACCEPTED, -- status
1119: null,-- car_contact_id
1120: null, -- car contact name
1121: null, -- auto_accept
1122: null, -- auto tender

Line 1135: FTE_TENDER_PVT.S_SOURCE_WL,

1131: l_vehicle_number,
1132: l_operator,
1133: l_carrier_reference_number,
1134: null,
1135: FTE_TENDER_PVT.S_SOURCE_WL,
1136: null);
1137:
1138: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_ACCEPTED,
1139: null,null,null,null,null,null,

Line 1138: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_ACCEPTED,

1134: null,
1135: FTE_TENDER_PVT.S_SOURCE_WL,
1136: null);
1137:
1138: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_ACCEPTED,
1139: null,null,null,null,null,null,
1140: null,null,null,null,null,null,
1141: null,null);
1142:

Line 1262: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR

1258: IF (funcmode = 'RUN') THEN
1259:
1260: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1261:
1262: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR
1263: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)
1264: THEN
1265: RETURN; -- We already have response.
1266: END IF;

Line 1263: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)

1259:
1260: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1261:
1262: IF (l_responseSource = FTE_TENDER_PVT.S_SOURCE_CP OR
1263: l_responseSource = FTE_TENDER_PVT.S_SOURCE_XML)
1264: THEN
1265: RETURN; -- We already have response.
1266: END IF;
1267:

Line 1280: FTE_TENDER_PVT.S_REJECTED, -- status

1276: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1277: l_trip_id, -- TripId
1278: null, -- Trip Name
1279: l_tender_id, --tender id
1280: FTE_TENDER_PVT.S_REJECTED, -- status
1281: null,-- car_contact_id
1282: null, -- car contact name
1283: null, -- auto_accept
1284: null, -- auto tender

Line 1297: FTE_TENDER_PVT.S_SOURCE_WL,

1293: null,
1294: null,
1295: null,
1296: null,
1297: FTE_TENDER_PVT.S_SOURCE_WL,
1298: null);
1299:
1300: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_REJECTED,
1301: 204,null,null,null,null,null,

Line 1300: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_REJECTED,

1296: null,
1297: FTE_TENDER_PVT.S_SOURCE_WL,
1298: null);
1299:
1300: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_REJECTED,
1301: 204,null,null,null,null,null,
1302: null,null,null,null,null,null,
1303: null,null);
1304:

Line 1417: avalue => FTE_TENDER_PVT.S_SHIPPER_UPDATED);

1413:
1414: wf_engine.SetItemAttrText(itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'TENDER_STATUS',
1417: avalue => FTE_TENDER_PVT.S_SHIPPER_UPDATED);
1418:
1419: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(itemtype,
1420: itemkey,'SHIPPER_NAME'));
1421:

Line 2023: avalue => FTE_TENDER_PVT.S_NORESPONSE);

2019:
2020: wf_engine.SetItemAttrText(itemtype => itemtype,
2021: itemkey => itemkey,
2022: aname => 'TENDER_STATUS',
2023: avalue => FTE_TENDER_PVT.S_NORESPONSE);
2024:
2025: -- Rel12 Coding ....
2026: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2027: itemkey => itemkey,

Line 2056: FTE_TENDER_PVT.S_NORESPONSE, -- status

2052: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2053: l_trip_id, -- TripId
2054: null, -- Trip Name
2055: l_tender_id, --tender id
2056: FTE_TENDER_PVT.S_NORESPONSE, -- status
2057: null,-- car_contact_id
2058: null, -- car contact name
2059: null, -- auto_accept
2060: null, -- auto tender

Line 2068: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_NORESPONSE,

2064: 'TENDER_NORESPONSE_PROCESS', -- wf process name
2065: itemkey, --wf item key
2066: null,null,null,null,null,null,null,null,null);
2067:
2068: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_NORESPONSE,
2069: null,null,null,null,null,null,
2070: null,null,null,null,null,null,
2071: null,null);
2072:

Line 2196: avalue => FTE_TENDER_PVT.S_AUTO_ACCEPTED);

2192:
2193: wf_engine.SetItemAttrText(itemtype => itemtype,
2194: itemkey => itemkey,
2195: aname => 'TENDER_STATUS',
2196: avalue => FTE_TENDER_PVT.S_AUTO_ACCEPTED);
2197:
2198: -- Rel12 Coding ....
2199: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2200: itemkey => itemkey,

Line 2224: FTE_TENDER_PVT.S_AUTO_ACCEPTED, -- status

2220: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
2221: l_trip_id, -- TripId
2222: null, -- Trip Name
2223: l_tender_id, --tender id
2224: FTE_TENDER_PVT.S_AUTO_ACCEPTED, -- status
2225: null,-- car_contact_id
2226: null, -- car contact name
2227: null, -- auto_accept
2228: null, -- auto tender

Line 2236: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_AUTO_ACCEPTED,

2232: 'AUTO_ACCEPT_PROCESS', -- wf process name
2233: itemkey, --wf item key
2234: null,null,null,null,null,null,null,null,null);
2235:
2236: trip_action_param := FTE_TRIP_ACTION_PARAM_REC(null,FTE_TENDER_PVT.S_AUTO_ACCEPTED,
2237: 204,null,null,null,null,null,
2238: null,null,null,null,null,null,
2239: null,null);
2240:

Line 2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR

2715: WSH_DEBUG_SV.logmsg(l_module_name,' TEnder status ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717:
2718:
2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR
2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR
2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR
2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)

Line 2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR

2716: END IF;
2717:
2718:
2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR
2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR
2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR
2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2724: THEN

Line 2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR

2717:
2718:
2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR
2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR
2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR
2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2724: THEN
2725: l_delivery_leg_activity_rec.action_by :=

Line 2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR

2718:
2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR
2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR
2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR
2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2724: THEN
2725: l_delivery_leg_activity_rec.action_by :=
2726: wf_engine.GetItemAttrNumber(itemtype,itemkey,'SHIPPER_USER_ID');

Line 2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)

2719: IF (l_tender_status = FTE_TENDER_PVT.S_TENDERED OR
2720: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_CANCELLED OR
2721: l_tender_status = FTE_TENDER_PVT.S_AUTO_ACCEPTED OR
2722: l_tender_status = FTE_TENDER_PVT.S_NORESPONSE OR
2723: l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2724: THEN
2725: l_delivery_leg_activity_rec.action_by :=
2726: wf_engine.GetItemAttrNumber(itemtype,itemkey,'SHIPPER_USER_ID');
2727: l_delivery_leg_activity_rec.action_by_name :=

Line 2741: IF (l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)

2737: END IF;
2738:
2739: -- For shipper update item key is different. so we have to get the original
2740: -- tender wf item key.
2741: IF (l_tender_status = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
2742: THEN
2743: SELECT WF_ITEM_KEY INTO l_delivery_leg_activity_rec.wf_item_key
2744: FROM WSH_TRIPS
2745: WHERE TRIP_ID = l_trip_id;