[Home] [Help]
6559: WHEN OTHERS THEN
6560: RAISE;
6561: END;
6562: ELSE
6563: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Person := '||lv_person_number ||
6564: ' With the Course := '||v_spo_upd_rec.COURSE_CD||' Has no Expiry date');
6565: END IF;
6566: END LOOP; -- c_spo
6567: --Functionality for the part of the code that follows:-
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'
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
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
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;