DBA Data[Home] [Help]

APPS.IGS_FI_REFUNDS_PROCESS dependencies on FND_MESSAGE

Line 211: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');

207: Who When What
208:
209: ********************************************************************************************** */
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 ;

Line 212: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);

208:
209: ********************************************************************************************** */
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:

Line 213: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;

209: ********************************************************************************************** */
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,

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 288: p_err_msg:=FND_MESSAGE.GET;

284: );
285: EXCEPTION
286: WHEN OTHERS THEN
287: p_dml_status:=FALSE;
288: p_err_msg:=FND_MESSAGE.GET;
289: --If any unexpected event occured , other than what is expected from TBH, say ORA errors , then
290: -- return that
291: IF p_err_msg IS NULL THEN
292: p_err_msg:=sqlerrm;

Line 364: p_err_msg:=FND_MESSAGE.GET;

360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: p_dml_status:=FALSE;
364: p_err_msg:=FND_MESSAGE.GET;
365: --If any unexpected event occured , other than what is expected from TBH, say ORA errors , then
366: -- return that
367: IF p_err_msg IS NULL THEN
368: p_err_msg:=sqlerrm;

Line 654: fnd_message.set_name('IGS',l_v_message_name);

650: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
651: p_v_message_name => l_v_message_name
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;

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 667: fnd_message.set_name('IGS','IGS_FI_RFND_DST_OTH');

663: -- The Refund destination set in igs_fi_control has to be 'Other' for this process to be run.
664: l_v_rfnd_destination := igs_fi_gen_apint.get_rfnd_destination;
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;

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 676: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

672: END IF;
673:
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;

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 683: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON');

679: l_valid_param := FALSE;
680: END IF;
681:
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;

Line 684: FND_MESSAGE.SET_TOKEN('PERSON_ID',TO_CHAR(p_person_id));

680: END IF;
681:
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;

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 691: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVPERS_ID_GRP');

687: l_valid_param := FALSE;
688: END IF;
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;

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 700: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');

696:
697: --Validates if start date is less than end date
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;

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 753: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

749: END IF;
750:
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;

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 762: fnd_message.set_name('IGS','IGS_FI_PRC_TEST_RUN');

758:
759: -- If run in test mode = Y and records have been processed,
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;

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 774: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')||':'||sqlerrm;

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 ;
776: END transfer_to_int;
777:
778:

Line 804: FND_MESSAGE.Set_Name('IGS',

800: ********************************************************************************************** */
801:
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;

Line 807: FND_MESSAGE.Get);

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
811: retcode := 2;

Line 812: FND_MESSAGE.Set_Name('IGS',

808: retcode := 0;
809: EXCEPTION
810: WHEN OTHERS THEN
811: retcode := 2;
812: FND_MESSAGE.Set_Name('IGS',
813: 'IGS_GE_UNHANDLED_EXCEPTION');
814: IGS_GE_MSG_STACK.Add;
815: APP_EXCEPTION.Raise_Exception;
816: END update_pay_info;