DBA Data[Home] [Help]

APPS.IGS_PS_GRP_PKG dependencies on IGS_GE_MSG_STACK

Line 41: IGS_GE_MSG_STACK.ADD;

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

Line 88: IGS_GE_MSG_STACK.ADD;

84: IF IGS_PS_VAL_CGR.crsp_val_cgr_type (
85: new_references.course_group_type,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: -- Validate the responsible org IGS_PS_UNIT.

Line 105: IGS_GE_MSG_STACK.ADD;

101: new_references.responsible_org_unit_cd,
102: new_references.responsible_ou_start_dt,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109:

Line 134: IGS_GE_MSG_STACK.ADD;

130: IF upper(column_name) = 'CLOSED_IND' OR
131: column_name is null Then
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: END IF;
138:

Line 143: IGS_GE_MSG_STACK.ADD;

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

Line 152: IGS_GE_MSG_STACK.ADD;

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

Line 170: IGS_GE_MSG_STACK.ADD;

166: IF NOT IGS_PS_GRP_TYPE_PKG.Get_PK_For_Validation (
167: new_references.course_group_type
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 186: IGS_GE_MSG_STACK.ADD;

182: new_references.responsible_org_unit_cd,
183: new_references.responsible_ou_start_dt
184: ) THEN
185: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190:

Line 239: IGS_GE_MSG_STACK.ADD;

235: Fetch cur_rowid INTO lv_rowid;
236: IF (cur_rowid%FOUND) THEN
237: Close cur_rowid;
238: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CGR_CGT_FK');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;
243: Close cur_rowid;

Line 267: IGS_GE_MSG_STACK.ADD;

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

Line 321: IGS_GE_MSG_STACK.ADD;

317: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
318: IF Get_PK_For_Validation (
319: new_references.course_group_cd) THEN
320: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END IF;
324: Check_Constraints;
325: Check_Parent_Existance;

Line 335: IGS_GE_MSG_STACK.ADD;

331: ELSIF (p_action = 'VALIDATE_INSERT') THEN
332: IF Get_PK_For_Validation (
333: new_references.course_group_cd) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 388: IGS_GE_MSG_STACK.ADD;

384: X_LAST_UPDATE_LOGIN := -1;
385: end if;
386: else
387: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
388: IGS_GE_MSG_STACK.ADD;
389: app_exception.raise_exception;
390: end if;
391: Before_DML (
392: p_action => 'INSERT',

Line 476: IGS_GE_MSG_STACK.ADD;

472: fetch c1 into tlinfo;
473: if (c1%notfound) then
474: close c1;
475: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
476: IGS_GE_MSG_STACK.ADD;
477: app_exception.raise_exception;
478: return;
479: end if;
480: close c1;

Line 495: IGS_GE_MSG_STACK.ADD;

491: ) then
492: null;
493: else
494: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
495: IGS_GE_MSG_STACK.ADD;
496: app_exception.raise_exception;
497: end if;
498: return;
499: end LOCK_ROW;

Line 531: IGS_GE_MSG_STACK.ADD;

527: X_LAST_UPDATE_LOGIN := -1;
528: end if;
529: else
530: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
531: IGS_GE_MSG_STACK.ADD;
532: app_exception.raise_exception;
533: end if;
534:
535: Before_DML (