[Home] [Help]
2193:
2194: -- ATTR_NAME is set as DB Column Name
2195: IF l_num_value IS NOT NULL
2196: THEN
2197: IF l_num_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
2198: THEN
2199: l_num_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;
2200: END IF;
2201:
2203: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || TO_CHAR(l_num_value) ;
2204:
2205: ELSIF l_char_value IS NOT NULL
2206: THEN
2207: IF l_char_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR
2208: THEN
2209: l_char_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
2210: END IF;
2211:
2213: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || '''' || l_char_value || '''' ;
2214:
2215: ELSIF l_date_value IS NOT NULL
2216: THEN
2217: IF l_date_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE
2218: THEN
2219: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
2220: END IF;
2221:
5277: -- the production table already exists there --
5278: -------------------------------------------------------------------
5279: IF (l_current_acd_type = 'CHANGE')
5280: THEN
5281: Write_Debug('Calling ENG_CHANGE_ATTR_UTIL.SETUP_IMPL_ATTR_DATA_ROW. . .');
5282:
5283:
5284:
5285:
5282:
5283:
5284:
5285:
5286: ENG_CHANGE_ATTR_UTIL.SETUP_IMPL_ATTR_DATA_ROW
5287: (
5288: p_api_version => p_api_version
5289: ,p_object_name => p_object_name
5290: ,p_attr_group_id => l_attr_group_metadata_obj.ATTR_GROUP_ID
5636: USING l_ext_id_for_current_row, p_change_line_id, l_current_acd_type, l_current_row_language;
5637: -- BUG 5340167
5638: END IF;
5639:
5640: Write_Debug('After Calling ENG_CHANGE_ATTR_UTIL.SETUP_IMPL_ATTR_DATA_ROW: Return Status: ' || x_return_status );
5641:
5642: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
5643: THEN
5644:
5641:
5642: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
5643: THEN
5644:
5645: Write_Debug('Raising error after ENG_CHANGE_ATTR_UTIL ' );
5646:
5647: RAISE FND_API.G_EXC_ERROR;
5648: END IF;
5649: