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

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

37: Who When What
38: smvk 09-Jul-2004 Bug # 3676145. Modified the cursor c_ucl to select active (not closed) unit classes.
39: ********************************************************************************************** */
40: BEGIN
41: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
42: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
43: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
45: END log_parameters ;

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

38: smvk 09-Jul-2004 Bug # 3676145. Modified the cursor c_ucl to select active (not closed) unit classes.
39: ********************************************************************************************** */
40: BEGIN
41: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
42: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
43: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
45: END log_parameters ;
46:

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

39: ********************************************************************************************** */
40: BEGIN
41: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
42: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
43: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
45: END log_parameters ;
46:
47:

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

40: BEGIN
41: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
42: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
43: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
45: END log_parameters ;
46:
47:
48: FUNCTION crsp_get_ucl_mode(

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

168: END IF;
169: EXCEPTION
170:
171: WHEN OTHERS THEN
172: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
173: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_uoo_key');
174: IGS_GE_MSG_STACK.ADD;
175: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||p_cal_type
176: ||','||to_char(p_ci_sequence_number)||','||p_location_cd

Line 173: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_uoo_key');

169: EXCEPTION
170:
171: WHEN OTHERS THEN
172: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
173: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_uoo_key');
174: IGS_GE_MSG_STACK.ADD;
175: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||p_cal_type
176: ||','||to_char(p_ci_sequence_number)||','||p_location_cd
177: ||','||p_unit_class||','||to_char(p_uoo_id);

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

174: IGS_GE_MSG_STACK.ADD;
175: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||p_cal_type
176: ||','||to_char(p_ci_sequence_number)||','||p_location_cd
177: ||','||p_unit_class||','||to_char(p_uoo_id);
178: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
179: Fnd_Message.Set_Token('VALUE',lv_param_values);
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END;

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

175: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||p_cal_type
176: ||','||to_char(p_ci_sequence_number)||','||p_location_cd
177: ||','||p_unit_class||','||to_char(p_uoo_id);
178: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
179: Fnd_Message.Set_Token('VALUE',lv_param_values);
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END;
183: END crsp_get_uoo_key;

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

216: App_Exception.Raise_Exception;
217: END;
218: EXCEPTION
219: WHEN OTHERS THEN
220: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
221: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_admin');
222: IGS_GE_MSG_STACK.ADD;
223: lv_param_values := p_unit_set_cd||','||to_char(p_version_number);
224: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 221: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_admin');

217: END;
218: EXCEPTION
219: WHEN OTHERS THEN
220: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
221: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_admin');
222: IGS_GE_MSG_STACK.ADD;
223: lv_param_values := p_unit_set_cd||','||to_char(p_version_number);
224: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
225: Fnd_Message.Set_Token('VALUE',lv_param_values);

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

220: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
221: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_admin');
222: IGS_GE_MSG_STACK.ADD;
223: lv_param_values := p_unit_set_cd||','||to_char(p_version_number);
224: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
225: Fnd_Message.Set_Token('VALUE',lv_param_values);
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END crsp_get_us_admin;

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

221: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_admin');
222: IGS_GE_MSG_STACK.ADD;
223: lv_param_values := p_unit_set_cd||','||to_char(p_version_number);
224: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
225: Fnd_Message.Set_Token('VALUE',lv_param_values);
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END crsp_get_us_admin;
229:

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

261: App_Exception.Raise_Exception;
262: END;
263: EXCEPTION
264: WHEN OTHERS THEN
265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
266: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_sys_sts');
267: IGS_GE_MSG_STACK.ADD;
268: lv_param_values := p_unit_set_status;
269: Fnd_Message.Set_Token('VALUE',lv_param_values);

Line 266: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_sys_sts');

262: END;
263: EXCEPTION
264: WHEN OTHERS THEN
265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
266: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_sys_sts');
267: IGS_GE_MSG_STACK.ADD;
268: lv_param_values := p_unit_set_status;
269: Fnd_Message.Set_Token('VALUE',lv_param_values);
270: IGS_GE_MSG_STACK.ADD;

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

265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
266: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_get_us_sys_sts');
267: IGS_GE_MSG_STACK.ADD;
268: lv_param_values := p_unit_set_status;
269: Fnd_Message.Set_Token('VALUE',lv_param_values);
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END crsp_get_us_sys_sts;
273:

Line 535: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_DEST_CAL_UNIT' );

531: FETCH gc_check_dest_uo_exists INTO gv_uo_rec;
532: IF (gc_check_dest_uo_exists%NOTFOUND) THEN
533: -- This message has been added as part of Bug# 2550411 by shtatiko to log more specific message in case
534: -- Destination Calendar is not defined for the current Unit.
535: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_DEST_CAL_UNIT' );
536: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
537: ELSE
538: OPEN gc_check_uop_exists (gv_uop_rec.unit_cd,
539: gv_uop_rec.version_number);

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

532: IF (gc_check_dest_uo_exists%NOTFOUND) THEN
533: -- This message has been added as part of Bug# 2550411 by shtatiko to log more specific message in case
534: -- Destination Calendar is not defined for the current Unit.
535: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_DEST_CAL_UNIT' );
536: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
537: ELSE
538: OPEN gc_check_uop_exists (gv_uop_rec.unit_cd,
539: gv_uop_rec.version_number);
540: FETCH gc_check_uop_exists INTO gv_check;

Line 560: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_SUCCESS' );

556: x_abort_flag => 'N');
557:
558: gv_rec_inserted_cnt := gv_rec_inserted_cnt + 1;
559: -- This message has been added as part of Bug# 2550411 by shtatiko
560: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_SUCCESS' );
561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );

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

557:
558: gv_rec_inserted_cnt := gv_rec_inserted_cnt + 1;
559: -- This message has been added as part of Bug# 2550411 by shtatiko
560: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_SUCCESS' );
561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );
565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

Line 564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );

560: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_SUCCESS' );
561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );
565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
566: END IF;
567: CLOSE gc_check_uop_exists;
568:

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

561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );
565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
566: END IF;
567: CLOSE gc_check_uop_exists;
568:
569: --Enhancement bug no 1800179

Line 583: fnd_message.set_name ( 'IGS', gv_message );

579: lv_out_date) = TRUE) THEN
580: -- This logging of message returned by the function has been added to log the
581: -- status of importing Unit Offering Pattern and other details. This has been done
582: -- as per Bug fix 2550411 by shtatiko
583: fnd_message.set_name ( 'IGS', gv_message );
584: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
585:
586: IF (gv_message = 'IGS_PS_NO_UOO_AND_UAI_ROLLED' OR
587: gv_message = 'IGS_PS_UOO_NO_UOO_TOBE_ROLLED' OR

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

580: -- This logging of message returned by the function has been added to log the
581: -- status of importing Unit Offering Pattern and other details. This has been done
582: -- as per Bug fix 2550411 by shtatiko
583: fnd_message.set_name ( 'IGS', gv_message );
584: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
585:
586: IF (gv_message = 'IGS_PS_NO_UOO_AND_UAI_ROLLED' OR
587: gv_message = 'IGS_PS_UOO_NO_UOO_TOBE_ROLLED' OR
588: gv_message = 'IGS_PS_UOO_NO_UAI_TOBE_ROLLED' OR

Line 610: fnd_message.set_name ( 'IGS', gv_message );

606:
607: -- This logging of message returned by the function has been added to log the
608: -- status of importing Unit Offering Pattern and other details. This has been done
609: -- as per Bug fix 2550411 by shtatiko
610: fnd_message.set_name ( 'IGS', gv_message );
611: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
612:
613: v_uoo_uai_error_flag := TRUE;
614: IF ( gv_message='IGS_PS_INV_NO_UOO_ROLLED' OR

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

607: -- This logging of message returned by the function has been added to log the
608: -- status of importing Unit Offering Pattern and other details. This has been done
609: -- as per Bug fix 2550411 by shtatiko
610: fnd_message.set_name ( 'IGS', gv_message );
611: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
612:
613: v_uoo_uai_error_flag := TRUE;
614: IF ( gv_message='IGS_PS_INV_NO_UOO_ROLLED' OR
615: gv_message = 'IGS_PS_INV_UOO_ROLLED' OR

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

806: COMMIT;
807: RETCODE:=0;
808: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
809: fnd_file.put_line ( fnd_file.LOG, ' ');
810: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
814: fnd_file.put_line ( fnd_file.LOG, ' ');

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

811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
814: fnd_file.put_line ( fnd_file.LOG, ' ');
815: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
816: WHEN OTHERS THEN
817: RETCODE:=2;
818: ROLLBACK;
819: -- SQLERRM has been added as per Bug Fux 2550411

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

816: WHEN OTHERS THEN
817: RETCODE:=2;
818: ROLLBACK;
819: -- SQLERRM has been added as per Bug Fux 2550411
820: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
821: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
822: --Fnd log implementation
823: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
824: fnd_log.string( fnd_log.level_exception, 'igs.plsql.igs_ps_gen_006.crsp_ins_ci_uop_uoo.in_exception_section_OTHERS.err_msg',

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

1020: END;
1021: EXCEPTION
1022:
1023: WHEN OTHERS THEN
1024: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1025: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_us_hist');
1026: IGS_GE_MSG_STACK.ADD;
1027: lv_param_values := p_unit_set_cd||','||to_char(p_version_number)||','||p_new_unit_set_status||','
1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','

Line 1025: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_us_hist');

1021: EXCEPTION
1022:
1023: WHEN OTHERS THEN
1024: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1025: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_us_hist');
1026: IGS_GE_MSG_STACK.ADD;
1027: lv_param_values := p_unit_set_cd||','||to_char(p_version_number)||','||p_new_unit_set_status||','
1028: ||p_old_unit_set_status||','||p_new_unit_set_cat||','||p_old_unit_set_cat||','
1029: ||fnd_date.date_to_displaydate(p_new_start_dt)||','

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

1037: fnd_date.date_to_displaydate(p_old_responsible_ou_start_dt)||','||p_new_administrative_ind
1038: ||','||p_old_administrative_ind||','||p_new_authorisation_rqrd_ind||','||p_old_authorisation_rqrd_ind||','||
1039: p_new_update_who||','||p_old_update_who||','||
1040: fnd_date.date_to_displaydate(p_new_update_on)||','||fnd_date.date_to_displaydate(p_old_update_on);
1041: Fnd_Message.Set_Token('VALUE',lv_param_values);
1042: IGS_GE_MSG_STACK.ADD;
1043: App_Exception.Raise_Exception;
1044: END crsp_ins_us_hist;
1045:

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

1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333:
1334: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1335: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_uv_hist');
1336: IGS_GE_MSG_STACK.ADD;
1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
1338: ||p_last_update_who||','

Line 1335: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_uv_hist');

1331: EXCEPTION
1332: WHEN OTHERS THEN
1333:
1334: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1335: Fnd_Message.Set_Token('NAME','IGS_PS_GEN_006.crsp_ins_uv_hist');
1336: IGS_GE_MSG_STACK.ADD;
1337: lv_param_values := p_unit_cd||','||to_char(p_version_number)||','||fnd_date.date_to_displaydate(p_last_update_on)||','||fnd_date.date_to_displaydate(p_update_on)||','
1338: ||p_last_update_who||','
1339: ||fnd_date.date_to_displaydate(p_start_dt)||','||fnd_date.date_to_displaydate(p_review_dt)||','||fnd_date.date_to_displaydate(p_expiry_dt)||','

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

1347: ||','|| p_industrial_ind
1348: ||','||p_practical_ind||','||p_repeatable_ind||','||p_assessable_ind||','||p_unit_int_course_level_cd||','||TO_CHAR(p_billing_credit_points)||','||p_ovrd_wkld_val_flag||','||p_workload_val_code
1349: ||',' || to_char(p_billing_hrs);
1350:
1351: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1352: Fnd_Message.Set_Token('VALUE',lv_param_values);
1353: IGS_GE_MSG_STACK.ADD;
1354: App_Exception.Raise_Exception;
1355: END crsp_ins_uv_hist;

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

1348: ||','||p_practical_ind||','||p_repeatable_ind||','||p_assessable_ind||','||p_unit_int_course_level_cd||','||TO_CHAR(p_billing_credit_points)||','||p_ovrd_wkld_val_flag||','||p_workload_val_code
1349: ||',' || to_char(p_billing_hrs);
1350:
1351: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1352: Fnd_Message.Set_Token('VALUE',lv_param_values);
1353: IGS_GE_MSG_STACK.ADD;
1354: App_Exception.Raise_Exception;
1355: END crsp_ins_uv_hist;
1356: