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_WRAPPER dependencies on BSC_PERIODICITIES_WRAPPER

Line 1: PACKAGE BODY BSC_PERIODICITIES_WRAPPER AS

1: PACKAGE BODY BSC_PERIODICITIES_WRAPPER AS
2: /* $Header: BSCWPERB.pls 120.5 2006/04/18 22:34:58 ashankar noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_WRAPPER';

18: REM | 21-MAR-2006 ashankar Fixed bug#5099465 Modified Validate_Periodicity |
19: REM +=======================================================================+
20: */
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_WRAPPER';
23:
24: PROCEDURE Create_Periodicity (
25: p_Commit IN VARCHAR2
26: ,p_Periodicity_Id IN VARCHAR2

Line 114: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

110: WHEN NO_DATA_FOUND THEN
111: ROLLBACK TO CreatePeriodicityWRP;
112: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
115: ELSE
116: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
117: END IF;
118: WHEN OTHERS THEN

Line 116: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

112: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
115: ELSE
116: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
117: END IF;
118: WHEN OTHERS THEN
119: ROLLBACK TO CreatePeriodicityWRP;
120: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 122: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

118: WHEN OTHERS THEN
119: ROLLBACK TO CreatePeriodicityWRP;
120: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
121: IF (x_msg_data IS NOT NULL) THEN
122: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
123: ELSE
124: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
125: END IF;
126: END Create_Periodicity;

Line 124: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

120: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
121: IF (x_msg_data IS NOT NULL) THEN
122: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
123: ELSE
124: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
125: END IF;
126: END Create_Periodicity;
127:
128:

Line 222: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

218: WHEN NO_DATA_FOUND THEN
219: ROLLBACK TO UpdatePeriodicityWRP;
220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF (x_msg_data IS NOT NULL) THEN
222: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
223: ELSE
224: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
225: END IF;
226: WHEN OTHERS THEN

Line 224: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF (x_msg_data IS NOT NULL) THEN
222: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
223: ELSE
224: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
225: END IF;
226: WHEN OTHERS THEN
227: ROLLBACK TO UpdatePeriodicityWRP;
228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

226: WHEN OTHERS THEN
227: ROLLBACK TO UpdatePeriodicityWRP;
228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
231: ELSE
232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
233: END IF;
234: END Update_Periodicity;

Line 232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
231: ELSE
232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
233: END IF;
234: END Update_Periodicity;
235:
236:

Line 320: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

316: WHEN NO_DATA_FOUND THEN
317: ROLLBACK TO DeletePeriodicityWRP;
318: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF (x_msg_data IS NOT NULL) THEN
320: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
321: ELSE
322: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
323: END IF;
324: WHEN OTHERS THEN

Line 322: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

318: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF (x_msg_data IS NOT NULL) THEN
320: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
321: ELSE
322: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
323: END IF;
324: WHEN OTHERS THEN
325: ROLLBACK TO DeletePeriodicityWRP;
326: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 328: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

324: WHEN OTHERS THEN
325: ROLLBACK TO DeletePeriodicityWRP;
326: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
327: IF (x_msg_data IS NOT NULL) THEN
328: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
331: END IF;
332: END Delete_Periodicity;

Line 330: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

326: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
327: IF (x_msg_data IS NOT NULL) THEN
328: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
331: END IF;
332: END Delete_Periodicity;
333:
334: PROCEDURE Validate_Periodicity (

Line 394: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

390: WHEN NO_DATA_FOUND THEN
391: ROLLBACK TO ValidatePeriodicityWRP;
392: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF (x_msg_data IS NOT NULL) THEN
394: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
395: ELSE
396: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
397: END IF;
398: WHEN OTHERS THEN

Line 396: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

392: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF (x_msg_data IS NOT NULL) THEN
394: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
395: ELSE
396: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
397: END IF;
398: WHEN OTHERS THEN
399: ROLLBACK TO ValidatePeriodicityWRP;
400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 402: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

398: WHEN OTHERS THEN
399: ROLLBACK TO ValidatePeriodicityWRP;
400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
401: IF (x_msg_data IS NOT NULL) THEN
402: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
403: ELSE
404: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
405: END IF;
406: END Validate_Periodicity;

Line 404: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
401: IF (x_msg_data IS NOT NULL) THEN
402: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
403: ELSE
404: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
405: END IF;
406: END Validate_Periodicity;
407:
408: PROCEDURE Create_Periodicity (

Line 426: BSC_PERIODICITIES_WRAPPER.Create_Periodicity

422: ,x_Msg_Count OUT NOCOPY NUMBER
423: ,x_Msg_Data OUT NOCOPY VARCHAR2
424: ) IS
425: BEGIN
426: BSC_PERIODICITIES_WRAPPER.Create_Periodicity
427: (
428: p_Commit => p_Commit
429: ,p_Periodicity_Id => p_Periodicity_Id
430: ,p_Periodicity_Name => p_Periodicity_Name

Line 467: BSC_PERIODICITIES_WRAPPER.Update_Periodicity (

463: ,x_Msg_Data OUT NOCOPY VARCHAR2
464: ) IS
465: BEGIN
466:
467: BSC_PERIODICITIES_WRAPPER.Update_Periodicity (
468: p_Commit => p_Commit
469: ,p_Periodicity_id => p_Periodicity_id
470: ,p_Periodicity_Name => p_Periodicity_Name
471: ,p_Periodicity_Description => p_Periodicity_Description

Line 488: END BSC_PERIODICITIES_WRAPPER;

484: );
485:
486: END Update_Periodicity;
487:
488: END BSC_PERIODICITIES_WRAPPER;