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.AR_AUTOREC_API dependencies on RA_CUSTOMER_TRX

Line 715: /* update the error flag in ra_customer_trx */

711: p_exception_code => 'AR_CC_AUTH_FAILED',
712: p_additional_message => pl_count||pl_msg_data
713: );
714:
715: /* update the error flag in ra_customer_trx */
716:
717: UPDATE ra_customer_trx
718: SET cc_error_flag = 'Y',
719: cc_error_code = l_response_error_code,

Line 717: UPDATE ra_customer_trx

713: );
714:
715: /* update the error flag in ra_customer_trx */
716:
717: UPDATE ra_customer_trx
718: SET cc_error_flag = 'Y',
719: cc_error_code = l_response_error_code,
720: cc_error_text = pl_msg_data,
721: last_updated_by = l_last_updated_by,

Line 756: /* update the error flag in ra_customer_trx */

752: p_exception_code => 'AR_CC_AUTH_FAILED',
753: p_additional_message => pl_count||pl_msg_data
754: );
755:
756: /* update the error flag in ra_customer_trx */
757:
758: UPDATE ra_customer_trx
759: SET cc_error_flag = 'Y',
760: cc_error_code = l_response_error_code,

Line 758: UPDATE ra_customer_trx

754: );
755:
756: /* update the error flag in ra_customer_trx */
757:
758: UPDATE ra_customer_trx
759: SET cc_error_flag = 'Y',
760: cc_error_code = l_response_error_code,
761: cc_error_text = pl_msg_data,
762: last_updated_by = l_last_updated_by,

Line 1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,

1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688

Line 1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,

1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1197: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688

Line 1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,

1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,

Line 1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,

1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
1213: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,
1214: p_instrument_type OUT NOCOPY IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE,

Line 1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,

1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
1213: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,
1214: p_instrument_type OUT NOCOPY IBY_PMT_INSTR_USES_ALL.instrument_type%TYPE,
1215: p_return_status OUT NOCOPY VARCHAR2
1216: ) IS

Line 1301: ra_customer_trx ct,

1297: FROM hz_customer_profiles cust_cp,
1298: hz_customer_profiles site_cp,
1299: hz_cust_profile_amts cust_cpa,
1300: hz_cust_profile_amts site_cpa,
1301: ra_customer_trx ct,
1302: iby_fndcpt_tx_extensions x,
1303: iby_pmt_instr_uses_all u,
1304: iby_fndcpt_pmt_chnnls_b p,
1305: ar_payment_schedules ps,

Line 1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;

1764: ) IS
1765:
1766: p_creation_rule VARCHAR2(40);
1767: l_status NUMBER;
1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;

Line 1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;

1765:
1766: p_creation_rule VARCHAR2(40);
1767: l_status NUMBER;
1768: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
1769: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
1770: p_set_of_books_id ar_batches.set_of_books_id%TYPE;
1771: p_name ar_receipt_methods.name%TYPE;
1772: p_batch_date ar_batches.batch_date%TYPE;
1773: p_currency_code ar_batches.currency_code%TYPE;

Line 4375: UPDATE /+ index(ct ra_customer_trx_u1) / ra_customer_trx_all ct

4371: l_program_id := arp_standard.profile.program_id;
4372:
4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
4374:
4375: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
4376: SET cc_error_flag = 'Y',
4377: last_updated_by = l_last_updated_by,
4378: last_update_date = sysdate,
4379: last_update_login = l_last_update_login,

Line 4489: UPDATE /+ index(ct ra_customer_trx_u1) / ra_customer_trx_all ct

4485:
4486: /* Note here - the apply process was succesful but auth failed so here we have to unapply the
4487: payment_schedule_id before going in for the delete */
4488:
4489: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
4490: SET cc_error_flag = null,
4491: cc_error_code = null,
4492: cc_error_text = null
4493: WHERE customer_trx_id in (

Line 4560: ra_customer_trx trx,

4556: ps.customer_trx_id trx_id,
4557: r.receipt_number rec_num,
4558: r.cash_receipt_id rec_id
4559: from ar_payment_schedules ps,
4560: ra_customer_trx trx,
4561: ar_receipts_gt r
4562: where trx.customer_trx_id = ps.customer_trx_id
4563: and trx.cc_error_flag = 'Y'
4564: and r.payment_schedule_id = ps.payment_schedule_id;

Line 4754: ra_customer_trx trx

4750: status = 'OP'
4751: where payment_schedule_id in (
4752: select ps.payment_schedule_id
4753: from ar_payment_schedules ps,
4754: ra_customer_trx trx
4755: where trx.customer_trx_id = ps.customer_trx_id
4756: and trx.cc_error_flag = 'Y'
4757: and trx.request_id = l_request_id);
4758: