APPS.IGS_PE_COUNTRY_CD_PKG dependencies on APP_EXCEPTION

Line 76: App_Exception.Raise_Exception;

72:
73: IGS_GE_MSG_STACK.ADD;
74:
75: Close cur_old_ref_values;
76: App_Exception.Raise_Exception;
77: Return;
78:
79: END IF;
80:

Line 162: App_Exception.Raise_Exception;

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:
166: END IF;

Line 182: App_Exception.Raise_Exception;

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:
186: END IF;

Line 218: App_Exception.Raise_Exception;

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:
222: IF upper(column_name) = 'COUNTRY_CD' OR

Line 227: App_Exception.Raise_Exception;

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:
231: IF upper(column_name) = 'GOVT_COUNTRY_CD' OR

Line 237: App_Exception.Raise_Exception;

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:
241:

Line 261: App_Exception.Raise_Exception;

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;
265: PROCEDURE Check_Child_Existance as

Line 371: App_Exception.Raise_Exception;

367: IGS_GE_MSG_STACK.ADD;
368:
369:
370: Close cur_rowid;
371: App_Exception.Raise_Exception;
372: Return;
373:
374: END IF;
375:

Line 453: App_Exception.Raise_Exception;

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
457: Check_Parent_Existance; -- if procedure present

Line 473: App_Exception.Raise_Exception;

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
477: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 562: app_exception.raise_exception;

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(
566:

Line 660: App_Exception.Raise_Exception;

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

Line 675: app_exception.raise_exception;

671: ) then
672: null;
673: else
674: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
675: app_exception.raise_exception;
676: end if;
677: return;
678: end LOCK_ROW;
679:

Line 710: app_exception.raise_exception;

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(
714: