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_OA_MAINFLOW_PKG

Line 1: PACKAGE BODY AP_WEB_OA_MAINFLOW_PKG AS

1: PACKAGE BODY AP_WEB_OA_MAINFLOW_PKG AS
2: /* $Header: apwoamfb.pls 120.56.12010000.2 2008/08/06 10:17:00 rveliche ship $ */
3:
4:
5: PROCEDURE DeleteExpenseReport(

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 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 441: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 694: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 738: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 747: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 796: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

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

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

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

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

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

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

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

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

Line 867: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 930: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1028: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1105: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1110: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1146: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1156: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1178: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

Line 1188: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

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

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

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

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

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

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

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

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

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

Line 1627: END AP_WEB_OA_MAINFLOW_PKG;

1623: END DeleteReport;
1624:
1625:
1626:
1627: END AP_WEB_OA_MAINFLOW_PKG;