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 2238: FND_FILE.put_line(FND_FILE.LOG, 'Start procedure - Ja_In_Bulk_PO_Tax_Insert');

2234: v_total := 0;
2235: v_processed := 0;
2236: audsid := userenv('SESSIONID');
2237:
2238: FND_FILE.put_line(FND_FILE.LOG, 'Start procedure - Ja_In_Bulk_PO_Tax_Insert');
2239: -- this cursor picks up the PO Shipment lines from the temporary table but does not pick up such shipment lines
2240: -- which have error_flag set to 'Y' for any of it's Shipment lines.
2241:
2242: /* Added by Ramananda for removal of SQL LITERALs */

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

2255: DBMS_SUPPORT.START_TRACE_IN_SESSION( sid, serial, waits => false, binds=>true);
2256: */
2257: /*
2258: ||Opened the existing cursor to get the database name
2259: || and called fnd_file.put_line to register the info
2260: || also changed the dbms_support.start and stop trace to execute immediate alter session code
2261: */
2262: OPEN get_dbname;
2263: FETCH get_dbname INTO v_name1;

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

2262: OPEN get_dbname;
2263: FETCH get_dbname INTO v_name1;
2264: CLOSE get_dbname;
2265:
2266: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||spid||'.trc');
2267: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
2268: END IF;
2269:
2270: FOR c_rec IN

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

2352: WHERE ROWID = v_rowid;
2353:
2354: COMMIT;
2355:
2356: FND_FILE.put_line(FND_FILE.LOG, v_error_mesg || ' : FOR line_location_id = ' || v_line_location_id || ', Quantity = ' || v_qty);
2357: END;
2358:
2359: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
2360:

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

2355:
2356: FND_FILE.put_line(FND_FILE.LOG, v_error_mesg || ' : FOR line_location_id = ' || v_line_location_id || ', Quantity = ' || v_qty);
2357: END;
2358:
2359: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
2360:
2361: END LOOP; -- CURSOR FOR
2362:
2363: 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 2363: 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.');

2359: FND_FILE.put_line(FND_FILE.LOG, ' Processed line_location_id = ' || v_line_location_id);
2360:
2361: END LOOP; -- CURSOR FOR
2362:
2363: 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.');
2364:
2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

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

3229: v_line_uom_code := p_line_uom_code;
3230: v_debug := jai_constants.no;
3231:
3232: IF v_debug = 'Y' THEN
3233: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
3234: fnd_file.put_line(fnd_file.log,
3235: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
3236: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
3237: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||

Line 3234: fnd_file.put_line(fnd_file.log,

3230: v_debug := jai_constants.no;
3231:
3232: IF v_debug = 'Y' THEN
3233: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
3234: fnd_file.put_line(fnd_file.log,
3235: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
3236: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
3237: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
3238: ' p_line_focus_id -> '||p_line_focus_id||

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

3236: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
3237: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
3238: ' p_line_focus_id -> '||p_line_focus_id||
3239: ' p_line_quantity -> '||p_line_quantity|| ' p_base_value -> '||p_base_value);
3240: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||
3241: ' p_assessable_value -> '||p_assessable_value|| ' p_item_id -> '||p_item_id||
3242: ' p_conv_rate -> '||p_conv_rate||
3243: ' p_po_curr -> '||p_po_curr|| ' p_func_curr -> '||p_func_curr
3244: );

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

4210: v_line_uom_code := p_line_uom_code;
4211: v_debug := jai_constants.no;
4212:
4213: IF v_debug = 'Y' THEN
4214: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4215: fnd_file.put_line(fnd_file.log,
4216: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
4217: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4218: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||

Line 4215: fnd_file.put_line(fnd_file.log,

4211: v_debug := jai_constants.no;
4212:
4213: IF v_debug = 'Y' THEN
4214: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4215: fnd_file.put_line(fnd_file.log,
4216: -- INSERT INTO mc_debug values ( mc_debug_s.nextval,
4217: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4218: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
4219: ' p_line_focus_id -> '||p_line_focus_id||

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

4217: ' p_type -> '||p_type|| ' p_header_id -> '||p_header_id||
4218: ' P_line_id -> '||P_line_id|| ' p_line_location_id -> '||p_line_location_id||
4219: ' p_line_focus_id -> '||p_line_focus_id||
4220: ' p_line_quantity -> '||p_line_quantity|| ' p_base_value -> '||p_base_value);
4221: fnd_file.put_line(fnd_file.log, ' p_line_uom_code -> '||p_line_uom_code|| ' p_tax_amount -> '||p_tax_amount||
4222: ' p_assessable_value -> '||p_assessable_value|| ' p_item_id -> '||p_item_id||
4223: ' p_conv_rate -> '||p_conv_rate||
4224: ' p_po_curr -> '||p_po_curr|| ' p_func_curr -> '||p_func_curr
4225: );

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

4894: END IF;
4895: --======================================================================================================
4896:
4897: IF v_debug = 'Y' THEN
4898: fnd_file.put_line( fnd_file.log,' 1 After calculating the taxes -> '||row_count );
4899: FOR I in 1..row_count LOOP
4900: fnd_file.put_line(fnd_file.log, ' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
4901: ', tax_target_tab -> '||tax_target_tab(i));
4902: END LOOP;

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

4896:
4897: IF v_debug = 'Y' THEN
4898: fnd_file.put_line( fnd_file.log,' 1 After calculating the taxes -> '||row_count );
4899: FOR I in 1..row_count LOOP
4900: fnd_file.put_line(fnd_file.log, ' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
4901: ', tax_target_tab -> '||tax_target_tab(i));
4902: END LOOP;
4903:
4904: END IF;

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

4987:
4988: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN
4989:
4990: IF v_debug = 'Y' THEN
4991: fnd_file.put_line( fnd_file.log, '3 Before Updating the table');
4992: END IF;
4993:
4994: FOR i in 1..row_count LOOP
4995:

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

5010: END IF;
5011: --end, cbabu for Bug# 2659815
5012:
5013: IF v_debug = 'Y' THEN
5014: fnd_file.put_line( fnd_file.log,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
5015: ', tax_target_tab -> '||tax_target_tab(i));
5016: END IF;
5017:
5018: --Bgowrava for Bug#5877782 Added standard Who columns

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

5083: END IF;
5084: --end, cbabu for Bug# 2659815
5085:
5086: IF v_debug = 'Y' THEN
5087: FND_FILE.put_line(FND_FILE.LOG,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
5088: ', tax_target_tab -> '||tax_target_tab(i));
5089: END IF;
5090:
5091: UPDATE jai_cmn_document_taxes

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

5341: OPEN Fetch_Focus_Id_Cur;
5342: FETCH Fetch_Focus_Id_Cur INTO v_seq_val;
5343: CLOSE Fetch_Focus_Id_Cur;
5344:
5345: FND_FILE.put_line( FND_FILE.log, 'v_seq_val->'||v_seq_val);
5346:
5347: FOR rec1 in Fetch_Jain_Line_Cur LOOP
5348:
5349: INSERT INTO JAI_PO_LINE_LOCATIONS (

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

5362:
5363: END LOOP;
5364: END IF;
5365:
5366: FND_FILE.put_line( FND_FILE.log, 'bef taxes');
5367: FOR rec2 in Fetch_Jain_Line_Tax_Cur LOOP
5368: FND_FILE.put_line( FND_FILE.log, 'rec2.tax_id->'||rec2.tax_id);
5369:
5370:

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

5364: END IF;
5365:
5366: FND_FILE.put_line( FND_FILE.log, 'bef taxes');
5367: FOR rec2 in Fetch_Jain_Line_Tax_Cur LOOP
5368: FND_FILE.put_line( FND_FILE.log, 'rec2.tax_id->'||rec2.tax_id);
5369:
5370:
5371: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
5372:

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

6116: FETCH Fetch_Org_Id_Cur INTO lv_org_id;
6117: CLOSE fetch_Org_Id_Cur;
6118:
6119: /*
6120: fnd_file.put_line(fnd_file.log,' v_type_lookup_code ' || v_type_lookup_code ||
6121: ' v_quot_class_code ' || v_quot_class_code||
6122: 'v_vendor_id ' || v_vendor_id||
6123: 'v_vendor_site_id' ||v_vendor_site_id ||
6124: 'v_curr ' || v_curr||