DBA Data[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on FND_FILE

Line 182: fnd_file.put_line(fnd_file.log, FND_MESSAGE.GET);

178: FETCH cur_person_id INTO rec_cur_person_id;
179:
180: IF cur_person_id%NOTFOUND THEN
181: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON_ID');
182: fnd_file.put_line(fnd_file.log, FND_MESSAGE.GET);
183: l_flag := FALSE;
184: END IF;
185: CLOSE cur_person_id;
186: ELSE

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

183: l_flag := FALSE;
184: END IF;
185: CLOSE cur_person_id;
186: ELSE
187: fnd_file.new_line(fnd_file.log);
188: END IF;
189: -- If the Person Id Group is not null, then validate if the Person Id Group is invalid
190:
191: IF p_person_id_grp IS NOT NULL THEN

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

195:
196: IF cur_person_id_group%NOTFOUND THEN
197: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PARAMETER');
198: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PERSON_ID_GRP');
199: fnd_file.put_line(fnd_file.log, fnd_message.get);
200: l_flag := FALSE;
201: END IF;
202: CLOSE cur_person_id_group;
203: ELSE

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

200: l_flag := FALSE;
201: END IF;
202: CLOSE cur_person_id_group;
203: ELSE
204: fnd_file.new_line(fnd_file.log);
205: END IF;
206:
207:
208: -- Validate if the Person Id and the Person ID Group both are not passed

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

209: -- simultaneously
210: IF ((p_person_id_grp IS NOT NULL) AND (p_person_id IS NOT NULL)) THEN
211: -- Return FALSE if both the parameters are NOT NULL.
212: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_OR_PRSIDGRP');
213: fnd_file.put_line(fnd_file.log, fnd_message.get);
214: l_flag := FALSE;
215: END IF;
216:
217:

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

221: FETCH cur_fee_ci INTO l_var;
222:
223: IF cur_fee_ci%NOTFOUND THEN
224: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_FEE_CAL_TYPE');
225: fnd_file.put_line(fnd_file.log,fnd_message.get);
226: l_flag := FALSE;
227: END IF;
228: CLOSE cur_fee_ci;
229:

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

235:
236: IF p_balance_type IS NOT NULL AND cur_balance_lkup_type%NOTFOUND THEN
237: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PARAMETER');
238: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BALANCE_TYPE');
239: fnd_file.put_line(fnd_file.log, fnd_message.get);
240: l_flag := FALSE;
241: END IF;
242: CLOSE cur_balance_lkup_type;
243:

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

248:
249:
250: IF cur_dcnt_reason_cd%NOTFOUND THEN
251: FND_MESSAGE.SET_NAME('IGS','IGS_EN_DISCONT_REAS_CD_CLOS');
252: fnd_file.put_line(fnd_file.log, fnd_message.get);
253: l_flag := FALSE;
254: END IF;
255: CLOSE cur_dcnt_reason_cd;
256:

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

260:
261: IF cur_test_run%NOTFOUND THEN
262: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PARAMETER');
263: FND_MESSAGE.SET_TOKEN('PARAMETER','P_TEST_RUN');
264: fnd_file.put_line(fnd_file.log, fnd_message.get);
265: l_flag := FALSE;
266: END IF;
267: CLOSE cur_test_run;
268: fnd_file.new_line(fnd_file.log);

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

264: fnd_file.put_line(fnd_file.log, fnd_message.get);
265: l_flag := FALSE;
266: END IF;
267: CLOSE cur_test_run;
268: fnd_file.new_line(fnd_file.log);
269:
270: RETURN l_flag;
271: END validate_input_parameters;
272:

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

527:
528: retcode:= 0;
529: -- logging input parameters
530: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
531: fnd_file.put_line(fnd_file.log,fnd_message.get);
532:
533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');
534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));
535:

Line 533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');

529: -- logging input parameters
530: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
531: fnd_file.put_line(fnd_file.log,fnd_message.get);
532:
533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');
534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));
535:
536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));

Line 534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));

530: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
531: fnd_file.put_line(fnd_file.log,fnd_message.get);
532:
533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');
534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));
535:
536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
538:

Line 536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');

532:
533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');
534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));
535:
536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
538:
539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);

Line 537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));

533: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')|| ': ');
534: fnd_file.put_line(fnd_file.log,igs_fi_gen_008.get_party_number(p_person_id));
535:
536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
538:
539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);
541:

Line 539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');

535:
536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
538:
539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);
541:
542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');
543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));

Line 540: fnd_file.put_line(fnd_file.log,p_fee_period);

536: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')|| ': ');
537: fnd_file.put_line(fnd_file.log,igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
538:
539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);
541:
542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');
543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));
544:

Line 542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');

538:
539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);
541:
542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');
543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));
544:
545: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DCNT_REASON_CD')|| ': ');
546: OPEN cur_dcnt_reason_cd(p_dcnt_reason_cd);

Line 543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));

539: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')|| ': ');
540: fnd_file.put_line(fnd_file.log,p_fee_period);
541:
542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');
543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));
544:
545: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DCNT_REASON_CD')|| ': ');
546: OPEN cur_dcnt_reason_cd(p_dcnt_reason_cd);
547: FETCH cur_dcnt_reason_cd INTO l_v_dcnt_reason_cd_desc;

Line 545: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DCNT_REASON_CD')|| ': ');

541:
542: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','BALANCE_TYPE')|| ': ');
543: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning(g_lookup_type,p_balance_type));
544:
545: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DCNT_REASON_CD')|| ': ');
546: OPEN cur_dcnt_reason_cd(p_dcnt_reason_cd);
547: FETCH cur_dcnt_reason_cd INTO l_v_dcnt_reason_cd_desc;
548: CLOSE cur_dcnt_reason_cd;
549: fnd_file.put_line(fnd_file.log,l_v_dcnt_reason_cd_desc);

Line 549: fnd_file.put_line(fnd_file.log,l_v_dcnt_reason_cd_desc);

545: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DCNT_REASON_CD')|| ': ');
546: OPEN cur_dcnt_reason_cd(p_dcnt_reason_cd);
547: FETCH cur_dcnt_reason_cd INTO l_v_dcnt_reason_cd_desc;
548: CLOSE cur_dcnt_reason_cd;
549: fnd_file.put_line(fnd_file.log,l_v_dcnt_reason_cd_desc);
550:
551: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE')|| ': ');
552: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_test_run));
553: -- end of logging the input parameters

Line 551: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE')|| ': ');

547: FETCH cur_dcnt_reason_cd INTO l_v_dcnt_reason_cd_desc;
548: CLOSE cur_dcnt_reason_cd;
549: fnd_file.put_line(fnd_file.log,l_v_dcnt_reason_cd_desc);
550:
551: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE')|| ': ');
552: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_test_run));
553: -- end of logging the input parameters
554:
555:

Line 552: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_test_run));

548: CLOSE cur_dcnt_reason_cd;
549: fnd_file.put_line(fnd_file.log,l_v_dcnt_reason_cd_desc);
550:
551: fnd_file.put(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE')|| ': ');
552: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_test_run));
553: -- end of logging the input parameters
554:
555:
556: -- Obtain the value of manage_accounts in the System Options form

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

559: p_v_message_name => l_v_message_name
560: );
561: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
562: fnd_message.set_name('IGS',l_v_message_name);
563: fnd_file.put_line(fnd_file.log,fnd_message.get());
564: fnd_file.new_line(fnd_file.log);
565: retcode := 2;
566: RETURN;
567: END IF;

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

560: );
561: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
562: fnd_message.set_name('IGS',l_v_message_name);
563: fnd_file.put_line(fnd_file.log,fnd_message.get());
564: fnd_file.new_line(fnd_file.log);
565: retcode := 2;
566: RETURN;
567: END IF;
568:

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

595: p_ret_ci_sequence_number=> l_ld_ci_sequence_number,
596: p_message_name => l_message
597: ) = FALSE THEN
598: FND_MESSAGE.SET_NAME('IGS', l_message);
599: fnd_file.put_line(fnd_file.log,fnd_message.get);
600: retcode:=2;
601: RETURN;
602: END IF;
603:

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

638: p_n_balance_rule_id => l_balance_rule_id,
639: p_d_last_conversion_date => l_last_conversion_date,
640: p_n_version_number => l_version_number );
641: IF l_version_number = 0 THEN
642: fnd_file.new_line(fnd_file.log);
643: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CANNOT_CRT_TXN');
644: fnd_file.put_line(fnd_file.log, fnd_message.get);
645: retcode:=2;
646: RETURN;

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

640: p_n_version_number => l_version_number );
641: IF l_version_number = 0 THEN
642: fnd_file.new_line(fnd_file.log);
643: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CANNOT_CRT_TXN');
644: fnd_file.put_line(fnd_file.log, fnd_message.get);
645: retcode:=2;
646: RETURN;
647: END IF;
648: ELSIF p_balance_type = 'FEE' THEN

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

657: -- Displaying appropriate message in the log file based on the
658: -- Test Run Parameter
659: IF p_test_run = g_yes_ind THEN
660: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WILL_DROP_UNITS');
661: fnd_file.put_line(fnd_file.log,fnd_message.get);
662: ELSE
663: FND_MESSAGE.SET_NAME('IGS','IGS_FI_HAVE_DROP_UNITS');
664: fnd_file.put_line(fnd_file.log,fnd_message.get );
665: END IF;

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

660: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WILL_DROP_UNITS');
661: fnd_file.put_line(fnd_file.log,fnd_message.get);
662: ELSE
663: FND_MESSAGE.SET_NAME('IGS','IGS_FI_HAVE_DROP_UNITS');
664: fnd_file.put_line(fnd_file.log,fnd_message.get );
665: END IF;
666:
667: --Bug 5123583, Removed the logic to display header like person number, enrollement date etc. used in the log file.
668:

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

834: --Bug 5123583, Removed the code to display all data through l_str local variable.
835: --Changed the tabular form of output to show records by person number.
836:
837: --Printing output in the log file.
838: fnd_file.put_line(fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_person_number);
839:
840: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NAME');
841: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_person_name);
842:

Line 841: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_person_name);

837: --Printing output in the log file.
838: fnd_file.put_line(fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_person_number);
839:
840: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NAME');
841: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_person_name);
842:
843: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP','COURSE')|| ': ' || rec_chrgs.course_cd);
844:
845: fnd_message.set_name('IGS', 'IGS_FI_UNIT_DTLS');

Line 843: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP','COURSE')|| ': ' || rec_chrgs.course_cd);

839:
840: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NAME');
841: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_person_name);
842:
843: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP','COURSE')|| ': ' || rec_chrgs.course_cd);
844:
845: fnd_message.set_name('IGS', 'IGS_FI_UNIT_DTLS');
846: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_str_enrl);
847:

Line 846: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_str_enrl);

842:
843: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP','COURSE')|| ': ' || rec_chrgs.course_cd);
844:
845: fnd_message.set_name('IGS', 'IGS_FI_UNIT_DTLS');
846: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || l_str_enrl);
847:
848: l_str_enrl := NULL;
849:
850: fnd_message.set_name('IGS', 'IGS_FI_ENR_DATE');

Line 851: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || TRUNC(l_enr_dtls.enrolled_dt));

847:
848: l_str_enrl := NULL;
849:
850: fnd_message.set_name('IGS', 'IGS_FI_ENR_DATE');
851: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || TRUNC(l_enr_dtls.enrolled_dt));
852:
853: --for separating one person details with the others
854: fnd_file.new_line(fnd_file.log);
855: END IF;

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

850: fnd_message.set_name('IGS', 'IGS_FI_ENR_DATE');
851: fnd_file.put_line(fnd_file.log, fnd_message.get || ': ' || TRUNC(l_enr_dtls.enrolled_dt));
852:
853: --for separating one person details with the others
854: fnd_file.new_line(fnd_file.log);
855: END IF;
856: END IF;
857: l_person_id := rec_chrgs.person_id;
858: l_course_cd := rec_chrgs.course_cd;

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

860:
861: EXCEPTION
862: WHEN e_skip_record THEN
863: fnd_message.set_name('IGS','IGS_FI_PP_NO_UNIT_DROP');
864: fnd_file.new_line(fnd_file.log);
865: fnd_file.put_line(fnd_file.log,l_str||' - '||fnd_message.get);
866: fnd_file.new_line(fnd_file.log);
867: END;
868: END IF; -- end of condition v_tab_chrgs_rec.EXISTS(l_n_cntr)

Line 865: fnd_file.put_line(fnd_file.log,l_str||' - '||fnd_message.get);

861: EXCEPTION
862: WHEN e_skip_record THEN
863: fnd_message.set_name('IGS','IGS_FI_PP_NO_UNIT_DROP');
864: fnd_file.new_line(fnd_file.log);
865: fnd_file.put_line(fnd_file.log,l_str||' - '||fnd_message.get);
866: fnd_file.new_line(fnd_file.log);
867: END;
868: END IF; -- end of condition v_tab_chrgs_rec.EXISTS(l_n_cntr)
869: END LOOP;

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

862: WHEN e_skip_record THEN
863: fnd_message.set_name('IGS','IGS_FI_PP_NO_UNIT_DROP');
864: fnd_file.new_line(fnd_file.log);
865: fnd_file.put_line(fnd_file.log,l_str||' - '||fnd_message.get);
866: fnd_file.new_line(fnd_file.log);
867: END;
868: END IF; -- end of condition v_tab_chrgs_rec.EXISTS(l_n_cntr)
869: END LOOP;
870: END IF;

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

871:
872: -- If there were no units identified for dropping, then log the appropriate message in the
873: -- log file of the concurrent manager.
874: IF l_cnt = 0 THEN
875: fnd_file.new_line(fnd_file.log);
876: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_DROP_UNITS');
877: fnd_file.put_line(fnd_file.log, fnd_message.get);
878: END IF;
879:

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

873: -- log file of the concurrent manager.
874: IF l_cnt = 0 THEN
875: fnd_file.new_line(fnd_file.log);
876: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_DROP_UNITS');
877: fnd_file.put_line(fnd_file.log, fnd_message.get);
878: END IF;
879:
880: -- If the test run flag is not Y, then the transactions need to be committed else
881: -- rollback to the savepoint