DBA Data[Home] [Help]

APPS.IGS_AS_UNT_PATRN_ITM_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

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

Line 111: IGS_GE_MSG_STACK.ADD;

107: new_references.ass_id,
108: new_references.uai_sequence_number,
109: v_message_name) = FALSE THEN
110: Fnd_Message.Set_Name('IGS', v_message_name);
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115: IF p_inserting THEN

Line 170: IGS_GE_MSG_STACK.ADD;

166: new_references.ass_id,
167: new_references.uai_sequence_number
168: )THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:

Line 195: IGS_GE_MSG_STACK.ADD;

191: new_references.ci_sequence_number,
192: new_references.ass_pattern_id
193: ))THEN
194: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199:

Line 225: IGS_GE_MSG_STACK.ADD;

221: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR
222: column_name is null Then
223: IF new_references.ci_sequence_number < 1 AND new_references.ci_sequence_number > 999999 Then
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:

Line 234: IGS_GE_MSG_STACK.ADD;

230: IF upper(column_name) = 'APPORTIONMENT_PERCENTAGE' OR
231: column_name is null Then
232: IF new_references.apportionment_percentage < 0 AND new_references.apportionment_percentage > 100 Then
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238: IF upper(column_name) = 'UAI_SEQUENCE_NUMBER' OR

Line 242: IGS_GE_MSG_STACK.ADD;

238: IF upper(column_name) = 'UAI_SEQUENCE_NUMBER' OR
239: column_name is null Then
240: IF new_references.uai_sequence_number < 1 AND new_references.uai_sequence_number > 999999 Then
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246: IF upper(column_name) = 'CAL_TYPE' OR

Line 250: IGS_GE_MSG_STACK.ADD;

246: IF upper(column_name) = 'CAL_TYPE' OR
247: column_name is null Then
248: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254: IF upper(column_name) = 'UNIT_CD' OR

Line 258: IGS_GE_MSG_STACK.ADD;

254: IF upper(column_name) = 'UNIT_CD' OR
255: column_name is null Then
256: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
262:

Line 331: IGS_GE_MSG_STACK.ADD;

327: Open cur_rowid;
328: Fetch cur_rowid INTO lv_rowid;
329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAI_FK');
331: IGS_GE_MSG_STACK.ADD;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;

Line 365: IGS_GE_MSG_STACK.ADD;

361: Open cur_rowid;
362: Fetch cur_rowid INTO lv_rowid;
363: IF (cur_rowid%FOUND) THEN
364: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAP_FK');
365: IGS_GE_MSG_STACK.ADD;
366: Close cur_rowid;
367: App_Exception.Raise_Exception;
368: Return;
369: END IF;

Line 424: IGS_GE_MSG_STACK.ADD;

420: new_references.ass_id ,
421: new_references.uai_sequence_number
422: ) THEN
423: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427: Check_Constraints;
428: Check_Parent_Existance;

Line 448: IGS_GE_MSG_STACK.ADD;

444: new_references.ass_id ,
445: new_references.uai_sequence_number
446: ) THEN
447: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451: Check_Constraints;
452: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 517: IGS_GE_MSG_STACK.ADD;

513: X_PROGRAM_UPDATE_DATE := SYSDATE;
514: end if;
515: else
516: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
517: IGS_GE_MSG_STACK.ADD;
518: app_exception.raise_exception;
519: end if;
520: --
521: Before_DML(

Line 612: IGS_GE_MSG_STACK.ADD;

608: open c1;
609: fetch c1 into tlinfo;
610: if (c1%notfound) then
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: IGS_GE_MSG_STACK.ADD;
613: close c1;
614: app_exception.raise_exception;
615: return;
616: end if;

Line 626: IGS_GE_MSG_STACK.ADD;

622: ) then
623: null;
624: else
625: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
626: IGS_GE_MSG_STACK.ADD;
627: app_exception.raise_exception;
628: end if;
629: return;
630: end LOCK_ROW;

Line 667: IGS_GE_MSG_STACK.ADD;

663: X_LAST_UPDATE_LOGIN := -1;
664: end if;
665: else
666: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
667: IGS_GE_MSG_STACK.ADD;
668: app_exception.raise_exception;
669: end if;
670: Before_DML(
671: p_action=>'UPDATE',