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_RCV_DELIVER_RTR_PKG dependencies on FND_FILE

Line 215: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));

211:
212: -- this is to identify the path in SQL TRACE file if any problem occured
213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
214:
215: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
218:
219: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

Line 348: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );

344: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
345: (p_transaction_id => r_trx.transaction_id);
346:
347: if lv_debug ='Y' then
348: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );
349: end if;
350:
351: /*Step 1 : Call Individual Tax Entries As this should happen in any case if
352: Recoverable Taxes other than Excise Exist */

Line 437: fnd_file.put_line( fnd_file.log, ' 1.3 ln_modvat_amount ='|| ln_modvat_amount

433: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
434: END IF;
435:
436: if lv_debug='Y' THEN
437: fnd_file.put_line( fnd_file.log, ' 1.3 ln_modvat_amount ='|| ln_modvat_amount
438: ||', ln_non_modvat_amount =' || ln_non_modvat_amount
439: ||', ln_other_modvat_amount ='|| ln_other_modvat_amount
440: ||', ln_total ='|| ln_total);
441: end if;

Line 692: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

688: EXCEPTION
689: WHEN OTHERS THEN
690: p_process_status := 'E';
691: p_process_message := 'DELIVER_RTR_PKG.process_transaction:' || sqlerrm;
692: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
693: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 34 */
694: return;
695: END process_transaction;
696:

Line 937: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

933: EXCEPTION
934: WHEN OTHERS THEN
935: p_process_status := 'E';
936: p_process_message := 'DELIVER_RTR_PKG.deliver_rtr_reco_nonexcise:' || sqlerrm;
937: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
938: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 20 */
939: return;
940: END deliver_rtr_reco_nonexcise;
941:

Line 1095: fnd_file.put_line( fnd_file.log, 'tax breakup tax_rec.tax_amount :'|| tax_rec.tax_amount||' tax_rec.rounding_factor:'||tax_rec.rounding_factor);

1091: ln_tax_amount := 0;
1092:
1093: IF tax_rec.tax_type IN (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other,jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess)
1094: THEN
1095: fnd_file.put_line( fnd_file.log, 'tax breakup tax_rec.tax_amount :'|| tax_rec.tax_amount||' tax_rec.rounding_factor:'||tax_rec.rounding_factor);
1096: ln_tax_amount := Round(tax_rec.tax_amount,Nvl(tax_rec.rounding_factor,0)); -- not to be rounded
1097: fnd_file.put_line( fnd_file.log, ' tax breakup ln_tax_amount :'|| ln_tax_amount);
1098: ELSE
1099: ln_tax_amount := tax_rec.tax_amount;

Line 1097: fnd_file.put_line( fnd_file.log, ' tax breakup ln_tax_amount :'|| ln_tax_amount);

1093: IF tax_rec.tax_type IN (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other,jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess)
1094: THEN
1095: fnd_file.put_line( fnd_file.log, 'tax breakup tax_rec.tax_amount :'|| tax_rec.tax_amount||' tax_rec.rounding_factor:'||tax_rec.rounding_factor);
1096: ln_tax_amount := Round(tax_rec.tax_amount,Nvl(tax_rec.rounding_factor,0)); -- not to be rounded
1097: fnd_file.put_line( fnd_file.log, ' tax breakup ln_tax_amount :'|| ln_tax_amount);
1098: ELSE
1099: ln_tax_amount := tax_rec.tax_amount;
1100: END IF;
1101: /* Added for bug #13494816 *//* End*/

Line 1217: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: p_process_status := 'E';
1216: p_process_message := 'DELIVER_RTR_PKG.get_tax_amount_breakup:' || sqlerrm;
1217: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1218: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 16 */
1219: return;
1220:
1221: END get_tax_amount_breakup;

Line 1341: fnd_file.put_line(fnd_file.log, 'OPM Costing. ln_apportion_factor:'||ln_apportion_factor

1337: ln_opm_costing_amount := p_costing_amount * ln_apportion_factor ;
1338:
1339: /* End Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch.*/
1340: if lv_debug ='Y' then
1341: fnd_file.put_line(fnd_file.log, 'OPM Costing. ln_apportion_factor:'||ln_apportion_factor
1342: ||', ln_opm_costing_amount:'||ln_opm_costing_amount
1343: ||', pCostAmt:'||p_costing_amount
1344: ||', Qty:'||ln_rcv_quantity
1345: ||', FinalCostAmt:'||ln_costing_amount

Line 1447: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: p_process_status := 'E';
1446: p_process_message := 'DELIVER_RTR_PKG.opm_costing:' || sqlerrm;
1447: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1448: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1449: return;
1450: END opm_costing;
1451:

Line 1663: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

1659: EXCEPTION
1660: WHEN OTHERS THEN
1661: p_process_status := 'E';
1662: p_process_message := 'DELIVER_RTR_PKG.expense_accounting:' || sqlerrm ;
1663: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1664: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 17 */
1665:
1666: END expense_accounting;
1667:

Line 1774: fnd_file.put_line( fnd_file.log, ' 3.3 '|| ' p_unit_of_measure -> ' || p_unit_of_measure || ' lv_uom_code -> ' || lv_uom_code);

1770: );
1771: end if;
1772:
1773: if lv_debug='Y' THEN
1774: fnd_file.put_line( fnd_file.log, ' 3.3 '|| ' p_unit_of_measure -> ' || p_unit_of_measure || ' lv_uom_code -> ' || lv_uom_code);
1775: end if;
1776:
1777: if (p_transaction_type ='CORRECT' AND p_parent_transaction_type = 'DELIVER') or
1778: p_transaction_type = 'DELIVER' then

Line 1867: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

1863: exception
1864: WHEN OTHERS THEN
1865: p_process_status := 'E';
1866: p_process_message := 'DELIVER_RTR_PKG.average_costing:' || sqlerrm ;
1867: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1868: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 12 */
1869:
1870: END average_costing;
1871:

Line 2069: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: p_process_status := 'E';
2068: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
2069: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2070: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
2071:
2072: END standard_costing;
2073:

Line 2116: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2112: EXCEPTION
2113: WHEN OTHERS THEN
2114: p_process_status := 'E';
2115: p_process_message := 'DELIVER_RTR_PKG.receiving_account:' || SQLERRM;
2116: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2117: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 5 */
2118: return null;
2119:
2120: END receiving_account;

Line 2181: fnd_file.put_line( fnd_file.log, '4_2.1 costing group' || ln_costing_group_id);

2177: fetch c_material_account_cg into ln_material_account_id;
2178: close c_material_account_cg;
2179:
2180: if lv_debug='Y' THEN
2181: fnd_file.put_line( fnd_file.log, '4_2.1 costing group' || ln_costing_group_id);
2182: fnd_file.put_line( fnd_file.log, '4_2.2 material acct of costing group' || ln_material_account_id);
2183: end if;
2184:
2185: end if;

Line 2182: fnd_file.put_line( fnd_file.log, '4_2.2 material acct of costing group' || ln_material_account_id);

2178: close c_material_account_cg;
2179:
2180: if lv_debug='Y' THEN
2181: fnd_file.put_line( fnd_file.log, '4_2.1 costing group' || ln_costing_group_id);
2182: fnd_file.put_line( fnd_file.log, '4_2.2 material acct of costing group' || ln_material_account_id);
2183: end if;
2184:
2185: end if;
2186:

Line 2214: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2210:
2211: WHEN OTHERS THEN
2212: p_process_status :='E';
2213: p_process_message :='DELIVER_RTR_PKG.material_account:' || SQLERRM;
2214: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2215: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 8 */
2216: return null;
2217:
2218: END material_account ;

Line 2331: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2327: EXCEPTION
2328: WHEN OTHERS THEN
2329: p_process_status := 'E';
2330: p_process_message := 'DELIVER_RTR_PKG.expense_account:' || SQLERRM;
2331: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2332: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 10 */
2333: return null;
2334: END expense_account;
2335:

Line 2379: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: p_process_status := 'E';
2378: p_process_message := 'DELIVER_RTR_PKG.ppv_account:' || SQLERRM ;
2379: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2380: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */
2381: return null;
2382: END ppv_account;
2383:

Line 2593: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);

2589: exception
2590: when others then
2591: p_process_status := 'E';
2592: p_process_message := 'DELIVER_RTR_PKG.include_cenvat_in_costing:' || SQLERRM ;
2593: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2594: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2595: return null;
2596: end include_cenvat_in_costing;
2597: /*procedures added for bug 10335708*/