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_DTC_GENERATION_PKG dependencies on FND_FILE

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

1263: open c_check_not_validate(p_invoice_id, lv_section_type); -- Harshita, added lv_section_type for Bug 4870243
1264: fetch c_check_not_validate into ln_total_count, ln_validated_a_cnt, ln_validated_t_cnt;
1265: close c_check_not_validate;
1266:
1267: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
1268:
1269: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
1270: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
1271:

Line 1269: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);

1265: close c_check_not_validate;
1266:
1267: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
1268:
1269: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
1270: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
1271:
1272: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1273:

Line 1270: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);

1266:
1267: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
1268:
1269: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
1270: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
1271:
1272: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1273:
1274: if ln_total_count = (ln_validated_a_cnt + ln_validated_t_cnt) then

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

1297: end if;
1298:
1299: end if;
1300:
1301: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
1302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
1303:
1304: << exit_from_procedure >>
1305: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath, null, 'END'); /* 7 */

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

2095:
2096: exception
2097: when others then
2098:
2099: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));
2100: p_process_flag := 'E';
2101: p_process_message := 'Error from jai_ap_dtc_generation_pkg.maintain_thhold_grps :' || sqlerrm;
2102: end maintain_thhold_grps;
2103:

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

3256: , 'Check for tax count ' || ln_count
3257: );
3258: END IF; --( ln_proc_level >= ln_dbg_level) ;
3259:
3260: --fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);
3261:
3262: /*if nvl(ln_count, 0) = 0 then
3263: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); \* 2 *\
3264: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');

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

3260: --fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);
3261:
3262: /*if nvl(ln_count, 0) = 0 then
3263: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); \* 2 *\
3264: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');
3265: p_process_flag := 'X';
3266: p_process_message := ' TDS tax is not applicable';
3267: goto exit_from_procedure;
3268: end if;*/

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

3282: , 'Check for processed already ' || ln_cnt_already_processed
3283: );
3284: END IF; --( ln_proc_level >= ln_dbg_level) ;
3285:
3286: --fnd_file.put_line(FND_FILE.LOG, '3. Check for processed already '|| ln_cnt_already_processed);
3287:
3288: if nvl(ln_cnt_already_processed, 0) > 0 then
3289: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
3290: p_process_flag := 'X';

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

3486: , '20 Process message ' || p_process_message
3487: );
3488: END IF; --( ln_proc_level >= ln_dbg_level) ;
3489:
3490: --fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
3491: --fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
3492: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3493: goto exit_from_procedure;
3494: end if;

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

3487: );
3488: END IF; --( ln_proc_level >= ln_dbg_level) ;
3489:
3490: --fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
3491: --fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
3492: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3493: goto exit_from_procedure;
3494: end if;
3495: --Call defaulting logic (default_tds_from_setup) with P_REDEFAULT_SECTION_CODE = 'Y' and P_REDEFAULT_TAX_CATEGORY = 'Y'.

Line 3519: --fnd_file.put_line(FND_FILE.LOG, '21 Process flag '|| p_process_flag);

3515: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3516: , '21 Process message ' || p_process_message
3517: );
3518: END IF; --( ln_proc_level >= ln_dbg_level) ;
3519: --fnd_file.put_line(FND_FILE.LOG, '21 Process flag '|| p_process_flag);
3520: --fnd_file.put_line(FND_FILE.LOG, '21 Process message '|| p_process_message);
3521: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3522: goto exit_from_procedure;
3523: end if;

Line 3520: --fnd_file.put_line(FND_FILE.LOG, '21 Process message '|| p_process_message);

3516: , '21 Process message ' || p_process_message
3517: );
3518: END IF; --( ln_proc_level >= ln_dbg_level) ;
3519: --fnd_file.put_line(FND_FILE.LOG, '21 Process flag '|| p_process_flag);
3520: --fnd_file.put_line(FND_FILE.LOG, '21 Process message '|| p_process_message);
3521: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3522: goto exit_from_procedure;
3523: end if;
3524: --Call defaulting logic (default_tds_from_setup) with P_REDEFAULT_SECTION_CODE = 'N' and P_REDEFAULT_TAX_CATEGORY = 'Y'.

Line 3567: --fnd_file.put_line(FND_FILE.LOG, '22 Process flag '|| p_process_flag);

3563: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3564: , '22 Process message ' || p_process_message
3565: );
3566: END IF; --( ln_proc_level >= ln_dbg_level) ;
3567: --fnd_file.put_line(FND_FILE.LOG, '22 Process flag '|| p_process_flag);
3568: --fnd_file.put_line(FND_FILE.LOG, '22 Process message '|| p_process_message);
3569: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3570: goto exit_from_procedure;
3571: end if;

Line 3568: --fnd_file.put_line(FND_FILE.LOG, '22 Process message '|| p_process_message);

3564: , '22 Process message ' || p_process_message
3565: );
3566: END IF; --( ln_proc_level >= ln_dbg_level) ;
3567: --fnd_file.put_line(FND_FILE.LOG, '22 Process flag '|| p_process_flag);
3568: --fnd_file.put_line(FND_FILE.LOG, '22 Process message '|| p_process_message);
3569: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3570: goto exit_from_procedure;
3571: end if;
3572: --Call defaulting logic (default_tds_from_setup) with P_REDEFAULT_SECTION_CODE = 'Y' and P_REDEFAULT_TAX_CATEGORY = 'Y'.

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

3592: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3593: , '23 Process message ' || p_process_message
3594: );
3595: END IF; --( ln_proc_level >= ln_dbg_level) ;
3596: --fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
3597: --fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
3598: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3599: goto exit_from_procedure;
3600: end if;

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

3593: , '23 Process message ' || p_process_message
3594: );
3595: END IF; --( ln_proc_level >= ln_dbg_level) ;
3596: --fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
3597: --fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
3598: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
3599: goto exit_from_procedure;
3600: end if;
3601: --Call defaulting logic (default_tds_from_setup) with P_REDEFAULT_SECTION_CODE = 'N' and P_REDEFAULT_TAX_CATEGORY = 'Y'.

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

3957: );
3958:
3959: END IF; --( ln_proc_level >= ln_dbg_level) ;
3960:
3961: --fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
3962:
3963:
3964:
3965: lv_attr_code := 'TDS_CALENDAR';--'TAN NO';--Update by Zhiwei Hou on 20120111

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

3982: );
3983: END IF; --( ln_proc_level >= ln_dbg_level) ;
3984:
3985:
3986: --fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
3987:
3988: --fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
3989:
3990: /* Get the fin year */

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

3984:
3985:
3986: --fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
3987:
3988: --fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
3989:
3990: /* Get the fin year */
3991: open c_get_fin_year(p_accounting_date, p_org_id);
3992: fetch c_get_fin_year into ln_fin_year;

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

4000: , ' 8.2 Fin Year -> ' || ln_fin_year
4001: );
4002:
4003: END IF; --( ln_proc_level >= ln_dbg_level) ;
4004: --fnd_file.put_line(FND_FILE.LOG,' 8.2 Fin Year -> '|| ln_fin_year);
4005:
4006:
4007:
4008: FOR r_section_cod IN c_get_section_codes

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

4101: if nvl(ln_threshold_grp_id, 0) = 0 then
4102:
4103: p_codepath := jai_general_pkg.plot_codepath(19.1, p_codepath); /* 19.1 */
4104:
4105: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');
4106:
4107: if (ln_exception_flag = 'Y') then
4108: ln_hdr_id := ln_threshold_hdr_id;
4109: else

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

4150: , ' 19.1 Process message -> ' || p_process_message
4151: );
4152: END IF; --( ln_proc_level >= ln_dbg_level) ;
4153:
4154: --fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
4155: --fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
4156:
4157: else
4158:

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

4151: );
4152: END IF; --( ln_proc_level >= ln_dbg_level) ;
4153:
4154: --fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
4155: --fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
4156:
4157: else
4158:
4159: p_codepath := jai_general_pkg.plot_codepath(19.2, p_codepath); /* 19.2 */

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

4180: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4181: , ' 19.2 Process message -> ' || p_process_message
4182: );
4183: END IF; --( ln_proc_level >= ln_dbg_level) ;
4184: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
4185: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
4186:
4187:
4188: end if;

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

4181: , ' 19.2 Process message -> ' || p_process_message
4182: );
4183: END IF; --( ln_proc_level >= ln_dbg_level) ;
4184: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
4185: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
4186:
4187:
4188: end if;
4189:

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

4210: , ' 9 Threshold hdr id -> ' || ln_threshold_hdr_id
4211: );
4212:
4213: END IF; --( ln_proc_level >= ln_dbg_level) ;
4214: --fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);
4215:
4216:
4217: /* Get the threshold group id */
4218: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

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

4269: , '11. Threshold grp id ->' || ln_threshold_grp_id
4270: );
4271:
4272: END IF; --( ln_proc_level >= ln_dbg_level) ;
4273: --fnd_file.put_line(FND_FILE.LOG, '11. Threshold grp id ->'||ln_threshold_grp_id);
4274:
4275: /* Get the threshold group details */
4276: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
4277:

Line 4306: --fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||ln_total_invoice_amount);

4302: , '12. Total invoice amount -> ' || ln_total_invoice_amount
4303: );
4304:
4305: END IF; --( ln_proc_level >= ln_dbg_level) ;
4306: --fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||ln_total_invoice_amount);
4307:
4308: /* Get the threshold position before this invoice impact */
4309: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
4310:

Line 4359: --fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||ln_threshold_slab_id_before);

4355: , '15. Threshold slab id before ' || ln_threshold_slab_id_before
4356: );
4357:
4358: END IF; --( ln_proc_level >= ln_dbg_level) ;
4359: --fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||ln_threshold_slab_id_before);
4360:
4361: /* Get the threshold position after this invoice impact */
4362: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
4363:

Line 4423: --fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'|| ln_threshold_slab_id_after);

4419: , '15. Threshold slab id after ' || ln_threshold_slab_id_after
4420: );
4421:
4422: END IF; --( ln_proc_level >= ln_dbg_level) ;
4423: --fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'|| ln_threshold_slab_id_after);
4424:
4425: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
4426:
4427: if ln_threshold_slab_id_after <> 0 then

Line 4444: --fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' || lv_generate_all_invoices);

4440: , '19. Generate invoices -> ' || lv_generate_all_invoices
4441: );
4442:
4443: END IF; --( ln_proc_level >= ln_dbg_level) ;
4444: --fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' || lv_generate_all_invoices);
4445:
4446:
4447: /* Check for Single Invoice threshold if cumulative has not been reached */
4448: if lv_generate_all_invoices = 'N' then

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

4537: , ' Tax amount while calling generate tds invoices ' || cur_rec.tax_amount
4538: );
4539: END IF; --( ln_proc_level >= ln_dbg_level) ;
4540:
4541: --fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
4542:
4543: --fnd_file.put_line(FND_FILE.LOG, ' Tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
4544:
4545: jai_ap_dtc_generation_pkg.generate_dtc_invoices

Line 4543: --fnd_file.put_line(FND_FILE.LOG, ' Tax amount while calling generate tds invoices '|| cur_rec.tax_amount);

4539: END IF; --( ln_proc_level >= ln_dbg_level) ;
4540:
4541: --fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
4542:
4543: --fnd_file.put_line(FND_FILE.LOG, ' Tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
4544:
4545: jai_ap_dtc_generation_pkg.generate_dtc_invoices
4546:
4547: (

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

4577: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4578: , '20 Process message ' || p_process_message
4579: );
4580: END IF; --( ln_proc_level >= ln_dbg_level) ;
4581: --fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
4582: --fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
4583: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
4584: goto exit_from_procedure;
4585: end if;

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

4578: , '20 Process message ' || p_process_message
4579: );
4580: END IF; --( ln_proc_level >= ln_dbg_level) ;
4581: --fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
4582: --fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
4583: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
4584: goto exit_from_procedure;
4585: end if;
4586:

Line 4604: --fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||ln_start_threshold_trx_id);

4600: );
4601:
4602: END IF; --( ln_proc_level >= ln_dbg_level) ;
4603:
4604: --fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||ln_start_threshold_trx_id);
4605:
4606: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);
4607:
4608: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */

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

4602: END IF; --( ln_proc_level >= ln_dbg_level) ;
4603:
4604: --fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||ln_start_threshold_trx_id);
4605:
4606: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);
4607:
4608: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */
4609:
4610: jai_ap_dtc_generation_pkg.maintain_thhold_grps

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

4631: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4632: , '23 Process message ' || p_process_message
4633: );
4634: END IF; --( ln_proc_level >= ln_dbg_level) ;
4635: --fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
4636: --fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
4637:
4638: --Added by Sanjikum for Bug#5131075(4722011)
4639: IF p_process_flag = 'E' THEN

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

4632: , '23 Process message ' || p_process_message
4633: );
4634: END IF; --( ln_proc_level >= ln_dbg_level) ;
4635: --fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
4636: --fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
4637:
4638: --Added by Sanjikum for Bug#5131075(4722011)
4639: IF p_process_flag = 'E' THEN
4640: p_codepath := jai_general_pkg.plot_codepath(23.1, p_codepath); /* 23.1 */

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

4747: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4748: , '26. Event is ' || lv_slab_transition_tds_event
4749: );
4750: END IF; --( ln_proc_level >= ln_dbg_level) ;
4751: --fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
4752: --fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
4753:
4754:
4755: --Commented by Zhiwei Hou on 20120302 for bug#13720981 begin

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

4748: , '26. Event is ' || lv_slab_transition_tds_event
4749: );
4750: END IF; --( ln_proc_level >= ln_dbg_level) ;
4751: --fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
4752: --fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
4753:
4754:
4755: --Commented by Zhiwei Hou on 20120302 for bug#13720981 begin
4756: --------------------------------------------------------------

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

4823: , '27 Process message ' || p_process_message
4824: );
4825: END IF; --( ln_proc_level >= ln_dbg_level) ;
4826:
4827: --fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);
4828: --fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);
4829:
4830: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
4831: goto exit_from_procedure;

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

4824: );
4825: END IF; --( ln_proc_level >= ln_dbg_level) ;
4826:
4827: --fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);
4828: --fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);
4829:
4830: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
4831: goto exit_from_procedure;
4832: end if;

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

4907: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4908: , ' WCT Tax amt ' || cur_non_tds_rec.tax_amount
4909: );
4910: END IF; --( ln_proc_level >= ln_dbg_level) ;
4911: --fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
4912:
4913: --fnd_file.put_line(FND_FILE.LOG, ' WCT Tax amt '||cur_non_tds_rec.tax_amount);
4914:
4915:

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

4909: );
4910: END IF; --( ln_proc_level >= ln_dbg_level) ;
4911: --fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
4912:
4913: --fnd_file.put_line(FND_FILE.LOG, ' WCT Tax amt '||cur_non_tds_rec.tax_amount);
4914:
4915:
4916:
4917:

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

4978: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4979: , '31 Process message ' || p_process_message
4980: );
4981: END IF; --( ln_proc_level >= ln_dbg_level) ;
4982: --fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);
4983: --fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);
4984:
4985: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
4986: goto exit_from_procedure;

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

4979: , '31 Process message ' || p_process_message
4980: );
4981: END IF; --( ln_proc_level >= ln_dbg_level) ;
4982: --fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);
4983: --fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);
4984:
4985: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
4986: goto exit_from_procedure;
4987: end if;

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

5000: , '34. Start thhold trx id ' || ln_start_threshold_trx_id
5001: );
5002:
5003: END IF; --( ln_proc_level >= ln_dbg_level) ;
5004: --fnd_file.put_line(FND_FILE.LOG, '34. Start thhold trx id '|| ln_start_threshold_trx_id);
5005:
5006: /* Punch threshold_trx_id in jai_ap_tds_inv_taxes */
5007: update jai_ap_tds_inv_taxes
5008: set threshold_trx_id = ln_threshold_trx_id,

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

5030: , '35. called from ' || p_call_from
5031: );
5032:
5033: END IF; --( ln_proc_level >= ln_dbg_level) ;
5034: --fnd_file.put_line(FND_FILE.LOG, '35. called from '|| p_call_from);
5035:
5036: IF p_call_from <> 'BATCH' THEN
5037: /* Not Called from Batch */
5038:

Line 5051: --fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '|| ln_start_threshold_trx_id);

5047: , '36 start thhold trx id ' || ln_start_threshold_trx_id
5048: );
5049:
5050: END IF; --( ln_proc_level >= ln_dbg_level) ;
5051: --fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '|| ln_start_threshold_trx_id);
5052:
5053: p_codepath := jai_general_pkg.plot_codepath(37, p_codepath); /* 37 */
5054: import_and_approve
5055: (

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

5070: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5071: , '37 Process message ' || p_process_message
5072: );
5073: END IF; --( ln_proc_level >= ln_dbg_level) ;
5074: --fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
5075: --fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);
5076:
5077: --Added by Sanjikum for Bug#5131075(4722011)
5078: IF p_process_flag = 'E' THEN

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

5071: , '37 Process message ' || p_process_message
5072: );
5073: END IF; --( ln_proc_level >= ln_dbg_level) ;
5074: --fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
5075: --fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);
5076:
5077: --Added by Sanjikum for Bug#5131075(4722011)
5078: IF p_process_flag = 'E' THEN
5079: p_codepath := jai_general_pkg.plot_codepath(37.1, p_codepath); /* 37.1 */

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

6279: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
6280: ('PREPAYMENT UNAPPLICATION')
6281: THEN
6282: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
6283: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
6284: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6285: /* Bug 7280925. Added by Lakshmi Gopalsami
6286: * we should not round for WCT and ESSI. For those threshold_grp_id
6287: * will be null

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

6288: */
6289: and pn_threshold_grp_id is not null
6290: THEN
6291: ln_invoice_to_tds_amount := get_rnded_value(ln_invoice_to_tds_amount);
6292: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);
6293: END IF;
6294: END IF ; -- pv_tds_event not in
6295:
6296: -- End for Bug 5722028

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

6409: END IF; --2
6410: END IF;
6411:
6412:
6413: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
6414: /*IF trunc(pd_creation_date) >=
6415: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6416: and pn_threshold_grp_id is not null
6417: THEN

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

6415: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6416: and pn_threshold_grp_id is not null
6417: THEN
6418: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
6419: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);
6420: END IF; */ --commented by bgowrava for Bug#8995604
6421:
6422:
6423: if upper(r_ap_invoices_all.exchange_rate_type) = 'USER' then

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

6425: else
6426: ln_exchange_rate := null;
6427: end if;
6428:
6429: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
6430:
6431: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
6432: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
6433: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default

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

6512: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective
6513: * of the tds event.
6514: */
6515:
6516: Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);
6517: /*IF pn_taxable_amount IS NOT NULL THEN
6518: ln_invoice_amount := pn_taxable_amount;
6519: ELSE*/ /*Commented the above if condition for bug 13070779 */
6520: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);

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

6518: ln_invoice_amount := pn_taxable_amount;
6519: ELSE*/ /*Commented the above if condition for bug 13070779 */
6520: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);
6521: -- END IF;
6522: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6523:
6524: /* For downward compatibility with the pre-cleanup code */
6525: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then
6526:

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

6536: ELSIF r_ja_in_tax_codes.section_type = 'ESSI_SECTION' THEN
6537: lv_source_attribute := 'ATTRIBUTE3';
6538: END IF;
6539:
6540: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);

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

6537: lv_source_attribute := 'ATTRIBUTE3';
6538: END IF;
6539:
6540: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

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

6538: END IF;
6539:
6540: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

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

6539:
6540: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);

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

6540: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);

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

6541: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

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

6542: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

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

6543: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:

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

6544: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);

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

6545: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);

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

6546: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
6547: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);

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

6639: and pn_threshold_grp_id is not null )
6640: THEN
6641: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
6642: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
6643: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
6644: END IF;
6645: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
6646: END IF ;
6647: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

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

6643: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
6644: END IF;
6645: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
6646: END IF ;
6647: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);
6648:
6649: END IF;
6650: -- End for bug 5722028.
6651:

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

7287: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
7288: ('PREPAYMENT UNAPPLICATION')
7289: THEN
7290: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
7291: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
7292: IF trunc(pd_creation_date) >= trunc(jai_ap_dtc_generation_pkg.gd_tds_rounding_effective_date)
7293: /* Bug 7280925. Added by Lakshmi Gopalsami
7294: * we should not round for WCT and ESSI. For those threshold_grp_id
7295: * will be null

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

7305: , 'value after round per setup TDS auth inv' || ln_invoice_to_tds_amount
7306: );
7307:
7308: END IF; --( ln_proc_level >= ln_dbg_level) ;
7309: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);
7310: END IF;
7311: END IF ; -- pv_tds_event not in
7312:
7313: -- End for Bug 5722028

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

7376: , ' CALL utils for inserting interface lines' || ''
7377: );
7378:
7379: END IF; --( ln_proc_level >= ln_dbg_level) ;
7380: --fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
7381:
7382: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
7383: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
7384: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default

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

7678: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective
7679: * of the tds event.
7680: */
7681:
7682: --Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);
7683: /*IF pn_taxable_amount IS NOT NULL THEN
7684: ln_invoice_amount := pn_taxable_amount;
7685: ELSE*/ /*Commented the above if condition for bug 13070779 */
7686: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);

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

7684: ln_invoice_amount := pn_taxable_amount;
7685: ELSE*/ /*Commented the above if condition for bug 13070779 */
7686: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);
7687: -- END IF;
7688: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7689: IF ( ln_proc_level >= ln_dbg_level)
7690: THEN
7691:
7692: FND_LOG.STRING ( ln_proc_level

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

7747: , ' sec code ' || pv_section_code
7748: );
7749:
7750: END IF; --( ln_proc_level >= ln_dbg_level) ;
7751: --fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);

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

7748: );
7749:
7750: END IF; --( ln_proc_level >= ln_dbg_level) ;
7751: --fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

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

7749:
7750: END IF; --( ln_proc_level >= ln_dbg_level) ;
7751: --fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

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

7750: END IF; --( ln_proc_level >= ln_dbg_level) ;
7751: --fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);

Line 7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);

7751: --fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);

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

7752: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

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

7753: --fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

Line 7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);

7754: --fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
7762:

Line 7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);

7755: --fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_category_id);
7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
7762:
7763: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019

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

7756: --fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
7762:
7763: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
7764: insert into JAI_AP_TDS_INVOICES

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

7757: --fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
7758: --fnd_file.put_line(FND_FILE.LOG, 'sec code '||pv_section_code);
7759: --fnd_file.put_line(FND_FILE.LOG, 'stformtype '||lv_stform_type);
7760: --fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
7761: --fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
7762:
7763: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
7764: insert into JAI_AP_TDS_INVOICES
7765: (TDS_INVOICE_ID,

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

7841: and pn_threshold_grp_id is not null )
7842: THEN
7843: ln_tds_rnding_factor := jai_ap_dtc_generation_pkg.gn_tds_rounding_factor;
7844: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
7845: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
7846: END IF;
7847: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
7848: END IF ;
7849: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

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

7845: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
7846: END IF;
7847: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
7848: END IF ;
7849: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);
7850:
7851: END IF;
7852: -- End for bug 5722028.
7853:

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

8002:
8003: begin
8004: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8005: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'p_tds_event='||p_tds_event);
8006: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);
8007: --Added by Sanjikum for Bug#5131075(4722011)
8008: IF p_tds_event = 'PREPAYMENT APPLICATION' OR p_tds_event = 'PREPAYMENT UNAPPLICATION' THEN
8009: lv_group_id := to_char(p_invoice_id)||p_tds_event;
8010: ELSE

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

8242:
8243: begin
8244: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8245: /* Check for the status of the import request */
8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

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

8243: begin
8244: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8245: /* Check for the status of the import request */
8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
8251: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);

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

8244: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8245: /* Check for the status of the import request */
8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
8251: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
8252:

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

8245: /* Check for the status of the import request */
8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
8251: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
8252:
8253: /*Comment for TDS bug#15915537 Performance ER on 26-Nov-2012 by Qimeng begin

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

8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
8251: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
8252:
8253: /*Comment for TDS bug#15915537 Performance ER on 26-Nov-2012 by Qimeng begin
8254: lb_request_status :=

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

8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
8251: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
8252:
8253: /*Comment for TDS bug#15915537 Performance ER on 26-Nov-2012 by Qimeng begin
8254: lb_request_status :=
8255: fnd_concurrent.wait_for_request

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

8266:
8267:
8268: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
8269:
8270: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
8271: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
8272: retcode := 1;
8273: errbuf := 'Exiting with warnings as parent request not completed with normal status';
8274: goto exit_from_procedure;

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

8267:
8268: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
8269:
8270: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
8271: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
8272: retcode := 1;
8273: errbuf := 'Exiting with warnings as parent request not completed with normal status';
8274: goto exit_from_procedure;
8275:

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

8276: end if;
8277: Comment for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng end*/
8278:
8279: /* Control comes here only when the concurrent request has completed with Normal Status */
8280: Fnd_File.put_line(Fnd_File.LOG, 'Before Loop ');
8281:
8282: /* Get all the tds invoices that have been created and call the base API to approve it */
8283: for cur_rec in
8284: c_jai_ap_tds_thhold_trxs(p_invoice_id , p_start_thhold_trx_id , p_vendor_id , p_vendor_site_id)

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

8294: the invoice is not existing. Base requires the org_id from the
8295: invoice_id we pass. Ensure that the invoice_id exists before calling approval
8296: */
8297:
8298: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');
8299:
8300: /*Added by nprashar for bug # 6720018*/
8301: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN
8302: lv_conc_flag := 'N';

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

8312: --Bug 6819855. Added by Lakshmi Gopalsami
8313: ln_sob_id;
8314: CLOSE c_jai_chk_tds_inv;
8315:
8316: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || ln_org_id);
8317:
8318:
8319: mo_global.set_policy_context('S', ln_org_id);
8320:

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

8317:
8318:
8319: mo_global.set_policy_context('S', ln_org_id);
8320:
8321: fnd_file.put_line(FND_FILE.LOG,' TDS authority invoice id '
8322: || cur_rec.invoice_to_tds_authority_id);
8323:
8324: /* Invoice to TDS Authority */
8325: /* Bug 6819855. Added by Lakshmi Gopalsami

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

8361: p_org_id => ln_org_id,
8362: p_report_holds_count => ln_holds_count
8363: ) THEN
8364:
8365: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to TDS Authority ' ||
8366: cur_rec.invoice_to_tds_authority_num ||
8367: '(' || cur_rec.invoice_to_tds_authority_id ||
8368: ') Was submitted for Approval.
8369: Holds count ' || ln_holds_count);

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

8391: CLOSE c_jai_chk_tds_inv;
8392:
8393: mo_global.set_policy_context('S', ln_org_id);
8394:
8395: fnd_file.put_line(FND_FILE.LOG,' Supplier credit invoice id '
8396: || cur_rec.invoice_to_vendor_id);
8397: /* Bug 6819855. Added by Lakshmi Gopalsami
8398: Commented the following code and added a call to function batch_approval
8399: ap_approval_pkg.approve

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

8434: p_org_id => ln_org_id,
8435: p_report_holds_count => ln_holds_count1
8436: ) THEN
8437:
8438: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to Supplier for TDS' ||
8439: cur_rec.invoice_to_vendor_num ||
8440: '(' || cur_rec.invoice_to_vendor_id ||
8441: ') Was submitted for Approval.
8442: Holds count ' || ln_holds_count1);

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

8618: is
8619: l_api_name CONSTANT VARCHAR2(50) := 'insert_tds_thhold_trxs()';
8620: begin
8621: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8622: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');
8623:
8624: insert into jai_ap_tds_thhold_trxs
8625: (
8626: threshold_trx_id ,

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

8683: sysdate ,
8684: fnd_global.login_id
8685: );
8686:
8687: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
8688: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
8689: end insert_tds_thhold_trxs;
8690:
8691: /* ******************************** create_tds_after_holds_rel ******************************************* */

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

8790: dev_status => lv_dev_status,
8791: message => lv_message) ;
8792:
8793: IF not ln_req_status THEN
8794: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
8795: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
8796: 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 );
8797: END IF ;
8798:

Line 8796: 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 );

8792:
8793: IF not ln_req_status THEN
8794: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
8795: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
8796: 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 );
8797: END IF ;
8798:
8799: END IF ;
8800:

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

8799: END IF ;
8800:
8801: EXCEPTION
8802: WHEN OTHERS THEN
8803: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
8804: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
8805: 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 );
8806: END;
8807:

Line 8805: 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 );

8801: EXCEPTION
8802: WHEN OTHERS THEN
8803: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
8804: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
8805: 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 );
8806: END;
8807:
8808:
8809: lv_invoice_validation_status :=

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

8819: lv_is_invoice_validated := 'Y';
8820: end if;
8821:
8822: if lv_debug='Y' then
8823: fnd_file.put_line(FND_FILE.LOG, ' value of validate'||lv_is_invoice_validated);
8824: end if ;
8825:
8826: if lv_is_invoice_validated = 'Y' then
8827:

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

8849: );
8850:
8851: --Moved this from below to here by Sanjikum for Bug#5131075(4722011)
8852: if nvl(lv_process_flag, 'N') = 'E' then
8853: fnd_file.put_line(FND_FILE.LOG, ' Error in the concurrent program '|| lv_process_message);
8854: goto exit_from_procedure;
8855: END IF;
8856:
8857: --Start Addition by Sanjikum for Bug#5131075(4722011)

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

8979:
8980: --End Addition by Sanjikum for Bug#5131075(4722011)
8981:
8982: Else
8983: fnd_file.put_line(FND_FILE.LOG,' Not generating the TDS invoice
8984: as the parent invoice is not yet validated');
8985: retcode := 1;
8986: End if; /* lv_is_invoice_validated = 'Y' */
8987:

Line 9271: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_slab_id:[' || p_threshold_slab_id || ']');

9267: ----------------------------------------------------------------------
9268: --Added by Chong for bug#16414088 eTDS ER End
9269:
9270: END IF;
9271: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_slab_id:[' || p_threshold_slab_id || ']');
9272: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_type:[' || p_threshold_type || ']');
9273: --Fnd_File.put_line(Fnd_File.LOG, '**** END of procedure jai_ap_dtc_cancellation_pkg.get_tds_threshold_slab ****');
9274: IF ( ln_proc_level >= ln_dbg_level)
9275: THEN

Line 9272: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_type:[' || p_threshold_type || ']');

9268: --Added by Chong for bug#16414088 eTDS ER End
9269:
9270: END IF;
9271: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_slab_id:[' || p_threshold_slab_id || ']');
9272: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_type:[' || p_threshold_type || ']');
9273: --Fnd_File.put_line(Fnd_File.LOG, '**** END of procedure jai_ap_dtc_cancellation_pkg.get_tds_threshold_slab ****');
9274: IF ( ln_proc_level >= ln_dbg_level)
9275: THEN
9276: FND_LOG.STRING ( ln_proc_level

Line 9273: --Fnd_File.put_line(Fnd_File.LOG, ' END of procedure jai_ap_dtc_cancellation_pkg.get_tds_threshold_slab ');

9269:
9270: END IF;
9271: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_slab_id:[' || p_threshold_slab_id || ']');
9272: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_type:[' || p_threshold_type || ']');
9273: --Fnd_File.put_line(Fnd_File.LOG, '**** END of procedure jai_ap_dtc_cancellation_pkg.get_tds_threshold_slab ****');
9274: IF ( ln_proc_level >= ln_dbg_level)
9275: THEN
9276: FND_LOG.STRING ( ln_proc_level
9277: , GV_MODULE_PREFIX ||'.'|| lv_proc_name

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

10605: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
10606: ('PREPAYMENT UNAPPLICATION')
10607: THEN
10608: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,jai_ap_dtc_generation_pkg.g_inr_currency_rounding);
10609: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
10610: IF trunc(pd_creation_date) >= trunc(jai_ap_dtc_generation_pkg.gd_tds_rounding_effective_date)
10611: /* Bug 7280925. Added by Lakshmi Gopalsami
10612: * we should not round for WCT and ESSI. For those threshold_grp_id
10613: * will be null

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

10623: , 'value after round per setup TDS auth inv' || ln_invoice_to_tds_amount
10624: );
10625:
10626: END IF; --( ln_proc_level >= ln_dbg_level) ;
10627: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);
10628: END IF;
10629: END IF ; -- pv_tds_event not in
10630: if lv_invoice_to_vendor_num is not null and lv_invoice_to_vendor_type is not null then
10631:

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

10687: , ' CALL utils for inserting interface lines' || ''
10688: );
10689:
10690: END IF; --( ln_proc_level >= ln_dbg_level) ;
10691: --fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
10692:
10693: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
10694: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
10695: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default

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

10841: , 'value before round ' || ln_invoice_to_vendor_amount
10842: );
10843:
10844: END IF; --( ln_proc_level >= ln_dbg_level) ;
10845: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
10846:
10847: IF ( ln_proc_level >= ln_dbg_level)
10848: THEN
10849:

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

10852: , ' CALL utils for inserting interface lines' || ''
10853: );
10854:
10855: END IF; --( ln_proc_level >= ln_dbg_level) ;
10856: --fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
10857:
10858: IF NVL(ln_invoice_to_vendor_amount,0) <> 0 THEN
10859:
10860: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice

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

10968: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective
10969: * of the tds event.
10970: */
10971:
10972: --Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);
10973: /*IF pn_taxable_amount IS NOT NULL THEN
10974: ln_invoice_amount := pn_taxable_amount;
10975: ELSE*/ /*Commented the above if condition for bug 13070779 */
10976: -- ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);

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

10974: ln_invoice_amount := pn_taxable_amount;
10975: ELSE*/ /*Commented the above if condition for bug 13070779 */
10976: -- ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);
10977: -- END IF;
10978: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
10979: IF ( ln_proc_level >= ln_dbg_level)
10980: THEN
10981:
10982: FND_LOG.STRING ( ln_proc_level

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

11022: and pn_threshold_grp_id is not null )
11023: THEN
11024: ln_tds_rnding_factor := jai_ap_dtc_generation_pkg.gn_tds_rounding_factor;
11025: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
11026: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
11027: END IF;
11028: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
11029: END IF ;
11030: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

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

11026: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
11027: END IF;
11028: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
11029: END IF ;
11030: --fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);
11031:
11032: END IF;
11033: -- End for bug 5722028.
11034: