DBA Data[Home] [Help]

APPS.IGS_FI_F_CAT_F_LBL_H_PKG dependencies on APP_EXCEPTION

Line 54: App_Exception.Raise_Exception;

50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
51: Close cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: Return;
56: END IF;
57: Close cur_old_ref_values;
58: -- Populate New Values.

Line 118: App_Exception.Raise_Exception;

114: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
115: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121: IF ((UPPER (column_name) = 'RUL_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
122: IF ((new_references.rul_sequence_number < 1) OR (new_references.rul_sequence_number > 999999)) THEN

Line 125: App_Exception.Raise_Exception;

121: IF ((UPPER (column_name) = 'RUL_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
122: IF ((new_references.rul_sequence_number < 1) OR (new_references.rul_sequence_number > 999999)) THEN
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128: IF ((UPPER (column_name) = 'START_DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
129: IF ((new_references.start_dai_sequence_number < 1) OR (new_references.start_dai_sequence_number > 999999)) THEN

Line 132: App_Exception.Raise_Exception;

128: IF ((UPPER (column_name) = 'START_DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
129: IF ((new_references.start_dai_sequence_number < 1) OR (new_references.start_dai_sequence_number > 999999)) THEN
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
136: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN

Line 139: App_Exception.Raise_Exception;

135: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
136: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN
137: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142: IF ((UPPER (column_name) = 'START_DT_ALIAS') OR (column_name IS NULL)) THEN
143: IF (new_references.start_dt_alias <> UPPER (new_references.start_dt_alias)) THEN

Line 146: App_Exception.Raise_Exception;

142: IF ((UPPER (column_name) = 'START_DT_ALIAS') OR (column_name IS NULL)) THEN
143: IF (new_references.start_dt_alias <> UPPER (new_references.start_dt_alias)) THEN
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149: IF ((UPPER (column_name) = 'S_CHG_METHOD_TYPE') OR (column_name IS NULL)) THEN
150: IF (new_references.s_chg_method_type <> UPPER (new_references.s_chg_method_type)) THEN

Line 153: App_Exception.Raise_Exception;

149: IF ((UPPER (column_name) = 'S_CHG_METHOD_TYPE') OR (column_name IS NULL)) THEN
150: IF (new_references.s_chg_method_type <> UPPER (new_references.s_chg_method_type)) THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156: END Check_Constraints;
157: FUNCTION Get_PK_For_Validation (

Line 252: App_Exception.Raise_Exception;

248: new_references.hist_start_dt
249: )) THEN
250: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: Check_Constraints;
255: ELSIF (p_action = 'UPDATE') THEN
256: -- Call all the procedures related to Before Update.

Line 268: App_Exception.Raise_Exception;

264: new_references.hist_start_dt
265: )) THEN
266: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: END IF;
270: Check_Constraints;
271: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
272: Check_Constraints;

Line 329: app_exception.raise_exception;

325: end if;
326: else
327: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331: Before_DML(
332: p_action=>'INSERT',
333: x_rowid=>X_ROWID,

Line 445: app_exception.raise_exception;

441: if (c1%notfound) then
442: close c1;
443: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: return;
447: end if;
448: close c1;
449: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 471: app_exception.raise_exception;

467: null;
468: else
469: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
470: IGS_GE_MSG_STACK.ADD;
471: app_exception.raise_exception;
472: end if;
473: return;
474: end LOCK_ROW;
475: procedure UPDATE_ROW (

Line 522: app_exception.raise_exception;

518: end if;
519: else
520: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
521: IGS_GE_MSG_STACK.ADD;
522: app_exception.raise_exception;
523: end if;
524: Before_DML(
525: p_action=>'UPDATE',
526: x_rowid=>X_ROWID,