4472: -- Variables for dff validation
4473: l_recDFlexR Fnd_Dflex.Dflex_R;
4474: l_recDFlexDR Fnd_Dflex.Dflex_Dr;
4475: l_recContextsDR Fnd_Dflex.Contexts_Dr;
4476: l_arrDflex Pa_Self_Service_Dflex_Pub.Dflex_Array;
4477: l_strContext Varchar2(30); -- Changed length from 20 to 30. Bug 4036480
4478: l_strReferenceField Varchar2(200);
4479: l_bresult Boolean;
4480:
4551:
4552: End If;
4553:
4554: -- Initializing dff validation procedures
4555: G_Stage := 'Call procedure Pa_Self_Service_Dflex_Pub.InitDFlex().';
4556: Pa_Self_Service_Dflex_Pub.InitDFlex(
4557: P_StrProductName => 'PA',
4558: P_StrDFlexName => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
4559: P_sErrorStack => l_Error_Stack,
4552: End If;
4553:
4554: -- Initializing dff validation procedures
4555: G_Stage := 'Call procedure Pa_Self_Service_Dflex_Pub.InitDFlex().';
4556: Pa_Self_Service_Dflex_Pub.InitDFlex(
4557: P_StrProductName => 'PA',
4558: P_StrDFlexName => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
4559: P_sErrorStack => l_Error_Stack,
4560: X_RecDFlexR => l_RecDFlexR,
4577: -- Call IsDFlexUsed to determine whether any desc flex segments
4578: -- are defined. If no, then it is not necessary to perform DFF
4579: -- validation.
4580:
4581: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.IsDFlexUsed().';
4582: Pa_Self_Service_Dflex_Pub.IsDFlexUsed(
4583: P_RecDFlexR => l_RecDFlexR,
4584: P_RecContextsDR => l_RecContextsDR,
4585: P_sErrorStack => l_Error_Stack,
4578: -- are defined. If no, then it is not necessary to perform DFF
4579: -- validation.
4580:
4581: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.IsDFlexUsed().';
4582: Pa_Self_Service_Dflex_Pub.IsDFlexUsed(
4583: P_RecDFlexR => l_RecDFlexR,
4584: P_RecContextsDR => l_RecContextsDR,
4585: P_sErrorStack => l_Error_Stack,
4586: X_bResult => l_bResult,
4599:
4600: --Call GetDFlexReferenceField to determine the Reference field for the DFF, either
4601: --system_linkage_function or expenditure_type in this case.
4602:
4603: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.GetDFlexReferenceField().';
4604: Pa_Self_Service_DFlex_Pub.GetDFlexReferenceField(
4605: P_RecDFlexDR => l_RecDFlexDR,
4606: P_sErrorStack => l_Error_Stack,
4607: X_StrReferenceField => l_strReferenceField,
4600: --Call GetDFlexReferenceField to determine the Reference field for the DFF, either
4601: --system_linkage_function or expenditure_type in this case.
4602:
4603: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.GetDFlexReferenceField().';
4604: Pa_Self_Service_DFlex_Pub.GetDFlexReferenceField(
4605: P_RecDFlexDR => l_RecDFlexDR,
4606: P_sErrorStack => l_Error_Stack,
4607: X_StrReferenceField => l_strReferenceField,
4608: X_sErrorType => l_Error_Type,
5113: l_ArrDflex(8) := l_Proj_Attrib_Rec.Attribute8;
5114: l_ArrDFlex(9) := l_Proj_Attrib_Rec.Attribute9;
5115: l_ArrDFlex(10) := l_Proj_Attrib_Rec.Attribute10;
5116:
5117: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.ValidateDFlex().';
5118: Pa_Self_Service_Dflex_Pub.ValidateDFlex(
5119: P_StrProductName => 'PA',
5120: P_StrDFlexName => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5121: P_RecContextsDR => l_RecContextsDR,
5114: l_ArrDFlex(9) := l_Proj_Attrib_Rec.Attribute9;
5115: l_ArrDFlex(10) := l_Proj_Attrib_Rec.Attribute10;
5116:
5117: G_Stage := 'Call Pa_Self_Service_Dflex_Pub.ValidateDFlex().';
5118: Pa_Self_Service_Dflex_Pub.ValidateDFlex(
5119: P_StrProductName => 'PA',
5120: P_StrDFlexName => 'PA_EXPENDITURE_ITEMS_DESC_FLEX',
5121: P_RecContextsDR => l_RecContextsDR,
5122: P_StrContextName => l_StrContext,