DBA Data[Home] [Help]

APPS.IGS_PE_ABORG_TORESCD_PKG dependencies on IGS_GE_MSG_STACK

Line 71: IGS_GE_MSG_STACK.ADD;

67:
68: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
69:
70: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
71: IGS_GE_MSG_STACK.ADD;
72:
73:
74: Close cur_old_ref_values;
75: App_Exception.Raise_Exception;

Line 151: IGS_GE_MSG_STACK.ADD;

147:
148: v_message_name) = FALSE THEN
149:
150: Fnd_Message.Set_Name('IGS', v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153:
154: END IF;
155:

Line 183: IGS_GE_MSG_STACK.ADD;

179: IF upper(column_name) = 'ABORIG_TORRES_CD' OR
180: column_name is null Then
181: IF new_references.aborig_torres_cd <> UPPER(new_references.aborig_torres_cd ) Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187:

Line 193: IGS_GE_MSG_STACK.ADD;

189: column_name is null Then
190: IF new_references.closed_ind<>
191: UPPER(new_references.closed_ind) Then
192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: IF upper(column_name) = 'CLOSED_IND' OR

Line 201: IGS_GE_MSG_STACK.ADD;

197: IF upper(column_name) = 'CLOSED_IND' OR
198: column_name is null Then
199: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )Then
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: END IF;
205:

Line 224: IGS_GE_MSG_STACK.ADD;

220: ELSE
221: IF NOT IGS_PE_GOV_ABRGRESCD_PKG.Get_PK_For_Validation (
222: new_references.govt_aborig_torres_cd) THEN
223: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227:
228: END IF;

Line 302: IGS_GE_MSG_STACK.ADD;

298:
299: IF (cur_rowid%FOUND) THEN
300:
301: Fnd_Message.Set_Name ('IGS', 'IGS_PE_ATC_GATC_FK');
302: IGS_GE_MSG_STACK.ADD;
303:
304:
305: Close cur_rowid;
306: App_Exception.Raise_Exception;

Line 387: IGS_GE_MSG_STACK.ADD;

383: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
384: IF Get_PK_For_Validation (
385: new_references.aborig_torres_cd ) THEN
386: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
387: IGS_GE_MSG_STACK.ADD;
388: App_Exception.Raise_Exception;
389: END IF;
390:
391: Check_Constraints; -- if procedure present

Line 408: IGS_GE_MSG_STACK.ADD;

404: ELSIF (p_action = 'VALIDATE_INSERT') THEN
405: IF Get_PK_For_Validation (
406: new_references.aborig_torres_cd ) THEN
407: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411:
412: Check_Constraints; -- if procedure present

Line 500: IGS_GE_MSG_STACK.ADD;

496: X_LAST_UPDATE_LOGIN := -1;
497: end if;
498: else
499: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503:
504:

Line 654: IGS_GE_MSG_STACK.ADD;

650: X_LAST_UPDATE_LOGIN := -1;
651: end if;
652: else
653: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
654: IGS_GE_MSG_STACK.ADD;
655: app_exception.raise_exception;
656: end if;
657:
658: