APPS.RCV_SHIPMENT_OBJECT_SV dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

1: PACKAGE BODY rcv_shipment_object_sv AS
2: /* $Header: RCVCHTIB.pls 120.1 2005/06/29 00:52:00 pjiang noship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6:
7: /*===========================================================================
8:
9: PROCEDURE NAME: create_object()

Line 31: IF (g_asn_debug = 'Y') THEN

27: n BINARY_INTEGER := 0;
28: x_current_line_status VARCHAR2(1) := 'S';
29: x_fail_if_one_line_fails VARCHAR2(1) := 'N';
30: BEGIN
31: IF (g_asn_debug = 'Y') THEN
32: asn_debug.put_line('Enter shipment object create');
33: END IF;
34:
35: x_progress := '000';

Line 32: asn_debug.put_line('Enter shipment object create');

28: x_current_line_status VARCHAR2(1) := 'S';
29: x_fail_if_one_line_fails VARCHAR2(1) := 'N';
30: BEGIN
31: IF (g_asn_debug = 'Y') THEN
32: asn_debug.put_line('Enter shipment object create');
33: END IF;
34:
35: x_progress := '000';
36:

Line 37: IF (g_asn_debug = 'Y') THEN

33: END IF;
34:
35: x_progress := '000';
36:
37: IF (g_asn_debug = 'Y') THEN
38: asn_debug.put_line('Enter garbage processor');
39: END IF;
40:
41: -- Need to do garbage collection before anything else

Line 38: asn_debug.put_line('Enter garbage processor');

34:
35: x_progress := '000';
36:
37: IF (g_asn_debug = 'Y') THEN
38: asn_debug.put_line('Enter garbage processor');
39: END IF;
40:
41: -- Need to do garbage collection before anything else
42: -- as we may have some ASNs that are entirely invalid

Line 51: IF (g_asn_debug = 'Y') THEN

47: -- The call to garbage collector is for Bug 2367174.
48:
49: x_progress := '001';
50:
51: IF (g_asn_debug = 'Y') THEN
52: asn_debug.put_line('Calling the Garbage collector');
53: END IF;
54:
55: -- bug2626270 - pass x_group_id into collect_garbage procedure also

Line 52: asn_debug.put_line('Calling the Garbage collector');

48:
49: x_progress := '001';
50:
51: IF (g_asn_debug = 'Y') THEN
52: asn_debug.put_line('Calling the Garbage collector');
53: END IF;
54:
55: -- bug2626270 - pass x_group_id into collect_garbage procedure also
56: rcv_garbage_collector_sv.collect_garbage(x_request_id, x_group_id);

Line 58: IF (g_asn_debug = 'Y') THEN

54:
55: -- bug2626270 - pass x_group_id into collect_garbage procedure also
56: rcv_garbage_collector_sv.collect_garbage(x_request_id, x_group_id);
57:
58: IF (g_asn_debug = 'Y') THEN
59: asn_debug.put_line('Enter shipment object create');
60: END IF;
61:
62: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_if_one_line_fails);

Line 59: asn_debug.put_line('Enter shipment object create');

55: -- bug2626270 - pass x_group_id into collect_garbage procedure also
56: rcv_garbage_collector_sv.collect_garbage(x_request_id, x_group_id);
57:
58: IF (g_asn_debug = 'Y') THEN
59: asn_debug.put_line('Enter shipment object create');
60: END IF;
61:
62: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_if_one_line_fails);
63:

Line 64: IF (g_asn_debug = 'Y') THEN

60: END IF;
61:
62: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_if_one_line_fails);
63:
64: IF (g_asn_debug = 'Y') THEN
65: asn_debug.put_line('RCV_FAIL_IF_LINE_FAILS profile option =' || x_fail_if_one_line_fails);
66: END IF;
67:
68: --ksareddy 2506961 - performance bug - cache the install status of EC

Line 65: asn_debug.put_line('RCV_FAIL_IF_LINE_FAILS profile option =' || x_fail_if_one_line_fails);

61:
62: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_if_one_line_fails);
63:
64: IF (g_asn_debug = 'Y') THEN
65: asn_debug.put_line('RCV_FAIL_IF_LINE_FAILS profile option =' || x_fail_if_one_line_fails);
66: END IF;
67:
68: --ksareddy 2506961 - performance bug - cache the install status of EC
69: --X_edi_install := po_core_s.get_product_install_status('EC'); --2187209

Line 81: IF (g_asn_debug = 'Y') THEN

77:
78: LOOP
79: FETCH rcv_shipment_object_sv.c1 INTO x_header_record.header_record;
80:
81: IF (g_asn_debug = 'Y') THEN
82: asn_debug.put_line(TO_CHAR(rcv_shipment_object_sv.c1%ROWCOUNT));
83: END IF;
84:
85: EXIT WHEN rcv_shipment_object_sv.c1%NOTFOUND;

Line 82: asn_debug.put_line(TO_CHAR(rcv_shipment_object_sv.c1%ROWCOUNT));

78: LOOP
79: FETCH rcv_shipment_object_sv.c1 INTO x_header_record.header_record;
80:
81: IF (g_asn_debug = 'Y') THEN
82: asn_debug.put_line(TO_CHAR(rcv_shipment_object_sv.c1%ROWCOUNT));
83: END IF;
84:
85: EXIT WHEN rcv_shipment_object_sv.c1%NOTFOUND;
86: x_progress := '020';

Line 92: IF (g_asn_debug = 'Y') THEN

88: x_error_record.error_message := NULL;
89: x_header_record.error_record := x_error_record;
90:
91: IF x_header_record.header_record.transaction_type = 'CANCEL' THEN
92: IF (g_asn_debug = 'Y') THEN
93: asn_debug.put_line('Enter Cancel Shipment ');
94: END IF;
95:
96: rcv_shipment_header_sv.cancel_shipment(x_header_record);

Line 93: asn_debug.put_line('Enter Cancel Shipment ');

89: x_header_record.error_record := x_error_record;
90:
91: IF x_header_record.header_record.transaction_type = 'CANCEL' THEN
92: IF (g_asn_debug = 'Y') THEN
93: asn_debug.put_line('Enter Cancel Shipment ');
94: END IF;
95:
96: rcv_shipment_header_sv.cancel_shipment(x_header_record);
97:

Line 105: IF (g_asn_debug = 'Y') THEN

101: validation_flag = 'N',
102: receipt_header_id = x_header_record.header_record.receipt_header_id
103: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
104:
105: IF (g_asn_debug = 'Y') THEN
106: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');
107: END IF;
108:
109: -- bug 654099, should not insert into PO Interface Errors table if there is no error

Line 106: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');

102: receipt_header_id = x_header_record.header_record.receipt_header_id
103: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
104:
105: IF (g_asn_debug = 'Y') THEN
106: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');
107: END IF;
108:
109: -- bug 654099, should not insert into PO Interface Errors table if there is no error
110: -- otherwise, 824 will pick it up and send to customers

Line 111: IF (g_asn_debug = 'Y') THEN

107: END IF;
108:
109: -- bug 654099, should not insert into PO Interface Errors table if there is no error
110: -- otherwise, 824 will pick it up and send to customers
111: IF (g_asn_debug = 'Y') THEN
112: asn_debug.put_line('ASN cancelled without errors');
113: END IF;
114: ELSE
115: -- the header failed

Line 112: asn_debug.put_line('ASN cancelled without errors');

108:
109: -- bug 654099, should not insert into PO Interface Errors table if there is no error
110: -- otherwise, 824 will pick it up and send to customers
111: IF (g_asn_debug = 'Y') THEN
112: asn_debug.put_line('ASN cancelled without errors');
113: END IF;
114: ELSE
115: -- the header failed
116: -- error status for the header is either 'E' or 'U'

Line 118: IF (g_asn_debug = 'Y') THEN

114: ELSE
115: -- the header failed
116: -- error status for the header is either 'E' or 'U'
117:
118: IF (g_asn_debug = 'Y') THEN
119: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
121: asn_debug.put_line('ASN could not be cancelled');
122: END IF;

Line 119: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');

115: -- the header failed
116: -- error status for the header is either 'E' or 'U'
117:
118: IF (g_asn_debug = 'Y') THEN
119: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
121: asn_debug.put_line('ASN could not be cancelled');
122: END IF;
123:

Line 120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));

116: -- error status for the header is either 'E' or 'U'
117:
118: IF (g_asn_debug = 'Y') THEN
119: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
121: asn_debug.put_line('ASN could not be cancelled');
122: END IF;
123:
124: UPDATE rcv_headers_interface

Line 121: asn_debug.put_line('ASN could not be cancelled');

117:
118: IF (g_asn_debug = 'Y') THEN
119: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
121: asn_debug.put_line('ASN could not be cancelled');
122: END IF;
123:
124: UPDATE rcv_headers_interface
125: SET processing_status_code = 'ERROR'

Line 143: IF (g_asn_debug = 'Y') THEN

139: FALSE
140: );
141: END IF;
142: ELSE
143: IF (g_asn_debug = 'Y') THEN
144: asn_debug.put_line('Enter create shipment header');
145: END IF;
146:
147: rcv_shipment_header_sv.create_shipment_header(x_header_record);

Line 144: asn_debug.put_line('Enter create shipment header');

140: );
141: END IF;
142: ELSE
143: IF (g_asn_debug = 'Y') THEN
144: asn_debug.put_line('Enter create shipment header');
145: END IF;
146:
147: rcv_shipment_header_sv.create_shipment_header(x_header_record);
148:

Line 149: IF (g_asn_debug = 'Y') THEN

145: END IF;
146:
147: rcv_shipment_header_sv.create_shipment_header(x_header_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(x_header_record.error_record.error_status);
151: asn_debug.put_line(x_header_record.error_record.error_message);
152: END IF;
153:

Line 150: asn_debug.put_line(x_header_record.error_record.error_status);

146:
147: rcv_shipment_header_sv.create_shipment_header(x_header_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(x_header_record.error_record.error_status);
151: asn_debug.put_line(x_header_record.error_record.error_message);
152: END IF;
153:
154: IF (x_header_record.error_record.error_status IN('S', 'W')) THEN

Line 151: asn_debug.put_line(x_header_record.error_record.error_message);

147: rcv_shipment_header_sv.create_shipment_header(x_header_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(x_header_record.error_record.error_status);
151: asn_debug.put_line(x_header_record.error_record.error_message);
152: END IF;
153:
154: IF (x_header_record.error_record.error_status IN('S', 'W')) THEN
155: x_progress := '030';

Line 160: IF (g_asn_debug = 'Y') THEN

156: x_all_lines_fatal := TRUE;
157: x_any_line_error_flag := FALSE;
158:
159: -- x_header_record.header_interface_id is not null thru table....
160: IF (g_asn_debug = 'Y') THEN
161: asn_debug.put_line('In lines');
162: asn_debug.put_line(TO_CHAR(x_header_record.header_record.header_interface_id));
163: END IF;
164:

Line 161: asn_debug.put_line('In lines');

157: x_any_line_error_flag := FALSE;
158:
159: -- x_header_record.header_interface_id is not null thru table....
160: IF (g_asn_debug = 'Y') THEN
161: asn_debug.put_line('In lines');
162: asn_debug.put_line(TO_CHAR(x_header_record.header_record.header_interface_id));
163: END IF;
164:
165: OPEN rcv_shipment_object_sv.c2(x_header_record.header_record.header_interface_id);

Line 162: asn_debug.put_line(TO_CHAR(x_header_record.header_record.header_interface_id));

158:
159: -- x_header_record.header_interface_id is not null thru table....
160: IF (g_asn_debug = 'Y') THEN
161: asn_debug.put_line('In lines');
162: asn_debug.put_line(TO_CHAR(x_header_record.header_record.header_interface_id));
163: END IF;
164:
165: OPEN rcv_shipment_object_sv.c2(x_header_record.header_record.header_interface_id);
166: n := 0;

Line 174: IF (g_asn_debug = 'Y') THEN

170:
171: LOOP
172: n := n + 1;
173:
174: IF (g_asn_debug = 'Y') THEN
175: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
176: asn_debug.put_line('No of records in cascaded table ' || TO_CHAR(x_cascaded_table.COUNT));
177: END IF;
178:

Line 175: asn_debug.put_line('Current counter is ' || TO_CHAR(n));

171: LOOP
172: n := n + 1;
173:
174: IF (g_asn_debug = 'Y') THEN
175: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
176: asn_debug.put_line('No of records in cascaded table ' || TO_CHAR(x_cascaded_table.COUNT));
177: END IF;
178:
179: FETCH rcv_shipment_object_sv.c2 INTO x_cascaded_table(n);

Line 176: asn_debug.put_line('No of records in cascaded table ' || TO_CHAR(x_cascaded_table.COUNT));

172: n := n + 1;
173:
174: IF (g_asn_debug = 'Y') THEN
175: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
176: asn_debug.put_line('No of records in cascaded table ' || TO_CHAR(x_cascaded_table.COUNT));
177: END IF;
178:
179: FETCH rcv_shipment_object_sv.c2 INTO x_cascaded_table(n);
180: EXIT WHEN( rcv_shipment_object_sv.c2%NOTFOUND

Line 186: IF (g_asn_debug = 'Y') THEN

182: x_progress := '040';
183: x_cascaded_table(n).error_status := x_current_line_status;
184: x_cascaded_table(n).error_message := NULL;
185:
186: IF (g_asn_debug = 'Y') THEN
187: asn_debug.put_line('Shipment number ' || x_header_record.header_record.shipment_num);
188: END IF;
189:
190: rcv_shipment_line_sv.create_shipment_line(x_cascaded_table,

Line 187: asn_debug.put_line('Shipment number ' || x_header_record.header_record.shipment_num);

183: x_cascaded_table(n).error_status := x_current_line_status;
184: x_cascaded_table(n).error_message := NULL;
185:
186: IF (g_asn_debug = 'Y') THEN
187: asn_debug.put_line('Shipment number ' || x_header_record.header_record.shipment_num);
188: END IF;
189:
190: rcv_shipment_line_sv.create_shipment_line(x_cascaded_table,
191: n,

Line 197: IF (g_asn_debug = 'Y') THEN

193: x_header_record.header_record.asn_type,
194: x_header_record
195: );
196:
197: IF (g_asn_debug = 'Y') THEN
198: asn_debug.put_line('Back from create shipment line');
199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
200: END IF;
201:

Line 198: asn_debug.put_line('Back from create shipment line');

194: x_header_record
195: );
196:
197: IF (g_asn_debug = 'Y') THEN
198: asn_debug.put_line('Back from create shipment line');
199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
200: END IF;
201:
202: IF (g_asn_debug = 'Y') THEN

Line 199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));

195: );
196:
197: IF (g_asn_debug = 'Y') THEN
198: asn_debug.put_line('Back from create shipment line');
199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
200: END IF;
201:
202: IF (g_asn_debug = 'Y') THEN
203: asn_debug.put_line('Error Status For Create Shipment Line=' || x_cascaded_table(n).error_status);

Line 202: IF (g_asn_debug = 'Y') THEN

198: asn_debug.put_line('Back from create shipment line');
199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
200: END IF;
201:
202: IF (g_asn_debug = 'Y') THEN
203: asn_debug.put_line('Error Status For Create Shipment Line=' || x_cascaded_table(n).error_status);
204: END IF;
205:
206: /*

Line 203: asn_debug.put_line('Error Status For Create Shipment Line=' || x_cascaded_table(n).error_status);

199: asn_debug.put_line('Current counter is ' || TO_CHAR(n));
200: END IF;
201:
202: IF (g_asn_debug = 'Y') THEN
203: asn_debug.put_line('Error Status For Create Shipment Line=' || x_cascaded_table(n).error_status);
204: END IF;
205:
206: /*
207: ** If one line has failed, check if the profile value that

Line 240: IF (g_asn_debug = 'Y') THEN

236: FOR i IN 1 .. n LOOP
237: x_cascaded_table(i).error_status := 'E';
238: END LOOP;
239:
240: IF (g_asn_debug = 'Y') THEN
241: asn_debug.put_line('Since some of the transaction lines are related to Consigned Inventory');
242: asn_debug.put_line('Set all the transaction lines error_status E');
243: END IF;
244:

Line 241: asn_debug.put_line('Since some of the transaction lines are related to Consigned Inventory');

237: x_cascaded_table(i).error_status := 'E';
238: END LOOP;
239:
240: IF (g_asn_debug = 'Y') THEN
241: asn_debug.put_line('Since some of the transaction lines are related to Consigned Inventory');
242: asn_debug.put_line('Set all the transaction lines error_status E');
243: END IF;
244:
245: x_current_line_status := 'E';

Line 242: asn_debug.put_line('Set all the transaction lines error_status E');

238: END LOOP;
239:
240: IF (g_asn_debug = 'Y') THEN
241: asn_debug.put_line('Since some of the transaction lines are related to Consigned Inventory');
242: asn_debug.put_line('Set all the transaction lines error_status E');
243: END IF;
244:
245: x_current_line_status := 'E';
246: x_all_lines_fatal := TRUE;

Line 255: IF (g_asn_debug = 'Y') THEN

251: -- Loop thru the plsql table for any success/warning at line level
252: -- If any line is a success then we need to insert the line level data
253:
254: FOR i IN 1 .. x_cascaded_table.COUNT LOOP
255: IF (g_asn_debug = 'Y') THEN
256: asn_debug.put_line(x_cascaded_table(i).error_status);
257: END IF;
258:
259: IF (x_cascaded_table(i).error_status IN('S', 'W')) THEN

Line 256: asn_debug.put_line(x_cascaded_table(i).error_status);

252: -- If any line is a success then we need to insert the line level data
253:
254: FOR i IN 1 .. x_cascaded_table.COUNT LOOP
255: IF (g_asn_debug = 'Y') THEN
256: asn_debug.put_line(x_cascaded_table(i).error_status);
257: END IF;
258:
259: IF (x_cascaded_table(i).error_status IN('S', 'W')) THEN
260: x_all_lines_fatal := FALSE;

Line 268: IF (g_asn_debug = 'Y') THEN

264: END IF;
265: END LOOP;
266:
267: IF (x_all_lines_fatal) THEN
268: IF (g_asn_debug = 'Y') THEN
269: asn_debug.put_line('All lines were in error for the shipment ' || x_header_record.header_record.shipment_num);
270: END IF;
271:
272: -- Need to insert an error condition into the poi

Line 269: asn_debug.put_line('All lines were in error for the shipment ' || x_header_record.header_record.shipment_num);

265: END LOOP;
266:
267: IF (x_all_lines_fatal) THEN
268: IF (g_asn_debug = 'Y') THEN
269: asn_debug.put_line('All lines were in error for the shipment ' || x_header_record.header_record.shipment_num);
270: END IF;
271:
272: -- Need to insert an error condition into the poi
273:

Line 274: IF (g_asn_debug = 'Y') THEN

270: END IF;
271:
272: -- Need to insert an error condition into the poi
273:
274: IF (g_asn_debug = 'Y') THEN
275: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
276: END IF;
277:
278: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 275: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');

271:
272: -- Need to insert an error condition into the poi
273:
274: IF (g_asn_debug = 'Y') THEN
275: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
276: END IF;
277:
278: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
279: rcv_error_pkg.set_error_message('RCV_ASN_NOT_ACCEPT', x_header_record.error_record.error_message);

Line 312: IF (g_asn_debug = 'Y') THEN

308: rcv_asn_trx_insert.handle_rcv_asn_transactions(x_cascaded_table, x_header_record);
309: END IF;
310:
311: IF NOT x_any_line_error_flag THEN -- all lines were fine
312: IF (g_asn_debug = 'Y') THEN
313: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');
314: END IF;
315:
316: -- bug 654099, should not insert into PO Interface Errors table if

Line 313: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');

309: END IF;
310:
311: IF NOT x_any_line_error_flag THEN -- all lines were fine
312: IF (g_asn_debug = 'Y') THEN
313: asn_debug.put_line('RCV_ASN_ACCEPT_NO_ERR');
314: END IF;
315:
316: -- bug 654099, should not insert into PO Interface Errors table if
317: -- there is no error. Otherwise, 824 will pick it up and send to customers

Line 319: IF (g_asn_debug = 'Y') THEN

315:
316: -- bug 654099, should not insert into PO Interface Errors table if
317: -- there is no error. Otherwise, 824 will pick it up and send to customers
318:
319: IF (g_asn_debug = 'Y') THEN
320: asn_debug.put_line('ASN accepted without errors');
321: END IF;
322: ELSE
323: IF (g_asn_debug = 'Y') THEN

Line 320: asn_debug.put_line('ASN accepted without errors');

316: -- bug 654099, should not insert into PO Interface Errors table if
317: -- there is no error. Otherwise, 824 will pick it up and send to customers
318:
319: IF (g_asn_debug = 'Y') THEN
320: asn_debug.put_line('ASN accepted without errors');
321: END IF;
322: ELSE
323: IF (g_asn_debug = 'Y') THEN
324: asn_debug.put_line('ASN accepted with errors RCV_ASN_ACCEPT_W_ERR');

Line 323: IF (g_asn_debug = 'Y') THEN

319: IF (g_asn_debug = 'Y') THEN
320: asn_debug.put_line('ASN accepted without errors');
321: END IF;
322: ELSE
323: IF (g_asn_debug = 'Y') THEN
324: asn_debug.put_line('ASN accepted with errors RCV_ASN_ACCEPT_W_ERR');
325: END IF;
326:
327: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;

Line 324: asn_debug.put_line('ASN accepted with errors RCV_ASN_ACCEPT_W_ERR');

320: asn_debug.put_line('ASN accepted without errors');
321: END IF;
322: ELSE
323: IF (g_asn_debug = 'Y') THEN
324: asn_debug.put_line('ASN accepted with errors RCV_ASN_ACCEPT_W_ERR');
325: END IF;
326:
327: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
328: rcv_error_pkg.set_error_message('RCV_ASN_ACCEPT_W_ERR', x_header_record.error_record.error_message);

Line 341: IF (g_asn_debug = 'Y') THEN

337: AND x_any_line_error_flag THEN -- if any line is in error and type = ASBN
338: -- use this flag to reset invoice_status_code
339:
340: -- update the interface table
341: IF (g_asn_debug = 'Y') THEN
342: asn_debug.put_line('RCV_ASBN_NO_AUTO_INVOICE');
343: END IF;
344:
345: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;

Line 342: asn_debug.put_line('RCV_ASBN_NO_AUTO_INVOICE');

338: -- use this flag to reset invoice_status_code
339:
340: -- update the interface table
341: IF (g_asn_debug = 'Y') THEN
342: asn_debug.put_line('RCV_ASBN_NO_AUTO_INVOICE');
343: END IF;
344:
345: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
346: rcv_error_pkg.set_error_message('RCV_ASBN_NO_AUTO_INVOICE', x_header_record.error_record.error_message);

Line 379: IF (g_asn_debug = 'Y') THEN

375: ELSE
376: -- the header failed
377: -- error status for the header is either 'E' or 'U'
378:
379: IF (g_asn_debug = 'Y') THEN
380: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
381: END IF;
382:
383: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 380: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');

376: -- the header failed
377: -- error status for the header is either 'E' or 'U'
378:
379: IF (g_asn_debug = 'Y') THEN
380: asn_debug.put_line('RCV_ASN_NOT_ACCEPT');
381: END IF;
382:
383: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
384: rcv_error_pkg.set_error_message('RCV_ASN_NOT_ACCEPT', x_header_record.error_record.error_message);

Line 391: IF (g_asn_debug = 'Y') THEN

387: 'SHIPMENT_NUM',
388: FALSE
389: );
390:
391: IF (g_asn_debug = 'Y') THEN
392: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
393: END IF;
394:
395: UPDATE rcv_headers_interface

Line 392: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));

388: FALSE
389: );
390:
391: IF (g_asn_debug = 'Y') THEN
392: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
393: END IF;
394:
395: UPDATE rcv_headers_interface
396: SET processing_status_code = 'ERROR'

Line 424: IF (g_asn_debug = 'Y') THEN

420: END LOOP;
421:
422: CLOSE rcv_shipment_object_sv.c1;
423:
424: IF (g_asn_debug = 'Y') THEN
425: asn_debug.put_line('Exit shipment object create');
426: END IF;
427: END create_object;
428: END rcv_shipment_object_sv;

Line 425: asn_debug.put_line('Exit shipment object create');

421:
422: CLOSE rcv_shipment_object_sv.c1;
423:
424: IF (g_asn_debug = 'Y') THEN
425: asn_debug.put_line('Exit shipment object create');
426: END IF;
427: END create_object;
428: END rcv_shipment_object_sv;