DBA Data[Home] [Help]

APPS.IGS_AD_OU_STAT_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 79: IGS_GE_MSG_STACK.ADD;

75: IF IGS_AD_VAL_AUOS.admp_val_saos_clsd(
76: new_references.s_adm_outcome_status,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN

Line 85: IGS_GE_MSG_STACK.ADD;

81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
84: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END BeforeRowInsertUpdate1;
89:

Line 119: IGS_GE_MSG_STACK.ADD;

115:
116: IF upper(Column_name) = 'ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
117: IF new_references.ADM_OUTCOME_STATUS<> upper(new_references.ADM_OUTCOME_STATUS) then
118: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception ;
121: END IF;
122:
123: END IF ;

Line 128: IGS_GE_MSG_STACK.ADD;

124:
125: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
126: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131:
132: IF new_references.CLOSED_IND not in ('Y','N') then

Line 134: IGS_GE_MSG_STACK.ADD;

130: END IF;
131:
132: IF new_references.CLOSED_IND not in ('Y','N') 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:
138: END IF ;

Line 144: IGS_GE_MSG_STACK.ADD;

140:
141: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
142: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
143: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception ;
146: END IF;
147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then

Line 150: IGS_GE_MSG_STACK.ADD;

146: END IF;
147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception ;
152: END IF;
153:
154: END IF ;

Line 159: IGS_GE_MSG_STACK.ADD;

155:
156: IF upper(Column_name) = 'S_ADM_OUTCOME_STATUS' OR COLUMN_NAME IS NULL THEN
157: IF new_references.S_ADM_OUTCOME_STATUS<> upper(new_references.S_ADM_OUTCOME_STATUS) then
158: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception ;
161: END IF;
162:
163: END IF ;

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
176: 'ADM_OUTCOME_STATUS', new_references.s_adm_outcome_status
177: ) THEN
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:

Line 253: IGS_GE_MSG_STACK.ADD;

249: Fetch cur_rowid INTO lv_rowid;
250: IF (cur_rowid%FOUND) THEN
251: Close cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOS_SLV_FK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: Return;
256: END IF;
257: Close cur_rowid;

Line 299: IGS_GE_MSG_STACK.ADD;

295:
296: IF Get_PK_For_Validation (
297: new_references.adm_outcome_status ) THEN
298: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: END IF;
302: Check_Constraints;
303: Check_Parent_Existance;

Line 317: IGS_GE_MSG_STACK.ADD;

313: IF Get_PK_For_Validation (
314: new_references.adm_outcome_status
315: ) THEN
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Constraints;
321: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 369: IGS_GE_MSG_STACK.ADD;

365: X_LAST_UPDATE_LOGIN := -1;
366: end if;
367: else
368: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
369: IGS_GE_MSG_STACK.ADD;
370: app_exception.raise_exception;
371: end if;
372:
373: Before_DML(

Line 452: IGS_GE_MSG_STACK.ADD;

448: fetch c1 into tlinfo;
449: if (c1%notfound) then
450: close c1;
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: IGS_GE_MSG_STACK.ADD;
453: app_exception.raise_exception;
454: return;
455: end if;
456: close c1;

Line 466: IGS_GE_MSG_STACK.ADD;

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

Line 500: IGS_GE_MSG_STACK.ADD;

496: X_LAST_UPDATE_LOGIN := -1;
497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503:
504: