DBA Data[Home] [Help]

APPS.IGS_EN_NSU_DLSTP_PKG dependencies on IGS_OR_UNIT_PKG

Line 145: igs_or_unit_pkg.get_pk_for_str_validation.

141: Nishikant 09DEC2002 Bug#2688542. For the field org_unit_cd
142: the foreign key check was done in this
143: procedure itself. Now its modified for
144: consistency to make a call to the function
145: igs_or_unit_pkg.get_pk_for_str_validation.
146: ***************************************************************/
147:
148: BEGIN
149:

Line 153: ELSIF NOT igs_or_unit_pkg.get_pk_for_str_validation (

149:
150: IF (((old_references.org_unit_code = new_references.org_unit_code)) OR
151: ((new_references.org_unit_code IS NULL))) THEN
152: NULL;
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;