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.PA_OTC_API dependencies on HXC_INTEGRATION_LAYER_V1_GRP

Line 537: Hxc_Integration_Layer_V1_Grp.Execute_Retrieval_Process(

533: If G_Debug_Mode = 'Y' Then
534: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
535: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
536: End If;
537: Hxc_Integration_Layer_V1_Grp.Execute_Retrieval_Process(
538: P_Process => 'Projects Retrieval Process',
539: P_Transaction_code => Null,
540: P_Start_Date => Null,
541: P_End_Date => Null,

Line 1453: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

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;
1453: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1454: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1455: (P_Process => 'Projects Retrieval Process',
1456: P_Status => 'SUCCESS',
1457: P_Exception_Description => NULL);

Line 1454: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

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;
1453: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1454: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1455: (P_Process => 'Projects Retrieval Process',
1456: P_Status => 'SUCCESS',
1457: P_Exception_Description => NULL);
1458:

Line 1475: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1471:
1472: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1473: l_Error_Text := SUBSTR(fnd_message.get,1,2000);
1474:
1475: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1476: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1477: (P_Process => 'Projects Retrieval Process',
1478: P_Status => 'ERRORS',
1479: P_Exception_Description => l_Error_Text);

Line 1476: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1472: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1473: l_Error_Text := SUBSTR(fnd_message.get,1,2000);
1474:
1475: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1476: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1477: (P_Process => 'Projects Retrieval Process',
1478: P_Status => 'ERRORS',
1479: P_Exception_Description => l_Error_Text);
1480:

Line 1499: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1495: -- that meains this is not the first time thru and we would not want to raise an error.
1496: -- The global variable is set to TRUE at the end of the Tieback_Otc_Timecards() procedure.
1497: -- If Not G_Processed_Import_Batch Then
1498: --
1499: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1500: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1501: -- (P_Process => 'Projects Retrieval Process',
1502: -- P_Status => 'ERRORS',
1503: -- P_Exception_Description =>

Line 1500: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1496: -- The global variable is set to TRUE at the end of the Tieback_Otc_Timecards() procedure.
1497: -- If Not G_Processed_Import_Batch Then
1498: --
1499: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1500: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1501: -- (P_Process => 'Projects Retrieval Process',
1502: -- P_Status => 'ERRORS',
1503: -- P_Exception_Description =>
1504: -- substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage ||

Line 1527: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1523:
1524: Else
1525:
1526: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
1527: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1528: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1529: (P_Process => 'Projects Retrieval Process',
1530: P_Status => 'ERRORS',
1531: P_Exception_Description =>

Line 1528: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1524: Else
1525:
1526: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
1527: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1528: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1529: (P_Process => 'Projects Retrieval Process',
1530: P_Status => 'ERRORS',
1531: P_Exception_Description =>
1532: substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM, 1, 2000));

Line 2392: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

2388: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2389: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2390: End If;
2391:
2392: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
2393: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2394: P_Process => 'Projects Retrieval Process',
2395: P_Status => 'SUCCESS',
2396: P_Exception_Description => NULL);

Line 2393: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (

2389: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2390: End If;
2391:
2392: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
2393: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2394: P_Process => 'Projects Retrieval Process',
2395: P_Status => 'SUCCESS',
2396: P_Exception_Description => NULL);
2397:

Line 2419: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (

2415:
2416: Exception
2417: When Others Then
2418: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
2419: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2420: P_Process => 'Projects Retrieval Process',
2421: P_Status => 'ERRORS',
2422: P_Exception_Description => Pa_Debug.G_err_Stage);
2423: RAISE;

Line 4347: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params()';

4343: Pa_Otc_Api.TrackPath('ADD','Update_Otc_Data');
4344:
4345: If P_Operation <> 'MIGRATION' Then
4346:
4347: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params()';
4348: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4349: P_Building_Blocks => l_Blocks,
4350: P_App_Attributes => l_Attributes,
4351: P_Messages => l_Messages);

Line 4348: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(

4344:
4345: If P_Operation <> 'MIGRATION' Then
4346:
4347: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params()';
4348: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4349: P_Building_Blocks => l_Blocks,
4350: P_App_Attributes => l_Attributes,
4351: P_Messages => l_Messages);
4352:

Line 4360: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(

4356: P_Building_Blocks => l_Blocks,
4357: P_Attribute_Table => l_Attributes);
4358:
4359: G_Stage := 'Call hxc_self_service_time_deposit.set_app_hook_params()';
4360: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(
4361: P_Building_Blocks => l_Blocks,
4362: P_App_Attributes => l_Attributes,
4363: P_Messages => l_Messages);
4364:

Line 4664: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(

4660:
4661: If P_Operation <> 'MIGRATION' Then
4662:
4663: G_Stage := 'Call hxc_self_service_time_deposit.get_app_hook_params()';
4664: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4665: P_Building_Blocks => l_Blocks,
4666: P_App_Attributes => l_Attributes,
4667: P_Messages => l_Messages);
4668:

Line 4679: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(

4675:
4676: If l_Messages.COUNT > 0 Then
4677:
4678: G_Stage := 'Call hxc_self_service_time_deposit.set_app_hook_params()';
4679: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(
4680: P_Building_Blocks => l_Blocks,
4681: P_App_Attributes => l_Attributes,
4682: P_Messages => l_Messages);
4683:

Line 7048: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed API.';

7044: G_Stage := 'BB Id and BB Ovn.';
7045: l_BB_Id := To_Number(SubStr(P_Orig_Txn_Reference,1,InStr(P_Orig_Txn_Reference,':') - 1));
7046: l_BB_Ovn := To_Number(SubStr(P_Orig_Txn_Reference,InStr(P_Orig_Txn_Reference,':') + 1));
7047:
7048: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed API.';
7049: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(
7050: P_Bb_Id => l_bb_id,
7051: P_Bb_Ovn => l_bb_ovn);
7052:

Line 7049: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(

7045: l_BB_Id := To_Number(SubStr(P_Orig_Txn_Reference,1,InStr(P_Orig_Txn_Reference,':') - 1));
7046: l_BB_Ovn := To_Number(SubStr(P_Orig_Txn_Reference,InStr(P_Orig_Txn_Reference,':') + 1));
7047:
7048: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed API.';
7049: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(
7050: P_Bb_Id => l_bb_id,
7051: P_Bb_Ovn => l_bb_ovn);
7052:
7053: G_Stage := 'Set out going flag based on what OTL is saying.';

Line 7126: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if project exists.';

7122: If P_Search_Attribute in ('PROJECT','TASK') and P_Search_Value is not null Then
7123:
7124: If P_Search_Attribute = 'PROJECT' Then
7125:
7126: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if project exists.';
7127: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7128: P_Bld_Blk_Info_Type => 'PROJECTS'
7129: , P_Field_Name => 'Project_Id'
7130: , P_Field_Value => P_Search_Value

Line 7127: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

7123:
7124: If P_Search_Attribute = 'PROJECT' Then
7125:
7126: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if project exists.';
7127: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7128: P_Bld_Blk_Info_Type => 'PROJECTS'
7129: , P_Field_Name => 'Project_Id'
7130: , P_Field_Value => P_Search_Value
7131: , P_status => 'WORKING' -- 8360516

Line 7136: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if task exists.';

7132: , P_Scope => 'DETAIL');
7133:
7134: Else
7135:
7136: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if task exists.';
7137: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7138: P_Bld_Blk_Info_Type => 'PROJECTS'
7139: , P_Field_Name => 'Task_Id'
7140: , P_Field_Value => P_Search_Value

Line 7137: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

7133:
7134: Else
7135:
7136: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if task exists.';
7137: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7138: P_Bld_Blk_Info_Type => 'PROJECTS'
7139: , P_Field_Name => 'Task_Id'
7140: , P_Field_Value => P_Search_Value
7141: , P_status => 'WORKING' -- 8360516

Line 7205: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if project purgeable.';

7201: If P_Search_Attribute in ('PROJECT','TASK') And P_Search_Value is Not Null Then
7202:
7203: If P_Search_Attribute = 'PROJECT' Then
7204:
7205: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if project purgeable.';
7206: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7207: P_Bld_Blk_Info_Type => 'PROJECTS'
7208: , P_Field_Name => 'Project_Id'
7209: , P_Field_Value => P_Search_Value

Line 7206: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

7202:
7203: If P_Search_Attribute = 'PROJECT' Then
7204:
7205: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if project purgeable.';
7206: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7207: P_Bld_Blk_Info_Type => 'PROJECTS'
7208: , P_Field_Name => 'Project_Id'
7209: , P_Field_Value => P_Search_Value
7210: , P_Scope => 'DETAIL'

Line 7215: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if task purgeable.';

7211: , P_Retrieval_Process_Name => 'Projects Retrieval Process');
7212:
7213: Else
7214:
7215: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if task purgeable.';
7216: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7217: P_Bld_Blk_Info_Type => 'PROJECTS'
7218: , P_Field_Name => 'Task_Id'
7219: , P_Field_Value => P_Search_Value

Line 7216: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

7212:
7213: Else
7214:
7215: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if task purgeable.';
7216: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
7217: P_Bld_Blk_Info_Type => 'PROJECTS'
7218: , P_Field_Name => 'Task_Id'
7219: , P_Field_Value => P_Search_Value
7220: , P_Scope => 'DETAIL'

Line 8675: P_Timecard := Hxc_Integration_Layer_V1_Grp.Blocks_To_String( P_Blocks => l_Building_Blocks_Table );

8671: -- back a partial set of building blocks.
8672: If l_Building_Blocks_Table.Count > 1 Then -- and l_Message_Table.Count = 0 Then bug 3766110
8673:
8674: G_Stage := 'Convert Building Blocks pl/sql table to varchar2.';
8675: P_Timecard := Hxc_Integration_Layer_V1_Grp.Blocks_To_String( P_Blocks => l_Building_Blocks_Table );
8676:
8677: G_Stage := 'Convert Attribution pl/sql table to varchar2.';
8678: P_Attributes := Hxc_Integration_Layer_V1_Grp.Attributes_To_String ( P_Attributes => l_Attribute_Table );
8679:

Line 8678: P_Attributes := Hxc_Integration_Layer_V1_Grp.Attributes_To_String ( P_Attributes => l_Attribute_Table );

8674: G_Stage := 'Convert Building Blocks pl/sql table to varchar2.';
8675: P_Timecard := Hxc_Integration_Layer_V1_Grp.Blocks_To_String( P_Blocks => l_Building_Blocks_Table );
8676:
8677: G_Stage := 'Convert Attribution pl/sql table to varchar2.';
8678: P_Attributes := Hxc_Integration_Layer_V1_Grp.Attributes_To_String ( P_Attributes => l_Attribute_Table );
8679:
8680: End If;
8681:
8682: -- Begin bug 3766110

Line 8687: -- P_Messages := Hxc_Integration_Layer_V1_Grp.Messages_to_String ( P_Messages => l_Message_Table );

8683:
8684: -- If l_Message_Table.Count > 0 Then
8685:
8686: -- G_Stage := 'Convert Message pl/sql table to varchar2.';
8687: -- P_Messages := Hxc_Integration_Layer_V1_Grp.Messages_to_String ( P_Messages => l_Message_Table );
8688:
8689: -- End If;
8690:
8691: -- End Bug 3766110

Line 9139: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);

9135:
9136: If l_Message_Table.Count > 0 Then
9137:
9138: G_Stage := 'Calling Hxc_Deposit_Wrapper_Utilities.Messages_To_String().';
9139: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
9140: End If;
9141:
9142: G_Stage := 'Leaving Wf_AutoApproval_BusMsg() procedure.';
9143: Pa_Otc_Api.TrackPath('STRIP','Wf_AutoApproval_BusMsg');

Line 9407: 'Hxc_Integration_Layer_V1_Grp.Messages_To_String().';

9403:
9404: If l_Message_Table.Count > 0 Then
9405:
9406: G_Stage := 'Messages have been created convert to varchar by calling ' ||
9407: 'Hxc_Integration_Layer_V1_Grp.Messages_To_String().';
9408: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
9409: End If;
9410:
9411: G_Stage := 'Leaving Wf_RouteTo_CheckApproval() procedure.';

Line 9408: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);

9404: If l_Message_Table.Count > 0 Then
9405:
9406: G_Stage := 'Messages have been created convert to varchar by calling ' ||
9407: 'Hxc_Integration_Layer_V1_Grp.Messages_To_String().';
9408: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
9409: End If;
9410:
9411: G_Stage := 'Leaving Wf_RouteTo_CheckApproval() procedure.';
9412: Pa_Otc_Api.TrackPath('STRIP','Wf_RouteTo_CheckApproval');

Line 9464: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;

9460:
9461: X_Timecard_Table.delete;
9462:
9463: G_Stage := 'Get the hxc pl/sql building block and attribution tables.';
9464: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;
9465: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;
9466:
9467: G_Stage := 'Begin looping thru hxc pl/sql building block table.';
9468: For i in l_Time_Building_Blocks.FIRST .. l_Time_Building_Blocks.LAST

Line 9465: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;

9461: X_Timecard_Table.delete;
9462:
9463: G_Stage := 'Get the hxc pl/sql building block and attribution tables.';
9464: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;
9465: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;
9466:
9467: G_Stage := 'Begin looping thru hxc pl/sql building block table.';
9468: For i in l_Time_Building_Blocks.FIRST .. l_Time_Building_Blocks.LAST
9469: Loop

Line 9660: If Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed( P_BB_Id => l_BB_id, P_BB_Ovn => l_BB_Ovn) Then

9656: /* The hxc function returns the case of whether or not there is a higher ovn value in the OTL table
9657: * than the ovn value we are passing in.
9658: * Therefore we actually want to return the opposite of that to the calling procedure/view.
9659: */
9660: If Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed( P_BB_Id => l_BB_id, P_BB_Ovn => l_BB_Ovn) Then
9661:
9662: Return ( 'N' );
9663:
9664: Else