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

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

1861: IF v_dev_phase = 'COMPLETE' THEN
1862:
1863: IF v_dev_status <> 'NORMAL' THEN
1864:
1865: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
1866: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
1867: retcode := 1;
1868: errbuf := 'Exiting with warningr as parent request not completed with normal status';
1869: RETURN;

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

1862:
1863: IF v_dev_status <> 'NORMAL' THEN
1864:
1865: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
1866: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
1867: retcode := 1;
1868: errbuf := 'Exiting with warningr as parent request not completed with normal status';
1869: RETURN;
1870:

Line 1906: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');

1902: '', to_char(p_set_of_books_id), '', /*Value N was passed to parameter p_commit_size , set it to NULL for bug # 10049591*/
1903: '' ); -- commit size
1904: exception
1905: when no_data_found then
1906: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');
1907: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );
1908: retcode := 1;
1909: errbuf := 'Exiting with warning as the PLA/BOE invoice to approve has not been imported ';
1910: RETURN;

Line 1907: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );

1903: '' ); -- commit size
1904: exception
1905: when no_data_found then
1906: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');
1907: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );
1908: retcode := 1;
1909: errbuf := 'Exiting with warning as the PLA/BOE invoice to approve has not been imported ';
1910: RETURN;
1911: end;

Line 1918: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');

1914:
1915:
1916: End If;
1917:
1918: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');
1919:
1920: exception
1921: when others then
1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');

Line 1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');

1918: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');
1919:
1920: exception
1921: when others then
1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');
1923: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1924: retcode := 2;
1925: errbuf := SQLERRM;
1926: RETURN;

Line 1923: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1919:
1920: exception
1921: when others then
1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');
1923: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1924: retcode := 2;
1925: errbuf := SQLERRM;
1926: RETURN;
1927: End submit_pla_boe_for_approval;

Line 2015: fnd_file.put_line(FND_FILE.LOG, stemp);

2011: WHILE(length(P_string) >= nlength)
2012: LOOP
2013:
2014: stemp := substrb(P_string, nlength, 80);
2015: fnd_file.put_line(FND_FILE.LOG, stemp);
2016: nlength := (nlength + 80);
2017:
2018: END LOOP;
2019: END IF;

Line 2095: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');

2091: lv_vendor_site_id_updated := '';
2092: lv_thhold_grp_id_updated := '';
2093: lv_thhold_xcep_id_updated := '';
2094:
2095: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');
2096:
2097: ln_request_id := FND_GLOBAL.conc_request_id;
2098:
2099: lv_debug_msg := ' A. Report Parameters';

Line 2457: fnd_file.put_line(FND_FILE.LOG, ' inside procedure ');

2453:
2454: Begin
2455:
2456:
2457: fnd_file.put_line(FND_FILE.LOG, ' inside procedure ');
2458:
2459: lv_base_curr_code := 'INR';
2460:
2461: Begin

Line 2490: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);

2486: Close get_prec;
2487:
2488: End if;
2489:
2490: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2491: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2492:
2493: for Misc_loop in ( select *
2494: from JAI_AP_MATCH_INV_TAXES

Line 2491: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);

2487:
2488: End if;
2489:
2490: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2491: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2492:
2493: for Misc_loop in ( select *
2494: from JAI_AP_MATCH_INV_TAXES
2495: where invoice_id = p_invoice_id

Line 2501: fnd_file.put_line(FND_FILE.LOG,' inside loop -- 2 ' );

2497: )
2498: loop
2499:
2500:
2501: fnd_file.put_line(FND_FILE.LOG,' inside loop -- 2 ' );
2502:
2503: /* For later use if necessary to check the tax type. now education cess will not be
2504: created at invoice level if it is available in PO/Receipt level
2505:

Line 2524: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);

2520: Close get_misc_lines;
2521:
2522: If nvl(p_amount ,0) <> 0 Then
2523:
2524: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);
2525:
2526: If nvl(r_get_misc_lines.amount , 0 ) <> 0 Then
2527:
2528: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);

Line 2528: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);

2524: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);
2525:
2526: If nvl(r_get_misc_lines.amount , 0 ) <> 0 Then
2527:
2528: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);
2529:
2530: IF nvl(p_invoice_price_variance,0 ) <> 0 Then
2531:
2532: ln_tax_ipv := r_get_misc_lines.amount * (nvl(p_invoice_price_variance,0) /p_amount);

Line 2542: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);

2538: ln_tax_erv := r_get_misc_lines.amount * (nvl(p_exchange_rate_variance,0)/p_amount);
2539:
2540: End if;
2541:
2542: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);
2543: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);
2544:
2545: /* IPV */
2546:

Line 2543: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);

2539:
2540: End if;
2541:
2542: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);
2543: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);
2544:
2545: /* IPV */
2546:
2547: If nvl(ln_tax_ipv,0) <> 0 then

Line 2549: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);

2545: /* IPV */
2546:
2547: If nvl(ln_tax_ipv,0) <> 0 then
2548:
2549: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);
2550:
2551: ln_tax_bipv := ln_tax_ipv * nvl(r_get_misc_lines.exchange_rate,1);
2552:
2553: update ap_invoice_distributions_all

Line 2565: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);

2561:
2562:
2563: If nvl(ln_tax_erv,0) <> 0 then
2564:
2565: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2566: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2567:
2568: update ap_invoice_distributions_all
2569: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),

Line 2566: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);

2562:
2563: If nvl(ln_tax_erv,0) <> 0 then
2564:
2565: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2566: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2567:
2568: update ap_invoice_distributions_all
2569: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),
2570: rate_var_code_combination_id = P_rate_var_ccid

Line 2600: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');

2596: Exception
2597: When others then
2598: P_errmsg := SQLERRM;
2599: P_retcode := 2;
2600: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');
2601: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);
2602: End jai_calc_ipv_erv;
2603:
2604: -- added, Harshita for Bug 5553150

Line 2601: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);

2597: When others then
2598: P_errmsg := SQLERRM;
2599: P_retcode := 2;
2600: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');
2601: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);
2602: End jai_calc_ipv_erv;
2603:
2604: -- added, Harshita for Bug 5553150
2605:

Line 4310: Fnd_File.put_line(Fnd_File.LOG,'Please check existence for Old Section code['|| l_line_old ||'].');

4306: fetch chk_section_available into ln_flag_old;
4307: close chk_section_available;
4308:
4309: if( nvl(ln_flag_old,0) = 0 ) then
4310: Fnd_File.put_line(Fnd_File.LOG,'Please check existence for Old Section code['|| l_line_old ||'].');
4311: ln_flag := 0;
4312: end if;
4313:
4314:

Line 4320: Fnd_File.put_line(Fnd_File.LOG,'Please check existence for New Section code['|| l_line_new ||'].');

4316: fetch chk_section_available into ln_flag_new;
4317: close chk_section_available;
4318:
4319: if( nvl(ln_flag_new,0) = 0) then
4320: Fnd_File.put_line(Fnd_File.LOG,'Please check existence for New Section code['|| l_line_new ||'].');
4321: ln_flag := 0;
4322: end if;
4323:
4324: if( ln_flag = 0) then

Line 4357: Fnd_File.put_line(Fnd_File.LOG,'0 rows inserted , Please check files to ensure the Section Code is avaiable in System.');

4353: UTL_FILE.fclose (l_file_old);
4354: UTL_FILE.fclose (l_file_new);
4355:
4356: if(ln_flag = 0)then
4357: Fnd_File.put_line(Fnd_File.LOG,'0 rows inserted , Please check files to ensure the Section Code is avaiable in System.');
4358: rollback;
4359: else
4360: Fnd_File.put_line(Fnd_File.LOG,ln_sum ||' rows inserted ');
4361: commit;

Line 4360: Fnd_File.put_line(Fnd_File.LOG,ln_sum ||' rows inserted ');

4356: if(ln_flag = 0)then
4357: Fnd_File.put_line(Fnd_File.LOG,'0 rows inserted , Please check files to ensure the Section Code is avaiable in System.');
4358: rollback;
4359: else
4360: Fnd_File.put_line(Fnd_File.LOG,ln_sum ||' rows inserted ');
4361: commit;
4362: end if;
4363: WHEN OTHERS THEN
4364: raise lx_ex;

Line 4390: Fnd_File.put_line(Fnd_File.output,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4386: set dtc_section_code = rec_maps.new_section_code
4387: where dtc_section_code = rec_maps.old_section_code;
4388:
4389: update_count_out := SQL%ROWCOUNT;
4390: Fnd_File.put_line(Fnd_File.output,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4391: Fnd_File.put_line(Fnd_File.log,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4392:
4393: end loop;
4394:

Line 4391: Fnd_File.put_line(Fnd_File.log,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4387: where dtc_section_code = rec_maps.old_section_code;
4388:
4389: update_count_out := SQL%ROWCOUNT;
4390: Fnd_File.put_line(Fnd_File.output,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4391: Fnd_File.put_line(Fnd_File.log,'In table JAI_DTC_SCTN_ACCOUNT_MAPPING Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4392:
4393: end loop;
4394:
4395: commit;

Line 4425: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4421: set section_code = rec_maps.new_section_code
4422: where section_code = rec_maps.old_section_code;
4423:
4424: update_count_out := SQL%ROWCOUNT;
4425: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4426: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4427:
4428: end loop;
4429:

Line 4426: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4422: where section_code = rec_maps.old_section_code;
4423:
4424: update_count_out := SQL%ROWCOUNT;
4425: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4426: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_VENDOR_HDRS Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4427:
4428: end loop;
4429:
4430: commit;

Line 4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4456: set actual_section_code = rec_maps.new_section_code
4457: where actual_section_code = rec_maps.old_section_code;
4458:
4459: update_count_out := SQL%ROWCOUNT;
4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4462:
4463: end loop;
4464:

Line 4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);

4457: where actual_section_code = rec_maps.old_section_code;
4458:
4459: update_count_out := SQL%ROWCOUNT;
4460: Fnd_File.put_line(Fnd_File.output,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4461: Fnd_File.put_line(Fnd_File.log,'In table JAI_AP_TDS_INV_TAXES Updated '||update_count_out||' rows for section code '||rec_maps.old_section_code|| ' to '|| rec_maps.new_section_code);
4462:
4463: end loop;
4464:
4465: commit;

Line 4487: Fnd_File.put_line(Fnd_File.LOG,'**Entering dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: '||pv_file_old_name||'; file_new_name: '||pv_file_new_name ||';');

4483: ) IS
4484:
4485: BEGIN
4486:
4487: Fnd_File.put_line(Fnd_File.LOG,'**Entering dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: '||pv_file_old_name||'; file_new_name: '||pv_file_new_name ||';');
4488:
4489: --Process start.
4490: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4491:

Line 4490: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

4486:
4487: Fnd_File.put_line(Fnd_File.LOG,'**Entering dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: '||pv_file_old_name||'; file_new_name: '||pv_file_new_name ||';');
4488:
4489: --Process start.
4490: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4491:
4492: --Step 1, Populate Mapping between Old and new.
4493: Fnd_File.put_line(Fnd_File.LOG,'Step 1 begin: Populate Section Mapping between Old and New.');
4494: populate_section_mapping(

Line 4493: Fnd_File.put_line(Fnd_File.LOG,'Step 1 begin: Populate Section Mapping between Old and New.');

4489: --Process start.
4490: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4491:
4492: --Step 1, Populate Mapping between Old and new.
4493: Fnd_File.put_line(Fnd_File.LOG,'Step 1 begin: Populate Section Mapping between Old and New.');
4494: populate_section_mapping(
4495: pv_file_path => pv_file_path,
4496: pv_file_old_name => pv_file_old_name,
4497: pv_file_new_name => pv_file_new_name

Line 4499: Fnd_File.put_line(Fnd_File.LOG,'Step 1 end.');

4495: pv_file_path => pv_file_path,
4496: pv_file_old_name => pv_file_old_name,
4497: pv_file_new_name => pv_file_new_name
4498: );
4499: Fnd_File.put_line(Fnd_File.LOG,'Step 1 end.');
4500:
4501: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4502: --Step 2, Update Section code for Natural Account mapping.
4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');

Line 4501: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

4497: pv_file_new_name => pv_file_new_name
4498: );
4499: Fnd_File.put_line(Fnd_File.LOG,'Step 1 end.');
4500:
4501: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4502: --Step 2, Update Section code for Natural Account mapping.
4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');
4504: update_natural_sec_mapping;
4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');

Line 4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');

4499: Fnd_File.put_line(Fnd_File.LOG,'Step 1 end.');
4500:
4501: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4502: --Step 2, Update Section code for Natural Account mapping.
4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');
4504: update_natural_sec_mapping;
4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');
4506:
4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

Line 4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');

4501: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4502: --Step 2, Update Section code for Natural Account mapping.
4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');
4504: update_natural_sec_mapping;
4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');
4506:
4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4508: --Step 3, Update Defaulted Section Code for Supplier Site.
4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');

Line 4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

4503: Fnd_File.put_line(Fnd_File.LOG,'Step 2 begin: Update Section Code for Natural Account Mapping.');
4504: update_natural_sec_mapping;
4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');
4506:
4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4508: --Step 3, Update Defaulted Section Code for Supplier Site.
4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');
4510: update_suppl_default_sec;
4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');

Line 4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');

4505: Fnd_File.put_line(Fnd_File.LOG,'Step 2 end.');
4506:
4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4508: --Step 3, Update Defaulted Section Code for Supplier Site.
4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');
4510: update_suppl_default_sec;
4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');
4512:
4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

Line 4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');

4507: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4508: --Step 3, Update Defaulted Section Code for Supplier Site.
4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');
4510: update_suppl_default_sec;
4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');
4512:
4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4514: --Step 4, Update Actual Section Code for Invoice Tax.
4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');

Line 4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

4509: Fnd_File.put_line(Fnd_File.LOG,'Step 3 begin: Update Defaulted Section Code for Supplier Site.');
4510: update_suppl_default_sec;
4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');
4512:
4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4514: --Step 4, Update Actual Section Code for Invoice Tax.
4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');
4516: update_inv_tax_sec;
4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');

Line 4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');

4511: Fnd_File.put_line(Fnd_File.LOG,'Step 3 end.');
4512:
4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4514: --Step 4, Update Actual Section Code for Invoice Tax.
4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');
4516: update_inv_tax_sec;
4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');
4518:
4519: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

Line 4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');

4513: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4514: --Step 4, Update Actual Section Code for Invoice Tax.
4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');
4516: update_inv_tax_sec;
4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');
4518:
4519: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4520: --Process end.
4521: Fnd_File.put_line(Fnd_File.LOG,'**Closing dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: ' ||pv_file_old_name||'; file_new_name: '||pv_file_new_name|| ';');

Line 4519: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');

4515: Fnd_File.put_line(Fnd_File.LOG,'Step 4 begin: Update Actual Section Code for Invoice Tax.');
4516: update_inv_tax_sec;
4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');
4518:
4519: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4520: --Process end.
4521: Fnd_File.put_line(Fnd_File.LOG,'**Closing dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: ' ||pv_file_old_name||'; file_new_name: '||pv_file_new_name|| ';');
4522:
4523: END dtc_batch_migration;

Line 4521: Fnd_File.put_line(Fnd_File.LOG,'**Closing dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: ' ||pv_file_old_name||'; file_new_name: '||pv_file_new_name|| ';');

4517: Fnd_File.put_line(Fnd_File.LOG,'Step 4 end.');
4518:
4519: Fnd_File.put_line(Fnd_File.LOG,'----------------------------------------------------------------------------------------');
4520: --Process end.
4521: Fnd_File.put_line(Fnd_File.LOG,'**Closing dtc_migration_batch for file_path :'||pv_file_path||'; file_old_name: ' ||pv_file_old_name||'; file_new_name: '||pv_file_new_name|| ';');
4522:
4523: END dtc_batch_migration;
4524: -------------------------------------------------------------------------------
4525: --Added by Zhiwei Hou for DTC migration bug#13359892 on 20120309 begin