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_CASH_RECEIPTS_ALL

Line 204: l_rect_type ar_cash_receipts_all.type%TYPE;

200: )
201: IS
202: l_procedure_name VARCHAR2(100) :='.get_ar_receipt_details';
203: l_project_id pa_projects.project_id%TYPE;
204: l_rect_type ar_cash_receipts_all.type%TYPE;
205: BEGIN
206: l_procedure_name := g_path_name || l_procedure_name;
207:
208: p_error_code := c_SUCCESS;

Line 220: FROM ar_cash_receipts_all

216: BEGIN
217:
218: SELECT type
219: INTO l_rect_type
220: FROM ar_cash_receipts_all
221: WHERE cash_receipt_id = p_transcation_id;
222:
223: --Misc receipts will not have cust info, so bypassing
224: --this select for misc receipts

Line 232: FROM ar_cash_receipts_all h,

228: hcas.cust_account_id
229: INTO p_org_id,
230: p_rec_atrribute_id,
231: p_customer_id
232: FROM ar_cash_receipts_all h,
233: hz_cust_site_uses_all hcsu,
234: hz_cust_acct_sites_all hcas
235: WHERE h.cash_receipt_id = p_transcation_id
236: AND hcsu.site_use_id = h.customer_site_use_id

Line 245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);

241: p_error_code := c_FAILURE;
242: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
243: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
244: p_error_desc := fnd_message.get;
245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);
246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);
247:
248: END;
249: p_org_id := -1;

Line 246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);

242: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
243: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
244: p_error_desc := fnd_message.get;
245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);
246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);
247:
248: END;
249: p_org_id := -1;
250:

Line 299: ar_cash_receipts_all acr,

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
303: AND h.associated_cash_receipt_id = acr.cash_receipt_id