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

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

67:
68: BEGIN
69:
70: lv_procedure_name := '.enable_retro_overlap';
71: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
72: lv_legislation_code := 'CA';
73:
74: -- These are the legislation rules to check whether Enhanced Retropay is enabled or not
75: ltt_rule_type(1) := 'RETRO_DELETE';

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

90: THEN
91: lv_qualified := 'Y';
92: ELSE
93: lv_qualified := 'N';
94: 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));
95: fnd_file.put_line(fnd_file.log,'Enhanced RetroPay is not enabled');
96: exit;
97: END IF;
98:

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

91: lv_qualified := 'Y';
92: ELSE
93: lv_qualified := 'N';
94: 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));
95: fnd_file.put_line(fnd_file.log,'Enhanced RetroPay is not enabled');
96: exit;
97: END IF;
98:
99: CLOSE c_retro_rule_check;

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

122: IF c_retro_rule_check%FOUND
123: THEN
124: IF (ltt_rule_mode(3)= ln_exists)
125: THEN
126: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
127: ELSE
128: -- Updating Rero Ovelap rule mode to N
129: UPDATE pay_legislation_rules
130: SET RULE_MODE = ltt_rule_mode(3)

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

129: UPDATE pay_legislation_rules
130: SET RULE_MODE = ltt_rule_mode(3)
131: WHERE legislation_code = lv_legislation_code
132: AND rule_type = ltt_rule_type(3);
133: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
134: END IF;
135:
136: ELSE
137: --If Retro Overlap is not enabled inserting new legislation rule

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

136: ELSE
137: --If Retro Overlap is not enabled inserting new legislation rule
138: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
139: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
140: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
141: END IF;
142:
143: CLOSE c_retro_rule_check;
144: ElSE

Line 145: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );

141: END IF;
142:
143: CLOSE c_retro_rule_check;
144: ElSE
145: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );
146: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
147: END IF;
148: CLOSE c_upgrade_status;
149: ELSE

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

142:
143: CLOSE c_retro_rule_check;
144: ElSE
145: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );
146: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
147: END IF;
148: CLOSE c_upgrade_status;
149: ELSE
150: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');

Line 150: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');

146: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
147: END IF;
148: CLOSE c_upgrade_status;
149: ELSE
150: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');
151: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');
152: END IF;
153: CLOSE c_upgrade_definitions;
154: END IF;

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

147: END IF;
148: CLOSE c_upgrade_status;
149: ELSE
150: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');
151: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');
152: END IF;
153: CLOSE c_upgrade_definitions;
154: END IF;
155:

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

152: END IF;
153: CLOSE c_upgrade_definitions;
154: END IF;
155:
156: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
157:
158: EXCEPTION
159: WHEN others
160: THEN

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

157:
158: EXCEPTION
159: WHEN others
160: THEN
161: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
162: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
163: RAISE;
164: END enable_retro_overlap;
165:

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

158: EXCEPTION
159: WHEN others
160: THEN
161: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
162: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
163: RAISE;
164: END enable_retro_overlap;
165:
166: BEGIN