DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_OFR_NOTE_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

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

Line 83: IGS_GE_MSG_STACK.ADD;

79:
80: IF Upper(Column_Name)='CAL_TYPE' OR Column_Name IS NULL Then
81: IF New_References.Cal_Type <> UPPER(New_References.Cal_Type) Then
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87:

Line 91: IGS_GE_MSG_STACK.ADD;

87:
88: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then
89: IF New_References.Crs_Note_Type <> UPPER(New_References.Crs_Note_Type) Then
90: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95:

Line 100: IGS_GE_MSG_STACK.ADD;

96:
97: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
98: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:

Line 118: IGS_GE_MSG_STACK.ADD;

114: ELSE
115: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
116: new_references.crs_note_type) THEN
117: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121:
122: END IF;

Line 131: IGS_GE_MSG_STACK.ADD;

127: ELSE
128: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
129: new_references.reference_number) THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134:
135: END IF;

Line 150: IGS_GE_MSG_STACK.ADD;

146: new_references.unit_cd,
147: new_references.version_number,
148: new_references.cal_type) THEN
149: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
154: END IF;

Line 208: IGS_GE_MSG_STACK.ADD;

204: Fetch cur_rowid INTO lv_rowid;
205: IF (cur_rowid%FOUND) THEN
206: Close cur_rowid;
207: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UON_CNT_FK');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: Return;
211: END IF;
212: Close cur_rowid;

Line 234: IGS_GE_MSG_STACK.ADD;

230: Fetch cur_rowid INTO lv_rowid;
231: IF (cur_rowid%FOUND) THEN
232: Close cur_rowid;
233: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UON_NOTE_FK');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: Return;
237: END IF;
238: Close cur_rowid;

Line 264: IGS_GE_MSG_STACK.ADD;

260: Fetch cur_rowid INTO lv_rowid;
261: IF (cur_rowid%FOUND) THEN
262: Close cur_rowid;
263: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UON_UO_FK');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: Return;
267: END IF;
268: Close cur_rowid;

Line 310: IGS_GE_MSG_STACK.ADD;

306: New_References.version_number,
307: New_References.cal_type,
308: New_References.reference_number) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: Check_Constraints;
314: Check_Parent_Existance;

Line 326: IGS_GE_MSG_STACK.ADD;

322: New_References.version_number,
323: New_References.cal_type,
324: New_References.reference_number) THEN
325: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: Check_Constraints;
330: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 381: IGS_GE_MSG_STACK.ADD;

377: X_LAST_UPDATE_LOGIN := -1;
378: end if;
379: else
380: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
381: IGS_GE_MSG_STACK.ADD;
382: app_exception.raise_exception;
383: end if;
384:
385: Before_DML(

Line 458: IGS_GE_MSG_STACK.ADD;

454: fetch c1 into tlinfo;
455: if (c1%notfound) then
456: close c1;
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: return;
461: end if;
462: close c1;

Line 469: IGS_GE_MSG_STACK.ADD;

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

Line 503: IGS_GE_MSG_STACK.ADD;

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:
507: Before_DML(