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

Line 314: l_debug_str := fnd_message.get;

310: THEN
311: write_log (l_msg_data,
312: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
313: );
314: l_debug_str := fnd_message.get;
315: write_log (l_msg_data,
316: 'igs.plsql.igs_da_trns_imp.crc_pe_acad_hist'
317: );
318: END IF;

Line 669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

665: l_error_code := 'E518';
666: l_label :=
667: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details.exception '
668: || l_msg_data;
669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');
672: l_debug_str := fnd_message.get;
673: write_log (l_debug_str,

Line 670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');

666: l_label :=
667: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details.exception '
668: || l_msg_data;
669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');
672: l_debug_str := fnd_message.get;
673: write_log (l_debug_str,
674: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'

Line 671: fnd_message.set_token ('ERROR_CD', 'E322');

667: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details.exception '
668: || l_msg_data;
669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');
672: l_debug_str := fnd_message.get;
673: write_log (l_debug_str,
674: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
675: );

Line 672: l_debug_str := fnd_message.get;

668: || l_msg_data;
669: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
670: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
671: fnd_message.set_token ('ERROR_CD', 'E322');
672: l_debug_str := fnd_message.get;
673: write_log (l_debug_str,
674: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
675: );
676: END IF;

Line 794: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

790: 'E518',
791: 8405
792: );
793: l_error_code := 'E518';
794: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
796: fnd_message.set_token ('ERROR_CD', 'E014');
797: l_debug_str := fnd_message.get;
798: write_log (l_debug_str,

Line 795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');

791: 8405
792: );
793: l_error_code := 'E518';
794: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
796: fnd_message.set_token ('ERROR_CD', 'E014');
797: l_debug_str := fnd_message.get;
798: write_log (l_debug_str,
799: 'igs.plsql.igs_da_trns_imp.update_transcript_details'

Line 796: fnd_message.set_token ('ERROR_CD', 'E014');

792: );
793: l_error_code := 'E518';
794: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
796: fnd_message.set_token ('ERROR_CD', 'E014');
797: l_debug_str := fnd_message.get;
798: write_log (l_debug_str,
799: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
800: );

Line 797: l_debug_str := fnd_message.get;

793: l_error_code := 'E518';
794: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
795: fnd_message.set_token ('INTERFACE_ID', 'Some Value');
796: fnd_message.set_token ('ERROR_CD', 'E014');
797: l_debug_str := fnd_message.get;
798: write_log (l_debug_str,
799: 'igs.plsql.igs_da_trns_imp.update_transcript_details'
800: );
801: END IF;

Line 888: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

884: 'E518',
885: 8405
886: );
887: l_error_code := 'E518';
888: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
889: fnd_message.set_token ('INTERFACE_ID',
890: p_term_unitdtls_record.unit_details_id
891: );
892: fnd_message.set_token ('ERROR_CD', 'E014');

Line 889: fnd_message.set_token ('INTERFACE_ID',

885: 8405
886: );
887: l_error_code := 'E518';
888: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
889: fnd_message.set_token ('INTERFACE_ID',
890: p_term_unitdtls_record.unit_details_id
891: );
892: fnd_message.set_token ('ERROR_CD', 'E014');
893: l_debug_str := fnd_message.get;

Line 892: fnd_message.set_token ('ERROR_CD', 'E014');

888: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
889: fnd_message.set_token ('INTERFACE_ID',
890: p_term_unitdtls_record.unit_details_id
891: );
892: fnd_message.set_token ('ERROR_CD', 'E014');
893: l_debug_str := fnd_message.get;
894: write_log (l_debug_str,
895: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
896: );

Line 893: l_debug_str := fnd_message.get;

889: fnd_message.set_token ('INTERFACE_ID',
890: p_term_unitdtls_record.unit_details_id
891: );
892: fnd_message.set_token ('ERROR_CD', 'E014');
893: l_debug_str := fnd_message.get;
894: write_log (l_debug_str,
895: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
896: );
897: END IF;

Line 991: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

987: l_error_code := 'E518';
988: l_label :=
989: 'igs.plsql.igs_da_trns_imp.create_term_unit_details.exception '
990: || l_msg_data;
991: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
992: fnd_message.set_token ('INTERFACE_ID',
993: p_term_unitdtls_record.term_details_id
994: );
995: fnd_message.set_token ('ERROR_CD', 'E322');

Line 992: fnd_message.set_token ('INTERFACE_ID',

988: l_label :=
989: 'igs.plsql.igs_da_trns_imp.create_term_unit_details.exception '
990: || l_msg_data;
991: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
992: fnd_message.set_token ('INTERFACE_ID',
993: p_term_unitdtls_record.term_details_id
994: );
995: fnd_message.set_token ('ERROR_CD', 'E322');
996: l_debug_str := fnd_message.get;

Line 995: fnd_message.set_token ('ERROR_CD', 'E322');

991: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
992: fnd_message.set_token ('INTERFACE_ID',
993: p_term_unitdtls_record.term_details_id
994: );
995: fnd_message.set_token ('ERROR_CD', 'E322');
996: l_debug_str := fnd_message.get;
997: write_log (l_debug_str,
998: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
999: );

Line 996: l_debug_str := fnd_message.get;

992: fnd_message.set_token ('INTERFACE_ID',
993: p_term_unitdtls_record.term_details_id
994: );
995: fnd_message.set_token ('ERROR_CD', 'E322');
996: l_debug_str := fnd_message.get;
997: write_log (l_debug_str,
998: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
999: );
1000: END IF;

Line 1059: fnd_message.get_string ('IGS',

1055: );
1056: notify_error (p_batch_id,
1057: p_person_id,
1058: p_program_cd,
1059: fnd_message.get_string ('IGS',
1060: 'IGS_DA_SRC_UNT_NOT_EXIST'
1061: )
1062: );
1063: END IF;

Line 1155: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

1151: l_error_code := 'E518';
1152: l_label :=
1153: 'igs.plsql.igs_da_trns_imp.create_term_details.exception '
1154: || l_msg_data;
1155: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1156: fnd_message.set_token ('INTERFACE_ID',
1157: p_term_dtls_record.term_details_id
1158: );
1159: fnd_message.set_token ('ERROR_CD', 'E322');

Line 1156: fnd_message.set_token ('INTERFACE_ID',

1152: l_label :=
1153: 'igs.plsql.igs_da_trns_imp.create_term_details.exception '
1154: || l_msg_data;
1155: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1156: fnd_message.set_token ('INTERFACE_ID',
1157: p_term_dtls_record.term_details_id
1158: );
1159: fnd_message.set_token ('ERROR_CD', 'E322');
1160: l_debug_str := fnd_message.get;

Line 1159: fnd_message.set_token ('ERROR_CD', 'E322');

1155: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1156: fnd_message.set_token ('INTERFACE_ID',
1157: p_term_dtls_record.term_details_id
1158: );
1159: fnd_message.set_token ('ERROR_CD', 'E322');
1160: l_debug_str := fnd_message.get;
1161: write_log (l_debug_str,
1162: 'igs.plsql.igs_da_trns_imp.create_term_details'
1163: );

Line 1160: l_debug_str := fnd_message.get;

1156: fnd_message.set_token ('INTERFACE_ID',
1157: p_term_dtls_record.term_details_id
1158: );
1159: fnd_message.set_token ('ERROR_CD', 'E322');
1160: l_debug_str := fnd_message.get;
1161: write_log (l_debug_str,
1162: 'igs.plsql.igs_da_trns_imp.create_term_details'
1163: );
1164: END IF;

Line 1263: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');

1259: THEN
1260: l_label :=
1261: 'igs.plsql.igs_ad_imp_024.update_term_details.exception '
1262: || l_msg_data;
1263: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1264: fnd_message.set_token ('INTERFACE_ID',
1265: p_term_dtls_record.term_details_id
1266: );
1267: fnd_message.set_token ('ERROR_CD', 'E014');

Line 1264: fnd_message.set_token ('INTERFACE_ID',

1260: l_label :=
1261: 'igs.plsql.igs_ad_imp_024.update_term_details.exception '
1262: || l_msg_data;
1263: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1264: fnd_message.set_token ('INTERFACE_ID',
1265: p_term_dtls_record.term_details_id
1266: );
1267: fnd_message.set_token ('ERROR_CD', 'E014');
1268: l_debug_str := fnd_message.get;

Line 1267: fnd_message.set_token ('ERROR_CD', 'E014');

1263: fnd_message.set_name ('IGS', 'IGS_PE_IMP_ERROR');
1264: fnd_message.set_token ('INTERFACE_ID',
1265: p_term_dtls_record.term_details_id
1266: );
1267: fnd_message.set_token ('ERROR_CD', 'E014');
1268: l_debug_str := fnd_message.get;
1269: write_log (l_debug_str,
1270: 'igs.plsql.igs_da_trns_imp.update_term_details'
1271: );

Line 1268: l_debug_str := fnd_message.get;

1264: fnd_message.set_token ('INTERFACE_ID',
1265: p_term_dtls_record.term_details_id
1266: );
1267: fnd_message.set_token ('ERROR_CD', 'E014');
1268: l_debug_str := fnd_message.get;
1269: write_log (l_debug_str,
1270: 'igs.plsql.igs_da_trns_imp.update_term_details'
1271: );
1272: END IF;

Line 1688: fnd_message.set_name ('IGS', l_s_message_name);

1684: IF p_person_number IS NULL
1685: THEN
1686: l_s_message_name := 'IGS_EN_PER_NUM_NULL';
1687: l_b_return_val := FALSE;
1688: fnd_message.set_name ('IGS', l_s_message_name);
1689: fnd_msg_pub.ADD;
1690: notify_error (p_batch_id,
1691: p_person_id,
1692: p_program_cd,

Line 1693: fnd_message.get_string ('IGS', 'IGS_EN_PER_NUM_NULL')

1689: fnd_msg_pub.ADD;
1690: notify_error (p_batch_id,
1691: p_person_id,
1692: p_program_cd,
1693: fnd_message.get_string ('IGS', 'IGS_EN_PER_NUM_NULL')
1694: );
1695: END IF;
1696:
1697: IF p_program_cd IS NULL

Line 1701: fnd_message.set_name ('IGS', l_s_message_name);

1697: IF p_program_cd IS NULL
1698: THEN
1699: l_s_message_name := 'IGS_EN_PRGM_CD_NULL';
1700: l_b_return_val := FALSE;
1701: fnd_message.set_name ('IGS', l_s_message_name);
1702: fnd_msg_pub.ADD;
1703: notify_error (p_batch_id,
1704: p_person_id,
1705: p_program_cd,

Line 1706: fnd_message.get_string ('IGS', 'IGS_EN_PRGM_CD_NULL')

1702: fnd_msg_pub.ADD;
1703: notify_error (p_batch_id,
1704: p_person_id,
1705: p_program_cd,
1706: fnd_message.get_string ('IGS', 'IGS_EN_PRGM_CD_NULL')
1707: );
1708: END IF;
1709:
1710: IF p_unit_cd IS NULL

Line 1714: fnd_message.set_name ('IGS', l_s_message_name);

1710: IF p_unit_cd IS NULL
1711: THEN
1712: l_s_message_name := 'IGS_AV_UNIT_CD_NULL';
1713: l_b_return_val := FALSE;
1714: fnd_message.set_name ('IGS', l_s_message_name);
1715: fnd_msg_pub.ADD;
1716: notify_error (p_batch_id,
1717: p_person_id,
1718: p_program_cd,

Line 1719: fnd_message.get_string ('IGS', 'IGS_AV_UNIT_CD_NULL')

1715: fnd_msg_pub.ADD;
1716: notify_error (p_batch_id,
1717: p_person_id,
1718: p_program_cd,
1719: fnd_message.get_string ('IGS', 'IGS_AV_UNIT_CD_NULL')
1720: );
1721: END IF;
1722:
1723: IF p_version_number IS NULL

Line 1727: fnd_message.set_name ('IGS', l_s_message_name);

1723: IF p_version_number IS NULL
1724: THEN
1725: l_s_message_name := 'IGS_AV_UNIT_VER_NULL';
1726: l_b_return_val := FALSE;
1727: fnd_message.set_name ('IGS', l_s_message_name);
1728: fnd_msg_pub.ADD;
1729: notify_error (p_batch_id,
1730: p_person_id,
1731: p_program_cd,

Line 1732: fnd_message.get_string ('IGS',

1728: fnd_msg_pub.ADD;
1729: notify_error (p_batch_id,
1730: p_person_id,
1731: p_program_cd,
1732: fnd_message.get_string ('IGS',
1733: 'IGS_DA_TGT_UNT_NOT_EXIST'
1734: )
1735: );
1736: END IF;

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

1797: write_message ('Got person ID as ' || p_person_id);
1798:
1799: IF p_person_id IS NULL
1800: THEN
1801: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
1802: fnd_msg_pub.ADD;
1803: RETURN FALSE;
1804: END IF;
1805:

Line 1808: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');

1804: END IF;
1805:
1806: IF p_load_cal_alt_code IS NULL
1807: THEN
1808: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
1809: fnd_msg_pub.ADD;
1810: notify_error (p_batch_id,
1811: p_person_id,
1812: p_program_cd,

Line 1813: fnd_message.get_string ('IGS',

1809: fnd_msg_pub.ADD;
1810: notify_error (p_batch_id,
1811: p_person_id,
1812: p_program_cd,
1813: fnd_message.get_string ('IGS',
1814: 'IGS_AV_INVALID_CAL_ALT_CODE'
1815: )
1816: );
1817: RETURN FALSE;

Line 1841: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');

1837:
1838: -- IF 0 or more load calendars are found
1839: IF p_seq_number IS NULL OR p_cal_type IS NULL
1840: THEN
1841: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
1842: fnd_msg_pub.ADD;
1843: notify_error (p_batch_id,
1844: p_person_id,
1845: p_program_cd,

Line 1846: fnd_message.get_string ('IGS',

1842: fnd_msg_pub.ADD;
1843: notify_error (p_batch_id,
1844: p_person_id,
1845: p_program_cd,
1846: fnd_message.get_string ('IGS',
1847: 'IGS_AV_INVALID_CAL_ALT_CODE'
1848: )
1849: );
1850: RETURN FALSE;

Line 1918: fnd_message.set_name ('IGS', 'IGS_AV_PRG_CD_NOT_EXISTS');

1914: IF NOT igs_ps_ver_pkg.get_pk_for_validation (x_course_cd => p_program_cd,
1915: x_version_number => p_version_number
1916: )
1917: THEN
1918: fnd_message.set_name ('IGS', 'IGS_AV_PRG_CD_NOT_EXISTS');
1919: fnd_msg_pub.ADD;
1920: x_return_status := FALSE;
1921: notify_error (p_batch_id,
1922: p_person_id,

Line 1924: fnd_message.get_string ('IGS',

1920: x_return_status := FALSE;
1921: notify_error (p_batch_id,
1922: p_person_id,
1923: p_program_cd,
1924: fnd_message.get_string ('IGS',
1925: 'IGS_AV_PRG_CD_NOT_EXISTS'
1926: )
1927: );
1928: END IF;

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

1987: CLOSE c_ind;
1988:
1989: IF UPPER (l_ind) = 'Y'
1990: THEN
1991: fnd_message.set_name ('IGS', 'IGS_AV_PERSON_DECEASED');
1992: fnd_msg_pub.ADD;
1993: x_return_status := FALSE;
1994: notify_error (p_batch_id,
1995: p_person_id,

Line 1997: fnd_message.get_string ('IGS',

1993: x_return_status := FALSE;
1994: notify_error (p_batch_id,
1995: p_person_id,
1996: p_program_cd,
1997: fnd_message.get_string ('IGS',
1998: 'IGS_AV_PERSON_DECEASED'
1999: )
2000: );
2001: END IF;

Line 2032: fnd_message.set_name ('IGS', 'IGS_AV_STND_EXMPT_INVALID');

2028: FETCH c_validate_inst INTO l_validate_inst;
2029:
2030: IF c_validate_inst%NOTFOUND
2031: THEN
2032: fnd_message.set_name ('IGS', 'IGS_AV_STND_EXMPT_INVALID');
2033: fnd_msg_pub.ADD;
2034: x_return_status := FALSE;
2035: notify_error (p_batch_id,
2036: p_person_id,

Line 2038: fnd_message.get_string ('IGS',

2034: x_return_status := FALSE;
2035: notify_error (p_batch_id,
2036: p_person_id,
2037: p_program_cd,
2038: fnd_message.get_string ('IGS',
2039: 'IGS_AV_STND_EXMPT_INVALID'
2040: )
2041: );
2042: END IF;

Line 2060: fnd_message.set_name ('IGS', 'IGS_HE_EXT_SPA_DTL_NOT_FOUND');

2056: p_version_number => p_version_number,
2057: p_message_name => l_message_name
2058: )
2059: THEN
2060: fnd_message.set_name ('IGS', 'IGS_HE_EXT_SPA_DTL_NOT_FOUND');
2061: fnd_msg_pub.ADD;
2062: x_return_status := FALSE;
2063: notify_error (p_batch_id,
2064: p_person_id,

Line 2066: fnd_message.get_string ('IGS',

2062: x_return_status := FALSE;
2063: notify_error (p_batch_id,
2064: p_person_id,
2065: p_program_cd,
2066: fnd_message.get_string ('IGS',
2067: 'IGS_HE_EXT_SPA_DTL_NOT_FOUND'
2068: )
2069: );
2070: END IF;

Line 2150: fnd_message.set_name ('IGS', 'IGS_AV_PRG_ATTMPT_INVALID');

2146: FETCH c_exists INTO l_exists;
2147:
2148: IF c_exists%NOTFOUND
2149: THEN
2150: fnd_message.set_name ('IGS', 'IGS_AV_PRG_ATTMPT_INVALID');
2151: fnd_msg_pub.ADD;
2152: x_return_status := FALSE;
2153: notify_error (p_batch_id,
2154: p_person_id,

Line 2156: fnd_message.get_string ('IGS',

2152: x_return_status := FALSE;
2153: notify_error (p_batch_id,
2154: p_person_id,
2155: p_program_cd,
2156: fnd_message.get_string ('IGS',
2157: 'IGS_AV_PRG_ATTMPT_INVALID'
2158: )
2159: );
2160: END IF;

Line 2227: fnd_message.set_name ('IGS', 'IGS_AV_NO_ADV_STND_DET_EXIST');

2223: x_version_number => p_as_version_number,
2224: x_exemption_institution_cd => p_prev_institution_code
2225: )
2226: THEN
2227: fnd_message.set_name ('IGS', 'IGS_AV_NO_ADV_STND_DET_EXIST');
2228: fnd_msg_pub.ADD;
2229: x_return_status := FALSE;
2230: write_message ('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION '
2231: );

Line 2235: fnd_message.get_string ('IGS',

2231: );
2232: notify_error (p_batch_id,
2233: p_person_id,
2234: p_program_cd,
2235: fnd_message.get_string ('IGS',
2236: 'IGS_AV_NO_ADV_STND_DET_EXIST'
2237: )
2238: );
2239: END IF;

Line 2246: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_PERS_AUTH_NUM');

2242:
2243: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON
2244: IF p_auth_pers_id IS NULL
2245: THEN
2246: fnd_message.set_name ('IGS', 'IGS_AV_INVALID_PERS_AUTH_NUM');
2247: fnd_msg_pub.ADD;
2248: x_return_status := FALSE;
2249: write_message ('validate_std_unt_db_cons p_auth_pers_id ');
2250: notify_error (p_batch_id,

Line 2253: fnd_message.get_string ('IGS',

2249: write_message ('validate_std_unt_db_cons p_auth_pers_id ');
2250: notify_error (p_batch_id,
2251: p_person_id,
2252: p_program_cd,
2253: fnd_message.get_string ('IGS',
2254: 'IGS_AV_INVALID_PERS_AUTH_NUM'
2255: )
2256: );
2257: END IF;

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

2266: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (x_unit_cd => p_unit_cd,
2267: x_version_number => p_version_number
2268: )
2269: THEN
2270: fnd_message.set_name ('IGS', 'IGS_AV_ADV_STUNT_UNIT_EXISTS');
2271: fnd_msg_pub.ADD;
2272: x_return_status := FALSE;
2273: write_message ('validate_std_unt_db_cons IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION '
2274: );

Line 2278: fnd_message.get_string ('IGS',

2274: );
2275: notify_error (p_batch_id,
2276: p_person_id,
2277: p_program_cd,
2278: fnd_message.get_string ('IGS',
2279: 'IGS_AV_ADV_STUNT_UNIT_EXISTS'
2280: )
2281: );
2282: END IF;

Line 2287: fnd_message.set_name ('IGS', 'IGS_AV_STUT_INST_UID_NOT_NULL');

2283:
2284: -- Check that if institution_cd is NOT NULL and unit_details_id is NULL
2285: IF p_institution_cd IS NOT NULL AND p_unit_details_id IS NULL
2286: THEN
2287: fnd_message.set_name ('IGS', 'IGS_AV_STUT_INST_UID_NOT_NULL');
2288: fnd_msg_pub.ADD;
2289: x_return_status := FALSE;
2290: write_message ('validate_std_unt_db_cons p_prev_institution_code ');
2291: notify_error (p_batch_id,

Line 2294: fnd_message.get_string ('IGS',

2290: write_message ('validate_std_unt_db_cons p_prev_institution_code ');
2291: notify_error (p_batch_id,
2292: p_person_id,
2293: p_program_cd,
2294: fnd_message.get_string ('IGS',
2295: 'IGS_AV_STUT_INST_UID_NOT_NULL'
2296: )
2297: );
2298: END IF;

Line 2375: fnd_message.set_name ('IGS', l_message_name);

2371: p_unit_details_id => p_unit_details_id,
2372: p_tst_rslt_dtls_id => NULL
2373: )
2374: THEN
2375: fnd_message.set_name ('IGS', l_message_name);
2376: fnd_msg_pub.ADD;
2377: x_return_status := FALSE;
2378: write_message ('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_AS_TOTALS ');
2379: notify_error (p_batch_id,

Line 2382: fnd_message.get_string ('IGS', l_message_name)

2378: write_message ('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_AS_TOTALS ');
2379: notify_error (p_batch_id,
2380: p_person_id,
2381: p_program_cd,
2382: fnd_message.get_string ('IGS', l_message_name)
2383: );
2384: END IF;
2385:
2386: -- Check for person hold

Line 2393: fnd_message.set_name ('IGS', l_message_name);

2389: p_effective_dt => SYSDATE,
2390: p_message_name => l_message_name
2391: )
2392: THEN
2393: fnd_message.set_name ('IGS', l_message_name);
2394: fnd_msg_pub.ADD;
2395: x_return_status := FALSE;
2396: write_message ('validate_unit IGS_EN_VAL_ENCMB.ENRP_VAL_EXCLD_PRSN ');
2397: notify_error (p_batch_id,

Line 2400: fnd_message.get_string ('IGS', l_message_name)

2396: write_message ('validate_unit IGS_EN_VAL_ENCMB.ENRP_VAL_EXCLD_PRSN ');
2397: notify_error (p_batch_id,
2398: p_person_id,
2399: p_program_cd,
2400: fnd_message.get_string ('IGS', l_message_name)
2401: );
2402: END IF;
2403:
2404: write_message ( 'igs_ad_val_acai.genp_val_staff_prsn p_auth_pers_id='

Line 2412: fnd_message.set_name ('IGS', 'IGS_GE_NOT_STAFF_MEMBER');

2408: IF NOT igs_ad_val_acai.genp_val_staff_prsn (p_person_id => p_auth_pers_id,
2409: p_message_name => l_message_name
2410: )
2411: THEN
2412: fnd_message.set_name ('IGS', 'IGS_GE_NOT_STAFF_MEMBER');
2413: fnd_msg_pub.ADD;
2414: --todo change this to false if staff validation required
2415: --x_return_status := false;
2416: write_message ('validate_unit IGS_GE_NOT_STAFF_MEMBER ');

Line 2420: fnd_message.get_string ('IGS',

2416: write_message ('validate_unit IGS_GE_NOT_STAFF_MEMBER ');
2417: notify_error (p_batch_id,
2418: p_person_id,
2419: p_program_cd,
2420: fnd_message.get_string ('IGS',
2421: 'IGS_GE_NOT_STAFF_MEMBER'
2422: )
2423: );
2424: END IF;

Line 2428: fnd_message.set_name ('IGS', 'IGS_AV_CRD_PER_CANNOT_BE_NULL');

2424: END IF;
2425:
2426: IF p_achievable_credit_points IS NULL
2427: THEN
2428: fnd_message.set_name ('IGS', 'IGS_AV_CRD_PER_CANNOT_BE_NULL');
2429: fnd_msg_pub.ADD;
2430: x_return_status := FALSE;
2431: write_message ('validate_unit IGS_AV_CRD_PER_CANNOT_BE_NULL ');
2432: write_message ('validate_unit IGS_EN_VAL_ENCMB.ENRP_VAL_EXCLD_PRSN ');

Line 2436: fnd_message.get_string ('IGS',

2432: write_message ('validate_unit IGS_EN_VAL_ENCMB.ENRP_VAL_EXCLD_PRSN ');
2433: notify_error (p_batch_id,
2434: p_person_id,
2435: p_program_cd,
2436: fnd_message.get_string ('IGS',
2437: 'IGS_AV_CRD_PER_CANNOT_BE_NULL'
2438: )
2439: );
2440: END IF;

Line 2471: fnd_message.set_name ('IGS', 'IGS_AV_PRG_ATTMPT_INVALID');

2467: FETCH c_exists INTO l_exists;
2468:
2469: IF c_exists%NOTFOUND
2470: THEN
2471: fnd_message.set_name ('IGS', 'IGS_AV_PRG_ATTMPT_INVALID');
2472: fnd_msg_pub.ADD;
2473: write_message ('validate_unit IGS_AV_PRG_ATTMPT_INVALID ');
2474: x_return_status := FALSE;
2475: notify_error (p_batch_id,

Line 2478: fnd_message.get_string ('IGS',

2474: x_return_status := FALSE;
2475: notify_error (p_batch_id,
2476: p_person_id,
2477: p_program_cd,
2478: fnd_message.get_string ('IGS',
2479: 'IGS_AV_PRG_ATTMPT_INVALID'
2480: )
2481: );
2482: END IF;

Line 2569: fnd_message.set_name ('IGS', l_message);

2565: p_tst_rslt_dtls_id => NULL,
2566: p_asu_exmptn_institution_cd => p_prev_institution_code
2567: )
2568: THEN
2569: fnd_message.set_name ('IGS', l_message);
2570: fnd_msg_pub.ADD;
2571: x_return_status := FALSE;
2572: notify_error (p_batch_id,
2573: p_person_id,

Line 2575: fnd_message.get_string ('IGS', l_message)

2571: x_return_status := FALSE;
2572: notify_error (p_batch_id,
2573: p_person_id,
2574: p_program_cd,
2575: fnd_message.get_string ('IGS', l_message)
2576: );
2577: ELSE -- function returns TRUE
2578: /*
2579: update IGS_AV_ADV_STANDING_ALL with above obtained values for

Line 2772: fnd_message.get_string ('IGS', 'IGS_DA_INST_NOT_EXIST')

2768: );
2769: notify_error (p_batch_id,
2770: l_person_id,
2771: p_program_cd,
2772: fnd_message.get_string ('IGS', 'IGS_DA_INST_NOT_EXIST')
2773: );
2774: RETURN;
2775: END IF;
2776:

Line 3288: fnd_message.set_name ('IGS', 'IGS_AV_UNHANDLED_ERROR');

3284: );
3285: write_message('ERROR ' || sqlerrm);
3286: -- ROLLBACK TO create_adv_stnd_unit;
3287: l_return_status := fnd_api.g_ret_sts_unexp_error;
3288: fnd_message.set_name ('IGS', 'IGS_AV_UNHANDLED_ERROR');
3289: fnd_message.set_token ('ERROR', SQLERRM);
3290: fnd_msg_pub.ADD;
3291: notify_error (p_batch_id,
3292: l_person_id,

Line 3289: fnd_message.set_token ('ERROR', SQLERRM);

3285: write_message('ERROR ' || sqlerrm);
3286: -- ROLLBACK TO create_adv_stnd_unit;
3287: l_return_status := fnd_api.g_ret_sts_unexp_error;
3288: fnd_message.set_name ('IGS', 'IGS_AV_UNHANDLED_ERROR');
3289: fnd_message.set_token ('ERROR', SQLERRM);
3290: fnd_msg_pub.ADD;
3291: notify_error (p_batch_id,
3292: l_person_id,
3293: p_program_cd,

Line 3378: fnd_message.get_string ('IGS', 'IGS_DA_STU_NOT_EXIST')

3374: );
3375: notify_error (p_batch_id,
3376: l_person_id,
3377: p_program_code,
3378: fnd_message.get_string ('IGS', 'IGS_DA_STU_NOT_EXIST')
3379: );
3380: RETURN;
3381: END IF;
3382: