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');
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;
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');
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:
457: );
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
664: -- Bug #3236356
665: l_count := is_Menu_Id_Valid(p_launch_pad_rec.Bsc_menu_id);
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;
665: l_count := is_Menu_Id_Valid(p_launch_pad_rec.Bsc_menu_id);
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:
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
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;
672: END IF;
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:
801:
802: l_menu_name := p_menu_name;
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;
802: l_menu_name := p_menu_name;
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
812: -- Bug #3236356
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;
812: -- Bug #3236356
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:
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;
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;
819: END IF;
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:
836: ,p_user_menu_name => UPPER(p_user_menu_name)
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;
1046: -- Bug #3236356
1047: l_count := is_Menu_Id_Valid(p_menu_id);
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;
1047: l_count := is_Menu_Id_Valid(p_menu_id);
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:
1054: END IF;
1055:
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:
1055:
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;
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');
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;
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');
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:
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');
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;
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');
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:
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');
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;
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');
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:
1334: RAISE FND_API.G_EXC_ERROR;
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:
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');
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;
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');
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:
1541: FROM FND_FORM_FUNCTIONS_TL
1542: WHERE FUNCTION_ID = p_fucntion_id;
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;
1542: WHERE FUNCTION_ID = p_fucntion_id;
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:
1549: END IF;
1550:
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:
1550:
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;
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');
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;
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');
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:
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
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;
1651: END IF;
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: