137:
138: l_init_msg_list := FND_API.g_false;
139:
140: -- Debug Message
141: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
142:
143: -- Initialize API return status to SUCCESS
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: ,x_msg_count => l_msg_count
214: ,x_msg_data => l_msg_data
215: );
216:
217: AMS_UTILITY_PVT.debug_message('After upsert_item.');
218: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
219: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
220: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
214: ,x_msg_data => l_msg_data
215: );
216:
217: AMS_UTILITY_PVT.debug_message('After upsert_item.');
218: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
219: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
220: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
222:
215: );
216:
217: AMS_UTILITY_PVT.debug_message('After upsert_item.');
218: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
219: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
220: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
222:
223: IF FND_API.g_ret_sts_success <> l_return_status
216:
217: AMS_UTILITY_PVT.debug_message('After upsert_item.');
218: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
219: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
220: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
222:
223: IF FND_API.g_ret_sts_success <> l_return_status
224: THEN
217: AMS_UTILITY_PVT.debug_message('After upsert_item.');
218: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
219: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
220: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
222:
223: IF FND_API.g_ret_sts_success <> l_return_status
224: THEN
225: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
221: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
222:
223: IF FND_API.g_ret_sts_success <> l_return_status
224: THEN
225: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
226: RAISE FND_API.g_exc_error;
227: END IF;
228:
229: l_init_msg_list := FND_API.g_false ; -- This point onwards, we should not initialize the message list.
273: ,x_msg_data => l_msg_data
274: );
275: --
276: --
277: AMS_UTILITY_PVT.debug_message('Insert Assoc.');
278: AMS_UTILITY_PVT.debug_message('l_assoc_id = ' || l_assoc_id);
279: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
280: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
274: );
275: --
276: --
277: AMS_UTILITY_PVT.debug_message('Insert Assoc.');
278: AMS_UTILITY_PVT.debug_message('l_assoc_id = ' || l_assoc_id);
279: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
280: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
282:
275: --
276: --
277: AMS_UTILITY_PVT.debug_message('Insert Assoc.');
278: AMS_UTILITY_PVT.debug_message('l_assoc_id = ' || l_assoc_id);
279: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
280: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
282:
283: IF FND_API.g_ret_sts_success <> l_return_status
276: --
277: AMS_UTILITY_PVT.debug_message('Insert Assoc.');
278: AMS_UTILITY_PVT.debug_message('l_assoc_id = ' || l_assoc_id);
279: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
280: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
282:
283: IF FND_API.g_ret_sts_success <> l_return_status
284: THEN
277: AMS_UTILITY_PVT.debug_message('Insert Assoc.');
278: AMS_UTILITY_PVT.debug_message('l_assoc_id = ' || l_assoc_id);
279: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
280: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
282:
283: IF FND_API.g_ret_sts_success <> l_return_status
284: THEN
285: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM_ASSOC');
281: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
282:
283: IF FND_API.g_ret_sts_success <> l_return_status
284: THEN
285: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM_ASSOC');
286: RAISE FND_API.g_exc_error;
287: END IF;
288: --
289:
307: ,x_msg_count => l_msg_count
308: ,x_msg_data => l_msg_data
309: );
310: --
311: AMS_UTILITY_PVT.debug_message('After Unlock.');
312: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
313: --
314: --
315: IF FND_API.g_ret_sts_success <> l_return_status
308: ,x_msg_data => l_msg_data
309: );
310: --
311: AMS_UTILITY_PVT.debug_message('After Unlock.');
312: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
313: --
314: --
315: IF FND_API.g_ret_sts_success <> l_return_status
316: THEN
313: --
314: --
315: IF FND_API.g_ret_sts_success <> l_return_status
316: THEN
317: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
318: RAISE FND_API.g_exc_error;
319: END IF;
320:
321: END IF;
525:
526: l_init_msg_list := FND_API.g_false;
527:
528: -- Debug Message
529: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
530:
531: -- Initialize API return status to SUCCESS
532: x_return_status := FND_API.G_RET_STS_SUCCESS;
533: l_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: /*
542: IF l_delv_status_code NOT IN ('ACTIVE','AVAILABLE')
543: THEN
544: AMS_Utility_PVT.Error_Message('AMS_ERR_DELV_NOT_ACTIVE');
545: RAISE FND_API.g_exc_error;
546: END IF;
547: */
548: -- Removing the above check for now. Will revist.
564: );
565:
566: IF FND_API.g_ret_sts_success <> l_return_status
567: THEN
568: AMS_Utility_PVT.Error_Message('AMS_ERR_LOCKING_CITEM');
569: RAISE FND_API.g_exc_error;
570: END IF;
571: ELSE
572:
584: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
585:
586: END IF;
587:
588: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id ) ;
589: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id ) ;
590: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num ) ;
591:
592: -- Get the components of this content item.
585:
586: END IF;
587:
588: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id ) ;
589: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id ) ;
590: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num ) ;
591:
592: -- Get the components of this content item.
593: -- We must approve the components first.
586: END IF;
587:
588: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id ) ;
589: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id ) ;
590: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num ) ;
591:
592: -- Get the components of this content item.
593: -- We must approve the components first.
594:
617: );
618:
619: IF FND_API.g_ret_sts_success <> l_return_status
620: THEN
621: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_CITEM');
622: RAISE FND_API.g_exc_error;
623: END IF;
624:
625: -- First approve each of the components.
643:
644: --The line below does not work.
645: --The l_cpnt_attrib_types is un-initialized.
646: --Must check the original get_item from IBC API to see if that is working.
647: --AMS_Utility_PVT.Debug_Message(' For component ' || l_cpnt_attrib_types(i) );
648: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id );
649: AMS_Utility_PVT.Debug_Message(' l_cpnt_citem_ver_id = ' || l_cpnt_citem_ver_id );
650: AMS_Utility_PVT.Debug_Message(' l_cpnt_obj_ver_num = ' || l_cpnt_obj_ver_num );
651:
644: --The line below does not work.
645: --The l_cpnt_attrib_types is un-initialized.
646: --Must check the original get_item from IBC API to see if that is working.
647: --AMS_Utility_PVT.Debug_Message(' For component ' || l_cpnt_attrib_types(i) );
648: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id );
649: AMS_Utility_PVT.Debug_Message(' l_cpnt_citem_ver_id = ' || l_cpnt_citem_ver_id );
650: AMS_Utility_PVT.Debug_Message(' l_cpnt_obj_ver_num = ' || l_cpnt_obj_ver_num );
651:
652: IF l_cpnt_citem_ver_id IS NOT NULL
645: --The l_cpnt_attrib_types is un-initialized.
646: --Must check the original get_item from IBC API to see if that is working.
647: --AMS_Utility_PVT.Debug_Message(' For component ' || l_cpnt_attrib_types(i) );
648: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id );
649: AMS_Utility_PVT.Debug_Message(' l_cpnt_citem_ver_id = ' || l_cpnt_citem_ver_id );
650: AMS_Utility_PVT.Debug_Message(' l_cpnt_obj_ver_num = ' || l_cpnt_obj_ver_num );
651:
652: IF l_cpnt_citem_ver_id IS NOT NULL
653: AND
646: --Must check the original get_item from IBC API to see if that is working.
647: --AMS_Utility_PVT.Debug_Message(' For component ' || l_cpnt_attrib_types(i) );
648: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id );
649: AMS_Utility_PVT.Debug_Message(' l_cpnt_citem_ver_id = ' || l_cpnt_citem_ver_id );
650: AMS_Utility_PVT.Debug_Message(' l_cpnt_obj_ver_num = ' || l_cpnt_obj_ver_num );
651:
652: IF l_cpnt_citem_ver_id IS NOT NULL
653: AND
654: l_cpnt_obj_ver_num IS NOT NULL
667: );
668:
669: IF FND_API.g_ret_sts_success <> l_return_status
670: THEN
671: AMS_Utility_PVT.Error_Message('AMS_ERR_APPROVE_CITEM');
672: RAISE FND_API.g_exc_error;
673: END IF;
674:
675: END IF;
691: );
692:
693: IF FND_API.g_ret_sts_success <> l_return_status
694: THEN
695: AMS_Utility_PVT.Error_Message('AMS_ERR_APPROVE_CITEM');
696: RAISE FND_API.g_exc_error;
697: END IF;
698:
699: IF g_using_locking = FND_API.g_true
709: ,x_msg_count => l_msg_count
710: ,x_msg_data => l_msg_data
711: );
712:
713: AMS_UTILITY_PVT.debug_message('After Unlock.');
714: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
715:
716: --
717: IF FND_API.g_ret_sts_success <> l_return_status
710: ,x_msg_data => l_msg_data
711: );
712:
713: AMS_UTILITY_PVT.debug_message('After Unlock.');
714: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
715:
716: --
717: IF FND_API.g_ret_sts_success <> l_return_status
718: THEN
715:
716: --
717: IF FND_API.g_ret_sts_success <> l_return_status
718: THEN
719: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
720: RAISE FND_API.g_exc_error;
721: END IF;
722:
723: END IF;
972:
973: l_init_msg_list := FND_API.g_false;
974:
975: -- Debug Message
976: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
977:
978: -- Initialize API return status to SUCCESS
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980: l_return_status := FND_API.G_RET_STS_SUCCESS;
980: l_return_status := FND_API.G_RET_STS_SUCCESS;
981: --
982: IF p_content_type_code <> G_RICH_CONTENT -- Should be a CONSTANT in the package.
983: THEN
984: AMS_Utility_PVT.Error_Message('AMS_ERR_WRONG_CTYPE_CODE');
985: RAISE FND_API.g_exc_error;
986: END IF;
987: --
988: -- Check if the call is for Create or Update.
989:
990: l_citem_id := px_citem_id ;
991: l_citem_ver_id := px_citem_ver_id ;
992:
993: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
994: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
995: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
996:
997: IF p_dml_flag <> 'C'
990: l_citem_id := px_citem_id ;
991: l_citem_ver_id := px_citem_ver_id ;
992:
993: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
994: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
995: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
996:
997: IF p_dml_flag <> 'C'
998: THEN
991: l_citem_ver_id := px_citem_ver_id ;
992:
993: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
994: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
995: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
996:
997: IF p_dml_flag <> 'C'
998: THEN
999: -- check if content item id and content item version id is available.
1000: IF l_citem_id IS NULL
1001: OR
1002: l_citem_ver_id IS NULL
1003: THEN
1004: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_CITEM_OR_VER_ID');
1005: RAISE FND_API.g_exc_error;
1006: END IF;
1007: END IF;
1008:
1052:
1053: l_attributes.extend();
1054: l_attributes(l_attr_count) := p_data_source_list(1);
1055:
1056: AMS_UTILITY_PVT.debug_message( ' p_data_source_list(1) = ' || p_data_source_list(1) );
1057:
1058: -- Check if the Merge Fields are available.
1059: -- populate the attributes for Merge Fields.
1060: IF p_merge_fields_list IS NOT NULL
1098: );
1099:
1100: IF FND_API.g_ret_sts_success <> l_return_status
1101: THEN
1102: AMS_Utility_PVT.Error_Message('AMS_ERR_CPAGE_GEN_SQL');
1103: RAISE FND_API.g_exc_error;
1104: END IF;
1105:
1106: AMS_UTILITY_PVT.debug_message( ' l_select_sql_statement = ' || l_select_sql_statement );
1102: AMS_Utility_PVT.Error_Message('AMS_ERR_CPAGE_GEN_SQL');
1103: RAISE FND_API.g_exc_error;
1104: END IF;
1105:
1106: AMS_UTILITY_PVT.debug_message( ' l_select_sql_statement = ' || l_select_sql_statement );
1107:
1108: -- Set the attributes for Select SQL Statement and bind variables.
1109: IF l_select_sql_statement IS NOT NULL
1110: THEN
1198: ,x_msg_count => l_msg_count
1199: ,x_msg_data => l_msg_data
1200: );
1201:
1202: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1203: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1204: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1205: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1199: ,x_msg_data => l_msg_data
1200: );
1201:
1202: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1203: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1204: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1205: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1207:
1200: );
1201:
1202: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1203: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1204: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1205: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1207:
1208: IF FND_API.g_ret_sts_success <> l_return_status
1201:
1202: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1203: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1204: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1205: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1207:
1208: IF FND_API.g_ret_sts_success <> l_return_status
1209: THEN
1202: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1203: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1204: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1205: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1207:
1208: IF FND_API.g_ret_sts_success <> l_return_status
1209: THEN
1210: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
1206: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1207:
1208: IF FND_API.g_ret_sts_success <> l_return_status
1209: THEN
1210: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
1211: RAISE FND_API.g_exc_error;
1212: END IF;
1213:
1214: -- There is a bug in IBC Code. The field attachment_attribute_code in the
1244: l_dummy_sort_order.extend();
1245: l_dummy_sort_order(1) := 1;
1246: --
1247:
1248: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1249: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1245: l_dummy_sort_order(1) := 1;
1246: --
1247:
1248: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1249: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1253:
1246: --
1247:
1248: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1249: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1253:
1254: IBC_CITEM_ADMIN_GRP.insert_components(
1247:
1248: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1249: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1253:
1254: IBC_CITEM_ADMIN_GRP.insert_components(
1255: p_citem_ver_id => p_parent_citem_ver_id
1248: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1249: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1253:
1254: IBC_CITEM_ADMIN_GRP.insert_components(
1255: p_citem_ver_id => p_parent_citem_ver_id
1256: ,p_content_item_ids => l_citem_ids
1267: --
1268: --
1269: IF FND_API.g_ret_sts_success <> l_return_status
1270: THEN
1271: AMS_Utility_PVT.Error_Message('AMS_ERR_ADD_COMPOUND_REL');
1272: RAISE FND_API.g_exc_error;
1273: END IF;
1274:
1275: IF g_using_locking = FND_API.g_true
1288: ,x_msg_count => l_msg_count
1289: ,x_msg_data => l_msg_data
1290: );
1291:
1292: AMS_UTILITY_PVT.debug_message('After Unlock.');
1293: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1294:
1295: IF FND_API.g_ret_sts_success <> l_return_status
1296: THEN
1289: ,x_msg_data => l_msg_data
1290: );
1291:
1292: AMS_UTILITY_PVT.debug_message('After Unlock.');
1293: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1294:
1295: IF FND_API.g_ret_sts_success <> l_return_status
1296: THEN
1297: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
1293: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1294:
1295: IF FND_API.g_ret_sts_success <> l_return_status
1296: THEN
1297: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
1298: RAISE FND_API.g_exc_error;
1299: END IF;
1300:
1301: END IF;
1329: );
1330:
1331: IF FND_API.g_ret_sts_success <> l_return_status
1332: THEN
1333: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
1334: RAISE FND_API.g_exc_error;
1335: END IF;
1336:
1337: END IF;
1515:
1516: l_init_msg_list := FND_API.g_false;
1517:
1518: -- Debug Message
1519: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1520:
1521: -- Initialize API return status to SUCCESS
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523: l_return_status := FND_API.G_RET_STS_SUCCESS;
1523: l_return_status := FND_API.G_RET_STS_SUCCESS;
1524: --
1525: IF p_content_type_code <> G_TOC -- Should be a CONSTANT in the package.
1526: THEN
1527: AMS_Utility_PVT.Error_Message('AMS_ERR_WRONG_CTYPE_CODE');
1528: RAISE FND_API.g_exc_error;
1529: END IF;
1530: --
1531: -- Check if the call is for Create or Update.
1532:
1533: l_citem_id := px_citem_id ;
1534: l_citem_ver_id := px_citem_ver_id ;
1535:
1536: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
1537: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
1538: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
1539:
1540: IF p_dml_flag <> 'C'
1533: l_citem_id := px_citem_id ;
1534: l_citem_ver_id := px_citem_ver_id ;
1535:
1536: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
1537: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
1538: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
1539:
1540: IF p_dml_flag <> 'C'
1541: THEN
1534: l_citem_ver_id := px_citem_ver_id ;
1535:
1536: AMS_UTILITY_PVT.debug_message( 'l_citem_id = ' || l_citem_id );
1537: AMS_UTILITY_PVT.debug_message( 'l_citem_ver_id = ' || l_citem_ver_id );
1538: AMS_UTILITY_PVT.debug_message( 'p_dml_flag = ' || p_dml_flag );
1539:
1540: IF p_dml_flag <> 'C'
1541: THEN
1542: -- check if content item id and content item version id is available.
1543: IF l_citem_id IS NULL
1544: OR
1545: l_citem_ver_id IS NULL
1546: THEN
1547: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_CITEM_OR_VER_ID');
1548: RAISE FND_API.g_exc_error;
1549: END IF;
1550: END IF;
1551:
1601: ,x_msg_count => l_msg_count
1602: ,x_msg_data => l_msg_data
1603: );
1604:
1605: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1606: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1607: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1608: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1602: ,x_msg_data => l_msg_data
1603: );
1604:
1605: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1606: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1607: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1608: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1610:
1603: );
1604:
1605: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1606: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1607: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1608: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1610:
1611: IF FND_API.g_ret_sts_success <> l_return_status
1604:
1605: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1606: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1607: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1608: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1610:
1611: IF FND_API.g_ret_sts_success <> l_return_status
1612: THEN
1605: AMS_UTILITY_PVT.debug_message('After upsert_item.');
1606: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
1607: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
1608: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1610:
1611: IF FND_API.g_ret_sts_success <> l_return_status
1612: THEN
1613: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
1609: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1610:
1611: IF FND_API.g_ret_sts_success <> l_return_status
1612: THEN
1613: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CITEM');
1614: RAISE FND_API.g_exc_error;
1615: END IF;
1616:
1617: -- We do not approve this item at this point.
1638: l_dummy_sort_order.extend();
1639: l_dummy_sort_order(1) := 1;
1640: --
1641:
1642: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1643: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1639: l_dummy_sort_order(1) := 1;
1640: --
1641:
1642: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1643: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1647:
1640: --
1641:
1642: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1643: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1647:
1648: IBC_CITEM_ADMIN_GRP.insert_components(
1641:
1642: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1643: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1647:
1648: IBC_CITEM_ADMIN_GRP.insert_components(
1649: p_citem_ver_id => p_parent_citem_ver_id
1642: AMS_Utility_PVT.Debug_Message( ' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
1643: AMS_Utility_PVT.Debug_Message( ' l_citem_ids(1) = ' || l_citem_ids(1) );
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1647:
1648: IBC_CITEM_ADMIN_GRP.insert_components(
1649: p_citem_ver_id => p_parent_citem_ver_id
1650: ,p_content_item_ids => l_citem_ids
1661: --
1662: --
1663: IF FND_API.g_ret_sts_success <> l_return_status
1664: THEN
1665: AMS_Utility_PVT.Error_Message('AMS_ERR_ADD_COMPOUND_REL');
1666: RAISE FND_API.g_exc_error;
1667: END IF;
1668:
1669: IF g_using_locking = FND_API.g_true
1682: ,x_msg_count => l_msg_count
1683: ,x_msg_data => l_msg_data
1684: );
1685:
1686: AMS_UTILITY_PVT.debug_message('After Unlock.');
1687: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1688:
1689: IF FND_API.g_ret_sts_success <> l_return_status
1690: THEN
1683: ,x_msg_data => l_msg_data
1684: );
1685:
1686: AMS_UTILITY_PVT.debug_message('After Unlock.');
1687: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1688:
1689: IF FND_API.g_ret_sts_success <> l_return_status
1690: THEN
1691: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
1687: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
1688:
1689: IF FND_API.g_ret_sts_success <> l_return_status
1690: THEN
1691: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
1692: RAISE FND_API.g_exc_error;
1693: END IF;
1694:
1695: END IF;
1723: );
1724:
1725: IF FND_API.g_ret_sts_success <> l_return_status
1726: THEN
1727: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
1728: RAISE FND_API.g_exc_error;
1729: END IF;
1730:
1731: END IF;
1888: );
1889:
1890: IF FND_API.g_ret_sts_success <> l_return_status
1891: THEN
1892: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_RICH_CTNT');
1893: RAISE FND_API.g_exc_error;
1894: END IF;
1895:
1896: x_citem_ver_id := l_citem_ver_id;
2028: --
2029: BEGIN
2030: --
2031: x_return_status := FND_API.g_ret_sts_success;
2032: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' Entered the proc.');
2033: l_msg_data := 'Citem id = ' || p_citem_id;
2034: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2035: l_msg_data := 'Citem Version id = ' || p_citem_ver_id;
2036: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2030: --
2031: x_return_status := FND_API.g_ret_sts_success;
2032: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' Entered the proc.');
2033: l_msg_data := 'Citem id = ' || p_citem_id;
2034: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2035: l_msg_data := 'Citem Version id = ' || p_citem_ver_id;
2036: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2037: l_msg_data := 'API Version = ' || p_api_version;
2038: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2032: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' Entered the proc.');
2033: l_msg_data := 'Citem id = ' || p_citem_id;
2034: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2035: l_msg_data := 'Citem Version id = ' || p_citem_ver_id;
2036: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2037: l_msg_data := 'API Version = ' || p_api_version;
2038: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2039:
2040: --
2034: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2035: l_msg_data := 'Citem Version id = ' || p_citem_ver_id;
2036: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2037: l_msg_data := 'API Version = ' || p_api_version;
2038: AMS_UTILITY_PVT.debug_message(g_pkg_name || '.' || l_api_name || ' ' || l_msg_data);
2039:
2040: --
2041: -- Call Get_item procedure.
2042:
2089: );
2090:
2091: IF FND_API.g_ret_sts_success <> l_return_status
2092: THEN
2093: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_CITEM');
2094: RAISE FND_API.g_exc_error;
2095: END IF;
2096:
2097:
2096:
2097:
2098: -- Print the data for debug purposes.
2099: /*
2100: AMS_UTILITY_PVT.debug_message(p_citem_ver_id);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2097:
2098: -- Print the data for debug purposes.
2099: /*
2100: AMS_UTILITY_PVT.debug_message(p_citem_ver_id);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2098: -- Print the data for debug purposes.
2099: /*
2100: AMS_UTILITY_PVT.debug_message(p_citem_ver_id);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2099: /*
2100: AMS_UTILITY_PVT.debug_message(p_citem_ver_id);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2100: AMS_UTILITY_PVT.debug_message(p_citem_ver_id);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2101: AMS_UTILITY_PVT.debug_message(p_api_version);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2102: AMS_UTILITY_PVT.debug_message(l_citem_id);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2103: AMS_UTILITY_PVT.debug_message(l_citem_name);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2104: AMS_UTILITY_PVT.debug_message(l_citem_version);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2105: AMS_UTILITY_PVT.debug_message(l_dir_node_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2106: AMS_UTILITY_PVT.debug_message(l_dir_node_name);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2107: AMS_UTILITY_PVT.debug_message(l_status);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2108: AMS_UTILITY_PVT.debug_message(l_citem_description);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2109: AMS_UTILITY_PVT.debug_message(l_ctype_code);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2110: AMS_UTILITY_PVT.debug_message(l_ctype_name);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2111: AMS_UTILITY_PVT.debug_message(l_start_date);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2112: AMS_UTILITY_PVT.debug_message(l_end_date);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2113: AMS_UTILITY_PVT.debug_message(l_owner_resource_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2114: AMS_UTILITY_PVT.debug_message(l_owner_resource_type);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2115: AMS_UTILITY_PVT.debug_message(l_owner_name);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2116: AMS_UTILITY_PVT.debug_message(l_reference_code);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2117: AMS_UTILITY_PVT.debug_message(l_trans_required);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2118: AMS_UTILITY_PVT.debug_message(l_reusable_flag);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2119: AMS_UTILITY_PVT.debug_message(l_locked_by);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2120: AMS_UTILITY_PVT.debug_message(l_wd_restricted);
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2128: if l_attribute_type_codes is null
2121: AMS_UTILITY_PVT.debug_message(l_attach_file_id);
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2128: if l_attribute_type_codes is null
2129: then
2122: AMS_UTILITY_PVT.debug_message(l_attach_file_name);
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2128: if l_attribute_type_codes is null
2129: then
2130: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is null');
2123: AMS_UTILITY_PVT.debug_message(l_object_version_number);
2124: AMS_UTILITY_PVT.debug_message(l_created_by);
2125: AMS_UTILITY_PVT.debug_message(l_creation_date);
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2128: if l_attribute_type_codes is null
2129: then
2130: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is null');
2131: else
2126: AMS_UTILITY_PVT.debug_message(l_last_updated_by);
2127: AMS_UTILITY_PVT.debug_message(l_last_update_date);
2128: if l_attribute_type_codes is null
2129: then
2130: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is null');
2131: else
2132: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is not null');
2133: end if;
2134: if l_attribute_type_names is null
2128: if l_attribute_type_codes is null
2129: then
2130: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is null');
2131: else
2132: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is not null');
2133: end if;
2134: if l_attribute_type_names is null
2135: then
2136: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is null');
2132: AMS_UTILITY_PVT.debug_message('l_attribute_type_codes is not null');
2133: end if;
2134: if l_attribute_type_names is null
2135: then
2136: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is null');
2137: else
2138: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is not null');
2139: end if;
2140: if l_attributes is null
2134: if l_attribute_type_names is null
2135: then
2136: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is null');
2137: else
2138: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is not null');
2139: end if;
2140: if l_attributes is null
2141: then
2142: AMS_UTILITY_PVT.debug_message('l_attributes is null');
2138: AMS_UTILITY_PVT.debug_message('l_attribute_type_names is not null');
2139: end if;
2140: if l_attributes is null
2141: then
2142: AMS_UTILITY_PVT.debug_message('l_attributes is null');
2143: else
2144: AMS_UTILITY_PVT.debug_message('l_attributes is not null');
2145: end if;
2146: if l_cpnt_citems is null
2140: if l_attributes is null
2141: then
2142: AMS_UTILITY_PVT.debug_message('l_attributes is null');
2143: else
2144: AMS_UTILITY_PVT.debug_message('l_attributes is not null');
2145: end if;
2146: if l_cpnt_citems is null
2147: then
2148: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is null');
2144: AMS_UTILITY_PVT.debug_message('l_attributes is not null');
2145: end if;
2146: if l_cpnt_citems is null
2147: then
2148: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is null');
2149: else
2150: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is not null');
2151: end if;
2152: if l_cpnt_ctypes is null
2146: if l_cpnt_citems is null
2147: then
2148: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is null');
2149: else
2150: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is not null');
2151: end if;
2152: if l_cpnt_ctypes is null
2153: then
2154: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is null');
2150: AMS_UTILITY_PVT.debug_message('l_cpnt_citems is not null');
2151: end if;
2152: if l_cpnt_ctypes is null
2153: then
2154: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is null');
2155: else
2156: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is not null');
2157: end if;
2158: if l_cpnt_attrib_types is null
2152: if l_cpnt_ctypes is null
2153: then
2154: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is null');
2155: else
2156: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is not null');
2157: end if;
2158: if l_cpnt_attrib_types is null
2159: then
2160: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is null');
2156: AMS_UTILITY_PVT.debug_message('l_cpnt_ctypes is not null');
2157: end if;
2158: if l_cpnt_attrib_types is null
2159: then
2160: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is null');
2161: else
2162: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is not null');
2163: end if;
2164: if l_cpnt_citem_names is null
2158: if l_cpnt_attrib_types is null
2159: then
2160: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is null');
2161: else
2162: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is not null');
2163: end if;
2164: if l_cpnt_citem_names is null
2165: then
2166: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is null');
2162: AMS_UTILITY_PVT.debug_message('l_cpnt_attrib_types is not null');
2163: end if;
2164: if l_cpnt_citem_names is null
2165: then
2166: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is null');
2167: else
2168: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is not null');
2169: end if;
2170: if l_cpnt_owner_ids is null
2164: if l_cpnt_citem_names is null
2165: then
2166: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is null');
2167: else
2168: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is not null');
2169: end if;
2170: if l_cpnt_owner_ids is null
2171: then
2172: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is null');
2168: AMS_UTILITY_PVT.debug_message('l_cpnt_citem_names is not null');
2169: end if;
2170: if l_cpnt_owner_ids is null
2171: then
2172: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is null');
2173: else
2174: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is not null');
2175: end if;
2176: if l_cpnt_owner_ids is null
2170: if l_cpnt_owner_ids is null
2171: then
2172: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is null');
2173: else
2174: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is not null');
2175: end if;
2176: if l_cpnt_owner_ids is null
2177: then
2178: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is null');
2174: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_ids is not null');
2175: end if;
2176: if l_cpnt_owner_ids is null
2177: then
2178: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is null');
2179: else
2180: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is not null');
2181: end if;
2182: if l_cpnt_owner_names is null
2176: if l_cpnt_owner_ids is null
2177: then
2178: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is null');
2179: else
2180: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is not null');
2181: end if;
2182: if l_cpnt_owner_names is null
2183: then
2184: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is null');
2180: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_types is not null');
2181: end if;
2182: if l_cpnt_owner_names is null
2183: then
2184: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is null');
2185: else
2186: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is not null');
2187: end if;
2188: if l_cpnt_sort_orders is null
2182: if l_cpnt_owner_names is null
2183: then
2184: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is null');
2185: else
2186: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is not null');
2187: end if;
2188: if l_cpnt_sort_orders is null
2189: then
2190: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is null');
2186: AMS_UTILITY_PVT.debug_message('l_cpnt_owner_names is not null');
2187: end if;
2188: if l_cpnt_sort_orders is null
2189: then
2190: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is null');
2191: else
2192: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is not null');
2193: end if;
2194: AMS_UTILITY_PVT.debug_message(l_return_status);
2188: if l_cpnt_sort_orders is null
2189: then
2190: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is null');
2191: else
2192: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is not null');
2193: end if;
2194: AMS_UTILITY_PVT.debug_message(l_return_status);
2195: AMS_UTILITY_PVT.debug_message(l_msg_count);
2196: AMS_UTILITY_PVT.debug_message(l_msg_data);
2190: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is null');
2191: else
2192: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is not null');
2193: end if;
2194: AMS_UTILITY_PVT.debug_message(l_return_status);
2195: AMS_UTILITY_PVT.debug_message(l_msg_count);
2196: AMS_UTILITY_PVT.debug_message(l_msg_data);
2197: */
2198:
2191: else
2192: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is not null');
2193: end if;
2194: AMS_UTILITY_PVT.debug_message(l_return_status);
2195: AMS_UTILITY_PVT.debug_message(l_msg_count);
2196: AMS_UTILITY_PVT.debug_message(l_msg_data);
2197: */
2198:
2199:
2192: AMS_UTILITY_PVT.debug_message('l_cpnt_sort_orders is not null');
2193: end if;
2194: AMS_UTILITY_PVT.debug_message(l_return_status);
2195: AMS_UTILITY_PVT.debug_message(l_msg_count);
2196: AMS_UTILITY_PVT.debug_message(l_msg_data);
2197: */
2198:
2199:
2200: x_return_status := l_return_status;
2392:
2393: l_init_msg_list := FND_API.g_false;
2394:
2395: -- Debug Message
2396: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2397:
2398: -- Initialize API return status to SUCCESS
2399: x_return_status := FND_API.G_RET_STS_SUCCESS;
2400: l_return_status := FND_API.G_RET_STS_SUCCESS;
2415: THEN
2416: FOR i IN p_attr_types_image.first .. p_attr_types_image.last
2417: LOOP
2418: l_err_msg := i || ' : >' || p_attr_types_image(i) || '< : >' || p_attr_values_image(i) || '<';
2419: AMS_UTILITY_PVT.debug_message(l_err_msg);
2420: END LOOP;
2421: END IF;
2422: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for CP_IMAGE');
2423: FOR i IN p_attr_types_cp_image.first .. p_attr_types_cp_image.last
2422: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for CP_IMAGE');
2423: FOR i IN p_attr_types_cp_image.first .. p_attr_types_cp_image.last
2424: LOOP
2425: l_err_msg := i || ' : >' || p_attr_types_cp_image(i) || '< : >' || p_attr_values_cp_image(i) || '<';
2426: AMS_UTILITY_PVT.debug_message(l_err_msg);
2427: END LOOP;
2428: l_init_msg_list := FND_API.g_false;
2429:
2430:
2450: WIDTH decimal 0 1
2451: */
2452: -- Create the content item of type IMAGE.
2453: -- Call bulk_insert procedure.
2454: AMS_UTILITY_PVT.debug_message('file id = ' || p_attach_file_id);
2455: AMS_UTILITY_PVT.debug_message('file name = ' || p_attach_file_name);
2456: AMS_UTILITY_PVT.debug_message('start date = ' || l_start_date);
2457:
2458: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2451: */
2452: -- Create the content item of type IMAGE.
2453: -- Call bulk_insert procedure.
2454: AMS_UTILITY_PVT.debug_message('file id = ' || p_attach_file_id);
2455: AMS_UTILITY_PVT.debug_message('file name = ' || p_attach_file_name);
2456: AMS_UTILITY_PVT.debug_message('start date = ' || l_start_date);
2457:
2458: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2459: -- single API.
2452: -- Create the content item of type IMAGE.
2453: -- Call bulk_insert procedure.
2454: AMS_UTILITY_PVT.debug_message('file id = ' || p_attach_file_id);
2455: AMS_UTILITY_PVT.debug_message('file name = ' || p_attach_file_name);
2456: AMS_UTILITY_PVT.debug_message('start date = ' || l_start_date);
2457:
2458: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2459: -- single API.
2460:
2518:
2519: );
2520:
2521:
2522: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
2523: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
2524: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
2525: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2519: );
2520:
2521:
2522: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
2523: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
2524: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
2525: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2527:
2520:
2521:
2522: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
2523: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
2524: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
2525: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2527:
2528: IF FND_API.g_ret_sts_success <> l_return_status
2521:
2522: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
2523: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
2524: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
2525: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2527:
2528: IF FND_API.g_ret_sts_success <> l_return_status
2529: THEN
2522: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
2523: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
2524: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
2525: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2527:
2528: IF FND_API.g_ret_sts_success <> l_return_status
2529: THEN
2530: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_IMAGE_ITEM');
2526: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2527:
2528: IF FND_API.g_ret_sts_success <> l_return_status
2529: THEN
2530: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_IMAGE_ITEM');
2531: RAISE FND_API.g_exc_error;
2532: ELSE
2533: l_created_image := FND_API.g_true;
2534: END IF;
2549: );
2550:
2551: IF FND_API.g_ret_sts_success <> l_return_status
2552: THEN
2553: AMS_Utility_PVT.Error_Message('AMS_ERR_APPROVE_CITEM');
2554: RAISE FND_API.g_exc_error;
2555: END IF;
2556:
2557: END IF;
2619: ,x_msg_data => l_msg_data
2620:
2621: );
2622:
2623: AMS_UTILITY_PVT.debug_message('After upsert_item of type CP_IMAGE');
2624: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id );
2625: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id );
2626: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num );
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2620:
2621: );
2622:
2623: AMS_UTILITY_PVT.debug_message('After upsert_item of type CP_IMAGE');
2624: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id );
2625: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id );
2626: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num );
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2628:
2621: );
2622:
2623: AMS_UTILITY_PVT.debug_message('After upsert_item of type CP_IMAGE');
2624: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id );
2625: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id );
2626: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num );
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2628:
2629: IF FND_API.g_ret_sts_success <> l_return_status
2622:
2623: AMS_UTILITY_PVT.debug_message('After upsert_item of type CP_IMAGE');
2624: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id );
2625: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id );
2626: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num );
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2628:
2629: IF FND_API.g_ret_sts_success <> l_return_status
2630: THEN
2623: AMS_UTILITY_PVT.debug_message('After upsert_item of type CP_IMAGE');
2624: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id );
2625: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id );
2626: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num );
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2628:
2629: IF FND_API.g_ret_sts_success <> l_return_status
2630: THEN
2631: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CP_IMAGE');
2627: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2628:
2629: IF FND_API.g_ret_sts_success <> l_return_status
2630: THEN
2631: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_CP_IMAGE');
2632: RAISE FND_API.g_exc_error;
2633: END IF;
2634:
2635: l_init_msg_list := FND_API.g_false;
2656: --
2657: l_dummy_sort_order.extend();
2658: l_dummy_sort_order(1) := 1;
2659: --
2660: AMS_UTILITY_PVT.debug_message('parent_citem_ver_id = ' || p_parent_citem_ver_id);
2661: AMS_UTILITY_PVT.debug_message('parent_ctype_code = ' || p_parent_ctype_code);
2662: AMS_UTILITY_PVT.debug_message('citem_attr = ' || l_citem_attrs(1));
2663: AMS_UTILITY_PVT.debug_message('citem_id = ' || l_citem_ids(1));
2664:
2657: l_dummy_sort_order.extend();
2658: l_dummy_sort_order(1) := 1;
2659: --
2660: AMS_UTILITY_PVT.debug_message('parent_citem_ver_id = ' || p_parent_citem_ver_id);
2661: AMS_UTILITY_PVT.debug_message('parent_ctype_code = ' || p_parent_ctype_code);
2662: AMS_UTILITY_PVT.debug_message('citem_attr = ' || l_citem_attrs(1));
2663: AMS_UTILITY_PVT.debug_message('citem_id = ' || l_citem_ids(1));
2664:
2665: IBC_CITEM_ADMIN_GRP.insert_components(
2658: l_dummy_sort_order(1) := 1;
2659: --
2660: AMS_UTILITY_PVT.debug_message('parent_citem_ver_id = ' || p_parent_citem_ver_id);
2661: AMS_UTILITY_PVT.debug_message('parent_ctype_code = ' || p_parent_ctype_code);
2662: AMS_UTILITY_PVT.debug_message('citem_attr = ' || l_citem_attrs(1));
2663: AMS_UTILITY_PVT.debug_message('citem_id = ' || l_citem_ids(1));
2664:
2665: IBC_CITEM_ADMIN_GRP.insert_components(
2666: p_citem_ver_id => p_parent_citem_ver_id
2659: --
2660: AMS_UTILITY_PVT.debug_message('parent_citem_ver_id = ' || p_parent_citem_ver_id);
2661: AMS_UTILITY_PVT.debug_message('parent_ctype_code = ' || p_parent_ctype_code);
2662: AMS_UTILITY_PVT.debug_message('citem_attr = ' || l_citem_attrs(1));
2663: AMS_UTILITY_PVT.debug_message('citem_id = ' || l_citem_ids(1));
2664:
2665: IBC_CITEM_ADMIN_GRP.insert_components(
2666: p_citem_ver_id => p_parent_citem_ver_id
2667: ,p_content_item_ids => l_citem_ids
2678: END IF;
2679:
2680: IF FND_API.g_ret_sts_success <> l_return_status
2681: THEN
2682: AMS_Utility_PVT.Error_Message('AMS_ERR_ADD_COMPOUND_REL');
2683: RAISE FND_API.g_exc_error;
2684: END IF;
2685:
2686: -- If we reach till here, we can unlock the IMAGE item and then
2701: ,x_msg_count => l_msg_count
2702: ,x_msg_data => l_msg_data
2703: );
2704:
2705: AMS_UTILITY_PVT.debug_message('After Unlock.');
2706: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2707:
2708: --
2709: IF FND_API.g_ret_sts_success <> l_return_status
2702: ,x_msg_data => l_msg_data
2703: );
2704:
2705: AMS_UTILITY_PVT.debug_message('After Unlock.');
2706: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2707:
2708: --
2709: IF FND_API.g_ret_sts_success <> l_return_status
2710: THEN
2707:
2708: --
2709: IF FND_API.g_ret_sts_success <> l_return_status
2710: THEN
2711: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_IMAGE');
2712: RAISE FND_API.g_exc_error;
2713: END IF;
2714:
2715: END IF;
2728: ,x_msg_count => l_msg_count
2729: ,x_msg_data => l_msg_data
2730: );
2731:
2732: AMS_UTILITY_PVT.debug_message('After Unlock.');
2733: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2734:
2735: --
2736: IF FND_API.g_ret_sts_success <> l_return_status
2729: ,x_msg_data => l_msg_data
2730: );
2731:
2732: AMS_UTILITY_PVT.debug_message('After Unlock.');
2733: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
2734:
2735: --
2736: IF FND_API.g_ret_sts_success <> l_return_status
2737: THEN
2734:
2735: --
2736: IF FND_API.g_ret_sts_success <> l_return_status
2737: THEN
2738: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CP_IMAGE');
2739: RAISE FND_API.g_exc_error;
2740: END IF;
2741:
2742: END IF;
2916: l_init_msg_list := FND_API.g_false;
2917:
2918:
2919: -- Debug Message
2920: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2921:
2922: -- Initialize API return status to SUCCESS
2923: x_return_status := FND_API.G_RET_STS_SUCCESS;
2924: l_return_status := FND_API.G_RET_STS_SUCCESS;
2930: p_attr_values_image IS NOT NULL
2931: THEN
2932: FOR i IN p_attr_types_image.first .. p_attr_types_image.last
2933: LOOP
2934: AMS_UTILITY_PVT.debug_message(i || ' : ' || p_attr_types_image(i) || ' : ' || p_attr_values_image(i));
2935: null;
2936: END LOOP;
2937: END IF;
2938: IF p_attr_types_cp_image IS NOT NULL
2940: p_attr_values_cp_image IS NOT NULL
2941: THEN
2942: FOR i IN p_attr_types_cp_image.first .. p_attr_types_cp_image.last
2943: LOOP
2944: AMS_UTILITY_PVT.debug_message(i || ' : ' || p_attr_types_cp_image(i) || ' : ' || p_attr_values_cp_image(i));
2945: null;
2946: END LOOP;
2947: END IF;
2948:
2969: */
2970: -- Create the content item of type IMAGE.
2971: -- Call bulk_insert procedure.
2972: /*
2973: AMS_UTILITY_PVT.debug_message('file id = ' || p_attach_file_id);
2974: AMS_UTILITY_PVT.debug_message('file name = ' || p_attach_file_name);
2975: */
2976:
2977: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2970: -- Create the content item of type IMAGE.
2971: -- Call bulk_insert procedure.
2972: /*
2973: AMS_UTILITY_PVT.debug_message('file id = ' || p_attach_file_id);
2974: AMS_UTILITY_PVT.debug_message('file name = ' || p_attach_file_name);
2975: */
2976:
2977: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2978: -- single API.
3010: ,x_msg_data => l_msg_data
3011:
3012: );
3013:
3014: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
3015: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
3016: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
3017: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3011:
3012: );
3013:
3014: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
3015: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
3016: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
3017: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3019:
3012: );
3013:
3014: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
3015: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
3016: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
3017: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3019:
3020: IF FND_API.g_ret_sts_success <> l_return_status
3013:
3014: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
3015: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
3016: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
3017: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3019:
3020: IF FND_API.g_ret_sts_success <> l_return_status
3021: THEN
3014: AMS_UTILITY_PVT.debug_message('After upsert_item of type IBC_IMAGE');
3015: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_image_citem_id );
3016: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_image_citem_ver_id );
3017: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_image_obj_ver_num );
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3019:
3020: IF FND_API.g_ret_sts_success <> l_return_status
3021: THEN
3022: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_IMAGE_ITEM');
3018: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3019:
3020: IF FND_API.g_ret_sts_success <> l_return_status
3021: THEN
3022: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_IMAGE_ITEM');
3023: RAISE FND_API.g_exc_error;
3024: ELSE
3025: l_created_image := FND_API.g_true;
3026: END IF;
3041: );
3042:
3043: IF FND_API.g_ret_sts_success <> l_return_status
3044: THEN
3045: AMS_Utility_PVT.Error_Message('AMS_ERR_APPROVE_CITEM');
3046: RAISE FND_API.g_exc_error;
3047: END IF;
3048:
3049: END IF;
3093: );
3094:
3095: IF FND_API.g_ret_sts_success <> l_return_status
3096: THEN
3097: AMS_Utility_PVT.Error_Message('AMS_ERR_LOCKING_CP_IMAGE');
3098: RAISE FND_API.g_exc_error;
3099: END IF;
3100:
3101: IF l_cp_image_citem_ver_id <> p_cp_image_citem_ver_id
3099: END IF;
3100:
3101: IF l_cp_image_citem_ver_id <> p_cp_image_citem_ver_id
3102: THEN
3103: AMS_Utility_PVT.Error_Message('AMS_ERR_CITEM_VER_MISMATCH');
3104: RAISE FND_API.g_exc_error;
3105: END IF;
3106:
3107: ELSE
3110: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_cp_image_citem_id );
3111:
3112: END IF;
3113:
3114: AMS_Utility_PVT.Debug_Message(' CP IMage citem version id = ' || p_cp_image_citem_ver_id );
3115: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3116:
3117: IBC_CITEM_ADMIN_GRP.set_attribute_bundle(
3118: p_citem_ver_id => p_cp_image_citem_ver_id
3111:
3112: END IF;
3113:
3114: AMS_Utility_PVT.Debug_Message(' CP IMage citem version id = ' || p_cp_image_citem_ver_id );
3115: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3116:
3117: IBC_CITEM_ADMIN_GRP.set_attribute_bundle(
3118: p_citem_ver_id => p_cp_image_citem_ver_id
3119: ,p_attribute_type_codes => l_attribute_type_codes
3129: );
3130:
3131: IF FND_API.g_ret_sts_success <> l_return_status
3132: THEN
3133: AMS_Utility_PVT.Error_Message('AMS_ERR_SET_CITEM_ATTRIB');
3134: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CP_IMAGE');
3135: RAISE FND_API.g_exc_error;
3136: END IF;
3137:
3130:
3131: IF FND_API.g_ret_sts_success <> l_return_status
3132: THEN
3133: AMS_Utility_PVT.Error_Message('AMS_ERR_SET_CITEM_ATTRIB');
3134: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CP_IMAGE');
3135: RAISE FND_API.g_exc_error;
3136: END IF;
3137:
3138: -- If we reach till here, we can unlock the IMAGE item and then
3153: ,x_msg_count => l_msg_count
3154: ,x_msg_data => l_msg_data
3155: );
3156:
3157: AMS_UTILITY_PVT.debug_message('After Unlock.');
3158: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3159:
3160: --
3161: IF FND_API.g_ret_sts_success <> l_return_status
3154: ,x_msg_data => l_msg_data
3155: );
3156:
3157: AMS_UTILITY_PVT.debug_message('After Unlock.');
3158: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3159:
3160: --
3161: IF FND_API.g_ret_sts_success <> l_return_status
3162: THEN
3159:
3160: --
3161: IF FND_API.g_ret_sts_success <> l_return_status
3162: THEN
3163: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_IMAGE');
3164: RAISE FND_API.g_exc_error;
3165: END IF;
3166:
3167: END IF;
3180: ,x_msg_count => l_msg_count
3181: ,x_msg_data => l_msg_data
3182: );
3183:
3184: AMS_UTILITY_PVT.debug_message('After Unlock.');
3185: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3186:
3187: --
3188: IF FND_API.g_ret_sts_success <> l_return_status
3181: ,x_msg_data => l_msg_data
3182: );
3183:
3184: AMS_UTILITY_PVT.debug_message('After Unlock.');
3185: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3186:
3187: --
3188: IF FND_API.g_ret_sts_success <> l_return_status
3189: THEN
3186:
3187: --
3188: IF FND_API.g_ret_sts_success <> l_return_status
3189: THEN
3190: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CP_IMAGE');
3191: RAISE FND_API.g_exc_error;
3192: END IF;
3193:
3194: END IF;
3303: );
3304:
3305: IF FND_API.g_ret_sts_success <> l_return_status
3306: THEN
3307: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_CITEM_ATTRS');
3308: RAISE FND_API.g_exc_error;
3309: END IF;
3310:
3311: x_return_status := l_return_status;
3465:
3466: l_init_msg_list := FND_API.g_false;
3467:
3468: -- Debug Message
3469: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
3470: AMS_UTILITY_PVT.debug_message('content item id = ' || p_citem_id);
3471:
3472: -- Initialize API return status to SUCCESS
3473: x_return_status := FND_API.G_RET_STS_SUCCESS;
3466: l_init_msg_list := FND_API.g_false;
3467:
3468: -- Debug Message
3469: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
3470: AMS_UTILITY_PVT.debug_message('content item id = ' || p_citem_id);
3471:
3472: -- Initialize API return status to SUCCESS
3473: x_return_status := FND_API.G_RET_STS_SUCCESS;
3474: l_return_status := FND_API.G_RET_STS_SUCCESS;
3490: );
3491:
3492: IF FND_API.g_ret_sts_success <> l_return_status
3493: THEN
3494: AMS_Utility_PVT.Error_Message('AMS_ERR_LOCKING_CITEM');
3495: RAISE FND_API.g_exc_error;
3496: END IF;
3497:
3498: IF l_citem_ver_id <> p_citem_version_id
3496: END IF;
3497:
3498: IF l_citem_ver_id <> p_citem_version_id
3499: THEN
3500: AMS_Utility_PVT.Error_Message('AMS_ERR_CITEM_VER_MISMATCH');
3501: RAISE FND_API.g_exc_error;
3502: END IF;
3503:
3504: ELSE
3507: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
3508:
3509: END IF;
3510:
3511: AMS_Utility_PVT.Debug_Message(' p_citem_version_id = ' || p_citem_version_id );
3512: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3513:
3514: -- Get all the existing basic attributes for the content item if necessary.
3515:
3508:
3509: END IF;
3510:
3511: AMS_Utility_PVT.Debug_Message(' p_citem_version_id = ' || p_citem_version_id );
3512: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3513:
3514: -- Get all the existing basic attributes for the content item if necessary.
3515:
3516: -- Check if we just need to replace the attribute bundle.
3552: );
3553:
3554: IF FND_API.g_ret_sts_success <> l_return_status
3555: THEN
3556: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_CITEM_ATTRS');
3557: RAISE FND_API.g_exc_error;
3558: END IF;
3559:
3560: */
3584: );
3585:
3586: IF FND_API.g_ret_sts_success <> l_return_status
3587: THEN
3588: AMS_Utility_PVT.Error_Message('AMS_ERR_GET_CITEM');
3589: RAISE FND_API.g_exc_error;
3590: END IF;
3591:
3592: IF l_attribute_type_codes IS NOT NULL
3646: );
3647:
3648: IF FND_API.g_ret_sts_success <> l_return_status
3649: THEN
3650: AMS_Utility_PVT.Error_Message('AMS_ERR_SET_CITEM_ATTRIB');
3651: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3652: RAISE FND_API.g_exc_error;
3653: END IF;
3654:
3647:
3648: IF FND_API.g_ret_sts_success <> l_return_status
3649: THEN
3650: AMS_Utility_PVT.Error_Message('AMS_ERR_SET_CITEM_ATTRIB');
3651: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3652: RAISE FND_API.g_exc_error;
3653: END IF;
3654:
3655: END IF;
3674: );
3675:
3676: IF FND_API.g_ret_sts_success <> l_return_status
3677: THEN
3678: AMS_Utility_PVT.Error_Message('AMS_ERR_SET_CITEM_ATTCH');
3679: RAISE FND_API.g_exc_error;
3680: END IF;
3681: END IF;
3682:
3681: END IF;
3682:
3683: IF FND_API.g_ret_sts_success <> l_return_status
3684: THEN
3685: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3686: RAISE FND_API.g_exc_error;
3687: END IF;
3688:
3689: AMS_UTILITY_PVT.debug_message('Before Unlock.');
3685: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3686: RAISE FND_API.g_exc_error;
3687: END IF;
3688:
3689: AMS_UTILITY_PVT.debug_message('Before Unlock.');
3690: AMS_UTILITY_PVT.debug_message('p_citem_version_id = ' || p_citem_version_id);
3691: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
3692:
3693: IF g_using_locking = FND_API.g_true
3686: RAISE FND_API.g_exc_error;
3687: END IF;
3688:
3689: AMS_UTILITY_PVT.debug_message('Before Unlock.');
3690: AMS_UTILITY_PVT.debug_message('p_citem_version_id = ' || p_citem_version_id);
3691: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
3692:
3693: IF g_using_locking = FND_API.g_true
3694: THEN
3687: END IF;
3688:
3689: AMS_UTILITY_PVT.debug_message('Before Unlock.');
3690: AMS_UTILITY_PVT.debug_message('p_citem_version_id = ' || p_citem_version_id);
3691: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
3692:
3693: IF g_using_locking = FND_API.g_true
3694: THEN
3695:
3703: ,x_msg_count => l_msg_count
3704: ,x_msg_data => l_msg_data
3705: );
3706: --
3707: AMS_UTILITY_PVT.debug_message('After Unlock.');
3708: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3709: --
3710: IF FND_API.g_ret_sts_success <> l_return_status
3711: THEN
3704: ,x_msg_data => l_msg_data
3705: );
3706: --
3707: AMS_UTILITY_PVT.debug_message('After Unlock.');
3708: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3709: --
3710: IF FND_API.g_ret_sts_success <> l_return_status
3711: THEN
3712: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
3708: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3709: --
3710: IF FND_API.g_ret_sts_success <> l_return_status
3711: THEN
3712: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
3713: RAISE FND_API.g_exc_error;
3714: END IF;
3715:
3716: END IF;
3844:
3845: l_init_msg_list := FND_API.g_false;
3846:
3847: -- Debug Message
3848: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
3849:
3850: -- Initialize API return status to SUCCESS
3851: x_return_status := FND_API.G_RET_STS_SUCCESS;
3852: l_return_status := FND_API.G_RET_STS_SUCCESS;
3868: );
3869:
3870: IF FND_API.g_ret_sts_success <> l_return_status
3871: THEN
3872: AMS_Utility_PVT.Error_Message('AMS_ERR_LOCKING_CITEM');
3873: RAISE FND_API.g_exc_error;
3874: END IF;
3875:
3876: ELSE
3886: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
3887:
3888: END IF;
3889:
3890: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id );
3891: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3892:
3893: -- update the data if needed.
3894: IF p_def_disp_template_id IS NOT NULL
3887:
3888: END IF;
3889:
3890: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id );
3891: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3892:
3893: -- update the data if needed.
3894: IF p_def_disp_template_id IS NOT NULL
3895: THEN
3920: );
3921:
3922: IF FND_API.g_ret_sts_success <> l_return_status
3923: THEN
3924: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3925: RAISE FND_API.g_exc_error;
3926: END IF;
3927:
3928: --Change the value of default_display_template in IBC_ASSOCIATIONS table.
3957: ,x_msg_count => l_msg_count
3958: ,x_msg_data => l_msg_data
3959: );
3960:
3961: AMS_UTILITY_PVT.debug_message('After Unlock.');
3962: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3963:
3964: --
3965: IF FND_API.g_ret_sts_success <> l_return_status
3958: ,x_msg_data => l_msg_data
3959: );
3960:
3961: AMS_UTILITY_PVT.debug_message('After Unlock.');
3962: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
3963:
3964: --
3965: IF FND_API.g_ret_sts_success <> l_return_status
3966: THEN
3963:
3964: --
3965: IF FND_API.g_ret_sts_success <> l_return_status
3966: THEN
3967: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
3968: RAISE FND_API.g_exc_error;
3969: END IF;
3970:
3971: END IF;
4112:
4113: l_init_msg_list := FND_API.g_false;
4114:
4115: -- Debug Message
4116: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4117:
4118: -- Initialize API return status to SUCCESS
4119: x_return_status := FND_API.G_RET_STS_SUCCESS;
4120: l_return_status := FND_API.G_RET_STS_SUCCESS;
4169: ,x_msg_count => l_msg_count
4170: ,x_msg_data => l_msg_data
4171: );
4172:
4173: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4174: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4175: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4176: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4170: ,x_msg_data => l_msg_data
4171: );
4172:
4173: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4174: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4175: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4176: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4178:
4171: );
4172:
4173: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4174: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4175: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4176: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4178:
4179: IF FND_API.g_ret_sts_success <> l_return_status
4172:
4173: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4174: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4175: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4176: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4178:
4179: IF FND_API.g_ret_sts_success <> l_return_status
4180: THEN
4173: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4174: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4175: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4176: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4178:
4179: IF FND_API.g_ret_sts_success <> l_return_status
4180: THEN
4181: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_STYLE_CITEM');
4177: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4178:
4179: IF FND_API.g_ret_sts_success <> l_return_status
4180: THEN
4181: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_STYLE_CITEM');
4182: RAISE FND_API.g_exc_error;
4183: END IF;
4184:
4185: -- Approve the above item.
4196: );
4197:
4198: IF FND_API.g_ret_sts_success <> l_return_status
4199: THEN
4200: AMS_Utility_PVT.Error_Message('AMS_ERR_APPROVE_CITEM');
4201: RAISE FND_API.g_exc_error;
4202: END IF;
4203:
4204: IF g_using_locking = FND_API.g_true
4214: ,x_msg_count => l_msg_count
4215: ,x_msg_data => l_msg_data
4216: );
4217:
4218: AMS_UTILITY_PVT.debug_message('After Unlock.');
4219: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4220:
4221: --
4222: --
4215: ,x_msg_data => l_msg_data
4216: );
4217:
4218: AMS_UTILITY_PVT.debug_message('After Unlock.');
4219: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4220:
4221: --
4222: --
4223: --
4222: --
4223: --
4224: IF FND_API.g_ret_sts_success <> l_return_status
4225: THEN
4226: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
4227: RAISE FND_API.g_exc_error;
4228: END IF;
4229:
4230: END IF;
4258: );
4259:
4260: IF FND_API.g_ret_sts_success <> l_return_status
4261: THEN
4262: AMS_Utility_PVT.Error_Message('AMS_ERR_CREATE_DISP_TMPL');
4263: RAISE FND_API.g_exc_error;
4264: END IF;
4265: --
4266: -- If we come till here, everything has been created successfully.
4418:
4419: l_init_msg_list := FND_API.g_false;
4420:
4421: -- Debug Message
4422: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4423:
4424: -- Initialize API return status to SUCCESS
4425: x_return_status := FND_API.G_RET_STS_SUCCESS;
4426: l_return_status := FND_API.G_RET_STS_SUCCESS;
4426: l_return_status := FND_API.G_RET_STS_SUCCESS;
4427: --
4428: IF p_content_type_code <> G_QUESTIONS -- Should be a CONSTANT in the package.
4429: THEN
4430: AMS_Utility_PVT.Error_Message('AMS_ERR_WRONG_CTYPE_CODE');
4431: RAISE FND_API.g_exc_error;
4432: END IF;
4433: --
4434: x_return_status := FND_API.g_ret_sts_success;
4468: ,x_msg_count => l_msg_count
4469: ,x_msg_data => l_msg_data
4470: );
4471:
4472: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4473: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4474: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4475: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4469: ,x_msg_data => l_msg_data
4470: );
4471:
4472: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4473: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4474: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4475: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4477:
4470: );
4471:
4472: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4473: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4474: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4475: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4477:
4478: IF FND_API.g_ret_sts_success <> l_return_status
4471:
4472: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4473: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4474: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4475: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4477:
4478: IF FND_API.g_ret_sts_success <> l_return_status
4479: THEN
4472: AMS_UTILITY_PVT.debug_message('After upsert_item.');
4473: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
4474: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
4475: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4477:
4478: IF FND_API.g_ret_sts_success <> l_return_status
4479: THEN
4480: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_QUES_CITEM');
4476: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4477:
4478: IF FND_API.g_ret_sts_success <> l_return_status
4479: THEN
4480: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_QUES_CITEM');
4481: RAISE FND_API.g_exc_error;
4482: END IF;
4483:
4484: -- Create the Compound Relation with the parent.
4516: --
4517: --
4518: IF FND_API.g_ret_sts_success <> l_return_status
4519: THEN
4520: AMS_Utility_PVT.Error_Message('AMS_ERR_ADD_COMPOUND_REL');
4521: RAISE FND_API.g_exc_error;
4522: END IF;
4523: --
4524: IF g_using_locking = FND_API.g_true
4535: ,x_msg_count => l_msg_count
4536: ,x_msg_data => l_msg_data
4537: );
4538: --
4539: AMS_UTILITY_PVT.debug_message('After Unlock.');
4540: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4541:
4542: END IF;
4543: --
4536: ,x_msg_data => l_msg_data
4537: );
4538: --
4539: AMS_UTILITY_PVT.debug_message('After Unlock.');
4540: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
4541:
4542: END IF;
4543: --
4544: -- If we come till here, everything has been created successfully.
4720: IF l_source_object_name IS NULL
4721: AND
4722: l_source_object_pk_field IS NULL
4723: THEN
4724: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_DATA_SRC');
4725: RAISE FND_API.g_exc_error;
4726: END IF;
4727:
4728: --
4782: IF UPPER(l_source_object_pk_field) = 'PARTY_ID'
4783: THEN
4784: l_bind_vars(1) := G_BIND_VAR_AMSP;
4785: ELSE
4786: AMS_Utility_PVT.Error_Message('AMS_ERR_UNDEF_BIND_VAR');
4787: RAISE FND_API.g_exc_error;
4788: -- For user entered data sources, there has to be a way to define the bind variable
4789: -- name that we can use here.
4790: END IF;
4796: CLOSE c_get_list_src_id ;
4797:
4798: IF l_data_src_type_id IS NULL
4799: THEN
4800: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_DATA_SRC_TYPE');
4801: RAISE FND_API.g_exc_error;
4802: END IF ;
4803:
4804: -- For each field id in the incoming array, get the source_column_name
4819: CLOSE c_get_list_src_fld_data;
4820:
4821: IF l_source_column_name IS NULL
4822: THEN
4823: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_DATA_SRC_FLD');
4824: RAISE FND_API.g_exc_error;
4825: ELSE
4826:
4827: -- Form the alias for the Column Name in the select list.
4860: l_source_column_name := SUBSTR(l_list_source_field, INSTR(l_list_source_field,':') + 1) ;
4861:
4862: IF l_source_column_name = ''
4863: THEN
4864: AMS_Utility_PVT.Error_Message('AMS_ERR_MALFORMED_FLD_NAME');
4865: RAISE FND_API.g_exc_error;
4866: ELSE
4867: l_fld_count := l_fld_count + 1;
4868:
4886:
4887: END LOOP;
4888: ELSE
4889: -- Cannot form the select statement, as no fields list available.
4890: AMS_Utility_PVT.Error_Message('AMS_ERR_NO_FLDS_FOR_GEN_SQL');
4891: RAISE FND_API.g_exc_error;
4892: END IF;
4893:
4894: END IF;
5060:
5061: l_init_msg_list := FND_API.g_false;
5062:
5063: -- Debug Message
5064: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5065:
5066: -- Initialize API return status to SUCCESS
5067: x_return_status := FND_API.G_RET_STS_SUCCESS;
5068: l_return_status := FND_API.G_RET_STS_SUCCESS;
5069: --
5070: --
5071: IF p_content_type_code <> G_SUBMIT_SECTION -- Should be a CONSTANT in the package.
5072: THEN
5073: AMS_Utility_PVT.Error_Message('AMS_ERR_WRONG_CTYPE_CODE');
5074: RAISE FND_API.g_exc_error;
5075: END IF;
5076: --
5077: x_return_status := FND_API.g_ret_sts_success;
5142: ,x_msg_count => l_msg_count
5143: ,x_msg_data => l_msg_data
5144: );
5145:
5146: AMS_UTILITY_PVT.debug_message('After upsert_item.');
5147: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
5148: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
5149: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5143: ,x_msg_data => l_msg_data
5144: );
5145:
5146: AMS_UTILITY_PVT.debug_message('After upsert_item.');
5147: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
5148: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
5149: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5151:
5144: );
5145:
5146: AMS_UTILITY_PVT.debug_message('After upsert_item.');
5147: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
5148: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
5149: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5151:
5152: IF FND_API.g_ret_sts_success <> l_return_status
5145:
5146: AMS_UTILITY_PVT.debug_message('After upsert_item.');
5147: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
5148: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
5149: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5151:
5152: IF FND_API.g_ret_sts_success <> l_return_status
5153: THEN
5146: AMS_UTILITY_PVT.debug_message('After upsert_item.');
5147: AMS_UTILITY_PVT.debug_message('l_citem_id = ' || l_citem_id);
5148: AMS_UTILITY_PVT.debug_message('l_citem_ver_id = ' || l_citem_ver_id);
5149: AMS_UTILITY_PVT.debug_message('l_obj_ver_num = ' || l_obj_ver_num);
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5151:
5152: IF FND_API.g_ret_sts_success <> l_return_status
5153: THEN
5154: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_SUBMIT_CITEM');
5150: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5151:
5152: IF FND_API.g_ret_sts_success <> l_return_status
5153: THEN
5154: AMS_Utility_PVT.Error_Message('AMS_ERR_CRE_SUBMIT_CITEM');
5155: RAISE FND_API.g_exc_error;
5156: END IF;
5157:
5158: -- Create the Compound Relation with the parent.
5191: );
5192:
5193: IF FND_API.g_ret_sts_success <> l_return_status
5194: THEN
5195: AMS_Utility_PVT.Error_Message('AMS_ERR_LOCKING_CITEM');
5196: RAISE FND_API.g_exc_error;
5197: END IF;
5198:
5199: IF l_parent_citem_ver_id <> p_parent_citem_ver_id
5197: END IF;
5198:
5199: IF l_parent_citem_ver_id <> p_parent_citem_ver_id
5200: THEN
5201: AMS_Utility_PVT.Error_Message('AMS_ERR_CITEM_VER_MISMATCH');
5202: RAISE FND_API.g_exc_error;
5203: END IF;
5204:
5205: ELSE
5208: l_parent_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_parent_citem_id );
5209:
5210: END IF;
5211:
5212: AMS_Utility_PVT.Debug_Message(' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
5213: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_parent_obj_ver_num );
5214:
5215:
5216: -- insert compound relations.
5209:
5210: END IF;
5211:
5212: AMS_Utility_PVT.Debug_Message(' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
5213: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_parent_obj_ver_num );
5214:
5215:
5216: -- insert compound relations.
5217: -- If we use locking, the parent content item and the children content items
5232: );
5233:
5234: IF FND_API.g_ret_sts_success <> l_return_status
5235: THEN
5236: AMS_Utility_PVT.Error_Message('AMS_ERR_ADD_COMPOUND_REL');
5237: RAISE FND_API.g_exc_error;
5238: END IF;
5239:
5240: IF g_using_locking = FND_API.g_true
5251: ,x_msg_count => l_msg_count
5252: ,x_msg_data => l_msg_data
5253: );
5254:
5255: AMS_UTILITY_PVT.debug_message('After Unlock.');
5256: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5257:
5258: IF FND_API.g_ret_sts_success <> l_return_status
5259: THEN
5252: ,x_msg_data => l_msg_data
5253: );
5254:
5255: AMS_UTILITY_PVT.debug_message('After Unlock.');
5256: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5257:
5258: IF FND_API.g_ret_sts_success <> l_return_status
5259: THEN
5260: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
5256: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5257:
5258: IF FND_API.g_ret_sts_success <> l_return_status
5259: THEN
5260: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
5261: RAISE FND_API.g_exc_error;
5262: END IF;
5263:
5264: END IF;
5279: ,x_msg_count => l_msg_count
5280: ,x_msg_data => l_msg_data
5281: );
5282:
5283: AMS_UTILITY_PVT.debug_message('After Unlock.');
5284: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5285:
5286: IF FND_API.g_ret_sts_success <> l_return_status
5287: THEN
5280: ,x_msg_data => l_msg_data
5281: );
5282:
5283: AMS_UTILITY_PVT.debug_message('After Unlock.');
5284: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5285:
5286: IF FND_API.g_ret_sts_success <> l_return_status
5287: THEN
5288: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
5284: AMS_UTILITY_PVT.debug_message('l_return_status = ' || l_return_status);
5285:
5286: IF FND_API.g_ret_sts_success <> l_return_status
5287: THEN
5288: AMS_Utility_PVT.Error_Message('AMS_ERR_UNLOCK_CITEM');
5289: RAISE FND_API.g_exc_error;
5290: END IF;
5291:
5292: END IF;
5438:
5439: l_init_msg_list := FND_API.g_false;
5440:
5441: -- Debug Message
5442: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5443:
5444: -- Initialize API return status to SUCCESS
5445: x_return_status := FND_API.G_RET_STS_SUCCESS;
5446: l_return_status := FND_API.G_RET_STS_SUCCESS;
5515: END IF;
5516:
5517: IF FND_API.g_ret_sts_success <> l_return_status
5518: THEN
5519: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
5520: RAISE FND_API.g_exc_error;
5521: END IF;
5522:
5523: -- Commit the work and set the output values.
5722: FETCH c_fild_id_check INTO l_test_file_id, l_test_file_name ;
5723: CLOSE c_fild_id_check ;
5724:
5725: -- Debug Message
5726: AMS_UTILITY_PVT.debug_message(' l_test_file_id in update_questions_section = ' || l_test_file_id);
5727: AMS_UTILITY_PVT.debug_message(' l_test_file_name in update_questions_section = ' || l_test_file_name);
5728:
5729: -- Standard call to check for call compatibility.
5730: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5723: CLOSE c_fild_id_check ;
5724:
5725: -- Debug Message
5726: AMS_UTILITY_PVT.debug_message(' l_test_file_id in update_questions_section = ' || l_test_file_id);
5727: AMS_UTILITY_PVT.debug_message(' l_test_file_name in update_questions_section = ' || l_test_file_name);
5728:
5729: -- Standard call to check for call compatibility.
5730: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5731: p_api_version,
5746:
5747: l_init_msg_list := FND_API.g_false;
5748:
5749: -- Debug Message
5750: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5751:
5752: -- Initialize API return status to SUCCESS
5753: x_return_status := FND_API.G_RET_STS_SUCCESS;
5754: l_return_status := FND_API.G_RET_STS_SUCCESS;
5754: l_return_status := FND_API.G_RET_STS_SUCCESS;
5755: --
5756: IF p_content_type_code <> G_QUESTIONS -- Should be a CONSTANT in the package.
5757: THEN
5758: AMS_Utility_PVT.Error_Message('AMS_ERR_WRONG_CTYPE_CODE');
5759: RAISE FND_API.g_exc_error;
5760: END IF;
5761:
5762: -- check the version id.
5768: IF p_section_citem_ver_id IS NOT NULL
5769: THEN
5770: IF p_section_citem_ver_id <> l_section_citem_ver_id
5771: THEN
5772: AMS_Utility_PVT.Error_Message('AMS_ERR_CITEM_VER_MISMATCH');
5773: RAISE FND_API.g_exc_error;
5774: END IF;
5775: END IF;
5776: --
5857: END LOOP ;
5858: CLOSE c_data_src_flds ;
5859:
5860: -- Debug Message
5861: AMS_UTILITY_PVT.debug_message('Data Src : ' || l_data_src_type_code || ': # of fields : ' || l_fld_cnt );
5862:
5863: IF l_fld_cnt > 0
5864: THEN
5865: -- This means that we have some field ids for this data source.
5876: );
5877:
5878: IF FND_API.g_ret_sts_success <> l_return_status
5879: THEN
5880: AMS_Utility_PVT.Error_Message('AMS_ERR_CPAGE_GEN_SQL');
5881: RAISE FND_API.g_exc_error;
5882: END IF;
5883:
5884: AMS_UTILITY_PVT.debug_message( ' l_select_sql_statement = ' || l_select_sql_statement );
5880: AMS_Utility_PVT.Error_Message('AMS_ERR_CPAGE_GEN_SQL');
5881: RAISE FND_API.g_exc_error;
5882: END IF;
5883:
5884: AMS_UTILITY_PVT.debug_message( ' l_select_sql_statement = ' || l_select_sql_statement );
5885:
5886: -- Set the attributes for Select SQL Statement and bind variables.
5887: IF l_select_sql_statement IS NOT NULL
5888: THEN
5984: THEN
5985: FOR i IN l_attribute_type_codes.first .. l_attribute_type_codes.last
5986: LOOP
5987: l_err_msg := i || ' : >' || l_attribute_type_codes(i) || '< : >' || l_attributes(i) || '<';
5988: AMS_UTILITY_PVT.debug_message(l_err_msg);
5989: END LOOP;
5990: END IF;
5991:
5992: -- call update_content_item.
6010: ,x_msg_data => l_msg_data
6011: ,p_replace_attr_bundle => FND_API.g_true
6012: );
6013:
6014: AMS_UTILITY_PVT.debug_message( ' After update_content_item call. ' );
6015:
6016: IF FND_API.g_ret_sts_success <> l_return_status
6017: THEN
6018: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
6014: AMS_UTILITY_PVT.debug_message( ' After update_content_item call. ' );
6015:
6016: IF FND_API.g_ret_sts_success <> l_return_status
6017: THEN
6018: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
6019: RAISE FND_API.g_exc_error;
6020: END IF;
6021:
6022: -- There is a bug in IBC Code. The field attachment_attribute_code in the
6033: OPEN c_data_src_usage_count ;
6034: FETCH c_data_src_usage_count INTO l_data_src_usage_count ;
6035: CLOSE c_data_src_usage_count ;
6036:
6037: AMS_UTILITY_PVT.debug_message( ' l_data_src_usage_count = ' || l_data_src_usage_count );
6038:
6039: IF l_data_src_usage_count > 0
6040: THEN
6041: DELETE FROM ams_list_src_type_usages
6042: WHERE list_src_used_by_type = 'CPAGE'
6043: AND list_src_used_by_id = p_section_citem_id;
6044: END IF;
6045:
6046: AMS_UTILITY_PVT.debug_message( ' l_data_src_usage_count = ' || l_data_src_usage_count );
6047:
6048: -- Insert into ams_list_src_type_usages the usage record for all the Data Sources
6049: -- being used by this content item.
6050:
6052: THEN
6053:
6054: FOR i IN l_data_src_type_codes.first .. l_data_src_type_codes.last
6055: LOOP
6056: AMS_UTILITY_PVT.debug_message( ' There are data sources. ' );
6057:
6058: l_data_src_type_code := l_data_src_type_codes(i);
6059:
6060: AMS_UTILITY_PVT.debug_message( ' Adding usage record for : l_data_src_type_code = ' || l_data_src_type_code );
6056: AMS_UTILITY_PVT.debug_message( ' There are data sources. ' );
6057:
6058: l_data_src_type_code := l_data_src_type_codes(i);
6059:
6060: AMS_UTILITY_PVT.debug_message( ' Adding usage record for : l_data_src_type_code = ' || l_data_src_type_code );
6061:
6062: INSERT INTO ams_list_src_type_usages
6063: (
6064: list_source_type_usage_id
6160: l_blob BLOB;
6161: l_length NUMBER;
6162: l_api_name CONSTANT VARCHAR2(30) := 'erase_blob';
6163: BEGIN
6164: AMS_UTILITY_PVT.debug_message('enter erase');
6165:
6166: IF FND_API.to_Boolean( p_init_msg_list )
6167: THEN
6168: FND_MSG_PUB.initialize;
6175: where file_id = p_file_id
6176: for update;
6177:
6178: l_length := dbms_lob.getlength(l_blob);
6179: AMS_UTILITY_PVT.debug_message('Length of lob erased : '||TO_CHAR(l_length));
6180:
6181: dbms_lob.erase(l_blob,l_length,1);
6182: dbms_lob.trim(l_blob,0);
6183:
6182: dbms_lob.trim(l_blob,0);
6183:
6184: x_blob := l_blob;
6185:
6186: AMS_UTILITY_PVT.debug_message('erase successful');
6187:
6188: EXCEPTION
6189: WHEN FND_API.g_exc_error THEN
6190: ROLLBACK ;