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 78: asn_debug.put_line('Entering RCV_INSERT_FROM_INL.insert_rcv_tables' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

225: IF c_rcv_header%ISOPEN THEN
226: CLOSE c_rcv_header;
227: END IF;
228:
229: asn_debug.put_line ('inserted header');
230:
231: end if;
232:
233: asn_debug.put_line ('ship line group ID: '||p_int_rec(i).ship_line_group_id);

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

229: asn_debug.put_line ('inserted header');
230:
231: end if;
232:
233: asn_debug.put_line ('ship line group ID: '||p_int_rec(i).ship_line_group_id);
234:
235: l_interface_source_code := 'LCM';
236: l_transaction_type := 'SHIP';
237: l_processing_status_code := 'PENDING';

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

277: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
278: INTO l_interface_transaction_id
279: FROM dual;
280:
281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
282: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
283: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
284:
285: INSERT INTO rcv_transactions_interface

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

278: INTO l_interface_transaction_id
279: FROM dual;
280:
281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
282: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
283: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
284:
285: INSERT INTO rcv_transactions_interface
286: (interface_transaction_id, -- 01

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

279: FROM dual;
280:
281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
282: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
283: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
284:
285: INSERT INTO rcv_transactions_interface
286: (interface_transaction_id, -- 01
287: group_id, -- 02

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

372: p_int_rec(i).secondary_qty, -- 42 /* Bug 8911750 */
373: p_int_rec(i).secondary_uom_code, -- 43 /* Bug 8911750 */
374: l_secondary_uom); -- 44 /* Bug 8911750 */
375:
376: asn_debug.put_line('inserted line');
377:
378: end loop;
379: COMMIT;
380:

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

391: NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
392: NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
393: NULL, NULL, NULL, NULL, NULL, NULL);
394:
395: asn_debug.put_line ('request id: '||l_req_id);
396:
397: if (l_req_id <= 0 or l_req_id is null) then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;

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

406: END IF;
407:
408: ROLLBACK;
409:
410: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
411:
412: END insert_rcv_tables;
413:
414: END RCV_INSERT_FROM_INL;