DBA Data[Home] [Help]

APPS.FUN_RULE_CRIT_PARAMS_PKG dependencies on APP_EXCEPTION

Line 118: app_exception.raise_exception;

114: fetch c into recinfo;
115: if (c%notfound) then
116: close c;
117: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
118: app_exception.raise_exception;
119: end if;
120: close c;
121: if (
122: recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER

Line 127: app_exception.raise_exception;

123: ) then
124: null;
125: else
126: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
127: app_exception.raise_exception;
128: end if;
129:
130: return;
131: end LOCK_ROW;

Line 371: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);

367: WHERE application_short_name = X_APP_SHORT_NAME;
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: -- Since this should never happen, throwing an exception with hard coded message text
371: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);
372: END;
373:
374: BEGIN
375: select RULE_OBJECT_ID

Line 384: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);

380: and parent_rule_object_id is null;
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: -- Since this should never happen, throwing an exception with hard coded message text
384: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);
385: END;
386:
387: BEGIN
388: select FLEX_VALUE_SET_ID

Line 395: app_exception.raise_exception(exception_text=>'Invalid value set name - '||x_flex_value_set_name);

391: where FLEX_VALUE_SET_NAME = X_FLEX_VALUE_SET_NAME;
392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: -- Since this should never happen, throwing an exception with hard coded message text
395: app_exception.raise_exception(exception_text=>'Invalid value set name - '||x_flex_value_set_name);
396: END;
397:
398: -- Translate owner to file_last_updated_by
399: f_luby := fnd_load_util.owner_id(x_owner);

Line 492: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);

488: WHERE application_short_name = X_APP_SHORT_NAME;
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN
491: -- Since this should never happen, throwing an exception with hard coded message text
492: app_exception.raise_exception(exception_text=>'Invalid application short name - '||X_APP_SHORT_NAME);
493: END;
494:
495: BEGIN
496: select RULE_OBJECT_ID

Line 505: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);

501: and parent_rule_object_id is null;
502: EXCEPTION
503: WHEN NO_DATA_FOUND THEN
504: -- Since this should never happen, throwing an exception with hard coded message text
505: app_exception.raise_exception(exception_text=>'Invalid rule object name - '||x_rule_object_name);
506: END;
507:
508: BEGIN
509: select criteria_param_id

Line 517: app_exception.raise_exception(exception_text=>'Invalid parameter name - '||x_param_name);

513: and param_name = X_PARAM_NAME;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: -- Since this should never happen, throwing an exception with hard coded message text
517: app_exception.raise_exception(exception_text=>'Invalid parameter name - '||x_param_name);
518: END;
519:
520: BEGIN
521: select last_updated_by, last_update_date

Line 529: app_exception.raise_exception(exception_text=>'Unable to find translation row for parameter - '||x_param_name||','||userenv('LANG'));

525: and language = userenv('LANG');
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN
528: -- Since this should never happen, throwing an exception with hard coded message text
529: app_exception.raise_exception(exception_text=>'Unable to find translation row for parameter - '||x_param_name||','||userenv('LANG'));
530: END;
531:
532: -- c. owners are the same, and file_date > db_date
533: if (fnd_load_util.UPLOAD_TEST(