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

Line 33: ASN_DEBUG.PUT_LINE('Transaction Type ' || v_trans_tab(j).transaction_type);

29:
30:
31: FOR j in i..E_O_T loop
32:
33: ASN_DEBUG.PUT_LINE('Transaction Type ' || v_trans_tab(j).transaction_type);
34:
35: V_CURRENT_INTERFACE_ID := V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID;
36:
37: /* SELECT GROUP_SEQUENCE_ID_S.nextval into V_TRANS_TAB(j).GROUP_ID

Line 44: ASN_DEBUG.PUT_LINE('Group id ' || to_char(V_TRANS_TAB(j).GROUP_ID));

40: -- Will use the group_id from the header_record as the pre-processor
41: -- needs the header and transactions group id to be the same
42:
43: V_TRANS_TAB(j).GROUP_ID := V_HEADER_RECORD.HEADER_RECORD.GROUP_ID;
44: ASN_DEBUG.PUT_LINE('Group id ' || to_char(V_TRANS_TAB(j).GROUP_ID));
45:
46: /* Assigning to_organization_id to lorgid which is passed
47: as a parameter to WMS_INSTALL function .Also added
48: debug messages .*/

Line 52: ASN_DEBUG.PUT_LINE('organization id ' || to_char(V_TRANS_TAB(j).TO_ORGANIZATION_ID));

48: debug messages .*/
49:
50: lorgid := V_TRANS_TAB(j).TO_ORGANIZATION_ID;
51:
52: ASN_DEBUG.PUT_LINE('organization id ' || to_char(V_TRANS_TAB(j).TO_ORGANIZATION_ID));
53: ASN_DEBUG.PUT_LINE('lorgid ' || to_char(lorgid));
54:
55:
56: IF V_CURRENT_INTERFACE_ID <> V_PRIOR_INTERFACE_ID then

Line 53: ASN_DEBUG.PUT_LINE('lorgid ' || to_char(lorgid));

49:
50: lorgid := V_TRANS_TAB(j).TO_ORGANIZATION_ID;
51:
52: ASN_DEBUG.PUT_LINE('organization id ' || to_char(V_TRANS_TAB(j).TO_ORGANIZATION_ID));
53: ASN_DEBUG.PUT_LINE('lorgid ' || to_char(lorgid));
54:
55:
56: IF V_CURRENT_INTERFACE_ID <> V_PRIOR_INTERFACE_ID then
57:

Line 58: ASN_DEBUG.PUT_LINE('Handle the original interface id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));

54:
55:
56: IF V_CURRENT_INTERFACE_ID <> V_PRIOR_INTERFACE_ID then
57:
58: ASN_DEBUG.PUT_LINE('Handle the original interface id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
59: ASN_DEBUG.PUT_LINE('delete from rcv_transactions_interface rowid ' || V_TRANS_TAB(j).ROW_ID);
60:
61: RCV_TRX_INTERFACE_DELETE_PKG.Delete_Row(V_TRANS_TAB(j).ROW_ID);
62:

Line 59: ASN_DEBUG.PUT_LINE('delete from rcv_transactions_interface rowid ' || V_TRANS_TAB(j).ROW_ID);

55:
56: IF V_CURRENT_INTERFACE_ID <> V_PRIOR_INTERFACE_ID then
57:
58: ASN_DEBUG.PUT_LINE('Handle the original interface id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
59: ASN_DEBUG.PUT_LINE('delete from rcv_transactions_interface rowid ' || V_TRANS_TAB(j).ROW_ID);
60:
61: RCV_TRX_INTERFACE_DELETE_PKG.Delete_Row(V_TRANS_TAB(j).ROW_ID);
62:
63: /* V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID := NULL; */ -- need to maintain the interface transaction id

Line 262: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);

258: V_TRANS_TAB(j).SHIPMENT_LINE_STATUS_CODE,
259: V_TRANS_TAB(j).BARCODE_LABEL,
260: V_TRANS_TAB(j).COUNTRY_OF_ORIGIN_CODE);
261:
262: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);
263: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
264:
265: V_PRIOR_INTERFACE_ID := V_CURRENT_INTERFACE_ID;
266: V_TRANS_TAB.delete(j);

Line 263: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));

259: V_TRANS_TAB(j).BARCODE_LABEL,
260: V_TRANS_TAB(j).COUNTRY_OF_ORIGIN_CODE);
261:
262: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);
263: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
264:
265: V_PRIOR_INTERFACE_ID := V_CURRENT_INTERFACE_ID;
266: V_TRANS_TAB.delete(j);
267:

Line 270: ASN_DEBUG.PUT_LINE('insert into rcv_transactions_interface with new id ');

266: V_TRANS_TAB.delete(j);
267:
268: ELSE
269:
270: ASN_DEBUG.PUT_LINE('insert into rcv_transactions_interface with new id ');
271:
272: /* Since we are inserting 1-> many rows need to generate a new interface id */
273:
274: V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID := NULL;

Line 472: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);

468: V_TRANS_TAB(j).SHIPMENT_LINE_STATUS_CODE,
469: V_TRANS_TAB(j).BARCODE_LABEL,
470: V_TRANS_TAB(j).COUNTRY_OF_ORIGIN_CODE);
471:
472: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);
473: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
474:
475: V_TRANS_TAB.delete(j);
476: END IF;

Line 473: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));

469: V_TRANS_TAB(j).BARCODE_LABEL,
470: V_TRANS_TAB(j).COUNTRY_OF_ORIGIN_CODE);
471:
472: ASN_DEBUG.PUT_LINE('RowId ' || V_TRANS_TAB(j).ROW_ID);
473: ASN_DEBUG.PUT_LINE('Interface Id ' || to_char(V_TRANS_TAB(j).INTERFACE_TRANSACTION_ID));
474:
475: V_TRANS_TAB.delete(j);
476: END IF;
477:

Line 507: asn_debug.put_line('Delete any asn lines that have been sent');

503: BEGIN
504:
505: -- delete any asn lines that have been sent
506:
507: asn_debug.put_line('Delete any asn lines that have been sent');
508:
509: delete from rcv_transactions_interface
510: where header_interface_id = v_header_record.header_record.header_interface_id;
511: