DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2061:
2062: if(p_ele_id_tbl is null ) then
2063:
2064: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2065: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2066: fnd_msg_pub.Add;
2067: end if;
2068: raise FND_API.G_EXC_ERROR;
2069: end if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3887:
3888:
3889: if l_sql_contains is null then
3890: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3891: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3892: fnd_msg_pub.Add;
3893: end if;
3894: raise FND_API.G_EXC_ERROR; --goto error_found;
3895: end if;

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

4089: end if;
4090:
4091: if l_sql_contains is null then
4092: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4093: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4094: fnd_msg_pub.Add;
4095: end if;
4096: raise FND_API.G_EXC_ERROR; --goto error_found;
4097: end if;