DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on FND_FILE

Line 455: fnd_file.put_line(FND_FILE.LOG, ' --- 1');

451: ln_acct_count := 0 ;
452: ln_user_id := fnd_global.user_id;
453:
454: /* Multiple Accounting Entry Checks. Needs to be changed for CENVAT */
455: fnd_file.put_line(FND_FILE.LOG, ' --- 1');
456: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */
457: lv_accounting_date:=p_accounting_date; /*Added by nprashar for FP bug # 9304844*/
458:
459: fnd_file.put_line(FND_FILE.LOG, ' --- 2');

Line 459: fnd_file.put_line(FND_FILE.LOG, ' --- 2');

455: fnd_file.put_line(FND_FILE.LOG, ' --- 1');
456: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */
457: lv_accounting_date:=p_accounting_date; /*Added by nprashar for FP bug # 9304844*/
458:
459: fnd_file.put_line(FND_FILE.LOG, ' --- 2');
460:
461: open c_acct_check(p_transaction_id, p_acct_nature, p_code_combination_id, p_reference_name, p_reference_id);
462: fetch c_acct_check into ln_acct_count;
463: close c_acct_check;

Line 466: fnd_file.put_line( fnd_file.log, '1.0 ln_acct_count -> ' || ln_acct_count ||' p_simulate_flag -> ' || p_simulate_flag );

462: fetch c_acct_check into ln_acct_count;
463: close c_acct_check;
464:
465: if lv_debug ='Y' then
466: fnd_file.put_line( fnd_file.log, '1.0 ln_acct_count -> ' || ln_acct_count ||' p_simulate_flag -> ' || p_simulate_flag );
467: end if;
468:
469: fnd_file.put_line(FND_FILE.LOG, ' --- 3');
470: /**bug#8649408

Line 469: fnd_file.put_line(FND_FILE.LOG, ' --- 3');

465: if lv_debug ='Y' then
466: fnd_file.put_line( fnd_file.log, '1.0 ln_acct_count -> ' || ln_acct_count ||' p_simulate_flag -> ' || p_simulate_flag );
467: end if;
468:
469: fnd_file.put_line(FND_FILE.LOG, ' --- 3');
470: /**bug#8649408
471: if ln_acct_count > 0 and p_simulate_flag ='N' then
472: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2
473: p_process_status := 'X';

Line 500: fnd_file.put_line(FND_FILE.LOG, ' --- 4');

496: ln_set_of_books_id := l_func_curr_det.ledger_id;
497:
498: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
499:
500: fnd_file.put_line(FND_FILE.LOG, ' --- 4');
501:
502: /* added for bug 7007523 */
503: /*If accouting date is in a closed gl period, the startdate of the latest open period is used as accounting date */
504:

Line 535: fnd_file.put_line(FND_FILE.LOG, ' --- 5');

531:
532: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
533: ln_precision := jai_general_pkg.get_currency_precision(r_trx.organization_id);
534:
535: fnd_file.put_line(FND_FILE.LOG, ' --- 5');
536:
537: ln_entered_cr := ROUND(p_entered_cr,ln_precision);
538: ln_entered_dr := ROUND(p_entered_dr,ln_precision);
539:

Line 541: fnd_file.put_line( fnd_file.log, '1.3 ln_entered_cr -> ' || ln_entered_cr ||' ln_entered_dr -> '|| ln_entered_dr );

537: ln_entered_cr := ROUND(p_entered_cr,ln_precision);
538: ln_entered_dr := ROUND(p_entered_dr,ln_precision);
539:
540: if lv_debug ='Y' then
541: fnd_file.put_line( fnd_file.log, '1.3 ln_entered_cr -> ' || ln_entered_cr ||' ln_entered_dr -> '|| ln_entered_dr );
542: end if;
543:
544: fnd_file.put_line(FND_FILE.LOG, ' ---6');
545:

Line 544: fnd_file.put_line(FND_FILE.LOG, ' ---6');

540: if lv_debug ='Y' then
541: fnd_file.put_line( fnd_file.log, '1.3 ln_entered_cr -> ' || ln_entered_cr ||' ln_entered_dr -> '|| ln_entered_dr );
542: end if;
543:
544: fnd_file.put_line(FND_FILE.LOG, ' ---6');
545:
546: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
547: jai_rcv_journal_pkg.insert_row
548: (

Line 580: fnd_file.put_line(FND_FILE.LOG, ' --- 7');

576: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
577: if p_process_status IN ('E', 'X') then
578: goto exit_from_procedure;
579: end if;
580: fnd_file.put_line(FND_FILE.LOG, ' --- 7');
581:
582: /*This is to Ensure that in case of simulate flag ='Y',
583: No Accounting, costing and sub ledger tables are affected */
584:

Line 590: fnd_file.put_line(FND_FILE.LOG, ' --- 8');

586: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
587: goto exit_from_procedure;
588: end if;
589:
590: fnd_file.put_line(FND_FILE.LOG, ' --- 8');
591: /*
592: The Destination is sent from the respective procedures depending on the Accounting/Costing that
593: needs to happen.
594: Following are the p_destination values and its target tables.

Line 609: fnd_file.put_line(FND_FILE.LOG, ' --- 9');

605: if p_destination ='G' then --GL Interface Entries
606:
607: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
608:
609: fnd_file.put_line(FND_FILE.LOG, ' --- 9');
610: gl_entry
611: (
612: p_organization_id => r_trx.organization_id,
613: p_organization_code => lv_organization_code,

Line 648: fnd_file.put_line(FND_FILE.LOG, ' --- 10');

644: elsif p_destination = 'A1' then /*Average Costing Receiving Inspection Account Entry */
645:
646: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
647:
648: fnd_file.put_line(FND_FILE.LOG, ' --- 10');
649:
650: average_costing
651: (
652: p_receiving_account_id => p_code_combination_id,

Line 681: fnd_file.put_line(FND_FILE.LOG, ' --- 11');

677: Amount > 0 Debit Credit Flag
678: Credit Amount N
679: Debit Amount Y
680: */
681: fnd_file.put_line(FND_FILE.LOG, ' --- 11');
682:
683: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
684: if ln_entered_cr <> 0 then
685: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */

Line 693: fnd_file.put_line( fnd_file.log, '1.7 Before the call to mta_entry Procedure ' || 'lv_debit_credit_flag ' || lv_debit_credit_flag);

689: lv_debit_credit_flag :='Y';
690: end if;
691:
692: if lv_debug ='Y' then
693: fnd_file.put_line( fnd_file.log, '1.7 Before the call to mta_entry Procedure ' || 'lv_debit_credit_flag ' || lv_debit_credit_flag);
694: end if;
695:
696: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
697: mta_entry

Line 732: fnd_file.put_line(FND_FILE.LOG, ' --- 12');

728: ELSIF p_destination ='O1' then -- OPM Costing Entry
729:
730: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); -- 20
731:
732: fnd_file.put_line(FND_FILE.LOG, ' --- 12');
733:
734: rcv_transactions_update
735: (
736: p_transaction_id => p_transaction_id,

Line 756: fnd_file.put_line(FND_FILE.LOG, ' --- 13');

752:
753: end if; /*End if for p_destination */
754: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */
755:
756: fnd_file.put_line(FND_FILE.LOG, ' --- 13');
757:
758: /*This check ensures that this is called only in the following transaction types
759: 1. RECEIVE
760: 2. RETURN TO VENDOR

Line 766: fnd_file.put_line( fnd_file.log, '2.0 p_acct_nature - > ' || p_acct_nature );

762: 4. CORRECT TO RTV
763: And this is called from JA_in_RECEIVE_RTR_PKG. */
764:
765: if lv_debug ='Y' then
766: fnd_file.put_line( fnd_file.log, '2.0 p_acct_nature - > ' || p_acct_nature );
767: end if;
768:
769: if p_acct_nature = 'Receiving' then
770:

Line 773: fnd_file.put_line(FND_FILE.LOG, ' --- 14');

769: if p_acct_nature = 'Receiving' then
770:
771: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
772:
773: fnd_file.put_line(FND_FILE.LOG, ' --- 14');
774:
775: rcv_receiving_sub_ledger_entry
776: (
777: p_transaction_id => p_transaction_id,

Line 810: fnd_file.put_line(FND_FILE.LOG, ' --- 15');

806:
807: end if; /* End if for p_acct_nature */
808:
809: << exit_from_procedure >>
810: fnd_file.put_line(FND_FILE.LOG, ' --- 15');
811:
812: if p_process_status = 'Y' then
813: p_process_message := 'The Accounting / Costing Entries are passed successfully ' ;
814: end if;

Line 818: fnd_file.put_line(FND_FILE.LOG, ' --- 16');

814: end if;
815:
816: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath, NULL, 'END'); /* 28 */
817:
818: fnd_file.put_line(FND_FILE.LOG, ' --- 16');
819:
820: exception
821:
822: when others then

Line 824: fnd_file.put_line(FND_FILE.LOG, ' --- 17');

820: exception
821:
822: when others then
823: p_process_status := 'E';
824: fnd_file.put_line(FND_FILE.LOG, ' --- 17');
825: p_process_message := 'RECEIPT_ACCOUNTING_PKG.process_transaction:' || SQLERRM;
826: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
827: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 29 */
828: return;

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

822: when others then
823: p_process_status := 'E';
824: fnd_file.put_line(FND_FILE.LOG, ' --- 17');
825: p_process_message := 'RECEIPT_ACCOUNTING_PKG.process_transaction:' || SQLERRM;
826: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
827: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 29 */
828: return;
829:
830: end process_transaction;

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

988:
989: WHEN OTHERS then
990: p_process_status := 'E';
991: p_process_message := 'RECEIPT_ACCOUNTING_PKG.gl_entry:' || SQLERRM;
992: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
993: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 9 */
994: RETURN;
995:
996: end gl_entry;

Line 1133: fnd_file.put_line(fnd_file.log, 'ln_costing_group_id:' || ln_costing_group_id);

1129: fetch c_cost_group into ln_costing_group_id;
1130: close c_cost_group;
1131:
1132: if lv_debug='Y' THEN
1133: fnd_file.put_line(fnd_file.log, 'ln_costing_group_id:' || ln_costing_group_id);
1134: end if;
1135:
1136: -- if cost group is 1, then it means it is Common Cost group which should not be populated
1137: -- so that costing happens at Organization Level instead of CostGroup level

Line 1162: fnd_file.put_line(fnd_file.log, 'v_transaction_type_id:' || ln_transaction_type_id

1158: fetch c_fetch_count_overheads into ln_overhead_cnt;
1159: close c_fetch_count_overheads;
1160:
1161: if lv_debug='Y' then
1162: fnd_file.put_line(fnd_file.log, 'v_transaction_type_id:' || ln_transaction_type_id
1163: ||', v_transaction_source_type_id:' || ln_transaction_source_type_id
1164: ||', v_transaction_action_id:' || ln_transaction_action_id
1165: ||', p_transaction_uom:' || p_transaction_uom
1166: ||', Transaction Id:' || p_transaction_id ||', ln_overhead_cnt:' || ln_overhead_cnt

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

1262: EXCEPTION
1263: WHEN OTHERS then
1264: p_process_status := 'E';
1265: p_process_message := 'RECEIPT_ACCOUNTING_PKG.average_costing:' || SQLERRM;
1266: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1267: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
1268: RETURN;
1269:
1270: end average_costing;

Line 1341: fnd_file.put_line( fnd_file.log, 'Both Credit and Debit are 0. So, returning back');

1337:
1338: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_receiving_sub_ledger_entry', 'START'); /* 1 */
1339:
1340: if NVL(p_credit_amount, 0) = 0 AND NVL(p_debit_amount, 0) = 0 then
1341: fnd_file.put_line( fnd_file.log, 'Both Credit and Debit are 0. So, returning back');
1342: GOTO exit_from_procedure;
1343: end if;
1344:
1345: open c_base_sub_ledger_details(p_transaction_id);

Line 1351: fnd_file.put_line( fnd_file.log, 'Base Entry in rcv_receiving_sub_ledger not found. Hence returning back');

1347:
1348: if c_base_sub_ledger_details%notfound then
1349: close c_base_sub_ledger_details;
1350:
1351: fnd_file.put_line( fnd_file.log, 'Base Entry in rcv_receiving_sub_ledger not found. Hence returning back');
1352: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath, null, 'END'); /* 2 */
1353: goto exit_from_procedure;
1354: end if;
1355:

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

1479:
1480: WHEN OTHERS then
1481: p_process_status := 'E';
1482: p_process_message := 'RECEIPT_ACCOUNTING_PKG.rcv_receiving_sub_ledger_entry:' || SQLERRM;
1483: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1484: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1485: RETURN;
1486:
1487: end rcv_receiving_sub_ledger_entry;

Line 1571: fnd_file.put_line( fnd_file.log, 'Tax amount is 0. So, returning back');

1567:
1568: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.mta_entry', 'START'); /* 1 */
1569:
1570: if NVL(p_tax_amount, 0) = 0 then
1571: fnd_file.put_line( fnd_file.log, 'Tax amount is 0. So, returning back');
1572: GOTO exit_from_procedure;
1573: end if;
1574:
1575: open c_fetch_mmt_details(p_transaction_id);

Line 1580: fnd_file.put_line( fnd_file.log, '5.1 r_mmt_details.primary_quantity ' || r_mmt_details.primary_quantity ||' '||r_mmt_details.transaction_id);

1576: fetch c_fetch_mmt_details into r_mmt_details;
1577: close c_fetch_mmt_details;
1578:
1579: if lv_debug ='Y' then
1580: fnd_file.put_line( fnd_file.log, '5.1 r_mmt_details.primary_quantity ' || r_mmt_details.primary_quantity ||' '||r_mmt_details.transaction_id);
1581: end if;
1582: /* Bug 5243532. Added by Lakshmi Gopalsami
1583: * Removed the commented codes.
1584: */

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

1647: EXCEPTION
1648: WHEN OTHERS then
1649: p_process_status := 'E';
1650: p_process_message := 'RECEIPT_ACCOUNTING_PKG.mta_entry:' || SQLERRM;
1651: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1652: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 11 */
1653: RETURN;
1654: end mta_entry;
1655:

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

1676: EXCEPTION
1677: WHEN OTHERS then
1678: p_process_status := 'E';
1679: p_process_message := 'RECEIPT_ACCOUNTING_PKG.rcv_transactions_update:' || SQLERRM;
1680: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1681: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */
1682: RETURN;
1683:
1684: end rcv_transactions_update;