APPS.FTE_TENDER_WF dependencies on WF_ENGINE

Line 226: X_SHIPPER_NAME := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'SHIPPER_NAME');

222:
223: BEGIN
224:
225:
226: X_SHIPPER_NAME := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'SHIPPER_NAME');
227:
228: X_TENDERED_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'TENDERED_DATE');
229:
230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');

Line 228: X_TENDERED_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'TENDERED_DATE');

224:
225:
226: X_SHIPPER_NAME := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'SHIPPER_NAME');
227:
228: X_TENDERED_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'TENDERED_DATE');
229:
230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');
231:
232: X_VEHICLE_TYPE := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_TYPE');

Line 230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');

226: X_SHIPPER_NAME := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'SHIPPER_NAME');
227:
228: X_TENDERED_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'TENDERED_DATE');
229:
230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');
231:
232: X_VEHICLE_TYPE := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_TYPE');
233:
234: X_VEHICLE_CLASS := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_CLASS');

Line 232: X_VEHICLE_TYPE := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_TYPE');

228: X_TENDERED_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'TENDERED_DATE');
229:
230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');
231:
232: X_VEHICLE_TYPE := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_TYPE');
233:
234: X_VEHICLE_CLASS := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_CLASS');
235:
236:

Line 234: X_VEHICLE_CLASS := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_CLASS');

230: X_RESPOND_BY_DATE := wf_engine.GetItemAttrDate(P_ITEM_TYPE,P_ITEM_KEY,'RESPOND_BY_DATE');
231:
232: X_VEHICLE_TYPE := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_TYPE');
233:
234: X_VEHICLE_CLASS := wf_engine.GetItemAttrText(P_ITEM_TYPE,P_ITEM_KEY,'VEHICLE_CLASS');
235:
236:
237:
238: END GET_ITEM_INFO;

Line 508: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

504: WSH_DEBUG_SV.logmsg(l_module_name,'Getting Trip id, tender id, shipper name ',WSH_DEBUG_SV.C_PROC_LEVEL);
505: END IF;
506:
507:
508: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
509: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
510: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
511:
512:

Line 509: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');

505: END IF;
506:
507:
508: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
509: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
510: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
511:
512:
513: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN

Line 510: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');

506:
507:
508: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
509: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
510: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
511:
512:
513: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN
514: RAISE no_data_found;

Line 524: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

520: IF l_debug_on THEN
521: WSH_DEBUG_SV.logmsg(l_module_name,'Item key' || itemkey,WSH_DEBUG_SV.C_PROC_LEVEL);
522: END IF;
523:
524: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
525:
526: --l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
527: l_trip_id := l_tender_id;
528:

Line 526: --l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

522: END IF;
523:
524: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
525:
526: --l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
527: l_trip_id := l_tender_id;
528:
529:
530: IF l_debug_on THEN

Line 534: l_shipper_name := wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');

530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'After getting trip id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);
532: END IF;
533:
534: l_shipper_name := wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
535:
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.logmsg(l_module_name,'After Getting Trip id, tender id, shipper name ' ||
538: l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 621: wf_engine.SetItemOwner(itemtype,itemkey,l_shipper_name);

617: ------------------------------------------------------------------
618: -- Samuthuk [ workflow Notifications std ]
619: ------------------------------------------------------------------
620:
621: wf_engine.SetItemOwner(itemtype,itemkey,l_shipper_name);
622:
623:
624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'Setting tender id',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 628: wf_engine.SetItemAttrText(itemtype => itemtype,

624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'Setting tender id',WSH_DEBUG_SV.C_PROC_LEVEL);
626: END IF;
627:
628: wf_engine.SetItemAttrText(itemtype => itemtype,
629: itemkey => itemkey,
630: aname => 'TENDER_TEXT_ID',
631: avalue => to_char(l_tender_id));
632:

Line 633: wf_engine.SetItemAttrText(itemtype => itemtype,

629: itemkey => itemkey,
630: aname => 'TENDER_TEXT_ID',
631: avalue => to_char(l_tender_id));
632:
633: wf_engine.SetItemAttrText(itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'TENDER_STATUS',
636: avalue => FTE_TENDER_PVT.S_TENDERED);
637:

Line 639: wf_engine.SetItemAttrNumber(itemtype => itemtype,

635: aname => 'TENDER_STATUS',
636: avalue => FTE_TENDER_PVT.S_TENDERED);
637:
638:
639: wf_engine.SetItemAttrNumber(itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'CARRIER_ID',
642: avalue => l_carrier_id);
643:

Line 644: wf_engine.SetItemAttrDate(itemtype => itemtype,

640: itemkey => itemkey,
641: aname => 'CARRIER_ID',
642: avalue => l_carrier_id);
643:
644: wf_engine.SetItemAttrDate(itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'RESPOND_BY_DATE',
647: avalue => (l_load_tendered_time+l_shipper_cutoff_time_days));
648:

Line 650: wf_engine.SetItemAttrDate(itemtype => itemtype,

646: aname => 'RESPOND_BY_DATE',
647: avalue => (l_load_tendered_time+l_shipper_cutoff_time_days));
648:
649:
650: wf_engine.SetItemAttrDate(itemtype => itemtype,
651: itemkey => itemkey,
652: aname => 'TENDERED_DATE',
653: avalue => l_load_tendered_time);
654:

Line 655: wf_engine.SetItemAttrNumber(itemtype => itemtype,

651: itemkey => itemkey,
652: aname => 'TENDERED_DATE',
653: avalue => l_load_tendered_time);
654:
655: wf_engine.SetItemAttrNumber(itemtype => itemtype,
656: itemkey => itemkey,
657: aname => 'SHIPPER_CUTOFF_TIME',
658: avalue => l_shipper_cutoff_time);
659:

Line 661: wf_engine.SetItemAttrText(itemtype => itemtype,

657: aname => 'SHIPPER_CUTOFF_TIME',
658: avalue => l_shipper_cutoff_time);
659:
660: --Added by sharvisa
661: wf_engine.SetItemAttrText(itemtype => itemtype,
662: itemkey => itemkey,
663: aname => 'MODE_OF_TRANSPORT',
664: avalue => l_mode_of_transport);
665:

Line 671: wf_engine.SetItemAttrText(itemtype => itemtype,

667: -- Samuthuk [ workflow Notifications std ]
668: ------------------------------------------------------------------
669: l_shipper_wait_time := to_char(l_shipper_wait_time)||':'||l_wait_time_uom;
670:
671: wf_engine.SetItemAttrText(itemtype => itemtype,
672: itemkey => itemkey,
673: aname => 'SHIPPER_WAIT_TIME',
674: avalue => l_shipper_wait_time);
675:

Line 698: wf_engine.SetItemAttrText(itemtype => itemtype,

694: wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
695: END IF;
696:
697:
698: wf_engine.SetItemAttrText(itemtype => itemtype,
699: itemkey => itemkey,
700: aname => 'SHIPPING_ORG_NAME',
701: avalue => l_ship_org_name);
702:

Line 756: wf_engine.SetItemAttrText(itemtype => itemtype,

752: FETCH get_carrier_name into l_carrier_name;
753: close get_carrier_name;
754:
755:
756: wf_engine.SetItemAttrText(itemtype => itemtype,
757: itemkey => itemkey,
758: aname => 'CARRIER_NAME',
759: avalue => l_carrier_name);
760:

Line 761: wf_engine.SetItemAttrText(itemtype => itemtype,

757: itemkey => itemkey,
758: aname => 'CARRIER_NAME',
759: avalue => l_carrier_name);
760:
761: wf_engine.SetItemAttrText(itemtype => itemtype,
762: itemkey => itemkey,
763: aname => 'NOTIF_TYPE',
764: avalue => l_notif_type);
765:

Line 766: wf_engine.SetItemAttrText(itemtype => itemtype,

762: itemkey => itemkey,
763: aname => 'NOTIF_TYPE',
764: avalue => l_notif_type);
765:
766: wf_engine.SetItemAttrText(itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'AUTO_ACCEPT',
769: avalue => l_auto_accept);
770:

Line 772: wf_engine.SetItemAttrNumber(itemtype => itemtype,

768: aname => 'AUTO_ACCEPT',
769: avalue => l_auto_accept);
770:
771: -- Rel 12 Coding....
772: wf_engine.SetItemAttrNumber(itemtype => itemtype,
773: itemkey => itemkey,
774: aname => 'CARRIER_SITE_ID',
775: avalue => l_carrier_site_id);
776:

Line 1086: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');

1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.push(l_module_name);
1084: END IF;
1085:
1086: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');
1087:
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,' Response source ' || l_responseSource,
1090: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1100: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

1096: THEN
1097: RETURN; -- We already have response.
1098: END IF;
1099:
1100: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1101: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1102:
1103: -- TBD
1104: l_trip_id := l_tender_id;

Line 1101: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

1097: RETURN; -- We already have response.
1098: END IF;
1099:
1100: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1101: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1102:
1103: -- TBD
1104: l_trip_id := l_tender_id;
1105: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');

Line 1105: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');

1101: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1102:
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');

Line 1108: l_initial_pickup_date := wf_engine.GetItemAttrDate(itemtype,itemkey,'INITIAL_PICKUP_DATE');

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');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');

Line 1109: l_ultimate_dropoff_date := wf_engine.GetItemAttrDate(itemtype,itemkey,'ULTIMATE_DROPOFF_DATE');

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');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');
1113:

Line 1110: --l_carrier_reference_number := wf_engine.GetItemAttrText(itemtype,itemkey,'Z_CARRIER_REFERENCE_NUMBER');

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');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');
1113:
1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

Line 1111: l_vehicle_number := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_NUMBER');

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');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');
1113:
1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1115: l_trip_id, -- TripId

Line 1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');

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');
1112: l_operator := wf_engine.GetItemAttrText(itemtype,itemkey,'VEHICLE_OPERATOR');
1113:
1114: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1115: l_trip_id, -- TripId
1116: null, -- Trip Name

Line 1260: l_responseSource := wf_engine.GetItemAttrText(itemtype,itemkey,'RESPONSE_SOURCE');

1256: BEGIN
1257:
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

Line 1269: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

1265: RETURN; -- We already have response.
1266: END IF;
1267:
1268:
1269: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1270: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1271:
1272: -- TBD
1273: l_trip_id := l_tender_id;

Line 1270: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

1266: END IF;
1267:
1268:
1269: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1270: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1271:
1272: -- TBD
1273: l_trip_id := l_tender_id;
1274: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');

Line 1274: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');

1270: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1271:
1272: -- TBD
1273: l_trip_id := l_tender_id;
1274: l_carrier_response := wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_RESPONSE');
1275:
1276: l_tender_attr_rec := FTE_TENDER_ATTR_REC(
1277: l_trip_id, -- TripId
1278: null, -- Trip Name

Line 1414: wf_engine.SetItemAttrText(itemtype => itemtype,

1410: -- based on the tender id
1411: -- Get the tender id first
1412:
1413:
1414: wf_engine.SetItemAttrText(itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'TENDER_STATUS',
1417: avalue => FTE_TENDER_PVT.S_SHIPPER_UPDATED);
1418:

Line 1419: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(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:
1422:
1423: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

Line 1423: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

1419: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(itemtype,
1420: itemkey,'SHIPPER_NAME'));
1421:
1422:
1423: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1424: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1425: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1426:
1427:

Line 1424: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');

1420: itemkey,'SHIPPER_NAME'));
1421:
1422:
1423: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1424: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1425: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1426:
1427:
1428: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN

Line 1425: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');

1421:
1422:
1423: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1424: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1425: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1426:
1427:
1428: IF(l_respAppId IS NULL OR l_respId IS NULL) THEN
1429: RAISE no_data_found;

Line 1543: l_tender_action := wf_engine.getItemAttrText(itemtype, itemkey, 'TENDER_ACTION');

1539:
1540: END IF;
1541:
1542:
1543: l_tender_action := wf_engine.getItemAttrText(itemtype, itemkey, 'TENDER_ACTION');
1544:
1545: IF l_debug_on THEN
1546: WSH_DEBUG_SV.logmsg(l_api_name,l_tender_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;

Line 1550: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

1546: WSH_DEBUG_SV.logmsg(l_api_name,l_tender_action,WSH_DEBUG_SV.C_PROC_LEVEL);
1547: END IF;
1548:
1549:
1550: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1551: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1552: l_trip_id := l_tender_id;
1553:
1554:

Line 1551: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

1547: END IF;
1548:
1549:
1550: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
1551: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1552: l_trip_id := l_tender_id;
1553:
1554:
1555: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1555: wf_engine.SetItemAttrText(itemtype => itemtype,

1551: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
1552: l_trip_id := l_tender_id;
1553:
1554:
1555: wf_engine.SetItemAttrText(itemtype => itemtype,
1556: itemkey => itemkey,
1557: aname => 'TENDER_TEXT_ID',
1558: avalue => to_char(l_tender_id));
1559:

Line 1561: wf_engine.SetItemAttrText(itemtype => itemtype,

1557: aname => 'TENDER_TEXT_ID',
1558: avalue => to_char(l_tender_id));
1559:
1560:
1561: wf_engine.SetItemAttrText(itemtype => itemtype,
1562: itemkey => itemkey,
1563: aname => 'TENDER_STATUS',
1564: avalue => l_tender_action);
1565:

Line 1566: wf_engine.SetItemAttrText(itemtype => itemtype,

1562: itemkey => itemkey,
1563: aname => 'TENDER_STATUS',
1564: avalue => l_tender_action);
1565:
1566: wf_engine.SetItemAttrText(itemtype => itemtype,
1567: itemkey => itemkey,
1568: aname => 'SHIPPER_NAME',
1569: avalue => wf_engine.GetItemAttrText(
1570: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));

Line 1569: avalue => wf_engine.GetItemAttrText(

1565:
1566: wf_engine.SetItemAttrText(itemtype => itemtype,
1567: itemkey => itemkey,
1568: aname => 'SHIPPER_NAME',
1569: avalue => wf_engine.GetItemAttrText(
1570: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));
1571:
1572: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(
1573: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));

Line 1572: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(

1568: aname => 'SHIPPER_NAME',
1569: avalue => wf_engine.GetItemAttrText(
1570: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));
1571:
1572: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(
1573: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));
1574:
1575: --Addded by sharvisa for R12
1576: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1576: wf_engine.SetItemAttrText(itemtype => itemtype,

1572: wf_engine.SetItemOwner(itemtype,itemkey,wf_engine.GetItemAttrText(
1573: 'FTETEREQ', itemkey, 'SHIPPER_NAME'));
1574:
1575: --Addded by sharvisa for R12
1576: wf_engine.SetItemAttrText(itemtype => itemtype,
1577: itemkey => itemkey,
1578: aname => 'MODE_OF_TRANSPORT',
1579: avalue => wf_engine.GetItemAttrText(
1580: 'FTETEREQ', itemkey, 'MODE_OF_TRANSPORT'));

Line 1579: avalue => wf_engine.GetItemAttrText(

1575: --Addded by sharvisa for R12
1576: wf_engine.SetItemAttrText(itemtype => itemtype,
1577: itemkey => itemkey,
1578: aname => 'MODE_OF_TRANSPORT',
1579: avalue => wf_engine.GetItemAttrText(
1580: 'FTETEREQ', itemkey, 'MODE_OF_TRANSPORT'));
1581:
1582:
1583: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1583: wf_engine.SetItemAttrText(itemtype => itemtype,

1579: avalue => wf_engine.GetItemAttrText(
1580: 'FTETEREQ', itemkey, 'MODE_OF_TRANSPORT'));
1581:
1582:
1583: wf_engine.SetItemAttrText(itemtype => itemtype,
1584: itemkey => itemkey,
1585: aname => 'SHIPPER_WAIT_TIME',
1586: avalue => wf_engine.GetItemAttrText(
1587: 'FTETEREQ', itemkey, 'SHIPPER_WAIT_TIME'));

Line 1586: avalue => wf_engine.GetItemAttrText(

1582:
1583: wf_engine.SetItemAttrText(itemtype => itemtype,
1584: itemkey => itemkey,
1585: aname => 'SHIPPER_WAIT_TIME',
1586: avalue => wf_engine.GetItemAttrText(
1587: 'FTETEREQ', itemkey, 'SHIPPER_WAIT_TIME'));
1588:
1589:
1590: wf_engine.SetItemAttrDate(itemtype => itemtype,

Line 1590: wf_engine.SetItemAttrDate(itemtype => itemtype,

1586: avalue => wf_engine.GetItemAttrText(
1587: 'FTETEREQ', itemkey, 'SHIPPER_WAIT_TIME'));
1588:
1589:
1590: wf_engine.SetItemAttrDate(itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'TENDERED_DATE',
1593: avalue => wf_engine.GetItemAttrDate(
1594: 'FTETEREQ', itemkey, 'TENDERED_DATE'));

Line 1593: avalue => wf_engine.GetItemAttrDate(

1589:
1590: wf_engine.SetItemAttrDate(itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'TENDERED_DATE',
1593: avalue => wf_engine.GetItemAttrDate(
1594: 'FTETEREQ', itemkey, 'TENDERED_DATE'));
1595:
1596: wf_engine.SetItemAttrText(itemtype => itemtype,
1597: itemkey => itemkey,

Line 1596: wf_engine.SetItemAttrText(itemtype => itemtype,

1592: aname => 'TENDERED_DATE',
1593: avalue => wf_engine.GetItemAttrDate(
1594: 'FTETEREQ', itemkey, 'TENDERED_DATE'));
1595:
1596: wf_engine.SetItemAttrText(itemtype => itemtype,
1597: itemkey => itemkey,
1598: aname => 'MBOL_NUM',
1599: avalue => wf_engine.GetItemAttrText(
1600: 'FTETEREQ', itemkey, 'MBOL_NUM'));

Line 1599: avalue => wf_engine.GetItemAttrText(

1595:
1596: wf_engine.SetItemAttrText(itemtype => itemtype,
1597: itemkey => itemkey,
1598: aname => 'MBOL_NUM',
1599: avalue => wf_engine.GetItemAttrText(
1600: 'FTETEREQ', itemkey, 'MBOL_NUM'));
1601:
1602:
1603: -- Rel12 Coding ....

Line 1604: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1600: 'FTETEREQ', itemkey, 'MBOL_NUM'));
1601:
1602:
1603: -- Rel12 Coding ....
1604: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'CARRIER_SITE_ID',
1607: avalue => wf_engine.GetItemAttrNumber(
1608: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));

Line 1607: avalue => wf_engine.GetItemAttrNumber(

1603: -- Rel12 Coding ....
1604: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'CARRIER_SITE_ID',
1607: avalue => wf_engine.GetItemAttrNumber(
1608: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
1609:
1610: wf_engine.SetItemAttrText(itemtype => itemtype,
1611: itemkey => itemkey,

Line 1610: wf_engine.SetItemAttrText(itemtype => itemtype,

1606: aname => 'CARRIER_SITE_ID',
1607: avalue => wf_engine.GetItemAttrNumber(
1608: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
1609:
1610: wf_engine.SetItemAttrText(itemtype => itemtype,
1611: itemkey => itemkey,
1612: aname => 'CONTACT_PERFORMER',
1613: avalue => wf_engine.GetItemAttrText(
1614: 'FTETEREQ', itemkey, 'CONTACT_PERFORMER'));

Line 1613: avalue => wf_engine.GetItemAttrText(

1609:
1610: wf_engine.SetItemAttrText(itemtype => itemtype,
1611: itemkey => itemkey,
1612: aname => 'CONTACT_PERFORMER',
1613: avalue => wf_engine.GetItemAttrText(
1614: 'FTETEREQ', itemkey, 'CONTACT_PERFORMER'));
1615:
1616: wf_engine.SetItemAttrText(itemtype => itemtype,
1617: itemkey => itemkey,

Line 1616: wf_engine.SetItemAttrText(itemtype => itemtype,

1612: aname => 'CONTACT_PERFORMER',
1613: avalue => wf_engine.GetItemAttrText(
1614: 'FTETEREQ', itemkey, 'CONTACT_PERFORMER'));
1615:
1616: wf_engine.SetItemAttrText(itemtype => itemtype,
1617: itemkey => itemkey,
1618: aname => 'SHIPPING_ORG_NAME',
1619: avalue => wf_engine.GetItemAttrText(
1620: 'FTETEREQ', itemkey, 'SHIPPING_ORG_NAME'));

Line 1619: avalue => wf_engine.GetItemAttrText(

1615:
1616: wf_engine.SetItemAttrText(itemtype => itemtype,
1617: itemkey => itemkey,
1618: aname => 'SHIPPING_ORG_NAME',
1619: avalue => wf_engine.GetItemAttrText(
1620: 'FTETEREQ', itemkey, 'SHIPPING_ORG_NAME'));
1621:
1622:
1623: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 1623: wf_engine.SetItemAttrText(itemtype => itemtype,

1619: avalue => wf_engine.GetItemAttrText(
1620: 'FTETEREQ', itemkey, 'SHIPPING_ORG_NAME'));
1621:
1622:
1623: wf_engine.SetItemAttrText(itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'CARRIER_NAME',
1626: avalue => wf_engine.GetItemAttrText(
1627: 'FTETEREQ', itemkey, 'CARRIER_NAME'));

Line 1626: avalue => wf_engine.GetItemAttrText(

1622:
1623: wf_engine.SetItemAttrText(itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'CARRIER_NAME',
1626: avalue => wf_engine.GetItemAttrText(
1627: 'FTETEREQ', itemkey, 'CARRIER_NAME'));
1628:
1629: -- Initialize fnd context.
1630:

Line 1631: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

1627: 'FTETEREQ', itemkey, 'CARRIER_NAME'));
1628:
1629: -- Initialize fnd context.
1630:
1631: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1632: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1634:
1635: IF l_debug_on THEN

Line 1632: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');

1628:
1629: -- Initialize fnd context.
1630:
1631: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1632: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1634:
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

Line 1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');

1629: -- Initialize fnd context.
1630:
1631: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
1632: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
1633: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
1634:
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
1637: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1734: l_is_modified := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_MODIFIED');

1730: --
1731: -- Call API to get the value of the wf status
1732: --
1733:
1734: l_is_modified := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_MODIFIED');
1735:
1736: IF (l_is_modified = 'YES') THEN
1737: resultout := 'COMPLETE:Y';
1738: return;

Line 1887: l_max_reminder := wf_engine.GetItemAttrNumber(

1883: p_item_key => itemkey,
1884: p_aname => 'CYCLE_COUNTER'
1885: );
1886:
1887: l_max_reminder := wf_engine.GetItemAttrNumber(
1888: itemtype => itemtype,
1889: itemkey => itemkey,
1890: aname => 'MAX_NO_REMINDER'
1891: );

Line 1893: l_reminder_time := wf_engine.GetItemAttrNumber(

1889: itemkey => itemkey,
1890: aname => 'MAX_NO_REMINDER'
1891: );
1892:
1893: l_reminder_time := wf_engine.GetItemAttrNumber(
1894: itemtype => itemtype,
1895: itemkey => itemkey,
1896: aname => 'REMINDER_WAIT_TIME'
1897: );

Line 1900: l_tender_block_time := wf_engine.GetItemAttrNumber(

1896: aname => 'REMINDER_WAIT_TIME'
1897: );
1898:
1899: -- wait time to expire load tender request.
1900: l_tender_block_time := wf_engine.GetItemAttrNumber(
1901: itemtype => itemtype,
1902: itemkey => itemkey,
1903: aname => 'SHIPPER_CUTOFF_TIME'
1904: );

Line 1919: wf_engine.SetItemAttrNumber(

1915: -- tender block time
1916: l_tender_block_time := l_tender_block_time - l_reminder_time;
1917: END IF;
1918:
1919: wf_engine.SetItemAttrNumber(
1920: itemtype => itemtype,
1921: itemkey => itemkey,
1922: aname => 'SHIPPER_CUTOFF_TIME',
1923: avalue => l_tender_block_time

Line 2010: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

2006: --
2007: IF (funcmode = 'RUN') THEN
2008: --
2009:
2010: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
2011: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2012: l_trip_id := l_tender_id;
2013:
2014: IF l_debug_on THEN

Line 2011: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

2007: IF (funcmode = 'RUN') THEN
2008: --
2009:
2010: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
2011: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2012: l_trip_id := l_tender_id;
2013:
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2020: wf_engine.SetItemAttrText(itemtype => itemtype,

2016: WSH_DEBUG_SV.logmsg(l_module_name,' Tender Id' || l_tender_id,WSH_DEBUG_SV.C_PROC_LEVEL);
2017: END IF;
2018:
2019:
2020: wf_engine.SetItemAttrText(itemtype => itemtype,
2021: itemkey => itemkey,
2022: aname => 'TENDER_STATUS',
2023: avalue => FTE_TENDER_PVT.S_NORESPONSE);
2024:

Line 2026: wf_engine.SetItemAttrNumber(itemtype => itemtype,

2022: aname => 'TENDER_STATUS',
2023: avalue => FTE_TENDER_PVT.S_NORESPONSE);
2024:
2025: -- Rel12 Coding ....
2026: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'CARRIER_SITE_ID',
2029: avalue => wf_engine.GetItemAttrNumber(
2030: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));

Line 2029: avalue => wf_engine.GetItemAttrNumber(

2025: -- Rel12 Coding ....
2026: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'CARRIER_SITE_ID',
2029: avalue => wf_engine.GetItemAttrNumber(
2030: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
2031:
2032: -- INITIALIZE_ APPS CONTEXT
2033:

Line 2034: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');

2030: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
2031:
2032: -- INITIALIZE_ APPS CONTEXT
2033:
2034: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
2035: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
2037:
2038: IF l_debug_on THEN

Line 2035: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');

2031:
2032: -- INITIALIZE_ APPS CONTEXT
2033:
2034: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
2035: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
2037:
2038: IF l_debug_on THEN
2039: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

Line 2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');

2032: -- INITIALIZE_ APPS CONTEXT
2033:
2034: l_userId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'USER_ID');
2035: l_respAppId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey, 'RESP_APPL_ID');
2036: l_respId := wf_engine.GetItemAttrNumber('FTETEREQ',itemKey,'RESPONSIBILITY_ID');
2037:
2038: IF l_debug_on THEN
2039: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
2040: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2193: wf_engine.SetItemAttrText(itemtype => itemtype,

2189: IF (funcmode = 'RUN') THEN
2190: --
2191:
2192:
2193: wf_engine.SetItemAttrText(itemtype => itemtype,
2194: itemkey => itemkey,
2195: aname => 'TENDER_STATUS',
2196: avalue => FTE_TENDER_PVT.S_AUTO_ACCEPTED);
2197:

Line 2199: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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,
2201: aname => 'CARRIER_SITE_ID',
2202: avalue => wf_engine.GetItemAttrNumber(
2203: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));

Line 2202: avalue => wf_engine.GetItemAttrNumber(

2198: -- Rel12 Coding ....
2199: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2200: itemkey => itemkey,
2201: aname => 'CARRIER_SITE_ID',
2202: avalue => wf_engine.GetItemAttrNumber(
2203: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
2204:
2205: wf_engine.SetItemAttrText(itemtype => itemtype,
2206: itemkey => itemkey,

Line 2205: wf_engine.SetItemAttrText(itemtype => itemtype,

2201: aname => 'CARRIER_SITE_ID',
2202: avalue => wf_engine.GetItemAttrNumber(
2203: 'FTETEREQ', itemkey, 'CARRIER_SITE_ID'));
2204:
2205: wf_engine.SetItemAttrText(itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'CARRIER_NAME',
2208: avalue => wf_engine.GetItemAttrText(
2209: 'FTETEREQ', itemkey, 'CARRIER_NAME'));

Line 2208: avalue => wf_engine.GetItemAttrText(

2204:
2205: wf_engine.SetItemAttrText(itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'CARRIER_NAME',
2208: avalue => wf_engine.GetItemAttrText(
2209: 'FTETEREQ', itemkey, 'CARRIER_NAME'));
2210:
2211: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2212: l_number_of_warnings := 0;

Line 2215: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

2211: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2212: l_number_of_warnings := 0;
2213: l_number_of_errors := 0;
2214:
2215: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
2216: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2217: l_trip_id := l_tender_id;
2218:
2219:

Line 2216: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

2212: l_number_of_warnings := 0;
2213: l_number_of_errors := 0;
2214:
2215: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');
2216: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2217: l_trip_id := l_tender_id;
2218:
2219:
2220: l_tender_attr_rec := FTE_TENDER_ATTR_REC(

Line 2335: l_autoAccept := wf_engine.GetItemAttrText(itemtype,itemkey,'AUTO_ACCEPT');

2331: --
2332: IF (funcmode = 'RUN') THEN
2333: --
2334:
2335: l_autoAccept := wf_engine.GetItemAttrText(itemtype,itemkey,'AUTO_ACCEPT');
2336:
2337: IF (l_autoAccept = 'Y')
2338: THEN
2339: resultout := 'COMPLETE:Y';

Line 2614: l_notif_type := wf_engine.GetItemAttrText('FTETEUPD',itemkey,'NOTIF_TYPE');

2610: --
2611: IF (funcmode = 'RUN') THEN
2612: --
2613: IF (itemtype ='FTETEUPD') THEN
2614: l_notif_type := wf_engine.GetItemAttrText('FTETEUPD',itemkey,'NOTIF_TYPE');
2615: ELSE
2616: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ',itemkey,'NOTIF_TYPE');
2617: END IF ;
2618:

Line 2616: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ',itemkey,'NOTIF_TYPE');

2612: --
2613: IF (itemtype ='FTETEUPD') THEN
2614: l_notif_type := wf_engine.GetItemAttrText('FTETEUPD',itemkey,'NOTIF_TYPE');
2615: ELSE
2616: l_notif_type := wf_engine.GetItemAttrText('FTETEREQ',itemkey,'NOTIF_TYPE');
2617: END IF ;
2618:
2619: IF (l_notif_type IS NULL OR l_notif_type = 'EMAIL')
2620: THEN

Line 2708: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

2704: IF (funcmode = 'RUN') THEN
2705: --
2706:
2707:
2708: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2709: l_tender_status := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_STATUS');
2710: l_rank_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_ID');
2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');
2712:

Line 2709: l_tender_status := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_STATUS');

2705: --
2706:
2707:
2708: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2709: l_tender_status := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_STATUS');
2710: l_rank_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_ID');
2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');
2712:
2713: IF l_debug_on

Line 2710: l_rank_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_ID');

2706:
2707:
2708: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2709: l_tender_status := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_STATUS');
2710: l_rank_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_ID');
2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');
2712:
2713: IF l_debug_on
2714: THEN

Line 2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');

2707:
2708: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2709: l_tender_status := wf_engine.GetItemAttrText(itemtype,itemkey,'TENDER_STATUS');
2710: l_rank_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_ID');
2711: l_rank_version := wf_engine.GetItemAttrNumber(itemtype,itemkey,'RANK_VERSION');
2712:
2713: IF l_debug_on
2714: THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,' TEnder status ' || l_tender_status,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2726: wf_engine.GetItemAttrNumber(itemtype,itemkey,'SHIPPER_USER_ID');

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 :=
2728: wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
2729: ELSE
2730: l_delivery_leg_activity_rec.action_by :=

Line 2728: wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');

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 :=
2728: wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
2729: ELSE
2730: l_delivery_leg_activity_rec.action_by :=
2731: wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTACT_USER_ID');
2732: l_delivery_leg_activity_rec.action_by_name :=

Line 2731: wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTACT_USER_ID');

2727: l_delivery_leg_activity_rec.action_by_name :=
2728: wf_engine.GetItemAttrText(itemtype,itemkey,'SHIPPER_NAME');
2729: ELSE
2730: l_delivery_leg_activity_rec.action_by :=
2731: wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTACT_USER_ID');
2732: l_delivery_leg_activity_rec.action_by_name :=
2733: wf_engine.GetItemAttrText(itemtype,itemkey,'CONTACT_USER_NAME');
2734: l_delivery_leg_activity_rec.remarks :=
2735: wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_REMARKS');

Line 2733: wf_engine.GetItemAttrText(itemtype,itemkey,'CONTACT_USER_NAME');

2729: ELSE
2730: l_delivery_leg_activity_rec.action_by :=
2731: wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTACT_USER_ID');
2732: l_delivery_leg_activity_rec.action_by_name :=
2733: wf_engine.GetItemAttrText(itemtype,itemkey,'CONTACT_USER_NAME');
2734: l_delivery_leg_activity_rec.remarks :=
2735: wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_REMARKS');
2736:
2737: END IF;

Line 2735: wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_REMARKS');

2731: wf_engine.GetItemAttrNumber(itemtype,itemkey,'CONTACT_USER_ID');
2732: l_delivery_leg_activity_rec.action_by_name :=
2733: wf_engine.GetItemAttrText(itemtype,itemkey,'CONTACT_USER_NAME');
2734: l_delivery_leg_activity_rec.remarks :=
2735: wf_engine.GetItemAttrText(itemtype,itemkey,'CARRIER_REMARKS');
2736:
2737: END IF;
2738:
2739: -- For shipper update item key is different. so we have to get the original

Line 2932: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

2928: l_number_of_warnings := 0;
2929: l_number_of_errors := 0;
2930:
2931:
2932: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
2933:
2934: SELECT APPEND_FLAG,ROUTING_RULE_ID INTO l_appendFlag, l_ruleId
2935: FROM WSH_TRIPS
2936: WHERE TRIP_ID = l_trip_id;

Line 3016: wf_engine.SetItemAttrText(itemtype => itemtype,

3012: -- wf_core.TOKEN('ERROR_STRING','Test Error MEssage ');
3013: -- wf_core.RAISE('FTE_WF_ERROR_MESSAGE');
3014:
3015:
3016: wf_engine.SetItemAttrText(itemtype => itemtype,
3017: itemkey => itemkey,
3018: aname => 'PRICE_REQUEST_ID',
3019: avalue => l_rating_request_id);
3020:

Line 3100: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

3096: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3097: l_number_of_warnings := 0;
3098: l_number_of_errors := 0;
3099:
3100: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3101:
3102: IF l_debug_on
3103: THEN
3104: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Id ' || l_trip_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

3220: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3221: l_number_of_warnings := 0;
3222: l_number_of_errors := 0;
3223:
3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3225: l_priceRequestId := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PRICE_REQUEST_ID');
3226:
3227: FTE_CARRIER_RANK_LIST_PVT.REMOVE_SERVICE_APPLY_NEXT(
3228: p_init_msg_list => FND_API.G_TRUE,

Line 3225: l_priceRequestId := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PRICE_REQUEST_ID');

3221: l_number_of_warnings := 0;
3222: l_number_of_errors := 0;
3223:
3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3225: l_priceRequestId := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PRICE_REQUEST_ID');
3226:
3227: FTE_CARRIER_RANK_LIST_PVT.REMOVE_SERVICE_APPLY_NEXT(
3228: p_init_msg_list => FND_API.G_TRUE,
3229: x_return_status => l_return_status,

Line 3325: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

3321: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3322: l_number_of_warnings := 0;
3323: l_number_of_errors := 0;
3324:
3325: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3326:
3327:
3328: SELECT CARRIER_ID INTO l_carrier_id FROM WSH_TRIPS
3329: WHERE TRIP_ID = l_trip_id;

Line 3443: l_userId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'USER_ID');

3439: IF l_debug_on THEN
3440: WSH_DEBUG_SV.push(l_module_name);
3441: END IF;
3442:
3443: l_userId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'USER_ID');
3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');
3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');
3446:
3447: IF l_debug_on THEN

Line 3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');

3440: WSH_DEBUG_SV.push(l_module_name);
3441: END IF;
3442:
3443: l_userId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'USER_ID');
3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');
3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');
3446:
3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||

Line 3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');

3441: END IF;
3442:
3443: l_userId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'USER_ID');
3444: l_respAppId := wf_engine.GetItemAttrNumber(itemtype,itemKey, 'RESP_APPL_ID');
3445: l_respId := wf_engine.GetItemAttrNumber(itemtype,itemKey,'RESPONSIBILITY_ID');
3446:
3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,' Initializing responsiblity information ' ||
3449: l_userId,WSH_DEBUG_SV.C_PROC_LEVEL);