DBA Data[Home] [Help]

APPS.BSC_LAUNCH_PAD_PUB dependencies on FND_MSG_PUB

Line 320: FND_MSG_PUB.Initialize;

316: l_root_menu_count NUMBER;
317:
318: BEGIN
319: SAVEPOINT AddLaunchPadRootMenu;
320: FND_MSG_PUB.Initialize;
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: get_All_Root_Menu(x_Root_Menu_Tbl => l_Root_Menu_Tbl);
324: l_root_menu_count :=0;

Line 346: FND_MSG_PUB.Count_And_Get

342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO AddLaunchPadRootMenu;
345: IF (x_msg_data IS NULL) THEN
346: FND_MSG_PUB.Count_And_Get
347: ( p_encoded => FND_API.G_FALSE
348: , p_count => x_msg_count
349: , p_data => x_msg_data
350: );

Line 357: FND_MSG_PUB.Count_And_Get

353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO AddLaunchPadRootMenu;
356: IF (x_msg_data IS NULL) THEN
357: FND_MSG_PUB.Count_And_Get
358: ( p_encoded => FND_API.G_FALSE
359: , p_count => x_msg_count
360: , p_data => x_msg_data
361: );

Line 432: FND_MSG_PUB.Initialize;

428:
429: BEGIN
430:
431: SAVEPOINT CreateLaunchPad;
432: FND_MSG_PUB.Initialize;
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: IF(p_user_menu_name IS NULL) THEN
436: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 438: FND_MSG_PUB.ADD;

434:
435: IF(p_user_menu_name IS NULL) THEN
436: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
437: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'NAME'), TRUE);
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: SELECT FND_MENUS_S.NEXTVAL

Line 462: FND_MSG_PUB.ADD;

458:
459: IF (l_check_val<>'T') THEN
460:
461: FND_MESSAGE.SET_NAME('BSC','BSC_D_NAME_EXIST');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464:
465: ELSE
466:

Line 529: FND_MSG_PUB.Count_And_Get

525: EXCEPTION
526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO CreateLaunchPad;
528: IF (x_msg_data IS NULL) THEN
529: FND_MSG_PUB.Count_And_Get
530: ( p_encoded => FND_API.G_FALSE
531: , p_count => x_msg_count
532: , p_data => x_msg_data
533: );

Line 541: FND_MSG_PUB.Count_And_Get

537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO CreateLaunchPad;
540: IF (x_msg_data IS NULL) THEN
541: FND_MSG_PUB.Count_And_Get
542: ( p_encoded => FND_API.G_FALSE
543: , p_count => x_msg_count
544: , p_data => x_msg_data
545: );

Line 593: FND_MSG_PUB.Initialize;

589: ,x_msg_data OUT NOCOPY VARCHAR2
590:
591: ) IS
592: BEGIN
593: FND_MSG_PUB.Initialize;
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: SELECT menu_id
597: ,menu_name

Line 659: FND_MSG_PUB.Initialize;

655: l_count NUMBER;
656:
657: BEGIN
658: SAVEPOINT UpdateLaunchPad;
659: FND_MSG_PUB.Initialize;
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: IF(p_launch_pad_rec.Bsc_menu_id IS NOT NULL) THEN
663:

Line 670: FND_MSG_PUB.ADD;

666:
667: IF(l_count =0) THEN
668: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
669: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_launch_pad_rec.Bsc_menu_id);
670: FND_MSG_PUB.ADD;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: ELSE

Line 677: FND_MSG_PUB.ADD;

673:
674: ELSE
675: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
676: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_launch_pad_rec.Bsc_menu_id);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: Retrieve_Launch_Pad

Line 725: FND_MSG_PUB.Count_And_Get

721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO UpdateLaunchPad;
724: IF (x_msg_data IS NULL) THEN
725: FND_MSG_PUB.Count_And_Get
726: ( p_encoded => FND_API.G_FALSE
727: , p_count => x_msg_count
728: , p_data => x_msg_data
729: );

Line 799: FND_MSG_PUB.Initialize;

795: l_menu_name FND_MENUS.menu_name%TYPE;
796: l_count NUMBER :=0;
797:
798: BEGIN
799: FND_MSG_PUB.Initialize;
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801:
802: l_menu_name := p_menu_name;
803:

Line 807: FND_MSG_PUB.ADD;

803:
804: IF(p_user_menu_name IS NULL) THEN
805: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
806: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'NAME'), TRUE);
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810:
811: IF(p_menu_id IS NOT NULL) THEN

Line 817: FND_MSG_PUB.ADD;

813: l_count := is_Menu_Id_Valid(p_menu_id);
814: IF(l_count =0) THEN
815: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
816: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
817: FND_MSG_PUB.ADD;
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;
820:
821: ELSE

Line 824: FND_MSG_PUB.ADD;

820:
821: ELSE
822: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
823: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
824: FND_MSG_PUB.ADD;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828:

Line 841: FND_MSG_PUB.ADD;

837: );
838:
839: IF (l_check_val<>'T') THEN
840: FND_MESSAGE.SET_NAME('BSC','BSC_D_NAME_EXIST');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: ELSE
844: l_launch_pad_rec.Bsc_menu_id := p_menu_id;
845: l_launch_pad_rec.Bsc_menu_name := l_menu_name;

Line 907: FND_MSG_PUB.Count_And_Get

903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905:
906: IF (x_msg_data IS NULL) THEN
907: FND_MSG_PUB.Count_And_Get
908: ( p_encoded => FND_API.G_FALSE
909: , p_count => x_msg_count
910: , p_data => x_msg_data
911: );

Line 919: FND_MSG_PUB.Count_And_Get

915:
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917:
918: IF (x_msg_data IS NULL) THEN
919: FND_MSG_PUB.Count_And_Get
920: ( p_encoded => FND_API.G_FALSE
921: , p_count => x_msg_count
922: , p_data => x_msg_data
923: );

Line 972: FND_MSG_PUB.Initialize;

968: l_entry_sequence FND_MENU_ENTRIES.Entry_Sequence%TYPE;
969:
970: BEGIN
971: SAVEPOINT DeleteRootMenuLaunchPad;
972: FND_MSG_PUB.Initialize;
973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975: get_All_Root_Menu(x_Root_Menu_Tbl => l_Root_Menu_Tbl);
976: l_root_menu_count :=0;

Line 995: FND_MSG_PUB.Count_And_Get

991:
992: WHEN FND_API.G_EXC_ERROR THEN
993: ROLLBACK TO DeleteRootMenuLaunchPad;
994: IF (x_msg_data IS NULL) THEN
995: FND_MSG_PUB.Count_And_Get
996: ( p_encoded => FND_API.G_FALSE
997: , p_count => x_msg_count
998: , p_data => x_msg_data
999: );

Line 1041: FND_MSG_PUB.Initialize;

1037: ) IS
1038: l_count NUMBER;
1039: BEGIN
1040: SAVEPOINT DelteLaunchPad;
1041: FND_MSG_PUB.Initialize;
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043:
1044: IF(p_menu_id IS NOT NULL) THEN
1045:

Line 1052: FND_MSG_PUB.ADD;

1048:
1049: IF(l_count =0) THEN
1050: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1051: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055:
1056: ELSE

Line 1060: FND_MSG_PUB.ADD;

1056: ELSE
1057:
1058: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1059: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
1060: FND_MSG_PUB.ADD;
1061: RAISE FND_API.G_EXC_ERROR;
1062:
1063: END IF;
1064:

Line 1103: FND_MSG_PUB.Count_And_Get

1099: WHEN FND_API.G_EXC_ERROR THEN
1100:
1101: ROLLBACK TO DelteLaunchPad;
1102: IF (x_msg_data IS NULL) THEN
1103: FND_MSG_PUB.Count_And_Get
1104: ( p_encoded => FND_API.G_FALSE
1105: , p_count => x_msg_count
1106: , p_data => x_msg_data
1107: );

Line 1155: FND_MSG_PUB.Initialize;

1151: AND LABEL_TYPE =2;
1152:
1153: BEGIN
1154: SAVEPOINT deletelaunchpadlinks;
1155: FND_MSG_PUB.Initialize;
1156: x_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: IF(p_menu_id IS NULL) THEN
1159: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');

Line 1161: FND_MSG_PUB.ADD;

1157:
1158: IF(p_menu_id IS NULL) THEN
1159: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1160: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
1161: FND_MSG_PUB.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164:
1165: FOR cd IN c_Launch_Pad_Links LOOP

Line 1187: FND_MSG_PUB.Count_And_Get

1183: END IF;
1184:
1185: ROLLBACK TO deletelaunchpadlinks;
1186: IF (x_msg_data IS NULL) THEN
1187: FND_MSG_PUB.Count_And_Get
1188: ( p_encoded => FND_API.G_FALSE
1189: , p_count => x_msg_count
1190: , p_data => x_msg_data
1191: );

Line 1242: FND_MSG_PUB.Initialize;

1238: FROM FND_MENU_ENTRIES
1239: WHERE menu_id = p_menu_id;
1240: BEGIN
1241: SAVEPOINT deletemenufunctionlink;
1242: FND_MSG_PUB.Initialize;
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: IF(p_menu_id IS NULL) THEN
1246: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');

Line 1248: FND_MSG_PUB.ADD;

1244:
1245: IF(p_menu_id IS NULL) THEN
1246: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1247: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252:

Line 1275: FND_MSG_PUB.Count_And_Get

1271: END IF;
1272:
1273: ROLLBACK TO deletemenufunctionlink;
1274: IF (x_msg_data IS NULL) THEN
1275: FND_MSG_PUB.Count_And_Get
1276: ( p_encoded => FND_API.G_FALSE
1277: , p_count => x_msg_count
1278: , p_data => x_msg_data
1279: );

Line 1327: FND_MSG_PUB.Initialize;

1323: ) IS
1324: row_id VARCHAR2(30);
1325: l_user_id NUMBER ;
1326: BEGIN
1327: FND_MSG_PUB.Initialize;
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:
1330: IF(p_menu_id IS NULL) THEN
1331: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');

Line 1333: FND_MSG_PUB.ADD;

1329:
1330: IF(p_menu_id IS NULL) THEN
1331: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1332: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_menu_id);
1333: FND_MSG_PUB.ADD;
1334: RAISE FND_API.G_EXC_ERROR;
1335: END IF;
1336:
1337: IF (p_entry_sequence IS NULL) THEN

Line 1339: FND_MSG_PUB.ADD;

1335: END IF;
1336:
1337: IF (p_entry_sequence IS NULL) THEN
1338: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ENTRY_SEQUENCE');
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;
1341: END IF;
1342:
1343: l_user_id := get_User_Id;

Line 1364: FND_MSG_PUB.Count_And_Get

1360:
1361: EXCEPTION
1362: WHEN FND_API.G_EXC_ERROR THEN
1363: IF (x_msg_data IS NULL) THEN
1364: FND_MSG_PUB.Count_And_Get
1365: ( p_encoded => FND_API.G_FALSE
1366: , p_count => x_msg_count
1367: , p_data => x_msg_data
1368: );

Line 1422: FND_MSG_PUB.Initialize;

1418: l_user_id NUMBER := NULL;
1419: row_id VARCHAR2(30);
1420: l_url FND_FORM_FUNCTIONS.web_host_name%TYPE;
1421: BEGIN
1422: FND_MSG_PUB.Initialize;
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:
1425: IF (p_user_function_name IS NULL) THEN
1426: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 1428: FND_MSG_PUB.ADD;

1424:
1425: IF (p_user_function_name IS NULL) THEN
1426: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1427: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'FUCNTION_NAME'), TRUE);
1428: FND_MSG_PUB.ADD;
1429: RAISE FND_API.G_EXC_ERROR;
1430: END IF;
1431:
1432:

Line 1478: FND_MSG_PUB.Count_And_Get

1474: EXCEPTION
1475:
1476: WHEN FND_API.G_EXC_ERROR THEN
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 1533: FND_MSG_PUB.Initialize;

1529: l_count NUMBER;
1530:
1531: BEGIN
1532: SAVEPOINT deletelauchpadlink;
1533: FND_MSG_PUB.Initialize;
1534: x_return_status := FND_API.G_RET_STS_SUCCESS;
1535:
1536: IF(p_fucntion_id IS NOT NULL) THEN
1537:

Line 1547: FND_MSG_PUB.ADD;

1543:
1544: IF(l_count =0) THEN
1545: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1546: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_fucntion_id);
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: ELSE

Line 1555: FND_MSG_PUB.ADD;

1551: ELSE
1552:
1553: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');
1554: FND_MESSAGE.SET_TOKEN('BSC_MENU', p_fucntion_id);
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557:
1558: END IF;
1559:

Line 1589: FND_MSG_PUB.Count_And_Get

1585: END IF;
1586:
1587: ROLLBACK TO deletelauchpadlink;
1588: IF (x_msg_data IS NULL) THEN
1589: FND_MSG_PUB.Count_And_Get
1590: ( p_encoded => FND_API.G_FALSE
1591: , p_count => x_msg_count
1592: , p_data => x_msg_data
1593: );

Line 1643: FND_MSG_PUB.Initialize;

1639:
1640: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1641:
1642: BEGIN
1643: FND_MSG_PUB.Initialize;
1644: x_return_status := FND_API.G_RET_STS_SUCCESS;
1645:
1646: IF (p_user_function_name IS NULL) THEN
1647: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 1649: FND_MSG_PUB.ADD;

1645:
1646: IF (p_user_function_name IS NULL) THEN
1647: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1648: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'FUCNTION_NAME'), TRUE);
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: IF (p_user_function_name IS NULL) THEN

Line 1656: FND_MSG_PUB.ADD;

1652:
1653: IF (p_user_function_name IS NULL) THEN
1654: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1655: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ADD_URL'), TRUE);
1656: FND_MSG_PUB.ADD;
1657: RAISE FND_API.G_EXC_ERROR;
1658: END IF;
1659:
1660: l_function_name := get_Form_Function_Name(p_function_id);

Line 1693: FND_MSG_PUB.Count_And_Get

1689: EXCEPTION
1690:
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: IF (x_msg_data IS NULL) THEN
1693: FND_MSG_PUB.Count_And_Get
1694: ( p_encoded => FND_API.G_FALSE
1695: , p_count => x_msg_count
1696: , p_data => x_msg_data
1697: );