APPS.AP_WEB_AME_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start getTotalPerCostCenter');

217: l_line_item_total NUMBER := 0;
218:
219: BEGIN
220:
221: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start getTotalPerCostCenter');
222:
223: -- If project is enabled, then get the total reimbursable amount for the same project number. Otherwise, if line-level-accounting is enabled, get the total reimbursable amount for the same cost center
224:
225: SELECT SUM(AMOUNT)

Line 237: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end getTotalPerCostCenter');

233: AND DISTRIBUTION_LINE_NUMBER = p_line_number
234: )
235: AND itemization_parent_id <> -1;
236:
237: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end getTotalPerCostCenter');
238: return l_line_item_total;
239:
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN

Line 518: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');

514: -------------------------------------------------------------------
515: l_award_number GMS_AWARDS.AWARD_NUMBER%type;
516: BEGIN
517:
518: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
519:
520: select award_number
521: into l_award_number
522: from GMS_AWARDS_ALL

Line 549: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetItemAmount');

545: p_amount OUT NOCOPY NUMBER) IS
546: -------------------------------------------------------------------------
547: BEGIN
548:
549: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetItemAmount');
550:
551: if (p_item_class = C_HEADER) then
552: select total
553: into p_amount

Line 583: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End GetItemAmount');

579: where report_header_id = p_report_header_id
580: and cost_center = p_item_id;
581: end if;
582:
583: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End GetItemAmount');
584:
585: EXCEPTION
586: WHEN NO_DATA_FOUND THEN
587: null;

Line 611: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InsertToAMENotifGT');

607: p_project_name IN VARCHAR2,
608: p_award_number IN VARCHAR2) as
609: -------------------------------------------------------------------------
610: BEGIN
611: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InsertToAMENotifGT');
612:
613: insert into OIE_AME_NOTIF_GT(
614: report_header_id,
615: orig_system,

Line 636: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End InsertToAMENotifGT');

632: p_project_number,
633: p_project_name,
634: p_award_number
635: );
636: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'End InsertToAMENotifGT');
637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: AP_WEB_DB_UTIL_PKG.RaiseException( 'InsertToAMENotifGT' );

Line 684: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InitOieAmeNotifGT');

680: l_amount number;
681:
682: BEGIN
683:
684: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start InitOieAmeNotifGT');
685:
686: p_display_instr := 'Y';
687:
688: DELETE FROM OIE_AME_NOTIF_GT;

Line 818: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeNotifGT');

814: l_debug_info := 'Before call to InitOieAmeApproverAmtGT';
815: -----------------------------------------------------------
816: InitOieAmeApproverAmtGT(p_report_header_id);
817:
818: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeNotifGT');
819:
820: EXCEPTION
821: WHEN OTHERS THEN
822: IF (SQLCODE <> -20001) THEN

Line 860: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start InitOieAmeApproverAmtGT');

856: l_approver_amount number;
857:
858: BEGIN
859:
860: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'start InitOieAmeApproverAmtGT');
861:
862: DELETE FROM OIE_AME_APPROVER_AMT_GT;
863:
864: for i in c1(p_report_header_id) loop

Line 947: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeApproverAmtGT');

943: i.report_line_id,
944: nvl(l_approver_amount,0));
945: end loop;
946:
947: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'end InitOieAmeApproverAmtGT');
948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF (SQLCODE <> -20001) THEN