[Home] [Help]
PACKAGE: APPS.PO_PDOI_ERR_UTL
Source
1 PACKAGE PO_PDOI_ERR_UTL AS
2 /* $Header: PO_PDOI_ERR_UTL.pls 120.5 2006/01/31 10:03 jinwang noship $ */
3
4 PROCEDURE add_error
5 ( p_interface_header_id IN NUMBER,
6 p_interface_line_id IN NUMBER := NULL,
7 p_interface_line_location_id IN NUMBER := NULL,
8 p_interface_distribution_id IN NUMBER := NULL,
9 p_price_diff_interface_id IN NUMBER := NULL,
10 p_interface_attr_values_id IN NUMBER := NULL,
11 p_interface_attr_values_tlp_id IN NUMBER := NULL,
12 p_app_name IN VARCHAR2 := NULL,
13 p_error_message_name IN VARCHAR2 := NULL,
14 p_table_name IN VARCHAR2 := NULL,
15 p_column_name IN VARCHAR2 , -- TODO: Default to NULL later
16 p_column_value IN VARCHAR2 , -- TODO: Default to NULL later
17 p_token1_name IN VARCHAR2 := NULL,
18 p_token1_value IN VARCHAR2 := NULL,
19 p_token2_name IN VARCHAR2 := NULL,
20 p_token2_value IN VARCHAR2 := NULL,
21 p_token3_name IN VARCHAR2 := NULL,
22 p_token3_value IN VARCHAR2 := NULL,
23 p_token4_name IN VARCHAR2 := NULL,
24 p_token4_value IN VARCHAR2 := NULL,
25 p_token5_name IN VARCHAR2 := NULL,
26 p_token5_value IN VARCHAR2 := NULL,
27 p_token6_name IN VARCHAR2 := NULL,
28 p_token6_value IN VARCHAR2 := NULL,
29 p_error_message IN VARCHAR2 := NULL
30 );
31
32
33 PROCEDURE add_warning
34 ( p_interface_header_id IN NUMBER,
35 p_interface_line_id IN NUMBER := NULL,
36 p_interface_line_location_id IN NUMBER := NULL,
37 p_interface_distribution_id IN NUMBER := NULL,
38 p_price_diff_interface_id IN NUMBER := NULL,
39 p_interface_attr_values_id IN NUMBER := NULL,
40 p_interface_attr_values_tlp_id IN NUMBER := NULL,
41 p_app_name IN VARCHAR2 := NULL,
42 p_error_message_name IN VARCHAR2 := NULL,
43 p_table_name IN VARCHAR2 := NULL,
44 p_column_name IN VARCHAR2 := NULL,
45 p_column_value IN VARCHAR2 := NULL,
46 p_token1_name IN VARCHAR2 := NULL,
47 p_token1_value IN VARCHAR2 := NULL,
48 p_token2_name IN VARCHAR2 := NULL,
49 p_token2_value IN VARCHAR2 := NULL,
50 p_token3_name IN VARCHAR2 := NULL,
51 p_token3_value IN VARCHAR2 := NULL,
52 p_token4_name IN VARCHAR2 := NULL,
53 p_token4_value IN VARCHAR2 := NULL,
54 p_token5_name IN VARCHAR2 := NULL,
55 p_token5_value IN VARCHAR2 := NULL,
56 p_token6_name IN VARCHAR2 := NULL,
57 p_token6_value IN VARCHAR2 := NULL,
58 p_error_message IN VARCHAR2 := NULL
59 );
60
61 PROCEDURE add_fatal_error
62 ( p_interface_header_id IN NUMBER,
63 p_interface_line_id IN NUMBER := NULL,
64 p_interface_line_location_id IN NUMBER := NULL,
65 p_interface_distribution_id IN NUMBER := NULL,
66 p_price_diff_interface_id IN NUMBER := NULL,
67 p_interface_attr_values_id IN NUMBER := NULL,
68 p_interface_attr_values_tlp_id IN NUMBER := NULL,
69 p_app_name IN VARCHAR2 := NULL,
70 p_error_message_name IN VARCHAR2 := NULL,
71 p_table_name IN VARCHAR2 := NULL,
72 p_column_name IN VARCHAR2 := NULL,
73 p_column_value IN VARCHAR2 := NULL,
74 p_token1_name IN VARCHAR2 := NULL,
75 p_token1_value IN VARCHAR2 := NULL,
76 p_token2_name IN VARCHAR2 := NULL,
77 p_token2_value IN VARCHAR2 := NULL,
78 p_token3_name IN VARCHAR2 := NULL,
79 p_token3_value IN VARCHAR2 := NULL,
80 p_token4_name IN VARCHAR2 := NULL,
81 p_token4_value IN VARCHAR2 := NULL,
82 p_token5_name IN VARCHAR2 := NULL,
83 p_token5_value IN VARCHAR2 := NULL,
84 p_token6_name IN VARCHAR2 := NULL,
85 p_token6_value IN VARCHAR2 := NULL,
86 p_error_message IN VARCHAR2 := NULL,
87 p_validation_id IN NUMBER := NULL,
88 p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
89 p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
90 p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
91 p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
92 p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
93 );
94
95 PROCEDURE process_val_type_errors
96 ( x_results IN OUT NOCOPY po_validation_results_type,
97 p_table_name IN VARCHAR2,
98 p_headers IN PO_PDOI_TYPES.headers_rec_type := NULL,
99 p_lines IN PO_PDOI_TYPES.lines_rec_type := NULL,
100 p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type := NULL,
101 p_distributions IN PO_PDOI_TYPES.distributions_rec_type := NULL,
102 p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
103 );
104
105 PROCEDURE derive_parent_interface_ids
106 ( p_table_name IN VARCHAR2,
107 p_table_id_tbl IN PO_TBL_NUMBER,
108 x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
109 x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
110 x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
111 x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
112 x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
113 );
114
115
116
117 END PO_PDOI_ERR_UTL;