DBA Data[Home] [Help]

APPS.IGS_AD_SBM_AOU_FNDTT_PKG dependencies on FND_MESSAGE

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

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

Line 90: FND_MESSAGE.SET_NAME('IGS',v_message_name);

86: IF IGS_AD_VAL_SAFT.crsp_val_fs_closed(
87: new_references.funding_source,
88: v_message_name) = FALSE THEN
89: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
90: FND_MESSAGE.SET_NAME('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END IF;
94: END IF;

Line 104: FND_MESSAGE.SET_NAME('IGS',v_message_name);

100: new_references.org_unit_cd,
101: new_references.ou_start_dt,
102: v_message_name) = FALSE THEN
103: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
104: FND_MESSAGE.SET_NAME('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: APP_EXCEPTION.RAISE_EXCEPTION;
107: END IF;
108: END IF;

Line 116: FND_MESSAGE.SET_NAME('IGS',v_message_name);

112: IF IGS_AD_VAL_SIT.admp_val_itt_closed(
113: new_references.intake_target_type,
114: v_message_name) = FALSE THEN
115: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
116: FND_MESSAGE.SET_NAME('IGS',v_message_name);
117: IGS_GE_MSG_STACK.ADD;
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: END IF;
120: END IF;

Line 132: FND_MESSAGE.SET_NAME('IGS',v_message_name);

128: v_s_amount_type,
129: new_references.override_s_amount_type,
130: v_message_name) = FALSE THEN
131: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
132: FND_MESSAGE.SET_NAME('IGS',v_message_name);
133: IGS_GE_MSG_STACK.ADD;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135: END IF;
136: END IF;

Line 151: FND_MESSAGE.SET_NAME('IGS',v_message_name);

147: new_references.target,
148: new_references.max_target,
149: v_message_name) = FALSE THEN
150: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
151: FND_MESSAGE.SET_NAME('IGS',v_message_name);
152: IGS_GE_MSG_STACK.ADD;
153: APP_EXCEPTION.RAISE_EXCEPTION;
154: END IF;
155: ELSE

Line 162: FND_MESSAGE.SET_NAME('IGS',v_message_name);

158: new_references.target,
159: new_references.max_target,
160: v_message_name) = FALSE THEN
161: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
162: FND_MESSAGE.SET_NAME('IGS',v_message_name);
163: IGS_GE_MSG_STACK.ADD;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: END IF;
166: END IF;

Line 183: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

179: ELSE
180: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
181: new_references.funding_source
182: )THEN
183: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
184: IGS_GE_MSG_STACK.ADD;
185: APP_EXCEPTION.RAISE_EXCEPTION;
186: END IF;
187: END IF;

Line 199: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

195: IF NOT IGS_ST_GVT_SPSHT_CTL_PKG.Get_PK_For_Validation (
196: new_references.submission_yr,
197: new_references.submission_number
198: )THEN
199: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
200: IGS_GE_MSG_STACK.ADD;
201: APP_EXCEPTION.RAISE_EXCEPTION;
202: END IF;
203: END IF;

Line 213: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

209: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
210: new_references.intake_target_type,
211: 'N'
212: )THEN
213: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;
217: END IF;

Line 229: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

225: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
226: new_references.org_unit_cd,
227: new_references.ou_start_dt
228: )THEN
229: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: END IF;

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

239: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
240: 'AMOUNT_TYPE',
241: new_references.override_s_amount_type
242: ) THEN
243: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;

Line 305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_FS_FK');

301: Open cur_rowid;
302: Fetch cur_rowid INTO lv_rowid;
303: IF (cur_rowid%FOUND) THEN
304: Close cur_rowid;
305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_FS_FK');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: Return;
309: END IF;

Line 333: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_GSC_FK');

329: Open cur_rowid;
330: Fetch cur_rowid INTO lv_rowid;
331: IF (cur_rowid%FOUND) THEN
332: Close cur_rowid;
333: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_GSC_FK');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: Return;
337: END IF;

Line 359: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_ITT_FK');

355: Open cur_rowid;
356: Fetch cur_rowid INTO lv_rowid;
357: IF (cur_rowid%FOUND) THEN
358: Close cur_rowid;
359: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_ITT_FK');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: Return;
363: END IF;

Line 387: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_OU_FK');

383: Open cur_rowid;
384: Fetch cur_rowid INTO lv_rowid;
385: IF (cur_rowid%FOUND) THEN
386: Close cur_rowid;
387: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_OU_FK');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception;
390: Return;
391: END IF;

Line 413: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');

409: Open cur_rowid;
410: Fetch cur_rowid INTO lv_rowid;
411: IF (cur_rowid%FOUND) THEN
412: Close cur_rowid;
413: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
414: IGS_GE_MSG_STACK.ADD;
415: App_Exception.Raise_Exception;
416: Return;
417: END IF;

Line 446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

442: END IF;
443:
444: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
445: IF new_references.target < 00000.000 OR new_references.target > 99999.999 THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
447: IGS_GE_MSG_STACK.ADD;
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: END IF;
450: END IF;

Line 453: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

449: END IF;
450: END IF;
451: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
452: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN
453: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
454: IGS_GE_MSG_STACK.ADD;
455: APP_EXCEPTION.RAISE_EXCEPTION;
456: END IF;
457: END IF;

Line 460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

456: END IF;
457: END IF;
458: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
459: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
461: IGS_GE_MSG_STACK.ADD;
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: END IF;
464: END IF;

Line 467: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

463: END IF;
464: END IF;
465: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
466: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN
467: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: APP_EXCEPTION.RAISE_EXCEPTION;
470: END IF;
471: END IF;

Line 474: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

470: END IF;
471: END IF;
472: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
473: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
474: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
475: IGS_GE_MSG_STACK.ADD;
476: APP_EXCEPTION.RAISE_EXCEPTION;
477: END IF;
478: END IF;

Line 481: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

477: END IF;
478: END IF;
479: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
480: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
481: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
482: IGS_GE_MSG_STACK.ADD;
483: APP_EXCEPTION.RAISE_EXCEPTION;
484: END IF;
485: END IF;

Line 544: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

540: new_references.ou_start_dt,
541: new_references.funding_source,
542: new_references.intake_target_type
543: )THEN
544: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
545: IGS_GE_MSG_STACK.ADD;
546: APP_EXCEPTION.RAISE_EXCEPTION;
547: END IF;
548: Check_Constraints;

Line 568: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

564: new_references.ou_start_dt,
565: new_references.funding_source,
566: new_references.intake_target_type
567: )THEN
568: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
569: IGS_GE_MSG_STACK.ADD;
570: APP_EXCEPTION.RAISE_EXCEPTION;
571: END IF;
572: Check_Constraints;

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

631: if X_LAST_UPDATE_LOGIN is NULL then
632: X_LAST_UPDATE_LOGIN := -1;
633: end if;
634: else
635: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
636: IGS_GE_MSG_STACK.ADD;
637: app_exception.raise_exception;
638: end if;
639:

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

737: begin
738: open c1;
739: fetch c1 into tlinfo;
740: if (c1%notfound) then
741: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
742: IGS_GE_MSG_STACK.ADD;
743: app_exception.raise_exception;
744: close c1;
745: return;

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

761: AND (X_ACTUAL_ENR_EFFECTIVE_DT is null)))
762: ) then
763: null;
764: else
765: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
766: IGS_GE_MSG_STACK.ADD;
767: app_exception.raise_exception;
768: end if;
769: return;

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

801: if X_LAST_UPDATE_LOGIN is NULL then
802: X_LAST_UPDATE_LOGIN := -1;
803: end if;
804: else
805: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
806: IGS_GE_MSG_STACK.ADD;
807: app_exception.raise_exception;
808: end if;
809: