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

Line 57: FND_MSG_PUB.Initialize;

53: FROM fnd_languages
54: WHERE installed_flag IN ('I','B');
55:
56: begin
57: FND_MSG_PUB.Initialize;
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: SAVEPOINT CreateBSCTabPVT;
60: -- Check Tab Id does not exist.
61: IF p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id IS NOT NULL THEN

Line 70: FND_MSG_PUB.ADD;

66:
67: IF l_Count <> 0 THEN
68: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_ID_EXISTS');
69: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
70: FND_MSG_PUB.ADD;
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: -- Check for duplicate short_name

Line 82: FND_MSG_PUB.ADD;

78: WHERE T.SHORT_NAME = p_Bsc_Tab_Entity_Rec.Bsc_Short_Name;
79:
80: IF l_Count <> 0 THEN
81: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SHORT_NAME_NOT_UNIQUE');
82: FND_MSG_PUB.ADD;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: END IF;
86:

Line 90: FND_MSG_PUB.ADD;

86:
87: ELSE
88: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
89: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
90: FND_MSG_PUB.ADD;
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: g_db_object := 'BSC_TABS_B';

Line 201: FND_MSG_PUB.Count_And_Get

197:
198: EXCEPTION
199: WHEN FND_API.G_EXC_ERROR THEN
200: ROLLBACK TO CreateBSCTabPVT;
201: FND_MSG_PUB.Count_And_Get
202: ( p_encoded => FND_API.G_FALSE
203: , p_count => x_msg_count
204: , p_data => x_msg_data
205: );

Line 211: FND_MSG_PUB.Count_And_Get

207: x_return_status := FND_API.G_RET_STS_ERROR;
208: RAISE;
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO CreateBSCTabPVT;
211: FND_MSG_PUB.Count_And_Get
212: ( p_encoded => FND_API.G_FALSE
213: , p_count => x_msg_count
214: , p_data => x_msg_data
215: );

Line 311: FND_MSG_PUB.Count_And_Get

307: AND B.LANGUAGE = USERENV('LANG')
308: AND D.LANGUAGE = USERENV('LANG');
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: FND_MSG_PUB.Count_And_Get
312: ( p_encoded => FND_API.G_FALSE
313: , p_count => x_msg_count
314: , p_data => x_msg_data
315: );

Line 320: FND_MSG_PUB.Count_And_Get

316: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: FND_MSG_PUB.Count_And_Get
321: ( p_encoded => FND_API.G_FALSE
322: , p_count => x_msg_count
323: , p_data => x_msg_data
324: );

Line 367: FND_MSG_PUB.Initialize;

363: l_count number;
364: l_move_flag number := 0; --Flag to move Tabs.
365:
366: begin
367: FND_MSG_PUB.Initialize;
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369: SAVEPOINT UpdateBSCTabPVT;
370: -- Check that valid Tab id was entered.
371: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then

Line 378: FND_MSG_PUB.ADD;

374: ,p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
375: if l_count = 0 then
376: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
377: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
378: FND_MSG_PUB.ADD;
379: RAISE FND_API.G_EXC_ERROR;
380: end if;
381: else
382: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

Line 384: FND_MSG_PUB.ADD;

380: end if;
381: else
382: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
383: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: end if;
387:
388: -- Not all values will be passed. We need to make sure values not passed are not

Line 533: FND_MSG_PUB.Count_And_Get

529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: ROLLBACK TO UpdateBSCTabPVT;
533: FND_MSG_PUB.Count_And_Get
534: ( p_encoded => FND_API.G_FALSE
535: , p_count => x_msg_count
536: , p_data => x_msg_data
537: );

Line 543: FND_MSG_PUB.Count_And_Get

539: x_return_status := FND_API.G_RET_STS_ERROR;
540: RAISE;
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: ROLLBACK TO UpdateBSCTabPVT;
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE
545: , p_count => x_msg_count
546: , p_data => x_msg_data
547: );

Line 613: FND_MSG_PUB.Initialize;

609:
610:
611:
612: begin
613: FND_MSG_PUB.Initialize;
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: SAVEPOINT DeleteBSCTabPVT;
616: -- Check that valid Tab id was entered.
617: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then

Line 627: FND_MSG_PUB.ADD;

623:
624: if l_count = 0 then
625: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
626: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: end if;
630: else
631: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

Line 633: FND_MSG_PUB.ADD;

629: end if;
630: else
631: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
632: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
633: FND_MSG_PUB.ADD;
634: RAISE FND_API.G_EXC_ERROR;
635: end if;
636:
637: -- Before we delete the tab we need to reset the tab id parent and tab_index

Line 769: FND_MSG_PUB.Count_And_Get

765: ROLLBACK TO DeleteBSCTabPVT;
766: IF(c_indic_in_tab%ISOPEN ) THEN
767: CLOSE c_indic_in_tab;
768: END IF;
769: FND_MSG_PUB.Count_And_Get
770: ( p_encoded => FND_API.G_FALSE
771: , p_count => x_msg_count
772: , p_data => x_msg_data
773: );

Line 783: FND_MSG_PUB.Count_And_Get

779: IF(c_indic_in_tab%ISOPEN ) THEN
780: CLOSE c_indic_in_tab;
781: END IF;
782:
783: FND_MSG_PUB.Count_And_Get
784: ( p_encoded => FND_API.G_FALSE
785: , p_count => x_msg_count
786: , p_data => x_msg_data
787: );

Line 836: FND_MSG_PUB.Initialize;

832:
833: l_count number;
834:
835: begin
836: FND_MSG_PUB.Initialize;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: SAVEPOINT CreateBSCTabAccessPVT;
839: -- Check that valid Tab id was entered.
840: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then

Line 847: FND_MSG_PUB.ADD;

843: ,p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
844: if l_count = 0 then
845: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
846: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
847: FND_MSG_PUB.ADD;
848: RAISE FND_API.G_EXC_ERROR;
849: end if;
850: else
851: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

Line 853: FND_MSG_PUB.ADD;

849: end if;
850: else
851: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
852: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
853: FND_MSG_PUB.ADD;
854: RAISE FND_API.G_EXC_ERROR;
855: end if;
856:
857: g_db_object := 'BSC_USER_TAB_ACCESS';

Line 885: FND_MSG_PUB.Count_And_Get

881:
882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO CreateBSCTabAccessPVT;
885: FND_MSG_PUB.Count_And_Get
886: ( p_encoded => FND_API.G_FALSE
887: , p_count => x_msg_count
888: , p_data => x_msg_data
889: );

Line 895: FND_MSG_PUB.Count_And_Get

891: x_return_status := FND_API.G_RET_STS_ERROR;
892: RAISE;
893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: ROLLBACK TO CreateBSCTabAccessPVT;
895: FND_MSG_PUB.Count_And_Get
896: ( p_encoded => FND_API.G_FALSE
897: , p_count => x_msg_count
898: , p_data => x_msg_data
899: );

Line 942: FND_MSG_PUB.Initialize;

938:
939: l_count number;
940:
941: begin
942: FND_MSG_PUB.Initialize;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: SAVEPOINT CreateBSCTabGrantsPVT;
945:
946: Insert_Scorecard_Grants(

Line 957: FND_MSG_PUB.Count_And_Get

953:
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ROLLBACK TO CreateBSCTabGrantsPVT;
957: FND_MSG_PUB.Count_And_Get
958: ( p_encoded => FND_API.G_FALSE
959: , p_count => x_msg_count
960: , p_data => x_msg_data
961: );

Line 967: FND_MSG_PUB.Count_And_Get

963: x_return_status := FND_API.G_RET_STS_ERROR;
964: RAISE;
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: ROLLBACK TO CreateBSCTabGrantsPVT;
967: FND_MSG_PUB.Count_And_Get
968: ( p_encoded => FND_API.G_FALSE
969: , p_count => x_msg_count
970: , p_data => x_msg_data
971: );

Line 1020: FND_MSG_PUB.Initialize;

1016:
1017: l_sql varchar2(2000);
1018:
1019: begin
1020: FND_MSG_PUB.Initialize;
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022: SAVEPOINT MoveBSCTabPVT;
1023: l_sql := 'select distinct tab_id, tab_index ' ||
1024: ' from BSC_TABS_B ' ||

Line 1052: FND_MSG_PUB.Count_And_Get

1048:
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK TO MoveBSCTabPVT;
1052: FND_MSG_PUB.Count_And_Get
1053: ( p_encoded => FND_API.G_FALSE
1054: , p_count => x_msg_count
1055: , p_data => x_msg_data
1056: );

Line 1062: FND_MSG_PUB.Count_And_Get

1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: RAISE;
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: ROLLBACK TO MoveBSCTabPVT;
1062: FND_MSG_PUB.Count_And_Get
1063: ( p_encoded => FND_API.G_FALSE
1064: , p_count => x_msg_count
1065: , p_data => x_msg_data
1066: );

Line 1105: FND_MSG_PUB.Initialize;

1101: ,x_msg_data OUT NOCOPY varchar2
1102: ) is
1103:
1104: begin
1105: FND_MSG_PUB.Initialize;
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107: SAVEPOINT UpdateBSCTabTimStmPVT;
1108: update BSC_TABS_B
1109: set last_update_date = sysdate

Line 1119: FND_MSG_PUB.Count_And_Get

1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN
1118: ROLLBACK TO UpdateBSCTabTimStmPVT;
1119: FND_MSG_PUB.Count_And_Get
1120: ( p_encoded => FND_API.G_FALSE
1121: , p_count => x_msg_count
1122: , p_data => x_msg_data
1123: );

Line 1129: FND_MSG_PUB.Count_And_Get

1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: RAISE;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO UpdateBSCTabTimStmPVT;
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_encoded => FND_API.G_FALSE
1131: , p_count => x_msg_count
1132: , p_data => x_msg_data
1133: );

Line 1172: FND_MSG_PUB.Initialize;

1168: ,x_msg_data OUT NOCOPY varchar2
1169: ) is
1170:
1171: begin
1172: FND_MSG_PUB.Initialize;
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174: SAVEPOINT UpdateBSCTabSysTimStmPVT;
1175: update BSC_SYS_INIT
1176: set last_update_date = sysdate

Line 1186: FND_MSG_PUB.Count_And_Get

1182:
1183: EXCEPTION
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: ROLLBACK TO UpdateBSCTabSysTimStmPVT;
1186: FND_MSG_PUB.Count_And_Get
1187: ( p_encoded => FND_API.G_FALSE
1188: , p_count => x_msg_count
1189: , p_data => x_msg_data
1190: );

Line 1196: FND_MSG_PUB.Count_And_Get

1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: RAISE;
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO UpdateBSCTabSysTimStmPVT;
1196: FND_MSG_PUB.Count_And_Get
1197: ( p_encoded => FND_API.G_FALSE
1198: , p_count => x_msg_count
1199: , p_data => x_msg_data
1200: );

Line 1353: FND_MSG_PUB.ADD;

1349: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B','tab_id',p_tab_id);
1350: IF l_count = 0 THEN
1351: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
1352: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
1353: FND_MSG_PUB.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF;
1356: ELSE
1357: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

Line 1359: FND_MSG_PUB.ADD;

1355: END IF;
1356: ELSE
1357: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
1358: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
1359: FND_MSG_PUB.ADD;
1360: RAISE FND_API.G_EXC_ERROR;
1361: END IF;
1362:
1363: /*User name can never be null, so no need to check for null condition*/