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_ACCOUNTING_PKG dependencies on JAI_GENERAL_PKG

Line 456: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */

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

Line 472: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2

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';
474: p_process_message := 'Accounting Entries are already passed for Transaction' ; --After Review
475: goto exit_from_procedure;
476: end if;

Line 498: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

494: (p_org_id => r_trx.organization_id);
495: lv_organization_code := l_func_curr_det.organization_code;
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 */

Line 532: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

528: open c_period_name(ln_set_of_books_id, lv_accounting_date); --Commented p_accounting_date added lv_accounting_date by nprashar;
529: fetch c_period_name into lv_period_name;
530: close c_period_name;
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:

Line 533: ln_precision := jai_general_pkg.get_currency_precision(r_trx.organization_id);

529: fetch c_period_name into lv_period_name;
530: close c_period_name;
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);

Line 546: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

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: (
549: p_organization_id => r_trx.organization_id,
550: p_organization_code => lv_organization_code,

Line 576: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */

572: p_reference_name => p_reference_name,
573: p_reference_id => p_reference_id
574: );
575:
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');

Line 586: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

582: /*This is to Ensure that in case of simulate flag ='Y',
583: No Accounting, costing and sub ledger tables are affected */
584:
585: if p_simulate_flag ='Y' then
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');

Line 607: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

603: */
604:
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: (

Line 636: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

632: p_process_status => p_process_status,
633: p_codepath => p_codepath
634: );
635:
636: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
637: if p_process_status IN ('E', 'X') then
638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
639: goto exit_from_procedure;
640: end if;

Line 638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

634: );
635:
636: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
637: if p_process_status IN ('E', 'X') then
638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
639: goto exit_from_procedure;
640: end if;
641:
642:

Line 646: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

642:
643:
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

Line 666: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */

662: p_process_message => p_process_message,
663: p_process_status => p_process_status,
664: p_codepath => p_codepath
665: );
666: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
667:
668: if p_process_status IN ('E', 'X') then
669: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
670: goto exit_from_procedure;

Line 669: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */

665: );
666: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
667:
668: if p_process_status IN ('E', 'X') then
669: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
670: goto exit_from_procedure;
671: end if;
672:
673: ELSIF p_destination ='S' then /* Indicates Standard Costing */

Line 683: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */

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 */
686: lv_debit_credit_flag :='N';
687: elsif ln_entered_dr <> 0 then

Line 685: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */

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 */
686: lv_debit_credit_flag :='N';
687: elsif ln_entered_dr <> 0 then
688: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
689: lv_debit_credit_flag :='Y';

Line 688: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */

684: if ln_entered_cr <> 0 then
685: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
686: lv_debit_credit_flag :='N';
687: elsif ln_entered_dr <> 0 then
688: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
689: lv_debit_credit_flag :='Y';
690: end if;
691:
692: if lv_debug ='Y' then

Line 696: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */

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
698: (
699: p_transaction_id => p_transaction_id,
700: p_reference_account => p_code_combination_id,

Line 719: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */

715: p_category_name => p_category_name,
716: p_accounting_date => lv_accounting_date --Replaced the call of p_accounting_date by nprashar /*Added by nprashar for FP bug # 9304844*/
717: );
718:
719: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
720:
721: if p_process_status IN ('E', 'X') then
722: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
723: goto exit_from_procedure;

Line 722: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */

718:
719: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
720:
721: if p_process_status IN ('E', 'X') then
722: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
723: goto exit_from_procedure;
724: end if;
725:
726: /*Bug 7581494 Porting fix made via 6905807 to 12.1 branch and Mainline*/

Line 730: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); -- 20

726: /*Bug 7581494 Porting fix made via 6905807 to 12.1 branch and Mainline*/
727: /*
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

Line 745: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); -- 21

741: p_process_status => p_process_status,
742: p_codepath => p_codepath
743: ) ;
744:
745: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); -- 21
746:
747: if p_process_status IN ('E', 'X') then
748: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); -- 22
749: goto exit_from_procedure;

Line 748: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); -- 22

744:
745: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); -- 21
746:
747: if p_process_status IN ('E', 'X') then
748: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); -- 22
749: goto exit_from_procedure;
750: end if;
751: */
752:

Line 754: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */

750: end if;
751: */
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

Line 771: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */

767: end if;
768:
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

Line 798: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */

794: p_process_status => p_process_status,
795: p_codepath => p_codepath
796: );
797:
798: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
799:
800: if p_process_status IN ('E', 'X') then
801: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
802: goto exit_from_procedure;

Line 801: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */

797:
798: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
799:
800: if p_process_status IN ('E', 'X') then
801: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
802: goto exit_from_procedure;
803: end if;
804:
805: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */

Line 805: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */

801: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
802: goto exit_from_procedure;
803: end if;
804:
805: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
806:
807: end if; /* End if for p_acct_nature */
808:
809: << exit_from_procedure >>

Line 816: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath, NULL, 'END'); /* 28 */

812: if p_process_status = 'Y' then
813: p_process_message := 'The Accounting / Costing Entries are passed successfully ' ;
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

Line 827: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 29 */

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;
831:

Line 890: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.gl_entry', 'START'); /* 1 */

886: lv_debug := jai_constants.yes;
887: ln_user_id := fnd_global.user_id;
888: ld_sysdate := SYSDATE;
889:
890: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.gl_entry', 'START'); /* 1 */
891: lv_reference_10 := substr(p_reference_10 || ' for the Organization code ' || p_organization_code,1,240);
892:
893: /*This is introduced to ensure that if the reference values goes beyond the specified width,
894: then the value would be restriced to an width of 240 so that exception would not occur.*/

Line 902: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

898: close c_trunc_references;
899:
900:
901: if p_accounting_date is null then
902: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
903: ld_accounting_date := sysdate;
904: else
905: ld_accounting_date := p_accounting_date;
906: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

Line 906: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

902: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
903: ld_accounting_date := sysdate;
904: else
905: ld_accounting_date := p_accounting_date;
906: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
907: end if;
908:
909: ld_accounting_date := trunc(ld_accounting_date);
910:

Line 914: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

910:
911: if p_cc_id is NULL then
912: p_process_status := 'E';
913: p_process_message := 'Account not given';
914: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
915: goto exit_from_procedure;
916: end if;
917:
918: if NVL(p_credit_amount, 0) = 0 and NVL(p_debit_amount,0) = 0 then

Line 921: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */

917:
918: if NVL(p_credit_amount, 0) = 0 and NVL(p_debit_amount,0) = 0 then
919: p_process_status := 'E';
920: p_process_message := 'Both Credit and Debit are Zero';
921: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
922: goto exit_from_procedure;
923: end if;
924:
925: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 925: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

921: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
922: goto exit_from_procedure;
923: end if;
924:
925: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
926:
927: lv_status := 'NEW' ;
928: insert into gl_interface
929: (

Line 984: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath, NULL, 'END'); /* 8 */

980: to_char(p_organization_id)
981: );
982:
983: << exit_from_procedure >>
984: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath, NULL, 'END'); /* 8 */
985: return;
986:
987: EXCEPTION
988:

Line 993: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, NULL, 'END'); /* 9 */

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;
997:

Line 1126: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.average_costing', 'START'); /* 1 */

1122: ln_user_id := fnd_global.user_id;
1123: lv_debug := 'Y';
1124: lv_transaction_type_name := 'Average cost update';
1125:
1126: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.average_costing', 'START'); /* 1 */
1127:
1128: open c_cost_group(p_transaction_id, p_organization_id); --added the parameter p_organization_id for bug#8449597
1129: fetch c_cost_group into ln_costing_group_id;
1130: close c_cost_group;

Line 1233: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);

1229:
1230: end if; --end if for ln_overhead_cnt= 0
1231:
1232:
1233: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);
1234: lv_process_mode := FND_PROFILE.value('TRANSACTION_PROCESS_MODE');
1235:
1236: --Indicates Online Mode
1237: if lv_process_mode = '1' then

Line 1260: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath, null, 'END');

1256: );
1257: end if;
1258:
1259: << exit_from_procedure >>
1260: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath, null, 'END');
1261:
1262: EXCEPTION
1263: WHEN OTHERS then
1264: p_process_status := 'E';

Line 1267: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');

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;
1271:

Line 1338: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_receiving_sub_ledger_entry', 'START'); /* 1 */

1334: lv_debug := 'Y';
1335: ln_user_id := fnd_global.user_id;
1336: ld_sysdate := SYSDATE;
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;

Line 1352: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath, null, 'END'); /* 2 */

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:
1356: close c_base_sub_ledger_details;

Line 1358: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

1354: end if;
1355:
1356: close c_base_sub_ledger_details;
1357:
1358: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1359:
1360: if p_source_document_code='PO' then
1361:
1362: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

Line 1362: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

1358: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1359:
1360: if p_source_document_code='PO' then
1361:
1362: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
1363: open c_fetch_price_override(p_po_line_location_id);
1364: fetch c_fetch_price_override into ln_unit_price;
1365: close c_fetch_price_override;
1366:

Line 1369: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

1365: close c_fetch_price_override;
1366:
1367: ELSIF p_source_document_code='INVENTORY' then
1368:
1369: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1370: open c_fetch_list_price(p_organization_id, p_item_id);
1371: fetch c_fetch_list_price into ln_unit_price;
1372: close c_fetch_list_price;
1373:

Line 1376: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */

1372: close c_fetch_list_price;
1373:
1374: ELSIF p_source_document_code = 'REQ' then
1375:
1376: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1377: open c_fetch_unit_price(p_requisition_line_id);
1378: fetch c_fetch_unit_price into ln_unit_price;
1379: close c_fetch_unit_price;
1380:

Line 1383: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

1379: close c_fetch_unit_price;
1380:
1381: end if;
1382:
1383: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1384: ln_amount := NVL(p_credit_amount,p_debit_amount);
1385:
1386: if ln_amount is not NULL and nvl(ln_unit_price,0) <> 0 then
1387: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 1387: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

1383: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1384: ln_amount := NVL(p_credit_amount,p_debit_amount);
1385:
1386: if ln_amount is not NULL and nvl(ln_unit_price,0) <> 0 then
1387: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1388: ln_amount := ln_amount / ln_unit_price;
1389: end if;
1390:
1391: if p_accounting_date is NULL then

Line 1392: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

1388: ln_amount := ln_amount / ln_unit_price;
1389: end if;
1390:
1391: if p_accounting_date is NULL then
1392: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1393: ld_accounting_date := TRUNC(ld_sysdate);
1394: ELSE
1395: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1396: ld_accounting_date := TRUNC(p_accounting_date);

Line 1395: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

1391: if p_accounting_date is NULL then
1392: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1393: ld_accounting_date := TRUNC(ld_sysdate);
1394: ELSE
1395: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1396: ld_accounting_date := TRUNC(p_accounting_date);
1397: end if;
1398:
1399: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

Line 1399: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

1395: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1396: ld_accounting_date := TRUNC(p_accounting_date);
1397: end if;
1398:
1399: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1400: insert into JAI_RCV_SUBLED_ENTRIES
1401: (SUBLED_ENTRY_ID,
1402: rcv_transaction_id,
1403: set_of_books_id,

Line 1473: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */

1469: ln_user_id,
1470: 'L',
1471: fnd_profile.value('PROG_APPL_ID')
1472: );
1473: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1474:
1475: << exit_from_procedure >>
1476: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1477:

Line 1476: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */

1472: );
1473: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1474:
1475: << exit_from_procedure >>
1476: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1477:
1478: EXCEPTION
1479:
1480: WHEN OTHERS then

Line 1484: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 14 */

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;
1488:

Line 1568: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.mta_entry', 'START'); /* 1 */

1564: ld_sysdate := SYSDATE;
1565: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';--rchandan for bug#4473022
1566: lv_reference_10_desc2 := ' For the Transaction Type ';--rchandan for bug#4473022
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;

Line 1638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */

1634: p_process_status => p_process_status,
1635: p_codepath => p_codepath
1636: );
1637: if p_process_status IN ('E', 'X') then
1638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1639: goto exit_from_procedure;
1640: end if; /* rchandan for bug#4473022 end*/
1641:
1642: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

Line 1642: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

1638: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1639: goto exit_from_procedure;
1640: end if; /* rchandan for bug#4473022 end*/
1641:
1642: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1643:
1644: << exit_from_procedure >>
1645: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */
1646:

Line 1645: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */

1641:
1642: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1643:
1644: << exit_from_procedure >>
1645: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */
1646:
1647: EXCEPTION
1648: WHEN OTHERS then
1649: p_process_status := 'E';

Line 1652: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 11 */

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:
1656: /*------------------------------------------------------------------------------------------------*/

Line 1668: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_transactions_update', 'START'); /* 1 */

1664: ) IS
1665:
1666: BEGIN
1667:
1668: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_transactions_update', 'START'); /* 1 */
1669:
1670: UPDATE rcv_transactions
1671: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1672: WHERE transaction_id = p_transaction_id;

Line 1674: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END'); /* 3 */

1670: UPDATE rcv_transactions
1671: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1672: WHERE transaction_id = p_transaction_id;
1673:
1674: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END'); /* 3 */
1675:
1676: EXCEPTION
1677: WHEN OTHERS then
1678: p_process_status := 'E';

Line 1681: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 4 */

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;
1685: