DBA Data[Home] [Help]

APPS.IGS_AD_CNDNL_OFRSTAT_PKG dependencies on FND_MESSAGE

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

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

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

80: (old_references.closed_ind = 'Y' AND new_references.closed_ind = 'N')) THEN
81: IF IGS_AD_VAL_ACOS.admp_val_sacoos_clsd(
82: new_references.s_adm_cndtnl_offer_status,
83: v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name('IGS',v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;

Line 90: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');

86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
90: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94:

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

114: END IF;
115:
116: IF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
117: IF new_references.adm_cndtnl_offer_status<> UPPER(new_references.adm_cndtnl_offer_status) Then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;

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

121: END IF;
122: END IF;
123: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
124: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
125: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;

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

128: END IF;
129: END IF;
130: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
131: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: END IF;

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

135: END IF;
136: END IF;
137: IF upper(column_name) = 'S_ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
138: IF new_references.s_adm_cndtnl_offer_status<> UPPER(new_references.s_adm_cndtnl_offer_status) Then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;

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

152: ELSE
153: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
154: 'ADM_CNDTNL_OFFER_STATUS',
155: new_references.s_adm_cndtnl_offer_status ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;

Line 213: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACOS_SLV_FK');

209: Open cur_rowid;
210: Fetch cur_rowid INTO lv_rowid;
211: IF (cur_rowid%FOUND) THEN
212: Close cur_rowid;
213: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACOS_SLV_FK');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: Return;
217: END IF;

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

253: -- Call all the procedures related to Before Insert.
254: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
255: IF Get_PK_For_Validation (
256: new_references.adm_cndtnl_offer_status ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;

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

270: Check_Child_Existance;
271: ELSIF (p_action = 'VALIDATE_INSERT') THEN
272: IF Get_PK_For_Validation (
273: new_references.adm_cndtnl_offer_status ) THEN
274: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: Check_Constraints;

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

321: if X_LAST_UPDATE_LOGIN is NULL then
322: X_LAST_UPDATE_LOGIN := -1;
323: end if;
324: else
325: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
326: IGS_GE_MSG_STACK.ADD;
327: app_exception.raise_exception;
328: end if;
329:

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

400: begin
401: open c1;
402: fetch c1 into tlinfo;
403: if (c1%notfound) then
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: IGS_GE_MSG_STACK.ADD;
406: app_exception.raise_exception;
407: close c1;
408: return;

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

415: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
416: ) then
417: null;
418: else
419: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
420: IGS_GE_MSG_STACK.ADD;
421: app_exception.raise_exception;
422: end if;
423: return;

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

449: if X_LAST_UPDATE_LOGIN is NULL then
450: X_LAST_UPDATE_LOGIN := -1;
451: end if;
452: else
453: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457: