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 WSH_INTERFACE_ERRORS

Line 783: select wsh_interface_errors_s.nextval into l_error_id

779:
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',

Line 802: select wsh_interface_errors_s.nextval into l_error_id

798: p_encoded => FND_API.G_FALSE
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',

Line 1601: select wsh_interface_errors_s.nextval into l_error_id

1597:
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',

Line 1612: select wsh_interface_errors_s.nextval into l_error_id

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

Line 1623: select wsh_interface_errors_s.nextval into l_error_id

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

Line 1634: select wsh_interface_errors_s.nextval into l_error_id

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

Line 1645: select wsh_interface_errors_s.nextval into l_error_id

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

Line 1872: select wsh_interface_errors_s.nextval into l_error_id

1868: l_exception_message := 'Invalid transaction id';
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',

Line 1911: INSERT INTO WSH_INTERFACE_ERRORS

1907: IS
1908: BEGIN
1909:
1910: -- message_code 0 = completed with success, 1 = completed with error
1911: INSERT INTO WSH_INTERFACE_ERRORS
1912: (INTERFACE_ERROR_ID, INTERFACE_ERROR_GROUP_ID, INTERFACE_TABLE_NAME,
1913: INTERFACE_ID, MESSAGE_CODE, MESSAGE_NAME, ERROR_MESSAGE,
1914: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
1915: VALUES (p_interface_error_id, 1, p_interface_table_name,