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 897: p_init_msg_list in varchar2 := FND_API.G_FALSE,

893: */
894: FUNCTION Create_Set_With_Validation
895: (
896: p_api_version in number,
897: p_init_msg_list in varchar2 := FND_API.G_FALSE,
898: p_commit in varchar2 := FND_API.G_FALSE,
899: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
900: x_return_status OUT NOCOPY varchar2,
901: x_msg_count OUT NOCOPY number,

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

894: FUNCTION Create_Set_With_Validation
895: (
896: p_api_version in number,
897: p_init_msg_list in varchar2 := FND_API.G_FALSE,
898: p_commit in varchar2 := FND_API.G_FALSE,
899: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
900: x_return_status OUT NOCOPY varchar2,
901: x_msg_count OUT NOCOPY number,
902: x_msg_data OUT NOCOPY varchar2,

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

895: (
896: p_api_version in number,
897: p_init_msg_list in varchar2 := FND_API.G_FALSE,
898: p_commit in varchar2 := FND_API.G_FALSE,
899: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
900: x_return_status OUT NOCOPY varchar2,
901: x_msg_count OUT NOCOPY number,
902: x_msg_data OUT NOCOPY varchar2,
903: p_set_type_name in varchar2,

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

959:
960: FUNCTION Create_Set_With_Validation_2
961: (
962: p_api_version in number,
963: p_init_msg_list in varchar2 := FND_API.G_FALSE,
964: p_commit in varchar2 := FND_API.G_FALSE,
965: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
966: x_return_status OUT NOCOPY varchar2,
967: x_msg_count OUT NOCOPY number,

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

960: FUNCTION Create_Set_With_Validation_2
961: (
962: p_api_version in number,
963: p_init_msg_list in varchar2 := FND_API.G_FALSE,
964: p_commit in varchar2 := FND_API.G_FALSE,
965: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
966: x_return_status OUT NOCOPY varchar2,
967: x_msg_count OUT NOCOPY number,
968: x_msg_data OUT NOCOPY varchar2,

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

961: (
962: p_api_version in number,
963: p_init_msg_list in varchar2 := FND_API.G_FALSE,
964: p_commit in varchar2 := FND_API.G_FALSE,
965: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
966: x_return_status OUT NOCOPY varchar2,
967: x_msg_count OUT NOCOPY number,
968: x_msg_data OUT NOCOPY varchar2,
969: p_set_type_name in varchar2,

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

1050: */
1051: FUNCTION Update_Set_With_Validation
1052: (
1053: p_api_version in number,
1054: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1055: p_commit in varchar2 := FND_API.G_FALSE,
1056: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1057: x_return_status OUT NOCOPY varchar2,
1058: x_msg_count OUT NOCOPY number,

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

1051: FUNCTION Update_Set_With_Validation
1052: (
1053: p_api_version in number,
1054: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1055: p_commit in varchar2 := FND_API.G_FALSE,
1056: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1057: x_return_status OUT NOCOPY varchar2,
1058: x_msg_count OUT NOCOPY number,
1059: x_msg_data OUT NOCOPY varchar2,

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

1052: (
1053: p_api_version in number,
1054: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1055: p_commit in varchar2 := FND_API.G_FALSE,
1056: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1057: x_return_status OUT NOCOPY varchar2,
1058: x_msg_count OUT NOCOPY number,
1059: x_msg_data OUT NOCOPY varchar2,
1060: p_set_number in varchar2,

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

1116: */
1117: FUNCTION Update_Set_With_Validation_2
1118: (
1119: p_api_version in number,
1120: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1123: x_return_status OUT NOCOPY varchar2,
1124: x_msg_count OUT NOCOPY number,

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

1117: FUNCTION Update_Set_With_Validation_2
1118: (
1119: p_api_version in number,
1120: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1123: x_return_status OUT NOCOPY varchar2,
1124: x_msg_count OUT NOCOPY number,
1125: x_msg_data OUT NOCOPY varchar2,

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

1118: (
1119: p_api_version in number,
1120: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1123: x_return_status OUT NOCOPY varchar2,
1124: x_msg_count OUT NOCOPY number,
1125: x_msg_data OUT NOCOPY varchar2,
1126: p_set_number in varchar2,

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

1347: */
1348: FUNCTION Create_Set_With_Validation_3
1349: (
1350: p_api_version in number,
1351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1352: p_commit in varchar2 := FND_API.G_FALSE,
1353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1354: x_return_status OUT NOCOPY varchar2,
1355: x_msg_count OUT NOCOPY number,

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

1348: FUNCTION Create_Set_With_Validation_3
1349: (
1350: p_api_version in number,
1351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1352: p_commit in varchar2 := FND_API.G_FALSE,
1353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1354: x_return_status OUT NOCOPY varchar2,
1355: x_msg_count OUT NOCOPY number,
1356: x_msg_data OUT NOCOPY varchar2,

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

1349: (
1350: p_api_version in number,
1351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1352: p_commit in varchar2 := FND_API.G_FALSE,
1353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1354: x_return_status OUT NOCOPY varchar2,
1355: x_msg_count OUT NOCOPY number,
1356: x_msg_data OUT NOCOPY varchar2,
1357: p_set_type_name in varchar2,

Line 1426: x_return_status := FND_API.G_RET_STS_SUCCESS;

1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1425:
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427:
1428: -- Validate Set Type Name, get Set Type ID
1429: l_validate_buf := p_set_type_name;
1430: l_return_val := Validate_Set_Type_Name_Create(p_set_type_name,

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

1496: x_msg_data => l_msg_data,
1497: x_msg_count => l_msg_count );
1498:
1499: -- dbms_output.put_line('created x_set_id='||l_set_id);
1500: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1501: (l_set_id <= 0) ) then
1502: raise FND_API.G_EXC_ERROR;
1503: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1504: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1502: raise FND_API.G_EXC_ERROR;

1498:
1499: -- dbms_output.put_line('created x_set_id='||l_set_id);
1500: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1501: (l_set_id <= 0) ) then
1502: raise FND_API.G_EXC_ERROR;
1503: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1504: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506:

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

1499: -- dbms_output.put_line('created x_set_id='||l_set_id);
1500: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1501: (l_set_id <= 0) ) then
1502: raise FND_API.G_EXC_ERROR;
1503: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1504: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506:
1507: -- link set with statements, products, categories, platforms, etc.

Line 1504: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1500: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1501: (l_set_id <= 0) ) then
1502: raise FND_API.G_EXC_ERROR;
1503: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1504: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506:
1507: -- link set with statements, products, categories, platforms, etc.
1508: -- also create new statements if info provided

Line 1546: x_return_status := fnd_api.g_ret_sts_success;

1542: END IF;
1543:
1544: -- dbms_output.put_line('return from LINK='||l_return_val);
1545:
1546: x_return_status := fnd_api.g_ret_sts_success;
1547: x_msg_count := 0;
1548: x_msg_data := null;
1549: RETURN OKAY_STATUS;
1550:

Line 1555: x_return_status := FND_API.G_RET_STS_ERROR;

1551: EXCEPTION
1552:
1553: WHEN VALIDATION_ERROR THEN
1554: /*
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: x_msg_count := 1;
1557: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1558: */
1559:

Line 1564: x_return_status := FND_API.G_RET_STS_ERROR;

1560: RETURN ERROR_STATUS;
1561:
1562: WHEN MANDATORY_STATEMENT_MISSING THEN
1563: ROLLBACK TO Create_Set;
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: x_msg_count := 1;
1566: x_msg_data := 'Mandatory Statements Missing.';
1567:
1568: RETURN ERROR_STATUS;

Line 1572: x_return_status := FND_API.G_RET_STS_ERROR;

1568: RETURN ERROR_STATUS;
1569:
1570: WHEN INVALID_SET_TYPE_NAME THEN
1571: ROLLBACK TO Create_Set;
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: x_msg_count := 1;
1574: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1575:
1576: RETURN ERROR_STATUS;

Line 1580: x_return_status := FND_API.G_RET_STS_ERROR;

1576: RETURN ERROR_STATUS;
1577:
1578: WHEN INVALID_FLOW 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 := 'Invalid flow: ' || p_set_flow_name ||
1583: ' or step: ' || p_set_flow_stepcode;
1584:

Line 1589: x_return_status := FND_API.G_RET_STS_ERROR;

1585: RETURN ERROR_STATUS;
1586:
1587: WHEN DUPLICATE_SET_NAME THEN
1588: ROLLBACK TO Create_Set;
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: x_msg_count := 1;
1591: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1592:
1593: RETURN ERROR_STATUS;

Line 1595: WHEN FND_API.G_EXC_ERROR THEN

1591: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1592:
1593: RETURN ERROR_STATUS;
1594:
1595: WHEN FND_API.G_EXC_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_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_ERROR ;

1593: RETURN ERROR_STATUS;
1594:
1595: WHEN FND_API.G_EXC_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_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_ERROR THEN
1596: ROLLBACK TO Create_Set;
1597: x_return_status := FND_API.G_RET_STS_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 1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602: RETURN ERROR_STATUS;
1603:
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO Create_Set;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE ,

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1602: RETURN ERROR_STATUS;
1603:
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO Create_Set;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE ,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);

Line 1608: p_encoded => FND_API.G_FALSE ,

1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO Create_Set;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE ,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
1611: RETURN ERROR_STATUS;
1612:

Line 1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1612:
1613: WHEN OTHERS THEN
1614: ROLLBACK TO Create_Set;
1615: x_msg_data := 'Creating solution: ' || SQLERRM ;
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1617: x_msg_count := 1;
1618: RETURN ERROR_STATUS;
1619:
1620: END Create_Set_With_Validation_3;

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

1624: */
1625: FUNCTION Update_Set_With_Validation_3
1626: (
1627: p_api_version in number,
1628: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1629: p_commit in varchar2 := FND_API.G_FALSE,
1630: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1631: x_return_status OUT NOCOPY varchar2,
1632: x_msg_count OUT NOCOPY number,

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

1625: FUNCTION Update_Set_With_Validation_3
1626: (
1627: p_api_version in number,
1628: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1629: p_commit in varchar2 := FND_API.G_FALSE,
1630: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1631: x_return_status OUT NOCOPY varchar2,
1632: x_msg_count OUT NOCOPY number,
1633: x_msg_data OUT NOCOPY varchar2,

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

1626: (
1627: p_api_version in number,
1628: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1629: p_commit in varchar2 := FND_API.G_FALSE,
1630: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1631: x_return_status OUT NOCOPY varchar2,
1632: x_msg_count OUT NOCOPY number,
1633: x_msg_data OUT NOCOPY varchar2,
1634: p_set_number in varchar2,

Line 1733: x_return_status := FND_API.G_RET_STS_SUCCESS;

1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1732:
1733: x_return_status := FND_API.G_RET_STS_SUCCESS;
1734:
1735: -- dbms_output.put_line('Validate Set number');
1736: -- Validate Set number, get Set ID
1737: l_validate_buf := p_set_number;

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

1825: p_attribute15 => null
1826: );
1827:
1828: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1829: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1830: (x_set_id <= 0) ) then
1831: raise FND_API.G_EXC_ERROR;
1832: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1833: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1831: raise FND_API.G_EXC_ERROR;

1827:
1828: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1829: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1830: (x_set_id <= 0) ) then
1831: raise FND_API.G_EXC_ERROR;
1832: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1833: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1834: end if;
1835:

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

1828: -- dbms_output.put_line('return from UPDATE_SET='||l_return_val);
1829: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1830: (x_set_id <= 0) ) then
1831: raise FND_API.G_EXC_ERROR;
1832: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1833: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1834: end if;
1835:
1836: -- dbms_output.put_line('updated soln.');

Line 1833: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1829: if( (l_return_status = FND_API.G_RET_STS_ERROR) or
1830: (x_set_id <= 0) ) then
1831: raise FND_API.G_EXC_ERROR;
1832: elsif ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
1833: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1834: end if;
1835:
1836: -- dbms_output.put_line('updated soln.');
1837:

Line 1845: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1841: p_element_id => cur_row.element_id,
1842: p_set_id => x_set_id
1843: );
1844: if (l_return_val < 0) then
1845: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1846: end if;
1847: END LOOP;
1848: -- dbms_output.put_line('unlinked element ids. ');
1849:

Line 1867: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1863: p_task => 0,
1864: p_result => l_return_val);
1865:
1866: if (l_return_val < 0) then
1867: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1868: end if;
1869: -- dbms_output.put_line('unlinked products. ');
1870:
1871: -- unlink all platforms

Line 1889: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1885: p_task => 0,
1886: p_result => l_return_val);
1887:
1888: if (l_return_val < 0) then
1889: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1890: end if;
1891: -- dbms_output.put_line('unlinked platforms. ');
1892:
1893: -- unlink categories

Line 1953: x_return_status := FND_API.G_RET_STS_ERROR;

1949: RETURN ERROR_STATUS;
1950:
1951: WHEN MANDATORY_STATEMENT_MISSING THEN
1952: ROLLBACK TO Update_Set;
1953: x_return_status := FND_API.G_RET_STS_ERROR;
1954: x_msg_count := 1;
1955: x_msg_data := 'Mandatory Statements Missing.';
1956:
1957: RETURN ERROR_STATUS;

Line 1961: x_return_status := FND_API.G_RET_STS_ERROR;

1957: RETURN ERROR_STATUS;
1958:
1959: WHEN INVALID_SET_NUMBER THEN
1960: ROLLBACK TO Update_Set;
1961: x_return_status := FND_API.G_RET_STS_ERROR;
1962: x_msg_count := 1;
1963: x_msg_data := 'Invalid Solution Number: ' || p_set_number || '. Solutions to be updated should be valid and PUBLISHED.' ;
1964:
1965: RETURN ERROR_STATUS;

Line 1969: x_return_status := FND_API.G_RET_STS_ERROR;

1965: RETURN ERROR_STATUS;
1966:
1967: WHEN INVALID_SET_TYPE_NAME THEN
1968: ROLLBACK TO Update_Set;
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: x_msg_count := 1;
1971: x_msg_data := 'Invalid Set Type Name : ' || p_set_type_name;
1972:
1973: RETURN ERROR_STATUS;

Line 1977: x_return_status := FND_API.G_RET_STS_ERROR;

1973: RETURN ERROR_STATUS;
1974:
1975: WHEN DUPLICATE_SET_NAME THEN
1976: ROLLBACK TO Update_Set;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: x_msg_count := 1;
1979: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1980:
1981: RETURN ERROR_STATUS;

Line 1983: WHEN FND_API.G_EXC_ERROR THEN

1979: x_msg_data := 'Duplicate Solution Name:' || l_validate_buf;
1980:
1981: RETURN ERROR_STATUS;
1982:
1983: WHEN FND_API.G_EXC_ERROR THEN
1984: ROLLBACK TO Create_Set;
1985: x_return_status := FND_API.G_RET_STS_ERROR ;
1986: FND_MSG_PUB.Count_And_Get(
1987: p_encoded => FND_API.G_FALSE,

Line 1985: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1987: p_encoded => FND_API.G_FALSE,

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

Line 1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1988: p_count => x_msg_count,
1989: p_data => x_msg_data);
1990: RETURN ERROR_STATUS;
1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: ROLLBACK TO Update_Set;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1995: FND_MSG_PUB.Count_And_Get(
1996: p_encoded => FND_API.G_FALSE,

Line 1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1990: RETURN ERROR_STATUS;
1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: ROLLBACK TO Update_Set;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1995: FND_MSG_PUB.Count_And_Get(
1996: p_encoded => FND_API.G_FALSE,
1997: p_count => x_msg_count,
1998: p_data => x_msg_data);

Line 1996: p_encoded => FND_API.G_FALSE,

1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: ROLLBACK TO Update_Set;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1995: FND_MSG_PUB.Count_And_Get(
1996: p_encoded => FND_API.G_FALSE,
1997: p_count => x_msg_count,
1998: p_data => x_msg_data);
1999: RETURN ERROR_STATUS;
2000:

Line 2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2000:
2001: WHEN OTHERS THEN
2002: ROLLBACK TO Update_Set;
2003: x_msg_data := 'Update Solution: ' || SQLERRM ;
2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2005: x_msg_count := 0;
2006: RETURN ERROR_STATUS;
2007:
2008: END Update_Set_With_validation_3;

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

2071: -- Validate Solution Visibility Level Name, get ID
2072: l_validate_buf := p_visibility_name;
2073: l_return_status := Validate_Visibility_Level( p_visibility_name,
2074: x_visibility_id );
2075: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2076: RAISE INVALID_VISIBILITY_LEVEL;
2077: END IF;
2078:
2079:

Line 2277: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2273: END IF;
2274:
2275: end loop;
2276:
2277: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2278: return OKAY_STATUS;
2279: EXCEPTION
2280: WHEN INVALID_VISIBILITY_LEVEL THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2281: x_return_status := FND_API.G_RET_STS_ERROR;

2277: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2278: return OKAY_STATUS;
2279: EXCEPTION
2280: WHEN INVALID_VISIBILITY_LEVEL THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282: x_msg_count := 1;
2283: x_msg_data := ' Invalid Visibility Name: ' || l_validate_buf;
2284:
2285: RETURN ERROR_STATUS;

Line 2288: x_return_status := FND_API.G_RET_STS_ERROR;

2284:
2285: RETURN ERROR_STATUS;
2286:
2287: WHEN INVALID_ACCESS_LEVEL THEN
2288: x_return_status := FND_API.G_RET_STS_ERROR;
2289: x_msg_count := 1;
2290: x_msg_data := ' Invalid Distribution Name: ' || l_validate_buf;
2291:
2292: RETURN ERROR_STATUS;

Line 2295: x_return_status := FND_API.G_RET_STS_ERROR;

2291:
2292: RETURN ERROR_STATUS;
2293:
2294: WHEN INVALID_ELEMENT_TYPE_NAME THEN
2295: x_return_status := FND_API.G_RET_STS_ERROR;
2296: x_msg_count := 1;
2297: x_msg_data := 'Invalid Element Type Name: ' || l_validate_buf;
2298:
2299: RETURN ERROR_STATUS;

Line 2302: x_return_status := FND_API.G_RET_STS_ERROR;

2298:
2299: RETURN ERROR_STATUS;
2300:
2301: WHEN INVALID_ELEMENT_TYPE THEN
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: x_msg_count := 1;
2304: x_msg_data := 'Invalid Element Type ID for Element Number: ' || l_validate_buf;
2305:
2306: RETURN ERROR_STATUS;

Line 2309: x_return_status := FND_API.G_RET_STS_ERROR;

2305:
2306: RETURN ERROR_STATUS;
2307:
2308: WHEN INVALID_SET_ELEMENT_TYPE_MAP THEN
2309: x_return_status := FND_API.G_RET_STS_ERROR;
2310: x_msg_count := 1;
2311: x_msg_data := 'Invalid Set Element Type Mapping: ' || l_validate_buf;
2312:
2313: RETURN ERROR_STATUS;

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR;

2312:
2313: RETURN ERROR_STATUS;
2314:
2315: WHEN INVALID_ELEMENT_CONTENT_TYPE THEN
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: x_msg_count := 1;
2318: x_msg_data := 'Invalid Element Content Type: ' || l_validate_buf;
2319:
2320: RETURN ERROR_STATUS;

Line 2323: x_return_status := FND_API.G_RET_STS_ERROR;

2319:
2320: RETURN ERROR_STATUS;
2321:
2322: WHEN INVALID_ELEMENT_NUMBER THEN
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: x_msg_count := 1;
2325: x_msg_data := 'This Statement No is invalid or in DRAFT status: ' || l_validate_buf;
2326:
2327: RETURN ERROR_STATUS;

Line 2330: x_return_status := FND_API.G_RET_STS_ERROR;

2326:
2327: RETURN ERROR_STATUS;
2328:
2329: WHEN INVALID_PRODUCT_NAME THEN
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: x_msg_count := 1;
2332: x_msg_data := 'Product Name is invalid: ' || l_validate_buf;
2333:
2334: RETURN ERROR_STATUS;

Line 2337: x_return_status := FND_API.G_RET_STS_ERROR;

2333:
2334: RETURN ERROR_STATUS;
2335:
2336: WHEN INVALID_PRODUCT_SEGMENT THEN
2337: x_return_status := FND_API.G_RET_STS_ERROR;
2338: x_msg_count := 1;
2339: x_msg_data := 'Product Segment is invalid: ' || l_validate_buf;
2340:
2341: RETURN ERROR_STATUS;

Line 2344: x_return_status := FND_API.G_RET_STS_ERROR;

2340:
2341: RETURN ERROR_STATUS;
2342:
2343: WHEN INVALID_PLATFORM_NAME THEN
2344: x_return_status := FND_API.G_RET_STS_ERROR;
2345: x_msg_count := 1;
2346: x_msg_data := 'Platform Name is Invalid: ' || l_validate_buf;
2347:
2348: RETURN ERROR_STATUS;

Line 2351: x_return_status := FND_API.G_RET_STS_ERROR;

2347:
2348: RETURN ERROR_STATUS;
2349:
2350: WHEN INVALID_PLATFORM_SEGMENT THEN
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: x_msg_count := 1;
2353: x_msg_data := 'Platform Segment is Invalid: ' || l_validate_buf;
2354:
2355: RETURN ERROR_STATUS;

Line 2358: x_return_status := FND_API.G_RET_STS_ERROR;

2354:
2355: RETURN ERROR_STATUS;
2356:
2357: WHEN MANDATORY_CATEGORY_MISSING THEN
2358: x_return_status := FND_API.G_RET_STS_ERROR;
2359: x_msg_count := 1;
2360: x_msg_data := 'Mandatory category missing. Solution must belong to at least one category.';
2361:
2362: RETURN ERROR_STATUS;

Line 2365: x_return_status := FND_API.G_RET_STS_ERROR;

2361:
2362: RETURN ERROR_STATUS;
2363:
2364: WHEN INVALID_CATEGORY_NAME THEN
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: x_msg_count := 1;
2367: x_msg_data := 'Category Name is Invalid:' || l_validate_buf;
2368:
2369: RETURN ERROR_STATUS;

Line 2373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2369: RETURN ERROR_STATUS;
2370:
2371: WHEN OTHERS THEN
2372: x_msg_data := 'ERROR in validating solution attributes: ' || SQLERRM ;
2373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2374: x_msg_count := 0;
2375: RETURN ERROR_STATUS;
2376:
2377: END VALIDATE_SOLN_ATTRIBUTES_3;

Line 2442: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2438: l_validate_buf := p_element_summaries(i);
2439: raise DUPLICATE_ELEMENT_NAME;
2440: -- should should get existing ID and link
2441: ELSIF (not x_created_element_ids(i) > 0) then
2442: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2443: end if;
2444: end loop;
2445:
2446: -- link The Created element ids to set id;

Line 2456: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2452: p_element_number => l_temp_element_no,
2453: p_set_id => p_set_id);
2454:
2455: if (l_return_val = ERROR_STATUS) THEN
2456: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2457: end if;
2458: end loop;
2459:
2460: -- link The provided element ids to set id;

Line 2469: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2465: p_element_number => l_temp_element_no,
2466: p_set_id => p_set_id);
2467:
2468: if (l_return_val = ERROR_STATUS) THEN
2469: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2470: end if;
2471: end loop;
2472:
2473: -- global updating given elements

Line 2486: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2482: p_content_type => p_given_ele_content_types(i),
2483: p_status => 'PUBLISHED');
2484:
2485: IF (l_temp_update_return < 0) then
2486: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2487: end if;
2488:
2489: -- Mark the text indexes for the updated statement
2490: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(p_given_element_ids(i));

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

2550: p_category_id => p_set_category_ids(i),
2551: x_soln_category_link_id => l_temp_category_link_id
2552: );
2553:
2554: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2555: raise CATEGORY_LINK_ERROR;
2556: end if;
2557: end loop;
2558:

Line 2568: x_return_status := FND_API.G_RET_STS_ERROR;

2564: ROLLBACK TO Create_Set;
2565: ELSIF (p_validate_type = 'UPDATE') THEN
2566: ROLLBACK TO Update_Set;
2567: END IF;
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: x_msg_count := 1;
2570: x_msg_data := 'Unable to link to Product' ;
2571:
2572: RETURN ERROR_STATUS;

Line 2581: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2594: x_return_status := FND_API.G_RET_STS_ERROR;

2590: ELSIF (p_validate_type = 'UPDATE') THEN
2591: ROLLBACK TO Update_Set;
2592: END IF;
2593:
2594: x_return_status := FND_API.G_RET_STS_ERROR;
2595: x_msg_count := 1;
2596: x_msg_data := 'Unable to link to Category' ;
2597: RETURN ERROR_STATUS;
2598:

Line 2606: x_return_status := FND_API.G_RET_STS_ERROR;

2602: ELSIF (p_validate_type = 'UPDATE') THEN
2603: ROLLBACK TO Update_Set;
2604: END IF;
2605:
2606: x_return_status := FND_API.G_RET_STS_ERROR;
2607: x_msg_count := 1;
2608: x_msg_data := 'Error while linking to statement:' || l_validate_buf ;
2609: RETURN ERROR_STATUS;
2610:

Line 2611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2607: x_msg_count := 1;
2608: x_msg_data := 'Error while linking to statement:' || l_validate_buf ;
2609: RETURN ERROR_STATUS;
2610:
2611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2612: IF (p_validate_type = 'CREATE') THEN
2613: ROLLBACK TO Create_Set;
2614: ELSIF (p_validate_type = 'UPDATE') THEN
2615: ROLLBACK TO Update_Set;

Line 2618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2614: ELSIF (p_validate_type = 'UPDATE') THEN
2615: ROLLBACK TO Update_Set;
2616: END IF;
2617:
2618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2619: FND_MSG_PUB.Count_And_Get(
2620: p_count => x_msg_count,
2621: p_data => x_msg_data);
2622: RETURN ERROR_STATUS;

Line 2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2628: ROLLBACK TO Update_Set;
2629: END IF;
2630:
2631: x_msg_data := 'Error at Create Links: ' || SQLERRM ;
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2633: x_msg_count := 1;
2634: RETURN ERROR_STATUS;
2635:
2636: END Link_Soln_Attributes;

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

2864: * p_visibility_name - textual name of the visibility level to validate.
2865: * x_visibility_id - out the validated visibility level id. The value
2866: * is undefined if the function returns an error.
2867: * Return Value:
2868: * If there is a validation error, returns FND_API.G_RET_STS_ERROR.
2869: * If the validation succeeds, returns FND_API.G_RET_STS_SUCCESSFUL.
2870: */
2871: FUNCTION VALIDATE_VISIBILITY_LEVEL
2872: (

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

2865: * x_visibility_id - out the validated visibility level id. The value
2866: * is undefined if the function returns an error.
2867: * Return Value:
2868: * If there is a validation error, returns FND_API.G_RET_STS_ERROR.
2869: * If the validation succeeds, returns FND_API.G_RET_STS_SUCCESSFUL.
2870: */
2871: FUNCTION VALIDATE_VISIBILITY_LEVEL
2872: (
2873: p_visibility_name IN VARCHAR2,

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

2876: cursor get_matching_visibility( c_visibility_name VARCHAR2 ) is
2877: select visibility_id
2878: from cs_kb_visibilities_vl v
2879: where upper(v.name) like upper(c_visibility_name);
2880: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2881: BEGIN
2882:
2883: -- Check input parameters
2884: if( p_visibility_name is null) then

Line 2885: return FND_API.G_RET_STS_ERROR;

2881: BEGIN
2882:
2883: -- Check input parameters
2884: if( p_visibility_name is null) then
2885: return FND_API.G_RET_STS_ERROR;
2886: end if;
2887:
2888: -- Fetch the id of the visibility level
2889: open get_matching_visibility(p_visibility_name);

Line 2892: l_return_status := FND_API.G_RET_STS_ERROR;

2888: -- Fetch the id of the visibility level
2889: open get_matching_visibility(p_visibility_name);
2890: fetch get_matching_visibility into x_visibility_id;
2891: if ( get_matching_visibility%NOTFOUND ) then
2892: l_return_status := FND_API.G_RET_STS_ERROR;
2893: else
2894: l_return_status := FND_API.G_RET_STS_SUCCESS;
2895: end if;
2896: close get_matching_visibility;

Line 2894: l_return_status := FND_API.G_RET_STS_SUCCESS;

2890: fetch get_matching_visibility into x_visibility_id;
2891: if ( get_matching_visibility%NOTFOUND ) then
2892: l_return_status := FND_API.G_RET_STS_ERROR;
2893: else
2894: l_return_status := FND_API.G_RET_STS_SUCCESS;
2895: end if;
2896: close get_matching_visibility;
2897: return l_return_status;
2898: EXCEPTION

Line 2900: RETURN FND_API.G_RET_STS_ERROR;

2896: close get_matching_visibility;
2897: return l_return_status;
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: RETURN FND_API.G_RET_STS_ERROR;
2901: END Validate_Visibility_Level;
2902:
2903:
2904: FUNCTION VALIDATE_ACCESS_LEVEL

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

3440: In both cases, we only look at those solutions of which the feedback or
3441: linkage were create AFTERthe cut-off date (sysdate - time_span).
3442: */
3443: PROCEDURE Update_Solution_Usage_Score (
3444: p_commit IN VARCHAR2 := FND_API.G_FALSE)
3445: IS
3446: -- Default time usage to 1 year if the profile is not set.
3447: CURSOR Get_Time_Usage_Csr IS
3448: Select nvl(fnd_profile.value('CS_KB_USAGE_TIME_SPAN'), 365) from dual;

Line 3666: IF FND_API.to_Boolean( p_commit )

3662: where status = 'PUB';
3663: End If; --5705547
3664:
3665: -- commit changes
3666: IF FND_API.to_Boolean( p_commit )
3667: THEN
3668: COMMIT WORK;
3669: END IF;
3670: END IF; -- end l_set_count > 0, 4740480

Line 4484: x_return_status := fnd_api.g_ret_sts_success;

4480: 'PUB',
4481: l_flow_details_id,
4482: null);
4483: END IF;
4484: x_return_status := fnd_api.g_ret_sts_success;
4485: x_msg_count := 0;
4486: x_msg_data := null;
4487: EXCEPTION
4488: WHEN INVALID_FLOW THEN

Line 4490: x_return_status := FND_API.G_RET_STS_ERROR;

4486: x_msg_data := null;
4487: EXCEPTION
4488: WHEN INVALID_FLOW THEN
4489: ROLLBACK TO Clone_Soln;
4490: x_return_status := FND_API.G_RET_STS_ERROR;
4491: x_msg_count := 1;
4492: x_msg_data := 'Invalid flow: ' || p_set_flow_name ||
4493: ' or step: ' || p_set_flow_stepcode;
4494: WHEN OTHERS THEN

Line 4497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4493: ' or step: ' || p_set_flow_stepcode;
4494: WHEN OTHERS THEN
4495: ROLLBACK TO Clone_Soln;
4496: x_msg_data := 'Creating solution: ' || SQLERRM ;
4497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4498: x_msg_count := 1;
4499: END Clone_Soln_After_Import;
4500: END CS_KNOWLEDGE_AUDIT_PVT;