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.8.12020000.3 2012/09/25 12:32:25 nivsubra ship $ */
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 448: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',

444: ame_util.getMessage(applicationShortNameIn => 'PER',
445: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
446: tokenNameOneIn => 'NAME',
447: tokenValueOneIn => nameIn);
448: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
449: routineNameIn => 'getApproverOrigSystemId',
450: exceptionNumberIn => errorCode,
451: exceptionStringIn => errorMessage);
452: raise_application_error(errorCode,

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

452: raise_application_error(errorCode,
453: errorMessage);
454: return(null);
455: when others then
456: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
457: routineNameIn => 'getApproverOrigSystemId',
458: exceptionNumberIn => sqlcode,
459: exceptionStringIn => sqlerrm);
460: raise;

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

474: rownum < 2;
475: return(approverTypeId);
476: exception
477: when others then
478: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
479: routineNameIn => 'getApproverTypeId',
480: exceptionNumberIn => sqlcode,
481: exceptionStringIn => sqlerrm);
482: raise;

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

496: rownum < 2;
497: return(origSystem);
498: exception
499: when others then
500: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
501: routineNameIn => 'getApproverTypeOrigSystem',
502: exceptionNumberIn => sqlcode,
503: exceptionStringIn => sqlerrm);
504: raise;

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

514: approver_type_id = approverTypeIdIn and
515: sysdate between start_date and
516: nvl(end_date - ame_util.oneSecond, sysdate) and
517: rownum < 2;
518: return(ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem));
519: exception
520: when others then
521: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
522: routineNameIn => 'getApproverTypeDisplayName',

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

517: rownum < 2;
518: return(ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem));
519: exception
520: when others then
521: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
522: routineNameIn => 'getApproverTypeDisplayName',
523: exceptionNumberIn => sqlcode,
524: exceptionStringIn => sqlerrm);
525: raise;

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

540: rownum < 2;
541: return(origDisplayName);
542: exception
543: when others then
544: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
545: routineNameIn => 'getOrigSystemDisplayName',
546: exceptionNumberIn => sqlcode,
547: exceptionStringIn => sqlerrm);
548: raise;

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

562: rownum < 2;
563: return(queryProcedure);
564: exception
565: when others then
566: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
567: routineNameIn => 'getQueryProcedure',
568: exceptionNumberIn => sqlcode,
569: exceptionStringIn => sqlerrm);
570: raise;

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

628: tokenValueOneIn => origSystemIdIn,
629: tokenNameTwoIn => 'ORIG_SYSTEM',
630: tokenValueTwoIn => origSystemIn
631: );
632: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
633: routineNameIn => 'getWfRolesName',
634: exceptionNumberIn => errorCode,
635: exceptionStringIn => errorMessage);
636: raise_application_error(errorCode,

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

637: errorMessage);
638: end if;
639: return(null);
640: when others then
641: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
642: routineNameIn => 'getWfRolesName',
643: exceptionNumberIn => sqlcode,
644: exceptionStringIn => sqlerrm);
645: raise;

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

662: end if;
663: return false;
664: exception
665: when others then
666: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
667: routineNameIn => 'allowsAllApproverTypes',
668: exceptionNumberIn => sqlcode,
669: exceptionStringIn => sqlerrm);
670: raise;

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

759: exception
760: when no_data_found then
761: return false;
762: when others then
763: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
764: routineNameIn => 'isASubordinate',
765: exceptionNumberIn => sqlcode,
766: exceptionStringIn => sqlerrm);
767: raise;

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

789: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
790: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
791: tokenNameOneIn => 'NAME',
792: tokenValueOneIn => nameIn);
793: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
794: routineNameIn => 'validateApprover',
795: exceptionNumberIn => errorCode,
796: exceptionStringIn => errorMessage);
797: raise_application_error(errorCode,

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

797: raise_application_error(errorCode,
798: errorMessage);
799: return(false);
800: when others then
801: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
802: routineNameIn => 'validateApprover',
803: exceptionNumberIn => sqlcode,
804: exceptionStringIn => sqlerrm);
805: raise;

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

889: errorCode := -20001;
890: errorMessage :=
891: ame_util.getMessage(applicationShortNameIn => 'PER',
892: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
893: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
894: routineNameIn => 'fndUsrApproverQuery',
895: exceptionNumberIn => errorCode,
896: exceptionStringIn => errorMessage);
897: approverNamesOut := null;

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

902: errorCode := -20001;
903: errorMessage :=
904: ame_util.getMessage(applicationShortNameIn => 'PER',
905: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
906: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
907: routineNameIn => 'fndUsrApproverQuery',
908: exceptionNumberIn => errorCode,
909: exceptionStringIn => errorMessage);
910: approverNamesOut := null;

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

911: approverDescriptionsOut := null;
912: raise_application_error(errorCode,
913: errorMessage);
914: when others then
915: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
916: routineNameIn => 'fndUsrApproverQuery',
917: exceptionNumberIn => sqlcode,
918: exceptionStringIn => sqlerrm);
919: approverNamesOut := null;

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

1001: errorCode := -20001;
1002: errorMessage :=
1003: ame_util.getMessage(applicationShortNameIn => 'PER',
1004: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
1005: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1006: routineNameIn => 'fndRespApproverQuery',
1007: exceptionNumberIn => errorCode,
1008: exceptionStringIn => errorMessage);
1009: approverNamesOut := null;

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

1014: errorCode := -20001;
1015: errorMessage :=
1016: ame_util.getMessage(applicationShortNameIn => 'PER',
1017: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
1018: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1019: routineNameIn => 'fndRespApproverQuery',
1020: exceptionNumberIn => errorCode,
1021: exceptionStringIn => errorMessage);
1022: approverNamesOut := null;

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

1023: approverDescriptionsOut := null;
1024: raise_application_error(errorCode,
1025: errorMessage);
1026: when others then
1027: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1028: routineNameIn => 'fndRespApproverQuery',
1029: exceptionNumberIn => sqlcode,
1030: exceptionStringIn => sqlerrm);
1031: approverNamesOut := null;

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

1091: if(origSystem like ame_util.fndRespOrigSystem || '%') then
1092: origSystem := ame_util.fndRespOrigSystem;
1093: end if;
1094: descriptionOut :=
1095: ame_approver_type_pkg.getOrigSystemDisplayName(origSystemIn => origSystem)
1096: ||': '
1097: ||descriptionOut;
1098: end if;
1099: if(not validityOut) then

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

1104: when others then
1105: descriptionOut := ame_util.getLabel(attributeApplicationIdIn => ame_util.perFndAppId,
1106: attributeCodeIn => 'AME_INVALID_COLON') || nameIn;
1107: validityOut := false;
1108: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1109: routineNameIn => 'getApproverDescAndValidity',
1110: exceptionNumberIn => sqlcode,
1111: exceptionStringIn => sqlerrm);
1112: raise;

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

1138: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1139: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
1140: tokenNameOneIn => 'NAME',
1141: tokenValueOneIn => nameIn);
1142: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1143: routineNameIn => 'getApproverOrigSystemAndId',
1144: exceptionNumberIn => errorCode,
1145: exceptionStringIn => errorMessage);
1146: raise_application_error(errorCode,

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

1145: exceptionStringIn => errorMessage);
1146: raise_application_error(errorCode,
1147: errorMessage);
1148: when others then
1149: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1150: routineNameIn => 'getApproverOrigSystemAndId',
1151: exceptionNumberIn => sqlcode,
1152: exceptionStringIn => sqlerrm);
1153: origSystemOut := null;

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

1193: end loop;
1194: exception
1195: when others then
1196: rollback;
1197: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1198: routineNameIn => 'getApprovalTypes',
1199: exceptionNumberIn => sqlcode,
1200: exceptionStringIn => sqlerrm);
1201: actionTypeNamesOut := ame_util.emptyStringList;

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

1246: end loop;
1247: exception
1248: when others then
1249: rollback;
1250: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1251: routineNameIn => 'getApproverTypeQueryData',
1252: exceptionNumberIn => sqlcode,
1253: exceptionStringIn => sqlerrm);
1254: queryVariableLabelsOut := ame_util.emptyLongStringList;

Line 1266: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1262: approverTypeNamesOut out nocopy ame_util.stringList) as
1263: cursor getApproverTypeDataCursor is
1264: select
1265: approver_type_id,
1266: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1267: from ame_approver_types
1268: where sysdate between
1269: start_date and
1270: nvl(end_date - ame_util.oneSecond, sysdate);

Line 1274: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1270: nvl(end_date - ame_util.oneSecond, sysdate);
1271: cursor getApproverTypeDataCursor2 is
1272: select
1273: approver_type_id,
1274: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1275: from ame_approver_types
1276: where
1277: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
1278: sysdate between

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

1311: end if;
1312: exception
1313: when others then
1314: rollback;
1315: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1316: routineNameIn => 'getAvailableApproverTypes',
1317: exceptionNumberIn => sqlcode,
1318: exceptionStringIn => sqlerrm);
1319: approverTypeIdsOut := ame_util.emptyStringList;

Line 1329: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1325: approverTypeNamesOut out nocopy ame_util.stringList) as
1326: cursor unusedApproverTypeCursor is
1327: select
1328: approver_type_id,
1329: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1330: from ame_approver_types
1331: where sysdate between
1332: start_date and
1333: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1337: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name

1333: nvl(end_date - ame_util.oneSecond, sysdate)
1334: minus
1335: select
1336: ame_approver_types.approver_type_id,
1337: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_type_name
1338: from ame_approver_types,
1339: ame_approver_type_usages
1340: where
1341: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

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

1360: end loop;
1361: exception
1362: when others then
1363: rollback;
1364: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1365: routineNameIn => 'getAvailableApproverTypes2',
1366: exceptionNumberIn => sqlcode,
1367: exceptionStringIn => sqlerrm);
1368: approverTypeIdsOut := ame_util.emptyStringList;

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

1390: end loop;
1391: exception
1392: when others then
1393: rollback;
1394: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1395: routineNameIn => 'getAvailableApproverTypes3',
1396: exceptionNumberIn => sqlcode,
1397: exceptionStringIn => sqlerrm);
1398: approverTypeIdsOut := ame_util.emptyIdList;

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

1429: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1430: messageNameIn => 'AME_400405_APPR_TYPE_NDF',
1431: tokenNameOneIn => 'NAME',
1432: tokenValueOneIn => nameIn);
1433: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1434: routineNameIn => 'getOrigSystemIdAndDisplayName',
1435: exceptionNumberIn => errorCode,
1436: exceptionStringIn => errorMessage);
1437: raise_application_error(errorCode,

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

1439: when others then
1440: origSystemOut := null;
1441: origSystemIdOut := null;
1442: displayNameOut := null;
1443: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1444: routineNameIn => 'getOrigSystemIdAndDisplayName',
1445: exceptionNumberIn => sqlcode,
1446: exceptionStringIn => sqlerrm);
1447: raise;

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

1624: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1625: messageNameIn => 'AME_400436_APPR_NO_APPR_EXTS',
1626: tokenNameOneIn => 'NAME',
1627: tokenValueOneIn => approverName);
1628: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1629: routineNameIn => 'getSuperior',
1630: exceptionNumberIn => errorCode,
1631: exceptionStringIn => errorMessage);
1632: raise_application_error(errorCode,

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

1631: exceptionStringIn => errorMessage);
1632: raise_application_error(errorCode,
1633: errorMessage);
1634: when others then
1635: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1636: routineNameIn => 'getSuperior',
1637: exceptionNumberIn => sqlcode,
1638: exceptionStringIn => sqlerrm);
1639: raise;

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

1822: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1823: messageNameIn => 'AME_400436_APPR_NO_APPR_EXTS',
1824: tokenNameOneIn => 'NAME',
1825: tokenValueOneIn => approverName);
1826: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1827: routineNameIn => 'getSurrogate',
1828: exceptionNumberIn => errorCode,
1829: exceptionStringIn => errorMessage);
1830: raise_application_error(errorCode,

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

1829: exceptionStringIn => errorMessage);
1830: raise_application_error(errorCode,
1831: errorMessage);
1832: when others then
1833: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1834: routineNameIn => 'getSurrogate',
1835: exceptionNumberIn => sqlcode,
1836: exceptionStringIn => sqlerrm);
1837: raise;

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

1900: tokenValueOneIn => origSystemIdIn,
1901: tokenNameTwoIn => 'ORIG_SYSTEM',
1902: tokenValueTwoIn => origSystemIn
1903: );
1904: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1905: routineNameIn => 'getWfRolesNameAndDisplayName',
1906: exceptionNumberIn => errorCode,
1907: exceptionStringIn => errorMessage);
1908: nameOut := null;

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

1909: displayNameOut := null;
1910: raise_application_error(errorCode,
1911: errorMessage);
1912: when others then
1913: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1914: routineNameIn => 'getWfRolesNameAndDisplayName',
1915: exceptionNumberIn => sqlcode,
1916: exceptionStringIn => sqlerrm);
1917: nameOut := null;

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

1944: null);
1945: exception
1946: when others then
1947: rollback;
1948: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1949: routineNameIn => 'newApproverTypeUsage',
1950: exceptionNumberIn => sqlcode,
1951: exceptionStringIn => sqlerrm);
1952: raise;

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

1972: end if;
1973: exception
1974: when others then
1975: rollback;
1976: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
1977: routineNameIn => 'newApproverTypeUsages',
1978: exceptionNumberIn => sqlcode,
1979: exceptionStringIn => sqlerrm);
1980: raise;

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

2077: errorCode := -20001;
2078: errorMessage :=
2079: ame_util.getMessage(applicationShortNameIn => 'PER',
2080: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
2081: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2082: routineNameIn => 'perApproverQuery',
2083: exceptionNumberIn => errorCode,
2084: exceptionStringIn => errorMessage);
2085: approverNamesOut := null;

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

2090: errorCode := -20001;
2091: errorMessage :=
2092: ame_util.getMessage(applicationShortNameIn => 'PER',
2093: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
2094: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2095: routineNameIn => 'perApproverQuery',
2096: exceptionNumberIn => errorCode,
2097: exceptionStringIn => errorMessage);
2098: approverNamesOut := null;

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

2099: approverDescriptionsOut := null;
2100: raise_application_error(errorCode,
2101: errorMessage);
2102: when others then
2103: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2104: routineNameIn => 'perApproverQuery',
2105: exceptionNumberIn => sqlcode,
2106: exceptionStringIn => sqlerrm);
2107: approverNamesOut := null;

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

2193: errorCode := -20001;
2194: errorMessage :=
2195: ame_util.getMessage(applicationShortNameIn => 'PER',
2196: messageNameIn => 'AME_400111_UIN_MANY_ROWS');
2197: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2198: routineNameIn => 'posApproverQuery',
2199: exceptionNumberIn => errorCode,
2200: exceptionStringIn => errorMessage);
2201: approverNamesOut := null;

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

2206: errorCode := -20001;
2207: errorMessage :=
2208: ame_util.getMessage(applicationShortNameIn => 'PER',
2209: messageNameIn => 'AME_400110_UIN_NO_CURR_EMP');
2210: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2211: routineNameIn => 'posApproverQuery',
2212: exceptionNumberIn => errorCode,
2213: exceptionStringIn => errorMessage);
2214: approverNamesOut := null;

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

2215: approverDescriptionsOut := null;
2216: raise_application_error(errorCode,
2217: errorMessage);
2218: when others then
2219: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2220: routineNameIn => 'posApproverQuery',
2221: exceptionNumberIn => sqlcode,
2222: exceptionStringIn => sqlerrm);
2223: approverNamesOut := null;

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

2251: close variableCur;
2252: exception
2253: when others then
2254: rollback;
2255: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2256: routineNameIn => 'processApproverQuery',
2257: exceptionNumberIn => sqlcode,
2258: exceptionStringIn => sqlerrm);
2259: approverNamesOut := ame_util.emptyLongStringList;

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

2284: close variableCur;
2285: exception
2286: when others then
2287: rollback;
2288: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2289: routineNameIn => 'processApproverQuery2',
2290: exceptionNumberIn => sqlcode,
2291: exceptionStringIn => sqlerrm);
2292: approverNamesOut := ame_util.emptyLongStringList;

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

2315: nvl(end_date - ame_util.oneSecond, processingDateIn) ;
2316: exception
2317: when others then
2318: rollback;
2319: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2320: routineNameIn => 'removeApproverTypeUsage',
2321: exceptionNumberIn => sqlcode,
2322: exceptionStringIn => sqlerrm);
2323: raise;

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

2345: end if;
2346: exception
2347: when others then
2348: rollback;
2349: ame_util.runtimeException(packageNameIn => 'ame_approver_type_pkg',
2350: routineNameIn => 'removeApproverTypeUsages',
2351: exceptionNumberIn => sqlcode,
2352: exceptionStringIn => sqlerrm);
2353: raise;

Line 2355: end ame_approver_type_pkg;

2351: exceptionNumberIn => sqlcode,
2352: exceptionStringIn => sqlerrm);
2353: raise;
2354: end removeApproverTypeUsages;
2355: end ame_approver_type_pkg;