[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE_VALIDATIONS_PKG
Source
1 PACKAGE Wsh_interface_validations_pkg AUTHID CURRENT_USER AS
2 /* $Header: WSHINVDS.pls 120.0.12010000.5 2010/02/25 15:55:31 sankarun 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 --R12.1.1 STANDALONE PROJECT
36 TYPE Interface_errors_rec_tab IS TABLE OF Interface_errors_rec_type INDEX BY BINARY_INTEGER;
37 -- LSP PROJECT : Added new in parameter p_client_code.
38 -- Trading Partner Id value comes from xml mapping when p_client_code is not NULL
39 PROCEDURE Validate_document (
40 P_doc_type IN VARCHAR2,
41 P_doc_number IN VARCHAR2,
42 --R12.1.1 STANDALONE PROJECT
43 P_doc_revision IN NUMBER DEFAULT NULL,
44 P_trading_partner_Code IN VARCHAR2,
45 P_action_type IN VARCHAR2,
46 P_doc_direction IN VARCHAR2,
47 P_orig_document_number IN VARCHAR2,
48 p_client_code IN VARCHAR2 DEFAULT NULL, -- LSP PROJECT
49 X_Trading_Partner_ID IN OUT NOCOPY NUMBER, -- LSP PROJECT
50 X_valid_doc OUT NOCOPY VARCHAR2,
51 X_return_status OUT NOCOPY VARCHAR2
52 );
53
54 -- LSP PROJECT : API returns client Code associated to the given
55 -- party id and party site id values. It also returns item delimiter
56 -- value. This api is being called from XML gateway inbound mapping.
57 PROCEDURE Get_Client_details (
58 P_trading_partner_id IN NUMBER,
59 P_trading_partner_site_id IN NUMBER,
60 p_trading_partner_type OUT NOCOPY VARCHAR2,
61 P_client_code OUT NOCOPY VARCHAR2,
62 P_item_delimiter OUT NOCOPY VARCHAR2,
63 X_return_status OUT NOCOPY VARCHAR2
64 );
65
66 -- TPW - Distributed Organization Changes
67 /*==============================================================================
68
69 PROCEDURE NAME: Validate_Delivery_Details
70
71 This Procedure is called from the Wsh_Inbound_Ship_Advice_Pkg.Process_Ship_Advice,
72 after data is populated into the interface tables.
73
74 This Procedure checks if the Delivery Details received in the 945,
75 exists in the Supplier Instance base tables.
76
77 ==============================================================================*/
78 PROCEDURE Validate_delivery_details (
79 p_delivery_interface_id IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE Validate_deliveries (
84 P_delivery_id IN NUMBER,
85 X_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Compare_ship_request_advice (
89 P_delivery_id IN NUMBER,
90 X_return_status OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE Log_interface_errors (
94 P_interface_errors_rec IN Interface_errors_rec_type,
95 p_msg_data IN VARCHAR2 DEFAULT NULL,
96 p_api_name IN VARCHAR2,
97 X_return_status OUT NOCOPY VARCHAR2
98 );
99
100 -- R12.1.1 STANDALONE PROJECT
101 /*==============================================================================
102
103 PROCEDURE NAME: Log_Interface_Errors (Overloaded)
104
105 This Procedure is called from various procedure whenever an error is detected in
106 the data elements.
107 ==============================================================================*/
108
109 PROCEDURE Log_interface_errors (
110 P_Interface_errors_rec_tab IN Interface_errors_rec_tab,
111 p_interface_action_code IN VARCHAR2,
112 X_return_status OUT NOCOPY VARCHAR2
113 );
114 END Wsh_interface_validations_pkg;