[Home] [Help]
182: IF ( f_log_action = FND_API.g_true) THEN
183: --***************************************************
184: --************ADDING TO AUDIT LOG********************
185: --***************************************************
186: Ibc_Utilities_Pvt.log_action(
187: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
188: ,p_parent_value => f_citem_ver_id
189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
190: ,p_object_value1 => old_file_id
183: --***************************************************
184: --************ADDING TO AUDIT LOG********************
185: --***************************************************
186: Ibc_Utilities_Pvt.log_action(
187: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
188: ,p_parent_value => f_citem_ver_id
189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
190: ,p_object_value1 => old_file_id
191: ,p_object_value2 => NULL
185: --***************************************************
186: Ibc_Utilities_Pvt.log_action(
187: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
188: ,p_parent_value => f_citem_ver_id
189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
190: ,p_object_value1 => old_file_id
191: ,p_object_value2 => NULL
192: ,p_object_value3 => NULL
193: ,p_object_value4 => NULL
736: THEN
737: CLOSE c_admin;
738: RETURN FND_API.g_true;
739: -- if owner (Resource)
740: ELSIF (IBC_UTILITIES_PVT.check_current_user(
741: p_user_id => NULL
742: ,p_resource_id => ori
743: ,p_resource_type => ort ) = 'TRUE') THEN
744: CLOSE c_admin;
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSE
1420: -- adding data to fnd_lobs
1421: Ibc_Utilities_Pvt.insert_attribute_bundle(
1422: x_lob_file_id => new_attrib_fid
1423: ,p_new_bundle => o_attrib_bundle
1424: ,x_return_status => x_return_status
1425: );
1541: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1542: --***************************************************
1543: --************ADDING TO AUDIT LOG********************
1544: --***************************************************
1545: Ibc_Utilities_Pvt.log_action(
1546: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1547: ,p_parent_value => NULL
1548: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1549: ,p_object_value1 => px_content_item_id
1542: --***************************************************
1543: --************ADDING TO AUDIT LOG********************
1544: --***************************************************
1545: Ibc_Utilities_Pvt.log_action(
1546: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1547: ,p_parent_value => NULL
1548: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1549: ,p_object_value1 => px_content_item_id
1550: ,p_object_value2 => NULL
1544: --***************************************************
1545: Ibc_Utilities_Pvt.log_action(
1546: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1547: ,p_parent_value => NULL
1548: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1549: ,p_object_value1 => px_content_item_id
1550: ,p_object_value2 => NULL
1551: ,p_object_value3 => NULL
1552: ,p_object_value4 => NULL
1553: ,p_object_value5 => NULL
1554: ,p_description => NULL
1555: );
1556:
1557: Ibc_Utilities_Pvt.log_action(
1558: p_activity => Ibc_Utilities_Pvt.G_ALA_COPY
1559: ,p_parent_value => px_content_item_id
1560: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
1561: ,p_object_value1 => new_citem_ver_id
1554: ,p_description => NULL
1555: );
1556:
1557: Ibc_Utilities_Pvt.log_action(
1558: p_activity => Ibc_Utilities_Pvt.G_ALA_COPY
1559: ,p_parent_value => px_content_item_id
1560: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
1561: ,p_object_value1 => new_citem_ver_id
1562: ,p_object_value2 => p_language
1556:
1557: Ibc_Utilities_Pvt.log_action(
1558: p_activity => Ibc_Utilities_Pvt.G_ALA_COPY
1559: ,p_parent_value => px_content_item_id
1560: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
1561: ,p_object_value1 => new_citem_ver_id
1562: ,p_object_value2 => p_language
1563: ,p_object_value3 => px_citem_ver_id
1564: ,p_object_value4 => NULL
1677: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
1678:
1679: -- Attaching encoding to XML based on DB character set
1680: l_xml_encoding := '
1681: IBC_UTILITIES_PVT.getEncoding() ||
1682: '"?>';
1683: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
1684:
1685: -- BUILDING COMPLETE XML CLOB
1683: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
1684:
1685: -- BUILDING COMPLETE XML CLOB
1686: -- creating open tags
1687: Ibc_Utilities_Pvt.build_citem_open_tags (
1688: p_content_type_code => p_ctype_code
1689: ,p_content_item_id => -1
1690: ,p_item_reference_code => NULL
1691: ,p_root_tag_only_flag => FND_API.g_false
1691: ,p_root_tag_only_flag => FND_API.g_false
1692: ,p_xml_clob_loc => temp_bundle
1693: );
1694:
1695: Ibc_Utilities_Pvt.Build_Attribute_Bundle (
1696: p_file_id => p_attrib_fid
1697: ,p_xml_clob_loc => temp_bundle
1698: );
1699:
1697: ,p_xml_clob_loc => temp_bundle
1698: );
1699:
1700: -- creating close tags
1701: Ibc_Utilities_Pvt.build_close_tag (
1702: p_close_tag => p_ctype_code
1703: ,p_xml_clob_loc => temp_bundle
1704: );
1705:
1987:
1988: --***************************************************
1989: --************ADDING TO AUDIT LOG********************
1990: --***************************************************
1991: Ibc_Utilities_Pvt.log_action(
1992: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1993: ,p_parent_value => NULL
1994: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1995: ,p_object_value1 => p_content_item_id
1988: --***************************************************
1989: --************ADDING TO AUDIT LOG********************
1990: --***************************************************
1991: Ibc_Utilities_Pvt.log_action(
1992: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1993: ,p_parent_value => NULL
1994: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1995: ,p_object_value1 => p_content_item_id
1996: ,p_object_value2 => NULL
1990: --***************************************************
1991: Ibc_Utilities_Pvt.log_action(
1992: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
1993: ,p_parent_value => NULL
1994: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
1995: ,p_object_value1 => p_content_item_id
1996: ,p_object_value2 => NULL
1997: ,p_object_value3 => NULL
1998: ,p_object_value4 => NULL
1998: ,p_object_value4 => NULL
1999: ,p_object_value5 => NULL
2000: ,p_description => 'Updated item'
2001: );
2002: Ibc_Utilities_Pvt.log_action(
2003: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2004: ,p_parent_value => p_content_item_id
2005: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
2006: ,p_object_value1 => p_assoc_objects1(counter)
1999: ,p_object_value5 => NULL
2000: ,p_description => 'Updated item'
2001: );
2002: Ibc_Utilities_Pvt.log_action(
2003: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2004: ,p_parent_value => p_content_item_id
2005: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
2006: ,p_object_value1 => p_assoc_objects1(counter)
2007: ,p_object_value2 => a2
2001: );
2002: Ibc_Utilities_Pvt.log_action(
2003: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2004: ,p_parent_value => p_content_item_id
2005: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
2006: ,p_object_value1 => p_assoc_objects1(counter)
2007: ,p_object_value2 => a2
2008: ,p_object_value3 => a3
2009: ,p_object_value4 => a4
2245:
2246: --***************************************************
2247: --************ADDING TO AUDIT LOG********************
2248: --***************************************************
2249: Ibc_Utilities_Pvt.log_action(
2250: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2251: ,p_parent_value => NULL
2252: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
2253: ,p_object_value1 => p_content_item_ids(counter)
2246: --***************************************************
2247: --************ADDING TO AUDIT LOG********************
2248: --***************************************************
2249: Ibc_Utilities_Pvt.log_action(
2250: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2251: ,p_parent_value => NULL
2252: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
2253: ,p_object_value1 => p_content_item_ids(counter)
2254: ,p_object_value2 => NULL
2248: --***************************************************
2249: Ibc_Utilities_Pvt.log_action(
2250: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2251: ,p_parent_value => NULL
2252: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
2253: ,p_object_value1 => p_content_item_ids(counter)
2254: ,p_object_value2 => NULL
2255: ,p_object_value3 => NULL
2256: ,p_object_value4 => NULL
2256: ,p_object_value4 => NULL
2257: ,p_object_value5 => NULL
2258: ,p_description => 'Updating version'
2259: );
2260: Ibc_Utilities_Pvt.log_action(
2261: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2262: ,p_parent_value => p_content_item_ids(counter)
2263: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
2264: ,p_object_value1 => p_citem_ver_id
2257: ,p_object_value5 => NULL
2258: ,p_description => 'Updating version'
2259: );
2260: Ibc_Utilities_Pvt.log_action(
2261: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2262: ,p_parent_value => p_content_item_ids(counter)
2263: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
2264: ,p_object_value1 => p_citem_ver_id
2265: ,p_object_value2 => NULL
2259: );
2260: Ibc_Utilities_Pvt.log_action(
2261: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
2262: ,p_parent_value => p_content_item_ids(counter)
2263: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
2264: ,p_object_value1 => p_citem_ver_id
2265: ,p_object_value2 => NULL
2266: ,p_object_value3 => NULL
2267: ,p_object_value4 => NULL
2267: ,p_object_value4 => NULL
2268: ,p_object_value5 => NULL
2269: ,p_description => 'Adding component'
2270: );
2271: Ibc_Utilities_Pvt.log_action(
2272: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2273: ,p_parent_value => p_citem_ver_id
2274: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
2275: ,p_object_value1 => p_attribute_type_codes(counter)
2268: ,p_object_value5 => NULL
2269: ,p_description => 'Adding component'
2270: );
2271: Ibc_Utilities_Pvt.log_action(
2272: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2273: ,p_parent_value => p_citem_ver_id
2274: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
2275: ,p_object_value1 => p_attribute_type_codes(counter)
2276: ,p_object_value2 => p_content_item_ids(counter)
2270: );
2271: Ibc_Utilities_Pvt.log_action(
2272: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
2273: ,p_parent_value => p_citem_ver_id
2274: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
2275: ,p_object_value1 => p_attribute_type_codes(counter)
2276: ,p_object_value2 => p_content_item_ids(counter)
2277: ,p_object_value3 => NULL
2278: ,p_object_value4 => NULL
2585: -- BUILDING COMPLETE XML CLOB
2586:
2587: -- Attaching encoding to XML based on DB character set
2588: l_xml_encoding := '
2589: IBC_UTILITIES_PVT.getEncoding() ||
2590: '"?>';
2591: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
2592:
2593: -- creating open tags
2590: '"?>';
2591: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
2592:
2593: -- creating open tags
2594: Ibc_Utilities_Pvt.build_citem_open_tags (
2595: p_content_type_code => ctype_code
2596: ,p_content_item_id => content_item_id
2597: ,p_item_reference_code => NULL
2598: ,p_content_item_name => citem_name
2608: );
2609:
2610:
2611: -- creating close tags
2612: Ibc_Utilities_Pvt.build_close_tag (
2613: p_close_tag => ctype_code
2614: ,p_xml_clob_loc => temp_bundle
2615: );
2616:
3040:
3041:
3042: -- building full XML if the bundle is present
3043: IF ( (attrib_fid IS NOT NULL) AND (x_return_status IS NOT NULL) ) THEN
3044: Ibc_Utilities_Pvt.build_attribute_bundle (
3045: p_file_id => attrib_fid
3046: ,p_xml_clob_loc => temp_bundle
3047: );
3048: -- VALIDATION
3123: IF (p_log_action = FND_API.g_true) THEN
3124: --***************************************************
3125: --************ADDING TO AUDIT LOG********************
3126: --***************************************************
3127: Ibc_Utilities_Pvt.log_action(
3128: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3129: ,p_parent_value => NULL
3130: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3131: ,p_object_value1 => p_content_item_id
3124: --***************************************************
3125: --************ADDING TO AUDIT LOG********************
3126: --***************************************************
3127: Ibc_Utilities_Pvt.log_action(
3128: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3129: ,p_parent_value => NULL
3130: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3131: ,p_object_value1 => p_content_item_id
3132: ,p_object_value2 => NULL
3126: --***************************************************
3127: Ibc_Utilities_Pvt.log_action(
3128: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3129: ,p_parent_value => NULL
3130: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3131: ,p_object_value1 => p_content_item_id
3132: ,p_object_value2 => NULL
3133: ,p_object_value3 => NULL
3134: ,p_object_value4 => NULL
3135: ,p_object_value5 => NULL
3136: ,p_description => 'Setting status to APPROVED and setting live version id'
3137: );
3138: --***************************************************
3139: Ibc_Utilities_Pvt.log_action(
3140: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3141: ,p_parent_value => p_content_item_id
3142: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
3143: ,p_object_value1 => p_citem_ver_id
3136: ,p_description => 'Setting status to APPROVED and setting live version id'
3137: );
3138: --***************************************************
3139: Ibc_Utilities_Pvt.log_action(
3140: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3141: ,p_parent_value => p_content_item_id
3142: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
3143: ,p_object_value1 => p_citem_ver_id
3144: ,p_object_value2 => NULL
3138: --***************************************************
3139: Ibc_Utilities_Pvt.log_action(
3140: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
3141: ,p_parent_value => p_content_item_id
3142: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
3143: ,p_object_value1 => p_citem_ver_id
3144: ,p_object_value2 => NULL
3145: ,p_object_value3 => NULL
3146: ,p_object_value4 => NULL
3602: EXCEPTION
3603: WHEN FND_API.G_EXC_ERROR THEN
3604: ROLLBACK TO svpt_approve_item;
3605: --DBMS_OUTPUT.put_line('Expected Error');
3606: Ibc_Utilities_Pvt.handle_exceptions(
3607: p_api_name => L_API_NAME
3608: ,p_pkg_name => G_PKG_NAME
3609: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3610: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3606: Ibc_Utilities_Pvt.handle_exceptions(
3607: p_api_name => L_API_NAME
3608: ,p_pkg_name => G_PKG_NAME
3609: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3610: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3611: ,p_sqlcode => SQLCODE
3612: ,p_sqlerrm => SQLERRM
3613: ,x_msg_count => x_msg_count
3614: ,x_msg_data => x_msg_data
3629: END IF;
3630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3631: ROLLBACK TO svpt_approve_item;
3632: --DBMS_OUTPUT.put_line('Unexpected error');
3633: Ibc_Utilities_Pvt.handle_exceptions(
3634: p_api_name => L_API_NAME
3635: ,p_pkg_name => G_PKG_NAME
3636: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3637: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3633: Ibc_Utilities_Pvt.handle_exceptions(
3634: p_api_name => L_API_NAME
3635: ,p_pkg_name => G_PKG_NAME
3636: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3637: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3638: ,p_sqlcode => SQLCODE
3639: ,p_sqlerrm => SQLERRM
3640: ,x_msg_count => x_msg_count
3641: ,x_msg_data => x_msg_data
3656: END IF;
3657: WHEN OTHERS THEN
3658: ROLLBACK TO svpt_approve_item;
3659: --DBMS_OUTPUT.put_line('Other error');
3660: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3661: p_api_name => L_API_NAME
3662: ,p_pkg_name => G_PKG_NAME
3663: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
3664: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3659: --DBMS_OUTPUT.put_line('Other error');
3660: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3661: p_api_name => L_API_NAME
3662: ,p_pkg_name => G_PKG_NAME
3663: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
3664: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3665: ,p_sqlcode => SQLCODE
3666: ,p_sqlerrm => SQLERRM
3667: ,x_msg_count => x_msg_count
3660: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3661: p_api_name => L_API_NAME
3662: ,p_pkg_name => G_PKG_NAME
3663: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
3664: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3665: ,p_sqlcode => SQLCODE
3666: ,p_sqlerrm => SQLERRM
3667: ,x_msg_count => x_msg_count
3668: ,x_msg_data => x_msg_data
3896:
3897: --***************************************************
3898: --************ADDING TO AUDIT LOG********************
3899: --***************************************************
3900: Ibc_Utilities_Pvt.log_action(
3901: p_activity => Ibc_Utilities_Pvt.G_ALA_ARCHIVE
3902: ,p_parent_value => NULL
3903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3904: ,p_object_value1 => p_content_item_id
3897: --***************************************************
3898: --************ADDING TO AUDIT LOG********************
3899: --***************************************************
3900: Ibc_Utilities_Pvt.log_action(
3901: p_activity => Ibc_Utilities_Pvt.G_ALA_ARCHIVE
3902: ,p_parent_value => NULL
3903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3904: ,p_object_value1 => p_content_item_id
3905: ,p_object_value2 => NULL
3899: --***************************************************
3900: Ibc_Utilities_Pvt.log_action(
3901: p_activity => Ibc_Utilities_Pvt.G_ALA_ARCHIVE
3902: ,p_parent_value => NULL
3903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
3904: ,p_object_value1 => p_content_item_id
3905: ,p_object_value2 => NULL
3906: ,p_object_value3 => NULL
3907: ,p_object_value4 => NULL
3939: EXCEPTION
3940: WHEN FND_API.G_EXC_ERROR THEN
3941: ROLLBACK TO svpt_archive_item;
3942: --DBMS_OUTPUT.put_line('Expected Error');
3943: Ibc_Utilities_Pvt.handle_exceptions(
3944: p_api_name => L_API_NAME
3945: ,p_pkg_name => G_PKG_NAME
3946: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3947: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3943: Ibc_Utilities_Pvt.handle_exceptions(
3944: p_api_name => L_API_NAME
3945: ,p_pkg_name => G_PKG_NAME
3946: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3947: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3948: ,p_sqlcode => SQLCODE
3949: ,p_sqlerrm => SQLERRM
3950: ,x_msg_count => x_msg_count
3951: ,x_msg_data => x_msg_data
3966: END IF;
3967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3968: ROLLBACK TO svpt_archive_item;
3969: --DBMS_OUTPUT.put_line('Unexpected error');
3970: Ibc_Utilities_Pvt.handle_exceptions(
3971: p_api_name => L_API_NAME
3972: ,p_pkg_name => G_PKG_NAME
3973: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3974: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3970: Ibc_Utilities_Pvt.handle_exceptions(
3971: p_api_name => L_API_NAME
3972: ,p_pkg_name => G_PKG_NAME
3973: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3974: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3975: ,p_sqlcode => SQLCODE
3976: ,p_sqlerrm => SQLERRM
3977: ,x_msg_count => x_msg_count
3978: ,x_msg_data => x_msg_data
3993: END IF;
3994: WHEN OTHERS THEN
3995: ROLLBACK TO svpt_archive_item;
3996: --DBMS_OUTPUT.put_line('Other error');
3997: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3998: p_api_name => L_API_NAME
3999: ,p_pkg_name => G_PKG_NAME
4000: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4001: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
3996: --DBMS_OUTPUT.put_line('Other error');
3997: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3998: p_api_name => L_API_NAME
3999: ,p_pkg_name => G_PKG_NAME
4000: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4001: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4002: ,p_sqlcode => SQLCODE
4003: ,p_sqlerrm => SQLERRM
4004: ,x_msg_count => x_msg_count
3997: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
3998: p_api_name => L_API_NAME
3999: ,p_pkg_name => G_PKG_NAME
4000: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4001: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4002: ,p_sqlcode => SQLCODE
4003: ,p_sqlerrm => SQLERRM
4004: ,x_msg_count => x_msg_count
4005: ,x_msg_data => x_msg_data
4182:
4183: --***************************************************
4184: --************ADDING TO AUDIT LOG********************
4185: --***************************************************
4186: Ibc_Utilities_Pvt.log_action(
4187: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4188: ,p_parent_value => NULL
4189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
4190: ,p_object_value1 => content_item_id
4183: --***************************************************
4184: --************ADDING TO AUDIT LOG********************
4185: --***************************************************
4186: Ibc_Utilities_Pvt.log_action(
4187: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4188: ,p_parent_value => NULL
4189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
4190: ,p_object_value1 => content_item_id
4191: ,p_object_value2 => NULL
4185: --***************************************************
4186: Ibc_Utilities_Pvt.log_action(
4187: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4188: ,p_parent_value => NULL
4189: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
4190: ,p_object_value1 => content_item_id
4191: ,p_object_value2 => NULL
4192: ,p_object_value3 => NULL
4193: ,p_object_value4 => NULL
4194: ,p_object_value5 => NULL
4195: ,p_description => 'Updating version'
4196: );
4197:
4198: Ibc_Utilities_Pvt.log_action(
4199: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4200: ,p_parent_value => content_item_id
4201: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
4202: ,p_object_value1 => p_citem_ver_id
4195: ,p_description => 'Updating version'
4196: );
4197:
4198: Ibc_Utilities_Pvt.log_action(
4199: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4200: ,p_parent_value => content_item_id
4201: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
4202: ,p_object_value1 => p_citem_ver_id
4203: ,p_object_value2 => NULL
4197:
4198: Ibc_Utilities_Pvt.log_action(
4199: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
4200: ,p_parent_value => content_item_id
4201: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
4202: ,p_object_value1 => p_citem_ver_id
4203: ,p_object_value2 => NULL
4204: ,p_object_value3 => NULL
4205: ,p_object_value4 => 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
4215: ,p_object_value1 => p_citem_ver_id
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
4215: ,p_object_value1 => p_citem_ver_id
4216: ,p_object_value2 => NULL
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
4215: ,p_object_value1 => p_citem_ver_id
4216: ,p_object_value2 => NULL
4217: ,p_object_value3 => NULL
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
4227: ,p_object_value1 => p_citem_ver_id
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
4227: ,p_object_value1 => p_citem_ver_id
4228: ,p_object_value2 => NULL
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
4227: ,p_object_value1 => p_citem_ver_id
4228: ,p_object_value2 => NULL
4229: ,p_object_value3 => NULL
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
4239: ,p_object_value1 => p_citem_ver_id
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
4239: ,p_object_value1 => p_citem_ver_id
4240: ,p_object_value2 => NULL
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
4239: ,p_object_value1 => p_citem_ver_id
4240: ,p_object_value2 => NULL
4241: ,p_object_value3 => NULL
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
4251: ,p_object_value1 => p_citem_ver_id
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
4251: ,p_object_value1 => p_citem_ver_id
4252: ,p_object_value2 => NULL
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
4251: ,p_object_value1 => p_citem_ver_id
4252: ,p_object_value2 => NULL
4253: ,p_object_value3 => NULL
4254: ,p_object_value4 => NULL
4288: EXCEPTION
4289: WHEN FND_API.G_EXC_ERROR THEN
4290: ROLLBACK TO svpt_change_status;
4291: --DBMS_OUTPUT.put_line('Expected Error');
4292: Ibc_Utilities_Pvt.handle_exceptions(
4293: p_api_name => L_API_NAME
4294: ,p_pkg_name => G_PKG_NAME
4295: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4296: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4292: Ibc_Utilities_Pvt.handle_exceptions(
4293: p_api_name => L_API_NAME
4294: ,p_pkg_name => G_PKG_NAME
4295: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4296: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4297: ,p_sqlcode => SQLCODE
4298: ,p_sqlerrm => SQLERRM
4299: ,x_msg_count => x_msg_count
4300: ,x_msg_data => x_msg_data
4315: END IF;
4316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4317: ROLLBACK TO svpt_change_status;
4318: --DBMS_OUTPUT.put_line('Unexpected error');
4319: Ibc_Utilities_Pvt.handle_exceptions(
4320: p_api_name => L_API_NAME
4321: ,p_pkg_name => G_PKG_NAME
4322: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4323: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4319: Ibc_Utilities_Pvt.handle_exceptions(
4320: p_api_name => L_API_NAME
4321: ,p_pkg_name => G_PKG_NAME
4322: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4323: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4324: ,p_sqlcode => SQLCODE
4325: ,p_sqlerrm => SQLERRM
4326: ,x_msg_count => x_msg_count
4327: ,x_msg_data => x_msg_data
4342: END IF;
4343: WHEN OTHERS THEN
4344: ROLLBACK TO svpt_change_status;
4345: --DBMS_OUTPUT.put_line('Other error');
4346: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4347: p_api_name => L_API_NAME
4348: ,p_pkg_name => G_PKG_NAME
4349: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4350: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4345: --DBMS_OUTPUT.put_line('Other error');
4346: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4347: p_api_name => L_API_NAME
4348: ,p_pkg_name => G_PKG_NAME
4349: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4350: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4351: ,p_sqlcode => SQLCODE
4352: ,p_sqlerrm => SQLERRM
4353: ,x_msg_count => x_msg_count
4346: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4347: p_api_name => L_API_NAME
4348: ,p_pkg_name => G_PKG_NAME
4349: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4350: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4351: ,p_sqlcode => SQLCODE
4352: ,p_sqlerrm => SQLERRM
4353: ,x_msg_count => x_msg_count
4354: ,x_msg_data => x_msg_data
4758: EXCEPTION
4759: WHEN FND_API.G_EXC_ERROR THEN
4760: ROLLBACK TO svpt_copy_item;
4761: --DBMS_OUTPUT.put_line('Expected Error');
4762: Ibc_Utilities_Pvt.handle_exceptions(
4763: p_api_name => L_API_NAME
4764: ,p_pkg_name => G_PKG_NAME
4765: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4766: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4762: Ibc_Utilities_Pvt.handle_exceptions(
4763: p_api_name => L_API_NAME
4764: ,p_pkg_name => G_PKG_NAME
4765: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4766: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4767: ,p_sqlcode => SQLCODE
4768: ,p_sqlerrm => SQLERRM
4769: ,x_msg_count => x_msg_count
4770: ,x_msg_data => x_msg_data
4787: END IF;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: ROLLBACK TO svpt_copy_item;
4790: --DBMS_OUTPUT.put_line('Unexpected error');
4791: Ibc_Utilities_Pvt.handle_exceptions(
4792: p_api_name => L_API_NAME
4793: ,p_pkg_name => G_PKG_NAME
4794: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4795: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4791: Ibc_Utilities_Pvt.handle_exceptions(
4792: p_api_name => L_API_NAME
4793: ,p_pkg_name => G_PKG_NAME
4794: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4795: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4796: ,p_sqlcode => SQLCODE
4797: ,p_sqlerrm => SQLERRM
4798: ,x_msg_count => x_msg_count
4799: ,x_msg_data => x_msg_data
4816: END IF;
4817: WHEN OTHERS THEN
4818: ROLLBACK TO svpt_copy_item;
4819: --DBMS_OUTPUT.put_line('Other error');
4820: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4821: p_api_name => L_API_NAME
4822: ,p_pkg_name => G_PKG_NAME
4823: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4824: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4819: --DBMS_OUTPUT.put_line('Other error');
4820: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4821: p_api_name => L_API_NAME
4822: ,p_pkg_name => G_PKG_NAME
4823: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4824: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4825: ,p_sqlcode => SQLCODE
4826: ,p_sqlerrm => SQLERRM
4827: ,x_msg_count => x_msg_count
4820: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
4821: p_api_name => L_API_NAME
4822: ,p_pkg_name => G_PKG_NAME
4823: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
4824: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
4825: ,p_sqlcode => SQLCODE
4826: ,p_sqlerrm => SQLERRM
4827: ,x_msg_count => x_msg_count
4828: ,x_msg_data => x_msg_data
5071: EXCEPTION
5072: WHEN FND_API.G_EXC_ERROR THEN
5073: ROLLBACK TO svpt_copy_version;
5074: --DBMS_OUTPUT.put_line('Expected Error');
5075: Ibc_Utilities_Pvt.handle_exceptions(
5076: p_api_name => L_API_NAME
5077: ,p_pkg_name => G_PKG_NAME
5078: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5079: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5075: Ibc_Utilities_Pvt.handle_exceptions(
5076: p_api_name => L_API_NAME
5077: ,p_pkg_name => G_PKG_NAME
5078: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5079: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5080: ,p_sqlcode => SQLCODE
5081: ,p_sqlerrm => SQLERRM
5082: ,x_msg_count => x_msg_count
5083: ,x_msg_data => x_msg_data
5100: END IF;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: ROLLBACK TO svpt_copy_version;
5103: --DBMS_OUTPUT.put_line('Unexpected error');
5104: Ibc_Utilities_Pvt.handle_exceptions(
5105: p_api_name => L_API_NAME
5106: ,p_pkg_name => G_PKG_NAME
5107: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5108: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5104: Ibc_Utilities_Pvt.handle_exceptions(
5105: p_api_name => L_API_NAME
5106: ,p_pkg_name => G_PKG_NAME
5107: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5108: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5109: ,p_sqlcode => SQLCODE
5110: ,p_sqlerrm => SQLERRM
5111: ,x_msg_count => x_msg_count
5112: ,x_msg_data => x_msg_data
5129: END IF;
5130: WHEN OTHERS THEN
5131: ROLLBACK TO svpt_copy_version;
5132: --DBMS_OUTPUT.put_line('Other error');
5133: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5134: p_api_name => L_API_NAME
5135: ,p_pkg_name => G_PKG_NAME
5136: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5137: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5132: --DBMS_OUTPUT.put_line('Other error');
5133: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5134: p_api_name => L_API_NAME
5135: ,p_pkg_name => G_PKG_NAME
5136: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5137: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5138: ,p_sqlcode => SQLCODE
5139: ,p_sqlerrm => SQLERRM
5140: ,x_msg_count => x_msg_count
5133: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5134: p_api_name => L_API_NAME
5135: ,p_pkg_name => G_PKG_NAME
5136: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5137: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5138: ,p_sqlcode => SQLCODE
5139: ,p_sqlerrm => SQLERRM
5140: ,x_msg_count => x_msg_count
5141: ,x_msg_data => x_msg_data
5305: Ibc_Compound_Relations_Pkg.delete_row(temp);
5306: --***************************************************
5307: --************ADDING TO AUDIT LOG********************
5308: --***************************************************
5309: Ibc_Utilities_Pvt.log_action(
5310: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5311: ,p_parent_value => NULL
5312: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5313: ,p_object_value1 => content_item_id
5306: --***************************************************
5307: --************ADDING TO AUDIT LOG********************
5308: --***************************************************
5309: Ibc_Utilities_Pvt.log_action(
5310: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5311: ,p_parent_value => NULL
5312: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5313: ,p_object_value1 => content_item_id
5314: ,p_object_value2 => NULL
5308: --***************************************************
5309: Ibc_Utilities_Pvt.log_action(
5310: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5311: ,p_parent_value => NULL
5312: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5313: ,p_object_value1 => content_item_id
5314: ,p_object_value2 => NULL
5315: ,p_object_value3 => NULL
5316: ,p_object_value4 => NULL
5316: ,p_object_value4 => NULL
5317: ,p_object_value5 => NULL
5318: ,p_description => 'Updating version'
5319: );
5320: Ibc_Utilities_Pvt.log_action(
5321: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5322: ,p_parent_value => content_item_id
5323: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
5324: ,p_object_value1 => p_citem_ver_id
5317: ,p_object_value5 => NULL
5318: ,p_description => 'Updating version'
5319: );
5320: Ibc_Utilities_Pvt.log_action(
5321: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5322: ,p_parent_value => content_item_id
5323: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
5324: ,p_object_value1 => p_citem_ver_id
5325: ,p_object_value2 => NULL
5319: );
5320: Ibc_Utilities_Pvt.log_action(
5321: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5322: ,p_parent_value => content_item_id
5323: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
5324: ,p_object_value1 => p_citem_ver_id
5325: ,p_object_value2 => NULL
5326: ,p_object_value3 => NULL
5327: ,p_object_value4 => NULL
5327: ,p_object_value4 => NULL
5328: ,p_object_value5 => NULL
5329: ,p_description => 'Removing component'
5330: );
5331: Ibc_Utilities_Pvt.log_action(
5332: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5333: ,p_parent_value => p_citem_ver_id
5334: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
5335: ,p_object_value1 => p_attribute_type_code
5328: ,p_object_value5 => NULL
5329: ,p_description => 'Removing component'
5330: );
5331: Ibc_Utilities_Pvt.log_action(
5332: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5333: ,p_parent_value => p_citem_ver_id
5334: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
5335: ,p_object_value1 => p_attribute_type_code
5336: ,p_object_value2 => ctype_code
5330: );
5331: Ibc_Utilities_Pvt.log_action(
5332: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5333: ,p_parent_value => p_citem_ver_id
5334: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_COMPONENT
5335: ,p_object_value1 => p_attribute_type_code
5336: ,p_object_value2 => ctype_code
5337: ,p_object_value3 => content_item_id
5338: ,p_object_value4 => NULL
5369: EXCEPTION
5370: WHEN FND_API.G_EXC_ERROR THEN
5371: ROLLBACK TO svpt_delete_component;
5372: --DBMS_OUTPUT.put_line('Expected Error');
5373: Ibc_Utilities_Pvt.handle_exceptions(
5374: p_api_name => L_API_NAME
5375: ,p_pkg_name => G_PKG_NAME
5376: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5377: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5373: Ibc_Utilities_Pvt.handle_exceptions(
5374: p_api_name => L_API_NAME
5375: ,p_pkg_name => G_PKG_NAME
5376: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5377: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5378: ,p_sqlcode => SQLCODE
5379: ,p_sqlerrm => SQLERRM
5380: ,x_msg_count => x_msg_count
5381: ,x_msg_data => x_msg_data
5395: END IF;
5396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5397: ROLLBACK TO svpt_delete_component;
5398: --DBMS_OUTPUT.put_line('Unexpected error');
5399: Ibc_Utilities_Pvt.handle_exceptions(
5400: p_api_name => L_API_NAME
5401: ,p_pkg_name => G_PKG_NAME
5402: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5403: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5399: Ibc_Utilities_Pvt.handle_exceptions(
5400: p_api_name => L_API_NAME
5401: ,p_pkg_name => G_PKG_NAME
5402: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5403: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5404: ,p_sqlcode => SQLCODE
5405: ,p_sqlerrm => SQLERRM
5406: ,x_msg_count => x_msg_count
5407: ,x_msg_data => x_msg_data
5421: END IF;
5422: WHEN OTHERS THEN
5423: ROLLBACK TO svpt_delete_component;
5424: --DBMS_OUTPUT.put_line('Other error');
5425: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5426: p_api_name => L_API_NAME
5427: ,p_pkg_name => G_PKG_NAME
5428: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5429: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5424: --DBMS_OUTPUT.put_line('Other error');
5425: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5426: p_api_name => L_API_NAME
5427: ,p_pkg_name => G_PKG_NAME
5428: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5429: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5430: ,p_sqlcode => SQLCODE
5431: ,p_sqlerrm => SQLERRM
5432: ,x_msg_count => x_msg_count
5425: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5426: p_api_name => L_API_NAME
5427: ,p_pkg_name => G_PKG_NAME
5428: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5429: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5430: ,p_sqlcode => SQLCODE
5431: ,p_sqlerrm => SQLERRM
5432: ,x_msg_count => x_msg_count
5433: ,x_msg_data => x_msg_data
5649:
5650: --***************************************************
5651: --************ADDING TO AUDIT LOG********************
5652: --***************************************************
5653: Ibc_Utilities_Pvt.log_action(
5654: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5655: ,p_parent_value => NULL
5656: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5657: ,p_object_value1 => p_content_item_id
5650: --***************************************************
5651: --************ADDING TO AUDIT LOG********************
5652: --***************************************************
5653: Ibc_Utilities_Pvt.log_action(
5654: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5655: ,p_parent_value => NULL
5656: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5657: ,p_object_value1 => p_content_item_id
5658: ,p_object_value2 => NULL
5652: --***************************************************
5653: Ibc_Utilities_Pvt.log_action(
5654: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
5655: ,p_parent_value => NULL
5656: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
5657: ,p_object_value1 => p_content_item_id
5658: ,p_object_value2 => NULL
5659: ,p_object_value3 => NULL
5660: ,p_object_value4 => NULL
5660: ,p_object_value4 => NULL
5661: ,p_object_value5 => NULL
5662: ,p_description => 'Updating item'
5663: );
5664: Ibc_Utilities_Pvt.log_action(
5665: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5666: ,p_parent_value => p_content_item_id
5667: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
5668: ,p_object_value1 => p_associated_object_val1
5661: ,p_object_value5 => NULL
5662: ,p_description => 'Updating item'
5663: );
5664: Ibc_Utilities_Pvt.log_action(
5665: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5666: ,p_parent_value => p_content_item_id
5667: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
5668: ,p_object_value1 => p_associated_object_val1
5669: ,p_object_value2 => p_associated_object_val2
5663: );
5664: Ibc_Utilities_Pvt.log_action(
5665: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
5666: ,p_parent_value => p_content_item_id
5667: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ASSOCIATION
5668: ,p_object_value1 => p_associated_object_val1
5669: ,p_object_value2 => p_associated_object_val2
5670: ,p_object_value3 => p_associated_object_val3
5671: ,p_object_value4 => p_associated_object_val4
5717: EXCEPTION
5718: WHEN FND_API.G_EXC_ERROR THEN
5719: ROLLBACK TO svpt_delete_association;
5720: --DBMS_OUTPUT.put_line('Expected Error');
5721: Ibc_Utilities_Pvt.handle_exceptions(
5722: p_api_name => L_API_NAME
5723: ,p_pkg_name => G_PKG_NAME
5724: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5725: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5721: Ibc_Utilities_Pvt.handle_exceptions(
5722: p_api_name => L_API_NAME
5723: ,p_pkg_name => G_PKG_NAME
5724: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5725: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5726: ,p_sqlcode => SQLCODE
5727: ,p_sqlerrm => SQLERRM
5728: ,x_msg_count => x_msg_count
5729: ,x_msg_data => x_msg_data
5743: END IF;
5744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5745: ROLLBACK TO svpt_delete_association;
5746: --DBMS_OUTPUT.put_line('Unexpected error');
5747: Ibc_Utilities_Pvt.handle_exceptions(
5748: p_api_name => L_API_NAME
5749: ,p_pkg_name => G_PKG_NAME
5750: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5751: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5747: Ibc_Utilities_Pvt.handle_exceptions(
5748: p_api_name => L_API_NAME
5749: ,p_pkg_name => G_PKG_NAME
5750: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5751: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5752: ,p_sqlcode => SQLCODE
5753: ,p_sqlerrm => SQLERRM
5754: ,x_msg_count => x_msg_count
5755: ,x_msg_data => x_msg_data
5769: END IF;
5770: WHEN OTHERS THEN
5771: ROLLBACK TO svpt_delete_association;
5772: --DBMS_OUTPUT.put_line('Other error');
5773: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5774: p_api_name => L_API_NAME
5775: ,p_pkg_name => G_PKG_NAME
5776: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5777: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5772: --DBMS_OUTPUT.put_line('Other error');
5773: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5774: p_api_name => L_API_NAME
5775: ,p_pkg_name => G_PKG_NAME
5776: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5777: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5778: ,p_sqlcode => SQLCODE
5779: ,p_sqlerrm => SQLERRM
5780: ,x_msg_count => x_msg_count
5773: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
5774: p_api_name => L_API_NAME
5775: ,p_pkg_name => G_PKG_NAME
5776: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
5777: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5778: ,p_sqlcode => SQLCODE
5779: ,p_sqlerrm => SQLERRM
5780: ,x_msg_count => x_msg_count
5781: ,x_msg_data => x_msg_data
5945:
5946: EXCEPTION
5947: WHEN FND_API.G_EXC_ERROR THEN
5948: --DBMS_OUTPUT.put_line('Expected Error');
5949: Ibc_Utilities_Pvt.handle_exceptions(
5950: p_api_name => L_API_NAME
5951: ,p_pkg_name => G_PKG_NAME
5952: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5953: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5949: Ibc_Utilities_Pvt.handle_exceptions(
5950: p_api_name => L_API_NAME
5951: ,p_pkg_name => G_PKG_NAME
5952: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
5953: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5954: ,p_sqlcode => SQLCODE
5955: ,p_sqlerrm => SQLERRM
5956: ,x_msg_count => x_msg_count
5957: ,x_msg_data => x_msg_data
5973: );
5974: END IF;
5975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5976: --DBMS_OUTPUT.put_line('Unexpected error');
5977: Ibc_Utilities_Pvt.handle_exceptions(
5978: p_api_name => L_API_NAME
5979: ,p_pkg_name => G_PKG_NAME
5980: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5981: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5977: Ibc_Utilities_Pvt.handle_exceptions(
5978: p_api_name => L_API_NAME
5979: ,p_pkg_name => G_PKG_NAME
5980: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5981: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
5982: ,p_sqlcode => SQLCODE
5983: ,p_sqlerrm => SQLERRM
5984: ,x_msg_count => x_msg_count
5985: ,x_msg_data => x_msg_data
6001: );
6002: END IF;
6003: WHEN OTHERS THEN
6004: --DBMS_OUTPUT.put_line('Other error');
6005: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6006: p_api_name => L_API_NAME
6007: ,p_pkg_name => G_PKG_NAME
6008: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6009: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6004: --DBMS_OUTPUT.put_line('Other error');
6005: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6006: p_api_name => L_API_NAME
6007: ,p_pkg_name => G_PKG_NAME
6008: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6009: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6010: ,p_sqlcode => SQLCODE
6011: ,p_sqlerrm => SQLERRM
6012: ,x_msg_count => x_msg_count
6005: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6006: p_api_name => L_API_NAME
6007: ,p_pkg_name => G_PKG_NAME
6008: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6009: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6010: ,p_sqlcode => SQLCODE
6011: ,p_sqlerrm => SQLERRM
6012: ,x_msg_count => x_msg_count
6013: ,x_msg_data => x_msg_data
6158:
6159: CURSOR c_Rendition_Name(p_mime_type VARCHAR2, p_language VARCHAR2) IS
6160: SELECT MEANING
6161: FROM FND_LOOKUP_VALUES
6162: WHERE LOOKUP_TYPE = IBC_UTILITIES_PVT.G_REND_LOOKUP_TYPE
6163: AND LANGUAGE = p_language
6164: AND LOOKUP_CODE = p_mime_type;
6165:
6166:
6401: OPEN c_Rendition_Name(x_attach_mime_type, lang);
6402: FETCH c_Rendition_Name INTO x_attach_mime_name;
6403: IF c_Rendition_Name%NOTFOUND THEN
6404: CLOSE c_Rendition_Name;
6405: OPEN c_Rendition_Name(IBC_UTILITIES_PVT.G_REND_UNKNOWN_MIME, lang);
6406: FETCH c_Rendition_Name INTO x_attach_mime_name;
6407: END IF;
6408: CLOSE c_Rendition_Name;
6409:
6433: OPEN c_Rendition_Name(r_rendition.mime_type, lang);
6434: FETCH c_Rendition_Name INTO x_rendition_mime_names(l_index);
6435: IF c_Rendition_Name%NOTFOUND THEN
6436: CLOSE c_Rendition_Name;
6437: OPEN c_Rendition_Name(IBC_UTILITIES_PVT.G_REND_UNKNOWN_MIME, lang);
6438: FETCH c_Rendition_Name INTO x_rendition_mime_names(l_index);
6439: END IF;
6440: CLOSE c_Rendition_Name;
6441:
6563:
6564: EXCEPTION
6565: WHEN FND_API.G_EXC_ERROR THEN
6566: --DBMS_OUTPUT.put_line('Expected Error');
6567: Ibc_Utilities_Pvt.handle_exceptions(
6568: p_api_name => L_API_NAME
6569: ,p_pkg_name => G_PKG_NAME
6570: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
6571: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6567: Ibc_Utilities_Pvt.handle_exceptions(
6568: p_api_name => L_API_NAME
6569: ,p_pkg_name => G_PKG_NAME
6570: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
6571: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6572: ,p_sqlcode => SQLCODE
6573: ,p_sqlerrm => SQLERRM
6574: ,x_msg_count => x_msg_count
6575: ,x_msg_data => x_msg_data
6588: );
6589: END IF;
6590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6591: --DBMS_OUTPUT.put_line('Unexpected error');
6592: Ibc_Utilities_Pvt.handle_exceptions(
6593: p_api_name => L_API_NAME
6594: ,p_pkg_name => G_PKG_NAME
6595: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6596: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6592: Ibc_Utilities_Pvt.handle_exceptions(
6593: p_api_name => L_API_NAME
6594: ,p_pkg_name => G_PKG_NAME
6595: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6596: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6597: ,p_sqlcode => SQLCODE
6598: ,p_sqlerrm => SQLERRM
6599: ,x_msg_count => x_msg_count
6600: ,x_msg_data => x_msg_data
6613: );
6614: END IF;
6615: WHEN OTHERS THEN
6616: --DBMS_OUTPUT.put_line('Other error');
6617: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6618: p_api_name => L_API_NAME
6619: ,p_pkg_name => G_PKG_NAME
6620: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6621: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6616: --DBMS_OUTPUT.put_line('Other error');
6617: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6618: p_api_name => L_API_NAME
6619: ,p_pkg_name => G_PKG_NAME
6620: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6621: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6622: ,p_sqlcode => SQLCODE
6623: ,p_sqlerrm => SQLERRM
6624: ,x_msg_count => x_msg_count
6617: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
6618: p_api_name => L_API_NAME
6619: ,p_pkg_name => G_PKG_NAME
6620: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
6621: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
6622: ,p_sqlcode => SQLCODE
6623: ,p_sqlerrm => SQLERRM
6624: ,x_msg_count => x_msg_count
6625: ,x_msg_data => x_msg_data
8192: EXCEPTION
8193: WHEN FND_API.G_EXC_ERROR THEN
8194: ROLLBACK TO svpt_insert_components;
8195: --DBMS_OUTPUT.put_line('Expected Error');
8196: Ibc_Utilities_Pvt.handle_exceptions(
8197: p_api_name => L_API_NAME
8198: ,p_pkg_name => G_PKG_NAME
8199: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8200: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8196: Ibc_Utilities_Pvt.handle_exceptions(
8197: p_api_name => L_API_NAME
8198: ,p_pkg_name => G_PKG_NAME
8199: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8200: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8201: ,p_sqlcode => SQLCODE
8202: ,p_sqlerrm => SQLERRM
8203: ,x_msg_count => x_msg_count
8204: ,x_msg_data => x_msg_data
8218: END IF;
8219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8220: ROLLBACK TO svpt_insert_components;
8221: --DBMS_OUTPUT.put_line('Unexpected error');
8222: Ibc_Utilities_Pvt.handle_exceptions(
8223: p_api_name => L_API_NAME
8224: ,p_pkg_name => G_PKG_NAME
8225: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8226: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8222: Ibc_Utilities_Pvt.handle_exceptions(
8223: p_api_name => L_API_NAME
8224: ,p_pkg_name => G_PKG_NAME
8225: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8226: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8227: ,p_sqlcode => SQLCODE
8228: ,p_sqlerrm => SQLERRM
8229: ,x_msg_count => x_msg_count
8230: ,x_msg_data => x_msg_data
8244: END IF;
8245: WHEN OTHERS THEN
8246: ROLLBACK TO svpt_insert_components;
8247: --DBMS_OUTPUT.put_line('Other error');
8248: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8249: p_api_name => L_API_NAME
8250: ,p_pkg_name => G_PKG_NAME
8251: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8252: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8247: --DBMS_OUTPUT.put_line('Other error');
8248: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8249: p_api_name => L_API_NAME
8250: ,p_pkg_name => G_PKG_NAME
8251: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8252: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8253: ,p_sqlcode => SQLCODE
8254: ,p_sqlerrm => SQLERRM
8255: ,x_msg_count => x_msg_count
8248: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8249: p_api_name => L_API_NAME
8250: ,p_pkg_name => G_PKG_NAME
8251: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8252: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8253: ,p_sqlcode => SQLCODE
8254: ,p_sqlerrm => SQLERRM
8255: ,x_msg_count => x_msg_count
8256: ,x_msg_data => x_msg_data
8534: EXCEPTION
8535: WHEN FND_API.G_EXC_ERROR THEN
8536: ROLLBACK TO svpt_insert_associations;
8537: --DBMS_OUTPUT.put_line('Expected Error');
8538: Ibc_Utilities_Pvt.handle_exceptions(
8539: p_api_name => L_API_NAME
8540: ,p_pkg_name => G_PKG_NAME
8541: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8542: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8538: Ibc_Utilities_Pvt.handle_exceptions(
8539: p_api_name => L_API_NAME
8540: ,p_pkg_name => G_PKG_NAME
8541: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8542: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8543: ,p_sqlcode => SQLCODE
8544: ,p_sqlerrm => SQLERRM
8545: ,x_msg_count => x_msg_count
8546: ,x_msg_data => x_msg_data
8560: END IF;
8561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8562: ROLLBACK TO svpt_insert_associations;
8563: --DBMS_OUTPUT.put_line('Unexpected error');
8564: Ibc_Utilities_Pvt.handle_exceptions(
8565: p_api_name => L_API_NAME
8566: ,p_pkg_name => G_PKG_NAME
8567: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8568: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8564: Ibc_Utilities_Pvt.handle_exceptions(
8565: p_api_name => L_API_NAME
8566: ,p_pkg_name => G_PKG_NAME
8567: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8568: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8569: ,p_sqlcode => SQLCODE
8570: ,p_sqlerrm => SQLERRM
8571: ,x_msg_count => x_msg_count
8572: ,x_msg_data => x_msg_data
8586: END IF;
8587: WHEN OTHERS THEN
8588: ROLLBACK TO svpt_insert_associations;
8589: --DBMS_OUTPUT.put_line('Other error');
8590: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8591: p_api_name => L_API_NAME
8592: ,p_pkg_name => G_PKG_NAME
8593: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8594: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8589: --DBMS_OUTPUT.put_line('Other error');
8590: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8591: p_api_name => L_API_NAME
8592: ,p_pkg_name => G_PKG_NAME
8593: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8594: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8595: ,p_sqlcode => SQLCODE
8596: ,p_sqlerrm => SQLERRM
8597: ,x_msg_count => x_msg_count
8590: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8591: p_api_name => L_API_NAME
8592: ,p_pkg_name => G_PKG_NAME
8593: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8594: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8595: ,p_sqlcode => SQLCODE
8596: ,p_sqlerrm => SQLERRM
8597: ,x_msg_count => x_msg_count
8598: ,x_msg_data => x_msg_data
8831:
8832: --***************************************************
8833: --************ADDING TO AUDIT LOG********************
8834: --***************************************************
8835: Ibc_Utilities_Pvt.log_action(
8836: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8837: ,p_parent_value => NULL
8838: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8839: ,p_object_value1 => px_content_item_id
8832: --***************************************************
8833: --************ADDING TO AUDIT LOG********************
8834: --***************************************************
8835: Ibc_Utilities_Pvt.log_action(
8836: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8837: ,p_parent_value => NULL
8838: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8839: ,p_object_value1 => px_content_item_id
8840: ,p_object_value2 => NULL
8834: --***************************************************
8835: Ibc_Utilities_Pvt.log_action(
8836: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8837: ,p_parent_value => NULL
8838: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8839: ,p_object_value1 => px_content_item_id
8840: ,p_object_value2 => NULL
8841: ,p_object_value3 => NULL
8842: ,p_object_value4 => NULL
8870: IF (current_version <> 1) THEN
8871: --***************************************************
8872: --************ADDING TO AUDIT LOG********************
8873: --***************************************************
8874: Ibc_Utilities_Pvt.log_action(
8875: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8876: ,p_parent_value => NULL
8877: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8878: ,p_object_value1 => px_content_item_id
8871: --***************************************************
8872: --************ADDING TO AUDIT LOG********************
8873: --***************************************************
8874: Ibc_Utilities_Pvt.log_action(
8875: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8876: ,p_parent_value => NULL
8877: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8878: ,p_object_value1 => px_content_item_id
8879: ,p_object_value2 => NULL
8873: --***************************************************
8874: Ibc_Utilities_Pvt.log_action(
8875: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8876: ,p_parent_value => NULL
8877: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
8878: ,p_object_value1 => px_content_item_id
8879: ,p_object_value2 => NULL
8880: ,p_object_value3 => NULL
8881: ,p_object_value4 => NULL
8887: END IF;
8888: --***************************************************
8889: --************ADDING TO AUDIT LOG********************
8890: --***************************************************
8891: Ibc_Utilities_Pvt.log_action(
8892: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8893: ,p_parent_value => px_content_item_id
8894: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
8895: ,p_object_value1 => x_citem_ver_id
8888: --***************************************************
8889: --************ADDING TO AUDIT LOG********************
8890: --***************************************************
8891: Ibc_Utilities_Pvt.log_action(
8892: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8893: ,p_parent_value => px_content_item_id
8894: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
8895: ,p_object_value1 => x_citem_ver_id
8896: ,p_object_value2 => USERENV('LANG')
8890: --***************************************************
8891: Ibc_Utilities_Pvt.log_action(
8892: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
8893: ,p_parent_value => px_content_item_id
8894: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
8895: ,p_object_value1 => x_citem_ver_id
8896: ,p_object_value2 => USERENV('LANG')
8897: ,p_object_value3 => NULL
8898: ,p_object_value4 => NULL
8930: EXCEPTION
8931: WHEN FND_API.G_EXC_ERROR THEN
8932: --DBMS_OUTPUT.put_line('Expected Error');
8933: ROLLBACK TO svpt_insert_minimum_item;
8934: Ibc_Utilities_Pvt.handle_exceptions(
8935: p_api_name => L_API_NAME
8936: ,p_pkg_name => G_PKG_NAME
8937: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8938: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8934: Ibc_Utilities_Pvt.handle_exceptions(
8935: p_api_name => L_API_NAME
8936: ,p_pkg_name => G_PKG_NAME
8937: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
8938: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8939: ,p_sqlcode => SQLCODE
8940: ,p_sqlerrm => SQLERRM
8941: ,x_msg_count => x_msg_count
8942: ,x_msg_data => x_msg_data
8956: END IF;
8957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8958: --DBMS_OUTPUT.put_line('Unexpected error');
8959: ROLLBACK TO svpt_insert_minimum_item;
8960: Ibc_Utilities_Pvt.handle_exceptions(
8961: p_api_name => L_API_NAME
8962: ,p_pkg_name => G_PKG_NAME
8963: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8964: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8960: Ibc_Utilities_Pvt.handle_exceptions(
8961: p_api_name => L_API_NAME
8962: ,p_pkg_name => G_PKG_NAME
8963: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8964: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8965: ,p_sqlcode => SQLCODE
8966: ,p_sqlerrm => SQLERRM
8967: ,x_msg_count => x_msg_count
8968: ,x_msg_data => x_msg_data
8982: END IF;
8983: WHEN OTHERS THEN
8984: --DBMS_OUTPUT.put_line('Other error');
8985: ROLLBACK TO svpt_insert_minimum_item;
8986: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8987: p_api_name => L_API_NAME
8988: ,p_pkg_name => G_PKG_NAME
8989: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8990: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8985: ROLLBACK TO svpt_insert_minimum_item;
8986: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8987: p_api_name => L_API_NAME
8988: ,p_pkg_name => G_PKG_NAME
8989: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8990: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8991: ,p_sqlcode => SQLCODE
8992: ,p_sqlerrm => SQLERRM
8993: ,x_msg_count => x_msg_count
8986: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
8987: p_api_name => L_API_NAME
8988: ,p_pkg_name => G_PKG_NAME
8989: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
8990: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
8991: ,p_sqlcode => SQLCODE
8992: ,p_sqlerrm => SQLERRM
8993: ,x_msg_count => x_msg_count
8994: ,x_msg_data => x_msg_data
9144: EXCEPTION
9145: WHEN FND_API.G_EXC_ERROR THEN
9146: --DBMS_OUTPUT.put_line('Expected Error');
9147: ROLLBACK TO svpt_lock_item;
9148: Ibc_Utilities_Pvt.handle_exceptions(
9149: p_api_name => L_API_NAME
9150: ,p_pkg_name => G_PKG_NAME
9151: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9152: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9148: Ibc_Utilities_Pvt.handle_exceptions(
9149: p_api_name => L_API_NAME
9150: ,p_pkg_name => G_PKG_NAME
9151: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9152: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9153: ,p_sqlcode => SQLCODE
9154: ,p_sqlerrm => SQLERRM
9155: ,x_msg_count => x_msg_count
9156: ,x_msg_data => x_msg_data
9170: END IF;
9171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9172: --DBMS_OUTPUT.put_line('Unexpected error');
9173: ROLLBACK TO svpt_lock_item;
9174: Ibc_Utilities_Pvt.handle_exceptions(
9175: p_api_name => L_API_NAME
9176: ,p_pkg_name => G_PKG_NAME
9177: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9178: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9174: Ibc_Utilities_Pvt.handle_exceptions(
9175: p_api_name => L_API_NAME
9176: ,p_pkg_name => G_PKG_NAME
9177: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9178: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9179: ,p_sqlcode => SQLCODE
9180: ,p_sqlerrm => SQLERRM
9181: ,x_msg_count => x_msg_count
9182: ,x_msg_data => x_msg_data
9196: END IF;
9197: WHEN OTHERS THEN
9198: --DBMS_OUTPUT.put_line('Other error');
9199: ROLLBACK TO svpt_lock_item;
9200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9201: p_api_name => L_API_NAME
9202: ,p_pkg_name => G_PKG_NAME
9203: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9204: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9199: ROLLBACK TO svpt_lock_item;
9200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9201: p_api_name => L_API_NAME
9202: ,p_pkg_name => G_PKG_NAME
9203: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9204: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9205: ,p_sqlcode => SQLCODE
9206: ,p_sqlerrm => SQLERRM
9207: ,x_msg_count => x_msg_count
9200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9201: p_api_name => L_API_NAME
9202: ,p_pkg_name => G_PKG_NAME
9203: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9204: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9205: ,p_sqlcode => SQLCODE
9206: ,p_sqlerrm => SQLERRM
9207: ,x_msg_count => x_msg_count
9208: ,x_msg_data => x_msg_data
9285: GROUP BY ci.base_language;
9286:
9287: -- building full XML if the bundle is present
9288: IF (file_id IS NOT NULL) THEN
9289: Ibc_Utilities_Pvt.build_attribute_bundle (
9290: p_file_id => file_id
9291: ,p_xml_clob_loc => temp_bundle
9292: );
9293: END IF;
9324:
9325: EXCEPTION
9326: WHEN FND_API.G_EXC_ERROR THEN
9327: --DBMS_OUTPUT.put_line('Expected Error');
9328: Ibc_Utilities_Pvt.handle_exceptions(
9329: p_api_name => L_API_NAME
9330: ,p_pkg_name => G_PKG_NAME
9331: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9332: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9328: Ibc_Utilities_Pvt.handle_exceptions(
9329: p_api_name => L_API_NAME
9330: ,p_pkg_name => G_PKG_NAME
9331: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9332: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9333: ,p_sqlcode => SQLCODE
9334: ,p_sqlerrm => SQLERRM
9335: ,x_msg_count => x_msg_count
9336: ,x_msg_data => x_msg_data
9349: );
9350: END IF;
9351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9352: --DBMS_OUTPUT.put_line('Unexpected error');
9353: Ibc_Utilities_Pvt.handle_exceptions(
9354: p_api_name => L_API_NAME
9355: ,p_pkg_name => G_PKG_NAME
9356: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9357: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9353: Ibc_Utilities_Pvt.handle_exceptions(
9354: p_api_name => L_API_NAME
9355: ,p_pkg_name => G_PKG_NAME
9356: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9357: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9358: ,p_sqlcode => SQLCODE
9359: ,p_sqlerrm => SQLERRM
9360: ,x_msg_count => x_msg_count
9361: ,x_msg_data => x_msg_data
9374: );
9375: END IF;
9376: WHEN OTHERS THEN
9377: --DBMS_OUTPUT.put_line('Other error');
9378: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9379: p_api_name => L_API_NAME
9380: ,p_pkg_name => G_PKG_NAME
9381: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9382: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9377: --DBMS_OUTPUT.put_line('Other error');
9378: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9379: p_api_name => L_API_NAME
9380: ,p_pkg_name => G_PKG_NAME
9381: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9382: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9383: ,p_sqlcode => SQLCODE
9384: ,p_sqlerrm => SQLERRM
9385: ,x_msg_count => x_msg_count
9378: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9379: p_api_name => L_API_NAME
9380: ,p_pkg_name => G_PKG_NAME
9381: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9382: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9383: ,p_sqlcode => SQLCODE
9384: ,p_sqlerrm => SQLERRM
9385: ,x_msg_count => x_msg_count
9386: ,x_msg_data => x_msg_data
9548: return_status := deleteAttributeBundle(p_citem_ver_id);
9549: END IF;
9550:
9551: -- adding data to fnd_lobs
9552: Ibc_Utilities_Pvt.insert_attribute_bundle(
9553: x_lob_file_id => file_id
9554: ,p_new_bundle => bundle_text
9555: ,x_return_status => return_status
9556: );
9573:
9574: --***************************************************
9575: --************ADDING TO AUDIT LOG********************
9576: --***************************************************
9577: Ibc_Utilities_Pvt.log_action(
9578: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9579: ,p_parent_value => NULL
9580: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9581: ,p_object_value1 => content_item_id
9574: --***************************************************
9575: --************ADDING TO AUDIT LOG********************
9576: --***************************************************
9577: Ibc_Utilities_Pvt.log_action(
9578: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9579: ,p_parent_value => NULL
9580: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9581: ,p_object_value1 => content_item_id
9582: ,p_object_value2 => NULL
9576: --***************************************************
9577: Ibc_Utilities_Pvt.log_action(
9578: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9579: ,p_parent_value => NULL
9580: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9581: ,p_object_value1 => content_item_id
9582: ,p_object_value2 => NULL
9583: ,p_object_value3 => NULL
9584: ,p_object_value4 => NULL
9584: ,p_object_value4 => NULL
9585: ,p_object_value5 => NULL
9586: ,p_description => 'Altering content item version'
9587: );
9588: Ibc_Utilities_Pvt.log_action(
9589: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9590: ,p_parent_value => content_item_id
9591: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
9592: ,p_object_value1 => p_citem_ver_id
9585: ,p_object_value5 => NULL
9586: ,p_description => 'Altering content item version'
9587: );
9588: Ibc_Utilities_Pvt.log_action(
9589: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9590: ,p_parent_value => content_item_id
9591: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
9592: ,p_object_value1 => p_citem_ver_id
9593: ,p_object_value2 => USERENV('LANG')
9587: );
9588: Ibc_Utilities_Pvt.log_action(
9589: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9590: ,p_parent_value => content_item_id
9591: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
9592: ,p_object_value1 => p_citem_ver_id
9593: ,p_object_value2 => USERENV('LANG')
9594: ,p_object_value3 => NULL
9595: ,p_object_value4 => NULL
9595: ,p_object_value4 => NULL
9596: ,p_object_value5 => NULL
9597: ,p_description => 'Altering attribute bundle'
9598: );
9599: Ibc_Utilities_Pvt.log_action(
9600: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
9601: ,p_parent_value => p_citem_ver_id
9602: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
9603: ,p_object_value1 => file_id
9596: ,p_object_value5 => NULL
9597: ,p_description => 'Altering attribute bundle'
9598: );
9599: Ibc_Utilities_Pvt.log_action(
9600: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
9601: ,p_parent_value => p_citem_ver_id
9602: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
9603: ,p_object_value1 => file_id
9604: ,p_object_value2 => NULL
9598: );
9599: Ibc_Utilities_Pvt.log_action(
9600: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
9601: ,p_parent_value => p_citem_ver_id
9602: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_ATTRIBUTE_BUNDLE
9603: ,p_object_value1 => file_id
9604: ,p_object_value2 => NULL
9605: ,p_object_value3 => NULL
9606: ,p_object_value4 => NULL
9646: EXCEPTION
9647: WHEN FND_API.G_EXC_ERROR THEN
9648: --DBMS_OUTPUT.put_line('Expected Error');
9649: ROLLBACK TO svpt_set_attribute_bundle;
9650: Ibc_Utilities_Pvt.handle_exceptions(
9651: p_api_name => L_API_NAME
9652: ,p_pkg_name => G_PKG_NAME
9653: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9654: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9650: Ibc_Utilities_Pvt.handle_exceptions(
9651: p_api_name => L_API_NAME
9652: ,p_pkg_name => G_PKG_NAME
9653: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
9654: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9655: ,p_sqlcode => SQLCODE
9656: ,p_sqlerrm => SQLERRM
9657: ,x_msg_count => x_msg_count
9658: ,x_msg_data => x_msg_data
9672: END IF;
9673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9674: --DBMS_OUTPUT.put_line('Unexpected error');
9675: ROLLBACK TO svpt_set_attribute_bundle;
9676: Ibc_Utilities_Pvt.handle_exceptions(
9677: p_api_name => L_API_NAME
9678: ,p_pkg_name => G_PKG_NAME
9679: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9680: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9676: Ibc_Utilities_Pvt.handle_exceptions(
9677: p_api_name => L_API_NAME
9678: ,p_pkg_name => G_PKG_NAME
9679: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9680: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9681: ,p_sqlcode => SQLCODE
9682: ,p_sqlerrm => SQLERRM
9683: ,x_msg_count => x_msg_count
9684: ,x_msg_data => x_msg_data
9698: END IF;
9699: WHEN OTHERS THEN
9700: --DBMS_OUTPUT.put_line('Other error');
9701: ROLLBACK TO svpt_set_attribute_bundle;
9702: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9703: p_api_name => L_API_NAME
9704: ,p_pkg_name => G_PKG_NAME
9705: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9706: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9701: ROLLBACK TO svpt_set_attribute_bundle;
9702: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9703: p_api_name => L_API_NAME
9704: ,p_pkg_name => G_PKG_NAME
9705: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9706: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9707: ,p_sqlcode => SQLCODE
9708: ,p_sqlerrm => SQLERRM
9709: ,x_msg_count => x_msg_count
9702: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
9703: p_api_name => L_API_NAME
9704: ,p_pkg_name => G_PKG_NAME
9705: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
9706: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
9707: ,p_sqlcode => SQLCODE
9708: ,p_sqlerrm => SQLERRM
9709: ,x_msg_count => x_msg_count
9710: ,x_msg_data => x_msg_data
9988:
9989: --***************************************************
9990: --************ADDING TO AUDIT LOG********************
9991: --***************************************************
9992: Ibc_Utilities_Pvt.log_action(
9993: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9994: ,p_parent_value => NULL
9995: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9996: ,p_object_value1 => content_item_id
9989: --***************************************************
9990: --************ADDING TO AUDIT LOG********************
9991: --***************************************************
9992: Ibc_Utilities_Pvt.log_action(
9993: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9994: ,p_parent_value => NULL
9995: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9996: ,p_object_value1 => content_item_id
9997: ,p_object_value2 => NULL
9991: --***************************************************
9992: Ibc_Utilities_Pvt.log_action(
9993: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
9994: ,p_parent_value => NULL
9995: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
9996: ,p_object_value1 => content_item_id
9997: ,p_object_value2 => NULL
9998: ,p_object_value3 => NULL
9999: ,p_object_value4 => NULL
9999: ,p_object_value4 => NULL
10000: ,p_object_value5 => NULL
10001: ,p_description => 'Altering content item version'
10002: );
10003: Ibc_Utilities_Pvt.log_action(
10004: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10005: ,p_parent_value => content_item_id
10006: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10007: ,p_object_value1 => p_citem_ver_id
10000: ,p_object_value5 => NULL
10001: ,p_description => 'Altering content item version'
10002: );
10003: Ibc_Utilities_Pvt.log_action(
10004: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10005: ,p_parent_value => content_item_id
10006: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10007: ,p_object_value1 => p_citem_ver_id
10008: ,p_object_value2 => USERENV('LANG')
10002: );
10003: Ibc_Utilities_Pvt.log_action(
10004: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10005: ,p_parent_value => content_item_id
10006: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10007: ,p_object_value1 => p_citem_ver_id
10008: ,p_object_value2 => USERENV('LANG')
10009: ,p_object_value3 => NULL
10010: ,p_object_value4 => NULL
10057: EXCEPTION
10058: WHEN FND_API.G_EXC_ERROR THEN
10059: --DBMS_OUTPUT.put_line('Expected Error');
10060: ROLLBACK TO svpt_set_attachment;
10061: Ibc_Utilities_Pvt.handle_exceptions(
10062: p_api_name => L_API_NAME
10063: ,p_pkg_name => G_PKG_NAME
10064: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10065: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10061: Ibc_Utilities_Pvt.handle_exceptions(
10062: p_api_name => L_API_NAME
10063: ,p_pkg_name => G_PKG_NAME
10064: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10065: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10066: ,p_sqlcode => SQLCODE
10067: ,p_sqlerrm => SQLERRM
10068: ,x_msg_count => x_msg_count
10069: ,x_msg_data => x_msg_data
10083: END IF;
10084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10085: --DBMS_OUTPUT.put_line('Unexpected error');
10086: ROLLBACK TO svpt_set_attachment;
10087: Ibc_Utilities_Pvt.handle_exceptions(
10088: p_api_name => L_API_NAME
10089: ,p_pkg_name => G_PKG_NAME
10090: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10091: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10087: Ibc_Utilities_Pvt.handle_exceptions(
10088: p_api_name => L_API_NAME
10089: ,p_pkg_name => G_PKG_NAME
10090: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10091: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10092: ,p_sqlcode => SQLCODE
10093: ,p_sqlerrm => SQLERRM
10094: ,x_msg_count => x_msg_count
10095: ,x_msg_data => x_msg_data
10109: END IF;
10110: WHEN OTHERS THEN
10111: --DBMS_OUTPUT.put_line('Other error');
10112: ROLLBACK TO svpt_set_attachment;
10113: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10114: p_api_name => L_API_NAME
10115: ,p_pkg_name => G_PKG_NAME
10116: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10117: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10112: ROLLBACK TO svpt_set_attachment;
10113: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10114: p_api_name => L_API_NAME
10115: ,p_pkg_name => G_PKG_NAME
10116: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10117: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10118: ,p_sqlcode => SQLCODE
10119: ,p_sqlerrm => SQLERRM
10120: ,x_msg_count => x_msg_count
10113: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10114: p_api_name => L_API_NAME
10115: ,p_pkg_name => G_PKG_NAME
10116: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10117: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10118: ,p_sqlcode => SQLCODE
10119: ,p_sqlerrm => SQLERRM
10120: ,x_msg_count => x_msg_count
10121: ,x_msg_data => x_msg_data
10340: );
10341: --***************************************************
10342: --************ADDING TO AUDIT LOG********************
10343: --***************************************************
10344: Ibc_Utilities_Pvt.log_action(
10345: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10346: ,p_parent_value => NULL
10347: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10348: ,p_object_value1 => p_content_item_id
10341: --***************************************************
10342: --************ADDING TO AUDIT LOG********************
10343: --***************************************************
10344: Ibc_Utilities_Pvt.log_action(
10345: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10346: ,p_parent_value => NULL
10347: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10348: ,p_object_value1 => p_content_item_id
10349: ,p_object_value2 => NULL
10343: --***************************************************
10344: Ibc_Utilities_Pvt.log_action(
10345: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10346: ,p_parent_value => NULL
10347: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10348: ,p_object_value1 => p_content_item_id
10349: ,p_object_value2 => NULL
10350: ,p_object_value3 => NULL
10351: ,p_object_value4 => NULL
10383: EXCEPTION
10384: WHEN FND_API.G_EXC_ERROR THEN
10385: --DBMS_OUTPUT.put_line('Expected Error');
10386: ROLLBACK TO svpt_set_citem_meta;
10387: Ibc_Utilities_Pvt.handle_exceptions(
10388: p_api_name => L_API_NAME
10389: ,p_pkg_name => G_PKG_NAME
10390: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10391: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10387: Ibc_Utilities_Pvt.handle_exceptions(
10388: p_api_name => L_API_NAME
10389: ,p_pkg_name => G_PKG_NAME
10390: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10391: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10392: ,p_sqlcode => SQLCODE
10393: ,p_sqlerrm => SQLERRM
10394: ,x_msg_count => x_msg_count
10395: ,x_msg_data => x_msg_data
10409: END IF;
10410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10411: --DBMS_OUTPUT.put_line('Unexpected error');
10412: ROLLBACK TO svpt_set_citem_meta;
10413: Ibc_Utilities_Pvt.handle_exceptions(
10414: p_api_name => L_API_NAME
10415: ,p_pkg_name => G_PKG_NAME
10416: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10417: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10413: Ibc_Utilities_Pvt.handle_exceptions(
10414: p_api_name => L_API_NAME
10415: ,p_pkg_name => G_PKG_NAME
10416: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10417: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10418: ,p_sqlcode => SQLCODE
10419: ,p_sqlerrm => SQLERRM
10420: ,x_msg_count => x_msg_count
10421: ,x_msg_data => x_msg_data
10435: END IF;
10436: WHEN OTHERS THEN
10437: --DBMS_OUTPUT.put_line('Other error');
10438: ROLLBACK TO svpt_set_citem_meta;
10439: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10440: p_api_name => L_API_NAME
10441: ,p_pkg_name => G_PKG_NAME
10442: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10443: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10438: ROLLBACK TO svpt_set_citem_meta;
10439: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10440: p_api_name => L_API_NAME
10441: ,p_pkg_name => G_PKG_NAME
10442: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10443: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10444: ,p_sqlcode => SQLCODE
10445: ,p_sqlerrm => SQLERRM
10446: ,x_msg_count => x_msg_count
10439: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10440: p_api_name => L_API_NAME
10441: ,p_pkg_name => G_PKG_NAME
10442: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10443: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10444: ,p_sqlcode => SQLCODE
10445: ,p_sqlerrm => SQLERRM
10446: ,x_msg_count => x_msg_count
10447: ,x_msg_data => x_msg_data
10645: EXCEPTION
10646: WHEN FND_API.G_EXC_ERROR THEN
10647: ROLLBACK TO svpt_set_live_version;
10648: --DBMS_OUTPUT.put_line('Expected Error');
10649: Ibc_Utilities_Pvt.handle_exceptions(
10650: p_api_name => L_API_NAME
10651: ,p_pkg_name => G_PKG_NAME
10652: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10653: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10649: Ibc_Utilities_Pvt.handle_exceptions(
10650: p_api_name => L_API_NAME
10651: ,p_pkg_name => G_PKG_NAME
10652: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10653: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10654: ,p_sqlcode => SQLCODE
10655: ,p_sqlerrm => SQLERRM
10656: ,x_msg_count => x_msg_count
10657: ,x_msg_data => x_msg_data
10671: END IF;
10672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10673: ROLLBACK TO svpt_set_live_version;
10674: --DBMS_OUTPUT.put_line('Unexpected error');
10675: Ibc_Utilities_Pvt.handle_exceptions(
10676: p_api_name => L_API_NAME
10677: ,p_pkg_name => G_PKG_NAME
10678: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10679: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10675: Ibc_Utilities_Pvt.handle_exceptions(
10676: p_api_name => L_API_NAME
10677: ,p_pkg_name => G_PKG_NAME
10678: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10679: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10680: ,p_sqlcode => SQLCODE
10681: ,p_sqlerrm => SQLERRM
10682: ,x_msg_count => x_msg_count
10683: ,x_msg_data => x_msg_data
10697: END IF;
10698: WHEN OTHERS THEN
10699: ROLLBACK TO svpt_set_live_version;
10700: --DBMS_OUTPUT.put_line('Other error');
10701: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10702: p_api_name => L_API_NAME
10703: ,p_pkg_name => G_PKG_NAME
10704: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10705: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10700: --DBMS_OUTPUT.put_line('Other error');
10701: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10702: p_api_name => L_API_NAME
10703: ,p_pkg_name => G_PKG_NAME
10704: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10705: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10706: ,p_sqlcode => SQLCODE
10707: ,p_sqlerrm => SQLERRM
10708: ,x_msg_count => x_msg_count
10701: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10702: p_api_name => L_API_NAME
10703: ,p_pkg_name => G_PKG_NAME
10704: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10705: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10706: ,p_sqlcode => SQLCODE
10707: ,p_sqlerrm => SQLERRM
10708: ,x_msg_count => x_msg_count
10709: ,x_msg_data => x_msg_data
10884:
10885: --***************************************************
10886: --************ADDING TO AUDIT LOG********************
10887: --***************************************************
10888: Ibc_Utilities_Pvt.log_action(
10889: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10890: ,p_parent_value => NULL
10891: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10892: ,p_object_value1 => content_item_id
10885: --***************************************************
10886: --************ADDING TO AUDIT LOG********************
10887: --***************************************************
10888: Ibc_Utilities_Pvt.log_action(
10889: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10890: ,p_parent_value => NULL
10891: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10892: ,p_object_value1 => content_item_id
10893: ,p_object_value2 => NULL
10887: --***************************************************
10888: Ibc_Utilities_Pvt.log_action(
10889: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10890: ,p_parent_value => NULL
10891: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
10892: ,p_object_value1 => content_item_id
10893: ,p_object_value2 => NULL
10894: ,p_object_value3 => NULL
10895: ,p_object_value4 => NULL
10896: ,p_object_value5 => NULL
10897: ,p_description => 'Altering content item version'
10898: );
10899:
10900: Ibc_Utilities_Pvt.log_action(
10901: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10902: ,p_parent_value => content_item_id
10903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10904: ,p_object_value1 => p_citem_ver_id
10897: ,p_description => 'Altering content item version'
10898: );
10899:
10900: Ibc_Utilities_Pvt.log_action(
10901: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10902: ,p_parent_value => content_item_id
10903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10904: ,p_object_value1 => p_citem_ver_id
10905: ,p_object_value2 => USERENV('LANG')
10899:
10900: Ibc_Utilities_Pvt.log_action(
10901: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
10902: ,p_parent_value => content_item_id
10903: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
10904: ,p_object_value1 => p_citem_ver_id
10905: ,p_object_value2 => USERENV('LANG')
10906: ,p_object_value3 => NULL
10907: ,p_object_value4 => NULL
10939: EXCEPTION
10940: WHEN FND_API.G_EXC_ERROR THEN
10941: --DBMS_OUTPUT.put_line('Expected Error');
10942: ROLLBACK TO svpt_set_version_meta;
10943: Ibc_Utilities_Pvt.handle_exceptions(
10944: p_api_name => L_API_NAME
10945: ,p_pkg_name => G_PKG_NAME
10946: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10947: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10943: Ibc_Utilities_Pvt.handle_exceptions(
10944: p_api_name => L_API_NAME
10945: ,p_pkg_name => G_PKG_NAME
10946: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
10947: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10948: ,p_sqlcode => SQLCODE
10949: ,p_sqlerrm => SQLERRM
10950: ,x_msg_count => x_msg_count
10951: ,x_msg_data => x_msg_data
10965: END IF;
10966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10967: --DBMS_OUTPUT.put_line('Unexpected error');
10968: ROLLBACK TO svpt_set_version_meta;
10969: Ibc_Utilities_Pvt.handle_exceptions(
10970: p_api_name => L_API_NAME
10971: ,p_pkg_name => G_PKG_NAME
10972: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10973: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10969: Ibc_Utilities_Pvt.handle_exceptions(
10970: p_api_name => L_API_NAME
10971: ,p_pkg_name => G_PKG_NAME
10972: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10973: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10974: ,p_sqlcode => SQLCODE
10975: ,p_sqlerrm => SQLERRM
10976: ,x_msg_count => x_msg_count
10977: ,x_msg_data => x_msg_data
10991: END IF;
10992: WHEN OTHERS THEN
10993: --DBMS_OUTPUT.put_line('Other error');
10994: ROLLBACK TO svpt_set_version_meta;
10995: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10996: p_api_name => L_API_NAME
10997: ,p_pkg_name => G_PKG_NAME
10998: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10999: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
10994: ROLLBACK TO svpt_set_version_meta;
10995: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10996: p_api_name => L_API_NAME
10997: ,p_pkg_name => G_PKG_NAME
10998: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10999: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11000: ,p_sqlcode => SQLCODE
11001: ,p_sqlerrm => SQLERRM
11002: ,x_msg_count => x_msg_count
10995: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
10996: p_api_name => L_API_NAME
10997: ,p_pkg_name => G_PKG_NAME
10998: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
10999: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11000: ,p_sqlcode => SQLCODE
11001: ,p_sqlerrm => SQLERRM
11002: ,x_msg_count => x_msg_count
11003: ,x_msg_data => x_msg_data
11183:
11184: --***************************************************
11185: --************ADDING TO AUDIT LOG********************
11186: --***************************************************
11187: Ibc_Utilities_Pvt.log_action(
11188: p_activity => Ibc_Utilities_Pvt.G_ALA_UNARCHIVE
11189: ,p_parent_value => NULL
11190: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11191: ,p_object_value1 => p_content_item_id
11184: --***************************************************
11185: --************ADDING TO AUDIT LOG********************
11186: --***************************************************
11187: Ibc_Utilities_Pvt.log_action(
11188: p_activity => Ibc_Utilities_Pvt.G_ALA_UNARCHIVE
11189: ,p_parent_value => NULL
11190: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11191: ,p_object_value1 => p_content_item_id
11192: ,p_object_value2 => NULL
11186: --***************************************************
11187: Ibc_Utilities_Pvt.log_action(
11188: p_activity => Ibc_Utilities_Pvt.G_ALA_UNARCHIVE
11189: ,p_parent_value => NULL
11190: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11191: ,p_object_value1 => p_content_item_id
11192: ,p_object_value2 => NULL
11193: ,p_object_value3 => NULL
11194: ,p_object_value4 => NULL
11226: EXCEPTION
11227: WHEN FND_API.G_EXC_ERROR THEN
11228: --DBMS_OUTPUT.put_line('Expected Error');
11229: ROLLBACK TO svpt_unarchive_item;
11230: Ibc_Utilities_Pvt.handle_exceptions(
11231: p_api_name => L_API_NAME
11232: ,p_pkg_name => G_PKG_NAME
11233: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
11234: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11230: Ibc_Utilities_Pvt.handle_exceptions(
11231: p_api_name => L_API_NAME
11232: ,p_pkg_name => G_PKG_NAME
11233: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
11234: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11235: ,p_sqlcode => SQLCODE
11236: ,p_sqlerrm => SQLERRM
11237: ,x_msg_count => x_msg_count
11238: ,x_msg_data => x_msg_data
11252: END IF;
11253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11254: --DBMS_OUTPUT.put_line('Unexpected error');
11255: ROLLBACK TO svpt_unarchive_item;
11256: Ibc_Utilities_Pvt.handle_exceptions(
11257: p_api_name => L_API_NAME
11258: ,p_pkg_name => G_PKG_NAME
11259: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11260: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11256: Ibc_Utilities_Pvt.handle_exceptions(
11257: p_api_name => L_API_NAME
11258: ,p_pkg_name => G_PKG_NAME
11259: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11260: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11261: ,p_sqlcode => SQLCODE
11262: ,p_sqlerrm => SQLERRM
11263: ,x_msg_count => x_msg_count
11264: ,x_msg_data => x_msg_data
11278: END IF;
11279: WHEN OTHERS THEN
11280: --DBMS_OUTPUT.put_line('Other error');
11281: ROLLBACK TO svpt_unarchive_item;
11282: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11283: p_api_name => L_API_NAME
11284: ,p_pkg_name => G_PKG_NAME
11285: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11286: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11281: ROLLBACK TO svpt_unarchive_item;
11282: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11283: p_api_name => L_API_NAME
11284: ,p_pkg_name => G_PKG_NAME
11285: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11286: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11287: ,p_sqlcode => SQLCODE
11288: ,p_sqlerrm => SQLERRM
11289: ,x_msg_count => x_msg_count
11282: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11283: p_api_name => L_API_NAME
11284: ,p_pkg_name => G_PKG_NAME
11285: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11286: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11287: ,p_sqlcode => SQLCODE
11288: ,p_sqlerrm => SQLERRM
11289: ,x_msg_count => x_msg_count
11290: ,x_msg_data => x_msg_data
11435: EXCEPTION
11436: WHEN FND_API.G_EXC_ERROR THEN
11437: --DBMS_OUTPUT.put_line('Expected Error');
11438: ROLLBACK TO svpt_unlock_item;
11439: Ibc_Utilities_Pvt.handle_exceptions(
11440: p_api_name => L_API_NAME
11441: ,p_pkg_name => G_PKG_NAME
11442: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
11443: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11439: Ibc_Utilities_Pvt.handle_exceptions(
11440: p_api_name => L_API_NAME
11441: ,p_pkg_name => G_PKG_NAME
11442: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
11443: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11444: ,p_sqlcode => SQLCODE
11445: ,p_sqlerrm => SQLERRM
11446: ,x_msg_count => x_msg_count
11447: ,x_msg_data => x_msg_data
11461: END IF;
11462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11463: --DBMS_OUTPUT.put_line('Unexpected error');
11464: ROLLBACK TO svpt_unlock_item;
11465: Ibc_Utilities_Pvt.handle_exceptions(
11466: p_api_name => L_API_NAME
11467: ,p_pkg_name => G_PKG_NAME
11468: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11469: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11465: Ibc_Utilities_Pvt.handle_exceptions(
11466: p_api_name => L_API_NAME
11467: ,p_pkg_name => G_PKG_NAME
11468: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11469: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11470: ,p_sqlcode => SQLCODE
11471: ,p_sqlerrm => SQLERRM
11472: ,x_msg_count => x_msg_count
11473: ,x_msg_data => x_msg_data
11487: END IF;
11488: WHEN OTHERS THEN
11489: --DBMS_OUTPUT.put_line('Other error');
11490: ROLLBACK TO svpt_unlock_item;
11491: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11492: p_api_name => L_API_NAME
11493: ,p_pkg_name => G_PKG_NAME
11494: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11495: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11490: ROLLBACK TO svpt_unlock_item;
11491: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11492: p_api_name => L_API_NAME
11493: ,p_pkg_name => G_PKG_NAME
11494: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11495: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11496: ,p_sqlcode => SQLCODE
11497: ,p_sqlerrm => SQLERRM
11498: ,x_msg_count => x_msg_count
11491: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
11492: p_api_name => L_API_NAME
11493: ,p_pkg_name => G_PKG_NAME
11494: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
11495: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
11496: ,p_sqlcode => SQLCODE
11497: ,p_sqlerrm => SQLERRM
11498: ,x_msg_count => x_msg_count
11499: ,x_msg_data => x_msg_data
11915: IF(p_log_action = FND_API.g_true) THEN
11916: --***************************************************
11917: --************ADDING TO AUDIT LOG********************
11918: --***************************************************
11919: Ibc_Utilities_Pvt.log_action(
11920: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
11921: ,p_parent_value => NULL
11922: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11923: ,p_object_value1 => px_content_item_id
11916: --***************************************************
11917: --************ADDING TO AUDIT LOG********************
11918: --***************************************************
11919: Ibc_Utilities_Pvt.log_action(
11920: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
11921: ,p_parent_value => NULL
11922: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11923: ,p_object_value1 => px_content_item_id
11924: ,p_object_value2 => NULL
11918: --***************************************************
11919: Ibc_Utilities_Pvt.log_action(
11920: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
11921: ,p_parent_value => NULL
11922: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11923: ,p_object_value1 => px_content_item_id
11924: ,p_object_value2 => NULL
11925: ,p_object_value3 => NULL
11926: ,p_object_value4 => NULL
11963: IF(p_log_action = FND_API.g_true) THEN
11964: --***************************************************
11965: --************ADDING TO AUDIT LOG********************
11966: --***************************************************
11967: Ibc_Utilities_Pvt.log_action(
11968: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
11969: ,p_parent_value => NULL
11970: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11971: ,p_object_value1 => px_content_item_id
11964: --***************************************************
11965: --************ADDING TO AUDIT LOG********************
11966: --***************************************************
11967: Ibc_Utilities_Pvt.log_action(
11968: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
11969: ,p_parent_value => NULL
11970: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11971: ,p_object_value1 => px_content_item_id
11972: ,p_object_value2 => NULL
11966: --***************************************************
11967: Ibc_Utilities_Pvt.log_action(
11968: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
11969: ,p_parent_value => NULL
11970: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
11971: ,p_object_value1 => px_content_item_id
11972: ,p_object_value2 => NULL
11973: ,p_object_value3 => NULL
11974: ,p_object_value4 => NULL
12081: -- Inserting temp lob into fnd_lobs
12082: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12083:
12084: -- adding data to fnd_lobs
12085: Ibc_Utilities_Pvt.insert_attribute_bundle(
12086: x_lob_file_id => bundle_file_id
12087: ,p_new_bundle => bundle_text
12088: ,x_return_status => x_return_status
12089: );
12148: IF(p_log_action = FND_API.g_true) THEN
12149: --***************************************************
12150: --************ADDING TO AUDIT LOG********************
12151: --***************************************************
12152: Ibc_Utilities_Pvt.log_action(
12153: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
12154: ,p_parent_value => px_content_item_id
12155: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12156: ,p_object_value1 => px_citem_ver_id
12149: --***************************************************
12150: --************ADDING TO AUDIT LOG********************
12151: --***************************************************
12152: Ibc_Utilities_Pvt.log_action(
12153: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
12154: ,p_parent_value => px_content_item_id
12155: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12156: ,p_object_value1 => px_citem_ver_id
12157: ,p_object_value2 => lang
12151: --***************************************************
12152: Ibc_Utilities_Pvt.log_action(
12153: p_activity => Ibc_Utilities_Pvt.G_ALA_CREATE
12154: ,p_parent_value => px_content_item_id
12155: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12156: ,p_object_value1 => px_citem_ver_id
12157: ,p_object_value2 => lang
12158: ,p_object_value3 => NULL
12159: ,p_object_value4 => NULL
12234: IF(p_log_action = FND_API.g_true) THEN
12235: --***************************************************
12236: --************ADDING TO AUDIT LOG********************
12237: --***************************************************
12238: Ibc_Utilities_Pvt.log_action(
12239: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12240: ,p_parent_value => px_content_item_id
12241: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12242: ,p_object_value1 => px_citem_ver_id
12235: --***************************************************
12236: --************ADDING TO AUDIT LOG********************
12237: --***************************************************
12238: Ibc_Utilities_Pvt.log_action(
12239: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12240: ,p_parent_value => px_content_item_id
12241: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12242: ,p_object_value1 => px_citem_ver_id
12243: ,p_object_value2 => lang
12237: --***************************************************
12238: Ibc_Utilities_Pvt.log_action(
12239: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12240: ,p_parent_value => px_content_item_id
12241: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12242: ,p_object_value1 => px_citem_ver_id
12243: ,p_object_value2 => lang
12244: ,p_object_value3 => NULL
12245: ,p_object_value4 => NULL
12310: IF(p_log_action = FND_API.g_true) THEN
12311: --***************************************************
12312: --************ADDING TO AUDIT LOG********************
12313: --***************************************************
12314: Ibc_Utilities_Pvt.log_action(
12315: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12316: ,p_parent_value => px_content_item_id
12317: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12318: ,p_object_value1 => px_citem_ver_id
12311: --***************************************************
12312: --************ADDING TO AUDIT LOG********************
12313: --***************************************************
12314: Ibc_Utilities_Pvt.log_action(
12315: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12316: ,p_parent_value => px_content_item_id
12317: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12318: ,p_object_value1 => px_citem_ver_id
12319: ,p_object_value2 => lang
12313: --***************************************************
12314: Ibc_Utilities_Pvt.log_action(
12315: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
12316: ,p_parent_value => px_content_item_id
12317: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
12318: ,p_object_value1 => px_citem_ver_id
12319: ,p_object_value2 => lang
12320: ,p_object_value3 => NULL
12321: ,p_object_value4 => NULL
12542: EXCEPTION
12543: WHEN FND_API.G_EXC_ERROR THEN
12544: --DBMS_OUTPUT.put_line('Expected Error');
12545: ROLLBACK TO svpt_upsert_item;
12546: Ibc_Utilities_Pvt.handle_exceptions(
12547: p_api_name => L_API_NAME
12548: ,p_pkg_name => G_PKG_NAME
12549: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
12550: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12546: Ibc_Utilities_Pvt.handle_exceptions(
12547: p_api_name => L_API_NAME
12548: ,p_pkg_name => G_PKG_NAME
12549: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
12550: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12551: ,p_sqlcode => SQLCODE
12552: ,p_sqlerrm => SQLERRM
12553: ,x_msg_count => x_msg_count
12554: ,x_msg_data => x_msg_data
12568: END IF;
12569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12570: --DBMS_OUTPUT.put_line('Unexpected error');
12571: ROLLBACK TO svpt_upsert_item;
12572: Ibc_Utilities_Pvt.handle_exceptions(
12573: p_api_name => L_API_NAME
12574: ,p_pkg_name => G_PKG_NAME
12575: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12576: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12572: Ibc_Utilities_Pvt.handle_exceptions(
12573: p_api_name => L_API_NAME
12574: ,p_pkg_name => G_PKG_NAME
12575: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12576: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12577: ,p_sqlcode => SQLCODE
12578: ,p_sqlerrm => SQLERRM
12579: ,x_msg_count => x_msg_count
12580: ,x_msg_data => x_msg_data
12594: END IF;
12595: WHEN OTHERS THEN
12596: --DBMS_OUTPUT.put_line('Other error');
12597: ROLLBACK TO svpt_upsert_item;
12598: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
12599: p_api_name => L_API_NAME
12600: ,p_pkg_name => G_PKG_NAME
12601: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
12602: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12597: ROLLBACK TO svpt_upsert_item;
12598: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
12599: p_api_name => L_API_NAME
12600: ,p_pkg_name => G_PKG_NAME
12601: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
12602: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12603: ,p_sqlcode => SQLCODE
12604: ,p_sqlerrm => SQLERRM
12605: ,x_msg_count => x_msg_count
12598: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
12599: p_api_name => L_API_NAME
12600: ,p_pkg_name => G_PKG_NAME
12601: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
12602: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
12603: ,p_sqlcode => SQLCODE
12604: ,p_sqlerrm => SQLERRM
12605: ,x_msg_count => x_msg_count
12606: ,x_msg_data => x_msg_data
13386:
13387: --***************************************************
13388: --************ADDING TO AUDIT LOG********************
13389: --***************************************************
13390: Ibc_Utilities_Pvt.log_action(
13391: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13392: ,p_parent_value => l_content_item_id
13393: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13394: ,p_object_value1 => l_citem_version_id
13387: --***************************************************
13388: --************ADDING TO AUDIT LOG********************
13389: --***************************************************
13390: Ibc_Utilities_Pvt.log_action(
13391: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13392: ,p_parent_value => l_content_item_id
13393: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13394: ,p_object_value1 => l_citem_version_id
13395: ,p_object_value2 => NULL
13389: --***************************************************
13390: Ibc_Utilities_Pvt.log_action(
13391: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13392: ,p_parent_value => l_content_item_id
13393: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13394: ,p_object_value1 => l_citem_version_id
13395: ,p_object_value2 => NULL
13396: ,p_object_value3 => NULL
13397: ,p_object_value4 => NULL
13399: ,p_description => 'Hard deleting content item version'
13400: );
13401:
13402: IF (l_log_item_flag = FND_API.g_true) THEN
13403: Ibc_Utilities_Pvt.log_action(
13404: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
13405: ,p_parent_value => NULL
13406: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13407: ,p_object_value1 => l_content_item_id
13400: );
13401:
13402: IF (l_log_item_flag = FND_API.g_true) THEN
13403: Ibc_Utilities_Pvt.log_action(
13404: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
13405: ,p_parent_value => NULL
13406: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13407: ,p_object_value1 => l_content_item_id
13408: ,p_object_value2 => NULL
13402: IF (l_log_item_flag = FND_API.g_true) THEN
13403: Ibc_Utilities_Pvt.log_action(
13404: p_activity => Ibc_Utilities_Pvt.G_ALA_UPDATE
13405: ,p_parent_value => NULL
13406: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13407: ,p_object_value1 => l_content_item_id
13408: ,p_object_value2 => NULL
13409: ,p_object_value3 => NULL
13410: ,p_object_value4 => NULL
13448: EXCEPTION
13449: WHEN FND_API.G_EXC_ERROR THEN
13450: --DBMS_OUTPUT.put_line('Expected Error');
13451: ROLLBACK TO HARD_DELETE_ITEM_VERSIONS_PT;
13452: Ibc_Utilities_Pvt.handle_exceptions(
13453: p_api_name => L_API_NAME
13454: ,p_pkg_name => G_PKG_NAME
13455: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
13456: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13452: Ibc_Utilities_Pvt.handle_exceptions(
13453: p_api_name => L_API_NAME
13454: ,p_pkg_name => G_PKG_NAME
13455: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
13456: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13457: ,p_sqlcode => SQLCODE
13458: ,p_sqlerrm => SQLERRM
13459: ,x_msg_count => x_msg_count
13460: ,x_msg_data => x_msg_data
13474: END IF;
13475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13476: --DBMS_OUTPUT.put_line('Unexpected error');
13477: ROLLBACK TO HARD_DELETE_ITEM_VERSIONS_PT;
13478: Ibc_Utilities_Pvt.handle_exceptions(
13479: p_api_name => L_API_NAME
13480: ,p_pkg_name => G_PKG_NAME
13481: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13482: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13478: Ibc_Utilities_Pvt.handle_exceptions(
13479: p_api_name => L_API_NAME
13480: ,p_pkg_name => G_PKG_NAME
13481: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13482: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13483: ,p_sqlcode => SQLCODE
13484: ,p_sqlerrm => SQLERRM
13485: ,x_msg_count => x_msg_count
13486: ,x_msg_data => x_msg_data
13500: END IF;
13501: WHEN OTHERS THEN
13502: --DBMS_OUTPUT.put_line('Other error');
13503: ROLLBACK TO HARD_DELETE_ITEM_VERSIONS_PT;
13504: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13505: p_api_name => L_API_NAME
13506: ,p_pkg_name => G_PKG_NAME
13507: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13508: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13503: ROLLBACK TO HARD_DELETE_ITEM_VERSIONS_PT;
13504: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13505: p_api_name => L_API_NAME
13506: ,p_pkg_name => G_PKG_NAME
13507: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13508: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13509: ,p_sqlcode => SQLCODE
13510: ,p_sqlerrm => SQLERRM
13511: ,x_msg_count => x_msg_count
13504: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13505: p_api_name => L_API_NAME
13506: ,p_pkg_name => G_PKG_NAME
13507: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13508: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13509: ,p_sqlcode => SQLCODE
13510: ,p_sqlerrm => SQLERRM
13511: ,x_msg_count => x_msg_count
13512: ,x_msg_data => x_msg_data
13658:
13659: --***************************************************
13660: --************ADDING TO AUDIT LOG********************
13661: --***************************************************
13662: Ibc_Utilities_Pvt.log_action(
13663: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13664: ,p_parent_value => NULL
13665: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13666: ,p_object_value1 => l_citem_id
13659: --***************************************************
13660: --************ADDING TO AUDIT LOG********************
13661: --***************************************************
13662: Ibc_Utilities_Pvt.log_action(
13663: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13664: ,p_parent_value => NULL
13665: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13666: ,p_object_value1 => l_citem_id
13667: ,p_object_value2 => NULL
13661: --***************************************************
13662: Ibc_Utilities_Pvt.log_action(
13663: p_activity => Ibc_Utilities_Pvt.G_ALA_REMOVE
13664: ,p_parent_value => NULL
13665: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CONTENT_ITEM
13666: ,p_object_value1 => l_citem_id
13667: ,p_object_value2 => NULL
13668: ,p_object_value3 => NULL
13669: ,p_object_value4 => NULL
13704: EXCEPTION
13705: WHEN FND_API.G_EXC_ERROR THEN
13706: --DBMS_OUTPUT.put_line('Expected Error');
13707: ROLLBACK TO HARD_DELETE_ITEMS_PT;
13708: Ibc_Utilities_Pvt.handle_exceptions(
13709: p_api_name => L_API_NAME
13710: ,p_pkg_name => G_PKG_NAME
13711: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
13712: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13708: Ibc_Utilities_Pvt.handle_exceptions(
13709: p_api_name => L_API_NAME
13710: ,p_pkg_name => G_PKG_NAME
13711: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
13712: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13713: ,p_sqlcode => SQLCODE
13714: ,p_sqlerrm => SQLERRM
13715: ,x_msg_count => x_msg_count
13716: ,x_msg_data => x_msg_data
13730: END IF;
13731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13732: --DBMS_OUTPUT.put_line('Unexpected error');
13733: ROLLBACK TO HARD_DELETE_ITEMS_PT;
13734: Ibc_Utilities_Pvt.handle_exceptions(
13735: p_api_name => L_API_NAME
13736: ,p_pkg_name => G_PKG_NAME
13737: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13738: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13734: Ibc_Utilities_Pvt.handle_exceptions(
13735: p_api_name => L_API_NAME
13736: ,p_pkg_name => G_PKG_NAME
13737: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13738: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13739: ,p_sqlcode => SQLCODE
13740: ,p_sqlerrm => SQLERRM
13741: ,x_msg_count => x_msg_count
13742: ,x_msg_data => x_msg_data
13756: END IF;
13757: WHEN OTHERS THEN
13758: --DBMS_OUTPUT.put_line('Other error');
13759: ROLLBACK TO HARD_DELETE_ITEMS_PT;
13760: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13761: p_api_name => L_API_NAME
13762: ,p_pkg_name => G_PKG_NAME
13763: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13764: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13759: ROLLBACK TO HARD_DELETE_ITEMS_PT;
13760: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13761: p_api_name => L_API_NAME
13762: ,p_pkg_name => G_PKG_NAME
13763: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13764: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13765: ,p_sqlcode => SQLCODE
13766: ,p_sqlerrm => SQLERRM
13767: ,x_msg_count => x_msg_count
13760: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
13761: p_api_name => L_API_NAME
13762: ,p_pkg_name => G_PKG_NAME
13763: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
13764: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
13765: ,p_sqlcode => SQLCODE
13766: ,p_sqlerrm => SQLERRM
13767: ,x_msg_count => x_msg_count
13768: ,x_msg_data => x_msg_data
13952: --************ADDING TO AUDIT LOG********************
13953: --***************************************************
13954:
13955: l_description := 'Updating version';
13956: l_activity := Ibc_Utilities_Pvt.G_ALA_UPDATE;
13957:
13958: Ibc_Utilities_Pvt.log_action(
13959: p_activity => l_activity
13960: ,p_parent_value => content_item_id
13954:
13955: l_description := 'Updating version';
13956: l_activity := Ibc_Utilities_Pvt.G_ALA_UPDATE;
13957:
13958: Ibc_Utilities_Pvt.log_action(
13959: p_activity => l_activity
13960: ,p_parent_value => content_item_id
13961: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13962: ,p_object_value1 => p_citem_ver_id
13957:
13958: Ibc_Utilities_Pvt.log_action(
13959: p_activity => l_activity
13960: ,p_parent_value => content_item_id
13961: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13962: ,p_object_value1 => p_citem_ver_id
13963: ,p_object_value2 => NULL
13964: ,p_object_value3 => NULL
13965: ,p_object_value4 => NULL
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';
13975: l_activity := Ibc_Utilities_Pvt.G_ALA_SUBMIT;
13976: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_REJECTED 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';
13978: l_activity := Ibc_Utilities_Pvt.G_ALA_REJECT;
13979: ELSIF p_new_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED 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';
13981: l_activity := Ibc_Utilities_Pvt.G_ALA_ARCHIVE;
13982: END IF;
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:
13984: Ibc_Utilities_Pvt.log_action(
13985: p_activity => l_activity
13980: l_description := 'Archived';
13981: l_activity := Ibc_Utilities_Pvt.G_ALA_ARCHIVE;
13982: END IF;
13983:
13984: Ibc_Utilities_Pvt.log_action(
13985: p_activity => l_activity
13986: ,p_parent_value => content_item_id
13987: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13988: ,p_object_value1 => p_citem_ver_id
13983:
13984: Ibc_Utilities_Pvt.log_action(
13985: p_activity => l_activity
13986: ,p_parent_value => content_item_id
13987: ,p_object_type => Ibc_Utilities_Pvt.G_ALO_CITEM_VERSION
13988: ,p_object_value1 => p_citem_ver_id
13989: ,p_object_value2 => NULL
13990: ,p_object_value3 => NULL
13991: ,p_object_value4 => NULL
14041: EXCEPTION
14042: WHEN FND_API.G_EXC_ERROR THEN
14043: ROLLBACK TO svpt_change_status;
14044: --DBMS_OUTPUT.put_line('Expected Error');
14045: Ibc_Utilities_Pvt.handle_exceptions(
14046: p_api_name => L_API_NAME
14047: ,p_pkg_name => G_PKG_NAME
14048: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
14049: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14045: Ibc_Utilities_Pvt.handle_exceptions(
14046: p_api_name => L_API_NAME
14047: ,p_pkg_name => G_PKG_NAME
14048: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_ERROR
14049: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14050: ,p_sqlcode => SQLCODE
14051: ,p_sqlerrm => SQLERRM
14052: ,x_msg_count => x_msg_count
14053: ,x_msg_data => x_msg_data
14068: END IF;
14069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14070: ROLLBACK TO svpt_change_status;
14071: --DBMS_OUTPUT.put_line('Unexpected error');
14072: Ibc_Utilities_Pvt.handle_exceptions(
14073: p_api_name => L_API_NAME
14074: ,p_pkg_name => G_PKG_NAME
14075: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14076: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14072: Ibc_Utilities_Pvt.handle_exceptions(
14073: p_api_name => L_API_NAME
14074: ,p_pkg_name => G_PKG_NAME
14075: ,p_exception_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14076: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14077: ,p_sqlcode => SQLCODE
14078: ,p_sqlerrm => SQLERRM
14079: ,x_msg_count => x_msg_count
14080: ,x_msg_data => x_msg_data
14095: END IF;
14096: WHEN OTHERS THEN
14097: ROLLBACK TO svpt_change_status;
14098: --DBMS_OUTPUT.put_line('Other error');
14099: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
14100: p_api_name => L_API_NAME
14101: ,p_pkg_name => G_PKG_NAME
14102: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
14103: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14098: --DBMS_OUTPUT.put_line('Other error');
14099: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
14100: p_api_name => L_API_NAME
14101: ,p_pkg_name => G_PKG_NAME
14102: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
14103: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14104: ,p_sqlcode => SQLCODE
14105: ,p_sqlerrm => SQLERRM
14106: ,x_msg_count => x_msg_count
14099: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
14100: p_api_name => L_API_NAME
14101: ,p_pkg_name => G_PKG_NAME
14102: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
14103: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
14104: ,p_sqlcode => SQLCODE
14105: ,p_sqlerrm => SQLERRM
14106: ,x_msg_count => x_msg_count
14107: ,x_msg_data => x_msg_data