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.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_UTIL_PKG

Line 5201: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

5197:
5198: -----------------------------------------------------------------
5199: l_debug_info := 'Call clearAllApprovals' || to_char(p_item_key) ;
5200: -----------------------------------------------------------------
5201: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
5202: transactionIdIn => p_item_key,
5203: transactionTypeIn => p_item_type);
5204:
5205: END IF;

Line 10086: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10082: exception
10083: when others then
10084: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
10085: ame_api3.getOldApprovers(
10086: applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
10087: transactionTypeIn => 'APEXP',
10088: transactionIdIn => l_itemkey,
10089: oldApproversOut => l_oldApproversOut);
10090:

Line 10115: AME_API.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10111: l_forwardee.authority := ame_util.authorityApprover;
10112: l_forwardee.approval_status := null;
10113:
10114:
10115: AME_API.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
10116: transactionIdIn => p_item_key,
10117: approverIn => l_forwarder,
10118: forwardeeIn => l_forwardee,
10119: transactionTypeIn => p_item_type);

Line 10138: AME_API2.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10134: l_forwardee.api_insertion := ame_util.apiInsertion;
10135: end if;
10136: l_forwardee.approval_status := null;
10137:
10138: AME_API2.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
10139: transactionTypeIn => p_item_type,
10140: transactionIdIn => l_itemkey,
10141: approverIn => l_forwarder,
10142: forwardeeIn => l_forwardee);

Line 10147: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10143:
10144: -- 5135505: After re-assign the status of forwardee is null
10145: -- calling getNextApprover[n] will return forwardee and set the status to notified.
10146: begin
10147: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
10148: transactionTypeIn => p_item_type,
10149: transactionIdIn => l_itemkey,
10150: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
10151: nextApproversOut => l_nextApproversOut);

Line 10363: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10359:
10360: -----------------------------------------
10361: l_debug_info := 'Call clearAllApprovals';
10362: -----------------------------------------
10363: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
10364: transactionIdIn => p_item_key,
10365: transactionTypeIn => p_item_type);
10366: END IF;
10367:

Line 11003: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

10999:
11000: -----------------------------------------
11001: l_debug_info := 'Call clearAllApprovals';
11002: -----------------------------------------
11003: AME_API2.clearAllApprovals(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
11004: transactionIdIn => l_itemkey,
11005: transactionTypeIn => l_itemtype);
11006: end if;
11007:

Line 12281: AP_WEB_DB_UTIL_PKG.RaiseException('determineMileageAdjusted');

12277: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end determineMileageAdjusted');
12278:
12279: EXCEPTION
12280: WHEN OTHERS THEN
12281: AP_WEB_DB_UTIL_PKG.RaiseException('determineMileageAdjusted');
12282: APP_EXCEPTION.RAISE_EXCEPTION;
12283: END determineMileageAdjusted;
12284:
12285:

Line 12453: AP_WEB_DB_UTIL_PKG.RaiseException('getScheduleLineArray',

12449: END IF;
12450:
12451: EXCEPTION
12452: WHEN OTHERS THEN
12453: AP_WEB_DB_UTIL_PKG.RaiseException('getScheduleLineArray',
12454: l_debug_info);
12455: APP_EXCEPTION.RAISE_EXCEPTION;
12456: END getScheduleLineArray;
12457:

Line 12507: AP_WEB_DB_UTIL_PKG.RaiseException('updateCumulativeMileage');

12503: END IF;
12504:
12505: EXCEPTION
12506: WHEN OTHERS THEN
12507: AP_WEB_DB_UTIL_PKG.RaiseException('updateCumulativeMileage');
12508: APP_EXCEPTION.RAISE_EXCEPTION;
12509: END updateCumulativeMileage;
12510:
12511:

Line 12612: AP_WEB_DB_UTIL_PKG.RaiseException('getRate');

12608: EXCEPTION
12609: WHEN NO_DATA_FOUND THEN
12610: return 0;
12611: WHEN OTHERS THEN
12612: AP_WEB_DB_UTIL_PKG.RaiseException('getRate');
12613: APP_EXCEPTION.RAISE_EXCEPTION;
12614: return 0;
12615: END getRate;
12616:

Line 12646: AP_WEB_DB_UTIL_PKG.RaiseException('copyMileageArray');

12642:
12643:
12644: EXCEPTION
12645: WHEN OTHERS THEN
12646: AP_WEB_DB_UTIL_PKG.RaiseException('copyMileageArray');
12647: APP_EXCEPTION.RAISE_EXCEPTION;
12648: END copyMileageArray;
12649:
12650:

Line 12684: AP_WEB_DB_UTIL_PKG.RaiseException('addToMileageArray');

12680: p_mileage_line_array(p_index).status := AP_WEB_DB_EXPLINE_PKG.C_New;
12681:
12682: EXCEPTION
12683: WHEN OTHERS THEN
12684: AP_WEB_DB_UTIL_PKG.RaiseException('addToMileageArray');
12685: APP_EXCEPTION.RAISE_EXCEPTION;
12686: END addToMileageArray;
12687:
12688: -------------------------------------------------------------------------------

Line 12717: AP_WEB_DB_UTIL_PKG.RaiseException('updateNewDistNumber');

12713: END IF;
12714:
12715: EXCEPTION
12716: WHEN OTHERS THEN
12717: AP_WEB_DB_UTIL_PKG.RaiseException('updateNewDistNumber');
12718: APP_EXCEPTION.RAISE_EXCEPTION;
12719: END updateNewDistNumber;
12720:
12721: --------------------------------------------------------------------------------

Line 12952: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');

12948:
12949:
12950: EXCEPTION
12951: WHEN NO_DATA_FOUND THEN
12952: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
12953: APP_EXCEPTION.RAISE_EXCEPTION;
12954: WHEN OTHERS THEN
12955: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
12956: APP_EXCEPTION.RAISE_EXCEPTION;

Line 12955: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');

12951: WHEN NO_DATA_FOUND THEN
12952: AP_WEB_DB_UTIL_PKG.RaiseException('No Data found: processCrossThreshold');
12953: APP_EXCEPTION.RAISE_EXCEPTION;
12954: WHEN OTHERS THEN
12955: AP_WEB_DB_UTIL_PKG.RaiseException('processCrossThreshold');
12956: APP_EXCEPTION.RAISE_EXCEPTION;
12957: END processCrossThreshold;
12958:
12959: -------------------------------------------------------------------------------

Line 13442: AP_WEB_DB_UTIL_PKG.RaiseException('ProcessMileageLines');

13438: END IF;
13439:
13440: EXCEPTION
13441: WHEN OTHERS THEN
13442: AP_WEB_DB_UTIL_PKG.RaiseException('ProcessMileageLines');
13443: APP_EXCEPTION.RAISE_EXCEPTION;
13444: END ProcessMileageLines;
13445:
13446: -------------------------------------------------------------------------------

Line 13500: AP_WEB_DB_UTIL_PKG.RaiseException('hasCompanyViolations');

13496: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end hasCompanyViolations');
13497:
13498: EXCEPTION
13499: WHEN OTHERS THEN
13500: AP_WEB_DB_UTIL_PKG.RaiseException('hasCompanyViolations');
13501: APP_EXCEPTION.RAISE_EXCEPTION;
13502: END hasCompanyViolations;
13503:
13504:

Line 15229: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

15225: -------------------------------------------------
15226: l_debug_info := 'Call AMEs getNextApprovers4 api';
15227: -------------------------------------------------
15228: BEGIN
15229: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
15230: transactionTypeIn => p_item_type,
15231: transactionIdIn => p_item_key,
15232: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
15233: nextApproversOut => l_nextApproversOut);

Line 15873: AME_API2.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

15869: --l_approverIn.orig_system := 'PER';
15870: --l_approverIn.orig_system_id := l_approver_id;
15871: l_approverIn.approval_status := l_approvalStatusIn;
15872:
15873: AME_API2.updateApprovalStatus(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
15874: transactionTypeIn => p_item_type,
15875: transactionIdIn => l_AmeMasterItemKey,
15876: approverIn => l_approverIn);
15877: /*

Line 15878: AME_API2.updateApprovalStatus2(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

15874: transactionTypeIn => p_item_type,
15875: transactionIdIn => l_AmeMasterItemKey,
15876: approverIn => l_approverIn);
15877: /*
15878: AME_API2.updateApprovalStatus2(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
15879: transactionIdIn => l_AmeMasterItemKey,
15880: approvalStatusIn => l_approvalStatusIn,
15881: approverNameIn => l_approver_name,
15882: transactionTypeIn => 'APEXP');

Line 16017: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,

16013: end if;
16014: else
16015: -- if approval is complete, complete as 'Y' to avoid error notification
16016: -- from being sent to sysadmin
16017: AME_API2.getNextApprovers4(applicationIdIn => AP_WEB_DB_UTIL_PKG.GetApplicationID,
16018: transactionTypeIn => p_item_type,
16019: transactionIdIn => l_AmeMasterItemKey,
16020: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
16021: nextApproversOut => l_nextApproversOut);

Line 16086: ame_api2.getpendingapprovers(applicationidin => AP_WEB_DB_UTIL_PKG.GetApplicationID,

16082: l_report_header_id := to_char(p_item_key);
16083: -------------------------------------------------------
16084: l_debug_info := 'Calling ame_api2.getpendingapprovers';
16085: -------------------------------------------------------
16086: ame_api2.getpendingapprovers(applicationidin => AP_WEB_DB_UTIL_PKG.GetApplicationID,
16087: transactiontypein => p_item_type,
16088: transactionidin => p_item_key,
16089: approvalprocesscompleteynout => l_approvalProcessCompleteYNOut,
16090: approversout => l_approversOut);

Line 16164: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_EXPENSE_WF.getItemKey',

16160:
16161: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end getItemKey');
16162: EXCEPTION
16163: WHEN OTHERS THEN
16164: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_EXPENSE_WF.getItemKey',
16165: l_debug_info);
16166: APP_EXCEPTION.RAISE_EXCEPTION;
16167: END getItemKey;
16168: