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_CUSTOM_VIEW_PUB dependencies on BSC_CUSTOM_VIEW_PUB

Line 1: PACKAGE BODY BSC_CUSTOM_VIEW_PUB AS

1: PACKAGE BODY BSC_CUSTOM_VIEW_PUB AS
2: /* $Header: BSCCVDBB.pls 120.1 2005/08/22 17:07:48 hengliu noship $ */
3: /*****************************************************************************
4: This procedure will delete the custom view from the tab.
5: The entry will be deleted from the following tables.

Line 26: l_CustView_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_time_stamp IN VARCHAR2 := NULL
24: ) IS
25:
26: l_CustView_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
27: l_dep_obj_list VARCHAR2(1000);
28: l_exist_dependency VARCHAR2(5);
29:
30: BEGIN

Line 32: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_CUSTOM_VIEW_PUB.delete_Custom_View procedure');

28: l_exist_dependency VARCHAR2(5);
29:
30: BEGIN
31:
32: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_CUSTOM_VIEW_PUB.delete_Custom_View procedure');
33: FND_MSG_PUB.Initialize;
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35: l_exist_dependency := FND_API.G_FALSE;
36:

Line 135: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

131:
132: WHEN NO_DATA_FOUND THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (x_msg_data IS NOT NULL) THEN
135: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
136: ELSE
137: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
138: END IF;
139: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 137: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF (x_msg_data IS NOT NULL) THEN
135: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
136: ELSE
137: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
138: END IF;
139: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
140:
141: WHEN OTHERS THEN

Line 144: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

140:
141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (x_msg_data IS NOT NULL) THEN
144: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
145: ELSE
146: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
147: END IF;
148: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 146: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (x_msg_data IS NOT NULL) THEN
144: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
145: ELSE
146: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
147: END IF;
148: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
149:
150: END delete_Custom_View;

Line 193: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views Failed: at BSC_BIS_LOCKS_PUB.LOCK_TAB');

189: ,x_msg_data => x_msg_data
190:
191: );
192: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
193: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views Failed: at BSC_BIS_LOCKS_PUB.LOCK_TAB');
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: END IF;
196:
197: BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views

Line 209: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views <'||x_msg_data||'>');

205: ,x_msg_data => x_msg_data
206: );
207:
208: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
209: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views <'||x_msg_data||'>');
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: EXCEPTION

Line 240: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';

236:
237: WHEN NO_DATA_FOUND THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF (x_msg_data IS NOT NULL) THEN
240: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
241: ELSE
242: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
243: END IF;
244: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 242: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';

238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF (x_msg_data IS NOT NULL) THEN
240: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
241: ELSE
242: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
243: END IF;
244: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
245:
246: WHEN OTHERS THEN

Line 249: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';

245:
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF (x_msg_data IS NOT NULL) THEN
249: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
250: ELSE
251: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
252: END IF;
253: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 251: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';

247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF (x_msg_data IS NOT NULL) THEN
249: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
250: ELSE
251: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Unassign_Views ';
252: END IF;
253: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
254: END Assign_Unassign_Views;
255:

Line 296: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views <'||x_msg_data||'>');

292: ,x_msg_data => x_msg_data
293: );
294:
295: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
296: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views <'||x_msg_data||'>');
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
299: END IF;
300:

Line 328: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

324:
325: WHEN NO_DATA_FOUND THEN
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_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
331: END IF;
332: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 330: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

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_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
331: END IF;
332: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
333:
334: WHEN OTHERS THEN

Line 337: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

333:
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF (x_msg_data IS NOT NULL) THEN
337: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
338: ELSE
339: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
340: END IF;
341: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 339: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF (x_msg_data IS NOT NULL) THEN
337: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
338: ELSE
339: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
340: END IF;
341: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
342: END Assign_Cust_Views;
343:

Line 386: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views <'||x_msg_data||'>');

382: ,x_msg_count => x_msg_count
383: ,x_msg_data => x_msg_data
384: );
385: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
386: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views <'||x_msg_data||'>');
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389: END IF;
390: EXCEPTION

Line 417: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

413:
414: WHEN NO_DATA_FOUND THEN
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF (x_msg_data IS NOT NULL) THEN
417: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
418: ELSE
419: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
420: END IF;
421: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 419: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF (x_msg_data IS NOT NULL) THEN
417: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
418: ELSE
419: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
420: END IF;
421: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
422:
423: WHEN OTHERS THEN

Line 426: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

422:
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: IF (x_msg_data IS NOT NULL) THEN
426: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
427: ELSE
428: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
429: END IF;
430: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 428: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';

424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: IF (x_msg_data IS NOT NULL) THEN
426: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
427: ELSE
428: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Assign_Cust_Views ';
429: END IF;
430: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
431: END Unassign_Cust_Views;
432:

Line 469: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links Failed: at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links <'||x_msg_data||'>');

465: , x_msg_count => x_msg_count
466: , x_msg_data => x_msg_data
467: );
468: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links Failed: at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links <'||x_msg_data||'>');
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: EXCEPTION

Line 500: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

496:
497: WHEN NO_DATA_FOUND THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF (x_msg_data IS NOT NULL) THEN
500: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
501: ELSE
502: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
503: END IF;
504: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 502: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF (x_msg_data IS NOT NULL) THEN
500: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
501: ELSE
502: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
503: END IF;
504: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
505:
506: WHEN OTHERS THEN

Line 509: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF (x_msg_data IS NOT NULL) THEN
509: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
510: ELSE
511: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
512: END IF;
513: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 511: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF (x_msg_data IS NOT NULL) THEN
509: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
510: ELSE
511: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';
512: END IF;
513: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
514: END Delete_Custom_View_Links;
515:

Line 516: END BSC_CUSTOM_VIEW_PUB;

512: END IF;
513: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
514: END Delete_Custom_View_Links;
515:
516: END BSC_CUSTOM_VIEW_PUB;