DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on FND_MESSAGE

Line 170: fnd_message.set_name('CS','CS_KB_C_MISS_PARAM');

166: if(p_ele_def_tbl(i1).element_type_id=l_types_tbl(i2)) then
167: l_count := 1;
168: end if;
169: else
170: fnd_message.set_name('CS','CS_KB_C_MISS_PARAM');
171: return FND_API.G_TRUE;
172: end if;
173: i1 := p_ele_def_tbl.NEXT(i1);
174: end loop;

Line 605: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

601: p_other_id_tbl is null or p_other_code_tbl is null or
602: p_other_id_tbl.COUNT <> p_other_code_tbl.COUNT) then
603:
604: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
605: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
606: fnd_msg_pub.Add;
607: end if;
608: raise FND_API.G_EXC_ERROR;
609: end if;

Line 741: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

737: p_link_id_tbl.COUNT =0 or p_ele_type_id_tbl.COUNT =0 or
738: p_ele_type_id_tbl.COUNT < p_link_id_tbl.COUNT) then
739:
740: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
741: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
742: fnd_msg_pub.Add;
743: end if;
744: raise FND_API.G_EXC_ERROR;
745:

Line 760: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');

756: where element_type_id = l_ele_type_id;
757: if(l_count<1) then
758:
759: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
760: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
761: fnd_msg_pub.Add;
762: end if;
763:
764: raise FND_API.G_EXC_ERROR;

Line 862: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

858: p_link_id_tbl.COUNT =0 or p_set_id_tbl.COUNT =0 or
859: p_set_id_tbl.COUNT < p_link_id_tbl.COUNT) then
860:
861: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
862: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
863: fnd_msg_pub.Add;
864: end if;
865: raise FND_API.G_EXC_ERROR;
866: end if;

Line 880: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');

876: where set_id = l_set_id;
877: if(l_count<1) then
878:
879: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
880: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
881: fnd_msg_pub.Add;
882: end if;
883: raise FND_API.G_EXC_ERROR;
884: end if;

Line 982: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

978: p_set_id_tbl.COUNT =0 or p_new_ele_id_tbl.COUNT =0 or
979: p_new_ele_id_tbl.COUNT < p_set_id_tbl.COUNT) then
980:
981: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
982: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
983: fnd_msg_pub.Add;
984: end if;
985:
986: raise FND_API.G_EXC_ERROR;

Line 1003: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

999: from cs_kb_elements_b
1000: where element_id = l_element_id;
1001: if(l_count<1) then
1002: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1003: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1004: fnd_msg_pub.Add;
1005: end if;
1006: raise FND_API.G_EXC_ERROR;
1007: end if;

Line 1016: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

1012: where set_id = p_set_id_tbl(i1)
1013: and element_id = l_element_id;
1014: if(l_count>0) then
1015: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1016: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1017: fnd_msg_pub.Add;
1018: end if;
1019: raise FND_API.G_EXC_ERROR;
1020: end if;

Line 1144: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

1140: p_link_id_tbl.COUNT =0 or p_element_id_tbl.COUNT =0 or
1141: p_element_id_tbl.COUNT < p_link_id_tbl.COUNT) then
1142:
1143: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1144: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1145: fnd_msg_pub.Add;
1146: end if;
1147: raise FND_API.G_EXC_ERROR;
1148: end if;

Line 1162: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

1158: from cs_kb_elements_b
1159: where element_id = l_element_id;
1160: if(l_count<1) then
1161: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1162: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1163: fnd_msg_pub.Add;
1164: end if;
1165: raise FND_API.G_EXC_ERROR;
1166: end if;

Line 1248: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

1244:
1245: begin
1246: -- Check params
1247: if( not p_set_id > 0 ) or (not p_ele_id > 0) then
1248: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1249: goto error_found;
1250: end if;
1251:
1252:

Line 1287: fnd_message.set_name('CS', 'CS_KB_C_REQ_TYPE_ERR');

1283: where se.set_id = p_set_id
1284: and se.element_id = e.element_id
1285: and e.element_type_id = l_ele_type_id;
1286: if(l_count <=1) then
1287: fnd_message.set_name('CS', 'CS_KB_C_REQ_TYPE_ERR');
1288: goto error_found;
1289: end if;
1290: end if;
1291:

Line 1346: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

1342: begin
1343:
1344: -- Check params
1345: if( not p_set_id > 0 ) or (not p_ele_id > 0) then
1346: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1347: goto error_found;
1348: end if;
1349:
1350: -- check if element exists

Line 1355: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

1351: select count(*) into l_count
1352: from cs_kb_elements_b
1353: where element_id = p_ele_id;
1354: if(l_count=0) then
1355: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1356: goto error_found;
1357: end if;
1358:
1359: -- check if row already exists

Line 1365: fnd_message.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');

1361: from cs_kb_set_eles
1362: where set_id = p_set_id
1363: and element_id = p_ele_id;
1364: if(l_count>0) then
1365: fnd_message.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');
1366: goto error_found;
1367: end if;
1368:
1369: --check set ele type match

Line 1374: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');

1370: if( Is_Set_Ele_Type_Valid(
1371: p_set_id => p_set_id,
1372: p_ele_id => p_ele_id)
1373: = G_FALSE) then
1374: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
1375: goto error_found;
1376: end if;
1377:
1378: -- prepare data to insert

Line 1844: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

1840: p_set_def_obj.set_type_id <=0 or
1841: p_set_def_obj.name is null) then
1842:
1843: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1844: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1845: fnd_msg_pub.Add;
1846: end if;
1847: raise FND_API.G_EXC_ERROR;
1848:

Line 1857: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');

1853:
1854: -- This Create api only creates Draft Solutions
1855: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1856:
1857: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');
1858: fnd_msg_pub.Add;
1859:
1860: END IF;
1861: RAISE FND_API.G_EXC_ERROR;

Line 1876: fnd_message.set_name('CS', 'CS_KB_INV_CAT_PROFILE');

1872: OPEN Get_Profile_Name;
1873: FETCH Get_Profile_Name INTO l_profile_name;
1874: CLOSE Get_Profile_Name;
1875:
1876: fnd_message.set_name('CS', 'CS_KB_INV_CAT_PROFILE');
1877: FND_MESSAGE.SET_TOKEN(TOKEN => 'PROFILE',
1878: VALUE => l_profile_name,
1879: TRANSLATE => true);
1880: fnd_msg_pub.Add;

Line 1877: FND_MESSAGE.SET_TOKEN(TOKEN => 'PROFILE',

1873: FETCH Get_Profile_Name INTO l_profile_name;
1874: CLOSE Get_Profile_Name;
1875:
1876: fnd_message.set_name('CS', 'CS_KB_INV_CAT_PROFILE');
1877: FND_MESSAGE.SET_TOKEN(TOKEN => 'PROFILE',
1878: VALUE => l_profile_name,
1879: TRANSLATE => true);
1880: fnd_msg_pub.Add;
1881:

Line 1889: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

1885:
1886: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1887:
1888: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1889: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1890: fnd_msg_pub.Add;
1891: end if;
1892: raise FND_API.G_EXC_ERROR;
1893:

Line 1948: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_ELE_ID');

1944:
1945: IF l_ele_check = 1 THEN
1946: x_element_id_tbl(j) := p_ele_def_tbl(i1).element_id;
1947: ELSE
1948: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_ELE_ID');
1949: FND_MSG_PUB.Add;
1950: RAISE FND_API.G_EXC_ERROR;
1951: END IF;
1952:

Line 2061: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2057:
2058: if(p_ele_id_tbl is null ) then
2059:
2060: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2061: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2062: fnd_msg_pub.Add;
2063: end if;
2064: raise FND_API.G_EXC_ERROR;
2065: end if;

Line 2179: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2175: p_set_def_obj.name is null
2176: ) then
2177:
2178: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2179: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2180: fnd_msg_pub.Add;
2181: end if;
2182: RAISE FND_API.G_EXC_ERROR; -- goto error_found;
2183: end if;

Line 2188: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2184:
2185: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2186:
2187: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2188: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2189: fnd_msg_pub.Add;
2190: end if;
2191: raise FND_API.G_EXC_ERROR;
2192: end if;

Line 2203: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');

2199: p_set_type_id => p_set_def_obj.set_type_id,
2200: p_ele_id => p_ele_id_tbl(i3))
2201: = G_FALSE) then
2202: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2203: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
2204: fnd_msg_pub.Add;
2205:
2206: end if;
2207: RAISE FND_API.G_EXC_ERROR;

Line 2225: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');

2221: end loop;
2222: if(Is_Required_Type_Missing(
2223: p_set_def_obj.set_type_id,l_ele_def_tbl)=FND_API.G_TRUE) then
2224: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2225: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');
2226: fnd_msg_pub.Add;
2227:
2228: end if;
2229: raise FND_API.G_EXC_ERROR;

Line 2280: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2276: while i1 is not null loop
2277: --validate element
2278: if(p_ele_id_tbl(i1) is null or p_ele_id_tbl(i1) < 0) then
2279: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2280: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2281: fnd_msg_pub.Add;
2282: end if;
2283: RAISE FND_API.G_EXC_ERROR;
2284: end if;

Line 2447: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2443: -- Check params
2444: if(p_ele_def_obj.element_type_id is null
2445: ) then
2446: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2447: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2448: fnd_msg_pub.Add;
2449: end if;
2450:
2451: raise FND_API.G_EXC_ERROR; -- goto error_found;

Line 2571: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

2567: -- -- -- -- begin my code -- -- -- -- --
2568: -- Check params
2569: if(p_set_id is null) then
2570: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2571: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2572: fnd_msg_pub.Add;
2573: end if;
2574: raise FND_API.G_EXC_ERROR; --goto error_found;
2575: end if;

Line 3866: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

3862:
3863:
3864: if l_sql_contains is null then
3865: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3866: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3867: fnd_msg_pub.Add;
3868: end if;
3869: raise FND_API.G_EXC_ERROR; --goto error_found;
3870: end if;

Line 4068: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

4064: end if;
4065:
4066: if l_sql_contains is null then
4067: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4068: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4069: fnd_msg_pub.Add;
4070: end if;
4071: raise FND_API.G_EXC_ERROR; --goto error_found;
4072: end if;