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_API2 dependencies on AME_API2

Line 1: package body ame_api2 as

1: package body ame_api2 as
2: /* $Header: ameeapi2.pkb 120.11 2011/05/17 11:42:40 nchinnam ship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2: /* $Header: ameeapi2.pkb 120.11 2011/05/17 11:42:40 nchinnam ship $ */

1: package body ame_api2 as
2: /* $Header: ameeapi2.pkb 120.11 2011/05/17 11:42:40 nchinnam ship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400812_NULL_APPR_REC_NAME');

Line 29: ame_util.runtimeException(packageNameIn => 'ame_api2',

25: end if;
26: return(true);
27: exception
28: when others then
29: ame_util.runtimeException(packageNameIn => 'ame_api2',
30: routineNameIn => 'validateApprover',
31: exceptionNumberIn => sqlcode,
32: exceptionStringIn => sqlerrm);
33: raise;

Line 78: ame_util.runtimeException(packageNameIn => 'ame_api2',

74: when others then
75: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
76: transactionIdIn => transactionIdIn,
77: transactionTypeIdIn => transactionTypeIn);
78: ame_util.runtimeException(packageNameIn => 'ame_api2',
79: routineNameIn => 'clearAllApprovals',
80: exceptionNumberIn => sqlcode,
81: exceptionStringIn => sqlerrm);
82: raise;

Line 174: ame_util.runtimeException(packageNameIn => 'ame_api2',

170: ame_util.getMessage(applicationShortNameIn =>'PER',
171: messageNameIn => 'AME_400238_API_NO_DEF_ADM_CNFG');
172: end if;
173: errorCode := -20303;
174: ame_util.runtimeException(packageNameIn => 'ame_api2',
175: routineNameIn => 'getAdminApprover',
176: exceptionNumberIn => errorCode,
177: exceptionStringIn => errorMessage);
178: adminApproverOut.name := null;

Line 183: ame_util.runtimeException(packageNameIn => 'ame_api2',

179: adminApproverOut.approval_status := ame_util.exceptionStatus;
180: raise_application_error(errorCode,
181: errorMessage);
182: when others then
183: ame_util.runtimeException(packageNameIn => 'ame_api2',
184: routineNameIn => 'getAdminApprover',
185: exceptionNumberIn => sqlcode,
186: exceptionStringIn => sqlerrm);
187: adminApproverOut.name := null;

Line 241: ame_util.runtimeException(packageNameIn => 'ame_api2',

237: end if;
238: exception
239: when others then
240: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
241: ame_util.runtimeException(packageNameIn => 'ame_api2',
242: routineNameIn => 'getAllApprovers1',
243: exceptionNumberIn => sqlcode,
244: exceptionStringIn => sqlerrm);
245: approvalProcessCompleteYNOut:= null;

Line 305: ame_util.runtimeException(packageNameIn => 'ame_api2',

301: end if;
302: exception
303: when others then
304: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
305: ame_util.runtimeException(packageNameIn => 'ame_api2',
306: routineNameIn => 'getAllApprovers2',
307: exceptionNumberIn => sqlcode,
308: exceptionStringIn => sqlerrm);
309: approvalProcessCompleteYNOut:= null;

Line 373: ame_util.runtimeException(packageNameIn => 'ame_api2',

369: end if;
370: exception
371: when others then
372: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
373: ame_util.runtimeException(packageNameIn => 'ame_api2',
374: routineNameIn => 'getAllApprovers3',
375: exceptionNumberIn => sqlcode,
376: exceptionStringIn => sqlerrm);
377: approvalProcessCompleteYNOut:= null;

Line 437: ame_util.runtimeException(packageNameIn => 'ame_api2',

433: end if;
434: exception
435: when others then
436: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
437: ame_util.runtimeException(packageNameIn => 'ame_api2',
438: routineNameIn => 'getAllApprovers4',
439: exceptionNumberIn => sqlcode,
440: exceptionStringIn => sqlerrm);
441: approvalProcessCompleteYNOut:= null;

Line 501: ame_util.runtimeException(packageNameIn => 'ame_api2',

497: end if;
498: exception
499: when others then
500: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
501: ame_util.runtimeException(packageNameIn => 'ame_api2',
502: routineNameIn => 'getAllApprovers5',
503: exceptionNumberIn => sqlcode,
504: exceptionStringIn => sqlerrm);
505: approvalProcessCompleteYNOut:= null;

Line 567: ame_util.runtimeException(packageNameIn => 'ame_api2',

563: end if;
564: exception
565: when others then
566: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
567: ame_util.runtimeException(packageNameIn => 'ame_api2',
568: routineNameIn => 'getAllApprovers6',
569: exceptionNumberIn => sqlcode,
570: exceptionStringIn => sqlerrm);
571: approvalProcessCompleteYNOut:= null;

Line 617: ame_util.runtimeException(packageNameIn => 'ame_api2',

613: end if;
614: exception
615: when others then
616: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
617: ame_util.runtimeException(packageNameIn => 'ame_api2',
618: routineNameIn => 'getAllApprovers7',
619: exceptionNumberIn => sqlcode,
620: exceptionStringIn => sqlerrm);
621: approvalProcessCompleteYNOut:= null;

Line 714: ame_util.runtimeException(packageNameIn => 'ame_api2',

710: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
711: errorCode := -20311;
712: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
713: messageNameIn => 'AME_400419_INVALID_IC') ;
714: ame_util.runtimeException(packageNameIn => 'ame_api2',
715: routineNameIn => 'getAllItemApprovers1',
716: exceptionNumberIn => errorCode,
717: exceptionStringIn => errorMessage);
718: approvalProcessCompleteYNOut := null;

Line 726: ame_util.runtimeException(packageNameIn => 'ame_api2',

722: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
723: errorCode := -20312;
724: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
725: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
726: ame_util.runtimeException(packageNameIn => 'ame_api2',
727: routineNameIn => 'getAllItemApprovers1',
728: exceptionNumberIn => errorCode,
729: exceptionStringIn => errorMessage);
730: approvalProcessCompleteYNOut := null;

Line 735: ame_util.runtimeException(packageNameIn => 'ame_api2',

731: raise_application_error(errorCode,
732: errorMessage);
733: when others then
734: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
735: ame_util.runtimeException(packageNameIn => 'ame_api2',
736: routineNameIn => 'getAllItemApprovers1',
737: exceptionNumberIn => sqlcode,
738: exceptionStringIn => sqlerrm);
739: approvalProcessCompleteYNOut:= null;

Line 824: ame_util.runtimeException(packageNameIn => 'ame_api2',

820: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
821: errorCode := -20312;
822: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
823: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
824: ame_util.runtimeException(packageNameIn => 'ame_api2',
825: routineNameIn => 'getAllItemApprovers2',
826: exceptionNumberIn => errorCode,
827: exceptionStringIn => errorMessage);
828: approvalProcessCompleteYNOut := null;

Line 833: ame_util.runtimeException(packageNameIn => 'ame_api2',

829: raise_application_error(errorCode,
830: errorMessage);
831: when others then
832: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
833: ame_util.runtimeException(packageNameIn => 'ame_api2',
834: routineNameIn => 'getAllItemApprovers2',
835: exceptionNumberIn => sqlcode,
836: exceptionStringIn => sqlerrm);
837: approvalProcessCompleteYNOut:= null;

Line 900: ame_util.runtimeException(packageNameIn => 'ame_api2',

896: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
897: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
898: transactionIdIn => transactionIdIn,
899: transactionTypeIdIn => transactionTypeIn);
900: ame_util.runtimeException(packageNameIn => 'ame_api2',
901: routineNameIn => 'getAndRecordAllApprovers',
902: exceptionNumberIn => sqlcode,
903: exceptionStringIn => sqlerrm);
904: approvalProcessCompleteYNOut:= null;

Line 982: ame_util.runtimeException(packageNameIn => 'ame_api2',

978: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
979: errorCode := -20311;
980: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
981: messageNameIn => 'AME_400419_INVALID_IC') ;
982: ame_util.runtimeException(packageNameIn => 'ame_api2',
983: routineNameIn => 'getItemStatus1',
984: exceptionNumberIn => errorCode,
985: exceptionStringIn => errorMessage);
986: approvalProcessCompleteYNOut := null;

Line 994: ame_util.runtimeException(packageNameIn => 'ame_api2',

990: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
991: errorCode := -20312;
992: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
993: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
994: ame_util.runtimeException(packageNameIn => 'ame_api2',
995: routineNameIn => 'getItemStatus1',
996: exceptionNumberIn => errorCode,
997: exceptionStringIn => errorMessage);
998: approvalProcessCompleteYNOut := null;

Line 1003: ame_util.runtimeException(packageNameIn => 'ame_api2',

999: raise_application_error(errorCode,
1000: errorMessage);
1001: when others then
1002: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1003: ame_util.runtimeException(packageNameIn => 'ame_api2',
1004: routineNameIn => 'getItemStatus1',
1005: exceptionNumberIn => sqlcode,
1006: exceptionStringIn => sqlerrm);
1007: approvalProcessCompleteYNOut:= null;

Line 1077: ame_util.runtimeException(packageNameIn => 'ame_api2',

1073: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1074: errorCode := -20311;
1075: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1076: messageNameIn => 'AME_400419_INVALID_IC') ;
1077: ame_util.runtimeException(packageNameIn => 'ame_api2',
1078: routineNameIn => 'getItemStatus2',
1079: exceptionNumberIn => errorCode,
1080: exceptionStringIn => errorMessage);
1081: approvalProcessCompleteYNOut := null;

Line 1089: ame_util.runtimeException(packageNameIn => 'ame_api2',

1085: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1086: errorCode := -20312;
1087: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1088: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
1089: ame_util.runtimeException(packageNameIn => 'ame_api2',
1090: routineNameIn => 'getItemStatus2',
1091: exceptionNumberIn => errorCode,
1092: exceptionStringIn => errorMessage);
1093: approvalProcessCompleteYNOut := null;

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

1094: raise_application_error(errorCode,
1095: errorMessage);
1096: when others then
1097: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1098: ame_util.runtimeException(packageNameIn => 'ame_api2',
1099: routineNameIn => 'getItemStatus2',
1100: exceptionNumberIn => sqlcode,
1101: exceptionStringIn => sqlerrm);
1102: approvalProcessCompleteYNOut:= null;

Line 1151: ame_util.runtimeException(packageNameIn => 'ame_api2',

1147: end if;
1148: exception
1149: when others then
1150: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1151: ame_util.runtimeException(packageNameIn => 'ame_api2',
1152: routineNameIn => 'getItemStatuses',
1153: exceptionNumberIn => sqlcode,
1154: exceptionStringIn => sqlerrm);
1155: itemClassNamesOut.delete;

Line 1203: ame_util.runtimeException(packageNameIn => 'ame_api2',

1199: end if;
1200: exception
1201: when others then
1202: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1203: ame_util.runtimeException(packageNameIn => 'ame_api2',
1204: routineNameIn => 'getNextApprovers1',
1205: exceptionNumberIn => sqlcode,
1206: exceptionStringIn => sqlerrm);
1207: approvalProcessCompleteYNOut:= null;

Line 1260: ame_util.runtimeException(packageNameIn => 'ame_api2',

1256: end if;
1257: exception
1258: when others then
1259: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1260: ame_util.runtimeException(packageNameIn => 'ame_api2',
1261: routineNameIn => 'getNextApprovers2',
1262: exceptionNumberIn => sqlcode,
1263: exceptionStringIn => sqlerrm);
1264: approvalProcessCompleteYNOut:= null;

Line 1321: ame_util.runtimeException(packageNameIn => 'ame_api2',

1317: end if;
1318: exception
1319: when others then
1320: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1321: ame_util.runtimeException(packageNameIn => 'ame_api2',
1322: routineNameIn => 'getNextApprovers3',
1323: exceptionNumberIn => sqlcode,
1324: exceptionStringIn => sqlerrm);
1325: approvalProcessCompleteYNOut:= null;

Line 1378: ame_util.runtimeException(packageNameIn => 'ame_api2',

1374: end if;
1375: exception
1376: when others then
1377: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1378: ame_util.runtimeException(packageNameIn => 'ame_api2',
1379: routineNameIn => 'getNextApprovers4',
1380: exceptionNumberIn => sqlcode,
1381: exceptionStringIn => sqlerrm);
1382: approvalProcessCompleteYNOut:= null;

Line 1439: ame_util.runtimeException(packageNameIn => 'ame_api2',

1435: end if;
1436: exception
1437: when others then
1438: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1439: ame_util.runtimeException(packageNameIn => 'ame_api2',
1440: routineNameIn => 'getPendingApprovers',
1441: exceptionNumberIn => sqlcode,
1442: exceptionStringIn => sqlerrm);
1443: approvalProcessCompleteYNOut:= null;

Line 1486: ame_util.runtimeException(packageNameIn => 'ame_api2',

1482: tempIndex := tempIndex+1;
1483: end loop;
1484: exception
1485: when others then
1486: ame_util.runtimeException(packageNameIn => 'ame_api2',
1487: routineNameIn => 'getTransactionProductions',
1488: exceptionNumberIn => sqlcode,
1489: exceptionStringIn => sqlerrm);
1490: variableNamesOut.delete;

Line 1531: ame_util.runtimeException(packageNameIn => 'ame_api2',

1527: when others then
1528: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
1529: transactionIdIn => transactionIdIn,
1530: transactionTypeIdIn => transactionTypeIn);
1531: ame_util.runtimeException(packageNameIn => 'ame_api2',
1532: routineNameIn => 'initializeApprovalProcess',
1533: exceptionNumberIn => sqlcode,
1534: exceptionStringIn => sqlerrm);
1535: raise;

Line 1769: ame_util.runtimeException(packageNameIn => 'ame_api2',

1765: exception
1766: when ambiguousApproverException then
1767: errorCode := -20318;
1768: errorMessage := ambiguousApproverMessage;
1769: ame_util.runtimeException(packageNameIn => 'ame_api2',
1770: routineNameIn => 'setFirstAuthorityApprover',
1771: exceptionNumberIn => errorCode,
1772: exceptionStringIn => errorMessage);
1773: raise_application_error(errorCode,

Line 1780: ame_util.runtimeException(packageNameIn => 'ame_api2',

1776: errorCode := -20306;
1777: errorMessage :=
1778: ame_util.getMessage(applicationShortNameIn =>'PER',
1779: messageNameIn => 'AME_400242_API_NON_NULL_FRSAPP');
1780: ame_util.runtimeException(packageNameIn => 'ame_api2',
1781: routineNameIn => 'setFirstAuthorityApprover',
1782: exceptionNumberIn => errorCode,
1783: exceptionStringIn => errorMessage);
1784: raise_application_error(errorCode,

Line 1790: ame_util.runtimeException(packageNameIn => 'ame_api2',

1786: when invalidApproverException then
1787: errorCode := -20307;
1788: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1789: messageNameIn => 'AME_400243_API_INV_FRSTAPP');
1790: ame_util.runtimeException(packageNameIn => 'ame_api2',
1791: routineNameIn => 'setFirstAuthorityApprover',
1792: exceptionNumberIn => errorCode,
1793: exceptionStringIn => errorMessage);
1794: raise_application_error(errorCode,

Line 1800: ame_util.runtimeException(packageNameIn => 'ame_api2',

1796: when invalidActionTypeException then
1797: errorCode := -20321;
1798: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1799: messageNameIn => 'AME_400815_INV_COA_ACT_TYP');
1800: ame_util.runtimeException(packageNameIn => 'ame_api2',
1801: routineNameIn => 'setFirstAuthorityApprover',
1802: exceptionNumberIn => errorCode,
1803: exceptionStringIn => errorMessage);
1804: raise_application_error(errorCode,

Line 1821: ame_util.runtimeException(packageNameIn => 'ame_api2',

1817: tokenNameTwoIn => 'ORIG_SYSTEM',
1818: tokenvalueTwoIn =>
1819: ame_approver_type_pkg.getApproverOrigSystem(
1820: nameIn => approverIn.name));
1821: ame_util.runtimeException(packageNameIn => 'ame_api2',
1822: routineNameIn => 'setFirstAuthorityApprover',
1823: exceptionNumberIn => errorCode,
1824: exceptionStringIn => errorMessage);
1825: raise_application_error(errorCode,

Line 1831: ame_util.runtimeException(packageNameIn => 'ame_api2',

1827: when tooLateException then
1828: errorCode := -20001;
1829: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1830: messageNameIn => 'AME_400244_API_CHN_AUTH_TRANS');
1831: ame_util.runtimeException(packageNameIn => 'ame_api2',
1832: routineNameIn => 'setFirstAuthorityApprover',
1833: exceptionNumberIn => errorCode,
1834: exceptionStringIn => errorMessage);
1835: raise_application_error(errorCode,

Line 1849: ame_util.runtimeException(packageNameIn => 'ame_api2',

1845: tokenNameTwoIn => 'NAME',
1846: tokenValueTwoIn => approverIn.name);
1847: raise_application_error(errorCode,errorMessage);
1848: end if;
1849: ame_util.runtimeException(packageNameIn => 'ame_api2',
1850: routineNameIn => 'setFirstAuthorityApprover',
1851: exceptionNumberIn => sqlcode,
1852: exceptionStringIn => sqlerrm);
1853: raise;

Line 1879: ame_util.runtimeException(packageNameIn => 'ame_api2',

1875: exception
1876: when ambiguousApproverException then
1877: errorCode := -20318;
1878: errorMessage := ambiguousApproverMessage;
1879: ame_util.runtimeException(packageNameIn => 'ame_api2',
1880: routineNameIn => 'updateApprovalStatus',
1881: exceptionNumberIn => errorCode,
1882: exceptionStringIn => errorMessage);
1883: raise_application_error(errorCode,

Line 1886: ame_util.runtimeException(packageNameIn => 'ame_api2',

1882: exceptionStringIn => errorMessage);
1883: raise_application_error(errorCode,
1884: errorMessage);
1885: when others then
1886: ame_util.runtimeException(packageNameIn => 'ame_api2',
1887: routineNameIn => 'updateApprovalStatus',
1888: exceptionNumberIn => sqlcode,
1889: exceptionStringIn => sqlerrm);
1890: raise;

Line 1949: ame_util.runtimeException(packageNameIn => 'ame_api2',

1945: errorCode := -20318;
1946: errorMessage :=
1947: ame_util.getMessage(applicationShortNameIn =>'PER',
1948: messageNameIn => 'AME_400812_NULL_APPR_REC_NAME');
1949: ame_util.runtimeException(packageNameIn => 'ame_api2',
1950: routineNameIn => 'updateApprovalStatus2',
1951: exceptionNumberIn => errorCode,
1952: exceptionStringIn => errorMessage);
1953: raise_application_error(errorCode,

Line 1968: ame_util.runtimeException(packageNameIn => 'ame_api2',

1964: tokenValueTwoIn => approver.name);
1965: raise_application_error(errorCode,errorMessage);
1966: end if;
1967:
1968: ame_util.runtimeException(packageNameIn => 'ame_api2',
1969: routineNameIn => 'updateApprovalStatus2',
1970: exceptionNumberIn => sqlcode,
1971: exceptionStringIn => sqlerrm);
1972: raise;

Line 1992: end ame_api2;

1988: begin
1989: null;
1990: end updateApprovalStatuses2;
1991:
1992: end ame_api2;