148: | RETURNS |
149: | none |
150: *----------------------------------------------------------------------------*/
151: PROCEDURE ValidateExpLinesCustomFields(
152: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
149: | none |
150: *----------------------------------------------------------------------------*/
151: PROCEDURE ValidateExpLinesCustomFields(
152: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
150: *----------------------------------------------------------------------------*/
151: PROCEDURE ValidateExpLinesCustomFields(
152: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
151: PROCEDURE ValidateExpLinesCustomFields(
152: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
152: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
153: p_report_lines_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
154: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
155: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
156: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
157: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
158: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
159: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
160: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
168: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
161: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
168: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
169: p_num_max_flex_field IN NUMBER,
162: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
168: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
169: p_num_max_flex_field IN NUMBER,
170: P_IsSessionTaxEnabled IN VARCHAR2,
163: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
168: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
169: p_num_max_flex_field IN NUMBER,
170: P_IsSessionTaxEnabled IN VARCHAR2,
171: P_IsSessionProjectEnabled IN VARCHAR2,
164: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
165: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
166: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
167: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
168: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
169: p_num_max_flex_field IN NUMBER,
170: P_IsSessionTaxEnabled IN VARCHAR2,
171: P_IsSessionProjectEnabled IN VARCHAR2,
172: p_receipts_count IN BINARY_INTEGER,
704: END;
705:
706: ---------------------------------------------------------------
707: PROCEDURE ValidateReportHeader(
708: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
709: p_Error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError
710:
711: ) IS
712: ---------------------------------------------------------------
739: | none |
740: *----------------------------------------------------------------------------*/
741: PROCEDURE ValidateHeaderNoValidSession(
742: p_user_id IN NUMBER, -- 2242176, fnd user id
743: ExpReportHeaderInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
744: p_error IN OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
745: p_bFull_Approver_Validation IN BOOLEAN
746:
747: ) IS
1058: | none |
1059: *----------------------------------------------------------------------------*/
1060: PROCEDURE ValidateExpLineCustomFields(
1061: p_userId IN NUMBER,
1062: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1063: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
1064: p_receipt_index IN INTEGER, -- for AddExpError
1065: p_SysInfoRec IN AP_WEB_DB_AP_INT_PKG.APSysInfoRec,
1066: p_DefaultExchangeRate IN NUMBER,
1059: *----------------------------------------------------------------------------*/
1060: PROCEDURE ValidateExpLineCustomFields(
1061: p_userId IN NUMBER,
1062: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1063: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
1064: p_receipt_index IN INTEGER, -- for AddExpError
1065: p_SysInfoRec IN AP_WEB_DB_AP_INT_PKG.APSysInfoRec,
1066: p_DefaultExchangeRate IN NUMBER,
1067: p_EndExpenseDate IN DATE,
1065: p_SysInfoRec IN AP_WEB_DB_AP_INT_PKG.APSysInfoRec,
1066: p_DefaultExchangeRate IN NUMBER,
1067: p_EndExpenseDate IN DATE,
1068: p_DateFormat IN VARCHAR2,
1069: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1066: p_DefaultExchangeRate IN NUMBER,
1067: p_EndExpenseDate IN DATE,
1068: p_DateFormat IN VARCHAR2,
1069: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1067: p_EndExpenseDate IN DATE,
1068: p_DateFormat IN VARCHAR2,
1069: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1068: p_DateFormat IN VARCHAR2,
1069: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1069: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1070: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1071: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1072: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1073: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1074: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1075: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1076: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1084: P_IsSessionTaxEnabled IN VARCHAR2,
1077: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1084: P_IsSessionTaxEnabled IN VARCHAR2,
1085: P_IsSessionProjectEnabled IN VARCHAR2,
1078: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1084: P_IsSessionTaxEnabled IN VARCHAR2,
1085: P_IsSessionProjectEnabled IN VARCHAR2,
1086: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1079: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1080: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1081: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1082: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1083: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
1084: P_IsSessionTaxEnabled IN VARCHAR2,
1085: P_IsSessionProjectEnabled IN VARCHAR2,
1086: p_receipt_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
1087: p_calculate_receipt_index IN BINARY_INTEGER,
1120: )
1121: ----------------------------------------------------------------------------
1122: IS
1123:
1124: l_receipt_custom_fields_array AP_WEB_DFLEX_PKG.CustomFields_A;
1125:
1126: l_curr_calling_sequence VARCHAR2(200) := 'ValidateExpLinesCustomFields';
1127: l_debug_info VARCHAR2(2000);
1128:
1142: V_EnteredByUserID VARCHAR2(100);
1143:
1144: l_IsMobileApp boolean;
1145:
1146: l_report_lines_array AP_WEB_DFLEX_PKG.ExpReportLines_A;
1147:
1148: V_GrantsResult VARCHAR2(2000); -- For Grants: Error/warning message
1149:
1150: l_CostCenterErrorMsg VARCHAR2(2000) := NULL;
1168: l_debug_info := 'GetReceiptCustomFields';
1169: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1170: -----------------------------------------------------
1171:
1172: AP_WEB_DFLEX_PKG.GetReceiptCustomFields(l_receipt_custom_fields_array,
1173: p_receipt_index,
1174: p_custom1_array,
1175: p_custom2_array,
1176: p_custom3_array,
1190: -----------------------------------------------------
1191: l_debug_info := 'ValidateReceiptCustomFields';
1192: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1193: -----------------------------------------------------
1194: AP_WEB_DFLEX_PKG.ValidateReceiptCustomFields(p_userId,
1195: p_report_header_info,
1196: p_report_line_info,
1197: l_receipt_custom_fields_array,
1198: p_receipt_errors,
1212: -----------------------------------------------------
1213: l_debug_info := 'PropogateReceiptCustFldsInfo';
1214: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1215: -----------------------------------------------------
1216: AP_WEB_DFLEX_PKG.PropogateReceiptCustFldsInfo(
1217: l_receipt_custom_fields_array,
1218: p_receipt_index,
1219: p_custom1_array,
1220: p_custom2_array,
1237:
1238: -- Call custom validation hook for both core and pseudo descriptive flexfields
1239: l_debug_info := 'Call custom validation hook';
1240: -- Bug: 6617094, Expense type is null in Custom Validation.
1241: AP_WEB_DFLEX_PKG.PopulateExpTypeInLineRec(p_report_line_info);
1242: AP_WEB_UTILITIES_PKG.logStatement('AP_WEB_VALIDATE_UTIL', l_debug_info);
1243: AP_WEB_CUST_DFLEX_PKG.CustomValidateLine(p_report_header_info,
1244: p_report_line_info,
1245: l_receipt_custom_fields_array,
1338:
1339: ----------------------------------------------
1340: l_debug_info := 'Revalidate new values';
1341: ----------------------------------------------
1342: AP_WEB_DFLEX_PKG.ValidateReceiptCustomFields(p_userId,
1343: p_report_header_info,
1344: p_report_line_info,
1345: l_receipt_custom_fields_array,
1346: p_receipt_errors,
1388: | none |
1389: *----------------------------------------------------------------------------*/
1390: PROCEDURE ValidateExpLineCoreFields
1391: (p_user_id IN NUMBER, -- 2242176, fnd user id
1392: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1393: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
1394: p_receiptcount IN NUMBER,
1395: p_allow_credit_lines IN BOOLEAN,
1396: p_justreq_array IN AP_WEB_PARENT_PKG.Number_Array,
1389: *----------------------------------------------------------------------------*/
1390: PROCEDURE ValidateExpLineCoreFields
1391: (p_user_id IN NUMBER, -- 2242176, fnd user id
1392: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
1393: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
1394: p_receiptcount IN NUMBER,
1395: p_allow_credit_lines IN BOOLEAN,
1396: p_justreq_array IN AP_WEB_PARENT_PKG.Number_Array,
1397: p_reimbcurr_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
1421: l_amount NUMBER;
1422: l_sdate DATE := sysdate;
1423: l_edate DATE;
1424: l_acdate DATE; -- date1 if date2 is null, otherwise date2.
1425: l_receipt_custom_fields_array AP_WEB_DFLEX_PKG.CustomFields_A;
1426: l_reimbcurr_format VARCHAR2(80);
1427: l_reccurr_format VARCHAR2(80);
1428: l_date_format VARCHAR2(30);
1429: i NUMBER;
2130: *----------------------------------------------------------------------------*/
2131:
2132: PROCEDURE ValidateExpLines(
2133: p_userId IN NUMBER,
2134: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2131:
2132: PROCEDURE ValidateExpLines(
2133: p_userId IN NUMBER,
2134: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2132: PROCEDURE ValidateExpLines(
2133: p_userId IN NUMBER,
2134: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2133: p_userId IN NUMBER,
2134: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2134: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2135: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2136: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2137: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2138: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2139: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2140: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2141: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2142: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2143: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2151: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2144: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2151: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2152: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2145: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2151: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2152: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2153: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2146: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2147: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2148: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2149: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2150: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2151: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2152: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2153: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2154: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2184: p_cust_pdm_rate IN OUT NOCOPY OIE_PDM_NUMBER_T
2185: )
2186: IS
2187: l_receipt_count NUMBER;
2188: l_report_line_rec AP_WEB_DFLEX_PKG.ExpReportLineRec;
2189: l_receipt_with_error NUMBER := 0;
2190:
2191: BEGIN
2192:
2292: *----------------------------------------------------------------------------*/
2293:
2294: PROCEDURE ValidateExpLine(
2295: p_userId IN NUMBER,
2296: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2293:
2294: PROCEDURE ValidateExpLine(
2295: p_userId IN NUMBER,
2296: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2294: PROCEDURE ValidateExpLine(
2295: p_userId IN NUMBER,
2296: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2295: p_userId IN NUMBER,
2296: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2296: p_report_header_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2297: p_report_line_info IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLineRec,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2298: p_custom1_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2299: p_custom2_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2300: p_custom3_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2301: p_custom4_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2302: p_custom5_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2303: p_custom6_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2304: p_custom7_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2305: p_custom8_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2313: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2306: p_custom9_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2313: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2314: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2307: p_custom10_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2313: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2314: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2315: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2308: p_custom11_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2309: p_custom12_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2310: p_custom13_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2311: p_custom14_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2312: p_custom15_array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2313: p_has_core_field_errors OUT NOCOPY BOOLEAN,
2314: p_has_custom_field_errors OUT NOCOPY BOOLEAN,
2315: p_receipts_errors IN OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
2316: p_receipts_with_errors_count IN OUT NOCOPY BINARY_INTEGER,
2377: BEGIN
2378:
2379: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_VALIDATE_UTIL', 'start validateExpLine');
2380:
2381: AP_WEB_DFLEX_PKG.IsSessionTaxEnabled(
2382: V_IsSessionTaxEnabled,
2383: p_userId); -- 2242176, fnd user id
2384:
2385: -- validate core lines fields
2567: PROCEDURE MapColumnToCustomFields(
2568: p_userId IN NUMBER,
2569: P_ReceiptIndex IN NUMBER,
2570: Attribute_Array IN AP_WEB_PARENT_PKG.BigString_Array,
2571: ExpReportLinesInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2568: p_userId IN NUMBER,
2569: P_ReceiptIndex IN NUMBER,
2570: Attribute_Array IN AP_WEB_PARENT_PKG.BigString_Array,
2571: ExpReportLinesInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2569: P_ReceiptIndex IN NUMBER,
2570: Attribute_Array IN AP_WEB_PARENT_PKG.BigString_Array,
2571: ExpReportLinesInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2570: Attribute_Array IN AP_WEB_PARENT_PKG.BigString_Array,
2571: ExpReportLinesInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2571: ExpReportLinesInfo IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2572: Custom1_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2573: Custom2_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2574: Custom3_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2575: Custom4_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2576: Custom5_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2577: Custom6_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2578: Custom7_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2579: Custom8_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2580: Custom9_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2588:
2581: Custom10_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2588:
2589: l_CustomFieldsForOneReceipt AP_WEB_DFLEX_PKG.CustomFields_A;
2582: Custom11_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2583: Custom12_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2584: Custom13_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2588:
2589: l_CustomFieldsForOneReceipt AP_WEB_DFLEX_PKG.CustomFields_A;
2590: l_CustomField AP_WEB_DFLEX_PKG.CustomFieldRec;
2585: Custom14_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A,
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2588:
2589: l_CustomFieldsForOneReceipt AP_WEB_DFLEX_PKG.CustomFields_A;
2590: l_CustomField AP_WEB_DFLEX_PKG.CustomFieldRec;
2591: I NUMBER;
2592: l_NumGlobalEnabledSegs NUMBER;
2593: l_NumContextEnabledSegs NUMBER;
2586: Custom15_Array IN OUT NOCOPY AP_WEB_DFLEX_PKG.CustomFields_A)
2587: IS
2588:
2589: l_CustomFieldsForOneReceipt AP_WEB_DFLEX_PKG.CustomFields_A;
2590: l_CustomField AP_WEB_DFLEX_PKG.CustomFieldRec;
2591: I NUMBER;
2592: l_NumGlobalEnabledSegs NUMBER;
2593: l_NumContextEnabledSegs NUMBER;
2594: l_DFlexfield FND_DFLEX.DFLEX_R;
2647:
2648: -- Initialize l_CustomFieldsForOneReceipt
2649: l_DebugInfo := 'Initialize l_CustomFieldsForOneReceipt';
2650: FOR I IN 1..15 LOOP
2651: AP_WEB_DFLEX_PKG.ClearCustomFieldRec(l_CustomFieldsForOneReceipt(I));
2652: END LOOP;
2653:
2654: -- Get information about custom fields
2655: l_DebugInfo := 'Get information about custom fields';
2652: END LOOP;
2653:
2654: -- Get information about custom fields
2655: l_DebugInfo := 'Get information about custom fields';
2656: AP_WEB_DFLEX_PKG.PopulateCustomFieldsInfo(
2657: p_userId => p_userId,
2658: p_exp_line_info => ExpReportLinesInfo(P_ReceiptIndex),
2659: p_custom_fields_array => l_CustomFieldsForOneReceipt,
2660: p_num_global_enabled_segs => l_NumGlobalEnabledSegs,
2667: -- Map the columns to custom value
2668: l_DebugInfo := 'Map the columns to custom value';
2669: FOR I IN 1..15 LOOP
2670:
2671: IF AP_WEB_DFLEX_PKG.IsFlexFieldUsed(l_CustomFieldsForOneReceipt(I)) THEN
2672:
2673: MapColToField(
2674: Attribute_Array,
2675: l_CustomFieldsForOneReceipt(I).column_mapping,
2679: END LOOP;
2680:
2681: -- Propagate receipt info into the custom array
2682: l_DebugInfo := 'Propagate receipt info into the custom array';
2683: AP_WEB_DFLEX_PKG.PropogateReceiptCustFldsInfo(
2684: p_receipt_custom_fields_array => l_CustomFieldsForOneReceipt,
2685: p_receipt_index => P_ReceiptIndex,
2686: p_custom1_array => Custom1_Array,
2687: p_custom2_array => Custom2_Array,