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_MSG_PUB

Line 1689: fnd_msg_pub.ADD;

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,
1693: fnd_message.get_string ('IGS', 'IGS_EN_PER_NUM_NULL')

Line 1702: fnd_msg_pub.ADD;

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,
1706: fnd_message.get_string ('IGS', 'IGS_EN_PRGM_CD_NULL')

Line 1715: fnd_msg_pub.ADD;

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,
1719: fnd_message.get_string ('IGS', 'IGS_AV_UNIT_CD_NULL')

Line 1728: fnd_msg_pub.ADD;

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,
1732: fnd_message.get_string ('IGS',

Line 1802: fnd_msg_pub.ADD;

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:
1806: IF p_load_cal_alt_code IS NULL

Line 1809: fnd_msg_pub.ADD;

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,
1813: fnd_message.get_string ('IGS',

Line 1842: fnd_msg_pub.ADD;

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,
1846: fnd_message.get_string ('IGS',

Line 1919: fnd_msg_pub.ADD;

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,
1923: p_program_cd,

Line 1992: fnd_msg_pub.ADD;

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,
1996: p_program_cd,

Line 2033: fnd_msg_pub.ADD;

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,
2037: p_program_cd,

Line 2061: fnd_msg_pub.ADD;

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,
2065: p_program_cd,

Line 2151: fnd_msg_pub.ADD;

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,
2155: p_program_cd,

Line 2228: fnd_msg_pub.ADD;

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: );
2232: notify_error (p_batch_id,

Line 2247: fnd_msg_pub.ADD;

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,
2251: p_person_id,

Line 2271: fnd_msg_pub.ADD;

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: );
2275: notify_error (p_batch_id,

Line 2288: fnd_msg_pub.ADD;

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,
2292: p_person_id,

Line 2376: fnd_msg_pub.ADD;

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,
2380: p_person_id,

Line 2394: fnd_msg_pub.ADD;

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,
2398: p_person_id,

Line 2413: fnd_msg_pub.ADD;

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 ');
2417: notify_error (p_batch_id,

Line 2429: fnd_msg_pub.ADD;

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 ');
2433: notify_error (p_batch_id,

Line 2472: fnd_msg_pub.ADD;

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,
2476: p_person_id,

Line 2570: fnd_msg_pub.ADD;

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,
2574: p_program_cd,

Line 2839: fnd_msg_pub.initialize;

2835:
2836: write_message ('ENTERED create_adv_stnd_unit ');
2837: --Standard start of API savepoint
2838: SAVEPOINT create_adv_stnd_unit;
2839: fnd_msg_pub.initialize;
2840: --Initialize API return status to success.
2841: l_return_status := fnd_api.g_ret_sts_success;
2842: l_unit_cd := UPPER (l_unit_cd);
2843: l_prev_institution_code := UPPER (l_prev_institution_code);

Line 3236: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3232: write_message ('************************ END ADVSTND ********************'
3233: );
3234: ecx_debug.pop ('IGS_DA_TRNS_IMP.CREATE_ADV_STND_UNIT');
3235: --Standard call to get message count and if count is 1, get message info.
3236: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3237: p_data => l_msg_data);
3238: EXCEPTION
3239: WHEN duplicate_record_exists
3240: THEN

Line 3251: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3247:
3248: write_message('ERROR ' || sqlerrm);
3249: -- ROLLBACK TO create_adv_stnd_unit;
3250: l_return_status := 'W';
3251: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3252: p_data => l_msg_data
3253: );
3254: WHEN fnd_api.g_exc_error
3255: THEN

Line 3263: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3259: p_program_cd,
3260: 'Error has occurred.See log for Details'
3261: );
3262: l_return_status := fnd_api.g_ret_sts_error;
3263: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3264: p_data => l_msg_data
3265: );
3266: WHEN fnd_api.g_exc_unexpected_error
3267: THEN

Line 3275: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3271: l_person_id,
3272: p_program_cd,
3273: 'Error has occurred.See log for Details'
3274: );
3275: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3276: p_data => l_msg_data
3277: );
3278: WHEN OTHERS
3279: THEN

Line 3290: fnd_msg_pub.ADD;

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,
3294: 'Error has occurred.See log for Details'

Line 3298: fnd_msg_pub.count_and_get (p_count => l_msg_count,

3294: 'Error has occurred.See log for Details'
3295: );
3296:
3297: write_message('ERROR ' || sqlerrm);
3298: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3299: p_data => l_msg_data
3300: );
3301: END create_adv_stnd_unit;
3302: