DBA Data[Home] [Help]

APPS.IGS_AV_STND_ALT_UNIT_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 89: Fnd_Message.Set_Name('IGS', v_message_name);

85: rec.s_adv_stnd_type, --new_references.s_adv_stnd_type,
86: rec.unit_cd, --new_references.unit_cd,
87: rec.version_number, --new_references.version_number,
88: v_message_name) = FALSE THEN
89: Fnd_Message.Set_Name('IGS', v_message_name);
90: Igs_Ge_Msg_Stack.Add;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;

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

96: IF IGS_AV_VAL_ASAU.advp_val_prclde_unit (
97: rec.unit_cd, --new_references.unit_cd,
98: new_references.alt_unit_cd,
99: v_message_name) = FALSE THEN
100: Fnd_Message.Set_Name('IGS', v_message_name);
101: Igs_Ge_Msg_Stack.Add;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;

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

122: IF upper(column_name) = 'ALT_UNIT_CD' OR
123: column_name IS null Then
124: IF new_references.ALT_UNIT_CD <>
125: UPPER(new_references.ALT_UNIT_CD) Then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: Igs_Ge_Msg_Stack.Add;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;

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

131: IF upper(column_name) = 'OPTIONAL_IND' OR
132: column_name IS null Then
133: IF new_references.OPTIONAL_IND <>
134: UPPER(new_references.OPTIONAL_IND) Then
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
136: Igs_Ge_Msg_Stack.Add;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;

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

139: END IF;
140: IF upper(column_name) = 'OPTIONAL_IND' OR
141: column_name IS null Then
142: IF (new_references.optional_ind not in ('Y', 'N')) Then
143: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
144: Igs_Ge_Msg_Stack.Add;
145: App_Exception.Raise_Exception;
146: END IF;
147: END IF;

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

156: ELSE
157: IF NOT IGS_AV_STND_UNIT_PKG.Get_PK_For_Validation (
158: new_references.av_stnd_unit_id
159: ) THEN
160: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
161: Igs_Ge_Msg_Stack.Add;
162: App_Exception.Raise_Exception;
163: END IF;
164: END IF;

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

172: IF NOT IGS_PS_UNIT_VER_PKG.Get_PK_For_Validation (
173: new_references.alt_unit_cd,
174: new_references.alt_version_number
175: ) THEN
176: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
177: Igs_Ge_Msg_Stack.Add;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;

Line 230: Fnd_Message.Set_Name ('IGS', 'IGS_AV_ASAU_ASU_FK');

226:
227: Open cur_rowid;
228: Fetch cur_rowid INTO lv_rowid;
229: IF (cur_rowid%FOUND) THEN
230: Fnd_Message.Set_Name ('IGS', 'IGS_AV_ASAU_ASU_FK');
231: Igs_Ge_Msg_Stack.Add;
232: Close cur_rowid;
233: App_Exception.Raise_Exception;
234: Return;

Line 258: Fnd_Message.Set_Name ('IGS', 'IGS_AV_ASAU_UV_FK');

254:
255: Open cur_rowid;
256: Fetch cur_rowid INTO lv_rowid;
257: IF (cur_rowid%FOUND) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_AV_ASAU_UV_FK');
259: Igs_Ge_Msg_Stack.Add;
260: Close cur_rowid;
261: App_Exception.Raise_Exception;
262: Return;

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

300: new_references.av_stnd_unit_id,
301: new_references.alt_unit_cd,
302: new_references.alt_version_number
303: ) THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
305: Igs_Ge_Msg_Stack.Add;
306: App_Exception.Raise_Exception;
307: END IF;
308: Check_Constraints;

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

320: new_references.av_stnd_unit_id,
321: new_references.alt_unit_cd,
322: new_references.alt_version_number
323: ) THEN
324: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
325: Igs_Ge_Msg_Stack.Add;
326: App_Exception.Raise_Exception;
327: END IF;
328: Check_Constraints;

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

363: if X_LAST_UPDATE_LOGIN IS NULL then
364: X_LAST_UPDATE_LOGIN := -1;
365: end if;
366: else
367: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
368: Igs_Ge_Msg_Stack.Add;
369: app_exception.raise_exception;
370: end if;
371: Before_DML(

Line 425: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

421: close c;
422: EXCEPTION
423: WHEN OTHERS THEN
424: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
425: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
426: fnd_message.set_token ('ERR_CD', SQLCODE);
427: igs_ge_msg_stack.add;
428: igs_sc_gen_001.unset_ctx('R');
429: app_exception.raise_exception;

Line 426: fnd_message.set_token ('ERR_CD', SQLCODE);

422: EXCEPTION
423: WHEN OTHERS THEN
424: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
425: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
426: fnd_message.set_token ('ERR_CD', SQLCODE);
427: igs_ge_msg_stack.add;
428: igs_sc_gen_001.unset_ctx('R');
429: app_exception.raise_exception;
430: ELSE

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

450: begin
451: open c1;
452: fetch c1 into tlinfo;
453: if (c1%notfound) then
454: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
455: Igs_Ge_Msg_Stack.Add;
456: close c1;
457: app_exception.raise_exception;
458: return;

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

462: if ( (tlinfo.OPTIONAL_IND = X_OPTIONAL_IND)
463: ) then
464: null;
465: else
466: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
467: Igs_Ge_Msg_Stack.Add;
468: app_exception.raise_exception;
469: end if;
470: return;

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

495: if X_LAST_UPDATE_LOGIN IS NULL then
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: Before_DML(

Line 526: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

522: LAST_UPDATED_BY = LAST_UPDATED_BY,
523: LAST_UPDATE_LOGIN = LAST_UPDATE_LOGIN
524: where ROWID = X_ROWID ;
525: if (sql%notfound) then
526: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
527: igs_ge_msg_stack.add;
528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: end if;

Line 539: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

535:
536: EXCEPTION
537: WHEN OTHERS THEN
538: IF (SQLCODE = (-28115)) THEN
539: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
540: fnd_message.set_token ('ERR_CD', SQLCODE);
541: igs_ge_msg_stack.add;
542: igs_sc_gen_001.unset_ctx('R');
543: app_exception.raise_exception;

Line 540: fnd_message.set_token ('ERR_CD', SQLCODE);

536: EXCEPTION
537: WHEN OTHERS THEN
538: IF (SQLCODE = (-28115)) THEN
539: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
540: fnd_message.set_token ('ERR_CD', SQLCODE);
541: igs_ge_msg_stack.add;
542: igs_sc_gen_001.unset_ctx('R');
543: app_exception.raise_exception;
544: ELSE

Line 603: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

599: END IF;
600: delete from IGS_AV_STND_ALT_UNIT
601: where ROWID = X_ROWID ;
602: if (sql%notfound) then
603: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
604: igs_ge_msg_stack.add;
605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: end if;