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

Line 147: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

143: l_cur_date cur_date%ROWTYPE;
144:
145: BEGIN
146:
147: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
148: IF g_last_person_id = p_person_id THEN
149: NULL;
150: ELSE
151: OPEN cur_pers(p_person_id);

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG,lookup_desc('IGS_FI_LOCKBOX','PERSON')||':'||l_cur_pers.party_number);

150: ELSE
151: OPEN cur_pers(p_person_id);
152: FETCH cur_pers INTO l_cur_pers;
153: CLOSE cur_pers;
154: FND_FILE.PUT_LINE(FND_FILE.LOG,lookup_desc('IGS_FI_LOCKBOX','PERSON')||':'||l_cur_pers.party_number);
155: END IF;
156: g_last_person_id:=p_person_id;
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG,g_five_space||lookup_desc('IGS_FI_LOCKBOX','REFUND_ID')||':'||TO_CHAR(p_refund_id));

Line 158: FND_FILE.PUT_LINE(FND_FILE.LOG,g_five_space||lookup_desc('IGS_FI_LOCKBOX','REFUND_ID')||':'||TO_CHAR(p_refund_id));

154: FND_FILE.PUT_LINE(FND_FILE.LOG,lookup_desc('IGS_FI_LOCKBOX','PERSON')||':'||l_cur_pers.party_number);
155: END IF;
156: g_last_person_id:=p_person_id;
157:
158: FND_FILE.PUT_LINE(FND_FILE.LOG,g_five_space||lookup_desc('IGS_FI_LOCKBOX','REFUND_ID')||':'||TO_CHAR(p_refund_id));
159:
160:
161: OPEN cur_inv;
162: FETCH cur_inv INTO l_cur_inv;

Line 164: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','INVOICE_NUMBER')||':'||l_cur_inv.invoice_number);

160:
161: OPEN cur_inv;
162: FETCH cur_inv INTO l_cur_inv;
163: CLOSE cur_inv;
164: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','INVOICE_NUMBER')||':'||l_cur_inv.invoice_number);
165:
166: OPEN cur_pers(p_pay_person_id);
167: FETCH cur_pers INTO l_cur_pers;
168: CLOSE cur_pers;

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','PAYEE')||':'||l_cur_pers.party_number);

165:
166: OPEN cur_pers(p_pay_person_id);
167: FETCH cur_pers INTO l_cur_pers;
168: CLOSE cur_pers;
169: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','PAYEE')||':'||l_cur_pers.party_number);
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE')||':'||p_fee_type);
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||':'||p_fee_cal_type);

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE')||':'||p_fee_type);

167: FETCH cur_pers INTO l_cur_pers;
168: CLOSE cur_pers;
169: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','PAYEE')||':'||l_cur_pers.party_number);
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE')||':'||p_fee_type);
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||':'||p_fee_cal_type);
174:
175: OPEN cur_date;

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||':'||p_fee_cal_type);

169: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','PAYEE')||':'||l_cur_pers.party_number);
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_TYPE')||':'||p_fee_type);
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||':'||p_fee_cal_type);
174:
175: OPEN cur_date;
176: FETCH cur_date INTO l_cur_date;
177: CLOSE cur_date;

Line 178: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','START_DT')||':'||TO_CHAR(l_cur_date.start_dt,'DD-MON-YYYY'));

174:
175: OPEN cur_date;
176: FETCH cur_date INTO l_cur_date;
177: CLOSE cur_date;
178: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','START_DT')||':'||TO_CHAR(l_cur_date.start_dt,'DD-MON-YYYY'));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','END_DT')||':'||TO_CHAR(l_cur_date.end_dt,'DD-MON-YYYY'));
181:
182: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REVERSED')||':'||lookup_desc('VS_AS_YN',p_reversal_ind));

Line 180: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','END_DT')||':'||TO_CHAR(l_cur_date.end_dt,'DD-MON-YYYY'));

176: FETCH cur_date INTO l_cur_date;
177: CLOSE cur_date;
178: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','START_DT')||':'||TO_CHAR(l_cur_date.start_dt,'DD-MON-YYYY'));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','END_DT')||':'||TO_CHAR(l_cur_date.end_dt,'DD-MON-YYYY'));
181:
182: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REVERSED')||':'||lookup_desc('VS_AS_YN',p_reversal_ind));
183:
184: IF p_status THEN

Line 182: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REVERSED')||':'||lookup_desc('VS_AS_YN',p_reversal_ind));

178: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','START_DT')||':'||TO_CHAR(l_cur_date.start_dt,'DD-MON-YYYY'));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','END_DT')||':'||TO_CHAR(l_cur_date.end_dt,'DD-MON-YYYY'));
181:
182: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REVERSED')||':'||lookup_desc('VS_AS_YN',p_reversal_ind));
183:
184: IF p_status THEN
185: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||
186: lookup_desc('REFUND_TRANSFER_STATUS',p_rec_status));

Line 185: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||

181:
182: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REVERSED')||':'||lookup_desc('VS_AS_YN',p_reversal_ind));
183:
184: IF p_status THEN
185: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||
186: lookup_desc('REFUND_TRANSFER_STATUS',p_rec_status));
187: ELSE
188: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||lookup_desc('IGS_FI_LOCKBOX','ERROR'));
189: END IF;

Line 188: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||lookup_desc('IGS_FI_LOCKBOX','ERROR'));

184: IF p_status THEN
185: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||
186: lookup_desc('REFUND_TRANSFER_STATUS',p_rec_status));
187: ELSE
188: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||lookup_desc('IGS_FI_LOCKBOX','ERROR'));
189: END IF;
190:
191: IF p_status=FALSE THEN
192: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REASON')||':'||p_err_msg);

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REASON')||':'||p_err_msg);

188: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','STATUS')||':'||lookup_desc('IGS_FI_LOCKBOX','ERROR'));
189: END IF;
190:
191: IF p_status=FALSE THEN
192: FND_FILE.PUT_LINE(FND_FILE.LOG,g_ten_space||lookup_desc('IGS_FI_LOCKBOX','REASON')||':'||p_err_msg);
193: END IF;
194: END log_person;
195:
196: PROCEDURE log_messages ( p_msg_name VARCHAR2 ,

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

210: BEGIN
211: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
212: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
213: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
215: END log_messages ;
216:
217: PROCEDURE update_refunds(p_status IN igs_fi_refunds.transfer_status%TYPE,
218: p_cur_ref_upd IN cur_refund%ROWTYPE ,

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

652: );
653: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
654: fnd_message.set_name('IGS',l_v_message_name);
655: igs_ge_msg_stack.add;
656: fnd_file.put_line(fnd_file.log,fnd_message.get());
657: fnd_file.put_line(fnd_file.log,' ');
658: retcode := 2;
659: RETURN;
660: END IF;

Line 657: fnd_file.put_line(fnd_file.log,' ');

653: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
654: fnd_message.set_name('IGS',l_v_message_name);
655: igs_ge_msg_stack.add;
656: fnd_file.put_line(fnd_file.log,fnd_message.get());
657: fnd_file.put_line(fnd_file.log,' ');
658: retcode := 2;
659: RETURN;
660: END IF;
661:

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

665:
666: IF (l_v_rfnd_destination = 'PAYABLES') OR (l_v_rfnd_destination IS NULL) THEN
667: fnd_message.set_name('IGS','IGS_FI_RFND_DST_OTH');
668: igs_ge_msg_stack.add;
669: fnd_file.put_line(fnd_file.log,fnd_message.get);
670: retcode := 2;
671: RETURN;
672: END IF;
673:

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

674: --Validates if both person_id and person id group is passed
675: IF ((p_person_id IS NOT NULL) AND (p_person_id_grp IS NOT NULL)) THEN
676: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
677: IGS_GE_MSG_STACK.ADD;
678: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
679: l_valid_param := FALSE;
680: END IF;
681:
682: IF NOT l_pers_valid THEN

Line 686: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

682: IF NOT l_pers_valid THEN
683: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON');
684: FND_MESSAGE.SET_TOKEN('PERSON_ID',TO_CHAR(p_person_id));
685: IGS_GE_MSG_STACK.ADD;
686: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
687: l_valid_param := FALSE;
688: END IF;
689:
690: IF NOT l_pers_id_grp THEN

Line 693: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

689:
690: IF NOT l_pers_id_grp THEN
691: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVPERS_ID_GRP');
692: IGS_GE_MSG_STACK.ADD;
693: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
694: l_valid_param := FALSE;
695: END IF;
696:
697: --Validates if start date is less than end date

Line 702: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

698: IF ((p_start_date IS NOT NULL) AND (p_end_date IS NOT NULL)) THEN
699: IF l_start_date > l_end_date THEN
700: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
701: IGS_GE_MSG_STACK.ADD;
702: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
703: l_valid_param := FALSE;
704: END IF;
705: END IF;
706:

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

751: -- Log message if no data found for processing
752: IF (NOT g_b_data_found) THEN
753: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
754: igs_ge_msg_stack.add;
755: fnd_file.put_line(fnd_file.log,fnd_message.get);
756: fnd_file.new_line(fnd_file.log);
757: END IF;
758:
759: -- If run in test mode = Y and records have been processed,

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

752: IF (NOT g_b_data_found) THEN
753: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
754: igs_ge_msg_stack.add;
755: fnd_file.put_line(fnd_file.log,fnd_message.get);
756: fnd_file.new_line(fnd_file.log);
757: END IF;
758:
759: -- If run in test mode = Y and records have been processed,
760: -- log message saying transactions have been rolled back

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

760: -- log message saying transactions have been rolled back
761: IF (p_test_run = 'Y') AND (g_b_data_found = TRUE) THEN
762: fnd_message.set_name('IGS','IGS_FI_PRC_TEST_RUN');
763: igs_ge_msg_stack.add;
764: fnd_file.new_line(fnd_file.log);
765: fnd_file.put_line(fnd_file.log,fnd_message.get);
766: END IF;
767:
768: EXCEPTION

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

761: IF (p_test_run = 'Y') AND (g_b_data_found = TRUE) THEN
762: fnd_message.set_name('IGS','IGS_FI_PRC_TEST_RUN');
763: igs_ge_msg_stack.add;
764: fnd_file.new_line(fnd_file.log);
765: fnd_file.put_line(fnd_file.log,fnd_message.get);
766: END IF;
767:
768: EXCEPTION
769: WHEN e_resource_busy THEN

Line 771: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_FI_RFND_REC_LOCK'));

767:
768: EXCEPTION
769: WHEN e_resource_busy THEN
770: retcode := 2;
771: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_FI_RFND_REC_LOCK'));
772: WHEN OTHERS THEN
773: retcode := 2;
774: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||':'||sqlerrm;
775: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;

Line 806: FND_FILE.Put_Line(FND_FILE.Log,

802: BEGIN
803: --Bug# 2442030, Concurrent Process is obsoleted, and hence nullified the code
804: FND_MESSAGE.Set_Name('IGS',
805: 'IGS_GE_OBSOLETE_JOB');
806: FND_FILE.Put_Line(FND_FILE.Log,
807: FND_MESSAGE.Get);
808: retcode := 0;
809: EXCEPTION
810: WHEN OTHERS THEN