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 1472: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');

1468: Exception
1469:
1470: When HXC_RETRIEVAL_MAX_ERRORS Then
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

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

1469:
1470: When HXC_RETRIEVAL_MAX_ERRORS Then
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',

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

1477: (P_Process => 'Projects Retrieval Process',
1478: P_Status => 'ERRORS',
1479: P_Exception_Description => l_Error_Text);
1480:
1481: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1482: fnd_message.raise_error;
1483:
1484: When Others Then
1485:

Line 1482: fnd_message.raise_error;

1478: P_Status => 'ERRORS',
1479: P_Exception_Description => l_Error_Text);
1480:
1481: fnd_message.set_name('HXC','HXC_RET_MAX_ERRORS');
1482: fnd_message.raise_error;
1483:
1484: When Others Then
1485:
1486: If ( SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' or

Line 1507: -- Fnd_Message.Raise_Error;

1503: -- P_Exception_Description =>
1504: -- substr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage ||
1505: -- ' : ' || SQLERRM, 1, 2000));
1506: --
1507: -- Fnd_Message.Raise_Error;
1508: --
1509: -- End If;
1510:
1511: If SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' Then

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

1509: -- End If;
1510:
1511: If SQLERRM = 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS:' Then
1512:
1513: fnd_message.set_name('HXC','HXC_0012_GNRET_NO_TIMECARDS');
1514: Else
1515:
1516: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1517:

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

1512:
1513: fnd_message.set_name('HXC','HXC_0012_GNRET_NO_TIMECARDS');
1514: Else
1515:
1516: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1517:
1518: End If;
1519: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || fnd_message.get;
1520: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);

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

1515:
1516: fnd_message.set_name('HXC','HXC_0013_GNRET_NO_BLD_BLKS');
1517:
1518: End If;
1519: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' : ' || fnd_message.get;
1520: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
1521:
1522: -- End bug 3422899
1523:

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

2297: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := 'ERRORS';
2298:
2299: If TrxRecord.Transaction_Rejection_Code is not null Then
2300:
2301: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);
2302: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2303: Substr(Fnd_Message.Get,1,2000);
2304:
2305: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.

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

2299: If TrxRecord.Transaction_Rejection_Code is not null Then
2300:
2301: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);
2302: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2303: Substr(Fnd_Message.Get,1,2000);
2304:
2305: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.
2306: -- Else
2307: --

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

4098: l_Status_Code := 'HXC_RET_NO_TIMECARD_DATA_OLD';
4099:
4100: End If;
4101:
4102: fnd_message.set_name('HXC', l_Status_Code);
4103: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4104:
4105: Elsif P_Timecard_Rec.Project_id is null and
4106: P_Timecard_Rec.Task_id is null and

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

4099:
4100: End If;
4101:
4102: fnd_message.set_name('HXC', l_Status_Code);
4103: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4104:
4105: Elsif P_Timecard_Rec.Project_id is null and
4106: P_Timecard_Rec.Task_id is null and
4107: P_Timecard_Rec.Expenditure_Type is null and

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

4115:
4116: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
4117:
4118: End If;
4119: fnd_message.set_name('HXC',l_Status_Code);
4120: fnd_message.set_token('STAGE', '1');
4121: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4122:
4123: ElsIf P_Timecard_Rec.Quantity is null or

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

4116: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
4117:
4118: End If;
4119: fnd_message.set_name('HXC',l_Status_Code);
4120: fnd_message.set_token('STAGE', '1');
4121: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4122:
4123: ElsIf P_Timecard_Rec.Quantity is null or
4124: P_Timecard_Rec.Incurred_By_Person_Id is null or

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

4117:
4118: End If;
4119: fnd_message.set_name('HXC',l_Status_Code);
4120: fnd_message.set_token('STAGE', '1');
4121: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4122:
4123: ElsIf P_Timecard_Rec.Quantity is null or
4124: P_Timecard_Rec.Incurred_By_Person_Id is null or
4125: P_Timecard_Rec.Expenditure_Item_Date is null Then

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

4130:
4131: l_Status_Code := 'HXC_RET_NO_BLD_BLK_DATA_OLD';
4132:
4133: End If;
4134: fnd_message.set_name('HXC',l_Status_Code);
4135: fnd_message.set_token('STAGE', '1');
4136: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4137:
4138: ElsIf P_Timecard_Rec.Billable_flag is null or

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

4131: l_Status_Code := 'HXC_RET_NO_BLD_BLK_DATA_OLD';
4132:
4133: End If;
4134: fnd_message.set_name('HXC',l_Status_Code);
4135: fnd_message.set_token('STAGE', '1');
4136: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4137:
4138: ElsIf P_Timecard_Rec.Billable_flag is null or
4139: P_Timecard_Rec.Project_id is null or

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

4132:
4133: End If;
4134: fnd_message.set_name('HXC',l_Status_Code);
4135: fnd_message.set_token('STAGE', '1');
4136: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4137:
4138: ElsIf P_Timecard_Rec.Billable_flag is null or
4139: P_Timecard_Rec.Project_id is null or
4140: P_Timecard_Rec.Task_id is null or

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

4152:
4153: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
4154:
4155: End If;
4156: fnd_message.set_name('HXC',l_Status_Code);
4157: fnd_message.set_token('STAGE', '2');
4158: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4159:
4160: End If;

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

4153: l_Status_Code := 'HXC_RET_NO_ATT_DATA_OLD';
4154:
4155: End If;
4156: fnd_message.set_name('HXC',l_Status_Code);
4157: fnd_message.set_token('STAGE', '2');
4158: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4159:
4160: End If;
4161:

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

4154:
4155: End If;
4156: fnd_message.set_name('HXC',l_Status_Code);
4157: fnd_message.set_token('STAGE', '2');
4158: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4159:
4160: End If;
4161:
4162: G_Stage := 'Leaving PopulateProjRec(), strip procedure from trackpath.';

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

4168:
4169: Exception
4170: When Others Then
4171: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
4172: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
4173: fnd_message.set_token('ERR', l_Error_Text);
4174: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4175:
4176: If G_Debug_Mode = 'Y' Then

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

4169: Exception
4170: When Others Then
4171: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
4172: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
4173: fnd_message.set_token('ERR', l_Error_Text);
4174: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4175:
4176: If G_Debug_Mode = 'Y' Then
4177: Pa_Debug.G_err_Stage := P_Timecard_Rec.Status;

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

4170: When Others Then
4171: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage || ' -- ' || SqlErrM, 1, 1800);
4172: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
4173: fnd_message.set_token('ERR', l_Error_Text);
4174: P_Timecard_Rec.Status := SubStr(Fnd_Message.Get,1,2000);
4175:
4176: If G_Debug_Mode = 'Y' Then
4177: Pa_Debug.G_err_Stage := P_Timecard_Rec.Status;
4178: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

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

9933: When No_Data_Found Then
9934: -- Data corruption exists if this happens here.
9935: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9936: SqlErrM, 1, 1800);
9937: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9938: fnd_message.set_token('ERR', l_error_text);
9939: X_Status := SubStr(fnd_message.get,1,2000);
9940:
9941: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';

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

9934: -- Data corruption exists if this happens here.
9935: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9936: SqlErrM, 1, 1800);
9937: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9938: fnd_message.set_token('ERR', l_error_text);
9939: X_Status := SubStr(fnd_message.get,1,2000);
9940:
9941: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';
9942: If G_Debug_Mode = 'Y' Then

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

9935: l_error_text := SubStr('Pa_Otc_Api ::: ' || G_Path || ' : ' || G_Stage || ' -- ' ||
9936: SqlErrM, 1, 1800);
9937: fnd_message.set_name('HXC', 'HXC_RET_UNEXPECTED_ERROR');
9938: fnd_message.set_token('ERR', l_error_text);
9939: X_Status := SubStr(fnd_message.get,1,2000);
9940:
9941: G_Stage := 'Leaving GetOrigTrxRef() due to unhandled exception, strip procedure from trackpath';
9942: If G_Debug_Mode = 'Y' Then
9943: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;