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

Line 2959: FND_FILE.put_line(FND_FILE.LOG, 'Start procedure - Ja_In_Bulk_PO_Tax_Insert');

2955: v_total := 0;
2956: v_processed := 0;
2957: audsid := userenv('SESSIONID');
2958:
2959: FND_FILE.put_line(FND_FILE.LOG, 'Start procedure - Ja_In_Bulk_PO_Tax_Insert');
2960: -- this cursor picks up the PO Shipment lines from the temporary table but does not pick up such shipment lines
2961: -- which have error_flag set to 'Y' for any of it's Shipment lines.
2962:
2963: /* Added by Ramananda for removal of SQL LITERALs */

Line 2980: || and called fnd_file.put_line to register the info

2976: DBMS_SUPPORT.START_TRACE_IN_SESSION( sid, serial, waits => false, binds=>true);
2977: */
2978: /*
2979: ||Opened the existing cursor to get the database name
2980: || and called fnd_file.put_line to register the info
2981: || also changed the dbms_support.start and stop trace to execute immediate alter session code
2982: */
2983: OPEN get_dbname;
2984: FETCH get_dbname INTO v_name1;

Line 2987: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||spid||'.trc');

2983: OPEN get_dbname;
2984: FETCH get_dbname INTO v_name1;
2985: CLOSE get_dbname;
2986:
2987: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||spid||'.trc');
2988: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
2989: END IF;
2990:
2991: FOR c_rec IN

Line 3077: FND_FILE.put_line(FND_FILE.LOG, v_error_mesg || ' : FOR line_location_id = ' || v_line_location_id || ', Quantity = ' || v_qty);

3073: WHERE ROWID = v_rowid;
3074:
3075: COMMIT;
3076:
3077: FND_FILE.put_line(FND_FILE.LOG, v_error_mesg || ' : FOR line_location_id = ' || v_line_location_id || ', Quantity = ' || v_qty);
3078: END;
3079:
3080: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
3081:

Line 3080: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);

3076:
3077: FND_FILE.put_line(FND_FILE.LOG, v_error_mesg || ' : FOR line_location_id = ' || v_line_location_id || ', Quantity = ' || v_qty);
3078: END;
3079:
3080: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
3081:
3082: END LOOP; -- CURSOR FOR
3083:
3084: FND_FILE.put_line(FND_FILE.LOG, 'Tax Defaultation is SUCCESSFUL. END PROCEDURE - JA_IN_BULK_PO_QUOT_TAXES - '||v_processed||'/'||v_total||' records processed.');

Line 3084: FND_FILE.put_line(FND_FILE.LOG, 'Tax Defaultation is SUCCESSFUL. END PROCEDURE - JA_IN_BULK_PO_QUOT_TAXES - '||v_processed||'/'||v_total||' records processed.');

3080: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
3081:
3082: END LOOP; -- CURSOR FOR
3083:
3084: FND_FILE.put_line(FND_FILE.LOG, 'Tax Defaultation is SUCCESSFUL. END PROCEDURE - JA_IN_BULK_PO_QUOT_TAXES - '||v_processed||'/'||v_total||' records processed.');
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

Line 4033: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );

4029: v_line_uom_code := p_line_uom_code;
4030: v_debug := jai_constants.no;
4031:
4032: IF v_debug = 'Y' THEN
4033: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4034: fnd_file.put_line(fnd_file.log,
4035: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
4036: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4037: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||

Line 4034: fnd_file.put_line(fnd_file.log,

4030: v_debug := jai_constants.no;
4031:
4032: IF v_debug = 'Y' THEN
4033: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4034: fnd_file.put_line(fnd_file.log,
4035: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
4036: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4037: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
4038: ' p_line_focus_id -> '||p_line_focus_id||

Line 4040: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||

4036: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4037: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
4038: ' p_line_focus_id -> '||p_line_focus_id||
4039: ' p_line_quantity -> '||p_line_quantity|| ' p_base_value -> '||p_base_value);
4040: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||
4041: ' p_assessable_value -> '||p_assessable_value||
4042: /* for bug 16013918 by anupgupt
4043: ' pn_gst_assessable_value -> '||pn_gst_assessable_value||
4044: */

Line 5582: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );

5578: v_line_uom_code := p_line_uom_code;
5579: v_debug := jai_constants.no;
5580:
5581: IF v_debug = 'Y' THEN
5582: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
5583: fnd_file.put_line(fnd_file.log,
5584: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
5585: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
5586: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||

Line 5583: fnd_file.put_line(fnd_file.log,

5579: v_debug := jai_constants.no;
5580:
5581: IF v_debug = 'Y' THEN
5582: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
5583: fnd_file.put_line(fnd_file.log,
5584: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
5585: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
5586: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
5587: ' p_line_focus_id -> '||p_line_focus_id||

Line 5589: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||

5585: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
5586: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
5587: ' p_line_focus_id -> '||p_line_focus_id||
5588: ' p_line_quantity -> '||p_line_quantity|| ' p_base_value -> '||p_base_value);
5589: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||
5590: ' p_assessable_value -> '||p_assessable_value||
5591: /* for bug 16013918 by anupgupt
5592: ' pn_gst_assessable_value -> '||pn_gst_assessable_value||
5593: */

Line 6287: fnd_file.put_line( fnd_file.log,' 1 After calculating the taxes -> '||row_count );

6283: END IF;
6284: --======================================================================================================
6285:
6286: IF v_debug = 'Y' THEN
6287: fnd_file.put_line( fnd_file.log,' 1 After calculating the taxes -> '||row_count );
6288: FOR I in 1..row_count LOOP
6289: fnd_file.put_line(fnd_file.log, ' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6290: ', tax_target_tab -> '||tax_target_tab(i));
6291: END LOOP;

Line 6289: fnd_file.put_line(fnd_file.log, ' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||

6285:
6286: IF v_debug = 'Y' THEN
6287: fnd_file.put_line( fnd_file.log,' 1 After calculating the taxes -> '||row_count );
6288: FOR I in 1..row_count LOOP
6289: fnd_file.put_line(fnd_file.log, ' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6290: ', tax_target_tab -> '||tax_target_tab(i));
6291: END LOOP;
6292:
6293: END IF;

Line 6380: fnd_file.put_line( fnd_file.log, '3 Before Updating the table');

6376:
6377: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN
6378:
6379: IF v_debug = 'Y' THEN
6380: fnd_file.put_line( fnd_file.log, '3 Before Updating the table');
6381: END IF;
6382:
6383: FOR i in 1..row_count LOOP
6384:

Line 6403: fnd_file.put_line( fnd_file.log,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||

6399: END IF;
6400: --end, cbabu for Bug# 2659815
6401:
6402: IF v_debug = 'Y' THEN
6403: fnd_file.put_line( fnd_file.log,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6404: ', tax_target_tab -> '||tax_target_tab(i));
6405: END IF;
6406:
6407: --Bgowrava for Bug#5877782 Added standard Who columns

Line 6476: FND_FILE.put_line(FND_FILE.LOG,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||

6472: END IF;
6473: --end, cbabu for Bug# 2659815
6474:
6475: IF v_debug = 'Y' THEN
6476: FND_FILE.put_line(FND_FILE.LOG,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6477: ', tax_target_tab -> '||tax_target_tab(i));
6478: END IF;
6479:
6480: UPDATE jai_cmn_document_taxes

Line 6734: FND_FILE.put_line( FND_FILE.log, 'v_seq_val->'||v_seq_val);

6730: OPEN Fetch_Focus_Id_Cur;
6731: FETCH Fetch_Focus_Id_Cur INTO v_seq_val;
6732: CLOSE Fetch_Focus_Id_Cur;
6733:
6734: FND_FILE.put_line( FND_FILE.log, 'v_seq_val->'||v_seq_val);
6735:
6736: FOR rec1 in Fetch_Jain_Line_Cur LOOP
6737:
6738: INSERT INTO JAI_PO_LINE_LOCATIONS (

Line 6755: FND_FILE.put_line( FND_FILE.log, 'bef taxes');

6751:
6752: END LOOP;
6753: END IF;
6754:
6755: FND_FILE.put_line( FND_FILE.log, 'bef taxes');
6756: FOR rec2 in Fetch_Jain_Line_Tax_Cur LOOP
6757: FND_FILE.put_line( FND_FILE.log, 'rec2.tax_id->'||rec2.tax_id);
6758:
6759:

Line 6757: FND_FILE.put_line( FND_FILE.log, 'rec2.tax_id->'||rec2.tax_id);

6753: END IF;
6754:
6755: FND_FILE.put_line( FND_FILE.log, 'bef taxes');
6756: FOR rec2 in Fetch_Jain_Line_Tax_Cur LOOP
6757: FND_FILE.put_line( FND_FILE.log, 'rec2.tax_id->'||rec2.tax_id);
6758:
6759:
6760: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6761:

Line 7538: fnd_file.put_line(fnd_file.log,' v_type_lookup_code ' || v_type_lookup_code ||

7534: FETCH Fetch_Org_Id_Cur INTO lv_org_id;
7535: CLOSE fetch_Org_Id_Cur;
7536:
7537: /*
7538: fnd_file.put_line(fnd_file.log,' v_type_lookup_code ' || v_type_lookup_code ||
7539: ' v_quot_class_code ' || v_quot_class_code||
7540: 'v_vendor_id ' || v_vendor_id||
7541: 'v_vendor_site_id' ||v_vendor_site_id ||
7542: 'v_curr ' || v_curr||