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

Line 31: p_commit IN VARCHAR2 := FND_API.G_FALSE

27:
28: /************************************************************************************
29: ************************************************************************************/
30: PROCEDURE Create_Color_Props (
31: p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_objective_id IN NUMBER
33: ,p_kpi_measure_id IN NUMBER
34: ,p_color_type IN VARCHAR2
35: ,p_color_range_id IN NUMBER

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: l_count NUMBER;
43: BEGIN
44:
45: FND_MSG_PUB.Initialize;
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: SAVEPOINT BscColorRangePvt_CrtColorRng;
49:
50: IF(p_objective_id IS NULL) THEN

Line 53: RAISE FND_API.G_EXC_ERROR;

49:
50: IF(p_objective_id IS NULL) THEN
51: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56: IF (p_kpi_measure_id IS NULL) THEN
57: SELECT COUNT(1)

Line 74: RAISE FND_API.G_EXC_ERROR;

70:
71: IF(l_count > 0 ) THEN
72: FND_MESSAGE.SET_NAME('BSC','BSC_RANGES_ALREADY_EXISTS');
73: FND_MSG_PUB.ADD;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76:
77: l_user_id := FND_GLOBAL.USER_ID;
78:

Line 100: WHEN FND_API.G_EXC_ERROR THEN

96: ,sysdate
97: ,l_user_id
98: ,l_user_id);
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: IF (x_msg_data IS NULL) THEN
102: ROLLBACK TO BscColorRangePvt_CrtColorRng;
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => FND_API.G_FALSE

Line 104: ( p_encoded => FND_API.G_FALSE

100: WHEN FND_API.G_EXC_ERROR THEN
101: IF (x_msg_data IS NULL) THEN
102: ROLLBACK TO BscColorRangePvt_CrtColorRng;
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => FND_API.G_FALSE
105: , p_count => x_msg_count
106: , p_data => x_msg_data
107: );
108: END IF;

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105: , p_count => x_msg_count
106: , p_data => x_msg_data
107: );
108: END IF;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: IF (x_msg_data IS NULL) THEN
112: FND_MSG_PUB.Count_And_Get
113: ( p_encoded => FND_API.G_FALSE

Line 110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

106: , p_data => x_msg_data
107: );
108: END IF;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: IF (x_msg_data IS NULL) THEN
112: FND_MSG_PUB.Count_And_Get
113: ( p_encoded => FND_API.G_FALSE
114: , p_count => x_msg_count

Line 113: ( p_encoded => FND_API.G_FALSE

109: x_return_status := FND_API.G_RET_STS_ERROR;
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: IF (x_msg_data IS NULL) THEN
112: FND_MSG_PUB.Count_And_Get
113: ( p_encoded => FND_API.G_FALSE
114: , p_count => x_msg_count
115: , p_data => x_msg_data
116: );
117: END IF;

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: , p_count => x_msg_count
115: , p_data => x_msg_data
116: );
117: END IF;
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';

Line 120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

116: );
117: END IF;
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';

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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';

Line 138: p_commit IN VARCHAR2 := FND_API.G_FALSE

134:
135: /************************************************************************************
136: ************************************************************************************/
137: PROCEDURE Create_Color_Range (
138: p_commit IN VARCHAR2 := FND_API.G_FALSE
139: ,p_range_id IN NUMBER
140: ,p_Bsc_Kpi_Color_Range_Rec IN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec
141: ,p_user_id IN FND_USER.user_id%TYPE
142: ,x_return_status OUT NOCOPY VARCHAR2

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: l_th_count NUMBER;
148: BEGIN
149:
150: FND_MSG_PUB.Initialize;
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: SAVEPOINT BscColorRangePvt_CrtColorRng;
154: l_bsc_kpi_color_range_rec := p_Bsc_Kpi_Color_Range_Rec;
155:

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: ,p_Bsc_Kpi_Color_Range_Rec(l_th_count).color_id);
168: END LOOP;
169: END IF;
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: IF (x_msg_data IS NULL) THEN
173: ROLLBACK TO BscColorRangePvt_CrtColorRng;
174: FND_MSG_PUB.Count_And_Get
175: ( p_encoded => FND_API.G_FALSE

Line 175: ( p_encoded => FND_API.G_FALSE

171: WHEN FND_API.G_EXC_ERROR THEN
172: IF (x_msg_data IS NULL) THEN
173: ROLLBACK TO BscColorRangePvt_CrtColorRng;
174: FND_MSG_PUB.Count_And_Get
175: ( p_encoded => FND_API.G_FALSE
176: , p_count => x_msg_count
177: , p_data => x_msg_data
178: );
179: END IF;

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: , p_count => x_msg_count
177: , p_data => x_msg_data
178: );
179: END IF;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: IF (x_msg_data IS NULL) THEN
183: FND_MSG_PUB.Count_And_Get
184: ( p_encoded => FND_API.G_FALSE

Line 181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

177: , p_data => x_msg_data
178: );
179: END IF;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: IF (x_msg_data IS NULL) THEN
183: FND_MSG_PUB.Count_And_Get
184: ( p_encoded => FND_API.G_FALSE
185: , p_count => x_msg_count

Line 184: ( p_encoded => FND_API.G_FALSE

180: x_return_status := FND_API.G_RET_STS_ERROR;
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: IF (x_msg_data IS NULL) THEN
183: FND_MSG_PUB.Count_And_Get
184: ( p_encoded => FND_API.G_FALSE
185: , p_count => x_msg_count
186: , p_data => x_msg_data
187: );
188: END IF;

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: , p_count => x_msg_count
186: , p_data => x_msg_data
187: );
188: END IF;
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';

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: );
188: END IF;
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';

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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';

Line 209: p_commit IN VARCHAR2 := FND_API.G_FALSE

205: /************************************************************************************
206: ************************************************************************************/
207:
208: PROCEDURE Delete_Color_Ranges (
209: p_commit IN VARCHAR2 := FND_API.G_FALSE
210: ,p_color_range_id IN NUMBER
211: ,x_return_status OUT NOCOPY VARCHAR2
212: ,x_msg_count OUT NOCOPY NUMBER
213: ,x_msg_data OUT NOCOPY VARCHAR2

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

214: ) IS
215: l_color_id NUMBER;
216: BEGIN
217: FND_MSG_PUB.Initialize;
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: SAVEPOINT BscCRangePvt_DelColorRng;
221: -- Update by id or short_name
222: IF(p_color_range_id IS NULL) THEN

Line 225: RAISE FND_API.G_EXC_ERROR;

221: -- Update by id or short_name
222: IF(p_color_range_id IS NULL) THEN
223: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: DELETE bsc_color_ranges
229: WHERE color_range_id = p_color_range_id;

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: ROLLBACK TO BscCRangePvt_DelColorRng;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (x_msg_data IS NULL) THEN
236: FND_MSG_PUB.Count_And_Get
237: ( p_encoded => FND_API.G_FALSE
238: ,p_count => x_msg_count

Line 237: ( p_encoded => FND_API.G_FALSE

233: ROLLBACK TO BscCRangePvt_DelColorRng;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (x_msg_data IS NULL) THEN
236: FND_MSG_PUB.Count_And_Get
237: ( p_encoded => FND_API.G_FALSE
238: ,p_count => x_msg_count
239: ,p_data => x_msg_data
240: );
241: END IF;

Line 248: p_commit IN VARCHAR2:= FND_API.G_FALSE

244:
245: /************************************************************************************
246: ************************************************************************************/
247: PROCEDURE Delete_Color_Prop_Ranges (
248: p_commit IN VARCHAR2:= FND_API.G_FALSE
249: ,p_color_range_id IN NUMBER
250: ,x_return_status OUT NOCOPY VARCHAR2
251: ,x_msg_count OUT NOCOPY NUMBER
252: ,x_msg_data OUT NOCOPY VARCHAR2

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: ,x_msg_data OUT NOCOPY VARCHAR2
253: ) IS
254: BEGIN
255: FND_MSG_PUB.Initialize;
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: SAVEPOINT BscCRangePvt_DelColorRngProp;
259:
260: IF(p_color_range_id IS NULL) THEN

Line 263: RAISE FND_API.G_EXC_ERROR;

259:
260: IF(p_color_range_id IS NULL) THEN
261: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: DELETE bsc_color_type_props
267: WHERE color_range_id = p_color_range_id;

Line 274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

270: ,x_return_status => x_return_status
271: ,x_msg_count => x_msg_count
272: ,x_msg_data => x_msg_data);
273:
274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: EXCEPTION

Line 275: RAISE FND_API.G_EXC_ERROR;

271: ,x_msg_count => x_msg_count
272: ,x_msg_data => x_msg_data);
273:
274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: EXCEPTION
279: WHEN OTHERS THEN

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: ROLLBACK TO BscCRangePvt_DelColorRngProp;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NULL) THEN
283: FND_MSG_PUB.Count_And_Get
284: ( p_encoded => FND_API.G_FALSE
285: ,p_count => x_msg_count

Line 284: ( p_encoded => FND_API.G_FALSE

280: ROLLBACK TO BscCRangePvt_DelColorRngProp;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NULL) THEN
283: FND_MSG_PUB.Count_And_Get
284: ( p_encoded => FND_API.G_FALSE
285: ,p_count => x_msg_count
286: ,p_data => x_msg_data
287: );
288: END IF;