DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on FND_FILE

Line 184: 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'));

180:
181: -- this is to identify the path in SQL TRACE file if any problem occured
182: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
183:
184: 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'));
185:
186: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
187:
188: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

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

267: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
268: (p_transaction_id => r_trx.transaction_id);
269:
270: if lv_debug ='Y' then
271: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );
272: end if;
273:
274: /*Step 1 : Call Individual Tax Entries As this should happen in any case if
275: Recoverable Taxes other than Excise Exist */

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

356: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
357: END IF;
358:
359: if lv_debug='Y' THEN
360: fnd_file.put_line( fnd_file.log, ' 1.3 ln_modvat_amount ='|| ln_modvat_amount
361: ||', ln_non_modvat_amount =' || ln_non_modvat_amount
362: ||', ln_other_modvat_amount ='|| ln_other_modvat_amount
363: ||', ln_total ='|| ln_total);
364: end if;

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

601: EXCEPTION
602: WHEN OTHERS THEN
603: p_process_status := 'E';
604: p_process_message := 'DELIVER_RTR_PKG.process_transaction:' || sqlerrm;
605: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
606: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 34 */
607: return;
608: END process_transaction;
609:

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

838: EXCEPTION
839: WHEN OTHERS THEN
840: p_process_status := 'E';
841: p_process_message := 'DELIVER_RTR_PKG.deliver_rtr_reco_nonexcise:' || sqlerrm;
842: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
843: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 20 */
844: return;
845: END deliver_rtr_reco_nonexcise;
846:

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

1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: p_process_status := 'E';
1066: p_process_message := 'DELIVER_RTR_PKG.get_tax_amount_breakup:' || sqlerrm;
1067: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1068: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 16 */
1069: return;
1070:
1071: END get_tax_amount_breakup;

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

1187: ln_opm_costing_amount := p_costing_amount * ln_apportion_factor ;
1188:
1189: /* End Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch.*/
1190: if lv_debug ='Y' then
1191: fnd_file.put_line(fnd_file.log, 'OPM Costing. ln_apportion_factor:'||ln_apportion_factor
1192: ||', ln_opm_costing_amount:'||ln_opm_costing_amount
1193: ||', pCostAmt:'||p_costing_amount
1194: ||', Qty:'||ln_rcv_quantity
1195: ||', FinalCostAmt:'||ln_costing_amount

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

1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: p_process_status := 'E';
1282: p_process_message := 'DELIVER_RTR_PKG.opm_costing:' || sqlerrm;
1283: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1284: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1285: return;
1286: END opm_costing;
1287:

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

1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: p_process_status := 'E';
1498: p_process_message := 'DELIVER_RTR_PKG.expense_accounting:' || sqlerrm ;
1499: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1500: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 17 */
1501:
1502: END expense_accounting;
1503:

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

1606: );
1607: end if;
1608:
1609: if lv_debug='Y' THEN
1610: fnd_file.put_line( fnd_file.log, ' 3.3 '|| ' p_unit_of_measure -> ' || p_unit_of_measure || ' lv_uom_code -> ' || lv_uom_code);
1611: end if;
1612:
1613: if (p_transaction_type ='CORRECT' AND p_parent_transaction_type = 'DELIVER') or
1614: p_transaction_type = 'DELIVER' then

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

1699: exception
1700: WHEN OTHERS THEN
1701: p_process_status := 'E';
1702: p_process_message := 'DELIVER_RTR_PKG.average_costing:' || sqlerrm ;
1703: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1704: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 12 */
1705:
1706: END average_costing;
1707:

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

1901: EXCEPTION
1902: WHEN OTHERS THEN
1903: p_process_status := 'E';
1904: p_process_message := 'DELIVER_RTR_PKG.standard_costing:' || sqlerrm ;
1905: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
1906: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1907:
1908: END standard_costing;
1909:

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

1948: EXCEPTION
1949: WHEN OTHERS THEN
1950: p_process_status := 'E';
1951: p_process_message := 'DELIVER_RTR_PKG.receiving_account:' || SQLERRM;
1952: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1953: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 5 */
1954: return null;
1955:
1956: END receiving_account;

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

2013: fetch c_material_account_cg into ln_material_account_id;
2014: close c_material_account_cg;
2015:
2016: if lv_debug='Y' THEN
2017: fnd_file.put_line( fnd_file.log, '4_2.1 costing group' || ln_costing_group_id);
2018: fnd_file.put_line( fnd_file.log, '4_2.2 material acct of costing group' || ln_material_account_id);
2019: end if;
2020:
2021: end if;

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

2014: close c_material_account_cg;
2015:
2016: if lv_debug='Y' THEN
2017: fnd_file.put_line( fnd_file.log, '4_2.1 costing group' || ln_costing_group_id);
2018: fnd_file.put_line( fnd_file.log, '4_2.2 material acct of costing group' || ln_material_account_id);
2019: end if;
2020:
2021: end if;
2022:

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

2046:
2047: WHEN OTHERS THEN
2048: p_process_status :='E';
2049: p_process_message :='DELIVER_RTR_PKG.material_account:' || SQLERRM;
2050: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2051: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 8 */
2052: return null;
2053:
2054: END material_account ;

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

2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: p_process_status := 'E';
2166: p_process_message := 'DELIVER_RTR_PKG.expense_account:' || SQLERRM;
2167: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2168: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 10 */
2169: return null;
2170: END expense_account;
2171:

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

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

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

2425: exception
2426: when others then
2427: p_process_status := 'E';
2428: p_process_message := 'DELIVER_RTR_PKG.include_cenvat_in_costing:' || SQLERRM ;
2429: fnd_file.put_line( fnd_file.log, 'Error in '||p_process_message);
2430: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2431: return null;
2432: end include_cenvat_in_costing;
2433: