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_PERIODICITIES_PVT dependencies on BSC_PERIODICITIES_PVT

Line 1: PACKAGE BODY BSC_PERIODICITIES_PVT AS

1: PACKAGE BODY BSC_PERIODICITIES_PVT AS
2: /* $Header: BSCVPERB.pls 120.4 2005/11/30 02:48:25 kyadamak noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_PVT';

16: REM | 19-SEP-2005 ashankar Fixed Bug#4612590 in Update_Periodicity() |
17: REM +=======================================================================+
18: */
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_PVT';
21:
22: /*
23: Procedure Name
24: Parameters

Line 150: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';

146: WHEN NO_DATA_FOUND THEN
147: ROLLBACK TO CreatePeriodicityPVT;
148: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF (x_msg_data IS NOT NULL) THEN
150: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';
151: ELSE
152: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';
153: END IF;
154: WHEN OTHERS THEN

Line 152: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';

148: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF (x_msg_data IS NOT NULL) THEN
150: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';
151: ELSE
152: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';
153: END IF;
154: WHEN OTHERS THEN
155: ROLLBACK TO CreatePeriodicityPVT;
156: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 158: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';

154: WHEN OTHERS THEN
155: ROLLBACK TO CreatePeriodicityPVT;
156: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
157: IF (x_msg_data IS NOT NULL) THEN
158: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';
159: ELSE
160: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';
161: END IF;
162:

Line 160: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';

156: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
157: IF (x_msg_data IS NOT NULL) THEN
158: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Create_Periodicity ';
159: ELSE
160: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Create_Periodicity ';
161: END IF;
162:
163: END Create_Periodicity;
164:

Line 260: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';

256: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
257: WHEN NO_DATA_FOUND THEN
258: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
259: IF (x_msg_data IS NOT NULL) THEN
260: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
261: ELSE
262: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
263: END IF;
264: WHEN OTHERS THEN

Line 262: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';

258: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
259: IF (x_msg_data IS NOT NULL) THEN
260: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
261: ELSE
262: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
263: END IF;
264: WHEN OTHERS THEN
265: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
266: IF (x_msg_data IS NOT NULL) THEN

Line 267: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';

263: END IF;
264: WHEN OTHERS THEN
265: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
266: IF (x_msg_data IS NOT NULL) THEN
267: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
268: ELSE
269: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
270: END IF;
271: END Retrieve_Periodicity;

Line 269: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';

265: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
266: IF (x_msg_data IS NOT NULL) THEN
267: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
268: ELSE
269: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Retrieve_Periodicity ';
270: END IF;
271: END Retrieve_Periodicity;
272:
273: -- Private Update Periodicity API

Line 294: BSC_PERIODICITIES_PVT.Retrieve_Periodicity (

290: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
291:
292: x_Structural_Flag := FND_API.G_FALSE;
293:
294: BSC_PERIODICITIES_PVT.Retrieve_Periodicity (
295: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
296: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
297: ,x_Periodicities_Rec_Type => l_Periodicities_Rec_Type
298: ,x_Return_Status => x_Return_Status

Line 405: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';

401: WHEN NO_DATA_FOUND THEN
402: ROLLBACK TO UpdatePeriodicityPVT;
403: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF (x_msg_data IS NOT NULL) THEN
405: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';
406: ELSE
407: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';
408: END IF;
409: WHEN OTHERS THEN

Line 407: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';

403: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF (x_msg_data IS NOT NULL) THEN
405: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';
406: ELSE
407: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';
408: END IF;
409: WHEN OTHERS THEN
410: ROLLBACK TO UpdatePeriodicityPVT;
411: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 413: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';

409: WHEN OTHERS THEN
410: ROLLBACK TO UpdatePeriodicityPVT;
411: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
412: IF (x_msg_data IS NOT NULL) THEN
413: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';
414: ELSE
415: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';
416: END IF;
417: END Update_Periodicity;

Line 415: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';

411: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
412: IF (x_msg_data IS NOT NULL) THEN
413: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Update_Periodicity ';
414: ELSE
415: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Update_Periodicity ';
416: END IF;
417: END Update_Periodicity;
418:
419: PROCEDURE Incr_Refresh_Objectives(

Line 469: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';

465: WHEN NO_DATA_FOUND THEN
466: ROLLBACK TO IncrRefreshPerPVT;
467: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF (x_msg_data IS NOT NULL) THEN
469: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
470: ELSE
471: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
472: END IF;
473: WHEN OTHERS THEN

Line 471: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';

467: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF (x_msg_data IS NOT NULL) THEN
469: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
470: ELSE
471: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
472: END IF;
473: WHEN OTHERS THEN
474: ROLLBACK TO IncrRefreshPerPVT;
475: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 477: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';

473: WHEN OTHERS THEN
474: ROLLBACK TO IncrRefreshPerPVT;
475: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF (x_msg_data IS NOT NULL) THEN
477: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
478: ELSE
479: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
480: END IF;
481: END Incr_Refresh_Objectives;

Line 479: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';

475: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF (x_msg_data IS NOT NULL) THEN
477: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
478: ELSE
479: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives ';
480: END IF;
481: END Incr_Refresh_Objectives;
482:
483:

Line 539: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';

535: WHEN NO_DATA_FOUND THEN
536: ROLLBACK TO DeletePeriodicityPVT;
537: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF (x_msg_data IS NOT NULL) THEN
539: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';
540: ELSE
541: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';
542: END IF;
543: WHEN OTHERS THEN

Line 541: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';

537: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF (x_msg_data IS NOT NULL) THEN
539: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';
540: ELSE
541: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';
542: END IF;
543: WHEN OTHERS THEN
544: ROLLBACK TO DeletePeriodicityPVT;
545: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 547: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';

543: WHEN OTHERS THEN
544: ROLLBACK TO DeletePeriodicityPVT;
545: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
546: IF (x_msg_data IS NOT NULL) THEN
547: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';
548: ELSE
549: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';
550: END IF;
551: END Delete_Periodicity;

Line 549: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';

545: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
546: IF (x_msg_data IS NOT NULL) THEN
547: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PVT.Delete_Periodicity ';
548: ELSE
549: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PVT.Delete_Periodicity ';
550: END IF;
551: END Delete_Periodicity;
552:
553:

Line 554: END BSC_PERIODICITIES_PVT;

550: END IF;
551: END Delete_Periodicity;
552:
553:
554: END BSC_PERIODICITIES_PVT;