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

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

83: EXCEPTION
84: WHEN OTHERS
85: THEN
86: write_to_log(SQLERRM);
87: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
88: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.log_error');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91:

Line 88: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.log_error');

84: WHEN OTHERS
85: THEN
86: write_to_log(SQLERRM);
87: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
88: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.log_error');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91:
92: END log_error;

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

190: THEN
191: CLOSE c_prog_type;
192: END IF;
193:
194: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
195: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_award_conferral_dates');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198:

Line 195: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_award_conferral_dates');

191: CLOSE c_prog_type;
192: END IF;
193:
194: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
195: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_award_conferral_dates');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198:
199:

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

272: CLOSE c_program;
273: END IF;
274:
275:
276: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
277: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_relalc_params');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280:

Line 277: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_relalc_params');

273: END IF;
274:
275:
276: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
277: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_relalc_params');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280:
281: END validate_recalc_params;

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

419: THEN
420: CLOSE c_psn_grp;
421: END IF;
422:
423: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
424: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params');
425: IGS_GE_MSG_STACK.ADD;
426: App_Exception.Raise_Exception;
427:

Line 424: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params');

420: CLOSE c_psn_grp;
421: END IF;
422:
423: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
424: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params');
425: IGS_GE_MSG_STACK.ADD;
426: App_Exception.Raise_Exception;
427:
428: END validate_params;

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

761: THEN
762: CLOSE c_specst;
763: END IF;
764:
765: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
766: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params1');
767: IGS_GE_MSG_STACK.ADD;
768: App_Exception.Raise_Exception;
769:

Line 766: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params1');

762: CLOSE c_specst;
763: END IF;
764:
765: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
766: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params1');
767: IGS_GE_MSG_STACK.ADD;
768: App_Exception.Raise_Exception;
769:
770: END validate_params1;

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

958: WHEN OTHERS
959: THEN
960: write_to_log(SQLERRM);
961:
962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
963: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params2');
964: IGS_GE_MSG_STACK.ADD;
965: App_Exception.Raise_Exception;
966:

Line 963: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params2');

959: THEN
960: write_to_log(SQLERRM);
961:
962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
963: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_params2');
964: IGS_GE_MSG_STACK.ADD;
965: App_Exception.Raise_Exception;
966:
967: END validate_params2;

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

1314:
1315: BEGIN
1316:
1317: -- printing datetimestamp for monitoring performance
1318: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:

Line 1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');

1315: BEGIN
1316:
1317: -- printing datetimestamp for monitoring performance
1318: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');

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

1316:
1317: -- printing datetimestamp for monitoring performance
1318: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());

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

1317: -- printing datetimestamp for monitoring performance
1318: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());
1325:

Line 1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');

1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());
1325:
1326: l_awd_min_dt := NULL;
1327: l_awd_max_dt := NULL;

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

1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());
1325:
1326: l_awd_min_dt := NULL;
1327: l_awd_max_dt := NULL;
1328:

Line 1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');

1447: EXCEPTION
1448: WHEN value_error THEN
1449: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1450: IF l_std_inst.person_id <> l_prev_person_id THEN
1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');
1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);
1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1454: fnd_file.put_line(fnd_file.log,fnd_message.get());
1455: END IF;

Line 1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);

1448: WHEN value_error THEN
1449: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1450: IF l_std_inst.person_id <> l_prev_person_id THEN
1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');
1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);
1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1454: fnd_file.put_line(fnd_file.log,fnd_message.get());
1455: END IF;
1456:

Line 1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);

1449: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1450: IF l_std_inst.person_id <> l_prev_person_id THEN
1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');
1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);
1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1454: fnd_file.put_line(fnd_file.log,fnd_message.get());
1455: END IF;
1456:
1457: --In case the alternate person id contains non-numeric characters ,then log the message and

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

1450: IF l_std_inst.person_id <> l_prev_person_id THEN
1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');
1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);
1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1454: fnd_file.put_line(fnd_file.log,fnd_message.get());
1455: END IF;
1456:
1457: --In case the alternate person id contains non-numeric characters ,then log the message and
1458: -- exclude this record from furtehr processing

Line 1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');

1463: -- Modified this validation to exclude the HUSID Type for bug, 3296711
1464: IF alternate_id_rec.person_id_type <> 'HUSID' AND alternate_id_rec.api_length > 8 THEN
1465: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1466: IF l_std_inst.person_id <> l_prev_person_id THEN
1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');
1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);
1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1470: fnd_file.put_line(fnd_file.log,fnd_message.get());
1471: END IF;

Line 1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);

1464: IF alternate_id_rec.person_id_type <> 'HUSID' AND alternate_id_rec.api_length > 8 THEN
1465: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1466: IF l_std_inst.person_id <> l_prev_person_id THEN
1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');
1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);
1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1470: fnd_file.put_line(fnd_file.log,fnd_message.get());
1471: END IF;
1472: --In case the alternate person id contains more than 8 digits ,then log the message and

Line 1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);

1465: -- added the check l_std_inst.person_id <> l_prev_person_id for Bug, 3491096
1466: IF l_std_inst.person_id <> l_prev_person_id THEN
1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');
1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);
1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1470: fnd_file.put_line(fnd_file.log,fnd_message.get());
1471: END IF;
1472: --In case the alternate person id contains more than 8 digits ,then log the message and
1473: -- exclude this record from furtehr processing

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

1466: IF l_std_inst.person_id <> l_prev_person_id THEN
1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');
1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);
1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1470: fnd_file.put_line(fnd_file.log,fnd_message.get());
1471: END IF;
1472: --In case the alternate person id contains more than 8 digits ,then log the message and
1473: -- exclude this record from furtehr processing
1474: l_valid := FALSE ;

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

1648: THEN
1649: -- If Year of Program details were not found, then log error
1650: l_valid := FALSE;
1651:
1652: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_YOP_NOT_FOUND');
1653: l_message := Fnd_Message.Get;
1654:
1655: -- Initialize Record to Null.
1656: g_he_ext_run_except := NULL;

Line 1653: l_message := Fnd_Message.Get;

1649: -- If Year of Program details were not found, then log error
1650: l_valid := FALSE;
1651:
1652: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_YOP_NOT_FOUND');
1653: l_message := Fnd_Message.Get;
1654:
1655: -- Initialize Record to Null.
1656: g_he_ext_run_except := NULL;
1657:

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

1711: THEN
1712: -- If Course details were not found, then log error
1713: l_valid := FALSE;
1714:
1715: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_CRSE_DTL_NOT_FOUND');
1716: l_message := Fnd_Message.Get;
1717:
1718: -- Initialize Record to Null.
1719: g_he_ext_run_except := NULL;

Line 1716: l_message := Fnd_Message.Get;

1712: -- If Course details were not found, then log error
1713: l_valid := FALSE;
1714:
1715: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_CRSE_DTL_NOT_FOUND');
1716: l_message := Fnd_Message.Get;
1717:
1718: -- Initialize Record to Null.
1719: g_he_ext_run_except := NULL;
1720:

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

1860: THEN
1861: CLOSE c_alternate_id;
1862: END IF;
1863:
1864: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1865: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_students');
1866: IGS_GE_MSG_STACK.ADD;
1867: App_Exception.Raise_Exception;
1868:

Line 1865: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_students');

1861: CLOSE c_alternate_id;
1862: END IF;
1863:
1864: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1865: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_students');
1866: IGS_GE_MSG_STACK.ADD;
1867: App_Exception.Raise_Exception;
1868:
1869: END get_students;

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

1906: l_dot_position NUMBER;
1907:
1908: BEGIN
1909: -- printing datetimestamp for monitoring performance
1910: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:

Line 1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');

1907:
1908: BEGIN
1909: -- printing datetimestamp for monitoring performance
1910: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');

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

1908: BEGIN
1909: -- printing datetimestamp for monitoring performance
1910: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());

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

1909: -- printing datetimestamp for monitoring performance
1910: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());
1917:

Line 1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');

1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());
1917:
1918: FOR l_mod IN c_get_mod (g_he_ext_run_dtls.student_ext_run_id)
1919: LOOP

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

1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());
1917:
1918: FOR l_mod IN c_get_mod (g_he_ext_run_dtls.student_ext_run_id)
1919: LOOP
1920: g_records_found := TRUE;

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

1964: EXCEPTION
1965: WHEN OTHERS
1966: THEN
1967: write_to_log(SQLERRM);
1968: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1969: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_modules');
1970: IGS_GE_MSG_STACK.ADD;
1971: App_Exception.Raise_Exception;
1972:

Line 1969: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_modules');

1965: WHEN OTHERS
1966: THEN
1967: write_to_log(SQLERRM);
1968: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1969: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_modules');
1970: IGS_GE_MSG_STACK.ADD;
1971: App_Exception.Raise_Exception;
1972:
1973: END get_modules;

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

2069: THEN
2070: CLOSE c_dlhe_prm;
2071: END IF;
2072:
2073: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2074: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_dlhe_status');
2075: IGS_GE_MSG_STACK.ADD;
2076: App_Exception.Raise_Exception;
2077: END validate_dlhe_status;

Line 2074: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_dlhe_status');

2070: CLOSE c_dlhe_prm;
2071: END IF;
2072:
2073: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2074: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.validate_dlhe_status');
2075: IGS_GE_MSG_STACK.ADD;
2076: App_Exception.Raise_Exception;
2077: END validate_dlhe_status;
2078:

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

2113: l_ext_interim_id NUMBER;
2114:
2115: BEGIN
2116: -- printing datetimestamp for monitoring performance
2117: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:

Line 2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');

2114:
2115: BEGIN
2116: -- printing datetimestamp for monitoring performance
2117: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');

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

2115: BEGIN
2116: -- printing datetimestamp for monitoring performance
2117: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());

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

2116: -- printing datetimestamp for monitoring performance
2117: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());
2124:

Line 2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');

2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());
2124:
2125: -- loop thru each dlhe record and validate dlhe_record_status
2126: FOR g_he_stdnt_dlhe IN c_get_dlhe ( g_he_ext_run_dtls.submission_name, g_he_ext_run_dtls.return_name,

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

2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());
2124:
2125: -- loop thru each dlhe record and validate dlhe_record_status
2126: FOR g_he_stdnt_dlhe IN c_get_dlhe ( g_he_ext_run_dtls.submission_name, g_he_ext_run_dtls.return_name,
2127: g_he_ext_run_dtls.user_return_subclass )

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

2157: EXCEPTION
2158: WHEN OTHERS
2159: THEN
2160: write_to_log(SQLERRM);
2161: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2162: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_dlhe');
2163: IGS_GE_MSG_STACK.ADD;
2164: App_Exception.Raise_Exception;
2165:

Line 2162: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_dlhe');

2158: WHEN OTHERS
2159: THEN
2160: write_to_log(SQLERRM);
2161: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2162: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_dlhe');
2163: IGS_GE_MSG_STACK.ADD;
2164: App_Exception.Raise_Exception;
2165:
2166: END get_dlhe;

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

2220: l_temp VARCHAR2(3);
2221:
2222: BEGIN
2223: -- printing datetimestamp for monitoring performance
2224: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:

Line 2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');

2221:
2222: BEGIN
2223: -- printing datetimestamp for monitoring performance
2224: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');

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

2222: BEGIN
2223: -- printing datetimestamp for monitoring performance
2224: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());

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

2223: -- printing datetimestamp for monitoring performance
2224: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:

Line 2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');

2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:
2232:
2233: -- Delete from igs_he_ext_run_interim, if rows exist

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

2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:
2232:
2233: -- Delete from igs_he_ext_run_interim, if rows exist
2234: -- Replaced the procedure call which calls the TBH for deletion with direct DML for bug,3179585

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

2309: EXCEPTION
2310: WHEN OTHERS
2311: THEN
2312: write_to_log(SQLERRM);
2313: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2314: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_marked_rows');
2315: IGS_GE_MSG_STACK.ADD;
2316: App_Exception.Raise_Exception;
2317:

Line 2314: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_marked_rows');

2310: WHEN OTHERS
2311: THEN
2312: write_to_log(SQLERRM);
2313: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2314: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_PKG.get_marked_rows');
2315: IGS_GE_MSG_STACK.ADD;
2316: App_Exception.Raise_Exception;
2317:
2318: END get_marked_rows;

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

2409: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
2410: IGS_GE_GEN_003.SET_ORG_ID;
2411:
2412: -- printing datetimestamp for monitoring performance
2413: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');
2415: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2416: fnd_file.put_line(fnd_file.log, fnd_message.get);
2417:

Line 2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');

2410: IGS_GE_GEN_003.SET_ORG_ID;
2411:
2412: -- printing datetimestamp for monitoring performance
2413: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');
2415: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2416: fnd_file.put_line(fnd_file.log, fnd_message.get);
2417:
2418: -- Check if UCAS and HESA are enabled, ie country = UK

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

2411:
2412: -- printing datetimestamp for monitoring performance
2413: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');
2415: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2416: fnd_file.put_line(fnd_file.log, fnd_message.get);
2417:
2418: -- Check if UCAS and HESA are enabled, ie country = UK
2419: IF NOT Igs_Uc_Utils.is_ucas_hesa_enabled

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

2412: -- printing datetimestamp for monitoring performance
2413: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');
2415: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2416: fnd_file.put_line(fnd_file.log, fnd_message.get);
2417:
2418: -- Check if UCAS and HESA are enabled, ie country = UK
2419: IF NOT Igs_Uc_Utils.is_ucas_hesa_enabled
2420: THEN

Line 2462: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DTL_NOT_FOUND');

2458: IF c_ext_dtl%NOTFOUND
2459: THEN
2460: CLOSE c_ext_dtl;
2461: l_message := NULL ;
2462: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DTL_NOT_FOUND');
2463: l_message := Fnd_Message.Get;
2464:
2465: -- Initialize Record to Null.
2466: g_he_ext_run_except := NULL;

Line 2463: l_message := Fnd_Message.Get;

2459: THEN
2460: CLOSE c_ext_dtl;
2461: l_message := NULL ;
2462: Fnd_Message.Set_Name('IGS', 'IGS_HE_EXT_DTL_NOT_FOUND');
2463: l_message := Fnd_Message.Get;
2464:
2465: -- Initialize Record to Null.
2466: g_he_ext_run_except := NULL;
2467:

Line 2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');

2477:
2478: CLOSE c_ext_dtl;
2479:
2480:
2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);

Line 2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);

2478: CLOSE c_ext_dtl;
2479:
2480:
2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);

Line 2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);

2479:
2480:
2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);

2480:
2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());
2488:

Line 2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);

2481: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());
2488:
2489:

Line 2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);

2482: fnd_message.set_token('submission_name',g_he_ext_run_dtls.submission_name);
2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());
2488:
2489:
2490: IF p_module_called_from = 'IGSHE008'

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

2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());
2488:
2489:
2490: IF p_module_called_from = 'IGSHE008'
2491: THEN

Line 2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');

2513: -- Do a fresh run.
2514: -- Therefore, delete all data that was created previously
2515: -- for the same run.
2516: -- Delete from igs_he_ext_run_interim
2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');

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

2514: -- Therefore, delete all data that was created previously
2515: -- for the same run.
2516: -- Delete from igs_he_ext_run_interim
2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

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

2516: -- Delete from igs_he_ext_run_interim
2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2523: fnd_file.put_line(fnd_file.log, fnd_message.get);
2524:

Line 2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');

2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2523: fnd_file.put_line(fnd_file.log, fnd_message.get);
2524:
2525: -- Changed the logic to replace the call to procedure, delete_rows with the

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

2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2523: fnd_file.put_line(fnd_file.log, fnd_message.get);
2524:
2525: -- Changed the logic to replace the call to procedure, delete_rows with the
2526: -- Direct DMLs to improve performance for bug,3179585

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

2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2523: fnd_file.put_line(fnd_file.log, fnd_message.get);
2524:
2525: -- Changed the logic to replace the call to procedure, delete_rows with the
2526: -- Direct DMLs to improve performance for bug,3179585
2527:

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

2536:
2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2543: fnd_file.put_line(fnd_file.log, fnd_message.get);
2544:

Line 2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');

2537: -- Delete from igs_he_ext_run_excp
2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2543: fnd_file.put_line(fnd_file.log, fnd_message.get);
2544:
2545: IF Substr(g_he_submsn_return.record_id,4,2) = '11'

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

2538: DELETE FROM igs_he_ext_run_excp WHERE extract_run_id = p_extract_run_id;
2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2543: fnd_file.put_line(fnd_file.log, fnd_message.get);
2544:
2545: IF Substr(g_he_submsn_return.record_id,4,2) = '11'
2546: OR Substr(g_he_submsn_return.record_id,4,2) = '12'

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

2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2543: fnd_file.put_line(fnd_file.log, fnd_message.get);
2544:
2545: IF Substr(g_he_submsn_return.record_id,4,2) = '11'
2546: OR Substr(g_he_submsn_return.record_id,4,2) = '12'
2547: THEN

Line 2576: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_INV_MOD');

2572: END IF; -- check new_run_flag
2573:
2574: ELSE
2575: -- Unknown p_module_called_from
2576: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_INV_MOD');
2577: IGS_GE_MSG_STACK.ADD;
2578:
2579: l_message := Fnd_message.Get_string('IGS','IGS_HE_EXT_INV_MOD');
2580: write_to_log (l_message);

Line 2579: l_message := Fnd_message.Get_string('IGS','IGS_HE_EXT_INV_MOD');

2575: -- Unknown p_module_called_from
2576: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_INV_MOD');
2577: IGS_GE_MSG_STACK.ADD;
2578:
2579: l_message := Fnd_message.Get_string('IGS','IGS_HE_EXT_INV_MOD');
2580: write_to_log (l_message);
2581:
2582: App_Exception.Raise_Exception;
2583: END IF; -- Module called from check

Line 2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');

2586: COMMIT;
2587:
2588: IF g_records_found
2589: THEN
2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2587:
2588: IF g_records_found
2589: THEN
2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());
2595:

Line 2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');

2589: THEN
2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());
2595:
2596: -- If records were found that need processing,
2597: -- call the next procedure to process these

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

2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());
2595:
2596: -- If records were found that need processing,
2597: -- call the next procedure to process these
2598: -- Transaction handling is done within this procedure

Line 2607: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_SPA_NOT_FOUND');

2603: ELSE
2604: IF Substr(g_he_submsn_return.record_id,4,2) = '11'
2605: OR Substr(g_he_submsn_return.record_id,4,2) = '12'
2606: THEN
2607: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_SPA_NOT_FOUND');
2608: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '13' THEN
2609: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_MOD_NOT_FOUND');
2610: Fnd_Message.Set_Token('ST_RUN_ID',g_he_ext_run_dtls.student_ext_run_id,
2611: TRUE);

Line 2609: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_MOD_NOT_FOUND');

2605: OR Substr(g_he_submsn_return.record_id,4,2) = '12'
2606: THEN
2607: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_SPA_NOT_FOUND');
2608: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '13' THEN
2609: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_MOD_NOT_FOUND');
2610: Fnd_Message.Set_Token('ST_RUN_ID',g_he_ext_run_dtls.student_ext_run_id,
2611: TRUE);
2612: -- smaddali added processing for DLHE return as part of HEFD203 build , bug#2717745
2613: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '18' THEN

Line 2610: Fnd_Message.Set_Token('ST_RUN_ID',g_he_ext_run_dtls.student_ext_run_id,

2606: THEN
2607: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_SPA_NOT_FOUND');
2608: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '13' THEN
2609: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_MOD_NOT_FOUND');
2610: Fnd_Message.Set_Token('ST_RUN_ID',g_he_ext_run_dtls.student_ext_run_id,
2611: TRUE);
2612: -- smaddali added processing for DLHE return as part of HEFD203 build , bug#2717745
2613: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '18' THEN
2614: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_DLHE_NOT_FOUND');

Line 2614: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_DLHE_NOT_FOUND');

2610: Fnd_Message.Set_Token('ST_RUN_ID',g_he_ext_run_dtls.student_ext_run_id,
2611: TRUE);
2612: -- smaddali added processing for DLHE return as part of HEFD203 build , bug#2717745
2613: ELSIF Substr(g_he_submsn_return.record_id,4,2) = '18' THEN
2614: Fnd_Message.Set_Name('IGS','IGS_HE_EXT_DLHE_NOT_FOUND');
2615: END IF;
2616:
2617: IGS_GE_MSG_STACK.ADD;
2618:

Line 2619: l_message := Fnd_message.Get;

2615: END IF;
2616:
2617: IGS_GE_MSG_STACK.ADD;
2618:
2619: l_message := Fnd_message.Get;
2620: write_to_log (l_message);
2621:
2622: END IF; -- records found check
2623:

Line 2647: fnd_message.set_name('IGS','IGS_HE_PROC_COMP');

2643:
2644: -- Commit Transaction
2645: COMMIT;
2646:
2647: fnd_message.set_name('IGS','IGS_HE_PROC_COMP');
2648: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2649:
2650: -- Submit the Extract Run Exception report.
2651: l_request_id := NULL ;

Line 2648: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2644: -- Commit Transaction
2645: COMMIT;
2646:
2647: fnd_message.set_name('IGS','IGS_HE_PROC_COMP');
2648: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2649:
2650: -- Submit the Extract Run Exception report.
2651: l_request_id := NULL ;
2652: l_request_id := Fnd_Request.Submit_Request

Line 2662: fnd_message.set_name('IGS','IGS_HE_REP_SUBM');

2658: p_extract_run_id,
2659: 'LINE');
2660:
2661:
2662: fnd_message.set_name('IGS','IGS_HE_REP_SUBM');
2663: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2664:
2665: EXCEPTION
2666: WHEN IGS_HESA_NOT_ENABLED_EXCEP

Line 2663: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2659: 'LINE');
2660:
2661:
2662: fnd_message.set_name('IGS','IGS_HE_REP_SUBM');
2663: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2664:
2665: EXCEPTION
2666: WHEN IGS_HESA_NOT_ENABLED_EXCEP
2667: THEN

Line 2668: Errbuf := Fnd_message.Get_string('IGS','IGS_UC_HE_NOT_ENABLED');

2664:
2665: EXCEPTION
2666: WHEN IGS_HESA_NOT_ENABLED_EXCEP
2667: THEN
2668: Errbuf := Fnd_message.Get_string('IGS','IGS_UC_HE_NOT_ENABLED');
2669: retcode := 2;
2670: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2671:
2672: WHEN OTHERS