APPS.IGS_EN_NSU_DLSTP_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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;
57:

Line 100: App_Exception.Raise_Exception;

96: IF l_c_column_value ='INCL_WKEND_DURATION_FLAG' OR Column_Name IS NULL Then
97: IF New_References.incl_wkend_duration_flag NOT IN ( 'Y' , 'N' ) Then
98: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:
104: END Check_Constraints;

Line 126: app_exception.raise_exception;

122: )
123: ) THEN
124: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_uniqueness;
130:

Line 157: app_exception.raise_exception;

153: ELSIF NOT igs_or_unit_pkg.get_pk_for_str_validation (
154: new_references.org_unit_code) THEN
155: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159:
160: END check_parent_existance;
161:

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_uniqueness;
315: Check_Constraints;
316: check_parent_existance;

Line 333: app_exception.raise_exception;

329: )
330: ) THEN
331: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335: check_uniqueness;
336: Check_Constraints;
337: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 396: app_exception.raise_exception;

392: END IF;
393: ELSE
394: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:
399: SELECT igs_en_nsu_dlstp_all_s.NEXTVAL
400: INTO x_non_std_usec_dls_id

Line 514: app_exception.raise_exception;

510: IF (c1%notfound) THEN
511: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
512: igs_ge_msg_stack.add;
513: CLOSE c1;
514: app_exception.raise_exception;
515: RETURN;
516: END IF;
517: CLOSE c1;
518:

Line 533: app_exception.raise_exception;

529: NULL;
530: ELSE
531: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
532: igs_ge_msg_stack.add;
533: app_exception.raise_exception;
534: END IF;
535:
536: RETURN;
537:

Line 585: app_exception.raise_exception;

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