DBA Data[Home] [Help]

APPS.IGS_CO_S_PER_LT_PARM_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

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

Line 115: igs_ge_msg_stack.add;

111: IF (UPPER(column_name) = 'SPLRG_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
112: IF NOT (new_references.splrg_sequence_number BETWEEN 1
113: AND 9999999999) THEN
114: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118: END IF;
119:

Line 124: igs_ge_msg_stack.add;

120: IF (UPPER(column_name) = 'SPL_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
121: IF NOT (new_references.spl_sequence_number BETWEEN 1
122: AND 9999999999) THEN
123: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: END IF;
127: END IF;
128:

Line 133: igs_ge_msg_stack.add;

129: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN
130: IF NOT (new_references.sequence_number BETWEEN 1
131: AND 9999999999) THEN
132: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
133: igs_ge_msg_stack.add;
134: app_exception.raise_exception;
135: END IF;
136: END IF;
137:

Line 166: igs_ge_msg_stack.add;

162: new_references.correspondence_type,
163: new_references.letter_reference_number
164: ) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169:
170: IF (((old_references.person_id = new_references.person_id) AND

Line 186: igs_ge_msg_stack.add;

182: new_references.letter_reference_number,
183: new_references.spl_sequence_number
184: ) THEN
185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189:
190: IF (((old_references.letter_order_number = new_references.letter_order_number) AND

Line 206: igs_ge_msg_stack.add;

202: new_references.letter_reference_number,
203: new_references.letter_repeating_group_cd
204: ) THEN
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: IF (((old_references.person_id = new_references.person_id) AND

Line 232: igs_ge_msg_stack.add;

228: new_references.letter_repeating_group_cd,
229: new_references.splrg_sequence_number
230: ) THEN
231: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235:
236: END check_parent_existance;

Line 314: igs_ge_msg_stack.add;

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

Line 355: igs_ge_msg_stack.add;

351: FETCH cur_rowid INTO lv_rowid;
352: IF (cur_rowid%FOUND) THEN
353: CLOSE cur_rowid;
354: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: RETURN;
358: END IF;
359: CLOSE cur_rowid;

Line 396: igs_ge_msg_stack.add;

392: FETCH cur_rowid INTO lv_rowid;
393: IF (cur_rowid%FOUND) THEN
394: CLOSE cur_rowid;
395: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: RETURN;
399: END IF;
400: CLOSE cur_rowid;

Line 441: igs_ge_msg_stack.add;

437: FETCH cur_rowid INTO lv_rowid;
438: IF (cur_rowid%FOUND) THEN
439: CLOSE cur_rowid;
440: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;
445: CLOSE cur_rowid;

Line 515: igs_ge_msg_stack.add;

511: new_references.sequence_number
512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_constraints;
519: check_parent_existance;

Line 536: igs_ge_msg_stack.add;

532: new_references.sequence_number
533: )
534: ) THEN
535: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
536: igs_ge_msg_stack.add;
537: app_exception.raise_exception;
538: END IF;
539: check_constraints;
540: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 618: igs_ge_msg_stack.add;

614: x_program_update_date := SYSDATE;
615: END IF;
616: ELSE
617: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:
622: before_dml(

Line 740: igs_ge_msg_stack.add;

736: OPEN c1;
737: FETCH c1 INTO tlinfo;
738: IF (c1%notfound) THEN
739: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
740: igs_ge_msg_stack.add;
741: CLOSE c1;
742: app_exception.raise_exception;
743: RETURN;
744: END IF;

Line 757: igs_ge_msg_stack.add;

753: ) THEN
754: NULL;
755: ELSE
756: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
760:
761: RETURN;

Line 814: igs_ge_msg_stack.add;

810: x_last_update_login := -1;
811: END IF;
812: ELSE
813: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
814: igs_ge_msg_stack.add;
815: app_exception.raise_exception;
816: END IF;
817:
818: before_dml(