DBA Data[Home] [Help]

APPS.IGS_PR_GEN_004 dependencies on IGS_PR_GEN_004

Line 1: PACKAGE BODY IGS_PR_GEN_004 AS

1: PACKAGE BODY IGS_PR_GEN_004 AS
2: /* $Header: IGSPR25B.pls 120.5 2006/02/08 02:52:18 sepalani ship $ */
3: --------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 170: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_INS_SUAO_TODO');

166: END;
167: EXCEPTION
168: WHEN OTHERS THEN
169: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
170: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_INS_SUAO_TODO');
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END igs_pr_ins_suao_todo;
174:

Line 916: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY.PRGPL_INS_LOG_ENTRY');

912: END;
913: EXCEPTION
914: WHEN OTHERS THEN
915: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
916: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY.PRGPL_INS_LOG_ENTRY');
917: IGS_GE_MSG_STACK.ADD;
918: App_Exception.Raise_Exception;
919: END prgpl_ins_log_entry;
920:

Line 1193: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY.PRGPL_UPD_SPO');

1189: END;
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1193: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY.PRGPL_UPD_SPO');
1194: IGS_GE_MSG_STACK.ADD;
1195: App_Exception.Raise_Exception;
1196: END prgpl_upd_spo;
1197:

Line 2663: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY');

2659: END;
2660: EXCEPTION
2661: WHEN OTHERS THEN
2662: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2663: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_OUT_APPLY');
2664: IGS_GE_MSG_STACK.ADD;
2665: App_Exception.Raise_Exception;
2666: END IGS_PR_upd_out_apply;
2667:

Line 2836: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_CHECK_READINESS');

2832: END;
2833: EXCEPTION
2834: WHEN OTHERS THEN
2835: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2836: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_CHECK_READINESS');
2837: IGS_GE_MSG_STACK.ADD;
2838: App_Exception.Raise_Exception;
2839: END PRGPL_UPD_CHECK_READINESS;
2840: --

Line 2976: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.dynamic_query',

2972: --
2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: fnd_log.string (
2975: fnd_log.level_statement,
2976: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.dynamic_query',
2977: 'Query Built => ' || stmt_str
2978: );
2979: END IF;
2980: --

Line 3041: igs_pr_gen_004.igs_pr_upd_sca_apply (

3037: p_ci_cal_type,
3038: p_ci_sequence_number,
3039: v_outcome_check_type
3040: ) = 'Y' THEN
3041: igs_pr_gen_004.igs_pr_upd_sca_apply (
3042: n_person_id,
3043: v_course_cd,
3044: p_ci_cal_type,
3045: p_ci_sequence_number,

Line 3071: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.exit_exception',

3067: WHEN OTHERS THEN
3068: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3069: fnd_log.string (
3070: fnd_log.level_exception,
3071: 'igs.plsql.igs_pr_gen_004.prgpl_upd_initial_appl.exit_exception',
3072: 'Exception => ' || SQLERRM
3073: );
3074: END IF;
3075: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 3076: fnd_message.set_token ('NAME', 'IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_INITIAL_APPL');

3072: 'Exception => ' || SQLERRM
3073: );
3074: END IF;
3075: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
3076: fnd_message.set_token ('NAME', 'IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_INITIAL_APPL');
3077: igs_ge_msg_stack.ADD;
3078: app_exception.raise_exception;
3079: END prgpl_upd_initial_appl;
3080:

Line 3381: IGS_PR_GEN_004.IGS_PR_upd_sca_apply (

3377: END IF;
3378: -- Process the distinct progression calendars in the PL/SQL table
3379: FOR v_index IN 1..v_ci_index LOOP
3380:
3381: IGS_PR_GEN_004.IGS_PR_upd_sca_apply (
3382: v_st_rec.person_id,
3383: v_st_rec.course_cd,
3384: v_ci_table(v_index).cal_type,
3385: v_ci_table(v_index).sequence_number,

Line 3451: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_TODO_APPL');

3447: END;
3448: EXCEPTION
3449: WHEN OTHERS THEN
3450: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3451: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY.PRGPL_UPD_TODO_APPL');
3452: IGS_GE_MSG_STACK.ADD;
3453: App_Exception.Raise_Exception;
3454: END prgpl_upd_todo_appl;
3455: BEGIN

Line 3498: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY');

3494: END;
3495: EXCEPTION
3496: WHEN OTHERS THEN
3497: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3498: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_RULE_APPLY');
3499: IGS_GE_MSG_STACK.ADD;
3500: App_Exception.Raise_Exception;
3501: END IGS_PR_upd_rule_apply;
3502:

Line 3659: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_INS_LOG_ENTRY');

3655: END;
3656: EXCEPTION
3657: WHEN OTHERS THEN
3658: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3659: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_INS_LOG_ENTRY');
3660: IGS_GE_MSG_STACK.ADD;
3661: App_Exception.Raise_Exception;
3662: END prgpl_ins_log_entry;
3663:

Line 4087: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_ADD_STDNT_PRG_OUTCOMES');

4083: END;
4084: EXCEPTION
4085: WHEN OTHERS THEN
4086: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4087: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_ADD_STDNT_PRG_OUTCOMES');
4088: IGS_GE_MSG_STACK.ADD;
4089: App_Exception.Raise_Exception;
4090: END prgpl_add_stdnt_prg_outcomes;
4091:

Line 4300: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_CREATE_OUTCOMES');

4296: END;
4297: EXCEPTION
4298: WHEN OTHERS THEN
4299: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4300: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_CREATE_OUTCOMES');
4301: IGS_GE_MSG_STACK.ADD;
4302: App_Exception.Raise_Exception;
4303: END prgpl_create_outcomes;
4304:

Line 4811: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_RMV_STDNT_PRG_OUTCOMES');

4807: END;
4808: EXCEPTION
4809: WHEN OTHERS THEN
4810: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4811: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_RMV_STDNT_PRG_OUTCOMES');
4812: IGS_GE_MSG_STACK.ADD;
4813: App_Exception.Raise_Exception;
4814: END prgpl_rmv_stdnt_prg_outcomes;
4815:

Line 4894: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_ATT_TYPE');

4890: END;
4891: EXCEPTION
4892: WHEN OTHERS THEN
4893: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4894: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_ATT_TYPE');
4895: IGS_GE_MSG_STACK.ADD;
4896: App_Exception.Raise_Exception;
4897: END prgpl_match_att_type;
4898:

Line 4999: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_CLASS_STANDING');

4995:
4996: EXCEPTION
4997: WHEN OTHERS THEN
4998: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4999: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_CLASS_STANDING');
5000: IGS_GE_MSG_STACK.ADD;
5001: App_Exception.Raise_Exception;
5002: END prgpl_match_class_standing;
5003:

Line 5105: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_CP_RANGE');

5101:
5102: EXCEPTION
5103: WHEN OTHERS THEN
5104: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5105: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_MATCH_CP_RANGE');
5106: IGS_GE_MSG_STACK.ADD;
5107: App_Exception.Raise_Exception;
5108: END prgpl_match_cp_range;
5109: ---------------------------------------------------------------------------------

Line 5416: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_SCA_APPLY_RULES');

5412: END;
5413: EXCEPTION
5414: WHEN OTHERS THEN
5415: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5416: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_SCA_APPLY_RULES');
5417: IGS_GE_MSG_STACK.ADD;
5418: App_Exception.Raise_Exception;
5419: END prgpl_sca_apply_rules;
5420:

Line 6000: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_SCA_PROCESS_RULES');

5996: END;
5997: EXCEPTION
5998: WHEN OTHERS THEN
5999: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6000: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY.PRGPL_SCA_PROCESS_RULES');
6001: IGS_GE_MSG_STACK.ADD;
6002: App_Exception.Raise_Exception;
6003: END prgpl_sca_process_rules;
6004: BEGIN

Line 6196: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY');

6192: END;
6193: EXCEPTION
6194: WHEN OTHERS THEN
6195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6196: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SCA_APPLY');
6197: IGS_GE_MSG_STACK.ADD;
6198: App_Exception.Raise_Exception;
6199: END IGS_PR_upd_sca_apply;
6200:

Line 6299: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SPO_APLY_DT');

6295: END;
6296: EXCEPTION
6297: WHEN OTHERS THEN
6298: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6299: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SPO_APLY_DT');
6300: IGS_GE_MSG_STACK.ADD;
6301: App_Exception.Raise_Exception;
6302: END IGS_PR_upd_spo_aply_dt;
6303: PROCEDURE IGS_PR_upd_spo_maint

Line 6687: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SPO_MAINT');

6683: END;
6684: EXCEPTION
6685: WHEN OTHERS THEN
6686: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6687: FND_MESSAGE.SET_TOKEN('NAME','IGS_PR_GEN_004.IGS_PR_UPD_SPO_MAINT');
6688: IGS_GE_MSG_STACK.ADD;
6689: retcode := 2;
6690: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXP');
6691: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 6695: END IGS_PR_GEN_004;

6691: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
6692:
6693: END IGS_PR_upd_spo_maint;
6694:
6695: END IGS_PR_GEN_004;