DBA Data[Home] [Help]

APPS.IGS_PR_OU_UNIT_SET_PKG dependencies on FND_MESSAGE

Line 38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

34: -- Populate Old Values.
35: Open cur_old_ref_values;
36: Fetch cur_old_ref_values INTO old_references;
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;

Line 82: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

78: new_references.progression_rule_cat,
79: new_references.pra_sequence_number,
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;

Line 99: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

95: IF NOT IGS_EN_UNIT_SET_PKG.Get_PK_For_Validation (
96: new_references.unit_set_cd,
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:

Line 162: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_PRO_FK');

158:
159: Open cur_rowid;
160: Fetch cur_rowid INTO lv_rowid;
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;

Line 190: Fnd_Message.Set_Name ('IGS', 'IGS_PR_POUS_US_FK');

186:
187: Open cur_rowid;
188: Fetch cur_rowid INTO lv_rowid;
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;

Line 229: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

225: OPEN c_parent( new_references.progression_rule_cat, new_references.pra_sequence_number, new_references.pro_sequence_number );
226: FETCH c_parent INTO l_dummy;
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;

Line 242: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

238: OPEN c_parent( new_references.progression_rule_cat, new_references.pra_sequence_number, new_references.pro_sequence_number );
239: FETCH c_parent INTO l_dummy;
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;

Line 294: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

290: new_references.pra_sequence_number,
291: new_references.pro_sequence_number,
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;

Line 311: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

307: new_references.pra_sequence_number,
308: new_references.pro_sequence_number,
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:

Line 360: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

356: if X_LAST_UPDATE_LOGIN is NULL then
357: X_LAST_UPDATE_LOGIN := -1;
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 (

Line 432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

428: begin
429: open c1;
430: fetch c1 into tlinfo;
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;

Line 483: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

479: END IF ;
480:
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:

Line 492: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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:

Line 501: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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:

Line 510: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

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: