DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on FND_FILE

Line 566: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure pay_nl_general.insert_leg_rule');

562: l_rule_found varchar2(10):='N';
563:
564: begin
565: retcode := 0;
566: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure pay_nl_general.insert_leg_rule');
567:
568: OPEN c_leg_rule('RETRO_COMP_DFLT_OVERRIDE');
569: FETCH c_leg_rule INTO l_rule_found;
570:

Line 582: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Added,Retropay method is now REPLACEMENT');

578:
579:
580: if (p_retropay_method = 1 AND l_rule_found = 'N') then /* Replacement Method */
581: insert into pay_legislation_rules(legislation_code,rule_type,rule_mode) values ('NL','RETRO_COMP_DFLT_OVERRIDE','Y');
582: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Added,Retropay method is now REPLACEMENT');
583: else /*Standard Method*/
584: IF (p_retropay_method = 0 AND l_rule_found = 'Y') then
585: delete from pay_legislation_rules
586: where legislation_code='NL'

Line 588: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Removed,Retropay method is now STANDARD');

584: IF (p_retropay_method = 0 AND l_rule_found = 'Y') then
585: delete from pay_legislation_rules
586: where legislation_code='NL'
587: and rule_type='RETRO_COMP_DFLT_OVERRIDE';
588: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Removed,Retropay method is now STANDARD');
589: END if;
590: end if;
591: fnd_file.put_line(FND_FILE.LOG,'Leaving Procedure pay_nl_general.insert_leg_rule');
592: END insert_leg_rule;

Line 591: fnd_file.put_line(FND_FILE.LOG,'Leaving Procedure pay_nl_general.insert_leg_rule');

587: and rule_type='RETRO_COMP_DFLT_OVERRIDE';
588: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Removed,Retropay method is now STANDARD');
589: END if;
590: end if;
591: fnd_file.put_line(FND_FILE.LOG,'Leaving Procedure pay_nl_general.insert_leg_rule');
592: END insert_leg_rule;
593:
594:
595: ---------------------------------------------------------------------------