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

Line 27: p_commit IN VARCHAR2:= FND_API.G_FALSE

23:
24: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_COLOR_PVT';
25:
26: PROCEDURE Retrieve_Color(
27: p_commit IN VARCHAR2:= FND_API.G_FALSE
28: ,p_Bsc_Color_Id IN NUMBER
29: ,p_Bsc_Color_SN IN VARCHAR2
30: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec
31: ,x_return_status OUT NOCOPY VARCHAR2

Line 39: p_commit IN VARCHAR2 := FND_API.G_FALSE

35:
36: /************************************************************************************
37: ************************************************************************************/
38: PROCEDURE Create_Color(
39: p_commit IN VARCHAR2 := FND_API.G_FALSE
40: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER
43: ,x_msg_data OUT NOCOPY VARCHAR2

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: l_forecast_color NUMBER;
48: BEGIN
49:
50: FND_MSG_PUB.Initialize;
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: SAVEPOINT BscColorPvt_CrtColor;
54:
55: IF(p_Bsc_Color_Rec.Color_id IS NOT NULL) THEN

Line 64: RAISE FND_API.G_EXC_ERROR;

60: IF (l_Count > 0) THEN
61: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_ID_EXISTS');
62: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
63: FND_MSG_PUB.ADD;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');
68: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);

Line 70: RAISE FND_API.G_EXC_ERROR;

66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');
68: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
69: FND_MSG_PUB.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');
74: FND_MESSAGE.SET_TOKEN('BSC_COLOR_SN', p_Bsc_Color_Rec.short_name);

Line 76: RAISE FND_API.G_EXC_ERROR;

72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');
74: FND_MESSAGE.SET_TOKEN('BSC_COLOR_SN', p_Bsc_Color_Rec.short_name);
75: FND_MSG_PUB.ADD;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78: BSC_COLOR_PKG.INSERT_ROW(p_Bsc_Color_Rec.color_id
79: ,p_Bsc_Color_Rec.Short_Name
80: ,p_Bsc_Color_Rec.name

Line 96: WHEN FND_API.G_EXC_ERROR THEN

92: ,p_Bsc_Color_Rec.Last_Updated_By
93: ,p_Bsc_Color_Rec.Last_Update_Login
94: );
95: EXCEPTION
96: WHEN FND_API.G_EXC_ERROR THEN
97: IF (x_msg_data IS NULL) THEN
98: ROLLBACK TO BscColorPvt_CrtColor;
99: FND_MSG_PUB.Count_And_Get
100: ( p_encoded => FND_API.G_FALSE

Line 100: ( p_encoded => FND_API.G_FALSE

96: WHEN FND_API.G_EXC_ERROR THEN
97: IF (x_msg_data IS NULL) THEN
98: ROLLBACK TO BscColorPvt_CrtColor;
99: FND_MSG_PUB.Count_And_Get
100: ( p_encoded => FND_API.G_FALSE
101: , p_count => x_msg_count
102: , p_data => x_msg_data
103: );
104: END IF;

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: , p_count => x_msg_count
102: , p_data => x_msg_data
103: );
104: END IF;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: IF (x_msg_data IS NULL) THEN
108: FND_MSG_PUB.Count_And_Get
109: ( p_encoded => FND_API.G_FALSE

Line 106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 109: ( p_encoded => FND_API.G_FALSE

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

Line 114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

110: , p_count => x_msg_count
111: , p_data => x_msg_data
112: );
113: END IF;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: WHEN NO_DATA_FOUND THEN
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: IF (x_msg_data IS NOT NULL) THEN
118: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: );
113: END IF;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: WHEN NO_DATA_FOUND THEN
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: IF (x_msg_data IS NOT NULL) THEN
118: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
119: ELSE
120: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: ELSE
120: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
121: END IF;
122: WHEN OTHERS THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF (x_msg_data IS NOT NULL) THEN
125: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';
126: ELSE
127: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color with parameter x_Bsc_Kpi_Entity_Rec ';

Line 135: p_commit IN VARCHAR2 := FND_API.G_FALSE

131: /************************************************************************************
132: ************************************************************************************/
133: -- API To be called from UI.
134: PROCEDURE Update_Color(
135: p_commit IN VARCHAR2 := FND_API.G_FALSE
136: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144: l_user_id NUMBER;
145: l_login_id NUMBER;
146: BEGIN
147: FND_MSG_PUB.Initialize;
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: SAVEPOINT BscColorPvt_UpdColor;
151: /*BSC_COLOR_PKG.UPDATE_ROW(p_Bsc_Color_Rec.color_id
152: ,p_Bsc_Color_Rec.Perf_Sequence

Line 167: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

163: ,x_Bsc_Color_Rec => l_Bsc_Color_Rec
164: ,x_return_status => x_return_status
165: ,x_msg_count => x_msg_count
166: ,x_msg_data => x_msg_data);
167: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: /*IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN

Line 168: RAISE FND_API.G_EXC_ERROR;

164: ,x_return_status => x_return_status
165: ,x_msg_count => x_msg_count
166: ,x_msg_data => x_msg_data);
167: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: /*IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN
172: l_Bsc_Color_Rec.name := p_Bsc_Color_Rec.name;

Line 223: p_commit IN VARCHAR2:= FND_API.G_FALSE

219: END Update_Color;
220: /************************************************************************************
221: ************************************************************************************/
222: PROCEDURE Delete_Color(
223: p_commit IN VARCHAR2:= FND_API.G_FALSE
224: ,p_Bsc_Color_Id IN NUMBER
225: ,p_Bsc_Color_SN IN NUMBER
226: ,x_return_status OUT NOCOPY VARCHAR2
227: ,x_msg_count OUT NOCOPY NUMBER

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: ,x_msg_data OUT NOCOPY VARCHAR2
229: ) IS
230: BEGIN
231: FND_MSG_PUB.Initialize;
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: SAVEPOINT BscColorPvt_DelColor;
235:
236: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN

Line 239: RAISE FND_API.G_EXC_ERROR;

235:
236: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
237: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
242: ,p_Bsc_Color_SN);
243: EXCEPTION

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
242: ,p_Bsc_Color_SN);
243: EXCEPTION
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: ROLLBACK TO BscColorPvt_DelColor;
247: END Delete_Color;
248:
249: /************************************************************************************

Line 252: p_commit IN VARCHAR2:= FND_API.G_FALSE

248:
249: /************************************************************************************
250: ************************************************************************************/
251: PROCEDURE Translate_Color(
252: p_commit IN VARCHAR2:= FND_API.G_FALSE
253: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2

Line 270: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

266: ,x_Bsc_Color_Rec => l_Bsc_Color_Rec
267: ,x_return_status => x_return_status
268: ,x_msg_count => x_msg_count
269: ,x_msg_data => x_msg_data);
270: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN

Line 271: RAISE FND_API.G_EXC_ERROR;

267: ,x_return_status => x_return_status
268: ,x_msg_count => x_msg_count
269: ,x_msg_data => x_msg_data);
270: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN
275: l_Bsc_Color_Rec.name := p_Bsc_Color_Rec.name;

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: ,p_Last_Updated_By => l_Bsc_Color_Rec.Last_Updated_By
322: ,p_Last_Update_Login => l_Bsc_Color_Rec.last_update_login);
323: EXCEPTION
324: WHEN OTHERS THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: ROLLBACK TO BscColorPvt_TrnsColor;
327: END Translate_Color;
328: /************************************************************************************
329: ************************************************************************************/

Line 331: p_commit IN VARCHAR2:= FND_API.G_FALSE

327: END Translate_Color;
328: /************************************************************************************
329: ************************************************************************************/
330: PROCEDURE Load_Translated_Color(
331: p_commit IN VARCHAR2:= FND_API.G_FALSE
332: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
333: ,x_return_status OUT NOCOPY VARCHAR2
334: ,x_msg_count OUT NOCOPY NUMBER
335: ,x_msg_data OUT NOCOPY VARCHAR2

Line 342: x_return_status := FND_API.G_RET_STS_SUCCESS;

338: l_user_id NUMBER;
339: l_login_id NUMBER;
340: BEGIN
341: FND_MSG_PUB.Initialize;
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: SAVEPOINT BscColorPvt_LdTrnsColor;
345:
346: Retrieve_Color(p_Bsc_Color_Id => p_Bsc_Color_Rec.color_id

Line 352: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

348: ,x_Bsc_Color_Rec => l_Bsc_Color_Rec
349: ,x_return_status => x_return_status
350: ,x_msg_count => x_msg_count
351: ,x_msg_data => x_msg_data);
352: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN

Line 353: RAISE FND_API.G_EXC_ERROR;

349: ,x_return_status => x_return_status
350: ,x_msg_count => x_msg_count
351: ,x_msg_data => x_msg_data);
352: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: IF(p_Bsc_Color_Rec.name IS NOT NULL) THEN
357: l_Bsc_Color_Rec.name := p_Bsc_Color_Rec.name;

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400: WHERE color_id= l_Bsc_Color_Rec.color_id;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: ROLLBACK TO BscColorPvt_LdTrnsColor;
406: END Load_Translated_Color;
407:
408: /************************************************************************************

Line 411: p_commit IN VARCHAR2:= FND_API.G_FALSE

407:
408: /************************************************************************************
409: ************************************************************************************/
410: PROCEDURE Retrieve_Color(
411: p_commit IN VARCHAR2:= FND_API.G_FALSE
412: ,p_Bsc_Color_Id IN NUMBER
413: ,p_Bsc_Color_SN IN VARCHAR2
414: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec
415: ,x_return_status OUT NOCOPY VARCHAR2

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: FROM bsc_sys_colors_vl
429: WHERE short_name = p_Bsc_Color_SN;
430: BEGIN
431: FND_MSG_PUB.Initialize;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: SAVEPOINT BscColorPvt_RetColor;
435:
436: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN

Line 439: RAISE FND_API.G_EXC_ERROR;

435:
436: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
437: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: IF(p_Bsc_Color_Id IS NOT NULL) THEN
443: OPEN c_sys_colors_id;

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: ,x_Bsc_Color_Rec.user_numeric_equivalent
457: ,x_Bsc_Color_Rec.last_update_date;
458:
459: IF c_sys_colors_id%ROWCOUNT = 0 THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: END IF;
462: CLOSE c_sys_colors_id;
463: ELSE
464: OPEN c_sys_colors_sn;

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: ,x_Bsc_Color_Rec.user_numeric_equivalent
478: ,x_Bsc_Color_Rec.last_update_date;
479:
480: IF c_sys_colors_sn%ROWCOUNT = 0 THEN
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: END IF;
483: CLOSE c_sys_colors_sn;
484: END IF;
485: EXCEPTION

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483: CLOSE c_sys_colors_sn;
484: END IF;
485: EXCEPTION
486: WHEN OTHERS THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: ROLLBACK TO BscColorPvt_RetColor;
489: END Retrieve_Color;
490:
491: /************************************************************************************

Line 494: p_commit IN VARCHAR2:= FND_API.G_FALSE

490:
491: /************************************************************************************
492: ************************************************************************************/
493: PROCEDURE Load_Color(
494: p_commit IN VARCHAR2:= FND_API.G_FALSE
495: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
496: ,x_return_status OUT NOCOPY VARCHAR2
497: ,x_msg_count OUT NOCOPY NUMBER
498: ,x_msg_data OUT NOCOPY VARCHAR2

Line 506: x_return_status := FND_API.G_RET_STS_SUCCESS;

502: l_login_id NUMBER;
503: l_count NUMBER;
504: BEGIN
505: FND_MSG_PUB.Initialize;
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: SAVEPOINT BscColorPvt_LoadColor;
509:
510: SELECT COUNT(1)

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

517: ,x_return_status => x_return_status
518: ,x_msg_count => x_msg_count
519: ,x_msg_data => x_msg_data);
520:
521: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: ELSE
525:

Line 522: RAISE FND_API.G_EXC_ERROR;

518: ,x_msg_count => x_msg_count
519: ,x_msg_data => x_msg_data);
520:
521: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: ELSE
525:
526: l_Bsc_Color_Rec := p_Bsc_Color_Rec;

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

539: ,x_return_status => x_return_status
540: ,x_msg_count => x_msg_count
541: ,x_msg_data => x_msg_data);
542:
543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: END IF;
547:

Line 544: RAISE FND_API.G_EXC_ERROR;

540: ,x_msg_count => x_msg_count
541: ,x_msg_data => x_msg_data);
542:
543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: END IF;
547:
548:

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547:
548:
549: EXCEPTION
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: ROLLBACK TO BscColorPvt_LoadColor;
553: END Load_Color;
554:
555: END BSC_COLOR_PVT;