DBA Data[Home] [Help]

APPS.IBC_CITEM_ADMIN_GRP dependencies on IBC_VALIDATE_PVT

Line 1121: IF (IBC_VALIDATE_PVT.isNumber(temp_attribute) = FND_API.g_false) THEN

1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: END IF;
1119: -- number (decimal)
1120: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_NUMBER) THEN
1121: IF (IBC_VALIDATE_PVT.isNumber(temp_attribute) = FND_API.g_false) THEN
1122: FND_MESSAGE.Set_Name('IBC', 'IBC_VALATTR_INVALID_NUMBER');
1123: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME', get_Attribute_type_name(p_ctype_code, p_attribute_type_codes(counter)), FALSE);
1124: FND_MSG_PUB.ADD;
1125: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1129: IF (IBC_VALIDATE_PVT.isDate(temp_attribute) = FND_API.g_false) THEN

1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: END IF;
1127: -- date (datetime)
1128: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_DATE) THEN
1129: IF (IBC_VALIDATE_PVT.isDate(temp_attribute) = FND_API.g_false) THEN
1130: FND_MESSAGE.Set_Name('IBC', 'IBC_VALATTR_INVALID_DATE');
1131: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME', get_Attribute_type_name(p_ctype_code, p_attribute_type_codes(counter)), FALSE);
1132: FND_MSG_PUB.ADD;
1133: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1137: IF (IBC_VALIDATE_PVT.isBoolean(temp_attribute) = FND_API.g_false) THEN

1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: END IF;
1135: -- boolean
1136: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_BOOLEAN) THEN
1137: IF (IBC_VALIDATE_PVT.isBoolean(temp_attribute) = FND_API.g_false) THEN
1138: FND_MESSAGE.Set_Name('IBC', 'IBC_VALATTR_INVALID_BOOLEAN');
1139: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME', get_Attribute_type_name(p_ctype_code, p_attribute_type_codes(counter)), FALSE);
1140: FND_MSG_PUB.ADD;
1141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1933: IF (IBC_VALIDATE_PVT.isValidAssocType(p_assoc_type_codes(counter)) = FND_API.g_false ) THEN

1929: -- setting insert flag to true to start
1930: insert_data := FND_API.g_true;
1931:
1932: -- assoc type
1933: IF (IBC_VALIDATE_PVT.isValidAssocType(p_assoc_type_codes(counter)) = FND_API.g_false ) THEN
1934: --DBMS_OUTPUT.put_line('EX - assoc type');
1935: insert_data := FND_API.g_false;
1936: x_return_status := FND_API.G_RET_STS_ERROR;
1937: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');

Line 2125: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_ids(counter)) = FND_API.g_false) THEN

2121: -- setting insert flag to true to start
2122: insert_data := FND_API.g_true;
2123:
2124: -- content item
2125: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_ids(counter)) = FND_API.g_false) THEN
2126: --DBMS_OUTPUT.put_line('EX - content_item_id -- '||p_content_item_ids(counter) );
2127: insert_data := FND_API.g_false;
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');

Line 2140: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_ids(counter), p_citem_ver_ids(counter)) = FND_API.g_false)

2136: IF (insert_data = FND_API.g_true AND
2137: p_citem_ver_ids IS NOT NULL AND
2138: p_citem_ver_ids IS NOT NULL AND
2139: p_citem_ver_ids(counter) NOT IN (0, -1, -999, FND_API.G_MISS_NUM) AND
2140: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_ids(counter), p_citem_ver_ids(counter)) = FND_API.g_false)
2141: THEN
2142: insert_data := FND_API.g_false;
2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');

Line 2151: IF ( (insert_data = FND_API.g_true) AND (IBC_VALIDATE_PVT.isValidAttrCode(p_attribute_type_codes(counter),p_ctype_code) = FND_API.g_false) ) THEN

2147: RAISE FND_API.G_EXC_ERROR;
2148: END IF;
2149:
2150: -- attribute type code
2151: IF ( (insert_data = FND_API.g_true) AND (IBC_VALIDATE_PVT.isValidAttrCode(p_attribute_type_codes(counter),p_ctype_code) = FND_API.g_false) ) THEN
2152: --DBMS_OUTPUT.put_line('EX - attribute type');
2153: insert_data := FND_API.g_false;
2154: x_return_status := FND_API.G_RET_STS_ERROR;
2155: FND_MESSAGE.Set_Name('IBC', 'INVALID_ATT_TYPE');

Line 3260: IF (IBC_VALIDATE_PVT.isValidCType(p_ctype_code) = FND_API.g_true) THEN

3256: -- YES --> Is Content Item = NULL?
3257: IF (px_content_item_id IS NULL) THEN
3258: -- YES -- Does content type exist?
3259: -- miss_char will NOT work here!
3260: IF (IBC_VALIDATE_PVT.isValidCType(p_ctype_code) = FND_API.g_true) THEN
3261: -- YES --> Create new content item and version.
3262: -- create new item and version
3263: x_item_command := G_COMMAND_CREATE;
3264: x_version_command := G_COMMAND_CREATE;

Line 3276: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_true) THEN

3272: FND_MSG_PUB.ADD;
3273: END IF;
3274: ELSE
3275: -- NO --> Content Item exist?
3276: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_true) THEN
3277: -- YES --> Is this language = base language?
3278: x_base_lang := getBaseLanguage(px_content_item_id);
3279: IF (x_base_lang = p_language) THEN
3280: -- YES --> Create a new version with incremented version number! **

Line 3302: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_true) THEN

3298: END IF;
3299: END IF;
3300: ELSE
3301: -- NO --> Does this version exist?
3302: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_true) THEN
3303: -- making sure that a valid value exists for content item id
3304: px_content_item_id := getCitemId(p_citem_ver_id);
3305: x_base_lang := getBaseLanguage(px_content_item_id);
3306: -- YES --> Is it approved?

Line 3307: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

3303: -- making sure that a valid value exists for content item id
3304: px_content_item_id := getCitemId(p_citem_ver_id);
3305: x_base_lang := getBaseLanguage(px_content_item_id);
3306: -- YES --> Is it approved?
3307: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
3308: -- YES --> Is it the same language?
3309: IF (x_base_lang = p_language) THEN
3310: -- DBMS_OUTPUT.put_line('EX - content_item_id');
3311: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 3468: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

3464: );
3465: END IF;
3466:
3467: -- checking version id
3468: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
3469: --DBMS_OUTPUT.put_line('EX - p_citem_ver_id');
3470: x_return_status := FND_API.G_RET_STS_ERROR;
3471: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
3472: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 3759: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

3755: );
3756: END IF;
3757:
3758: -- citem validation
3759: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
3760: --DBMS_OUTPUT.put_line('EX - content_item_id');
3761: x_return_status := FND_API.G_RET_STS_ERROR;
3762: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
3763: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 4092: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

4088: );
4089: END IF;
4090:
4091: -- checking version id
4092: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
4093: --DBMS_OUTPUT.put_line('EX - p_citem_ver_id');
4094: x_return_status := FND_API.G_RET_STS_ERROR;
4095: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
4096: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 4102: IF (IBC_VALIDATE_PVT.isValidStatus(p_new_status) = FND_API.g_false) THEN

4098: RAISE FND_API.G_EXC_ERROR;
4099: END IF;
4100:
4101: -- checking if valid status
4102: IF (IBC_VALIDATE_PVT.isValidStatus(p_new_status) = FND_API.g_false) THEN
4103: --DBMS_OUTPUT.put_line('EX - p_status');
4104: x_return_status := FND_API.G_RET_STS_ERROR;
4105: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
4106: FND_MESSAGE.Set_Token('INPUT', 'p_status', FALSE);

Line 4111: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

4107: FND_MSG_PUB.ADD;
4108: RAISE FND_API.G_EXC_ERROR;
4109: END IF;
4110:
4111: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
4112: x_return_status := FND_API.G_RET_STS_ERROR;
4113: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
4114: FND_MSG_PUB.ADD;
4115: RAISE FND_API.G_EXC_ERROR;

Line 4522: IF ( (px_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(px_citem_ver_id) = FND_API.g_false) ) THEN

4518: px_object_version_number := 1;
4519: END IF;
4520:
4521: -- Filling in version id if non-existent
4522: IF ( (px_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(px_citem_ver_id) = FND_API.g_false) ) THEN
4523: IF (px_content_item_id IS NULL) THEN
4524: --DBMS_OUTPUT.put_line('EX - content_item_id');
4525: x_return_status := FND_API.G_RET_STS_ERROR;
4526: FND_MESSAGE.Set_Name('IBC', 'IBC_INPUT_REQUIRED');

Line 4532: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) THEN

4528: FND_MSG_PUB.ADD;
4529: RAISE FND_API.G_EXC_ERROR;
4530: END IF;
4531: -- getting item that needs to be copied
4532: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) THEN
4533: --DBMS_OUTPUT.put_line('EX - content_item_id');
4534: x_return_status := FND_API.G_RET_STS_ERROR;
4535: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
4536: FND_MESSAGE.Set_Token('INPUT', 'px_content_item_id', FALSE);

Line 5001: IF ( (px_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(px_citem_ver_id) = FND_API.g_false) ) THEN

4997: );
4998: END IF;
4999:
5000: -- Filling in version id if non-existent
5001: IF ( (px_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(px_citem_ver_id) = FND_API.g_false) ) THEN
5002: -- getting item that needs to be copied
5003: IF ( (px_content_item_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) ) THEN
5004: --DBMS_OUTPUT.put_line('EX - content_item_id');
5005: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5003: IF ( (px_content_item_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) ) THEN

4999:
5000: -- Filling in version id if non-existent
5001: IF ( (px_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(px_citem_ver_id) = FND_API.g_false) ) THEN
5002: -- getting item that needs to be copied
5003: IF ( (px_content_item_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) ) THEN
5004: --DBMS_OUTPUT.put_line('EX - content_item_id');
5005: x_return_status := FND_API.G_RET_STS_ERROR;
5006: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
5007: FND_MESSAGE.Set_Token('INPUT', 'px_content_item_id/px_citem_ver_id combination', FALSE);

Line 5232: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

5228: END IF;
5229:
5230: -- *** VALIDATION OF VALUES ******
5231: -- version id
5232: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
5233: --DBMS_OUTPUT.put_line('EX - citem_ver_id');
5234: x_return_status := FND_API.G_RET_STS_ERROR;
5235: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
5236: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 5242: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

5238: RAISE FND_API.G_EXC_ERROR;
5239: END IF;
5240:
5241: -- citem
5242: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
5243: --DBMS_OUTPUT.put_line('EX - content_item_id');
5244: x_return_status := FND_API.G_RET_STS_ERROR;
5245: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
5246: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 5538: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

5534: );
5535: END IF;
5536:
5537: -- citem validation
5538: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
5539: --DBMS_OUTPUT.put_line('EX - content_item_id');
5540: x_return_status := FND_API.G_RET_STS_ERROR;
5541: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
5542: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 5864: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

5860: );
5861: END IF;
5862:
5863: -- checking for valid inputs and throwing exception if invalid
5864: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
5865: --DBMS_OUTPUT.put_line('EX - CITEM_VER_ID');
5866: x_return_status := FND_API.G_RET_STS_ERROR;
5867: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
5868: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 6250: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

6246: END IF;
6247:
6248: -- checking for valid inputs and throwing exception if invalid
6249: -- validating item information
6250: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
6251: --DBMS_OUTPUT.put_line('EX - CITEM_VER_ID');
6252: x_return_status := FND_API.G_RET_STS_ERROR;
6253: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
6254: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 6266: IF (IBC_VALIDATE_PVT.isValidLanguage(lang) = FND_API.g_false) THEN

6262: lang := p_language;
6263: END IF;
6264:
6265: -- validating language
6266: IF (IBC_VALIDATE_PVT.isValidLanguage(lang) = FND_API.g_false) THEN
6267: --DBMS_OUTPUT.put_line('EX - LANGUAGE');
6268: x_return_status := FND_API.G_RET_STS_ERROR;
6269: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
6270: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);

Line 8101: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

8097: END IF;
8098:
8099: -- *** VALIDATION OF VALUES ******
8100: -- version id
8101: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
8102: --DBMS_OUTPUT.put_line('EX - citem_ver_id');
8103: x_return_status := FND_API.G_RET_STS_ERROR;
8104: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
8105: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 8424: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

8420: );
8421: END IF;
8422:
8423: -- citem
8424: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
8425: --DBMS_OUTPUT.put_line('EX - content_item_id');
8426: x_return_status := FND_API.G_RET_STS_ERROR;
8427: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
8428: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 8434: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id, p_citem_version_id) = FND_API.g_false)

8430: RAISE FND_API.G_EXC_ERROR;
8431: END IF;
8432:
8433: IF (p_citem_version_id IS NOT NULL AND
8434: IBC_VALIDATE_PVT.isValidCitemVerForCitem(p_content_item_id, p_citem_version_id) = FND_API.g_false)
8435: THEN
8436: --DBMS_OUTPUT.put_line('EX - content_item_id');
8437: x_return_status := FND_API.G_RET_STS_ERROR;
8438: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');

Line 8723: IF (IBC_VALIDATE_PVT.isValidCType(p_ctype_code) = FND_API.g_false) THEN

8719: FND_MSG_PUB.ADD;
8720: RAISE FND_API.G_EXC_ERROR;
8721: END IF;
8722: -- content type
8723: IF (IBC_VALIDATE_PVT.isValidCType(p_ctype_code) = FND_API.g_false) THEN
8724: --DBMS_OUTPUT.put_line('EX - ctype code');
8725: x_return_status := FND_API.G_RET_STS_ERROR;
8726: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
8727: FND_MESSAGE.Set_Token('INPUT', 'p_ctype_code', FALSE);

Line 8732: IF ( (p_dir_node_id <> Ibc_Utilities_Pub.G_COMMON_DIR_NODE) AND (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN

8728: FND_MSG_PUB.ADD;
8729: RAISE FND_API.G_EXC_ERROR;
8730: END IF;
8731: -- directory nodes
8732: IF ( (p_dir_node_id <> Ibc_Utilities_Pub.G_COMMON_DIR_NODE) AND (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN
8733: --DBMS_OUTPUT.put_line('EX - dir_node_id');
8734: x_return_status := FND_API.G_RET_STS_ERROR;
8735: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
8736: FND_MESSAGE.Set_Token('INPUT', 'p_dir_node_id', FALSE);

Line 8742: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) THEN

8738: RAISE FND_API.G_EXC_ERROR;
8739: END IF;
8740: -- checking if versioning is necessary
8741: IF (px_content_item_id IS NOT NULL) THEN
8742: IF (IBC_VALIDATE_PVT.isValidCitem(px_content_item_id) = FND_API.g_false) THEN
8743: --DBMS_OUTPUT.put_line('EX - content_item_id');
8744: x_return_status := FND_API.G_RET_STS_ERROR;
8745: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
8746: FND_MESSAGE.Set_Token('INPUT', 'px_content_item_id', FALSE);

Line 9073: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

9069: );
9070: END IF;
9071:
9072: -- citem validation
9073: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
9074: --DBMS_OUTPUT.put_line('EX - content_item_id');
9075: x_return_status := FND_API.G_RET_STS_ERROR;
9076: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
9077: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 9481: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

9477: END IF;
9478:
9479: --******************* INPUT VALIDATION ************
9480: -- validating item information
9481: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
9482: --DBMS_OUTPUT.put_line('EX - citem_ver_id');
9483: x_return_status := FND_API.G_RET_STS_ERROR;
9484: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
9485: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 9490: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

9486: FND_MSG_PUB.ADD;
9487: RAISE FND_API.G_EXC_ERROR;
9488: END IF;
9489:
9490: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
9491: --DBMS_OUTPUT.put_line('EX - updating approved');
9492: x_return_status := FND_API.G_RET_STS_ERROR;
9493: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
9494: FND_MSG_PUB.ADD;

Line 9857: IF ( (p_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) ) THEN

9853: END IF;
9854:
9855: -- *** VALIDATION OF VALUES ******
9856: -- version id
9857: IF ( (p_citem_ver_id IS NULL) OR (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) ) THEN
9858: --DBMS_OUTPUT.put_line('EX - citem_ver_id');
9859: x_return_status := FND_API.G_RET_STS_ERROR;
9860: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
9861: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 9867: IF (IBC_VALIDATE_PVT.isValidLanguage(p_language) = FND_API.g_false) THEN

9863: RAISE FND_API.G_EXC_ERROR;
9864: END IF;
9865:
9866: -- validating language
9867: IF (IBC_VALIDATE_PVT.isValidLanguage(p_language) = FND_API.g_false) THEN
9868: --DBMS_OUTPUT.put_line('EX - LANGUAGE');
9869: x_return_status := FND_API.G_RET_STS_ERROR;
9870: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
9871: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);

Line 9876: IF ((IBC_VALIDATE_PVT.getItemBaseLanguage(getCitemId(p_citem_ver_id))) = p_language) THEN

9872: FND_MSG_PUB.ADD;
9873: RAISE FND_API.G_EXC_ERROR;
9874: END IF;
9875:
9876: IF ((IBC_VALIDATE_PVT.getItemBaseLanguage(getCitemId(p_citem_ver_id))) = p_language) THEN
9877: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
9878: --DBMS_OUTPUT.put_line('EX - updating approved');
9879: x_return_status := FND_API.G_RET_STS_ERROR;
9880: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');

Line 9877: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

9873: RAISE FND_API.G_EXC_ERROR;
9874: END IF;
9875:
9876: IF ((IBC_VALIDATE_PVT.getItemBaseLanguage(getCitemId(p_citem_ver_id))) = p_language) THEN
9877: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
9878: --DBMS_OUTPUT.put_line('EX - updating approved');
9879: x_return_status := FND_API.G_RET_STS_ERROR;
9880: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
9881: FND_MSG_PUB.ADD;

Line 9885: IF (IBC_VALIDATE_PVT.isTranslationApproved(p_citem_ver_id,p_language) = FND_API.g_true) THEN

9881: FND_MSG_PUB.ADD;
9882: RAISE FND_API.G_EXC_ERROR;
9883: END IF;
9884: ELSE
9885: IF (IBC_VALIDATE_PVT.isTranslationApproved(p_citem_ver_id,p_language) = FND_API.g_true) THEN
9886: --DBMS_OUTPUT.put_line('EX - updating approved translation');
9887: x_return_status := FND_API.G_RET_STS_ERROR;
9888: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
9889: FND_MSG_PUB.ADD;

Line 9907: IF (IBC_VALIDATE_PVT.isValidAttachment(p_attach_file_id) = FND_API.g_false) THEN

9903: -- attachment
9904: -- if attachment given
9905: IF (p_attach_file_id IS NOT NULL) THEN
9906: -- check to see if attachment is valid
9907: IF (IBC_VALIDATE_PVT.isValidAttachment(p_attach_file_id) = FND_API.g_false) THEN
9908: --DBMS_OUTPUT.put_line('EX - p_attach_file_id');
9909: x_return_status := FND_API.G_RET_STS_ERROR;
9910: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
9911: FND_MESSAGE.Set_Token('INPUT', 'p_attach_file_id', FALSE);

Line 10216: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false) THEN

10212: END IF;
10213:
10214: -- *** VALIDATION OF VALUES ******
10215: -- item id
10216: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false) THEN
10217: --DBMS_OUTPUT.put_line('EX - citem_id');
10218: x_return_status := FND_API.G_RET_STS_ERROR;
10219: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10220: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 10225: IF (IBC_VALIDATE_PVT.isApprovedItem(p_content_item_id) = FND_API.g_true) THEN

10221: FND_MSG_PUB.ADD;
10222: RAISE FND_API.G_EXC_ERROR;
10223: END IF;
10224:
10225: IF (IBC_VALIDATE_PVT.isApprovedItem(p_content_item_id) = FND_API.g_true) THEN
10226: --DBMS_OUTPUT.put_line('EX - updating approved');
10227: x_return_status := FND_API.G_RET_STS_ERROR;
10228: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
10229: FND_MSG_PUB.ADD;

Line 10234: IF ( (p_dir_node_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN

10230: RAISE FND_API.G_EXC_ERROR;
10231: END IF;
10232:
10233: IF (p_dir_node_id IS NOT NULL) THEN
10234: IF ( (p_dir_node_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN
10235: --DBMS_OUTPUT.put_line('EX - dir_node_id');
10236: x_return_status := FND_API.G_RET_STS_ERROR;
10237: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10238: FND_MESSAGE.Set_Token('INPUT', 'p_dir_node_id', FALSE);

Line 10258: IF ( (p_parent_item_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidCitem(p_parent_item_id) = FND_API.g_false)) THEN

10254: FND_MSG_PUB.ADD;
10255: RAISE FND_API.G_EXC_ERROR;
10256: END IF;
10257: -- parent item id
10258: IF ( (p_parent_item_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidCitem(p_parent_item_id) = FND_API.g_false)) THEN
10259: --DBMS_OUTPUT.put_line('EX - parent item id');
10260: x_return_status := FND_API.G_RET_STS_ERROR;
10261: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10262: FND_MESSAGE.Set_Token('INPUT', 'p_parent_item_id', FALSE);

Line 10267: IF ( (p_wd_restricted <> FND_API.g_miss_char) AND (IBC_VALIDATE_PVT.isBoolean(p_wd_restricted) = FND_API.g_false) ) THEN

10263: FND_MSG_PUB.ADD;
10264: RAISE FND_API.G_EXC_ERROR;
10265: END IF;
10266: -- wd restricted
10267: IF ( (p_wd_restricted <> FND_API.g_miss_char) AND (IBC_VALIDATE_PVT.isBoolean(p_wd_restricted) = FND_API.g_false) ) THEN
10268: --DBMS_OUTPUT.put_line('EX - wd_restricted');
10269: x_return_status := FND_API.G_RET_STS_ERROR;
10270: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10271: FND_MESSAGE.Set_Token('INPUT', 'p_wd_restricted', FALSE);

Line 10294: IF (IBC_VALIDATE_PVT.isValidResource(p_new_owner_resource_id,p_new_owner_resource_type) = FND_API.g_false) THEN

10290: p_new_owner_resource_type := 'USER';
10291: END IF;
10292:
10293:
10294: IF (IBC_VALIDATE_PVT.isValidResource(p_new_owner_resource_id,p_new_owner_resource_type) = FND_API.g_false) THEN
10295: x_return_status := FND_API.G_RET_STS_ERROR;
10296: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10297: FND_MESSAGE.Set_Token('INPUT', 'p_owner_resource_id/p_owner_resource_type<' || p_new_owner_resource_id||':'||p_new_owner_resource_type||'>', FALSE);
10298: FND_MSG_PUB.ADD;

Line 10545: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false) THEN

10541:
10542: -- *** VALIDATION OF VALUES ******
10543:
10544: -- content item id
10545: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false) THEN
10546: x_return_status := FND_API.G_RET_STS_ERROR;
10547: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10548: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);
10549: FND_MSG_PUB.ADD;

Line 10553: IF (IBC_VALIDATE_PVT.isApprovedItem(p_content_item_id) = FND_API.g_false) THEN

10549: FND_MSG_PUB.ADD;
10550: RAISE FND_API.G_EXC_ERROR;
10551: END IF;
10552:
10553: IF (IBC_VALIDATE_PVT.isApprovedItem(p_content_item_id) = FND_API.g_false) THEN
10554: x_return_status := FND_API.G_RET_STS_ERROR;
10555: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10556: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);
10557: FND_MSG_PUB.ADD;

Line 10561: IF (IBC_VALIDATE_PVT.isapproved(p_citem_ver_id) = FND_API.g_false) THEN

10557: FND_MSG_PUB.ADD;
10558: RAISE FND_API.G_EXC_ERROR;
10559: END IF;
10560:
10561: IF (IBC_VALIDATE_PVT.isapproved(p_citem_ver_id) = FND_API.g_false) THEN
10562: x_return_status := FND_API.G_RET_STS_ERROR;
10563: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10564: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);
10565: FND_MSG_PUB.ADD;

Line 10798: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

10794: END IF;
10795:
10796: -- *** VALIDATION OF VALUES ******
10797: -- item id
10798: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
10799: --DBMS_OUTPUT.put_line('EX - citem_ver_id');
10800: x_return_status := FND_API.G_RET_STS_ERROR;
10801: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
10802: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 10807: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

10803: FND_MSG_PUB.ADD;
10804: RAISE FND_API.G_EXC_ERROR;
10805: END IF;
10806:
10807: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
10808: --DBMS_OUTPUT.put_line('EX - updating approved');
10809: x_return_status := FND_API.G_RET_STS_ERROR;
10810: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
10811: FND_MSG_PUB.ADD;

Line 11088: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

11084: );
11085: END IF;
11086:
11087: -- citem validation
11088: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
11089: --DBMS_OUTPUT.put_line('EX - content_item_id');
11090: x_return_status := FND_API.G_RET_STS_ERROR;
11091: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11092: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 11367: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN

11363: );
11364: END IF;
11365:
11366: -- citem validation
11367: IF (IBC_VALIDATE_PVT.isValidCitem(p_content_item_id) = FND_API.g_false ) THEN
11368: --DBMS_OUTPUT.put_line('EX - content_item_id');
11369: x_return_status := FND_API.G_RET_STS_ERROR;
11370: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11371: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);

Line 11737: (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN

11733: END IF;
11734: -- directory nodes
11735: IF ( (p_dir_node_id <> Ibc_Utilities_Pub.G_COMMON_DIR_NODE) AND
11736: (p_dir_node_id <> FND_API.G_MISS_NUM) AND
11737: (IBC_VALIDATE_PVT.isValidDirNode(p_dir_node_id) = FND_API.g_false) ) THEN
11738: --DBMS_OUTPUT.put_line('EX - dir_node_id');
11739: x_return_status := FND_API.G_RET_STS_ERROR;
11740: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11741: FND_MESSAGE.Set_Token('INPUT', 'p_dir_node_id', FALSE);

Line 11746: IF (IBC_VALIDATE_PVT.isValidStatus(p_status) = FND_API.g_false) THEN

11742: FND_MSG_PUB.ADD;
11743: RAISE FND_API.G_EXC_ERROR;
11744: END IF;
11745: -- p_status
11746: IF (IBC_VALIDATE_PVT.isValidStatus(p_status) = FND_API.g_false) THEN
11747: --DBMS_OUTPUT.put_line('EX - p_status');
11748: x_return_status := FND_API.G_RET_STS_ERROR;
11749: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11750: FND_MESSAGE.Set_Token('INPUT', 'p_status', FALSE);

Line 11773: IF (IBC_VALIDATE_PVT.isBoolean(p_trans_required) = FND_API.g_false) THEN

11769: FND_MSG_PUB.ADD;
11770: RAISE FND_API.G_EXC_ERROR;
11771: END IF;
11772: -- p_trans_required
11773: IF (IBC_VALIDATE_PVT.isBoolean(p_trans_required) = FND_API.g_false) THEN
11774: --DBMS_OUTPUT.put_line('EX - p_trans req');
11775: x_return_status := FND_API.G_RET_STS_ERROR;
11776: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11777: FND_MESSAGE.Set_Token('INPUT', 'p_trans_required', FALSE);

Line 11782: IF ( (p_parent_item_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidCitem(p_parent_item_id) = FND_API.g_false)) THEN

11778: FND_MSG_PUB.ADD;
11779: RAISE FND_API.G_EXC_ERROR;
11780: END IF;
11781: -- parent item id
11782: IF ( (p_parent_item_id <> FND_API.g_miss_num) AND (IBC_VALIDATE_PVT.isValidCitem(p_parent_item_id) = FND_API.g_false)) THEN
11783: --DBMS_OUTPUT.put_line('EX - parent item id');
11784: x_return_status := FND_API.G_RET_STS_ERROR;
11785: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11786: FND_MESSAGE.Set_Token('INPUT', 'p_parent_item_id', FALSE);

Line 11791: IF (IBC_VALIDATE_PVT.isBoolean(p_lock_flag) = FND_API.g_false) THEN

11787: FND_MSG_PUB.ADD;
11788: RAISE FND_API.G_EXC_ERROR;
11789: END IF;
11790: -- p_lock_flag
11791: IF (IBC_VALIDATE_PVT.isBoolean(p_lock_flag) = FND_API.g_false) THEN
11792: --DBMS_OUTPUT.put_line('EX - p_lock_flag');
11793: x_return_status := FND_API.G_RET_STS_ERROR;
11794: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11795: FND_MESSAGE.Set_Token('INPUT', 'p_lock_flag', FALSE);

Line 11800: IF (IBC_VALIDATE_PVT.isBoolean(p_wd_restricted) = FND_API.g_false) THEN

11796: FND_MSG_PUB.ADD;
11797: RAISE FND_API.G_EXC_ERROR;
11798: END IF;
11799: -- p_wd_restricted
11800: IF (IBC_VALIDATE_PVT.isBoolean(p_wd_restricted) = FND_API.g_false) THEN
11801: --DBMS_OUTPUT.put_line('EX - p_wd_restricted');
11802: x_return_status := FND_API.G_RET_STS_ERROR;
11803: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11804: FND_MESSAGE.Set_Token('INPUT', 'p_wd_restricted', FALSE);

Line 11834: IF (IBC_VALIDATE_PVT.isValidResource(p_new_owner_resource_id,p_new_owner_resource_type) = FND_API.g_false) THEN

11830: p_new_owner_resource_type := 'USER';
11831: END IF;
11832:
11833:
11834: IF (IBC_VALIDATE_PVT.isValidResource(p_new_owner_resource_id,p_new_owner_resource_type) = FND_API.g_false) THEN
11835: --DBMS_OUTPUT.put_line('EX - invalid resource id');
11836: x_return_status := FND_API.G_RET_STS_ERROR;
11837: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
11838: FND_MESSAGE.Set_Token('INPUT', 'p_owner_resource_id/p_owner_resource_type<' || p_new_owner_resource_id||':'||p_new_owner_resource_type||'>', FALSE);

Line 12020: IF (IBC_VALIDATE_PVT.isValidAttachment(p_item_renditions(I)) = FND_API.g_false) THEN

12016: WHERE citem_version_id = px_citem_ver_id
12017: AND LANGUAGE = lang;
12018:
12019: FOR I IN 1..p_item_renditions.COUNT LOOP
12020: IF (IBC_VALIDATE_PVT.isValidAttachment(p_item_renditions(I)) = FND_API.g_false) THEN
12021: x_return_status := FND_API.G_RET_STS_ERROR;
12022: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
12023: FND_MESSAGE.Set_Token('INPUT', 'p_item_renditions', FALSE);
12024: FND_MSG_PUB.ADD;

Line 12040: IF (IBC_VALIDATE_PVT.isValidAttachment(p_attach_file_id) = FND_API.g_false) THEN

12036:
12037: IF ((p_attach_file_id IS NOT NULL) AND
12038: (do_version <> G_COMMAND_POST_APPROVAL_UPDATE)) THEN
12039:
12040: IF (IBC_VALIDATE_PVT.isValidAttachment(p_attach_file_id) = FND_API.g_false) THEN
12041: x_return_status := FND_API.G_RET_STS_ERROR;
12042: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
12043: FND_MESSAGE.Set_Token('INPUT', 'p_attach_file_id', FALSE);
12044: FND_MSG_PUB.ADD;

Line 13596: IF IBC_VALIDATE_PVT.isvalidcitem(l_citem_id) = FND_API.g_false THEN

13592:
13593: FOR i IN 1..p_content_item_ids.COUNT LOOP
13594: l_citem_id := p_content_item_ids(i);
13595:
13596: IF IBC_VALIDATE_PVT.isvalidcitem(l_citem_id) = FND_API.g_false THEN
13597: x_return_status := FND_API.G_RET_STS_ERROR;
13598: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
13599: FND_MESSAGE.Set_Token('INPUT', 'content_item_id:[' || l_citem_id || ']', FALSE);
13600: FND_MSG_PUB.ADD;

Line 13861: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN

13857: );
13858: END IF;
13859:
13860: -- checking version id
13861: IF (IBC_VALIDATE_PVT.isValidCitemVer(p_citem_ver_id) = FND_API.g_false) THEN
13862: --DBMS_OUTPUT.put_line('EX - p_citem_ver_id');
13863: x_return_status := FND_API.G_RET_STS_ERROR;
13864: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
13865: FND_MESSAGE.Set_Token('INPUT', 'p_citem_ver_id', FALSE);

Line 13871: IF (IBC_VALIDATE_PVT.isValidStatus(p_new_status) = FND_API.g_false) THEN

13867: RAISE FND_API.G_EXC_ERROR;
13868: END IF;
13869:
13870: -- checking if valid status
13871: IF (IBC_VALIDATE_PVT.isValidStatus(p_new_status) = FND_API.g_false) THEN
13872: --DBMS_OUTPUT.put_line('EX - p_status');
13873: x_return_status := FND_API.G_RET_STS_ERROR;
13874: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
13875: FND_MESSAGE.Set_Token('INPUT', 'p_status', FALSE);

Line 13881: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN

13877: RAISE FND_API.G_EXC_ERROR;
13878: END IF;
13879:
13880: /*
13881: IF (IBC_VALIDATE_PVT.isApproved(p_citem_ver_id) = FND_API.g_true) THEN
13882: x_return_status := FND_API.G_RET_STS_ERROR;
13883: FND_MESSAGE.Set_Name('IBC', 'UPDATE_APPROVED_ITEM_ERROR');
13884: FND_MSG_PUB.ADD;
13885: RAISE FND_API.G_EXC_ERROR;

Line 13889: IF (IBC_VALIDATE_PVT.isTranslationApproved(p_citem_ver_id

13885: RAISE FND_API.G_EXC_ERROR;
13886: END IF;
13887: */
13888:
13889: IF (IBC_VALIDATE_PVT.isTranslationApproved(p_citem_ver_id
13890: ,p_language
13891: ) = FND_API.g_true) THEN
13892: x_return_status := FND_API.G_RET_STS_ERROR;
13893: FND_MESSAGE.Set_Name('IBC', 'IBC_TRANSLATION_UPDATE_ERROR');