DBA Data[Home] [Help]

APPS.IGS_AD_SBMAO_FN_UITT_PKG dependencies on FND_MESSAGE

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

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

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

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

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

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

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

114: IF IGS_AD_VAL_SAFT.crsp_val_uicl_closed(
115: new_references.unit_int_course_level_cd,
116: v_message_name) = FALSE THEN
117: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
118: FND_MESSAGE.SET_NAME('IGS',v_message_name);
119: IGS_GE_MSG_STACK.ADD;
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122: END IF;

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

126: IF IGS_AD_VAL_SIT.admp_val_itt_closed(
127: new_references.intake_target_type,
128: v_message_name) = FALSE THEN
129: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
130: FND_MESSAGE.SET_NAME('IGS',v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134: END IF;

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

142: v_s_amount_type,
143: new_references.override_s_amount_type,
144: v_message_name) = FALSE THEN
145: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
146: FND_MESSAGE.SET_NAME('IGS',v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: APP_EXCEPTION.RAISE_EXCEPTION;
149: END IF;
150: END IF;

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

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

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

172: new_references.target,
173: new_references.max_target,
174: v_message_name) = FALSE THEN
175: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
176: FND_MESSAGE.SET_NAME('IGS',v_message_name);
177: IGS_GE_MSG_STACK.ADD;
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END IF;
180: END IF;

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

192: ELSE
193: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
194: new_references.funding_source
195: )THEN
196: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
197: IGS_GE_MSG_STACK.ADD;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: END IF;
200: END IF;

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

208: IF NOT IGS_ST_GVT_SPSHT_CTL_PKG.Get_PK_For_Validation (
209: new_references.submission_yr,
210: new_references.submission_number
211: )THEN
212: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
213: IGS_GE_MSG_STACK.ADD;
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: END IF;

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

222: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
223: new_references.intake_target_type,
224: 'N'
225: )THEN
226: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
227: IGS_GE_MSG_STACK.ADD;
228: APP_EXCEPTION.RAISE_EXCEPTION;
229: END IF;
230: END IF;

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

238: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
239: new_references.org_unit_cd,
240: new_references.ou_start_dt
241: )THEN
242: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: END IF;
246: END IF;

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

251: ELSE
252: IF NOT IGS_PS_UNIT_INT_LVL_PKG.Get_PK_For_Validation (
253: new_references.unit_int_course_level_cd
254: )THEN
255: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
256: IGS_GE_MSG_STACK.ADD;
257: APP_EXCEPTION.RAISE_EXCEPTION;
258: END IF;
259: END IF;

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

265: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
266: 'AMOUNT_TYPE',
267: new_references.override_s_amount_type
268: ) THEN
269: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;

Line 332: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_FS_FK');

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

Line 360: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_GSC_FK');

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

Line 386: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_ITT_FK');

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

Line 414: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_OU_FK');

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

Line 440: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_UICL_FK');

436: Open cur_rowid;
437: Fetch cur_rowid INTO lv_rowid;
438: IF (cur_rowid%FOUND) THEN
439: Close cur_rowid;
440: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_UICL_FK');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: Return;
444: END IF;

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

462: Open cur_rowid;
463: Fetch cur_rowid INTO lv_rowid;
464: IF (cur_rowid%FOUND) THEN
465: Close cur_rowid;
466: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception;
469: Return;
470: END IF;

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

497: END IF;
498:
499: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
500: IF new_references.target < 00000.000 OR new_references.target > 99999.999 THEN
501: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
502: IGS_GE_MSG_STACK.ADD;
503: APP_EXCEPTION.RAISE_EXCEPTION;
504: END IF;
505: END IF;

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

504: END IF;
505: END IF;
506: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
507: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN
508: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: END IF;
512: END IF;

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

511: END IF;
512: END IF;
513: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
514: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN
515: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: END IF;

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

518: END IF;
519: END IF;
520: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
521: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
522: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
523: IGS_GE_MSG_STACK.ADD;
524: APP_EXCEPTION.RAISE_EXCEPTION;
525: END IF;
526: END IF;

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

525: END IF;
526: END IF;
527: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
528: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
529: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
530: IGS_GE_MSG_STACK.ADD;
531: APP_EXCEPTION.RAISE_EXCEPTION;
532: END IF;
533: END IF;

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

532: END IF;
533: END IF;
534: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
535: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN
536: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
537: IGS_GE_MSG_STACK.ADD;
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: END IF;
540: END IF;

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

539: END IF;
540: END IF;
541: IF upper(column_name) = 'UNIT_INT_COURSE_LEVEL_CD' OR column_name IS NULL THEN
542: IF new_references.unit_int_course_level_cd <> UPPER(new_references.unit_int_course_level_cd) THEN
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
544: IGS_GE_MSG_STACK.ADD;
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: END IF;
547: END IF;

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

604: new_references.funding_source,
605: new_references.unit_int_course_level_cd,
606: new_references.intake_target_type
607: )THEN
608: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
609: IGS_GE_MSG_STACK.ADD;
610: APP_EXCEPTION.RAISE_EXCEPTION;
611: END IF;
612: Check_Constraints;

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

629: new_references.funding_source,
630: new_references.unit_int_course_level_cd,
631: new_references.intake_target_type
632: )THEN
633: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
634: IGS_GE_MSG_STACK.ADD;
635: APP_EXCEPTION.RAISE_EXCEPTION;
636: END IF;
637: Check_Constraints;

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

696: if X_LAST_UPDATE_LOGIN is NULL then
697: X_LAST_UPDATE_LOGIN := -1;
698: end if;
699: else
700: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
701: IGS_GE_MSG_STACK.ADD;
702: app_exception.raise_exception;
703: end if;
704:

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

807: begin
808: open c1;
809: fetch c1 into tlinfo;
810: if (c1%notfound) then
811: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
812: IGS_GE_MSG_STACK.ADD;
813: app_exception.raise_exception;
814: close c1;
815: return;

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

831: AND (X_ACTUAL_ENR_EFFECTIVE_DT is null)))
832: ) then
833: null;
834: else
835: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
836: IGS_GE_MSG_STACK.ADD;
837: app_exception.raise_exception;
838: end if;
839: return;

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

872: if X_LAST_UPDATE_LOGIN is NULL then
873: X_LAST_UPDATE_LOGIN := -1;
874: end if;
875: else
876: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
877: IGS_GE_MSG_STACK.ADD;
878: app_exception.raise_exception;
879: end if;
880: