DBA Data[Home] [Help]

APPS.IGS_PS_GEN_003 dependencies on FND_MESSAGE

Line 32: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');

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 ;

Line 33: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );

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:

Line 34: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;

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:

Line 35: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);

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(

Line 105: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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;

Line 106: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_coo_key');

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

Line 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;

Line 111: Fnd_Message.Set_Token('VALUE',lv_param_values);

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;

Line 187: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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;

Line 188: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cop_key');

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

Line 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;

Line 193: Fnd_Message.Set_Token('VALUE',lv_param_values);

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;

Line 238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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:

Line 239: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_ind');

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

Line 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;

Line 244: Fnd_Message.Set_Token('VALUE',lv_param_values);

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:

Line 291: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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

Line 292: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_get_cous_subind');

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:

Line 297: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

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;

Line 298: Fnd_Message.Set_Token('VALUE',lv_param_values);

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:

Line 502: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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||','||

Line 503: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_coi_cop');

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;

Line 509: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

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;

Line 510: Fnd_Message.Set_Token('VALUE',lv_param_values);

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:

Line 741: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_SUCCESS' );

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

Line 742: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

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

Line 745: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_POI_EXISTS' );

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

Line 746: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

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.

Line 763: fnd_message.set_name ( 'IGS', v_message );

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

Line 764: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

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;

Line 816: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

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

Line 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;

Line 823: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

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:

Line 902: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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;

Line 903: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_003.crsp_ins_cous');

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

Line 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;

Line 908: Fnd_Message.Set_Token('VALUE',lv_param_values);

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: