DBA Data[Home] [Help]

APPS.IGS_FI_FEE_CAT_CI_HT_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT', 'VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;
46: Close cur_old_ref_values;

Line 113: IGS_GE_MSG_STACK.ADD;

109: IF upper(Column_Name) = 'START_DAI_SEQUENCE_NUMBER' OR
110: column_name is NULL THEN
111: IF new_references.start_dai_sequence_number < 1 OR new_references.start_dai_sequence_number > 999999 THEN
112: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116: END IF;
117: IF upper(Column_Name) = 'RETRO_DAI_SEQUENCE_NUMBER' OR

Line 121: IGS_GE_MSG_STACK.ADD;

117: IF upper(Column_Name) = 'RETRO_DAI_SEQUENCE_NUMBER' OR
118: column_name is NULL THEN
119: IF new_references.retro_dai_sequence_number < 1 OR new_references.retro_dai_sequence_number > 999999 THEN
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: IF upper(Column_Name) = 'END_DAI_SEQUENCE_NUMBER' OR

Line 129: IGS_GE_MSG_STACK.ADD;

125: IF upper(Column_Name) = 'END_DAI_SEQUENCE_NUMBER' OR
126: column_name is NULL THEN
127: IF new_references.end_dai_sequence_number < 1 OR new_references.end_dai_sequence_number > 999999 THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132: END IF;
133: IF upper(Column_Name) = 'FEE_CI_SEQUENCE_NUMBER' OR

Line 137: IGS_GE_MSG_STACK.ADD;

133: IF upper(Column_Name) = 'FEE_CI_SEQUENCE_NUMBER' OR
134: column_name is NULL THEN
135: IF new_references.fee_ci_sequence_number < 1 OR new_references.fee_ci_sequence_number > 999999 THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:

Line 146: IGS_GE_MSG_STACK.ADD;

142: IF upper(Column_Name) = 'END_DT_ALIAS' OR
143: column_name is NULL THEN
144: IF new_references.end_dt_alias <> UPPER(new_references.end_dt_alias) THEN
145: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: END IF;
150:

Line 155: IGS_GE_MSG_STACK.ADD;

151: IF upper(Column_Name) = 'FEE_CAL_TYPE' OR
152: column_name is NULL THEN
153: IF new_references.fee_cal_type <> UPPER(new_references.fee_cal_type) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:

Line 164: IGS_GE_MSG_STACK.ADD;

160: IF upper(Column_Name) = 'RETRO_DT_ALIAS' OR
161: column_name is NULL THEN
162: IF new_references.retro_dt_alias <> UPPER(new_references.retro_dt_alias) THEN
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168: IF upper(Column_Name) = 'START_DT_ALIAS' OR

Line 172: IGS_GE_MSG_STACK.ADD;

168: IF upper(Column_Name) = 'START_DT_ALIAS' OR
169: column_name is NULL THEN
170: IF new_references.start_dt_alias <> UPPER(new_references.start_dt_alias) THEN
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: END Check_Constraints;

Line 261: IGS_GE_MSG_STACK.ADD;

257: new_references.fee_ci_sequence_number,
258: new_references.hist_start_dt
259: ) THEN
260: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263: END IF;
264: Check_Constraints;
265: ELSIF (p_action = 'UPDATE') THEN

Line 277: IGS_GE_MSG_STACK.ADD;

273: new_references.fee_ci_sequence_number,
274: new_references.hist_start_dt
275: ) THEN
276: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280: Check_Constraints;
281: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 327: IGS_GE_MSG_STACK.ADD;

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

Line 437: IGS_GE_MSG_STACK.ADD;

433: open c1;
434: fetch c1 into tlinfo;
435: if (c1%notfound) then
436: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
437: IGS_GE_MSG_STACK.ADD;
438: app_exception.raise_exception;
439: close c1;
440: return;
441: end if;

Line 470: IGS_GE_MSG_STACK.ADD;

466: ) then
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;

Line 511: IGS_GE_MSG_STACK.ADD;

507: X_LAST_UPDATE_LOGIN := -1;
508: end if;
509: else
510: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
511: IGS_GE_MSG_STACK.ADD;
512: app_exception.raise_exception;
513: end if;
514: Before_DML(
515: p_action=>'UPDATE',