DBA Data[Home] [Help]

APPS.BSC_COLOR_RANGE_PVT dependencies on BSC_COLOR_RANGE_PVT

Line 1: PACKAGE BODY BSC_COLOR_RANGE_PVT AS

1: PACKAGE BODY BSC_COLOR_RANGE_PVT AS
2: /* $Header: BSCVCRNB.pls 120.2.12000000.1 2007/07/17 07:44:39 appldev noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 25: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_RANGE_PVT';

21: | 26-JUN-2007 ankgoel Bug#6132361 - Handled PL objectives |
22: +======================================================================================+
23: */
24:
25: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_RANGE_PVT';
26:
27:
28: /************************************************************************************
29: ************************************************************************************/

Line 122: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Props';

118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: WHEN NO_DATA_FOUND THEN
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_COLOR_RANGE_PVT.Create_Color_Props';
123: ELSE
124: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';
125: END IF;
126: WHEN OTHERS THEN

Line 124: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';

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_COLOR_RANGE_PVT.Create_Color_Props';
123: ELSE
124: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';
125: END IF;
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: IF (x_msg_data IS NOT NULL) THEN

Line 129: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Props';

125: END IF;
126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: IF (x_msg_data IS NOT NULL) THEN
129: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Props';
130: ELSE
131: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';
132: END IF;
133: END Create_Color_Props;

Line 131: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';

127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: IF (x_msg_data IS NOT NULL) THEN
129: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Props';
130: ELSE
131: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Props';
132: END IF;
133: END Create_Color_Props;
134:
135: /************************************************************************************

Line 193: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';

189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: WHEN NO_DATA_FOUND THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: IF (x_msg_data IS NOT NULL) THEN
193: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';
194: ELSE
195: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';
196: END IF;
197: WHEN OTHERS THEN

Line 195: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';

191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: IF (x_msg_data IS NOT NULL) THEN
193: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';
194: ELSE
195: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';
196: END IF;
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF (x_msg_data IS NOT NULL) THEN

Line 200: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';

196: END IF;
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF (x_msg_data IS NOT NULL) THEN
200: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';
201: ELSE
202: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';
203: END IF;
204: END Create_Color_Range;

Line 202: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';

198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: IF (x_msg_data IS NOT NULL) THEN
200: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGE_PVT.Create_Color_Range';
201: ELSE
202: x_msg_data := SQLERRM||' at BSC_COLOR_RANGE_PVT.Create_Color_Range';
203: END IF;
204: END Create_Color_Range;
205: /************************************************************************************
206: ************************************************************************************/

Line 291: END BSC_COLOR_RANGE_PVT;

287: );
288: END IF;
289: END Delete_Color_Prop_Ranges;
290:
291: END BSC_COLOR_RANGE_PVT;