[Home] [Help]
41: Open cur_old_ref_values;
42: Fetch cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
44: Close cur_old_ref_values;
45: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: Return;
49: END IF;
99: new_references.grd_cal_type,
100: new_references.grd_ci_sequence_number,
101: new_references.ceremony_number,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS', v_message_name);
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
110: -- Validate venue is related to a location with a s_location_type of grd_ctr
111: IF IGS_GR_VAL_GC.grdp_val_ve_lot(
112: new_references.venue_cd,
113: v_message_name) = FALSE THEN
114: Fnd_Message.Set_Name('IGS', v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- Validate venue is not closed
118: -- Validate venue is not closed
119: IF IGS_GR_VAL_GC.assp_val_ve_closed(
120: new_references.venue_cd,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS', v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
137: new_references.ceremony_dai_sequence_number,
138: new_references.closing_dt_alias,
139: new_references.closing_dai_sequence_number,
140: v_message_name) = FALSE THEN
141: Fnd_Message.Set_Name('IGS', v_message_name);
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
174: NEW_REFERENCES.ceremony_dai_sequence_number,
175: NEW_REFERENCES.ceremony_start_time,
176: NEW_REFERENCES.ceremony_end_time,
177: v_message_name) = FALSE THEN
178: Fnd_Message.Set_Name('IGS', v_message_name);
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: v_rowid_saved := TRUE;
202: new_references.ceremony_dai_sequence_number,
203: new_references.grd_cal_type,
204: new_references.grd_ci_sequence_number
205: ) THEN
206: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
207: IGS_GE_MSG_STACK.ADD;
208: APP_EXCEPTION.RAISE_EXCEPTION;
209: END IF;
210:
225: new_references.closing_dai_sequence_number,
226: new_references.grd_cal_type,
227: new_references.grd_ci_sequence_number
228: ) THEN
229: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233:
242: IF NOT IGS_GR_CRMN_ROUND_PKG.Get_PK_For_Validation (
243: new_references.grd_cal_type,
244: new_references.grd_ci_sequence_number
245: ) THEN
246: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
247: IGS_GE_MSG_STACK.ADD;
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: END IF;
250:
256: ELSE
257: IF NOT IGS_GR_VENUE_PKG.Get_PK_For_Validation (
258: new_references.venue_cd
259: ) THEN
260: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
261: IGS_GE_MSG_STACK.ADD;
262: APP_EXCEPTION.RAISE_EXCEPTION;
263: END IF;
264:
305: END IF ;
306:
307: IF upper(Column_name) = 'CEREMONY_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
308: IF new_references.CEREMONY_DT_ALIAS<> upper(NEW_REFERENCES.CEREMONY_DT_ALIAS) then
309: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception ;
312: END IF;
313:
314: END IF ;
315:
316: IF upper(Column_name) = 'CLOSING_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
317: IF new_references.CLOSING_DT_ALIAS<> upper(NEW_REFERENCES.CLOSING_DT_ALIAS) then
318: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception ;
321: END IF;
322:
323: END IF ;
324:
325: IF upper(Column_name) = 'GRD_CAL_TYPE' OR COLUMN_NAME IS NULL THEN
326: IF new_references.GRD_CAL_TYPE<> upper(NEW_REFERENCES.GRD_CAL_TYPE) then
327: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception ;
330: END IF;
331:
332: END IF ;
333:
334: IF upper(Column_name) = 'VENUE_CD' OR COLUMN_NAME IS NULL THEN
335: IF new_references.VENUE_CD<> upper(NEW_REFERENCES.VENUE_CD) then
336: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception ;
339: END IF;
340:
340:
341: END IF ;
342: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
343: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 then
344: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
345: IGS_GE_MSG_STACK.ADD;
346: App_Exception.Raise_Exception ;
347: END IF;
348:
348:
349: END IF ;
350: IF upper(Column_name) = 'CEREMONY_NUMBER' OR COLUMN_NAME IS NULL THEN
351: IF new_references.CEREMONY_NUMBER < 0 OR new_references.CEREMONY_NUMBER > 999 then
352: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception ;
355: END IF;
356:
356:
357: END IF ;
358: IF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
359: IF new_references.CEREMONY_DAI_SEQUENCE_NUMBER < 1 OR new_references.CEREMONY_DAI_SEQUENCE_NUMBER > 999999 then
360: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception ;
363: END IF;
364:
364:
365: END IF ;
366: IF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
367: IF new_references.CLOSING_DAI_SEQUENCE_NUMBER < 1 OR new_references.CLOSING_DAI_SEQUENCE_NUMBER > 999999 then
368: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception ;
371: END IF;
372:
372:
373: END IF ;
374: IF upper(Column_name) = 'CEREMONY_FEE' OR COLUMN_NAME IS NULL THEN
375: IF new_references.CEREMONY_FEE < 0.00 OR new_references.CEREMONY_FEE > 999.99 then
376: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception ;
379: END IF;
380:
380:
381: END IF ;
382: IF upper(Column_name) = 'NUMBER_OF_GUESTS' OR COLUMN_NAME IS NULL THEN
383: IF new_references.NUMBER_OF_GUESTS < 0 OR new_references.NUMBER_OF_GUESTS > 999 then
384: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception ;
387: END IF;
388:
461: Open cur_rowid;
462: Fetch cur_rowid INTO lv_rowid;
463: IF (cur_rowid%FOUND) THEN
464: Close cur_rowid;
465: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_CEREMONY_DAI_FK');
466: IGS_GE_MSG_STACK.ADD;
467: App_Exception.Raise_Exception;
468: Return;
469: END IF;
489: Open cur_rowid;
490: Fetch cur_rowid INTO lv_rowid;
491: IF (cur_rowid%FOUND) THEN
492: Close cur_rowid;
493: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_CRD_FK');
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: Return;
497: END IF;
515: Open cur_rowid;
516: Fetch cur_rowid INTO lv_rowid;
517: IF (cur_rowid%FOUND) THEN
518: Close cur_rowid;
519: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GC_VE_FK');
520: IGS_GE_MSG_STACK.ADD;
521: App_Exception.Raise_Exception;
522: Return;
523: END IF;
579: NEW_REFERENCES.grd_cal_type,
580: NEW_REFERENCES.grd_ci_sequence_number,
581: NEW_REFERENCES.ceremony_number
582: ) THEN
583: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception;
586: END IF;
587:
601: NEW_REFERENCES.grd_cal_type,
602: NEW_REFERENCES.grd_ci_sequence_number,
603: NEW_REFERENCES.ceremony_number
604: ) THEN
605: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
606: IGS_GE_MSG_STACK.ADD;
607: App_Exception.Raise_Exception;
608: END IF;
609:
673: if X_LAST_UPDATE_LOGIN is NULL then
674: X_LAST_UPDATE_LOGIN := -1;
675: end if;
676: else
677: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
678: IGS_GE_MSG_STACK.ADD;
679: app_exception.raise_exception;
680: end if;
681:
790: open c1;
791: fetch c1 into tlinfo;
792: if (c1%notfound) then
793: close c1;
794: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
795: app_exception.raise_exception;
796: return;
797: end if;
798: close c1;
813:
814: ) then
815: null;
816: else
817: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
818: app_exception.raise_exception;
819: end if;
820: return;
821: end LOCK_ROW;
853: if X_LAST_UPDATE_LOGIN is NULL then
854: X_LAST_UPDATE_LOGIN := -1;
855: end if;
856: else
857: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
858: IGS_GE_MSG_STACK.ADD;
859: app_exception.raise_exception;
860: end if;
861: