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_SBMINTAK_TRGT_PKG dependencies on IGS_GE_MSG_STACK

Line 41: IGS_GE_MSG_STACK.ADD;

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

Line 87: IGS_GE_MSG_STACK.ADD;

83: new_references.intake_target_type,
84: v_message_name) = FALSE THEN
85: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
86: FND_MESSAGE.SET_NAME('IGS',v_message_name);
87: IGS_GE_MSG_STACK.ADD;
88: APP_EXCEPTION.RAISE_EXCEPTION;
89: END IF;
90: END IF;
91: -- Validate override system amount type does not equal the system amount type

Line 103: IGS_GE_MSG_STACK.ADD;

99: new_references.override_s_amount_type,
100: v_message_name) = FALSE THEN
101: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
102: FND_MESSAGE.SET_NAME('IGS',v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: APP_EXCEPTION.RAISE_EXCEPTION;
105: END IF;
106: END IF;
107: -- Validate target and maximum target against amount type

Line 122: IGS_GE_MSG_STACK.ADD;

118: new_references.max_target,
119: v_message_name) = FALSE THEN
120: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
121: FND_MESSAGE.SET_NAME('IGS',v_message_name);
122: IGS_GE_MSG_STACK.ADD;
123: APP_EXCEPTION.RAISE_EXCEPTION;
124: END IF;
125: ELSE
126: IF IGS_AD_VAL_SIT.admp_val_trgt_amt(

Line 133: IGS_GE_MSG_STACK.ADD;

129: new_references.max_target,
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: END IF;

Line 156: IGS_GE_MSG_STACK.ADD;

152: new_references.submission_yr,
153: new_references.submission_number
154: )THEN
155: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
156: IGS_GE_MSG_STACK.ADD;
157: APP_EXCEPTION.RAISE_EXCEPTION;
158: END IF;
159: END IF;
160:

Line 170: IGS_GE_MSG_STACK.ADD;

166: new_references.intake_target_type,
167: 'N'
168: )THEN
169: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: END IF;
173: END IF;
174:

Line 184: IGS_GE_MSG_STACK.ADD;

180: 'AMOUNT_TYPE',
181: new_references.override_s_amount_type
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 242: IGS_GE_MSG_STACK.ADD;

238: Fetch cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: Close cur_rowid;
241: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SIT_GSC_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;
246: Close cur_rowid;

Line 268: IGS_GE_MSG_STACK.ADD;

264: Fetch cur_rowid INTO lv_rowid;
265: IF (cur_rowid%FOUND) THEN
266: Close cur_rowid;
267: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SIT_ITT_FK');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: Return;
271: END IF;
272: Close cur_rowid;

Line 295: IGS_GE_MSG_STACK.ADD;

291: Fetch cur_rowid INTO lv_rowid;
292: IF (cur_rowid%FOUND) THEN
293: Close cur_rowid;
294: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: Return;
298: END IF;
299: Close cur_rowid;

Line 324: IGS_GE_MSG_STACK.ADD;

320:
321: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
322: IF new_references.target < 0 OR new_references.target > 99999.999 THEN
323: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
324: IGS_GE_MSG_STACK.ADD;
325: APP_EXCEPTION.RAISE_EXCEPTION;
326: END IF;
327: END IF;
328: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN

Line 331: IGS_GE_MSG_STACK.ADD;

327: END IF;
328: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
329: IF new_references.max_target < 0 OR new_references.max_target > 99999.999 THEN
330: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
331: IGS_GE_MSG_STACK.ADD;
332: APP_EXCEPTION.RAISE_EXCEPTION;
333: END IF;
334: END IF;
335: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN

Line 338: IGS_GE_MSG_STACK.ADD;

334: END IF;
335: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
336: IF new_references.actual_enrolment < 0 OR new_references.actual_enrolment > 99999.999 THEN
337: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
338: IGS_GE_MSG_STACK.ADD;
339: APP_EXCEPTION.RAISE_EXCEPTION;
340: END IF;
341: END IF;
342: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN

Line 345: IGS_GE_MSG_STACK.ADD;

341: END IF;
342: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
343: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
344: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
345: IGS_GE_MSG_STACK.ADD;
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: END IF;
348: END IF;
349: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN

Line 352: IGS_GE_MSG_STACK.ADD;

348: END IF;
349: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
350: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN
351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
352: IGS_GE_MSG_STACK.ADD;
353: APP_EXCEPTION.RAISE_EXCEPTION;
354: END IF;
355: END IF;
356: END CHECK_CONSTRAINTS;

Line 407: IGS_GE_MSG_STACK.ADD;

403: new_references.submission_number,
404: new_references.intake_target_type
405: )THEN
406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
407: IGS_GE_MSG_STACK.ADD;
408: APP_EXCEPTION.RAISE_EXCEPTION;
409: END IF;
410: Check_constraints;
411: Check_Parent_Existance;

Line 428: IGS_GE_MSG_STACK.ADD;

424: new_references.submission_number,
425: new_references.intake_target_type
426: )THEN
427: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
428: IGS_GE_MSG_STACK.ADD;
429: APP_EXCEPTION.RAISE_EXCEPTION;
430: END IF;
431: Check_constraints;
432: ELSIF ( p_action = 'VALIDATE_UPDATE') THEN

Line 487: IGS_GE_MSG_STACK.ADD;

483: X_LAST_UPDATE_LOGIN := -1;
484: end if;
485: else
486: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490:
491: Before_DML (

Line 586: IGS_GE_MSG_STACK.ADD;

582: open c1;
583: fetch c1 into tlinfo;
584: if (c1%notfound) then
585: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: close c1;
589: return;
590: end if;

Line 613: IGS_GE_MSG_STACK.ADD;

609: ) then
610: null;
611: else
612: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
613: IGS_GE_MSG_STACK.ADD;
614: app_exception.raise_exception;
615: end if;
616: return;
617: end LOCK_ROW;

Line 651: IGS_GE_MSG_STACK.ADD;

647: X_LAST_UPDATE_LOGIN := -1;
648: end if;
649: else
650: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
651: IGS_GE_MSG_STACK.ADD;
652: app_exception.raise_exception;
653: end if;
654:
655: Before_DML (