DBA Data[Home] [Help]

APPS.IGS_PE_STAT_DETAILS_PKG dependencies on IGS_GE_MSG_STACK

Line 111: igs_ge_msg_stack.ADD;

107: FETCH cur_old_ref_values INTO old_references;
108: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
109: CLOSE cur_old_ref_values;
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 1');
111: igs_ge_msg_stack.ADD;
112: app_exception.raise_exception;
113: RETURN;
114: END IF;
115: CLOSE cur_old_ref_values;

Line 238: Igs_Ge_Msg_Stack.Add;

234: Open cur_rowid;
235: Fetch cur_rowid INTO lv_rowid;
236: IF (cur_rowid%FOUND) THEN
237: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PST_CI_FK');
238: Igs_Ge_Msg_Stack.Add;
239: Close cur_rowid;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;

Line 277: IGS_GE_MSG_STACK.ADD;

273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%NOTFOUND) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED 2');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280: CLOSE cur_rowid;
281:

Line 294: igs_ge_msg_stack.add;

290: new_references.MATR_CAL_TYPE,
291: new_references.MATR_SEQUENCE_NUMBER
292: ) THEN
293: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 3');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297:
298: IF (((old_references.INIT_CAL_TYPE = new_references.INIT_CAL_TYPE) AND

Line 308: igs_ge_msg_stack.add;

304: new_references.INIT_CAL_TYPE,
305: new_references.INIT_SEQUENCE_NUMBER
306: ) THEN
307: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 4');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:
312: IF (((old_references.RECENT_CAL_TYPE = new_references.RECENT_CAL_TYPE) AND

Line 322: igs_ge_msg_stack.add;

318: new_references.RECENT_CAL_TYPE,
319: new_references.RECENT_SEQUENCE_NUMBER
320: ) THEN
321: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 5');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:
326: IF (((old_references.CATALOG_CAL_TYPE = new_references.CATALOG_CAL_TYPE) AND

Line 336: igs_ge_msg_stack.add;

332: new_references.CATALOG_CAL_TYPE,
333: new_references.CATALOG_SEQUENCE_NUMBER
334: ) THEN
335: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED 6');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:
340:

Line 477: igs_ge_msg_stack.ADD;

473: new_references.person_id
474: )
475: ) THEN
476: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
477: igs_ge_msg_stack.ADD;
478: app_exception.raise_exception;
479: END IF;
480: ELSIF (p_action = 'UPDATE') THEN
481: -- Call all the procedures related to Before Update.

Line 490: igs_ge_msg_stack.ADD;

486: new_references.person_id
487: )
488: ) THEN
489: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
490: igs_ge_msg_stack.ADD;
491: app_exception.raise_exception;
492: END IF;
493: END IF;
494:

Line 601: igs_ge_msg_stack.ADD;

597: x_program_update_date := SYSDATE;
598: END IF;
599: ELSE
600: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
601: igs_ge_msg_stack.ADD;
602: app_exception.raise_exception;
603: END IF;
604:
605: before_dml(

Line 800: igs_ge_msg_stack.add;

796: WHEN OTHERS THEN
797: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
798: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
799: fnd_message.set_token ('ERR_CD', SQLCODE);
800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;
803: ELSE
804: igs_sc_gen_001.unset_ctx('R');

Line 929: igs_ge_msg_stack.ADD;

925: OPEN c1;
926: FETCH c1 INTO tlinfo;
927: IF (c1%NOTFOUND) THEN
928: fnd_message.set_name('FND', 'FORM_RECORD_DELETED 7');
929: igs_ge_msg_stack.ADD;
930: CLOSE c1;
931: app_exception.raise_exception;
932: RETURN;
933: END IF;

Line 1029: igs_ge_msg_stack.ADD;

1025: ) THEN
1026: NULL;
1027: ELSE
1028: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1029: igs_ge_msg_stack.ADD;
1030: app_exception.raise_exception;
1031: END IF;
1032:
1033: RETURN;

Line 1124: igs_ge_msg_stack.ADD;

1120: x_last_update_login := -1;
1121: END IF;
1122: ELSE
1123: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1124: igs_ge_msg_stack.ADD;
1125: app_exception.raise_exception;
1126: END IF;
1127:
1128: before_dml(

Line 1260: igs_ge_msg_stack.add;

1256: WHERE ROWID = x_rowid;
1257:
1258: IF (SQL%NOTFOUND) THEN
1259: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1260: igs_ge_msg_stack.add;
1261: igs_sc_gen_001.unset_ctx('R');
1262: app_exception.raise_exception;
1263: END IF;
1264: IF (x_mode = 'S') THEN

Line 1275: igs_ge_msg_stack.add;

1271: WHEN OTHERS THEN
1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE
1279: igs_sc_gen_001.unset_ctx('R');

Line 1497: igs_ge_msg_stack.add;

1493: WHERE ROWID = x_rowid;
1494:
1495: IF (SQL%NOTFOUND) THEN
1496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1497: igs_ge_msg_stack.add;
1498: igs_sc_gen_001.unset_ctx('R');
1499: app_exception.raise_exception;
1500: END IF;
1501: IF (x_mode = 'S') THEN