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_EN_GEN_018 dependencies on FND_MESSAGE

Line 53: --than 30 chars, fnd_message returns the same text if it cant find a match.

49: IF SUBSTR(p_messages,i,1) = cst_delimiter THEN
50: --If any call to igs_ss_en_wrappers results in a exception
51: --Then l_mesg_name contains the exception text and should not be translated
52: --Message texts are generally more than 30 chars and even if they are less
53: --than 30 chars, fnd_message returns the same text if it cant find a match.
54: --If messages larger than 30 chars (max size if msg_name field) are passed to
55: --fnd_message, an plsql exception is thrown.Hence the check for 30 characters size.
56: IF LENGTH(l_mesg_name)<=30 THEN
57: l_str_place :=INSTR(l_mesg_name,'*');

Line 55: --fnd_message, an plsql exception is thrown.Hence the check for 30 characters size.

51: --Then l_mesg_name contains the exception text and should not be translated
52: --Message texts are generally more than 30 chars and even if they are less
53: --than 30 chars, fnd_message returns the same text if it cant find a match.
54: --If messages larger than 30 chars (max size if msg_name field) are passed to
55: --fnd_message, an plsql exception is thrown.Hence the check for 30 characters size.
56: IF LENGTH(l_mesg_name)<=30 THEN
57: l_str_place :=INSTR(l_mesg_name,'*');
58: IF l_str_place <> 0 THEN
59: l_msg_token:= SUBSTR(l_mesg_name,l_str_place+1);

Line 61: fnd_message.set_name('IGS',l_mesg_name);

57: l_str_place :=INSTR(l_mesg_name,'*');
58: IF l_str_place <> 0 THEN
59: l_msg_token:= SUBSTR(l_mesg_name,l_str_place+1);
60: l_mesg_name:= SUBSTR(l_mesg_name,1,l_str_place-1);
61: fnd_message.set_name('IGS',l_mesg_name);
62: fnd_message.set_token('UNIT_CD',l_msg_token);
63: ELSE
64: fnd_message.set_name('IGS',l_mesg_name);
65: END IF;

Line 62: fnd_message.set_token('UNIT_CD',l_msg_token);

58: IF l_str_place <> 0 THEN
59: l_msg_token:= SUBSTR(l_mesg_name,l_str_place+1);
60: l_mesg_name:= SUBSTR(l_mesg_name,1,l_str_place-1);
61: fnd_message.set_name('IGS',l_mesg_name);
62: fnd_message.set_token('UNIT_CD',l_msg_token);
63: ELSE
64: fnd_message.set_name('IGS',l_mesg_name);
65: END IF;
66: l_mesg_text:=fnd_message.get;

Line 64: fnd_message.set_name('IGS',l_mesg_name);

60: l_mesg_name:= SUBSTR(l_mesg_name,1,l_str_place-1);
61: fnd_message.set_name('IGS',l_mesg_name);
62: fnd_message.set_token('UNIT_CD',l_msg_token);
63: ELSE
64: fnd_message.set_name('IGS',l_mesg_name);
65: END IF;
66: l_mesg_text:=fnd_message.get;
67: ELSE
68: l_mesg_text:=l_mesg_name;

Line 66: l_mesg_text:=fnd_message.get;

62: fnd_message.set_token('UNIT_CD',l_msg_token);
63: ELSE
64: fnd_message.set_name('IGS',l_mesg_name);
65: END IF;
66: l_mesg_text:=fnd_message.get;
67: ELSE
68: l_mesg_text:=l_mesg_name;
69: END IF; --30 character message name
70:

Line 141: fnd_message.set_name('IGS','IGS_EN_BLK_PER_MSG');

137: IF p_load_alt_code IS NULL THEN -- group header has not yet been put..teach code will be not null only in case of teach calendar errors or relationship errors
138: --group header
139: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
140: IF p_program_cd IS NULL THEN
141: fnd_message.set_name('IGS','IGS_EN_BLK_PER_MSG');
142: ELSE
143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');
144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));
145: END IF;

Line 143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');

139: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
140: IF p_program_cd IS NULL THEN
141: fnd_message.set_name('IGS','IGS_EN_BLK_PER_MSG');
142: ELSE
143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');
144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));
145: END IF;
146: fnd_message.set_token('PERNUM', p_person_number);
147: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

Line 144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));

140: IF p_program_cd IS NULL THEN
141: fnd_message.set_name('IGS','IGS_EN_BLK_PER_MSG');
142: ELSE
143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');
144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));
145: END IF;
146: fnd_message.set_token('PERNUM', p_person_number);
147: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
148: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));

Line 146: fnd_message.set_token('PERNUM', p_person_number);

142: ELSE
143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');
144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));
145: END IF;
146: fnd_message.set_token('PERNUM', p_person_number);
147: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
148: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
149: END IF;
150: WHILE l_fcount < LENGTH(l_message) LOOP

Line 147: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

143: fnd_message.set_name('IGS','IGS_EN_BLK_PER_PRO');
144: fnd_message.set_token('PRGCD',NVL(p_program_cd,''' '''));
145: END IF;
146: fnd_message.set_token('PERNUM', p_person_number);
147: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
148: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
149: END IF;
150: WHILE l_fcount < LENGTH(l_message) LOOP
151: l_lcount:=INSTR(l_message,';',l_fcount);

Line 189: fnd_file.put_line(Fnd_File.LOG, rpad(fnd_message.get_string('IGS','IGS_EN_BLK_GRP_UID'),20,' ')||fnd_message.get_string('IGS','IGS_EN_BLK_GRP_UMSG'));

185:
186:
187: BEGIN
188: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
189: fnd_file.put_line(Fnd_File.LOG, rpad(fnd_message.get_string('IGS','IGS_EN_BLK_GRP_UID'),20,' ')||fnd_message.get_string('IGS','IGS_EN_BLK_GRP_UMSG'));
190: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'-'));
191: FOR i IN 0.. l_msg_rec_ind-1
192: LOOP
193:

Line 599: Fnd_message.set_name('IGS','IGS_SS_EN_NOENR_METHOD');

595: --Derive the --enrollment method
596: IF p_ovr_enr_method IS NULL THEN
597: igs_en_gen_017.enrp_get_enr_method (l_enr_method,l_error_message,l_ret_status);
598: IF l_ret_status='FALSE' THEN
599: Fnd_message.set_name('IGS','IGS_SS_EN_NOENR_METHOD');
600: Fnd_file.put_line(fnd_file.log,fnd_message.get);
601: retcode:=2;
602: RETURN;
603: END IF;

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

596: IF p_ovr_enr_method IS NULL THEN
597: igs_en_gen_017.enrp_get_enr_method (l_enr_method,l_error_message,l_ret_status);
598: IF l_ret_status='FALSE' THEN
599: Fnd_message.set_name('IGS','IGS_SS_EN_NOENR_METHOD');
600: Fnd_file.put_line(fnd_file.log,fnd_message.get);
601: retcode:=2;
602: RETURN;
603: END IF;
604: ELSE

Line 614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);

610: --Log header
611: OPEN c_batch_desc(p_batch_id);
612: FETCH c_batch_desc INTO l_batch_desc;
613: CLOSE c_batch_desc;
614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);
615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);

Line 615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');

611: OPEN c_batch_desc(p_batch_id);
612: FETCH c_batch_desc INTO l_batch_desc;
613: CLOSE c_batch_desc;
614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);
615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

Line 616: fnd_message.set_token('BATCHID', p_batch_id);

612: FETCH c_batch_desc INTO l_batch_desc;
613: CLOSE c_batch_desc;
614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);
615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:

Line 617: fnd_message.set_token('BATCHDESC',l_batch_desc);

613: CLOSE c_batch_desc;
614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);
615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');

Line 618: fnd_message.set_token('ENRMETHOD',l_enr_method);

614: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_PE_CURR_DT')||':'||SYSDATE);
615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);

Line 619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

615: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_HD');
616: fnd_message.set_token('BATCHID', p_batch_id);
617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);

Line 621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');

617: fnd_message.set_token('BATCHDESC',l_batch_desc);
618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);
624: fnd_message.set_token('PARAM3',p_deletion_flag);
625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

Line 622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);

618: fnd_message.set_token('ENRMETHOD',l_enr_method);
619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);
624: fnd_message.set_token('PARAM3',p_deletion_flag);
625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
626:

Line 623: fnd_message.set_token('PARAM2',p_ovr_enr_method);

619: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);
624: fnd_message.set_token('PARAM3',p_deletion_flag);
625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
626:
627:

Line 624: fnd_message.set_token('PARAM3',p_deletion_flag);

620:
621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);
624: fnd_message.set_token('PARAM3',p_deletion_flag);
625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
626:
627:
628: FOR l_bulk_persons IN c_bulk_persons(p_batch_id)

Line 625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

621: fnd_message.set_name('IGS','IGS_EN_BLK_JOB_PARAM');
622: fnd_message.set_token('PARAM1', p_dflt_unit_confirmed);
623: fnd_message.set_token('PARAM2',p_ovr_enr_method);
624: fnd_message.set_token('PARAM3',p_deletion_flag);
625: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
626:
627:
628: FOR l_bulk_persons IN c_bulk_persons(p_batch_id)
629: LOOP --for each person

Line 671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');

667: FOR l_bulk_load IN c_bulk_load (p_batch_id,l_bulk_persons.person_number,l_bulk_programs.program_cd,l_bulk_programs.program_ver_num) LOOP --load calendars
668: SAVEPOINT blk_sc_load_lvl;
669: --group header
670: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');
672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);
673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);
674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);
675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

Line 672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);

668: SAVEPOINT blk_sc_load_lvl;
669: --group header
670: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');
672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);
673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);
674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);
675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
676: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));

Line 673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);

669: --group header
670: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');
672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);
673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);
674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);
675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
676: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
677:

Line 674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);

670: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');
672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);
673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);
674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);
675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
676: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
677:
678: l_abort_loop:=FALSE;

Line 675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);

671: fnd_message.set_name('IGS','IGS_EN_BLK_GRP_INF');
672: fnd_message.set_token('PERNUM', l_bulk_persons.person_number);
673: fnd_message.set_token('PRGCD',l_bulk_programs.program_cd);
674: fnd_message.set_token('LOADALTCD',l_bulk_load.alt_cd);
675: fnd_file.put_line(Fnd_File.LOG,fnd_message.get);
676: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
677:
678: l_abort_loop:=FALSE;
679: l_error_message:=null;

Line 1011: l_error_message := FND_MESSAGE.GET;

1007: p_calling_obj =>'JOB');
1008: EXCEPTION WHEN OTHERS THEN
1009: --When an exception is raised..get the exception text and store it in l_error_message
1010: IF IGS_GE_MSG_STACK.COUNT_MSG <> 0 THEN
1011: l_error_message := FND_MESSAGE.GET;
1012: ELSE
1013: l_error_message := SQLERRM;
1014: END IF;
1015: l_ret_status := 'D';

Line 1143: l_error_message := FND_MESSAGE.GET;

1139: p_enrolled_dt =>SYSDATE);
1140: EXCEPTION WHEN OTHERS THEN
1141: --If an exception is thrown, get the error message text and save it in the message name variable
1142: IF IGS_GE_MSG_STACK.COUNT_MSG <> 0 THEN
1143: l_error_message := FND_MESSAGE.GET;
1144: ELSE
1145: l_error_message := SQLERRM;
1146: END IF;
1147: l_deny_warn := 'DENY';

Line 1208: fnd_file.put_line(Fnd_File.LOG,fnd_message.get_string('IGS','IGS_EN_BLK_NO_RECS'));

1204: END IF;
1205:
1206: IF l_processed_rec=FALSE THEN
1207: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
1208: fnd_file.put_line(Fnd_File.LOG,fnd_message.get_string('IGS','IGS_EN_BLK_NO_RECS'));
1209: fnd_file.put_line(Fnd_File.LOG, rpad(' ',80,'_'));
1210: END IF;
1211:
1212: --Delete the successfully processed records from the interface table if required

Line 1228: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

1224: WHEN OTHERS THEN
1225: retcode:=2;
1226: ROLLBACK TO blk_sua_job;
1227: fnd_file.put_line(fnd_file.LOG,SQLERRM);
1228: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1229: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Gen_018.Enrp_batch_sua_upload');
1230: IGS_GE_MSG_STACK.ADD;
1231: igs_ge_msg_stack.conc_exception_hndl;
1232: END enrp_batch_sua_upload;

Line 1229: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Gen_018.Enrp_batch_sua_upload');

1225: retcode:=2;
1226: ROLLBACK TO blk_sua_job;
1227: fnd_file.put_line(fnd_file.LOG,SQLERRM);
1228: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1229: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Gen_018.Enrp_batch_sua_upload');
1230: IGS_GE_MSG_STACK.ADD;
1231: igs_ge_msg_stack.conc_exception_hndl;
1232: END enrp_batch_sua_upload;
1233: