28: Who When What
29:
30: ********************************************************************************************** */
31: BEGIN
32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
36: END log_parameters ;
29:
30: ********************************************************************************************** */
31: BEGIN
32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
36: END log_parameters ;
37:
30: ********************************************************************************************** */
31: BEGIN
32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
36: END log_parameters ;
37:
38:
31: BEGIN
32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
36: END log_parameters ;
37:
38:
39: PROCEDURE crsp_get_coo_key(
101: END IF;
102: END IF;
103: EXCEPTION
104: WHEN OTHERS THEN
105: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
106: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_coo_key');
107: IGS_GE_MSG_STACK.ADD;
108: lv_param_values := to_char(p_coo_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
109: ||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
102: END IF;
103: EXCEPTION
104: WHEN OTHERS THEN
105: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
106: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_coo_key');
107: IGS_GE_MSG_STACK.ADD;
108: lv_param_values := to_char(p_coo_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
109: ||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
110: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
106: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_coo_key');
107: IGS_GE_MSG_STACK.ADD;
108: lv_param_values := to_char(p_coo_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
109: ||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
110: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
111: Fnd_Message.Set_Token('VALUE',lv_param_values);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END;
107: IGS_GE_MSG_STACK.ADD;
108: lv_param_values := to_char(p_coo_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
109: ||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
110: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
111: Fnd_Message.Set_Token('VALUE',lv_param_values);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END;
115: END crsp_get_coo_key;
183: END IF;
184: EXCEPTION
185:
186: WHEN OTHERS THEN
187: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
188: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cop_key');
189: IGS_GE_MSG_STACK.ADD;
190: lv_param_values := to_char(p_cop_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
191: ||to_char(p_ci_sequence_number)||','||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
184: EXCEPTION
185:
186: WHEN OTHERS THEN
187: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
188: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cop_key');
189: IGS_GE_MSG_STACK.ADD;
190: lv_param_values := to_char(p_cop_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
191: ||to_char(p_ci_sequence_number)||','||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
192: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
188: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cop_key');
189: IGS_GE_MSG_STACK.ADD;
190: lv_param_values := to_char(p_cop_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
191: ||to_char(p_ci_sequence_number)||','||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
192: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
193: Fnd_Message.Set_Token('VALUE',lv_param_values);
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END;
189: IGS_GE_MSG_STACK.ADD;
190: lv_param_values := to_char(p_cop_id)||','||p_course_cd||','||to_char(p_version_number)||','||p_cal_type||','
191: ||to_char(p_ci_sequence_number)||','||p_location_cd||','||p_attendance_mode||','||p_attendance_type;
192: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
193: Fnd_Message.Set_Token('VALUE',lv_param_values);
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END;
197: END crsp_get_cop_key;
234: App_Exception.Raise_Exception;
235: END;
236: EXCEPTION
237: WHEN OTHERS THEN
238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
239: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_ind');
240: IGS_GE_MSG_STACK.ADD;
241: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd;
242:
235: END;
236: EXCEPTION
237: WHEN OTHERS THEN
238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
239: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_ind');
240: IGS_GE_MSG_STACK.ADD;
241: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd;
242:
243: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
239: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_ind');
240: IGS_GE_MSG_STACK.ADD;
241: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd;
242:
243: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
244: Fnd_Message.Set_Token('VALUE',lv_param_values);
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END crsp_get_cous_ind;
240: IGS_GE_MSG_STACK.ADD;
241: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd;
242:
243: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
244: Fnd_Message.Set_Token('VALUE',lv_param_values);
245: IGS_GE_MSG_STACK.ADD;
246: App_Exception.Raise_Exception;
247: END crsp_get_cous_ind;
248:
287: END;
288: EXCEPTION
289: WHEN OTHERS THEN
290:
291: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
292: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_subind');
293: IGS_GE_MSG_STACK.ADD;
294: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd||
295: ','||to_char(p_us_version_number);
288: EXCEPTION
289: WHEN OTHERS THEN
290:
291: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
292: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_subind');
293: IGS_GE_MSG_STACK.ADD;
294: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd||
295: ','||to_char(p_us_version_number);
296:
293: IGS_GE_MSG_STACK.ADD;
294: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd||
295: ','||to_char(p_us_version_number);
296:
297: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
298: Fnd_Message.Set_Token('VALUE',lv_param_values);
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END crsp_get_cous_subind;
294: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','||p_unit_set_cd||
295: ','||to_char(p_us_version_number);
296:
297: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
298: Fnd_Message.Set_Token('VALUE',lv_param_values);
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END crsp_get_cous_subind;
302:
498: END;
499: EXCEPTION
500: WHEN OTHERS THEN
501:
502: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
503: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_coi_cop');
504: IGS_GE_MSG_STACK.ADD;
505: lv_param_values := p_course_cd||','||to_char(p_version_number)||','||p_source_cal_type||','
506: ||to_char(p_source_sequence_number)||','||p_dest_cal_type||','||
499: EXCEPTION
500: WHEN OTHERS THEN
501:
502: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
503: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_coi_cop');
504: IGS_GE_MSG_STACK.ADD;
505: lv_param_values := p_course_cd||','||to_char(p_version_number)||','||p_source_cal_type||','
506: ||to_char(p_source_sequence_number)||','||p_dest_cal_type||','||
507: to_char(p_dest_sequence_number)||','||p_message_name;
505: lv_param_values := p_course_cd||','||to_char(p_version_number)||','||p_source_cal_type||','
506: ||to_char(p_source_sequence_number)||','||p_dest_cal_type||','||
507: to_char(p_dest_sequence_number)||','||p_message_name;
508:
509: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
510: Fnd_Message.Set_Token('VALUE',lv_param_values);
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END crsp_ins_coi_cop;
506: ||to_char(p_source_sequence_number)||','||p_dest_cal_type||','||
507: to_char(p_dest_sequence_number)||','||p_message_name;
508:
509: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
510: Fnd_Message.Set_Token('VALUE',lv_param_values);
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END crsp_ins_coi_cop;
514:
737: X_GUARANTEED_ENTRY_ASS_SCR => v_coi_rec.guaranteed_entry_ass_scr,
738: X_MODE => 'R');
739: v_rec_inserted_cnt := v_rec_inserted_cnt + 1;
740: -- This message has been added as part of Bug# 2550392 by shtatiko
741: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_SUCCESS' );
742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
738: X_MODE => 'R');
739: v_rec_inserted_cnt := v_rec_inserted_cnt + 1;
740: -- This message has been added as part of Bug# 2550392 by shtatiko
741: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_SUCCESS' );
742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
741: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_SUCCESS' );
742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
747: END IF;
748: CLOSE c_check_coi_exist;
749: -- Rollover all course_offering_patterns
742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
743: ELSE
744: -- This message has been added as part of Bug# 2550392 by shtatiko
745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );
746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
747: END IF;
748: CLOSE c_check_coi_exist;
749: -- Rollover all course_offering_patterns
750: -- within IGS_PS_OFR_INST.
759: -- This function never return FALSE at the moment
760: RAISE invalid;
761: END IF;
762:
763: fnd_message.set_name ( 'IGS', v_message );
764: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
765: -- no course_offering_patterns rolled over
766: IF (v_message = 'IGS_PS_PRGOFFR_ROLLED_EXIST' OR
767: v_message = 'IGS_PS_NO_POP_TOBE_ENROLLED') THEN
760: RAISE invalid;
761: END IF;
762:
763: fnd_message.set_name ( 'IGS', v_message );
764: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
765: -- no course_offering_patterns rolled over
766: IF (v_message = 'IGS_PS_PRGOFFR_ROLLED_EXIST' OR
767: v_message = 'IGS_PS_NO_POP_TOBE_ENROLLED') THEN
768: cst_all_cop_rec_inserted := FALSE;
812: WHEN VALID THEN
813: COMMIT;
814: RETCODE:=0;
815: fnd_file.put_line ( fnd_file.LOG, ' ');
816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
817: WHEN INVALID THEN
818: RETCODE:=2;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
821: WHEN OTHERS THEN
822: RETCODE:=2;
823: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
824: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
819: fnd_file.put_line ( fnd_file.LOG, ' ');
820: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
821: WHEN OTHERS THEN
822: RETCODE:=2;
823: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
824: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
825: ROLLBACK;
826: END crsp_ins_ci_cop;
827:
898: END;
899: EXCEPTION
900: WHEN OTHERS THEN
901:
902: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
903: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_cous');
904: IGS_GE_MSG_STACK.ADD;
905: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','
906: ||p_unit_set_cd||','||to_char(p_us_version_number)||','||p_override_title||','||p_only_as_sub_ind;
899: EXCEPTION
900: WHEN OTHERS THEN
901:
902: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
903: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_cous');
904: IGS_GE_MSG_STACK.ADD;
905: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','
906: ||p_unit_set_cd||','||to_char(p_us_version_number)||','||p_override_title||','||p_only_as_sub_ind;
907: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
903: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_cous');
904: IGS_GE_MSG_STACK.ADD;
905: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','
906: ||p_unit_set_cd||','||to_char(p_us_version_number)||','||p_override_title||','||p_only_as_sub_ind;
907: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
908: Fnd_Message.Set_Token('VALUE',lv_param_values);
909: IGS_GE_MSG_STACK.ADD;
910: App_Exception.Raise_Exception;
911: END crsp_ins_cous;
904: IGS_GE_MSG_STACK.ADD;
905: lv_param_values := p_course_cd||','||to_char(p_crv_version_number)||','||p_cal_type||','
906: ||p_unit_set_cd||','||to_char(p_us_version_number)||','||p_override_title||','||p_only_as_sub_ind;
907: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
908: Fnd_Message.Set_Token('VALUE',lv_param_values);
909: IGS_GE_MSG_STACK.ADD;
910: App_Exception.Raise_Exception;
911: END crsp_ins_cous;
912: