DBA Data[Home] [Help]

APPS.IGS_AD_SPL_ADM_CAT_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;
55:

Line 124: app_exception.raise_exception;

120: ,new_references.spl_adm_cat
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;
127: PROCEDURE Check_Parent_Existance AS
128: /*************************************************************

Line 158: App_Exception.Raise_Exception;

154: new_references.sequence_number
155: ) THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:
161: IF (((old_references.spl_adm_cat = new_references.spl_adm_cat)) OR
162: ((new_references.spl_adm_cat IS NULL))) THEN

Line 171: App_Exception.Raise_Exception;

167: 'N'
168: ) THEN
169: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173:
174: END Check_Parent_Existance;
175:

Line 291: App_Exception.Raise_Exception;

287: IF (cur_rowid%FOUND) THEN
288: Close cur_rowid;
289: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACAI_FK');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: Return;
293: END IF;
294: Close cur_rowid;
295:

Line 328: App_Exception.Raise_Exception;

324: IF (cur_rowid%FOUND) THEN
325: Close cur_rowid;
326: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACDC_FK');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: Return;
330: END IF;
331: Close cur_rowid;
332:

Line 393: App_Exception.Raise_Exception;

389: IF Get_Pk_For_Validation(
390: new_references.spl_adm_cat_id) THEN
391: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;
395: Check_Uniqueness;
396: Check_Constraints;
397: Check_Parent_Existance;

Line 413: App_Exception.Raise_Exception;

409: IF Get_PK_For_Validation (
410: new_references.spl_adm_cat_id) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Uniqueness;
416: Check_Constraints;
417: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 503: app_exception.raise_exception;

499: end if;
500: else
501: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
502: IGS_GE_MSG_STACK.ADD;
503: app_exception.raise_exception;
504: end if;
505:
506: X_SPL_ADM_CAT_ID := -1;
507: Before_DML(

Line 577: app_exception.raise_exception;

573: -- that the ownerof policy function does not have privilege to access.
574: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
575: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: ELSE
579: RAISE;
580: END IF;
581: END INSERT_ROW;

Line 618: app_exception.raise_exception;

614: if (c1%notfound) then
615: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
616: IGS_GE_MSG_STACK.ADD;
617: close c1;
618: app_exception.raise_exception;
619: return;
620: end if;
621: close c1;
622: if ( (tlinfo.PERSON_ID = X_PERSON_ID)

Line 632: app_exception.raise_exception;

628: null;
629: else
630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
631: IGS_GE_MSG_STACK.ADD;
632: app_exception.raise_exception;
633: end if;
634: return;
635: end LOCK_ROW;
636: Procedure UPDATE_ROW (

Line 678: app_exception.raise_exception;

674: end if;
675: else
676: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
677: IGS_GE_MSG_STACK.ADD;
678: app_exception.raise_exception;
679: end if;
680: Before_DML(
681: p_action=>'UPDATE',
682: x_rowid=>X_ROWID,

Line 713: app_exception.raise_exception;

709: igs_ge_msg_stack.add;
710: IF (x_mode = 'S') THEN
711: igs_sc_gen_001.unset_ctx('R');
712: END IF;
713: app_exception.raise_exception;
714: end if;
715: IF (x_mode = 'S') THEN
716: igs_sc_gen_001.unset_ctx('R');
717: END IF;

Line 738: app_exception.raise_exception;

734: -- that the ownerof policy function does not have privilege to access.
735: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
736: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
737: IGS_GE_MSG_STACK.ADD;
738: app_exception.raise_exception;
739: ELSE
740: RAISE;
741: END IF;
742: end UPDATE_ROW;

Line 825: app_exception.raise_exception;

821: igs_ge_msg_stack.add;
822: IF (x_mode = 'S') THEN
823: igs_sc_gen_001.unset_ctx('R');
824: END IF;
825: app_exception.raise_exception;
826: end if;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.unset_ctx('R');
829: END IF;

Line 849: app_exception.raise_exception;

845: -- that the ownerof policy function does not have privilege to access.
846: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
847: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
848: IGS_GE_MSG_STACK.ADD;
849: app_exception.raise_exception;
850: ELSE
851: RAISE;
852: END IF;
853: end DELETE_ROW;