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_OA_MAINFLOW_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 11: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

7: IS
8:
9: BEGIN
10:
11: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
12: 'start DeleteExpenseReport');
13:
14: DeleteReport(ReportID);
15:

Line 21: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

17: IF (AP_WEB_DB_CCARD_PKG.ResetCCLines(ReportID)) THEN
18: COMMIT;
19: END IF;
20:
21: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
22: 'end DeleteExpenseReport');
23: EXCEPTION
24: WHEN OTHERS THEN
25: APP_EXCEPTION.RAISE_EXCEPTION;

Line 33: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

29: PROCEDURE GetEmployeeIdFromBothPayParent(p_bothpay_parent_id IN NUMBER,
30: p_employee_id OUT NOCOPY NUMBER)
31: IS
32: BEGIN
33: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
34: 'start GetEmployeeIdFromBothPayParent');
35:
36: AP_WEB_DB_EXPRPT_PKG.GetEmployeeIdFromBothPayParent(p_bothpay_parent_id,
37: p_employee_id);

Line 39: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

35:
36: AP_WEB_DB_EXPRPT_PKG.GetEmployeeIdFromBothPayParent(p_bothpay_parent_id,
37: p_employee_id);
38:
39: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
40: 'end GetEmployeeIdFromBothPayParent');
41: END GetEmployeeIdFromBothPayParent;
42:
43: PROCEDURE GetGeneralInfo(

Line 71: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

67: l_approver_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
68:
69: BEGIN
70:
71: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
72: 'start GetGeneralInfo');
73:
74: -- Initialize arguments
75: p_default_expense_template_id := NULL;

Line 122: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

118: ELSE
119: p_is_grants_enabled := 'N';
120: END IF;
121:
122: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
123: 'end GetGeneralInfo');
124:
125: END GetGeneralInfo;
126:

Line 175: l_Error AP_WEB_UTILITIES_PKG.expError ;

171: p_msg_data OUT NOCOPY VARCHAR2
172: ) IS
173: -------------------------------------------------------------------
174: ExpReportHeaderInfo AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
175: l_Error AP_WEB_UTILITIES_PKG.expError ;
176: l_org_id AP_WEB_DB_HR_INT_PKG.empCurrent_orgID;
177: l_user_id varchar2(20); -- 2242176, fnd user id
178: l_debug_info varchar2(200);
179: current_calling_sequence varchar2(100) := 'ValidateReportHeader';

Line 182: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

178: l_debug_info varchar2(200);
179: current_calling_sequence varchar2(100) := 'ValidateReportHeader';
180:
181: BEGIN
182: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
183: 'start ValidateReportHeader');
184: p_return_status := '';
185: l_debug_info := 'setting ExpReportHeaderInfo values';
186: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

Line 186: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

182: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
183: 'start ValidateReportHeader');
184: p_return_status := '';
185: l_debug_info := 'setting ExpReportHeaderInfo values';
186: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
187: ExpReportHeaderInfo.report_header_id := report_header_id;
188: ExpReportHeaderInfo.employee_id := employee_id;
189: ExpReportHeaderInfo.cost_center := cost_center;
190: ExpReportHeaderInfo.template_id := template_id;

Line 214: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

210: l_debug_info := 'Getting employee user ID';
211: GetUserID(employee_id, l_user_id);
212:
213: l_debug_info := 'calling ValidateReportHeader';
214: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
215: --Bug 2829307:Pass session_id for validation.
216: AP_WEB_VALIDATE_UTIL.ValidateHeaderNoValidSession(
217: p_user_id => TO_NUMBER(l_user_id),
218: ExpReportHeaderInfo => ExpReportHeaderInfo ,

Line 229: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

225:
226: fnd_msg_pub.count_and_get(p_count => p_msg_count,
227: p_data => p_msg_data);
228:
229: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
230: 'end ValidateReportHeader');
231: exception
232: when others then
233: BEGIN

Line 428: Receipt_Error_Array AP_WEB_UTILITIES_PKG.receipt_error_stack;

424: Custom13_Array AP_WEB_DFLEX_PKG.CustomFields_A;
425: Custom14_Array AP_WEB_DFLEX_PKG.CustomFields_A;
426: Custom15_Array AP_WEB_DFLEX_PKG.CustomFields_A;
427: Receipts_With_Errors_Count BINARY_INTEGER;
428: Receipt_Error_Array AP_WEB_UTILITIES_PKG.receipt_error_stack;
429: l_has_core_field_errors BOOLEAN;
430: l_has_custom_field_errors BOOLEAN;
431: l_receipt_line_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
432: l_validate_receipt_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;

Line 431: l_receipt_line_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;

427: Receipts_With_Errors_Count BINARY_INTEGER;
428: Receipt_Error_Array AP_WEB_UTILITIES_PKG.receipt_error_stack;
429: l_has_core_field_errors BOOLEAN;
430: l_has_custom_field_errors BOOLEAN;
431: l_receipt_line_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
432: l_validate_receipt_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
433: l_receipt_with_error NUMBER;
434: current_calling_sequence varchar2(100) := 'ValidateReceiptLine';
435: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;

Line 432: l_validate_receipt_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;

428: Receipt_Error_Array AP_WEB_UTILITIES_PKG.receipt_error_stack;
429: l_has_core_field_errors BOOLEAN;
430: l_has_custom_field_errors BOOLEAN;
431: l_receipt_line_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
432: l_validate_receipt_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
433: l_receipt_with_error NUMBER;
434: current_calling_sequence varchar2(100) := 'ValidateReceiptLine';
435: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;
436:

Line 442: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

438: CustomValuesArray AP_WEB_PARENT_PKG.BigString_Array;
439: l_calculate_amt_index INTEGER := p_calculate_amt_index;
440:
441: BEGIN
442: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
443: 'start ValidateReceiptLines');
444:
445: ExpReportHeaderInfo.employee_id := employee_id;
446: ExpReportHeaderInfo.template_id := template_id;

Line 569: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

565: Custom15_Array(1).value := attribute15;
566:
567: ------------------------------------------------------------------------
568: l_debug_info := 'Convert to Arrays to pass into MapColumnToCustomFields';
569: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
570: ------------------------------------------------------------------------
571: ExpReportLinesInfo_A(1) := ExpReportLinesInfo;
572: CustomValuesArray(1) := Custom1_Array(1).value;
573: CustomValuesArray(2) := Custom2_Array(1).value;

Line 590: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

586: CustomValuesArray(15) := Custom15_Array(1).value;
587:
588: -----------------------------------------------------
589: l_debug_info := 'Calling MapColumnToCustomFields';
590: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
591: -----------------------------------------------------
592: AP_WEB_VALIDATE_UTIL.MapColumnToCustomFields(p_userId,
593: 1, --P_ReceiptIndex
594: CustomValuesArray,

Line 614: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

610: Custom15_Array);
611:
612: ----------------------------------------------------------------------------------------------------------
613: l_debug_info := 'Assiging l_calculate_amt_index to null so that Calculate Amount will not be called';
614: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
615: ----------------------------------------------------------------------------------------------------------
616: IF (p_calculate_amt_index = -1) THEN
617: l_calculate_amt_index := NULL;
618: END IF;

Line 623: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

619:
620:
621: -----------------------------------------------------
622: l_debug_info := 'Calling ValidateExpLine';
623: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
624: -----------------------------------------------------
625: --Bug 2829307:Pass session_id for validation.
626: AP_WEB_VALIDATE_UTIL.ValidateExpLine(
627: to_number(p_userId),

Line 684: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

680: );
681:
682: ------------------------------------------------------------------------------------------
683: l_debug_info := 'Assigning p_calculated_receipt_amount, which is NULL if not calculated';
684: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
685: ------------------------------------------------------------------------------------------
686: --Return Calculated Receipt Amount
687: p_calculated_receipt_amount := ExpReportLinesInfo.calculated_amount;
688: justification := ExpReportLinesInfo.justification;

Line 691: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

687: p_calculated_receipt_amount := ExpReportLinesInfo.calculated_amount;
688: justification := ExpReportLinesInfo.justification;
689: -----------------------------------------------------
690: l_debug_info := 'Calling fnd_msg_pub.count_and_get';
691: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
692: -----------------------------------------------------
693: fnd_msg_pub.count_and_get(p_count => p_msg_count,
694: p_data => p_msg_data);
695:

Line 696: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

692: -----------------------------------------------------
693: fnd_msg_pub.count_and_get(p_count => p_msg_count,
694: p_data => p_msg_data);
695:
696: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
697: 'end ValidateReceiptLines');
698:
699: EXCEPTION
700: WHEN OTHERS THEN

Line 740: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

736: bResult BOOLEAN;
737: l_require_receipt_amount NUMBER;
738: BEGIN
739:
740: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
741: 'start GetItemDescLookupCode');
742:
743: bResult := AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode(
744: p_parameter_id,

Line 749: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

745: p_item_description,
746: p_line_type_lookup_code,
747: l_require_receipt_amount);
748:
749: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
750: 'end GetItemDescLookupCode');
751:
752: END GetItemDescLookupCode;
753:

Line 794: l_errors AP_WEB_UTILITIES_PKG.expError;

790: l_debug_info VARCHAR2(300) := '';
791: l_neg_pos_total NUMBER := 0;
792: l_pos_total NUMBER := 0;
793: l_msg_data VARCHAR2(1000);
794: l_errors AP_WEB_UTILITIES_PKG.expError;
795: l_ResubmitReport BOOLEAN := FALSE;
796:
797: BEGIN
798: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

Line 798: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

794: l_errors AP_WEB_UTILITIES_PKG.expError;
795: l_ResubmitReport BOOLEAN := FALSE;
796:
797: BEGIN
798: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
799: 'start OASubmitWorkflow');
800:
801:
802: -------------------------------------------------------------------

Line 813: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

809: IF (TRUE) THEN
810:
811: -------------------------------------------------------------------
812: l_debug_info := 'Get the Total of the negative and positive amounts';
813: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
814: -------------------------------------------------------------------
815: BEGIN
816: SELECT
817: SUM(amount),

Line 836: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

832: END;
833:
834: ------------------------------------------------------------
835: l_debug_info := 'Starting workflow process';
836: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
837: ------------------------------------------------------------
838: AP_WEB_EXPENSE_WF.StartExpenseReportProcess(to_number(p_report_header_id),
839: to_number(p_preparer_id),
840: to_number(p_employee_id),

Line 853: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

849: p_workflow_appr_flag,
850: p_submit_from_oie => AP_WEB_EXPENSE_WF.C_SUBMIT_FROM_OIE,
851: p_event_raised => 'N');
852: l_debug_info := 'End of workflow process';
853: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
854: -- Do not remove this commit otherwise wf process will not be created.
855: COMMIT;
856: ELSE -- Not a ReSubmit
857:

Line 860: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

856: ELSE -- Not a ReSubmit
857:
858: ------------------------------------------------------------
859: l_debug_info := 'Starting Expenses WF process via Business Event';
860: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
861: ------------------------------------------------------------
862: AP_WEB_EXPENSE_WF.RaiseSubmitEvent(to_number(p_report_header_id),
863: p_workflow_appr_flag);
864:

Line 869: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

865: -- Do not remove this commit otherwise wf process will not be created.
866: COMMIT;
867: END IF;
868:
869: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
870: 'end OASubmitWorkflow');
871:
872: EXCEPTION
873: WHEN OTHERS THEN

Line 893: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,

889: -- APP_EXCEPTION.RAISE_EXCEPTION can only display error message with less than
890: -- 512 characters. In order to display the compelte workflow information for bug
891: -- 2203689, call addExpError and checkErrors to get message from error stack
892:
893: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
894: fnd_message.get_encoded(),
895: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
896:
897: fnd_msg_pub.count_and_get(p_count => p_msg_count,

Line 895: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);

891: -- 2203689, call addExpError and checkErrors to get message from error stack
892:
893: AP_WEB_UTILITIES_PKG.AddExpError(l_errors,
894: fnd_message.get_encoded(),
895: AP_WEB_UTILITIES_PKG.C_ErrorMessageType);
896:
897: fnd_msg_pub.count_and_get(p_count => p_msg_count,
898: p_data => l_msg_data);
899: END IF;

Line 932: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

928: l_reimb_currency_code AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE; -- Bug: 5696596
929: l_nonBasePayAllowed VARCHAR2(1);
930:
931: Begin
932: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
933: 'start GetEmployeeInfo');
934:
935: l_debug_info := 'Getting employee information';
936: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

Line 936: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

932: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
933: 'start GetEmployeeInfo');
934:
935: l_debug_info := 'Getting employee information';
936: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
937: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(
938: p_employee_name,
939: p_employee_num,
940: p_cost_center,

Line 937: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(

933: 'start GetEmployeeInfo');
934:
935: l_debug_info := 'Getting employee information';
936: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
937: AP_WEB_UTILITIES_PKG.GetEmployeeInfo(
938: p_employee_name,
939: p_employee_num,
940: p_cost_center,
941: p_employee_id);

Line 950: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

946: l_userId := to_number(p_userId);
947:
948:
949: l_debug_info := 'Check if user is project enabled';
950: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
951: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(p_employee_id,
952: FND_PROFILE.VALUE('USER_ID'),
953: p_is_project_enabled);
954:

Line 961: p_is_project_enabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

957: -- AP_WEB_PROJECT_PKG.IsSessionProjectEnabled only returns 'Y' or 'N"
958: -- If profile option OIE:Enable Projects equals to Required then
959: -- we need to make sure project information is entered in the
960: -- middle-tier validation
961: p_is_project_enabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
962: p_name => 'AP_WEB_ENABLE_PROJECT_ACCOUNTING',
963: p_user_id => l_userId,
964: p_resp_id => null,
965: p_apps_id => null);

Line 970: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

966: END IF;
967:
968:
969: l_debug_info := 'vendor id';
970: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
971: IF (NOT AP_WEB_DB_AP_INT_PKG.GetVendorInfoOfEmp(p_employee_id,
972: l_vendor_id,
973: l_vend_pay_curr,
974: l_vend_pay_curr_name

Line 982: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

978: l_vend_pay_curr_name := NULL;
979: END IF;
980:
981: l_debug_info := 'Select currency information';
982: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
983: IF (AP_WEB_DB_AP_INT_PKG.GetAPSysCurrencySetupInfo(l_SysInfoRec)) THEN
984: l_base_currency := l_SysInfoRec.base_currency;
985: l_sys_multi_curr_flag := l_SysInfoRec.sys_multi_curr_flag;
986: l_base_curr_name := l_SysInfoRec.base_curr_name;

Line 992: l_nonBasePayAllowed := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

988:
989: p_default_reimb_currency_code := nvl(l_vend_pay_curr, l_base_currency);
990:
991: --Bug: 5696596, pickup the default currency from the preferences if there is one.
992: l_nonBasePayAllowed := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
993: p_name => 'AP_WEB_ALLOW_NON_BASE_REIMB',
994: p_user_id => l_userId,
995: p_resp_id => null,
996: p_apps_id => null);

Line 998: -- Cannot use AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC as user can change preferences without logout.

994: p_user_id => l_userId,
995: p_resp_id => null,
996: p_apps_id => null);
997: IF (l_nonBasePayAllowed = 'Y') THEN
998: -- Cannot use AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC as user can change preferences without logout.
999: l_reimb_currency_code := FND_PROFILE.VALUE_SPECIFIC(
1000: NAME => 'ICX_PREFERRED_CURRENCY',
1001: USER_ID => l_userId,
1002: RESPONSIBILITY_ID => null,

Line 1010: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

1006: END IF;
1007:
1008:
1009: l_debug_info := 'Check if user is credit card enabled';
1010: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
1011: l_cCardEnabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1012: p_name => 'SSE_ENABLE_CREDIT_CARD',
1013: p_user_id => l_userId,
1014: p_resp_id => null,

Line 1011: l_cCardEnabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(

1007:
1008:
1009: l_debug_info := 'Check if user is credit card enabled';
1010: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
1011: l_cCardEnabled := AP_WEB_UTILITIES_PKG.VALUE_SPECIFIC(
1012: p_name => 'SSE_ENABLE_CREDIT_CARD',
1013: p_user_id => l_userId,
1014: p_resp_id => null,
1015: p_apps_id => null);

Line 1027: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);

1023: p_is_cc_enabled := 'N';
1024: END IF;
1025:
1026: l_debug_info := 'Get Maximum number of flexfield segments';
1027: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
1028: p_max_num_segments := AP_WEB_DFLEX_PKG.GetMaxNumSegmentsUsed(TO_NUMBER(p_userId));
1029:
1030: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1031: 'end GetEmployeeInfo');

Line 1030: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1026: l_debug_info := 'Get Maximum number of flexfield segments';
1027: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_OA_MAINFLOW_PKG', l_debug_info);
1028: p_max_num_segments := AP_WEB_DFLEX_PKG.GetMaxNumSegmentsUsed(TO_NUMBER(p_userId));
1029:
1030: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1031: 'end GetEmployeeInfo');
1032: EXCEPTION
1033: WHEN NO_DATA_FOUND THEN
1034: NULL;

Line 1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

1077: BEGIN
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetUserID');
1081: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1082: END;
1083:
1084:
1085: END GetUserID;

Line 1107: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1103: IS
1104: l_debug_info varchar2(200);
1105: BEGIN
1106:
1107: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1108: 'start WithdrawExpenseReport');
1109: l_debug_info := 'Calling WithdrawExpenseRep';
1110: AP_WEB_EXPENSE_WF.WithdrawExpenseRep(p_report_header_id);
1111:

Line 1112: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1108: 'start WithdrawExpenseReport');
1109: l_debug_info := 'Calling WithdrawExpenseRep';
1110: AP_WEB_EXPENSE_WF.WithdrawExpenseRep(p_report_header_id);
1111:
1112: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1113: 'end WithdrawExpenseReport');
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF (SQLCODE <> -20001) THEN

Line 1148: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1144: IS
1145: l_SysInfoRec AP_WEB_DB_AP_INT_PKG.APSysInfoRec;
1146: BEGIN
1147:
1148: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1149: 'start GetFunctionalCurrencyInfo');
1150: p_currencyCode := null;
1151: p_currencyType := null;
1152:

Line 1158: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1154: p_currencyType := l_SysInfoRec.default_exchange_rate_type;
1155: p_currencyCode := l_SysInfoRec.base_currency;
1156: END IF; /* GetAPSysCurrencySetupInfo */
1157:
1158: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1159: 'end GetFunctionalCurrencyInfo ');
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1180: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1176: p_target_report_header_id IN OUT NOCOPY expHdr_headerID) IS
1177:
1178: BEGIN
1179:
1180: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1181: 'start DuplicateExpenseReport');
1182:
1183: select AP_EXPENSE_REPORT_HEADERS_S.NEXTVAL
1184: into p_target_report_header_id

Line 1190: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

1186:
1187: AP_WEB_DB_EXPRPT_PKG.DuplicateHeader(p_user_id, p_source_report_header_id, p_target_report_header_id);
1188: AP_WEB_DB_EXPLINE_PKG.DuplicateLines(p_user_id, p_source_report_header_id, p_target_report_header_id);
1189:
1190: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
1191: 'end DuplicateExpenseReport');
1192:
1193: END DuplicateExpenseReport;
1194:

Line 1245: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start GetDefaultAcctgSegValues');

1241: l_ccid NUMBER;
1242:
1243: BEGIN
1244:
1245: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start GetDefaultAcctgSegValues');
1246:
1247: -- Initialize API return status to success
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249:

Line 1307: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'end GetDefaultAcctgSegValues');

1303: if (l_return_error_message is not null) then
1304: raise G_EXC_ERROR;
1305: end if;
1306:
1307: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'end GetDefaultAcctgSegValues');
1308:
1309: EXCEPTION
1310: WHEN G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1338: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start validateAccountSegments');

1334: -- Bug: 7039477, sync error message length with fnd_flex_keyval.err_text
1335: l_return_error_message varchar2(2000);
1336:
1337: BEGIN
1338: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start validateAccountSegments');
1339:
1340: -- Initialize API return status to success
1341: x_return_status := FND_API.G_RET_STS_SUCCESS;
1342:

Line 1394: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start rebuildAccountSegments');

1390: -- Bug: 7039477, sync error message length with fnd_flex_keyval.err_text
1391: l_return_error_message varchar2(2000);
1392:
1393: BEGIN
1394: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_MAINFLOW_PKG', 'Start rebuildAccountSegments');
1395:
1396: -- Initialize API return status to success
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:

Line 1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

1482: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updateExpensedAmount');
1485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1486: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1487: END;
1488: END updateExpensedAmount;
1489:
1490: /*

Line 1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

1555: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1556: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1557: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'updChargesFromDeletedReport');
1558: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1559: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1560: END;
1561: END updChargesFromDeletedReport;
1562:
1563: PROCEDURE DeleteReport(