1: package body ame_li_job_level_handler as
2: /* $Header: ameeliha.pkb 120.6 2011/05/17 11:38:58 nchinnam ship $ */
3: /* package variables */
4: approverCategories ame_util.charList;
5: parametersCount integer;
146: tokenNameTwoIn => 'LAST_NAME',
147: tokenValueTwoIn => null ,
148: tokenNameThreeIn => 'OTHER_NAME',
149: tokenValueThreeIn => null );
150: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
151: routineNameIn => 'getCatSourceAndAuthority',
152: exceptionNumberIn => errorCode,
153: exceptionStringIn => errorMessage);
154: raise_application_error(errorCode,
156: when others then
157: categoryOut := null;
158: hasFinalAuthorityYNOut := null;
159: sourceOut := null;
160: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
161: routineNameIn => 'getCatSourceAndAuthority',
162: exceptionNumberIn => sqlcode,
163: exceptionStringIn => sqlerrm);
164: raise;
453: tokenNameTwoIn => 'LAST_NAME',
454: tokenValueTwoIn => null ,
455: tokenNameThreeIn => 'OTHER_NAME',
456: tokenValueThreeIn => null );
457: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
458: routineNameIn => 'handler',
459: exceptionNumberIn => errorCode,
460: exceptionStringIn => errorMessage);
461: raise_application_error(errorCode,
464: errorCode := -20001;
465: errorMessage :=
466: ame_util.getMessage(applicationShortNameIn => 'PER',
467: messageNameIn => 'AME_400450_LIHA_NO_PER_ID');
468: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
469: routineNameIn => 'handler',
470: exceptionNumberIn => errorCode,
471: exceptionStringIn => errorMessage);
472: raise_application_error(errorCode,
471: exceptionStringIn => errorMessage);
472: raise_application_error(errorCode,
473: errorMessage);
474: when others then
475: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
476: routineNameIn => 'handler',
477: exceptionNumberIn => sqlcode,
478: exceptionStringIn => sqlerrm);
479: l_error_code := sqlcode;
544: when badParameterException then
545: errorCode := -20001;
546: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
547: messageNameIn => 'AME_400234_HAN_ACT_PAR_SIGN');
548: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
549: routineNameIn => 'parseAndSortRules',
550: exceptionNumberIn => errorCode,
551: exceptionStringIn => errorMessage);
552: raise_application_error(errorCode,
551: exceptionStringIn => errorMessage);
552: raise_application_error(errorCode,
553: errorMessage);
554: when others then
555: ame_util.runtimeException(packageNameIn => 'ame_li_job_level_handler',
556: routineNameIn => 'parseAndSortRules',
557: exceptionNumberIn => sqlcode,
558: exceptionStringIn => sqlerrm);
559: raise;
557: exceptionNumberIn => sqlcode,
558: exceptionStringIn => sqlerrm);
559: raise;
560: end parseAndSortRules;
561: end ame_li_job_level_handler;