DBA Data[Home] [Help]

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 298: FROM ar_adjustments_all h,

294: hcas.cust_account_id
295: INTO p_org_id,
296: p_rec_atrribute_id,
297: p_customer_id
298: FROM ar_adjustments_all h,
299: ar_cash_receipts_all acr,
300: hz_cust_site_uses_all hcsu,
301: hz_cust_acct_sites_all hcas
302: WHERE h.adjustment_id = p_transcation_id

Line 314: FROM ar_adjustments_all h,

310: hcas.cust_account_id
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

Line 329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);

325: p_error_code := c_FAILURE;
326: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
327: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
328: p_error_desc := fnd_message.get;
329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);
330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);
331: END;
332:
333: trace(C_PROC_LEVEL, l_procedure_name, 'p_org_id='||p_org_id);

Line 330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);

326: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
327: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
328: p_error_desc := fnd_message.get;
329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);
330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);
331: END;
332:
333: trace(C_PROC_LEVEL, l_procedure_name, 'p_org_id='||p_org_id);
334: trace(C_PROC_LEVEL, l_procedure_name, 'p_customer_id='||p_customer_id);