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

Line 145: FND_MSG_PUB.Initialize;

141: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
142: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
143: l_tab_view_id NUMBER;
144: BEGIN
145: FND_MSG_PUB.Initialize;
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: IF (p_tab_id IS NOT NULL) THEN
149:

Line 156: FND_MSG_PUB.ADD;

152:
153: IF(l_count =0) THEN
154: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
155: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: ELSE
160: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');

Line 161: FND_MSG_PUB.ADD;

157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: ELSE
160: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165: IF(p_assign_views IS NOT NULL) THEN

Line 231: FND_MSG_PUB.Count_And_Get

227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: IF (x_msg_data IS NULL) THEN
231: FND_MSG_PUB.Count_And_Get
232: ( p_encoded => FND_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data
235: );

Line 243: FND_MSG_PUB.Count_And_Get

239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: IF (x_msg_data IS NULL) THEN
243: FND_MSG_PUB.Count_And_Get
244: ( p_encoded => FND_API.G_FALSE
245: , p_count => x_msg_count
246: , p_data => x_msg_data
247: );

Line 300: FND_MSG_PUB.Initialize;

296: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
297: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
298: l_tab_view_id NUMBER;
299: BEGIN
300: FND_MSG_PUB.Initialize;
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: IF (p_tab_id IS NOT NULL) THEN
304: -- Bug #3236356

Line 310: FND_MSG_PUB.ADD;

306:
307: IF(l_count =0) THEN
308: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
309: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: ELSE
314: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');

Line 315: FND_MSG_PUB.ADD;

311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: ELSE
314: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
315: FND_MSG_PUB.ADD;
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: IF(p_unassign_views IS NOT NULL) THEN

Line 421: FND_MSG_PUB.Count_And_Get

417:
418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: IF (x_msg_data IS NULL) THEN
421: FND_MSG_PUB.Count_And_Get
422: ( p_encoded => FND_API.G_FALSE
423: , p_count => x_msg_count
424: , p_data => x_msg_data
425: );

Line 433: FND_MSG_PUB.Count_And_Get

429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: IF (x_msg_data IS NULL) THEN
433: FND_MSG_PUB.Count_And_Get
434: ( p_encoded => FND_API.G_FALSE
435: , p_count => x_msg_count
436: , p_data => x_msg_data
437: );

Line 494: FND_MSG_PUB.Initialize;

490: l_count NUMBER;
491: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
492: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
493: BEGIN
494: FND_MSG_PUB.Initialize;
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: IF (p_tab_id IS NULL) THEN
498: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');

Line 500: FND_MSG_PUB.ADD;

496:
497: IF (p_tab_id IS NULL) THEN
498: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
499: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504: IF (p_default_value IS NULL) THEN

Line 507: FND_MSG_PUB.ADD;

503:
504: IF (p_default_value IS NULL) THEN
505: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DEFAULT_ID');
506: FND_MESSAGE.SET_TOKEN('BSC_DEF_ID', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DEFAULT_TAB_ID'), TRUE);
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: -- call the unassign first and then assign the views APIS.

Line 601: FND_MSG_PUB.ADD;

597: );
598:
599: IF(l_count=0) THEN
600: FND_MESSAGE.SET_NAME('BSC','BSC_NOTSET_DEFAULT_ID');
601: FND_MSG_PUB.ADD;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: l_Tab_Rec.Bsc_Tab_Id := p_tab_id;

Line 621: FND_MSG_PUB.Count_And_Get

617:
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: IF (x_msg_data IS NULL) THEN
621: FND_MSG_PUB.Count_And_Get
622: ( p_encoded => FND_API.G_FALSE
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );

Line 633: FND_MSG_PUB.Count_And_Get

629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (x_msg_data IS NULL) THEN
633: FND_MSG_PUB.Count_And_Get
634: ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );

Line 678: FND_MSG_PUB.Initialize;

674: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
675: l_count NUMBER;
676: BEGIN
677: SAVEPOINT CreateTabView;
678: FND_MSG_PUB.Initialize;
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: l_Tab_View_Rec := p_Tab_View_Rec;
682:

Line 690: FND_MSG_PUB.ADD;

686:
687: IF(l_count =0) THEN
688: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
689: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_View_Rec.Bsc_Tab_Id);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: ELSE
694: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');

Line 695: FND_MSG_PUB.ADD;

691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: ELSE
694: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
695: FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699:

Line 762: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

758: EXCEPTION
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO CreateTabView;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
763: ,p_data => x_msg_data);
764: RAISE;
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 769: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO CreateTabView;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
770: ,p_data => x_msg_data);
771: RAISE;
772:
773: WHEN NO_DATA_FOUND THEN

Line 808: FND_MSG_PUB.Initialize;

804: ,x_msg_count OUT NOCOPY NUMBER
805: ,x_msg_data OUT NOCOPY VARCHAR2
806: ) IS
807: BEGIN
808: FND_MSG_PUB.Initialize;
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: SELECT a.tab_id
812: ,a.kpi_model

Line 847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

843:
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: RAISE;
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

848: ,p_data => x_msg_data);
849: RAISE;
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
853: ,p_data => x_msg_data);
854: RAISE;
855: WHEN NO_DATA_FOUND THEN
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 888: FND_MSG_PUB.Initialize;

884: ,x_msg_count OUT NOCOPY NUMBER
885: ,x_msg_data OUT NOCOPY VARCHAR2
886: )IS
887: BEGIN
888: FND_MSG_PUB.Initialize;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_Id --->' || p_Tab_View_Rec.Bsc_Tab_Id);
892: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_View_Id --->' || p_Tab_View_Rec.Bsc_Tab_View_Id);

Line 917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

913:
914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
918: ,p_data => x_msg_data);
919: RAISE;
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 922: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

918: ,p_data => x_msg_data);
919: RAISE;
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
923: ,p_data => x_msg_data);
924: RAISE;
925: WHEN NO_DATA_FOUND THEN
926: ----DBMS_OUTPUT.PUT_LINE\n('insdei exception p_Tab_View_Rec.Bsc_Tab_Id --->' || p_Tab_View_Rec.Bsc_Tab_Id);

Line 966: FND_MSG_PUB.Initialize;

962: l_count NUMBER;
963:
964: BEGIN
965: SAVEPOINT UpdateTabView;
966: FND_MSG_PUB.Initialize;
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968:
969: l_Tab_View_Rec.Bsc_Tab_Id := p_Tab_View_Rec.Bsc_Tab_Id;
970:

Line 978: FND_MSG_PUB.ADD;

974:
975: IF(l_count =0) THEN
976: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
977: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_View_Rec.Bsc_Tab_Id);
978: FND_MSG_PUB.ADD;
979: RAISE FND_API.G_EXC_ERROR;
980: END IF;
981:
982: ELSE

Line 985: FND_MSG_PUB.ADD;

981:
982: ELSE
983:
984: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987:
988: END IF;
989:

Line 1048: FND_MSG_PUB.Count_And_Get

1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO UpdateTabView;
1047: IF (x_msg_data IS NULL) THEN
1048: FND_MSG_PUB.Count_And_Get
1049: ( p_encoded => FND_API.G_FALSE
1050: , p_count => x_msg_count
1051: , p_data => x_msg_data
1052: );

Line 1059: FND_MSG_PUB.Count_And_Get

1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO UpdateTabView;
1058: IF (x_msg_data IS NULL) THEN
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_encoded => FND_API.G_FALSE
1061: , p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );

Line 1110: FND_MSG_PUB.Initialize;

1106: l_count NUMBER;
1107:
1108: BEGIN
1109: SAVEPOINT UpdateTabdefaultView;
1110: FND_MSG_PUB.Initialize;
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: l_Tab_Rec.Bsc_Tab_Id := p_Tab_Rec.Bsc_Tab_Id;
1114:

Line 1123: FND_MSG_PUB.ADD;

1119:
1120: IF(l_count =0) THEN
1121: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1122: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_Rec.Bsc_Tab_Id);
1123: FND_MSG_PUB.ADD;
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126:
1127: ELSE

Line 1130: FND_MSG_PUB.ADD;

1126:
1127: ELSE
1128:
1129: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1130: FND_MSG_PUB.ADD;
1131: RAISE FND_API.G_EXC_ERROR;
1132:
1133: END IF;
1134:

Line 1227: FND_MSG_PUB.Count_And_Get

1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO UpdateTabdefaultView;
1226: IF (x_msg_data IS NULL) THEN
1227: FND_MSG_PUB.Count_And_Get
1228: ( p_encoded => FND_API.G_FALSE
1229: , p_count => x_msg_count
1230: , p_data => x_msg_data
1231: );

Line 1238: FND_MSG_PUB.Count_And_Get

1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236: ROLLBACK TO UpdateTabdefaultView;
1237: IF (x_msg_data IS NULL) THEN
1238: FND_MSG_PUB.Count_And_Get
1239: ( p_encoded => FND_API.G_FALSE
1240: , p_count => x_msg_count
1241: , p_data => x_msg_data
1242: );

Line 1340: FND_MSG_PUB.Initialize;

1336: BEGIN
1337:
1338: SAVEPOINT deleteCustomView;
1339: ----DBMS_OUTPUT.PUT_LINE\n('Entered inside BSC_CUSTOM_VIEW_PUB.delete_Custom_View ');
1340: FND_MSG_PUB.Initialize;
1341:
1342: l_CustView_Rec.Bsc_Tab_Id := p_CustView_Rec.Bsc_Tab_Id;
1343: l_CustView_Rec.Bsc_Tab_View_Id := p_CustView_Rec.Bsc_Tab_View_Id;
1344:

Line 1352: FND_MSG_PUB.ADD;

1348:
1349: IF(l_count =0) THEN
1350: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1351: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_CustView_Rec.Bsc_Tab_Id);
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356: ELSE

Line 1359: FND_MSG_PUB.ADD;

1355:
1356: ELSE
1357:
1358: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1359: FND_MSG_PUB.ADD;
1360: RAISE FND_API.G_EXC_ERROR;
1361:
1362: END IF;
1363:

Line 1375: FND_MSG_PUB.ADD;

1371:
1372: IF (l_count =0) THEN
1373: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1374: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_CustView_Rec.Bsc_Tab_Id);
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: -- Before deleting the custom view check if it was the default view with the scorecard.

Line 1478: FND_MSG_PUB.Count_And_Get

1474: EXCEPTION
1475: WHEN FND_API.G_EXC_ERROR THEN
1476: ROLLBACK TO deleteCustomView;
1477: IF (x_msg_data IS NULL) THEN
1478: FND_MSG_PUB.Count_And_Get
1479: ( p_encoded => FND_API.G_FALSE
1480: , p_count => x_msg_count
1481: , p_data => x_msg_data
1482: );

Line 1491: FND_MSG_PUB.Count_And_Get

1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO deleteCustomView;
1490: IF (x_msg_data IS NULL) THEN
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_encoded => FND_API.G_FALSE
1493: , p_count => x_msg_count
1494: , p_data => x_msg_data
1495: );

Line 1570: FND_MSG_PUB.Initialize;

1566: AND link_id = p_obj_id;
1567:
1568: BEGIN
1569: SAVEPOINT DeleteCustomViewLinks;
1570: FND_MSG_PUB.Initialize;
1571:
1572: IF(p_tab_id IS NOT NULL) THEN
1573: l_count := get_Tab_Id_Count(p_tab_id);
1574:

Line 1578: FND_MSG_PUB.ADD;

1574:
1575: IF(l_count =0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1577: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
1578: FND_MSG_PUB.ADD;
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: ELSE
1582: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');

Line 1583: FND_MSG_PUB.ADD;

1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: ELSE
1582: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1583: FND_MSG_PUB.ADD;
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586:
1587: l_Count := 0;

Line 1642: FND_MSG_PUB.Count_And_Get

1638:
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO DeleteCustomViewLinks;
1641: IF (x_msg_data IS NULL) THEN
1642: FND_MSG_PUB.Count_And_Get
1643: ( p_encoded => FND_API.G_FALSE
1644: , p_count => x_msg_count
1645: , p_data => x_msg_data
1646: );

Line 1655: FND_MSG_PUB.Count_And_Get

1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO DeleteCustomViewLinks;
1654: IF (x_msg_data IS NULL) THEN
1655: FND_MSG_PUB.Count_And_Get
1656: ( p_encoded => FND_API.G_FALSE
1657: , p_count => x_msg_count
1658: , p_data => x_msg_data
1659: );