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

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

165: RAISE;
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;

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 211: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REASON_ACA_HOLD');

207: OPEN c_tl;
208: FETCH c_tl INTO l_load_cal_type, l_load_ci_sequence_number;
209: CLOSE c_tl;
210:
211: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REASON_ACA_HOLD');
212: FND_MESSAGE.SET_TOKEN('UNIT',p_unit_cd);
213: igs_ss_en_wrappers.drop_notif_variable(FND_MESSAGE.GET(),'ACADEMIC-HOLDS' );
214:
215: END invoke_drop_workflow;

Line 212: FND_MESSAGE.SET_TOKEN('UNIT',p_unit_cd);

208: FETCH c_tl INTO l_load_cal_type, l_load_ci_sequence_number;
209: CLOSE c_tl;
210:
211: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REASON_ACA_HOLD');
212: FND_MESSAGE.SET_TOKEN('UNIT',p_unit_cd);
213: igs_ss_en_wrappers.drop_notif_variable(FND_MESSAGE.GET(),'ACADEMIC-HOLDS' );
214:
215: END invoke_drop_workflow;
216:

Line 213: igs_ss_en_wrappers.drop_notif_variable(FND_MESSAGE.GET(),'ACADEMIC-HOLDS' );

209: CLOSE c_tl;
210:
211: FND_MESSAGE.SET_NAME('IGS','IGS_EN_REASON_ACA_HOLD');
212: FND_MESSAGE.SET_TOKEN('UNIT',p_unit_cd);
213: igs_ss_en_wrappers.drop_notif_variable(FND_MESSAGE.GET(),'ACADEMIC-HOLDS' );
214:
215: END invoke_drop_workflow;
216:
217:

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

911: v_text);
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;

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 1192: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1188: RAISE;
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;

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 1279: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_SC');

1275: (v_spo_rec.show_cause_dt IS NOT NULL AND v_spo_rec.show_cause_outcome_dt IS NULL)
1276: THEN
1277: -- Show cause is still in effect.. do not apply the outcomes yet
1278: IF p_spo_person_id IS NOT NULL THEN
1279: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_SC');
1280: p_message_text := FND_MESSAGE.GET;
1281: p_message_level := cst_warn;
1282: EXIT;
1283: END IF;

Line 1280: p_message_text := FND_MESSAGE.GET;

1276: THEN
1277: -- Show cause is still in effect.. do not apply the outcomes yet
1278: IF p_spo_person_id IS NOT NULL THEN
1279: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_SC');
1280: p_message_text := FND_MESSAGE.GET;
1281: p_message_level := cst_warn;
1282: EXIT;
1283: END IF;
1284: v_process_next_spo := TRUE;

Line 1298: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_AP');

1294: OR
1295: (v_spo_rec.appeal_dt IS NOT NULL AND v_spo_rec.appeal_outcome_dt IS NULL) THEN
1296: -- Appeal period is still in effect.. do not apply outcomes
1297: IF p_spo_person_id IS NOT NULL THEN
1298: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_AP');
1299: p_message_text := FND_MESSAGE.GET;
1300: p_message_level := cst_warn;
1301: EXIT;
1302: END IF;

Line 1299: p_message_text := FND_MESSAGE.GET;

1295: (v_spo_rec.appeal_dt IS NOT NULL AND v_spo_rec.appeal_outcome_dt IS NULL) THEN
1296: -- Appeal period is still in effect.. do not apply outcomes
1297: IF p_spo_person_id IS NOT NULL THEN
1298: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNAB_APLY_OTCM_AP');
1299: p_message_text := FND_MESSAGE.GET;
1300: p_message_level := cst_warn;
1301: EXIT;
1302: END IF;
1303: v_process_next_spo := TRUE;

Line 1393: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');

1389: ROLLBACK TO sp_before_spo_apply;
1390: IF p_spo_person_id IS NULL THEN
1391: v_process_next_spo := TRUE;
1392: ELSE
1393: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
1394: p_message_text := FND_MESSAGE.GET;
1395: p_message_level := cst_error;
1396: EXIT;
1397: END IF;

Line 1394: p_message_text := FND_MESSAGE.GET;

1390: IF p_spo_person_id IS NULL THEN
1391: v_process_next_spo := TRUE;
1392: ELSE
1393: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
1394: p_message_text := FND_MESSAGE.GET;
1395: p_message_level := cst_error;
1396: EXIT;
1397: END IF;
1398: ELSE

Line 1477: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_RSN_CD');

1473: NULL);
1474: v_process_next_spo := TRUE;
1475: EXIT;
1476: ELSE
1477: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_RSN_CD');
1478: p_message_level := cst_error;
1479: v_exit_procedure := TRUE;
1480: EXIT;
1481: END IF;

Line 1535: FND_MESSAGE.SET_NAME ('IGS', v_message_name);

1531: END IF;
1532: v_process_next_spo := TRUE;
1533: EXIT;
1534: ELSE
1535: FND_MESSAGE.SET_NAME ('IGS', v_message_name);
1536: p_message_text := FND_MESSAGE.GET;
1537: p_message_level := cst_error;
1538: v_exit_procedure := TRUE;
1539: EXIT;

Line 1536: p_message_text := FND_MESSAGE.GET;

1532: v_process_next_spo := TRUE;
1533: EXIT;
1534: ELSE
1535: FND_MESSAGE.SET_NAME ('IGS', v_message_name);
1536: p_message_text := FND_MESSAGE.GET;
1537: p_message_level := cst_error;
1538: v_exit_procedure := TRUE;
1539: EXIT;
1540: END IF;

Line 1589: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_UPD_END_SUA');

1585: NULL);
1586: v_process_next_spo := TRUE;
1587: EXIT;
1588: ELSE
1589: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_UPD_END_SUA');
1590: p_message_level := cst_error;
1591: v_exit_procedure := TRUE;
1592: EXIT;
1593: END IF;

Line 1658: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SUSA_TA');

1654: CLOSE c_susa;
1655: END IF;
1656: ROLLBACK TO sp_before_spo_apply;
1657: IF p_spo_person_id IS NOT NULL THEN
1658: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SUSA_TA');
1659: p_message_text := FND_MESSAGE.GET;
1660: p_message_level := cst_error;
1661: EXIT;
1662: ELSE

Line 1659: p_message_text := FND_MESSAGE.GET;

1655: END IF;
1656: ROLLBACK TO sp_before_spo_apply;
1657: IF p_spo_person_id IS NOT NULL THEN
1658: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SUSA_TA');
1659: p_message_text := FND_MESSAGE.GET;
1660: p_message_level := cst_error;
1661: EXIT;
1662: ELSE
1663: v_process_next_spo := TRUE;

Line 1720: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');

1716: 'IGS_PR_DISCON_UNIT',
1717: NULL);
1718: ELSE
1719: IF p_message_level IS NULL THEN
1720: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');
1721: p_message_level := cst_warning;
1722: END IF;
1723: END IF;
1724: ELSE

Line 1839: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');

1835: 'IGS_PR_DISCON_UNIT',
1836: NULL);
1837: ELSE
1838: IF p_message_level IS NULL THEN
1839: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');
1840: p_message_level := cst_warning;
1841: END IF;
1842: END IF;
1843: ELSE

Line 1874: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');

1870: 'IGS_PR_DISCON_UNIT',
1871: NULL);
1872: ELSE
1873: IF p_message_level IS NULL THEN
1874: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_DISCON_UNIT');
1875: p_message_level := cst_warning;
1876: END IF;
1877: END IF;
1878:

Line 2004: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_UA_TA');

2000: CLOSE c_sua;
2001: END IF;
2002: ROLLBACK TO sp_before_spo_apply;
2003: IF p_spo_person_id IS NOT NULL THEN
2004: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_UA_TA');
2005: p_message_text := FND_MESSAGE.GET;
2006: p_message_level := cst_error;
2007: EXIT;
2008: ELSE

Line 2005: p_message_text := FND_MESSAGE.GET;

2001: END IF;
2002: ROLLBACK TO sp_before_spo_apply;
2003: IF p_spo_person_id IS NOT NULL THEN
2004: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_UA_TA');
2005: p_message_text := FND_MESSAGE.GET;
2006: p_message_level := cst_error;
2007: EXIT;
2008: ELSE
2009: v_process_next_spo := TRUE;

Line 2109: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');

2105: ROLLBACK TO sp_before_spo_apply;
2106: IF p_spo_person_id IS NULL THEN
2107: v_process_next_spo := TRUE;
2108: ELSE
2109: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2110: p_message_text := FND_MESSAGE.GET;
2111: p_message_level := cst_error;
2112: EXIT;
2113: END IF;

Line 2110: p_message_text := FND_MESSAGE.GET;

2106: IF p_spo_person_id IS NULL THEN
2107: v_process_next_spo := TRUE;
2108: ELSE
2109: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2110: p_message_text := FND_MESSAGE.GET;
2111: p_message_level := cst_error;
2112: EXIT;
2113: END IF;
2114: END IF;

Line 2177: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_FUT_CAL_INST_NOT_EXST');

2173: NULL);/* added because of commenting the following*/
2174: v_process_next_spo := TRUE;
2175: EXIT;
2176: ELSE
2177: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_FUT_CAL_INST_NOT_EXST');
2178: p_message_text := FND_MESSAGE.GET;
2179: p_message_level := cst_error;
2180: v_exit_procedure := TRUE;
2181: EXIT;

Line 2178: p_message_text := FND_MESSAGE.GET;

2174: v_process_next_spo := TRUE;
2175: EXIT;
2176: ELSE
2177: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_FUT_CAL_INST_NOT_EXST');
2178: p_message_text := FND_MESSAGE.GET;
2179: p_message_level := cst_error;
2180: v_exit_procedure := TRUE;
2181: EXIT;
2182: END IF;

Line 2270: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');

2266: ROLLBACK TO sp_before_spo_apply;
2267: IF p_spo_person_id IS NULL THEN
2268: v_process_next_spo := TRUE;
2269: ELSE
2270: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2271: p_message_text := FND_MESSAGE.GET;
2272: p_message_level := cst_error;
2273: EXIT;
2274: END IF;

Line 2271: p_message_text := FND_MESSAGE.GET;

2267: IF p_spo_person_id IS NULL THEN
2268: v_process_next_spo := TRUE;
2269: ELSE
2270: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2271: p_message_text := FND_MESSAGE.GET;
2272: p_message_level := cst_error;
2273: EXIT;
2274: END IF;
2275: WHEN OTHERS THEN

Line 2287: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OTCM_ST_NO_EFFECT');

2283: IF p_spo_person_id IS NOT NULL AND
2284: v_spo_rec.decision_status NOT IN (
2285: cst_removed,
2286: cst_cancelled) THEN
2287: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OTCM_ST_NO_EFFECT');
2288: p_message_text := FND_MESSAGE.GET;
2289: p_message_level := cst_warn;
2290: EXIT;
2291: END IF;

Line 2288: p_message_text := FND_MESSAGE.GET;

2284: v_spo_rec.decision_status NOT IN (
2285: cst_removed,
2286: cst_cancelled) THEN
2287: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_OTCM_ST_NO_EFFECT');
2288: p_message_text := FND_MESSAGE.GET;
2289: p_message_level := cst_warn;
2290: EXIT;
2291: END IF;
2292: -- Logic to un-apply a previously applied outcome following the decision

Line 2357: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');

2353: ROLLBACK TO sp_before_spo_apply;
2354: IF p_spo_person_id IS NULL THEN
2355: v_process_next_spo := TRUE;
2356: ELSE
2357: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2358: p_message_text := FND_MESSAGE.GET;
2359: p_message_level := cst_error;
2360: EXIT;
2361: END IF;

Line 2358: p_message_text := FND_MESSAGE.GET;

2354: IF p_spo_person_id IS NULL THEN
2355: v_process_next_spo := TRUE;
2356: ELSE
2357: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2358: p_message_text := FND_MESSAGE.GET;
2359: p_message_level := cst_error;
2360: EXIT;
2361: END IF;
2362: END IF;

Line 2409: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_SCA_DISCON_NOT_LIFTED');

2405: NULL,
2406: 'IGS_PR_SCA_DISCON_NOT_LIFTED',
2407: NULL);
2408: ELSE
2409: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_SCA_DISCON_NOT_LIFTED');
2410: p_message_level := cst_error;
2411: END IF;
2412: ELSE
2413: -- Lift the course discontinuation

Line 2512: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SCA_TA');

2508: ROLLBACK TO sp_before_spo_apply;
2509: IF p_spo_person_id IS NULL THEN
2510: v_process_next_spo := TRUE;
2511: ELSE
2512: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SCA_TA');
2513: p_message_text := FND_MESSAGE.GET;
2514: p_message_level := cst_error;
2515: EXIT;
2516: END IF;

Line 2513: p_message_text := FND_MESSAGE.GET;

2509: IF p_spo_person_id IS NULL THEN
2510: v_process_next_spo := TRUE;
2511: ELSE
2512: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_SCA_TA');
2513: p_message_text := FND_MESSAGE.GET;
2514: p_message_level := cst_error;
2515: EXIT;
2516: END IF;
2517: WHEN e_application THEN

Line 2537: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_ERR_SCA_DISCON_LIFT');

2533: NULL,
2534: 'IGS_PR_ERR_SCA_DISCON_LIFT',
2535: SUBSTR(SQLERRM, 12, LENGTH(SQLERRM)));
2536: ELSE
2537: p_message_text := FND_MESSAGE.GET_STRING('IGS','IGS_PR_ERR_SCA_DISCON_LIFT');
2538: p_message_level := cst_error;
2539: EXIT;
2540: END IF;
2541: WHEN OTHERS THEN

Line 2598: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');

2594: CLOSE c_pra_upd1;
2595: END IF;
2596: ROLLBACK TO sp_before_spo_apply;
2597: IF p_spo_person_id IS NOT NULL THEN
2598: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2599: p_message_text := FND_MESSAGE.GET;
2600: p_message_level := cst_error;
2601: EXIT;
2602: END IF;

Line 2599: p_message_text := FND_MESSAGE.GET;

2595: END IF;
2596: ROLLBACK TO sp_before_spo_apply;
2597: IF p_spo_person_id IS NOT NULL THEN
2598: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_UNLO_DTLS_TA');
2599: p_message_text := FND_MESSAGE.GET;
2600: p_message_level := cst_error;
2601: EXIT;
2602: END IF;
2603: WHEN OTHERS THEN

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

2658: RAISE;
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;

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 2835: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2831: RETURN 'Y';
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;

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 3075: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

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');
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;

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 3450: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3446: RAISE;
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;

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 3497: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3493: RAISE;
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;

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 3658: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3654: v_text);
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;

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 4086: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4082: RAISE;
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;

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 4299: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4295: RAISE;
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;

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 4810: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4806: RAISE;
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;

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 4893: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4889: RAISE;
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;

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 4998: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4994: END;
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;

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 5104: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5100: END;
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;

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 5415: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5411: RAISE;
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;

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 5999: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5995: RAISE;
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;

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 6195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6191: RAISE;
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;

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 6298: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6294: RAISE;
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;

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 6588: FND_MESSAGE.SET_NAME('IGS', v_message_name);

6584: v_sca_rec.version_number,
6585: v_message_name);
6586:
6587: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6588: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6589: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6590: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6591: end if;
6592: END LOOP; -- c_sca1

Line 6589: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);

6585: v_message_name);
6586:
6587: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6588: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6589: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6590: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6591: end if;
6592: END LOOP; -- c_sca1
6593:

Line 6590: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

6586:
6587: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6588: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6589: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6590: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6591: end if;
6592: END LOOP; -- c_sca1
6593:
6594: -- Corresponding to all records where decision status is still 'PENDING'

Line 6612: FND_MESSAGE.SET_NAME('IGS', v_message_name);

6608: v_sca_rec.progression_status,
6609: v_sca_rec.version_number,
6610: v_message_name);
6611: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6612: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6613: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6614: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6615: end if;
6616:

Line 6613: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);

6609: v_sca_rec.version_number,
6610: v_message_name);
6611: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6612: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6613: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6614: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6615: end if;
6616:
6617: END LOOP; -- c_sca2

Line 6614: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

6610: v_message_name);
6611: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6612: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6613: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6614: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6615: end if;
6616:
6617: END LOOP; -- c_sca2
6618: -- Show Cause ; Selects records with a status of show cause where there is no

Line 6633: FND_MESSAGE.SET_NAME('IGS', v_message_name);

6629: v_sca_rec.progression_status,
6630: v_sca_rec.version_number,
6631: v_message_name);
6632: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6633: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6634: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6635: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6636: end if;
6637:

Line 6634: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);

6630: v_sca_rec.version_number,
6631: v_message_name);
6632: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6633: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6634: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6635: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6636: end if;
6637:
6638: END LOOP; -- c_sca3

Line 6635: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

6631: v_message_name);
6632: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6633: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6634: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6635: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6636: end if;
6637:
6638: END LOOP; -- c_sca3
6639: -- Probation, Suspension, Exclusion, Expulsion : Selects records were effects

Line 6655: FND_MESSAGE.SET_NAME('IGS', v_message_name);

6651: v_sca_rec.progression_status,
6652: v_sca_rec.version_number,
6653: v_message_name);
6654: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6655: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6656: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6657: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6658: end if;
6659:

Line 6656: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);

6652: v_sca_rec.version_number,
6653: v_message_name);
6654: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6655: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6656: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6657: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6658: end if;
6659:
6660: END LOOP; -- c_sca4

Line 6657: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

6653: v_message_name);
6654: IF v_message_name = 'IGS_PR_LOCK_DETECTED' THEN
6655: FND_MESSAGE.SET_NAME('IGS', v_message_name);
6656: fnd_message.set_token('RECORD', 'Student program Attempt for ' || lv_person_number || ' and course ' || v_sca_rec.course_cd);
6657: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
6658: end if;
6659:
6660: END LOOP; -- c_sca4
6661: COMMIT;

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

6682: RAISE;
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');

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 6690: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXP');

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;
6692:
6693: END IGS_PR_upd_spo_maint;
6694: