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

Line 141: FND_MSG_PUB.Count_And_Get

137: end if;
138:
139: EXCEPTION
140: WHEN FND_API.G_EXC_ERROR THEN
141: FND_MSG_PUB.Count_And_Get
142: ( p_encoded => FND_API.G_FALSE
143: , p_count => x_msg_count
144: , p_data => x_msg_data
145: );

Line 150: FND_MSG_PUB.Count_And_Get

146: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: RAISE;
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: FND_MSG_PUB.Count_And_Get
151: ( p_encoded => FND_API.G_FALSE
152: , p_count => x_msg_count
153: , p_data => x_msg_data
154: );

Line 206: FND_MSG_PUB.Count_And_Get

202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO UpdateBSCDimLevPVT;
206: FND_MSG_PUB.Count_And_Get
207: ( p_encoded => FND_API.G_FALSE
208: , p_count => x_msg_count
209: , p_data => x_msg_data
210: );

Line 216: FND_MSG_PUB.Count_And_Get

212: x_return_status := FND_API.G_RET_STS_ERROR;
213: RAISE;
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO UpdateBSCDimLevPVT;
216: FND_MSG_PUB.Count_And_Get
217: ( p_encoded => FND_API.G_FALSE
218: , p_count => x_msg_count
219: , p_data => x_msg_data
220: );

Line 270: FND_MSG_PUB.Initialize;

266: FROM BSC_SYS_DIM_LEVELS_B
267: WHERE DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id;
268: begin
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: FND_MSG_PUB.Initialize;
271: SAVEPOINT DeleteBSCDimLevPVT;
272: BSC_APPS.Init_Bsc_Apps;
273:
274: l_Dim_Level_Rec := p_Dim_Level_Rec;

Line 281: FND_MSG_PUB.ADD;

277: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
278: if l_count = 0 then
279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
280: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: end if;
284: else
285: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 287: FND_MSG_PUB.ADD;

283: end if;
284: else
285: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
286: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: end if;
290: IF ((l_Dim_Level_Rec.Bsc_Level_Name IS NOT NULL) OR
291: (l_Dim_Level_Rec.Bsc_Level_View_Name IS NOT NULL) OR

Line 376: FND_MSG_PUB.Count_And_Get

372: IF (c_drop_tabs%ISOPEN) THEN
373: CLOSE c_drop_tabs;
374: END IF;
375: ROLLBACK TO DeleteBSCDimLevPVT;
376: FND_MSG_PUB.Count_And_Get
377: ( p_encoded => FND_API.G_FALSE
378: , p_count => x_msg_count
379: , p_data => x_msg_data
380: );

Line 389: FND_MSG_PUB.Count_And_Get

385: IF (c_drop_tabs%ISOPEN) THEN
386: CLOSE c_drop_tabs;
387: END IF;
388: ROLLBACK TO DeleteBSCDimLevPVT;
389: FND_MSG_PUB.Count_And_Get
390: ( p_encoded => FND_API.G_FALSE
391: , p_count => x_msg_count
392: , p_data => x_msg_data
393: );

Line 449: FND_MSG_PUB.Initialize;

445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446: l_Dim_Level_Rec := p_Dim_Level_Rec;
447:
448: SAVEPOINT CreateBSCDimLevMdPVT;
449: FND_MSG_PUB.Initialize;
450: -- Validate Level Id not exists.
451: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
452: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
453: if l_count <> 0 then

Line 456: FND_MSG_PUB.ADD;

452: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
453: if l_count <> 0 then
454: FND_MESSAGE.SET_NAME('BSC','BSC_LEVEL_ID_EXISTS');
455: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
456: FND_MSG_PUB.ADD;
457: RAISE FND_API.G_EXC_ERROR;
458: end if;
459: else
460: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 462: FND_MSG_PUB.ADD;

458: end if;
459: else
460: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
461: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: end if;
465:
466: g_db_object := 'BSC_SYS_DIM_LEVELS_B';

Line 550: FND_MSG_PUB.Count_And_Get

546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: ROLLBACK TO CreateBSCDimLevMdPVT;
550: FND_MSG_PUB.Count_And_Get
551: ( p_encoded => FND_API.G_FALSE
552: , p_count => x_msg_count
553: , p_data => x_msg_data
554: );

Line 560: FND_MSG_PUB.Count_And_Get

556: x_return_status := FND_API.G_RET_STS_ERROR;
557: RAISE;
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO CreateBSCDimLevMdPVT;
560: FND_MSG_PUB.Count_And_Get
561: ( p_encoded => FND_API.G_FALSE
562: , p_count => x_msg_count
563: , p_data => x_msg_data
564: );

Line 583: FND_MSG_PUB.ADD;

579: ROLLBACK TO CreateBSCDimLevMdPVT;
580: if (SQLCODE = -01400) then
581: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
582: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: end if;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: IF (x_msg_data IS NOT NULL) THEN

Line 611: FND_MSG_PUB.Initialize;

607:
608: begin
609:
610: x_return_status:= FND_API.G_RET_STS_SUCCESS;
611: FND_MSG_PUB.Initialize;
612: g_db_object := 'Retrieve_Bsc_Dim_Levels_Md';
613:
614: select a.level_view_name
615: ,a.level_table_name

Line 669: FND_MSG_PUB.Count_And_Get

665: end if;
666:
667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN
669: FND_MSG_PUB.Count_And_Get
670: ( p_encoded => FND_API.G_FALSE
671: , p_count => x_msg_count
672: , p_data => x_msg_data
673: );

Line 678: FND_MSG_PUB.Count_And_Get

674: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: RAISE;
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: FND_MSG_PUB.Count_And_Get
679: ( p_encoded => FND_API.G_FALSE
680: , p_count => x_msg_count
681: , p_data => x_msg_data
682: );

Line 723: FND_MSG_PUB.Initialize;

719: l_count number;
720:
721: begin
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: FND_MSG_PUB.Initialize;
724: SAVEPOINT UpdateBSCDimLevMdPVT;
725: -- Check that valid level id was entered.
726: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
727: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);

Line 731: FND_MSG_PUB.ADD;

727: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
728: if l_count = 0 then
729: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
730: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
731: FND_MSG_PUB.ADD;
732: RAISE FND_API.G_EXC_ERROR;
733: end if;
734: else
735: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 737: FND_MSG_PUB.ADD;

733: end if;
734: else
735: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
736: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
737: FND_MSG_PUB.ADD;
738: RAISE FND_API.G_EXC_ERROR;
739: end if;
740:
741: -- Not all values will be passed. We need to make sure values not passed are not

Line 861: FND_MSG_PUB.Count_And_Get

857:
858: EXCEPTION
859: WHEN FND_API.G_EXC_ERROR THEN
860: ROLLBACK TO UpdateBSCDimLevMdPVT;
861: FND_MSG_PUB.Count_And_Get
862: ( p_encoded => FND_API.G_FALSE
863: , p_count => x_msg_count
864: , p_data => x_msg_data
865: );

Line 871: FND_MSG_PUB.Count_And_Get

867: x_return_status := FND_API.G_RET_STS_ERROR;
868: RAISE;
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: ROLLBACK TO UpdateBSCDimLevMdPVT;
871: FND_MSG_PUB.Count_And_Get
872: ( p_encoded => FND_API.G_FALSE
873: , p_count => x_msg_count
874: , p_data => x_msg_data
875: );

Line 941: FND_MSG_PUB.Count_And_Get

937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO DeleteBSCDimLevMdPVT;
941: FND_MSG_PUB.Count_And_Get
942: ( p_encoded => FND_API.G_FALSE
943: , p_count => x_msg_count
944: , p_data => x_msg_data
945: );

Line 951: FND_MSG_PUB.Count_And_Get

947: x_return_status := FND_API.G_RET_STS_ERROR;
948: RAISE;
949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: ROLLBACK TO DeleteBSCDimLevMdPVT;
951: FND_MSG_PUB.Count_And_Get
952: ( p_encoded => FND_API.G_FALSE
953: , p_count => x_msg_count
954: , p_data => x_msg_data
955: );

Line 999: FND_MSG_PUB.Initialize;

995: l_count number;
996:
997: begin
998: x_return_status := FND_API.G_RET_STS_SUCCESS;
999: FND_MSG_PUB.Initialize;
1000: SAVEPOINT CreateBSCSysDimLevColsPVT;
1001: -- Validate Level Id exists.
1002: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1003: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);

Line 1007: FND_MSG_PUB.ADD;

1003: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1004: if l_count <> 1 then
1005: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1006: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1007: FND_MSG_PUB.ADD;
1008: RAISE FND_API.G_EXC_ERROR;
1009: end if;
1010: else
1011: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 1013: FND_MSG_PUB.ADD;

1009: end if;
1010: else
1011: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1012: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;
1016:
1017: g_db_object := 'BSC_SYS_DIM_LEVEL_COLS';

Line 1034: FND_MSG_PUB.Count_And_Get

1030:
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO CreateBSCSysDimLevColsPVT;
1034: FND_MSG_PUB.Count_And_Get
1035: ( p_encoded => FND_API.G_FALSE
1036: , p_count => x_msg_count
1037: , p_data => x_msg_data
1038: );

Line 1044: FND_MSG_PUB.Count_And_Get

1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: RAISE;
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043: ROLLBACK TO CreateBSCSysDimLevColsPVT;
1044: FND_MSG_PUB.Count_And_Get
1045: ( p_encoded => FND_API.G_FALSE
1046: , p_count => x_msg_count
1047: , p_data => x_msg_data
1048: );

Line 1068: FND_MSG_PUB.ADD;

1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: if (SQLCODE = -01400) then
1066: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1067: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: end if;
1071: IF (x_msg_data IS NOT NULL) THEN
1072: x_msg_data := x_msg_data||' -> BSC_DIMENSION_LEVELS_PVT.Create_Bsc_Sys_Dim_Lvl_Cols ';

Line 1108: FND_MSG_PUB.Count_And_Get

1104: end if;
1105:
1106: EXCEPTION
1107: WHEN FND_API.G_EXC_ERROR THEN
1108: FND_MSG_PUB.Count_And_Get
1109: ( p_encoded => FND_API.G_FALSE
1110: , p_count => x_msg_count
1111: , p_data => x_msg_data
1112: );

Line 1117: FND_MSG_PUB.Count_And_Get

1113: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: RAISE;
1116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1117: FND_MSG_PUB.Count_And_Get
1118: ( p_encoded => FND_API.G_FALSE
1119: , p_count => x_msg_count
1120: , p_data => x_msg_data
1121: );

Line 1162: FND_MSG_PUB.Initialize;

1158: l_count number;
1159:
1160: begin
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162: FND_MSG_PUB.Initialize;
1163: SAVEPOINT UpdateBSCSysDimLevColsPVT;
1164: -- Check that valid level id was entered.
1165: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1166: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);

Line 1170: FND_MSG_PUB.ADD;

1166: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1167: if l_count <> 1 then
1168: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1169: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1170: FND_MSG_PUB.ADD;
1171: RAISE FND_API.G_EXC_ERROR;
1172: end if;
1173: else
1174: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 1176: FND_MSG_PUB.ADD;

1172: end if;
1173: else
1174: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1175: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1176: FND_MSG_PUB.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1178: end if;
1179:
1180: -- Level Column Type must be entered, if not raise error.

Line 1184: FND_MSG_PUB.ADD;

1180: -- Level Column Type must be entered, if not raise error.
1181: if l_Dim_Level_Rec.Bsc_Level_Column_Type not in ('A', 'D', 'F', 'P', 'U') then
1182: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_COL_TYPE');
1183: FND_MESSAGE.SET_TOKEN('BSC_COL_TYPE', l_Dim_Level_Rec.Bsc_Level_Column_Type);
1184: FND_MSG_PUB.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;
1187:
1188: -- In this case there is only one column that may be updated, therefore there is no

Line 1203: FND_MSG_PUB.Count_And_Get

1199:
1200: EXCEPTION
1201: WHEN FND_API.G_EXC_ERROR THEN
1202: ROLLBACK TO UpdateBSCSysDimLevColsPVT;
1203: FND_MSG_PUB.Count_And_Get
1204: ( p_encoded => FND_API.G_FALSE
1205: , p_count => x_msg_count
1206: , p_data => x_msg_data
1207: );

Line 1213: FND_MSG_PUB.Count_And_Get

1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: RAISE;
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: ROLLBACK TO UpdateBSCSysDimLevColsPVT;
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );

Line 1271: FND_MSG_PUB.Count_And_Get

1267:
1268: EXCEPTION
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO DeleteBSCSysDimLevColsPVT;
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_encoded => FND_API.G_FALSE
1273: , p_count => x_msg_count
1274: , p_data => x_msg_data
1275: );

Line 1281: FND_MSG_PUB.Count_And_Get

1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: RAISE;
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: ROLLBACK TO DeleteBSCSysDimLevColsPVT;
1281: FND_MSG_PUB.Count_And_Get
1282: ( p_encoded => FND_API.G_FALSE
1283: , p_count => x_msg_count
1284: , p_data => x_msg_data
1285: );

Line 1372: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1368:
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: l_return_status := FND_API.G_RET_STS_ERROR;
1372: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1373: ,p_data => l_msg_data);
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1375: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1376: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1372: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1373: ,p_data => l_msg_data);
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1375: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1377: ,p_data => l_msg_data);
1378: raise;
1379: WHEN NO_DATA_FOUND THEN
1380: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1381: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1377: ,p_data => l_msg_data);
1378: raise;
1379: WHEN NO_DATA_FOUND THEN
1380: l_return_status := FND_API.G_RET_STS_ERROR;
1381: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1382: ,p_data => l_msg_data);
1383: raise;
1384: WHEN OTHERS THEN
1385: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1386: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1382: ,p_data => l_msg_data);
1383: raise;
1384: WHEN OTHERS THEN
1385: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1387: ,p_data => l_msg_data);
1388: raise;
1389:
1390: end Get_Next_Value;

Line 1432: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1428:
1429: EXCEPTION
1430: WHEN FND_API.G_EXC_ERROR THEN
1431: l_return_status := FND_API.G_RET_STS_ERROR;
1432: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1433: ,p_data => l_msg_data);
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1436: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1432: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1433: ,p_data => l_msg_data);
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1437: ,p_data => l_msg_data);
1438: raise;
1439: WHEN NO_DATA_FOUND THEN
1440: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1441: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1437: ,p_data => l_msg_data);
1438: raise;
1439: WHEN NO_DATA_FOUND THEN
1440: l_return_status := FND_API.G_RET_STS_ERROR;
1441: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1442: ,p_data => l_msg_data);
1443: raise;
1444: WHEN OTHERS THEN
1445: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1446: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1442: ,p_data => l_msg_data);
1443: raise;
1444: WHEN OTHERS THEN
1445: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1447: ,p_data => l_msg_data);
1448: raise;
1449:
1450: end Get_Id;

Line 1478: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1474: RETURN l_Count;
1475: EXCEPTION
1476: WHEN FND_API.G_EXC_ERROR THEN
1477: l_return_status := FND_API.G_RET_STS_ERROR;
1478: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1479: ,p_data => l_msg_data);
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1482: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1478: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1479: ,p_data => l_msg_data);
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1483: ,p_data => l_msg_data);
1484: raise;
1485: WHEN NO_DATA_FOUND THEN
1486: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1487: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1483: ,p_data => l_msg_data);
1484: raise;
1485: WHEN NO_DATA_FOUND THEN
1486: l_return_status := FND_API.G_RET_STS_ERROR;
1487: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1488: ,p_data => l_msg_data);
1489: raise;
1490: WHEN OTHERS THEN
1491: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1492: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1488: ,p_data => l_msg_data);
1489: raise;
1490: WHEN OTHERS THEN
1491: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1492: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1493: ,p_data => l_msg_data);
1494: raise;
1495:
1496: end Validate_Dim_Level;

Line 1523: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1519: RETURN l_Count;
1520: EXCEPTION
1521: WHEN FND_API.G_EXC_ERROR THEN
1522: l_return_status := FND_API.G_RET_STS_ERROR;
1523: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1524: ,p_data => l_msg_data);
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1527: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1523: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1524: ,p_data => l_msg_data);
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1528: ,p_data => l_msg_data);
1529: raise;
1530: WHEN NO_DATA_FOUND THEN
1531: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1532: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1528: ,p_data => l_msg_data);
1529: raise;
1530: WHEN NO_DATA_FOUND THEN
1531: l_return_status := FND_API.G_RET_STS_ERROR;
1532: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1533: ,p_data => l_msg_data);
1534: raise;
1535: WHEN OTHERS THEN
1536: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1537: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1533: ,p_data => l_msg_data);
1534: raise;
1535: WHEN OTHERS THEN
1536: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1538: ,p_data => l_msg_data);
1539: raise;
1540:
1541: end Validate_Dim_Group;

Line 1616: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1612:
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_ERROR THEN
1615: l_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1617: ,p_data => l_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1620: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1616: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1617: ,p_data => l_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1621: ,p_data => l_msg_data);
1622: raise;
1623: WHEN NO_DATA_FOUND THEN
1624: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1625: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1621: ,p_data => l_msg_data);
1622: raise;
1623: WHEN NO_DATA_FOUND THEN
1624: l_return_status := FND_API.G_RET_STS_ERROR;
1625: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1626: ,p_data => l_msg_data);
1627: raise;
1628: WHEN OTHERS THEN
1629: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1630: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1626: ,p_data => l_msg_data);
1627: raise;
1628: WHEN OTHERS THEN
1629: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1631: ,p_data => l_msg_data);
1632: raise;
1633:
1634: end get_dim_levels;

Line 1671: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1667:
1668: EXCEPTION
1669: WHEN FND_API.G_EXC_ERROR THEN
1670: l_return_status := FND_API.G_RET_STS_ERROR;
1671: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1672: ,p_data => l_msg_data);
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1675: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1671: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1672: ,p_data => l_msg_data);
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1676: ,p_data => l_msg_data);
1677: raise;
1678: WHEN NO_DATA_FOUND THEN
1679: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1680: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1676: ,p_data => l_msg_data);
1677: raise;
1678: WHEN NO_DATA_FOUND THEN
1679: l_return_status := FND_API.G_RET_STS_ERROR;
1680: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1681: ,p_data => l_msg_data);
1682: raise;
1683: WHEN OTHERS THEN
1684: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1685: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1681: ,p_data => l_msg_data);
1682: raise;
1683: WHEN OTHERS THEN
1684: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1686: ,p_data => l_msg_data);
1687: raise;
1688:
1689: end Validate_Value;

Line 1728: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1724:
1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: l_return_status := FND_API.G_RET_STS_ERROR;
1728: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1729: ,p_data => l_msg_data);
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1732: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1728: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1729: ,p_data => l_msg_data);
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1733: ,p_data => l_msg_data);
1734: raise;
1735: WHEN NO_DATA_FOUND THEN
1736: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1737: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1733: ,p_data => l_msg_data);
1734: raise;
1735: WHEN NO_DATA_FOUND THEN
1736: l_return_status := FND_API.G_RET_STS_ERROR;
1737: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1738: ,p_data => l_msg_data);
1739: raise;
1740: WHEN OTHERS THEN
1741: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1742: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1738: ,p_data => l_msg_data);
1739: raise;
1740: WHEN OTHERS THEN
1741: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1743: ,p_data => l_msg_data);
1744: raise;
1745:
1746: end Get_Object_Name;

Line 1771: FND_MSG_PUB.Initialize;

1767: l_temp_col VARCHAR2(50);
1768:
1769: BEGIN
1770: x_return_status := FND_API.G_RET_STS_SUCCESS;
1771: FND_MSG_PUB.Initialize;
1772: SAVEPOINT CreateBSCDimLevRelsPVT;
1773: g_db_object := 'Create_Dim_Level_Relation';
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775: -- Validate level id exists.

Line 1783: FND_MSG_PUB.ADD;

1779: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1780: IF (l_count = 0) THEN
1781: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);

Line 1791: FND_MSG_PUB.ADD;

1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1788: IF (l_count = 0) THEN
1789: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1790: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794:
1795: ---- DBMS_OUTPUT.PUT_LINE('After Validation');

Line 1900: FND_MSG_PUB.ADD;

1896:
1897: ELSE
1898: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1899: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903:
1904: ---- DBMS_OUTPUT.PUT_LINE('END ....');

Line 1913: FND_MSG_PUB.Count_And_Get

1909:
1910: EXCEPTION
1911: WHEN FND_API.G_EXC_ERROR THEN
1912: ROLLBACK TO CreateBSCDimLevRelsPVT;
1913: FND_MSG_PUB.Count_And_Get
1914: ( p_encoded => FND_API.G_FALSE
1915: , p_count => x_msg_count
1916: , p_data => x_msg_data
1917: );

Line 1923: FND_MSG_PUB.Count_And_Get

1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: RAISE;
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922: ROLLBACK TO CreateBSCDimLevRelsPVT;
1923: FND_MSG_PUB.Count_And_Get
1924: ( p_encoded => FND_API.G_FALSE
1925: , p_count => x_msg_count
1926: , p_data => x_msg_data
1927: );

Line 1977: FND_MSG_PUB.Count_And_Get

1973:
1974: EXCEPTION
1975: WHEN FND_API.G_EXC_ERROR THEN
1976: ROLLBACK TO DeleteBSCDimLevRelsPVT;
1977: FND_MSG_PUB.Count_And_Get
1978: ( p_encoded => FND_API.G_FALSE
1979: , p_count => x_msg_count
1980: , p_data => x_msg_data
1981: );

Line 1987: FND_MSG_PUB.Count_And_Get

1983: x_return_status := FND_API.G_RET_STS_ERROR;
1984: RAISE;
1985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1986: ROLLBACK TO DeleteBSCDimLevRelsPVT;
1987: FND_MSG_PUB.Count_And_Get
1988: ( p_encoded => FND_API.G_FALSE
1989: , p_count => x_msg_count
1990: , p_data => x_msg_data
1991: );

Line 2113: FND_MSG_PUB.Count_And_Get

2109: END IF;
2110: RETURN v_temp;
2111: EXCEPTION
2112: WHEN FND_API.G_EXC_ERROR THEN
2113: FND_MSG_PUB.Count_And_Get
2114: ( p_encoded => FND_API.G_FALSE
2115: , p_count => x_msg_count
2116: , p_data => x_msg_data
2117: );

Line 2122: FND_MSG_PUB.Count_And_Get

2118: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2119: x_return_status := FND_API.G_RET_STS_ERROR;
2120: RAISE;
2121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2122: FND_MSG_PUB.Count_And_Get
2123: ( p_encoded => FND_API.G_FALSE
2124: , p_count => x_msg_count
2125: , p_data => x_msg_data
2126: );

Line 2271: FND_MSG_PUB.Initialize;

2267: AND DL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Level_Short_Name
2268: AND PL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
2269: BEGIN
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271: FND_MSG_PUB.Initialize;
2272: g_db_object := 'Retrieve_Relationship';
2273: -- Validate level id exists.
2274: IF ((p_Dim_Level_Rec.Bsc_Level_Id IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Id IS NOT NULL)) THEN
2275: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);

Line 2279: FND_MSG_PUB.ADD;

2275: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
2276: IF (l_count = 0) THEN
2277: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2278: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2283: IF (l_count = 0) THEN

Line 2286: FND_MSG_PUB.ADD;

2282: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2283: IF (l_count = 0) THEN
2284: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2285: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;
2289: IF (cr_getId_rels%ISOPEN) THEN
2290: CLOSE cr_getId_rels;

Line 2314: FND_MSG_PUB.ADD;

2310:
2311: IF (l_count = 0) THEN
2312: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2313: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Level_Short_Name);
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;
2317:
2318: -- bug# 3814375: Most often short name and parent are the same - hence, need not fire this SQL if the above is validated.

Line 2327: FND_MSG_PUB.ADD;

2323:
2324: IF (l_count = 0) THEN
2325: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2326: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
2327: FND_MSG_PUB.ADD;
2328: RAISE FND_API.G_EXC_ERROR;
2329: END IF;
2330: END IF;
2331:

Line 2352: FND_MSG_PUB.ADD;

2348: CLOSE cr_getName_rels;
2349: ELSE
2350: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2351: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
2352: FND_MSG_PUB.ADD;
2353: RAISE FND_API.G_EXC_ERROR;
2354: END IF;
2355: EXCEPTION
2356: WHEN FND_API.G_EXC_ERROR THEN

Line 2360: FND_MSG_PUB.Count_And_Get

2356: WHEN FND_API.G_EXC_ERROR THEN
2357: IF (cr_getId_rels%ISOPEN) THEN
2358: CLOSE cr_getId_rels;
2359: END IF;
2360: FND_MSG_PUB.Count_And_Get
2361: ( p_encoded => FND_API.G_FALSE
2362: , p_count => x_msg_count
2363: , p_data => x_msg_data
2364: );

Line 2372: FND_MSG_PUB.Count_And_Get

2368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2369: IF (cr_getId_rels%ISOPEN) THEN
2370: CLOSE cr_getId_rels;
2371: END IF;
2372: FND_MSG_PUB.Count_And_Get
2373: ( p_encoded => FND_API.G_FALSE
2374: , p_count => x_msg_count
2375: , p_data => x_msg_data
2376: );

Line 2464: FND_MSG_PUB.Initialize;

2460:
2461: BEGIN
2462: x_return_status := FND_API.G_RET_STS_SUCCESS;
2463: g_db_object := 'get_Relation_Column';
2464: FND_MSG_PUB.Initialize;
2465:
2466: IF ((p_Child_level_Id IS NOT NULL) AND (p_Parent_level_Id IS NOT NULL)) THEN
2467:
2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);

Line 2472: FND_MSG_PUB.ADD;

2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);
2469: IF (l_count = 0) THEN
2470: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2471: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475:
2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);

Line 2480: FND_MSG_PUB.ADD;

2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);
2477: IF (l_count = 0) THEN
2478: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2479: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Parent_level_Id);
2480: FND_MSG_PUB.ADD;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:
2484:

Line 2537: FND_MSG_PUB.ADD;

2533:
2534: ELSE
2535: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2536: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2537: FND_MSG_PUB.ADD;
2538: RAISE FND_API.G_EXC_ERROR;
2539: END IF;
2540:
2541: RETURN x_rel_col;

Line 2554: FND_MSG_PUB.Count_And_Get

2550: END IF;
2551: IF (r_col%ISOPEN) THEN
2552: CLOSE r_col;
2553: END IF;
2554: FND_MSG_PUB.Count_And_Get
2555: ( p_encoded => FND_API.G_FALSE
2556: , p_count => x_msg_count
2557: , p_data => x_msg_data
2558: );

Line 2572: FND_MSG_PUB.Count_And_Get

2568: END IF;
2569: IF (r_col%ISOPEN) THEN
2570: CLOSE r_col;
2571: END IF;
2572: FND_MSG_PUB.Count_And_Get
2573: ( p_encoded => FND_API.G_FALSE
2574: , p_count => x_msg_count
2575: , p_data => x_msg_data
2576: );

Line 2669: FND_MSG_PUB.Count_And_Get(

2665:
2666: EXCEPTION
2667: WHEN FND_API.G_EXC_ERROR THEN
2668: x_return_status := FND_API.G_RET_STS_ERROR;
2669: FND_MSG_PUB.Count_And_Get(
2670: p_encoded => 'F'
2671: ,p_count => x_msg_count
2672: ,p_data => x_msg_data
2673: );

Line 2677: FND_MSG_PUB.Count_And_Get(

2673: );
2674: RAISE;
2675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2677: FND_MSG_PUB.Count_And_Get(
2678: p_encoded => 'F'
2679: ,p_count => x_msg_count
2680: ,p_data => x_msg_data
2681: );

Line 2755: FND_MSG_PUB.Count_And_Get(

2751: EXCEPTION
2752: WHEN FND_API.G_EXC_ERROR THEN
2753: x_return_status := FND_API.G_RET_STS_ERROR ;
2754: ROLLBACK TO TranslateBSCDimLevPVT;
2755: FND_MSG_PUB.Count_And_Get(
2756: p_encoded => 'F'
2757: ,p_count => x_msg_count
2758: ,p_data => x_msg_data
2759: );

Line 2763: FND_MSG_PUB.Count_And_Get(

2759: );
2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: ROLLBACK TO TranslateBSCDimLevPVT;
2763: FND_MSG_PUB.Count_And_Get(
2764: p_encoded => 'F'
2765: ,p_count => x_msg_count
2766: ,p_data => x_msg_data
2767: );

Line 2798: FND_MSG_PUB.Initialize;

2794: l_Dim_Level_Id NUMBER;
2795: BEGIN
2796: SAVEPOINT TransDimObjByLangBsc;
2797: x_return_status := FND_API.G_RET_STS_SUCCESS;
2798: FND_MSG_PUB.Initialize;
2799:
2800: SELECT Dim_Level_Id
2801: INTO l_Dim_Level_Id
2802: FROM BSC_SYS_DIM_LEVELS_B

Line 2823: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2819: EXCEPTION
2820: WHEN FND_API.G_EXC_ERROR THEN
2821: ROLLBACK TO TransDimObjByLangBsc;
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2824: ,p_data => x_msg_data);
2825:
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: ROLLBACK TO TransDimObjByLangBsc;

Line 2829: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2825:
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: ROLLBACK TO TransDimObjByLangBsc;
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2830: ,p_data => x_msg_data);
2831: WHEN NO_DATA_FOUND THEN
2832: ROLLBACK TO TransDimObjByLangBsc;
2833: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2830: ,p_data => x_msg_data);
2831: WHEN NO_DATA_FOUND THEN
2832: ROLLBACK TO TransDimObjByLangBsc;
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2835: ,p_data => x_msg_data);
2836:
2837: WHEN OTHERS THEN
2838: ROLLBACK TO TransDimObjByLangBsc;

Line 2840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2836:
2837: WHEN OTHERS THEN
2838: ROLLBACK TO TransDimObjByLangBsc;
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2841: ,p_data => x_msg_data);
2842:
2843: END Trans_DimObj_By_Given_Lang;
2844: