DBA Data[Home] [Help]

APPS.IGS_FI_CC_PMT dependencies on FND_FILE

Line 112: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_c_pnum);

108: FETCH c_pers INTO l_c_pnum;
109: CLOSE c_pers;
110:
111: -- Log the person number
112: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_c_pnum);
113:
114: -- Update the OSS Tables (Credits, Admissions Applications Request)
115: -- only if the credit card status is changed to failure or success
116: -- from 'Pending'

Line 124: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RECEIPT_NUMBER')||': '||p_r_crd_row.credit_number);

120:
121: IF p_r_crd_row.party_id IS NOT NULL THEN
122:
123: -- Log the Receipt Number
124: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RECEIPT_NUMBER')||': '||p_r_crd_row.credit_number);
125:
126: IF l_flag THEN
127: -- Update the credit card status in the Credits Table
128: SAVEPOINT sp_crd;

Line 197: fnd_file.put_line(fnd_file.log,sqlerrm);

193: EXCEPTION
194: WHEN OTHERS THEN
195: ROLLBACK TO sp_crd;
196: l_b_exception_flag := TRUE;
197: fnd_file.put_line(fnd_file.log,sqlerrm);
198: fnd_file.new_line(fnd_file.log);
199: END;
200: END IF; -- For l_flag
201:

Line 198: fnd_file.new_line(fnd_file.log);

194: WHEN OTHERS THEN
195: ROLLBACK TO sp_crd;
196: l_b_exception_flag := TRUE;
197: fnd_file.put_line(fnd_file.log,sqlerrm);
198: fnd_file.new_line(fnd_file.log);
199: END;
200: END IF; -- For l_flag
201:
202: ELSIF p_r_ad_app_row.person_id IS NOT NULL THEN

Line 205: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ADM_APPL_ID')||': '||p_r_ad_app_row.app_req_id);

201:
202: ELSIF p_r_ad_app_row.person_id IS NOT NULL THEN
203:
204: -- Log the Admission Application Id
205: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ADM_APPL_ID')||': '||p_r_ad_app_row.app_req_id);
206:
207: IF l_flag THEN
208: SAVEPOINT sp_adm;
209: BEGIN

Line 242: fnd_file.put_line(fnd_file.log,sqlerrm);

238: EXCEPTION
239: WHEN OTHERS THEN
240: ROLLBACK TO sp_adm;
241: l_b_exception_flag := TRUE;
242: fnd_file.put_line(fnd_file.log,sqlerrm);
243: fnd_file.new_line(fnd_file.log);
244: END;
245: END IF;
246: END IF;

Line 243: fnd_file.new_line(fnd_file.log);

239: WHEN OTHERS THEN
240: ROLLBACK TO sp_adm;
241: l_b_exception_flag := TRUE;
242: fnd_file.put_line(fnd_file.log,sqlerrm);
243: fnd_file.new_line(fnd_file.log);
244: END;
245: END IF;
246: END IF;
247:

Line 250: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CC_STATUS')||': '||

246: END IF;
247:
248: IF NOT l_b_exception_flag THEN
249: -- Log the Credit Card Status of the person
250: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CC_STATUS')||': '||
251: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CARD_STATUS',l_c_cc_status));
252: fnd_file.new_line(fnd_file.log);
253: END IF;
254:

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

248: IF NOT l_b_exception_flag THEN
249: -- Log the Credit Card Status of the person
250: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CC_STATUS')||': '||
251: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CARD_STATUS',l_c_cc_status));
252: fnd_file.new_line(fnd_file.log);
253: END IF;
254:
255: END local_upd;
256:

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

284: l_org_id := NULL;
285: igs_ge_gen_003.set_org_id(l_org_id);
286: EXCEPTION
287: WHEN OTHERS THEN
288: fnd_file.put_line (fnd_file.log, fnd_message.get);
289: retcode:=2;
290: RETURN;
291: END;
292: retcode := 0;

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

299:
300: -- If Manage Accounts is 'Other' or Null, then this process is not available.
301: IF (l_c_manage_acc = 'OTHER') OR (l_c_manage_acc IS NULL) THEN
302: fnd_message.set_name('IGS',l_c_message_name);
303: fnd_file.put_line(fnd_file.log,fnd_message.get());
304: fnd_file.new_line(fnd_file.log);
305: retcode := 2;
306: RETURN;
307: END IF;

Line 304: fnd_file.new_line(fnd_file.log);

300: -- If Manage Accounts is 'Other' or Null, then this process is not available.
301: IF (l_c_manage_acc = 'OTHER') OR (l_c_manage_acc IS NULL) THEN
302: fnd_message.set_name('IGS',l_c_message_name);
303: fnd_file.put_line(fnd_file.log,fnd_message.get());
304: fnd_file.new_line(fnd_file.log);
305: retcode := 2;
306: RETURN;
307: END IF;
308:

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

323:
324: -- Log a message if there are no records to process
325: IF NOT l_b_records THEN
326: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
327: fnd_file.put_line(fnd_file.log,fnd_message.get());
328: END IF;
329:
330:
331: EXCEPTION

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

331: EXCEPTION
332: WHEN e_resource_busy THEN
333: ROLLBACK;
334: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
335: fnd_file.put_line(fnd_file.log,fnd_message.get());
336: fnd_file.new_line(fnd_file.log);
337: retcode := 2;
338:
339: WHEN OTHERS THEN

Line 336: fnd_file.new_line(fnd_file.log);

332: WHEN e_resource_busy THEN
333: ROLLBACK;
334: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
335: fnd_file.put_line(fnd_file.log,fnd_message.get());
336: fnd_file.new_line(fnd_file.log);
337: retcode := 2;
338:
339: WHEN OTHERS THEN
340: ROLLBACK;