APPS.IGS_HE_EXTRACT2_PKG dependencies on FND_MESSAGE

Line 149: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

145: IF c_field_of_study%ISOPEN THEN
146: CLOSE c_field_of_study ;
147: END IF ;
148:
149: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
150: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pgce_subj');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153:

Line 150: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pgce_subj');

146: CLOSE c_field_of_study ;
147: END IF ;
148:
149: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
150: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pgce_subj');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153:
154: END get_pgce_subj ;

Line 352: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

348: THEN
349: CLOSE c_mapval;
350: END IF;
351:
352: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
353: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values_from_sql');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356:

Line 353: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values_from_sql');

349: CLOSE c_mapval;
350: END IF;
351:
352: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
353: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values_from_sql');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356:
357: END get_map_values_from_sql;

Line 450: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

446: THEN
447: CLOSE cur_map5;
448: END IF;
449:
450: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
451: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454:

Line 451: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values');

447: CLOSE cur_map5;
448: END IF;
449:
450: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
451: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_map_values');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454:
455: END get_map_values;

Line 538: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

534: EXCEPTION
535: WHEN OTHERS
536: THEN
537: write_to_log(SQLERRM);
538: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
539: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.log_error');
540: IGS_GE_MSG_STACK.ADD;
541: App_Exception.Raise_Exception;
542:

Line 539: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.log_error');

535: WHEN OTHERS
536: THEN
537: write_to_log(SQLERRM);
538: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
539: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.log_error');
540: IGS_GE_MSG_STACK.ADD;
541: App_Exception.Raise_Exception;
542:
543: END log_error;

Line 636: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLDS_NOT_FOUND');

632: END LOOP;
633:
634: IF g_field_defn.field_number.COUNT = 0
635: THEN
636: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLDS_NOT_FOUND');
637: l_message := Fnd_Message.Get;
638: write_to_log(l_message);
639: -- Initialize Record to Null.
640: g_he_ext_run_except := NULL;

Line 637: l_message := Fnd_Message.Get;

633:
634: IF g_field_defn.field_number.COUNT = 0
635: THEN
636: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLDS_NOT_FOUND');
637: l_message := Fnd_Message.Get;
638: write_to_log(l_message);
639: -- Initialize Record to Null.
640: g_he_ext_run_except := NULL;
641:

Line 660: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

656: THEN
657: CLOSE c_ext_dtl;
658: END IF;
659:
660: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
661: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_field_defn');
662: IGS_GE_MSG_STACK.ADD;
663: App_Exception.Raise_Exception;
664:

Line 661: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_field_defn');

657: CLOSE c_ext_dtl;
658: END IF;
659:
660: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
661: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.get_field_defn');
662: IGS_GE_MSG_STACK.ADD;
663: App_Exception.Raise_Exception;
664:
665: END get_field_defn;

Line 4586: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');

4582: EXCEPTION
4583: WHEN OTHERS
4584: THEN
4585: write_to_log(SQLERRM);
4586: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
4587: fnd_message.set_token('field_number',p_field_number);
4588: IGS_GE_MSG_STACK.ADD;
4589: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4590: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_comb_fields');

Line 4587: fnd_message.set_token('field_number',p_field_number);

4583: WHEN OTHERS
4584: THEN
4585: write_to_log(SQLERRM);
4586: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
4587: fnd_message.set_token('field_number',p_field_number);
4588: IGS_GE_MSG_STACK.ADD;
4589: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4590: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_comb_fields');
4591: IGS_GE_MSG_STACK.ADD;

Line 4589: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4585: write_to_log(SQLERRM);
4586: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
4587: fnd_message.set_token('field_number',p_field_number);
4588: IGS_GE_MSG_STACK.ADD;
4589: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4590: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_comb_fields');
4591: IGS_GE_MSG_STACK.ADD;
4592: App_Exception.Raise_Exception;
4593:

Line 4590: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_comb_fields');

4586: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
4587: fnd_message.set_token('field_number',p_field_number);
4588: IGS_GE_MSG_STACK.ADD;
4589: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4590: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_comb_fields');
4591: IGS_GE_MSG_STACK.ADD;
4592: App_Exception.Raise_Exception;
4593:
4594: END process_comb_fields;

Line 8204: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');

8200: EXCEPTION
8201: WHEN OTHERS
8202: THEN
8203: write_to_log(SQLERRM);
8204: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8205: fnd_message.set_token('field_number',p_field_number);
8206: IGS_GE_MSG_STACK.ADD;
8207: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8208: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_stdnt_fields');

Line 8205: fnd_message.set_token('field_number',p_field_number);

8201: WHEN OTHERS
8202: THEN
8203: write_to_log(SQLERRM);
8204: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8205: fnd_message.set_token('field_number',p_field_number);
8206: IGS_GE_MSG_STACK.ADD;
8207: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8208: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_stdnt_fields');
8209: IGS_GE_MSG_STACK.ADD;

Line 8207: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

8203: write_to_log(SQLERRM);
8204: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8205: fnd_message.set_token('field_number',p_field_number);
8206: IGS_GE_MSG_STACK.ADD;
8207: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8208: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_stdnt_fields');
8209: IGS_GE_MSG_STACK.ADD;
8210: App_Exception.Raise_Exception;
8211:

Line 8208: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_stdnt_fields');

8204: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8205: fnd_message.set_token('field_number',p_field_number);
8206: IGS_GE_MSG_STACK.ADD;
8207: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8208: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_stdnt_fields');
8209: IGS_GE_MSG_STACK.ADD;
8210: App_Exception.Raise_Exception;
8211:
8212: END process_stdnt_fields;

Line 8573: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');

8569: EXCEPTION
8570: WHEN OTHERS
8571: THEN
8572: write_to_log(SQLERRM);
8573: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8574: fnd_message.set_token('field_number',p_field_number);
8575: IGS_GE_MSG_STACK.ADD;
8576:
8577: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 8574: fnd_message.set_token('field_number',p_field_number);

8570: WHEN OTHERS
8571: THEN
8572: write_to_log(SQLERRM);
8573: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8574: fnd_message.set_token('field_number',p_field_number);
8575: IGS_GE_MSG_STACK.ADD;
8576:
8577: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8578: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_module_fields');

Line 8577: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

8573: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
8574: fnd_message.set_token('field_number',p_field_number);
8575: IGS_GE_MSG_STACK.ADD;
8576:
8577: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8578: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_module_fields');
8579: IGS_GE_MSG_STACK.ADD;
8580: App_Exception.Raise_Exception;
8581: END process_module_fields;

Line 8578: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_module_fields');

8574: fnd_message.set_token('field_number',p_field_number);
8575: IGS_GE_MSG_STACK.ADD;
8576:
8577: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
8578: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_module_fields');
8579: IGS_GE_MSG_STACK.ADD;
8580: App_Exception.Raise_Exception;
8581: END process_module_fields;
8582:

Line 9168: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');

9164: EXCEPTION
9165: WHEN OTHERS
9166: THEN
9167: write_to_log(SQLERRM);
9168: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
9169: fnd_message.set_token('field_number',p_field_number);
9170: IGS_GE_MSG_STACK.ADD;
9171: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
9172: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_fields');

Line 9169: fnd_message.set_token('field_number',p_field_number);

9165: WHEN OTHERS
9166: THEN
9167: write_to_log(SQLERRM);
9168: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
9169: fnd_message.set_token('field_number',p_field_number);
9170: IGS_GE_MSG_STACK.ADD;
9171: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
9172: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_fields');
9173: IGS_GE_MSG_STACK.ADD;

Line 9171: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

9167: write_to_log(SQLERRM);
9168: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
9169: fnd_message.set_token('field_number',p_field_number);
9170: IGS_GE_MSG_STACK.ADD;
9171: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
9172: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_fields');
9173: IGS_GE_MSG_STACK.ADD;
9174: App_Exception.Raise_Exception;
9175:

Line 9172: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_fields');

9168: fnd_message.set_name('IGS','IGS_HE_FIELD_NUM');
9169: fnd_message.set_token('field_number',p_field_number);
9170: IGS_GE_MSG_STACK.ADD;
9171: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
9172: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_fields');
9173: IGS_GE_MSG_STACK.ADD;
9174: App_Exception.Raise_Exception;
9175:
9176: END process_dlhe_fields;

Line 9863: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');

9859: g_pe_person.birth_dt ,
9860: g_pe_person.full_name ;
9861: IF c_pers%NOTFOUND
9862: THEN
9863: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');
9864: l_message := Fnd_Message.Get;
9865:
9866: -- Initialize Record to Null.
9867: g_he_ext_run_except := NULL;

Line 9864: l_message := Fnd_Message.Get;

9860: g_pe_person.full_name ;
9861: IF c_pers%NOTFOUND
9862: THEN
9863: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');
9864: l_message := Fnd_Message.Get;
9865:
9866: -- Initialize Record to Null.
9867: g_he_ext_run_except := NULL;
9868:

Line 9987: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_SPA_DTL_NOT_FOUND');

9983:
9984: IF c_spa%NOTFOUND
9985: THEN
9986: -- If SPA details were not found, then log error
9987: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_SPA_DTL_NOT_FOUND');
9988: l_message := Fnd_Message.Get;
9989:
9990: -- Initialize Record to Null.
9991: g_he_ext_run_except := NULL;

Line 9988: l_message := Fnd_Message.Get;

9984: IF c_spa%NOTFOUND
9985: THEN
9986: -- If SPA details were not found, then log error
9987: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_SPA_DTL_NOT_FOUND');
9988: l_message := Fnd_Message.Get;
9989:
9990: -- Initialize Record to Null.
9991: g_he_ext_run_except := NULL;
9992:

Line 10151: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_YOP_NOT_FOUND');

10147:
10148: IF c_yop%NOTFOUND
10149: THEN
10150: -- If Year of Program details were not found, then log error
10151: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_YOP_NOT_FOUND');
10152: l_message := Fnd_Message.Get;
10153:
10154: -- Initialize Record to Null.
10155: g_he_ext_run_except := NULL;

Line 10152: l_message := Fnd_Message.Get;

10148: IF c_yop%NOTFOUND
10149: THEN
10150: -- If Year of Program details were not found, then log error
10151: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_YOP_NOT_FOUND');
10152: l_message := Fnd_Message.Get;
10153:
10154: -- Initialize Record to Null.
10155: g_he_ext_run_except := NULL;
10156:

Line 10249: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_CRSE_DTL_NOT_FOUND');

10245:
10246: IF c_crse%NOTFOUND
10247: THEN
10248: -- If Course details were not found, then log error
10249: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_CRSE_DTL_NOT_FOUND');
10250: l_message := Fnd_Message.Get;
10251:
10252: -- Initialize Record to Null.
10253: g_he_ext_run_except := NULL;

Line 10250: l_message := Fnd_Message.Get;

10246: IF c_crse%NOTFOUND
10247: THEN
10248: -- If Course details were not found, then log error
10249: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_CRSE_DTL_NOT_FOUND');
10250: l_message := Fnd_Message.Get;
10251:
10252: -- Initialize Record to Null.
10253: g_he_ext_run_except := NULL;
10254:

Line 10321: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

10317: THEN
10318: CLOSE c_adm;
10319: END IF;
10320:
10321: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10322: Fnd_Message.Set_Token('NAME',
10323: 'IGS_HE_EXTRACT2_PKG.process_comb_stdnt_return');
10324: IGS_GE_MSG_STACK.ADD;
10325: App_Exception.Raise_Exception;

Line 10322: Fnd_Message.Set_Token('NAME',

10318: CLOSE c_adm;
10319: END IF;
10320:
10321: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10322: Fnd_Message.Set_Token('NAME',
10323: 'IGS_HE_EXTRACT2_PKG.process_comb_stdnt_return');
10324: IGS_GE_MSG_STACK.ADD;
10325: App_Exception.Raise_Exception;
10326: END process_comb_stdnt_return;

Line 10384: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_MOD_DTL_NOT_FOUND');

10380:
10381: IF c_moddtl%NOTFOUND
10382: THEN
10383: -- If Module details were not found, then log error
10384: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_MOD_DTL_NOT_FOUND');
10385: l_message := Fnd_Message.Get;
10386:
10387: -- Initialize Record to Null.
10388: g_he_ext_run_except := NULL;

Line 10385: l_message := Fnd_Message.Get;

10381: IF c_moddtl%NOTFOUND
10382: THEN
10383: -- If Module details were not found, then log error
10384: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_MOD_DTL_NOT_FOUND');
10385: l_message := Fnd_Message.Get;
10386:
10387: -- Initialize Record to Null.
10388: g_he_ext_run_except := NULL;
10389:

Line 10431: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

10427: THEN
10428: CLOSE c_moddtl;
10429: END IF;
10430:
10431: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10432: Fnd_Message.Set_Token('NAME',
10433: 'IGS_HE_EXTRACT2_PKG.process_module_return');
10434: IGS_GE_MSG_STACK.ADD;
10435: App_Exception.Raise_Exception;

Line 10432: Fnd_Message.Set_Token('NAME',

10428: CLOSE c_moddtl;
10429: END IF;
10430:
10431: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10432: Fnd_Message.Set_Token('NAME',
10433: 'IGS_HE_EXTRACT2_PKG.process_module_return');
10434: IGS_GE_MSG_STACK.ADD;
10435: App_Exception.Raise_Exception;
10436: END process_module_return;

Line 10488: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');

10484: OPEN c_pers_number;
10485: FETCH c_pers_number INTO g_pe_person.person_number;
10486: IF c_pers_number%NOTFOUND
10487: THEN
10488: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');
10489: l_message := Fnd_Message.Get;
10490:
10491: -- Initialize Record to Null.
10492: g_he_ext_run_except := NULL;

Line 10489: l_message := Fnd_Message.Get;

10485: FETCH c_pers_number INTO g_pe_person.person_number;
10486: IF c_pers_number%NOTFOUND
10487: THEN
10488: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_PSN_NOT_FOUND');
10489: l_message := Fnd_Message.Get;
10490:
10491: -- Initialize Record to Null.
10492: g_he_ext_run_except := NULL;
10493:

Line 10520: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DLHE_DTL_NOT_FOUND');

10516:
10517: IF c_dlhe_dtls%NOTFOUND
10518: THEN
10519: -- If dlhe person details were not found, then log error
10520: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DLHE_DTL_NOT_FOUND');
10521: l_message := Fnd_Message.Get;
10522:
10523: -- Initialize Record to Null.
10524: g_he_ext_run_except := NULL;

Line 10521: l_message := Fnd_Message.Get;

10517: IF c_dlhe_dtls%NOTFOUND
10518: THEN
10519: -- If dlhe person details were not found, then log error
10520: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DLHE_DTL_NOT_FOUND');
10521: l_message := Fnd_Message.Get;
10522:
10523: -- Initialize Record to Null.
10524: g_he_ext_run_except := NULL;
10525:

Line 10567: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

10563: THEN
10564: CLOSE c_dlhe_dtls;
10565: END IF;
10566:
10567: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10568: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_return');
10569: IGS_GE_MSG_STACK.ADD;
10570: App_Exception.Raise_Exception;
10571: END process_dlhe_return;

Line 10568: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_return');

10564: CLOSE c_dlhe_dtls;
10565: END IF;
10566:
10567: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10568: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_dlhe_return');
10569: IGS_GE_MSG_STACK.ADD;
10570: App_Exception.Raise_Exception;
10571: END process_dlhe_return;
10572:

Line 10639: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');

10635: g_prog_rec_flag := FALSE;
10636: g_prog_type_rec_flag := FALSE;
10637:
10638: -- printing datetimestamp for monitoring performance
10639: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
10640: fnd_message.set_token('PROCEDURE', 'PROCESS_TEMP_TABLE');
10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:

Line 10640: fnd_message.set_token('PROCEDURE', 'PROCESS_TEMP_TABLE');

10636: g_prog_type_rec_flag := FALSE;
10637:
10638: -- printing datetimestamp for monitoring performance
10639: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
10640: fnd_message.set_token('PROCEDURE', 'PROCESS_TEMP_TABLE');
10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:
10644:

Line 10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

10637:
10638: -- printing datetimestamp for monitoring performance
10639: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
10640: fnd_message.set_token('PROCEDURE', 'PROCESS_TEMP_TABLE');
10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:
10644:
10645: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLD_VAL_NULL');

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

10638: -- printing datetimestamp for monitoring performance
10639: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
10640: fnd_message.set_token('PROCEDURE', 'PROCESS_TEMP_TABLE');
10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:
10644:
10645: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLD_VAL_NULL');
10646: g_msg_ext_fld_val_null := Fnd_Message.Get;

Line 10645: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLD_VAL_NULL');

10641: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:
10644:
10645: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLD_VAL_NULL');
10646: g_msg_ext_fld_val_null := Fnd_Message.Get;
10647:
10648: -- Load the field definitions for each field of the return
10649: -- into an array

Line 10646: g_msg_ext_fld_val_null := Fnd_Message.Get;

10642: fnd_file.put_line(fnd_file.log, fnd_message.get);
10643:
10644:
10645: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_FLD_VAL_NULL');
10646: g_msg_ext_fld_val_null := Fnd_Message.Get;
10647:
10648: -- Load the field definitions for each field of the return
10649: -- into an array
10650: get_field_defn (p_extract_run_id );

Line 10784: fnd_message.set_name('IGS','IGS_HE_COM_STD_PROC');

10780: l_he_ex_rn_dat_ln.student_inst_number,
10781: l_he_ex_rn_dat_ln.line_number)
10782: THEN
10783:
10784: fnd_message.set_name('IGS','IGS_HE_COM_STD_PROC');
10785: fnd_message.set_token('person',l_person_number);
10786: fnd_file.put_line(fnd_file.log,fnd_message.get());
10787:
10788:

Line 10785: fnd_message.set_token('person',l_person_number);

10781: l_he_ex_rn_dat_ln.line_number)
10782: THEN
10783:
10784: fnd_message.set_name('IGS','IGS_HE_COM_STD_PROC');
10785: fnd_message.set_token('person',l_person_number);
10786: fnd_file.put_line(fnd_file.log,fnd_message.get());
10787:
10788:
10789: -- Not processed successfully, therefore rollback

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

10782: THEN
10783:
10784: fnd_message.set_name('IGS','IGS_HE_COM_STD_PROC');
10785: fnd_message.set_token('person',l_person_number);
10786: fnd_file.put_line(fnd_file.log,fnd_message.get());
10787:
10788:
10789: -- Not processed successfully, therefore rollback
10790: -- for this student record

Line 10808: fnd_message.set_name('IGS','IGS_HE_MOD_PROC');

10804: -- Not processed successfully, therefore rollback
10805: -- for this module record
10806: ROLLBACK TO savepoint_dat_ln_ins;
10807:
10808: fnd_message.set_name('IGS','IGS_HE_MOD_PROC');
10809: fnd_message.set_token('unit',l_he_ex_rn_dat_ln.unit_cd);
10810: fnd_file.put_line(fnd_file.log,fnd_message.get());
10811:
10812: -- Decrement the line number as this line will not

Line 10809: fnd_message.set_token('unit',l_he_ex_rn_dat_ln.unit_cd);

10805: -- for this module record
10806: ROLLBACK TO savepoint_dat_ln_ins;
10807:
10808: fnd_message.set_name('IGS','IGS_HE_MOD_PROC');
10809: fnd_message.set_token('unit',l_he_ex_rn_dat_ln.unit_cd);
10810: fnd_file.put_line(fnd_file.log,fnd_message.get());
10811:
10812: -- Decrement the line number as this line will not
10813: -- be processed.

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

10806: ROLLBACK TO savepoint_dat_ln_ins;
10807:
10808: fnd_message.set_name('IGS','IGS_HE_MOD_PROC');
10809: fnd_message.set_token('unit',l_he_ex_rn_dat_ln.unit_cd);
10810: fnd_file.put_line(fnd_file.log,fnd_message.get());
10811:
10812: -- Decrement the line number as this line will not
10813: -- be processed.
10814: l_line_number := l_line_number - 1;

Line 10827: fnd_message.set_name('IGS','IGS_HE_DLHE_PROC');

10823: -- Not processed successfully, therefore rollback
10824: -- for this student record
10825: ROLLBACK TO savepoint_dat_ln_ins;
10826:
10827: fnd_message.set_name('IGS','IGS_HE_DLHE_PROC');
10828: fnd_message.set_token('unit',l_person_number);
10829: fnd_file.put_line(fnd_file.log,fnd_message.get());
10830:
10831: -- Decrement the line number as this line will not

Line 10828: fnd_message.set_token('unit',l_person_number);

10824: -- for this student record
10825: ROLLBACK TO savepoint_dat_ln_ins;
10826:
10827: fnd_message.set_name('IGS','IGS_HE_DLHE_PROC');
10828: fnd_message.set_token('unit',l_person_number);
10829: fnd_file.put_line(fnd_file.log,fnd_message.get());
10830:
10831: -- Decrement the line number as this line will not
10832: -- be processed.

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

10825: ROLLBACK TO savepoint_dat_ln_ins;
10826:
10827: fnd_message.set_name('IGS','IGS_HE_DLHE_PROC');
10828: fnd_message.set_token('unit',l_person_number);
10829: fnd_file.put_line(fnd_file.log,fnd_message.get());
10830:
10831: -- Decrement the line number as this line will not
10832: -- be processed.
10833: l_line_number := l_line_number - 1;

Line 10871: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

10867: EXCEPTION
10868: WHEN OTHERS
10869: THEN
10870: write_to_log(SQLERRM);
10871: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10872: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_temp_table');
10873: IGS_GE_MSG_STACK.ADD;
10874: App_Exception.Raise_Exception;
10875:

Line 10872: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_temp_table');

10868: WHEN OTHERS
10869: THEN
10870: write_to_log(SQLERRM);
10871: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
10872: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT2_PKG.process_temp_table');
10873: IGS_GE_MSG_STACK.ADD;
10874: App_Exception.Raise_Exception;
10875:
10876: END process_temp_table;