APPS.RCV_DEFAULT_PKG dependencies on RCV_ERROR_PKG

Line 48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');

44: IF (p_dst_value IS NULL) THEN
45: p_dst_value := p_src_value;
46: ELSIF( p_src_value IS NOT NULL
47: AND p_dst_value <> p_src_value) THEN
48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
49: rcv_error_pkg.set_token('COLUMN', p_column);
50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
52: rcv_error_pkg.log_interface_error(p_column);

Line 49: rcv_error_pkg.set_token('COLUMN', p_column);

45: p_dst_value := p_src_value;
46: ELSIF( p_src_value IS NOT NULL
47: AND p_dst_value <> p_src_value) THEN
48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
49: rcv_error_pkg.set_token('COLUMN', p_column);
50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
52: rcv_error_pkg.log_interface_error(p_column);
53: END IF;

Line 50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);

46: ELSIF( p_src_value IS NOT NULL
47: AND p_dst_value <> p_src_value) THEN
48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
49: rcv_error_pkg.set_token('COLUMN', p_column);
50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
52: rcv_error_pkg.log_interface_error(p_column);
53: END IF;
54: END default_and_check;

Line 51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);

47: AND p_dst_value <> p_src_value) THEN
48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
49: rcv_error_pkg.set_token('COLUMN', p_column);
50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
52: rcv_error_pkg.log_interface_error(p_column);
53: END IF;
54: END default_and_check;
55:

Line 52: rcv_error_pkg.log_interface_error(p_column);

48: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
49: rcv_error_pkg.set_token('COLUMN', p_column);
50: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
51: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
52: rcv_error_pkg.log_interface_error(p_column);
53: END IF;
54: END default_and_check;
55:
56: PROCEDURE default_and_check(

Line 63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');

59: IF (p_dst_value IS NULL) THEN
60: p_dst_value := p_src_value;
61: ELSIF( p_src_value IS NOT NULL
62: AND p_dst_value <> p_src_value) THEN
63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
64: rcv_error_pkg.set_token('COLUMN', p_column);
65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
67: rcv_error_pkg.log_interface_error(p_column);

Line 64: rcv_error_pkg.set_token('COLUMN', p_column);

60: p_dst_value := p_src_value;
61: ELSIF( p_src_value IS NOT NULL
62: AND p_dst_value <> p_src_value) THEN
63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
64: rcv_error_pkg.set_token('COLUMN', p_column);
65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
67: rcv_error_pkg.log_interface_error(p_column);
68: END IF;

Line 65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);

61: ELSIF( p_src_value IS NOT NULL
62: AND p_dst_value <> p_src_value) THEN
63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
64: rcv_error_pkg.set_token('COLUMN', p_column);
65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
67: rcv_error_pkg.log_interface_error(p_column);
68: END IF;
69: END default_and_check;

Line 66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);

62: AND p_dst_value <> p_src_value) THEN
63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
64: rcv_error_pkg.set_token('COLUMN', p_column);
65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
67: rcv_error_pkg.log_interface_error(p_column);
68: END IF;
69: END default_and_check;
70:

Line 67: rcv_error_pkg.log_interface_error(p_column);

63: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
64: rcv_error_pkg.set_token('COLUMN', p_column);
65: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
66: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
67: rcv_error_pkg.log_interface_error(p_column);
68: END IF;
69: END default_and_check;
70:
71: PROCEDURE default_and_check(

Line 78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');

74: IF (p_dst_value IS NULL) THEN
75: p_dst_value := p_src_value;
76: ELSIF( p_src_value IS NOT NULL
77: AND p_dst_value <> p_src_value) THEN
78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
79: rcv_error_pkg.set_token('COLUMN', p_column);
80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
82: rcv_error_pkg.log_interface_error(p_column);

Line 79: rcv_error_pkg.set_token('COLUMN', p_column);

75: p_dst_value := p_src_value;
76: ELSIF( p_src_value IS NOT NULL
77: AND p_dst_value <> p_src_value) THEN
78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
79: rcv_error_pkg.set_token('COLUMN', p_column);
80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
82: rcv_error_pkg.log_interface_error(p_column);
83: END IF;

Line 80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);

76: ELSIF( p_src_value IS NOT NULL
77: AND p_dst_value <> p_src_value) THEN
78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
79: rcv_error_pkg.set_token('COLUMN', p_column);
80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
82: rcv_error_pkg.log_interface_error(p_column);
83: END IF;
84: END default_and_check;

Line 81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);

77: AND p_dst_value <> p_src_value) THEN
78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
79: rcv_error_pkg.set_token('COLUMN', p_column);
80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
82: rcv_error_pkg.log_interface_error(p_column);
83: END IF;
84: END default_and_check;
85:

Line 82: rcv_error_pkg.log_interface_error(p_column);

78: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
79: rcv_error_pkg.set_token('COLUMN', p_column);
80: rcv_error_pkg.set_token('ROI_VALUE', p_dst_value);
81: rcv_error_pkg.set_token('SYS_VALUE', p_src_value);
82: rcv_error_pkg.log_interface_error(p_column);
83: END IF;
84: END default_and_check;
85:
86: PROCEDURE DEFAULT_VALUE(

Line 115: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');

111: p_value IN VARCHAR2, p_column IN VARCHAR2) IS
112: BEGIN
113: IF (p_value IS NULL) THEN
114: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
115: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
116: rcv_error_pkg.set_token('COLUMN', p_column);
117: rcv_error_pkg.log_interface_error(p_column);
118: END IF;
119: END test_is_null;

Line 116: rcv_error_pkg.set_token('COLUMN', p_column);

112: BEGIN
113: IF (p_value IS NULL) THEN
114: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
115: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
116: rcv_error_pkg.set_token('COLUMN', p_column);
117: rcv_error_pkg.log_interface_error(p_column);
118: END IF;
119: END test_is_null;
120:

Line 117: rcv_error_pkg.log_interface_error(p_column);

113: IF (p_value IS NULL) THEN
114: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
115: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
116: rcv_error_pkg.set_token('COLUMN', p_column);
117: rcv_error_pkg.log_interface_error(p_column);
118: END IF;
119: END test_is_null;
120:
121: PROCEDURE test_is_null(

Line 126: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');

122: p_value IN NUMBER, p_column IN VARCHAR2) IS
123: BEGIN
124: IF (p_value IS NULL) THEN
125: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
126: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
127: rcv_error_pkg.set_token('COLUMN', p_column);
128: rcv_error_pkg.log_interface_error(p_column);
129: END IF;
130: END test_is_null;

Line 127: rcv_error_pkg.set_token('COLUMN', p_column);

123: BEGIN
124: IF (p_value IS NULL) THEN
125: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
126: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
127: rcv_error_pkg.set_token('COLUMN', p_column);
128: rcv_error_pkg.log_interface_error(p_column);
129: END IF;
130: END test_is_null;
131:

Line 128: rcv_error_pkg.log_interface_error(p_column);

124: IF (p_value IS NULL) THEN
125: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
126: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
127: rcv_error_pkg.set_token('COLUMN', p_column);
128: rcv_error_pkg.log_interface_error(p_column);
129: END IF;
130: END test_is_null;
131:
132: PROCEDURE test_is_null(

Line 137: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');

133: p_value IN DATE, p_column IN VARCHAR2) IS
134: BEGIN
135: IF (p_value IS NULL) THEN
136: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
137: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
138: rcv_error_pkg.set_token('COLUMN', p_column);
139: rcv_error_pkg.log_interface_error(p_column);
140: END IF;
141: END test_is_null;

Line 138: rcv_error_pkg.set_token('COLUMN', p_column);

134: BEGIN
135: IF (p_value IS NULL) THEN
136: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
137: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
138: rcv_error_pkg.set_token('COLUMN', p_column);
139: rcv_error_pkg.log_interface_error(p_column);
140: END IF;
141: END test_is_null;
142: */

Line 139: rcv_error_pkg.log_interface_error(p_column);

135: IF (p_value IS NULL) THEN
136: asn_debug.put_line('fail assert test_is_null for column ' || p_column);
137: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
138: rcv_error_pkg.set_token('COLUMN', p_column);
139: rcv_error_pkg.log_interface_error(p_column);
140: END IF;
141: END test_is_null;
142: */
143: PROCEDURE invalid_match_value(

Line 149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');

145: p_sys_value IN VARCHAR2,
146: p_column IN VARCHAR2
147: ) IS
148: BEGIN
149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
150: rcv_error_pkg.set_token('COLUMN', p_column);
151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);
152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);
153: rcv_error_pkg.log_interface_error(g_curr_table,

Line 150: rcv_error_pkg.set_token('COLUMN', p_column);

146: p_column IN VARCHAR2
147: ) IS
148: BEGIN
149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
150: rcv_error_pkg.set_token('COLUMN', p_column);
151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);
152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);
153: rcv_error_pkg.log_interface_error(g_curr_table,
154: p_column,

Line 151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);

147: ) IS
148: BEGIN
149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
150: rcv_error_pkg.set_token('COLUMN', p_column);
151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);
152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);
153: rcv_error_pkg.log_interface_error(g_curr_table,
154: p_column,
155: g_curr_group_id,

Line 152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);

148: BEGIN
149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
150: rcv_error_pkg.set_token('COLUMN', p_column);
151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);
152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);
153: rcv_error_pkg.log_interface_error(g_curr_table,
154: p_column,
155: g_curr_group_id,
156: g_curr_header_id,

Line 153: rcv_error_pkg.log_interface_error(g_curr_table,

149: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
150: rcv_error_pkg.set_token('COLUMN', p_column);
151: rcv_error_pkg.set_token('ROI_VALUE', p_roi_value);
152: rcv_error_pkg.set_token('SYS_VALUE', p_sys_value);
153: rcv_error_pkg.log_interface_error(g_curr_table,
154: p_column,
155: g_curr_group_id,
156: g_curr_header_id,
157: g_curr_transaction_id

Line 165: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');

161: PROCEDURE invalid_null_value(
162: p_column IN VARCHAR2
163: ) IS
164: BEGIN
165: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
166: rcv_error_pkg.set_token('COLUMN', p_column);
167: rcv_error_pkg.log_interface_error(g_curr_table,
168: p_column,
169: g_curr_group_id,

Line 166: rcv_error_pkg.set_token('COLUMN', p_column);

162: p_column IN VARCHAR2
163: ) IS
164: BEGIN
165: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
166: rcv_error_pkg.set_token('COLUMN', p_column);
167: rcv_error_pkg.log_interface_error(g_curr_table,
168: p_column,
169: g_curr_group_id,
170: g_curr_header_id,

Line 167: rcv_error_pkg.log_interface_error(g_curr_table,

163: ) IS
164: BEGIN
165: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL');
166: rcv_error_pkg.set_token('COLUMN', p_column);
167: rcv_error_pkg.log_interface_error(g_curr_table,
168: p_column,
169: g_curr_group_id,
170: g_curr_header_id,
171: g_curr_transaction_id

Line 180: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

176: p_value IN VARCHAR2,
177: p_column IN VARCHAR2
178: ) IS
179: BEGIN
180: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
181: rcv_error_pkg.set_token('COLUMN', p_column);
182: rcv_error_pkg.set_token('ROI_VALUE', p_value);
183: rcv_error_pkg.log_interface_error(g_curr_table,
184: p_column,

Line 181: rcv_error_pkg.set_token('COLUMN', p_column);

177: p_column IN VARCHAR2
178: ) IS
179: BEGIN
180: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
181: rcv_error_pkg.set_token('COLUMN', p_column);
182: rcv_error_pkg.set_token('ROI_VALUE', p_value);
183: rcv_error_pkg.log_interface_error(g_curr_table,
184: p_column,
185: g_curr_group_id,

Line 182: rcv_error_pkg.set_token('ROI_VALUE', p_value);

178: ) IS
179: BEGIN
180: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
181: rcv_error_pkg.set_token('COLUMN', p_column);
182: rcv_error_pkg.set_token('ROI_VALUE', p_value);
183: rcv_error_pkg.log_interface_error(g_curr_table,
184: p_column,
185: g_curr_group_id,
186: g_curr_header_id,

Line 183: rcv_error_pkg.log_interface_error(g_curr_table,

179: BEGIN
180: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
181: rcv_error_pkg.set_token('COLUMN', p_column);
182: rcv_error_pkg.set_token('ROI_VALUE', p_value);
183: rcv_error_pkg.log_interface_error(g_curr_table,
184: p_column,
185: g_curr_group_id,
186: g_curr_header_id,
187: g_curr_transaction_id

Line 196: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

192: p_value IN NUMBER,
193: p_column IN VARCHAR2
194: ) IS
195: BEGIN
196: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
197: rcv_error_pkg.set_token('COLUMN', p_column);
198: rcv_error_pkg.set_token('ROI_VALUE', p_value);
199: rcv_error_pkg.log_interface_error(g_curr_table,
200: p_column,

Line 197: rcv_error_pkg.set_token('COLUMN', p_column);

193: p_column IN VARCHAR2
194: ) IS
195: BEGIN
196: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
197: rcv_error_pkg.set_token('COLUMN', p_column);
198: rcv_error_pkg.set_token('ROI_VALUE', p_value);
199: rcv_error_pkg.log_interface_error(g_curr_table,
200: p_column,
201: g_curr_group_id,

Line 198: rcv_error_pkg.set_token('ROI_VALUE', p_value);

194: ) IS
195: BEGIN
196: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
197: rcv_error_pkg.set_token('COLUMN', p_column);
198: rcv_error_pkg.set_token('ROI_VALUE', p_value);
199: rcv_error_pkg.log_interface_error(g_curr_table,
200: p_column,
201: g_curr_group_id,
202: g_curr_header_id,

Line 199: rcv_error_pkg.log_interface_error(g_curr_table,

195: BEGIN
196: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
197: rcv_error_pkg.set_token('COLUMN', p_column);
198: rcv_error_pkg.set_token('ROI_VALUE', p_value);
199: rcv_error_pkg.log_interface_error(g_curr_table,
200: p_column,
201: g_curr_group_id,
202: g_curr_header_id,
203: g_curr_transaction_id

Line 212: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

208: p_value IN DATE,
209: p_column IN VARCHAR2
210: ) IS
211: BEGIN
212: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
213: rcv_error_pkg.set_token('COLUMN', p_column);
214: rcv_error_pkg.set_token('ROI_VALUE', p_value);
215: rcv_error_pkg.log_interface_error(g_curr_table,
216: p_column,

Line 213: rcv_error_pkg.set_token('COLUMN', p_column);

209: p_column IN VARCHAR2
210: ) IS
211: BEGIN
212: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
213: rcv_error_pkg.set_token('COLUMN', p_column);
214: rcv_error_pkg.set_token('ROI_VALUE', p_value);
215: rcv_error_pkg.log_interface_error(g_curr_table,
216: p_column,
217: g_curr_group_id,

Line 214: rcv_error_pkg.set_token('ROI_VALUE', p_value);

210: ) IS
211: BEGIN
212: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
213: rcv_error_pkg.set_token('COLUMN', p_column);
214: rcv_error_pkg.set_token('ROI_VALUE', p_value);
215: rcv_error_pkg.log_interface_error(g_curr_table,
216: p_column,
217: g_curr_group_id,
218: g_curr_header_id,

Line 215: rcv_error_pkg.log_interface_error(g_curr_table,

211: BEGIN
212: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
213: rcv_error_pkg.set_token('COLUMN', p_column);
214: rcv_error_pkg.set_token('ROI_VALUE', p_value);
215: rcv_error_pkg.log_interface_error(g_curr_table,
216: p_column,
217: g_curr_group_id,
218: g_curr_header_id,
219: g_curr_transaction_id

Line 1396: rcv_error_pkg.set_error_message('RCV_VENDOR_ALL_NULL');

1392: END IF;
1393: -- Bug 6434823, Bug 6603681, Bug 7651399
1394: asn_debug.put_line('checking for rhi vendor fields');
1395: If (rhi.receipt_source_code = 'VENDOR' and rhi.vendor_id IS NULL AND rhi.vendor_name IS NULL AND rhi.vendor_num IS NULL) Then
1396: rcv_error_pkg.set_error_message('RCV_VENDOR_ALL_NULL');
1397: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1398: 'VENDOR_ID',
1399: g_curr_group_id,
1400: g_curr_header_id,

Line 1397: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1393: -- Bug 6434823, Bug 6603681, Bug 7651399
1394: asn_debug.put_line('checking for rhi vendor fields');
1395: If (rhi.receipt_source_code = 'VENDOR' and rhi.vendor_id IS NULL AND rhi.vendor_name IS NULL AND rhi.vendor_num IS NULL) Then
1396: rcv_error_pkg.set_error_message('RCV_VENDOR_ALL_NULL');
1397: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1398: 'VENDOR_ID',
1399: g_curr_group_id,
1400: g_curr_header_id,
1401: g_curr_transaction_id);

Line 2814: rcv_error_pkg.set_error_message('RCV_HEADER_IS_ERROR');

2810: END IF;
2811:
2812: /* it is ok if a header has previously been processed. */
2813: IF (rhi.processing_status_code = 'ERROR') THEN
2814: rcv_error_pkg.set_error_message('RCV_HEADER_IS_ERROR');
2815: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', rhi.header_interface_id);
2816: rcv_error_pkg.log_interface_error('HEADER_INTERFACE_ID');
2817: END IF;
2818:

Line 2815: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', rhi.header_interface_id);

2811:
2812: /* it is ok if a header has previously been processed. */
2813: IF (rhi.processing_status_code = 'ERROR') THEN
2814: rcv_error_pkg.set_error_message('RCV_HEADER_IS_ERROR');
2815: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', rhi.header_interface_id);
2816: rcv_error_pkg.log_interface_error('HEADER_INTERFACE_ID');
2817: END IF;
2818:
2819: IF ( rhi.GROUP_ID IS NULL

Line 2816: rcv_error_pkg.log_interface_error('HEADER_INTERFACE_ID');

2812: /* it is ok if a header has previously been processed. */
2813: IF (rhi.processing_status_code = 'ERROR') THEN
2814: rcv_error_pkg.set_error_message('RCV_HEADER_IS_ERROR');
2815: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', rhi.header_interface_id);
2816: rcv_error_pkg.log_interface_error('HEADER_INTERFACE_ID');
2817: END IF;
2818:
2819: IF ( rhi.GROUP_ID IS NULL
2820: AND rti.GROUP_ID IS NOT NULL) THEN

Line 3164: rcv_error_pkg.set_error_message('RCV_INTERFACE_PARENT_NOT_PENDING');

3160:
3161: /* PENDING is the only status that's going to get processed, therefore
3162: everything else is an error */
3163: IF (prti.processing_status_code <> 'PENDING') THEN
3164: rcv_error_pkg.set_error_message('RCV_INTERFACE_PARENT_NOT_PENDING');
3165: rcv_error_pkg.set_token('PARENT_INTERFACE_TXN_ID', prti.parent_interface_txn_id);
3166: rcv_error_pkg.log_interface_error('PARENT_INTERFACE_TXN_ID');
3167: END IF;
3168:

Line 3165: rcv_error_pkg.set_token('PARENT_INTERFACE_TXN_ID', prti.parent_interface_txn_id);

3161: /* PENDING is the only status that's going to get processed, therefore
3162: everything else is an error */
3163: IF (prti.processing_status_code <> 'PENDING') THEN
3164: rcv_error_pkg.set_error_message('RCV_INTERFACE_PARENT_NOT_PENDING');
3165: rcv_error_pkg.set_token('PARENT_INTERFACE_TXN_ID', prti.parent_interface_txn_id);
3166: rcv_error_pkg.log_interface_error('PARENT_INTERFACE_TXN_ID');
3167: END IF;
3168:
3169: IF (rti.document_distribution_num IS NULL) THEN

Line 3166: rcv_error_pkg.log_interface_error('PARENT_INTERFACE_TXN_ID');

3162: everything else is an error */
3163: IF (prti.processing_status_code <> 'PENDING') THEN
3164: rcv_error_pkg.set_error_message('RCV_INTERFACE_PARENT_NOT_PENDING');
3165: rcv_error_pkg.set_token('PARENT_INTERFACE_TXN_ID', prti.parent_interface_txn_id);
3166: rcv_error_pkg.log_interface_error('PARENT_INTERFACE_TXN_ID');
3167: END IF;
3168:
3169: IF (rti.document_distribution_num IS NULL) THEN
3170: rti.document_distribution_num := prti.document_distribution_num;

Line 7179: rcv_error_pkg.log_interface_error(g_curr_table,

7175: rhi.expected_receipt_date := SYSDATE;
7176: END IF;
7177: EXCEPTION
7178: WHEN rcv_table_functions.e_fatal_error THEN
7179: rcv_error_pkg.log_interface_error(g_curr_table,
7180: rcv_table_functions.g_error_column,
7181: g_curr_group_id,
7182: g_curr_header_id,
7183: g_curr_transaction_id

Line 7185: WHEN rcv_error_pkg.e_fatal_error THEN

7181: g_curr_group_id,
7182: g_curr_header_id,
7183: g_curr_transaction_id
7184: );
7185: WHEN rcv_error_pkg.e_fatal_error THEN
7186: RAISE rcv_error_pkg.e_fatal_error;
7187: WHEN OTHERS THEN
7188: rcv_error_pkg.set_sql_error_message('default_header', '000');
7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');

Line 7186: RAISE rcv_error_pkg.e_fatal_error;

7182: g_curr_header_id,
7183: g_curr_transaction_id
7184: );
7185: WHEN rcv_error_pkg.e_fatal_error THEN
7186: RAISE rcv_error_pkg.e_fatal_error;
7187: WHEN OTHERS THEN
7188: rcv_error_pkg.set_sql_error_message('default_header', '000');
7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7190: END default_header;

Line 7188: rcv_error_pkg.set_sql_error_message('default_header', '000');

7184: );
7185: WHEN rcv_error_pkg.e_fatal_error THEN
7186: RAISE rcv_error_pkg.e_fatal_error;
7187: WHEN OTHERS THEN
7188: rcv_error_pkg.set_sql_error_message('default_header', '000');
7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7190: END default_header;
7191:
7192: PROCEDURE default_transaction(

Line 7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');

7185: WHEN rcv_error_pkg.e_fatal_error THEN
7186: RAISE rcv_error_pkg.e_fatal_error;
7187: WHEN OTHERS THEN
7188: rcv_error_pkg.set_sql_error_message('default_header', '000');
7189: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7190: END default_header;
7191:
7192: PROCEDURE default_transaction(
7193: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

Line 7239: rcv_error_pkg.set_error_message('RCV_CANNOT_HAVE_2_PARENT');

7235: elapsed_time('default_rti_from_rhi');
7236:
7237: IF ( rti.parent_interface_txn_id IS NOT NULL
7238: AND rti.parent_transaction_id IS NOT NULL) THEN
7239: rcv_error_pkg.set_error_message('RCV_CANNOT_HAVE_2_PARENT');
7240: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
7241: END IF;
7242:
7243: default_rti_from_rti(rti);

Line 7240: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');

7236:
7237: IF ( rti.parent_interface_txn_id IS NOT NULL
7238: AND rti.parent_transaction_id IS NOT NULL) THEN
7239: rcv_error_pkg.set_error_message('RCV_CANNOT_HAVE_2_PARENT');
7240: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
7241: END IF;
7242:
7243: default_rti_from_rti(rti);
7244: elapsed_time('default_rti_from_rti');

Line 7722: rcv_error_pkg.log_interface_error(g_curr_table,

7718: rti.from_subinventory := x_temp_subinv;
7719: END IF;
7720: */
7721:
7722: rcv_error_pkg.log_interface_error(g_curr_table,
7723: rcv_table_functions.g_error_column,
7724: g_curr_group_id,
7725: g_curr_header_id,
7726: g_curr_transaction_id

Line 7728: WHEN rcv_error_pkg.e_fatal_error THEN

7724: g_curr_group_id,
7725: g_curr_header_id,
7726: g_curr_transaction_id
7727: );
7728: WHEN rcv_error_pkg.e_fatal_error THEN
7729: /* Bug 5584736.
7730: * We have a detailed defaulting routine for defaulting
7731: * subinventory and locator later. Commenting out this code
7732: * here since this is creating problems later.

Line 7743: RAISE rcv_error_pkg.e_fatal_error;

7739: rti.from_subinventory := x_temp_subinv;
7740: END IF;
7741: */
7742:
7743: RAISE rcv_error_pkg.e_fatal_error;
7744: WHEN OTHERS THEN
7745: /* Bug 5584736.
7746: * We have a detailed defaulting routine for defaulting
7747: * subinventory and locator later. Commenting out this code

Line 7759: rcv_error_pkg.set_sql_error_message('deafault_transaction', '000');

7755: rti.from_subinventory := x_temp_subinv;
7756: END IF;
7757: */
7758:
7759: rcv_error_pkg.set_sql_error_message('deafault_transaction', '000');
7760: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7761: END default_transaction;
7762:
7763: PROCEDURE default_from_parent(

Line 7760: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');

7756: END IF;
7757: */
7758:
7759: rcv_error_pkg.set_sql_error_message('deafault_transaction', '000');
7760: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
7761: END default_transaction;
7762:
7763: PROCEDURE default_from_parent(
7764: rti IN OUT NOCOPY rcv_transactions_interface%ROWTYPE