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.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_API

Line 888: p_init_msg_list in varchar2 := FND_API.G_FALSE,

884: */
885: FUNCTION Create_Set_With_Validation
886: (
887: p_api_version in number,
888: p_init_msg_list in varchar2 := FND_API.G_FALSE,
889: p_commit in varchar2 := FND_API.G_FALSE,
890: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY varchar2,
892: x_msg_count OUT NOCOPY number,

Line 889: p_commit in varchar2 := FND_API.G_FALSE,

885: FUNCTION Create_Set_With_Validation
886: (
887: p_api_version in number,
888: p_init_msg_list in varchar2 := FND_API.G_FALSE,
889: p_commit in varchar2 := FND_API.G_FALSE,
890: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY varchar2,
892: x_msg_count OUT NOCOPY number,
893: x_msg_data OUT NOCOPY varchar2,

Line 890: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

886: (
887: p_api_version in number,
888: p_init_msg_list in varchar2 := FND_API.G_FALSE,
889: p_commit in varchar2 := FND_API.G_FALSE,
890: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY varchar2,
892: x_msg_count OUT NOCOPY number,
893: x_msg_data OUT NOCOPY varchar2,
894: p_set_type_name in varchar2,

Line 954: p_init_msg_list in varchar2 := FND_API.G_FALSE,

950:
951: FUNCTION Create_Set_With_Validation_2
952: (
953: p_api_version in number,
954: p_init_msg_list in varchar2 := FND_API.G_FALSE,
955: p_commit in varchar2 := FND_API.G_FALSE,
956: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
957: x_return_status OUT NOCOPY varchar2,
958: x_msg_count OUT NOCOPY number,

Line 955: p_commit in varchar2 := FND_API.G_FALSE,

951: FUNCTION Create_Set_With_Validation_2
952: (
953: p_api_version in number,
954: p_init_msg_list in varchar2 := FND_API.G_FALSE,
955: p_commit in varchar2 := FND_API.G_FALSE,
956: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
957: x_return_status OUT NOCOPY varchar2,
958: x_msg_count OUT NOCOPY number,
959: x_msg_data OUT NOCOPY varchar2,

Line 956: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

952: (
953: p_api_version in number,
954: p_init_msg_list in varchar2 := FND_API.G_FALSE,
955: p_commit in varchar2 := FND_API.G_FALSE,
956: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
957: x_return_status OUT NOCOPY varchar2,
958: x_msg_count OUT NOCOPY number,
959: x_msg_data OUT NOCOPY varchar2,
960: p_set_type_name in varchar2,

Line 1045: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1041: */
1042: FUNCTION Update_Set_With_Validation
1043: (
1044: p_api_version in number,
1045: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1046: p_commit in varchar2 := FND_API.G_FALSE,
1047: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1048: x_return_status OUT NOCOPY varchar2,
1049: x_msg_count OUT NOCOPY number,

Line 1046: p_commit in varchar2 := FND_API.G_FALSE,

1042: FUNCTION Update_Set_With_Validation
1043: (
1044: p_api_version in number,
1045: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1046: p_commit in varchar2 := FND_API.G_FALSE,
1047: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1048: x_return_status OUT NOCOPY varchar2,
1049: x_msg_count OUT NOCOPY number,
1050: x_msg_data OUT NOCOPY varchar2,

Line 1047: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1043: (
1044: p_api_version in number,
1045: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1046: p_commit in varchar2 := FND_API.G_FALSE,
1047: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1048: x_return_status OUT NOCOPY varchar2,
1049: x_msg_count OUT NOCOPY number,
1050: x_msg_data OUT NOCOPY varchar2,
1051: p_set_number in varchar2,

Line 1111: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1107: */
1108: FUNCTION Update_Set_With_Validation_2
1109: (
1110: p_api_version in number,
1111: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1112: p_commit in varchar2 := FND_API.G_FALSE,
1113: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1114: x_return_status OUT NOCOPY varchar2,
1115: x_msg_count OUT NOCOPY number,

Line 1112: p_commit in varchar2 := FND_API.G_FALSE,

1108: FUNCTION Update_Set_With_Validation_2
1109: (
1110: p_api_version in number,
1111: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1112: p_commit in varchar2 := FND_API.G_FALSE,
1113: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1114: x_return_status OUT NOCOPY varchar2,
1115: x_msg_count OUT NOCOPY number,
1116: x_msg_data OUT NOCOPY varchar2,

Line 1113: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1109: (
1110: p_api_version in number,
1111: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1112: p_commit in varchar2 := FND_API.G_FALSE,
1113: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1114: x_return_status OUT NOCOPY varchar2,
1115: x_msg_count OUT NOCOPY number,
1116: x_msg_data OUT NOCOPY varchar2,
1117: p_set_number in varchar2,

Line 1342: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1338: */
1339: FUNCTION Create_Set_With_Validation_3
1340: (
1341: p_api_version in number,
1342: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1343: p_commit in varchar2 := FND_API.G_FALSE,
1344: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1345: x_return_status OUT NOCOPY varchar2,
1346: x_msg_count OUT NOCOPY number,

Line 1343: p_commit in varchar2 := FND_API.G_FALSE,

1339: FUNCTION Create_Set_With_Validation_3
1340: (
1341: p_api_version in number,
1342: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1343: p_commit in varchar2 := FND_API.G_FALSE,
1344: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1345: x_return_status OUT NOCOPY varchar2,
1346: x_msg_count OUT NOCOPY number,
1347: x_msg_data OUT NOCOPY varchar2,

Line 1344: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1340: (
1341: p_api_version in number,
1342: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1343: p_commit in varchar2 := FND_API.G_FALSE,
1344: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1345: x_return_status OUT NOCOPY varchar2,
1346: x_msg_count OUT NOCOPY number,
1347: x_msg_data OUT NOCOPY varchar2,
1348: p_set_type_name in varchar2,

Line 1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: -- Validate Set Type Name, get Set Type ID
1420: l_validate_buf := p_set_type_name;
1421: l_return_val := Validate_Set_Type_Name_Create(p_set_type_name,

Line 1491: if( (l_return_status = FND_API.G_RET_STS_ERROR) or

1487: x_msg_data => l_msg_data,
1488: x_msg_count => l_msg_count );
1489:
1490: -- dbms_output.put_line('created x_set_id='||l_set_id);
1491: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1492: (l_set_id <= 0) ) then
1493: raise FND_API.G_EXC_ERROR;
1494: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1493: raise FND_API.G_EXC_ERROR;

1489:
1490: -- dbms_output.put_line('created x_set_id='||l_set_id);
1491: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1492: (l_set_id <= 0) ) then
1493: raise FND_API.G_EXC_ERROR;
1494: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: end if;
1497:

Line 1494: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

1490: -- dbms_output.put_line('created x_set_id='||l_set_id);
1491: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1492: (l_set_id <= 0) ) then
1493: raise FND_API.G_EXC_ERROR;
1494: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: end if;
1497:
1498: -- link set with statements, products, categories, platforms, etc.

Line 1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1491: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1492: (l_set_id <= 0) ) then
1493: raise FND_API.G_EXC_ERROR;
1494: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: end if;
1497:
1498: -- link set with statements, products, categories, platforms, etc.
1499: -- also create new statements if info provided

Line 1537: x_return_status := fnd_api.g_ret_sts_success;

1533: END IF;
1534:
1535: -- dbms_output.put_line('return from LINK='||l_return_val);
1536:
1537: x_return_status := fnd_api.g_ret_sts_success;
1538: x_msg_count := 0;
1539: x_msg_data := null;
1540: RETURN OKAY_STATUS;
1541:

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: EXCEPTION
1543:
1544: WHEN VALIDATION_ERROR THEN
1545: /*
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: x_msg_count := 1;
1548: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1549: */
1550:

Line 1555: x_return_status := FND_API.G_RET_STS_ERROR;

1551: RETURN ERROR_STATUS;
1552:
1553: WHEN MANDATORY_STATEMENT_MISSING THEN
1554: ROLLBACK TO Create_Set;
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: x_msg_count := 1;
1557: x_msg_data := 'Mandatory Statements Missing.';
1558:
1559: RETURN ERROR_STATUS;

Line 1563: x_return_status := FND_API.G_RET_STS_ERROR;

1559: RETURN ERROR_STATUS;
1560:
1561: WHEN INVALID_SET_TYPE_NAME THEN
1562: ROLLBACK TO Create_Set;
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: x_msg_count := 1;
1565: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1566:
1567: RETURN ERROR_STATUS;

Line 1571: x_return_status := FND_API.G_RET_STS_ERROR;

1567: RETURN ERROR_STATUS;
1568:
1569: WHEN INVALID_FLOW THEN
1570: ROLLBACK TO Create_Set;
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: x_msg_count := 1;
1573: x_msg_data := 'Invalid flow: ' || p_set_flow_name ||
1574: ' or step: ' || p_set_flow_stepcode;
1575:

Line 1580: x_return_status := FND_API.G_RET_STS_ERROR;

1576: RETURN ERROR_STATUS;
1577:
1578: WHEN DUPLICATE_SET_NAME THEN
1579: ROLLBACK TO Create_Set;
1580: x_return_status := FND_API.G_RET_STS_ERROR;
1581: x_msg_count := 1;
1582: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1583:
1584: RETURN ERROR_STATUS;

Line 1586: WHEN FND_API.G_EXC_ERROR THEN

1582: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1583:
1584: RETURN ERROR_STATUS;
1585:
1586: WHEN FND_API.G_EXC_ERROR THEN
1587: ROLLBACK TO Create_Set;
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: FND_MSG_PUB.Count_And_Get(
1590: p_encoded => FND_API.G_FALSE,

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR ;

1584: RETURN ERROR_STATUS;
1585:
1586: WHEN FND_API.G_EXC_ERROR THEN
1587: ROLLBACK TO Create_Set;
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
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);

Line 1590: p_encoded => FND_API.G_FALSE,

1586: WHEN FND_API.G_EXC_ERROR THEN
1587: ROLLBACK TO Create_Set;
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
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: RETURN ERROR_STATUS;
1594:

Line 1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1591: p_count => x_msg_count,
1592: p_data => x_msg_data);
1593: RETURN ERROR_STATUS;
1594:
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1598: FND_MSG_PUB.Count_And_Get(
1599: p_encoded => FND_API.G_FALSE ,

Line 1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1593: RETURN ERROR_STATUS;
1594:
1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1598: FND_MSG_PUB.Count_And_Get(
1599: p_encoded => FND_API.G_FALSE ,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data);

Line 1599: p_encoded => FND_API.G_FALSE ,

1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1598: FND_MSG_PUB.Count_And_Get(
1599: p_encoded => FND_API.G_FALSE ,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602: RETURN ERROR_STATUS;
1603:

Line 1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1603:
1604: WHEN OTHERS THEN
1605: ROLLBACK TO Create_Set;
1606: x_msg_data := 'Creating solution: ' || SQLERRM ;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1608: x_msg_count := 1;
1609: RETURN ERROR_STATUS;
1610:
1611: END Create_Set_With_Validation_3;

Line 1619: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1615: */
1616: FUNCTION Update_Set_With_Validation_3
1617: (
1618: p_api_version in number,
1619: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1620: p_commit in varchar2 := FND_API.G_FALSE,
1621: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1622: x_return_status OUT NOCOPY varchar2,
1623: x_msg_count OUT NOCOPY number,

Line 1620: p_commit in varchar2 := FND_API.G_FALSE,

1616: FUNCTION Update_Set_With_Validation_3
1617: (
1618: p_api_version in number,
1619: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1620: p_commit in varchar2 := FND_API.G_FALSE,
1621: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1622: x_return_status OUT NOCOPY varchar2,
1623: x_msg_count OUT NOCOPY number,
1624: x_msg_data OUT NOCOPY varchar2,

Line 1621: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1617: (
1618: p_api_version in number,
1619: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1620: p_commit in varchar2 := FND_API.G_FALSE,
1621: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1622: x_return_status OUT NOCOPY varchar2,
1623: x_msg_count OUT NOCOPY number,
1624: x_msg_data OUT NOCOPY varchar2,
1625: p_set_number in varchar2,

Line 1724: x_return_status := FND_API.G_RET_STS_SUCCESS;

1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1722: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- dbms_output.put_line('Validate Set number');
1727: -- Validate Set number, get Set ID
1728: l_validate_buf := p_set_number;

Line 1820: if( (l_return_status = FND_API.G_RET_STS_ERROR) or

1816: p_attribute15 => null
1817: );
1818:
1819: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1820: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1821: (x_set_id <= 0) ) then
1822: raise FND_API.G_EXC_ERROR;
1823: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1822: raise FND_API.G_EXC_ERROR;

1818:
1819: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1820: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1821: (x_set_id <= 0) ) then
1822: raise FND_API.G_EXC_ERROR;
1823: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1825: end if;
1826:

Line 1823: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

1819: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1820: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1821: (x_set_id <= 0) ) then
1822: raise FND_API.G_EXC_ERROR;
1823: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1825: end if;
1826:
1827: -- dbms_output.put_line('updated soln.');

Line 1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1820: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1821: (x_set_id <= 0) ) then
1822: raise FND_API.G_EXC_ERROR;
1823: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1825: end if;
1826:
1827: -- dbms_output.put_line('updated soln.');
1828:

Line 1836: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1832: p_element_id => cur_row.element_id,
1833: p_set_id => x_set_id
1834: );
1835: if (l_return_val < 0) then
1836: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1837: end if;
1838: END LOOP;
1839: -- dbms_output.put_line('unlinked element ids. ');
1840:

Line 1858: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1854: p_task => 0,
1855: p_result => l_return_val);
1856:
1857: if (l_return_val < 0) then
1858: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1859: end if;
1860: -- dbms_output.put_line('unlinked products. ');
1861:
1862: -- unlink all platforms

Line 1880: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1876: p_task => 0,
1877: p_result => l_return_val);
1878:
1879: if (l_return_val < 0) then
1880: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1881: end if;
1882: -- dbms_output.put_line('unlinked platforms. ');
1883:
1884: -- unlink categories

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939: RETURN ERROR_STATUS;
1940:
1941: WHEN MANDATORY_STATEMENT_MISSING THEN
1942: ROLLBACK TO Update_Set;
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: x_msg_count := 1;
1945: x_msg_data := 'Mandatory Statements Missing.';
1946:
1947: RETURN ERROR_STATUS;

Line 1951: x_return_status := FND_API.G_RET_STS_ERROR;

1947: RETURN ERROR_STATUS;
1948:
1949: WHEN INVALID_SET_NUMBER THEN
1950: ROLLBACK TO Update_Set;
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: x_msg_count := 1;
1953: x_msg_data := 'Invalid Solution Number: ' || p_set_number || '. Solutions to be updated should be valid and PUBLISHED.' ;
1954:
1955: RETURN ERROR_STATUS;

Line 1959: x_return_status := FND_API.G_RET_STS_ERROR;

1955: RETURN ERROR_STATUS;
1956:
1957: WHEN INVALID_SET_TYPE_NAME THEN
1958: ROLLBACK TO Update_Set;
1959: x_return_status := FND_API.G_RET_STS_ERROR;
1960: x_msg_count := 1;
1961: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1962:
1963: RETURN ERROR_STATUS;

Line 1967: x_return_status := FND_API.G_RET_STS_ERROR;

1963: RETURN ERROR_STATUS;
1964:
1965: WHEN DUPLICATE_SET_NAME THEN
1966: ROLLBACK TO Update_Set;
1967: x_return_status := FND_API.G_RET_STS_ERROR;
1968: x_msg_count := 1;
1969: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1970:
1971: RETURN ERROR_STATUS;

Line 1973: WHEN FND_API.G_EXC_ERROR THEN

1969: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1970:
1971: RETURN ERROR_STATUS;
1972:
1973: WHEN FND_API.G_EXC_ERROR THEN
1974: ROLLBACK TO Create_Set;
1975: x_return_status := FND_API.G_RET_STS_ERROR ;
1976: FND_MSG_PUB.Count_And_Get(
1977: p_encoded => FND_API.G_FALSE,

Line 1975: x_return_status := FND_API.G_RET_STS_ERROR ;

1971: RETURN ERROR_STATUS;
1972:
1973: WHEN FND_API.G_EXC_ERROR THEN
1974: ROLLBACK TO Create_Set;
1975: x_return_status := FND_API.G_RET_STS_ERROR ;
1976: FND_MSG_PUB.Count_And_Get(
1977: p_encoded => FND_API.G_FALSE,
1978: p_count => x_msg_count,
1979: p_data => x_msg_data);

Line 1977: p_encoded => FND_API.G_FALSE,

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

Line 1982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1978: p_count => x_msg_count,
1979: p_data => x_msg_data);
1980: RETURN ERROR_STATUS;
1981:
1982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1983: ROLLBACK TO Update_Set;
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,

Line 1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1980: RETURN ERROR_STATUS;
1981:
1982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1983: ROLLBACK TO Update_Set;
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);

Line 1986: p_encoded => FND_API.G_FALSE,

1982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1983: ROLLBACK TO Update_Set;
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989: RETURN ERROR_STATUS;
1990:

Line 1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1990:
1991: WHEN OTHERS THEN
1992: ROLLBACK TO Update_Set;
1993: x_msg_data := 'Update Solution: ' || SQLERRM ;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1995: x_msg_count := 0;
1996: RETURN ERROR_STATUS;
1997:
1998: END Update_Set_With_validation_3;

Line 2065: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2061: -- Validate Solution Visibility Level Name, get ID
2062: l_validate_buf := p_visibility_name;
2063: l_return_status := Validate_Visibility_Level( p_visibility_name,
2064: x_visibility_id );
2065: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2066: RAISE INVALID_VISIBILITY_LEVEL;
2067: END IF;
2068:
2069:

Line 2267: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2263: END IF;
2264:
2265: end loop;
2266:
2267: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2268: return OKAY_STATUS;
2269: EXCEPTION
2270: WHEN INVALID_VISIBILITY_LEVEL THEN
2271: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2271: x_return_status := FND_API.G_RET_STS_ERROR;

2267: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2268: return OKAY_STATUS;
2269: EXCEPTION
2270: WHEN INVALID_VISIBILITY_LEVEL THEN
2271: x_return_status := FND_API.G_RET_STS_ERROR;
2272: x_msg_count := 1;
2273: x_msg_data := ' Invalid Visibility Name: ' || l_validate_buf;
2274:
2275: RETURN ERROR_STATUS;

Line 2278: x_return_status := FND_API.G_RET_STS_ERROR;

2274:
2275: RETURN ERROR_STATUS;
2276:
2277: WHEN INVALID_ACCESS_LEVEL THEN
2278: x_return_status := FND_API.G_RET_STS_ERROR;
2279: x_msg_count := 1;
2280: x_msg_data := ' Invalid Distribution Name: ' || l_validate_buf;
2281:
2282: RETURN ERROR_STATUS;

Line 2285: x_return_status := FND_API.G_RET_STS_ERROR;

2281:
2282: RETURN ERROR_STATUS;
2283:
2284: WHEN INVALID_ELEMENT_TYPE_NAME THEN
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286: x_msg_count := 1;
2287: x_msg_data := 'Invalid Element Type Name: ' || l_validate_buf;
2288:
2289: RETURN ERROR_STATUS;

Line 2292: x_return_status := FND_API.G_RET_STS_ERROR;

2288:
2289: RETURN ERROR_STATUS;
2290:
2291: WHEN INVALID_ELEMENT_TYPE THEN
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: x_msg_count := 1;
2294: x_msg_data := 'Invalid Element Type ID for Element Number: ' || l_validate_buf;
2295:
2296: RETURN ERROR_STATUS;

Line 2299: x_return_status := FND_API.G_RET_STS_ERROR;

2295:
2296: RETURN ERROR_STATUS;
2297:
2298: WHEN INVALID_SET_ELEMENT_TYPE_MAP THEN
2299: x_return_status := FND_API.G_RET_STS_ERROR;
2300: x_msg_count := 1;
2301: x_msg_data := 'Invalid Set Element Type Mapping: ' || l_validate_buf;
2302:
2303: RETURN ERROR_STATUS;

Line 2306: x_return_status := FND_API.G_RET_STS_ERROR;

2302:
2303: RETURN ERROR_STATUS;
2304:
2305: WHEN INVALID_ELEMENT_CONTENT_TYPE THEN
2306: x_return_status := FND_API.G_RET_STS_ERROR;
2307: x_msg_count := 1;
2308: x_msg_data := 'Invalid Element Content Type: ' || l_validate_buf;
2309:
2310: RETURN ERROR_STATUS;

Line 2313: x_return_status := FND_API.G_RET_STS_ERROR;

2309:
2310: RETURN ERROR_STATUS;
2311:
2312: WHEN INVALID_ELEMENT_NUMBER THEN
2313: x_return_status := FND_API.G_RET_STS_ERROR;
2314: x_msg_count := 1;
2315: x_msg_data := 'This Statement No is invalid or in DRAFT status: ' || l_validate_buf;
2316:
2317: RETURN ERROR_STATUS;

Line 2320: x_return_status := FND_API.G_RET_STS_ERROR;

2316:
2317: RETURN ERROR_STATUS;
2318:
2319: WHEN INVALID_PRODUCT_NAME THEN
2320: x_return_status := FND_API.G_RET_STS_ERROR;
2321: x_msg_count := 1;
2322: x_msg_data := 'Product Name is invalid: ' || l_validate_buf;
2323:
2324: RETURN ERROR_STATUS;

Line 2327: x_return_status := FND_API.G_RET_STS_ERROR;

2323:
2324: RETURN ERROR_STATUS;
2325:
2326: WHEN INVALID_PRODUCT_SEGMENT THEN
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: x_msg_count := 1;
2329: x_msg_data := 'Product Segment is invalid: ' || l_validate_buf;
2330:
2331: RETURN ERROR_STATUS;

Line 2334: x_return_status := FND_API.G_RET_STS_ERROR;

2330:
2331: RETURN ERROR_STATUS;
2332:
2333: WHEN INVALID_PLATFORM_NAME THEN
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: x_msg_count := 1;
2336: x_msg_data := 'Platform Name is Invalid: ' || l_validate_buf;
2337:
2338: RETURN ERROR_STATUS;

Line 2341: x_return_status := FND_API.G_RET_STS_ERROR;

2337:
2338: RETURN ERROR_STATUS;
2339:
2340: WHEN INVALID_PLATFORM_SEGMENT THEN
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342: x_msg_count := 1;
2343: x_msg_data := 'Platform Segment is Invalid: ' || l_validate_buf;
2344:
2345: RETURN ERROR_STATUS;

Line 2348: x_return_status := FND_API.G_RET_STS_ERROR;

2344:
2345: RETURN ERROR_STATUS;
2346:
2347: WHEN MANDATORY_CATEGORY_MISSING THEN
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: x_msg_count := 1;
2350: x_msg_data := 'Mandatory category missing. Solution must belong to at least one category.';
2351:
2352: RETURN ERROR_STATUS;

Line 2355: x_return_status := FND_API.G_RET_STS_ERROR;

2351:
2352: RETURN ERROR_STATUS;
2353:
2354: WHEN INVALID_CATEGORY_NAME THEN
2355: x_return_status := FND_API.G_RET_STS_ERROR;
2356: x_msg_count := 1;
2357: x_msg_data := 'Category Name is Invalid:' || l_validate_buf;
2358:
2359: RETURN ERROR_STATUS;

Line 2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2359: RETURN ERROR_STATUS;
2360:
2361: WHEN OTHERS THEN
2362: x_msg_data := 'ERROR in validating solution attributes: ' || SQLERRM ;
2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2364: x_msg_count := 0;
2365: RETURN ERROR_STATUS;
2366:
2367: END VALIDATE_SOLN_ATTRIBUTES_3;

Line 2432: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2428: l_validate_buf := p_element_summaries(i);
2429: raise DUPLICATE_ELEMENT_NAME;
2430: -- should should get existing ID and link
2431: ELSIF (not x_created_element_ids(i) > 0) then
2432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2433: end if;
2434: end loop;
2435:
2436: -- link The Created element ids to set id;

Line 2446: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2442: p_element_number => l_temp_element_no,
2443: p_set_id => p_set_id);
2444:
2445: if (l_return_val = ERROR_STATUS) THEN
2446: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2447: end if;
2448: end loop;
2449:
2450: -- link The provided element ids to set id;

Line 2459: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2455: p_element_number => l_temp_element_no,
2456: p_set_id => p_set_id);
2457:
2458: if (l_return_val = ERROR_STATUS) THEN
2459: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2460: end if;
2461: end loop;
2462:
2463: -- global updating given elements

Line 2476: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2472: p_content_type => p_given_ele_content_types(i),
2473: p_status => 'PUBLISHED');
2474:
2475: IF (l_temp_update_return < 0) then
2476: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2477: end if;
2478:
2479: -- Mark the text indexes for the updated statement
2480: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(p_given_element_ids(i));

Line 2544: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2540: p_category_id => p_set_category_ids(i),
2541: x_soln_category_link_id => l_temp_category_link_id
2542: );
2543:
2544: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2545: raise CATEGORY_LINK_ERROR;
2546: end if;
2547: end loop;
2548:

Line 2558: x_return_status := FND_API.G_RET_STS_ERROR;

2554: ROLLBACK TO Create_Set;
2555: ELSIF (p_validate_type = 'UPDATE') THEN
2556: ROLLBACK TO Update_Set;
2557: END IF;
2558: x_return_status := FND_API.G_RET_STS_ERROR;
2559: x_msg_count := 1;
2560: x_msg_data := 'Unable to link to Product' ;
2561:
2562: RETURN ERROR_STATUS;

Line 2571: x_return_status := FND_API.G_RET_STS_ERROR;

2567: ELSIF (p_validate_type = 'UPDATE') THEN
2568: ROLLBACK TO Update_Set;
2569: END IF;
2570:
2571: x_return_status := FND_API.G_RET_STS_ERROR;
2572: x_msg_count := 1;
2573: x_msg_data := 'Unable to link to Platform' ;
2574:
2575: RETURN ERROR_STATUS;

Line 2584: x_return_status := FND_API.G_RET_STS_ERROR;

2580: ELSIF (p_validate_type = 'UPDATE') THEN
2581: ROLLBACK TO Update_Set;
2582: END IF;
2583:
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585: x_msg_count := 1;
2586: x_msg_data := 'Unable to link to Category' ;
2587: RETURN ERROR_STATUS;
2588:

Line 2596: x_return_status := FND_API.G_RET_STS_ERROR;

2592: ELSIF (p_validate_type = 'UPDATE') THEN
2593: ROLLBACK TO Update_Set;
2594: END IF;
2595:
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: x_msg_count := 1;
2598: x_msg_data := 'Error while linking to statement:' || l_validate_buf ;
2599: RETURN ERROR_STATUS;
2600:

Line 2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2597: x_msg_count := 1;
2598: x_msg_data := 'Error while linking to statement:' || l_validate_buf ;
2599: RETURN ERROR_STATUS;
2600:
2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2602: IF (p_validate_type = 'CREATE') THEN
2603: ROLLBACK TO Create_Set;
2604: ELSIF (p_validate_type = 'UPDATE') THEN
2605: ROLLBACK TO Update_Set;

Line 2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2604: ELSIF (p_validate_type = 'UPDATE') THEN
2605: ROLLBACK TO Update_Set;
2606: END IF;
2607:
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2609: FND_MSG_PUB.Count_And_Get(
2610: p_count => x_msg_count,
2611: p_data => x_msg_data);
2612: RETURN ERROR_STATUS;

Line 2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2618: ROLLBACK TO Update_Set;
2619: END IF;
2620:
2621: x_msg_data := 'Error at Create Links: ' || SQLERRM ;
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2623: x_msg_count := 1;
2624: RETURN ERROR_STATUS;
2625:
2626: END Link_Soln_Attributes;

Line 2858: * If there is a validation error, returns FND_API.G_RET_STS_ERROR.

2854: * p_visibility_name - textual name of the visibility level to validate.
2855: * x_visibility_id - out the validated visibility level id. The value
2856: * is undefined if the function returns an error.
2857: * Return Value:
2858: * If there is a validation error, returns FND_API.G_RET_STS_ERROR.
2859: * If the validation succeeds, returns FND_API.G_RET_STS_SUCCESSFUL.
2860: */
2861: FUNCTION VALIDATE_VISIBILITY_LEVEL
2862: (

Line 2859: * If the validation succeeds, returns FND_API.G_RET_STS_SUCCESSFUL.

2855: * x_visibility_id - out the validated visibility level id. The value
2856: * is undefined if the function returns an error.
2857: * Return Value:
2858: * If there is a validation error, returns FND_API.G_RET_STS_ERROR.
2859: * If the validation succeeds, returns FND_API.G_RET_STS_SUCCESSFUL.
2860: */
2861: FUNCTION VALIDATE_VISIBILITY_LEVEL
2862: (
2863: p_visibility_name IN VARCHAR2,

Line 2870: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

2866: cursor get_matching_visibility( c_visibility_name VARCHAR2 ) is
2867: select visibility_id
2868: from cs_kb_visibilities_vl v
2869: where upper(v.name) like upper(c_visibility_name);
2870: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2871: BEGIN
2872:
2873: -- Check input parameters
2874: if( p_visibility_name is null) then

Line 2875: return FND_API.G_RET_STS_ERROR;

2871: BEGIN
2872:
2873: -- Check input parameters
2874: if( p_visibility_name is null) then
2875: return FND_API.G_RET_STS_ERROR;
2876: end if;
2877:
2878: -- Fetch the id of the visibility level
2879: open get_matching_visibility(p_visibility_name);

Line 2882: l_return_status := FND_API.G_RET_STS_ERROR;

2878: -- Fetch the id of the visibility level
2879: open get_matching_visibility(p_visibility_name);
2880: fetch get_matching_visibility into x_visibility_id;
2881: if ( get_matching_visibility%NOTFOUND ) then
2882: l_return_status := FND_API.G_RET_STS_ERROR;
2883: else
2884: l_return_status := FND_API.G_RET_STS_SUCCESS;
2885: end if;
2886: close get_matching_visibility;

Line 2884: l_return_status := FND_API.G_RET_STS_SUCCESS;

2880: fetch get_matching_visibility into x_visibility_id;
2881: if ( get_matching_visibility%NOTFOUND ) then
2882: l_return_status := FND_API.G_RET_STS_ERROR;
2883: else
2884: l_return_status := FND_API.G_RET_STS_SUCCESS;
2885: end if;
2886: close get_matching_visibility;
2887: return l_return_status;
2888: EXCEPTION

Line 2890: RETURN FND_API.G_RET_STS_ERROR;

2886: close get_matching_visibility;
2887: return l_return_status;
2888: EXCEPTION
2889: WHEN OTHERS THEN
2890: RETURN FND_API.G_RET_STS_ERROR;
2891: END Validate_Visibility_Level;
2892:
2893:
2894: FUNCTION VALIDATE_ACCESS_LEVEL

Line 3434: p_commit IN VARCHAR2 := FND_API.G_FALSE)

3430: In both cases, we only look at those solutions of which the feedback or
3431: linkage were create AFTERthe cut-off date (sysdate - time_span).
3432: */
3433: PROCEDURE Update_Solution_Usage_Score (
3434: p_commit IN VARCHAR2 := FND_API.G_FALSE)
3435: IS
3436: -- Default time usage to 1 year if the profile is not set.
3437: CURSOR Get_Time_Usage_Csr IS
3438: Select nvl(fnd_profile.value('CS_KB_USAGE_TIME_SPAN'), 365) from dual;

Line 3656: IF FND_API.to_Boolean( p_commit )

3652: where status = 'PUB';
3653: End If; --5705547
3654:
3655: -- commit changes
3656: IF FND_API.to_Boolean( p_commit )
3657: THEN
3658: COMMIT WORK;
3659: END IF;
3660: END IF; -- end l_set_count > 0, 4740480

Line 4474: x_return_status := fnd_api.g_ret_sts_success;

4470: 'PUB',
4471: l_flow_details_id,
4472: null);
4473: END IF;
4474: x_return_status := fnd_api.g_ret_sts_success;
4475: x_msg_count := 0;
4476: x_msg_data := null;
4477: EXCEPTION
4478: WHEN INVALID_FLOW THEN

Line 4480: x_return_status := FND_API.G_RET_STS_ERROR;

4476: x_msg_data := null;
4477: EXCEPTION
4478: WHEN INVALID_FLOW THEN
4479: ROLLBACK TO Clone_Soln;
4480: x_return_status := FND_API.G_RET_STS_ERROR;
4481: x_msg_count := 1;
4482: x_msg_data := 'Invalid flow: ' || p_set_flow_name ||
4483: ' or step: ' || p_set_flow_stepcode;
4484: WHEN OTHERS THEN

Line 4487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4483: ' or step: ' || p_set_flow_stepcode;
4484: WHEN OTHERS THEN
4485: ROLLBACK TO Clone_Soln;
4486: x_msg_data := 'Creating solution: ' || SQLERRM ;
4487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4488: x_msg_count := 1;
4489: END Clone_Soln_After_Import;
4490: END CS_KNOWLEDGE_AUDIT_PVT;