DBA Data[Home] [Help]

APPS.IGS_PS_USEC_SP_FEES_PKG dependencies on FND_MESSAGE

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

43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;

Line 101: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');

97: END IF;
98:
99: IF l_c_column_name='CLOSED_FLAG' OR column_name IS NULL THEN
100: IF new_references.closed_flag NOT IN ( 'Y' , 'N' ) Then
101: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
102: igs_ge_msg_stack.ADD;
103: app_exception.raise_exception;
104: END IF;
105: END IF;

Line 109: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');

105: END IF;
106:
107: IF l_c_column_name ='SP_FEE_AMT' OR column_name IS NULL Then
108: IF new_references.sp_fee_amt <= 0 Then
109: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.ADD;
111: app_exception.raise_exception;
112: END IF;
113: END IF;

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

131: new_references.uoo_id,
132: new_references.fee_type
133: )
134: ) THEN
135: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:

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

157: NULL;
158: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
159: new_references.uoo_id
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:

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

168: NULL;
169: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
170: new_references.fee_type
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:

Line 277: fnd_message.set_name ('IGS', 'IGS_PS_USSF_UOO_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_USSF_UOO_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;

Line 313: fnd_message.set_name ('IGS', 'IGS_PS_USSF_FT_FK');

309: OPEN cur_rowid;
310: FETCH cur_rowid INTO lv_rowid;
311: IF (cur_rowid%FOUND) THEN
312: CLOSE cur_rowid;
313: fnd_message.set_name ('IGS', 'IGS_PS_USSF_FT_FK');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: RETURN;
317: END IF;

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

384: IF ( get_pk_for_validation(
385: new_references.usec_sp_fees_id
386: )
387: ) THEN
388: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392: check_uniqueness;

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

404: IF ( get_pk_for_validation (
405: new_references.usec_sp_fees_id
406: )
407: ) THEN
408: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_constraints;

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

460: IF (x_last_update_login IS NULL) THEN
461: x_last_update_login := -1;
462: END IF;
463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;

Line 465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');

461: x_last_update_login := -1;
462: END IF;
463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:

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

544:
545: OPEN c1;
546: FETCH c1 INTO tlinfo;
547: IF (c1%notfound) THEN
548: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
549: igs_ge_msg_stack.add;
550: CLOSE c1;
551: app_exception.raise_exception;
552: RETURN;

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

560: AND (tlinfo.closed_flag = x_closed_flag)
561: ) THEN
562: NULL;
563: ELSE
564: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:

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

608: IF (x_last_update_login IS NULL) THEN
609: x_last_update_login := -1;
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.UPDATE_ROW');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;

Line 613: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.UPDATE_ROW');

609: x_last_update_login := -1;
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.UPDATE_ROW');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;
617: