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.FV_SLA_AR_PROCESSING_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 462: l_cash_receipt_id ar_receivable_applications_all.cash_receipt_id%TYPE;

458: l_procedure_name VARCHAR2(100) :='.get_receipt_info_for_pr';
459: l_org_id NUMBER;
460: l_rec_atrribute_id NUMBER;
461: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;
462: l_cash_receipt_id ar_receivable_applications_all.cash_receipt_id%TYPE;
463: l_payment_set_id ar_receivable_applications_all.payment_set_id%TYPE;
464: l_stmt VARCHAR2(2000);
465: BEGIN
466: l_procedure_name := g_path_name || l_procedure_name;

Line 463: l_payment_set_id ar_receivable_applications_all.payment_set_id%TYPE;

459: l_org_id NUMBER;
460: l_rec_atrribute_id NUMBER;
461: l_rec_attribute_type fv_ar_acc_category_map_hdr.receivable_attribute_type%TYPE;
462: l_cash_receipt_id ar_receivable_applications_all.cash_receipt_id%TYPE;
463: l_payment_set_id ar_receivable_applications_all.payment_set_id%TYPE;
464: l_stmt VARCHAR2(2000);
465: BEGIN
466: l_procedure_name := g_path_name || l_procedure_name;
467:

Line 482: FROM ar_receivable_applications_all ara

478: SELECT cash_receipt_id,
479: payment_set_id
480: INTO l_cash_receipt_id,
481: l_payment_set_id
482: FROM ar_receivable_applications_all ara
483: WHERE ara.receivable_application_id = p_transcation_id;
484: trace(C_STATE_LEVEL, l_procedure_name, 'l_cash_receipt_id='||l_cash_receipt_id);
485: trace(C_STATE_LEVEL, l_procedure_name, 'l_payment_set_id='||l_payment_set_id);
486: EXCEPTION

Line 492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);

488: p_error_code := c_FAILURE;
489: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
490: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
491: p_error_desc := fnd_message.get;
492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);
493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);
494: END;
495:
496: IF (p_error_code = c_SUCCESS) THEN

Line 493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);

489: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
490: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
491: p_error_desc := fnd_message.get;
492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);
493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);
494: END;
495:
496: IF (p_error_code = c_SUCCESS) THEN
497: get_ar_receipt_details