DBA Data[Home] [Help]

APPS.IGS_CA_DA_INST_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

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

Line 108: APP_EXCEPTION.RAISE_EXCEPTION;

104: v_message_name) = TRUE
105: THEN
106: Fnd_Message.Set_Name('IGS',v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: APP_EXCEPTION.RAISE_EXCEPTION;
109: END IF;
110: END IF;
111: END IF;
112: END BeforeRowInsertUpdateDelete1;

Line 150: APP_EXCEPTION.RAISE_EXCEPTION;

146: v_message_name) = FALSE
147: THEN
148: Fnd_Message.Set_Name('IGS',v_message_name);
149: IGS_GE_MSG_STACK.ADD;
150: APP_EXCEPTION.RAISE_EXCEPTION;
151: END IF;
152: IF p_inserting
153: THEN
154: -- Validate date alias instance date alias

Line 161: APP_EXCEPTION.RAISE_EXCEPTION;

157: v_message_name) = FALSE
158: THEN
159: Fnd_Message.Set_Name('IGS',v_message_name);
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163: END IF;
164: END IF;
165: END AfterStmtInsertUpdateDelete3;

Line 185: App_Exception.Raise_Exception;

181: if upper(column_name) = 'CAL_TYPE' or column_name is null Then
182: if new_references.cal_type <> UPPER( new_references.cal_type) then
183: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: end if;
187: end if;
188: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
189: if new_references.dt_alias <> UPPER( new_references.dt_alias) then

Line 192: App_Exception.Raise_Exception;

188: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
189: if new_references.dt_alias <> UPPER( new_references.dt_alias) then
190: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: end if;
194: end if;
195:
196: END Check_Constraints ;

Line 214: App_Exception.Raise_Exception;

210: new_references.ci_sequence_number
211: ) THEN
212: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
217: IF (((old_references.dt_alias = new_references.dt_alias)) OR
218: ((new_references.dt_alias IS NULL))) THEN

Line 226: App_Exception.Raise_Exception;

222: new_references.dt_alias
223: ) THEN
224: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:
230: END Check_Parent_Existance;

Line 385: App_Exception.Raise_Exception;

381: IF (cur_rowid%FOUND) THEN
382: Close cur_rowid;
383: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAI_CI_FK');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: Return;
387: END IF;
388: Close cur_rowid;
389:

Line 411: App_Exception.Raise_Exception;

407: IF (cur_rowid%FOUND) THEN
408: Close cur_rowid;
409: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAI_DA_FK');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: Return;
413: END IF;
414: Close cur_rowid;
415:

Line 474: App_Exception.Raise_Exception;

470: new_references.cal_type ,
471: new_references.ci_sequence_number ) THEN
472: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: CHECK_CONSTRAINTS;
477: Check_Parent_Existance;
478: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 486: App_Exception.Raise_Exception;

482: new_references.cal_type ,
483: new_references.ci_sequence_number ) THEN
484: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: END IF;
488: CHECK_CONSTRAINTS;
489: ELSIF (p_action = 'UPDATE') THEN
490: -- Call all the procedures related to Before Update.

Line 585: app_exception.raise_exception;

581: end if;
582: else
583: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
584: IGS_GE_MSG_STACK.ADD;
585: app_exception.raise_exception;
586: end if;
587: Before_DML (
588: p_action =>'INSERT',
589: x_rowid =>X_ROWID,

Line 660: app_exception.raise_exception;

656: if (c1%notfound) then
657: close c1;
658: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
659: IGS_GE_MSG_STACK.ADD;
660: app_exception.raise_exception;
661: return;
662: end if;
663: close c1;
664:

Line 673: app_exception.raise_exception;

669: null;
670: else
671: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
672: IGS_GE_MSG_STACK.ADD;
673: app_exception.raise_exception;
674: end if;
675: return;
676: end LOCK_ROW;
677:

Line 707: app_exception.raise_exception;

703: end if;
704: else
705: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
706: IGS_GE_MSG_STACK.ADD;
707: app_exception.raise_exception;
708: end if;
709: Before_DML (
710: p_action =>'UPDATE',
711: x_rowid =>X_ROWID,