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_EN_TRANSFER_APIS dependencies on IGS_EN_STDNT_PS_ATT_PKG

Line 233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

229: p_course_rqrmnt_complete_ind => l_stdnt_ps_attempt_dtls_rec.COURSE_RQRMNT_COMPLETE_IND,
230: p_logical_delete_dt => l_stdnt_ps_attempt_dtls_rec.logical_delete_dt );
231: igs_en_spa_terms_api.set_spa_term_cal_type(P_TERM_CAL_TYPE);
232: igs_en_spa_terms_api.set_spa_term_sequence_number (p_term_seq_num);
233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
234: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
235: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
236: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
237: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,

Line 330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

326:
327: EXCEPTION
328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;

Line 331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

327: EXCEPTION
328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN

Line 336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;

Line 342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

339:
340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');

Line 2824: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

2820: -- this procedure will automatically make the source secondary and make some other program in that career primary
2821: OPEN c_get_discont_reason;
2822: FETCH c_get_discont_reason INTO l_discont_reason_code;
2823: CLOSE c_get_discont_reason;
2824: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
2825: -- discontinue the source program attempt on the same date as the program ransfer record was created
2826: l_status := IGS_EN_GEN_012.ENRP_UPD_SCA_DISCONT (
2827: p_person_id,
2828: p_source_program_cd,

Line 2887: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

2883: l_course_type ,
2884: p_dest_program_cd);
2885: END IF;
2886:
2887: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
2888: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
2889: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
2890: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
2891: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,

Line 2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2966: END IF;-- end of p_discontinue_source = 'Y' AND p_dest_fut_dt_trans_flag = 'N' IF THEN
2967:
2968: EXCEPTION
2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2971: RAISE;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;

Line 2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2971: RAISE;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;
2975: WHEN OTHERS THEN
2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;
2975: WHEN OTHERS THEN
2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2978: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_source_prgm');
2979: IGS_GE_MSG_STACK.ADD;
2980: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

Line 3362: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;

3358:
3359: -- Updating destination program attempt during transfer.
3360: -- in this case the setting global variable to skip auto calculations of primary/secondary
3361: -- since the rank calculations need not be done. The destination will always be primary.
3362: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;
3363: update_destination_prgm(p_person_id,
3364: p_source_program_cd,
3365: p_dest_program_cd,
3366: l_new_dest_key_prgm_flag,

Line 3578: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3574: l_src_career_type);
3575: END IF;
3576: -- its an immediate transfer.
3577:
3578: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3579: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3580: p_data => p_msg_data);
3581:
3582: IF p_show_warning = 'Y' AND p_msg_count > 0 THEN

Line 3588: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3584: END IF;
3585:
3586: EXCEPTION
3587: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3588: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3589: p_return_status := FND_API.G_RET_STS_ERROR;
3590: FND_MESSAGE.SET_ENCODED(FND_MESSAGE.GET_ENCODED());
3591: FND_MSG_PUB.ADD;
3592: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,

Line 3596: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3592: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3593: p_data => p_msg_data);
3594: ROLLBACK TO TRANSFER_PRGM;
3595: WHEN FND_API.G_EXC_ERROR THEN
3596: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3597: p_return_status := FND_API.G_RET_STS_ERROR;
3598: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3599: p_data => p_msg_data);
3600: ROLLBACK TO TRANSFER_PRGM;

Line 3602: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3598: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3599: p_data => p_msg_data);
3600: ROLLBACK TO TRANSFER_PRGM;
3601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3602: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3605: p_data => p_msg_data);
3606: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

Line 3611: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3607: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3608: END IF;
3609: ROLLBACK TO TRANSFER_PRGM;
3610: WHEN OTHERS THEN
3611: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3613: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3614: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
3615: l_api_name);