DBA Data[Home] [Help]

APPS.IGS_PS_TCH_RSOV_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 46: IGS_GE_MSG_STACK.ADD;

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

Line 106: IGS_GE_MSG_STACK.ADD;

102: IF upper(column_name) = 'PERCENTAGE' OR
103: column_name is null Then
104: IF new_references.percentage < 000.01 OR new_references.percentage > 100.00 Then
105: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:

Line 115: IGS_GE_MSG_STACK.ADD;

111: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR
112: column_name is null Then
113: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:

Line 124: IGS_GE_MSG_STACK.ADD;

120: IF upper(column_name) = 'CAL_TYPE' OR
121: column_name is null Then
122: IF new_references.cal_type <> UPPER(new_references.cal_type) 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:

Line 133: IGS_GE_MSG_STACK.ADD;

129: IF upper(column_name) = 'LOCATION_CD' OR
130: column_name is null Then
131: IF new_references.location_cd <> UPPER(new_references.location_cd) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;
137:

Line 142: IGS_GE_MSG_STACK.ADD;

138: IF upper(column_name) = 'UNIT_CLASS' OR
139: column_name is null Then
140: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:

Line 151: IGS_GE_MSG_STACK.ADD;

147: IF upper(column_name) = 'UNIT_CD' OR
148: column_name is null Then
149: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155:

Line 172: IGS_GE_MSG_STACK.ADD;

168: new_references.org_unit_cd,
169: new_references.ou_start_dt
170: ) THEN
171: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176:

Line 200: IGS_GE_MSG_STACK.ADD;

196: new_references.location_cd,
197: new_references.unit_class
198: ) THEN
199: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204:

Line 268: IGS_GE_MSG_STACK.ADD;

264: Fetch cur_rowid INTO lv_rowid;
265: IF (cur_rowid%FOUND) THEN
266: Close cur_rowid;
267: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_OU_FK');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: Return;
271: END IF;
272: Close cur_rowid;

Line 304: IGS_GE_MSG_STACK.ADD;

300: Fetch cur_rowid INTO lv_rowid;
301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_UOO_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
308: Close cur_rowid;

Line 374: IGS_GE_MSG_STACK.ADD;

370: new_references.ou_start_dt,
371: new_references.hist_start_dt
372: ) THEN
373: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
378: Check_Parent_Existance;

Line 398: IGS_GE_MSG_STACK.ADD;

394: new_references.ou_start_dt,
395: new_references.hist_start_dt
396: ) THEN
397: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
398: IGS_GE_MSG_STACK.ADD;
399: App_Exception.Raise_Exception;
400: END IF;
401: Check_Constraints;
402: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 465: IGS_GE_MSG_STACK.ADD;

461: X_LAST_UPDATE_LOGIN := -1;
462: end if;
463: else
464: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: end if;
468:
469: Before_DML(

Line 576: IGS_GE_MSG_STACK.ADD;

572: fetch c1 into tlinfo;
573: if (c1%notfound) then
574: close c1;
575: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: return;
579: end if;
580: close c1;

Line 589: IGS_GE_MSG_STACK.ADD;

585: ) then
586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: app_exception.raise_exception;
591: end if;
592: return;
593: end LOCK_ROW;

Line 630: IGS_GE_MSG_STACK.ADD;

626: X_LAST_UPDATE_LOGIN := -1;
627: end if;
628: else
629: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
630: IGS_GE_MSG_STACK.ADD;
631: app_exception.raise_exception;
632: end if;
633: Before_DML(
634: p_action => 'UPDATE',