[Home] [Help]
54: Open cur_old_ref_values;
55: Fetch cur_old_ref_values INTO old_references;
56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
135: new_references.fee_cal_type,
136: new_references.fee_ci_sequence_number,
137: new_references.fee_cat,
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS',v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF; */
150: new_references.fee_type,
151: new_references.fee_cat,
152: new_references.course_cd,
153: v_message_name) = FALSE THEN
154: Fnd_Message.Set_Name('IGS',v_message_name);
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: -- Validate that course code can be specified.
167: new_references.s_transaction_type,
168: new_references.fee_cal_type,
169: new_references.fee_ci_sequence_number,
170: v_message_name) = FALSE THEN
171: Fnd_Message.Set_Name('IGS',v_message_name);
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
189: new_references.fee_cat,
190: new_references.effective_dt,
191: new_references.s_transaction_type,
192: v_message_name) = FALSE THEN
193: Fnd_Message.Set_Name('IGS',v_message_name);
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
201: IF IGS_FI_VAL_FAS.finp_val_fas_com (
202: new_references.s_transaction_type,
203: new_references.comments,
204: v_message_name) = FALSE THEN
205: Fnd_Message.Set_Name('IGS',v_message_name);
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
242: old_references.notification_dt,
243: new_references.logical_delete_dt,
244: old_references.logical_delete_dt,
245: v_message_name) = FALSE THEN
246: Fnd_Message.Set_Name('IGS',v_message_name);
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: END IF;
254: Begin
255: IF Get_UK_For_Validation (
256: new_references.transaction_id
257: ) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: End Check_Uniqueness;
303: IF upper(column_name) = 'COURSE_CD' OR
304: column_name is null Then
305: IF new_references.COURSE_CD <>
306: UPPER(new_references.COURSE_CD) Then
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: END IF;
312: IF upper(column_name) = 'CURRENCY_CD' OR
313: column_name is null Then
314: IF new_references.CURRENCY_CD <>
315: UPPER(new_references.CURRENCY_CD) Then
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: END IF;
321: IF upper(column_name) = 'FEE_CAL_TYPE' OR
322: column_name is null Then
323: IF new_references.FEE_CAL_TYPE <>
324: UPPER(new_references.FEE_CAL_TYPE) Then
325: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: END IF;
330: IF upper(column_name) = 'S_TRANSACTION_TYPE' OR
331: column_name is null Then
332: IF new_references.S_TRANSACTION_TYPE <>
333: UPPER(new_references.S_TRANSACTION_TYPE) Then
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: END IF;
340: IF upper(column_name) = 'TRANSACTION_ID' OR
341: column_name is null Then
342: IF new_references.transaction_id < 1 OR
343: new_references.transaction_id > 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: END IF;
349: IF upper(column_name) = 'CHG_ELEMENTS' OR
350: column_name is null Then
351: IF new_references.chg_elements < 0 OR
352: new_references.chg_elements > 9999.999 Then
353: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: END IF;
357: END IF;
358: IF upper(column_name) = 'EXCHANGE_RATE' OR
359: column_name is null Then
360: IF new_references.exchange_rate < 0.0001 OR
361: new_references.exchange_rate > 9999.9999 Then
362: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: END IF;
367: IF upper(column_name) = 'TRANSACTION_AMOUNT' OR
368: column_name is null Then
369: IF new_references.transaction_amount < -999990.00 OR
370: new_references.transaction_amount > 999990.00 Then
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375: END IF;
376: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR
377: column_name is null Then
378: IF new_references.fee_ci_sequence_number < 1 OR
379: new_references.fee_ci_sequence_number > 999999 Then
380: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception;
383: END IF;
384: END IF;
408: ELSE
409: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
410: new_references.course_cd
411: ) THEN
412: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: App_Exception.Raise_Exception;
415: END IF;
416: END IF;
430: new_references.fee_cal_type,
431: new_references.fee_ci_sequence_number,
432: new_references.fee_type
433: ) THEN
434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438: END IF;
448: new_references.fee_type,
449: new_references.fee_cal_type,
450: new_references.fee_ci_sequence_number
451: ) THEN
452: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception;
455: END IF;
456: END IF;
460: ELSE
461: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
462: new_references.person_id
463: ) THEN
464: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467: END IF;
468: END IF;
473: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
474: 'TRANSACTION_TYPE',
475: new_references.s_transaction_type
476: ) THEN
477: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
478: IGS_GE_MSG_STACK.ADD;
479: App_Exception.Raise_Exception;
480: END IF;
481: END IF;
541: Open cur_rowid;
542: Fetch cur_rowid INTO lv_rowid;
543: IF (cur_rowid%FOUND) THEN
544: Close cur_rowid;
545: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_CRS_FK');
546: IGS_GE_MSG_STACK.ADD;
547: App_Exception.Raise_Exception;
548: Return;
549: END IF;
563: Open cur_rowid;
564: Fetch cur_rowid INTO lv_rowid;
565: IF (cur_rowid%FOUND) THEN
566: Close cur_rowid;
567: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_PE_FK');
568: IGS_GE_MSG_STACK.ADD;
569: App_Exception.Raise_Exception;
570: Return;
571: END IF;
584: Open cur_rowid;
585: Fetch cur_rowid INTO lv_rowid;
586: IF (cur_rowid%FOUND) THEN
587: Close cur_rowid;
588: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_STRTY_FK');
589: IGS_GE_MSG_STACK.ADD;
590: App_Exception.Raise_Exception;
591: Return;
592: END IF;
668: IF Get_PK_For_Validation (
669: new_references.person_id ,
670: new_references.transaction_id
671: ) THEN
672: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
673: IGS_GE_MSG_STACK.ADD;
674: App_Exception.Raise_Exception;
675: END IF;
676: Check_Constraints;
691: IF Get_PK_For_Validation (
692: new_references.person_id ,
693: new_references.transaction_id
694: ) THEN
695: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
696: IGS_GE_MSG_STACK.ADD;
697: App_Exception.Raise_Exception;
698: END IF;
699: Check_Constraints;
813: else
814: X_PROGRAM_UPDATE_DATE := SYSDATE;
815: end if;
816: else
817: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
818: IGS_GE_MSG_STACK.ADD;
819: app_exception.raise_exception;
820: end if;
821: ---added by syam on 23-aug-2000
965: open c1;
966: fetch c1 into tlinfo;
967: if (c1%notfound) then
968: close c1;
969: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
970: IGS_GE_MSG_STACK.ADD;
971: app_exception.raise_exception;
972: return;
973: end if;
1029: AND (X_COMMENTS is null)))
1030: ) then
1031: null;
1032: else
1033: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1034: IGS_GE_MSG_STACK.ADD;
1035: app_exception.raise_exception;
1036: end if;
1037: return;
1127: else
1128: X_PROGRAM_UPDATE_DATE := SYSDATE;
1129: end if;
1130: else
1131: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1132: IGS_GE_MSG_STACK.ADD;
1133: app_exception.raise_exception;
1134: end if;
1135: update IGS_FI_FEE_AS_ALL set