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 421: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.process_transaction', 'START'); /* 1 */

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:
425: open c_acct_check(p_transaction_id, p_acct_nature, p_code_combination_id, p_reference_name, p_reference_id);

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

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

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

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

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

472: open c_period_name(ln_set_of_books_id,p_accounting_date);
473: fetch c_period_name into lv_period_name;
474: close c_period_name;
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:

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

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

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

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

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

516: p_reference_name => p_reference_name,
517: p_reference_id => p_reference_id
518: );
519:
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');

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

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

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

547: */
548:
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: (

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

576: p_process_status => p_process_status,
577: p_codepath => p_codepath
578: );
579:
580: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
581: if p_process_status IN ('E', 'X') then
582: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
583: goto exit_from_procedure;
584: end if;

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

578: );
579:
580: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
581: if p_process_status IN ('E', 'X') then
582: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
583: goto exit_from_procedure;
584: end if;
585:
586:

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

586:
587:
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

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

606: p_process_message => p_process_message,
607: p_process_status => p_process_status,
608: p_codepath => p_codepath
609: );
610: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
611:
612: if p_process_status IN ('E', 'X') then
613: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
614: goto exit_from_procedure;

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

609: );
610: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
611:
612: if p_process_status IN ('E', 'X') then
613: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
614: goto exit_from_procedure;
615: end if;
616:
617: ELSIF p_destination ='S' then /* Indicates Standard Costing */

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

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

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

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 */
630: lv_debit_credit_flag :='N';
631: elsif ln_entered_dr <> 0 then
632: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
633: lv_debit_credit_flag :='Y';

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

628: if ln_entered_cr <> 0 then
629: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
630: lv_debit_credit_flag :='N';
631: elsif ln_entered_dr <> 0 then
632: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
633: lv_debit_credit_flag :='Y';
634: end if;
635:
636: if lv_debug ='Y' then

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

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
642: (
643: p_transaction_id => p_transaction_id,
644: p_reference_account => p_code_combination_id,

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

659: p_category_name => p_category_name,
660: p_accounting_date => p_accounting_date
661: );
662:
663: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
664:
665: if p_process_status IN ('E', 'X') then
666: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
667: goto exit_from_procedure;

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

662:
663: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
664:
665: if p_process_status IN ('E', 'X') then
666: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
667: goto exit_from_procedure;
668: end if;
669:
670: /*Bug 7581494 Porting fix made via 6905807 to 12.1 branch and Mainline*/

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

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

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

685: p_process_status => p_process_status,
686: p_codepath => p_codepath
687: ) ;
688:
689: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); -- 21
690:
691: if p_process_status IN ('E', 'X') then
692: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); -- 22
693: goto exit_from_procedure;

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

688:
689: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); -- 21
690:
691: if p_process_status IN ('E', 'X') then
692: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); -- 22
693: goto exit_from_procedure;
694: end if;
695: */
696:

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

694: end if;
695: */
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

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

711: end if;
712:
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

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

738: p_process_status => p_process_status,
739: p_codepath => p_codepath
740: );
741:
742: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
743:
744: if p_process_status IN ('E', 'X') then
745: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
746: goto exit_from_procedure;

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

741:
742: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
743:
744: if p_process_status IN ('E', 'X') then
745: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
746: goto exit_from_procedure;
747: end if;
748:
749: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */

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

745: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
746: goto exit_from_procedure;
747: end if;
748:
749: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
750:
751: end if; /* End if for p_acct_nature */
752:
753: << exit_from_procedure >>

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

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

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

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

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

830: lv_debug := jai_constants.yes;
831: ln_user_id := fnd_global.user_id;
832: ld_sysdate := SYSDATE;
833:
834: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.gl_entry', 'START'); /* 1 */
835: lv_reference_10 := substr(p_reference_10 || ' for the Organization code ' || p_organization_code,1,240);
836:
837: /*This is introduced to ensure that if the reference values goes beyond the specified width,
838: then the value would be restriced to an width of 240 so that exception would not occur.*/

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

842: close c_trunc_references;
843:
844:
845: if p_accounting_date is null then
846: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
847: ld_accounting_date := sysdate;
848: else
849: ld_accounting_date := p_accounting_date;
850: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

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

846: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
847: ld_accounting_date := sysdate;
848: else
849: ld_accounting_date := p_accounting_date;
850: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
851: end if;
852:
853: ld_accounting_date := trunc(ld_accounting_date);
854:

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

854:
855: if p_cc_id is NULL then
856: p_process_status := 'E';
857: p_process_message := 'Account not given';
858: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
859: goto exit_from_procedure;
860: end if;
861:
862: if NVL(p_credit_amount, 0) = 0 and NVL(p_debit_amount,0) = 0 then

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

861:
862: if NVL(p_credit_amount, 0) = 0 and NVL(p_debit_amount,0) = 0 then
863: p_process_status := 'E';
864: p_process_message := 'Both Credit and Debit are Zero';
865: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
866: goto exit_from_procedure;
867: end if;
868:
869: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

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

865: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
866: goto exit_from_procedure;
867: end if;
868:
869: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
870:
871: lv_status := 'NEW' ;
872: insert into gl_interface
873: (

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

924: to_char(p_organization_id)
925: );
926:
927: << exit_from_procedure >>
928: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath, NULL, 'END'); /* 8 */
929: return;
930:
931: EXCEPTION
932:

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

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

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

1062: ln_user_id := fnd_global.user_id;
1063: lv_debug := 'Y';
1064: lv_transaction_type_name := 'Average cost update';
1065:
1066: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.average_costing', 'START'); /* 1 */
1067:
1068: open c_cost_group(p_transaction_id);
1069: fetch c_cost_group into ln_costing_group_id;
1070: close c_cost_group;

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

1169:
1170: end if; --end if for ln_overhead_cnt= 0
1171:
1172:
1173: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);
1174: lv_process_mode := FND_PROFILE.value('TRANSACTION_PROCESS_MODE');
1175:
1176: --Indicates Online Mode
1177: if lv_process_mode = '1' then

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

1196: );
1197: end if;
1198:
1199: << exit_from_procedure >>
1200: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath, null, 'END');
1201:
1202: EXCEPTION
1203: WHEN OTHERS then
1204: p_process_status := 'E';

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

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

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

1274: lv_debug := 'Y';
1275: ln_user_id := fnd_global.user_id;
1276: ld_sysdate := SYSDATE;
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;

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

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

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

1294: end if;
1295:
1296: close c_base_sub_ledger_details;
1297:
1298: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1299:
1300: if p_source_document_code='PO' then
1301:
1302: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

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

1298: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1299:
1300: if p_source_document_code='PO' then
1301:
1302: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
1303: open c_fetch_price_override(p_po_line_location_id);
1304: fetch c_fetch_price_override into ln_unit_price;
1305: close c_fetch_price_override;
1306:

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

1305: close c_fetch_price_override;
1306:
1307: ELSIF p_source_document_code='INVENTORY' then
1308:
1309: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1310: open c_fetch_list_price(p_organization_id, p_item_id);
1311: fetch c_fetch_list_price into ln_unit_price;
1312: close c_fetch_list_price;
1313:

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

1312: close c_fetch_list_price;
1313:
1314: ELSIF p_source_document_code = 'REQ' then
1315:
1316: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1317: open c_fetch_unit_price(p_requisition_line_id);
1318: fetch c_fetch_unit_price into ln_unit_price;
1319: close c_fetch_unit_price;
1320:

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

1319: close c_fetch_unit_price;
1320:
1321: end if;
1322:
1323: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1324: ln_amount := NVL(p_credit_amount,p_debit_amount);
1325:
1326: if ln_amount is not NULL and nvl(ln_unit_price,0) <> 0 then
1327: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

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

1323: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1324: ln_amount := NVL(p_credit_amount,p_debit_amount);
1325:
1326: if ln_amount is not NULL and nvl(ln_unit_price,0) <> 0 then
1327: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1328: ln_amount := ln_amount / ln_unit_price;
1329: end if;
1330:
1331: if p_accounting_date is NULL then

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

1328: ln_amount := ln_amount / ln_unit_price;
1329: end if;
1330:
1331: if p_accounting_date is NULL then
1332: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1333: ld_accounting_date := TRUNC(ld_sysdate);
1334: ELSE
1335: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1336: ld_accounting_date := TRUNC(p_accounting_date);

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

1331: if p_accounting_date is NULL then
1332: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1333: ld_accounting_date := TRUNC(ld_sysdate);
1334: ELSE
1335: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1336: ld_accounting_date := TRUNC(p_accounting_date);
1337: end if;
1338:
1339: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

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

1335: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1336: ld_accounting_date := TRUNC(p_accounting_date);
1337: end if;
1338:
1339: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1340: insert into JAI_RCV_SUBLED_ENTRIES
1341: (SUBLED_ENTRY_ID,
1342: rcv_transaction_id,
1343: set_of_books_id,

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

1409: ln_user_id,
1410: 'L',
1411: fnd_profile.value('PROG_APPL_ID')
1412: );
1413: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1414:
1415: << exit_from_procedure >>
1416: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1417:

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

1412: );
1413: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1414:
1415: << exit_from_procedure >>
1416: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1417:
1418: EXCEPTION
1419:
1420: WHEN OTHERS then

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

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

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

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

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

1574: p_process_status => p_process_status,
1575: p_codepath => p_codepath
1576: );
1577: if p_process_status IN ('E', 'X') then
1578: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1579: goto exit_from_procedure;
1580: end if; /* rchandan for bug#4473022 end*/
1581:
1582: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

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

1578: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1579: goto exit_from_procedure;
1580: end if; /* rchandan for bug#4473022 end*/
1581:
1582: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1583:
1584: << exit_from_procedure >>
1585: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */
1586:

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

1581:
1582: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1583:
1584: << exit_from_procedure >>
1585: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */
1586:
1587: EXCEPTION
1588: WHEN OTHERS then
1589: p_process_status := 'E';

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

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

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

1604: ) IS
1605:
1606: BEGIN
1607:
1608: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_accounting_pkg.rcv_transactions_update', 'START'); /* 1 */
1609:
1610: UPDATE rcv_transactions
1611: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1612: WHERE transaction_id = p_transaction_id;

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

1610: UPDATE rcv_transactions
1611: SET po_unit_price = nvl(po_unit_price,0) + nvl(p_costing_amount,0)
1612: WHERE transaction_id = p_transaction_id;
1613:
1614: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath, null, 'END'); /* 3 */
1615:
1616: EXCEPTION
1617: WHEN OTHERS then
1618: p_process_status := 'E';

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

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