[Home] [Help]
1235: l_error_message VARCHAR2(128);
1236: l_defaulting_rule_used VARCHAR2(50);
1237: l_default_gl_date DATE;
1238: error_defaulting_gl_date EXCEPTION;
1239: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1240: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1241: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1242: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1243: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1861: arp_standard.debug( '-- Get CB_ADJ activity accounting code combination');
1862: END IF;
1863: SELECT rt.code_combination_id
1864: INTO l_cb_activity_ccid
1865: FROM ar_receivables_trx rt
1866: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID
1867: AND rt.code_combination_id IS NOT NULL;
1868: EXCEPTION
1869: WHEN NO_DATA_FOUND THEN
1870: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );
1871: app_exception.raise_exception;
1872: WHEN OTHERS THEN
1873: IF PG_DEBUG in ('Y', 'C') THEN
1874: arp_standard.debug( '-- Exception: select from ar_receivables_trx');
1875: END IF;
1876: END;
1877:
1878: l_ctlgd_row.code_combination_id := l_cb_activity_ccid;
2156: THEN
2157: -- Set up sequential numbering stuff
2158: SELECT rt.name
2159: INTO l_rec_name
2160: FROM ar_receivables_trx rt
2161: WHERE rt.receivables_trx_id = arp_global.G_CB_RT_ID;
2162:
2163:
2164: -- Bug 686025/694300: instead of calling GET_SEQ_NAME, use