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

Line 130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

126: RETURN return_value;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
131: fnd_message.set_token('NAME','IS_NUMERIC - '||SQLERRM);
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134:

Line 131: fnd_message.set_token('NAME','IS_NUMERIC - '||SQLERRM);

127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
131: fnd_message.set_token('NAME','IS_NUMERIC - '||SQLERRM);
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134:
135: END is_numeric;

Line 165: fnd_message.set_name('IGS', 'IGS_UC_INVALID_CHOICE');

161: l_ascii := ASCII(UPPER(p_char));
162: l_num := 10 + (l_ascii - l_a_ascii);
163: ELSE
164: l_num := 0;
165: fnd_message.set_name('IGS', 'IGS_UC_INVALID_CHOICE');
166: fnd_message.set_token('CHOICE',p_char);
167: fnd_file.put_line( fnd_file.log, fnd_message.get());
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;

Line 166: fnd_message.set_token('CHOICE',p_char);

162: l_num := 10 + (l_ascii - l_a_ascii);
163: ELSE
164: l_num := 0;
165: fnd_message.set_name('IGS', 'IGS_UC_INVALID_CHOICE');
166: fnd_message.set_token('CHOICE',p_char);
167: fnd_file.put_line( fnd_file.log, fnd_message.get());
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;

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

163: ELSE
164: l_num := 0;
165: fnd_message.set_name('IGS', 'IGS_UC_INVALID_CHOICE');
166: fnd_message.set_token('CHOICE',p_char);
167: fnd_file.put_line( fnd_file.log, fnd_message.get());
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171:

Line 176: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

172: RETURN (l_num);
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','GET_NUMERIC_CHOICE - '||SQLERRM);
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END get_numeric_choice;

Line 177: fnd_message.set_token('NAME','GET_NUMERIC_CHOICE - '||SQLERRM);

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','GET_NUMERIC_CHOICE - '||SQLERRM);
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END get_numeric_choice;
181:

Line 234: fnd_message.set_name('IGS', 'IGS_UC_MV_PROC_SEQ');

230: FETCH c_cyc_defaults INTO cyc_defaults_rec;
231: CLOSE c_cyc_defaults;
232:
233: -- log a message displaying the system and the section number being processed.
234: fnd_message.set_name('IGS', 'IGS_UC_MV_PROC_SEQ');
235: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
236: fnd_message.set_token('SEQ', p_curr_seq_num);
237: fnd_file.put_line(fnd_file.log, fnd_message.get());
238:

Line 235: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);

231: CLOSE c_cyc_defaults;
232:
233: -- log a message displaying the system and the section number being processed.
234: fnd_message.set_name('IGS', 'IGS_UC_MV_PROC_SEQ');
235: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
236: fnd_message.set_token('SEQ', p_curr_seq_num);
237: fnd_file.put_line(fnd_file.log, fnd_message.get());
238:
239: --Update the Marvin file seq number in the setup table.

Line 236: fnd_message.set_token('SEQ', p_curr_seq_num);

232:
233: -- log a message displaying the system and the section number being processed.
234: fnd_message.set_name('IGS', 'IGS_UC_MV_PROC_SEQ');
235: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
236: fnd_message.set_token('SEQ', p_curr_seq_num);
237: fnd_file.put_line(fnd_file.log, fnd_message.get());
238:
239: --Update the Marvin file seq number in the setup table.
240: igs_uc_cyc_defaults_pkg.update_row (

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

233: -- log a message displaying the system and the section number being processed.
234: fnd_message.set_name('IGS', 'IGS_UC_MV_PROC_SEQ');
235: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
236: fnd_message.set_token('SEQ', p_curr_seq_num);
237: fnd_file.put_line(fnd_file.log, fnd_message.get());
238:
239: --Update the Marvin file seq number in the setup table.
240: igs_uc_cyc_defaults_pkg.update_row (
241: x_rowid => cyc_defaults_rec.rowid,

Line 256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

252: END IF;
253:
254: EXCEPTION
255: WHEN OTHERS THEN
256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
257: fnd_message.set_token('NAME','VALIDATE_FILE_SEQ_NUM - '||SQLERRM);
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END validate_file_seq_num;

Line 257: fnd_message.set_token('NAME','VALIDATE_FILE_SEQ_NUM - '||SQLERRM);

253:
254: EXCEPTION
255: WHEN OTHERS THEN
256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
257: fnd_message.set_token('NAME','VALIDATE_FILE_SEQ_NUM - '||SQLERRM);
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END validate_file_seq_num;
261:

Line 323: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');

319: OPEN c_cyc_defaults (ae_trans_rec.file_type);
320: FETCH c_cyc_defaults INTO cyc_defaults_rec;
321: IF c_cyc_defaults%NOTFOUND THEN
322: CLOSE c_cyc_defaults;
323: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
324: fnd_message.set_token('SYSTEM', ae_trans_rec.file_type );
325: fnd_file.put_line( fnd_file.log, fnd_message.get());
326: l_valid := FALSE ;
327: ELSE

Line 324: fnd_message.set_token('SYSTEM', ae_trans_rec.file_type );

320: FETCH c_cyc_defaults INTO cyc_defaults_rec;
321: IF c_cyc_defaults%NOTFOUND THEN
322: CLOSE c_cyc_defaults;
323: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
324: fnd_message.set_token('SYSTEM', ae_trans_rec.file_type );
325: fnd_file.put_line( fnd_file.log, fnd_message.get());
326: l_valid := FALSE ;
327: ELSE
328: CLOSE c_cyc_defaults;

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

321: IF c_cyc_defaults%NOTFOUND THEN
322: CLOSE c_cyc_defaults;
323: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
324: fnd_message.set_token('SYSTEM', ae_trans_rec.file_type );
325: fnd_file.put_line( fnd_file.log, fnd_message.get());
326: l_valid := FALSE ;
327: ELSE
328: CLOSE c_cyc_defaults;
329: END IF;

Line 333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');

329: END IF;
330:
331: -- check whether the current file/section being processed is immediate next to earlier processed seq.
332: IF NVL(cyc_defaults_rec.marvin_seq,0) <> (l_curr_seq_num - 1) THEN
333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');
334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));
336: fnd_message.set_token('CURSEQ', l_curr_seq_num);
337: fnd_file.put_line(fnd_file.log, fnd_message.get());

Line 334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);

330:
331: -- check whether the current file/section being processed is immediate next to earlier processed seq.
332: IF NVL(cyc_defaults_rec.marvin_seq,0) <> (l_curr_seq_num - 1) THEN
333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');
334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));
336: fnd_message.set_token('CURSEQ', l_curr_seq_num);
337: fnd_file.put_line(fnd_file.log, fnd_message.get());
338: l_valid := FALSE ;

Line 335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));

331: -- check whether the current file/section being processed is immediate next to earlier processed seq.
332: IF NVL(cyc_defaults_rec.marvin_seq,0) <> (l_curr_seq_num - 1) THEN
333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');
334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));
336: fnd_message.set_token('CURSEQ', l_curr_seq_num);
337: fnd_file.put_line(fnd_file.log, fnd_message.get());
338: l_valid := FALSE ;
339: END IF;

Line 336: fnd_message.set_token('CURSEQ', l_curr_seq_num);

332: IF NVL(cyc_defaults_rec.marvin_seq,0) <> (l_curr_seq_num - 1) THEN
333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');
334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));
336: fnd_message.set_token('CURSEQ', l_curr_seq_num);
337: fnd_file.put_line(fnd_file.log, fnd_message.get());
338: l_valid := FALSE ;
339: END IF;
340:

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

333: fnd_message.set_name('IGS', 'IGS_UC_MV_FILE_NOT_SEQ');
334: fnd_message.set_token('SYSTEM', cyc_defaults_rec.name);
335: fnd_message.set_token('OLDSEQ', NVL(cyc_defaults_rec.marvin_seq,0));
336: fnd_message.set_token('CURSEQ', l_curr_seq_num);
337: fnd_file.put_line(fnd_file.log, fnd_message.get());
338: l_valid := FALSE ;
339: END IF;
340:
341: END IF;

Line 348: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

344: RETURN l_valid ;
345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
349: fnd_message.set_token('NAME','SEQUENCE_VALIDITY - '||SQLERRM);
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END sequence_validity;

Line 349: fnd_message.set_token('NAME','SEQUENCE_VALIDITY - '||SQLERRM);

345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
349: fnd_message.set_token('NAME','SEQUENCE_VALIDITY - '||SQLERRM);
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END sequence_validity;
353:

Line 435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

431: ln_appno igs_uc_istara_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
432:
433: BEGIN
434:
435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
436: fnd_message.set_token('TTYPE','*A ');
437: fnd_message.set_token('APPNO', ln_appno);
438: fnd_file.put_line( fnd_file.log, fnd_message.get());
439:

Line 436: fnd_message.set_token('TTYPE','*A ');

432:
433: BEGIN
434:
435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
436: fnd_message.set_token('TTYPE','*A ');
437: fnd_message.set_token('APPNO', ln_appno);
438: fnd_file.put_line( fnd_file.log, fnd_message.get());
439:
440: -- Obsolete matching records in interface table with status N

Line 437: fnd_message.set_token('APPNO', ln_appno);

433: BEGIN
434:
435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
436: fnd_message.set_token('TTYPE','*A ');
437: fnd_message.set_token('APPNO', ln_appno);
438: fnd_file.put_line( fnd_file.log, fnd_message.get());
439:
440: -- Obsolete matching records in interface table with status N
441: UPDATE igs_uc_istara_ints SET record_status = 'O'

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

434:
435: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
436: fnd_message.set_token('TTYPE','*A ');
437: fnd_message.set_token('APPNO', ln_appno);
438: fnd_file.put_line( fnd_file.log, fnd_message.get());
439:
440: -- Obsolete matching records in interface table with status N
441: UPDATE igs_uc_istara_ints SET record_status = 'O'
442: WHERE record_status = 'N' AND appno = ln_appno ;

Line 497: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

493: g_success_cnt := g_success_cnt +1;
494:
495: EXCEPTION
496: WHEN VALUE_ERROR THEN
497: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
498: fnd_message.set_token('TTYPE',p_trans_type);
499: fnd_file.put_line( fnd_file.log, fnd_message.get());
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;

Line 498: fnd_message.set_token('TTYPE',p_trans_type);

494:
495: EXCEPTION
496: WHEN VALUE_ERROR THEN
497: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
498: fnd_message.set_token('TTYPE',p_trans_type);
499: fnd_file.put_line( fnd_file.log, fnd_message.get());
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502:

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

495: EXCEPTION
496: WHEN VALUE_ERROR THEN
497: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
498: fnd_message.set_token('TTYPE',p_trans_type);
499: fnd_file.put_line( fnd_file.log, fnd_message.get());
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502:
503: WHEN OTHERS THEN

Line 504: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502:
503: WHEN OTHERS THEN
504: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
505: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARA - '||SQLERRM);
506: igs_ge_msg_stack.add;
507: app_exception.raise_exception;
508:

Line 505: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARA - '||SQLERRM);

501: app_exception.raise_exception;
502:
503: WHEN OTHERS THEN
504: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
505: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARA - '||SQLERRM);
506: igs_ge_msg_stack.add;
507: app_exception.raise_exception;
508:
509: END transfer_to_stara;

Line 553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');

549: AND w.record_status = 'N';
550:
551: BEGIN
552:
553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
554: fnd_message.set_token('TTYPE','*C ');
555: fnd_message.set_token('APPNO', ln_appno);
556: fnd_message.set_token('CHOICENO', l_char_choice);
557: fnd_file.put_line( fnd_file.log, fnd_message.get());

Line 554: fnd_message.set_token('TTYPE','*C ');

550:
551: BEGIN
552:
553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
554: fnd_message.set_token('TTYPE','*C ');
555: fnd_message.set_token('APPNO', ln_appno);
556: fnd_message.set_token('CHOICENO', l_char_choice);
557: fnd_file.put_line( fnd_file.log, fnd_message.get());
558:

Line 555: fnd_message.set_token('APPNO', ln_appno);

551: BEGIN
552:
553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
554: fnd_message.set_token('TTYPE','*C ');
555: fnd_message.set_token('APPNO', ln_appno);
556: fnd_message.set_token('CHOICENO', l_char_choice);
557: fnd_file.put_line( fnd_file.log, fnd_message.get());
558:
559: --Added as part of UCFD02 build for GTTR system.

Line 556: fnd_message.set_token('CHOICENO', l_char_choice);

552:
553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
554: fnd_message.set_token('TTYPE','*C ');
555: fnd_message.set_token('APPNO', ln_appno);
556: fnd_message.set_token('CHOICENO', l_char_choice);
557: fnd_file.put_line( fnd_file.log, fnd_message.get());
558:
559: --Added as part of UCFD02 build for GTTR system.
560: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.

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

553: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
554: fnd_message.set_token('TTYPE','*C ');
555: fnd_message.set_token('APPNO', ln_appno);
556: fnd_message.set_token('CHOICENO', l_char_choice);
557: fnd_file.put_line( fnd_file.log, fnd_message.get());
558:
559: --Added as part of UCFD02 build for GTTR system.
560: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.
561: -- i.e. if the incoming Choice No = 'A' then Choice No = 10, If it is 'F' then Choice = 15 etc.

Line 709: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

705: g_success_cnt := g_success_cnt +1;
706:
707: EXCEPTION
708: WHEN VALUE_ERROR THEN
709: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
710: fnd_message.set_token('TTYPE',p_trans_type);
711: fnd_file.put_line( fnd_file.log, fnd_message.get());
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;

Line 710: fnd_message.set_token('TTYPE',p_trans_type);

706:
707: EXCEPTION
708: WHEN VALUE_ERROR THEN
709: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
710: fnd_message.set_token('TTYPE',p_trans_type);
711: fnd_file.put_line( fnd_file.log, fnd_message.get());
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:

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

707: EXCEPTION
708: WHEN VALUE_ERROR THEN
709: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
710: fnd_message.set_token('TTYPE',p_trans_type);
711: fnd_file.put_line( fnd_file.log, fnd_message.get());
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN

Line 716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN
716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARC - '||SQLERRM);
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720:

Line 717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARC - '||SQLERRM);

713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN
716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARC - '||SQLERRM);
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720:
721: END transfer_to_starc;

Line 748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');

744:
745:
746: BEGIN
747:
748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
749: fnd_message.set_token('TTYPE','*G ');
750: fnd_message.set_token('APPNO', ln_appno);
751: fnd_message.set_token('CHOICENO', l_char_choice);
752: fnd_file.put_line( fnd_file.log, fnd_message.get());

Line 749: fnd_message.set_token('TTYPE','*G ');

745:
746: BEGIN
747:
748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
749: fnd_message.set_token('TTYPE','*G ');
750: fnd_message.set_token('APPNO', ln_appno);
751: fnd_message.set_token('CHOICENO', l_char_choice);
752: fnd_file.put_line( fnd_file.log, fnd_message.get());
753:

Line 750: fnd_message.set_token('APPNO', ln_appno);

746: BEGIN
747:
748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
749: fnd_message.set_token('TTYPE','*G ');
750: fnd_message.set_token('APPNO', ln_appno);
751: fnd_message.set_token('CHOICENO', l_char_choice);
752: fnd_file.put_line( fnd_file.log, fnd_message.get());
753:
754: --Added as part of UCFD02 build for GTTR system.

Line 751: fnd_message.set_token('CHOICENO', l_char_choice);

747:
748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
749: fnd_message.set_token('TTYPE','*G ');
750: fnd_message.set_token('APPNO', ln_appno);
751: fnd_message.set_token('CHOICENO', l_char_choice);
752: fnd_file.put_line( fnd_file.log, fnd_message.get());
753:
754: --Added as part of UCFD02 build for GTTR system.
755: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.

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

748: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
749: fnd_message.set_token('TTYPE','*G ');
750: fnd_message.set_token('APPNO', ln_appno);
751: fnd_message.set_token('CHOICENO', l_char_choice);
752: fnd_file.put_line( fnd_file.log, fnd_message.get());
753:
754: --Added as part of UCFD02 build for GTTR system.
755: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.
756: -- i.e. if the incoming Choice No = 'A' then Choice No = 10, If it is 'F' then Choice = 15 etc.

Line 831: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

827: g_success_cnt := g_success_cnt +1;
828:
829: EXCEPTION
830: WHEN VALUE_ERROR THEN
831: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
832: fnd_message.set_token('TTYPE',p_trans_type);
833: fnd_file.put_line( fnd_file.log, fnd_message.get());
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;

Line 832: fnd_message.set_token('TTYPE',p_trans_type);

828:
829: EXCEPTION
830: WHEN VALUE_ERROR THEN
831: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
832: fnd_message.set_token('TTYPE',p_trans_type);
833: fnd_file.put_line( fnd_file.log, fnd_message.get());
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836:

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

829: EXCEPTION
830: WHEN VALUE_ERROR THEN
831: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
832: fnd_message.set_token('TTYPE',p_trans_type);
833: fnd_file.put_line( fnd_file.log, fnd_message.get());
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836:
837: WHEN OTHERS THEN

Line 838: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836:
837: WHEN OTHERS THEN
838: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
839: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARG - '||SQLERRM);
840: igs_ge_msg_stack.add;
841: app_exception.raise_exception;
842:

Line 839: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARG - '||SQLERRM);

835: app_exception.raise_exception;
836:
837: WHEN OTHERS THEN
838: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
839: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARG - '||SQLERRM);
840: igs_ge_msg_stack.add;
841: app_exception.raise_exception;
842:
843: END transfer_to_starg;

Line 871: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

867:
868:
869: BEGIN
870:
871: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
872: fnd_message.set_token('TTYPE','*H ');
873: fnd_message.set_token('APPNO', ln_appno);
874: fnd_file.put_line( fnd_file.log, fnd_message.get());
875:

Line 872: fnd_message.set_token('TTYPE','*H ');

868:
869: BEGIN
870:
871: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
872: fnd_message.set_token('TTYPE','*H ');
873: fnd_message.set_token('APPNO', ln_appno);
874: fnd_file.put_line( fnd_file.log, fnd_message.get());
875:
876: -- Obsolete matching records in interface table with status N

Line 873: fnd_message.set_token('APPNO', ln_appno);

869: BEGIN
870:
871: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
872: fnd_message.set_token('TTYPE','*H ');
873: fnd_message.set_token('APPNO', ln_appno);
874: fnd_file.put_line( fnd_file.log, fnd_message.get());
875:
876: -- Obsolete matching records in interface table with status N
877: UPDATE igs_uc_istarh_ints SET record_status = 'O'

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

870:
871: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
872: fnd_message.set_token('TTYPE','*H ');
873: fnd_message.set_token('APPNO', ln_appno);
874: fnd_file.put_line( fnd_file.log, fnd_message.get());
875:
876: -- Obsolete matching records in interface table with status N
877: UPDATE igs_uc_istarh_ints SET record_status = 'O'
878: WHERE record_status = 'N' AND appno = ln_appno ;

Line 919: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

915: g_success_cnt := g_success_cnt +1;
916:
917: EXCEPTION
918: WHEN VALUE_ERROR THEN
919: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
920: fnd_message.set_token('TTYPE',p_trans_type);
921: fnd_file.put_line( fnd_file.log, fnd_message.get());
922: igs_ge_msg_stack.add;
923: app_exception.raise_exception;

Line 920: fnd_message.set_token('TTYPE',p_trans_type);

916:
917: EXCEPTION
918: WHEN VALUE_ERROR THEN
919: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
920: fnd_message.set_token('TTYPE',p_trans_type);
921: fnd_file.put_line( fnd_file.log, fnd_message.get());
922: igs_ge_msg_stack.add;
923: app_exception.raise_exception;
924:

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

917: EXCEPTION
918: WHEN VALUE_ERROR THEN
919: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
920: fnd_message.set_token('TTYPE',p_trans_type);
921: fnd_file.put_line( fnd_file.log, fnd_message.get());
922: igs_ge_msg_stack.add;
923: app_exception.raise_exception;
924:
925: WHEN OTHERS THEN

Line 926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

922: igs_ge_msg_stack.add;
923: app_exception.raise_exception;
924:
925: WHEN OTHERS THEN
926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
927: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARH - '||SQLERRM);
928: igs_ge_msg_stack.add;
929: app_exception.raise_exception;
930:

Line 927: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARH - '||SQLERRM);

923: app_exception.raise_exception;
924:
925: WHEN OTHERS THEN
926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
927: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARH - '||SQLERRM);
928: igs_ge_msg_stack.add;
929: app_exception.raise_exception;
930:
931: END transfer_to_starh;

Line 996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

992: l_surname igs_uc_app_names.surname%TYPE ;
993:
994: BEGIN
995:
996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
997: fnd_message.set_token('TTYPE','*K ');
998: fnd_message.set_token('APPNO', ln_appno);
999: fnd_file.put_line( fnd_file.log, fnd_message.get());
1000:

Line 997: fnd_message.set_token('TTYPE','*K ');

993:
994: BEGIN
995:
996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
997: fnd_message.set_token('TTYPE','*K ');
998: fnd_message.set_token('APPNO', ln_appno);
999: fnd_file.put_line( fnd_file.log, fnd_message.get());
1000:
1001: -- If the value stored in the 69th position is Numeric then the data goes into

Line 998: fnd_message.set_token('APPNO', ln_appno);

994: BEGIN
995:
996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
997: fnd_message.set_token('TTYPE','*K ');
998: fnd_message.set_token('APPNO', ln_appno);
999: fnd_file.put_line( fnd_file.log, fnd_message.get());
1000:
1001: -- If the value stored in the 69th position is Numeric then the data goes into
1002: -- Regno column else data goes into scn column

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

995:
996: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
997: fnd_message.set_token('TTYPE','*K ');
998: fnd_message.set_token('APPNO', ln_appno);
999: fnd_file.put_line( fnd_file.log, fnd_message.get());
1000:
1001: -- If the value stored in the 69th position is Numeric then the data goes into
1002: -- Regno column else data goes into scn column
1003: IF is_numeric(TRIM(SUBSTR(p_record_data,69,1))) THEN

Line 1259: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1255: g_success_cnt := g_success_cnt +1;
1256:
1257: EXCEPTION
1258: WHEN VALUE_ERROR THEN
1259: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1260: fnd_message.set_token('TTYPE',p_trans_type);
1261: fnd_file.put_line( fnd_file.log, fnd_message.get());
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;

Line 1260: fnd_message.set_token('TTYPE',p_trans_type);

1256:
1257: EXCEPTION
1258: WHEN VALUE_ERROR THEN
1259: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1260: fnd_message.set_token('TTYPE',p_trans_type);
1261: fnd_file.put_line( fnd_file.log, fnd_message.get());
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264:

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

1257: EXCEPTION
1258: WHEN VALUE_ERROR THEN
1259: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1260: fnd_message.set_token('TTYPE',p_trans_type);
1261: fnd_file.put_line( fnd_file.log, fnd_message.get());
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264:
1265: WHEN OTHERS THEN

Line 1266: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264:
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1267: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARK - '||SQLERRM);
1268: igs_ge_msg_stack.add;
1269: app_exception.raise_exception;
1270:

Line 1267: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARK - '||SQLERRM);

1263: app_exception.raise_exception;
1264:
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1267: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARK - '||SQLERRM);
1268: igs_ge_msg_stack.add;
1269: app_exception.raise_exception;
1270:
1271: END transfer_to_stark;

Line 1333: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1329: c_app_name_rec c_app_name%ROWTYPE ;
1330:
1331: BEGIN
1332:
1333: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1334: fnd_message.set_token('TTYPE','*N');
1335: fnd_message.set_token('APPNO', ln_appno);
1336: fnd_file.put_line( fnd_file.log, fnd_message.get());
1337:

Line 1334: fnd_message.set_token('TTYPE','*N');

1330:
1331: BEGIN
1332:
1333: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1334: fnd_message.set_token('TTYPE','*N');
1335: fnd_message.set_token('APPNO', ln_appno);
1336: fnd_file.put_line( fnd_file.log, fnd_message.get());
1337:
1338: -- initialising variables

Line 1335: fnd_message.set_token('APPNO', ln_appno);

1331: BEGIN
1332:
1333: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1334: fnd_message.set_token('TTYPE','*N');
1335: fnd_message.set_token('APPNO', ln_appno);
1336: fnd_file.put_line( fnd_file.log, fnd_message.get());
1337:
1338: -- initialising variables
1339: l_k_data := NULL ;

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

1332:
1333: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1334: fnd_message.set_token('TTYPE','*N');
1335: fnd_message.set_token('APPNO', ln_appno);
1336: fnd_file.put_line( fnd_file.log, fnd_message.get());
1337:
1338: -- initialising variables
1339: l_k_data := NULL ;
1340: l_birthdate := NULL;

Line 1433: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1429: g_success_cnt := g_success_cnt +1;
1430:
1431: EXCEPTION
1432: WHEN VALUE_ERROR THEN
1433: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1434: fnd_message.set_token('TTYPE',p_trans_type);
1435: fnd_file.put_line( fnd_file.log, fnd_message.get());
1436: igs_ge_msg_stack.add;
1437: app_exception.raise_exception;

Line 1434: fnd_message.set_token('TTYPE',p_trans_type);

1430:
1431: EXCEPTION
1432: WHEN VALUE_ERROR THEN
1433: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1434: fnd_message.set_token('TTYPE',p_trans_type);
1435: fnd_file.put_line( fnd_file.log, fnd_message.get());
1436: igs_ge_msg_stack.add;
1437: app_exception.raise_exception;
1438:

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

1431: EXCEPTION
1432: WHEN VALUE_ERROR THEN
1433: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1434: fnd_message.set_token('TTYPE',p_trans_type);
1435: fnd_file.put_line( fnd_file.log, fnd_message.get());
1436: igs_ge_msg_stack.add;
1437: app_exception.raise_exception;
1438:
1439: WHEN OTHERS THEN

Line 1440: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1436: igs_ge_msg_stack.add;
1437: app_exception.raise_exception;
1438:
1439: WHEN OTHERS THEN
1440: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1441: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARN - '||SQLERRM);
1442: igs_ge_msg_stack.add;
1443: app_exception.raise_exception;
1444:

Line 1441: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARN - '||SQLERRM);

1437: app_exception.raise_exception;
1438:
1439: WHEN OTHERS THEN
1440: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1441: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARN - '||SQLERRM);
1442: igs_ge_msg_stack.add;
1443: app_exception.raise_exception;
1444:
1445: END transfer_to_starn;

Line 1486: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1482:
1483:
1484: BEGIN
1485:
1486: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1487: fnd_message.set_token('TTYPE','*PQR');
1488: fnd_message.set_token('APPNO', ln_appno);
1489: fnd_file.put_line( fnd_file.log, fnd_message.get());
1490:

Line 1487: fnd_message.set_token('TTYPE','*PQR');

1483:
1484: BEGIN
1485:
1486: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1487: fnd_message.set_token('TTYPE','*PQR');
1488: fnd_message.set_token('APPNO', ln_appno);
1489: fnd_file.put_line( fnd_file.log, fnd_message.get());
1490:
1491: -- update all records in interface table for the current applicant ,marvin type with status L

Line 1488: fnd_message.set_token('APPNO', ln_appno);

1484: BEGIN
1485:
1486: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1487: fnd_message.set_token('TTYPE','*PQR');
1488: fnd_message.set_token('APPNO', ln_appno);
1489: fnd_file.put_line( fnd_file.log, fnd_message.get());
1490:
1491: -- update all records in interface table for the current applicant ,marvin type with status L
1492: -- to status D,i.e processed for this applicant

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

1485:
1486: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1487: fnd_message.set_token('TTYPE','*PQR');
1488: fnd_message.set_token('APPNO', ln_appno);
1489: fnd_file.put_line( fnd_file.log, fnd_message.get());
1490:
1491: -- update all records in interface table for the current applicant ,marvin type with status L
1492: -- to status D,i.e processed for this applicant
1493: UPDATE igs_uc_istrpqr_ints SET record_status = 'D'

Line 1594: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1590:
1591:
1592: EXCEPTION
1593: WHEN VALUE_ERROR THEN
1594: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1595: fnd_message.set_token('TTYPE',p_trans_type);
1596: fnd_file.put_line( fnd_file.log, fnd_message.get());
1597: igs_ge_msg_stack.add;
1598: app_exception.raise_exception;

Line 1595: fnd_message.set_token('TTYPE',p_trans_type);

1591:
1592: EXCEPTION
1593: WHEN VALUE_ERROR THEN
1594: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1595: fnd_message.set_token('TTYPE',p_trans_type);
1596: fnd_file.put_line( fnd_file.log, fnd_message.get());
1597: igs_ge_msg_stack.add;
1598: app_exception.raise_exception;
1599:

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

1592: EXCEPTION
1593: WHEN VALUE_ERROR THEN
1594: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1595: fnd_message.set_token('TTYPE',p_trans_type);
1596: fnd_file.put_line( fnd_file.log, fnd_message.get());
1597: igs_ge_msg_stack.add;
1598: app_exception.raise_exception;
1599:
1600: WHEN OTHERS THEN

Line 1601: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1597: igs_ge_msg_stack.add;
1598: app_exception.raise_exception;
1599:
1600: WHEN OTHERS THEN
1601: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1602: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARPQR - '||SQLERRM);
1603: igs_ge_msg_stack.add;
1604: app_exception.raise_exception;
1605:

Line 1602: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARPQR - '||SQLERRM);

1598: app_exception.raise_exception;
1599:
1600: WHEN OTHERS THEN
1601: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1602: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARPQR - '||SQLERRM);
1603: igs_ge_msg_stack.add;
1604: app_exception.raise_exception;
1605:
1606: END transfer_to_starpqr;

Line 1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1627: ln_appno igs_uc_istart_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1628:
1629: BEGIN
1630:
1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1632: fnd_message.set_token('TTYPE','*T');
1633: fnd_message.set_token('APPNO', ln_appno);
1634: fnd_file.put_line( fnd_file.log, fnd_message.get());
1635:

Line 1632: fnd_message.set_token('TTYPE','*T');

1628:
1629: BEGIN
1630:
1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1632: fnd_message.set_token('TTYPE','*T');
1633: fnd_message.set_token('APPNO', ln_appno);
1634: fnd_file.put_line( fnd_file.log, fnd_message.get());
1635:
1636: -- Obsolete matching records in interface table with status N

Line 1633: fnd_message.set_token('APPNO', ln_appno);

1629: BEGIN
1630:
1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1632: fnd_message.set_token('TTYPE','*T');
1633: fnd_message.set_token('APPNO', ln_appno);
1634: fnd_file.put_line( fnd_file.log, fnd_message.get());
1635:
1636: -- Obsolete matching records in interface table with status N
1637: UPDATE igs_uc_istart_ints SET record_status = 'O'

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

1630:
1631: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1632: fnd_message.set_token('TTYPE','*T');
1633: fnd_message.set_token('APPNO', ln_appno);
1634: fnd_file.put_line( fnd_file.log, fnd_message.get());
1635:
1636: -- Obsolete matching records in interface table with status N
1637: UPDATE igs_uc_istart_ints SET record_status = 'O'
1638: WHERE record_status = 'N' AND appno = ln_appno ;

Line 1671: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1667: g_success_cnt := g_success_cnt +1;
1668:
1669: EXCEPTION
1670: WHEN VALUE_ERROR THEN
1671: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1672: fnd_message.set_token('TTYPE',p_trans_type);
1673: fnd_file.put_line( fnd_file.log, fnd_message.get());
1674: igs_ge_msg_stack.add;
1675: app_exception.raise_exception;

Line 1672: fnd_message.set_token('TTYPE',p_trans_type);

1668:
1669: EXCEPTION
1670: WHEN VALUE_ERROR THEN
1671: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1672: fnd_message.set_token('TTYPE',p_trans_type);
1673: fnd_file.put_line( fnd_file.log, fnd_message.get());
1674: igs_ge_msg_stack.add;
1675: app_exception.raise_exception;
1676:

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

1669: EXCEPTION
1670: WHEN VALUE_ERROR THEN
1671: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1672: fnd_message.set_token('TTYPE',p_trans_type);
1673: fnd_file.put_line( fnd_file.log, fnd_message.get());
1674: igs_ge_msg_stack.add;
1675: app_exception.raise_exception;
1676:
1677: WHEN OTHERS THEN

Line 1678: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1674: igs_ge_msg_stack.add;
1675: app_exception.raise_exception;
1676:
1677: WHEN OTHERS THEN
1678: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1679: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_START - '||SQLERRM);
1680: igs_ge_msg_stack.add;
1681: app_exception.raise_exception;
1682:

Line 1679: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_START - '||SQLERRM);

1675: app_exception.raise_exception;
1676:
1677: WHEN OTHERS THEN
1678: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1679: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_START - '||SQLERRM);
1680: igs_ge_msg_stack.add;
1681: app_exception.raise_exception;
1682:
1683: END transfer_to_start;

Line 1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1707: ln_appno igs_uc_istarw_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1708:
1709: BEGIN
1710:
1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1712: fnd_message.set_token('TTYPE','*W');
1713: fnd_message.set_token('APPNO', ln_appno);
1714: fnd_file.put_line( fnd_file.log, fnd_message.get());
1715:

Line 1712: fnd_message.set_token('TTYPE','*W');

1708:
1709: BEGIN
1710:
1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1712: fnd_message.set_token('TTYPE','*W');
1713: fnd_message.set_token('APPNO', ln_appno);
1714: fnd_file.put_line( fnd_file.log, fnd_message.get());
1715:
1716: -- Obsolete matching records in interface table with status N

Line 1713: fnd_message.set_token('APPNO', ln_appno);

1709: BEGIN
1710:
1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1712: fnd_message.set_token('TTYPE','*W');
1713: fnd_message.set_token('APPNO', ln_appno);
1714: fnd_file.put_line( fnd_file.log, fnd_message.get());
1715:
1716: -- Obsolete matching records in interface table with status N
1717: UPDATE igs_uc_istarw_ints SET record_status = 'O'

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

1710:
1711: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1712: fnd_message.set_token('TTYPE','*W');
1713: fnd_message.set_token('APPNO', ln_appno);
1714: fnd_file.put_line( fnd_file.log, fnd_message.get());
1715:
1716: -- Obsolete matching records in interface table with status N
1717: UPDATE igs_uc_istarw_ints SET record_status = 'O'
1718: WHERE record_status = 'N' AND appno = ln_appno ;

Line 1761: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1757: g_success_cnt := g_success_cnt +1;
1758:
1759: EXCEPTION
1760: WHEN VALUE_ERROR THEN
1761: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1762: fnd_message.set_token('TTYPE',p_trans_type);
1763: fnd_file.put_line( fnd_file.log, fnd_message.get());
1764: igs_ge_msg_stack.add;
1765: app_exception.raise_exception;

Line 1762: fnd_message.set_token('TTYPE',p_trans_type);

1758:
1759: EXCEPTION
1760: WHEN VALUE_ERROR THEN
1761: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1762: fnd_message.set_token('TTYPE',p_trans_type);
1763: fnd_file.put_line( fnd_file.log, fnd_message.get());
1764: igs_ge_msg_stack.add;
1765: app_exception.raise_exception;
1766:

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

1759: EXCEPTION
1760: WHEN VALUE_ERROR THEN
1761: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1762: fnd_message.set_token('TTYPE',p_trans_type);
1763: fnd_file.put_line( fnd_file.log, fnd_message.get());
1764: igs_ge_msg_stack.add;
1765: app_exception.raise_exception;
1766:
1767: WHEN OTHERS THEN

Line 1768: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1764: igs_ge_msg_stack.add;
1765: app_exception.raise_exception;
1766:
1767: WHEN OTHERS THEN
1768: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1769: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARW - '||SQLERRM);
1770: igs_ge_msg_stack.add;
1771: app_exception.raise_exception;
1772:

Line 1769: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARW - '||SQLERRM);

1765: app_exception.raise_exception;
1766:
1767: WHEN OTHERS THEN
1768: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1769: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARW - '||SQLERRM);
1770: igs_ge_msg_stack.add;
1771: app_exception.raise_exception;
1772:
1773: END transfer_to_starw;

Line 1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1797: ln_appno igs_uc_istarx_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1798:
1799: BEGIN
1800:
1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1802: fnd_message.set_token('TTYPE','*X');
1803: fnd_message.set_token('APPNO', ln_appno);
1804: fnd_file.put_line( fnd_file.log, fnd_message.get());
1805:

Line 1802: fnd_message.set_token('TTYPE','*X');

1798:
1799: BEGIN
1800:
1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1802: fnd_message.set_token('TTYPE','*X');
1803: fnd_message.set_token('APPNO', ln_appno);
1804: fnd_file.put_line( fnd_file.log, fnd_message.get());
1805:
1806: -- Obsolete matching records in interface table with status N

Line 1803: fnd_message.set_token('APPNO', ln_appno);

1799: BEGIN
1800:
1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1802: fnd_message.set_token('TTYPE','*X');
1803: fnd_message.set_token('APPNO', ln_appno);
1804: fnd_file.put_line( fnd_file.log, fnd_message.get());
1805:
1806: -- Obsolete matching records in interface table with status N
1807: UPDATE igs_uc_istarx_ints SET record_status = 'O'

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

1800:
1801: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1802: fnd_message.set_token('TTYPE','*X');
1803: fnd_message.set_token('APPNO', ln_appno);
1804: fnd_file.put_line( fnd_file.log, fnd_message.get());
1805:
1806: -- Obsolete matching records in interface table with status N
1807: UPDATE igs_uc_istarx_ints SET record_status = 'O'
1808: WHERE record_status = 'N' AND appno = ln_appno ;

Line 1848: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1844: g_success_cnt := g_success_cnt +1;
1845:
1846: EXCEPTION
1847: WHEN VALUE_ERROR THEN
1848: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1849: fnd_message.set_token('TTYPE',p_trans_type);
1850: fnd_file.put_line( fnd_file.log, fnd_message.get());
1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;

Line 1849: fnd_message.set_token('TTYPE',p_trans_type);

1845:
1846: EXCEPTION
1847: WHEN VALUE_ERROR THEN
1848: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1849: fnd_message.set_token('TTYPE',p_trans_type);
1850: fnd_file.put_line( fnd_file.log, fnd_message.get());
1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;
1853:

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

1846: EXCEPTION
1847: WHEN VALUE_ERROR THEN
1848: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1849: fnd_message.set_token('TTYPE',p_trans_type);
1850: fnd_file.put_line( fnd_file.log, fnd_message.get());
1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;
1853:
1854: WHEN OTHERS THEN

Line 1855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;
1853:
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1856: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARX - '||SQLERRM);
1857: igs_ge_msg_stack.add;
1858: app_exception.raise_exception;
1859:

Line 1856: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARX - '||SQLERRM);

1852: app_exception.raise_exception;
1853:
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1856: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARX - '||SQLERRM);
1857: igs_ge_msg_stack.add;
1858: app_exception.raise_exception;
1859:
1860: END transfer_to_starx;

Line 1886: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');

1882: ln_appno igs_uc_istarz1_ints.appno%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
1883:
1884: BEGIN
1885:
1886: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1887: fnd_message.set_token('TTYPE','*Z');
1888: fnd_message.set_token('APPNO', ln_appno);
1889: fnd_file.put_line( fnd_file.log, fnd_message.get());
1890:

Line 1887: fnd_message.set_token('TTYPE','*Z');

1883:
1884: BEGIN
1885:
1886: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1887: fnd_message.set_token('TTYPE','*Z');
1888: fnd_message.set_token('APPNO', ln_appno);
1889: fnd_file.put_line( fnd_file.log, fnd_message.get());
1890:
1891: -- Result column contains 'A' if the Institution and course columns has the values

Line 1888: fnd_message.set_token('APPNO', ln_appno);

1884: BEGIN
1885:
1886: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1887: fnd_message.set_token('TTYPE','*Z');
1888: fnd_message.set_token('APPNO', ln_appno);
1889: fnd_file.put_line( fnd_file.log, fnd_message.get());
1890:
1891: -- Result column contains 'A' if the Institution and course columns has the values
1892: IF (TRIM(SUBSTR(p_record_data,20,4)) IS NOT NULL) OR

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

1885:
1886: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APP');
1887: fnd_message.set_token('TTYPE','*Z');
1888: fnd_message.set_token('APPNO', ln_appno);
1889: fnd_file.put_line( fnd_file.log, fnd_message.get());
1890:
1891: -- Result column contains 'A' if the Institution and course columns has the values
1892: IF (TRIM(SUBSTR(p_record_data,20,4)) IS NOT NULL) OR
1893: (TRIM(SUBSTR(p_record_data,24,6)) IS NOT NULL) THEN

Line 1984: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

1980: g_success_cnt := g_success_cnt +1;
1981:
1982: EXCEPTION
1983: WHEN VALUE_ERROR THEN
1984: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1985: fnd_message.set_token('TTYPE',p_trans_type);
1986: fnd_file.put_line( fnd_file.log, fnd_message.get());
1987: igs_ge_msg_stack.add;
1988: app_exception.raise_exception;

Line 1985: fnd_message.set_token('TTYPE',p_trans_type);

1981:
1982: EXCEPTION
1983: WHEN VALUE_ERROR THEN
1984: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1985: fnd_message.set_token('TTYPE',p_trans_type);
1986: fnd_file.put_line( fnd_file.log, fnd_message.get());
1987: igs_ge_msg_stack.add;
1988: app_exception.raise_exception;
1989:

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

1982: EXCEPTION
1983: WHEN VALUE_ERROR THEN
1984: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1985: fnd_message.set_token('TTYPE',p_trans_type);
1986: fnd_file.put_line( fnd_file.log, fnd_message.get());
1987: igs_ge_msg_stack.add;
1988: app_exception.raise_exception;
1989:
1990: WHEN OTHERS THEN

Line 1991: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1987: igs_ge_msg_stack.add;
1988: app_exception.raise_exception;
1989:
1990: WHEN OTHERS THEN
1991: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1992: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARZ - '||SQLERRM);
1993: igs_ge_msg_stack.add;
1994: app_exception.raise_exception;
1995:

Line 1992: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARZ - '||SQLERRM);

1988: app_exception.raise_exception;
1989:
1990: WHEN OTHERS THEN
1991: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1992: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARZ - '||SQLERRM);
1993: igs_ge_msg_stack.add;
1994: app_exception.raise_exception;
1995:
1996: END transfer_to_starz;

Line 2049: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

2045: g_success_cnt := g_success_cnt +1;
2046:
2047: EXCEPTION
2048: WHEN VALUE_ERROR THEN
2049: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2050: fnd_message.set_token('TTYPE',p_trans_type);
2051: fnd_file.put_line( fnd_file.log, fnd_message.get());
2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;

Line 2050: fnd_message.set_token('TTYPE',p_trans_type);

2046:
2047: EXCEPTION
2048: WHEN VALUE_ERROR THEN
2049: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2050: fnd_message.set_token('TTYPE',p_trans_type);
2051: fnd_file.put_line( fnd_file.log, fnd_message.get());
2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;
2054:

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

2047: EXCEPTION
2048: WHEN VALUE_ERROR THEN
2049: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2050: fnd_message.set_token('TTYPE',p_trans_type);
2051: fnd_file.put_line( fnd_file.log, fnd_message.get());
2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;
2054:
2055: WHEN OTHERS THEN

Line 2056: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;
2054:
2055: WHEN OTHERS THEN
2056: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2057: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QA - '||SQLERRM);
2058: igs_ge_msg_stack.add;
2059: app_exception.raise_exception;
2060:

Line 2057: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QA - '||SQLERRM);

2053: app_exception.raise_exception;
2054:
2055: WHEN OTHERS THEN
2056: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2057: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QA - '||SQLERRM);
2058: igs_ge_msg_stack.add;
2059: app_exception.raise_exception;
2060:
2061: END transfer_to_qa;

Line 2172: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

2168: g_success_cnt := g_success_cnt +1;
2169:
2170: EXCEPTION
2171: WHEN VALUE_ERROR THEN
2172: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2173: fnd_message.set_token('TTYPE',p_trans_type);
2174: fnd_file.put_line( fnd_file.log, fnd_message.get());
2175: igs_ge_msg_stack.add;
2176: app_exception.raise_exception;

Line 2173: fnd_message.set_token('TTYPE',p_trans_type);

2169:
2170: EXCEPTION
2171: WHEN VALUE_ERROR THEN
2172: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2173: fnd_message.set_token('TTYPE',p_trans_type);
2174: fnd_file.put_line( fnd_file.log, fnd_message.get());
2175: igs_ge_msg_stack.add;
2176: app_exception.raise_exception;
2177:

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

2170: EXCEPTION
2171: WHEN VALUE_ERROR THEN
2172: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2173: fnd_message.set_token('TTYPE',p_trans_type);
2174: fnd_file.put_line( fnd_file.log, fnd_message.get());
2175: igs_ge_msg_stack.add;
2176: app_exception.raise_exception;
2177:
2178: WHEN OTHERS THEN

Line 2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2175: igs_ge_msg_stack.add;
2176: app_exception.raise_exception;
2177:
2178: WHEN OTHERS THEN
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QC - '||SQLERRM);
2181: igs_ge_msg_stack.add;
2182: app_exception.raise_exception;
2183:

Line 2180: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QC - '||SQLERRM);

2176: app_exception.raise_exception;
2177:
2178: WHEN OTHERS THEN
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QC - '||SQLERRM);
2181: igs_ge_msg_stack.add;
2182: app_exception.raise_exception;
2183:
2184: END transfer_to_qc;

Line 2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');

2266: l_char_choice VARCHAR2(1) := TRIM(SUBSTR(p_record_data,10,1));
2267: ln_appno igs_uc_transactions.app_no%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
2268: BEGIN
2269:
2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);
2272: fnd_message.set_token('APPNO', ln_appno);
2273: fnd_message.set_token('CHOICENO', l_char_choice);
2274: fnd_file.put_line( fnd_file.log, fnd_message.get());

Line 2271: fnd_message.set_token('TTYPE',p_trans_type);

2267: ln_appno igs_uc_transactions.app_no%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
2268: BEGIN
2269:
2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);
2272: fnd_message.set_token('APPNO', ln_appno);
2273: fnd_message.set_token('CHOICENO', l_char_choice);
2274: fnd_file.put_line( fnd_file.log, fnd_message.get());
2275:

Line 2272: fnd_message.set_token('APPNO', ln_appno);

2268: BEGIN
2269:
2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);
2272: fnd_message.set_token('APPNO', ln_appno);
2273: fnd_message.set_token('CHOICENO', l_char_choice);
2274: fnd_file.put_line( fnd_file.log, fnd_message.get());
2275:
2276: --Added as part of UCFD02 build for GTTR system.

Line 2273: fnd_message.set_token('CHOICENO', l_char_choice);

2269:
2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);
2272: fnd_message.set_token('APPNO', ln_appno);
2273: fnd_message.set_token('CHOICENO', l_char_choice);
2274: fnd_file.put_line( fnd_file.log, fnd_message.get());
2275:
2276: --Added as part of UCFD02 build for GTTR system.
2277: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.

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

2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);
2272: fnd_message.set_token('APPNO', ln_appno);
2273: fnd_message.set_token('CHOICENO', l_char_choice);
2274: fnd_file.put_line( fnd_file.log, fnd_message.get());
2275:
2276: --Added as part of UCFD02 build for GTTR system.
2277: --If the incoming CHOICE No. is Alphabetic then it has to be converted to appropriate Number and used.
2278: -- i.e. if the incoming Choice No = 'A' then Choice No = 10, If it is 'F' then Choice = 15 etc.

Line 2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');

2289: -- If no record was foung then log a message that "No Transaction record was found - Error codition since a transaction
2290: -- coming as Echo/Ack a transaction record should be existing in our tranaction table.
2291: -- If more than one record then update the oldest transaction record.
2292: IF cur_trans%NOTFOUND THEN
2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');
2294: fnd_message.set_token('TTYPE',p_trans_type);
2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());

Line 2294: fnd_message.set_token('TTYPE',p_trans_type);

2290: -- coming as Echo/Ack a transaction record should be existing in our tranaction table.
2291: -- If more than one record then update the oldest transaction record.
2292: IF cur_trans%NOTFOUND THEN
2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');
2294: fnd_message.set_token('TTYPE',p_trans_type);
2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());
2298: igs_ge_msg_stack.add;

Line 2295: fnd_message.set_token('APPNO',ln_appno);

2291: -- If more than one record then update the oldest transaction record.
2292: IF cur_trans%NOTFOUND THEN
2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');
2294: fnd_message.set_token('TTYPE',p_trans_type);
2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());
2298: igs_ge_msg_stack.add;
2299: app_exception.raise_exception;

Line 2296: fnd_message.set_token('CHCNO',ln_choiceno);

2292: IF cur_trans%NOTFOUND THEN
2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');
2294: fnd_message.set_token('TTYPE',p_trans_type);
2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());
2298: igs_ge_msg_stack.add;
2299: app_exception.raise_exception;
2300:

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

2293: fnd_message.set_name('IGS', 'IGS_UC_MV_NO_TRANIN');
2294: fnd_message.set_token('TTYPE',p_trans_type);
2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());
2298: igs_ge_msg_stack.add;
2299: app_exception.raise_exception;
2300:
2301: ELSE

Line 2344: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');

2340: CLOSE cur_trans;
2341:
2342: EXCEPTION
2343: WHEN VALUE_ERROR THEN
2344: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2345: fnd_message.set_token('TTYPE',p_trans_type);
2346: fnd_file.put_line( fnd_file.log, fnd_message.get());
2347: igs_ge_msg_stack.add;
2348: app_exception.raise_exception;

Line 2345: fnd_message.set_token('TTYPE',p_trans_type);

2341:
2342: EXCEPTION
2343: WHEN VALUE_ERROR THEN
2344: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2345: fnd_message.set_token('TTYPE',p_trans_type);
2346: fnd_file.put_line( fnd_file.log, fnd_message.get());
2347: igs_ge_msg_stack.add;
2348: app_exception.raise_exception;
2349:

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

2342: EXCEPTION
2343: WHEN VALUE_ERROR THEN
2344: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2345: fnd_message.set_token('TTYPE',p_trans_type);
2346: fnd_file.put_line( fnd_file.log, fnd_message.get());
2347: igs_ge_msg_stack.add;
2348: app_exception.raise_exception;
2349:
2350: WHEN OTHERS THEN

Line 2351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2347: igs_ge_msg_stack.add;
2348: app_exception.raise_exception;
2349:
2350: WHEN OTHERS THEN
2351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2352: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_ACK_TO_TRANS - '||SQLERRM);
2353: igs_ge_msg_stack.add;
2354: app_exception.raise_exception;
2355:

Line 2352: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_ACK_TO_TRANS - '||SQLERRM);

2348: app_exception.raise_exception;
2349:
2350: WHEN OTHERS THEN
2351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2352: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_ACK_TO_TRANS - '||SQLERRM);
2353: igs_ge_msg_stack.add;
2354: app_exception.raise_exception;
2355:
2356: END transfer_ack_to_trans;

Line 2423: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');

2419: FETCH c_interface INTO c_interface_rec ;
2420: IF c_interface%NOTFOUND THEN
2421: CLOSE c_interface ;
2422: l_valid := FALSE ;
2423: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
2424: fnd_message.set_token('SYSTEM', chk_file_type_rec.file_type ) ;
2425: fnd_file.put_line( fnd_file.log, fnd_message.get());
2426: ELSE
2427: CLOSE c_interface ;

Line 2424: fnd_message.set_token('SYSTEM', chk_file_type_rec.file_type ) ;

2420: IF c_interface%NOTFOUND THEN
2421: CLOSE c_interface ;
2422: l_valid := FALSE ;
2423: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
2424: fnd_message.set_token('SYSTEM', chk_file_type_rec.file_type ) ;
2425: fnd_file.put_line( fnd_file.log, fnd_message.get());
2426: ELSE
2427: CLOSE c_interface ;
2428: -- check for Marvin or Hercules Interface.

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

2421: CLOSE c_interface ;
2422: l_valid := FALSE ;
2423: fnd_message.set_name('IGS', 'IGS_UC_MV_SYSTEM_NOT_CONFIG');
2424: fnd_message.set_token('SYSTEM', chk_file_type_rec.file_type ) ;
2425: fnd_file.put_line( fnd_file.log, fnd_message.get());
2426: ELSE
2427: CLOSE c_interface ;
2428: -- check for Marvin or Hercules Interface.
2429: -- Load Marvin data only if the profile value is Marvin.

Line 2432: fnd_message.set_name('IGS', 'IGS_UC_SYS_NOT_MARV');

2428: -- check for Marvin or Hercules Interface.
2429: -- Load Marvin data only if the profile value is Marvin.
2430: IF c_interface_rec.ucas_interface <> 'M' THEN
2431: l_valid := FALSE ;
2432: fnd_message.set_name('IGS', 'IGS_UC_SYS_NOT_MARV');
2433: fnd_message.set_token('SYSTEM_CODE' ,chk_file_type_rec.file_type) ;
2434: fnd_file.put_line( fnd_file.log, fnd_message.get());
2435: END IF ;
2436: END IF;

Line 2433: fnd_message.set_token('SYSTEM_CODE' ,chk_file_type_rec.file_type) ;

2429: -- Load Marvin data only if the profile value is Marvin.
2430: IF c_interface_rec.ucas_interface <> 'M' THEN
2431: l_valid := FALSE ;
2432: fnd_message.set_name('IGS', 'IGS_UC_SYS_NOT_MARV');
2433: fnd_message.set_token('SYSTEM_CODE' ,chk_file_type_rec.file_type) ;
2434: fnd_file.put_line( fnd_file.log, fnd_message.get());
2435: END IF ;
2436: END IF;
2437: END LOOP ;

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

2430: IF c_interface_rec.ucas_interface <> 'M' THEN
2431: l_valid := FALSE ;
2432: fnd_message.set_name('IGS', 'IGS_UC_SYS_NOT_MARV');
2433: fnd_message.set_token('SYSTEM_CODE' ,chk_file_type_rec.file_type) ;
2434: fnd_file.put_line( fnd_file.log, fnd_message.get());
2435: END IF ;
2436: END IF;
2437: END LOOP ;
2438:

Line 2441: fnd_message.set_name('IGS', 'IGS_UC_MV_DATA_SEC_WRNG');

2437: END LOOP ;
2438:
2439: ELSE
2440: l_valid := FALSE ;
2441: fnd_message.set_name('IGS', 'IGS_UC_MV_DATA_SEC_WRNG');
2442: fnd_file.put_line( fnd_file.log, fnd_message.get());
2443: END IF;
2444:
2445: RETURN l_valid ;

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

2438:
2439: ELSE
2440: l_valid := FALSE ;
2441: fnd_message.set_name('IGS', 'IGS_UC_MV_DATA_SEC_WRNG');
2442: fnd_file.put_line( fnd_file.log, fnd_message.get());
2443: END IF;
2444:
2445: RETURN l_valid ;
2446:

Line 2449: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2445: RETURN l_valid ;
2446:
2447: EXCEPTION
2448: WHEN OTHERS THEN
2449: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2450: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.CHECK_VALIDITY - '||SQLERRM);
2451: igs_ge_msg_stack.add;
2452: app_exception.raise_exception;
2453:

Line 2450: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.CHECK_VALIDITY - '||SQLERRM);

2446:
2447: EXCEPTION
2448: WHEN OTHERS THEN
2449: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2450: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.CHECK_VALIDITY - '||SQLERRM);
2451: igs_ge_msg_stack.add;
2452: app_exception.raise_exception;
2453:
2454: END check_validity;

Line 2503: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2499: WHEN app_exception.record_lock_exception THEN
2500: RAISE;
2501:
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.MERGE_DATA - '||SQLERRM);
2505: igs_ge_msg_stack.add;
2506: app_exception.raise_exception;
2507:

Line 2504: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.MERGE_DATA - '||SQLERRM);

2500: RAISE;
2501:
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.MERGE_DATA - '||SQLERRM);
2505: igs_ge_msg_stack.add;
2506: app_exception.raise_exception;
2507:
2508: END merge_data;

Line 2550: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2546: WHEN app_exception.record_lock_exception THEN
2547: RAISE;
2548:
2549: WHEN OTHERS THEN
2550: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2551: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.REARRANGE_DATA - '||SQLERRM);
2552: igs_ge_msg_stack.add;
2553: app_exception.raise_exception;
2554:

Line 2551: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.REARRANGE_DATA - '||SQLERRM);

2547: RAISE;
2548:
2549: WHEN OTHERS THEN
2550: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2551: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.REARRANGE_DATA - '||SQLERRM);
2552: igs_ge_msg_stack.add;
2553: app_exception.raise_exception;
2554:
2555: END rearrange_data;

Line 2617: fnd_message.set_name('IGS', 'IGS_UC_INVLD_APPNO');

2613: -- available transaction
2614: IF rec_cur_ucas.trans_type IN ( '*A','*C','*G','*H','*K','*N','*P','*R','*T','*W','*X','*Z','LA', 'LC','LD','LE','LK','PE','RA','RD','RE','RK','RQ','RR','RW','RX','XA','XD') THEN
2615: IF TO_CHAR(get_check_digit(SUBSTR(rec_cur_ucas.record_data,1,8))) <> SUBSTR(rec_cur_ucas.record_data,9,1) THEN
2616: l_valid_rec := FALSE;
2617: fnd_message.set_name('IGS', 'IGS_UC_INVLD_APPNO');
2618: fnd_message.set_token('APPNO',SUBSTR(rec_cur_ucas.record_data,1,8));
2619: fnd_message.set_token('TTYPE',rec_cur_ucas.trans_type);
2620: fnd_file.put_line(fnd_file.log,fnd_message.get );
2621: END IF;

Line 2618: fnd_message.set_token('APPNO',SUBSTR(rec_cur_ucas.record_data,1,8));

2614: IF rec_cur_ucas.trans_type IN ( '*A','*C','*G','*H','*K','*N','*P','*R','*T','*W','*X','*Z','LA', 'LC','LD','LE','LK','PE','RA','RD','RE','RK','RQ','RR','RW','RX','XA','XD') THEN
2615: IF TO_CHAR(get_check_digit(SUBSTR(rec_cur_ucas.record_data,1,8))) <> SUBSTR(rec_cur_ucas.record_data,9,1) THEN
2616: l_valid_rec := FALSE;
2617: fnd_message.set_name('IGS', 'IGS_UC_INVLD_APPNO');
2618: fnd_message.set_token('APPNO',SUBSTR(rec_cur_ucas.record_data,1,8));
2619: fnd_message.set_token('TTYPE',rec_cur_ucas.trans_type);
2620: fnd_file.put_line(fnd_file.log,fnd_message.get );
2621: END IF;
2622:

Line 2619: fnd_message.set_token('TTYPE',rec_cur_ucas.trans_type);

2615: IF TO_CHAR(get_check_digit(SUBSTR(rec_cur_ucas.record_data,1,8))) <> SUBSTR(rec_cur_ucas.record_data,9,1) THEN
2616: l_valid_rec := FALSE;
2617: fnd_message.set_name('IGS', 'IGS_UC_INVLD_APPNO');
2618: fnd_message.set_token('APPNO',SUBSTR(rec_cur_ucas.record_data,1,8));
2619: fnd_message.set_token('TTYPE',rec_cur_ucas.trans_type);
2620: fnd_file.put_line(fnd_file.log,fnd_message.get );
2621: END IF;
2622:
2623: ELSE

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

2616: l_valid_rec := FALSE;
2617: fnd_message.set_name('IGS', 'IGS_UC_INVLD_APPNO');
2618: fnd_message.set_token('APPNO',SUBSTR(rec_cur_ucas.record_data,1,8));
2619: fnd_message.set_token('TTYPE',rec_cur_ucas.trans_type);
2620: fnd_file.put_line(fnd_file.log,fnd_message.get );
2621: END IF;
2622:
2623: ELSE
2624: -- if trans type = 'AE' then it carries the file seq num which needs to be validated that the flat files are being processed in sequence.

Line 2716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2712:
2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: fnd_file.put_line( fnd_file.log, 'TRANSACTION: ' ||l_trans_type || ' DATA : ' || l_curr_rec_data);
2716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_DATA - '||SQLERRM);
2718: igs_ge_msg_stack.add;
2719: app_exception.raise_exception;
2720:

Line 2717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_DATA - '||SQLERRM);

2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: fnd_file.put_line( fnd_file.log, 'TRANSACTION: ' ||l_trans_type || ' DATA : ' || l_curr_rec_data);
2716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_DATA - '||SQLERRM);
2718: igs_ge_msg_stack.add;
2719: app_exception.raise_exception;
2720:
2721: END transfer_data;

Line 2764: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');

2760: OPEN c_cycles ;
2761: FETCH c_cycles INTO g_c_cycles ;
2762: CLOSE c_cycles ;
2763: IF g_c_cycles.configured_cycle IS NULL OR g_c_cycles.current_cycle IS NULL THEN
2764: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
2765: errbuf := fnd_message.get;
2766: fnd_file.put_line(fnd_file.log, errbuf);
2767: retcode := 2 ;
2768: RETURN ;

Line 2765: errbuf := fnd_message.get;

2761: FETCH c_cycles INTO g_c_cycles ;
2762: CLOSE c_cycles ;
2763: IF g_c_cycles.configured_cycle IS NULL OR g_c_cycles.current_cycle IS NULL THEN
2764: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
2765: errbuf := fnd_message.get;
2766: fnd_file.put_line(fnd_file.log, errbuf);
2767: retcode := 2 ;
2768: RETURN ;
2769: END IF ;

Line 2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');

2774: FETCH c_ucas_cycle INTO c_ucas_cycle_rec ;
2775: CLOSE c_ucas_cycle ;
2776: -- If hercules and our oss system are not configured to the same cycle then report error and exit
2777: IF NVL(c_ucas_cycle_rec.entry_year,0) <> LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) THEN
2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );
2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
2781: fnd_message.set_token('SYSTEM_CODE','UCAS');
2782: errbuf := fnd_message.get ;

Line 2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );

2775: CLOSE c_ucas_cycle ;
2776: -- If hercules and our oss system are not configured to the same cycle then report error and exit
2777: IF NVL(c_ucas_cycle_rec.entry_year,0) <> LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) THEN
2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );
2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
2781: fnd_message.set_token('SYSTEM_CODE','UCAS');
2782: errbuf := fnd_message.get ;
2783: fnd_file.put_line(fnd_file.log,errbuf );

Line 2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );

2776: -- If hercules and our oss system are not configured to the same cycle then report error and exit
2777: IF NVL(c_ucas_cycle_rec.entry_year,0) <> LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) THEN
2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );
2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
2781: fnd_message.set_token('SYSTEM_CODE','UCAS');
2782: errbuf := fnd_message.get ;
2783: fnd_file.put_line(fnd_file.log,errbuf );
2784: retcode := 2 ;

Line 2781: fnd_message.set_token('SYSTEM_CODE','UCAS');

2777: IF NVL(c_ucas_cycle_rec.entry_year,0) <> LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) THEN
2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );
2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
2781: fnd_message.set_token('SYSTEM_CODE','UCAS');
2782: errbuf := fnd_message.get ;
2783: fnd_file.put_line(fnd_file.log,errbuf );
2784: retcode := 2 ;
2785: RETURN ;

Line 2782: errbuf := fnd_message.get ;

2778: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
2779: fnd_message.set_token('UCAS_CYCLE',LTRIM(SUBSTR(g_c_cycles.configured_cycle,3,2) ) );
2780: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
2781: fnd_message.set_token('SYSTEM_CODE','UCAS');
2782: errbuf := fnd_message.get ;
2783: fnd_file.put_line(fnd_file.log,errbuf );
2784: retcode := 2 ;
2785: RETURN ;
2786: END IF ;

Line 2789: fnd_message.set_name('IGS','IGS_UC_CYC_INFO');

2785: RETURN ;
2786: END IF ;
2787:
2788: -- show the configured cycle information , because the other messages donot show its value
2789: fnd_message.set_name('IGS','IGS_UC_CYC_INFO');
2790: fnd_message.set_token('CONF_CYCLE',g_c_cycles.configured_cycle );
2791: fnd_file.put_line(fnd_file.log, fnd_message.get );
2792: fnd_file.put_line( fnd_file.log, ' ');
2793:

Line 2790: fnd_message.set_token('CONF_CYCLE',g_c_cycles.configured_cycle );

2786: END IF ;
2787:
2788: -- show the configured cycle information , because the other messages donot show its value
2789: fnd_message.set_name('IGS','IGS_UC_CYC_INFO');
2790: fnd_message.set_token('CONF_CYCLE',g_c_cycles.configured_cycle );
2791: fnd_file.put_line(fnd_file.log, fnd_message.get );
2792: fnd_file.put_line( fnd_file.log, ' ');
2793:
2794: -- Check for the Validity of the file.

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

2787:
2788: -- show the configured cycle information , because the other messages donot show its value
2789: fnd_message.set_name('IGS','IGS_UC_CYC_INFO');
2790: fnd_message.set_token('CONF_CYCLE',g_c_cycles.configured_cycle );
2791: fnd_file.put_line(fnd_file.log, fnd_message.get );
2792: fnd_file.put_line( fnd_file.log, ' ');
2793:
2794: -- Check for the Validity of the file.
2795: -- 1.Number of headers in the data file should equal to number of trailers

Line 2824: fnd_message.set_name('IGS', 'IGS_UC_MV_LOAD_SUCCESS');

2820: END IF ;
2821:
2822: -- Print Number of records successfully transferred
2823: fnd_file.put_line( fnd_file.log, ' ');
2824: fnd_message.set_name('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
2825: fnd_message.set_token('CNT', g_success_cnt);
2826: fnd_file.put_line( fnd_file.log, fnd_message.get());
2827:
2828: -- commit the data;

Line 2825: fnd_message.set_token('CNT', g_success_cnt);

2821:
2822: -- Print Number of records successfully transferred
2823: fnd_file.put_line( fnd_file.log, ' ');
2824: fnd_message.set_name('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
2825: fnd_message.set_token('CNT', g_success_cnt);
2826: fnd_file.put_line( fnd_file.log, fnd_message.get());
2827:
2828: -- commit the data;
2829: COMMIT;

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

2822: -- Print Number of records successfully transferred
2823: fnd_file.put_line( fnd_file.log, ' ');
2824: fnd_message.set_name('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
2825: fnd_message.set_token('CNT', g_success_cnt);
2826: fnd_file.put_line( fnd_file.log, fnd_message.get());
2827:
2828: -- commit the data;
2829: COMMIT;
2830: fnd_file.put_line( fnd_file.log, ' ');

Line 2836: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

2832: EXCEPTION
2833: WHEN app_exception.record_lock_exception THEN
2834: ROLLBACK;
2835: retcode := 2;
2836: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2837: igs_ge_msg_stack.conc_exception_hndl;
2838:
2839: WHEN OTHERS THEN
2840: ROLLBACK;

Line 2842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2838:
2839: WHEN OTHERS THEN
2840: ROLLBACK;
2841: retcode := 2;
2842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2843: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.PROCESS_MARVIN_DATA - '||SQLERRM);
2844: errbuf := fnd_message.get;
2845: igs_ge_msg_stack.conc_exception_hndl;
2846:

Line 2843: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.PROCESS_MARVIN_DATA - '||SQLERRM);

2839: WHEN OTHERS THEN
2840: ROLLBACK;
2841: retcode := 2;
2842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2843: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.PROCESS_MARVIN_DATA - '||SQLERRM);
2844: errbuf := fnd_message.get;
2845: igs_ge_msg_stack.conc_exception_hndl;
2846:
2847: END process_marvin_data;

Line 2844: errbuf := fnd_message.get;

2840: ROLLBACK;
2841: retcode := 2;
2842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2843: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.PROCESS_MARVIN_DATA - '||SQLERRM);
2844: errbuf := fnd_message.get;
2845: igs_ge_msg_stack.conc_exception_hndl;
2846:
2847: END process_marvin_data;
2848: