[Home] [Help]
49: Open cur_old_ref_values;
50: Fetch cur_old_ref_values INTO old_references;
51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
120: begin
121: IF Get_Uk_For_Validation (
122: new_references.uoo_id
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;
145: NULL;
146: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
147: new_references.uoo_id
148: ) THEN
149: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153:
251: Open cur_rowid;
252: Fetch cur_rowid INTO lv_rowid;
253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USLW_UOO_UFK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
317: -- Call all the procedures related to Before Insert.
318: Null;
319: IF Get_Pk_For_Validation(
320: new_references.unit_section_limit_waitlist_id) THEN
321: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: Check_Uniqueness;
337: ELSIF (p_action = 'VALIDATE_INSERT') THEN
338: -- Call all the procedures related to Before Insert.
339: IF Get_PK_For_Validation (
340: new_references.unit_section_limit_waitlist_id) THEN
341: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END IF;
345: Check_Uniqueness;
402: p_message_name=>l_message_name
403: ) = FALSE THEN
404:
405:
406: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
407: IGS_GE_MSG_STACK.ADD;
408: app_exception.raise_exception;
409: END IF;
410: END IF;
426: p_message_name=>l_message_name
427: ) = FALSE THEN
428:
429:
430: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: END IF;
434: END IF;
456: p_message_name=>l_message_name
457: ) = FALSE THEN
458:
459:
460: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
461: IGS_GE_MSG_STACK.ADD;
462: app_exception.raise_exception;
463: END IF;
464: END IF;
513: if X_LAST_UPDATE_LOGIN is NULL then
514: X_LAST_UPDATE_LOGIN := -1;
515: end if;
516: else
517: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
518: IGS_GE_MSG_STACK.ADD;
519: app_exception.raise_exception;
520: end if;
521: SELECT
625: BEGIN
626: OPEN c1;
627: FETCH c1 INTO tlinfo;
628: IF (c1%NOTFOUND) THEN
629: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
630: IGS_GE_MSG_STACK.ADD;
631: CLOSE c1;
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: RETURN;
656: AND (x_max_auditors_allowed IS NULL)))
657: ) THEN
658: NULL;
659: ELSE
660: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
661: IGS_GE_MSG_STACK.ADD;
662: APP_EXCEPTION.RAISE_EXCEPTION;
663: END IF;
664: RETURN;
706: if X_LAST_UPDATE_LOGIN is NULL then
707: X_LAST_UPDATE_LOGIN := -1;
708: end if;
709: else
710: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
711: IGS_GE_MSG_STACK.ADD;
712: app_exception.raise_exception;
713: end if;
714: Before_DML(