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_HE_EXTRACT2_PKG dependencies on IGS_HE_EXTRACT2_PKG

Line 1: PACKAGE BODY IGS_HE_EXTRACT2_PKG AS

1: PACKAGE BODY IGS_HE_EXTRACT2_PKG AS
2: /* $Header: IGSHE9BB.pls 120.15 2006/09/21 23:56:26 jbaber noship $ */
3:
4: -- Variables that will be accessed by any or all the procedures
5: -- Extract related records

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 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 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 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 2115: igs_he_extract2_pkg.get_pgce_subj

2111: -- PGCE - Subject of Undergraduate Degree
2112: -- smaddali added call to the new local procedure for bug 2452592
2113: IF g_field_defn.hesa_value.EXISTS(41) AND g_field_defn.hesa_value(41) IN ('12','13')
2114: THEN
2115: igs_he_extract2_pkg.get_pgce_subj
2116: (p_person_id => p_person_id,
2117: p_pgce_subj => p_value);
2118: ELSE
2119: p_value := NULL ;

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 6011: igs_he_extract2_pkg.get_pgce_subj

6007: -- PGCE - Subject of Undergraduate Degree
6008: -- smaddali added call to the new local procedure for bug 2452592
6009: IF g_field_defn.hesa_value.EXISTS(41) AND g_field_defn.hesa_value(41) IN ('12','13')
6010: THEN
6011: igs_he_extract2_pkg.get_pgce_subj
6012: (p_person_id => p_person_id,
6013: p_pgce_subj => p_value);
6014: ELSE
6015: p_value := NULL ;

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 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 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 10323: 'IGS_HE_EXTRACT2_PKG.process_comb_stdnt_return');

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;
10327:

Line 10433: 'IGS_HE_EXTRACT2_PKG.process_module_return');

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;
10437:

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 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;

Line 10878: END IGS_HE_EXTRACT2_PKG;

10874: App_Exception.Raise_Exception;
10875:
10876: END process_temp_table;
10877:
10878: END IGS_HE_EXTRACT2_PKG;