[Home] [Help]
49: --Start of Comments
50: --Name: add_error
51: --Function:
52: -- Add an error to the strucutre. The structure will eventually gets
53: -- flushed to PO_INTERFACE_ERRORS table.
54: --Parameters:
55: --IN:
56: --p_app_name
57: -- Application where the error message is defined in. If none is passed,
91: d_api_name CONSTANT VARCHAR2(30) := 'add_error';
92: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
93: d_position NUMBER;
94:
95: l_rec PO_INTERFACE_ERRORS%ROWTYPE;
96:
97: BEGIN
98: d_position := 0;
99:
114: l_rec.table_name := p_table_name;
115: l_rec.column_name := p_column_name;
116: l_rec.column_value := p_column_value;
117: --bug 12812134: truncating the values assigned to token values to 200,
118: -- the column size of token values in po_interface_errors.
119: l_rec.token1_name := p_token1_name;
120: l_rec.token1_value := SubStr(p_token1_value,1,200);
121: l_rec.token2_name := p_token2_name;
122: l_rec.token2_value := SubStr(p_token2_value,1,200);
130: l_rec.token6_value := SubStr(p_token6_value,1,200);
131: l_rec.error_message := p_error_message; -- bug5385342
132:
133: /* Bug 9918507 start
134: Batch_id was not getting populated in the po_interface_errors
135: even though it was entered in po_headers_interface.
136: Query for batch_id using interface_header_id and populate l_rec.batch_id
137: with that value*/
138: SELECT batch_id
140: FROM po_headers_interface
141: WHERE interface_header_id = p_interface_header_id;
142: /* Bug 9918507 end*/
143:
144: PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl
145: ( p_err_type => 'FATAL',
146: p_err_rec => l_rec
147: );
148:
162: --Start of Comments
163: --Name: add_warning
164: --Function:
165: -- Add a warning to the strucutre. The structure will eventually gets
166: -- flushed to PO_INTERFACE_ERRORS table.
167: --Parameters:
168: --IN:
169: --p_app_name
170: -- Application where the error message is defined in. If none is passed,
203: d_api_name CONSTANT VARCHAR2(30) := 'add_warning';
204: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
205: d_position NUMBER;
206:
207: l_rec PO_INTERFACE_ERRORS%ROWTYPE;
208:
209: BEGIN
210: d_position := 0;
211:
226: l_rec.table_name := p_table_name;
227: l_rec.column_name := p_column_name;
228: l_rec.column_value := p_column_value;
229: --bug 12812134: truncating the values assigned to token values to 200,
230: -- the column size of token values in po_interface_errors.
231: l_rec.token1_name := p_token1_name;
232: l_rec.token1_value := SubStr(p_token1_value,1,200);
233: l_rec.token2_name := p_token2_name;
234: l_rec.token2_value := SubStr(p_token2_value,1,200);
243: l_rec.error_message := p_error_message; -- bug5385342
244:
245: d_position := 10;
246:
247: PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl
248: ( p_err_type => 'WARNING',
249: p_err_rec => l_rec
250: );
251:
267: --Start of Comments
268: --Name: add_fatal_error
269: --Function:
270: -- insert an error to the strucutre. The structure will eventually gets
271: -- flushed to PO_INTERFACE_ERRORS table. But the error may be mapped
272: -- to a new message before the actual insert happens accoring to its
273: -- context and validation content.
274: --Parameters:
275: --IN: