440: l_no_of_lines := 'No Of Lines Processed';
441: l_no_of_success_lines := 'No Of Successful Lines';
442: l_no_of_rejected_lines :='No Of Rejected Lines';
443:
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
445: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
441: l_no_of_success_lines := 'No Of Successful Lines';
442: l_no_of_rejected_lines :='No Of Rejected Lines';
443:
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
445: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
442: l_no_of_rejected_lines :='No Of Rejected Lines';
443:
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
445: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
443:
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
445: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
444: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
445: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
452:
446: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
452:
453: /*LOG*/
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
447: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' '|| l_msg ||' ') ;
448: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ****************************************************** ') ;
449:
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
452:
453: /*LOG*/
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
455: FND_FILE.PUT_LINE( FND_FILE.log, ' ****************************************************** ') ;
450: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
452:
453: /*LOG*/
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
455: FND_FILE.PUT_LINE( FND_FILE.log, ' ****************************************************** ') ;
456:
457: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
458: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
451: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
452:
453: /*LOG*/
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
455: FND_FILE.PUT_LINE( FND_FILE.log, ' ****************************************************** ') ;
456:
457: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
458: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
459:
453: /*LOG*/
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
455: FND_FILE.PUT_LINE( FND_FILE.log, ' ****************************************************** ') ;
456:
457: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
458: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
459:
460: /*LOG*/
461:
454: FND_FILE.PUT_LINE( FND_FILE.log, ' '|| l_msg ||' ') ;
455: FND_FILE.PUT_LINE( FND_FILE.log, ' ****************************************************** ') ;
456:
457: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
458: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
459:
460: /*LOG*/
461:
462: mass_update_status_wrapper(p_contract_id,l_return_status);
462: mass_update_status_wrapper(p_contract_id,l_return_status);
463: IF l_return_status <> 'S' THEN
464: l_overall_status := l_return_status;
465: END IF;
466: fnd_file.put_line (fnd_file.log,'mass_update_status_wrapper: '||l_overall_status);
467:
468: mass_update_eff_wrapper(p_contract_id,l_return_status);
469: IF l_return_status <> 'S' THEN
470: l_overall_status := l_return_status;
468: mass_update_eff_wrapper(p_contract_id,l_return_status);
469: IF l_return_status <> 'S' THEN
470: l_overall_status := l_return_status;
471: END IF;
472: fnd_file.put_line (fnd_file.log,'mass_update_eff_wrapper: '||l_overall_status);
473:
474: mass_update_price_wrapper(p_contract_id,l_return_status);
475: IF l_return_status <> 'S' THEN
476: l_overall_status := l_return_status;
474: mass_update_price_wrapper(p_contract_id,l_return_status);
475: IF l_return_status <> 'S' THEN
476: l_overall_status := l_return_status;
477: END IF;
478: fnd_file.put_line (fnd_file.log,'mass_update_price_wrapper: '||l_overall_status);
479:
480:
481: /*
482: OKS_AUTH_UTIL_PVT.CHECK_MASSUPD_REQUEST(p_contract_id,l_massupd_return_status);
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: retcode := 2;
501: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Entered exception block'||sqlerrm) ;
502: FND_FILE.PUT_LINE( FND_FILE.log, ' Entered exception block'||sqlerrm) ;
503:
504: END;
505:
498: EXCEPTION
499: WHEN OTHERS THEN
500: retcode := 2;
501: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' Entered exception block'||sqlerrm) ;
502: FND_FILE.PUT_LINE( FND_FILE.log, ' Entered exception block'||sqlerrm) ;
503:
504: END;
505:
506: procedure mass_update_price_prc(p_mass_update_price_tbl in mass_update_price_tbl,
640: ' l_input_details.intent ' ||
641: l_input_details.intent);
642: END IF;
643:
644: FND_FILE.PUT_LINE(FND_FILE.Log,' l_mu_price_tbl(i).line_number ' ||l_mu_price_tbl(i).line_number||' l_input_details.intent ' ||l_input_details.intent);
645:
646: ---check the eligibility of the line
647: open check_line_status(l_mu_price_tbl(i).chr_id,l_mu_price_tbl(i).sub_line_id ) ;
648: FETCH check_line_status INTO l_line_eligible;
655: G_MODULE || l_api_name,
656: 'line is not eligible for price change ');
657: END IF;
658:
659: FND_FILE.PUT_LINE(FND_FILE.Log,' line is not eligible for price change and the line number is - ' ||l_mu_price_tbl(i).line_number);
660:
661: l_err_idx := l_err_idx +1;
662: err_mu_price_tbl(l_err_idx).line_number := l_mu_price_tbl(i).line_number ;
663: err_mu_price_tbl(l_err_idx).err_msg := 'Sub line status is not eligible for price change';
698: 'after call to okc_contract_pub.update_contract_line ' ||
699: 'l_return_status -' || l_return_status);
700: END IF;
701:
702: FND_FILE.PUT_LINE(FND_FILE.Log,'after call to okc_contract_pub.update_contract_line AND l_return_status - ' ||l_return_status);
703:
704: IF (l_return_status <> 'S') then
705: x_return_status := l_return_status;
706: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
733: 'after call to oks_qp_int_pvt.compute_Price ' ||
734: 'l_return_status ' || l_return_status);
735: END IF;
736:
737: FND_FILE.PUT_LINE(FND_FILE.Log,'after call to oks_qp_int_pvt.compute_Price AND l_return_status - ' ||l_return_status);
738:
739: IF (l_return_status <> 'S') then
740: x_return_status := l_return_status;
741: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
767: ' after call to oks_bill_sch.Create_Bill_Sch_CP ' ||
768: 'l_return_status ' || l_return_status);
769: END IF;
770:
771: FND_FILE.PUT_LINE(FND_FILE.Log,' after call to oks_bill_sch.Create_Bill_Sch_CP AND l_return_status IS ' ||l_return_status);
772:
773: IF (l_return_status <> 'S') then
774: x_return_status := l_return_status;
775: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
815: ' after call to oks_contract_line_pub.update_line ' ||
816: 'l_return_status ' || l_return_status);
817: END IF;
818:
819: FND_FILE.PUT_LINE(FND_FILE.Log,' after call to oks_contract_line_pub.update_line AND l_return_status IS ' ||l_return_status);
820:
821: IF (l_return_status <> 'S') then
822: x_return_status := l_return_status;
823: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
865: ' after call to oks_contract_hdr_pub.update_header ' ||
866: 'l_return_status ' || l_return_status);
867: END IF;
868:
869: FND_FILE.PUT_LINE(FND_FILE.Log,' after call to oks_contract_hdr_pub.update_header AND l_return_status IS ' ||l_return_status);
870:
871: IF (l_return_status <> 'S') then
872: x_return_status := l_return_status;
873: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
887: end loop;
888:
889: l_success_count := l_mu_price_tbl.Count - Nvl(err_mu_price_tbl.Count,0);
890:
891: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
892: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
893:
894: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
895: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
888:
889: l_success_count := l_mu_price_tbl.Count - Nvl(err_mu_price_tbl.Count,0);
890:
891: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
892: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
893:
894: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
895: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
896:
890:
891: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
892: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
893:
894: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
895: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
896:
897:
898: IF err_mu_price_tbl.Count > 0 THEN
891: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
892: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Successful Lines/Sublines: '||l_success_count);
893:
894: fnd_file.put_line (fnd_file.log,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
895: fnd_file.put_line (fnd_file.output,'Subtotal Change: Total Number of Rejected Lines/Sublines: '||err_mu_price_tbl.count);
896:
897:
898: IF err_mu_price_tbl.Count > 0 THEN
899:
896:
897:
898: IF err_mu_price_tbl.Count > 0 THEN
899:
900: fnd_file.put_line (fnd_file.output,' ');
901: fnd_file.put_line (fnd_file.output,'Error Records');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
897:
898: IF err_mu_price_tbl.Count > 0 THEN
899:
900: fnd_file.put_line (fnd_file.output,' ');
901: fnd_file.put_line (fnd_file.output,'Error Records');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
898: IF err_mu_price_tbl.Count > 0 THEN
899:
900: fnd_file.put_line (fnd_file.output,' ');
901: fnd_file.put_line (fnd_file.output,'Error Records');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
900: fnd_file.put_line (fnd_file.output,' ');
901: fnd_file.put_line (fnd_file.output,'Error Records');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
901: fnd_file.put_line (fnd_file.output,'Error Records');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
902: fnd_file.put_line (fnd_file.output,' ');
903:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
910:
904: fnd_file.put_line (fnd_file.log,' ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
910:
911: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
912: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
905: fnd_file.put_line (fnd_file.log,'Error Records');
906: fnd_file.put_line (fnd_file.log,' ');
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
910:
911: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
912: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
913:
907:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
910:
911: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
912: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
913:
914: FOR i in err_mu_price_tbl.FIRST .. err_mu_price_tbl.LAST LOOP
915:
908: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
909: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
910:
911: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
912: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
913:
914: FOR i in err_mu_price_tbl.FIRST .. err_mu_price_tbl.LAST LOOP
915:
916: fnd_file.put_line (fnd_file.log,RPad(err_mu_price_tbl(i).line_number,11, ' ') ||' - '||
912: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
913:
914: FOR i in err_mu_price_tbl.FIRST .. err_mu_price_tbl.LAST LOOP
915:
916: fnd_file.put_line (fnd_file.log,RPad(err_mu_price_tbl(i).line_number,11, ' ') ||' - '||
917: err_mu_price_tbl(i).err_msg );
918:
919: fnd_file.put_line (fnd_file.output,RPad(err_mu_price_tbl(i).line_number,11, ' ') ||' - '||
920: err_mu_price_tbl(i).err_msg );
915:
916: fnd_file.put_line (fnd_file.log,RPad(err_mu_price_tbl(i).line_number,11, ' ') ||' - '||
917: err_mu_price_tbl(i).err_msg );
918:
919: fnd_file.put_line (fnd_file.output,RPad(err_mu_price_tbl(i).line_number,11, ' ') ||' - '||
920: err_mu_price_tbl(i).err_msg );
921:
922: END LOOP;
923: END IF;
941: sqlerrm);
942: END IF;
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_price_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
946:
947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
949: END IF;
966: FROM oks_sublines_temp
967: WHERE price_change_flag = 'Y'
968: AND dnz_chr_id = To_Number(p_contract_id);
969:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
967: WHERE price_change_flag = 'Y'
968: AND dnz_chr_id = To_Number(p_contract_id);
969:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
968: AND dnz_chr_id = To_Number(p_contract_id);
969:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
969:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
970: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
971: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
972: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
973: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Subtotal Change ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
974: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
975: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
976: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
977:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
978: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
986: IF l_mass_update_price_tbl.Count > 0 THEN
979: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
986: IF l_mass_update_price_tbl.Count > 0 THEN
987: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
980: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
981: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Subtotal Change Processing') ;
982: FND_FILE.PUT_LINE( FND_FILE.log, '*********************************** ') ;
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
986: IF l_mass_update_price_tbl.Count > 0 THEN
987: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
988: fnd_file.put_line (fnd_file.output, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
983: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
986: IF l_mass_update_price_tbl.Count > 0 THEN
987: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
988: fnd_file.put_line (fnd_file.output, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
989: mass_update_price_prc(l_mass_update_price_tbl,
990: x_return_status,
991: x_msg_data,
984: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
985:
986: IF l_mass_update_price_tbl.Count > 0 THEN
987: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
988: fnd_file.put_line (fnd_file.output, 'Subtotal Change: Total number of Lines/Sublines to process: '||l_mass_update_price_tbl.Count);
989: mass_update_price_prc(l_mass_update_price_tbl,
990: x_return_status,
991: x_msg_data,
992: x_msg_count);
990: x_return_status,
991: x_msg_data,
992: x_msg_count);
993:
994: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
991: x_msg_data,
992: x_msg_count);
993:
994: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
992: x_msg_count);
993:
994: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
993:
994: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
1001: ELSE
994: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
1001: ELSE
1002: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: No records to process');
995: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
996: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Subtotal Change Processing') ;
997: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
1001: ELSE
1002: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: No records to process');
1003: fnd_file.put_line (fnd_file.output, 'Subtotal Change: No records to process');
998: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
1001: ELSE
1002: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: No records to process');
1003: fnd_file.put_line (fnd_file.output, 'Subtotal Change: No records to process');
1004: x_return_status := 'S';
1005: END IF;
1006:
999: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1000:
1001: ELSE
1002: fnd_file.put_line (fnd_file.Log, 'Subtotal Change: No records to process');
1003: fnd_file.put_line (fnd_file.output, 'Subtotal Change: No records to process');
1004: x_return_status := 'S';
1005: END IF;
1006:
1007:
1017: l_count NUMBER := 0;
1018:
1019: BEGIN
1020:
1021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1018:
1019: BEGIN
1020:
1021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1019: BEGIN
1020:
1021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1020:
1021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1028:
1021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1028:
1029:
1022: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1028:
1029:
1030: /*log*/
1023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1024: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, 'Following are the Lines Processed for Status Change ') ;
1025: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, '*************************************************** ') ;
1026: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1028:
1029:
1030: /*log*/
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1027: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1028:
1029:
1030: /*log*/
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1028:
1029:
1030: /*log*/
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1029:
1030: /*log*/
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1037: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1030: /*log*/
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1037: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1038:
1031: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1037: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1038:
1039:
1032: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1037: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1038:
1039:
1040: /*log*/
1033: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1034: FND_FILE.PUT_LINE( FND_FILE.log, 'Start of Status Change Processing') ;
1035: FND_FILE.PUT_LINE( FND_FILE.log, '********************************* ') ;
1036: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1037: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1038:
1039:
1040: /*log*/
1041:
1051: WHERE (status_change_flag = 'Y' AND status_error_flag = 'Y')
1052: AND dnz_chr_id = to_number(p_contract_id)) LOOP
1053:
1054: IF l_count = 0 THEN
1055: FND_FILE.PUT_LINE( FND_FILE.output, 'Records rejected during validation') ;
1056: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1057: END IF;
1058: fnd_file.put_line (fnd_file.Log,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1059: fnd_file.put_line (fnd_file.output,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1052: AND dnz_chr_id = to_number(p_contract_id)) LOOP
1053:
1054: IF l_count = 0 THEN
1055: FND_FILE.PUT_LINE( FND_FILE.output, 'Records rejected during validation') ;
1056: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1057: END IF;
1058: fnd_file.put_line (fnd_file.Log,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1059: fnd_file.put_line (fnd_file.output,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1060: l_count := l_count +1;
1054: IF l_count = 0 THEN
1055: FND_FILE.PUT_LINE( FND_FILE.output, 'Records rejected during validation') ;
1056: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1057: END IF;
1058: fnd_file.put_line (fnd_file.Log,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1059: fnd_file.put_line (fnd_file.output,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1060: l_count := l_count +1;
1061:
1062: END LOOP;
1055: FND_FILE.PUT_LINE( FND_FILE.output, 'Records rejected during validation') ;
1056: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1057: END IF;
1058: fnd_file.put_line (fnd_file.Log,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1059: fnd_file.put_line (fnd_file.output,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1060: l_count := l_count +1;
1061:
1062: END LOOP;
1063: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Rejected lines during validation: ' || l_count);
1059: fnd_file.put_line (fnd_file.output,'Line Number: ' || I.line_number || ' Error Message is: ' || i.status_err_message);
1060: l_count := l_count +1;
1061:
1062: END LOOP;
1063: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Rejected lines during validation: ' || l_count);
1064:
1065: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1066:
1067:
1061:
1062: END LOOP;
1063: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Rejected lines during validation: ' || l_count);
1064:
1065: FND_FILE.PUT_LINE( FND_FILE.output, ' ') ;
1066:
1067:
1068: SELECT * BULK COLLECT
1069: INTO l_mass_update_status_tbl
1094: AND dnz_chr_id = to_number(p_contract_id));
1095:
1096: IF l_mass_update_status_tbl.Count > 0 THEN
1097: IF l_count <> 0 THEN
1098: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1099: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1100: END IF;
1101:
1102: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1095:
1096: IF l_mass_update_status_tbl.Count > 0 THEN
1097: IF l_count <> 0 THEN
1098: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1099: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1100: END IF;
1101:
1102: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1103: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1098: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1099: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1100: END IF;
1101:
1102: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1103: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1104:
1105: mass_update_status_prc(l_mass_update_status_tbl,
1106: x_return_status,
1099: FND_FILE.PUT_LINE( FND_FILE.OUTPUT, ' ') ;
1100: END IF;
1101:
1102: fnd_file.put_line (fnd_file.Log, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1103: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Lines/Sublines to process: '||l_mass_update_status_tbl.count);
1104:
1105: mass_update_status_prc(l_mass_update_status_tbl,
1106: x_return_status,
1107: x_msg_data,
1106: x_return_status,
1107: x_msg_data,
1108: x_msg_count);
1109:
1110: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1107: x_msg_data,
1108: x_msg_count);
1109:
1110: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1108: x_msg_count);
1109:
1110: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1109:
1110: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1117:
1110: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1117:
1118: ELSE
1111: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1117:
1118: ELSE
1119: fnd_file.put_line (fnd_file.Log, 'Status Change: No records to process');
1112: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1113: FND_FILE.PUT_LINE( FND_FILE.log, 'End of Status Change Processing') ;
1114: FND_FILE.PUT_LINE( FND_FILE.log, '*************************************************** ') ;
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1117:
1118: ELSE
1119: fnd_file.put_line (fnd_file.Log, 'Status Change: No records to process');
1120: IF l_count <> 0 THEN
1115: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1116: FND_FILE.PUT_LINE( FND_FILE.log, ' ') ;
1117:
1118: ELSE
1119: fnd_file.put_line (fnd_file.Log, 'Status Change: No records to process');
1120: IF l_count <> 0 THEN
1121: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1122: END IF;
1123: fnd_file.put_line (fnd_file.output, 'Status Change: No records to process');
1117:
1118: ELSE
1119: fnd_file.put_line (fnd_file.Log, 'Status Change: No records to process');
1120: IF l_count <> 0 THEN
1121: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1122: END IF;
1123: fnd_file.put_line (fnd_file.output, 'Status Change: No records to process');
1124: x_return_status := 'S';
1125: END IF;
1119: fnd_file.put_line (fnd_file.Log, 'Status Change: No records to process');
1120: IF l_count <> 0 THEN
1121: fnd_file.put_line (fnd_file.output, 'Status Change: Total Number of Rejected Lines during validation: ' || l_count);
1122: END IF;
1123: fnd_file.put_line (fnd_file.output, 'Status Change: No records to process');
1124: x_return_status := 'S';
1125: END IF;
1126:
1127: END;
1134: --l_mass_update_eff_tbl_err oks_mass_upd_pvt.mass_update_effectivity_tbl;
1135: l_count NUMBER := 0;
1136: BEGIN
1137:
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1139: ' ');
1140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1141: ' ');
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1136: BEGIN
1137:
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1139: ' ');
1140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1141: ' ');
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1143: ' ');
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1139: ' ');
1140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1141: ' ');
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1143: ' ');
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1145: 'Following are the Lines Processed for Effectivity Change ');
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1141: ' ');
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1143: ' ');
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1145: 'Following are the Lines Processed for Effectivity Change ');
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1147: '******************************************************** ');
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1143: ' ');
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1145: 'Following are the Lines Processed for Effectivity Change ');
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1147: '******************************************************** ');
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1149: ' ');
1150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1145: 'Following are the Lines Processed for Effectivity Change ');
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1147: '******************************************************** ');
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1149: ' ');
1150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1151: ' ');
1152:
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1147: '******************************************************** ');
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1149: ' ');
1150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1151: ' ');
1152:
1153: /*log*/
1154:
1151: ' ');
1152:
1153: /*log*/
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1156: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1152:
1153: /*log*/
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1156: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1153: /*log*/
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1156: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1161: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1156: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1161: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1162: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1155: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1156: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1161: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1162: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1163:
1157: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1161: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1162: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1163:
1164: /*log*/
1165:
1158: FND_FILE.PUT_LINE(FND_FILE.log, 'Start of Effectivity Change Processing');
1159: FND_FILE.PUT_LINE(FND_FILE.log,
1160: '************************************** ');
1161: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1162: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1163:
1164: /*log*/
1165:
1166: FOR I IN (SELECT line_number,
1193: end_dt_error_flag = 'Y'))
1194: AND dnz_chr_id = to_number(p_contract_id)) LOOP
1195:
1196: IF l_count = 0 THEN
1197: FND_FILE.PUT_LINE(FND_FILE.output, 'Records rejected during validation');
1198: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1199: END IF;
1200: fnd_file.put_line(fnd_file.Log,
1201: 'Line Number: ' || I.line_number ||
1194: AND dnz_chr_id = to_number(p_contract_id)) LOOP
1195:
1196: IF l_count = 0 THEN
1197: FND_FILE.PUT_LINE(FND_FILE.output, 'Records rejected during validation');
1198: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1199: END IF;
1200: fnd_file.put_line(fnd_file.Log,
1201: 'Line Number: ' || I.line_number ||
1202: ' Error Message is: ' || i.st_dt_err || ' ' ||
1196: IF l_count = 0 THEN
1197: FND_FILE.PUT_LINE(FND_FILE.output, 'Records rejected during validation');
1198: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1199: END IF;
1200: fnd_file.put_line(fnd_file.Log,
1201: 'Line Number: ' || I.line_number ||
1202: ' Error Message is: ' || i.st_dt_err || ' ' ||
1203: i.end_dt_err);
1204: fnd_file.put_line(fnd_file.output,
1200: fnd_file.put_line(fnd_file.Log,
1201: 'Line Number: ' || I.line_number ||
1202: ' Error Message is: ' || i.st_dt_err || ' ' ||
1203: i.end_dt_err);
1204: fnd_file.put_line(fnd_file.output,
1205: 'Line Number: ' || I.line_number ||
1206: ' Error Message is: ' || i.st_dt_err || ' ' ||
1207: i.end_dt_err);
1208: l_count := l_count + 1;
1208: l_count := l_count + 1;
1209: END LOOP;
1210:
1211: IF l_count > 0 THEN
1212: fnd_file.put_line(fnd_file.Log,
1213: 'Effectivity Change: Total Number of Rejected lines during validation: ' ||
1214: l_count);
1215: END IF;
1216:
1243: AND dnz_chr_id = to_number(p_contract_id));
1244:
1245: IF l_mass_update_eff_tbl.Count > 0 THEN
1246: IF l_count <> 0 THEN
1247: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1248: fnd_file.put_line(fnd_file.output,
1249: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1250: l_count);
1251: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1244:
1245: IF l_mass_update_eff_tbl.Count > 0 THEN
1246: IF l_count <> 0 THEN
1247: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1248: fnd_file.put_line(fnd_file.output,
1249: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1250: l_count);
1251: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1247: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1248: fnd_file.put_line(fnd_file.output,
1249: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1250: l_count);
1251: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1253: ' ');
1254: END IF;
1255: mass_update_effectivity_prc(l_mass_update_eff_tbl, x_return_status);
1248: fnd_file.put_line(fnd_file.output,
1249: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1250: l_count);
1251: FND_FILE.PUT_LINE(FND_FILE.output, ' ');
1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1253: ' ');
1254: END IF;
1255: mass_update_effectivity_prc(l_mass_update_eff_tbl, x_return_status);
1256:
1253: ' ');
1254: END IF;
1255: mass_update_effectivity_prc(l_mass_update_eff_tbl, x_return_status);
1256:
1257: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1258: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1254: END IF;
1255: mass_update_effectivity_prc(l_mass_update_eff_tbl, x_return_status);
1256:
1257: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1258: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1255: mass_update_effectivity_prc(l_mass_update_eff_tbl, x_return_status);
1256:
1257: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1258: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1263: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1256:
1257: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1258: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1263: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1264: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1257: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1258: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1263: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1264: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1265:
1259: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1263: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1264: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1265:
1266: ELSE
1267: IF l_count <> 0 THEN
1260: FND_FILE.PUT_LINE(FND_FILE.log, 'End of Effectivity Change Processing');
1261: FND_FILE.PUT_LINE(FND_FILE.log,
1262: '************************************** ');
1263: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1264: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1265:
1266: ELSE
1267: IF l_count <> 0 THEN
1268: fnd_file.put_line(fnd_file.output,
1264: FND_FILE.PUT_LINE(FND_FILE.log, ' ');
1265:
1266: ELSE
1267: IF l_count <> 0 THEN
1268: fnd_file.put_line(fnd_file.output,
1269: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1270: l_count);
1271: END IF;
1272: fnd_file.put_line(fnd_file.Log,
1268: fnd_file.put_line(fnd_file.output,
1269: 'Effectivity Change: Total Number of Rejected Lines during validation: ' ||
1270: l_count);
1271: END IF;
1272: fnd_file.put_line(fnd_file.Log,
1273: 'Effectivity Change: No records to process');
1274: fnd_file.put_line(fnd_file.output,
1275: 'Effectivity Change: No records to process');
1276: x_return_status := 'S';
1270: l_count);
1271: END IF;
1272: fnd_file.put_line(fnd_file.Log,
1273: 'Effectivity Change: No records to process');
1274: fnd_file.put_line(fnd_file.output,
1275: 'Effectivity Change: No records to process');
1276: x_return_status := 'S';
1277: END IF;
1278: END;
1374: .line_id || 'Old_Ste_Code -' || l_old_ste_code ||
1375: 'New_ste_Code -' || l_new_ste_code);
1376: END IF;
1377:
1378: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Before OKS_CHANGE_STATUS_PVT.VALIDATE_STATUS for line_number - '||p_lines_tbl(i).line_number||' Old_Ste_Code - is '||l_old_ste_code||' New_ste_Code - '||l_new_ste_code);
1379:
1380: OKS_CHANGE_STATUS_PVT.VALIDATE_STATUS(x_return_status => l_return_status,
1381: x_msg_count => l_msg_count,
1382: x_msg_data => l_msg_data,
1398: 'After Validate_Status' || 'l_return_status -' ||
1399: l_return_status);
1400: END IF;
1401:
1402: FND_FILE.PUT_LINE(FND_FILE.Log,'After Validate_Status - l_return_status - '||l_return_status);
1403:
1404: IF (l_return_status NOT IN ('S','W')) then
1405: x_return_status := l_return_status;
1406: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
1441: 'After Update_Line_Status' || 'l_return_status -' ||
1442: l_return_status);
1443: END IF;
1444:
1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'After Update_Line_Status - l_return_status is ' ||l_return_status);
1446:
1447: IF (l_return_status <> 'S') then
1448: x_return_status := l_return_status;
1449: x_overall_status := l_return_status;
1459: END IF;
1460:
1461: EXCEPTION
1462: WHEN l_EXC_ERROR THEN
1463: fnd_file.put_line (fnd_file.log,'Exception raised for Line Number: '||err_mu_status_tbl(l_error_count).line_number ||
1464: 'Error Msg : '||err_mu_status_tbl(l_error_count).err_msg );
1465: DBMS_TRANSACTION.rollback_savepoint('MASS_UPDATE_STATUS');
1466: x_overall_status := 'W';
1467: END;
1471: --COMMIT;
1472:
1473: l_success_count := p_mass_update_status_tbl.Count - Nvl(err_mu_status_tbl.Count,0);
1474:
1475: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1476: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1477:
1478: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1479: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1472:
1473: l_success_count := p_mass_update_status_tbl.Count - Nvl(err_mu_status_tbl.Count,0);
1474:
1475: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1476: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1477:
1478: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1479: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1480:
1474:
1475: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1476: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1477:
1478: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1479: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1480:
1481: fnd_file.put_line (fnd_file.output,' ');
1482:
1475: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1476: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Successful Lines/Sublines: '||l_success_count);
1477:
1478: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1479: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1480:
1481: fnd_file.put_line (fnd_file.output,' ');
1482:
1483:
1477:
1478: fnd_file.put_line (fnd_file.log,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1479: fnd_file.put_line (fnd_file.output,'Status Change: Total Number of Rejected Lines/Sublines: '||l_error_count);
1480:
1481: fnd_file.put_line (fnd_file.output,' ');
1482:
1483:
1484: IF err_mu_status_tbl.Count > 0 THEN
1485:
1482:
1483:
1484: IF err_mu_status_tbl.Count > 0 THEN
1485:
1486: fnd_file.put_line (fnd_file.output,'Status Change: Error Records');
1487: fnd_file.put_line (fnd_file.output,' ');
1488:
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1483:
1484: IF err_mu_status_tbl.Count > 0 THEN
1485:
1486: fnd_file.put_line (fnd_file.output,'Status Change: Error Records');
1487: fnd_file.put_line (fnd_file.output,' ');
1488:
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1491:
1485:
1486: fnd_file.put_line (fnd_file.output,'Status Change: Error Records');
1487: fnd_file.put_line (fnd_file.output,' ');
1488:
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1491:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1486: fnd_file.put_line (fnd_file.output,'Status Change: Error Records');
1487: fnd_file.put_line (fnd_file.output,' ');
1488:
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1491:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1494:
1488:
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1491:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1494:
1495: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
1496: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
1489: fnd_file.put_line (fnd_file.log,'Status Change: Error Records');
1490: fnd_file.put_line (fnd_file.log,' ');
1491:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1494:
1495: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
1496: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
1497:
1491:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1494:
1495: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
1496: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
1497:
1498: FOR i in err_mu_status_tbl.FIRST .. err_mu_status_tbl.LAST loop
1499:
1492: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
1493: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
1494:
1495: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
1496: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
1497:
1498: FOR i in err_mu_status_tbl.FIRST .. err_mu_status_tbl.LAST loop
1499:
1500: fnd_file.put_line (fnd_file.log,RPad(err_mu_status_tbl(i).line_number,11, ' ') ||' - '||
1496: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
1497:
1498: FOR i in err_mu_status_tbl.FIRST .. err_mu_status_tbl.LAST loop
1499:
1500: fnd_file.put_line (fnd_file.log,RPad(err_mu_status_tbl(i).line_number,11, ' ') ||' - '||
1501: err_mu_status_tbl(i).err_msg );
1502:
1503: fnd_file.put_line (fnd_file.output,RPad(err_mu_status_tbl(i).line_number,11, ' ') ||' - '||
1504: err_mu_status_tbl(i).err_msg );
1499:
1500: fnd_file.put_line (fnd_file.log,RPad(err_mu_status_tbl(i).line_number,11, ' ') ||' - '||
1501: err_mu_status_tbl(i).err_msg );
1502:
1503: fnd_file.put_line (fnd_file.output,RPad(err_mu_status_tbl(i).line_number,11, ' ') ||' - '||
1504: err_mu_status_tbl(i).err_msg );
1505:
1506: END LOOP;
1507: END IF;
1511: IF x_overall_status IS NOT NULL THEN
1512: x_return_status := x_overall_status;
1513: END IF;
1514:
1515: FND_FILE.PUT_LINE(FND_FILE.Log,'Return Status in Mass_Update_Status_Prc is '||x_return_status);
1516:
1517: EXCEPTION
1518:
1519: WHEN OTHERS THEN
1525: sqlerrm);
1526: END IF;
1527:
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_status_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
1530:
1531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1532: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1533: END IF;
1694: l_api_name VARCHAR2(150) := 'oks_mass_upd_pvt.check_new_line_effectivity';
1695: --l_err_mu_eff_tbl err_mu_eff_tbl;
1696: BEGIN
1697: exception_yn := 'N'; -- Defaulting value
1698: fnd_file.put_line (fnd_file.log, l_api_name || ', Checking Contract Line Effectivity for line number: ' || p_line_number);
1699: SELECT start_date, end_date
1700: INTO l_k_start_date, l_k_end_date
1701: FROM okc_k_headers_all_b
1702: where id = p_chr_id;
1722: exception_yn := 'Y';
1723: END IF;
1724:
1725: IF exception_yn = 'Y' THEN
1726: fnd_file.put_line (fnd_file.log, l_api_name || ', Line Start/End Date is out of Contract''s Effectivity, p_line_number: ' || p_line_number);
1727: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;
1728: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Line Start/End Date is out of Contract''s Effectivity';
1729: l_err_eff_idx := l_err_eff_idx +1;
1730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1737:
1738: EXCEPTION
1739: when OTHERS then
1740: exception_yn := 'Y';
1741: fnd_file.put_line (fnd_file.log, l_api_name ||
1742: ' Error while validating data in check_new_line_effectivity for line_number: ' || p_line_number);
1743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: l_api_name,
1767: --l_err_mu_eff_tbl err_mu_eff_tbl;
1768:
1769: BEGIN
1770: exception_yn := 'N'; -- Defaulting value
1771: fnd_file.put_line (fnd_file.log, l_api_name || ', Checking Contract SubLine Effectivity for Subline Number: ' || p_line_number);
1772: select l.chr_id, l.START_DATE, l.END_DATE
1773: INTO l_chr_id, l_kl_start_date, l_kl_end_date
1774: FROM OKC_K_LINES_B sl, okc_k_lines_b l
1775: WHERE sl.id = p_subline_id
1823: exception_yn := 'Y';
1824: END IF;
1825:
1826: IF (exception_yn <> 'N') THEN
1827: fnd_file.put_line (fnd_file.log, l_api_name ||
1828: ', Subline Start/End Date is out of Contract''s or Contract Line''s Effectivity, subline number: ' || p_line_number);
1829: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1831: l_api_name,
1841: exception_yn := 'Y';
1842: l_err_mu_eff_tbl(l_err_eff_idx).line_number := p_line_number;
1843: l_err_mu_eff_tbl(l_err_eff_idx).error_msg := 'Error while fetching data from okc_k_lines_b for subline, Error: ' || SQLERRM;
1844: l_err_eff_idx := l_err_eff_idx +1;
1845: fnd_file.put_line (fnd_file.output, l_api_name ||
1846: ' Error while validating data in check_new_subline_effectivity for subline number: ' || p_line_number);
1847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1849: l_api_name,
1909: end_date - 1);
1910:
1911: BEGIN
1912:
1913: fnd_file.put_line (fnd_file.output, 'Effectivity Change: ' || ' Total Number of Lines/Sublines to process: ' || p_mass_update_effectivity_tbl.Count);
1914:
1915: FOR i IN p_mass_update_effectivity_tbl.FIRST .. p_mass_update_effectivity_tbl.LAST LOOP
1916:
1917: IF p_mass_update_effectivity_tbl(i).sub_line_id IS NULL THEN
1940: INTO l_eligible;
1941: CLOSE check_eligiblity_line;
1942:
1943: IF l_eligible = 'Y' THEN
1944: fnd_file.put_line (fnd_file.log, l_api_name || ' Line number : ' || p_mass_update_effectivity_tbl(i).line_number || 'is eligible');
1945: l_clev_tbl_kl_in(p).id := p_mass_update_effectivity_tbl(i).line_id;
1946: /* Commented for Bug#14335289 */
1947: -- l_clev_tbl_kl_in(p).line_number := p_mass_update_effectivity_tbl(i).line_number;
1948: l_clev_tbl_kl_in(p).start_date := p_mass_update_effectivity_tbl(i).START_DATE;
1962: p_lse_id => p_mass_update_effectivity_tbl(i)
1963: .lse_id,
1964: p_end_date => null) THEN
1965:
1966: fnd_file.put_line (fnd_file.log,
1967: l_api_name ||
1968: ' Entering Validate_date for Line number: ' || p_mass_update_effectivity_tbl(i).line_number);
1969:
1970: validate_date(p_api_version => l_api_version,
1976: x_msg_count => l_msg_count,
1977: x_msg_data => l_msg_data,
1978: x_flag => l_flag);
1979:
1980: fnd_file.put_line (fnd_file.log,
1981: l_api_name ||
1982: ' After Validate_date for Line number: ' || p_mass_update_effectivity_tbl(i).line_number);
1983:
1984: IF (l_return_status <> 'S') then
2044: END IF;
2045:
2046: END IF; -- l_eligible
2047:
2048: fnd_file.put_line (fnd_file.log,
2049: l_api_name ||
2050: ' Line number: ' || p_mass_update_effectivity_tbl(i).line_number ||
2051: ', Status would be: ' || l_clev_tbl_kl_in(p).STS_CODE ||
2052: ', Start Date and End Date are: ' || l_clev_tbl_kl_in(p).start_date || ' and ' || l_clev_tbl_kl_in(p).end_date);
2112: l_clev_tbl_sl_in(q).start_date,
2113: l_clev_tbl_sl_in(q).end_date,
2114: l_clev_tbl_sl_in(q).exception_yn);
2115:
2116: fnd_file.put_line (fnd_file.log,
2117: l_api_name ||
2118: ' Subline ID : ' || l_clev_tbl_sl_in(q).id ||
2119: ' Line Id: ' || l_clev_tbl_sl_in(q).cle_id ||
2120: ' CHR Id: ' || l_clev_tbl_sl_in(q).CHR_id ||
2126: If oks_extwar_util_pvt.check_already_billed(p_chr_id => null,
2127: p_cle_id => p_mass_update_effectivity_tbl(i).line_id,
2128: p_lse_id => p_mass_update_effectivity_tbl(i).lse_id,
2129: p_end_date => null) THEN
2130: fnd_file.put_line (fnd_file.log,
2131: l_api_name ||
2132: ' Entering Validate_date for Sub Line Id: ' ||
2133: p_mass_update_effectivity_tbl(i).sub_line_id);
2134:
2194: END IF; -- l_clev_tbl_sl_in(q).sts_code
2195: END IF; --p_mass_update_effectivity_tbl(i).sub_line_id
2196: END LOOP;
2197:
2198: fnd_file.put_line (fnd_file.output, 'Effectivity Change: ' || ' Number of Lines to Process : ' || l_clev_tbl_kl_in.Count);
2199:
2200: --Processing Lines
2201: IF l_clev_tbl_kl_in.Count > 0 THEN
2202: FOR j IN l_clev_tbl_kl_in.FIRST .. l_clev_tbl_kl_in.LAST LOOP
2200: --Processing Lines
2201: IF l_clev_tbl_kl_in.Count > 0 THEN
2202: FOR j IN l_clev_tbl_kl_in.FIRST .. l_clev_tbl_kl_in.LAST LOOP
2203:
2204: fnd_file.put_line (fnd_file.log,
2205: l_api_name || ' Processing Line Id:' || l_clev_tbl_kl_in(j).id);
2206:
2207: IF l_clev_tbl_kl_in(j).exception_yn <> 'Y' THEN
2208: BEGIN
2206:
2207: IF l_clev_tbl_kl_in(j).exception_yn <> 'Y' THEN
2208: BEGIN
2209: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2210: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling : okc_contract_pub.update_contract_line');
2211:
2212: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2213: p_init_msg_list => l_init_msg_list,
2214: x_return_status => l_return_status,
2216: x_msg_data => l_msg_data,
2217: p_restricted_update => 'F',
2218: p_clev_rec => l_clev_tbl_kl_in(j),
2219: X_CLEV_rec => l_clev_tbl_kl_out(j));
2220: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling : okc_contract_pub.update_contract_line');
2221:
2222: IF (l_return_status <> 'S') then
2223: x_return_status := l_return_status;
2224: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
2269: --for coverage
2270: if l_return_status = 'S' then
2271: -- Updating Billing Schedule
2272: BEGIN
2273: fnd_file.put_line (fnd_file.log,l_api_name ||' Before Calling : OKS_BILL_SCH.Cascade_Dates_SLL');
2274:
2275: OKS_BILL_SCH.Cascade_Dates_SLL(p_top_line_id => l_clev_tbl_kl_in(j).id,
2276: x_return_status => l_return_status,
2277: x_msg_count => l_msg_count,
2276: x_return_status => l_return_status,
2277: x_msg_count => l_msg_count,
2278: x_msg_data => l_msg_data);
2279:
2280: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling : OKS_BILL_SCH.Cascade_Dates_SLL');
2281:
2282: IF (l_return_status <> 'S') then
2283: x_return_status := l_return_status;
2284: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
2328: Fetch LineCov_cur
2329: into l_id;
2330: if LINECOV_CUR%FOUND then
2331: BEGIN
2332: fnd_file.put_line (fnd_file.log,l_api_name ||
2333: ' Before Calling : OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity');
2334:
2335: OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity(p_api_version => l_api_version,
2336: p_init_msg_list => l_init_msg_list,
2339: X_MSG_DATA => L_MSG_DATA,
2340: p_service_Line_Id => l_clev_tbl_kl_in(j).cle_id,
2341: p_New_Start_Date => l_clev_tbl_kl_in(j).start_date,
2342: P_NEW_END_DATE => l_clev_tbl_kl_in(j).END_DATE);
2343: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling : OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity');
2344: END;
2345:
2346: IF (l_return_status <> 'S') then
2347: x_return_status := l_return_status;
2357:
2358: close LINEcov_cur;
2359:
2360: if L_RETURN_STATUS = 'S' then
2361: fnd_file.put_line (fnd_file.log, l_api_name || ' Before Calling : OKS_PM_PROGRAMS_PVT.ADJUST_PM_PROGRAM_SCHEDULE');
2362:
2363: BEGIN
2364: OKS_PM_PROGRAMS_PVT.ADJUST_PM_PROGRAM_SCHEDULE(p_api_version => l_api_version,
2365: P_INIT_MSG_LIST => L_INIT_MSG_LIST,
2368: p_new_end_date => l_clev_tbl_kl_in(j).end_date,
2369: x_return_status => l_return_status,
2370: x_msg_count => l_msg_count,
2371: x_msg_data => l_msg_data);
2372: fnd_file.put_line (fnd_file.log, l_api_name ||
2373: ' After Calling : OKS_PM_PROGRAMS_PVT.ADJUST_PM_PROGRAM_SCHEDULE');
2374: END;
2375:
2376: IF (l_return_status <> 'S') then
2392: END LOOP; --l_clev_tbl_kl_in
2393: END IF; --l_clev_tbl_kl_in.Count
2394: -- End for Processing Lines
2395:
2396: fnd_file.put_line (fnd_file.output, 'Effectivity Change: ' || ' Number of Sublines to process : ' || l_clev_tbl_sl_in.Count);
2397:
2398: -- Processing Sublines
2399: IF l_clev_tbl_sl_in.Count > 0 THEN
2400: FOR k IN l_clev_tbl_sl_in.FIRST .. l_clev_tbl_sl_in.LAST LOOP
2400: FOR k IN l_clev_tbl_sl_in.FIRST .. l_clev_tbl_sl_in.LAST LOOP
2401:
2402: IF l_clev_tbl_sl_in(k).exception_yn <> 'Y' THEN
2403: BEGIN
2404: fnd_file.put_line (fnd_file.log,l_api_name || ' Processing SubLine Id:' || To_Char(l_clev_tbl_sl_in(k).id));
2405:
2406: -- Resetting before calling the update package only for sublines
2407: l_clev_tbl_sl_in(k).CHR_id := NULL;
2408: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling okc_contract_pub.update_contract_line');
2404: fnd_file.put_line (fnd_file.log,l_api_name || ' Processing SubLine Id:' || To_Char(l_clev_tbl_sl_in(k).id));
2405:
2406: -- Resetting before calling the update package only for sublines
2407: l_clev_tbl_sl_in(k).CHR_id := NULL;
2408: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling okc_contract_pub.update_contract_line');
2409: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2410: p_init_msg_list => l_init_msg_list,
2411: x_return_status => l_return_status,
2412: x_msg_count => l_msg_count,
2413: x_msg_data => l_msg_data,
2414: p_restricted_update => 'F',
2415: p_clev_rec => l_clev_tbl_sl_in(k),
2416: X_CLEV_rec => l_clev_tbl_sl_out(k));
2417: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling okc_contract_pub.update_contract_line');
2418:
2419:
2420: EXCEPTION
2421: when OTHERS THEN
2467: l_input_details.line_id := l_clev_tbl_sl_in(k).cle_ID;
2468: l_input_details.intent := 'SP';
2469: l_input_details.subline_id := l_clev_tbl_sl_in(k).id;
2470: l_input_details.currency := l_currency;
2471: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling oks_qp_int_pvt.compute_Price');
2472:
2473: oks_qp_int_pvt.compute_Price(p_api_version => 1.0,
2474: p_init_msg_list => 'T',
2475: p_detail_rec => l_input_details,
2478: x_price_break_details => l_pb_details,
2479: x_return_status => l_return_status,
2480: x_msg_count => l_msg_count,
2481: x_msg_data => l_msg_data);
2482: fnd_file.put_line (fnd_file.log,l_api_name ||' After Calling oks_qp_int_pvt.compute_Price, l_return_status '||l_return_status);
2483:
2484: IF (l_return_status <> 'S') then
2485: x_return_status := l_return_status;
2486: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
2491: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: END IF;
2493:
2494: END IF; --l_clev_tbl_sl_in(k).lse_id
2495: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling OKS_BILL_SCH.Cascade_Dates_SLL');
2496:
2497: OKS_BILL_SCH.Cascade_Dates_SLL(p_top_line_id => l_clev_tbl_sl_in(k).cle_id,
2498: x_return_status => l_return_status,
2499: x_msg_count => l_msg_count,
2497: OKS_BILL_SCH.Cascade_Dates_SLL(p_top_line_id => l_clev_tbl_sl_in(k).cle_id,
2498: x_return_status => l_return_status,
2499: x_msg_count => l_msg_count,
2500: x_msg_data => l_msg_data);
2501: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling OKS_BILL_SCH.Cascade_Dates_SLL, l_return_status '||l_return_status);
2502:
2503: IF (l_return_status <> 'S') then
2504: x_return_status := l_return_status;
2505: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,
2531: END LOOP; --l_clev_tbl_sl_in
2532: END IF; --l_clev_tbl_sl_in.Count
2533: -- End for Processing Sublines
2534: --COMMIT; -- To commit the data to base tables
2535: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful lines : ' || l_no_of_prcd_ln);
2536: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected lines : ' || to_number(l_clev_tbl_kl_in.Count - l_no_of_prcd_ln));
2537:
2538: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful sublines : ' || l_no_of_prcd_sln);
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2532: END IF; --l_clev_tbl_sl_in.Count
2533: -- End for Processing Sublines
2534: --COMMIT; -- To commit the data to base tables
2535: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful lines : ' || l_no_of_prcd_ln);
2536: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected lines : ' || to_number(l_clev_tbl_kl_in.Count - l_no_of_prcd_ln));
2537:
2538: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful sublines : ' || l_no_of_prcd_sln);
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2540:
2534: --COMMIT; -- To commit the data to base tables
2535: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful lines : ' || l_no_of_prcd_ln);
2536: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected lines : ' || to_number(l_clev_tbl_kl_in.Count - l_no_of_prcd_ln));
2537:
2538: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful sublines : ' || l_no_of_prcd_sln);
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2540:
2541: IF l_err_mu_eff_tbl.Count > 0 THEN
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2535: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful lines : ' || l_no_of_prcd_ln);
2536: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected lines : ' || to_number(l_clev_tbl_kl_in.Count - l_no_of_prcd_ln));
2537:
2538: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful sublines : ' || l_no_of_prcd_sln);
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2540:
2541: IF l_err_mu_eff_tbl.Count > 0 THEN
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2543: fnd_file.put_line (fnd_file.Log, ' ');
2538: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Successful sublines : ' || l_no_of_prcd_sln);
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2540:
2541: IF l_err_mu_eff_tbl.Count > 0 THEN
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2543: fnd_file.put_line (fnd_file.Log, ' ');
2544:
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2539: fnd_file.put_line (fnd_file.output,'Effectivity Change: ' || ' No. of Rejected sublines : ' || to_number(l_clev_tbl_sl_in.Count - l_no_of_prcd_sln));
2540:
2541: IF l_err_mu_eff_tbl.Count > 0 THEN
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2543: fnd_file.put_line (fnd_file.Log, ' ');
2544:
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2547:
2541: IF l_err_mu_eff_tbl.Count > 0 THEN
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2543: fnd_file.put_line (fnd_file.Log, ' ');
2544:
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2547:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2542: fnd_file.put_line (fnd_file.Log, 'Error Messages while updating effectivities');
2543: fnd_file.put_line (fnd_file.Log, ' ');
2544:
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2547:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2550:
2544:
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2547:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2550:
2551: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
2552: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
2545: fnd_file.put_line (fnd_file.output, 'Error Messages while updating effectivities');
2546: fnd_file.put_line (fnd_file.output, ' ');
2547:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2550:
2551: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
2552: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
2553:
2547:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2550:
2551: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
2552: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
2553:
2554: FOR i in l_err_mu_eff_tbl.FIRST .. l_err_mu_eff_tbl.LAST LOOP
2555:
2548: fnd_file.put_line (fnd_file.log,'Line Number '||' - '|| 'Error Message ');
2549: fnd_file.put_line (fnd_file.log,'*********** '||' - '|| '************************************** ');
2550:
2551: fnd_file.put_line (fnd_file.output,'Line Number '||' - '|| 'Error Message ');
2552: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
2553:
2554: FOR i in l_err_mu_eff_tbl.FIRST .. l_err_mu_eff_tbl.LAST LOOP
2555:
2556: fnd_file.put_line (fnd_file.log,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2552: fnd_file.put_line (fnd_file.output,'*********** '||' - '|| '************************************** ');
2553:
2554: FOR i in l_err_mu_eff_tbl.FIRST .. l_err_mu_eff_tbl.LAST LOOP
2555:
2556: fnd_file.put_line (fnd_file.log,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2557: l_err_mu_eff_tbl(i).error_msg );
2558:
2559: fnd_file.put_line (fnd_file.output,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2560: l_err_mu_eff_tbl(i).error_msg );
2555:
2556: fnd_file.put_line (fnd_file.log,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2557: l_err_mu_eff_tbl(i).error_msg );
2558:
2559: fnd_file.put_line (fnd_file.output,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2560: l_err_mu_eff_tbl(i).error_msg );
2561:
2562: END LOOP;
2563: fnd_file.put_line (fnd_file.Log, '***********************************************************');
2559: fnd_file.put_line (fnd_file.output,RPad(l_err_mu_eff_tbl(i).line_number,11, ' ') ||' - '||
2560: l_err_mu_eff_tbl(i).error_msg );
2561:
2562: END LOOP;
2563: fnd_file.put_line (fnd_file.Log, '***********************************************************');
2564: END IF;
2565:
2566: IF x_overall_status IS NOT NULL THEN
2567: x_return_status := x_overall_status;
2574: l_api_name, ' Error while updating line' || SQLERRM);
2575:
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_effectivity_prc: '||x_return_status|| ' SQLERRM: '||SQLERRM);
2579: END mass_update_effectivity_prc;
2580:
2581: /*functions to be used internally*/
2582: FUNCTION oks_model_check(p_contract_id NUMBER, p_customer_prod_id NUMBER)