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_TRACKING_WRAPPER

Line 1: PACKAGE BODY FTE_TRACKING_WRAPPER as

1: PACKAGE BODY FTE_TRACKING_WRAPPER as
2: /* $Header: FTETKWRB.pls 120.6 2006/02/13 16:05:22 schennal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRACKING_WRAPPER';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRACKING_WRAPPER';

1: PACKAGE BODY FTE_TRACKING_WRAPPER as
2: /* $Header: FTETKWRB.pls 120.6 2006/02/13 16:05:22 schennal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRACKING_WRAPPER';
5:
6: --========================================================================
7: -- PROCEDURE : populate_child_delivery_legs FTE Tracking wrapper
8: --

Line 7: -- PROCEDURE : populate_child_delivery_legs FTE Tracking wrapper

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TRACKING_WRAPPER';
5:
6: --========================================================================
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

Line 58: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.populate_child_delivery_legs';

54: l_error_token_text NUMBER;
55: l_error_id NUMBER;
56: l_sql_error_code VARCHAR2(2000);
57: l_sql_error_msg VARCHAR2(2000);
58: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.populate_child_delivery_legs';
59:
60: cursor get_org_delivery_info ( c_delivery_leg_id NUMBER) IS
61: SELECT wnd.delivery_id, wnd.organization_id FROM
62: wsh_delivery_legs wdl, wsh_new_deliveries wnd

Line 732: FTE_TRACKING_WRAPPER.get_delivery_details ( l_transaction_id_s, p_carrier_id,

728: -- Call the procedure get_delivery_details to delete all the
729: -- details and POD information for a delivery leg and retain only the
730: -- last detail and POD information
731:
732: FTE_TRACKING_WRAPPER.get_delivery_details ( l_transaction_id_s, p_carrier_id,
733: l_exception_message,
734: l_return_status, l_error_token_text);
735:
736:

Line 747: FTE_TRACKING_WRAPPER.call_last_delivery_leg(l_delivery_leg_id,l_received_date);

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);
748: ELSE
749: --Added by shravisa for Release 12
750: --Raise Workflow Tracking Event when ever Tracking information comes for any
751: --Functional Workflow

Line 786: FTE_TRACKING_WRAPPER.insert_error_status

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',
789: p_carrier_id);
790:

Line 805: FTE_TRACKING_WRAPPER.insert_error_status

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',
808: p_carrier_id);
809:

Line 830: -- PROCEDURE : Get Location FTE Tracking wrapper

826: END populate_child_delivery_legs;
827:
828:
829: --========================================================================
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

Line 875: -- PROCEDURE : Insert_delete_delivery FTE Tracking wrapper

871: RETURN (l_loca_csc);
872: END GET_LOCATION;
873:
874: --========================================================================
875: -- PROCEDURE : Insert_delete_delivery FTE Tracking wrapper
876: --
877: -- COMMENT : Insert the data from the header interface table to
878: -- wsh_delivery_leg_activities and wsh_delivery_leg_details.
879: -- Delete the record from the detail interface table if they are

Line 928: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.get_delivery_or_container';

924: l_error_token_text NUMBER;
925:
926: l_sql_error_code VARCHAR2(2000);
927: l_sql_error_msg VARCHAR2(2000);
928: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.get_delivery_or_container';
929:
930: invalid_carrier EXCEPTION;
931: no_license_plate EXCEPTION;
932: invalid_tracking_id_type EXCEPTION;

Line 1552: FTE_TRACKING_WRAPPER.get_delivery_details (p_transaction_id, l_carrier_id,

1548: -- details and POD information for a delivery leg and retain only the
1549: -- last detail and POD information
1550:
1551:
1552: FTE_TRACKING_WRAPPER.get_delivery_details (p_transaction_id, l_carrier_id,
1553: l_exception_message,
1554: l_return_status, l_error_token_text);
1555:
1556:

Line 1570: FTE_TRACKING_WRAPPER.call_last_delivery_leg(l_delivery_leg_id,l_received_date);

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);
1571: else
1572: --Added by shravisa for Release 12
1573: --Raise Workflow Tracking Event when ever Tracking information comes for any
1574: --Functional Workflow

Line 1604: FTE_TRACKING_WRAPPER.insert_error_status

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',
1607: 0);
1608: x_error_token_text := 1;

Line 1615: FTE_TRACKING_WRAPPER.insert_error_status

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',
1618: 0);
1619: x_error_token_text := 2;

Line 1626: FTE_TRACKING_WRAPPER.insert_error_status

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',
1629: l_carrier_id);
1630: x_error_token_text := 3;

Line 1637: FTE_TRACKING_WRAPPER.insert_error_status

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',
1640: l_carrier_id);
1641: x_return_status := 4 ;

Line 1648: FTE_TRACKING_WRAPPER.insert_error_status

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',
1651: l_carrier_id);
1652:

Line 1692: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.get_delivery_details';

1688:
1689: l_sql_error_code VARCHAR2(2000);
1690: l_sql_error_msg VARCHAR2(2000);
1691: l_cursor_name VARCHAR2(2000);
1692: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.get_delivery_details';
1693:
1694: INVALID_TRANSACTION_ID EXCEPTION;
1695:
1696: l_error_id NUMBER;

Line 1875: FTE_TRACKING_WRAPPER.insert_error_status

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',
1878: p_carrier_id);
1879:

Line 2303: END FTE_TRACKING_WRAPPER;

2299: );
2300:
2301: END call_last_delivery_leg;
2302:
2303: END FTE_TRACKING_WRAPPER;