DBA Data[Home] [Help]

APPS.IGS_CO_S_PERLT_RPTGP_PKG dependencies on IGS_GE_MSG_STACK

Line 52: igs_ge_msg_stack.add;

48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
56: CLOSE cur_old_ref_values;

Line 111: igs_ge_msg_stack.add;

107: IF (UPPER(column_name) = 'SPL_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
108: IF NOT (new_references.spl_sequence_number BETWEEN 1
109: AND 9999999999) THEN
110: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114: END IF;
115:

Line 120: igs_ge_msg_stack.add;

116: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN
117: IF NOT (new_references.sequence_number BETWEEN 1
118: AND 9999999999) THEN
119: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
124:

Line 129: igs_ge_msg_stack.add;

125: IF (UPPER(column_name) = 'SUP_SPLRG_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
126: IF NOT (new_references.sup_splrg_sequence_number BETWEEN 1
127: AND 9999999999) THEN
128: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132: END IF;
133:

Line 171: igs_ge_msg_stack.add;

167: new_references.sup_repeating_group_cd,
168: new_references.sup_splrg_sequence_number
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: IF (((old_references.person_id = new_references.person_id) AND

Line 191: igs_ge_msg_stack.add;

187: new_references.letter_reference_number,
188: new_references.spl_sequence_number
189: ) THEN
190: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception;
193: END IF;
194:
195: IF (((old_references.correspondence_type = new_references.correspondence_type) AND

Line 208: igs_ge_msg_stack.add;

204: new_references.letter_reference_number,
205: new_references.letter_repeating_group_cd
206: ) THEN
207: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211:
212: END check_parent_existance;

Line 329: igs_ge_msg_stack.add;

325: FETCH cur_rowid INTO lv_rowid;
326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;

Line 370: igs_ge_msg_stack.add;

366: FETCH cur_rowid INTO lv_rowid;
367: IF (cur_rowid%FOUND) THEN
368: CLOSE cur_rowid;
369: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: RETURN;
373: END IF;
374: CLOSE cur_rowid;

Line 409: igs_ge_msg_stack.add;

405: FETCH cur_rowid INTO lv_rowid;
406: IF (cur_rowid%FOUND) THEN
407: CLOSE cur_rowid;
408: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE cur_rowid;

Line 479: igs_ge_msg_stack.add;

475: new_references.sequence_number
476: )
477: ) THEN
478: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482: check_constraints;
483: check_parent_existance;

Line 503: igs_ge_msg_stack.add;

499: new_references.sequence_number
500: )
501: ) THEN
502: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: check_constraints;
507: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 585: igs_ge_msg_stack.add;

581: x_program_update_date := SYSDATE;
582: END IF;
583: ELSE
584: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: before_dml(

Line 695: igs_ge_msg_stack.add;

691: OPEN c1;
692: FETCH c1 INTO tlinfo;
693: IF (c1%notfound) THEN
694: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
695: igs_ge_msg_stack.add;
696: CLOSE c1;
697: app_exception.raise_exception;
698: RETURN;
699: END IF;

Line 709: igs_ge_msg_stack.add;

705: ) THEN
706: NULL;
707: ELSE
708: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
709: igs_ge_msg_stack.add;
710: app_exception.raise_exception;
711: END IF;
712:
713: RETURN;

Line 764: igs_ge_msg_stack.add;

760: x_last_update_login := -1;
761: END IF;
762: ELSE
763: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
764: igs_ge_msg_stack.add;
765: app_exception.raise_exception;
766: END IF;
767:
768: before_dml(