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_INSERT_FROM_INL dependencies on ASN_DEBUG

Line 77: asn_debug.put_line('Entering RCV_INSERT_FROM_INL.insert_rcv_tables' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

73: l_primary_uom VARCHAR2(25); /* Bug 8210608: Added to fetch unit_of_measure from uom_code */
74:
75: BEGIN
76:
77: asn_debug.put_line('Entering RCV_INSERT_FROM_INL.insert_rcv_tables' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
78: asn_debug.put_line ('count: '||p_int_rec.COUNT);
79:
80: currentLineGrpId := -9999;
81: for i in 1..p_int_rec.COUNT loop

Line 78: asn_debug.put_line ('count: '||p_int_rec.COUNT);

74:
75: BEGIN
76:
77: asn_debug.put_line('Entering RCV_INSERT_FROM_INL.insert_rcv_tables' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
78: asn_debug.put_line ('count: '||p_int_rec.COUNT);
79:
80: currentLineGrpId := -9999;
81: for i in 1..p_int_rec.COUNT loop
82:

Line 98: asn_debug.put_line ('no of rows updated: '|| SQL%ROWCOUNT);

94: and rhi.group_id = rti.group_id
95: and rhi.receipt_header_id = p_int_rec(i).shipment_header_id)
96: and RTI.PROCESSING_STATUS_CODE = 'INSERTING';
97:
98: asn_debug.put_line ('no of rows updated: '|| SQL%ROWCOUNT);
99:
100: update rcv_headers_interface
101: set receipt_header_id = NULL
102: where receipt_header_id = p_int_rec(i).shipment_header_id;

Line 122: asn_debug.put_line ('request id: '||l_req_id);

118: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
119: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
120: NULL, NULL, NULL, NULL, NULL, NULL);
121:
122: asn_debug.put_line ('request id: '||l_req_id);
123:
124: if (l_req_id <= 0 or l_req_id is null) then
125: raise fnd_api.g_exc_unexpected_error;
126: end if;

Line 132: asn_debug.put_line ('ship line group id: '||p_int_rec(i).ship_line_group_id);

128: -- null;
129:
130: end if;
131:
132: asn_debug.put_line ('ship line group id: '||p_int_rec(i).ship_line_group_id);
133:
134: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL
135: INTO l_header_interface_id
136: FROM dual;

Line 148: asn_debug.put_line ('header interface id: '||l_header_interface_id);

144: l_processing_status_code := 'PENDING';
145: l_receipt_source_code := 'VENDOR';
146: l_validation_flag := 'Y';
147:
148: asn_debug.put_line ('header interface id: '||l_header_interface_id);
149: asn_debug.put_line ('group id: '||l_group_id);
150:
151: /*
152: receipt_header_id is used to store the LCM shipment header id in order to populate the

Line 149: asn_debug.put_line ('group id: '||l_group_id);

145: l_receipt_source_code := 'VENDOR';
146: l_validation_flag := 'Y';
147:
148: asn_debug.put_line ('header interface id: '||l_header_interface_id);
149: asn_debug.put_line ('group id: '||l_group_id);
150:
151: /*
152: receipt_header_id is used to store the LCM shipment header id in order to populate the
153: next set of RTI columnss with the corresponding columns of the earlier set of RTIs.

Line 156: asn_debug.put_line ('ship_date: '||l_rcv_header.ship_date);

152: receipt_header_id is used to store the LCM shipment header id in order to populate the
153: next set of RTI columnss with the corresponding columns of the earlier set of RTIs.
154: */
155:
156: asn_debug.put_line ('ship_date: '||l_rcv_header.ship_date);
157:
158: open c_rcv_header(p_ship_header_id, p_int_rec(i).ship_line_group_id);
159: fetch c_rcv_header into l_rcv_header;
160:

Line 216: asn_debug.put_line ('inserted header');

212: IF c_rcv_header%ISOPEN THEN
213: CLOSE c_rcv_header;
214: END IF;
215:
216: asn_debug.put_line ('inserted header');
217:
218: end if;
219:
220: asn_debug.put_line ('ship line group ID: '||p_int_rec(i).ship_line_group_id);

Line 220: asn_debug.put_line ('ship line group ID: '||p_int_rec(i).ship_line_group_id);

216: asn_debug.put_line ('inserted header');
217:
218: end if;
219:
220: asn_debug.put_line ('ship line group ID: '||p_int_rec(i).ship_line_group_id);
221:
222: l_interface_source_code := 'LCM';
223: l_transaction_type := 'SHIP';
224: l_processing_status_code := 'PENDING';

Line 255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);

251: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
252: INTO l_interface_transaction_id
253: FROM dual;
254:
255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
258:
259: INSERT INTO rcv_transactions_interface

Line 256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);

252: INTO l_interface_transaction_id
253: FROM dual;
254:
255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
258:
259: INSERT INTO rcv_transactions_interface
260: (interface_transaction_id, -- 01

Line 257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);

253: FROM dual;
254:
255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
258:
259: INSERT INTO rcv_transactions_interface
260: (interface_transaction_id, -- 01
261: group_id, -- 02

Line 344: asn_debug.put_line('inserted line');

340: 'SHIP', -- 39
341: p_int_rec(i).primary_qty, -- 40 /* Bug 8210608 */
342: l_primary_uom); -- 41 /* Bug 8210608 */
343:
344: asn_debug.put_line('inserted line');
345:
346: end loop;
347: COMMIT;
348:

Line 362: asn_debug.put_line ('request id: '||l_req_id);

358: NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
359: NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
360: NULL, NULL, NULL, NULL, NULL, NULL);
361:
362: asn_debug.put_line ('request id: '||l_req_id);
363:
364: if (l_req_id <= 0 or l_req_id is null) then
365: raise fnd_api.g_exc_unexpected_error;
366: end if;

Line 377: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

373: END IF;
374:
375: ROLLBACK;
376:
377: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
378:
379: END insert_rcv_tables;
380:
381: END RCV_INSERT_FROM_INL;