DBA Data[Home] [Help]

APPS.IGS_PS_NSUS_RTN_DTL_PKG dependencies on FND_MESSAGE

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

45: OPEN cur_old_ref_values;
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;

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

104: END IF;
105:
106: IF l_c_column_value ='OFFSET_VALUE' OR Column_Name IS NULL THEN
107: IF New_References.offset_value < 0 OR New_References.offset_value > 999 THEN
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;

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

112: END IF;
113:
114: IF l_c_column_value ='RETENTION_PERCENT' OR Column_Name IS NULL THEN
115: IF New_References.retention_percent < 0 OR New_References.retention_percent > 100 THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;

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

120: END IF;
121:
122: IF l_c_column_value ='RETENTION_AMOUNT' OR Column_Name IS NULL THEN
123: IF New_References.retention_amount < 0 OR New_References.retention_amount > 999999.99 THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;

Line 149: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

145: new_references.non_std_usec_rtn_id,
146: new_references.offset_value
147: )
148: ) THEN
149: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
150: igs_ge_msg_stack.add;
151: app_exception.raise_exception;
152: END IF;
153:

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

170: NULL;
171: ELSIF NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
172: new_references.non_std_usec_rtn_id
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:

Line 277: fnd_message.set_name ('IGS', 'IGS_PS_NRD_NR_FK');

273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('IGS', 'IGS_PS_NRD_NR_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;

Line 338: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

334: IF ( get_pk_for_validation(
335: new_references.non_std_usec_rtn_dtl_id
336: )
337: ) THEN
338: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342: check_uniqueness;

Line 356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

352: IF ( get_pk_for_validation (
353: new_references.non_std_usec_rtn_dtl_id
354: )
355: ) THEN
356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: check_uniqueness;

Line 412: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

408: IF (x_last_update_login IS NULL) THEN
409: x_last_update_login := -1;
410: END IF;
411: ELSE
412: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
413: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.INSERT_ROW');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;

Line 413: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.INSERT_ROW');

409: x_last_update_login := -1;
410: END IF;
411: ELSE
412: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
413: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.INSERT_ROW');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417:

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

502:
503: OPEN c1;
504: FETCH c1 INTO tlinfo;
505: IF (c1%notfound) THEN
506: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
507: igs_ge_msg_stack.add;
508: CLOSE c1;
509: app_exception.raise_exception;
510: RETURN;

Line 524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

520: AND (tlinfo.override_date_flag = x_override_date_flag)
521: ) THEN
522: NULL;
523: ELSE
524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
525: igs_ge_msg_stack.add;
526: app_exception.raise_exception;
527: END IF;
528:

Line 574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

570: IF (x_last_update_login IS NULL) THEN
571: x_last_update_login := -1;
572: END IF;
573: ELSE
574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
575: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.UPDATE_ROW');
576: igs_ge_msg_stack.add;
577: app_exception.raise_exception;
578: END IF;

Line 575: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.UPDATE_ROW');

571: x_last_update_login := -1;
572: END IF;
573: ELSE
574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
575: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.UPDATE_ROW');
576: igs_ge_msg_stack.add;
577: app_exception.raise_exception;
578: END IF;
579: