eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_APPROVER_TYPE_PKG dependencies on AME_APPROVER_TYPE_PKG

Line 1: package body ame_approver_type_pkg as

1: package body ame_approver_type_pkg as
2: /* $Header: ameoatyp.pkb 120.3.12000000.2 2007/01/31 18:09:07 prasashe noship $ */
3: function getApproverDescription(nameIn in varchar2) return varchar2 as
4: descriptionOut ame_util.longestStringType;
5: validityOut boolean;

Line 19: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

15: validityOut => validityOut);
16: return(descriptionOut);
17: exception
18: when others then
19: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
20: routineNameIn => 'getApproverDescription',
21: exceptionNumberIn => sqlcode,
22: exceptionStringIn => sqlerrm);
23: raise;

Line 75: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

71: tokenValueOneIn => origSystemIdIn,
72: tokenNameTwoIn => 'ORIG_SYSTEM',
73: tokenValueTwoIn => origSystemIn
74: );
75: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
76: routineNameIn => 'getApproverDescription2',
77: exceptionNumberIn => errorCode,
78: exceptionStringIn => errorMessage);
79: raise_application_error(errorCode,

Line 84: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

80: errorMessage);
81: end if;
82: return(null);
83: when others then
84: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
85: routineNameIn => 'getApproverDescription2',
86: exceptionNumberIn => sqlcode,
87: exceptionStringIn => sqlerrm);
88: raise;

Line 113: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

109: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
110: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
111: tokenNameOneIn => 'NAME',
112: tokenValueOneIn => nameIn);
113: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
114: routineNameIn => 'getApproverDisplayName',
115: exceptionNumberIn => errorCode,
116: exceptionStringIn => errorMessage);
117: raise_application_error(errorCode,

Line 122: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

118: errorMessage);
119: return(ame_util.getLabel(attributeApplicationIdIn => ame_util.perFndAppId,
120: attributeCodeIn => 'AME_INVALID_COLON') || nameIn);
121: when others then
122: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
123: routineNameIn => 'getApproverDisplayName',
124: exceptionNumberIn => sqlcode,
125: exceptionStringIn => sqlerrm);
126: raise;

Line 187: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

183: tokenValueOneIn => origSystemIdIn,
184: tokenNameTwoIn => 'ORIG_SYSTEM',
185: tokenValueTwoIn => origSystemIn
186: );
187: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
188: routineNameIn => 'getApproverDisplayName2',
189: exceptionNumberIn => errorCode,
190: exceptionStringIn => errorMessage);
191: raise_application_error(errorCode,

Line 195: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

191: raise_application_error(errorCode,
192: errorMessage);
193: return(null);
194: when others then
195: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
196: routineNameIn => 'getApproverDisplayName2',
197: exceptionNumberIn => sqlcode,
198: exceptionStringIn => sqlerrm);
199: raise;

Line 332: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

328: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
329: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
330: tokenNameOneIn => 'NAME',
331: tokenValueOneIn => nameIn);
332: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
333: routineNameIn => 'getApproverOrigSystem',
334: exceptionNumberIn => errorCode,
335: exceptionStringIn => errorMessage);
336: raise_application_error(errorCode,

Line 340: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

336: raise_application_error(errorCode,
337: errorMessage);
338: return(null);
339: when others then
340: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
341: routineNameIn => 'getApproverOrigSystem',
342: exceptionNumberIn => sqlcode,
343: exceptionStringIn => sqlerrm);
344: raise;

Line 409: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

405: ame_util.getMessage(applicationShortNameIn => 'PER',
406: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
407: tokenNameOneIn => 'NAME',
408: tokenValueOneIn => nameIn);
409: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
410: routineNameIn => 'getApproverOrigSystemId',
411: exceptionNumberIn => errorCode,
412: exceptionStringIn => errorMessage);
413: raise_application_error(errorCode,

Line 417: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

413: raise_application_error(errorCode,
414: errorMessage);
415: return(null);
416: when others then
417: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
418: routineNameIn => 'getApproverOrigSystemId',
419: exceptionNumberIn => sqlcode,
420: exceptionStringIn => sqlerrm);
421: raise;

Line 439: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

435: rownum < 2;
436: return(approverTypeId);
437: exception
438: when others then
439: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
440: routineNameIn => 'getApproverTypeId',
441: exceptionNumberIn => sqlcode,
442: exceptionStringIn => sqlerrm);
443: raise;

Line 461: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

457: rownum < 2;
458: return(origSystem);
459: exception
460: when others then
461: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
462: routineNameIn => 'getApproverTypeOrigSystem',
463: exceptionNumberIn => sqlcode,
464: exceptionStringIn => sqlerrm);
465: raise;

Line 479: return(ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem));

475: approver_type_id = approverTypeIdIn and
476: sysdate between start_date and
477: nvl(end_date - ame_util.oneSecond, sysdate) and
478: rownum < 2;
479: return(ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem));
480: exception
481: when others then
482: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
483: routineNameIn => 'getApproverTypeDisplayName',

Line 482: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

478: rownum < 2;
479: return(ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem));
480: exception
481: when others then
482: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
483: routineNameIn => 'getApproverTypeDisplayName',
484: exceptionNumberIn => sqlcode,
485: exceptionStringIn => sqlerrm);
486: raise;

Line 505: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

501: rownum < 2;
502: return(origDisplayName);
503: exception
504: when others then
505: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
506: routineNameIn => 'getOrigSystemDisplayName',
507: exceptionNumberIn => sqlcode,
508: exceptionStringIn => sqlerrm);
509: raise;

Line 527: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

523: rownum < 2;
524: return(queryProcedure);
525: exception
526: when others then
527: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
528: routineNameIn => 'getQueryProcedure',
529: exceptionNumberIn => sqlcode,
530: exceptionStringIn => sqlerrm);
531: raise;

Line 593: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

589: tokenValueOneIn => origSystemIdIn,
590: tokenNameTwoIn => 'ORIG_SYSTEM',
591: tokenValueTwoIn => origSystemIn
592: );
593: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
594: routineNameIn => 'getWfRolesName',
595: exceptionNumberIn => errorCode,
596: exceptionStringIn => errorMessage);
597: raise_application_error(errorCode,

Line 602: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

598: errorMessage);
599: end if;
600: return(null);
601: when others then
602: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
603: routineNameIn => 'getWfRolesName',
604: exceptionNumberIn => sqlcode,
605: exceptionStringIn => sqlerrm);
606: raise;

Line 627: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

623: end if;
624: return false;
625: exception
626: when others then
627: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
628: routineNameIn => 'allowsAllApproverTypes',
629: exceptionNumberIn => sqlcode,
630: exceptionStringIn => sqlerrm);
631: raise;

Line 719: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

715: exception
716: when no_data_found then
717: return false;
718: when others then
719: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
720: routineNameIn => 'isASubordinate',
721: exceptionNumberIn => sqlcode,
722: exceptionStringIn => sqlerrm);
723: raise;

Line 749: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

745: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
746: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
747: tokenNameOneIn => 'NAME',
748: tokenValueOneIn => nameIn);
749: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
750: routineNameIn => 'validateApprover',
751: exceptionNumberIn => errorCode,
752: exceptionStringIn => errorMessage);
753: raise_application_error(errorCode,

Line 757: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

753: raise_application_error(errorCode,
754: errorMessage);
755: return(false);
756: when others then
757: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
758: routineNameIn => 'validateApprover',
759: exceptionNumberIn => sqlcode,
760: exceptionStringIn => sqlerrm);
761: raise;

Line 849: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

845: errorCode := -20001;
846: errorMessage :=
847: ame_util.getMessage(applicationShortNameIn => 'PER',
848: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
849: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
850: routineNameIn => 'fndUsrApproverQuery',
851: exceptionNumberIn => errorCode,
852: exceptionStringIn => errorMessage);
853: approverNamesOut := null;

Line 862: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

858: errorCode := -20001;
859: errorMessage :=
860: ame_util.getMessage(applicationShortNameIn => 'PER',
861: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
862: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
863: routineNameIn => 'fndUsrApproverQuery',
864: exceptionNumberIn => errorCode,
865: exceptionStringIn => errorMessage);
866: approverNamesOut := null;

Line 871: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

867: approverDescriptionsOut := null;
868: raise_application_error(errorCode,
869: errorMessage);
870: when others then
871: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
872: routineNameIn => 'fndUsrApproverQuery',
873: exceptionNumberIn => sqlcode,
874: exceptionStringIn => sqlerrm);
875: approverNamesOut := null;

Line 961: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

957: errorCode := -20001;
958: errorMessage :=
959: ame_util.getMessage(applicationShortNameIn => 'PER',
960: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
961: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
962: routineNameIn => 'fndRespApproverQuery',
963: exceptionNumberIn => errorCode,
964: exceptionStringIn => errorMessage);
965: approverNamesOut := null;

Line 974: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

970: errorCode := -20001;
971: errorMessage :=
972: ame_util.getMessage(applicationShortNameIn => 'PER',
973: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
974: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
975: routineNameIn => 'fndRespApproverQuery',
976: exceptionNumberIn => errorCode,
977: exceptionStringIn => errorMessage);
978: approverNamesOut := null;

Line 983: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

979: approverDescriptionsOut := null;
980: raise_application_error(errorCode,
981: errorMessage);
982: when others then
983: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
984: routineNameIn => 'fndRespApproverQuery',
985: exceptionNumberIn => sqlcode,
986: exceptionStringIn => sqlerrm);
987: approverNamesOut := null;

Line 1051: ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem)

1047: if(origSystem like ame_util.fndRespOrigSystem || '%') then
1048: origSystem := ame_util.fndRespOrigSystem;
1049: end if;
1050: descriptionOut :=
1051: ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem)
1052: ||': '
1053: ||descriptionOut;
1054: end if;
1055: if(not validityOut) then

Line 1064: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1060: when others then
1061: descriptionOut := ame_util.getLabel(attributeApplicationIdIn => ame_util.perFndAppId,
1062: attributeCodeIn => 'AME_INVALID_COLON') || nameIn;
1063: validityOut := false;
1064: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1065: routineNameIn => 'getApproverDescAndValidity',
1066: exceptionNumberIn => sqlcode,
1067: exceptionStringIn => sqlerrm);
1068: raise;

Line 1098: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1094: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1095: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
1096: tokenNameOneIn => 'NAME',
1097: tokenValueOneIn => nameIn);
1098: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1099: routineNameIn => 'getApproverOrigSystemAndId',
1100: exceptionNumberIn => errorCode,
1101: exceptionStringIn => errorMessage);
1102: raise_application_error(errorCode,

Line 1105: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1101: exceptionStringIn => errorMessage);
1102: raise_application_error(errorCode,
1103: errorMessage);
1104: when others then
1105: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1106: routineNameIn => 'getApproverOrigSystemAndId',
1107: exceptionNumberIn => sqlcode,
1108: exceptionStringIn => sqlerrm);
1109: origSystemOut := null;

Line 1153: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1149: end loop;
1150: exception
1151: when others then
1152: rollback;
1153: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1154: routineNameIn => 'getApprovalTypes',
1155: exceptionNumberIn => sqlcode,
1156: exceptionStringIn => sqlerrm);
1157: actionTypeNamesOut := ame_util.emptyStringList;

Line 1206: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1202: end loop;
1203: exception
1204: when others then
1205: rollback;
1206: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1207: routineNameIn => 'getApproverTypeQueryData',
1208: exceptionNumberIn => sqlcode,
1209: exceptionStringIn => sqlerrm);
1210: queryVariableLabelsOut := ame_util.emptyLongStringList;

Line 1222: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1218: approverTypeNamesOut out nocopy ame_util.stringList) as
1219: cursor getApproverTypeDataCursor is
1220: select
1221: approver_type_id,
1222: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1223: from ame_approver_types
1224: where sysdate between
1225: start_date and
1226: nvl(end_date - ame_util.oneSecond, sysdate);

Line 1230: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1226: nvl(end_date - ame_util.oneSecond, sysdate);
1227: cursor getApproverTypeDataCursor2 is
1228: select
1229: approver_type_id,
1230: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1231: from ame_approver_types
1232: where
1233: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
1234: sysdate between

Line 1271: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1267: end if;
1268: exception
1269: when others then
1270: rollback;
1271: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1272: routineNameIn => 'getAvailableApproverTypes',
1273: exceptionNumberIn => sqlcode,
1274: exceptionStringIn => sqlerrm);
1275: approverTypeIdsOut := ame_util.emptyStringList;

Line 1285: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1281: approverTypeNamesOut out nocopy ame_util.stringList) as
1282: cursor unusedApproverTypeCursor is
1283: select
1284: approver_type_id,
1285: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1286: from ame_approver_types
1287: where sysdate between
1288: start_date and
1289: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1293: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1289: nvl(end_date - ame_util.oneSecond, sysdate)
1290: minus
1291: select
1292: ame_approver_types.approver_type_id,
1293: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1294: from ame_approver_types,
1295: ame_approver_type_usages
1296: where
1297: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

Line 1320: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1316: end loop;
1317: exception
1318: when others then
1319: rollback;
1320: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1321: routineNameIn => 'getAvailableApproverTypes2',
1322: exceptionNumberIn => sqlcode,
1323: exceptionStringIn => sqlerrm);
1324: approverTypeIdsOut := ame_util.emptyStringList;

Line 1350: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1346: end loop;
1347: exception
1348: when others then
1349: rollback;
1350: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1351: routineNameIn => 'getAvailableApproverTypes3',
1352: exceptionNumberIn => sqlcode,
1353: exceptionStringIn => sqlerrm);
1354: approverTypeIdsOut := ame_util.emptyIdList;

Line 1389: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1385: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1386: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
1387: tokenNameOneIn => 'NAME',
1388: tokenValueOneIn => nameIn);
1389: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1390: routineNameIn => 'getOrigSystemIdAndDisplayName',
1391: exceptionNumberIn => errorCode,
1392: exceptionStringIn => errorMessage);
1393: raise_application_error(errorCode,

Line 1399: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1395: when others then
1396: origSystemOut := null;
1397: origSystemIdOut := null;
1398: displayNameOut := null;
1399: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1400: routineNameIn => 'getOrigSystemIdAndDisplayName',
1401: exceptionNumberIn => sqlcode,
1402: exceptionStringIn => sqlerrm);
1403: raise;

Line 1584: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1580: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1581: messageNameIn => 'AME_400436_APPR_NO_APPR_EXTS',
1582: tokenNameOneIn => 'NAME',
1583: tokenValueOneIn => approverName);
1584: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1585: routineNameIn => 'getSuperior',
1586: exceptionNumberIn => errorCode,
1587: exceptionStringIn => errorMessage);
1588: raise_application_error(errorCode,

Line 1591: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1587: exceptionStringIn => errorMessage);
1588: raise_application_error(errorCode,
1589: errorMessage);
1590: when others then
1591: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1592: routineNameIn => 'getSuperior',
1593: exceptionNumberIn => sqlcode,
1594: exceptionStringIn => sqlerrm);
1595: raise;

Line 1777: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1773: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1774: messageNameIn => 'AME_400436_APPR_NO_APPR_EXTS',
1775: tokenNameOneIn => 'NAME',
1776: tokenValueOneIn => approverName);
1777: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1778: routineNameIn => 'getSurrogate',
1779: exceptionNumberIn => errorCode,
1780: exceptionStringIn => errorMessage);
1781: raise_application_error(errorCode,

Line 1784: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1780: exceptionStringIn => errorMessage);
1781: raise_application_error(errorCode,
1782: errorMessage);
1783: when others then
1784: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1785: routineNameIn => 'getSurrogate',
1786: exceptionNumberIn => sqlcode,
1787: exceptionStringIn => sqlerrm);
1788: raise;

Line 1855: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1851: tokenValueOneIn => origSystemIdIn,
1852: tokenNameTwoIn => 'ORIG_SYSTEM',
1853: tokenValueTwoIn => origSystemIn
1854: );
1855: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1856: routineNameIn => 'getWfRolesNameAndDisplayName',
1857: exceptionNumberIn => errorCode,
1858: exceptionStringIn => errorMessage);
1859: nameOut := null;

Line 1864: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1860: displayNameOut := null;
1861: raise_application_error(errorCode,
1862: errorMessage);
1863: when others then
1864: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1865: routineNameIn => 'getWfRolesNameAndDisplayName',
1866: exceptionNumberIn => sqlcode,
1867: exceptionStringIn => sqlerrm);
1868: nameOut := null;

Line 1899: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1895: null);
1896: exception
1897: when others then
1898: rollback;
1899: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1900: routineNameIn => 'newApproverTypeUsage',
1901: exceptionNumberIn => sqlcode,
1902: exceptionStringIn => sqlerrm);
1903: raise;

Line 1927: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

1923: end if;
1924: exception
1925: when others then
1926: rollback;
1927: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1928: routineNameIn => 'newApproverTypeUsages',
1929: exceptionNumberIn => sqlcode,
1930: exceptionStringIn => sqlerrm);
1931: raise;

Line 2032: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2028: errorCode := -20001;
2029: errorMessage :=
2030: ame_util.getMessage(applicationShortNameIn => 'PER',
2031: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
2032: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2033: routineNameIn => 'perApproverQuery',
2034: exceptionNumberIn => errorCode,
2035: exceptionStringIn => errorMessage);
2036: approverNamesOut := null;

Line 2045: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2041: errorCode := -20001;
2042: errorMessage :=
2043: ame_util.getMessage(applicationShortNameIn => 'PER',
2044: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
2045: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2046: routineNameIn => 'perApproverQuery',
2047: exceptionNumberIn => errorCode,
2048: exceptionStringIn => errorMessage);
2049: approverNamesOut := null;

Line 2054: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2050: approverDescriptionsOut := null;
2051: raise_application_error(errorCode,
2052: errorMessage);
2053: when others then
2054: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2055: routineNameIn => 'perApproverQuery',
2056: exceptionNumberIn => sqlcode,
2057: exceptionStringIn => sqlerrm);
2058: approverNamesOut := null;

Line 2148: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2144: errorCode := -20001;
2145: errorMessage :=
2146: ame_util.getMessage(applicationShortNameIn => 'PER',
2147: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
2148: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2149: routineNameIn => 'posApproverQuery',
2150: exceptionNumberIn => errorCode,
2151: exceptionStringIn => errorMessage);
2152: approverNamesOut := null;

Line 2161: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2157: errorCode := -20001;
2158: errorMessage :=
2159: ame_util.getMessage(applicationShortNameIn => 'PER',
2160: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
2161: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2162: routineNameIn => 'posApproverQuery',
2163: exceptionNumberIn => errorCode,
2164: exceptionStringIn => errorMessage);
2165: approverNamesOut := null;

Line 2170: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2166: approverDescriptionsOut := null;
2167: raise_application_error(errorCode,
2168: errorMessage);
2169: when others then
2170: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2171: routineNameIn => 'posApproverQuery',
2172: exceptionNumberIn => sqlcode,
2173: exceptionStringIn => sqlerrm);
2174: approverNamesOut := null;

Line 2206: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2202: close variableCur;
2203: exception
2204: when others then
2205: rollback;
2206: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2207: routineNameIn => 'processApproverQuery',
2208: exceptionNumberIn => sqlcode,
2209: exceptionStringIn => sqlerrm);
2210: approverNamesOut := ame_util.emptyLongStringList;

Line 2239: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2235: close variableCur;
2236: exception
2237: when others then
2238: rollback;
2239: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2240: routineNameIn => 'processApproverQuery2',
2241: exceptionNumberIn => sqlcode,
2242: exceptionStringIn => sqlerrm);
2243: approverNamesOut := ame_util.emptyLongStringList;

Line 2270: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2266: nvl(end_date - ame_util.oneSecond, processingDateIn) ;
2267: exception
2268: when others then
2269: rollback;
2270: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2271: routineNameIn => 'removeApproverTypeUsage',
2272: exceptionNumberIn => sqlcode,
2273: exceptionStringIn => sqlerrm);
2274: raise;

Line 2300: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

2296: end if;
2297: exception
2298: when others then
2299: rollback;
2300: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2301: routineNameIn => 'removeApproverTypeUsages',
2302: exceptionNumberIn => sqlcode,
2303: exceptionStringIn => sqlerrm);
2304: raise;

Line 2306: end ame_approver_type_pkg;

2302: exceptionNumberIn => sqlcode,
2303: exceptionStringIn => sqlerrm);
2304: raise;
2305: end removeApproverTypeUsages;
2306: end ame_approver_type_pkg;