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.IBC_CITEM_ADMIN_GRP dependencies on IBC_UTILITIES_PUB

Line 255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;

251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code
254: AND
255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;
256:
257: BEGIN
258: --DBMS_OUTPUT.put_line('----- getAttachAttribCode-----');
259: OPEN c_acode;

Line 1111: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_TEXT) THEN

1107: FND_MSG_PUB.ADD;
1108: x_return_status := FND_API.G_RET_STS_ERROR;
1109: END IF;
1110: -- string length
1111: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_TEXT) THEN
1112: IF (LENGTH(temp_attribute) > att_size) THEN
1113: FND_MESSAGE.Set_Name('IBC', 'IBC_VALATTR_DATA_LENGTH');
1114: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME', get_Attribute_type_name(p_ctype_code, p_attribute_type_codes(counter)), FALSE);
1115: FND_MESSAGE.Set_Token('DATA_LENGTH', att_size);

Line 1120: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_NUMBER) THEN

1116: FND_MSG_PUB.ADD;
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;

Line 1128: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_DATE) THEN

1124: FND_MSG_PUB.ADD;
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;

Line 1136: ELSIF (att_type = IBC_UTILITIES_PUB.G_DTC_BOOLEAN) THEN

1132: FND_MSG_PUB.ADD;
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;

Line 1144: ELSIF ( (att_type = IBC_UTILITIES_PUB.G_DTC_COMPONENT) OR (att_type = IBC_UTILITIES_PUB.G_DTC_ATTACHMENT) ) THEN

1140: FND_MSG_PUB.ADD;
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: END IF;
1143: -- boolean
1144: ELSIF ( (att_type = IBC_UTILITIES_PUB.G_DTC_COMPONENT) OR (att_type = IBC_UTILITIES_PUB.G_DTC_ATTACHMENT) ) THEN
1145: --DBMS_OUTPUT.put_line('EX - non primitive code');
1146: FND_MESSAGE.Set_Name('IBC', 'NON_PRIM_ATTRIB_ERROR');
1147: FND_MSG_PUB.ADD;
1148: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1156: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,

1152: -- only storing if an error has not yet been encountered
1153: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1154: -- Open TAG
1155: -- Building xml string to be stored
1156: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1157: IBC_UTILITIES_PUB.G_DTC_HTML,
1158: IBC_UTILITIES_PUB.G_DTC_URL))
1159: THEN
1160: -- If not TEXT or HTML or URL -> regular formatting

Line 1157: IBC_UTILITIES_PUB.G_DTC_HTML,

1153: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1154: -- Open TAG
1155: -- Building xml string to be stored
1156: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1157: IBC_UTILITIES_PUB.G_DTC_HTML,
1158: IBC_UTILITIES_PUB.G_DTC_URL))
1159: THEN
1160: -- If not TEXT or HTML or URL -> regular formatting
1161: temp_text := '<'||p_attribute_type_codes(counter)||' datatype="'||att_type||'">';

Line 1158: IBC_UTILITIES_PUB.G_DTC_URL))

1154: -- Open TAG
1155: -- Building xml string to be stored
1156: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1157: IBC_UTILITIES_PUB.G_DTC_HTML,
1158: IBC_UTILITIES_PUB.G_DTC_URL))
1159: THEN
1160: -- If not TEXT or HTML or URL -> regular formatting
1161: temp_text := '<'||p_attribute_type_codes(counter)||' datatype="'||att_type||'">';
1162: ELSE

Line 1170: IF (att_type = IBC_UTILITIES_PUB.G_DTC_DATE) THEN

1166: END IF;
1167: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);
1168:
1169: -- Actual Attribute Value
1170: IF (att_type = IBC_UTILITIES_PUB.G_DTC_DATE) THEN
1171: BEGIN
1172: -- Bug# 3625846
1173: temp_text := FND_DATE.date_to_canonical(TO_DATE(p_attributes(counter),
1174: FND_PROFILE.value('ICX_DATE_FORMAT_MASK')));

Line 1201: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,

1197: END LOOP;
1198:
1199: -- Close TAG
1200: -- Building xml string to be stored
1201: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1202: IBC_UTILITIES_PUB.G_DTC_HTML,
1203: IBC_UTILITIES_PUB.G_DTC_URL))
1204: THEN
1205: -- If not TEXT or HTML or URL -> regular formatting

Line 1202: IBC_UTILITIES_PUB.G_DTC_HTML,

1198:
1199: -- Close TAG
1200: -- Building xml string to be stored
1201: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1202: IBC_UTILITIES_PUB.G_DTC_HTML,
1203: IBC_UTILITIES_PUB.G_DTC_URL))
1204: THEN
1205: -- If not TEXT or HTML or URL -> regular formatting
1206: temp_text := '';

Line 1203: IBC_UTILITIES_PUB.G_DTC_URL))

1199: -- Close TAG
1200: -- Building xml string to be stored
1201: IF (att_type NOT IN (IBC_UTILITIES_PUB.G_DTC_TEXT,
1202: IBC_UTILITIES_PUB.G_DTC_HTML,
1203: IBC_UTILITIES_PUB.G_DTC_URL))
1204: THEN
1205: -- If not TEXT or HTML or URL -> regular formatting
1206: temp_text := '';
1207: ELSE

Line 1441: ,p_citem_version_status => IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS

1437: x_rowid => row_id
1438: ,px_citem_version_id => new_citem_ver_id
1439: ,p_content_item_id => px_content_item_id
1440: ,p_version_number => new_ver_num
1441: ,p_citem_version_status => IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS
1442: ,p_start_date => o_start_date
1443: ,p_end_date => o_end_date
1444: ,px_object_version_number => px_object_version_number
1445: ,p_attribute_file_id => new_attrib_fid

Line 1489: IBC_UTILITIES_PUB.g_stv_work_in_progress

1485: last_updated_by,
1486: last_update_login,
1487: LANGUAGE,
1488: source_lang,
1489: IBC_UTILITIES_PUB.g_stv_work_in_progress
1490: FROM IBC_CITEM_VERSIONS_TL
1491: WHERE citem_version_id = px_citem_ver_id
1492: AND LANGUAGE <> p_language;
1493:

Line 1796: IF attributes(counter) IS NOT NULL AND dtc = IBC_UTILITIES_PUB.G_DTC_DATE THEN

1792: END IF;
1793:
1794: -- Conversion from storage format (canonical) to client date format in case of Date
1795: -- Bug# 3625846
1796: IF attributes(counter) IS NOT NULL AND dtc = IBC_UTILITIES_PUB.G_DTC_DATE THEN
1797: BEGIN
1798: l_res_buffer := attributes(counter);
1799: attributes(counter) := TO_CHAR(FND_DATE.canonical_to_date(attributes(counter)),
1800: FND_PROFILE.value('ICX_DATE_FORMAT_MASK'));

Line 2399: IF (getContentItemStatus(citem_id) <> IBC_UTILITIES_PUB.G_STI_APPROVED) THEN

2395: END IF;
2396:
2397: -- if it is required then check to see if it is approved!
2398: IF(p_minimum > 0) THEN
2399: IF (getContentItemStatus(citem_id) <> IBC_UTILITIES_PUB.G_STI_APPROVED) THEN
2400: --DBMS_OUTPUT.put_line('EX - component not approved');
2401: x_return_status := FND_API.G_RET_STS_ERROR;
2402: FND_MESSAGE.Set_Name('IBC', 'COMPONENT_APPROVAL_REQUIRED');
2403: FND_MESSAGE.Set_Token('CONTENT_ITEM_ID', citem_id, FALSE);

Line 2680: ELSIF(r_attribute.dtc = Ibc_Utilities_Pub.G_DTC_COMPONENT) THEN

2676: END IF;
2677: END IF;
2678:
2679: -- do not check if the data type code is a component...
2680: ELSIF(r_attribute.dtc = Ibc_Utilities_Pub.G_DTC_COMPONENT) THEN
2681: validate_components(
2682: p_citem_version_id => p_citem_ver_id
2683: ,p_content_type_code => ctype_code
2684: ,p_attribute_type_code => r_attribute.atc

Line 2699: ELSIF(r_attribute.dtc = Ibc_Utilities_Pub.G_DTC_ATTACHMENT) THEN

2695: x_return_status := FND_API.G_RET_STS_ERROR;
2696: END IF;
2697:
2698: -- making sure attachments only appear once
2699: ELSIF(r_attribute.dtc = Ibc_Utilities_Pub.G_DTC_ATTACHMENT) THEN
2700:
2701: -- No more renditions support for attachments.
2702: -- IF attachment valid_element_count = 1 ELSE 0
2703: IF attach_file_id IS NOT NULL THEN

Line 3065: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED

3061: -- update version status
3062: Ibc_Citem_Versions_Pkg.update_row(
3063: p_CITEM_VERSION_ID => p_citem_ver_id
3064: ,p_content_item_id => p_content_item_id
3065: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED
3066: ,P_SOURCE_LANG => p_base_lang
3067: ,px_object_version_number => px_object_version_number
3068: ,p_citem_translation_status => Ibc_Utilities_Pub.G_STV_APPROVED
3069: );

Line 3068: ,p_citem_translation_status => Ibc_Utilities_Pub.G_STV_APPROVED

3064: ,p_content_item_id => p_content_item_id
3065: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED
3066: ,P_SOURCE_LANG => p_base_lang
3067: ,px_object_version_number => px_object_version_number
3068: ,p_citem_translation_status => Ibc_Utilities_Pub.G_STV_APPROVED
3069: );
3070:
3071: --DBMS_OUTPUT.put_line('APPROVING ITEM');
3072: -- set live version if this is base language

Line 3076: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_APPROVED

3072: -- set live version if this is base language
3073: Ibc_Content_Items_Pkg.update_row (
3074: p_CONTENT_ITEM_ID => p_content_item_id
3075: ,p_LIVE_CITEM_VERSION_ID => p_citem_ver_id
3076: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_APPROVED
3077: ,p_LOCKED_BY_USER_ID => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3078: ,px_object_version_number => px_object_version_number
3079: );
3080:

Line 3088: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED

3084: Ibc_Citem_Versions_Pkg.populate_all_lang (
3085: p_CITEM_VERSION_ID => temp
3086: ,p_CONTENT_ITEM_ID => p_content_item_id
3087: ,p_VERSION_NUMBER => version_number
3088: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED
3089: ,p_START_DATE => start_date
3090: ,p_END_DATE => end_date
3091: ,p_OBJECT_VERSION_NUMBER => ovn
3092: ,p_ATTRIBUTE_FILE_ID => attrib_fid

Line 3519: ibc_citem_versions_b.citem_version_status = Ibc_Utilities_Pub.G_STV_APPROVED

3515: (
3516: (
3517: ibc_citem_versions_tl.LANGUAGE = ibc_citem_versions_tl.source_lang
3518: AND
3519: ibc_citem_versions_b.citem_version_status = Ibc_Utilities_Pub.G_STV_APPROVED
3520: )
3521: OR
3522: ibc_citem_versions_tl.source_lang = base_lang
3523: )

Line 3540: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);

3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;
3538:
3539: -- Can be approved if in case of having components they are already approved.
3540: OPEN c_component_not_status(p_citem_ver_id, IBC_UTILITIES_PUB.G_STV_APPROVED);
3541: FETCH c_component_not_status INTO l_dummy;
3542: IF (c_component_not_status%FOUND) THEN
3543: CLOSE c_component_not_status;
3544: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3771: IF (isCitemVerInPassedStatus(p_content_item_id,IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL))THEN

3767:
3768: -- Version Status validation
3769: -- If any content item version is in a submitted status then the Content Item
3770: -- cannot be archived
3771: IF (isCitemVerInPassedStatus(p_content_item_id,IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL))THEN
3772: x_return_status := FND_API.G_RET_STS_ERROR;
3773: FND_MESSAGE.Set_Name('IBC', 'IBC_ITEM_INVALID_FOR_ARCHIVE');
3774: FND_MSG_PUB.ADD;
3775: RAISE FND_API.G_EXC_ERROR;

Line 3810: IN (Ibc_Utilities_Pub.G_STI_ARCHIVED, Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE))

3806: END IF;
3807:
3808: -- If already archived then raise error
3809: IF (getContentItemStatus(p_content_item_id)
3810: IN (Ibc_Utilities_Pub.G_STI_ARCHIVED, Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE))
3811: THEN
3812: --DBMS_OUTPUT.put_line('EX - content_item_id');
3813: x_return_status := FND_API.G_RET_STS_ERROR;
3814: FND_MESSAGE.Set_Name('IBC', 'IBC_CITEM_ALREADY_ARCHIVED');

Line 3883: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED

3879: -- Actual update
3880: IF p_cascaded_flag = FND_API.g_false THEN
3881: Ibc_Content_Items_Pkg.update_row (
3882: p_content_item_id => p_content_item_id
3883: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED
3884: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3885: ,px_object_version_number => px_object_version_number
3886: );
3887: ELSE

Line 3890: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE

3886: );
3887: ELSE
3888: Ibc_Content_Items_Pkg.update_row (
3889: p_content_item_id => p_content_item_id
3890: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE
3891: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3892: ,px_object_version_number => px_object_version_number
3893: );
3894: END IF;

Line 4139: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED)

4135: ,p_container_pk1_value => dir_id --|*|
4136: ,p_current_user_id => FND_GLOBAL.user_id --|*|
4137: ) = FND_API.g_false
4138: AND
4139: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED)
4140: OR
4141: IBC_DATA_SECURITY_PVT.has_permission( --|*|
4142: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
4143: ,p_instance_pk1_value => content_item_id --|*|

Line 4161: IF (p_new_status = Ibc_Utilities_Pub.G_STV_APPROVED ) THEN

4157: END IF; --|*|
4158: -- ***************PERMISSION CHECK*********************************************************************
4159:
4160:
4161: IF (p_new_status = Ibc_Utilities_Pub.G_STV_APPROVED ) THEN
4162: approve_item(
4163: p_citem_ver_id => p_citem_ver_id
4164: ,p_api_version_number => p_api_version_number
4165: ,px_object_version_number => px_object_version_number

Line 4210: IF p_new_status = IBC_UTILITIES_PUB.G_STV_APPROVED THEN

4206: ,p_object_value5 => NULL
4207: ,p_description => 'Updating version'
4208: );
4209: --***************************************************
4210: IF p_new_status = IBC_UTILITIES_PUB.G_STV_APPROVED THEN
4211: Ibc_Utilities_Pvt.log_action(
4212: p_activity => Ibc_Utilities_Pvt.G_ALA_APPROVE
4213: ,p_parent_value => content_item_id
4214: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION

Line 4222: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN

4218: ,p_object_value4 => NULL
4219: ,p_object_value5 => NULL
4220: ,p_description => 'Approved'
4221: );
4222: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN
4223: Ibc_Utilities_Pvt.log_action(
4224: p_activity => Ibc_Utilities_Pvt.G_ALA_SUBMIT
4225: ,p_parent_value => content_item_id
4226: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION

Line 4234: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN

4230: ,p_object_value4 => NULL
4231: ,p_object_value5 => NULL
4232: ,p_description => 'Submitted for Approval'
4233: );
4234: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN
4235: Ibc_Utilities_Pvt.log_action(
4236: p_activity => Ibc_Utilities_Pvt.G_ALA_REJECT
4237: ,p_parent_value => content_item_id
4238: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION

Line 4246: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED THEN

4242: ,p_object_value4 => NULL
4243: ,p_object_value5 => NULL
4244: ,p_description => 'Rejected'
4245: );
4246: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED THEN
4247: Ibc_Utilities_Pvt.log_action(
4248: p_activity => Ibc_Utilities_Pvt.G_ALA_ARCHIVE
4249: ,p_parent_value => content_item_id
4250: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION

Line 4617: ,p_content_item_status => IBC_UTILITIES_PUB.G_STI_PENDING

4613: ,p_content_type_code => o_ctype_code
4614: ,p_item_reference_code => p_item_reference_code
4615: ,p_directory_node_id => NVL(p_directory_node_id, o_dir_node)
4616: ,p_live_citem_version_id => NULL
4617: ,p_content_item_status => IBC_UTILITIES_PUB.G_STI_PENDING
4618: ,p_locked_by_user_id => NULL
4619: ,p_wd_restricted_flag => o_wd_flag
4620: ,p_base_language => lang
4621: ,p_translation_required_flag => o_trans_flag

Line 8645: status IBC_CONTENT_ITEMS.content_item_status%TYPE := Ibc_Utilities_Pub.G_STI_PENDING;

8641: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
8642: --******************* END REQUIRED VARIABLES ***************************
8643: row_id VARCHAR2(250); -- required for use with table handlers
8644: locked_by NUMBER; -- variable used to set locked_by column (logic needed)
8645: status IBC_CONTENT_ITEMS.content_item_status%TYPE := Ibc_Utilities_Pub.G_STI_PENDING;
8646: current_version NUMBER;
8647: BEGIN
8648: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
8649: --******************* BEGIN REQUIRED AREA ******************************

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 10245: directory_node := Ibc_Utilities_Pub.G_COMMON_DIR_NODE;

10241: ELSE
10242: directory_node := p_dir_node_id;
10243: END IF;
10244: ELSE
10245: directory_node := Ibc_Utilities_Pub.G_COMMON_DIR_NODE;
10246: END IF;
10247:
10248: -- trans required
10249: IF ( (p_trans_required <> FND_API.g_false) AND (p_trans_required <> FND_API.g_true) AND (p_trans_required <> FND_API.g_miss_char) ) THEN

Line 11098: NOT IN (IBC_UTILITIES_PUB.G_STI_ARCHIVED, IBC_UTILITIES_PUB.G_STI_ARCHIVED_CASCADE))

11094: RAISE FND_API.G_EXC_ERROR;
11095: END IF;
11096:
11097: IF (getContentItemStatus(p_content_item_id)
11098: NOT IN (IBC_UTILITIES_PUB.G_STI_ARCHIVED, IBC_UTILITIES_PUB.G_STI_ARCHIVED_CASCADE))
11099: THEN
11100: x_return_status := FND_API.G_RET_STS_ERROR;
11101: FND_MESSAGE.Set_Name('IBC', 'IBC_CITEM_NOT_ARCHIVED');
11102: FND_MSG_PUB.ADD;

Line 11153: new_status := Ibc_Utilities_Pub.G_STI_PENDING;

11149:
11150: -- which status was it previously in?
11151: IF (citem_version_id IS NULL) THEN
11152: -- since there was no live version id, it was PENDING
11153: new_status := Ibc_Utilities_Pub.G_STI_PENDING;
11154: ELSE
11155: -- was approved
11156: new_status := Ibc_Utilities_Pub.G_STI_APPROVED;
11157:

Line 11156: new_status := Ibc_Utilities_Pub.G_STI_APPROVED;

11152: -- since there was no live version id, it was PENDING
11153: new_status := Ibc_Utilities_Pub.G_STI_PENDING;
11154: ELSE
11155: -- was approved
11156: new_status := Ibc_Utilities_Pub.G_STI_APPROVED;
11157:
11158: -- reapprove live version to make sure that is still valid
11159: approve_citem_version_int(
11160: p_citem_ver_id => citem_version_id

Line 11677: IF (p_status = Ibc_Utilities_Pub.G_STV_APPROVED) THEN

11673: lang := p_language;
11674: END IF;
11675:
11676: -- setting temporary status
11677: IF (p_status = Ibc_Utilities_Pub.G_STV_APPROVED) THEN
11678: bulk_status := Ibc_Utilities_Pub.G_STV_SUBMIT_FOR_APPROVAL;
11679: ELSE
11680: bulk_status := p_status;
11681: END IF;

Line 11678: bulk_status := Ibc_Utilities_Pub.G_STV_SUBMIT_FOR_APPROVAL;

11674: END IF;
11675:
11676: -- setting temporary status
11677: IF (p_status = Ibc_Utilities_Pub.G_STV_APPROVED) THEN
11678: bulk_status := Ibc_Utilities_Pub.G_STV_SUBMIT_FOR_APPROVAL;
11679: ELSE
11680: bulk_status := p_status;
11681: END IF;
11682:

Line 11684: directory_node := Ibc_Utilities_Pub.G_COMMON_DIR_NODE;

11680: bulk_status := p_status;
11681: END IF;
11682:
11683: IF (p_dir_node_id IS NULL) THEN
11684: directory_node := Ibc_Utilities_Pub.G_COMMON_DIR_NODE;
11685: ELSE
11686: directory_node := p_dir_node_id;
11687: END IF;
11688: -- --------------------------------------------------------------------

Line 11735: IF ( (p_dir_node_id <> Ibc_Utilities_Pub.G_COMMON_DIR_NODE) AND

11731: FND_MSG_PUB.ADD;
11732: RAISE FND_API.G_EXC_ERROR;
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;

Line 11902: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_PENDING

11898: ,p_CONTENT_TYPE_CODE => p_ctype_code
11899: ,p_ITEM_REFERENCE_CODE => p_reference_code
11900: ,p_DIRECTORY_NODE_ID => directory_node
11901: ,p_LIVE_CITEM_VERSION_ID => NULL
11902: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_PENDING
11903: ,p_LOCKED_BY_USER_ID => locked_by
11904: ,p_WD_RESTRICTED_FLAG => p_wd_restricted
11905: ,p_BASE_LANGUAGE => lang
11906: ,p_TRANSLATION_REQUIRED_FLAG => p_trans_required

Line 12426: (p_status = Ibc_Utilities_Pub.G_STV_APPROVED) AND

12422: -------------------------------------
12423: -- APPROVE --------------------------
12424: -------------------------------------
12425: IF ((x_return_status = FND_API.G_RET_STS_SUCCESS) AND
12426: (p_status = Ibc_Utilities_Pub.G_STV_APPROVED) AND
12427: (do_version NOT IN (G_COMMAND_TRANSLATE,G_COMMAND_POST_APPROVAL_UPDATE))) THEN
12428: approve_citem_version_int(
12429: p_citem_ver_id => px_citem_ver_id
12430: ,p_content_item_id => px_content_item_id

Line 13329: IF ( (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED) OR

13325: END IF;
13326: CLOSE Get_Item_Version_Detail;
13327:
13328: -- error checking
13329: IF ( (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED) OR
13330: (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) ) THEN
13331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13332: FND_MESSAGE.Set_Name('IBC', 'INVALID_HARD_DELETE');
13333: FND_MESSAGE.Set_token('CITEM_VERSION_ID', l_citem_version_id);

Line 13330: (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) ) THEN

13326: CLOSE Get_Item_Version_Detail;
13327:
13328: -- error checking
13329: IF ( (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED) OR
13330: (l_citem_version_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL) ) THEN
13331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
13332: FND_MESSAGE.Set_Name('IBC', 'INVALID_HARD_DELETE');
13333: FND_MESSAGE.Set_token('CITEM_VERSION_ID', l_citem_version_id);
13334: FND_MSG_PUB.ADD;

Line 13919: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED) --|*|

13915: ,p_container_pk1_value => dir_id --|*|
13916: ,p_current_user_id => FND_GLOBAL.user_id --|*|
13917: ) = FND_API.g_false --|*|
13918: AND --|*|
13919: (p_new_status NOT IN (Ibc_Utilities_Pub.G_STV_APPROVED, IBC_UTILITIES_PUB.G_STV_REJECTED) --|*|
13920: OR --|*|
13921: IBC_DATA_SECURITY_PVT.has_permission( --|*|
13922: p_instance_object_id => IBC_DATA_SECURITY_PVT.get_object_id('IBC_CONTENT_ITEM') --|*|
13923: ,p_instance_pk1_value => content_item_id --|*|

Line 13970: IF p_new_status = IBC_UTILITIES_PUB.G_STV_APPROVED THEN

13966: ,p_object_value5 => NULL
13967: ,p_description => l_description
13968: );
13969:
13970: IF p_new_status = IBC_UTILITIES_PUB.G_STV_APPROVED THEN
13971: l_description := 'Approved';
13972: l_activity := Ibc_Utilities_Pvt.G_ALA_APPROVE;
13973: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN
13974: l_description := 'Submitted for Approval';

Line 13973: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN

13969:
13970: IF p_new_status = IBC_UTILITIES_PUB.G_STV_APPROVED THEN
13971: l_description := 'Approved';
13972: l_activity := Ibc_Utilities_Pvt.G_ALA_APPROVE;
13973: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN
13974: l_description := 'Submitted for Approval';
13975: l_activity := Ibc_Utilities_Pvt.G_ALA_SUBMIT;
13976: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN
13977: l_description := 'Rejected';

Line 13976: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN

13972: l_activity := Ibc_Utilities_Pvt.G_ALA_APPROVE;
13973: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_SUBMIT_FOR_APPROVAL THEN
13974: l_description := 'Submitted for Approval';
13975: l_activity := Ibc_Utilities_Pvt.G_ALA_SUBMIT;
13976: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN
13977: l_description := 'Rejected';
13978: l_activity := Ibc_Utilities_Pvt.G_ALA_REJECT;
13979: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED THEN
13980: l_description := 'Archived';

Line 13979: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED THEN

13975: l_activity := Ibc_Utilities_Pvt.G_ALA_SUBMIT;
13976: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED THEN
13977: l_description := 'Rejected';
13978: l_activity := Ibc_Utilities_Pvt.G_ALA_REJECT;
13979: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED THEN
13980: l_description := 'Archived';
13981: l_activity := Ibc_Utilities_Pvt.G_ALA_ARCHIVE;
13982: END IF;
13983: