APPS.RCV_TRANSACTION_PROCESSOR dependencies on PO_NOTE_REFERENCES

Line 564: * po_note_references table. To this rvthinns() function as whole, added one exception handler.

560: /* Bug: 6487371
561: * Added exception handler to catch the exception when insertion into rcv_transactions
562: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
563: * rcv_transactions table. Similarly added exception handler for insertion into
564: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
565: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.
566: * without that unhandled exception is raised while copying the sqlerrm. And moreover
567: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.
568: */

Line 963: asn_debug.put_line('Updating PO Note References');

959: NULL;
960: END;
961: END IF;
962:
963: asn_debug.put_line('Updating PO Note References');
964:
965: DECLARE
966: l_row_id NUMBER;
967: BEGIN

Line 968: UPDATE po_note_references

964:
965: DECLARE
966: l_row_id NUMBER;
967: BEGIN
968: UPDATE po_note_references
969: SET table_name = 'RCV_TRANSACTIONS',
970: column_name = 'TRANSACTION_ID',
971: foreign_id = l_rt_row.transaction_id
972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

Line 981: INSERT INTO po_note_references

977: p_transaction_type = 'DELIVER' AND
978: l_rti_row.auto_transact_code = 'DELIVER' AND
979: p_receive_id IS NOT NULL
980: THEN
981: INSERT INTO po_note_references
982: (po_note_reference_id,
983: last_update_date,
984: last_updated_by,
985: last_update_login,

Line 1014: SELECT po_note_references_s.nextval,

1010: attribute12,
1011: attribute13,
1012: attribute14,
1013: attribute15)
1014: SELECT po_note_references_s.nextval,
1015: last_update_date,
1016: last_updated_by,
1017: last_update_login,
1018: creation_date,

Line 1046: FROM po_note_references

1042: attribute12,
1043: attribute13,
1044: attribute14,
1045: attribute15
1046: FROM po_note_references
1047: WHERE table_name = 'RCV_TRANSACTIONS'
1048: AND column_name = 'TRANSACTION_ID'
1049: AND foreign_id = p_receive_id;
1050: END IF;

Line 1053: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);

1049: AND foreign_id = p_receive_id;
1050: END IF;
1051: EXCEPTION--Bug: 6487371
1052: when others then
1053: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);
1054: x_error_message := substr(sqlerrm,1,200);
1055: RETURN;--Bug: 6487371
1056: END;
1057: EXCEPTION--Bug: 6487371