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_TRACKING_WRAPPER dependencies on FTE_DELIVERY_PROOF

Line 11: -- STATUS_HEADERS, FTE_SHIPMENT_STATUS_DETAIL, FTE_DELIVERY_PROOF

7: -- PROCEDURE : populate_child_delivery_legs FTE Tracking wrapper
8: --
9: -- COMMENT : Populate the child legs when Tracking information is
10: -- sent for the parent_delivery i.e Populate FTE_SHIPMENT_
11: -- STATUS_HEADERS, FTE_SHIPMENT_STATUS_DETAIL, FTE_DELIVERY_PROOF
12: --========================================================================
13:
14: PROCEDURE populate_child_delivery_legs
15: (

Line 199: insert into fte_delivery_proof(

195: END ;
196: -- Insert into delivery proof table
197: BEGIN
198: select fte_tracking_status_s.nextval into l_content_pod_id from dual;
199: insert into fte_delivery_proof(
200: ID,
201: TRANSACTION_ID,
202: RECEIVED_DATE,
203: --NAME1, -- to fix Bug#5031206

Line 261: FROM fte_delivery_proof WHERE transaction_id = p_transaction_id;

257: STATUS,
258: SHIPMENT_WEIGHT,
259: SHIPMENT_VOLUME,
260: LOCATION
261: FROM fte_delivery_proof WHERE transaction_id = p_transaction_id;
262: EXCEPTION
263: WHEN OTHERS THEN
264: NULL; --No records in FTE_DELIVERY_PROOF table
265: END ;

Line 264: NULL; --No records in FTE_DELIVERY_PROOF table

260: LOCATION
261: FROM fte_delivery_proof WHERE transaction_id = p_transaction_id;
262: EXCEPTION
263: WHEN OTHERS THEN
264: NULL; --No records in FTE_DELIVERY_PROOF table
265: END ;
266:
267:
268: --Inserting into fte_message partner as per FTEFSSI XGM to content

Line 468: DECODE(location_to_table,'FTE_DELIVERY_PROOF',l_content_pod_id,l_content_details_id),

464: TRANSACTION_ID ,
465: LOCATION_TO_TABLE
466: )
467: SELECT
468: DECODE(location_to_table,'FTE_DELIVERY_PROOF',l_content_pod_id,l_content_details_id),
469: fte_tracking_status_s.nextval,
470: DESCRIPTION ,
471: GEOCOORDINATES ,
472: GEOCOORDINATES_TYPE ,

Line 740: from fte_delivery_proof where transaction_id= l_transaction_id_s;

736:
737: -- To update the recieced date for the last leg of a delivery when POD is received
738: BEGIN
739: select received_date,1 into l_received_date,l_flag
740: from fte_delivery_proof where transaction_id= l_transaction_id_s;
741: EXCEPTION
742: WHEN OTHERS THEN
743: NULL; --No records in FTE_DELIVERY_PROOF table
744: END ;

Line 743: NULL; --No records in FTE_DELIVERY_PROOF table

739: select received_date,1 into l_received_date,l_flag
740: from fte_delivery_proof where transaction_id= l_transaction_id_s;
741: EXCEPTION
742: WHEN OTHERS THEN
743: NULL; --No records in FTE_DELIVERY_PROOF table
744: END ;
745:
746: IF l_flag= 1 THEN
747: FTE_TRACKING_WRAPPER.call_last_delivery_leg(l_delivery_leg_id,l_received_date);

Line 834: -- fte_delivery_proof table using address_to_id as the foreign

830: -- PROCEDURE : Get Location FTE Tracking wrapper
831: --
832: -- COMMENT : Get the city,state and country information from the
833: -- fte_message_address and populate the location cloumn of
834: -- fte_delivery_proof table using address_to_id as the foreign
835: -- key for fte_message_location .
836: --========================================================================
837:
838: FUNCTION GET_LOCATION(p_location_id IN NUMBER)

Line 994: ---- Update fte_shipment_status_header,fte_shipment_status_details and fte_delivery_proof

990: RAISE invalid_carrier;
991: END;
992:
993:
994: ---- Update fte_shipment_status_header,fte_shipment_status_details and fte_delivery_proof
995: -- Based on the tracking id type
996: IF (UPPER(l_tracking_id_type) = 'WAYBILL') THEN
997:
998:

Line 1046: NULL; --No records in FTE_DELIVERY_PROOF table

1042: last_update_login=FND_GLOBAL.USER_ID
1043: WHERE transaction_id = p_transaction_id;
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: NULL; --No records in FTE_DELIVERY_PROOF table
1047: END ;
1048:
1049: BEGIN
1050: --Get the location inforamtion for the POD from the fte_message_address for the location id

Line 1054: and location_to_table = 'FTE_DELIVERY_PROOF';

1050: --Get the location inforamtion for the POD from the fte_message_address for the location id
1051: SELECT id INTO l_location_id
1052: FROM fte_message_location
1053: WHERE transaction_id=p_transaction_id
1054: and location_to_table = 'FTE_DELIVERY_PROOF';
1055: l_address:=get_location(l_location_id);
1056:
1057:
1058: -- Update the POD information

Line 1059: UPDATE fte_delivery_proof

1055: l_address:=get_location(l_location_id);
1056:
1057:
1058: -- Update the POD information
1059: UPDATE fte_delivery_proof
1060: SET creation_date = sysdate,
1061: created_by =FND_GLOBAL.USER_ID,
1062: last_update_date=sysdate,
1063: last_updated_by =FND_GLOBAL.USER_ID,

Line 1070: NULL; --No records in FTE_DELIVERY_PROOF table

1066: WHERE transaction_id= p_transaction_id;
1067:
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: NULL; --No records in FTE_DELIVERY_PROOF table
1071: END ;
1072:
1073:
1074:

Line 1138: NULL; --No records in FTE_DELIVERY_PROOF table

1134: last_update_login=FND_GLOBAL.USER_ID
1135: where transaction_id = p_transaction_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: NULL; --No records in FTE_DELIVERY_PROOF table
1139: END ;
1140:
1141: BEGIN
1142: --Get the location inforamtion for the POD from the fte_message_address for the location id

Line 1146: and location_to_table = 'FTE_DELIVERY_PROOF';

1142: --Get the location inforamtion for the POD from the fte_message_address for the location id
1143: select id into l_location_id
1144: from fte_message_location
1145: where transaction_id=p_transaction_id
1146: and location_to_table = 'FTE_DELIVERY_PROOF';
1147:
1148: l_address :=GET_LOCATION(l_location_id);
1149:
1150:

Line 1153: update fte_delivery_proof

1149:
1150:
1151:
1152: -- Update the POD information
1153: update fte_delivery_proof
1154: set creation_date=sysdate,
1155: created_by =FND_GLOBAL.USER_ID,
1156: last_update_date=sysdate,
1157: last_updated_by=FND_GLOBAL.USER_ID,

Line 1163: NULL; --No records in FTE_DELIVERY_PROOF table

1159: location = l_address
1160: where transaction_id= p_transaction_id;
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: NULL; --No records in FTE_DELIVERY_PROOF table
1164: END ;
1165:
1166:
1167: -- populate child legs if any

Line 1227: NULL; --No records in FTE_DELIVERY_PROOF table

1223: last_update_login=FND_GLOBAL.USER_ID
1224: where transaction_id = p_transaction_id;
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: NULL; --No records in FTE_DELIVERY_PROOF table
1228: END ;
1229:
1230: --Get the location inforamtion for the POD from the fte_message_address for the location id
1231:

Line 1236: and location_to_table = 'FTE_DELIVERY_PROOF';

1232: BEGIN
1233: select id into l_location_id
1234: from fte_message_location
1235: where transaction_id=p_transaction_id
1236: and location_to_table = 'FTE_DELIVERY_PROOF';
1237:
1238: l_address :=GET_LOCATION(l_location_id);
1239:
1240:

Line 1243: update fte_delivery_proof

1239:
1240:
1241: -- Update the POD information
1242:
1243: update fte_delivery_proof
1244: set creation_date = sysdate,
1245: created_by = FND_GLOBAL.USER_ID,
1246: last_update_date=sysdate,
1247: last_updated_by=FND_GLOBAL.USER_ID,

Line 1253: NULL; --No records in FTE_DELIVERY_PROOF table

1249: location = l_address
1250: where transaction_id= p_transaction_id;
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: NULL; --No records in FTE_DELIVERY_PROOF table
1254: END ;
1255:
1256: -- populate child legs if any
1257: populate_child_delivery_legs

Line 1320: NULL; --No records in FTE_DELIVERY_PROOF table

1316: creation_date = sysdate
1317: where transaction_id = p_transaction_id;
1318: EXCEPTION
1319: WHEN OTHERS THEN
1320: NULL; --No records in FTE_DELIVERY_PROOF table
1321: END ;
1322:
1323: -- populate child legs if any
1324: populate_child_delivery_legs

Line 1402: NULL; --No records in FTE_DELIVERY_PROOF table

1398: creation_date = sysdate
1399: where transaction_id = p_transaction_id;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: NULL; --No records in FTE_DELIVERY_PROOF table
1403: END ;
1404:
1405: -- populate child legs if any
1406: populate_child_delivery_legs

Line 1477: NULL; --No records in FTE_DELIVERY_PROOF table

1473: creation_date = sysdate
1474: where transaction_id = p_transaction_id;
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: NULL; --No records in FTE_DELIVERY_PROOF table
1478: END ;
1479:
1480: --Get the location inforamtion for the POD from the fte_message_address for the location id
1481:

Line 1486: and location_to_table = 'FTE_DELIVERY_PROOF';

1482: BEGIN
1483: select id into l_location_id
1484: from fte_message_location
1485: where transaction_id=p_transaction_id
1486: and location_to_table = 'FTE_DELIVERY_PROOF';
1487:
1488: l_address :=GET_LOCATION(l_location_id);
1489:
1490:

Line 1493: update fte_delivery_proof

1489:
1490:
1491: -- Update the POD information
1492:
1493: update fte_delivery_proof
1494: set creation_date = sysdate,
1495: created_by = FND_GLOBAL.USER_ID,
1496: last_update_date=sysdate,
1497: last_updated_by=FND_GLOBAL.USER_ID,

Line 1503: NULL; --No records in FTE_DELIVERY_PROOF table

1499: location = l_address
1500: where transaction_id= p_transaction_id;
1501: EXCEPTION
1502: WHEN OTHERS THEN
1503: NULL; --No records in FTE_DELIVERY_PROOF table
1504: END ;
1505:
1506: -- populate child legs if any
1507: populate_child_delivery_legs

Line 1563: fte_delivery_proof where transaction_id= p_transaction_id;

1559:
1560: begin
1561: select received_date,1 into l_received_date,l_flag
1562: from
1563: fte_delivery_proof where transaction_id= p_transaction_id;
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: NULL; --No records in FTE_DELIVERY_PROOF table
1567: END ;

Line 1566: NULL; --No records in FTE_DELIVERY_PROOF table

1562: from
1563: fte_delivery_proof where transaction_id= p_transaction_id;
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: NULL; --No records in FTE_DELIVERY_PROOF table
1567: END ;
1568:
1569: if l_flag= 1 then
1570: FTE_TRACKING_WRAPPER.call_last_delivery_leg(l_delivery_leg_id,l_received_date);

Line 1719: fte_delivery_proof fp

1715: SELECT
1716: fp.transaction_id
1717: FROM
1718: fte_shipment_status_headers fh,
1719: fte_delivery_proof fp
1720: WHERE
1721: fh.transaction_id = fp.transaction_id and
1722: fh.transaction_id <> c_transaction_id and
1723: fh.delivery_leg_id = c_delivery_leg_id;

Line 1796: from fte_delivery_proof where

1792: where transaction_id = l_previous_transaction_id;
1793:
1794:
1795: delete
1796: from fte_delivery_proof where
1797: transaction_id =l_previous_transaction_id;
1798:
1799:
1800: elsif (upper(l_message_type) = 'CONTAINER')

Line 1852: from fte_delivery_proof where

1848:
1849:
1850:
1851: delete
1852: from fte_delivery_proof where
1853: transaction_id =l_previous_transaction_id;
1854:
1855: end if;
1856: