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

Line 117: fnd_file.new_line(fnd_file.log,1);

113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','p_item_code:'||p_item_code);
114: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','p_term:'||p_term);
115: END IF;
116:
117: fnd_file.new_line(fnd_file.log,1);
118:
119: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
120: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
121:

Line 119: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

115: END IF;
116:
117: fnd_file.new_line(fnd_file.log,1);
118:
119: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
120: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
121:
122: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40) ||': '||p_run_type );
123:

Line 120: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));

116:
117: fnd_file.new_line(fnd_file.log,1);
118:
119: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
120: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
121:
122: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40) ||': '||p_run_type );
123:
124: OPEN c_group_code(p_pid_group);

Line 122: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40) ||': '||p_run_type );

118:
119: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
120: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
121:
122: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40) ||': '||p_run_type );
123:
124: OPEN c_group_code(p_pid_group);
125: FETCH c_group_code INTO l_grp_cd;
126: CLOSE c_group_code;

Line 128: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);

124: OPEN c_group_code(p_pid_group);
125: FETCH c_group_code INTO l_grp_cd;
126: CLOSE c_group_code;
127:
128: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:

Line 129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));

125: FETCH c_group_code INTO l_grp_cd;
126: CLOSE c_group_code;
127:
128: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:
133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));

Line 130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));

126: CLOSE c_group_code;
127:
128: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:
133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));
134:

Line 131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);

127:
128: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:
133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));
134:
135: fnd_file.new_line(fnd_file.log,2);

Line 133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));

129: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
130: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:
133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));
134:
135: fnd_file.new_line(fnd_file.log,2);
136:
137: IF (p_award_year IS NULL) OR (p_run_type IS NULL) OR (p_run_mode IS NULL) THEN

Line 135: fnd_file.new_line(fnd_file.log,2);

131: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','ITEM_CODE'),40) ||': '|| p_item_code);
132:
133: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TERM'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ld_cal_type,ln_ld_sequence_number));
134:
135: fnd_file.new_line(fnd_file.log,2);
136:
137: IF (p_award_year IS NULL) OR (p_run_type IS NULL) OR (p_run_mode IS NULL) THEN
138: RAISE param_exception;
139:

Line 150: fnd_file.put_line(fnd_file.log,fnd_message.get);

146: --If person selection is for all persons in the Person ID Group and
147: --Person ID Group is NULL then log error with exception
148: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
149: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
150: fnd_file.put_line(fnd_file.log,fnd_message.get);
151: RAISE param_exception;
152:
153: --If person selection is for a single person and
154: --Base ID is NULL then log error with exception

Line 157: fnd_file.put_line(fnd_file.log,fnd_message.get);

153: --If person selection is for a single person and
154: --Base ID is NULL then log error with exception
155: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
156: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: RAISE param_exception;
159:
160: END IF;
161:

Line 163: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

159:
160: END IF;
161:
162:
163: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
164:
165: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
166: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
167:

Line 168: fnd_file.new_line(fnd_file.log,1);

164:
165: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
166: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
167:
168: fnd_file.new_line(fnd_file.log,1);
169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
171: fnd_file.put_line(fnd_file.log,fnd_message.get);
172:

Line 171: fnd_file.put_line(fnd_file.log,fnd_message.get);

167:
168: fnd_file.new_line(fnd_file.log,1);
169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
171: fnd_file.put_line(fnd_file.log,fnd_message.get);
172:
173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
174: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=S with base_id:'||p_base_id);
175: END IF;

Line 191: fnd_file.new_line(fnd_file.log,1);

187: --COMPUTATION FOR AWARD YEAR ONLY
188: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN
189: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
190: LOOP
191: fnd_file.new_line(fnd_file.log,1);
192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
194: fnd_file.put_line(fnd_file.log,fnd_message.get);
195:

Line 194: fnd_file.put_line(fnd_file.log,fnd_message.get);

190: LOOP
191: fnd_file.new_line(fnd_file.log,1);
192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
194: fnd_file.put_line(fnd_file.log,fnd_message.get);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
198: END IF;

Line 236: fnd_file.put_line(fnd_file.log,fnd_message.get);

232: FETCH cur_per_grp INTO per_grp_rec;
233:
234: IF (cur_per_grp%NOTFOUND) THEN
235: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
236: fnd_file.put_line(fnd_file.log,fnd_message.get);
237: ELSE
238: LOOP
239: -- check if person has a fa base record
240: ln_base_id := NULL;

Line 252: fnd_file.new_line(fnd_file.log,1);

248: lv_err_msg
249: );
250:
251: IF lv_err_msg = 'NULL' THEN
252: fnd_file.new_line(fnd_file.log,1);
253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
255: fnd_file.put_line(fnd_file.log,fnd_message.get);
256:

Line 255: fnd_file.put_line(fnd_file.log,fnd_message.get);

251: IF lv_err_msg = 'NULL' THEN
252: fnd_file.new_line(fnd_file.log,1);
253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
255: fnd_file.put_line(fnd_file.log,fnd_message.get);
256:
257: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
258: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);
259: END IF;

Line 278: fnd_file.new_line(fnd_file.log,1);

274: CLOSE c_person_no;
275:
276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
277: fnd_message.set_token('STUD',l_person_no.party_number);
278: fnd_file.new_line(fnd_file.log,1);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280: END IF;
281:
282: FETCH cur_per_grp INTO per_grp_rec;

Line 279: fnd_file.put_line(fnd_file.log,fnd_message.get);

275:
276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
277: fnd_message.set_token('STUD',l_person_no.party_number);
278: fnd_file.new_line(fnd_file.log,1);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280: END IF;
281:
282: FETCH cur_per_grp INTO per_grp_rec;
283: EXIT WHEN cur_per_grp%NOTFOUND;

Line 291: fnd_file.new_line(fnd_file.log,1);

287: END IF; -- end of IF (cur_per_grp%NOTFOUND)
288:
289: END IF;
290:
291: fnd_file.new_line(fnd_file.log,1);
292: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
293:
294:
295: COMMIT;

Line 292: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

288:
289: END IF;
290:
291: fnd_file.new_line(fnd_file.log,1);
292: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
293:
294:
295: COMMIT;
296: