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.BSC_PERIODICITY_PVT dependencies on BSC_PERIODICITY_PVT

Line 1: PACKAGE BODY BSC_PERIODICITY_PVT AS

1: PACKAGE BODY BSC_PERIODICITY_PVT AS
2: /* $Header: BSCVPITB.pls 120.0 2005/07/21 23:35:41 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITY_PVT';

14: REM | 07-JUN-2005 Krishna Created. |
15: REM +=======================================================================+
16: */
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITY_PVT';
19:
20:
21: PROCEDURE Create_Periods
22: ( p_Api_Version IN NUMBER

Line 116: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';

112: WHEN NO_DATA_FOUND THEN
113: ROLLBACK TO CreatePeriodsPVTSP;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
116: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
117: ELSE
118: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';
119: END IF;
120: WHEN OTHERS THEN

Line 118: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';

114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
116: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
117: ELSE
118: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';
119: END IF;
120: WHEN OTHERS THEN
121: ROLLBACK TO CreatePeriodsPVTSP;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 124: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';

120: WHEN OTHERS THEN
121: ROLLBACK TO CreatePeriodsPVTSP;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF (x_msg_data IS NOT NULL) THEN
124: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
125: ELSE
126: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';
127: END IF;
128: END Create_Periods;

Line 126: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';

122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF (x_msg_data IS NOT NULL) THEN
124: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
125: ELSE
126: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';
127: END IF;
128: END Create_Periods;
129:
130: /****************************************************************************************/

Line 146: BSC_PERIODICITY_PVT.Delete_Periods

142: SAVEPOINT UpdatePeriodsPVTSP;
143: FND_MSG_PUB.Initialize;
144: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
145:
146: BSC_PERIODICITY_PVT.Delete_Periods
147: ( p_Api_Version => p_Api_Version
148: , p_Commit => p_Commit
149: , p_Period_Record => p_Period_Record
150: , x_Return_Status => x_Return_Status

Line 158: BSC_PERIODICITY_PVT.Create_Periods

154: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: BSC_PERIODICITY_PVT.Create_Periods
159: ( p_Api_Version => p_Api_Version
160: , p_Commit => p_Commit
161: , p_Period_Record => p_Period_Record
162: , x_Return_Status => x_Return_Status

Line 179: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';

175: WHEN NO_DATA_FOUND THEN
176: ROLLBACK TO UpdatePeriodsPVTSP;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';
182: END IF;
183: WHEN OTHERS THEN

Line 181: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';
182: END IF;
183: WHEN OTHERS THEN
184: ROLLBACK TO UpdatePeriodsPVTSP;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 187: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';

183: WHEN OTHERS THEN
184: ROLLBACK TO UpdatePeriodsPVTSP;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF (x_msg_data IS NOT NULL) THEN
187: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
188: ELSE
189: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';
190: END IF;
191: END Update_Periods;

Line 189: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF (x_msg_data IS NOT NULL) THEN
187: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
188: ELSE
189: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';
190: END IF;
191: END Update_Periods;
192:
193: /**********************************************************************************/

Line 224: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';

220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO DeletePeriodsPVTSP;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';
227: END IF;
228: WHEN OTHERS THEN

Line 226: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';

222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';
227: END IF;
228: WHEN OTHERS THEN
229: ROLLBACK TO DeletePeriodsPVTSP;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 232: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';

228: WHEN OTHERS THEN
229: ROLLBACK TO DeletePeriodsPVTSP;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: IF (x_msg_data IS NOT NULL) THEN
232: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';
235: END IF;
236: END Delete_Periods;

Line 234: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';

230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: IF (x_msg_data IS NOT NULL) THEN
232: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';
235: END IF;
236: END Delete_Periods;
237: /**********************************************************************************/
238:

Line 240: END BSC_PERIODICITY_PVT;

236: END Delete_Periods;
237: /**********************************************************************************/
238:
239:
240: END BSC_PERIODICITY_PVT;