DBA Data[Home] [Help]

APPS.IGS_FI_F_RET_SCHD_HT_PKG dependencies on FND_MESSAGE

Line 53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

49: Open cur_old_ref_values;
50: Fetch cur_old_ref_values INTO old_references;
51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;

Line 126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

122: new_references.fee_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
123: END IF;
124: IF ((UPPER (column_name) = 'RETENTION_PERCENTAGE') OR (column_name IS NULL)) THEN
125: IF ((new_references.retention_percentage < 0) OR (new_references.retention_percentage > 100.00)) THEN
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;

Line 133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

129: END IF;
130: END IF;
131: IF ((UPPER (column_name) = 'RETENTION_AMOUNT') OR (column_name IS NULL)) THEN
132: IF ((new_references.retention_amount < 0)) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;

Line 140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

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

Line 147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

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

Line 154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

150: END IF;
151: END IF;
152: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
153: IF (new_references.s_relation_type <> UPPER (new_references.s_relation_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;

Line 161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

157: END IF;
158: END IF;
159: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
160: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 999999)) THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;

Line 168: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

164: END IF;
165: END IF;
166: IF ((UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
167: IF ((new_references.dai_sequence_number < 1) OR (new_references.dai_sequence_number > 999999)) THEN
168: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;

Line 175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

171: END IF;
172: END IF;
173: IF ((UPPER (column_name) = 'SCHEDULE_NUMBER') OR (column_name IS NULL)) THEN
174: IF ((new_references.schedule_number < 1) OR (new_references.schedule_number > 999999)) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;

Line 182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

178: END IF;
179: END IF;
180: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
181: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;

Line 198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

194: new_references.fee_cat,
195: new_references.schedule_number,
196: new_references.hist_start_dt
197: ) THEN
198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202: END Check_Uniqueness;

Line 218: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

214: new_references.fee_cat,
215: new_references.fee_cal_type,
216: new_references.fee_ci_sequence_number
217: ) THEN
218: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
219: IGS_GE_MSG_STACK.ADD;
220: App_Exception.Raise_Exception;
221: END IF;
222: END IF;

Line 239: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

235: new_references.fee_cal_type,
236: new_references.fee_ci_sequence_number,
237: new_references.fee_type
238: ) THEN
239: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: END IF;

Line 257: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

253: new_references.fee_type,
254: new_references.fee_cal_type,
255: new_references.fee_ci_sequence_number
256: ) THEN
257: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;

Line 339: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FRTNSH_FCCI_FK');

335: Open cur_rowid;
336: Fetch cur_rowid INTO lv_rowid;
337: IF (cur_rowid%FOUND) THEN
338: Close cur_rowid;
339: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FRTNSH_FCCI_FK');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: Return;
343: END IF;

Line 416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

412: new_references.s_relation_type,
413: new_references.sequence_number,
414: new_references.hist_start_dt
415: )) THEN
416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Uniqueness;

Line 437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

433: new_references.s_relation_type,
434: new_references.sequence_number,
435: new_references.hist_start_dt
436: )) THEN
437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
438: IGS_GE_MSG_STACK.ADD;
439: App_Exception.Raise_Exception;
440: END IF;
441: Check_Uniqueness;

Line 502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

498: if X_LAST_UPDATE_LOGIN is NULL then
499: X_LAST_UPDATE_LOGIN := -1;
500: end if;
501: else
502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: Before_DML(

Line 628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

624: open c1;
625: fetch c1 into tlinfo;
626: if (c1%notfound) then
627: close c1;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: IGS_GE_MSG_STACK.ADD;
630: app_exception.raise_exception;
631: return;
632: end if;

Line 660: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

656: AND (X_RETENTION_AMOUNT is null)))
657: ) then
658: null;
659: else
660: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
661: IGS_GE_MSG_STACK.ADD;
662: app_exception.raise_exception;
663: end if;
664: return;

Line 713: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

709: if X_LAST_UPDATE_LOGIN is NULL then
710: X_LAST_UPDATE_LOGIN := -1;
711: end if;
712: else
713: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
714: IGS_GE_MSG_STACK.ADD;
715: app_exception.raise_exception;
716: end if;
717: Before_DML(