[Home] [Help]
37: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: Close cur_old_ref_values;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:
80: new_references.pro_sequence_number
81: ) THEN
82: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85:
86: END IF;
87: END IF;
88:
97: new_references.us_version_number
98: ) THEN
99: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103:
104: END IF;
105:
161: IF (cur_rowid%FOUND) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_PRO_FK');
163: IGS_GE_MSG_STACK.ADD;
164: Close cur_rowid;
165: App_Exception.Raise_Exception;
166: Return;
167: END IF;
168: Close cur_rowid;
169:
189: IF (cur_rowid%FOUND) THEN
190: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_US_FK');
191: IGS_GE_MSG_STACK.ADD;
192: Close cur_rowid;
193: App_Exception.Raise_Exception;
194: Return;
195: END IF;
196: Close cur_rowid;
197:
227: IF c_parent%NOTFOUND THEN
228: CLOSE c_parent;
229: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: CLOSE c_parent;
234: ELSIF(p_action = 'UPDATE') THEN
235: IF new_references.progression_rule_cat <> old_references.progression_rule_cat OR
240: IF c_parent%NOTFOUND THEN
241: CLOSE c_parent;
242: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: END IF;
246: CLOSE c_parent;
247: END IF;
248: END IF;
292: new_references.unit_set_cd,
293: new_references.us_version_number) THEN
294: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297: END IF;
298: CHECK_CONSTRAINTS;
299:
300: ELSIF (p_action = 'UPDATE') THEN
309: new_references.unit_set_cd,
310: new_references.us_version_number) THEN
311: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315:
316: CHECK_CONSTRAINTS;
317: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
358: end if;
359: else
360: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
361: IGS_GE_MSG_STACK.ADD;
362: app_exception.raise_exception;
363: end if;
364: Before_DML (
365: p_action => 'INSERT',
366: x_rowid => x_rowid ,
431: if (c1%notfound) then
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: close c1;
435: app_exception.raise_exception;
436: return;
437: end if;
438: close c1;
439: return;
481: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
482: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
483: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
484: IGS_GE_MSG_STACK.ADD;
485: App_Exception.Raise_Exception ;
486: END IF;
487:
488: END IF ;
489:
490: IF upper(Column_name) = 'UNIT_SET_CD' OR COLUMN_NAME IS NULL THEN
491: IF new_references.UNIT_SET_CD<> upper(new_references.UNIT_SET_CD) then
492: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
493: IGS_GE_MSG_STACK.ADD;
494: App_Exception.Raise_Exception ;
495: END IF;
496:
497: END IF ;
498:
499: IF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
500: IF new_references.PRA_SEQUENCE_NUMBER < 1 or new_references.PRA_SEQUENCE_NUMBER > 999999 then
501: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
502: IGS_GE_MSG_STACK.ADD;
503: App_Exception.Raise_Exception ;
504: END IF;
505:
506: END IF ;
507:
508: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
509: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
510: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception ;
513: END IF;
514:
515: END IF ;
516: