[Home] [Help]
84: OPEN cur_old_ref_values;
85: FETCH cur_old_ref_values INTO old_references;
86: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
87: CLOSE cur_old_ref_values;
88: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
89: igs_ge_msg_stack.add;
90: app_exception.raise_exception;
91: RETURN;
92: END IF;
182: IF upper(Column_name)= 'STATUS' or Column_name is null Then
183: IF new_references.status NOT IN ('TODO',
184: 'SUCCESS',
185: 'ERROR') THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;
190: END IF;
191:
192: IF upper(Column_name)= 'EXCHANGE_RATE' or Column_name is null Then
193: If new_references.EXCHANGE_RATE <= 0 then
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: End if;
198: End if;
217: || ,new_references.fee_cal_type
218: || ,new_references.person_id
219: || ,new_references.fee_type
220: || ) THEN
221: || fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
222: || igs_ge_msg_stack.add;
223: || app_exception.raise_exception;
224: || END IF;
225: */ ----Commented whole code as not needed anymore as indicated in Ancillary and External Charges by nshee
316: ELSE
317: IF NOT IGS_FI_ACC_PKG.Get_PK_For_Validation (
318: new_references.override_cr_rev_account_cd
319: ) THEN
320: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END IF;
324: END IF;
328: ELSE
329: IF NOT IGS_FI_ACC_PKG.Get_PK_For_Validation (
330: new_references.override_dr_rec_account_cd
331: ) THEN
332: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END IF;
336: END IF;
342: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
343: 'STATUS',
344: new_references.status
345: )THEN
346: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
347: IGS_GE_MSG_STACK.ADD;
348: App_Exception.Raise_Exception;
349: END IF;
350: END Check_Parent_Existance;
472: -- Call all the procedures related to Before Insert.
473: Null;
474: IF get_pk_for_validation(
475: new_references.external_fee_id) THEN
476: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480: -- check_uniqueness;
492: ELSIF (p_action = 'VALIDATE_INSERT') THEN
493: -- Call all the procedures related to Before Insert.
494: IF get_pk_for_validation (
495: new_references.external_fee_id) THEN
496: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
497: igs_ge_msg_stack.add;
498: app_exception.raise_exception;
499: END IF;
500: -- check_uniqueness;
634: ELSE
635: x_program_update_date := SYSDATE;
636: END IF;
637: ELSE
638: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
639: igs_ge_msg_stack.add;
640: app_exception.raise_exception;
641: end if;
642: SELECT igs_fi_ext_int_s.NEXTVAL
916: BEGIN
917: OPEN c1;
918: FETCH c1 INTO tlinfo;
919: IF (c1%notfound) THEN
920: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
921: igs_ge_msg_stack.add;
922: CLOSE c1;
923: app_exception.raise_exception;
924: RETURN;
976: AND ((tlinfo.error_msg = x_error_msg) OR ((tlinfo.error_msg IS NULL) AND (x_error_msg IS NULL)))
977: ) THEN
978: NULL;
979: ELSE
980: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
981: igs_ge_msg_stack.add;
982: app_exception.raise_exception;
983: END IF;
984: RETURN;
1064: IF x_last_update_login IS NULL THEN
1065: x_last_update_login := -1;
1066: END IF;
1067: ELSE
1068: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1069: igs_ge_msg_stack.add;
1070: app_exception.raise_exception;
1071: END IF;
1072: before_dml(