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.PAY_GB_RETRO_OVERLAP dependencies on FND_FILE

Line 59: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);

55:
56: BEGIN
57:
58: lv_procedure_name := '.enable_retro_overlap';
59: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
60: lv_legislation_code := 'GB';
61:
62: -- These are the legislation rules to check whether Enhanced Retropay is enabled or not
63: ltt_rule_type(1) := 'RETRO_DELETE';

Line 82: fnd_file.put_line(fnd_file.log,'Retro Overlap upgrade not performed when '||ltt_rule_type(i)||' legislation rule is not set to '||ltt_rule_mode(i));

78: THEN
79: lv_qualified := 'Y';
80: ELSE
81: lv_qualified := 'N';
82: fnd_file.put_line(fnd_file.log,'Retro Overlap upgrade not performed when '||ltt_rule_type(i)||' legislation rule is not set to '||ltt_rule_mode(i));
83: fnd_file.put_line(fnd_file.log,'Enhanced RetroPay is not enabled');
84: exit;
85: END IF;
86:

Line 83: fnd_file.put_line(fnd_file.log,'Enhanced RetroPay is not enabled');

79: lv_qualified := 'Y';
80: ELSE
81: lv_qualified := 'N';
82: fnd_file.put_line(fnd_file.log,'Retro Overlap upgrade not performed when '||ltt_rule_type(i)||' legislation rule is not set to '||ltt_rule_mode(i));
83: fnd_file.put_line(fnd_file.log,'Enhanced RetroPay is not enabled');
84: exit;
85: END IF;
86:
87: CLOSE c_retro_rule_check;

Line 114: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');

110: IF c_retro_rule_check%FOUND
111: THEN
112: IF (ltt_rule_mode(3)= ln_exists)
113: THEN
114: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
115: ELSE
116: -- Updating Rero Ovelap rule mode to N
117: UPDATE pay_legislation_rules
118: SET RULE_MODE = ltt_rule_mode(3)

Line 121: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

117: UPDATE pay_legislation_rules
118: SET RULE_MODE = ltt_rule_mode(3)
119: WHERE legislation_code = lv_legislation_code
120: AND rule_type = ltt_rule_type(3);
121: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
122: END IF;
123:
124: ELSE
125: --If Retro Overlap is not enabled inserting new legislation rule

Line 128: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

124: ELSE
125: --If Retro Overlap is not enabled inserting new legislation rule
126: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
127: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
128: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
129: END IF;
130:
131: CLOSE c_retro_rule_check;
132: ElSE

Line 133: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');

129: END IF;
130:
131: CLOSE c_retro_rule_check;
132: ElSE
133: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
134: END IF;
135: CLOSE c_upgrade_status;
136: ELSE
137: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');

Line 137: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');

133: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
134: END IF;
135: CLOSE c_upgrade_status;
136: ELSE
137: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');
138: END IF;
139: CLOSE c_upgrade_definitions;
140: END IF;
141:

Line 142: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);

138: END IF;
139: CLOSE c_upgrade_definitions;
140: END IF;
141:
142: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
143:
144: EXCEPTION
145: WHEN others
146: THEN

Line 147: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

143:
144: EXCEPTION
145: WHEN others
146: THEN
147: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
148: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
149: RAISE;
150: END enable_retro_overlap;
151:

Line 148: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

144: EXCEPTION
145: WHEN others
146: THEN
147: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
148: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
149: RAISE;
150: END enable_retro_overlap;
151:
152: BEGIN