APPS.RCV_TRANSACTION_PROCESSOR dependencies on PO_NOTE_REFERENCES

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

632: /* Bug: 6487371
633: * Added exception handler to catch the exception when insertion into rcv_transactions
634: * fails due to exception raised in the triggers(for eg; India Localisation triggers) on
635: * rcv_transactions table. Similarly added exception handler for insertion into
636: * po_note_references table. To this rvthinns() function as whole, added one exception handler.
637: * While storing sqlerrm in the x_message_data getting only the first 200 bytes.
638: * without that unhandled exception is raised while copying the sqlerrm. And moreover
639: * in rvtth.lpc rvthinns(), x_msg_data is defined to store only 200 bytes.
640: */

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

1035: NULL;
1036: END;
1037: END IF;
1038:
1039: asn_debug.put_line('Updating PO Note References');
1040:
1041: DECLARE
1042: l_row_id NUMBER;
1043: BEGIN

Line 1044: UPDATE po_note_references

1040:
1041: DECLARE
1042: l_row_id NUMBER;
1043: BEGIN
1044: UPDATE po_note_references
1045: SET table_name = 'RCV_TRANSACTIONS',
1046: column_name = 'TRANSACTION_ID',
1047: foreign_id = l_rt_row.transaction_id
1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

Line 1057: INSERT INTO po_note_references

1053: p_transaction_type = 'DELIVER' AND
1054: l_rti_row.auto_transact_code = 'DELIVER' AND
1055: p_receive_id IS NOT NULL
1056: THEN
1057: INSERT INTO po_note_references
1058: (po_note_reference_id,
1059: last_update_date,
1060: last_updated_by,
1061: last_update_login,

Line 1090: SELECT po_note_references_s.nextval,

1086: attribute12,
1087: attribute13,
1088: attribute14,
1089: attribute15)
1090: SELECT po_note_references_s.nextval,
1091: last_update_date,
1092: last_updated_by,
1093: last_update_login,
1094: creation_date,

Line 1122: FROM po_note_references

1118: attribute12,
1119: attribute13,
1120: attribute14,
1121: attribute15
1122: FROM po_note_references
1123: WHERE table_name = 'RCV_TRANSACTIONS'
1124: AND column_name = 'TRANSACTION_ID'
1125: AND foreign_id = p_receive_id;
1126: END IF;

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

1125: AND foreign_id = p_receive_id;
1126: END IF;
1127: EXCEPTION--Bug: 6487371
1128: when others then
1129: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);
1130: x_error_message := substr(sqlerrm,1,200);
1131: RETURN;--Bug: 6487371
1132: END;
1133: EXCEPTION--Bug: 6487371