eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_SBM_AOU_FNDTT_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

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;
47: END IF;

Line 91: IGS_GE_MSG_STACK.ADD;

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;
95: -- Validate org IGS_PS_UNIT is active and at the local IGS_OR_INSTITUTION.

Line 105: IGS_GE_MSG_STACK.ADD;

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;
109: -- Validate Intake target Type closed ind.

Line 117: IGS_GE_MSG_STACK.ADD;

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;
121: -- Validate override system amount type does not equal the system amount type

Line 133: IGS_GE_MSG_STACK.ADD;

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;
137: -- Validate target and maximum target against amount type

Line 152: IGS_GE_MSG_STACK.ADD;

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
156: IF IGS_AD_VAL_SIT.admp_val_trgt_amt(

Line 163: IGS_GE_MSG_STACK.ADD;

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;
167: END IF;

Line 184: IGS_GE_MSG_STACK.ADD;

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;
188:

Line 200: IGS_GE_MSG_STACK.ADD;

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;
204:

Line 214: IGS_GE_MSG_STACK.ADD;

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;
218:

Line 230: IGS_GE_MSG_STACK.ADD;

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;
234:

Line 244: IGS_GE_MSG_STACK.ADD;

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;
248:

Line 306: IGS_GE_MSG_STACK.ADD;

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;
310: Close cur_rowid;

Line 334: IGS_GE_MSG_STACK.ADD;

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;
338: Close cur_rowid;

Line 360: IGS_GE_MSG_STACK.ADD;

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;
364: Close cur_rowid;

Line 388: IGS_GE_MSG_STACK.ADD;

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;
392: Close cur_rowid;

Line 414: IGS_GE_MSG_STACK.ADD;

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;
418: Close cur_rowid;

Line 447: IGS_GE_MSG_STACK.ADD;

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;
451: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN

Line 454: IGS_GE_MSG_STACK.ADD;

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;
458: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN

Line 461: IGS_GE_MSG_STACK.ADD;

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;
465: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN

Line 468: IGS_GE_MSG_STACK.ADD;

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;
472: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN

Line 475: IGS_GE_MSG_STACK.ADD;

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;
479: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN

Line 482: IGS_GE_MSG_STACK.ADD;

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;
486: END CHECK_CONSTRAINTS;

Line 545: IGS_GE_MSG_STACK.ADD;

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;
549: Check_Parent_Existance;

Line 569: IGS_GE_MSG_STACK.ADD;

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;
573: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 636: IGS_GE_MSG_STACK.ADD;

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:
640: Before_DML (

Line 742: IGS_GE_MSG_STACK.ADD;

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;
746: end if;

Line 766: IGS_GE_MSG_STACK.ADD;

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;
770: end LOCK_ROW;

Line 806: IGS_GE_MSG_STACK.ADD;

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:
810: Before_DML (