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 DUAL

Line 92: select FTE_TRACKING_TRANSACTION_S.nextval into l_transaction_id_s from dual;

88: EXIT when c_child_delivery_leg%NOTFOUND;
89:
90:
91: --Create a new Transaction id for records in headers/detail/proof
92: select FTE_TRACKING_TRANSACTION_S.nextval into l_transaction_id_s from dual;
93:
94:
95: --Create a new Activity Id to record the activity in Activities table
96: select WSH_DELIVERY_LEG_ACTIVITIES_S.nextval into l_activity_id_s from dual;

Line 96: select WSH_DELIVERY_LEG_ACTIVITIES_S.nextval into l_activity_id_s from dual;

92: select FTE_TRACKING_TRANSACTION_S.nextval into l_transaction_id_s from dual;
93:
94:
95: --Create a new Activity Id to record the activity in Activities table
96: select WSH_DELIVERY_LEG_ACTIVITIES_S.nextval into l_activity_id_s from dual;
97:
98:
99: --Insert into Activities table
100: insert into wsh_delivery_leg_activities

Line 155: select fte_tracking_status_s.nextval into l_content_details_id from dual;

151: END ;
152: -- Insert into details table
153: BEGIN
154:
155: select fte_tracking_status_s.nextval into l_content_details_id from dual;
156: insert into fte_shipment_status_details(
157: SHIPMENT_STATUS_DETAIL_ID,
158: DELIVERY_LEG_ID,
159: TRANSACTION_ID,

Line 198: select fte_tracking_status_s.nextval into l_content_pod_id from dual;

194: NULL; --No records in FTE_SHIPMENT_STATUS_DETAILS
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,

Line 271: select fte_tracking_status_s.nextval into l_address_to_id from dual;

267:
268: --Inserting into fte_message partner as per FTEFSSI XGM to content
269: BEGIN
270:
271: select fte_tracking_status_s.nextval into l_address_to_id from dual;
272: INSERT INTO
273: FTE_MESSAGE_PARTNER (
274: ID,
275: NAME1 ,

Line 646: select fte_tracking_status_s.currval into l_content_exceptions_id from dual;

642: l_transaction_id_s
643: FROM FTE_SHIPMENT_STATUS_EXCEPTIONS
644: WHERE TRANSACTION_ID = P_TRANSACTION_ID ;
645:
646: select fte_tracking_status_s.currval into l_content_exceptions_id from dual;
647: EXCEPTION
648: WHEN OTHERS THEN
649: null;
650: END ;

Line 784: from dual;

780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN
782: ROLLBACK TO populate_child_legs_pub;
783: select wsh_interface_errors_s.nextval into l_error_id
784: from dual;
785:
786: FTE_TRACKING_WRAPPER.insert_error_status
787: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
788: p_transaction_id, 3, 'ERROR', 'NO CHILD DELIVERY FOUND',

Line 803: from dual;

799: );
800: WHEN OTHERS THEN
801: ROLLBACK TO populate_child_legs_pub;
802: select wsh_interface_errors_s.nextval into l_error_id
803: from dual;
804:
805: FTE_TRACKING_WRAPPER.insert_error_status
806: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
807: p_transaction_id, 5, 'ERROR', 'OTHER EXCEPTION',

Line 1602: from dual;

1598:
1599: EXCEPTION
1600: WHEN INVALID_CARRIER THEN
1601: select wsh_interface_errors_s.nextval into l_error_id
1602: from dual;
1603:
1604: FTE_TRACKING_WRAPPER.insert_error_status
1605: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
1606: p_transaction_id, 1, 'ERROR', 'INVALID CARRIER',

Line 1613: from dual;

1609: x_exception_message := 'Invalid carrier name. ';
1610: x_return_status := 1;
1611: WHEN NO_LICENSE_PLATE THEN
1612: select wsh_interface_errors_s.nextval into l_error_id
1613: from dual;
1614:
1615: FTE_TRACKING_WRAPPER.insert_error_status
1616: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
1617: p_transaction_id, 2, 'ERROR', 'NO LICENSE PLATE NUMBER',

Line 1624: from dual;

1620: x_exception_message := 'No license plate number. ';
1621: x_return_status := 2;
1622: WHEN NO_DATA_FOUND THEN
1623: select wsh_interface_errors_s.nextval into l_error_id
1624: from dual;
1625:
1626: FTE_TRACKING_WRAPPER.insert_error_status
1627: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
1628: p_transaction_id, 3, 'ERROR', 'NO DELIVERY FOUND',

Line 1635: from dual;

1631: x_exception_message := 'Unable to determine delivery. ';
1632: x_return_status := 3;
1633: WHEN INVALID_TRACKING_ID_TYPE THEN
1634: select wsh_interface_errors_s.nextval into l_error_id
1635: from dual;
1636:
1637: FTE_TRACKING_WRAPPER.insert_error_status
1638: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
1639: p_transaction_id, 4, 'ERROR', 'INVALID TRACKING ID TYPE',

Line 1646: from dual;

1642: x_exception_message := 'Invalid tracking id type';
1643: x_error_token_text := 4;
1644: WHEN OTHERS THEN
1645: select wsh_interface_errors_s.nextval into l_error_id
1646: from dual;
1647:
1648: FTE_TRACKING_WRAPPER.insert_error_status
1649: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
1650: p_transaction_id, 5, 'ERROR', 'OTHER EXCEPTION',

Line 1873: from dual;

1869:
1870: WHEN OTHERS THEN
1871:
1872: select wsh_interface_errors_s.nextval into l_error_id
1873: from dual;
1874:
1875: FTE_TRACKING_WRAPPER.insert_error_status
1876: (l_error_id, 'FTE_SHIPMEMT_STATUS_DETAILS',
1877: p_transaction_id, 2, 'ERROR', 'NO DELIVERY DETAILS FOUND',