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_COLOR_PUB dependencies on FND_API

Line 32: p_commit IN VARCHAR2 := FND_API.G_FALSE

28:
29: /************************************************************************************
30: ************************************************************************************/
31: PROCEDURE Create_Color(
32: p_commit IN VARCHAR2 := FND_API.G_FALSE
33: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_data OUT NOCOPY VARCHAR2

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: l_Count NUMBER;
40: BEGIN
41:
42: FND_MSG_PUB.Initialize;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: SAVEPOINT BscColorPub_CrtColor;
46:
47: BSC_COLOR_PVT.Create_Color(p_Bsc_Color_Rec => p_Bsc_Color_Rec

Line 52: IF(p_commit = FND_API.G_TRUE) THEN

48: ,x_return_status => x_return_status
49: ,x_msg_count => x_msg_count
50: ,x_msg_data => x_msg_data);
51:
52: IF(p_commit = FND_API.G_TRUE) THEN
53: COMMIT;
54: END IF;
55: EXCEPTION
56: WHEN FND_API.G_EXC_ERROR THEN

Line 56: WHEN FND_API.G_EXC_ERROR THEN

52: IF(p_commit = FND_API.G_TRUE) THEN
53: COMMIT;
54: END IF;
55: EXCEPTION
56: WHEN FND_API.G_EXC_ERROR THEN
57: IF (x_msg_data IS NULL) THEN
58: ROLLBACK TO BscColorPub_CrtColor;
59: FND_MSG_PUB.Count_And_Get
60: ( p_encoded => FND_API.G_FALSE

Line 60: ( p_encoded => FND_API.G_FALSE

56: WHEN FND_API.G_EXC_ERROR THEN
57: IF (x_msg_data IS NULL) THEN
58: ROLLBACK TO BscColorPub_CrtColor;
59: FND_MSG_PUB.Count_And_Get
60: ( p_encoded => FND_API.G_FALSE
61: , p_count => x_msg_count
62: , p_data => x_msg_data
63: );
64: END IF;

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61: , p_count => x_msg_count
62: , p_data => x_msg_data
63: );
64: END IF;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: IF (x_msg_data IS NULL) THEN
68: FND_MSG_PUB.Count_And_Get
69: ( p_encoded => FND_API.G_FALSE

Line 66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

62: , p_data => x_msg_data
63: );
64: END IF;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: IF (x_msg_data IS NULL) THEN
68: FND_MSG_PUB.Count_And_Get
69: ( p_encoded => FND_API.G_FALSE
70: , p_count => x_msg_count

Line 69: ( p_encoded => FND_API.G_FALSE

65: x_return_status := FND_API.G_RET_STS_ERROR;
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: IF (x_msg_data IS NULL) THEN
68: FND_MSG_PUB.Count_And_Get
69: ( p_encoded => FND_API.G_FALSE
70: , p_count => x_msg_count
71: , p_data => x_msg_data
72: );
73: END IF;

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: , p_count => x_msg_count
71: , p_data => x_msg_data
72: );
73: END IF;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: WHEN NO_DATA_FOUND THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: IF (x_msg_data IS NOT NULL) THEN
78: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: );
73: END IF;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: WHEN NO_DATA_FOUND THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: IF (x_msg_data IS NOT NULL) THEN
78: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
79: ELSE
80: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79: ELSE
80: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
81: END IF;
82: WHEN OTHERS THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: IF (x_msg_data IS NOT NULL) THEN
85: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
86: ELSE
87: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 95: p_commit IN VARCHAR2 := FND_API.G_FALSE

91:
92: /************************************************************************************
93: ************************************************************************************/
94: PROCEDURE Update_Color(
95: p_commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_Bsc_Color_Tbl IN COLOR_ARRAY
97: ,x_return_status OUT NOCOPY VARCHAR2
98: ,x_msg_count OUT NOCOPY NUMBER
99: ,x_msg_data OUT NOCOPY VARCHAR2

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119: prototype_flag = BSC_DESIGNER_PVT.C_PRODUCTION;
120:
121: BEGIN
122: FND_MSG_PUB.Initialize;
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: SAVEPOINT BscColorPvt_UpdColor;
126: -- Update by id or short_name
127: l_Weight_Reconfigured := FALSE;

Line 170: IF(p_commit = FND_API.G_TRUE) THEN

166: );
167: END LOOP;
168: END IF;
169:
170: IF(p_commit = FND_API.G_TRUE) THEN
171: COMMIT;
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: COMMIT;
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: ROLLBACK TO BscColorPvt_UpdColor;
177: raise;
178: END Update_Color;
179: /************************************************************************************

Line 183: p_commit IN VARCHAR2:= FND_API.G_FALSE

179: /************************************************************************************
180: ************************************************************************************/
181: -- Currently this API will not be used anywhere, need to see if we will provide it.
182: PROCEDURE Delete_Color(
183: p_commit IN VARCHAR2:= FND_API.G_FALSE
184: ,p_Bsc_Color_Id IN NUMBER
185: ,p_Bsc_Color_SN IN NUMBER
186: ,x_return_status OUT NOCOPY VARCHAR2
187: ,x_msg_count OUT NOCOPY NUMBER

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

188: ,x_msg_data OUT NOCOPY VARCHAR2
189: ) IS
190: BEGIN
191: FND_MSG_PUB.Initialize;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: SAVEPOINT BscColorPvt_DelColor;
195:
196: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN

Line 199: RAISE FND_API.G_EXC_ERROR;

195:
196: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
197: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
202: ,p_Bsc_Color_SN);
203: EXCEPTION

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
202: ,p_Bsc_Color_SN);
203: EXCEPTION
204: WHEN OTHERS THEN
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: ROLLBACK TO BscColorPvt_DelColor;
207: END Delete_Color;
208:
209: /************************************************************************************

Line 212: p_commit IN VARCHAR2:= FND_API.G_FALSE

208:
209: /************************************************************************************
210: ************************************************************************************/
211: PROCEDURE Update_Default_Color_Count(
212: p_commit IN VARCHAR2:= FND_API.G_FALSE
213: ,p_color_count IN NUMBER
214: ,x_return_status OUT NOCOPY VARCHAR2
215: ,x_msg_count OUT NOCOPY NUMBER
216: ,x_msg_data OUT NOCOPY VARCHAR2

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: ) IS
218: l_def_color_code VARCHAR2(15):= 'DEF_COLOR_COUNT';
219: BEGIN
220: FND_MSG_PUB.Initialize;
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: UPDATE bsc_sys_init
224: SET property_value = p_color_count
225: WHERE property_code = l_def_color_code;

Line 228: x_return_status := FND_API.G_RET_STS_ERROR;

224: SET property_value = p_color_count
225: WHERE property_code = l_def_color_code;
226: EXCEPTION
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: END;
230:
231: END BSC_COLOR_PUB;