eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_HEADER_COMMON dependencies on ASN_DEBUG

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

11: currency_record rcv_shipment_header_sv.currectype;
12: invoice_record rcv_shipment_header_sv.invrectype;
13: tax_record rcv_shipment_header_sv.taxrectype;
14: -- Read the profile option that enables/disables the debug log
15: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
16: x_sysdate DATE := SYSDATE;
17: x_count NUMBER := 0;
18: x_location_id NUMBER;
19: e_validation_error EXCEPTION;

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

39: ship_to_org_record.organization_id := p_header_record.header_record.ship_to_organization_id;
40: ship_to_org_record.error_record.error_status := p_header_record.error_record.error_status;
41: ship_to_org_record.error_record.error_message := p_header_record.error_record.error_message;
42:
43: IF (g_asn_debug = 'Y') THEN
44: asn_debug.put_line('In Ship to Organization Procedure');
45: END IF;
46:
47: po_orgs_sv.derive_org_info(ship_to_org_record);

Line 44: asn_debug.put_line('In Ship to Organization Procedure');

40: ship_to_org_record.error_record.error_status := p_header_record.error_record.error_status;
41: ship_to_org_record.error_record.error_message := p_header_record.error_record.error_message;
42:
43: IF (g_asn_debug = 'Y') THEN
44: asn_debug.put_line('In Ship to Organization Procedure');
45: END IF;
46:
47: po_orgs_sv.derive_org_info(ship_to_org_record);
48:

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

45: END IF;
46:
47: po_orgs_sv.derive_org_info(ship_to_org_record);
48:
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line(ship_to_org_record.organization_code);
51: asn_debug.put_line(TO_CHAR(ship_to_org_record.organization_id));
52: asn_debug.put_line(ship_to_org_record.error_record.error_status);
53: END IF;

Line 50: asn_debug.put_line(ship_to_org_record.organization_code);

46:
47: po_orgs_sv.derive_org_info(ship_to_org_record);
48:
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line(ship_to_org_record.organization_code);
51: asn_debug.put_line(TO_CHAR(ship_to_org_record.organization_id));
52: asn_debug.put_line(ship_to_org_record.error_record.error_status);
53: END IF;
54:

Line 51: asn_debug.put_line(TO_CHAR(ship_to_org_record.organization_id));

47: po_orgs_sv.derive_org_info(ship_to_org_record);
48:
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line(ship_to_org_record.organization_code);
51: asn_debug.put_line(TO_CHAR(ship_to_org_record.organization_id));
52: asn_debug.put_line(ship_to_org_record.error_record.error_status);
53: END IF;
54:
55: p_header_record.header_record.ship_to_organization_code := ship_to_org_record.organization_code;

Line 52: asn_debug.put_line(ship_to_org_record.error_record.error_status);

48:
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line(ship_to_org_record.organization_code);
51: asn_debug.put_line(TO_CHAR(ship_to_org_record.organization_id));
52: asn_debug.put_line(ship_to_org_record.error_record.error_status);
53: END IF;
54:
55: p_header_record.header_record.ship_to_organization_code := ship_to_org_record.organization_code;
56: p_header_record.header_record.ship_to_organization_id := ship_to_org_record.organization_id;

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

70: from_org_record.organization_id := p_header_record.header_record.from_organization_id;
71: from_org_record.error_record.error_status := p_header_record.error_record.error_status;
72: from_org_record.error_record.error_message := p_header_record.error_record.error_message;
73:
74: IF (g_asn_debug = 'Y') THEN
75: asn_debug.put_line('In From Organization Procedure');
76: END IF;
77:
78: po_orgs_sv.derive_org_info(from_org_record);

Line 75: asn_debug.put_line('In From Organization Procedure');

71: from_org_record.error_record.error_status := p_header_record.error_record.error_status;
72: from_org_record.error_record.error_message := p_header_record.error_record.error_message;
73:
74: IF (g_asn_debug = 'Y') THEN
75: asn_debug.put_line('In From Organization Procedure');
76: END IF;
77:
78: po_orgs_sv.derive_org_info(from_org_record);
79:

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

76: END IF;
77:
78: po_orgs_sv.derive_org_info(from_org_record);
79:
80: IF (g_asn_debug = 'Y') THEN
81: asn_debug.put_line(from_org_record.organization_code);
82: asn_debug.put_line(TO_CHAR(from_org_record.organization_id));
83: asn_debug.put_line(from_org_record.error_record.error_status);
84: END IF;

Line 81: asn_debug.put_line(from_org_record.organization_code);

77:
78: po_orgs_sv.derive_org_info(from_org_record);
79:
80: IF (g_asn_debug = 'Y') THEN
81: asn_debug.put_line(from_org_record.organization_code);
82: asn_debug.put_line(TO_CHAR(from_org_record.organization_id));
83: asn_debug.put_line(from_org_record.error_record.error_status);
84: END IF;
85:

Line 82: asn_debug.put_line(TO_CHAR(from_org_record.organization_id));

78: po_orgs_sv.derive_org_info(from_org_record);
79:
80: IF (g_asn_debug = 'Y') THEN
81: asn_debug.put_line(from_org_record.organization_code);
82: asn_debug.put_line(TO_CHAR(from_org_record.organization_id));
83: asn_debug.put_line(from_org_record.error_record.error_status);
84: END IF;
85:
86: p_header_record.header_record.from_organization_code := from_org_record.organization_code;

Line 83: asn_debug.put_line(from_org_record.error_record.error_status);

79:
80: IF (g_asn_debug = 'Y') THEN
81: asn_debug.put_line(from_org_record.organization_code);
82: asn_debug.put_line(TO_CHAR(from_org_record.organization_id));
83: asn_debug.put_line(from_org_record.error_record.error_status);
84: END IF;
85:
86: p_header_record.header_record.from_organization_code := from_org_record.organization_code;
87: p_header_record.header_record.from_organization_id := from_org_record.organization_id;

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

105: loc_record.location_id := p_header_record.header_record.location_id;
106: loc_record.error_record.error_status := p_header_record.error_record.error_status;
107: loc_record.error_record.error_message := p_header_record.error_record.error_message;
108:
109: IF (g_asn_debug = 'Y') THEN
110: asn_debug.put_line('In Location Code Procedure');
111: END IF;
112:
113: po_locations_s.derive_location_info(loc_record);

Line 110: asn_debug.put_line('In Location Code Procedure');

106: loc_record.error_record.error_status := p_header_record.error_record.error_status;
107: loc_record.error_record.error_message := p_header_record.error_record.error_message;
108:
109: IF (g_asn_debug = 'Y') THEN
110: asn_debug.put_line('In Location Code Procedure');
111: END IF;
112:
113: po_locations_s.derive_location_info(loc_record);
114:

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

111: END IF;
112:
113: po_locations_s.derive_location_info(loc_record);
114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line(loc_record.location_code);
117: asn_debug.put_line(TO_CHAR(loc_record.location_id));
118: asn_debug.put_line(loc_record.error_record.error_status);
119: END IF;

Line 116: asn_debug.put_line(loc_record.location_code);

112:
113: po_locations_s.derive_location_info(loc_record);
114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line(loc_record.location_code);
117: asn_debug.put_line(TO_CHAR(loc_record.location_id));
118: asn_debug.put_line(loc_record.error_record.error_status);
119: END IF;
120:

Line 117: asn_debug.put_line(TO_CHAR(loc_record.location_id));

113: po_locations_s.derive_location_info(loc_record);
114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line(loc_record.location_code);
117: asn_debug.put_line(TO_CHAR(loc_record.location_id));
118: asn_debug.put_line(loc_record.error_record.error_status);
119: END IF;
120:
121: p_header_record.header_record.location_code := loc_record.location_code;

Line 118: asn_debug.put_line(loc_record.error_record.error_status);

114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line(loc_record.location_code);
117: asn_debug.put_line(TO_CHAR(loc_record.location_id));
118: asn_debug.put_line(loc_record.error_record.error_status);
119: END IF;
120:
121: p_header_record.header_record.location_code := loc_record.location_code;
122: p_header_record.header_record.location_id := loc_record.location_id;

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

139: pay_record.payment_term_name := p_header_record.header_record.payment_terms_name;
140: pay_record.error_record.error_status := p_header_record.error_record.error_status;
141: pay_record.error_record.error_message := p_header_record.error_record.error_message;
142:
143: IF (g_asn_debug = 'Y') THEN
144: asn_debug.put_line('In Derive Payment Terms ');
145: END IF;
146:
147: po_terms_sv.derive_payment_terms_info(pay_record);

Line 144: asn_debug.put_line('In Derive Payment Terms ');

140: pay_record.error_record.error_status := p_header_record.error_record.error_status;
141: pay_record.error_record.error_message := p_header_record.error_record.error_message;
142:
143: IF (g_asn_debug = 'Y') THEN
144: asn_debug.put_line('In Derive Payment Terms ');
145: END IF;
146:
147: po_terms_sv.derive_payment_terms_info(pay_record);
148:

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

145: END IF;
146:
147: po_terms_sv.derive_payment_terms_info(pay_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(pay_record.payment_term_name);
151: asn_debug.put_line(TO_CHAR(pay_record.payment_term_id));
152: asn_debug.put_line(pay_record.error_record.error_status);
153: END IF;

Line 150: asn_debug.put_line(pay_record.payment_term_name);

146:
147: po_terms_sv.derive_payment_terms_info(pay_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(pay_record.payment_term_name);
151: asn_debug.put_line(TO_CHAR(pay_record.payment_term_id));
152: asn_debug.put_line(pay_record.error_record.error_status);
153: END IF;
154:

Line 151: asn_debug.put_line(TO_CHAR(pay_record.payment_term_id));

147: po_terms_sv.derive_payment_terms_info(pay_record);
148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(pay_record.payment_term_name);
151: asn_debug.put_line(TO_CHAR(pay_record.payment_term_id));
152: asn_debug.put_line(pay_record.error_record.error_status);
153: END IF;
154:
155: p_header_record.header_record.payment_terms_id := pay_record.payment_term_id;

Line 152: asn_debug.put_line(pay_record.error_record.error_status);

148:
149: IF (g_asn_debug = 'Y') THEN
150: asn_debug.put_line(pay_record.payment_term_name);
151: asn_debug.put_line(TO_CHAR(pay_record.payment_term_id));
152: asn_debug.put_line(pay_record.error_record.error_status);
153: END IF;
154:
155: p_header_record.header_record.payment_terms_id := pay_record.payment_term_id;
156: p_header_record.header_record.payment_terms_name := pay_record.payment_term_name;

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

172: emp_record.employee_id := p_header_record.header_record.employee_id;
173: emp_record.error_record.error_status := p_header_record.error_record.error_status;
174: emp_record.error_record.error_message := p_header_record.error_record.error_message;
175:
176: IF (g_asn_debug = 'Y') THEN
177: asn_debug.put_line('In Derive Receiver Information');
178: END IF;
179:
180: po_employees_sv.derive_employee_info(emp_record);

Line 177: asn_debug.put_line('In Derive Receiver Information');

173: emp_record.error_record.error_status := p_header_record.error_record.error_status;
174: emp_record.error_record.error_message := p_header_record.error_record.error_message;
175:
176: IF (g_asn_debug = 'Y') THEN
177: asn_debug.put_line('In Derive Receiver Information');
178: END IF;
179:
180: po_employees_sv.derive_employee_info(emp_record);
181:

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

178: END IF;
179:
180: po_employees_sv.derive_employee_info(emp_record);
181:
182: IF (g_asn_debug = 'Y') THEN
183: asn_debug.put_line(emp_record.employee_name);
184: asn_debug.put_line(TO_CHAR(emp_record.employee_id));
185: asn_debug.put_line(emp_record.error_record.error_status);
186: END IF;

Line 183: asn_debug.put_line(emp_record.employee_name);

179:
180: po_employees_sv.derive_employee_info(emp_record);
181:
182: IF (g_asn_debug = 'Y') THEN
183: asn_debug.put_line(emp_record.employee_name);
184: asn_debug.put_line(TO_CHAR(emp_record.employee_id));
185: asn_debug.put_line(emp_record.error_record.error_status);
186: END IF;
187:

Line 184: asn_debug.put_line(TO_CHAR(emp_record.employee_id));

180: po_employees_sv.derive_employee_info(emp_record);
181:
182: IF (g_asn_debug = 'Y') THEN
183: asn_debug.put_line(emp_record.employee_name);
184: asn_debug.put_line(TO_CHAR(emp_record.employee_id));
185: asn_debug.put_line(emp_record.error_record.error_status);
186: END IF;
187:
188: p_header_record.header_record.employee_name := emp_record.employee_name;

Line 185: asn_debug.put_line(emp_record.error_record.error_status);

181:
182: IF (g_asn_debug = 'Y') THEN
183: asn_debug.put_line(emp_record.employee_name);
184: asn_debug.put_line(TO_CHAR(emp_record.employee_id));
185: asn_debug.put_line(emp_record.error_record.error_status);
186: END IF;
187:
188: p_header_record.header_record.employee_name := emp_record.employee_name;
189: p_header_record.header_record.employee_id := emp_record.employee_id;

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

202:
203: IF p_header_record.error_record.error_status IN('S', 'W')
204: AND p_header_record.header_record.transaction_type = 'CANCEL'
205: AND p_header_record.header_record.shipment_num IS NOT NULL THEN
206: IF (g_asn_debug = 'Y') THEN
207: asn_debug.put_line('Derive shipment info');
208: END IF;
209:
210: --rcv_core_s.derive_shipment_info(p_header_record);

Line 207: asn_debug.put_line('Derive shipment info');

203: IF p_header_record.error_record.error_status IN('S', 'W')
204: AND p_header_record.header_record.transaction_type = 'CANCEL'
205: AND p_header_record.header_record.shipment_num IS NOT NULL THEN
206: IF (g_asn_debug = 'Y') THEN
207: asn_debug.put_line('Derive shipment info');
208: END IF;
209:
210: --rcv_core_s.derive_shipment_info(p_header_record);
211: /* block from rcv_core_s.derive_shipment_info */

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

220: AND shipment_num = p_header_record.header_record.shipment_num
221: AND shipped_date >= ADD_MONTHS(p_header_record.header_record.shipped_date, -12);
222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (g_asn_debug = 'Y') THEN
225: asn_debug.put_line(SQLERRM);
226: END IF;
227: END;
228: ELSE

Line 225: asn_debug.put_line(SQLERRM);

221: AND shipped_date >= ADD_MONTHS(p_header_record.header_record.shipped_date, -12);
222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (g_asn_debug = 'Y') THEN
225: asn_debug.put_line(SQLERRM);
226: END IF;
227: END;
228: ELSE
229: IF (g_asn_debug = 'Y') THEN

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

225: asn_debug.put_line(SQLERRM);
226: END IF;
227: END;
228: ELSE
229: IF (g_asn_debug = 'Y') THEN
230: asn_debug.put_line('Need to put a cursor to retrieve other values');
231: asn_debug.put_line('Shipment header Id has been provided');
232: END IF;
233: END IF;

Line 230: asn_debug.put_line('Need to put a cursor to retrieve other values');

226: END IF;
227: END;
228: ELSE
229: IF (g_asn_debug = 'Y') THEN
230: asn_debug.put_line('Need to put a cursor to retrieve other values');
231: asn_debug.put_line('Shipment header Id has been provided');
232: END IF;
233: END IF;
234:

Line 231: asn_debug.put_line('Shipment header Id has been provided');

227: END;
228: ELSE
229: IF (g_asn_debug = 'Y') THEN
230: asn_debug.put_line('Need to put a cursor to retrieve other values');
231: asn_debug.put_line('Shipment header Id has been provided');
232: END IF;
233: END IF;
234:
235: RETURN;

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

249: x_document_num RCV_TRANSACTIONS_INTERFACE.DOCUMENT_NUM%TYPE;
250: BEGIN
251: x_header_interface_id := p_header_record.header_record.header_interface_id;
252:
253: IF (g_asn_debug = 'Y') THEN
254: asn_debug.put_line('No ship to org specified at the header');
255: asn_debug.put_line('Trying to retrieve from lines');
256: END IF;
257:

Line 254: asn_debug.put_line('No ship to org specified at the header');

250: BEGIN
251: x_header_interface_id := p_header_record.header_record.header_interface_id;
252:
253: IF (g_asn_debug = 'Y') THEN
254: asn_debug.put_line('No ship to org specified at the header');
255: asn_debug.put_line('Trying to retrieve from lines');
256: END IF;
257:
258: SELECT MAX(rti.to_organization_code)

Line 255: asn_debug.put_line('Trying to retrieve from lines');

251: x_header_interface_id := p_header_record.header_record.header_interface_id;
252:
253: IF (g_asn_debug = 'Y') THEN
254: asn_debug.put_line('No ship to org specified at the header');
255: asn_debug.put_line('Trying to retrieve from lines');
256: END IF;
257:
258: SELECT MAX(rti.to_organization_code)
259: INTO x_to_organization_code

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

264: * then derive it from the To Organization Id and if this is also not
265: * specified then derive it from Ship To Location Code/Id which ever is
266: * specified. */
267: IF (x_to_organization_code IS NULL) THEN
268: IF (g_asn_debug = 'Y') THEN
269: asn_debug.put_line('No ship to org specified at the lines either');
270: asn_debug.put_line('Trying to retrieve from to_organization_id');
271: END IF;
272:

Line 269: asn_debug.put_line('No ship to org specified at the lines either');

265: * specified then derive it from Ship To Location Code/Id which ever is
266: * specified. */
267: IF (x_to_organization_code IS NULL) THEN
268: IF (g_asn_debug = 'Y') THEN
269: asn_debug.put_line('No ship to org specified at the lines either');
270: asn_debug.put_line('Trying to retrieve from to_organization_id');
271: END IF;
272:
273: /* ksareddy RVCTP performance fix 2481798 - select from mtl_parameters instead

Line 270: asn_debug.put_line('Trying to retrieve from to_organization_id');

266: * specified. */
267: IF (x_to_organization_code IS NULL) THEN
268: IF (g_asn_debug = 'Y') THEN
269: asn_debug.put_line('No ship to org specified at the lines either');
270: asn_debug.put_line('Trying to retrieve from to_organization_id');
271: END IF;
272:
273: /* ksareddy RVCTP performance fix 2481798 - select from mtl_parameters instead
274: SELECT MAX(ORG.ORGANIZATION_CODE)

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

286: AND mtl.organization_id = rti.to_organization_id;
287: END IF;
288:
289: IF (x_to_organization_code IS NULL) THEN
290: IF (g_asn_debug = 'Y') THEN
291: asn_debug.put_line('Trying to retrieve from ship to location');
292: END IF;
293:
294: SELECT MAX(org.organization_code)

Line 291: asn_debug.put_line('Trying to retrieve from ship to location');

287: END IF;
288:
289: IF (x_to_organization_code IS NULL) THEN
290: IF (g_asn_debug = 'Y') THEN
291: asn_debug.put_line('Trying to retrieve from ship to location');
292: END IF;
293:
294: SELECT MAX(org.organization_code)
295: INTO x_to_organization_code

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

304: END IF;
305:
306: /* Bug 3695855 - need to default org form shipping header */
307: IF (x_to_organization_code IS NULL) THEN
308: IF (g_asn_debug = 'Y') THEN
309: asn_debug.put_line('Trying to retrieve from shipment header id');
310: END IF;
311:
312: SELECT MAX(rti.shipment_header_id),MAX(rti.shipment_num),MAX(rti.document_num)

Line 309: asn_debug.put_line('Trying to retrieve from shipment header id');

305:
306: /* Bug 3695855 - need to default org form shipping header */
307: IF (x_to_organization_code IS NULL) THEN
308: IF (g_asn_debug = 'Y') THEN
309: asn_debug.put_line('Trying to retrieve from shipment header id');
310: END IF;
311:
312: SELECT MAX(rti.shipment_header_id),MAX(rti.shipment_num),MAX(rti.document_num)
313: INTO x_shipment_header_id,x_shipment_num,x_document_num

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

335:
336: IF ( p_header_record.header_record.ship_to_organization_code IS NULL
337: AND p_header_record.header_record.ship_to_organization_id IS NULL) THEN
338: IF (x_to_organization_code IS NOT NULL) THEN
339: IF (g_asn_debug = 'Y') THEN
340: asn_debug.put_line('A ship to location relating to an org was found');
341: END IF;
342:
343: p_header_record.header_record.ship_to_organization_code := x_to_organization_code;

Line 340: asn_debug.put_line('A ship to location relating to an org was found');

336: IF ( p_header_record.header_record.ship_to_organization_code IS NULL
337: AND p_header_record.header_record.ship_to_organization_id IS NULL) THEN
338: IF (x_to_organization_code IS NOT NULL) THEN
339: IF (g_asn_debug = 'Y') THEN
340: asn_debug.put_line('A ship to location relating to an org was found');
341: END IF;
342:
343: p_header_record.header_record.ship_to_organization_code := x_to_organization_code;
344: ELSIF (x_to_organization_id IS NOT NULL) THEN /* Bug#3909973 - (3) */

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

341: END IF;
342:
343: p_header_record.header_record.ship_to_organization_code := x_to_organization_code;
344: ELSIF (x_to_organization_id IS NOT NULL) THEN /* Bug#3909973 - (3) */
345: IF (g_asn_debug = 'Y') THEN
346: asn_debug.put_line('A ship to location relating to an org was found');
347: END IF;
348:
349: p_header_record.header_record.ship_to_organization_id := x_to_organization_id;

Line 346: asn_debug.put_line('A ship to location relating to an org was found');

342:
343: p_header_record.header_record.ship_to_organization_code := x_to_organization_code;
344: ELSIF (x_to_organization_id IS NOT NULL) THEN /* Bug#3909973 - (3) */
345: IF (g_asn_debug = 'Y') THEN
346: asn_debug.put_line('A ship to location relating to an org was found');
347: END IF;
348:
349: p_header_record.header_record.ship_to_organization_id := x_to_organization_id;
350: ELSE

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

347: END IF;
348:
349: p_header_record.header_record.ship_to_organization_id := x_to_organization_id;
350: ELSE
351: IF (g_asn_debug = 'Y') THEN
352: asn_debug.put_line('A ship to location relating to an org was NOT found');
353: asn_debug.put_line('This will cause an ERROR later');
354: END IF;
355: END IF;

Line 352: asn_debug.put_line('A ship to location relating to an org was NOT found');

348:
349: p_header_record.header_record.ship_to_organization_id := x_to_organization_id;
350: ELSE
351: IF (g_asn_debug = 'Y') THEN
352: asn_debug.put_line('A ship to location relating to an org was NOT found');
353: asn_debug.put_line('This will cause an ERROR later');
354: END IF;
355: END IF;
356: END IF;

Line 353: asn_debug.put_line('This will cause an ERROR later');

349: p_header_record.header_record.ship_to_organization_id := x_to_organization_id;
350: ELSE
351: IF (g_asn_debug = 'Y') THEN
352: asn_debug.put_line('A ship to location relating to an org was NOT found');
353: asn_debug.put_line('This will cause an ERROR later');
354: END IF;
355: END IF;
356: END IF;
357: EXCEPTION

Line 368: asn_debug.put_line('inside derive_uom_info');

364: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
365: n IN BINARY_INTEGER
366: ) IS
367: BEGIN
368: asn_debug.put_line('inside derive_uom_info');
369:
370: IF (x_cascaded_table(n).error_status IN('S', 'W'))
371: AND x_cascaded_table(n).item_id IS NOT NULL
372: AND x_cascaded_table(n).primary_unit_of_measure IS NULL THEN

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

384: FROM mtl_system_items
385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);
390: END IF;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN

Line 389: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);

385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);
390: END IF;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: x_cascaded_table(n).error_status := 'W';

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

392: WHEN NO_DATA_FOUND THEN
393: x_cascaded_table(n).error_status := 'W';
394: x_cascaded_table(n).error_message := 'Need an error message';
395:
396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('Primary UOM error');
398: END IF;
399: END;
400: END IF; -- set primary_uom

Line 397: asn_debug.put_line('Primary UOM error');

393: x_cascaded_table(n).error_status := 'W';
394: x_cascaded_table(n).error_message := 'Need an error message';
395:
396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('Primary UOM error');
398: END IF;
399: END;
400: END IF; -- set primary_uom
401:

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

402: /* Bug 2020269 : uom_code needs to be derived from unit_of_measure
403: entered in rcv_transactions_interface.
404: */
405: IF (x_cascaded_table(n).unit_of_measure IS NOT NULL) THEN
406: IF (g_asn_debug = 'Y') THEN
407: asn_debug.put_line('deriving uom_code from unit_of_measure');
408: END IF;
409:
410: SELECT muom.uom_code

Line 407: asn_debug.put_line('deriving uom_code from unit_of_measure');

403: entered in rcv_transactions_interface.
404: */
405: IF (x_cascaded_table(n).unit_of_measure IS NOT NULL) THEN
406: IF (g_asn_debug = 'Y') THEN
407: asn_debug.put_line('deriving uom_code from unit_of_measure');
408: END IF;
409:
410: SELECT muom.uom_code
411: INTO x_cascaded_table(n).uom_code

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

411: INTO x_cascaded_table(n).uom_code
412: FROM mtl_units_of_measure muom
413: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
414: ELSE
415: IF (g_asn_debug = 'Y') THEN
416: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');
417: END IF;
418: END IF; -- set uom_code
419: END derive_uom_info;

Line 416: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');

412: FROM mtl_units_of_measure muom
413: WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
414: ELSE
415: IF (g_asn_debug = 'Y') THEN
416: asn_debug.put_line('uom_code not dereived as unit_of_measure is null');
417: END IF;
418: END IF; -- set uom_code
419: END derive_uom_info;
420:

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

466: ( p_trx_record.destination_type_code = 'INVENTORY'
467: AND p_trx_record.auto_transact_code = 'RECEIVE') THEN
468: p_trx_record.destination_type_code := 'RECEIVING';
469:
470: IF (g_asn_debug = 'Y') THEN
471: asn_debug.put_line('Defaulting DESTINATION_TYPE_CODE ' || p_trx_record.destination_type_code);
472: END IF;
473: END IF;
474:

Line 471: asn_debug.put_line('Defaulting DESTINATION_TYPE_CODE ' || p_trx_record.destination_type_code);

467: AND p_trx_record.auto_transact_code = 'RECEIVE') THEN
468: p_trx_record.destination_type_code := 'RECEIVING';
469:
470: IF (g_asn_debug = 'Y') THEN
471: asn_debug.put_line('Defaulting DESTINATION_TYPE_CODE ' || p_trx_record.destination_type_code);
472: END IF;
473: END IF;
474:
475: IF p_trx_record.transaction_type IS NULL THEN

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

474:
475: IF p_trx_record.transaction_type IS NULL THEN
476: p_trx_record.transaction_type := 'SHIP';
477:
478: IF (g_asn_debug = 'Y') THEN
479: asn_debug.put_line('Defaulting TRANSACTION_TYPE ' || p_trx_record.transaction_type);
480: END IF;
481: END IF;
482:

Line 479: asn_debug.put_line('Defaulting TRANSACTION_TYPE ' || p_trx_record.transaction_type);

475: IF p_trx_record.transaction_type IS NULL THEN
476: p_trx_record.transaction_type := 'SHIP';
477:
478: IF (g_asn_debug = 'Y') THEN
479: asn_debug.put_line('Defaulting TRANSACTION_TYPE ' || p_trx_record.transaction_type);
480: END IF;
481: END IF;
482:
483: IF p_trx_record.processing_mode_code IS NULL THEN

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

482:
483: IF p_trx_record.processing_mode_code IS NULL THEN
484: p_trx_record.processing_mode_code := 'BATCH';
485:
486: IF (g_asn_debug = 'Y') THEN
487: asn_debug.put_line('Defaulting PROCESSING_MODE_CODE ' || p_trx_record.processing_mode_code);
488: END IF;
489: END IF;
490:

Line 487: asn_debug.put_line('Defaulting PROCESSING_MODE_CODE ' || p_trx_record.processing_mode_code);

483: IF p_trx_record.processing_mode_code IS NULL THEN
484: p_trx_record.processing_mode_code := 'BATCH';
485:
486: IF (g_asn_debug = 'Y') THEN
487: asn_debug.put_line('Defaulting PROCESSING_MODE_CODE ' || p_trx_record.processing_mode_code);
488: END IF;
489: END IF;
490:
491: p_trx_record.processing_status_code := 'RUNNING';

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

494: -- This has to be set to running otherwise C code in rvtbm
495: -- will not pick it up
496: p_trx_record.processing_status_code := 'RUNNING';
497:
498: IF (g_asn_debug = 'Y') THEN
499: asn_debug.put_line('Defaulting PROCESSING_STATUS_CODE ' || p_trx_record.processing_status_code);
500: END IF;
501: END IF;
502:

Line 499: asn_debug.put_line('Defaulting PROCESSING_STATUS_CODE ' || p_trx_record.processing_status_code);

495: -- will not pick it up
496: p_trx_record.processing_status_code := 'RUNNING';
497:
498: IF (g_asn_debug = 'Y') THEN
499: asn_debug.put_line('Defaulting PROCESSING_STATUS_CODE ' || p_trx_record.processing_status_code);
500: END IF;
501: END IF;
502:
503: IF p_trx_record.transaction_status_code IS NULL THEN

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

502:
503: IF p_trx_record.transaction_status_code IS NULL THEN
504: p_trx_record.transaction_status_code := 'PENDING';
505:
506: IF (g_asn_debug = 'Y') THEN
507: asn_debug.put_line('Defaulting TRANSACTION_STATUS_CODE ' || p_trx_record.transaction_status_code);
508: END IF;
509: END IF;
510: -- Default auto_transact_code if it is null

Line 507: asn_debug.put_line('Defaulting TRANSACTION_STATUS_CODE ' || p_trx_record.transaction_status_code);

503: IF p_trx_record.transaction_status_code IS NULL THEN
504: p_trx_record.transaction_status_code := 'PENDING';
505:
506: IF (g_asn_debug = 'Y') THEN
507: asn_debug.put_line('Defaulting TRANSACTION_STATUS_CODE ' || p_trx_record.transaction_status_code);
508: END IF;
509: END IF;
510: -- Default auto_transact_code if it is null
511: END commondefaultcode;

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

517: /* last_update_date */
518: IF p_header_record.header_record.last_update_date IS NULL THEN
519: p_header_record.header_record.last_update_date := x_sysdate;
520:
521: IF (g_asn_debug = 'Y') THEN
522: asn_debug.put_line('defaulting last update date');
523: END IF;
524: END IF;
525:

Line 522: asn_debug.put_line('defaulting last update date');

518: IF p_header_record.header_record.last_update_date IS NULL THEN
519: p_header_record.header_record.last_update_date := x_sysdate;
520:
521: IF (g_asn_debug = 'Y') THEN
522: asn_debug.put_line('defaulting last update date');
523: END IF;
524: END IF;
525:
526: /* last_updated_by */

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

526: /* last_updated_by */
527: IF p_header_record.header_record.last_updated_by IS NULL THEN
528: p_header_record.header_record.last_updated_by := fnd_global.user_id;
529:
530: IF (g_asn_debug = 'Y') THEN
531: asn_debug.put_line('defaulting last update by');
532: END IF;
533: END IF;
534:

Line 531: asn_debug.put_line('defaulting last update by');

527: IF p_header_record.header_record.last_updated_by IS NULL THEN
528: p_header_record.header_record.last_updated_by := fnd_global.user_id;
529:
530: IF (g_asn_debug = 'Y') THEN
531: asn_debug.put_line('defaulting last update by');
532: END IF;
533: END IF;
534:
535: /* last_update_login */

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

535: /* last_update_login */
536: IF p_header_record.header_record.last_update_login IS NULL THEN
537: p_header_record.header_record.last_update_login := fnd_global.login_id;
538:
539: IF (g_asn_debug = 'Y') THEN
540: asn_debug.put_line('defaulting last update login');
541: END IF;
542: END IF;
543: END default_last_update_info;

Line 540: asn_debug.put_line('defaulting last update login');

536: IF p_header_record.header_record.last_update_login IS NULL THEN
537: p_header_record.header_record.last_update_login := fnd_global.login_id;
538:
539: IF (g_asn_debug = 'Y') THEN
540: asn_debug.put_line('defaulting last update login');
541: END IF;
542: END IF;
543: END default_last_update_info;
544:

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

549: /* creation_date */
550: IF p_header_record.header_record.creation_date IS NULL THEN
551: p_header_record.header_record.creation_date := x_sysdate;
552:
553: IF (g_asn_debug = 'Y') THEN
554: asn_debug.put_line('defaulting creation date');
555: END IF;
556: END IF;
557:

Line 554: asn_debug.put_line('defaulting creation date');

550: IF p_header_record.header_record.creation_date IS NULL THEN
551: p_header_record.header_record.creation_date := x_sysdate;
552:
553: IF (g_asn_debug = 'Y') THEN
554: asn_debug.put_line('defaulting creation date');
555: END IF;
556: END IF;
557:
558: /* created_by */

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

558: /* created_by */
559: IF p_header_record.header_record.created_by IS NULL THEN
560: p_header_record.header_record.created_by := fnd_global.user_id;
561:
562: IF (g_asn_debug = 'Y') THEN
563: asn_debug.put_line('defaulting created by ');
564: END IF;
565: END IF;
566: END default_creation_info;

Line 563: asn_debug.put_line('defaulting created by ');

559: IF p_header_record.header_record.created_by IS NULL THEN
560: p_header_record.header_record.created_by := fnd_global.user_id;
561:
562: IF (g_asn_debug = 'Y') THEN
563: asn_debug.put_line('defaulting created by ');
564: END IF;
565: END IF;
566: END default_creation_info;
567:

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

572: /* Default STD into asn_type for null asn_type */
573: IF p_header_record.header_record.asn_type IS NULL THEN
574: p_header_record.header_record.asn_type := 'STD';
575:
576: IF (g_asn_debug = 'Y') THEN
577: asn_debug.put_line('defaulting asn type to STD');
578: END IF;
579: END IF;
580: END default_asn_type;

Line 577: asn_debug.put_line('defaulting asn type to STD');

573: IF p_header_record.header_record.asn_type IS NULL THEN
574: p_header_record.header_record.asn_type := 'STD';
575:
576: IF (g_asn_debug = 'Y') THEN
577: asn_debug.put_line('defaulting asn type to STD');
578: END IF;
579: END IF;
580: END default_asn_type;
581:

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

593:
594: /* Bug#4523892 */
595: IF p_header_record.header_record.receipt_source_code = 'VENDOR' THEN
596: rcv_roi_header.g_txn_against_asn := 'N';
597: IF (g_asn_debug = 'Y') THEN
598: asn_debug.put_line('g_txn_against_asn in default_shipment_header_id:' || rcv_roi_header.g_txn_against_asn);
599: END IF;
600: END IF;
601:

Line 598: asn_debug.put_line('g_txn_against_asn in default_shipment_header_id:' || rcv_roi_header.g_txn_against_asn);

594: /* Bug#4523892 */
595: IF p_header_record.header_record.receipt_source_code = 'VENDOR' THEN
596: rcv_roi_header.g_txn_against_asn := 'N';
597: IF (g_asn_debug = 'Y') THEN
598: asn_debug.put_line('g_txn_against_asn in default_shipment_header_id:' || rcv_roi_header.g_txn_against_asn);
599: END IF;
600: END IF;
601:
602: IF (g_asn_debug = 'Y') THEN

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

598: asn_debug.put_line('g_txn_against_asn in default_shipment_header_id:' || rcv_roi_header.g_txn_against_asn);
599: END IF;
600: END IF;
601:
602: IF (g_asn_debug = 'Y') THEN
603: asn_debug.put_line('defaulted receipt_id');
604: END IF;
605: END IF;
606: END default_shipment_header_id;

Line 603: asn_debug.put_line('defaulted receipt_id');

599: END IF;
600: END IF;
601:
602: IF (g_asn_debug = 'Y') THEN
603: asn_debug.put_line('defaulted receipt_id');
604: END IF;
605: END IF;
606: END default_shipment_header_id;
607:

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

638: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
639:
640: /* assuming that the ship_to_organization_id is populated at the header level of
641: rcv_headers_interface */
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line(v_rcv_type || ' Generation ');
644: END IF;
645:
646: IF v_rcv_type = 'AUTOMATIC' THEN

Line 643: asn_debug.put_line(v_rcv_type || ' Generation ');

639:
640: /* assuming that the ship_to_organization_id is populated at the header level of
641: rcv_headers_interface */
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line(v_rcv_type || ' Generation ');
644: END IF;
645:
646: IF v_rcv_type = 'AUTOMATIC' THEN
647: --bug 2506961

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

659: EXCEPTION
660: -- Added following NO_DATA_FOUND condition for bugfix #4070516
661: WHEN NO_DATA_FOUND
662: THEN
663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('NO_DATA_FOUND exception occured. Receiving options are not defined for organization = ' || p_header_record.header_record.ship_to_organization_id);
665: END IF;
666: p_header_record.error_record.error_status := 'E';
667: rcv_error_pkg.set_error_message('RCV_NO_OPTION', p_header_record.error_record.error_message);

Line 664: asn_debug.put_line('NO_DATA_FOUND exception occured. Receiving options are not defined for organization = ' || p_header_record.header_record.ship_to_organization_id);

660: -- Added following NO_DATA_FOUND condition for bugfix #4070516
661: WHEN NO_DATA_FOUND
662: THEN
663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('NO_DATA_FOUND exception occured. Receiving options are not defined for organization = ' || p_header_record.header_record.ship_to_organization_id);
665: END IF;
666: p_header_record.error_record.error_status := 'E';
667: rcv_error_pkg.set_error_message('RCV_NO_OPTION', p_header_record.error_record.error_message);
668: rcv_error_pkg.set_token('ORG', p_header_record.header_record.ship_to_organization_id);

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

671: p_header_record.error_record.error_status := 'E';
672: p_header_record.error_record.error_message := SQLERRM;
673: END;
674: ELSE -- of v_count
675: IF (g_asn_debug = 'Y') THEN
676: asn_debug.put_line('No need to generate a receipt_number');
677: END IF;
678: END IF; -- of v_count
679:

Line 676: asn_debug.put_line('No need to generate a receipt_number');

672: p_header_record.error_record.error_message := SQLERRM;
673: END;
674: ELSE -- of v_count
675: IF (g_asn_debug = 'Y') THEN
676: asn_debug.put_line('No need to generate a receipt_number');
677: END IF;
678: END IF; -- of v_count
679:
680: IF (g_asn_debug = 'Y') THEN

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

676: asn_debug.put_line('No need to generate a receipt_number');
677: END IF;
678: END IF; -- of v_count
679:
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('defaulted receipt_num ' || p_header_record.header_record.receipt_num);
682: END IF;
683: END IF;
684: END default_receipt_info;

Line 681: asn_debug.put_line('defaulted receipt_num ' || p_header_record.header_record.receipt_num);

677: END IF;
678: END IF; -- of v_count
679:
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('defaulted receipt_num ' || p_header_record.header_record.receipt_num);
682: END IF;
683: END IF;
684: END default_receipt_info;
685:

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

708: WHERE hr_locations_all.inventory_organization_id = p_header_record.header_record.ship_to_organization_id
709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN
713: asn_debug.put_line('count in hr_locations_all ' || x_count);
714: END IF;
715:
716: IF x_count = 1 THEN

Line 713: asn_debug.put_line('count in hr_locations_all ' || x_count);

709: AND NVL(hr_locations_all.inactive_date, x_sysdate + 1) > x_sysdate
710: AND NVL(hr_locations_all.receiving_site_flag, 'N') = 'Y';
711:
712: IF (g_asn_debug = 'Y') THEN
713: asn_debug.put_line('count in hr_locations_all ' || x_count);
714: END IF;
715:
716: IF x_count = 1 THEN
717: p_header_record.header_record.location_id := x_location_id;

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

761: FROM oe_drop_ship_sources
762: WHERE po_header_id = x_po_header_id;
763:
764: IF (temp_count <> 0) THEN -- this is a drop ship
765: IF (g_asn_debug = 'Y') THEN
766: asn_debug.put_line('drop ship PO');
767: END IF;
768:
769: p_header_record.header_record.location_id := NULL;

Line 766: asn_debug.put_line('drop ship PO');

762: WHERE po_header_id = x_po_header_id;
763:
764: IF (temp_count <> 0) THEN -- this is a drop ship
765: IF (g_asn_debug = 'Y') THEN
766: asn_debug.put_line('drop ship PO');
767: END IF;
768:
769: p_header_record.header_record.location_id := NULL;
770: END IF;

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

771: END IF;
772: END IF;
773: END IF;
774:
775: IF (g_asn_debug = 'Y') THEN
776: asn_debug.put_line('defaulted location info');
777: END IF;
778: END IF;
779: END default_ship_to_location_info;

Line 776: asn_debug.put_line('defaulted location info');

772: END IF;
773: END IF;
774:
775: IF (g_asn_debug = 'Y') THEN
776: asn_debug.put_line('defaulted location info');
777: END IF;
778: END IF;
779: END default_ship_to_location_info;
780:

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

794: RETURN;
795: END IF;
796:
797: /* Validate Transaction Type */
798: IF (g_asn_debug = 'Y') THEN
799: asn_debug.put_line('In validate routine');
800: END IF;
801:
802: lookup_record.lookup_code := p_header_record.header_record.transaction_type;

Line 799: asn_debug.put_line('In validate routine');

795: END IF;
796:
797: /* Validate Transaction Type */
798: IF (g_asn_debug = 'Y') THEN
799: asn_debug.put_line('In validate routine');
800: END IF;
801:
802: lookup_record.lookup_code := p_header_record.header_record.transaction_type;
803: lookup_record.lookup_type := 'TRANSACTION_TYPE';

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

811: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;
814:
815: IF (g_asn_debug = 'Y') THEN
816: asn_debug.put_line('validated transaction type');
817: END IF;
818: EXCEPTION
819: WHEN rcv_error_pkg.e_fatal_error THEN

Line 816: asn_debug.put_line('validated transaction type');

812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;
814:
815: IF (g_asn_debug = 'Y') THEN
816: asn_debug.put_line('validated transaction type');
817: END IF;
818: EXCEPTION
819: WHEN rcv_error_pkg.e_fatal_error THEN
820: NULL;

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

842: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
843: END IF;
844: END IF;
845:
846: IF (g_asn_debug = 'Y') THEN
847: asn_debug.put_line('validated expected_receipt_date is not missing');
848: END IF;
849: EXCEPTION
850: WHEN rcv_error_pkg.e_fatal_error THEN

Line 847: asn_debug.put_line('validated expected_receipt_date is not missing');

843: END IF;
844: END IF;
845:
846: IF (g_asn_debug = 'Y') THEN
847: asn_debug.put_line('validated expected_receipt_date is not missing');
848: END IF;
849: EXCEPTION
850: WHEN rcv_error_pkg.e_fatal_error THEN
851: NULL;

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

862:
863: IF p_header_record.header_record.receipt_num IS NULL
864: AND p_header_record.header_record.asn_type = 'STD'
865: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
866: IF (g_asn_debug = 'Y') THEN
867: asn_debug.put_line('Receipt Number is mandatory for STD');
868: END IF;
869:
870: /* Bug 3590735.

Line 867: asn_debug.put_line('Receipt Number is mandatory for STD');

863: IF p_header_record.header_record.receipt_num IS NULL
864: AND p_header_record.header_record.asn_type = 'STD'
865: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
866: IF (g_asn_debug = 'Y') THEN
867: asn_debug.put_line('Receipt Number is mandatory for STD');
868: END IF;
869:
870: /* Bug 3590735.
871: * When we error out with receipt number mandatory error,

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

893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('validated receipt number');
899: END IF;
900: END IF;
901: EXCEPTION

Line 898: asn_debug.put_line('validated receipt number');

894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('validated receipt number');
899: END IF;
900: END IF;
901: EXCEPTION
902: WHEN rcv_error_pkg.e_fatal_error THEN

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

917: ship_to_org_record.organization_id := p_header_record.header_record.ship_to_organization_id;
918: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
919: ship_to_org_record.error_record.error_message := NULL;
920:
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('In Validate Ship to Organization Procedure');
923: END IF;
924:
925: po_orgs_sv.validate_org_info(ship_to_org_record);

Line 922: asn_debug.put_line('In Validate Ship to Organization Procedure');

918: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
919: ship_to_org_record.error_record.error_message := NULL;
920:
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('In Validate Ship to Organization Procedure');
923: END IF;
924:
925: po_orgs_sv.validate_org_info(ship_to_org_record);
926:

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

926:
927: IF (ship_to_org_record.error_record.error_status <> 'S') THEN
928: IF ship_to_org_record.error_record.error_message = 'ORG_DISABLED' THEN
929: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
930: IF (g_asn_debug = 'Y') THEN
931: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
932: END IF;
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 931: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');

927: IF (ship_to_org_record.error_record.error_status <> 'S') THEN
928: IF ship_to_org_record.error_record.error_message = 'ORG_DISABLED' THEN
929: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
930: IF (g_asn_debug = 'Y') THEN
931: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
932: END IF;
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);

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

943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;
945: END IF;
946:
947: IF (g_asn_debug = 'Y') THEN
948: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
949: asn_debug.put_line('validated ship to organization info');
950: END IF;
951: END IF;

Line 948: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);

944: END IF;
945: END IF;
946:
947: IF (g_asn_debug = 'Y') THEN
948: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
949: asn_debug.put_line('validated ship to organization info');
950: END IF;
951: END IF;
952:

Line 949: asn_debug.put_line('validated ship to organization info');

945: END IF;
946:
947: IF (g_asn_debug = 'Y') THEN
948: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
949: asn_debug.put_line('validated ship to organization info');
950: END IF;
951: END IF;
952:
953: /* Bug# 3662698.

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

963: to_organization_code and to_organization_id as null.
964: This logic is followed keeping in view of the performance problems.
965: */
966: IF (p_header_record.header_record.ship_to_organization_code IS NOT NULL) THEN
967: IF (g_asn_debug = 'Y') THEN
968: asn_debug.put_line('Checking if any RTI has different destn org than that of the header');
969: END IF;
970:
971: SELECT COUNT(*)

Line 968: asn_debug.put_line('Checking if any RTI has different destn org than that of the header');

964: This logic is followed keeping in view of the performance problems.
965: */
966: IF (p_header_record.header_record.ship_to_organization_code IS NOT NULL) THEN
967: IF (g_asn_debug = 'Y') THEN
968: asn_debug.put_line('Checking if any RTI has different destn org than that of the header');
969: END IF;
970:
971: SELECT COUNT(*)
972: INTO x_count

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

980: AND rti.to_organization_id <> p_header_record.header_record.ship_to_organization_id)
981: );
982:
983: IF x_count >= 1 THEN
984: IF (g_asn_debug = 'Y') THEN
985: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
986: END IF;
987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 985: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');

981: );
982:
983: IF x_count >= 1 THEN
984: IF (g_asn_debug = 'Y') THEN
985: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
986: END IF;
987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

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

989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE
993: IF (g_asn_debug = 'Y') THEN
994: asn_debug.put_line('In the ELSE part');
995: END IF;
996:
997: /* Check if there is atleast one RTI record in this header with a different

Line 994: asn_debug.put_line('In the ELSE part');

990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE
993: IF (g_asn_debug = 'Y') THEN
994: asn_debug.put_line('In the ELSE part');
995: END IF;
996:
997: /* Check if there is atleast one RTI record in this header with a different
998: ship to org than the header's org. Here we consider those RTI records

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

1014: AND rti.ship_to_location_id = hl.location_id
1015: AND hl.inventory_organization_id = org.organization_id
1016: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1017:
1018: IF (g_asn_debug = 'Y') THEN
1019: asn_debug.put_line('Count is ' || TO_CHAR(x_count));
1020: END IF;
1021:
1022: /* Check if there is atleast one RTI record in this header with a different

Line 1019: asn_debug.put_line('Count is ' || TO_CHAR(x_count));

1015: AND hl.inventory_organization_id = org.organization_id
1016: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1017:
1018: IF (g_asn_debug = 'Y') THEN
1019: asn_debug.put_line('Count is ' || TO_CHAR(x_count));
1020: END IF;
1021:
1022: /* Check if there is atleast one RTI record in this header with a different
1023: ship to org than the header's org. Here we consider those RTI records

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

1042: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1043: END IF;
1044:
1045: IF x_count >= 1 THEN
1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1048: END IF;
1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 1047: asn_debug.put_line('For one of the RTI records a different org id/code is derived');

1043: END IF;
1044:
1045: IF x_count >= 1 THEN
1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1048: END IF;
1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1051: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

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

1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1054: END IF;
1055: END IF;
1056:
1057: IF (g_asn_debug = 'Y') THEN
1058: asn_debug.put_line('Validated ship to org of all the RTIs tied to the header');
1059: END IF;
1060: END IF;
1061: END IF; --End of bug# 3662698.

Line 1058: asn_debug.put_line('Validated ship to org of all the RTIs tied to the header');

1054: END IF;
1055: END IF;
1056:
1057: IF (g_asn_debug = 'Y') THEN
1058: asn_debug.put_line('Validated ship to org of all the RTIs tied to the header');
1059: END IF;
1060: END IF;
1061: END IF; --End of bug# 3662698.
1062:

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

1081: from_org_record.organization_id := p_header_record.header_record.from_organization_id;
1082: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1083: from_org_record.error_record.error_message := NULL;
1084:
1085: IF (g_asn_debug = 'Y') THEN
1086: asn_debug.put_line('In Validate From Organization Procedure');
1087: END IF;
1088:
1089: po_orgs_sv.validate_org_info(from_org_record);

Line 1086: asn_debug.put_line('In Validate From Organization Procedure');

1082: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1083: from_org_record.error_record.error_message := NULL;
1084:
1085: IF (g_asn_debug = 'Y') THEN
1086: asn_debug.put_line('In Validate From Organization Procedure');
1087: END IF;
1088:
1089: po_orgs_sv.validate_org_info(from_org_record);
1090:

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

1090:
1091: IF (from_org_record.error_record.error_status <> 'S') THEN
1092: IF from_org_record.error_record.error_message = 'ORG_DISABLED' THEN
1093: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1094: IF (g_asn_debug = 'Y') THEN
1095: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1096: END IF;
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 1095: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');

1091: IF (from_org_record.error_record.error_status <> 'S') THEN
1092: IF from_org_record.error_record.error_message = 'ORG_DISABLED' THEN
1093: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1094: IF (g_asn_debug = 'Y') THEN
1095: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1096: END IF;
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);

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

1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE
1104: IF (g_asn_debug = 'Y') THEN
1105: asn_debug.put_line('Error with from ORG_ID');
1106: END IF;
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 1105: asn_debug.put_line('Error with from ORG_ID');

1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE
1104: IF (g_asn_debug = 'Y') THEN
1105: asn_debug.put_line('Error with from ORG_ID');
1106: END IF;
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);

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

1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;
1113: END IF;
1114:
1115: IF (g_asn_debug = 'Y') THEN
1116: asn_debug.put_line('validated from organization info');
1117: END IF;
1118: END IF;
1119: END IF;

Line 1116: asn_debug.put_line('validated from organization info');

1112: END IF;
1113: END IF;
1114:
1115: IF (g_asn_debug = 'Y') THEN
1116: asn_debug.put_line('validated from organization info');
1117: END IF;
1118: END IF;
1119: END IF;
1120: EXCEPTION

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

1140: loc_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1141: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1142: loc_record.error_record.error_message := NULL;
1143:
1144: IF (g_asn_debug = 'Y') THEN
1145: asn_debug.put_line('In Validate Location Code Procedure');
1146: END IF;
1147:
1148: po_locations_s.validate_location_info(loc_record);

Line 1145: asn_debug.put_line('In Validate Location Code Procedure');

1141: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1142: loc_record.error_record.error_message := NULL;
1143:
1144: IF (g_asn_debug = 'Y') THEN
1145: asn_debug.put_line('In Validate Location Code Procedure');
1146: END IF;
1147:
1148: po_locations_s.validate_location_info(loc_record);
1149:

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

1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;
1163: END IF;
1164:
1165: IF (g_asn_debug = 'Y') THEN
1166: asn_debug.put_line(loc_record.error_record.error_status);
1167: asn_debug.put_line(loc_record.error_record.error_message);
1168: asn_debug.put_line('Validated location info');
1169: END IF;

Line 1166: asn_debug.put_line(loc_record.error_record.error_status);

1162: END IF;
1163: END IF;
1164:
1165: IF (g_asn_debug = 'Y') THEN
1166: asn_debug.put_line(loc_record.error_record.error_status);
1167: asn_debug.put_line(loc_record.error_record.error_message);
1168: asn_debug.put_line('Validated location info');
1169: END IF;
1170: END IF;

Line 1167: asn_debug.put_line(loc_record.error_record.error_message);

1163: END IF;
1164:
1165: IF (g_asn_debug = 'Y') THEN
1166: asn_debug.put_line(loc_record.error_record.error_status);
1167: asn_debug.put_line(loc_record.error_record.error_message);
1168: asn_debug.put_line('Validated location info');
1169: END IF;
1170: END IF;
1171: EXCEPTION

Line 1168: asn_debug.put_line('Validated location info');

1164:
1165: IF (g_asn_debug = 'Y') THEN
1166: asn_debug.put_line(loc_record.error_record.error_status);
1167: asn_debug.put_line(loc_record.error_record.error_message);
1168: asn_debug.put_line('Validated location info');
1169: END IF;
1170: END IF;
1171: EXCEPTION
1172: WHEN rcv_error_pkg.e_fatal_error THEN

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

1216: fetch c_get_shipping_control into l_shipping_control;
1217: close c_get_shipping_control;
1218:
1219: IF (nvl(l_shipping_control,'@@@') = 'BUYER' AND p_header_record.header_record.ship_from_location_id IS NULL) THEN
1220: IF (g_asn_debug = 'Y') THEN
1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

Line 1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');

1217: close c_get_shipping_control;
1218:
1219: IF (nvl(l_shipping_control,'@@@') = 'BUYER' AND p_header_record.header_record.ship_from_location_id IS NULL) THEN
1220: IF (g_asn_debug = 'Y') THEN
1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);

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

1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:
1254: IF (g_asn_debug = 'Y') THEN
1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1256: END IF;
1257: END IF;
1258: EXCEPTION

Line 1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);

1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:
1254: IF (g_asn_debug = 'Y') THEN
1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1256: END IF;
1257: END IF;
1258: EXCEPTION
1259: WHEN rcv_error_pkg.e_fatal_error THEN

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

1276: pay_record.payment_term_name := p_header_record.header_record.payment_terms_name;
1277: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1278: pay_record.error_record.error_message := NULL;
1279:
1280: IF (g_asn_debug = 'Y') THEN
1281: asn_debug.put_line('In Validate Payment Terms ');
1282: END IF;
1283:
1284: po_terms_sv.validate_payment_terms_info(pay_record);

Line 1281: asn_debug.put_line('In Validate Payment Terms ');

1277: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1278: pay_record.error_record.error_message := NULL;
1279:
1280: IF (g_asn_debug = 'Y') THEN
1281: asn_debug.put_line('In Validate Payment Terms ');
1282: END IF;
1283:
1284: po_terms_sv.validate_payment_terms_info(pay_record);
1285:

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

1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:
1298: IF (g_asn_debug = 'Y') THEN
1299: asn_debug.put_line(pay_record.error_record.error_status);
1300: END IF;
1301:
1302: IF (g_asn_debug = 'Y') THEN

Line 1299: asn_debug.put_line(pay_record.error_record.error_status);

1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:
1298: IF (g_asn_debug = 'Y') THEN
1299: asn_debug.put_line(pay_record.error_record.error_status);
1300: END IF;
1301:
1302: IF (g_asn_debug = 'Y') THEN
1303: asn_debug.put_line('Validated payment info');

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

1298: IF (g_asn_debug = 'Y') THEN
1299: asn_debug.put_line(pay_record.error_record.error_status);
1300: END IF;
1301:
1302: IF (g_asn_debug = 'Y') THEN
1303: asn_debug.put_line('Validated payment info');
1304: END IF;
1305: END IF;
1306: EXCEPTION

Line 1303: asn_debug.put_line('Validated payment info');

1299: asn_debug.put_line(pay_record.error_record.error_status);
1300: END IF;
1301:
1302: IF (g_asn_debug = 'Y') THEN
1303: asn_debug.put_line('Validated payment info');
1304: END IF;
1305: END IF;
1306: EXCEPTION
1307: WHEN rcv_error_pkg.e_fatal_error THEN

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

1325: emp_record.employee_id := p_header_record.header_record.employee_id;
1326: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1327: emp_record.error_record.error_message := NULL;
1328:
1329: IF (g_asn_debug = 'Y') THEN
1330: asn_debug.put_line('In Validate Receiver Information');
1331: END IF;
1332:
1333: po_employees_sv.validate_employee_info(emp_record);

Line 1330: asn_debug.put_line('In Validate Receiver Information');

1326: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1327: emp_record.error_record.error_message := NULL;
1328:
1329: IF (g_asn_debug = 'Y') THEN
1330: asn_debug.put_line('In Validate Receiver Information');
1331: END IF;
1332:
1333: po_employees_sv.validate_employee_info(emp_record);
1334:

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

1331: END IF;
1332:
1333: po_employees_sv.validate_employee_info(emp_record);
1334:
1335: IF (g_asn_debug = 'Y') THEN
1336: asn_debug.put_line(emp_record.error_record.error_status);
1337: END IF;
1338:
1339: IF emp_record.error_record.error_status <> 'S' THEN

Line 1336: asn_debug.put_line(emp_record.error_record.error_status);

1332:
1333: po_employees_sv.validate_employee_info(emp_record);
1334:
1335: IF (g_asn_debug = 'Y') THEN
1336: asn_debug.put_line(emp_record.error_record.error_status);
1337: END IF;
1338:
1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:
1346: IF (g_asn_debug = 'Y') THEN
1347: asn_debug.put_line('Validated receiver info');
1348: END IF;
1349: END IF;
1350: EXCEPTION

Line 1347: asn_debug.put_line('Validated receiver info');

1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:
1346: IF (g_asn_debug = 'Y') THEN
1347: asn_debug.put_line('Validated receiver info');
1348: END IF;
1349: END IF;
1350: EXCEPTION
1351: WHEN rcv_error_pkg.e_fatal_error THEN

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

1369: freight_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1370: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1371: freight_record.error_record.error_message := NULL;
1372:
1373: IF (g_asn_debug = 'Y') THEN
1374: asn_debug.put_line('In Validate Freight Carrier Information');
1375: END IF;
1376:
1377: po_terms_sv.validate_freight_carrier_info(freight_record);

Line 1374: asn_debug.put_line('In Validate Freight Carrier Information');

1370: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1371: freight_record.error_record.error_message := NULL;
1372:
1373: IF (g_asn_debug = 'Y') THEN
1374: asn_debug.put_line('In Validate Freight Carrier Information');
1375: END IF;
1376:
1377: po_terms_sv.validate_freight_carrier_info(freight_record);
1378:

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

1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN
1387: asn_debug.put_line(freight_record.error_record.error_status);
1388: asn_debug.put_line('Validated freight carrier info');
1389: END IF;
1390: END IF;

Line 1387: asn_debug.put_line(freight_record.error_record.error_status);

1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN
1387: asn_debug.put_line(freight_record.error_record.error_status);
1388: asn_debug.put_line('Validated freight carrier info');
1389: END IF;
1390: END IF;
1391: EXCEPTION

Line 1388: asn_debug.put_line('Validated freight carrier info');

1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN
1387: asn_debug.put_line(freight_record.error_record.error_status);
1388: asn_debug.put_line('Validated freight carrier info');
1389: END IF;
1390: END IF;
1391: EXCEPTION
1392: WHEN rcv_error_pkg.e_fatal_error THEN

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

1407: /* R12 Complex Work.
1408: * There is no concept of shipped_date for Work Confirmations.
1409: * So shipped_date can be null.
1410: */
1411: IF (g_asn_debug = 'Y') THEN
1412: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1413: END IF;
1414: IF p_header_record.header_record.shipped_date IS NULL
1415: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN

Line 1412: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);

1408: * There is no concept of shipped_date for Work Confirmations.
1409: * So shipped_date can be null.
1410: */
1411: IF (g_asn_debug = 'Y') THEN
1412: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1413: END IF;
1414: IF p_header_record.header_record.shipped_date IS NULL
1415: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1416: IF (g_asn_debug = 'Y') THEN

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

1412: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1413: END IF;
1414: IF p_header_record.header_record.shipped_date IS NULL
1415: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1416: IF (g_asn_debug = 'Y') THEN
1417: asn_debug.put_line('Shipped date can be blank for STD '||
1418: 'or Work Confirmations ');
1419: END IF;
1420: ELSE

Line 1417: asn_debug.put_line('Shipped date can be blank for STD '||

1413: END IF;
1414: IF p_header_record.header_record.shipped_date IS NULL
1415: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1416: IF (g_asn_debug = 'Y') THEN
1417: asn_debug.put_line('Shipped date can be blank for STD '||
1418: 'or Work Confirmations ');
1419: END IF;
1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;
1426: END IF;
1427:
1428: IF (g_asn_debug = 'Y') THEN
1429: asn_debug.put_line('validated for shipment_date > system date');
1430: END IF;
1431: EXCEPTION
1432: WHEN rcv_error_pkg.e_fatal_error THEN

Line 1429: asn_debug.put_line('validated for shipment_date > system date');

1425: END IF;
1426: END IF;
1427:
1428: IF (g_asn_debug = 'Y') THEN
1429: asn_debug.put_line('validated for shipment_date > system date');
1430: END IF;
1431: EXCEPTION
1432: WHEN rcv_error_pkg.e_fatal_error THEN
1433: NULL;

Line 1448: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);

1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);
1447: BEGIN
1448: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);
1449: x_error_status := rcv_error_pkg.g_ret_sts_error;
1450:
1451: SELECT NVL(MAX(inventory_item_id), -9999)
1452: INTO x_inventory_item

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

1472: -- Bugfix 5735599
1473: -- When item status is changed to INACTIVE all the flags are unchecked.
1474: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );

Line 1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);

1473: -- When item status is changed to INACTIVE all the flags are unchecked.
1474: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1481: END IF;

Line 1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);

1474: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1481: END IF;
1482:

Line 1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);

1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1481: END IF;
1482:
1483: BEGIN

Line 1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );

1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1478: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1479: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1480: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1481: END IF;
1482:
1483: BEGIN
1484: SELECT stock_enabled_flag,

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

1490: AND inventory_item_id = x_cascaded_table(n).item_id;
1491: EXCEPTION
1492: WHEN OTHERS
1493: THEN
1494: IF (g_asn_debug = 'Y') THEN
1495: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1496: END IF;
1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;

Line 1495: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );

1491: EXCEPTION
1492: WHEN OTHERS
1493: THEN
1494: IF (g_asn_debug = 'Y') THEN
1495: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1496: END IF;
1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');

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

1558: END IF;
1559: END IF; --}
1560:
1561: /* bug 608353, do not support lot and serial control if DELIVER is used */
1562: IF (g_asn_debug = 'Y') THEN
1563: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1564: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1565: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1566: END IF;

Line 1563: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);

1559: END IF; --}
1560:
1561: /* bug 608353, do not support lot and serial control if DELIVER is used */
1562: IF (g_asn_debug = 'Y') THEN
1563: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1564: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1565: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1566: END IF;
1567: EXCEPTION

Line 1564: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);

1560:
1561: /* bug 608353, do not support lot and serial control if DELIVER is used */
1562: IF (g_asn_debug = 'Y') THEN
1563: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1564: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1565: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1566: END IF;
1567: EXCEPTION
1568: WHEN e_validation_error THEN

Line 1565: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);

1561: /* bug 608353, do not support lot and serial control if DELIVER is used */
1562: IF (g_asn_debug = 'Y') THEN
1563: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1564: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1565: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1566: END IF;
1567: EXCEPTION
1568: WHEN e_validation_error THEN
1569: x_cascaded_table(n).error_status := x_error_status;

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

1820: RETURN;
1821: END IF;
1822:
1823: -- Check whether the revision number exists
1824: IF (g_asn_debug = 'Y') THEN
1825: asn_debug.put_line('Revision number : ' || x_cascaded_table(n).item_revision);
1826: END IF;
1827:
1828: SELECT NVL(MAX(inventory_item_id), 0)

Line 1825: asn_debug.put_line('Revision number : ' || x_cascaded_table(n).item_revision);

1821: END IF;
1822:
1823: -- Check whether the revision number exists
1824: IF (g_asn_debug = 'Y') THEN
1825: asn_debug.put_line('Revision number : ' || x_cascaded_table(n).item_revision);
1826: END IF;
1827:
1828: SELECT NVL(MAX(inventory_item_id), 0)
1829: INTO x_inventory_item

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

1845: IF x_cascaded_table(n).error_message = 'PO_RI_INVALID_ITEM_REVISION' THEN
1846: NULL;
1847: END IF;
1848: when others then
1849: IF (g_asn_debug = 'Y') THEN
1850: asn_debug.put_line('exception in valid_item_revision');
1851: asn_debug.put_line(SQLERRM);
1852: END IF;
1853: x_cascaded_table(n).error_status := 'E';

Line 1850: asn_debug.put_line('exception in valid_item_revision');

1846: NULL;
1847: END IF;
1848: when others then
1849: IF (g_asn_debug = 'Y') THEN
1850: asn_debug.put_line('exception in valid_item_revision');
1851: asn_debug.put_line(SQLERRM);
1852: END IF;
1853: x_cascaded_table(n).error_status := 'E';
1854: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

Line 1851: asn_debug.put_line(SQLERRM);

1847: END IF;
1848: when others then
1849: IF (g_asn_debug = 'Y') THEN
1850: asn_debug.put_line('exception in valid_item_revision');
1851: asn_debug.put_line(SQLERRM);
1852: END IF;
1853: x_cascaded_table(n).error_status := 'E';
1854: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1855:

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

1860: IS
1861: l_lcm_org_flag VARCHAR2(1);
1862: l_pre_rcv_flag VARCHAR2(1);
1863: BEGIN
1864: IF (g_asn_debug = 'Y') THEN
1865: asn_debug.put_line('In Validate LCM Info');
1866: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1867: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1868: END IF;

Line 1865: asn_debug.put_line('In Validate LCM Info');

1861: l_lcm_org_flag VARCHAR2(1);
1862: l_pre_rcv_flag VARCHAR2(1);
1863: BEGIN
1864: IF (g_asn_debug = 'Y') THEN
1865: asn_debug.put_line('In Validate LCM Info');
1866: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1867: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1868: END IF;
1869:

Line 1866: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);

1862: l_pre_rcv_flag VARCHAR2(1);
1863: BEGIN
1864: IF (g_asn_debug = 'Y') THEN
1865: asn_debug.put_line('In Validate LCM Info');
1866: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1867: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1868: END IF;
1869:
1870: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1867: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);

1863: BEGIN
1864: IF (g_asn_debug = 'Y') THEN
1865: asn_debug.put_line('In Validate LCM Info');
1866: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1867: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1868: END IF;
1869:
1870: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN
1871: RETURN;

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

1875:
1876: l_lcm_org_flag := rcv_table_functions.is_lcm_org(p_header_record.header_record.ship_to_organization_id);
1877: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1878:
1879: IF (g_asn_debug = 'Y') THEN
1880: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1881: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1882: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1883: END IF;

Line 1880: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);

1876: l_lcm_org_flag := rcv_table_functions.is_lcm_org(p_header_record.header_record.ship_to_organization_id);
1877: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1878:
1879: IF (g_asn_debug = 'Y') THEN
1880: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1881: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1882: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1883: END IF;
1884:

Line 1881: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);

1877: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1878:
1879: IF (g_asn_debug = 'Y') THEN
1880: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1881: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1882: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1883: END IF;
1884:
1885: IF (l_lcm_org_flag = 'Y') THEN

Line 1882: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);

1878:
1879: IF (g_asn_debug = 'Y') THEN
1880: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1881: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1882: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1883: END IF;
1884:
1885: IF (l_lcm_org_flag = 'Y') THEN
1886: IF ( l_pre_rcv_flag = 'N') THEN

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

1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --
1894: ELSE
1895: --
1896: IF (g_asn_debug = 'Y') THEN
1897: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1898: END IF;
1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 1897: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);

1893: --
1894: ELSE
1895: --
1896: IF (g_asn_debug = 'Y') THEN
1897: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1898: END IF;
1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);

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

1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;
1915: END IF;
1916:
1917: IF (g_asn_debug = 'Y') THEN
1918: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
1919: asn_debug.put_line('Exitting validate_lcm_info');
1920: END IF;
1921:

Line 1918: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);

1914: END IF;
1915: END IF;
1916:
1917: IF (g_asn_debug = 'Y') THEN
1918: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
1919: asn_debug.put_line('Exitting validate_lcm_info');
1920: END IF;
1921:
1922: EXCEPTION

Line 1919: asn_debug.put_line('Exitting validate_lcm_info');

1915: END IF;
1916:
1917: IF (g_asn_debug = 'Y') THEN
1918: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
1919: asn_debug.put_line('Exitting validate_lcm_info');
1920: END IF;
1921:
1922: EXCEPTION
1923: WHEN rcv_error_pkg.e_fatal_error THEN