[Home] [Help]
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: -- Since this should never happen if the code flow has reached till here.
139: -- Throwing an exception with hard coded message text
140: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||X_RULE_OBJECT_NAME);
141: END ;
142:
143: insert into FUN_RULE_OBJECTS_B (
144: RULE_OBJECT_ID,
294: fetch c into recinfo;
295: if (c%notfound) then
296: close c;
297: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
298: app_exception.raise_exception;
299: end if;
300: close c;
301: if (((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
302: OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
303: ) then
304: null;
305: else
306: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
307: app_exception.raise_exception;
308: end if;
309: return;
310: end LOCK_ROW;
311:
866: WHERE application_short_name = X_APP_SHORT_NAME;
867: EXCEPTION
868: WHEN NO_DATA_FOUND THEN
869: -- Since this should never happen, throwing an exception with hard coded message text
870: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);
871: END;
872:
873: BEGIN
874: select RULE_OBJECT_ID
880:
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: -- Since this should never happen, throwing an exception with hard coded message text
884: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);
885: END;
886:
887: BEGIN
888: select last_updated_by, last_update_date
892: and language = userenv('LANG');
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: -- Since this should never happen, throwing an exception with hard coded message text
896: app_exception.raise_exception(exception_text=>'Unable to find translation row for rule object - '||x_rule_object_name||','||userenv('LANG'));
897: END;
898:
899: -- c. owners are the same, and file_date > db_date
900: if (fnd_load_util.UPLOAD_TEST(
1016: WHERE application_short_name = X_APP_SHORT_NAME;
1017: exception
1018: WHEN NO_DATA_FOUND THEN
1019: -- Since this should never happen, throwing an exception with hard coded message text
1020: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);
1021: end;
1022:
1023: --
1024: -- Get the FLEX_VALUE_SET_ID. Required only if name is not null
1029: where flex_value_set_name = X_FLEX_VALUE_SET_NAME;
1030: exception
1031: WHEN NO_DATA_FOUND THEN
1032: -- Since this should never happen, throwing an exception with hard coded message text
1033: app_exception.raise_exception(exception_text=>'Invalid value set name - '||x_flex_value_set_name);
1034: end;
1035: ELSE
1036: vsid := NULL;
1037: END IF;
1057:
1058: --Raise an internal error, if developer wants to update the USE_INSTANCE_FLAG from Y to N.
1059: --Else, if the flag is NULL and NULL is passed, then make it as N
1060: if ( l_use_instance_flag = 'Y' AND X_USE_INSTANCE_FLAG = 'N') then
1061: app_exception.raise_exception(exception_text=>'Cannot update USE_INSTANCE_FLAG from Y to N. Please use the upgrdae script for this');
1062: elsif ( l_use_instance_flag IS NULL AND X_USE_INSTANCE_FLAG IS NULL) then
1063: l_use_instance_flag := 'N';
1064: else
1065: l_use_instance_flag := X_USE_INSTANCE_FLAG;
1204: WHERE application_short_name = X_APP_SHORT_NAME;
1205: EXCEPTION
1206: WHEN NO_DATA_FOUND THEN
1207: -- Since this should never happen, throwing an exception with hard coded message text
1208: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);
1209: END;
1210:
1211: if (X_DEFAULT_APP_SHORT_NAME IS NOT NULL) then
1212: SELECT application_id INTO default_appid
1231: AND parent_rule_object_id IS NULL;
1232: EXCEPTION
1233: WHEN NO_DATA_FOUND THEN
1234: -- Since this should never happen, throwing an exception with hard coded message text
1235: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);
1236: END;
1237:
1238:
1239: BEGIN