DBA Data[Home] [Help]

APPS.IGS_FI_FND_SRC_RSTN_PKG dependencies on IGS_GE_MSG_STACK

Line 74: IGS_GE_MSG_STACK.ADD;

70: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
71:
72: Close cur_old_ref_values;
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76:
77:
78: Return;

Line 185: IGS_GE_MSG_STACK.ADD;

181:
182: v_message_name) = FALSE THEN
183:
184: Fnd_Message.Set_Name('IGS',v_message_name);
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187:
188: END IF;
189:

Line 201: IGS_GE_MSG_STACK.ADD;

197:
198: v_message_name) = FALSE THEN
199:
200: Fnd_Message.Set_Name('IGS',v_message_name);
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203:
204: END IF;
205:

Line 221: IGS_GE_MSG_STACK.ADD;

217:
218: v_message_name) = FALSE THEN
219:
220: Fnd_Message.Set_Name('IGS',v_message_name);
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223:
224: END IF;
225:

Line 320: IGS_GE_MSG_STACK.ADD;

316: IF new_references.restricted_ind <> 'Y' AND
317: new_references.restricted_ind <> 'N'
318: THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
324:

Line 330: IGS_GE_MSG_STACK.ADD;

326: IF new_references.dflt_ind <> 'Y' AND
327: new_references.dflt_ind <> 'N'
328: THEN
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: END IF;
334: IF upper(Column_Name) = 'COURSE_CD' OR

Line 338: IGS_GE_MSG_STACK.ADD;

334: IF upper(Column_Name) = 'COURSE_CD' OR
335: column_name is NULL THEN
336: IF new_references.course_cd <> UPPER(new_references.course_cd) THEN
337: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: App_Exception.Raise_Exception;
340: END IF;
341: END IF;
342: IF upper(Column_Name) = 'FUNDING_SOURCE' OR

Line 346: IGS_GE_MSG_STACK.ADD;

342: IF upper(Column_Name) = 'FUNDING_SOURCE' OR
343: column_name is NULL THEN
344: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
345: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: END IF;
349: END IF;
350:

Line 362: IGS_GE_MSG_STACK.ADD;

358: ELSIF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
359: new_references.funding_source
360: ) THEN
361: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
362: IGS_GE_MSG_STACK.ADD;
363: App_Exception.Raise_Exception;
364: END IF;
365: IF (((old_references.course_cd = new_references.course_cd) AND
366: (old_references.version_number = new_references.version_number)) OR

Line 375: IGS_GE_MSG_STACK.ADD;

371: new_references.course_cd,
372: new_references.version_number
373: ) THEN
374: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
375: IGS_GE_MSG_STACK.ADD;
376: App_Exception.Raise_Exception;
377: END IF;
378: END Check_Parent_Existance;
379:

Line 421: IGS_GE_MSG_STACK.ADD;

417: Fetch cur_rowid INTO lv_rowid;
418: IF (cur_rowid%FOUND) THEN
419: Close cur_rowid;
420: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FSR_FS_FK');
421: IGS_GE_MSG_STACK.ADD;
422: App_Exception.Raise_Exception;
423: Return;
424: END IF;
425: Close cur_rowid;

Line 469: IGS_GE_MSG_STACK.ADD;

465: IF (cur_rowid%FOUND) THEN
466:
467: Close cur_rowid;
468: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FSR_CRV_FK');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471:
472:
473: Return;

Line 543: IGS_GE_MSG_STACK.ADD;

539: IF Get_PK_For_Validation ( new_references.course_cd,
540: new_references.version_number,
541: new_references.funding_source ) THEN
542: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
543: IGS_GE_MSG_STACK.ADD;
544: App_Exception.Raise_Exception;
545: END IF;
546:
547: Check_Constraints;

Line 573: IGS_GE_MSG_STACK.ADD;

569: IF Get_PK_For_Validation ( new_references.course_cd,
570: new_references.version_number,
571: new_references.funding_source ) THEN
572: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
573: IGS_GE_MSG_STACK.ADD;
574: App_Exception.Raise_Exception;
575: END IF;
576: Check_Constraints;
577: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 614: IGS_GE_MSG_STACK.ADD;

610: X_LAST_UPDATE_LOGIN := -1;
611: end if;
612: else
613: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
614: IGS_GE_MSG_STACK.ADD;
615: app_exception.raise_exception;
616: end if;
617:
618:

Line 691: IGS_GE_MSG_STACK.ADD;

687: fetch c1 into tlinfo;
688: if (c1%notfound) then
689: close c1;
690: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
691: IGS_GE_MSG_STACK.ADD;
692: app_exception.raise_exception;
693: return;
694: end if;
695: close c1;

Line 703: IGS_GE_MSG_STACK.ADD;

699: ) then
700: null;
701: else
702: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
703: IGS_GE_MSG_STACK.ADD;
704: app_exception.raise_exception;
705: end if;
706: return;
707: end LOCK_ROW;

Line 737: IGS_GE_MSG_STACK.ADD;

733: X_LAST_UPDATE_LOGIN := -1;
734: end if;
735: else
736: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
737: IGS_GE_MSG_STACK.ADD;
738: app_exception.raise_exception;
739: end if;
740:
741: Before_DML(