[Home] [Help]
91: Open cur_old_ref_values;
92: Fetch cur_old_ref_values INTO old_references;
93: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
94: Close cur_old_ref_values;
95: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: Return;
99: END IF;
239: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
240: 'IGS_FI_WAIVER_REASON',
241: new_references.waiver_reason
242: )THEN
243: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247:
251: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
252: 'STATUS',
253: new_references.status
254: ) THEN
255: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259:
263: ELSIF NOT Igs_lookups_view_Pkg.Get_PK_For_Validation (
264: 'TRANSACTION_TYPE',
265: new_references.transaction_type
266: ) THEN
267: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: END IF;
271:
274: NULL;
275: ELSIF NOT igs_fi_bill_pkg.get_pk_for_validation (
276: new_references.bill_id
277: ) THEN
278: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: END IF;
282:
295: new_references.fee_cal_type,
296: new_references.fee_ci_sequence_number,
297: new_references.waiver_name
298: ) THEN
299: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303:
403: OPEN cur_rowid;
404: FETCH cur_rowid INTO lv_rowid;
405: IF (cur_rowid%FOUND) THEN
406: CLOSE cur_rowid;
407: fnd_message.set_name ('IGS', 'IGS_FI_INVI_FBLLA_FK');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: RETURN;
411: END IF;
540: -- Call all the procedures related to Before Insert.
541: Null;
542: IF Get_Pk_For_Validation(
543: new_references.invoice_id) THEN
544: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
545: IGS_GE_MSG_STACK.ADD;
546: App_Exception.Raise_Exception;
547: END IF;
548: Check_Constraints;
557: ELSIF (p_action = 'VALIDATE_INSERT') THEN
558: -- Call all the procedures related to Before Insert.
559: IF Get_PK_For_Validation (
560: new_references.invoice_id) THEN
561: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
562: IGS_GE_MSG_STACK.ADD;
563: App_Exception.Raise_Exception;
564: END IF;
565: Check_Constraints;
704: else
705: X_PROGRAM_UPDATE_DATE:=SYSDATE;
706: end if;
707: else
708: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
709: IGS_GE_MSG_STACK.ADD;
710: app_exception.raise_exception;
711: end if;
712:
995:
996: OPEN c1;
997: FETCH c1 INTO tlinfo;
998: IF (c1%notfound) THEN
999: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1000: igs_ge_msg_stack.add;
1001: CLOSE c1;
1002: app_exception.raise_exception;
1003: RETURN;
1046: AND ((tlinfo.waiver_name = x_waiver_name) OR ((tlinfo.waiver_name IS NULL) AND (X_waiver_name IS NULL)))
1047: ) THEN
1048: NULL;
1049: ELSE
1050: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1051: igs_ge_msg_stack.add;
1052: app_exception.raise_exception;
1053: END IF;
1054:
1150: else
1151: X_PROGRAM_UPDATE_DATE:=SYSDATE;
1152: end if;
1153: else
1154: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1155: IGS_GE_MSG_STACK.ADD;
1156: app_exception.raise_exception;
1157: end if;
1158: Before_DML(