DBA Data[Home] [Help]

APPS.BSC_DIMENSION_GROUPS_PUB dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.Initialize;

70: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
71:
72: begin
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74: FND_MSG_PUB.Initialize;
75: -- Assign all values in the passed "Record" parameter to the locally defined
76: -- "Record" variable.
77: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
78:

Line 179: FND_MSG_PUB.ADD;

175: else
176:
177: FND_MESSAGE.SET_NAME('BSC','BSC_GROUP_NAME_NOT_ENTERED');
178: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
179: FND_MSG_PUB.ADD;
180: RAISE FND_API.G_EXC_ERROR;
181:
182: end if;
183:

Line 188: FND_MSG_PUB.Count_And_Get

184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: IF (x_msg_data IS NULL) THEN
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => 'F'
190: , p_count => x_msg_count
191: , p_data => x_msg_data
192: );

Line 198: FND_MSG_PUB.Count_And_Get

194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: IF (x_msg_data IS NULL) THEN
198: FND_MSG_PUB.Count_And_Get
199: ( p_encoded => 'F'
200: , p_count => x_msg_count
201: , p_data => x_msg_data
202: );

Line 254: FND_MSG_PUB.Count_And_Get

250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: IF (x_msg_data IS NULL) THEN
254: FND_MSG_PUB.Count_And_Get
255: ( p_encoded => 'F'
256: , p_count => x_msg_count
257: , p_data => x_msg_data
258: );

Line 264: FND_MSG_PUB.Count_And_Get

260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: IF (x_msg_data IS NULL) THEN
264: FND_MSG_PUB.Count_And_Get
265: ( p_encoded => 'F'
266: , p_count => x_msg_count
267: , p_data => x_msg_data
268: );

Line 322: FND_MSG_PUB.Count_And_Get

318: END IF;
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: IF (x_msg_data IS NULL) THEN
322: FND_MSG_PUB.Count_And_Get
323: ( p_encoded => 'F'
324: , p_count => x_msg_count
325: , p_data => x_msg_data
326: );

Line 332: FND_MSG_PUB.Count_And_Get

328: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: IF (x_msg_data IS NULL) THEN
332: FND_MSG_PUB.Count_And_Get
333: ( p_encoded => 'F'
334: , p_count => x_msg_count
335: , p_data => x_msg_data
336: );

Line 397: FND_MSG_PUB.Count_And_Get

393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: IF (x_msg_data IS NULL) THEN
397: FND_MSG_PUB.Count_And_Get
398: ( p_encoded => 'F'
399: , p_count => x_msg_count
400: , p_data => x_msg_data
401: );

Line 407: FND_MSG_PUB.Count_And_Get

403: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: IF (x_msg_data IS NULL) THEN
407: FND_MSG_PUB.Count_And_Get
408: ( p_encoded => 'F'
409: , p_count => x_msg_count
410: , p_data => x_msg_data
411: );

Line 463: FND_MSG_PUB.Count_And_Get

459: END IF;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: IF (x_msg_data IS NULL) THEN
463: FND_MSG_PUB.Count_And_Get
464: ( p_encoded => 'F'
465: , p_count => x_msg_count
466: , p_data => x_msg_data
467: );

Line 473: FND_MSG_PUB.Count_And_Get

469: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: IF (x_msg_data IS NULL) THEN
473: FND_MSG_PUB.Count_And_Get
474: ( p_encoded => 'F'
475: , p_count => x_msg_count
476: , p_data => x_msg_data
477: );

Line 535: FND_MSG_PUB.Count_And_Get

531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: IF (x_msg_data IS NULL) THEN
535: FND_MSG_PUB.Count_And_Get
536: ( p_encoded => 'F'
537: , p_count => x_msg_count
538: , p_data => x_msg_data
539: );

Line 545: FND_MSG_PUB.Count_And_Get

541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => 'F'
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );

Line 648: FND_MSG_PUB.Count_And_Get

644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: IF (x_msg_data IS NULL) THEN
648: FND_MSG_PUB.Count_And_Get
649: ( p_encoded => 'F'
650: , p_count => x_msg_count
651: , p_data => x_msg_data
652: );

Line 658: FND_MSG_PUB.Count_And_Get

654: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: IF (x_msg_data IS NULL) THEN
658: FND_MSG_PUB.Count_And_Get
659: ( p_encoded => 'F'
660: , p_count => x_msg_count
661: , p_data => x_msg_data
662: );

Line 709: FND_MSG_PUB.Count_And_Get

705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: IF (x_msg_data IS NULL) THEN
709: FND_MSG_PUB.Count_And_Get
710: ( p_encoded => 'F'
711: , p_count => x_msg_count
712: , p_data => x_msg_data
713: );

Line 719: FND_MSG_PUB.Count_And_Get

715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: IF (x_msg_data IS NULL) THEN
719: FND_MSG_PUB.Count_And_Get
720: ( p_encoded => 'F'
721: , p_count => x_msg_count
722: , p_data => x_msg_data
723: );

Line 768: FND_MSG_PUB.Count_And_Get

764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get
769: ( p_encoded => 'F'
770: , p_count => x_msg_count
771: , p_data => x_msg_data
772: );

Line 778: FND_MSG_PUB.Count_And_Get

774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: IF (x_msg_data IS NULL) THEN
778: FND_MSG_PUB.Count_And_Get
779: ( p_encoded => 'F'
780: , p_count => x_msg_count
781: , p_data => x_msg_data
782: );

Line 829: FND_MSG_PUB.Count_And_Get

825:
826: EXCEPTION
827: WHEN FND_API.G_EXC_ERROR THEN
828: IF (x_msg_data IS NULL) THEN
829: FND_MSG_PUB.Count_And_Get
830: ( p_encoded => 'F'
831: , p_count => x_msg_count
832: , p_data => x_msg_data
833: );

Line 839: FND_MSG_PUB.Count_And_Get

835: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: IF (x_msg_data IS NULL) THEN
839: FND_MSG_PUB.Count_And_Get
840: ( p_encoded => 'F'
841: , p_count => x_msg_count
842: , p_data => x_msg_data
843: );

Line 1007: FND_MSG_PUB.Count_And_Get

1003: IF (c_dim_level%ISOPEN) THEN
1004: CLOSE c_dim_level;
1005: END IF;
1006: IF (x_msg_data IS NULL) THEN
1007: FND_MSG_PUB.Count_And_Get
1008: ( p_encoded => 'F'
1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );

Line 1023: FND_MSG_PUB.Count_And_Get

1019: IF (c_dim_level%ISOPEN) THEN
1020: CLOSE c_dim_level;
1021: END IF;
1022: IF (x_msg_data IS NULL) THEN
1023: FND_MSG_PUB.Count_And_Get
1024: ( p_encoded => 'F'
1025: , p_count => x_msg_count
1026: , p_data => x_msg_data
1027: );

Line 1099: FND_MSG_PUB.Initialize;

1095: l_dim_level_id NUMBER;
1096: l_dim_group_id NUMBER;
1097: BEGIN
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: FND_MSG_PUB.Initialize;
1100: IF (p_all_id NOT IN (0, -1)) THEN
1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ALL_ID');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;

Line 1102: FND_MSG_PUB.ADD;

1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: FND_MSG_PUB.Initialize;
1100: IF (p_all_id NOT IN (0, -1)) THEN
1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ALL_ID');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: -- Dimension level short name in bsc_sys_dim_levels_b should be same as dimension
1106: -- level short name in bis_levels.

Line 1138: FND_MSG_PUB.Count_And_Get

1134:
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: IF (x_msg_data IS NULL) THEN
1138: FND_MSG_PUB.Count_And_Get
1139: ( p_encoded => 'F'
1140: , p_count => x_msg_count
1141: , p_data => x_msg_data
1142: );

Line 1148: FND_MSG_PUB.Count_And_Get

1144: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: IF (x_msg_data IS NULL) THEN
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_encoded => 'F'
1150: , p_count => x_msg_count
1151: , p_data => x_msg_data
1152: );

Line 1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1192: EXCEPTION
1193:
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1201: ,p_data => l_msg_data);
1202: raise;
1203: WHEN NO_DATA_FOUND THEN
1204: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1205: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1201: ,p_data => l_msg_data);
1202: raise;
1203: WHEN NO_DATA_FOUND THEN
1204: l_return_status := FND_API.G_RET_STS_ERROR;
1205: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1206: ,p_data => l_msg_data);
1207: raise;
1208: WHEN OTHERS THEN
1209: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1210: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1206: ,p_data => l_msg_data);
1207: raise;
1208: WHEN OTHERS THEN
1209: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1211: ,p_data => l_msg_data);
1212: raise;
1213: end Get_Next_Value;
1214:

Line 1257: FND_MSG_PUB.Count_And_Get(

1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => 'F'
1259: ,p_count => x_msg_count
1260: ,p_data => x_msg_data
1261: );

Line 1264: FND_MSG_PUB.Count_And_Get(

1260: ,p_data => x_msg_data
1261: );
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Count_And_Get(
1265: p_encoded => 'F'
1266: ,p_count => x_msg_count
1267: ,p_data => x_msg_data
1268: );

Line 1422: FND_MSG_PUB.Count_And_Get(

1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: FND_MSG_PUB.Count_And_Get(
1423: p_encoded => 'F'
1424: ,p_count => x_msg_count
1425: ,p_data => x_msg_data
1426: );

Line 1429: FND_MSG_PUB.Count_And_Get(

1425: ,p_data => x_msg_data
1426: );
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.Count_And_Get(
1430: p_encoded => 'F'
1431: ,p_count => x_msg_count
1432: ,p_data => x_msg_data
1433: );

Line 1513: FND_MSG_PUB.Count_And_Get

1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get
1514: ( p_encoded => 'F'
1515: , p_count => x_msg_count
1516: , p_data => x_msg_data
1517: );

Line 1520: FND_MSG_PUB.Count_And_Get

1516: , p_data => x_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_encoded => 'F'
1522: , p_count => x_msg_count
1523: , p_data => x_msg_data
1524: );

Line 1583: FND_MSG_PUB.Count_And_Get(

1579: IF (c_dim_grp_id%ISOPEN) THEN
1580: CLOSE c_dim_grp_id;
1581: END IF;
1582: x_return_status := FND_API.G_RET_STS_ERROR ;
1583: FND_MSG_PUB.Count_And_Get(
1584: p_encoded => 'F'
1585: ,p_count => x_msg_count
1586: ,p_data => x_msg_data
1587: );

Line 1593: FND_MSG_PUB.Count_And_Get(

1589: IF (c_dim_grp_id%ISOPEN) THEN
1590: CLOSE c_dim_grp_id;
1591: END IF;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: FND_MSG_PUB.Count_And_Get(
1594: p_encoded => 'F'
1595: ,p_count => x_msg_count
1596: ,p_data => x_msg_data
1597: );

Line 1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1636:
1637: EXCEPTION
1638: WHEN FND_API.G_EXC_ERROR THEN
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1645: ,p_data => x_msg_data);
1646: WHEN NO_DATA_FOUND THEN
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1645: ,p_data => x_msg_data);
1646: WHEN NO_DATA_FOUND THEN
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1649: ,p_data => x_msg_data);
1650: WHEN OTHERS THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1649: ,p_data => x_msg_data);
1650: WHEN OTHERS THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1653: ,p_data => x_msg_data);
1654: END Translate_Dim_By_Given_Lang;
1655:
1656: