1258:
1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN
1261:
1262: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1263: OE_MSG_PUB.Add;
1264:
1265: END IF;
1266:
1275:
1276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1277: THEN
1278:
1279: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1280: OE_MSG_PUB.Add;
1281:
1282: END IF;
1283: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1287:
1288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1289: THEN
1290:
1291: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1292: OE_MSG_PUB.Add;
1293:
1294: END IF;
1295: WHEN OTHERS THEN
1407:
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1413: OE_MSG_PUB.Add;
1414:
1415: END IF;
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1413: OE_MSG_PUB.Add;
1414:
1415: END IF;
1416:
1437:
1438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1439: THEN
1440:
1441: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');
1443: OE_MSG_PUB.Add;
1444:
1445: END IF;
1438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1439: THEN
1440:
1441: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');
1443: OE_MSG_PUB.Add;
1444:
1445: END IF;
1446:
1467:
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1469: THEN
1470:
1471: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1472: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');
1473: OE_MSG_PUB.Add;
1474:
1475: END IF;
1468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1469: THEN
1470:
1471: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1472: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');
1473: OE_MSG_PUB.Add;
1474:
1475: END IF;
1476:
1497:
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');
1503: OE_MSG_PUB.Add;
1504:
1505: END IF;
1498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');
1503: OE_MSG_PUB.Add;
1504:
1505: END IF;
1506:
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1529: THEN
1530:
1531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1533: OE_MSG_PUB.Add;
1534:
1535: END IF;
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1529: THEN
1530:
1531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
1533: OE_MSG_PUB.Add;
1534:
1535: END IF;
1536:
1574: p_action = 'DISABLE' THEN
1575:
1576: IF p_called_from_ui = 'Y' THEN
1577: l_msg_name := 'QP_WARN_DISABLE_FUNC_AREA_UI';
1578: FND_MESSAGE.set_name('QP', 'QP_' || p_action || 'D');
1579: ELSE
1580: l_msg_name := 'QP_WARN_DISABLE_FUNC_AREA_BOI' ;
1581: FND_MESSAGE.set_name('QP', 'QP_' || p_action || 'D');
1582: END IF;
1577: l_msg_name := 'QP_WARN_DISABLE_FUNC_AREA_UI';
1578: FND_MESSAGE.set_name('QP', 'QP_' || p_action || 'D');
1579: ELSE
1580: l_msg_name := 'QP_WARN_DISABLE_FUNC_AREA_BOI' ;
1581: FND_MESSAGE.set_name('QP', 'QP_' || p_action || 'D');
1582: END IF;
1583:
1584: l_action := fnd_message.get;
1585:
1580: l_msg_name := 'QP_WARN_DISABLE_FUNC_AREA_BOI' ;
1581: FND_MESSAGE.set_name('QP', 'QP_' || p_action || 'D');
1582: END IF;
1583:
1584: l_action := fnd_message.get;
1585:
1586: ELSE
1587: RETURN;
1588: END IF;
1599: from qp_fass_v
1600: where functional_area_id = p_functional_area_id;
1601:
1602: -- Add Message
1603: FND_MESSAGE.set_name('QP', l_msg_name);
1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1600: where functional_area_id = p_functional_area_id;
1601:
1602: -- Add Message
1603: FND_MESSAGE.set_name('QP', l_msg_name);
1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1608: OE_MSG_PUB.Add;
1601:
1602: -- Add Message
1603: FND_MESSAGE.set_name('QP', l_msg_name);
1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1608: OE_MSG_PUB.Add;
1609: END IF;
1602: -- Add Message
1603: FND_MESSAGE.set_name('QP', l_msg_name);
1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1608: OE_MSG_PUB.Add;
1609: END IF;
1610:
1603: FND_MESSAGE.set_name('QP', l_msg_name);
1604: FND_MESSAGE.set_token('ACTION', l_action);
1605: FND_MESSAGE.set_token('FNAREA', l_fna_desc);
1606: FND_MESSAGE.set_token('PTE', l_pte);
1607: FND_MESSAGE.set_token('SS', l_ss);
1608: OE_MSG_PUB.Add;
1609: END IF;
1610:
1611: END Warn_Disable_Delete_Fna;