APPS.WSH_EXCEPTIONS_GRP dependencies on STANDARD

Line 27: -- Standard parameters

23: -- name and create an exception table.
24: ------------------------------------------------------------------------------
25:
26: PROCEDURE Get_Exceptions (
27: -- Standard parameters
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,

Line 67: -- Standard call to check for call compatibility

63: SELECT exception_id, exception_name, status
64: FROM WSH_EXCEPTIONS
65: WHERE delivery_detail_id = v_del_detail_id;
66:
67: -- Standard call to check for call compatibility
68: l_api_version CONSTANT NUMBER := 1.0;
69: l_api_name CONSTANT VARCHAR2(30):= 'Get_Exceptions';
70:
71: l_count NUMBER;

Line 225: -- Standard parameters

221: -- status specified.
222: ------------------------------------------------------------------------------
223:
224: PROCEDURE Change_Status (
225: -- Standard parameters
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

Line 249: -- Standard call to check for call compatibility

245: SELECT status
246: FROM wsh_exceptions
247: WHERE exception_id = p_exception_id ;
248:
249: -- Standard call to check for call compatibility
250: l_api_version CONSTANT NUMBER := 1.0;
251: l_api_name CONSTANT VARCHAR2(30):= 'Change_Status';
252:
253: l_exceptions_tab WSH_EXCEPTIONS_PUB.xc_tab_type;

Line 544: -- Standard parameters

540: --
541: ------------------------------------------------------------------------------
542:
543: PROCEDURE Log_Exception (
544: -- Standard parameters
545: p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
548: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 587: AND delivery_type = 'STANDARD';

583: CURSOR c_check_consol_dlvy(p_delivery_id IN NUMBER) IS
584: SELECT delivery_id
585: FROM wsh_new_deliveries
586: WHERE delivery_id = p_delivery_id
587: AND delivery_type = 'STANDARD';
588:
589: -- local variables
590: l_exception_id NUMBER DEFAULT NULL;
591: l_trip_id NUMBER DEFAULT NULL;

Line 605: -- standard version information

601: l_msg_reason VARCHAR2(150);
602: l_logging_entity VARCHAR2(30);
603: l_severity VARCHAR2(30);
604:
605: -- standard version information
606: l_api_version CONSTANT NUMBER := 1.0;
607: l_api_name CONSTANT VARCHAR2(30) := 'Log_Exception';
608:
609: WSH_XC_INVALID_LOCATION EXCEPTION;

Line 809: --Delivery must be a standard delivery

805: END IF;
806: END IF;
807:
808: --R12 MDC
809: --Delivery must be a standard delivery
810: OPEN c_check_consol_dlvy(l_delivery_Id);
811: FETCH c_check_consol_dlvy INTO l_delivery_Id;
812: IF c_check_consol_dlvy%NOTFOUND THEN
813: CLOSE c_check_consol_dlvy;

Line 1267: -- Standard parameters

1263: -- entered by the user.
1264: ------------------------------------------------------------------------------
1265:
1266: PROCEDURE Purge_Exception (
1267: -- Standard parameters
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1270: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1271: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1315: -- Standard call to check for call compatibility

1311: l_logged_at_location_id NUMBER DEFAULT NULL;
1312: l_exception_location_id NUMBER DEFAULT NULL;
1313: l_trip_id NUMBER;
1314:
1315: -- Standard call to check for call compatibility
1316: l_api_version CONSTANT NUMBER := 1.0;
1317: l_api_name CONSTANT VARCHAR2(30):= 'Purge_Exception';
1318:
1319: WSH_XC_INVALID_STATUS EXCEPTION;

Line 1864: -- Standard parameters

1860: -- code it receives through the parameter p_action.
1861: ------------------------------------------------------------------------------
1862:
1863: PROCEDURE Exception_Action (
1864: -- Standard parameters
1865: p_api_version IN NUMBER,
1866: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1867: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1868: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1882: -- Standard call to check for call compatibility

1878: l_action VARCHAR2(20);
1879: l_updated_rows NUMBER;
1880: l_return_status VARCHAR2(1);
1881:
1882: -- Standard call to check for call compatibility
1883: l_api_version CONSTANT NUMBER := 1.0;
1884: l_api_name CONSTANT VARCHAR2(30):= 'Exception_Action';
1885:
1886: WSH_INVALID_ACTION_CODE EXCEPTION;