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 519: Hxc_Integration_Layer_V1_Grp.Execute_Retrieval_Process(

515: If G_Debug_Mode = 'Y' Then
516: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
517: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
518: End If;
519: Hxc_Integration_Layer_V1_Grp.Execute_Retrieval_Process(
520: P_Process => 'Projects Retrieval Process',
521: P_Transaction_code => Null,
522: P_Start_Date => Null,
523: P_End_Date => Null,

Line 1423: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

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;
1423: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1424: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1425: (P_Process => 'Projects Retrieval Process',
1426: P_Status => 'SUCCESS',
1427: P_Exception_Description => NULL);

Line 1424: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

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;
1423: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1424: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1425: (P_Process => 'Projects Retrieval Process',
1426: P_Status => 'SUCCESS',
1427: P_Exception_Description => NULL);
1428:

Line 1445: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1441:
1442: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1443: l_Error_Text := SUBSTR(fnd_message.get,1,2000);
1444:
1445: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1446: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1447: (P_Process => 'Projects Retrieval Process',
1448: P_Status => 'ERRORS',
1449: P_Exception_Description => l_Error_Text);

Line 1446: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1442: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1443: l_Error_Text := SUBSTR(fnd_message.get,1,2000);
1444:
1445: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1446: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1447: (P_Process => 'Projects Retrieval Process',
1448: P_Status => 'ERRORS',
1449: P_Exception_Description => l_Error_Text);
1450:

Line 1469: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1465: -- that meains this is not the first time thru and we would not want to raise an error.
1466: -- The global variable is set to TRUE at the end of the Tieback_Otc_Timecards() procedure.
1467: -- If Not G_Processed_Import_Batch Then
1468: --
1469: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1470: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1471: -- (P_Process => 'Projects Retrieval Process',
1472: -- P_Status => 'ERRORS',
1473: -- P_Exception_Description =>

Line 1470: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1466: -- The global variable is set to TRUE at the end of the Tieback_Otc_Timecards() procedure.
1467: -- If Not G_Processed_Import_Batch Then
1468: --
1469: -- Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1470: -- Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1471: -- (P_Process => 'Projects Retrieval Process',
1472: -- P_Status => 'ERRORS',
1473: -- P_Exception_Description =>
1474: -- substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage ||

Line 1497: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

1493:
1494: Else
1495:
1496: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
1497: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1498: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1499: (P_Process => 'Projects Retrieval Process',
1500: P_Status => 'ERRORS',
1501: P_Exception_Description =>

Line 1498: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status

1494: Else
1495:
1496: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
1497: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
1498: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status
1499: (P_Process => 'Projects Retrieval Process',
1500: P_Status => 'ERRORS',
1501: P_Exception_Description =>
1502: substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM, 1, 2000));

Line 2404: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;

2400: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2401: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2402: End If;
2403:
2404: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
2405: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2406: P_Process => 'Projects Retrieval Process',
2407: P_Status => 'SUCCESS',
2408: P_Exception_Description => NULL);

Line 2405: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (

2401: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2402: End If;
2403:
2404: Hxc_Integration_Layer_V1_Grp.Set_Parent_Statuses;
2405: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2406: P_Process => 'Projects Retrieval Process',
2407: P_Status => 'SUCCESS',
2408: P_Exception_Description => NULL);
2409:

Line 2431: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (

2427:
2428: Exception
2429: When Others Then
2430: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || SQLERRM;
2431: Hxc_Integration_Layer_V1_Grp.Update_Transaction_Status (
2432: P_Process => 'Projects Retrieval Process',
2433: P_Status => 'ERRORS',
2434: P_Exception_Description => Pa_Debug.G_err_Stage);
2435: RAISE;

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

4069: Pa_Otc_Api.TrackPath('ADD','Update_Otc_Data');
4070:
4071: If P_Operation <> 'MIGRATION' Then
4072:
4073: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params()';
4074: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4075: P_Building_Blocks => l_Blocks,
4076: P_App_Attributes => l_Attributes,
4077: P_Messages => l_Messages);

Line 4074: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(

4070:
4071: If P_Operation <> 'MIGRATION' Then
4072:
4073: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params()';
4074: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4075: P_Building_Blocks => l_Blocks,
4076: P_App_Attributes => l_Attributes,
4077: P_Messages => l_Messages);
4078:

Line 4086: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(

4082: P_Building_Blocks => l_Blocks,
4083: P_Attribute_Table => l_Attributes);
4084:
4085: G_Stage := 'Call hxc_self_service_time_deposit.set_app_hook_params()';
4086: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(
4087: P_Building_Blocks => l_Blocks,
4088: P_App_Attributes => l_Attributes,
4089: P_Messages => l_Messages);
4090:

Line 4363: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(

4359:
4360: If P_Operation <> 'MIGRATION' Then
4361:
4362: G_Stage := 'Call hxc_self_service_time_deposit.get_app_hook_params()';
4363: Hxc_Integration_Layer_V1_Grp.Get_App_Hook_Params(
4364: P_Building_Blocks => l_Blocks,
4365: P_App_Attributes => l_Attributes,
4366: P_Messages => l_Messages);
4367:

Line 4378: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(

4374:
4375: If l_Messages.COUNT > 0 Then
4376:
4377: G_Stage := 'Call hxc_self_service_time_deposit.set_app_hook_params()';
4378: Hxc_Integration_Layer_V1_Grp.Set_App_Hook_Params(
4379: P_Building_Blocks => l_Blocks,
4380: P_App_Attributes => l_Attributes,
4381: P_Messages => l_Messages);
4382:

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

6300: G_Stage := 'BB Id and BB Ovn.';
6301: l_BB_Id := To_Number(SubStr(P_Orig_Txn_Reference,1,InStr(P_Orig_Txn_Reference,':') - 1));
6302: l_BB_Ovn := To_Number(SubStr(P_Orig_Txn_Reference,InStr(P_Orig_Txn_Reference,':') + 1));
6303:
6304: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed API.';
6305: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(
6306: P_Bb_Id => l_bb_id,
6307: P_Bb_Ovn => l_bb_ovn);
6308:

Line 6305: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(

6301: l_BB_Id := To_Number(SubStr(P_Orig_Txn_Reference,1,InStr(P_Orig_Txn_Reference,':') - 1));
6302: l_BB_Ovn := To_Number(SubStr(P_Orig_Txn_Reference,InStr(P_Orig_Txn_Reference,':') + 1));
6303:
6304: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed API.';
6305: l_Changed_Flag := Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed(
6306: P_Bb_Id => l_bb_id,
6307: P_Bb_Ovn => l_bb_ovn);
6308:
6309: G_Stage := 'Set out going flag based on what OTL is saying.';

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

6378: If P_Search_Attribute in ('PROJECT','TASK') and P_Search_Value is not null Then
6379:
6380: If P_Search_Attribute = 'PROJECT' Then
6381:
6382: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if project exists.';
6383: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6384: P_Bld_Blk_Info_Type => 'PROJECTS'
6385: , P_Field_Name => 'Project_Id'
6386: , P_Field_Value => P_Search_Value

Line 6383: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

6379:
6380: If P_Search_Attribute = 'PROJECT' Then
6381:
6382: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if project exists.';
6383: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6384: P_Bld_Blk_Info_Type => 'PROJECTS'
6385: , P_Field_Name => 'Project_Id'
6386: , P_Field_Value => P_Search_Value
6387: , P_Scope => 'DETAIL');

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

6387: , P_Scope => 'DETAIL');
6388:
6389: Else
6390:
6391: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if task exists.';
6392: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6393: P_Bld_Blk_Info_Type => 'PROJECTS'
6394: , P_Field_Name => 'Task_Id'
6395: , P_Field_Value => P_Search_Value

Line 6392: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

6388:
6389: Else
6390:
6391: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API to check if task exists.';
6392: l_Attribute_Exists := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6393: P_Bld_Blk_Info_Type => 'PROJECTS'
6394: , P_Field_Name => 'Task_Id'
6395: , P_Field_Value => P_Search_Value
6396: , P_Scope => 'DETAIL');

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

6455: If P_Search_Attribute in ('PROJECT','TASK') And P_Search_Value is Not Null Then
6456:
6457: If P_Search_Attribute = 'PROJECT' Then
6458:
6459: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if project purgeable.';
6460: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6461: P_Bld_Blk_Info_Type => 'PROJECTS'
6462: , P_Field_Name => 'Project_Id'
6463: , P_Field_Value => P_Search_Value

Line 6460: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

6456:
6457: If P_Search_Attribute = 'PROJECT' Then
6458:
6459: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if project purgeable.';
6460: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6461: P_Bld_Blk_Info_Type => 'PROJECTS'
6462: , P_Field_Name => 'Project_Id'
6463: , P_Field_Value => P_Search_Value
6464: , P_Scope => 'DETAIL'

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

6465: , P_Retrieval_Process_Name => 'Projects Retrieval Process');
6466:
6467: Else
6468:
6469: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if task purgeable.';
6470: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6471: P_Bld_Blk_Info_Type => 'PROJECTS'
6472: , P_Field_Name => 'Task_Id'
6473: , P_Field_Value => P_Search_Value

Line 6470: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (

6466:
6467: Else
6468:
6469: G_Stage := 'Call Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists() API procedure to check if task purgeable.';
6470: l_Attribute_Purgeable := Hxc_Integration_Layer_V1_Grp.Chk_Mapping_Exists (
6471: P_Bld_Blk_Info_Type => 'PROJECTS'
6472: , P_Field_Name => 'Task_Id'
6473: , P_Field_Value => P_Search_Value
6474: , P_Scope => 'DETAIL'

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

7788: -- back a partial set of building blocks.
7789: If l_Building_Blocks_Table.Count > 1 Then -- and l_Message_Table.Count = 0 Then bug 3766110
7790:
7791: G_Stage := 'Convert Building Blocks pl/sql table to varchar2.';
7792: P_Timecard := Hxc_Integration_Layer_V1_Grp.Blocks_To_String( P_Blocks => l_Building_Blocks_Table );
7793:
7794: G_Stage := 'Convert Attribution pl/sql table to varchar2.';
7795: P_Attributes := Hxc_Integration_Layer_V1_Grp.Attributes_To_String ( P_Attributes => l_Attribute_Table );
7796:

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

7791: G_Stage := 'Convert Building Blocks pl/sql table to varchar2.';
7792: P_Timecard := Hxc_Integration_Layer_V1_Grp.Blocks_To_String( P_Blocks => l_Building_Blocks_Table );
7793:
7794: G_Stage := 'Convert Attribution pl/sql table to varchar2.';
7795: P_Attributes := Hxc_Integration_Layer_V1_Grp.Attributes_To_String ( P_Attributes => l_Attribute_Table );
7796:
7797: End If;
7798:
7799: -- Begin bug 3766110

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

7800:
7801: -- If l_Message_Table.Count > 0 Then
7802:
7803: -- G_Stage := 'Convert Message pl/sql table to varchar2.';
7804: -- P_Messages := Hxc_Integration_Layer_V1_Grp.Messages_to_String ( P_Messages => l_Message_Table );
7805:
7806: -- End If;
7807:
7808: -- End Bug 3766110

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

8226:
8227: If l_Message_Table.Count > 0 Then
8228:
8229: G_Stage := 'Calling Hxc_Deposit_Wrapper_Utilities.Messages_To_String().';
8230: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
8231: End If;
8232:
8233: G_Stage := 'Leaving Wf_AutoApproval_BusMsg() procedure.';
8234: Pa_Otc_Api.TrackPath('STRIP','Wf_AutoApproval_BusMsg');

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

8494:
8495: If l_Message_Table.Count > 0 Then
8496:
8497: G_Stage := 'Messages have been created convert to varchar by calling ' ||
8498: 'Hxc_Integration_Layer_V1_Grp.Messages_To_String().';
8499: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
8500: End If;
8501:
8502: G_Stage := 'Leaving Wf_RouteTo_CheckApproval() procedure.';

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

8495: If l_Message_Table.Count > 0 Then
8496:
8497: G_Stage := 'Messages have been created convert to varchar by calling ' ||
8498: 'Hxc_Integration_Layer_V1_Grp.Messages_To_String().';
8499: X_Messages := Hxc_Integration_Layer_V1_Grp.Messages_To_String(P_Messages => l_Message_Table);
8500: End If;
8501:
8502: G_Stage := 'Leaving Wf_RouteTo_CheckApproval() procedure.';
8503: Pa_Otc_Api.TrackPath('STRIP','Wf_RouteTo_CheckApproval');

Line 8555: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;

8551:
8552: X_Timecard_Table.delete;
8553:
8554: G_Stage := 'Get the hxc pl/sql building block and attribution tables.';
8555: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;
8556: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;
8557:
8558: G_Stage := 'Begin looping thru hxc pl/sql building block table.';
8559: For i in l_Time_Building_Blocks.FIRST .. l_Time_Building_Blocks.LAST

Line 8556: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;

8552: X_Timecard_Table.delete;
8553:
8554: G_Stage := 'Get the hxc pl/sql building block and attribution tables.';
8555: l_Time_Building_Blocks := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_Building_Blocks;
8556: l_Time_Attributes := Hxc_Integration_Layer_V1_Grp.Get_Wf_G_Time_App_Attributes;
8557:
8558: G_Stage := 'Begin looping thru hxc pl/sql building block table.';
8559: For i in l_Time_Building_Blocks.FIRST .. l_Time_Building_Blocks.LAST
8560: Loop

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

8741: /* The hxc function returns the case of whether or not there is a higher ovn value in the OTL table
8742: * than the ovn value we are passing in.
8743: * Therefore we actually want to return the opposite of that to the calling procedure/view.
8744: */
8745: If Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed( P_BB_Id => l_BB_id, P_BB_Ovn => l_BB_Ovn) Then
8746:
8747: Return ( 'N' );
8748:
8749: Else