DBA Data[Home] [Help]

APPS.IGS_PE_SUBURB_POSTCD_PKG dependencies on FND_MESSAGE

Line 35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

31: -- Populate Old Values.
32: Open cur_old_ref_values;
33: Fetch cur_old_ref_values INTO old_references;
34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN( 'INSERT','VALIDATE_INSERT')) THEN
35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: Close cur_old_ref_values;
38: App_Exception.Raise_Exception;
39: Return;

Line 78: Fnd_Message.Set_Name('IGS', v_message_name);

74: -- not have a foreign key to this table. Eg. IGS_PE_PERSON Statistics
75: IF IGS_EN_VAL_SP.enrp_val_sp_del (
76: old_references.postcode,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS', v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82:

Line 104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

100: END IF;
101: IF upper(column_name) = 'POSTCODE' OR
102: column_name is null Then
103: IF new_references.postcode < 0 OR new_references.postcode > 9999 Then
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;

Line 112: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

108: END IF;
109: IF upper(column_name) = 'CLOSED_IND' OR
110: column_name is null Then
111: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )Then
112: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116: END IF;

Line 206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

202: -- Call all the procedures related to Before Insert.
203: BeforeRowDelete1 ( p_inserting => TRUE );
204: IF Get_PK_For_Validation (
205: new_references.postcode ) THEN
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210:

Line 226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

222: Check_Child_Existance; -- if procedure present
223: ELSIF (p_action = 'VALIDATE_INSERT') THEN
224: IF Get_PK_For_Validation (
225: new_references.postcode ) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230:

Line 292: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

288: if X_LAST_UPDATE_LOGIN is NULL then
289: X_LAST_UPDATE_LOGIN := -1;
290: end if;
291: else
292: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
293: IGS_GE_MSG_STACK.ADD;
294: app_exception.raise_exception;
295: end if;
296: --

Line 363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

359: begin
360: open c1;
361: fetch c1 into tlinfo;
362: if (c1%notfound) then
363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
364:
365: close c1;
366: app_exception.raise_exception;
367: return;

Line 376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

372: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
373: ) then
374: null;
375: else
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: app_exception.raise_exception;
378: end if;
379: return;
380: end LOCK_ROW;

Line 407: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

403: if X_LAST_UPDATE_LOGIN is NULL then
404: X_LAST_UPDATE_LOGIN := -1;
405: end if;
406: else
407: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: end if;
411: --