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

Line 50: IGS_GE_MSG_STACK.ADD;

46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;

Line 124: IGS_GE_MSG_STACK.ADD;

120: 'OR_ACCR_STATUS',
121: new_references.org_accr_status
122: ) THEN
123: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127:
128: IF (((old_references.org_agency_id = new_references.org_agency_id)) OR

Line 135: IGS_GE_MSG_STACK.ADD;

131: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
132: new_references.org_agency_id
133: ) THEN
134: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',
139: new_references.org_structure_type) THEN

Line 141: IGS_GE_MSG_STACK.ADD;

137: END IF;
138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',
139: new_references.org_structure_type) THEN
140: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: APP_EXCEPTION.RAISE_EXCEPTION;
143:
144: END IF;
145: IF new_references.org_structure_type = 'INSTITUTE' THEN

Line 148: IGS_GE_MSG_STACK.ADD;

144: END IF;
145: IF new_references.org_structure_type = 'INSTITUTE' THEN
146: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN
147: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END IF;
151: ELSIF new_references.org_structure_type = 'LOCATION' THEN
152: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,

Line 155: IGS_GE_MSG_STACK.ADD;

151: ELSIF new_references.org_structure_type = 'LOCATION' THEN
152: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
153: 'N') THEN
154: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: END IF;
158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
159: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN

Line 161: IGS_GE_MSG_STACK.ADD;

157: END IF;
158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
159: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN
160: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163: END IF;
164: END IF;
165:

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_OR_OAD_OAS_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;
246: Close cur_rowid;

Line 279: IGS_GE_MSG_STACK.ADD;

275: Fetch cur_rowid INTO lv_rowid;
276: IF (cur_rowid%FOUND) THEN
277: Close cur_rowid;
278: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OI_FK');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: Return;
282: END IF;
283: Close cur_rowid;

Line 302: IGS_GE_MSG_STACK.ADD;

298: FETCH cur_rowid INTO lv_rowid;
299: IF (cur_rowid%FOUND) THEN
300: CLOSE cur_rowid;
301: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_LOC_FK');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: RETURN;
305: END IF;
306: CLOSE cur_rowid;

Line 364: IGS_GE_MSG_STACK.ADD;

360: new_references.org_structure_id,
361: new_references.org_structure_type,
362: new_references.start_date) THEN
363: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;
367: Check_Constraints;
368: Check_Parent_Existance;

Line 386: IGS_GE_MSG_STACK.ADD;

382: new_references.org_structure_id,
383: new_references.org_structure_type,
384: new_references.start_date) THEN
385: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Constraints;
390: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 477: IGS_GE_MSG_STACK.ADD;

473: X_LAST_UPDATE_LOGIN := -1;
474: end if;
475: else
476: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: end if;
480: Before_DML(
481: p_action=>'INSERT',

Line 561: IGS_GE_MSG_STACK.ADD;

557: open c1;
558: fetch c1 into tlinfo;
559: if (c1%notfound) then
560: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
561: IGS_GE_MSG_STACK.ADD;
562: close c1;
563: app_exception.raise_exception;
564: return;
565: end if;

Line 574: IGS_GE_MSG_STACK.ADD;

570: ) then
571: null;
572: else
573: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
574: IGS_GE_MSG_STACK.ADD;
575: app_exception.raise_exception;
576: end if;
577: return;
578: end LOCK_ROW;

Line 619: IGS_GE_MSG_STACK.ADD;

615: X_LAST_UPDATE_LOGIN := -1;
616: end if;
617: else
618: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
619: IGS_GE_MSG_STACK.ADD;
620: app_exception.raise_exception;
621: end if;
622: Before_DML(
623: p_action=>'UPDATE',