45: x_last_update_login := -1;
46: END IF;
47: ELSE
48: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
49: app_exception.raise_exception;
50: END IF;
51:
52: INSERT INTO pa_utilization_options_all (
53: org_id,
123: FETCH c1 INTO tlinfo;
124: IF (c1%notfound) THEN
125: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
126: CLOSE c1;
127: app_exception.raise_exception;
128: RETURN;
129: END IF;
130: CLOSE c1;
131:
138: ) THEN
139: NULL;
140: ELSE
141: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
142: app_exception.raise_exception;
143: END IF;
144:
145: RETURN;
146:
186: x_last_update_login := -1;
187: END IF;
188: ELSE
189: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
190: app_exception.raise_exception;
191: END IF;
192:
193: UPDATE pa_utilization_options_all
194: SET