DBA Data[Home] [Help]

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 164: FROM ra_customer_trx_all h

160: h.bill_to_customer_id
161: INTO p_org_id,
162: p_rec_atrribute_id,
163: p_customer_id
164: FROM ra_customer_trx_all h
165: WHERE customer_trx_id = p_transcation_id;
166: EXCEPTION
167: WHEN OTHERS THEN
168: p_error_code := c_FAILURE;

Line 172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);

168: p_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: p_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);
174: END;
175:
176: trace(C_PROC_LEVEL, l_procedure_name, 'p_org_id='||p_org_id);

Line 173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);

169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: p_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);
174: END;
175:
176: trace(C_PROC_LEVEL, l_procedure_name, 'p_org_id='||p_org_id);
177: trace(C_PROC_LEVEL, l_procedure_name, 'p_customer_id='||p_customer_id);

Line 315: ra_customer_trx_all acr,

311: INTO p_org_id,
312: p_rec_atrribute_id,
313: p_customer_id
314: FROM ar_adjustments_all h,
315: ra_customer_trx_all acr,
316: hz_cust_site_uses_all hcsu,
317: hz_cust_acct_sites_all hcas
318: WHERE h.adjustment_id = p_transcation_id
319: AND h.customer_trx_id = acr.customer_trx_id