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

Line 279: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 1 */

275: ln_no_of_holds number;
276:
277: begin
278:
279: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 1 */
280:
281: if p_invoice_distribution_id is not null and p_match_status_flag is not null then
282: update jai_ap_tds_inv_taxes
283: set match_status_flag = p_match_status_flag

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

297: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
298:
299: fnd_file.put_line(FND_FILE.LOG, ' Value ofvalidated cnt '|| ln_validated_cnt);
300:
301: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
302:
303: if ln_total_count = ln_validated_cnt then
304: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
305:

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

300:
301: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
302:
303: if ln_total_count = ln_validated_cnt then
304: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
305:
306: p_is_invoice_validated := 'Y';
307: else
308: p_is_invoice_validated := 'N';

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

305:
306: p_is_invoice_validated := 'Y';
307: else
308: p_is_invoice_validated := 'N';
309: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
310: end if;
311:
312: if p_match_status_flag is not null then
313: /* Scenarios other than holds release */

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

316: close c_ap_holds_all;
317:
318: if nvl(ln_no_of_holds, 0) > 0 then
319: p_is_invoice_validated := 'N';
320: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
321: end if;
322:
323: end if;
324:

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

324:
325: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
326:
327: << exit_from_procedure >>
328: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath, null, 'END'); /* 6 */
329: return;
330:
331: exception
332: when others then

Line 577: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate', 'START'); /* 1 */

573:
574:
575: begin
576:
577: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate', 'START'); /* 1 */
578: open c_check_if_exists(p_invoice_id);
579: fetch c_check_if_exists into ln_count;
580: close c_check_if_exists;
581:

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

581:
582: fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);
583:
584: if nvl(ln_count, 0) = 0 then
585: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
586: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');
587: p_process_flag := 'X';
588: p_process_message := ' TDS tax is not applicable';
589: goto exit_from_procedure;

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

588: p_process_message := ' TDS tax is not applicable';
589: goto exit_from_procedure;
590: end if;
591:
592: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
593: open c_check_if_processed(p_invoice_id,'P');
594: fetch c_check_if_processed into ln_cnt_already_processed;
595: close c_check_if_processed;
596:

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

596:
597: fnd_file.put_line(FND_FILE.LOG, '3. Check for processed already '|| ln_cnt_already_processed);
598:
599: if nvl(ln_cnt_already_processed, 0) > 0 then
600: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
601: p_process_flag := 'X';
602: p_process_message := 'TDS invoices have already been processed for this invoice';
603: goto exit_from_procedure;
604: end if;

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

604: end if;
605:
606:
607: /* Update actual value from default value if actual is null for TDS section taxes only*/
608: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
609: update jai_ap_tds_inv_taxes
610: set actual_tax_id = default_tax_id
611: where invoice_id = p_invoice_id
612: and actual_tax_id is null

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

620: where invoice_id = p_invoice_id
621: and section_type = lv_tds_section_type --rchandan for bug#4428980
622: and nvl(user_deleted_tax_flag, 'N') = 'Y';
623:
624: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
625:
626: open c_gl_sets_of_books(p_set_of_books_id);
627: fetch c_gl_sets_of_books into r_gl_sets_of_books;
628: close c_gl_sets_of_books;

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

628: close c_gl_sets_of_books;
629:
630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
631: /* Foreign currency invoice */
632: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
633: ln_exchange_rate := p_exchange_rate;
634: end if;
635:
636: ln_exchange_rate := nvl(ln_exchange_rate, 1);

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

637:
638: /* start Loop through and calculate taxes for taxes of all sections */
639: for cur_rec in c_calculate_tax(p_invoice_id) loop
640:
641: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
642:
643: r_ja_in_tax_codes := null;
644: open c_ja_in_tax_codes(cur_rec.actual_tax_id);
645: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;

Line 649: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */

645: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
646: close c_ja_in_tax_codes;
647:
648: if trunc(r_ja_in_tax_codes.end_date) < p_accounting_date then --trunc(r_ja_in_tax_codes.sysdate) then --commented by Bgowrava for Bug#7389849
649: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
650: p_process_flag := 'E';
651: p_process_message := r_ja_in_tax_codes.tax_end_dated_message;
652: goto exit_from_procedure;
653: end if;

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

694: /* End Loop through and calculate taxes */
695:
696:
697: /* Get vendor_type_lookup_code */
698: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
699: open c_po_vendors(p_vendor_id);
700: fetch c_po_vendors into lv_vendor_type_lookup_code;
701: close c_po_vendors;
702:

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

725: /* Start Loop through for each tds section and process for TDS section taxes only */
726: /* This section is meant for threshold, specific to TDS section taxes only */
727: for cur_rec_section in c_for_each_tds_section(p_invoice_id, ln_exchange_rate,'TDS_SECTION') LOOP --rchandan for bug#4428980
728:
729: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
730: ln_threshold_grp_id := 0;
731: ln_threshold_hdr_id := 0;
732: ln_threshold_slab_id_before := null;
733: ln_threshold_slab_id_after:= null;

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

740:
741: fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);
742:
743: if nvl(ln_threshold_hdr_id, 0) = 0 then
744: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
745: fnd_file.put_line(FND_FILE.LOG, '10. Threshold is not defined for the
746: applicable TDS section '||
747: cur_rec_section.actual_section_code||
748: '- Error');

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

752: goto exit_from_procedure;
753: end if;
754:
755: /* Get the threshold group id */
756: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
757: open c_get_threshold_group(p_vendor_id, lv_tan_no, lv_pan_no, cur_rec_section.actual_section_code, ln_fin_year,'TDS_SECTION'); --rchandan for bug#4428980
758: fetch c_get_threshold_group into ln_threshold_grp_id;
759: close c_get_threshold_group;
760:

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

760:
761: fnd_file.put_line(FND_FILE.LOG, '11. Threshold grp id ->'||ln_threshold_grp_id);
762:
763: /* Get the threshold group details */
764: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
765: if nvl(ln_threshold_grp_id, 0) <> 0 then
766: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
767:
768: r_jai_ap_tds_thhold_grps := null;

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

762:
763: /* Get the threshold group details */
764: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
765: if nvl(ln_threshold_grp_id, 0) <> 0 then
766: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
767:
768: r_jai_ap_tds_thhold_grps := null;
769:
770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

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

773:
774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
775:
776: else
777: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
778:
779: ln_total_invoice_amount := 0;
780:
781: end if;

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

783: fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||
784: ln_total_invoice_amount);
785:
786: /* Get the threshold position before this invoice impact */
787: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
788: open c_jai_ap_tds_thhold_slabs(ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount);
789: fetch c_jai_ap_tds_thhold_slabs into r_jai_ap_tds_thhold_slabs;
790: close c_jai_ap_tds_thhold_slabs;
791:

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

794: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||
795: ln_threshold_slab_id_before);
796:
797: /* Get the threshold position after this invoice impact */
798: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
799: /* FP Bug 6345725 - Removed the assignments for p_codepath without ja_in_general_pkg*/
800: r_jai_ap_tds_thhold_slabs := null;
801: open c_jai_ap_tds_thhold_slabs
802: (ln_threshold_hdr_id , 'CUMULATIVE' , ln_total_invoice_amount + cur_rec_section.invoice_amount);

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

821:
822: fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'||
823: ln_threshold_slab_id_after);
824: p_codepath := p_codepath || to_char(ln_threshold_slab_id_after) || '**'; /*Bug 4667681*/
825: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
826: if ln_threshold_slab_id_after <> 0 then
827: /* Threshold has reached */
828: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
829: lv_generate_all_invoices := 'Y';

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

824: p_codepath := p_codepath || to_char(ln_threshold_slab_id_after) || '**'; /*Bug 4667681*/
825: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
826: if ln_threshold_slab_id_after <> 0 then
827: /* Threshold has reached */
828: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
829: lv_generate_all_invoices := 'Y';
830: else
831: lv_generate_all_invoices := 'N';
832: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */

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

828: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
829: lv_generate_all_invoices := 'Y';
830: else
831: lv_generate_all_invoices := 'N';
832: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
833: end if; /* if ln_threshold_slab_id_after <> 0 */
834:
835: fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' ||
836: lv_generate_all_invoices);

Line 852: p_codepath := jai_general_pkg.plot_codepath(19.1, p_codepath); /* 19.1 */

848: /* Loop and generate invoices */
849:
850: if nvl(ln_threshold_grp_id, 0) = 0 then
851:
852: p_codepath := jai_general_pkg.plot_codepath(19.1, p_codepath); /* 19.1 */
853:
854: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');
855:
856: jai_ap_tds_generation_pkg.maintain_thhold_grps

Line 882: p_codepath := jai_general_pkg.plot_codepath(19.2, p_codepath); /* 19.2 */

878: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
879:
880: else
881:
882: p_codepath := jai_general_pkg.plot_codepath(19.2, p_codepath); /* 19.2 */
883:
884: jai_ap_tds_generation_pkg.maintain_thhold_grps
885: (
886: p_threshold_grp_id => ln_threshold_grp_id,

Line 903: p_codepath := jai_general_pkg.plot_codepath(19.3, p_codepath); /* 19.3 */

899: end if;
900:
901: --Added by Sanjikum for Bug#5131075(4722011)
902: IF p_process_flag = 'E' THEN
903: p_codepath := jai_general_pkg.plot_codepath(19.3, p_codepath); /* 19.3 */
904: goto exit_from_procedure;
905: END IF;
906:
907: /* Generate TDS invoices by taxes under the section */

Line 913: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); /* 20 */

909: c_get_taxes_to_generate_tds
910: (p_invoice_id , cur_rec_section.actual_section_code, lv_generate_all_invoices,
911: ln_exchange_rate, ln_threshold_slab_id_single,'TDS_SECTION') LOOP --rchandan for bug#4428980
912:
913: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); /* 20 */
914:
915:
916: ln_threshold_trx_id := 0;
917: lv_tds_invoice_num := null;

Line 948: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */

944:
945: if p_process_flag = 'E' then
946: fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
947: fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
948: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
949: goto exit_from_procedure;
950: end if;
951:
952: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); /* 22 */

Line 952: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); /* 22 */

948: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
949: goto exit_from_procedure;
950: end if;
951:
952: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); /* 22 */
953:
954: if ln_start_threshold_trx_id is null then
955: ln_start_threshold_trx_id := ln_threshold_trx_id;
956: end if;

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

973:
974: /* bug 7280925. Added by Lakshmi Gopalsami
975: * changed from ln_tmp_tds_amt to ln_tax_amount
976: */
977: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */
978:
979: jai_ap_tds_generation_pkg.maintain_thhold_grps
980: (
981: p_threshold_grp_id => ln_threshold_grp_id,

Line 998: p_codepath := jai_general_pkg.plot_codepath(23.1, p_codepath); /* 23.1 */

994: fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
995:
996: --Added by Sanjikum for Bug#5131075(4722011)
997: IF p_process_flag = 'E' THEN
998: p_codepath := jai_general_pkg.plot_codepath(23.1, p_codepath); /* 23.1 */
999: goto exit_from_procedure;
1000: END IF;
1001:
1002:

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

1016:
1017: ln_no_of_tds_inv_generated := ln_no_of_tds_inv_generated + 2;
1018: /* TDS invoices are always generated in pair */
1019:
1020: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1021: end loop;
1022: /* Loop and generate invoices */
1023:
1024: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */

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

1020: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1021: end loop;
1022: /* Loop and generate invoices */
1023:
1024: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
1025: update jai_ap_tds_inv_taxes
1026: set threshold_grp_id = ln_threshold_grp_id,
1027: threshold_hdr_id = ln_threshold_hdr_id,
1028: threshold_slab_id = ln_threshold_slab_id_after,

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

1032: and actual_section_code = cur_rec_section.actual_section_code;
1033:
1034: if ln_threshold_slab_id_before <> ln_threshold_slab_id_after then
1035: /* Transition in threshold has happened */
1036: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath); /* 26 */
1037:
1038: --4407184
1039: lv_slab_transition_tds_event := 'THRESHOLD TRANSITION(from slab id -' || ln_threshold_slab_id_before ||
1040: 'to slab id - ' || ln_threshold_slab_id_after || ')';

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

1061: if p_process_flag = 'E' then
1062: fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);
1063: fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);
1064:
1065: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
1066: goto exit_from_procedure;
1067: end if;
1068: ln_no_of_tds_inv_generated := ln_no_of_tds_inv_generated + 2;
1069: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */

Line 1069: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */

1065: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
1066: goto exit_from_procedure;
1067: end if;
1068: ln_no_of_tds_inv_generated := ln_no_of_tds_inv_generated + 2;
1069: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
1070: end if;
1071:
1072: p_codepath := jai_general_pkg.plot_codepath(29, p_codepath); /* 29 */
1073: end loop;

Line 1072: p_codepath := jai_general_pkg.plot_codepath(29, p_codepath); /* 29 */

1068: ln_no_of_tds_inv_generated := ln_no_of_tds_inv_generated + 2;
1069: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
1070: end if;
1071:
1072: p_codepath := jai_general_pkg.plot_codepath(29, p_codepath); /* 29 */
1073: end loop;
1074:
1075: /* End Loop through for each tds section and process */
1076:

Line 1077: p_codepath := jai_general_pkg.plot_codepath(30, p_codepath); /* 30 */

1073: end loop;
1074:
1075: /* End Loop through for each tds section and process */
1076:
1077: p_codepath := jai_general_pkg.plot_codepath(30, p_codepath); /* 30 */
1078: /* Check if any non-TDS Section taxes are applicable and generate invoices if required. */
1079: for cur_non_tds_rec in c_get_non_tds_section_tax(p_invoice_id, ln_exchange_rate,'TDS_SECTION') LOOP --rchandan for bug#4428980
1080:
1081: p_codepath := jai_general_pkg.plot_codepath(31, p_codepath); /* 31 */

Line 1081: p_codepath := jai_general_pkg.plot_codepath(31, p_codepath); /* 31 */

1077: p_codepath := jai_general_pkg.plot_codepath(30, p_codepath); /* 30 */
1078: /* Check if any non-TDS Section taxes are applicable and generate invoices if required. */
1079: for cur_non_tds_rec in c_get_non_tds_section_tax(p_invoice_id, ln_exchange_rate,'TDS_SECTION') LOOP --rchandan for bug#4428980
1080:
1081: p_codepath := jai_general_pkg.plot_codepath(31, p_codepath); /* 31 */
1082: ln_threshold_trx_id := null;
1083: lv_tds_invoice_num := null;
1084: lv_tds_cm_num := null;
1085: p_process_flag := null;

Line 1114: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */

1110: if p_process_flag = 'E' then
1111: fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);
1112: fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);
1113:
1114: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
1115: goto exit_from_procedure;
1116: end if;
1117:
1118: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath); /* 33 */

Line 1118: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath); /* 33 */

1114: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
1115: goto exit_from_procedure;
1116: end if;
1117:
1118: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath); /* 33 */
1119:
1120: if ln_start_threshold_trx_id is null then
1121: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath); /* 34 */
1122: ln_start_threshold_trx_id := ln_threshold_trx_id;

Line 1121: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath); /* 34 */

1117:
1118: p_codepath := jai_general_pkg.plot_codepath(33, p_codepath); /* 33 */
1119:
1120: if ln_start_threshold_trx_id is null then
1121: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath); /* 34 */
1122: ln_start_threshold_trx_id := ln_threshold_trx_id;
1123: end if;
1124:
1125: fnd_file.put_line(FND_FILE.LOG, '34. Start thhold trx id '|| ln_start_threshold_trx_id);

Line 1138: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath); /* 35 */

1134:
1135: end loop; /* cur_non_tds_rec */
1136:
1137:
1138: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath); /* 35 */
1139:
1140:
1141: /* If the process is called from batch do not fire import request */
1142:

Line 1148: p_codepath := jai_general_pkg.plot_codepath(36, p_codepath); /* 36 */

1144:
1145: if p_call_from <> 'BATCH' then
1146: /* Not Called from Batch */
1147:
1148: p_codepath := jai_general_pkg.plot_codepath(36, p_codepath); /* 36 */
1149:
1150: if ln_start_threshold_trx_id is not null then
1151:
1152: fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '||

Line 1155: p_codepath := jai_general_pkg.plot_codepath(37, p_codepath); /* 37 */

1151:
1152: fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '||
1153: ln_start_threshold_trx_id);
1154:
1155: p_codepath := jai_general_pkg.plot_codepath(37, p_codepath); /* 37 */
1156: import_and_approve
1157: (
1158: p_invoice_id => p_invoice_id,
1159: p_start_thhold_trx_id => ln_start_threshold_trx_id,

Line 1170: p_codepath := jai_general_pkg.plot_codepath(37.1, p_codepath); /* 37.1 */

1166: fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);
1167:
1168: --Added by Sanjikum for Bug#5131075(4722011)
1169: IF p_process_flag = 'E' THEN
1170: p_codepath := jai_general_pkg.plot_codepath(37.1, p_codepath); /* 37.1 */
1171: goto exit_from_procedure;
1172: END IF;
1173:
1174: end if; /* if ln_no_of_tds_inv_generated > 0 then */

Line 1179: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath); /* 100 */

1175:
1176: end if; /* p_call_from <> 'BATCH' then */
1177:
1178: <>
1179: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath); /* 100 */
1180: return;
1181:
1182: exception
1183: when others then

Line 2658: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.maintain_thhold_grps', 'START'); /* 1 */

2654:
2655:
2656: begin
2657:
2658: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.maintain_thhold_grps', 'START'); /* 1 */
2659:
2660:
2661: /* Validate the input */
2662: ln_threshold_grp_id := nvl(p_threshold_grp_id, 0);

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

2662: ln_threshold_grp_id := nvl(p_threshold_grp_id, 0);
2663:
2664: if ln_threshold_grp_id = 0 then
2665:
2666: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /*2*/
2667:
2668: if p_vendor_id is null then
2669: p_process_flag := 'E';
2670: P_process_message := 'Vendor must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

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

2702: end if;
2703:
2704: end if; /* Validate the input */
2705:
2706: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /*3*/
2707:
2708: if ln_threshold_grp_id = 0 then
2709:
2710: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

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

2706: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /*3*/
2707:
2708: if ln_threshold_grp_id = 0 then
2709:
2710: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
2711: /* Threshold has not been given as an input, check if exists */
2712: open c_get_threshold_grp_id
2713: (p_vendor_id, p_org_tan_num, p_vendor_pan_num, p_section_type, p_section_code, p_fin_year);
2714: fetch c_get_threshold_grp_id into ln_threshold_grp_id;

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

2715: close c_get_threshold_grp_id;
2716:
2717: if nvl(ln_threshold_grp_id, 0) = 0 then
2718:
2719: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2720:
2721: insert into jai_ap_tds_thhold_grps
2722: (
2723: threshold_grp_id ,

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

2753: p_threshold_grp_id := ln_threshold_grp_id;
2754:
2755: end if; /* ln_threshold_grp_id does not exist */
2756:
2757: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2758:
2759: end if; /* ln_threshold_grp_id is not given as an input */
2760:
2761: /* Get the old value of teh threshold group */

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

2758:
2759: end if; /* ln_threshold_grp_id is not given as an input */
2760:
2761: /* Get the old value of teh threshold group */
2762: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:

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

2806: END IF;
2807: END IF;
2808: -- End if ;
2809:
2810: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2811: update jai_ap_tds_thhold_grps
2812: set
2813: total_invoice_amount = nvl(total_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0),
2814: total_invoice_cancel_amount = nvl(total_invoice_cancel_amount, 0) + nvl(p_trx_invoice_cancel_amount, 0),

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

2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:
2838: /* Insert into the audite table */
2839: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2840: insert into jai_ap_tds_thgrp_audits
2841: (
2842: threshold_grp_audit_id ,
2843: threshold_grp_id ,

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

2909: sysdate ,
2910: fnd_global.login_id
2911: )
2912: returning threshold_grp_audit_id into p_threshold_grp_audit_id;
2913: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2914: <>
2915:
2916: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 1 */
2917: return;

Line 2916: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 1 */

2912: returning threshold_grp_audit_id into p_threshold_grp_audit_id;
2913: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2914: <>
2915:
2916: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 1 */
2917: return;
2918:
2919: exception
2920: when others then