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
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 .*/
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
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:
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:
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
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);
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:
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;
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;
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:
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: