DBA Data[Home] [Help]

APPS.IGS_PS_GEN_006 dependencies on IGS_GE_MSG_STACK

Line 174: IGS_GE_MSG_STACK.ADD;

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

Line 180: IGS_GE_MSG_STACK.ADD;

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;
184:

Line 222: IGS_GE_MSG_STACK.ADD;

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);
226: IGS_GE_MSG_STACK.ADD;

Line 226: IGS_GE_MSG_STACK.ADD;

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:
230: FUNCTION crsp_get_us_sys_sts(

Line 267: IGS_GE_MSG_STACK.ADD;

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;
271: App_Exception.Raise_Exception;

Line 270: IGS_GE_MSG_STACK.ADD;

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:
274:

Line 821: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

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',
825: SUBSTRB(SQLERRM,1,4000));

Line 1026: IGS_GE_MSG_STACK.ADD;

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)||','
1030: ||fnd_date.date_to_displaydate(p_old_start_dt)||','||fnd_date.date_to_displaydate(p_new_review_dt)||','

Line 1042: IGS_GE_MSG_STACK.ADD;

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:
1046: -- sommukhe 13-Feb-2006 Bug#3306014, modified cursors c_org_unit for performance reason.

Line 1336: IGS_GE_MSG_STACK.ADD;

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)||','
1340: ||fnd_date.date_to_displaydate(p_end_dt)||','||p_unit_status||','||p_title||','||p_short_title||

Line 1353: IGS_GE_MSG_STACK.ADD;

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:
1357: