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

Line 59: IGS_GE_MSG_STACK.ADD;

55: Fetch cur_old_ref_values INTO old_references;
56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
63: Close cur_old_ref_values;

Line 140: IGS_GE_MSG_STACK.ADD;

136: new_references.fee_ci_sequence_number,
137: new_references.fee_cat,
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS',v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF; */
144: -- Validate that appropriate fields are set depending on the fee type.

Line 155: IGS_GE_MSG_STACK.ADD;

151: new_references.fee_cat,
152: new_references.course_cd,
153: v_message_name) = FALSE THEN
154: Fnd_Message.Set_Name('IGS',v_message_name);
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: -- Validate that course code can be specified.
159: -- Enh # 2122257 (SFCR015 : Change In Fee Category)

Line 172: IGS_GE_MSG_STACK.ADD;

168: new_references.fee_cal_type,
169: new_references.fee_ci_sequence_number,
170: v_message_name) = FALSE THEN
171: Fnd_Message.Set_Name('IGS',v_message_name);
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: -- Validate effective date.

Line 194: IGS_GE_MSG_STACK.ADD;

190: new_references.effective_dt,
191: new_references.s_transaction_type,
192: v_message_name) = FALSE THEN
193: Fnd_Message.Set_Name('IGS',v_message_name);
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198: END IF; -- For External System Fee Type NOT FOUND

Line 206: IGS_GE_MSG_STACK.ADD;

202: new_references.s_transaction_type,
203: new_references.comments,
204: v_message_name) = FALSE THEN
205: Fnd_Message.Set_Name('IGS',v_message_name);
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210: IF p_updating THEN

Line 247: IGS_GE_MSG_STACK.ADD;

243: new_references.logical_delete_dt,
244: old_references.logical_delete_dt,
245: v_message_name) = FALSE THEN
246: Fnd_Message.Set_Name('IGS',v_message_name);
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: END IF;
251: END BeforeRowInsertUpdateDelete1;

Line 259: IGS_GE_MSG_STACK.ADD;

255: IF Get_UK_For_Validation (
256: new_references.transaction_id
257: ) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: End Check_Uniqueness;
263:

Line 308: IGS_GE_MSG_STACK.ADD;

304: column_name is null Then
305: IF new_references.COURSE_CD <>
306: UPPER(new_references.COURSE_CD) Then
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: END IF;
312: IF upper(column_name) = 'CURRENCY_CD' OR

Line 317: IGS_GE_MSG_STACK.ADD;

313: column_name is null Then
314: IF new_references.CURRENCY_CD <>
315: UPPER(new_references.CURRENCY_CD) Then
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: END IF;
321: IF upper(column_name) = 'FEE_CAL_TYPE' OR

Line 326: IGS_GE_MSG_STACK.ADD;

322: column_name is null Then
323: IF new_references.FEE_CAL_TYPE <>
324: UPPER(new_references.FEE_CAL_TYPE) Then
325: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: END IF;
330: IF upper(column_name) = 'S_TRANSACTION_TYPE' OR

Line 335: IGS_GE_MSG_STACK.ADD;

331: column_name is null Then
332: IF new_references.S_TRANSACTION_TYPE <>
333: UPPER(new_references.S_TRANSACTION_TYPE) Then
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: END IF;
339:

Line 345: IGS_GE_MSG_STACK.ADD;

341: column_name is null Then
342: IF new_references.transaction_id < 1 OR
343: new_references.transaction_id > 999999 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) = 'CHG_ELEMENTS' OR

Line 354: IGS_GE_MSG_STACK.ADD;

350: column_name is null Then
351: IF new_references.chg_elements < 0 OR
352: new_references.chg_elements > 9999.999 Then
353: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: END IF;
357: END IF;
358: IF upper(column_name) = 'EXCHANGE_RATE' OR

Line 363: IGS_GE_MSG_STACK.ADD;

359: column_name is null Then
360: IF new_references.exchange_rate < 0.0001 OR
361: new_references.exchange_rate > 9999.9999 Then
362: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: END IF;
367: IF upper(column_name) = 'TRANSACTION_AMOUNT' OR

Line 372: IGS_GE_MSG_STACK.ADD;

368: column_name is null Then
369: IF new_references.transaction_amount < -999990.00 OR
370: new_references.transaction_amount > 999990.00 Then
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375: END IF;
376: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR

Line 381: IGS_GE_MSG_STACK.ADD;

377: column_name is null Then
378: IF new_references.fee_ci_sequence_number < 1 OR
379: new_references.fee_ci_sequence_number > 999999 Then
380: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception;
383: END IF;
384: END IF;
385: END Check_CONSTRAINTS;

Line 413: IGS_GE_MSG_STACK.ADD;

409: IF NOT IGS_PS_COURSE_PKG.Get_PK_For_Validation (
410: new_references.course_cd
411: ) THEN
412: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: App_Exception.Raise_Exception;
415: END IF;
416: END IF;
417:

Line 435: IGS_GE_MSG_STACK.ADD;

431: new_references.fee_ci_sequence_number,
432: new_references.fee_type
433: ) THEN
434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438: END IF;
439: IF (((old_references.fee_type = new_references.fee_type) AND

Line 453: IGS_GE_MSG_STACK.ADD;

449: new_references.fee_cal_type,
450: new_references.fee_ci_sequence_number
451: ) THEN
452: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception;
455: END IF;
456: END IF;
457: IF (((old_references.person_id = new_references.person_id)) OR

Line 465: IGS_GE_MSG_STACK.ADD;

461: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
462: new_references.person_id
463: ) THEN
464: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467: END IF;
468: END IF;
469: IF (((old_references.s_transaction_type = new_references.s_transaction_type)) OR

Line 478: IGS_GE_MSG_STACK.ADD;

474: 'TRANSACTION_TYPE',
475: new_references.s_transaction_type
476: ) THEN
477: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
478: IGS_GE_MSG_STACK.ADD;
479: App_Exception.Raise_Exception;
480: END IF;
481: END IF;
482: END check_parent_existance;

Line 546: IGS_GE_MSG_STACK.ADD;

542: Fetch cur_rowid INTO lv_rowid;
543: IF (cur_rowid%FOUND) THEN
544: Close cur_rowid;
545: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_CRS_FK');
546: IGS_GE_MSG_STACK.ADD;
547: App_Exception.Raise_Exception;
548: Return;
549: END IF;
550: Close cur_rowid;

Line 568: IGS_GE_MSG_STACK.ADD;

564: Fetch cur_rowid INTO lv_rowid;
565: IF (cur_rowid%FOUND) THEN
566: Close cur_rowid;
567: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_PE_FK');
568: IGS_GE_MSG_STACK.ADD;
569: App_Exception.Raise_Exception;
570: Return;
571: END IF;
572: Close cur_rowid;

Line 589: IGS_GE_MSG_STACK.ADD;

585: Fetch cur_rowid INTO lv_rowid;
586: IF (cur_rowid%FOUND) THEN
587: Close cur_rowid;
588: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_STRTY_FK');
589: IGS_GE_MSG_STACK.ADD;
590: App_Exception.Raise_Exception;
591: Return;
592: END IF;
593: Close cur_rowid;

Line 673: IGS_GE_MSG_STACK.ADD;

669: new_references.person_id ,
670: new_references.transaction_id
671: ) THEN
672: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
673: IGS_GE_MSG_STACK.ADD;
674: App_Exception.Raise_Exception;
675: END IF;
676: Check_Constraints;
677: Check_Uniqueness;

Line 696: IGS_GE_MSG_STACK.ADD;

692: new_references.person_id ,
693: new_references.transaction_id
694: ) THEN
695: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
696: IGS_GE_MSG_STACK.ADD;
697: App_Exception.Raise_Exception;
698: END IF;
699: Check_Constraints;
700: Check_Uniqueness;

Line 818: IGS_GE_MSG_STACK.ADD;

814: X_PROGRAM_UPDATE_DATE := SYSDATE;
815: end if;
816: else
817: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
818: IGS_GE_MSG_STACK.ADD;
819: app_exception.raise_exception;
820: end if;
821: ---added by syam on 23-aug-2000
822: SELECT igs_fi_fee_as_trn_id_s.nextval

Line 970: IGS_GE_MSG_STACK.ADD;

966: fetch c1 into tlinfo;
967: if (c1%notfound) then
968: close c1;
969: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
970: IGS_GE_MSG_STACK.ADD;
971: app_exception.raise_exception;
972: return;
973: end if;
974: close c1;

Line 1034: IGS_GE_MSG_STACK.ADD;

1030: ) then
1031: null;
1032: else
1033: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1034: IGS_GE_MSG_STACK.ADD;
1035: app_exception.raise_exception;
1036: end if;
1037: return;
1038: end LOCK_ROW;

Line 1132: IGS_GE_MSG_STACK.ADD;

1128: X_PROGRAM_UPDATE_DATE := SYSDATE;
1129: end if;
1130: else
1131: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1132: IGS_GE_MSG_STACK.ADD;
1133: app_exception.raise_exception;
1134: end if;
1135: update IGS_FI_FEE_AS_ALL set
1136: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,