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 FND_MESSAGE

Line 1442: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');

1438: Exception
1439:
1440: When HXC_RETRIEVAL_MAX_ERRORS Then
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

Line 1443: l_Error_Text := SUBSTR(fnd_message.get,1,2000);

1439:
1440: When HXC_RETRIEVAL_MAX_ERRORS Then
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',

Line 1451: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');

1447: (P_Process => 'Projects Retrieval Process',
1448: P_Status => 'ERRORS',
1449: P_Exception_Description => l_Error_Text);
1450:
1451: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1452: fnd_message.raise_error;
1453:
1454: When Others Then
1455:

Line 1452: fnd_message.raise_error;

1448: P_Status => 'ERRORS',
1449: P_Exception_Description => l_Error_Text);
1450:
1451: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1452: fnd_message.raise_error;
1453:
1454: When Others Then
1455:
1456: If ( SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' or

Line 1477: -- Fnd_Message.Raise_Error;

1473: -- P_Exception_Description =>
1474: -- substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage ||
1475: -- ' : ' || SQLERRM, 1, 2000));
1476: --
1477: -- Fnd_Message.Raise_Error;
1478: --
1479: -- End If;
1480:
1481: If SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' Then

Line 1483: fnd_message.set_name('HXC','HXC_0012_GNRET_NO_TIMECARDS');

1479: -- End If;
1480:
1481: If SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' Then
1482:
1483: fnd_message.set_name('HXC','HXC_0012_GNRET_NO_TIMECARDS');
1484: Else
1485:
1486: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1487:

Line 1486: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');

1482:
1483: fnd_message.set_name('HXC','HXC_0012_GNRET_NO_TIMECARDS');
1484: Else
1485:
1486: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1487:
1488: End If;
1489: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || fnd_message.get;
1490: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);

Line 1489: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || fnd_message.get;

1485:
1486: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1487:
1488: End If;
1489: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || fnd_message.get;
1490: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
1491:
1492: -- End bug 3422899
1493:

Line 2313: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);

2309: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := 'ERRORS';
2310:
2311: If TrxRecord.Transaction_Rejection_Code is not null Then
2312:
2313: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);
2314: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2315: Substr(Fnd_Message.Get,1,2000);
2316:
2317: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.

Line 2315: Substr(Fnd_Message.Get,1,2000);

2311: If TrxRecord.Transaction_Rejection_Code is not null Then
2312:
2313: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);
2314: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2315: Substr(Fnd_Message.Get,1,2000);
2316:
2317: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.
2318: -- Else
2319: --

Line 3828: fnd_message.set_name('HXC', l_Status_Code);

3824: l_Status_Code := 'HXC_RET_NO_TIMECARD_DATA_OLD';
3825:
3826: End If;
3827:
3828: fnd_message.set_name('HXC', l_Status_Code);
3829: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3830:
3831: Elsif P_Timecard_Rec.Project_id is null and
3832: P_Timecard_Rec.Task_id is null and

Line 3829: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);

3825:
3826: End If;
3827:
3828: fnd_message.set_name('HXC', l_Status_Code);
3829: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3830:
3831: Elsif P_Timecard_Rec.Project_id is null and
3832: P_Timecard_Rec.Task_id is null and
3833: P_Timecard_Rec.Expenditure_Type is null and

Line 3845: fnd_message.set_name('HXC',l_Status_Code);

3841:
3842: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
3843:
3844: End If;
3845: fnd_message.set_name('HXC',l_Status_Code);
3846: fnd_message.set_token('STAGE', '1');
3847: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3848:
3849: ElsIf P_Timecard_Rec.Quantity is null or

Line 3846: fnd_message.set_token('STAGE', '1');

3842: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
3843:
3844: End If;
3845: fnd_message.set_name('HXC',l_Status_Code);
3846: fnd_message.set_token('STAGE', '1');
3847: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3848:
3849: ElsIf P_Timecard_Rec.Quantity is null or
3850: P_Timecard_Rec.Incurred_By_Person_Id is null or

Line 3847: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);

3843:
3844: End If;
3845: fnd_message.set_name('HXC',l_Status_Code);
3846: fnd_message.set_token('STAGE', '1');
3847: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3848:
3849: ElsIf P_Timecard_Rec.Quantity is null or
3850: P_Timecard_Rec.Incurred_By_Person_Id is null or
3851: P_Timecard_Rec.Expenditure_Item_Date is null Then

Line 3860: fnd_message.set_name('HXC',l_Status_Code);

3856:
3857: l_Status_Code := 'HXC_RET_NO_BLD_BLK_DATA_OLD';
3858:
3859: End If;
3860: fnd_message.set_name('HXC',l_Status_Code);
3861: fnd_message.set_token('STAGE', '1');
3862: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3863:
3864: ElsIf P_Timecard_Rec.Billable_flag is null or

Line 3861: fnd_message.set_token('STAGE', '1');

3857: l_Status_Code := 'HXC_RET_NO_BLD_BLK_DATA_OLD';
3858:
3859: End If;
3860: fnd_message.set_name('HXC',l_Status_Code);
3861: fnd_message.set_token('STAGE', '1');
3862: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3863:
3864: ElsIf P_Timecard_Rec.Billable_flag is null or
3865: P_Timecard_Rec.Project_id is null or

Line 3862: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);

3858:
3859: End If;
3860: fnd_message.set_name('HXC',l_Status_Code);
3861: fnd_message.set_token('STAGE', '1');
3862: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3863:
3864: ElsIf P_Timecard_Rec.Billable_flag is null or
3865: P_Timecard_Rec.Project_id is null or
3866: P_Timecard_Rec.Task_id is null or

Line 3882: fnd_message.set_name('HXC',l_Status_Code);

3878:
3879: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
3880:
3881: End If;
3882: fnd_message.set_name('HXC',l_Status_Code);
3883: fnd_message.set_token('STAGE', '2');
3884: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3885:
3886: End If;

Line 3883: fnd_message.set_token('STAGE', '2');

3879: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
3880:
3881: End If;
3882: fnd_message.set_name('HXC',l_Status_Code);
3883: fnd_message.set_token('STAGE', '2');
3884: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3885:
3886: End If;
3887:

Line 3884: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);

3880:
3881: End If;
3882: fnd_message.set_name('HXC',l_Status_Code);
3883: fnd_message.set_token('STAGE', '2');
3884: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3885:
3886: End If;
3887:
3888: G_Stage := 'Leaving PopulateProjRec(), strip procedure from trackpath.';

Line 3898: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');

3894:
3895: Exception
3896: When Others Then
3897: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
3898: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
3899: fnd_message.set_token('ERR', l_Error_Text);
3900: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3901:
3902: If G_Debug_Mode = 'Y' Then

Line 3899: fnd_message.set_token('ERR', l_Error_Text);

3895: Exception
3896: When Others Then
3897: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
3898: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
3899: fnd_message.set_token('ERR', l_Error_Text);
3900: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3901:
3902: If G_Debug_Mode = 'Y' Then
3903: Pa_Debug.G_err_Stage := P_Timecard_Rec.Status;

Line 3900: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);

3896: When Others Then
3897: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
3898: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
3899: fnd_message.set_token('ERR', l_Error_Text);
3900: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
3901:
3902: If G_Debug_Mode = 'Y' Then
3903: Pa_Debug.G_err_Stage := P_Timecard_Rec.Status;
3904: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 9022: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');

9018: When No_Data_Found Then
9019: -- Data corruption exists if this happens here.
9020: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9021: SqlErrM, 1, 1800);
9022: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9023: fnd_message.set_token('ERR', l_error_text);
9024: X_Status := SubStr(fnd_message.get,1,2000);
9025:
9026: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';

Line 9023: fnd_message.set_token('ERR', l_error_text);

9019: -- Data corruption exists if this happens here.
9020: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9021: SqlErrM, 1, 1800);
9022: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9023: fnd_message.set_token('ERR', l_error_text);
9024: X_Status := SubStr(fnd_message.get,1,2000);
9025:
9026: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';
9027: If G_Debug_Mode = 'Y' Then

Line 9024: X_Status := SubStr(fnd_message.get,1,2000);

9020: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9021: SqlErrM, 1, 1800);
9022: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9023: fnd_message.set_token('ERR', l_error_text);
9024: X_Status := SubStr(fnd_message.get,1,2000);
9025:
9026: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';
9027: If G_Debug_Mode = 'Y' Then
9028: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;