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.ARP_PROCESS_LOCKBOX dependencies on FND_FILE

Line 1987: Un comment lines calling fnd_file package and that will write to a file.

1983: /*----------------------------------------------------------------------------
1984: This procedure calls arp_util.debug for the string passed.
1985: Till arp_util.debug is changed to provide an option to write to a
1986: file, we can use this procedure to write to a file at the time of testing.
1987: Un comment lines calling fnd_file package and that will write to a file.
1988: Please change the directory name so that it does not raise any exception.
1989: ----------------------------------------------------------------------------*/
1990: PROCEDURE debug1(str IN VARCHAR2) IS
1991: -- myfile utl_file.file_type;

Line 2196: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()+');

2192: format_amount8 varchar2(2);
2193:
2194: BEGIN
2195: debug1('arp_process_lockbox.validate_llca_interface_data()+');
2196: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()+');
2197: p_trans_req_id := to_number(p_trans_request_id);
2198:
2199: UPDATE ar_pmts_interface_line_details
2200: SET status = 'AR_PLB_NEW_RECORD'

Line 2890: fnd_file.put_line(fnd_file.LOG, 'Apply_to' || cur_var2.apply_to);

2886: FROM ar_pmts_interface_lines_gt
2887: WHERE customer_trx_id = cur_var1.customer_trx_id
2888: AND transmission_request_id = p_trans_req_id
2889: AND apply_to = cur_var2.apply_to;
2890: fnd_file.put_line(fnd_file.LOG, 'Apply_to' || cur_var2.apply_to);
2891: fnd_file.put_line(fnd_file.log, 'Line_Amt '||l_line_amount_remaining);
2892: fnd_file.put_line(fnd_file.log, 'Tax_Amt '||l_line_tax_remaining);
2893: l_calc_per_line := ( Nvl(l_line_amount_remaining,0)
2894: / ( Nvl(l_line_amount_remaining,0)

Line 2891: fnd_file.put_line(fnd_file.log, 'Line_Amt '||l_line_amount_remaining);

2887: WHERE customer_trx_id = cur_var1.customer_trx_id
2888: AND transmission_request_id = p_trans_req_id
2889: AND apply_to = cur_var2.apply_to;
2890: fnd_file.put_line(fnd_file.LOG, 'Apply_to' || cur_var2.apply_to);
2891: fnd_file.put_line(fnd_file.log, 'Line_Amt '||l_line_amount_remaining);
2892: fnd_file.put_line(fnd_file.log, 'Tax_Amt '||l_line_tax_remaining);
2893: l_calc_per_line := ( Nvl(l_line_amount_remaining,0)
2894: / ( Nvl(l_line_amount_remaining,0)
2895: + Nvl(l_line_tax_remaining,0)));

Line 2892: fnd_file.put_line(fnd_file.log, 'Tax_Amt '||l_line_tax_remaining);

2888: AND transmission_request_id = p_trans_req_id
2889: AND apply_to = cur_var2.apply_to;
2890: fnd_file.put_line(fnd_file.LOG, 'Apply_to' || cur_var2.apply_to);
2891: fnd_file.put_line(fnd_file.log, 'Line_Amt '||l_line_amount_remaining);
2892: fnd_file.put_line(fnd_file.log, 'Tax_Amt '||l_line_tax_remaining);
2893: l_calc_per_line := ( Nvl(l_line_amount_remaining,0)
2894: / ( Nvl(l_line_amount_remaining,0)
2895: + Nvl(l_line_tax_remaining,0)));
2896:

Line 3284: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()-');

3280: OR interface1.invoice7_status = 'AR_PLB_INVALID_LINE_DET'
3281: OR interface1.invoice8_status = 'AR_PLB_INVALID_LINE_DET'))
3282: AND transmission_request_id = p_trans_req_id;
3283: END IF;
3284: fnd_file.put_line(fnd_file.log, 'arp_process_lockbox.validate_llca_interface_data()-');
3285: EXCEPTION
3286: WHEN OTHERS THEN
3287: p_return_status := 'E';
3288: debug1('Error '|| SQLERRM);

Line 3290: fnd_file.put_line(fnd_file.log, 'Error '|| SQLERRM);

3286: WHEN OTHERS THEN
3287: p_return_status := 'E';
3288: debug1('Error '|| SQLERRM);
3289: debug1('validate_llca_interface_data : p_return_status ' || p_return_status);
3290: fnd_file.put_line(fnd_file.log, 'Error '|| SQLERRM);
3291: RAISE;
3292: END validate_llca_interface_data;
3293: --
3294: FUNCTION get_format_amount (

Line 4148: --fnd_file.put_line(FND_FILE.LOG, 'Stmt : ' || g_cursor_string);

4144: debug1('Now Opening the cursor..');
4145: g_cursor_name := dbms_sql.open_cursor;
4146: debug1('Opened the cursor.. Now Parsing cursor..');
4147: --debug1('Stmt :' || g_cursor_string);
4148: --fnd_file.put_line(FND_FILE.LOG, 'Stmt : ' || g_cursor_string);
4149: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);
4150: debug1('Parsed cursor.');
4151: g_total_maching_options := g_total_maching_options + 1;
4152: -- Insert into PL/SQL table here values of matching_option, cursor_name