[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE_VALIDATIONS_PKG
Source
1 PACKAGE Wsh_interface_validations_pkg AUTHID CURRENT_USER AS
2 /* $Header: WSHINVDS.pls 115.2 2002/11/12 01:43:13 nparikh ship $ */
3
4 C_sdebug CONSTANT NUMBER := Wsh_debug_sv.C_level1;
5 C_debug CONSTANT NUMBER := Wsh_debug_sv.C_level2;
6
7 TYPE Interface_errors_rec_type IS RECORD (
8 P_message_name VARCHAR2 (30) DEFAULT NULL,
9 P_text VARCHAR2 (2000) DEFAULT NULL,
10 P_token1 VARCHAR2 (250) DEFAULT NULL,
11 P_value1 VARCHAR2 (250) DEFAULT NULL,
12 P_token2 VARCHAR2 (250) DEFAULT NULL,
13 P_value2 VARCHAR2 (250) DEFAULT NULL,
14 P_token3 VARCHAR2 (250) DEFAULT NULL,
15 P_value3 VARCHAR2 (250) DEFAULT NULL,
16 P_token4 VARCHAR2 (250) DEFAULT NULL,
17 P_value4 VARCHAR2 (250) DEFAULT NULL,
18 P_token5 VARCHAR2 (250) DEFAULT NULL,
19 P_value5 VARCHAR2 (250) DEFAULT NULL,
20 P_token6 VARCHAR2 (250) DEFAULT NULL,
21 P_value6 VARCHAR2 (250) DEFAULT NULL,
22 P_token7 VARCHAR2 (250) DEFAULT NULL,
23 P_value7 VARCHAR2 (250) DEFAULT NULL,
24 P_token8 VARCHAR2 (250) DEFAULT NULL,
25 P_value8 VARCHAR2 (250) DEFAULT NULL,
26 P_token9 VARCHAR2 (250) DEFAULT NULL,
27 P_value9 VARCHAR2 (250) DEFAULT NULL,
28 P_token10 VARCHAR2 (250) DEFAULT NULL,
29 P_value10 VARCHAR2 (250) DEFAULT NULL,
30 P_token11 VARCHAR2 (250) DEFAULT NULL,
31 P_value11 VARCHAR2 (250) DEFAULT NULL,
32 P_interface_table_name Wsh_interface_errors.Interface_table_name%TYPE,
33 P_interface_id Wsh_interface_errors.Interface_id%TYPE);
34
35 PROCEDURE Validate_document (
36 P_doc_type IN VARCHAR2,
37 P_doc_number IN VARCHAR2,
38 P_trading_partner_Code IN VARCHAR2,
39 P_action_type IN VARCHAR2,
40 P_doc_direction IN VARCHAR2,
41 P_orig_document_number IN VARCHAR2,
42 X_Trading_Partner_ID OUT NOCOPY NUMBER,
43 X_valid_doc OUT NOCOPY VARCHAR2,
44 X_return_status OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Validate_deliveries (
48 P_delivery_id IN NUMBER,
49 X_return_status OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE Compare_ship_request_advice (
53 P_delivery_id IN NUMBER,
54 X_return_status OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE Log_interface_errors (
58 P_interface_errors_rec IN Interface_errors_rec_type,
59 p_msg_data IN VARCHAR2 DEFAULT NULL,
60 p_api_name IN VARCHAR2,
61 X_return_status OUT NOCOPY VARCHAR2
62 );
63 END Wsh_interface_validations_pkg;