DBA Data[Home] [Help]

APPS.IGS_AS_GRD_SCHEMA_PKG dependencies on IGS_GE_MSG_STACK

Line 60: IGS_GE_MSG_STACK.ADD;

56: OPEN cur_old_ref_values;
57: FETCH cur_old_ref_values INTO old_references;
58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
60: IGS_GE_MSG_STACK.ADD;
61: CLOSE cur_old_ref_values;
62: APP_EXCEPTION.RAISE_EXCEPTION;
63: RETURN;
64: END IF;

Line 125: IGS_GE_MSG_STACK.ADD;

121: IF igs_ad_val_edtl.genp_val_strt_end_dt(new_references.start_dt,
122: new_references.end_dt,
123: v_message_name) = FALSE THEN
124: FND_MESSAGE.SET_NAME('IGS',v_message_name);
125: IGS_GE_MSG_STACK.ADD;
126: APP_EXCEPTION.RAISE_EXCEPTION;
127: END IF;
128: END IF;
129: END IF;

Line 156: IGS_GE_MSG_STACK.ADD;

152: new_references.start_dt,
153: new_references.end_dt,
154: v_message_name) = FALSE THEN
155: FND_MESSAGE.SET_NAME('IGS',v_message_name);
156: IGS_GE_MSG_STACK.ADD;
157: APP_EXCEPTION.RAISE_EXCEPTION;
158: END IF;
159:
160:

Line 186: IGS_GE_MSG_STACK.ADD;

182: OPEN cur_rowid;
183: FETCH cur_rowid INTO lv_rowid;
184: IF (cur_rowid%FOUND) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_AS_GS_LOV_FK');
186: IGS_GE_MSG_STACK.ADD;
187: CLOSE cur_rowid;
188: APP_EXCEPTION.RAISE_EXCEPTION;
189:
190: RETURN;

Line 384: IGS_GE_MSG_STACK.ADD;

380: IF Get_PK_For_Validation (
381: new_references.grading_schema_cd ,
382: new_references.version_number) THEN
383: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: APP_EXCEPTION.RAISE_EXCEPTION;
386: END IF;
387:
388: Check_Constraints;

Line 404: IGS_GE_MSG_STACK.ADD;

400: IF Get_PK_For_Validation (
401: new_references.grading_schema_cd ,
402: new_references.version_number) THEN
403: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
404: IGS_GE_MSG_STACK.ADD;
405: APP_EXCEPTION.RAISE_EXCEPTION;
406: END IF;
407:
408: Check_Constraints;

Line 494: IGS_GE_MSG_STACK.ADD;

490: X_LAST_UPDATE_LOGIN := -1;
491: END IF;
492: ELSE
493: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: APP_EXCEPTION.RAISE_EXCEPTION;
496: END IF;
497: Before_DML(
498: p_action=>'INSERT',

Line 684: IGS_GE_MSG_STACK.ADD;

680: OPEN c1;
681: FETCH c1 INTO tlinfo;
682: IF (c1%NOTFOUND) THEN
683: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
684: IGS_GE_MSG_STACK.ADD;
685: APP_EXCEPTION.RAISE_EXCEPTION;
686: CLOSE c1;
687: RETURN;
688: END IF;

Line 770: IGS_GE_MSG_STACK.ADD;

766: ) THEN
767: NULL;
768: ELSE
769: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
770: IGS_GE_MSG_STACK.ADD;
771: APP_EXCEPTION.RAISE_EXCEPTION;
772: END IF;
773: RETURN;
774: END LOCK_ROW;

Line 828: IGS_GE_MSG_STACK.ADD;

824: X_LAST_UPDATE_LOGIN := -1;
825: END IF;
826: ELSE
827: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
828: IGS_GE_MSG_STACK.ADD;
829: APP_EXCEPTION.RAISE_EXCEPTION;
830: END IF;
831: Before_DML(
832: p_action=>'UPDATE',

Line 1036: IGS_GE_MSG_STACK.ADD;

1032: IF UPPER(column_name) = 'GRADING_SCHEMA_CD' OR
1033: column_name IS NULL THEN
1034: IF new_references.GRADING_SCHEMA_CD <> UPPER(new_references.GRADING_SCHEMA_CD) THEN
1035: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
1036: IGS_GE_MSG_STACK.ADD;
1037: APP_EXCEPTION.RAISE_EXCEPTION;
1038: END IF;
1039: END IF;
1040: IF UPPER(column_name) = 'VERSION_NUMBER' OR

Line 1044: IGS_GE_MSG_STACK.ADD;

1040: IF UPPER(column_name) = 'VERSION_NUMBER' OR
1041: column_name IS NULL THEN
1042: IF new_references.VERSION_NUMBER < 0 OR new_references.VERSION_NUMBER > 999 THEN
1043: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
1044: IGS_GE_MSG_STACK.ADD;
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: END IF;
1047: END IF;
1048: