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 FND_FILE

Line 297: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);

293: open c_check_not_validate(p_invoice_id, lv_section_type); -- Harshita, added lv_section_type for Bug 4870243
294: fetch c_check_not_validate into ln_total_count, ln_validated_cnt;
295: close c_check_not_validate;
296:
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 */

Line 299: fnd_file.put_line(FND_FILE.LOG, ' Value ofvalidated cnt '|| ln_validated_cnt);

295: close c_check_not_validate;
296:
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

Line 325: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);

321: end if;
322:
323: end if;
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;

Line 582: fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);

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

Line 586: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');

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

Line 597: fnd_file.put_line(FND_FILE.LOG, '3. Check for processed already '|| ln_cnt_already_processed);

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

Line 682: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 value of tax_amount before update'||ln_tax_amount);

678: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
679: ln_tmp_tds_amt := get_rnded_value(ln_tmp_tds_amt);
680: END IF;
681: */
682: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 value of tax_amount before update'||ln_tax_amount);
683: -- End for bug 5722028.
684: /* bug 7280925. Added by Lakshmi Gopalsami
685: * changed from ln_tmp_tds_amt to ln_tax_amount
686: */

Line 703: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);

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:
703: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
704: /* Get Pan number and Tan number for the vendor */
705: open c_get_vendor_pan_tan(p_vendor_id, p_vendor_site_id);
706: fetch c_get_vendor_pan_tan into lv_pan_no, lv_tan_no;
707: close c_get_vendor_pan_tan;

Line 714: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);

710: lv_attr_type_code := 'PRIMARY';
711: lv_tds_regime := 'TDS';
712: lv_regn_type_others := 'OTHERS';
713:
714: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
715:
716: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
717:
718: /* Get the fin year */

Line 716: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);

712: lv_regn_type_others := 'OTHERS';
713:
714: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
715:
716: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
717:
718: /* Get the fin year */
719: open c_get_fin_year(p_accounting_date, p_org_id);
720: fetch c_get_fin_year into ln_fin_year;

Line 723: fnd_file.put_line(FND_FILE.LOG,' 8.2 Fin Year -> '|| ln_fin_year);

719: open c_get_fin_year(p_accounting_date, p_org_id);
720: fetch c_get_fin_year into ln_fin_year;
721: close c_get_fin_year;
722:
723: fnd_file.put_line(FND_FILE.LOG,' 8.2 Fin Year -> '|| ln_fin_year);
724:
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

Line 741: fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);

737: (p_vendor_id , p_vendor_site_id , cur_rec_section.actual_section_code,'TDS_SECTION'); --rchandan for bug#4428980
738: fetch c_get_threshold into ln_threshold_hdr_id;
739: close c_get_threshold;
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

Line 745: fnd_file.put_line(FND_FILE.LOG, '10. Threshold is not defined for the

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');
749: p_process_flag := 'E';

Line 761: fnd_file.put_line(FND_FILE.LOG, '11. Threshold grp id ->'||ln_threshold_grp_id);

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

Line 783: fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||

779: ln_total_invoice_amount := 0;
780:
781: end if;
782:
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 */

Line 794: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||

790: close c_jai_ap_tds_thhold_slabs;
791:
792: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
793:
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 */

Line 822: fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'||

818: close c_check_slabs_end_dated;
819: /*end addition for bug 6345725*/
820:
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

Line 835: fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' ||

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);
837:
838: /* Check for Single Invoice threshold if cumulative has not been reached */
839: if lv_generate_all_invoices = 'N' then

Line 854: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');

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
857: (
858: p_threshold_grp_id => ln_threshold_grp_id,

Line 877: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);

873: P_process_message => P_process_message,
874: p_codepath => p_codepath
875: );
876:
877: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
878: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
879:
880: else
881:

Line 878: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);

874: p_codepath => p_codepath
875: );
876:
877: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
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 */

Line 896: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);

892: P_process_message => P_process_message,
893: p_codepath => p_codepath
894: );
895:
896: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
897: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
898:
899: end if;
900:

Line 897: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);

893: p_codepath => p_codepath
894: );
895:
896: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
897: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
898:
899: end if;
900:
901: --Added by Sanjikum for Bug#5131075(4722011)

Line 921: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );

917: lv_tds_invoice_num := null;
918: lv_tds_cm_num := null;
919: p_process_flag := null;
920:
921: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
922:
923: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
924:
925: jai_ap_tds_generation_pkg.generate_tds_invoices

Line 923: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);

919: p_process_flag := null;
920:
921: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
922:
923: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
924:
925: jai_ap_tds_generation_pkg.generate_tds_invoices
926: (
927: pn_invoice_id => p_invoice_id ,

Line 946: fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);

942: );
943:
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;

Line 947: fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);

943:
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:

Line 958: fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||

954: if ln_start_threshold_trx_id is null then
955: ln_start_threshold_trx_id := ln_threshold_trx_id;
956: end if;
957:
958: fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||
959: ln_start_threshold_trx_id);
960:
961: /* Bug 7280925. Added by Lakshmi Gopalsami -- can be removed
962: * Need to round the value before calling maintain_thhold_grps

Line 970: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);

966: ln_tmp_tds_amt := get_rnded_value(cur_rec.tax_amount);
967: END IF;
968: */
969:
970: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);
971:
972: /* Update the total tax amount for which invoice was raised */
973:
974: /* bug 7280925. Added by Lakshmi Gopalsami

Line 993: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);

989: P_process_message => P_process_message,
990: p_codepath => p_codepath
991: );
992:
993: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
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

Line 994: fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);

990: p_codepath => p_codepath
991: );
992:
993: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
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 */

Line 1042: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');

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 || ')';
1041:
1042: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
1043: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
1044:
1045: process_threshold_transition
1046: (

Line 1043: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);

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 || ')';
1041:
1042: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
1043: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
1044:
1045: process_threshold_transition
1046: (
1047: p_threshold_grp_id => ln_threshold_grp_id,

Line 1062: fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);

1058: p_process_message => p_process_message
1059: );
1060:
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;

Line 1063: fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);

1059: );
1060:
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;

Line 1087: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');

1083: lv_tds_invoice_num := null;
1084: lv_tds_cm_num := null;
1085: p_process_flag := null;
1086:
1087: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
1088:
1089: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);
1090:
1091: jai_ap_tds_generation_pkg.generate_tds_invoices

Line 1089: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);

1085: p_process_flag := null;
1086:
1087: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
1088:
1089: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);
1090:
1091: jai_ap_tds_generation_pkg.generate_tds_invoices
1092: (
1093: pn_invoice_id => p_invoice_id ,

Line 1111: fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);

1107: p_process_message => p_process_message
1108: );
1109:
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;

Line 1112: fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);

1108: );
1109:
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;

Line 1125: fnd_file.put_line(FND_FILE.LOG, '34. Start thhold trx id '|| ln_start_threshold_trx_id);

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);
1126:
1127: /* Punch threshold_trx_id in jai_ap_tds_inv_taxes */
1128: update jai_ap_tds_inv_taxes
1129: set threshold_trx_id = ln_threshold_trx_id,

Line 1143: fnd_file.put_line(FND_FILE.LOG, '35. called from '|| p_call_from);

1139:
1140:
1141: /* If the process is called from batch do not fire import request */
1142:
1143: fnd_file.put_line(FND_FILE.LOG, '35. called from '|| p_call_from);
1144:
1145: if p_call_from <> 'BATCH' then
1146: /* Not Called from Batch */
1147:

Line 1152: fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '||

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 '||
1153: ln_start_threshold_trx_id);
1154:
1155: p_codepath := jai_general_pkg.plot_codepath(37, p_codepath); /* 37 */
1156: import_and_approve

Line 1165: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);

1161: p_process_flag => p_process_flag,
1162: p_process_message => p_process_message
1163: );
1164:
1165: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
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

Line 1166: fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);

1162: p_process_message => p_process_message
1163: );
1164:
1165: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
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 */

Line 1552: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);

1548: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
1549: ('PREPAYMENT UNAPPLICATION')
1550: THEN
1551: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
1552: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
1553: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
1554: /* Bug 7280925. Added by Lakshmi Gopalsami
1555: * we should not round for WCT and ESSI. For those threshold_grp_id
1556: * will be null

Line 1561: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);

1557: */
1558: and pn_threshold_grp_id is not null
1559: THEN
1560: ln_invoice_to_tds_amount := get_rnded_value(ln_invoice_to_tds_amount);
1561: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);
1562: END IF;
1563: END IF ; -- pv_tds_event not in
1564:
1565: -- End for Bug 5722028

Line 1646: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);

1642: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
1643: ELSE
1644: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
1645: end if;
1646: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
1647: IF trunc(pd_creation_date) >=
1648: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
1649: /* Bug 7280925. Added by Lakshmi Gopalsami
1650: * we should not round for WCT and ESSI. For those threshold_grp_id

Line 1656: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);

1652: */
1653: and pn_threshold_grp_id is not null
1654: THEN
1655: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
1656: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);
1657: END IF;
1658: END IF;
1659:
1660: if upper(r_ap_invoices_all.exchange_rate_type) = 'USER' then

Line 1666: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');

1662: else
1663: ln_exchange_rate := null;
1664: end if;
1665:
1666: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
1667:
1668: IF NVL(ln_invoice_to_vendor_amount,0) <> 0 THEN --condition added by bgowrava for bug#4549019
1669: /* Invoices Interface */
1670: jai_ap_utils_pkg.insert_ap_inv_interface

Line 1740: Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);

1736:
1737: /*
1738: || Added the IF-ELSE-ENDIF block by Ramananda for Bug#4562801
1739: */
1740: Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);
1741: IF pn_taxable_amount IS NOT NULL THEN
1742: ln_invoice_amount := pn_taxable_amount;
1743: ELSE
1744: ln_invoice_amount := ABS(round(pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate), 2));

Line 1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);

1751: ELSIF r_ja_in_tax_codes.section_type = 'ESSI_SECTION' THEN
1752: lv_source_attribute := 'ATTRIBUTE3';
1753: END IF;
1754:
1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);

Line 1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);

1752: lv_source_attribute := 'ATTRIBUTE3';
1753: END IF;
1754:
1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

Line 1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);

1753: END IF;
1754:
1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

Line 1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);

1754:
1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);

Line 1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);

1755: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);

Line 1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

1756: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

Line 1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

1757: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

Line 1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);

1758: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
1766:

Line 1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);

1759: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
1766:
1767: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019

Line 1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

1760: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
1766:
1767: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
1768: insert into JAI_AP_TDS_INVOICES

Line 1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

1761: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
1762: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
1763: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
1764: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
1765: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
1766:
1767: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
1768: insert into JAI_AP_TDS_INVOICES
1769: (TDS_INVOICE_ID,

Line 1826: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

1822: ln_tds_rnded_amt := ROUND(pn_tax_amount , g_inr_currency_rounding);
1823: ELSE
1824: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
1825: END IF ;
1826: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);
1827: IF (trunc(pd_creation_date) >=
1828: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
1829: /* Bug 7280925. Added by Lakshmi Gopalsami
1830: * we should not round for WCT and ESSI. For those threshold_grp_id

Line 1837: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);

1833: and pn_threshold_grp_id is not null )
1834: THEN
1835: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
1836: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
1837: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
1838: END IF;
1839: END IF;
1840: -- End for bug 5722028.
1841:

Line 2114: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);

2110: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
2111: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)
2112:
2113: begin
2114: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);
2115: --Added by Sanjikum for Bug#5131075(4722011)
2116: IF p_tds_event = 'PREPAYMENT APPLICATION' OR p_tds_event = 'PREPAYMENT UNAPPLICATION' THEN
2117: lv_group_id := to_char(p_invoice_id)||p_tds_event;
2118: ELSE

Line 2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');

2271:
2272: begin
2273:
2274: /* Check for the status of the import request */
2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

Line 2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);

2272: begin
2273:
2274: /* Check for the status of the import request */
2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);

Line 2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );

2273:
2274: /* Check for the status of the import request */
2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
2281:

Line 2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);

2274: /* Check for the status of the import request */
2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
2281:
2282: lb_request_status :=

Line 2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

2275: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
2281:
2282: lb_request_status :=
2283: fnd_concurrent.wait_for_request

Line 2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);

2276: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
2277: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
2278: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
2279: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
2280: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
2281:
2282: lb_request_status :=
2283: fnd_concurrent.wait_for_request
2284: (

Line 2298: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');

2294:
2295:
2296: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
2297:
2298: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
2299: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
2300: retcode := 1;
2301: errbuf := 'Exiting with warnings as parent request not completed with normal status';
2302: goto exit_from_procedure;

Line 2299: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);

2295:
2296: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
2297:
2298: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
2299: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
2300: retcode := 1;
2301: errbuf := 'Exiting with warnings as parent request not completed with normal status';
2302: goto exit_from_procedure;
2303:

Line 2307: Fnd_File.put_line(Fnd_File.LOG, 'Before Loop ');

2303:
2304: end if;
2305:
2306: /* Control comes here only when the concurrent request has completed with Normal Status */
2307: Fnd_File.put_line(Fnd_File.LOG, 'Before Loop ');
2308:
2309: /* Get all the tds invoices that have been created and call the base API to approve it */
2310: for cur_rec in
2311: c_jai_ap_tds_thhold_trxs(p_invoice_id , p_start_thhold_trx_id , p_vendor_id , p_vendor_site_id)

Line 2325: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');

2321: the invoice is not existing. Base requires the org_id from the
2322: invoice_id we pass. Ensure that the invoice_id exists before calling approval
2323: */
2324:
2325: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');
2326:
2327: /*Added by nprashar for bug # 6720018*/
2328: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN
2329: lv_conc_flag := 'N';

Line 2343: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || ln_org_id);

2339: --Bug 6819855. Added by Lakshmi Gopalsami
2340: ln_sob_id;
2341: CLOSE c_jai_chk_tds_inv;
2342:
2343: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || ln_org_id);
2344:
2345:
2346: mo_global.set_policy_context('S', ln_org_id);
2347:

Line 2348: fnd_file.put_line(FND_FILE.LOG,' TDS authority invoice id '

2344:
2345:
2346: mo_global.set_policy_context('S', ln_org_id);
2347:
2348: fnd_file.put_line(FND_FILE.LOG,' TDS authority invoice id '
2349: || cur_rec.invoice_to_tds_authority_id);
2350:
2351: /* Invoice to TDS Authority */
2352: /* Bug 6819855. Added by Lakshmi Gopalsami

Line 2392: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to TDS Authority ' ||

2388: p_org_id => ln_org_id,
2389: p_report_holds_count => ln_holds_count
2390: ) THEN
2391:
2392: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to TDS Authority ' ||
2393: cur_rec.invoice_to_tds_authority_num ||
2394: '(' || cur_rec.invoice_to_tds_authority_id ||
2395: ') Was submitted for Approval.
2396: Holds count ' || ln_holds_count);

Line 2422: fnd_file.put_line(FND_FILE.LOG,' Supplier credit invoice id '

2418: CLOSE c_jai_chk_tds_inv;
2419:
2420: mo_global.set_policy_context('S', ln_org_id);
2421:
2422: fnd_file.put_line(FND_FILE.LOG,' Supplier credit invoice id '
2423: || cur_rec.invoice_to_vendor_id);
2424: /* Bug 6819855. Added by Lakshmi Gopalsami
2425: Commented the following code and added a call to function batch_approval
2426: ap_approval_pkg.approve

Line 2465: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to Supplier for TDS' ||

2461: p_org_id => ln_org_id,
2462: p_report_holds_count => ln_holds_count1
2463: ) THEN
2464:
2465: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to Supplier for TDS' ||
2466: cur_rec.invoice_to_vendor_num ||
2467: '(' || cur_rec.invoice_to_vendor_id ||
2468: ') Was submitted for Approval.
2469: Holds count ' || ln_holds_count1);

Line 2921: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));

2917: return;
2918:
2919: exception
2920: when others then
2921: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));
2922: p_process_flag := 'E';
2923: p_process_message := 'Error from jai_ap_tds_generation_pkg.maintain_thhold_grps :' || sqlerrm;
2924: end maintain_thhold_grps;
2925:

Line 2957: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');

2953: )
2954: is
2955: begin
2956:
2957: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');
2958:
2959: insert into jai_ap_tds_thhold_trxs
2960: (
2961: threshold_trx_id ,

Line 3022: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');

3018: sysdate ,
3019: fnd_global.login_id
3020: );
3021:
3022: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
3023: end insert_tds_thhold_trxs;
3024:
3025: /* ******************************** create_tds_after_holds_rel ******************************************* */
3026:

Line 3114: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

3110: dev_status => lv_dev_status,
3111: message => lv_message) ;
3112:
3113: IF not ln_req_status THEN
3114: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
3115: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
3116: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
3117: END IF ;
3118:

Line 3116: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );

3112:
3113: IF not ln_req_status THEN
3114: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
3115: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
3116: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
3117: END IF ;
3118:
3119: END IF ;
3120:

Line 3123: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

3119: END IF ;
3120:
3121: EXCEPTION
3122: WHEN OTHERS THEN
3123: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
3124: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
3125: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
3126: END;
3127:

Line 3125: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );

3121: EXCEPTION
3122: WHEN OTHERS THEN
3123: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
3124: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
3125: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
3126: END;
3127:
3128:
3129: lv_invoice_validation_status :=

Line 3143: fnd_file.put_line(FND_FILE.LOG, ' value of validate'||lv_is_invoice_validated);

3139: lv_is_invoice_validated := 'Y';
3140: end if;
3141:
3142: if lv_debug='Y' then
3143: fnd_file.put_line(FND_FILE.LOG, ' value of validate'||lv_is_invoice_validated);
3144: end if ;
3145:
3146: if lv_is_invoice_validated = 'Y' then
3147:

Line 3167: fnd_file.put_line(FND_FILE.LOG, ' Error in the concurrent program '|| lv_process_message);

3163: );
3164:
3165: --Moved this from below to here by Sanjikum for Bug#5131075(4722011)
3166: if nvl(lv_process_flag, 'N') = 'E' then
3167: fnd_file.put_line(FND_FILE.LOG, ' Error in the concurrent program '|| lv_process_message);
3168: goto exit_from_procedure;
3169: END IF;
3170:
3171: --Start Addition by Sanjikum for Bug#5131075(4722011)

Line 3296: fnd_file.put_line(FND_FILE.LOG,' Not generating the TDS invoice

3292:
3293: --End Addition by Sanjikum for Bug#5131075(4722011)
3294:
3295: Else
3296: fnd_file.put_line(FND_FILE.LOG,' Not generating the TDS invoice
3297: as the parent invoice is not yet validated');
3298: retcode := 1;
3299: End if; /* lv_is_invoice_validated = 'Y' */
3300: