[Home] [Help]
1414:
1415: Pa_Trx_Import.G_Exit_Main := NULL;
1416: Pa_Trx_Import.G_Batch_Size := 0;
1417:
1418: G_Stage := 'Call Hxc_Generic_Retrieval_Pkg.Update_Transaction_Status() one last time.';
1419: If G_Debug_Mode = 'Y' Then
1420: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1421: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1422: End If;
2387: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2388: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2389: End If;
2390:
2391: Hxc_Generic_Retrieval_Pkg.T_Tx_Detail_Status(G_Trx_Direct_Upd_Tab(j).BB_Index) := 'SUCCESS';
2392: EXIT when j = G_Trx_Direct_Upd_Tab.Last;
2393:
2394: End Loop;
2395:
2684:
2685: If P_New_Old_BB = 'NEW' Then
2686:
2687: G_Stage := 'Get New Detail Building Block data. Inc by person id(Resource Id): ' ||
2688: to_char(Hxc_Generic_Retrieval_Pkg.T_Detail_Bld_Blks(P_Detail_Index).Resource_Id);
2689: If G_Debug_Mode = 'Y' Then
2690: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2691: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2692: End If;
3454: Loop
3455:
3456: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then
3457:
3458: G_Stage := 'Got old Project Id: ' || Hxc_Generic_Retrieval_Pkg.T_Old_Detail_Attributes(j).Value ||
3459: ' Index position: ' || to_char(j);
3460: If G_Debug_Mode = 'Y' Then
3461: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3462: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3922: -- Pre-Reqs : None
3923: -- Type : Procedure
3924: -- Return : n/a
3925: -- Function : This procedure finds the Index located in the detail pl/sql
3926: -- Hxc_Generic_Retrieval_Pkg.T_Detail_Bld_Blks table generated
3927: -- during the generic retrieval process for the
3928: -- Building_Block_Id that is passed in to it.
3929: --
3930: -- Parameters :