APPS.IGS_PE_COUNTRY_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 73: IGS_GE_MSG_STACK.ADD;

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

Line 161: IGS_GE_MSG_STACK.ADD;

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

Line 181: IGS_GE_MSG_STACK.ADD;

177:
178: v_message_name ) = FALSE THEN
179:
180: Fnd_Message.Set_Name('IGS', v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183:
184: END IF;
185:

Line 217: IGS_GE_MSG_STACK.ADD;

213: column_name is null Then
214: IF
215: new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
216: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: END IF;
220: END IF;
221:

Line 226: IGS_GE_MSG_STACK.ADD;

222: IF upper(column_name) = 'COUNTRY_CD' OR
223: column_name is null Then
224: IF new_references.COUNTRY_CD <> UPPER(new_references.COUNTRY_CD) Then
225: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
226: IGS_GE_MSG_STACK.ADD;
227: App_Exception.Raise_Exception;
228: END IF;
229: END IF;
230:

Line 236: IGS_GE_MSG_STACK.ADD;

232: column_name is null Then
233: IF new_references.GOVT_COUNTRY_CD<>
234: UPPER(new_references.GOVT_COUNTRY_CD) Then
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: END IF;
240:

Line 260: IGS_GE_MSG_STACK.ADD;

256: ELSE
257: IF NOT IGS_PE_GOV_COUNTRYCD_PKG.Get_PK_For_Validation (
258: new_references.GOVT_COUNTRY_CD) THEN
259: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264: END Check_Parent_Existance;

Line 367: IGS_GE_MSG_STACK.ADD;

363:
364: IF (cur_rowid%FOUND) THEN
365:
366: Fnd_Message.Set_Name ('IGS', 'IGS_PE_CNC_GCOC_FK');
367: IGS_GE_MSG_STACK.ADD;
368:
369:
370: Close cur_rowid;
371: App_Exception.Raise_Exception;

Line 452: IGS_GE_MSG_STACK.ADD;

448: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
449: IF Get_PK_For_Validation (
450: new_references.country_cd ) THEN
451: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454: END IF;
455:
456: Check_Constraints; -- if procedure present

Line 472: IGS_GE_MSG_STACK.ADD;

468: ELSIF (p_action = 'VALIDATE_INSERT') THEN
469: IF Get_PK_For_Validation (
470: new_references.country_cd ) THEN
471: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END IF;
475:
476: Check_Constraints; -- if procedure present

Line 561: IGS_GE_MSG_STACK.ADD;

557: X_LAST_UPDATE_LOGIN := -1;
558: end if;
559: else
560: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
561: IGS_GE_MSG_STACK.ADD;
562: app_exception.raise_exception;
563: end if;
564:
565: Before_DML(

Line 709: IGS_GE_MSG_STACK.ADD;

705: X_LAST_UPDATE_LOGIN := -1;
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:
713: Before_DML(