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) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement

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) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement
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 868: IF (g_asn_debug = 'Y') THEN

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

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

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

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

904: AND shipped_date >=
905: ADD_MONTHS(NVL(p_header_record.header_record.shipped_date, SYSDATE), -12)
906: AND receipt_source_code = p_header_record.header_record.receipt_source_code);
907:
908: IF (g_asn_debug = 'Y') THEN
909: asn_debug.put_line('shipment x_new_receipt '||x_new_receipt);
910: END IF;
911:
912: /*End Bug 12719212 */

Line 909: asn_debug.put_line('shipment x_new_receipt '||x_new_receipt);

905: ADD_MONTHS(NVL(p_header_record.header_record.shipped_date, SYSDATE), -12)
906: AND receipt_source_code = p_header_record.header_record.receipt_source_code);
907:
908: IF (g_asn_debug = 'Y') THEN
909: asn_debug.put_line('shipment x_new_receipt '||x_new_receipt);
910: END IF;
911:
912: /*End Bug 12719212 */
913:

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

936: OR rhi.ship_to_organization_code = p_header_record.header_record.ship_to_organization_code)
937: AND rhi.processing_status_code IN ('PENDING','RUNNING');
938:
939: IF x_rhi_count > 1 THEN
940: IF (g_asn_debug = 'Y') THEN
941: asn_debug.put_line('Multiple RHI Records exist with Duplicate Receipt Numbers for the same Ship To Organization Id.');
942: END IF;
943: END IF;
944: END IF;

Line 941: asn_debug.put_line('Multiple RHI Records exist with Duplicate Receipt Numbers for the same Ship To Organization Id.');

937: AND rhi.processing_status_code IN ('PENDING','RUNNING');
938:
939: IF x_rhi_count > 1 THEN
940: IF (g_asn_debug = 'Y') THEN
941: asn_debug.put_line('Multiple RHI Records exist with Duplicate Receipt Numbers for the same Ship To Organization Id.');
942: END IF;
943: END IF;
944: END IF;
945:

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

950: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
951: END IF;
952: /* End of fix for Bug 9126513 */
953:
954: IF (g_asn_debug = 'Y') THEN
955: asn_debug.put_line('validated receipt number');
956: END IF;
957: END IF;
958: EXCEPTION

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

951: END IF;
952: /* End of fix for Bug 9126513 */
953:
954: IF (g_asn_debug = 'Y') THEN
955: asn_debug.put_line('validated receipt number');
956: END IF;
957: END IF;
958: EXCEPTION
959: WHEN rcv_error_pkg.e_fatal_error THEN

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

974: ship_to_org_record.organization_id := p_header_record.header_record.ship_to_organization_id;
975: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
976: ship_to_org_record.error_record.error_message := NULL;
977:
978: IF (g_asn_debug = 'Y') THEN
979: asn_debug.put_line('In Validate Ship to Organization Procedure');
980: END IF;
981:
982: po_orgs_sv.validate_org_info(ship_to_org_record);

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

975: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
976: ship_to_org_record.error_record.error_message := NULL;
977:
978: IF (g_asn_debug = 'Y') THEN
979: asn_debug.put_line('In Validate Ship to Organization Procedure');
980: END IF;
981:
982: po_orgs_sv.validate_org_info(ship_to_org_record);
983:

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

983:
984: IF (ship_to_org_record.error_record.error_status <> 'S') THEN
985: IF ship_to_org_record.error_record.error_message = 'ORG_DISABLED' THEN
986: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
987: IF (g_asn_debug = 'Y') THEN
988: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
989: END IF;
990:
991: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

984: IF (ship_to_org_record.error_record.error_status <> 'S') THEN
985: IF ship_to_org_record.error_record.error_message = 'ORG_DISABLED' THEN
986: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
987: IF (g_asn_debug = 'Y') THEN
988: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
989: END IF;
990:
991: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
992: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);

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

1000: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
1001: END IF;
1002: END IF;
1003:
1004: IF (g_asn_debug = 'Y') THEN
1005: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
1006: asn_debug.put_line('validated ship to organization info');
1007: END IF;
1008: END IF;

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

1001: END IF;
1002: END IF;
1003:
1004: IF (g_asn_debug = 'Y') THEN
1005: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
1006: asn_debug.put_line('validated ship to organization info');
1007: END IF;
1008: END IF;
1009:

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

1002: END IF;
1003:
1004: IF (g_asn_debug = 'Y') THEN
1005: asn_debug.put_line('ship_to_org_record.error_status ' || ship_to_org_record.error_record.error_status);
1006: asn_debug.put_line('validated ship to organization info');
1007: END IF;
1008: END IF;
1009:
1010: /* Bug# 3662698.

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

1020: to_organization_code and to_organization_id as null.
1021: This logic is followed keeping in view of the performance problems.
1022: */
1023: IF (p_header_record.header_record.ship_to_organization_code IS NOT NULL) THEN
1024: IF (g_asn_debug = 'Y') THEN
1025: asn_debug.put_line('Checking if any RTI has different destn org than that of the header');
1026: END IF;
1027:
1028: SELECT COUNT(*)

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

1021: This logic is followed keeping in view of the performance problems.
1022: */
1023: IF (p_header_record.header_record.ship_to_organization_code IS NOT NULL) THEN
1024: IF (g_asn_debug = 'Y') THEN
1025: asn_debug.put_line('Checking if any RTI has different destn org than that of the header');
1026: END IF;
1027:
1028: SELECT COUNT(*)
1029: INTO x_count

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

1037: AND rti.to_organization_id <> p_header_record.header_record.ship_to_organization_id)
1038: );
1039:
1040: IF x_count >= 1 THEN
1041: IF (g_asn_debug = 'Y') THEN
1042: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
1043: END IF;
1044:
1045: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1038: );
1039:
1040: IF x_count >= 1 THEN
1041: IF (g_asn_debug = 'Y') THEN
1042: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
1043: END IF;
1044:
1045: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1046: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

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

1046: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
1047: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1048: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1049: ELSE
1050: IF (g_asn_debug = 'Y') THEN
1051: asn_debug.put_line('In the ELSE part');
1052: END IF;
1053:
1054: /* Check if there is atleast one RTI record in this header with a different

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

1047: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1048: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1049: ELSE
1050: IF (g_asn_debug = 'Y') THEN
1051: asn_debug.put_line('In the ELSE part');
1052: END IF;
1053:
1054: /* Check if there is atleast one RTI record in this header with a different
1055: ship to org than the header's org. Here we consider those RTI records

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

1071: AND rti.ship_to_location_id = hl.location_id
1072: AND hl.inventory_organization_id = org.organization_id
1073: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1074:
1075: IF (g_asn_debug = 'Y') THEN
1076: asn_debug.put_line('Count is ' || TO_CHAR(x_count));
1077: END IF;
1078:
1079: /* Check if there is atleast one RTI record in this header with a different

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

1072: AND hl.inventory_organization_id = org.organization_id
1073: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1074:
1075: IF (g_asn_debug = 'Y') THEN
1076: asn_debug.put_line('Count is ' || TO_CHAR(x_count));
1077: END IF;
1078:
1079: /* Check if there is atleast one RTI record in this header with a different
1080: ship to org than the header's org. Here we consider those RTI records

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

1099: AND org.organization_code <> p_header_record.header_record.ship_to_organization_code;
1100: END IF;
1101:
1102: IF x_count >= 1 THEN
1103: IF (g_asn_debug = 'Y') THEN
1104: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1105: END IF;
1106:
1107: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1100: END IF;
1101:
1102: IF x_count >= 1 THEN
1103: IF (g_asn_debug = 'Y') THEN
1104: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1105: END IF;
1106:
1107: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1108: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

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

1110: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1111: END IF;
1112: END IF;
1113:
1114: IF (g_asn_debug = 'Y') THEN
1115: asn_debug.put_line('Validated ship to org of all the RTIs tied to the header');
1116: END IF;
1117: END IF;
1118: END IF; --End of bug# 3662698.

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

1111: END IF;
1112: END IF;
1113:
1114: IF (g_asn_debug = 'Y') THEN
1115: asn_debug.put_line('Validated ship to org of all the RTIs tied to the header');
1116: END IF;
1117: END IF;
1118: END IF; --End of bug# 3662698.
1119:

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

1138: from_org_record.organization_id := p_header_record.header_record.from_organization_id;
1139: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1140: from_org_record.error_record.error_message := NULL;
1141:
1142: IF (g_asn_debug = 'Y') THEN
1143: asn_debug.put_line('In Validate From Organization Procedure');
1144: END IF;
1145:
1146: po_orgs_sv.validate_org_info(from_org_record);

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

1139: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1140: from_org_record.error_record.error_message := NULL;
1141:
1142: IF (g_asn_debug = 'Y') THEN
1143: asn_debug.put_line('In Validate From Organization Procedure');
1144: END IF;
1145:
1146: po_orgs_sv.validate_org_info(from_org_record);
1147:

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

1147:
1148: IF (from_org_record.error_record.error_status <> 'S') THEN
1149: IF from_org_record.error_record.error_message = 'ORG_DISABLED' THEN
1150: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1151: IF (g_asn_debug = 'Y') THEN
1152: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1153: END IF;
1154:
1155: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1148: IF (from_org_record.error_record.error_status <> 'S') THEN
1149: IF from_org_record.error_record.error_message = 'ORG_DISABLED' THEN
1150: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1151: IF (g_asn_debug = 'Y') THEN
1152: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1153: END IF;
1154:
1155: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1156: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);

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

1157: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1158: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1159: END IF;
1160: ELSE
1161: IF (g_asn_debug = 'Y') THEN
1162: asn_debug.put_line('Error with from ORG_ID');
1163: END IF;
1164:
1165: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1158: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1159: END IF;
1160: ELSE
1161: IF (g_asn_debug = 'Y') THEN
1162: asn_debug.put_line('Error with from ORG_ID');
1163: END IF;
1164:
1165: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1166: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);

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

1168: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1169: END IF;
1170: END IF;
1171:
1172: IF (g_asn_debug = 'Y') THEN
1173: asn_debug.put_line('validated from organization info');
1174: END IF;
1175: END IF;
1176: END IF;

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

1169: END IF;
1170: END IF;
1171:
1172: IF (g_asn_debug = 'Y') THEN
1173: asn_debug.put_line('validated from organization info');
1174: END IF;
1175: END IF;
1176: END IF;
1177: EXCEPTION

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

1197: loc_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1198: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1199: loc_record.error_record.error_message := NULL;
1200:
1201: IF (g_asn_debug = 'Y') THEN
1202: asn_debug.put_line('In Validate Location Code Procedure');
1203: END IF;
1204:
1205: po_locations_s.validate_location_info(loc_record);

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

1198: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1199: loc_record.error_record.error_message := NULL;
1200:
1201: IF (g_asn_debug = 'Y') THEN
1202: asn_debug.put_line('In Validate Location Code Procedure');
1203: END IF;
1204:
1205: po_locations_s.validate_location_info(loc_record);
1206:

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

1218: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1219: END IF;
1220: END IF;
1221:
1222: IF (g_asn_debug = 'Y') THEN
1223: asn_debug.put_line(loc_record.error_record.error_status);
1224: asn_debug.put_line(loc_record.error_record.error_message);
1225: asn_debug.put_line('Validated location info');
1226: END IF;

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

1219: END IF;
1220: END IF;
1221:
1222: IF (g_asn_debug = 'Y') THEN
1223: asn_debug.put_line(loc_record.error_record.error_status);
1224: asn_debug.put_line(loc_record.error_record.error_message);
1225: asn_debug.put_line('Validated location info');
1226: END IF;
1227: END IF;

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

1220: END IF;
1221:
1222: IF (g_asn_debug = 'Y') THEN
1223: asn_debug.put_line(loc_record.error_record.error_status);
1224: asn_debug.put_line(loc_record.error_record.error_message);
1225: asn_debug.put_line('Validated location info');
1226: END IF;
1227: END IF;
1228: EXCEPTION

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

1221:
1222: IF (g_asn_debug = 'Y') THEN
1223: asn_debug.put_line(loc_record.error_record.error_status);
1224: asn_debug.put_line(loc_record.error_record.error_message);
1225: asn_debug.put_line('Validated location info');
1226: END IF;
1227: END IF;
1228: EXCEPTION
1229: WHEN rcv_error_pkg.e_fatal_error THEN

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

1277: ** for ship_from_location_id happens only in case of ASN's and ASBN's
1278:
1279: IF (nvl(l_shipping_control,'@@@') = 'BUYER' AND p_header_record.header_record.ship_from_location_id IS NULL
1280: AND p_header_record.header_record.asn_type in ('ASN', 'ASBN') ) THEN
1281: IF (g_asn_debug = 'Y') THEN
1282: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1283: END IF;
1284: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

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

1278:
1279: IF (nvl(l_shipping_control,'@@@') = 'BUYER' AND p_header_record.header_record.ship_from_location_id IS NULL
1280: AND p_header_record.header_record.asn_type in ('ASN', 'ASBN') ) THEN
1281: IF (g_asn_debug = 'Y') THEN
1282: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1283: END IF;
1284: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1286: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);

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

1311: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1312: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1313: END IF;
1314:
1315: IF (g_asn_debug = 'Y') THEN
1316: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1317: END IF;
1318: END IF;
1319: EXCEPTION

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

1312: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1313: END IF;
1314:
1315: IF (g_asn_debug = 'Y') THEN
1316: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1317: END IF;
1318: END IF;
1319: EXCEPTION
1320: WHEN rcv_error_pkg.e_fatal_error THEN

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

1337: pay_record.payment_term_name := p_header_record.header_record.payment_terms_name;
1338: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1339: pay_record.error_record.error_message := NULL;
1340:
1341: IF (g_asn_debug = 'Y') THEN
1342: asn_debug.put_line('In Validate Payment Terms ');
1343: END IF;
1344:
1345: po_terms_sv.validate_payment_terms_info(pay_record);

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

1338: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1339: pay_record.error_record.error_message := NULL;
1340:
1341: IF (g_asn_debug = 'Y') THEN
1342: asn_debug.put_line('In Validate Payment Terms ');
1343: END IF;
1344:
1345: po_terms_sv.validate_payment_terms_info(pay_record);
1346:

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

1355: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1356: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1357: END IF;
1358:
1359: IF (g_asn_debug = 'Y') THEN
1360: asn_debug.put_line(pay_record.error_record.error_status);
1361: END IF;
1362:
1363: IF (g_asn_debug = 'Y') THEN

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

1356: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1357: END IF;
1358:
1359: IF (g_asn_debug = 'Y') THEN
1360: asn_debug.put_line(pay_record.error_record.error_status);
1361: END IF;
1362:
1363: IF (g_asn_debug = 'Y') THEN
1364: asn_debug.put_line('Validated payment info');

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

1359: IF (g_asn_debug = 'Y') THEN
1360: asn_debug.put_line(pay_record.error_record.error_status);
1361: END IF;
1362:
1363: IF (g_asn_debug = 'Y') THEN
1364: asn_debug.put_line('Validated payment info');
1365: END IF;
1366: END IF;
1367: EXCEPTION

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

1360: asn_debug.put_line(pay_record.error_record.error_status);
1361: END IF;
1362:
1363: IF (g_asn_debug = 'Y') THEN
1364: asn_debug.put_line('Validated payment info');
1365: END IF;
1366: END IF;
1367: EXCEPTION
1368: WHEN rcv_error_pkg.e_fatal_error THEN

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

1386: emp_record.employee_id := p_header_record.header_record.employee_id;
1387: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1388: emp_record.error_record.error_message := NULL;
1389:
1390: IF (g_asn_debug = 'Y') THEN
1391: asn_debug.put_line('In Validate Receiver Information');
1392: END IF;
1393:
1394: po_employees_sv.validate_employee_info(emp_record);

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

1387: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1388: emp_record.error_record.error_message := NULL;
1389:
1390: IF (g_asn_debug = 'Y') THEN
1391: asn_debug.put_line('In Validate Receiver Information');
1392: END IF;
1393:
1394: po_employees_sv.validate_employee_info(emp_record);
1395:

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

1392: END IF;
1393:
1394: po_employees_sv.validate_employee_info(emp_record);
1395:
1396: IF (g_asn_debug = 'Y') THEN
1397: asn_debug.put_line(emp_record.error_record.error_status);
1398: END IF;
1399:
1400: IF emp_record.error_record.error_status <> 'S' THEN

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

1393:
1394: po_employees_sv.validate_employee_info(emp_record);
1395:
1396: IF (g_asn_debug = 'Y') THEN
1397: asn_debug.put_line(emp_record.error_record.error_status);
1398: END IF;
1399:
1400: IF emp_record.error_record.error_status <> 'S' THEN
1401: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1403: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1404: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1405: END IF;
1406:
1407: IF (g_asn_debug = 'Y') THEN
1408: asn_debug.put_line('Validated receiver info');
1409: END IF;
1410: END IF;
1411: EXCEPTION

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

1404: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1405: END IF;
1406:
1407: IF (g_asn_debug = 'Y') THEN
1408: asn_debug.put_line('Validated receiver info');
1409: END IF;
1410: END IF;
1411: EXCEPTION
1412: WHEN rcv_error_pkg.e_fatal_error THEN

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

1433: freight_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1434: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1435: freight_record.error_record.error_message := NULL;
1436:
1437: IF (g_asn_debug = 'Y') THEN
1438: asn_debug.put_line('In Validate Freight Carrier Information');
1439: END IF;
1440:
1441: /*Bug 8366230

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

1434: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1435: freight_record.error_record.error_message := NULL;
1436:
1437: IF (g_asn_debug = 'Y') THEN
1438: asn_debug.put_line('In Validate Freight Carrier Information');
1439: END IF;
1440:
1441: /*Bug 8366230
1442: Adding IF conditions to ensure that the validation call for freight carriers is not made for

Line 1462: asn_debug.put_line('Erroring out in rcv_roi_header_common.validate_freight_carrier_info');

1458: END IF;
1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: asn_debug.put_line('Erroring out in rcv_roi_header_common.validate_freight_carrier_info');
1463: asn_debug.put_line(SQLERRM);
1464: END;
1465: /* End of fix for Bug 8366230 */
1466:

Line 1463: asn_debug.put_line(SQLERRM);

1459:
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: asn_debug.put_line('Erroring out in rcv_roi_header_common.validate_freight_carrier_info');
1463: asn_debug.put_line(SQLERRM);
1464: END;
1465: /* End of fix for Bug 8366230 */
1466:
1467: po_terms_sv.validate_freight_carrier_info(freight_record);

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

1472: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1473: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1474: END IF;
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line(freight_record.error_record.error_status);
1478: asn_debug.put_line('Validated freight carrier info');
1479: END IF;
1480: END IF;

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

1473: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1474: END IF;
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line(freight_record.error_record.error_status);
1478: asn_debug.put_line('Validated freight carrier info');
1479: END IF;
1480: END IF;
1481: EXCEPTION

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

1474: END IF;
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line(freight_record.error_record.error_status);
1478: asn_debug.put_line('Validated freight carrier info');
1479: END IF;
1480: END IF;
1481: EXCEPTION
1482: WHEN rcv_error_pkg.e_fatal_error THEN

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

1497: /* R12 Complex Work.
1498: * There is no concept of shipped_date for Work Confirmations.
1499: * So shipped_date can be null.
1500: */
1501: IF (g_asn_debug = 'Y') THEN
1502: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1503: END IF;
1504: IF p_header_record.header_record.shipped_date IS NULL
1505: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN

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

1498: * There is no concept of shipped_date for Work Confirmations.
1499: * So shipped_date can be null.
1500: */
1501: IF (g_asn_debug = 'Y') THEN
1502: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1503: END IF;
1504: IF p_header_record.header_record.shipped_date IS NULL
1505: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1506: IF (g_asn_debug = 'Y') THEN

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

1502: asn_debug.put_line('asn_type ' || p_header_record.header_record.asn_type);
1503: END IF;
1504: IF p_header_record.header_record.shipped_date IS NULL
1505: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1506: IF (g_asn_debug = 'Y') THEN
1507: asn_debug.put_line('Shipped date can be blank for STD '||
1508: 'or Work Confirmations ');
1509: END IF;
1510: ELSE

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

1503: END IF;
1504: IF p_header_record.header_record.shipped_date IS NULL
1505: AND p_header_record.header_record.asn_type IN ('WC', 'STD') THEN
1506: IF (g_asn_debug = 'Y') THEN
1507: asn_debug.put_line('Shipped date can be blank for STD '||
1508: 'or Work Confirmations ');
1509: END IF;
1510: ELSE
1511: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1514: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1515: END IF;
1516: END IF;
1517:
1518: IF (g_asn_debug = 'Y') THEN
1519: asn_debug.put_line('validated for shipment_date > system date');
1520: END IF;
1521: EXCEPTION
1522: WHEN rcv_error_pkg.e_fatal_error THEN

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

1515: END IF;
1516: END IF;
1517:
1518: IF (g_asn_debug = 'Y') THEN
1519: asn_debug.put_line('validated for shipment_date > system date');
1520: END IF;
1521: EXCEPTION
1522: WHEN rcv_error_pkg.e_fatal_error THEN
1523: NULL;

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

1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;
1536: x_error_status VARCHAR2(1);
1537: BEGIN
1538: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);
1539: x_error_status := rcv_error_pkg.g_ret_sts_error;
1540:
1541: SELECT NVL(MAX(inventory_item_id), -9999)
1542: INTO x_inventory_item

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

1563: -- Bugfix 5735599
1564: -- When item status is changed to INACTIVE all the flags are unchecked.
1565: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1566:
1567: IF (g_asn_debug = 'Y') THEN
1568: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1569: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1570: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1571: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );

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

1564: -- When item status is changed to INACTIVE all the flags are unchecked.
1565: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1566:
1567: IF (g_asn_debug = 'Y') THEN
1568: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1569: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1570: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1571: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1572: END IF;

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

1565: -- Hence to check inactive item we should check for STOCK_ENABLED_FLAG.
1566:
1567: IF (g_asn_debug = 'Y') THEN
1568: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1569: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1570: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1571: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1572: END IF;
1573:

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

1566:
1567: IF (g_asn_debug = 'Y') THEN
1568: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1569: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1570: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1571: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1572: END IF;
1573:
1574: BEGIN

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

1567: IF (g_asn_debug = 'Y') THEN
1568: asn_debug.put_line('x_cascaded_table(n).auto_transact_code: ' || x_cascaded_table(n).auto_transact_code);
1569: asn_debug.put_line('x_cascaded_table(n).TO_ORGANIZATION_ID: ' || x_cascaded_table(n).to_organization_id);
1570: asn_debug.put_line('x_cascaded_table(n).item_id: ' || x_cascaded_table(n).item_id);
1571: asn_debug.put_line('x_cascaded_table(n).TRANSACTION_TYPE ' || x_cascaded_table(n).transaction_type );
1572: END IF;
1573:
1574: BEGIN
1575: SELECT stock_enabled_flag,

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

1581: AND inventory_item_id = x_cascaded_table(n).item_id;
1582: EXCEPTION
1583: WHEN OTHERS
1584: THEN
1585: IF (g_asn_debug = 'Y') THEN
1586: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1587: END IF;
1588:
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;

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

1582: EXCEPTION
1583: WHEN OTHERS
1584: THEN
1585: IF (g_asn_debug = 'Y') THEN
1586: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1587: END IF;
1588:
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1590: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');

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

1650: END IF;
1651: END IF; --}
1652:
1653: /* bug 608353, do not support lot and serial control if DELIVER is used */
1654: IF (g_asn_debug = 'Y') THEN
1655: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1656: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1657: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1658: END IF;

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

1651: END IF; --}
1652:
1653: /* bug 608353, do not support lot and serial control if DELIVER is used */
1654: IF (g_asn_debug = 'Y') THEN
1655: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1656: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1657: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1658: END IF;
1659: EXCEPTION

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

1652:
1653: /* bug 608353, do not support lot and serial control if DELIVER is used */
1654: IF (g_asn_debug = 'Y') THEN
1655: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1656: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1657: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1658: END IF;
1659: EXCEPTION
1660: WHEN e_validation_error THEN

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

1653: /* bug 608353, do not support lot and serial control if DELIVER is used */
1654: IF (g_asn_debug = 'Y') THEN
1655: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).auto_transact_code);
1656: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_lot);
1657: asn_debug.put_line('Validating Item: ' || x_cascaded_table(n).use_mtl_serial);
1658: END IF;
1659: EXCEPTION
1660: WHEN e_validation_error THEN
1661: x_cascaded_table(n).error_status := x_error_status;

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

1909: RETURN;
1910: END IF;
1911:
1912: -- Check whether the revision number exists
1913: IF (g_asn_debug = 'Y') THEN
1914: asn_debug.put_line('Revision number : ' || x_cascaded_table(n).item_revision);
1915: END IF;
1916:
1917: SELECT NVL(MAX(inventory_item_id), 0)

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

1910: END IF;
1911:
1912: -- Check whether the revision number exists
1913: IF (g_asn_debug = 'Y') THEN
1914: asn_debug.put_line('Revision number : ' || x_cascaded_table(n).item_revision);
1915: END IF;
1916:
1917: SELECT NVL(MAX(inventory_item_id), 0)
1918: INTO x_inventory_item

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

1934: IF x_cascaded_table(n).error_message = 'PO_RI_INVALID_ITEM_REVISION' THEN
1935: NULL;
1936: END IF;
1937: when others then
1938: IF (g_asn_debug = 'Y') THEN
1939: asn_debug.put_line('exception in valid_item_revision');
1940: asn_debug.put_line(SQLERRM);
1941: END IF;
1942: x_cascaded_table(n).error_status := 'E';

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

1935: NULL;
1936: END IF;
1937: when others then
1938: IF (g_asn_debug = 'Y') THEN
1939: asn_debug.put_line('exception in valid_item_revision');
1940: asn_debug.put_line(SQLERRM);
1941: END IF;
1942: x_cascaded_table(n).error_status := 'E';
1943: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

Line 1940: asn_debug.put_line(SQLERRM);

1936: END IF;
1937: when others then
1938: IF (g_asn_debug = 'Y') THEN
1939: asn_debug.put_line('exception in valid_item_revision');
1940: asn_debug.put_line(SQLERRM);
1941: END IF;
1942: x_cascaded_table(n).error_status := 'E';
1943: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1944:

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

1949: IS
1950: l_lcm_org_flag VARCHAR2(1);
1951: l_pre_rcv_flag VARCHAR2(1);
1952: BEGIN
1953: IF (g_asn_debug = 'Y') THEN
1954: asn_debug.put_line('In Validate LCM Info');
1955: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1956: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1957: END IF;

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

1950: l_lcm_org_flag VARCHAR2(1);
1951: l_pre_rcv_flag VARCHAR2(1);
1952: BEGIN
1953: IF (g_asn_debug = 'Y') THEN
1954: asn_debug.put_line('In Validate LCM Info');
1955: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1956: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1957: END IF;
1958:

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

1951: l_pre_rcv_flag VARCHAR2(1);
1952: BEGIN
1953: IF (g_asn_debug = 'Y') THEN
1954: asn_debug.put_line('In Validate LCM Info');
1955: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1956: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1957: END IF;
1958:
1959: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

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

1952: BEGIN
1953: IF (g_asn_debug = 'Y') THEN
1954: asn_debug.put_line('In Validate LCM Info');
1955: asn_debug.put_line('p_header_record.error_record.error_status ' || p_header_record.error_record.error_status);
1956: asn_debug.put_line('p_header_record.header_record.asn_type ' || p_header_record.header_record.asn_type);
1957: END IF;
1958:
1959: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN
1960: RETURN;

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

1964:
1965: l_lcm_org_flag := rcv_table_functions.is_lcm_org(p_header_record.header_record.ship_to_organization_id);
1966: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1967:
1968: IF (g_asn_debug = 'Y') THEN
1969: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1970: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1971: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1972: END IF;

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

1965: l_lcm_org_flag := rcv_table_functions.is_lcm_org(p_header_record.header_record.ship_to_organization_id);
1966: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1967:
1968: IF (g_asn_debug = 'Y') THEN
1969: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1970: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1971: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1972: END IF;
1973:

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

1966: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(p_header_record.header_record.ship_to_organization_id);
1967:
1968: IF (g_asn_debug = 'Y') THEN
1969: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1970: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1971: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1972: END IF;
1973:
1974: IF (l_lcm_org_flag = 'Y') THEN

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

1967:
1968: IF (g_asn_debug = 'Y') THEN
1969: asn_debug.put_line('p_header_record.header_record.ship_to_organization_id ' || p_header_record.header_record.ship_to_organization_id);
1970: asn_debug.put_line('l_lcm_org_flag => ' || l_lcm_org_flag);
1971: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);
1972: END IF;
1973:
1974: IF (l_lcm_org_flag = 'Y') THEN
1975: IF ( l_pre_rcv_flag = 'N') THEN

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

1981: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1982: --
1983: ELSE
1984: --
1985: IF (g_asn_debug = 'Y') THEN
1986: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1987: END IF;
1988: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1989: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1982: --
1983: ELSE
1984: --
1985: IF (g_asn_debug = 'Y') THEN
1986: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1987: END IF;
1988: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1989: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1990: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);

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

2002: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
2003: END IF;
2004: END IF;
2005:
2006: IF (g_asn_debug = 'Y') THEN
2007: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
2008: asn_debug.put_line('Exitting validate_lcm_info');
2009: END IF;
2010:

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

2003: END IF;
2004: END IF;
2005:
2006: IF (g_asn_debug = 'Y') THEN
2007: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
2008: asn_debug.put_line('Exitting validate_lcm_info');
2009: END IF;
2010:
2011: EXCEPTION

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

2004: END IF;
2005:
2006: IF (g_asn_debug = 'Y') THEN
2007: asn_debug.put_line('p_header_record.error_record.error_status' || p_header_record.error_record.error_status);
2008: asn_debug.put_line('Exitting validate_lcm_info');
2009: END IF;
2010:
2011: EXCEPTION
2012: WHEN rcv_error_pkg.e_fatal_error THEN