DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on FND_FILE

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

416: ln_acct_count := 0 ;
417: ln_user_id := fnd_global.user_id;
418:
419: /* Multiple Accounting Entry Checks. Needs to be changed for CENVAT */
420: fnd_file.put_line(FND_FILE.LOG, ' --- 1');
421: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */
422:
423: fnd_file.put_line(FND_FILE.LOG, ' --- 2');
424:

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

419: /* Multiple Accounting Entry Checks. Needs to be changed for CENVAT */
420: fnd_file.put_line(FND_FILE.LOG, ' --- 1');
421: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */
422:
423: fnd_file.put_line(FND_FILE.LOG, ' --- 2');
424:
425: open c_acct_check(p_transaction_id, p_acct_nature, p_code_combination_id, p_reference_name, p_reference_id);
426: fetch c_acct_check into ln_acct_count;
427: close c_acct_check;

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

426: fetch c_acct_check into ln_acct_count;
427: close c_acct_check;
428:
429: if lv_debug ='Y' then
430: fnd_file.put_line( fnd_file.log, '1.0 ln_acct_count -> ' || ln_acct_count ||' p_simulate_flag -> ' || p_simulate_flag );
431: end if;
432:
433: fnd_file.put_line(FND_FILE.LOG, ' --- 3');
434:

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

429: if lv_debug ='Y' then
430: fnd_file.put_line( fnd_file.log, '1.0 ln_acct_count -> ' || ln_acct_count ||' p_simulate_flag -> ' || p_simulate_flag );
431: end if;
432:
433: fnd_file.put_line(FND_FILE.LOG, ' --- 3');
434:
435: if ln_acct_count > 0 and p_simulate_flag ='N' then
436: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
437: p_process_status := 'X';

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

459: ln_set_of_books_id := l_func_curr_det.ledger_id;
460:
461: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
462:
463: fnd_file.put_line(FND_FILE.LOG, ' --- 4');
464:
465: /* Fetch Period Information */
466:
467: /* Bug 5243532. Added by Lakshmi Gopalsami

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

475:
476: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
477: ln_precision := jai_general_pkg.get_currency_precision(r_trx.organization_id);
478:
479: fnd_file.put_line(FND_FILE.LOG, ' --- 5');
480:
481: ln_entered_cr := ROUND(p_entered_cr,ln_precision);
482: ln_entered_dr := ROUND(p_entered_dr,ln_precision);
483:

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

481: ln_entered_cr := ROUND(p_entered_cr,ln_precision);
482: ln_entered_dr := ROUND(p_entered_dr,ln_precision);
483:
484: if lv_debug ='Y' then
485: fnd_file.put_line( fnd_file.log, '1.3 ln_entered_cr -> ' || ln_entered_cr ||' ln_entered_dr -> '|| ln_entered_dr );
486: end if;
487:
488: fnd_file.put_line(FND_FILE.LOG, ' ---6');
489:

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

484: if lv_debug ='Y' then
485: fnd_file.put_line( fnd_file.log, '1.3 ln_entered_cr -> ' || ln_entered_cr ||' ln_entered_dr -> '|| ln_entered_dr );
486: end if;
487:
488: fnd_file.put_line(FND_FILE.LOG, ' ---6');
489:
490: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
491: jai_rcv_journal_pkg.insert_row
492: (

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

520: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
521: if p_process_status IN ('E', 'X') then
522: goto exit_from_procedure;
523: end if;
524: fnd_file.put_line(FND_FILE.LOG, ' --- 7');
525:
526: /*This is to Ensure that in case of simulate flag ='Y',
527: No Accounting, costing and sub ledger tables are affected */
528:

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

530: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
531: goto exit_from_procedure;
532: end if;
533:
534: fnd_file.put_line(FND_FILE.LOG, ' --- 8');
535: /*
536: The Destination is sent from the respective procedures depending on the Accounting/Costing that
537: needs to happen.
538: Following are the p_destination values and its target tables.

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

549: if p_destination ='G' then --GL Interface Entries
550:
551: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
552:
553: fnd_file.put_line(FND_FILE.LOG, ' --- 9');
554: gl_entry
555: (
556: p_organization_id => r_trx.organization_id,
557: p_organization_code => lv_organization_code,

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

588: elsif p_destination = 'A1' then /*Average Costing Receiving Inspection Account Entry */
589:
590: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
591:
592: fnd_file.put_line(FND_FILE.LOG, ' --- 10');
593:
594: average_costing
595: (
596: p_receiving_account_id => p_code_combination_id,

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

621: Amount > 0 Debit Credit Flag
622: Credit Amount N
623: Debit Amount Y
624: */
625: fnd_file.put_line(FND_FILE.LOG, ' --- 11');
626:
627: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
628: if ln_entered_cr <> 0 then
629: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */

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

633: lv_debit_credit_flag :='Y';
634: end if;
635:
636: if lv_debug ='Y' then
637: fnd_file.put_line( fnd_file.log, '1.7 Before the call to mta_entry Procedure ' || 'lv_debit_credit_flag ' || lv_debit_credit_flag);
638: end if;
639:
640: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
641: mta_entry

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

672: ELSIF p_destination ='O1' then -- OPM Costing Entry
673:
674: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); -- 20
675:
676: fnd_file.put_line(FND_FILE.LOG, ' --- 12');
677:
678: rcv_transactions_update
679: (
680: p_transaction_id => p_transaction_id,

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

696:
697: end if; /*End if for p_destination */
698: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */
699:
700: fnd_file.put_line(FND_FILE.LOG, ' --- 13');
701:
702: /*This check ensures that this is called only in the following transaction types
703: 1. RECEIVE
704: 2. RETURN TO VENDOR

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

706: 4. CORRECT TO RTV
707: And this is called from JA_in_RECEIVE_RTR_PKG. */
708:
709: if lv_debug ='Y' then
710: fnd_file.put_line( fnd_file.log, '2.0 p_acct_nature - > ' || p_acct_nature );
711: end if;
712:
713: if p_acct_nature = 'Receiving' then
714:

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

713: if p_acct_nature = 'Receiving' then
714:
715: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
716:
717: fnd_file.put_line(FND_FILE.LOG, ' --- 14');
718:
719: rcv_receiving_sub_ledger_entry
720: (
721: p_transaction_id => p_transaction_id,

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

750:
751: end if; /* End if for p_acct_nature */
752:
753: << exit_from_procedure >>
754: fnd_file.put_line(FND_FILE.LOG, ' --- 15');
755:
756: if p_process_status = 'Y' then
757: p_process_message := 'The Accounting / Costing Entries are passed successfully ' ;
758: end if;

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

758: end if;
759:
760: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath, NULL, 'END'); /* 28 */
761:
762: fnd_file.put_line(FND_FILE.LOG, ' --- 16');
763:
764: exception
765:
766: when others then

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

764: exception
765:
766: when others then
767: p_process_status := 'E';
768: fnd_file.put_line(FND_FILE.LOG, ' --- 17');
769: p_process_message := 'RECEIPT_ACCOUNTING_PKG.process_transaction:' || SQLERRM;
770: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
771: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 29 */
772: return;

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

766: when others then
767: p_process_status := 'E';
768: fnd_file.put_line(FND_FILE.LOG, ' --- 17');
769: p_process_message := 'RECEIPT_ACCOUNTING_PKG.process_transaction:' || SQLERRM;
770: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
771: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 29 */
772: return;
773:
774: end process_transaction;

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

932:
933: WHEN OTHERS then
934: p_process_status := 'E';
935: p_process_message := 'RECEIPT_ACCOUNTING_PKG.gl_entry:' || SQLERRM;
936: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
937: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 9 */
938: RETURN;
939:
940: end gl_entry;

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

1069: fetch c_cost_group into ln_costing_group_id;
1070: close c_cost_group;
1071:
1072: if lv_debug='Y' THEN
1073: fnd_file.put_line(fnd_file.log, 'ln_costing_group_id:' || ln_costing_group_id);
1074: end if;
1075:
1076: -- if cost group is 1, then it means it is Common Cost group which should not be populated
1077: -- so that costing happens at Organization Level instead of CostGroup level

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

1098: fetch c_fetch_count_overheads into ln_overhead_cnt;
1099: close c_fetch_count_overheads;
1100:
1101: if lv_debug='Y' then
1102: fnd_file.put_line(fnd_file.log, 'v_transaction_type_id:' || ln_transaction_type_id
1103: ||', v_transaction_source_type_id:' || ln_transaction_source_type_id
1104: ||', v_transaction_action_id:' || ln_transaction_action_id
1105: ||', p_transaction_uom:' || p_transaction_uom
1106: ||', Transaction Id:' || p_transaction_id ||', ln_overhead_cnt:' || ln_overhead_cnt

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

1202: EXCEPTION
1203: WHEN OTHERS then
1204: p_process_status := 'E';
1205: p_process_message := 'RECEIPT_ACCOUNTING_PKG.average_costing:' || SQLERRM;
1206: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1207: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
1208: RETURN;
1209:
1210: end average_costing;

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

1277:
1278: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_receiving_sub_ledger_entry', 'START'); /* 1 */
1279:
1280: if NVL(p_credit_amount, 0) = 0 AND NVL(p_debit_amount, 0) = 0 then
1281: fnd_file.put_line( fnd_file.log, 'Both Credit and Debit are 0. So, returning back');
1282: GOTO exit_from_procedure;
1283: end if;
1284:
1285: open c_base_sub_ledger_details(p_transaction_id);

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

1287:
1288: if c_base_sub_ledger_details%notfound then
1289: close c_base_sub_ledger_details;
1290:
1291: fnd_file.put_line( fnd_file.log, 'Base Entry in rcv_receiving_sub_ledger not found. Hence returning back');
1292: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath, null, 'END'); /* 2 */
1293: goto exit_from_procedure;
1294: end if;
1295:

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

1419:
1420: WHEN OTHERS then
1421: p_process_status := 'E';
1422: p_process_message := 'RECEIPT_ACCOUNTING_PKG.rcv_receiving_sub_ledger_entry:' || SQLERRM;
1423: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1424: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */
1425: RETURN;
1426:
1427: end rcv_receiving_sub_ledger_entry;

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

1507:
1508: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.mta_entry', 'START'); /* 1 */
1509:
1510: if NVL(p_tax_amount, 0) = 0 then
1511: fnd_file.put_line( fnd_file.log, 'Tax amount is 0. So, returning back');
1512: GOTO exit_from_procedure;
1513: end if;
1514:
1515: open c_fetch_mmt_details(p_transaction_id);

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

1516: fetch c_fetch_mmt_details into r_mmt_details;
1517: close c_fetch_mmt_details;
1518:
1519: if lv_debug ='Y' then
1520: fnd_file.put_line( fnd_file.log, '5.1 r_mmt_details.primary_quantity ' || r_mmt_details.primary_quantity ||' '||r_mmt_details.transaction_id);
1521: end if;
1522: /* Bug 5243532. Added by Lakshmi Gopalsami
1523: * Removed the commented codes.
1524: */

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

1587: EXCEPTION
1588: WHEN OTHERS then
1589: p_process_status := 'E';
1590: p_process_message := 'RECEIPT_ACCOUNTING_PKG.mta_entry:' || SQLERRM;
1591: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1592: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 11 */
1593: RETURN;
1594: end mta_entry;
1595:

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

1616: EXCEPTION
1617: WHEN OTHERS then
1618: p_process_status := 'E';
1619: p_process_message := 'RECEIPT_ACCOUNTING_PKG.rcv_transactions_update:' || SQLERRM;
1620: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1621: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */
1622: RETURN;
1623:
1624: end rcv_transactions_update;