DBA Data[Home] [Help]

APPS.IGS_FI_INVLN_INT_PKG dependencies on APP_EXCEPTION

Line 96: App_Exception.Raise_Exception;

92: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
93: Close cur_old_ref_values;
94: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: Return;
98: END IF;
99: Close cur_old_ref_values;
100:

Line 191: APP_EXCEPTION.RAISE_EXCEPTION;

187: IF UPPER(column_name) = 'ERROR_ACCOUNT' OR column_name IS NULL THEN
188: IF NVL(new_references.error_account,'N') NOT IN ('Y','N') THEN
189: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
190: IGS_GE_MSG_STACK.ADD;
191: APP_EXCEPTION.RAISE_EXCEPTION;
192: END IF;
193: END IF;
194:
195: END Check_Constraints;

Line 217: app_exception.raise_exception;

213: new_references.line_number
214: ) THEN
215: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
216: IGS_GE_MSG_STACK.ADD;
217: app_exception.raise_exception;
218: END IF;
219: END Check_Uniqueness ;
220:
221:

Line 283: App_Exception.Raise_Exception;

279: new_references.rev_account_cd
280: ) THEN
281: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286: IF ((old_references.rec_account_cd = new_references.rec_account_cd) OR
287: (new_references.rec_account_cd IS NULL)) THEN

Line 295: App_Exception.Raise_Exception;

291: new_references.rec_account_cd
292: ) THEN
293: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: END IF;
298:
299:

Line 309: App_Exception.Raise_Exception;

305: new_references.s_chg_method_type
306: ) THEN
307: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311:
312: IF (((old_references.posting_id = new_references.posting_id)) OR
313: ((new_references.posting_id IS NULL))) THEN

Line 320: app_exception.raise_exception;

316: new_references.posting_id
317: ) THEN
318: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: END IF;
322:
323: IF (((old_references.unit_type_id = new_references.unit_type_id)) OR
324: ((new_references.unit_type_id IS NULL))) THEN

Line 331: app_exception.raise_exception;

327: new_references.unit_type_id
328: ) THEN
329: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333:
334: END Check_Parent_Existance;
335:

Line 403: app_exception.raise_exception;

399: IF (cur_rowid%FOUND) THEN
400: CLOSE cur_rowid;
401: fnd_message.set_name ('IGS', 'IGS_FI_PINT_INLI_FK');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: RETURN;
405: END IF;
406: CLOSE cur_rowid;
407:

Line 438: app_exception.raise_exception;

434: IF (cur_rowid%FOUND) THEN
435: CLOSE cur_rowid;
436: fnd_message.set_name ('IGS', 'IGS_FI_INLI_UOO_FK');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: RETURN;
440: END IF;
441: CLOSE cur_rowid;
442:

Line 581: App_Exception.Raise_Exception;

577: IF Get_Pk_For_Validation(
578: new_references.invoice_lines_id) THEN
579: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
580: IGS_GE_MSG_STACK.ADD;
581: App_Exception.Raise_Exception;
582: END IF;
583: Check_Uniqueness;
584: Check_Constraints;
585: Check_Parent_Existance;

Line 600: App_Exception.Raise_Exception;

596: IF Get_PK_For_Validation (
597: new_references.invoice_lines_id) THEN
598: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END IF;
602: Check_Uniqueness;
603: Check_Constraints;
604: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 748: app_exception.raise_exception;

744: end if;
745: else
746: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
747: IGS_GE_MSG_STACK.ADD;
748: app_exception.raise_exception;
749: end if;
750:
751: SELECT
752: IGS_FI_INVLN_INT_S.nextval

Line 1066: app_exception.raise_exception;

1062: if (c1%notfound) then
1063: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1064: IGS_GE_MSG_STACK.ADD;
1065: close c1;
1066: app_exception.raise_exception;
1067: return;
1068: end if;
1069: close c1;
1070: if (

Line 1197: app_exception.raise_exception;

1193: null;
1194: ELSE
1195: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1196: IGS_GE_MSG_STACK.ADD;
1197: app_exception.raise_exception;
1198: END IF;
1199: RETURN;
1200: end LOCK_ROW;
1201:

Line 1306: app_exception.raise_exception;

1302: end if;
1303: else
1304: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1305: IGS_GE_MSG_STACK.ADD;
1306: app_exception.raise_exception;
1307: end if;
1308: Before_DML(
1309: p_action =>'UPDATE',
1310: x_rowid =>X_ROWID,