[Home] [Help]
1444:
1445: Pa_Trx_Import.G_Exit_Main := NULL;
1446: Pa_Trx_Import.G_Batch_Size := 0;
1447:
1448: G_Stage := 'Call Hxc_Generic_Retrieval_Pkg.Update_Transaction_Status() one last time.';
1449: If G_Debug_Mode = 'Y' Then
1450: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1451: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1452: End If;
2375: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2376: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2377: End If;
2378:
2379: Hxc_Generic_Retrieval_Pkg.T_Tx_Detail_Status(G_Trx_Direct_Upd_Tab(j).BB_Index) := 'SUCCESS';
2380: EXIT when j = G_Trx_Direct_Upd_Tab.Last;
2381:
2382: End Loop;
2383:
2748:
2749: If P_New_Old_BB = 'NEW' Then
2750:
2751: G_Stage := 'Get New Detail Building Block data. Inc by person id(Resource Id): ' ||
2752: to_char(Hxc_Generic_Retrieval_Pkg.T_Detail_Bld_Blks(P_Detail_Index).Resource_Id);
2753: If G_Debug_Mode = 'Y' Then
2754: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2755: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2756: End If;
3626: Loop
3627:
3628: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then
3629:
3630: G_Stage := 'Got old Project Id: ' || Hxc_Generic_Retrieval_Pkg.T_Old_Detail_Attributes(j).Value ||
3631: ' Index position: ' || to_char(j);
3632: If G_Debug_Mode = 'Y' Then
3633: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3634: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
4196: -- Pre-Reqs : None
4197: -- Type : Procedure
4198: -- Return : n/a
4199: -- Function : This procedure finds the Index located in the detail pl/sql
4200: -- Hxc_Generic_Retrieval_Pkg.T_Detail_Bld_Blks table generated
4201: -- during the generic retrieval process for the
4202: -- Building_Block_Id that is passed in to it.
4203: --
4204: -- Parameters :